models/ProductFrontendSearch.php

<?php
    
    namespace artweb\artbox\ecommerce\models;
    
    use artweb\artbox\ecommerce\helpers\FilterHelper;
    use artweb\artbox\ecommerce\models\Category;
    use yii\base\Model;
    use yii\data\ActiveDataProvider;
    use yii\data\ArrayDataProvider;
    use yii\data\Sort;
    use yii\db\ActiveQuery;
    
    use artweb\artbox\ecommerce\models\Product;
    use artweb\artbox\ecommerce\models\ProductVariant;
    
    class ProductFrontendSearch extends Product
    {
        
        public $price_interval;
        public $brands;
        
        public function behaviors()
        {
            $behaviors = parent::behaviors();
            
            if (isset( $behaviors[ 'language' ] )) {
                unset( $behaviors[ 'language' ] );
            }
            return $behaviors;
        }
        
        /**
         * @inheritdoc
         */
        public function rules()
        {
            return [
                [
                    [
                        'price_interval',
                        'brands',
                    ],
                    'safe',
                ],
            ];
        }
        
        /**
         * @inheritdoc
         */
        public function scenarios()
        {
            // bypass scenarios() implementation in the parent class
            return Model::scenarios();
        }
        
        /**
         * Creates data provider instance with search query applied for frontend
         *
         * @param array $params
         *
         * @return ArrayDataProvider
         */
        public function search($category = null, $params = [], $in_stock = true)
        {
            
            $sort = new Sort(
                [
                    'attributes' => [
                        'name_asc'  => [
                            'asc'     => [ 'lang.title' => SORT_ASC ],
                            'desc'    => [ 'lang.title' => SORT_ASC ],
                            'default' => SORT_ASC,
                            'label'   => 'имени от А до Я',
                        ],
                        'name_desc' => [
                            'asc'     => [ 'lang.title' => SORT_DESC ],
                            'desc'    => [ 'lang.title' => SORT_DESC ],
                            'default' => SORT_DESC,
                            'label'   => 'имени от Я до А',
                        ],
                        'price_asc'     => [
                            'asc'     => [ 'enabledVariants.price' => SORT_ASC ],
                            'desc'    => [ 'enabledVariants.price' => SORT_ASC ],
                            'default' => SORT_ASC,
                            'label'   => 'по цене по возрастанию',
                        ],
                        'price_desc'     => [
                            'asc'     => [ 'enabledVariants.price' => SORT_DESC ],
                            'desc'    => [ 'enabledVariants.price' => SORT_DESC ],
                            'default' => SORT_DESC,
                            'label'   => 'по цене по уменшению',
                        ],
                    ],
                ]
            );
            
            $dataProvider = new ArrayDataProvider(
                [
                    'allModels'  => $this->getSearchQuery($category, $params, $in_stock)
                                         ->with('variant', 'videos')->all(),
                    'pagination' => [
                        'pageSize' => 12,
                    ],
                    'sort'       => $sort,
                ]
            );
            
            return $dataProvider;
        }
        
        public function getSearchQuery($category = null, $params = [], $in_stock = true)
        {
            
            if (!empty( $category )) {
                /** @var ActiveQuery $query */
                /**@var Category $category * */
                $query = $category->getProducts();
                
            } else {
                $query = Product::find()
                    ->joinWith(['category','category.lang']);
            }
            
            $query->select([ 'product.*' ]);
            $query->joinWith(
                [
                    'lang',
                    'brand.lang',
                    'options',
                ]
            )
                  ->innerJoinWith(
                      [
                          'enabledVariants' => function ($query) {
                              /**
                               * @var ActiveQuery $query
                               */
                              $query->joinWith('lang')
                                    ->with('images');
                          },
                      ]
                  );
            
            $query->groupBy(
                [
                    'product.id',
                    'product_variant.price',
                ]
            );
            
            FilterHelper::setQueryParams($query, $params);
            if ($in_stock) {
                $query->andWhere(
                    [
                        '>=',
                        ProductVariant::tableName() . '.stock',
                        1,
                    ]
                );
            }
            
            return $query;
        }
        
        /**
         * @param Category|null $category
         *
         * @return array
         */

        public function priceLimits($category = null, $params = []) {
            if (!empty($category)) {
                /** @var ActiveQuery $query */
//            $query = $category->getRelations('product_categories');
                $query = $category->getProducts();
            } else {
                $query = Product::find();
            }
            $query->joinWith('variant');

            // Price filter fix
            unset($params['prices']);

            FilterHelper::setQueryParams($query, $params);
            $query->andWhere(
                [
                    '>=',
                    ProductVariant::tableName() . '.stock',
                    1,
                ]
            );
            return [
                'min' => $query->min(ProductVariant::tableName() .'.price'),
                'max' => $query->max(ProductVariant::tableName() .'.price'),
            ];
        }
    }