Blame view

frontend/models/ProductFrontendSearch.php 3.83 KB
4253cbec   root   first commit
1
2
3
4
5
  <?php

  

  namespace frontend\models;

  

  use common\modules\product\helpers\ProductHelper;

4253cbec   root   first commit
6
7
  use common\modules\product\models\ProductCategory;

  use common\modules\product\models\ProductOption;

4253cbec   root   first commit
8
9
10
11
12
13
  use common\modules\rubrication\models\TaxGroup;

  use common\modules\rubrication\models\TaxOption;

  use Yii;

  use yii\base\Model;

  use yii\data\ActiveDataProvider;

  use yii\db\ActiveQuery;

771f8d54   Administrator   big commti
14
  

4253cbec   root   first commit
15
16
17
18
  use common\modules\product\models\Product;

  use common\modules\product\models\ProductVariant;

  

  class ProductFrontendSearch extends Product {

771f8d54   Administrator   big commti
19
20
21
22
23
24
  

  

      public $price_interval;

      public $brands;

  

  

4253cbec   root   first commit
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
      /**

       * @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 ActiveDataProvider

       */

97edb6ce   Administrator   big commti
51
      public function search($category = null, $params = [], $in_stock = true) {

4d5dbae3   Administrator   big commti
52
          

4253cbec   root   first commit
53
          $dataProvider = new ActiveDataProvider([

97edb6ce   Administrator   big commti
54
              'query' => $this->getSearchQuery($category, $params, $in_stock),

4253cbec   root   first commit
55
              'pagination' => [

d09f430f   Administrator   big commti
56
                  'pageSize' => 15,

4253cbec   root   first commit
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
              ],

              'sort' => [

                  'attributes' => [

                      'name' => [

                          'asc' => ['name' => SORT_ASC],

                          'desc' => ['name' => SORT_DESC],

                          'default' => SORT_DESC,

                          'label' => 'имени',

                      ],

                      'price' => [

                          'asc' => [ProductVariant::tableName() .'.price' => SORT_ASC],

                          'desc' => [ProductVariant::tableName() .'.price' => SORT_DESC],

                          'default' => SORT_DESC,

                          'label' => 'по цене',

                      ],

                  ],

              ]

          ]);

  

          if (!$this->validate()) {

              return $dataProvider;

          }

  

  

  

          return $dataProvider;

      }

  

97edb6ce   Administrator   big commti
85
      public function getSearchQuery($category = null, $params = [], $in_stock = true) {

4253cbec   root   first commit
86
87
88
89
90
91
92
93
          if (!empty($category)) {

              /** @var ActiveQuery $query */

  //            $query = $category->getRelations('product_categories');

              $query = $category->getProducts();

          } else {

              $query = Product::find();

          }

          $query->select(['product.*']);

d09f430f   Administrator   big commti
94
          $query->joinWith(['enabledVariants','brand','options', 'category']);

4253cbec   root   first commit
95
  

4d5dbae3   Administrator   big commti
96
          $query->groupBy(['product.product_id', 'product_variant.price']);

4253cbec   root   first commit
97
98
  

          ProductHelper::_setQueryParams($query, $params);

97edb6ce   Administrator   big commti
99
100
101
          if($in_stock){

              $query->andWhere(['!=', ProductVariant::tableName() .'.status', 1]);

          }

4253cbec   root   first commit
102
  

4253cbec   root   first commit
103
104
105
106
  

          return $query;

      }

  

4253cbec   root   first commit
107
108
109
110
111
112
113
114
115
116
117
  

      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');

  

4d5dbae3   Administrator   big commti
118
119
120
          // Price filter fix

          unset($params['prices']);

          

4253cbec   root   first commit
121
122
123
124
125
126
127
128
129
130
131
132
133
          ProductHelper::_setQueryParams($query, $params, false);

  

  //        $query->select([

  //            'MIN('. ProductVariant::tableName() .'.price) AS priceMIN',

  //            'MAX('. ProductVariant::tableName() .'.price) AS priceMAX',

  //        ]);

  

          return [

              'min' => $query->min(ProductVariant::tableName() .'.price'),

              'max' => $query->max(ProductVariant::tableName() .'.price'),

          ];

      }

  }