Как отсортировать товары Woocomerce по минимальному и максимальному значениям атрибута?

Question

[Сергей Гурджиян]

Как отсортировать товары Woocomerce, передав через get строку минимальное и максимальное значения атрибута?

Например shop/?filtering=1&attr-min=10&attr-max=100 по аналогии с фильтром по цене?

Answer 1

[Игорь Мавлиханов]

вот мой пример...

add_action('pre_get_posts', 'filter');
  function filter($query)
    {
        if (!is_admin() && $query->is_main_query() && !is_single() &&
            ((isset($_GET['pa_class']) || isset($_GET['pa_size']) || isset($_GET['pa_material']))
            )
        ) {
            if (is_woocommerce()) {
                if ((isset($_GET['pa_class']) && !empty($_GET['pa_class'])) ||
                    (isset($_GET['pa_size']) && !empty($_GET['pa_size'])) ||
                    (isset($_GET['pa_color']) && !empty($_GET['pa_color'])) ||
                    (isset($_GET['pa_material']) && !empty($_GET['pa_material']))
                ) {
                    if ((isset($_GET['pa_class']) && !empty($_GET['pa_class']))) {
                        $tax[] = array(
                            'taxonomy' => 'pa_class',
                            'field' => 'slug',
                            'terms' => $_GET['pa_class']
                        );
                    }
                    if ((isset($_GET['pa_color']) && !empty($_GET['pa_color']))) {
                        $tax[] = array(
                            'taxonomy' => 'pa_color',
                            'field' => 'slug',
                            'terms' => $_GET['pa_color']
                        );
                    }
                    if ((isset($_GET['pa_size']) && !empty($_GET['pa_size']))) {
                        $tax[] = array(
                            'taxonomy' => 'pa_size',
                            'field' => 'slug',
                            'terms' => $_GET['pa_size']
                        );
                    }
                    if ((isset($_GET['pa_material']) && !empty($_GET['pa_material']))) {
                        $tax[] = array(
                            'taxonomy' => 'pa_material',
                            'field' => 'slug',
                            'terms' => $_GET['pa_material']
                        );
                    }
                    $query->set('tax_query', $tax);
                }
            }
        } elseif (is_search()) {
            $query->set('post_type', 'product');
        }
    }

https://wp-kama.ru/function/wp_query#kcmenu

Comments

[Сергей Гурджиян]

Благодарю за ответ. Вопрос уже не актуален, но ваш ответ очень полезен для меня)

[Игорь Мавлиханов]

на здоровье)

Answer 2

[Сергей Гурджиян]

Вот мой вариант решения сортировки через url

<?php
                    global $paged;
                    global $wp_query;
                    $paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
                    $catObj = $wp_query->get_queried_object();
                    $catId = $catObj->term_id;
                    $filterData = $_GET;
                    $params = [
                        'post_status' => 'publish',
                        'posts_per_page' => 12,
                        'paged' => $paged,
                        'post_type' => 'product'
                    ];
                    if (isset($filterData['orderby'])) {
                        switch ( $filterData['orderby'] ) {
                            case 'date':
                                $params['orderby'] = 'date';
                                $params['order'] = 'DESC';
                                break;
                            case 'price':
                                $params['orderby'] = 'meta_value_num';
                                $params['order'] = 'ASC';
                                $params['orderby_meta_key'] = '_price';
                                break;
                            case 'price-desc':
                                $params['orderby'] = 'meta_value_num';
                                $params['order'] = 'DESC';
                                $params['orderby_meta_key'] = '_price';
                                break;
                            case 'popularity':
                                $params['orderby'] = 'meta_value_num';
                                $params['order'] = 'DESC';
                                $params['orderby_meta_key'] = 'total_sales';
                                break;
                            case 'rating':
                                $params['orderby'] = 'meta_value_num';
                                $params['order'] = 'DESC';
                                $params['orderby_meta_key'] = '_wc_average_rating';
                                break;
                        }
                        unset($filterData['orderby']);
                    }
                    $meta_query = [
                        'relation' => 'AND'
                    ];
                    $tax_query = [
                        'relation' => 'AND'
                    ];
                    if ($catId != '') {
                        $tax_query[] =
                            array(
                                'taxonomy' => 'product_cat',
                                'field' => 'term_id',
                                'terms' => $catId,
                                'operator' => 'IN'
                            );
                    }
                    foreach ($filterData as $key => $metaItem) {
                        if ($metaItem != '') {
                            $values = explode(',', $metaItem);
                            $compare = '=';
                            switch ($key) {
                                case ('min_tempo') :
                                    $key = 'tempo';
                                    $compare = '>=';
                                    break;
                                case ('max_tempo') :
                                    $key = 'tempo';
                                    $compare = '<=';
                                    break;
                            }
                            foreach ($values as $value) {
                                if ($key == 'tempo') {
                                    $meta_query[] = [
                                        'key' => $key,
                                        'value' => $value,
                                        'compare' => $compare,
                                        'type' => 'NUMERIC'
                                    ];
                                } else {
                                    $tax_query[] = [
                                        'taxonomy' => 'pa_' . $key,
                                        'field' => 'slug',
                                        'terms' => $value
                                    ];
                                }
                            }
                        }
                    }
                    if (count($meta_query) > 1) {
                        $params['meta_query'] = $meta_query;
                    }
                    $params['tax_query'] = $tax_query;
                    $wc_query = new WP_Query($params);
                    if ($wc_query->have_posts()) {
                        woocommerce_product_loop_start();
                        woocommerce_product_subcategories();
                        while ($wc_query->have_posts()) {
                            $wc_query->the_post();
                            wc_get_template_part('content', 'product');
                        }
                        woocommerce_product_loop_end();
                        if ($wc_query->max_num_pages > 1) : ?>
                            <nav class="woocommerce-pagination">
                                <?php echo paginate_links(apply_filters('woocommerce_pagination_args', array(
                                    'base' => esc_url_raw(str_replace(999999999, '%#%', remove_query_arg('add-to-cart', get_pagenum_link(999999999, false)))),
                                    'format' => '',
                                    'add_args' => false,
                                    'current' => max(1, get_query_var('paged')),
                                    'total' => $wc_query->max_num_pages,
                                    'prev_text' => '&larr;',
                                    'next_text' => '&rarr;',
                                    'type' => 'list',
                                    'end_size' => 3,
                                    'mid_size' => 3
                                ))); ?>
                            </nav>
                        <?php endif;
                    } elseif (!woocommerce_product_subcategories(array('before' => woocommerce_product_loop_start(false), 'after' => woocommerce_product_loop_end(false)))) {
                        wc_get_template('loop/no-products-found.php');
                    }
                    ?>