VariantOptionGroupExcl.php
3.23 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
<?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();
}
}