Php WooCommerce产品按特定元数据的自定义数字排序选项

我想您添加了一个定制的"最便宜的工作台"排序选项，类似于:

add_filter( 'woocommerce_catalog_orderby', 'add_catalog_orderby_cheapest_worktop' );
function add_catalog_orderby_cheapest_worktop( $orderby ) {
    $orderby['cheapest_worktop'] = __('Sort by cheapest worktop', 'woocommerce');
    return $orderby;
}

现在，由于$args参数只处理‘orderby’和‘order’，而不处理‘meta_query’，因此您将try 执行以下操作:

add_filter( 'woocommerce_get_catalog_ordering_args', 'get_catalog_ordering_by_cheapest_worktop', 10, 3 );
function get_catalog_ordering_by_cheapest_worktop( $args, $orderby, $order ) {
    if ( isset( $_GET['orderby'] ) && $_GET['orderby'] === 'cheapest_worktop' ) {
        // Custom sorting order
        $args['orderby'] = array(
            'meta_value_num' => 'ASC', // Sort numerically ascending
        );
    }
    return $args;
}

// Here we set the query (meta query)
add_filter( 'woocommerce_product_query', 'product_query_by_cheapest_worktop', 10, 1 );
function product_query_by_cheapest_worktop( $q ) {
    if ( isset($_GET['orderby']) && $_GET['orderby'] === 'cheapest_worktop' ) {
        $meta_query = $q->get('meta_query');

        $meta_query['relation'] = 'AND';

        $meta_query[] = array(
            'key'     => 'cheapest_worktop',
            'value'   => 0,
            'compare' => '>=',
            'type'    => 'NUMERIC',
        );

        $q->set('meta_query', $meta_query);
        $q->set('orderby', array(
            'meta_value_num' => 'ASC', // Sort numerically ascending
        ) );
    }
}

应该能行得通.