Administrator / test_3

  <?php
  
      namespace common\models;
  

      use common\modules\comment\models\CommentProject;

      use common\modules\fileloader\behaviors\FileloaderBehavior;
      use common\modules\fileloader\models\Fileloader;

      use Yii;
      use yii\behaviors\BlameableBehavior;
      use yii\behaviors\TimestampBehavior;

      use yii\db\ActiveQuery;

      use yii\db\Expression;
  
      /**
       * This is the model class for table "project".
       * @property integer                 $project_id
       * @property integer                 $user_id
       * @property string                  $name
       * @property string                  $link
       * @property integer                 $project_pid
       * @property string                  $date_add
       * @property string                  $date_end
       * @property integer                 $user_add_id
       * @property double                  $view_count
       * @property string                  $budget
       * @property string                  $city
       * @property string                  $street
       * @property string                  $house
       * @property integer                 $payment_variant
       * @property integer                 $deadline
       * @property string                  $description
       * @property integer                 $contractual
       * @property ProjectPayment[]        $projectPayments
       * @property ProjectSpecialization[] $projectSpecializations
       * @property Specialization[]        $specializations

       * @property Currency                $budgetCurrency

       * @property Project                 $parent

       * @property int                     $hidden

       * @property int[]                   $fileloader
       * @method File[] getFileloaderFiles()

       */
      class Project extends \yii\db\ActiveRecord
      {
  

          public $files;

          /**
           * @inheritdoc
           */
          public static function tableName()
          {
              return 'project';
          }
  

          /**
           * @inheritdoc
           */
          public function behaviors()
          {
              return [
                  [
                      'class'              => BlameableBehavior::className(),
                      'createdByAttribute' => 'user_id',
                      'updatedByAttribute' => false,
                  ],
                  [
                      'class'              => TimestampBehavior::className(),
                      'createdAtAttribute' => 'date_add',
                      'updatedAtAttribute' => false,
                      'value'              => new Expression('NOW()'),
                  ],

                  'slug'       => [

                      'class'         => 'common\behaviors\Slug',
                      'in_attribute'  => 'name',

                      'out_attribute' => 'link',

                      'translit'      => true,
                  ],

                  'fileloader' => [
                      'class' => FileloaderBehavior::className(),
                  ],

              ];
          }
  
          /**
           * @inheritdoc
           */
          public function rules()
          {
              return [
                  [

                      [
                          'name',

                          'link',

                      ],

                      'required',
                  ],
                  [
                      [

                          'project_pid',
                          'payment_variant',
                          'contractual',

                          'budget_currency',

                      ],
                      'integer',
                  ],
                  [
                      [ 'description' ],
                      'string',
                  ],
                  [
                      [

                          'specializationInput',
                          'paymentInput',

                          'files',

                      ],
                      'safe',
                  ],
                  [
                      [

                          'name',
                          'link',
                          'budget',
                          'city',
                          'street',
                          'house',
                      ],
                      'string',
                      'max' => 255,
                  ],

                  [
                      [ 'view_count' ],
                      'default',
                      'value' => 0,
                  ],

                  [
                      [
                          'paymentInput',
                          'specializationInput',
                      ],
                      'default',
                      'value' => [ ],
                  ],

                  [

                      [ 'deadline' ],

                      'integer',
                      'min' => 1,
                  ],
                  [

                      [
                          'deadline',
                      ],

                      'default',
                      'value' => 1,
                  ],

                  [
                      [ 'date_end' ],
                      'default',
                      'value' => date('Y-m-d H:i:s'),
                  ],
                  [
                      [ 'hidden' ],
                      'boolean',
                  ],
                  [

                      [ 'hidden' ],

                      'default',
                      'value' => 0,
                  ],
                  [

                      [ 'date_end' ],

                      'filter',
                      'filter' => function($value) {
                          $unix = strtotime($value);
                          if($unix <= time()) {

                              $unix = time() + ( 3600 * 24 * 7 );

                          }
                          return date('Y-m-d', $unix);

                      },
                  ],

              ];
          }
  
          /**
           * @inheritdoc
           */
          public function attributeLabels()
          {
              return [

                  'project_id'           => Yii::t('app', 'project_id'),
                  'user_id'              => Yii::t('app', 'user_id'),
                  'name'                 => Yii::t('app', 'name'),
                  'link'                 => Yii::t('app', 'link'),
                  'project_pid'          => Yii::t('app', 'project_pid'),
                  'date_add'             => Yii::t('app', 'date_add'),
                  'date_end'             => Yii::t('app', 'date_end'),
                  'user_add_id'          => Yii::t('app', 'user_add_id'),
                  'view_count'           => Yii::t('app', 'view_count'),
                  'budget'               => Yii::t('app', 'budget'),
                  'city'                 => Yii::t('app', 'city'),
                  'street'               => Yii::t('app', 'street'),
                  'house'                => Yii::t('app', 'house'),
                  'payment_variant'      => Yii::t('app', 'payment_variant'),
                  'deadline'             => Yii::t('app', 'deadline'),
                  'description'          => Yii::t('app', 'description'),
                  'contractual'          => Yii::t('app', 'contractual'),
                  'file'                 => Yii::t('app', 'file'),
                  'specializationInput'  => Yii::t('app', 'specializationInput'),
                  'paymentInput'         => Yii::t('app', 'paymentInput'),
                  'specializationString' => Yii::t('app', 'specializationString'),

                  'hidden'               => Yii::t('app', 'hidden_project'),

              ];
          }
  
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getProjectPayments()
          {
              return $this->hasMany(ProjectPayment::className(), [ 'project_id' => 'project_id' ]);
          }
  
          public function getPayments()
          {
              return $this->hasMany(Payment::className(), [ 'payment_id' => 'payment_id' ])

                          ->viaTable('project_payment', [ 'project_id' => 'project_id' ]);

          }
  

          /**
           * @return \yii\db\ActiveQuery
           */

          public function getUser()

          {
              return $this->hasOne(User::className(), [ 'id' => 'user_id' ]);
          }
  

          /**
           * @return \yii\db\ActiveQuery
           */
          public function getParent()
          {
              return $this->hasOne(self::className(), [ 'project_id' => 'project_pid' ]);
          }
  

          public function getBudgetCurrency()
          {
              return $this->hasOne(Currency::className(), [ 'currency_id' => 'budget_currency' ]);
          }
  

          /**
           * @return \yii\db\ActiveQuery
           */
          public function getProjectSpecializations()
          {
              return $this->hasMany(ProjectSpecialization::className(), [ 'project_id' => 'project_id' ]);
          }
  
          public function getSpecializations()
          {
              return $this->hasMany(Specialization::className(), [ 'specialization_id' => 'specialization_id' ])
                          ->viaTable('project_specialization', [ 'project_id' => 'project_id' ]);
          }
  
          public function getSpecializationInput()
          {
              return $this->getSpecializations()
                          ->asArray()

                          ->indexBy('specialization_id')

                          ->column();
          }
  

          public function setSpecializationInput($value)
          {

              $this->specializationInput = $value;
          }
  
          public function getPaymentInput()
          {
              return $this->getPayments()
                          ->asArray()
                          ->column();
          }
  

          public function setPaymentInput($value)
          {

              $this->paymentInput = $value;
          }

  
          public function getSpecializationString()
          {
              return implode(', ', $this->getSpecializations()
                                        ->select([
                                            'specialization_name',
                                            'specialization_id',
                                        ])
                                        ->asArray()
                                        ->indexBy('specialization_id')
                                        ->column());
          }
  
          public function setSpecializationString($value)
          {
              $this->specializationString = $value;
          }

  
          /**
           * @return File[]
           */
          public function getFilesList()
          {
              $files = json_decode($this->files);
              if(!empty( $files )) {
                  return File::findAll($files);
              } else {
                  return [ ];
              }
          }

  
          public function getIsBookmarked()
          {

              $type = Bookmark::TYPE_PROJECT;
              if(!empty( \Yii::$app->user->identity )) {
                  if(!empty( $this->hasOne(Bookmark::className(), [ 'model_id' => 'project_id' ])
                                  ->andWhere([
                                      'model'   => $this->className(),
                                      'user_id' => \Yii::$app->user->getId(),
                                      'type'    => $type,
                                  ])
                                  ->one() )
                  ) {
                      return true;
                  } else {
                      return false;
                  }
              } else {
                  return false;
              }
          }
  
          public function getComments()
          {
              return $this->hasMany(CommentProject::className(), [ 'model_id' => 'project_id' ])
                          ->andWhere([ 'model' => $this->className() ]);

          }

      }