Blame view

common/modules/product/models/ProductSearch.php 3.64 KB
4ca21c3e   Alexey Boroda   first commit
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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
51
52
53
54
55
56
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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
  <?php

  

  namespace common\modules\product\models;

  

  use yii\base\Model;

  use yii\data\ActiveDataProvider;

  use yii\db\ActiveQuery;

  use yii\web\NotFoundHttpException;

  

  /**

   * ProductSearch represents the model behind the search form about `common\modules\product\models\Product`.

   */

  class ProductSearch extends Product

  {

      public $brand_name;

      public $brand_id;

      public $category_id;

      public $category_name;

      public $variant_sku;

  

      /**

       * @inheritdoc

       */

      public function rules()

      {

          return [

              [['name', 'brand_name', 'brand_id', 'category_id', 'category_name', 'variant_sku'], 'safe'],

              [['brand_id', 'product_id'], 'integer'],

              [['is_top', 'is_new', 'akciya'], 'boolean'],

          ];

      }

      

      /**

       * @inheritdoc

       */

      public function scenarios()

      {

          // bypass scenarios() implementation in the parent class

          return Model::scenarios();

      }

  

      /**

       * Creates data provider instance with search query applied

       *

       * @param array $params

       *

       * @return ActiveDataProvider

       */

      public function search($params)

      {

  

          $query = Product::find();

  

          $query->joinWith(['brand', 'categories', 'variant']);

  

          $query->groupBy(['product.product_id']);

  

          $dataProvider = new ActiveDataProvider([

              'query' => $query,

          ]);

  

          if ( !($this->load($params) && $this->validate()) ) {

              return $dataProvider;

          }

  

          $dataProvider->setSort([

              'attributes' => [

                  'name',

                  'brand_name' => [

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

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

                      'default' => SORT_DESC,

                      'label' => 'Brand name',

                  ],

                  'category_name',

                  'variant_sku',

              ]

          ]);

  

          if (isset($this->is_top)) {

              $query->andFilterWhere([

                  'is_top' => (bool)$this->is_top,

              ]);

          }

          if (isset($this->is_new)) {

              $query->andFilterWhere([

                  'is_new' => (bool)$this->is_new,

              ]);

          }

          if (isset($this->akciya)) {

              $query->andFilterWhere([

                  'akciya' => (bool)$this->akciya,

              ]);

          }

          $query->andFilterWhere([

              'product.brand_id' => $this->brand_id,

              'product.product_id' => $this->product_id,

              'product_category.category_id' => $this->category_id

          ]);

  

          $query->andFilterWhere(['ilike', 'product.name', $this->name]);

          $query->andFilterWhere(['ilike', 'brand.name', $this->brand_name]);

          $query->andFilterWhere(['ilike', 'category.name', $this->category_name]);

          $query->andFilterWhere(['ilike', 'product_variant.sku', $this->variant_sku]);

  

          return $dataProvider;

      }

  

      public static function findByAlias($alias) {

          /** @var ActiveQuery $query */

          $query = Product::find();

          $query->andFilterWhere(['alias' => $alias]);

          if (($model = $query->one()) !== null) {

              return $model;

          } else {

              throw new NotFoundHttpException('The requested product does not exist.');

          }

      }

  

      public static function findByRemoteID($id) {

          /** @var CategoryQuery $query */

          $query = Product::find()

              ->andFilterWhere(['remote_id' => $id]);

          if (($model = $query->one()) !== null) {

              return $model;

          }

          return null;

      }

  }