Administrator / test_3

Blame view

common/models/Project.php 11.2 KB
Edit Raw Normal View History
84ebac3d   Yarik   test 
1
2
3
4
 
  <?php
  
      namespace common\models;
3c618303   Yarik   test 
5
 
      use common\modules\comment\models\CommentProject;
84ebac3d   Yarik   test 
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
 
      use Yii;
      use yii\behaviors\BlameableBehavior;
      use yii\behaviors\TimestampBehavior;
      use yii\db\Expression;
  
      /**
       * This is the model class for table "project".
       * @property integer                 $project_id
       * @property integer                 $user_id
       * @property string                  $name
       * @property string                  $link
       * @property integer                 $project_pid
       * @property string                  $date_add
       * @property string                  $date_end
       * @property integer                 $user_add_id
       * @property double                  $view_count
       * @property string                  $budget
       * @property string                  $city
       * @property string                  $street
       * @property string                  $house
       * @property integer                 $payment_variant
       * @property integer                 $deadline
       * @property string                  $description
       * @property integer                 $contractual
       * @property ProjectPayment[]        $projectPayments
       * @property ProjectSpecialization[] $projectSpecializations
       * @property Specialization[]        $specializations
32ed90fd   Yarik   test 
33
 
       * @property Currency                $budgetCurrency
50ed5626   Yarik   test 
34
 
       * @property Project                 $parent
492ed7f7   Yarik   test 
35
 
       * @property int                     $hidden
84ebac3d   Yarik   test 
36
37
38
39
 
       */
      class Project extends \yii\db\ActiveRecord
      {
83b0052c   Yarik   test 
40
 
          public $files;
cc4e7c12   Yarik   test 
41
84ebac3d   Yarik   test 
42
43
44
45
46
47
48
49
 
          /**
           * @inheritdoc
           */
          public static function tableName()
          {
              return 'project';
          }
84ebac3d   Yarik   test 
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
 
          /**
           * @inheritdoc
           */
          public function behaviors()
          {
              return [
                  [
                      'class'              => BlameableBehavior::className(),
                      'createdByAttribute' => 'user_id',
                      'updatedByAttribute' => false,
                  ],
                  [
                      'class'              => TimestampBehavior::className(),
                      'createdAtAttribute' => 'date_add',
                      'updatedAtAttribute' => false,
                      'value'              => new Expression('NOW()'),
                  ],
9fd076e8   Administrator   01.03.16 
67
 
                  'slug' => [
cc4e7c12   Yarik   test 
68
69
 
                      'class'         => 'common\behaviors\Slug',
                      'in_attribute'  => 'name',
9fd076e8   Administrator   01.03.16 
70
 
                      'out_attribute' => 'link',
3c618303   Yarik   test 
71
72
 
                      'translit'      => true,
                  ],
84ebac3d   Yarik   test 
73
74
75
76
77
78
79
80
81
82
 
              ];
          }
  
          /**
           * @inheritdoc
           */
          public function rules()
          {
              return [
                  [
cc4e7c12   Yarik   test 
83
84
 
                      [
                          'name',
3c618303   Yarik   test 
85
 
                          'link',
cc4e7c12   Yarik   test 
86
 
                      ],
84ebac3d   Yarik   test 
87
88
89
90
 
                      'required',
                  ],
                  [
                      [
84ebac3d   Yarik   test 
91
92
93
 
                          'project_pid',
                          'payment_variant',
                          'contractual',
420d3dcd   Yarik   test 
94
 
                          'budget_currency',
84ebac3d   Yarik   test 
95
96
97
98
99
100
101
102
103
 
                      ],
                      'integer',
                  ],
                  [
                      [ 'description' ],
                      'string',
                  ],
                  [
                      [
aa182b5c   Yarik   test 
104
105
 
                          'specializationInput',
                          'paymentInput',
83b0052c   Yarik   test 
106
 
                          'files',
aa182b5c   Yarik   test 
107
108
109
110
111
 
                      ],
                      'safe',
                  ],
                  [
                      [
84ebac3d   Yarik   test 
112
113
114
115
116
117
118
119
120
121
 
                          'name',
                          'link',
                          'budget',
                          'city',
                          'street',
                          'house',
                      ],
                      'string',
                      'max' => 255,
                  ],
989c83b0   Yarik   test 
122
123
124
125
126
 
                  [
                      [ 'view_count' ],
                      'default',
                      'value' => 0,
                  ],
a02e2fdb   Yarik   test 
127
128
129
130
131
132
133
134
 
                  [
                      [
                          'paymentInput',
                          'specializationInput',
                      ],
                      'default',
                      'value' => [ ],
                  ],
d02fd466   Yarik   test 
135
 
                  [
4c9663e0   Yarik   test 
136
 
                      [ 'deadline' ],
d02fd466   Yarik   test 
137
138
139
140
 
                      'integer',
                      'min' => 1,
                  ],
                  [
492ed7f7   Yarik   test 
141
142
143
 
                      [
                          'deadline',
                      ],
d02fd466   Yarik   test 
144
145
146
 
                      'default',
                      'value' => 1,
                  ],
492ed7f7   Yarik   test 
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
 
                  [
                      [ 'date_end' ],
                      'default',
                      'value' => date('Y-m-d H:i:s'),
                  ],
                  [
                      [ 'hidden' ],
                      'boolean',
                  ],
                  [
                      ['hidden'],
                      'default',
                      'value' => 0,
                  ],
                  [
                      ['date_end'],
                      'filter',
                      'filter' => function($value) {
                          $unix = strtotime($value);
                          if($unix <= time()) {
                              $unix = time() + (3600 * 24 * 7);
                          }
                          return date('Y-m-d', $unix);
                      }
                  ]
84ebac3d   Yarik   test 
172
173
174
175
176
177
178
179
180
 
              ];
          }
  
          /**
           * @inheritdoc
           */
          public function attributeLabels()
          {
              return [
a02e2fdb   Yarik   test 
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
 
                  'project_id'           => Yii::t('app', 'Project ID'),
                  'user_id'              => Yii::t('app', 'User ID'),
                  'name'                 => Yii::t('app', 'Название'),
                  'link'                 => Yii::t('app', 'URL'),
                  'project_pid'          => Yii::t('app', 'Родительский проект'),
                  'date_add'             => Yii::t('app', 'Дата добавления'),
                  'date_end'             => Yii::t('app', 'Дата окончания'),
                  'user_add_id'          => Yii::t('app', 'User Add ID'),
                  'view_count'           => Yii::t('app', 'Количество просмотров'),
                  'budget'               => Yii::t('app', 'Бюджет'),
                  'city'                 => Yii::t('app', 'Город'),
                  'street'               => Yii::t('app', 'Улица'),
                  'house'                => Yii::t('app', 'Дом'),
                  'payment_variant'      => Yii::t('app', 'Варианты оплаты'),
                  'deadline'             => Yii::t('app', 'Срок выполнения'),
                  'description'          => Yii::t('app', 'Описание'),
                  'contractual'          => Yii::t('app', 'Договорной'),
                  'file'                 => Yii::t('app', 'Присоединить файл'),
                  'specializationInput'  => Yii::t('app', 'Специализации'),
                  'paymentInput'         => Yii::t('app', 'Способ оплаты'),
989c83b0   Yarik   test 
201
 
                  'specializationString' => Yii::t('app', 'Специализации'),
492ed7f7   Yarik   test 
202
 
                  'hidden'               => Yii::t('app', 'Снять проект с тендера'),
84ebac3d   Yarik   test 
203
204
205
206
207
208
209
210
211
212
213
214
215
216
 
              ];
          }
  
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getProjectPayments()
          {
              return $this->hasMany(ProjectPayment::className(), [ 'project_id' => 'project_id' ]);
          }
  
          public function getPayments()
          {
              return $this->hasMany(Payment::className(), [ 'payment_id' => 'payment_id' ])
aa182b5c   Yarik   test 
217
 
                          ->viaTable('project_payment', [ 'project_id' => 'project_id' ]);
84ebac3d   Yarik   test 
218
219
 
          }
7e6d3f52   Administrator   24.02.16 
220
221
222
 
          /**
           * @return \yii\db\ActiveQuery
           */
3dc20ff7   Administrator   24.02.16 
223
 
          public function getUser()
7e6d3f52   Administrator   24.02.16 
224
225
226
227
 
          {
              return $this->hasOne(User::className(), [ 'id' => 'user_id' ]);
          }
83cba62c   Administrator   24.02.16 
228
229
230
231
232
233
234
235
 
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getParent()
          {
              return $this->hasOne(self::className(), [ 'project_id' => 'project_pid' ]);
          }
6daaaafa   Administrator   24.02.16 
236
237
238
239
240
 
          public function getBudgetCurrency()
          {
              return $this->hasOne(Currency::className(), [ 'currency_id' => 'budget_currency' ]);
          }
84ebac3d   Yarik   test 
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
 
          /**
           * @return \yii\db\ActiveQuery
           */
          public function getProjectSpecializations()
          {
              return $this->hasMany(ProjectSpecialization::className(), [ 'project_id' => 'project_id' ]);
          }
  
          public function getSpecializations()
          {
              return $this->hasMany(Specialization::className(), [ 'specialization_id' => 'specialization_id' ])
                          ->viaTable('project_specialization', [ 'project_id' => 'project_id' ]);
          }
  
          public function getSpecializationInput()
          {
              return $this->getSpecializations()
                          ->asArray()
4c9663e0   Yarik   test 
259
 
                          ->indexBy('specialization_id')
84ebac3d   Yarik   test 
260
261
262
 
                          ->column();
          }
aa182b5c   Yarik   test 
263
264
 
          public function setSpecializationInput($value)
          {
84ebac3d   Yarik   test 
265
266
267
268
269
270
271
272
273
274
 
              $this->specializationInput = $value;
          }
  
          public function getPaymentInput()
          {
              return $this->getPayments()
                          ->asArray()
                          ->column();
          }
aa182b5c   Yarik   test 
275
276
 
          public function setPaymentInput($value)
          {
84ebac3d   Yarik   test 
277
278
 
              $this->paymentInput = $value;
          }
989c83b0   Yarik   test 
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
 
  
          public function getSpecializationString()
          {
              return implode(', ', $this->getSpecializations()
                                        ->select([
                                            'specialization_name',
                                            'specialization_id',
                                        ])
                                        ->asArray()
                                        ->indexBy('specialization_id')
                                        ->column());
          }
  
          public function setSpecializationString($value)
          {
              $this->specializationString = $value;
          }
83b0052c   Yarik   test 
296
297
298
299
300
301
302
303
304
305
306
307
308
 
  
          /**
           * @return File[]
           */
          public function getFilesList()
          {
              $files = json_decode($this->files);
              if(!empty( $files )) {
                  return File::findAll($files);
              } else {
                  return [ ];
              }
          }
cc4e7c12   Yarik   test 
309
310
311
 
  
          public function getIsBookmarked()
          {
3c618303   Yarik   test 
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
 
              $type = Bookmark::TYPE_PROJECT;
              if(!empty( \Yii::$app->user->identity )) {
                  if(!empty( $this->hasOne(Bookmark::className(), [ 'model_id' => 'project_id' ])
                                  ->andWhere([
                                      'model'   => $this->className(),
                                      'user_id' => \Yii::$app->user->getId(),
                                      'type'    => $type,
                                  ])
                                  ->one() )
                  ) {
                      return true;
                  } else {
                      return false;
                  }
              } else {
                  return false;
              }
          }
  
          public function getComments()
          {
              return $this->hasMany(CommentProject::className(), [ 'model_id' => 'project_id' ])
                          ->andWhere([ 'model' => $this->className() ]);
cc4e7c12   Yarik   test 
335
 
          }
84ebac3d   Yarik   test 
336
 
      }