Dashboard

Editing: class.product_query.php

<?php

// Exit if accessed directly
if( ! defined( 'ABSPATH' ) ) exit();

/**
* Third party
*/
class WooLentorProductQuery{

/**
     * [$_instance]
     * @var null
     */
    private static $_instance = null;

/**
     * [instance] Initializes a singleton instance
     * @return [Base]
     */
    public static function instance() {
        if ( is_null( self::$_instance ) ) {
            self::$_instance = new self();
        }
        return self::$_instance;
    }
    
    function __construct(){

if( class_exists('WooCommerce') ){
            add_action( 'woocommerce_product_query', [ $this, 'parse_query' ] );

//compatibility with woo shortcode
            add_filter('woocommerce_shortcode_products_query', [ $this, 'woocommerce_shortcode_products_query' ], 99, 3 );

// compatibility with product grid (Modern)
            add_filter('woolentor_product_grid_query_settings', [ $this, 'woolentor_grid_products_query' ], 99, 2 );

}

// Support Product Grid Widget
    public function woolentor_grid_products_query($query_settings, $settings){

if( !empty( $query_settings['query_orderby'] ) ){
            $query_settings['orderby'] = $query_settings['query_orderby'];
        }else{
            $query_settings['orderby'] = '';
        }
        if( !empty( $query_settings['query_order'] ) ){
            $query_settings['order'] = $query_settings['query_order'];
        }else{
            $query_settings['orderby'] = '';
        }

$query_settings = $this->woocommerce_shortcode_products_query($query_settings, $settings);
        return $query_settings;
    }

/**
     * [parse_query]
     * @param  [object] $wp_query WooCommerce Default Widget
     * @return [void]
     */
    public function parse_query( $wp_query ){

if ( isset( $_GET['wlfilter'] ) ) {

// $queries =[];
            // $new_queries = [];
            // parse_str( $_SERVER['QUERY_STRING' ], $queries );
            // foreach ( $queries as $key => $querie ) {
            //     $new_queries[] = $key;
            // }

if( isset( $_GET['wlorder_by'] ) ){
                if( in_array( $_GET['wlorder_by'], [ '_price', 'total_sales', '_wc_average_rating' ] ) ) {

$wp_query->set( 'meta_key', $_GET['wlorder_by'] );
                    $wp_query->set( 'orderby', 'meta_value_num' );

}else{
                    $wp_query->set( 'orderby', $_GET['wlorder_by'] );
                }
            }

if( isset( $_GET['wlsort'] ) ){
                $wp_query->set( 'order', $_GET['wlsort'] );
            }

$wp_query->set( 'meta_query', $this->get_meta_query() );

$wp_query->set( 'tax_query', $this->get_tax_query() );

}

public function woocommerce_shortcode_products_query( $query_args, $attr, $type = "" ) {

if( isset( $query_args['meta_query'] ) && is_array( $query_args['meta_query'] ) ){
            $query_args['meta_query'] = array_merge( $query_args['meta_query'], $this->get_meta_query() );
        }else{
            $query_args['meta_query'] = $this->get_meta_query();
        }

if( isset( $query_args['tax_query'] ) && is_array( $query_args['tax_query'] ) ){
            $query_args['tax_query'] = array_merge( $query_args['tax_query'], $this->get_tax_query() );
        }else{
            $query_args['tax_query'] = $this->get_tax_query();
        }
 
        if ( isset( $_GET['wlfilter'] ) ) {

$query_args = apply_filters('woolentor_products_query', $query_args);

if ( isset( $_GET['paged'] ) ) {
                $query_args['paged'] = intval( $_GET['paged'] );
            }

if( isset( $_GET['wlorder_by'] ) ){
                if( in_array( $_GET['wlorder_by'], [ '_price', 'total_sales', '_wc_average_rating' ] ) ) {
                    
                    $query_args['meta_key'] = $_GET['wlorder_by'];
                    $query_args['orderby'] = 'meta_value_num';

}else{
                    $query_args['orderby'] = $_GET['wlorder_by'];
                }
            }

if( isset( $_GET['wlsort'] ) ){
                $query_args['order'] = $_GET['wlsort'];
            }

}

if ( isset( $_GET['orderby'] ) ) {
            $ordering_args = WC()->query->get_catalog_ordering_args();
        } else {
            $ordering_args = WC()->query->get_catalog_ordering_args( $query_args['orderby'], $query_args['order'] );
        }
        $query_args['orderby'] = $ordering_args['orderby'];
        $query_args['order'] = $ordering_args['order'];

if ( $ordering_args['meta_key'] ) {
            $query_args['meta_key'] = $ordering_args['meta_key'];
        }

// Search Result
        if ( isset( $_GET['q'] ) || isset( $_GET['s'] ) ) {
            $s = !empty( $_GET['s'] ) ? $_GET['s'] : '';
            $q = !empty( $_GET['q'] ) ? $_GET['q'] : '';
            $query_args['s'] = !empty( $q ) ? $q : $s;
        }

return $query_args;
    }

/**
     * [get_tax_query]
     * @return [array]
     */
    public function get_tax_query(){

$tax_query = WC()->query->get_tax_query();

if ( isset( $_GET['wlfilter'] ) ) {

$woo_taxonomies = get_object_taxonomies( 'product' );

// Filter With Currenct taxonomies page filter
            // if( isset( $_GET['min_price'] ) && isset( $_GET['max_price'] ) ){
            //     $termobj = get_queried_object();
            //     $get_all_taxonomies = woolentor_get_taxonomies();

//     if ( is_shop() || ( is_tax('product_cat') && is_product_category() ) || ( is_tax('product_tag') && is_product_tag() ) || ( isset( $termobj->taxonomy ) && is_tax( $termobj->taxonomy ) && array_key_exists( $termobj->taxonomy, $get_all_taxonomies ) ) ) {
            //         if(( is_tax('product_cat') && is_product_category() ) || ( is_tax('product_tag') && is_product_tag() )){
            //             $term_id = $termobj->term_id;
            //             $tax_query[] = array(
            //                 array(
            //                     'taxonomy' => $termobj->taxonomy,
            //                     'terms' => $term_id,
            //                     'field' => 'term_id',
            //                     'include_children' => true
            //                 )
            //             );
            //         }
            //     }
            // }

$queries =[];
            $new_queries = [];
            parse_str( $_SERVER['QUERY_STRING' ], $queries );
            foreach ( $queries as $key => $querie ) {
                // $new_queries[] = $key;

if( !in_array( $key, [ 'wlsort', 'wlorder_by' ] ) ){
                    $attr_pre_str = substr( $key, 0, 6 );

if( 'filter' === $attr_pre_str ){
                        $taxonomy = str_replace('filter', 'pa', $key );
                    } else if( 'woolentor' === substr( $key, 0, 9 ) ){
                        $taxonomy = str_replace('woolentor_','',$key);
                    }else{
                        $taxonomy = $key;
                    }

if( ( $taxonomy !== "" ) && in_array( $taxonomy, $woo_taxonomies ) ){
                        $new_queries[] = $key;
                        $tax_query[] = array(
                            'taxonomy' => $taxonomy,
                            'field' => 'slug',
                            'terms' => explode( ',', $querie ),
                        );
                    }

}

// Set Current taxonomy if no filter with taxonomy
            if( is_array( $new_queries ) && count($new_queries) == 0 ){
                $termobj = get_queried_object();
                $get_all_taxonomies = woolentor_get_taxonomies();

if ( is_shop() || ( is_tax('product_cat') && is_product_category() ) || ( is_tax('product_tag') && is_product_tag() ) || ( isset( $termobj->taxonomy ) && is_tax( $termobj->taxonomy ) && array_key_exists( $termobj->taxonomy, $get_all_taxonomies ) ) ) {
                    if(( is_tax('product_cat') && is_product_category() ) || ( is_tax('product_tag') && is_product_tag() )){
                        $term_id = $termobj->term_id;
                        $tax_query[] = array(
                            array(
                                'taxonomy' => $termobj->taxonomy,
                                'terms' => $term_id,
                                'field' => 'term_id',
                                'include_children' => true
                            )
                        );
                    }
                }
            }

// Featured Product
            if( isset( $_GET['wlorder_by'] ) && $_GET['wlorder_by'] === 'featured' ){
                $tax_query[] = [
                    'taxonomy' => 'product_visibility',
                    'field'    => 'name',
                    'terms'    => explode( ',', $_GET['wlorder_by'] ),
                    'operator' => ( $_GET['wlorder_by'] === 'exclude-from-catalog' ? 'NOT IN' : 'IN' ),
                ];
            }           
        }

// Module Support: Advanced Filter module query, If set Advanced Filter module query then do not apply current taxonomy query
        $has_advanced_filter = false;
        if( function_exists('wlpf_get_query_args_prefix') ){
            $query_string = $_SERVER['QUERY_STRING' ];
            $has_advanced_filter = is_string($query_string) && strpos($query_string, wlpf_get_query_args_prefix()) === 0;
        }

if ( !isset( $_GET['wlfilter'] ) && !$has_advanced_filter ) {

// Taxonomy Taxquery
            $termobj = get_queried_object();
            $get_all_taxonomies = woolentor_get_taxonomies();
            if( isset( $termobj->taxonomy ) && is_tax( $termobj->taxonomy ) && array_key_exists( $termobj->taxonomy, $get_all_taxonomies ) ){
                $term_id = $termobj->term_id;
                $tax_query[] = array(
                    array(
                        'taxonomy' => $termobj->taxonomy,
                        'terms' => $term_id,
                        'field' => 'term_id',
                        'include_children' => true
                    )
                );
            }

// Attributes Taxquery
            if ( is_array( WC()->query->get_layered_nav_chosen_attributes() ) && count( WC()->query->get_layered_nav_chosen_attributes() ) > 0 ) {
                foreach ( WC()->query->get_layered_nav_chosen_attributes() as $taxonomy => $data ) {
                    $tax_query[] = array(
                        array(
                            'taxonomy'         => $taxonomy,
                            'field'            => 'slug',
                            'terms'            => $data['terms'],
                            'operator'         => 'and' === $data['query_type'] ? 'AND' : 'IN',
                            'include_children' => false,
                        )
                    );
                }
            }

}

return $tax_query;

}

/**
     * [get_meta_query]
     * @return [array] meta Query
     */
    public function get_meta_query(){
        $meta_query = WC()->query->get_meta_query();

if( isset( $_GET['min_price'] ) && isset( $_GET['max_price'] ) ){
            $meta_query = array_merge( array('relation' => 'AND'), $meta_query );
            $meta_query[] = array(
                [
                    'key' => '_price',
                    'value' => array( $_GET['min_price'], $_GET['max_price'] ),
                    'compare' => 'BETWEEN',
                    'type' => 'NUMERIC'
                ],
            );
        }

if( isset( $_GET['wlstock'] ) && $_GET['wlstock'] != 'all' ){

if( $_GET['wlstock'] == 'outofstock' ){
                $meta_query[] = [
                    'key'     => '_stock_status',
                    'value'   => 'outofstock',
                    'compare' => '==',
                ];
            }else{
                $meta_query[] = [
                    'key'     => '_stock_status',
                    'value'   => 'instock',
                    'compare' => '==',
                ];
            }

}
        
        return $meta_query;

}

WooLentorProductQuery::instance();

Cancel