Blame view

frontend/models/OptionValues.php 2.87 KB
b0f143c3   Yarik   first commit
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_language_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_language_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_language_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_language_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;
      }
  }