需要orderby _sales_price，_price

Question

我正在寻找像"orderby _sales_price，_price“这样的多个顺序的分类。

get_catalog_ordering_args( $orderby = '', $order = '' ) {
switch ( $orderby ) {
        default :
             //Defult PATCH;
            //$args['orderby']  = 'menu_order title';
                            $args['orderby']  = 'meta_value_num';
            #$args['order']    = $order == 'DESC' ? 'DESC' : 'ASC';
                            $args['order']    = 'DESC';
            #$args['meta_key'] = '';
                            $args['meta_key'] = '_sale_price';
                            #echo "<pre>";print_r($ordering);exit;
        break;
    }

}

这里最重要的是我改变了自己的观点

$args['orderby']  = 'meta_value_num';
$args['order']    = 'DESC';
$args['meta_key'] = '_sale_price';

现在我的一个级别的问题是固定的，但我在这里寻找更多的定制，通过订单在多个领域，如

$args['orderby']  = 'meta_value_num';
$args['order']    = 'DESC';
$args['meta_key'] = '_sale_price, _price';

如果需要任何信息，请告诉我。

你好，Jigar

Answer 1

我在这里找到了答案。

if($q['post_type']=="product") {

    if($orderby ==="ORDER BY $wpdb->postmeta.meta_value+0 DESC") {
         $orderby_c = "ORDER BY pm1.meta_value+0 DESC,pm2.meta_value+0 DESC";
    } else if($orderby==="ORDER BY $wpdb->postmeta.meta_value+0 ASC") {
         $orderby_c = "ORDER BY pm1.meta_value+0 ASC,pm2.meta_value+0 ASC";
    } else {
         $orderby_c = "ORDER BY pm1.meta_value+0 DESC,pm2.meta_value+0 DESC";
    }

    $this->request = "SELECT $found_rows $distinct $wpdb->posts.ID FROM $wpdb->posts
                                          LEFT JOIN $wpdb->postmeta pm1 ON $wpdb->posts.ID = pm1.post_id
                                          LEFT JOIN $wpdb->postmeta pm2 ON $wpdb->posts.ID = pm2.post_id
                                          WHERE $wpdb->posts.post_type = 'product' AND $wpdb->posts.post_status = 'publish' 
                                          AND pm1.meta_key = '_sale_price' 
                                          AND pm2.meta_key = '_price' 
                                          $orderby_c $limits";

}