OptionValues.php
2.85 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
<?php
namespace frontend\models;
use Yii;
/**
* This is the model class for table "option_values".
*
* @property integer $option_value_id
* @property string $option_key
* @property string $option_value_text
* @property integer $option_lang_id
* @property integer $option_value_parent
* @property integer $option_user
*
* @property Language $optionLang
*/
class OptionValues extends \yii\db\ActiveRecord
{
/**
* @inheritdoc
*/
public static function tableName()
{
return 'option_values';
}
/**
* @inheritdoc
*/
public function rules()
{
return [
[['option_key', 'option_value_text'], 'required'],
[['option_lang_id', 'option_value_parent', 'option_user'], 'integer'],
[['option_key'], 'string', 'max' => 200]
];
}
/**
* @inheritdoc
*/
public function attributeLabels()
{
return [
'option_value_id' => Yii::t('app', 'Option Value ID'),
'option_key' => Yii::t('app', 'Option Key'),
'option_value_text' => Yii::t('app', 'Option Value Text'),
'option_lang_id' => Yii::t('app', 'Option Lang ID'),
'option_value_parent' => Yii::t('app', 'Option Value Parent'),
'option_user' => Yii::t('app', 'Option User'),
];
}
/**
* @return \yii\db\ActiveQuery
*/
public function getOptionLang()
{
return $this->hasOne(Language::className(), ['language_id' => 'option_lang_id']);
}
public function getLanguages() {
return (new LanguageLang())->find()->orderBy('language_id ASC')->asArray()->all();
}
public function getLanguagesCodes() {
return (new Language())->find()->orderBy('language_id ASC')->asArray()->all();
}
public function getDropDownArray() {
$langs = array();
foreach($this->getLanguages() as $lang) {
$langs[$lang['language_id']] = $lang['lang_title'];
}
return $langs;
}
public function beforeSave($insert) {
if (parent::beforeSave($insert)) {
$this->option_user = \Yii::$app->user->getId();
if($this->option_value_parent == 0) {
unset($this->option_value_parent);
}
return true;
} else {
return false;
}
}
public function getUserOptions() {
return (new OptionValues())->find()->where('option_user=:user')->addParams([':user' => \Yii::$app->user->getID()])->andWhere(['not', ['option_user' => null]])->asArray()->all();
}
public function getUserOptionsArray() {
$options = array('0' => Yii::t('app', 'Default Parent'));
foreach($this->getUserOptions() as $option) {
$options[$option['option_value_id']] = $option['option_key'].' - '.$option['option_value_text'];
}
return $options;
}
}