Blame view

artweb/artbox-catalog/models/queries/ProductQuery.php 3.66 KB
16f1e516   mzavalniuk   add artbox-catalo...
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
  <?php
      
      namespace artbox\catalog\models\queries;
      
      use artbox\catalog\models\Product;
      use artbox\catalog\models\traits\BitmaskTrait;
      use yii\db\ActiveQuery;
      
      /**
       * This is the ActiveQuery class for [[Product]].
       *
       * @see Product
       */
      class ProductQuery extends ActiveQuery
      {
          
          use BitmaskTrait;
          
          public function active()
          {
              return $this->andWhere(
                  [
                      'status' => true,
                  ]
              );
          }
          
          public function joinOptions(bool $multiple = true)
          {
              return $this->with(
                  [
                      'productOptionCompls' => function ($query) {
                          /**
                           * @var ActiveQuery $query
                           */
                          $query->with('lang.alias')
                                ->with('group.lang');
                      },
                  ]
              )
                          ->with(
                              [
                                  'productOptionExcls' => function ($query) {
                                      /**
                                       * @var ActiveQuery $query
                                       */
                                      $query->with('lang.alias')
                                            ->with('group.lang');
                                  },
                              ]
                          )
                          ->with(
                              [
                                  $multiple ? 'variants' : 'variant' => function ($query) {
                                      /**
                                       * @var ActiveQuery $query
                                       */
                                      $query->with('image')
                                            ->with(
                                                [
                                                    'variantOptionCompls' => function ($query) {
                                                        /**
                                                         * @var ActiveQuery $query
                                                         */
                                                        $query->with('lang.alias')
                                                              ->with('group.lang');
                                                    },
                                                ]
                                            )
                                            ->with(
                                                [
                                                    'variantOptionExcls' => function ($query) {
                                                        /**
                                                         * @var ActiveQuery $query
                                                         */
                                                        $query->with('lang.alias')
                                                              ->with('group.lang');
                                                    },
                                                ]
                                            );
                                  },
                              ]
                          );
          }
          
          /**
           * @inheritdoc
           * @return Product[]|array
           */
          public function all($db = null)
          {
              return parent::all($db);
          }
          
          /**
           * @inheritdoc
           * @return Product|array|null
           */
          public function one($db = null)
          {
              return parent::one($db);
          }
      }