Blame view

artweb/artbox-catalog/models/VariantOptionGroupExcl.php 3.23 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
  <?php
      
      namespace artbox\catalog\models;
  
      use artbox\core\models\Language;
  
      /**
       * This is the model class for table "variant_option_group_excl".
       *
       * @property VariantOptionExcl[]          $variantOptionExcls
       * @property VariantOptionGroupExclLang[] $variantOptionGroupExclLangs
       * @property Language[]                   $languages
       */
      class VariantOptionGroupExcl extends OptionGroup
      {
          /**
           * @inheritdoc
           */
          public static function tableName()
          {
              return 'variant_option_group_excl';
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getVariantOptionExcls()
          {
              return $this->hasMany(VariantOptionExcl::className(), [ 'variant_option_group_excl_id' => 'id' ])
                          ->inverseOf('variantOptionGroupExcl');
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getVariantOptionGroupExclLangs()
          {
              return $this->hasMany(VariantOptionGroupExclLang::className(), [ 'variant_option_group_excl_id' => 'id' ])
                          ->inverseOf('variantOptionGroupExcl');
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getLanguages()
          {
              return $this->hasMany(Language::className(), [ 'id' => 'language_id' ])
                          ->viaTable('variant_option_group_excl_lang', [ 'variant_option_group_excl_id' => 'id' ]);
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getVariantOptionGroupExclToCategories()
          {
              return $this->hasMany(
                  VariantOptionGroupExclToCategory::className(),
                  [ 'variant_option_group_excl_id' => 'id' ]
              )
                          ->inverseOf('variantOptionGroupExcl');
          }
      
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getCategories()
          {
              return $this->hasMany(Category::className(), [ 'id' => 'category_id' ])
                          ->viaTable('variant_option_group_excl_to_category', [ 'variant_option_group_excl_id' => 'id' ]);
          }
      
          /**
           * @inheritdoc
           */
          public function getOptions()
          {
              return $this->getVariantOptionExcls()
                          ->inverseOf('group');
          }
      
          public function insertCategories(array $batch)
          {
              $query = \Yii::$app->db->createCommand()
                                     ->batchInsert(
                                         'variant_option_group_excl_to_category',
                                         [
                                             'variant_option_group_excl_id',
                                             'category_id',
                                             'sort',
                                             'status',
                                             'in_menu',
                                             'is_filter',
                                         ],
                                         $batch
                                     );
          
              $query->execute();
          }
      }