84ebac3d
 Yarik
test
|
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
|
<?php
namespace common\models;
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
*/
class Project extends \yii\db\ActiveRecord
{
/**
* @inheritdoc
*/
public static function tableName()
{
return 'project';
}
|
|
84ebac3d
Yarik
test
|
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
/**
* @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
|
61
62
63
64
65
66
|
'slug' => [
'class' => 'common\behaviors\Slug',
'in_attribute' => 'name',
'out_attribute' => 'link',
'translit' => true
]
|
|
84ebac3d
Yarik
test
|
67
68
69
70
71
72
73
74
75
76
|
];
}
/**
* @inheritdoc
*/
public function rules()
{
return [
[
|
|
420d3dcd
Yarik
test
|
77
|
[ 'name', 'link' ],
|
|
84ebac3d
Yarik
test
|
78
79
80
81
|
'required',
],
[
[
|
|
84ebac3d
Yarik
test
|
82
83
84
|
'project_pid',
'payment_variant',
'contractual',
|
|
420d3dcd
Yarik
test
|
85
|
'budget_currency',
|
|
84ebac3d
Yarik
test
|
86
87
88
89
90
91
92
93
94
|
],
'integer',
],
[
[ 'description' ],
'string',
],
[
[
|
|
aa182b5c
Yarik
test
|
95
96
97
98
99
100
101
|
'specializationInput',
'paymentInput',
],
'safe',
],
[
[
|
|
84ebac3d
Yarik
test
|
102
103
104
105
106
107
108
109
110
111
|
'name',
'link',
'budget',
'city',
'street',
'house',
],
'string',
'max' => 255,
],
|
|
989c83b0
Yarik
test
|
112
113
114
115
116
|
[
[ 'view_count' ],
'default',
'value' => 0,
],
|
|
a02e2fdb
Yarik
test
|
117
118
119
120
121
122
123
124
|
[
[
'paymentInput',
'specializationInput',
],
'default',
'value' => [ ],
],
|
|
d02fd466
Yarik
test
|
125
|
[
|
|
4c9663e0
Yarik
test
|
126
|
[ 'deadline' ],
|
|
d02fd466
Yarik
test
|
127
128
129
130
|
'integer',
'min' => 1,
],
[
|
|
4c9663e0
Yarik
test
|
131
|
[ 'deadline' ],
|
|
d02fd466
Yarik
test
|
132
133
134
|
'default',
'value' => 1,
],
|
|
84ebac3d
Yarik
test
|
135
136
137
138
139
140
141
142
143
|
];
}
/**
* @inheritdoc
*/
public function attributeLabels()
{
return [
|
|
a02e2fdb
Yarik
test
|
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
|
'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
|
164
|
'specializationString' => Yii::t('app', 'Специализации'),
|
|
84ebac3d
Yarik
test
|
165
166
167
168
169
170
171
172
173
174
175
176
177
178
|
];
}
/**
* @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
|
179
|
->viaTable('project_payment', [ 'project_id' => 'project_id' ]);
|
|
84ebac3d
Yarik
test
|
180
181
|
}
|
|
7e6d3f52
Administrator
24.02.16
|
182
183
184
185
|
/**
* @return \yii\db\ActiveQuery
*/
|
|
3dc20ff7
Administrator
24.02.16
|
186
|
public function getUser()
|
|
7e6d3f52
Administrator
24.02.16
|
187
188
189
190
|
{
return $this->hasOne(User::className(), [ 'id' => 'user_id' ]);
}
|
|
83cba62c
Administrator
24.02.16
|
191
192
193
194
195
196
197
198
199
|
/**
* @return \yii\db\ActiveQuery
*/
public function getParent()
{
return $this->hasOne(self::className(), [ 'project_id' => 'project_pid' ]);
}
|
|
6daaaafa
Administrator
24.02.16
|
200
201
202
203
204
205
|
public function getBudgetCurrency()
{
return $this->hasOne(Currency::className(), [ 'currency_id' => 'budget_currency' ]);
}
|
|
84ebac3d
Yarik
test
|
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
|
/**
* @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
|
224
|
->indexBy('specialization_id')
|
|
84ebac3d
Yarik
test
|
225
226
227
|
->column();
}
|
|
aa182b5c
Yarik
test
|
228
229
|
public function setSpecializationInput($value)
{
|
|
84ebac3d
Yarik
test
|
230
231
232
233
234
235
236
237
238
239
|
$this->specializationInput = $value;
}
public function getPaymentInput()
{
return $this->getPayments()
->asArray()
->column();
}
|
|
aa182b5c
Yarik
test
|
240
241
|
public function setPaymentInput($value)
{
|
|
84ebac3d
Yarik
test
|
242
243
|
$this->paymentInput = $value;
}
|
|
989c83b0
Yarik
test
|
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
|
public function getSpecializationString()
{
return implode(', ', $this->getSpecializations()
->select([
'specialization_name',
'specialization_id',
])
->asArray()
->indexBy('specialization_id')
->column());
}
public function setSpecializationString($value)
{
$this->specializationString = $value;
}
|
|
84ebac3d
Yarik
test
|
261
|
}
|
