Articles.php
3.32 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
namespace common\models;
use common\behaviors\RatingBehavior;
use common\behaviors\SaveImgBehavior;
use common\modules\comment\models\CommentModel;
use Yii;
/**
* This is the model class for table "articles".
*
* @property integer $id
* @property string $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
*/
class Articles extends \yii\db\ActiveRecord
{
public $imageUpload;
/**
* @inheritdoc
*/
public static function tableName()
{
return 'articles';
}
/**
* @inheritdoc
*/
public function behaviors()
{
return [
[
'class' => SaveImgBehavior::className(),
'fields' => [
['name'=>'image','directory' => 'articles' ]
]
],
'slug' => [
'class' => 'common\behaviors\Slug',
'in_attribute' => 'title',
'out_attribute' => 'translit',
'translit' => true
],
];
}
/**
* @inheritdoc
*/
public function rules()
{
return [
[['date'], 'safe'],
[['title', 'body'], 'required'],
[['body', 'seo_text'], 'string'],
[['title', 'image', 'translit', 'meta_title', 'meta_keywords', 'meta_description', 'h1'], 'string', 'max' => 255],
[['imageUpload'], 'safe'],
[['imageUpload'], 'file', 'extensions' => 'jpg, gif, png'],
];
}
/**
* @inheritdoc
*/
public function attributeLabels()
{
return [
'id' => 'ID',
'date' => 'Date',
'title' => 'Title',
'body' => 'Body',
'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 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']);
}
}