Blame view

artweb/artbox-catalog/models/VariantOptionGroupCompl.php 3.33 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
  <?php
      
      namespace artbox\catalog\models;
  
      use artbox\core\models\Language;
  
      /**
       * This is the model class for table "variant_option_group_compl".
       *
       * @property VariantOptionCompl[]          $variantOptionCompls
       * @property VariantOptionGroupComplLang[] $variantOptionGroupComplLangs
       * @property Language[]                    $languages
       */
      class VariantOptionGroupCompl extends OptionGroup
      {
          /**
           * @inheritdoc
           */
          public static function tableName()
          {
              return 'variant_option_group_compl';
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getVariantOptionCompls()
          {
              return $this->hasMany(VariantOptionCompl::className(), [ 'variant_option_group_compl_id' => 'id' ])
                          ->inverseOf('variantOptionGroupCompl');
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getVariantOptionGroupComplLangs()
          {
              return $this->hasMany(VariantOptionGroupComplLang::className(), [ 'variant_option_group_compl_id' => 'id' ])
                          ->inverseOf('variantOptionGroupCompl');
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getLanguages()
          {
              return $this->hasMany(Language::className(), [ 'id' => 'language_id' ])
                          ->viaTable('variant_option_group_compl_lang', [ 'variant_option_group_compl_id' => 'id' ]);
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getVariantOptionGroupComplToCategories()
          {
              return $this->hasMany(
                  VariantOptionGroupComplToCategory::className(),
                  [ 'variant_option_group_compl_id' => 'id' ]
              )
                          ->inverseOf('variantOptionGroupCompl');
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getCategories()
          {
              return $this->hasMany(Category::className(), [ 'id' => 'category_id' ])
                          ->viaTable(
                              'variant_option_group_compl_to_category',
                              [ 'variant_option_group_compl_id' => 'id' ]
                          );
          }
      
          /**
           * @inheritdoc
           */
          public function getOptions()
          {
              return $this->getVariantOptionCompls()
                          ->inverseOf('group');
          }
      
          public function insertCategories(array $batch)
          {
              $query = \Yii::$app->db->createCommand()
                                     ->batchInsert(
                                         'variant_option_group_compl_to_category',
                                         [
                                             'variant_option_group_compl_id',
                                             'category_id',
                                             'sort',
                                             'status',
                                             'in_menu',
                                             'is_filter',
                                         ],
                                         $batch
                                     );
          
              $query->execute();
          }
      }