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
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
|
<?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';
}
/**
* @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()'),
],
];
}
/**
* @inheritdoc
*/
public function rules()
{
return [
[
|
|
420d3dcd
Yarik
test
|
71
|
[ 'name', 'link' ],
|
|
84ebac3d
Yarik
test
|
72
73
74
75
|
'required',
],
[
[
|
|
84ebac3d
Yarik
test
|
76
77
78
|
'project_pid',
'payment_variant',
'contractual',
|
|
420d3dcd
Yarik
test
|
79
|
'budget_currency',
|
|
84ebac3d
Yarik
test
|
80
81
82
83
84
85
86
87
88
|
],
'integer',
],
[
[ 'description' ],
'string',
],
[
[
|
|
aa182b5c
Yarik
test
|
89
90
91
92
93
94
95
|
'specializationInput',
'paymentInput',
],
'safe',
],
[
[
|
|
84ebac3d
Yarik
test
|
96
97
98
99
100
101
102
103
104
105
|
'name',
'link',
'budget',
'city',
'street',
'house',
],
'string',
'max' => 255,
],
|
|
989c83b0
Yarik
test
|
106
107
108
109
110
|
[
[ 'view_count' ],
'default',
'value' => 0,
],
|
|
a02e2fdb
Yarik
test
|
111
112
113
114
115
116
117
118
|
[
[
'paymentInput',
'specializationInput',
],
'default',
'value' => [ ],
],
|
|
d02fd466
Yarik
test
|
119
|
[
|
|
4c9663e0
Yarik
test
|
120
|
[ 'deadline' ],
|
|
d02fd466
Yarik
test
|
121
122
123
124
|
'integer',
'min' => 1,
],
[
|
|
4c9663e0
Yarik
test
|
125
|
[ 'deadline' ],
|
|
d02fd466
Yarik
test
|
126
127
128
|
'default',
'value' => 1,
],
|
|
84ebac3d
Yarik
test
|
129
130
131
132
133
134
135
136
137
|
];
}
/**
* @inheritdoc
*/
public function attributeLabels()
{
return [
|
|
a02e2fdb
Yarik
test
|
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
|
'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
|
158
|
'specializationString' => Yii::t('app', 'Специализации'),
|
|
84ebac3d
Yarik
test
|
159
160
161
162
163
164
165
166
167
168
169
170
171
172
|
];
}
/**
* @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
|
173
|
->viaTable('project_payment', [ 'project_id' => 'project_id' ]);
|
|
84ebac3d
Yarik
test
|
174
175
|
}
|
6daaaafa
 Administrator
24.02.16
|
176
177
178
179
180
181
|
public function getBudgetCurrency()
{
return $this->hasOne(Currency::className(), [ 'currency_id' => 'budget_currency' ]);
}
|
|
84ebac3d
Yarik
test
|
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
|
/**
* @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
|
200
|
->indexBy('specialization_id')
|
|
84ebac3d
Yarik
test
|
201
202
203
|
->column();
}
|
|
aa182b5c
Yarik
test
|
204
205
|
public function setSpecializationInput($value)
{
|
|
84ebac3d
Yarik
test
|
206
207
208
209
210
211
212
213
214
215
|
$this->specializationInput = $value;
}
public function getPaymentInput()
{
return $this->getPayments()
->asArray()
->column();
}
|
|
aa182b5c
Yarik
test
|
216
217
|
public function setPaymentInput($value)
{
|
|
84ebac3d
Yarik
test
|
218
219
|
$this->paymentInput = $value;
}
|
|
989c83b0
Yarik
test
|
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
|
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
|
237
|
}
|
