Applying $posts_clauses filter to specific queries only

Question

I use this code for some kind of sorting but it brakes some theme parts, like “Last articles” in footer, and content part after products.

I understand that $posts_clauses brakes other content, how to filter it?

/**
* Sorting out of stock WooCommerce products - Order product collections by stock status, in-stock products first.
*/
class iWC_Orderby_Stock_Status
{

    public function __construct()
    {
        // Check if WooCommerce is active
        if (in_array('woocommerce/woocommerce.php', apply_filters('active_plugins', get_option('active_plugins')))) {
            add_filter('posts_clauses', array($this, 'order_by_stock_status'), 2000);
        }
    }

    public function order_by_stock_status($posts_clauses)
    {
        global $wpdb;

        // only change query on WooCommerce loops
        if( is_woocommerce() && ( is_shop() || is_product_category() || is_product_tag() ) ) {
            $posts_clauses['join']      .= " INNER JOIN $wpdb->postmeta istockstatus ON ($wpdb->posts.ID = istockstatus.post_id) ";
            $posts_clauses['orderby']    = " istockstatus.meta_value ASC, " . $posts_clauses['orderby'];
            $posts_clauses['where']      = " AND istockstatus.meta_key = '_stock_status' AND istockstatus.meta_value <> '' " . $posts_clauses['where'];
        }


        return $posts_clauses;
    }
}
new iWC_Orderby_Stock_Status;
0
, Horhe Garcia 4 years 2020-03-24T08:52:24-05:00 0 Answers 134 views 0

Leave an answer

Browse
Browse