Administrator / test_3

  <?php
  
  namespace common\models;
  
  use frontend\models\Options;
  use Yii;
  use yii\base\InvalidParamException;
  use yii\base\Model;
  
  class OptionHelper extends Model
  {
      const OPTION_OBJECT = 1;

      const OPTION_ARRAY = 2;

      const OPTION_VALUE = 3;

      public function getRule($return = 3)
      {

          $result = Option::find()->where(['name' => 'rules'])->with('value');

          if($return == self::OPTION_OBJECT) {
              return $result->one();
          } elseif($return == self::OPTION_ARRAY) {
              return $result->asArray()->one();
          } elseif($return == self::OPTION_VALUE) {
              return $result->one()->value->value;
          } else {
              throw new InvalidParamException(Yii::t('app', 'Must be 1-3'));
          }
      }

  
      public function createOptions($user_id)
      {
          if($rows_delete = \Yii::$app->db->createCommand()->delete('option', ['model' => 'common\models\User', 'model_id' => $user_id])->execute()) {
              Yii::trace( $rows_delete . " rows has been deleted.");
          } else {
              Yii::trace( "No rows has been deleted" );
          }

          //Yii::$app->db->createCommand()->batchInsert('option', ['model', 'model_id', 'name', 'template', 'option_pid'], [['common\models\User', $user_id, 'about', '']])

      }
  

  }