php - Wordpress:Learnpress 按自定义字段值(价格)显示课程
问题描述
我希望课程页面能够按价格查询课程...找到了这一点,并希望它能完成工作...
内容存档 course.php
$default_order = apply_filters( 'thim_default_order_course_option', array(
'newly-published' => esc_html__( 'Newly published', 'eduma' ),
'alphabetical' => esc_html__( 'Alphabetical', 'eduma' ),
'most-members' => esc_html__( 'Most members', 'eduma' ),
//'price' => esc_html__( 'Price', 'eduma' )
) );;
还位:learnpress_v3_functions.php
if ( !function_exists( 'thim_course_order_query' ) ) {
function thim_course_order_query( $query ) {
if ( !$query->is_main_query() ) {
return;
}
if ( !is_post_type_archive( 'lp_course' ) && !is_tax( 'course_category' ) ) {
return;
}
// Sort
if ( isset( $_POST['course_orderby'] ) ) {
switch ( $_POST['course_orderby'] ) {
case 'alphabetical':
$query->set( 'orderby', 'title' );
$query->set( 'order', 'ASC' );
break;
case 'most-members':
$query->set( 'orderby', 'meta_value_num' );
$query->set( 'meta_key', 'thim_real_student_enrolled' );
$query->set( 'order', 'DESC' );
break;
case 'price':
$query->set( 'orderby', 'price' );
$query->set( 'order', 'ASC' );
default:
$query->set( 'orderby', 'date' );
$query->set( 'order', 'DESC' );
}
}
任何帮助表示赞赏。
解决方案
在文件中:content-archive-course.php
$default_order = apply_filters( 'thim_default_order_course_option', array(
'newly-published' => esc_html__( 'Newly published', 'eduma' ),
'alphabetical' => esc_html__( 'Alphabetical', 'eduma' ),
'most-members' => esc_html__( 'Most members', 'eduma' ),
'priceasc' => esc_html__( 'Prices: low to High', 'eduma' ),
'pricedesc' => esc_html__( 'Prices: high to low', 'eduma' ),
) );;
在你的functions.php文件中添加这个钩子:
/*Add new filter options to course archive page */
add_action( 'pre_get_posts', 'thim_course_order_query', 15);
function thim_course_order_query( $query ) {
if ( !$query->is_main_query() ) {
return;
}
if ( !is_post_type_archive( 'lp_course' ) && !is_tax( 'course_category' ) ) {
return;
}
// Sort
if ( isset( $_POST['course_orderby'] ) ) {
switch ( $_POST['course_orderby'] ) {
case 'alphabetical':
$query->set( 'orderby', 'title' );
$query->set( 'order', 'ASC' );
break;
case 'most-members':
$query->set( 'orderby', 'meta_value_num' );
$query->set( 'meta_key', 'thim_real_student_enrolled' );
$query->set( 'order', 'DESC' );
break;
case 'priceasc':
$query->set( 'orderby', 'meta_value_num' );
$query->set( 'meta_key', '_lp_price' );
$query->set( 'order', 'ASC' );
break;
case 'pricedesc':
$query->set( 'orderby', 'meta_value_num' );
$query->set( 'meta_key', '_lp_price' );
$query->set( 'order', 'DESC' );
break;
default:
$query->set( 'orderby', 'date' );
$query->set( 'order', 'DESC' );
}
}
// Pagination
if ( isset( $_POST['course_paged'] ) ) {
$query->set( 'paged', $_POST['course_paged'] );
}
// Filter by categories
if ( isset( $_POST['course_cate_filter'] ) && is_array( $_POST['course_cate_filter'] ) ) {
$query->set( 'tax_query', array(
array(
'taxonomy' => 'course_category',
'field' => 'term_id',
'terms' => $_POST['course_cate_filter'],
)
) );
//$query->set( 'posts_per_page', - 1 );
}
// Filter by instructor
if ( isset( $_POST['course_instructor_filter'] ) && is_array( $_POST['course_instructor_filter'] ) ) {
$query->set( 'author__in', $_POST['course_instructor_filter'] );
}
// Filter by price
// TODO query courses has sale price
if ( isset( $_POST['course_price_filter'] ) ) {
switch ( $_POST['course_price_filter'] ) {
case 'free':
$query->set( 'meta_query', array(
array(
'key' => '_lp_price',
'compare' => 'NOT EXISTS'
)
) );
break;
case 'paid':
$query->set( 'meta_query', array(
array(
'key' => '_lp_price',
'compare' => 'EXISTS'
)
) );
break;
case 'all':
break;
default:
}
}
}
推荐阅读
- javascript - 当数据值不是对象时,地图如何将数据值作为普通对象返回?
- java - 在 servlet 中重定向或转发相同的 jsp 页面
- python - 我在“clean_json_response”函数中收到“ListError: list index out of range”
- c++ - 具有可选 ctor 参数的抽象工厂,没有可变参数模板
- javascript - setState is not permanent
- image - pubspec.yaml 第 40 行第 4 列出错:解析块映射时需要一个键。资产:^
- pycharm - 如何将环境变量传递给 PyCharm 的运行/调试配置中的参数?
- sql-server-2012 - 错误:内部查询处理器错误:查询处理器在执行期间遇到意外错误 (HRESULT = 0x80040e19)
- c# - 格式不保留在 closedXML 中
- sql - 需要帮助从 sql server 中的其他表在主表中插入新行