ProductQuery.php
3.66 KB
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);
        }
    } 
