Portfolio.php 4.77 KB
<?php

    namespace common\models;

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

    /**
     * This is the model class for table "portfolio".
     * @property integer                   $portfolio_id
     * @property integer                   $user_id
     * @property string                    $name
     * @property string                    $link
     * @property string                    $date_add
     * @property integer                   $user_add_id Currently inactive attribute
     * @property integer                   $view_count
     * @property string                    $city
     * @property string                    $street
     * @property string                    $house
     * @property string                    $description
     * @property string                    $cover
     * @property integer                   $gallery_id
     * @property PortfolioSpecialization[] $portfolioSpecializations
     * @property Specialization[]          $specializations
     */
    class Portfolio extends \yii\db\ActiveRecord
    {

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

        /**
         * @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()'),
                ],
            ];
        }

        /**
         * @inheritdoc
         */
        public function rules()
        {
            return [
                [
                    [
                        'name',
                    ],
                    'required',
                ],
                [
                    [
                        'gallery_id',
                    ],
                    'integer',
                ],
                [
                    [
                        'description',
                        'cover',
                    ],
                    'string',
                ],
                [
                    [
                        'name',
                        'link',
                        'city',
                        'street',
                        'house',
                    ],
                    'string',
                    'max' => 255,
                ],
                [
                    [
                        'specializationInput',
                    ],
                    'safe',
                ],
            ];
        }

        /**
         * @inheritdoc
         */
        public function attributeLabels()
        {
            return [
                'portfolio_id' => Yii::t('app', 'Portfolio ID'),
                'user_id'      => Yii::t('app', 'User ID'),
                'name'         => Yii::t('app', 'Название'),
                'link'         => Yii::t('app', 'URL'),
                'date_add'     => Yii::t('app', 'Дата добавления'),
                'user_add_id'  => Yii::t('app', 'User Add ID'),
                'view_count'   => Yii::t('app', 'Количество просмотров'),
                'city'         => Yii::t('app', 'Город'),
                'street'       => Yii::t('app', 'Улица'),
                'house'        => Yii::t('app', 'Дом'),
                'description'  => Yii::t('app', 'Описание'),
                'cover'        => Yii::t('app', 'Фото главное'),
                'gallery_id'   => Yii::t('app', 'Фото галерея'),
            ];
        }

        /**
         * @return \yii\db\ActiveQuery
         */
        public function getPortfolioSpecializations()
        {
            return $this->hasMany(PortfolioSpecialization::className(), [ 'portfolio_id' => 'portfolio_id' ]);
        }

        public function getSpecializations()
        {
            return $this->hasMany(Specialization::className(), [ 'specialization_id' => 'specialization_id' ])
                        ->viaTable('portfolio_specialization', [ 'portfolio_id' => 'portfolio_id' ]);
        }

        public function getSpecializationInput()
        {
            return $this->getSpecializations()
                        ->asArray()
                        ->column();
        }

        public function setSpecializationInput($value)
        {
            $this->specializationInput = $value;
        }
    }