common/models/Service.php

<?php
namespace common\models;
use artbox\core\models\Image;
use backend\traits\AliasableTrait;
use backend\behaviors\LevelBehavior;
use Yii;
use artbox\core\models\Language;
use yii\behaviors\TimestampBehavior;
use yii\db\ActiveQuery;
use yii\db\ActiveRecord;
use yii\helpers\Json;
use yii2tech\ar\position\PositionBehavior;
use yii2tech\ar\variation\VariationBehavior;
/**
 * This is the model class for table "service".
 *
 * @property int $id
 * @property int $parent_id
 * @property int $sort
 * @property bool $status
 * @property int $level
 * @property int $created_at
 * @property int $updated_at
 *
 * @property ServiceLang[] $serviceLangs
 * @property Language[] $languages
 * from VariationBehavior
 * @method ActiveQuery  hasDefaultVariationRelation();
 */
class Service extends ActiveRecord
{
    use AliasableTrait;
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return 'service';
    }
    
    /**
     * @return array
     */
    public function behaviors()
    {
        return [
            'translations'         => [
                'class'                             => VariationBehavior::className(),
                'variationsRelation'                => 'languages',
                'defaultVariationRelation'          => 'language',
                'variationOptionReferenceAttribute' => 'language_id',
                'optionModelClass'                  => Language::className(),
                'defaultVariationOptionReference'   => function () {
                    return Language::getCurrent()->id;
                },
                'optionQueryFilter'                 => function (ActiveQuery $query) {
                    $query->where(
                        [
                            'status' => true,
                        ]
                    );
                },
            ],
            'positionBehavior'     => [
                'class'             => PositionBehavior::className(),
                'positionAttribute' => 'sort',
            ],
            'timestamp'            => [
                'class' => TimestampBehavior::className(),
            ],
            'level' => [
                'class' => LevelBehavior::className(),
            ],
        ];
    }
    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['parent_id', 'sort', 'level', 'created_at', 'updated_at'], 'default', 'value' => null],
            [['sort', 'level', 'created_at', 'updated_at', 'image_id'], 'integer'],
            [['status'], 'boolean'],
        ];
    }
    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => Yii::t('app', 'ID'),
            'parent_id' => Yii::t('app', 'Parent ID'),
            'sort' => Yii::t('app', 'Sort'),
            'status' => Yii::t('app', 'Status'),
            'level' => Yii::t('app', 'Level'),
            'created_at' => Yii::t('app', 'Created At'),
            'updated_at' => Yii::t('app', 'Updated At'),
            'image_id' => Yii::t('app', 'Image'),
        ];
    }
    /**
     * @return \yii\db\ActiveQuery
     */
    public function getLanguages()
    {
        return $this->hasMany(ServiceLang::className(), ['service_id' => 'id']);
    }
    
    /**
     * @return \yii\db\ActiveQuery
     */
    public function getParent(){
        return $this->hasOne(Service::className(), ['id' => 'parent_id']);
    }
    
    
    public function getLanguage(){
        return $this->hasDefaultVariationRelation();
    }
    
    /**
     * @return string
     */
    public function getRoute()
    {
        return Json::encode(
            [
                'service/view',
                'id' => $this->id,
            ]
        );
    }
    
    public function getImage(){
        return $this->hasOne(Image::className(), ['id' => 'image_id']);
    }
    
    /**
     * @return \yii\db\ActiveQuery
     */
    public function getServices()
    {
        return $this->hasMany(Service::className(), [ 'parent_id' => 'id' ]);
    }
    
    public function getPrices(){
        return $this->hasMany(Price::className(), ['service_id' => 'id']);
    }
    
    public function getComments(){
        return $this->hasMany(Comment::className(), ['entity_id' => 'id'])->andWhere(['entity' => Service::className()]);
    }
    
    public function getQuestions(){
        return $this->hasMany(Question::className(), ['service_id' => 'id']);
    }
    
    public function getPackages(){
        return $this->hasMany(Package::className(), ['service_id' => 'id']);
    }
}