d8c1a2e0
 Yarik
Big commit artbox
|
1
2
3
4
|
<?php
namespace common\models;
|
|
36d1807a
Yarik
Big commit.
|
5
|
use common\behaviors\SaveImgBehavior;
|
|
d8c1a2e0
Yarik
Big commit artbox
|
6
7
8
9
10
11
12
|
use common\modules\comment\models\CommentModel;
use Yii;
/**
* This is the model class for table "articles".
*
* @property integer $id
|
|
36d1807a
Yarik
Big commit.
|
13
|
* @property integer $date
|
|
d8c1a2e0
Yarik
Big commit artbox
|
14
15
16
17
18
19
20
21
22
|
* @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
|
|
36d1807a
Yarik
Big commit.
|
23
|
* @property string $body_preview
|
|
d8c1a2e0
Yarik
Big commit artbox
|
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
|
*/
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
],
|
|
36d1807a
Yarik
Big commit.
|
49
50
51
|
[
'class' => SaveImgBehavior::className(),
],
|
|
d8c1a2e0
Yarik
Big commit artbox
|
52
53
54
55
56
57
58
59
60
|
];
}
/**
* @inheritdoc
*/
public function rules()
{
return [
|
|
36d1807a
Yarik
Big commit.
|
61
62
63
|
[['date'], 'default', 'value' => function() {
return time();
}],
|
|
d8c1a2e0
Yarik
Big commit artbox
|
64
65
|
[['date'], 'safe'],
[['title', 'body'], 'required'],
|
|
36d1807a
Yarik
Big commit.
|
66
|
[['body', 'body_preview', 'seo_text'], 'string'],
|
|
d8c1a2e0
Yarik
Big commit artbox
|
67
68
69
|
[['title', 'image', 'translit', 'meta_title', 'meta_keywords', 'meta_description', 'h1'], 'string', 'max' => 255],
[['imageUpload'], 'safe'],
[['imageUpload'], 'file', 'extensions' => 'jpg, gif, png'],
|
|
36d1807a
Yarik
Big commit.
|
70
71
72
|
[['date'], 'filter', 'filter' => function($value) {
return strtotime($value)?:time();
}],
|
|
d8c1a2e0
Yarik
Big commit artbox
|
73
74
75
76
77
78
79
80
81
82
83
84
85
|
];
}
/**
* @inheritdoc
*/
public function attributeLabels()
{
return [
'id' => 'ID',
'date' => 'Date',
'title' => 'Title',
'body' => 'Body',
|
|
36d1807a
Yarik
Big commit.
|
86
|
'body_preview' => 'Body preview',
|
|
d8c1a2e0
Yarik
Big commit artbox
|
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
125
126
127
128
129
130
131
132
133
134
135
|
'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']);
}
}
|
