common/models/Articles.php

<?php
    
    namespace common\models;
    
    use common\modules\language\behaviors\LanguageBehavior;
    use common\behaviors\SaveImgBehavior;
    use common\modules\comment\models\CommentModel;
    use Yii;
    use yii\db\ActiveQuery;
    use yii\db\ActiveRecord;
    use yii\web\Request;
    
    /**
     * This is the model class for table "articles".
     * @property integer        $id
     * @property integer        $date
     * @property string         $title
     * @property string         $body
     * @property string         $image
     * @property string         $translit
     * @property string         $meta_title
     * @property string         $meta_keywords
     * @property string         $meta_description
     * @property string         $seo_text
     * @property string         $h1
     * @property string         $body_preview
     * * From language behavior *
     * @property ArticlesLang   $lang
     * @property ArticlesLang[] $langs
     * @property ArticlesLang   $object_lang
     * @property string         $ownerKey
     * @property string         $langKey
     * @method string           getOwnerKey()
     * @method void             setOwnerKey(string $value)
     * @method string           getLangKey()
     * @method void             setLangKey(string $value)
     * @method ActiveQuery      getLangs()
     * @method ActiveQuery      getLang( integer $language_id )
     * @method ArticlesLang[]   generateLangs()
     * @method void             loadLangs(Request $request, ActiveRecord[] $model_langs)
     * @method bool             linkLangs(ActiveRecord[] $model_langs)
     * @method bool             saveLangs(ActiveRecord[] $model_langs)
     * * End language behavior *
     */
    class Articles extends \yii\db\ActiveRecord
    {
        public $imageUpload;
        
        /**
         * @inheritdoc
         */
        public static function tableName()
        {
            return 'articles';
        }
        
        /**
         * @inheritdoc
         */
        public function behaviors()
        {
            return [
                'slug'     => [
                    'class'         => 'common\behaviors\Slug',
                    'in_attribute'  => 'title',
                    'out_attribute' => 'translit',
                    'translit'      => true,
                ],
                [
                    'class' => SaveImgBehavior::className(),
                ],
                'language' => [
                    'class' => LanguageBehavior::className(),
                ],
            ];
        }
        
        /**
         * @inheritdoc
         */
        public function rules()
        {
            return [
                [
                    [ 'date' ],
                    'default',
                    'value' => function() {
                        return time();
                    },
                ],
                [
                    [ 'date' ],
                    'safe',
                ],
                [
                    [
                        'title',
                        'body',
                    ],
                    'required',
                ],
                [
                    [
                        'body',
                        'body_preview',
                        'seo_text',
                    ],
                    'string',
                ],
                [
                    [
                        'title',
                        'image',
                        'translit',
                        'meta_title',
                        'meta_keywords',
                        'meta_description',
                        'h1',
                    ],
                    'string',
                    'max' => 255,
                ],
                [
                    [ 'imageUpload' ],
                    'safe',
                ],
                [
                    [ 'imageUpload' ],
                    'file',
                    'extensions' => 'jpg, gif, png',
                ],
                [
                    [ 'date' ],
                    'filter',
                    'filter' => function($value) {
                        return strtotime($value) ? : time();
                    },
                ],
            ];
        }
        
        /**
         * @inheritdoc
         */
        public function attributeLabels()
        {
            return [
                'id'               => 'ID',
                'date'             => 'Date',
                'title'            => 'Title',
                'body'             => 'Body',
                'body_preview'     => 'Body preview',
                'image'            => 'Image',
                'imageUrl'         => Yii::t('app', 'Image'),
                'translit'         => 'Translit',
                'meta_title'       => 'Meta Title',
                'meta_keywords'    => 'Meta Keywords',
                'meta_description' => 'Meta Description',
                'seo_text'         => 'Seo Text',
                'h1'               => 'H1',
            ];
        }
        
        public function getImageFile()
        {
            return empty( $this->image ) ? NULL : Yii::getAlias('@imagesDir/articles/' . $this->image);
        }
        
        public function getImageUrl()
        {
            return empty( $this->image ) ? NULL : Yii::getAlias('@imagesUrl/articles/' . $this->image);
        }
        
        public function recalculateRating()
        {
            /**
             * @var ArticleToRating $averageRating
             */
            $average = $this->getComments()
                            ->joinWith('rating')
                            ->select([ 'average' => 'avg(artbox_comment_rating.value)::float' ])
                            ->scalar();
            if(!$average) {
                $average = 0;
            }
            $averageRating = $this->averageRating;
            if(!empty( $averageRating )) {
                $averageRating->value = $average;
            } else {
                $averageRating = new ArticleToRating([
                    'articles_id' => $this->id,
                    'value'       => $average,
                ]);
            }
            if($averageRating->save()) {
                return true;
            } else {
                return false;
            }
        }
        
        public function getComments()
        {
            return $this->hasMany(CommentModel::className(), [ 'entity_id' => 'id' ])
                        ->where([
                            'artbox_comment.entity'             => self::className(),
                            'artbox_comment.status'             => CommentModel::STATUS_ACTIVE,
                            'artbox_comment.artbox_comment_pid' => NULL,
                        ]);
        }
        
        public function getAverageRating()
        {
            return $this->hasOne(ArticleToRating::className(), [ 'articles_id' => 'id' ]);
        }
    }