Blame view

common/modules/product/models/CategorySearch.php 3.27 KB
4253cbec   root   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
  <?php

  

  namespace common\modules\product\models;

  

  use common\components\artboxtree\ArtboxTreeHelper;

  use Yii;

  use yii\base\Model;

  use yii\data\ActiveDataProvider;

  use common\modules\product\models\Category;

  use yii\web\NotFoundHttpException;

  

  /**

   * CategorySearch represents the model behind the search form about `common\modules\product\models\Category`.

   */

  class CategorySearch extends Category

  {

      public function behaviors()

      {

          $behaviors = parent::behaviors();

          if (isset($behaviors['slug'])) {

              unset($behaviors['slug']);

          }

          if (isset($behaviors['timestamp'])) {

              unset($behaviors['timestamp']);

          }

          return $behaviors;

      }

  

      /**

       * @inheritdoc

       */

      public function rules()

      {

          return [

              [['category_id', 'parent_id', 'depth', 'category_name_id', 'product_unit_id'], 'integer'],

              [['populary'], 'boolean'],

              [['path', 'image', 'meta_title', 'meta_desc', 'meta_robots', 'seo_text', 'alias'], 'safe'],

          ];

      }

  

      /**

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

      {

871a7349   Administrator   big commti
59
          $query = Category::find();

4253cbec   root   first commit
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
  

          // add conditions that should always apply here

  

          $dataProvider = new ActiveDataProvider([

              'query' => $query,

          ]);

  

          $this->load($params);

  

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

              // uncomment the following line if you do not want to return any records when validation fails

              // $query->where('0=1');

              return $dataProvider;

          }*/

  

          // grid filtering conditions

          $query->andFilterWhere([

              'category.category_id' => $this->category_id,

              'category.parent_id' => $this->parent_id,

              'category.category_name_id' => $this->category_name_id,

              'category.product_unit_id' => $this->product_unit_id,

          ]);

  

          $query->andFilterWhere(['like', 'category.alias', $this->alias]);

  

          $query->orderBy(['category.path' => SORT_ASC, 'category.depth' => SORT_ASC, 'category.category_id' => SORT_ASC]);

  

          return $dataProvider;

      }

  

      public static function findByAlias($alias) {

          /** @var CategoryQuery $query */

          $query = Category::find()

4253cbec   root   first commit
93
94
95
96
97
98
99
100
101
102
103
              ->andFilterWhere(['alias' => $alias]);

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

              return $model;

          } else {

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

          }

      }

  

      public static function findByRemoteID($id) {

          /** @var CategoryQuery $query */

          $query = Category::find()

4253cbec   root   first commit
104
105
106
107
108
109
110
111
112
113
114
              ->andFilterWhere(['@>', 'remote_id', ArtboxTreeHelper::setArrayField($id)]);

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

              return $model;

          }

          return null;

      }

  

  //    public static function findByProductsKeywords($keywords = [], $category = null) {

  //

  //    }

  }