Blame view

common/modules/comment/models/Comment.php 10.9 KB
b82db04a   Yarik   test
1
2
3
  <?php
      namespace common\modules\comment\models;
  
83b0052c   Yarik   test
4
      use common\models\User;
4ed1f788   Yarik   test
5
6
      use yii\db\ActiveQuery;
  
b82db04a   Yarik   test
7
8
      /**
       * Class Comment
2d107e9e   Yarik   test
9
10
       * @property bool    $guestComment
       * @property integer $comment_id
2fd40ee7   Yarik   test
11
12
13
14
15
16
17
18
19
20
21
       * @property string  $text
       * @property int     $user_id
       * @property string  $user_name
       * @property string  $user_email
       * @property int     $comment_pid
       * @property int     $status
       * @property string  $date_add
       * @property string  $date_update
       * @property string  $date_delete
       * @property string  $model
       * @property int     $model_id
83b0052c   Yarik   test
22
23
       * @property Rating  $rating
       * @property User    $user
b82db04a   Yarik   test
24
25
26
27
28
29
30
31
32
33
34
35
36
37
       * @package common\modules\comment\models
       */
      class Comment extends \yii\db\ActiveRecord
          implements \common\modules\comment\interfaces\CommentInterface
      {
  
          const STATUS_HIDDEN = 0;
          const STATUS_DELETED = 2;
          const STATUS_ACTIVE = 1;
          const STATUS_PERSONAL = 3;
  
          const SCENARIO_USER = 'user';
          const SCENARIO_GUEST = 'guest';
  
2d107e9e   Yarik   test
38
39
40
41
42
          /**
           * @var bool
           */
          public $guestComment = true;
  
b82db04a   Yarik   test
43
44
45
46
          public function rules()
          {
              return [
                  [
2d107e9e   Yarik   test
47
48
49
50
51
                      [
                          'text',
                          'user_name',
                          'user_email',
                      ],
b82db04a   Yarik   test
52
53
54
                      'required',
                  ],
                  [
2d107e9e   Yarik   test
55
56
57
58
59
60
61
                      [
                          'rating',
                      ],
                      'safe',
                  ],
                  [
                      [ 'user_email' ],
b82db04a   Yarik   test
62
63
64
                      'email',
                  ],
                  [
2d107e9e   Yarik   test
65
                      [ 'user_name' ],
b82db04a   Yarik   test
66
67
                      'string',
                  ],
2d107e9e   Yarik   test
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
                  [
                      [
                          'comment_id',
                          'comment_pid',
                      ],
                      'integer',
                  ],
                  [
                      [ 'status' ],
                      'default',
                      'value' => 1,
                  ],
                  [
                      [ 'comment_pid' ],
                      'exist',
                      'targetAttribute' => 'comment_id',
                      'filter'          => [
2fd40ee7   Yarik   test
85
86
                          'model'    => $this->model,
                          'model_id' => $this->model_id,
2d107e9e   Yarik   test
87
88
                      ],
                  ],
b82db04a   Yarik   test
89
90
91
92
93
94
              ];
          }
  
          public function scenarios()
          {
              return [
2d107e9e   Yarik   test
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
                  self::SCENARIO_GUEST => [
                      'user_name',
                      'user_email',
                      'text',
                      'comment_pid',
                  ],
                  self::SCENARIO_USER  => [
                      'text',
                      'comment_pid',
                  ],
              ];
          }
  
          /**
           * @inheritdoc
           */
          public function behaviors()
          {
              return [
                  [
                      'class'              => \yii\behaviors\TimestampBehavior::className(),
                      'createdAtAttribute' => 'date_add',
                      'updatedAtAttribute' => 'date_update',
                      'value'              => new \yii\db\Expression('NOW()'),
                  ],
b82db04a   Yarik   test
120
121
122
              ];
          }
  
83b0052c   Yarik   test
123
124
125
126
127
128
129
130
131
132
133
134
135
          public function afterSave($insert, $changedAttributes)
          {
              if($this->model == User::className()) {
                  if($user = User::findOne($this->model_id)) {
                      /**
                       * @var User $user
                       */
                      $user->updateRating();
                  }
              }
              parent::afterSave($insert, $changedAttributes);
          }
  
fdc1c9de   Yarik   test
136
137
138
          /**
           * @inheritdoc
           */
b82db04a   Yarik   test
139
140
141
142
143
144
145
146
147
148
149
          public static function tableName()
          {
              return '{{%comment}}';
          }
  
          /**
           * @inheritdoc
           */
          public function attributeLabels()
          {
              return [
2d107e9e   Yarik   test
150
151
                  'text'       => \Yii::t('app', 'Комментарий'),
                  'user_name'  => \Yii::t('app', 'Имя'),
b82db04a   Yarik   test
152
153
154
155
                  'user_email' => \Yii::t('app', 'Email'),
              ];
          }
  
2d107e9e   Yarik   test
156
157
158
159
160
161
          public function getGuestComment()
          {
              return $this->guestComment;
          }
  
          public function setGuestComment($value)
b82db04a   Yarik   test
162
          {
2d107e9e   Yarik   test
163
              $this->guestComment = $value;
b82db04a   Yarik   test
164
165
          }
  
4ed1f788   Yarik   test
166
          /**
2fd40ee7   Yarik   test
167
168
           * @param string  $model
           * @param integer $model_id
4ed1f788   Yarik   test
169
170
171
           *
           * @return ActiveQuery
           */
2fd40ee7   Yarik   test
172
          public function getComments($model, $model_id)
b82db04a   Yarik   test
173
          {
2d107e9e   Yarik   test
174
175
              return $this->find()
                          ->where([
2fd40ee7   Yarik   test
176
177
178
                              'comment.model'    => $model,
                              'comment.model_id' => $model_id,
                              'comment.status'   => 1,
baba04c2   Yarik   test
179
                          ])->with('rating');
b82db04a   Yarik   test
180
181
          }
  
2d107e9e   Yarik   test
182
          public function postComment()
b82db04a   Yarik   test
183
          {
2d107e9e   Yarik   test
184
185
186
187
188
189
190
              if($this->checkCreate()) {
                  if($this->insert()) {
                      $this->clearSafe();
                      return true;
                  } else {
                      return false;
                  }
b82db04a   Yarik   test
191
              } else {
2d107e9e   Yarik   test
192
                  $this->addError('comment_id', 'You can`t post comment here');
b82db04a   Yarik   test
193
194
195
196
                  return false;
              }
          }
  
2d107e9e   Yarik   test
197
          public function updateComment()
b82db04a   Yarik   test
198
          {
2d107e9e   Yarik   test
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
              if($this->checkUpdate()) {
                  if(empty( $this->comment_id )) {
                      $this->addError('comment_id', 'Comment ID not found');
                      return false;
                  } else {
                      if($this->update()) {
                          $this->clearSafe();
                          return true;
                      } else {
                          return false;
                      }
                  }
              } else {
                  $this->addError('comment_id', 'You can`t update this post');
                  return false;
              }
b82db04a   Yarik   test
215
216
          }
  
2d107e9e   Yarik   test
217
          public function deleteComment()
b82db04a   Yarik   test
218
          {
2d107e9e   Yarik   test
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
              if($this->checkDelete()) {
                  if(empty( $this->comment_id )) {
                      $this->addError('comment_id', 'Comment ID not found');
                      return false;
                  } else {
                      if($this->status == self::STATUS_DELETED) {
                          return false;
                      }
                      $this->status = self::STATUS_DELETED;
                      if($this->update()) {
                          $this->clearSafe();
                          return true;
                      } else {
                          return false;
                      }
                  }
              } else {
                  $this->addError('comment_id', 'You can`t delete this post');
                  return false;
              }
b82db04a   Yarik   test
239
240
          }
  
2d107e9e   Yarik   test
241
          public function checkCreate()
b82db04a   Yarik   test
242
          {
2d107e9e   Yarik   test
243
              if($this->getGuestComment()) {
b82db04a   Yarik   test
244
245
                  return true;
              } else {
2fd40ee7   Yarik   test
246
247
248
249
                  return \Yii::$app->user->can(\common\modules\comment\Permissions::CREATE, [
                      'model'    => $this->model,
                      'model_id' => $this->model_id,
                  ]);
b82db04a   Yarik   test
250
251
252
              }
          }
  
2d107e9e   Yarik   test
253
254
255
256
257
          public function checkUpdate()
          {
              if($this->scenario == self::SCENARIO_GUEST) {
                  return false;
              } else {
2fd40ee7   Yarik   test
258
259
260
261
262
263
264
                  return \Yii::$app->user->can(\common\modules\comment\Permissions::UPDATE, [
                      'model'    => $this->model,
                      'model_id' => $this->model_id,
                  ]) || \Yii::$app->user->can(\common\modules\comment\Permissions::UPDATE_OWN, [
                      'model'    => $this->model,
                      'model_id' => $this->model_id,
                  ]);
2d107e9e   Yarik   test
265
266
267
268
269
270
271
272
              }
          }
  
          public function checkDelete()
          {
              if($this->scenario == self::SCENARIO_GUEST) {
                  return false;
              } else {
2fd40ee7   Yarik   test
273
274
275
276
277
278
279
                  return \Yii::$app->user->can(\common\modules\comment\Permissions::DELETE, [
                      'model'    => $this->model,
                      'model_id' => $this->model_id,
                  ]) || \Yii::$app->user->can(\common\modules\comment\Permissions::DELETE_OWN, [
                      'model'    => $this->model,
                      'model_id' => $this->model_id,
                  ]);
2d107e9e   Yarik   test
280
281
282
283
284
              }
          }
  
          protected function clearSafe($setNew = true)
          {
b82db04a   Yarik   test
285
286
287
288
289
290
291
292
              $safe = $this->safeAttributes();
              $count = count($safe);
              $values = array_fill(0, $count, NULL);
              $result = array_combine($safe, $values);
              $this->setAttributes($result);
              $this->setIsNewRecord($setNew);
          }
  
2d107e9e   Yarik   test
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
          public function getParent()
          {
              return $this->hasOne(self::className(), [ 'comment_id' => 'comment_pid' ]);
          }
  
          public function getAuthor()
          {
              //            if($this->user_id != NULL) {
              return $this->hasOne(\common\models\User::className(), [ 'id' => 'user_id' ]);
              //            } else {
              //                return ['firstname' => $this->user_name, 'email' => $this->user_email];
              //            }
          }
  
          public function checkRating()
          {
2fd40ee7   Yarik   test
309
310
311
312
313
314
              $rating = $this->hasOne(\common\modules\comment\models\Rating::className(), [
                  'model_id' => 'comment_id',
              ])
                             ->andWhere([
                                 'model' => $this->className(),
                             ])
2d107e9e   Yarik   test
315
                             ->one();
47bd5ade   Yarik   test
316
              if(!$rating instanceof \common\modules\comment\models\Rating && !empty($this->primaryKey)) {
2d107e9e   Yarik   test
317
                  $rating = new \common\modules\comment\models\Rating([
2fd40ee7   Yarik   test
318
319
320
                      'model'    => $this->className(),
                      'model_id' => $this->comment_id,
                      'user_id'  => $this->user_id,
2d107e9e   Yarik   test
321
322
323
324
325
326
327
328
                  ]);
                  $rating->save();
              }
          }
  
          public function getRating()
          {
              $this->checkRating();
2fd40ee7   Yarik   test
329
330
331
332
              return $this->hasOne(\common\modules\comment\models\Rating::className(), [
                  'model_id' => 'comment_id',
              ])
                          ->andWhere([ 'model' => $this->className() ]);
2d107e9e   Yarik   test
333
334
335
336
          }
  
          public function hasRating($return = true)
          {
2fd40ee7   Yarik   test
337
338
339
340
              $rating = $this->hasOne(\common\modules\comment\models\Rating::className(), [
                  'model_id' => 'comment_id',
              ])
                             ->andWhere([ 'model' => $this->className() ])
2d107e9e   Yarik   test
341
342
343
344
345
346
347
348
349
350
351
352
                             ->andWhere([
                                 'not',
                                 [ 'value' => NULL ],
                             ])
                             ->one();
              if($return) {
                  return $rating;
              } else {
                  return $rating ? true : false;
              }
          }
  
83b0052c   Yarik   test
353
354
355
356
357
          public function getUser()
          {
              return $this->hasOne(User::className(), [ 'id' => 'user_id' ]);
          }
  
2d107e9e   Yarik   test
358
      }