3f2bc3d0
Administrator
first commit
|
1
2
3
4
5
|
<?php
namespace common\modules\product\models;
use common\behaviors\Slug;
|
e608c5f7
Yarik
Comment added
|
6
7
|
use common\models\ProductToRating;
use common\modules\comment\models\Comment;
|
96f5a822
Administrator
29.06.16
|
8
|
use common\modules\product\behaviors\FilterBehavior;
|
c7852657
Karnovsky A
-
|
9
|
use common\modules\rubrication\models\TaxGroup;
|
3f2bc3d0
Administrator
first commit
|
10
11
12
13
|
use common\modules\rubrication\models\TaxOption;
use Yii;
use common\modules\relation\relationBehavior;
use yii\db\ActiveQuery;
|
868680ca
Karnovsky A
-
|
14
|
use yii\db\ActiveRecord;
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
15
16
|
use yii\helpers\Html;
use yii\web\UploadedFile;
|
3f2bc3d0
Administrator
first commit
|
17
18
19
20
|
/**
* This is the model class for table "{{%product}}".
*
|
3f2bc3d0
Administrator
first commit
|
21
|
* @property string $name
|
3f2bc3d0
Administrator
first commit
|
22
|
* @property integer $brand_id
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
23
|
* @property integer $product_id
|
3f2bc3d0
Administrator
first commit
|
24
25
|
* @property Category $category
* @property array $categories
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
26
|
* @property array of ProductVariant $variants
|
3f2bc3d0
Administrator
first commit
|
27
|
* @property ProductVariant $variant
|
3f2bc3d0
Administrator
first commit
|
28
29
|
* @property ProductImage $image
* @property array $images
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
30
31
|
* @property boolean $is_top
* @property boolean $is_new
|
dc2cd017
Karnovsky A
-
|
32
|
* @property boolean $akciya
|
e608c5f7
Yarik
Comment added
|
33
|
* @property ProductToRating $averageRating
|
e9f291a5
Karnovsky A
Similar products ...
|
34
35
36
|
* @property array $properties
* @property ProductVariant $enabledVariant
* @property array $enabledVariants
|
3f2bc3d0
Administrator
first commit
|
37
38
39
40
41
42
43
44
|
*/
class Product extends \yii\db\ActiveRecord
{
/** @var array $_variants */
public $_variants = [];
/** @var array $_images */
public $imagesUpload = [];
|
a0be9a4d
Karnovsky A
30062016
|
45
|
|
3f2bc3d0
Administrator
first commit
|
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
/**
* @inheritdoc
*/
public function behaviors()
{
return [
[
'class' => relationBehavior::className(),
'relations' => [
'product_categories' => 'entity1', // Product category
'product_option' => 'entity1' // Product category
]
],
[
|
96f5a822
Administrator
29.06.16
|
60
61
62
|
'class' =>FilterBehavior::className(),
],
[
|
3f2bc3d0
Administrator
first commit
|
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
'class' => Slug::className(),
'in_attribute' => 'name',
'out_attribute' => 'alias',
'translit' => true
]
];
}
/**
* @inheritdoc
*/
public static function tableName()
{
return '{{%product}}';
}
/**
* @inheritdoc
*/
public function rules()
{
return [
|
067092f7
Karnovsky A
-
|
85
|
// [['categories'], 'required'],
|
3f2bc3d0
Administrator
first commit
|
86
87
88
|
[['brand_id'], 'integer'],
[['name'], 'string', 'max' => 150],
[['alias'], 'string', 'max' => 250],
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
89
|
[['categories', 'variants', 'options', 'imagesUpload'], 'safe'],
|
dc2cd017
Karnovsky A
-
|
90
|
// [['imagesUpload'], 'file', 'skipOnEmpty' => false, 'extensions' => 'png, jpg, gif', 'maxFiles' => 50],
|
3f2bc3d0
Administrator
first commit
|
91
|
[['description', 'video'], 'safe'],
|
dc2cd017
Karnovsky A
-
|
92
|
[['is_top', 'is_new', 'akciya'], 'boolean'],
|
3f2bc3d0
Administrator
first commit
|
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
// [['product_id'], 'exist', 'skipOnError' => true, 'targetClass' => Product::className(), 'targetAttribute' => ['product_id' => 'product_id']],
];
}
/**
* @inheritdoc
*/
public function attributeLabels()
{
return [
'product_id' => Yii::t('product', 'ID'),
'name' => Yii::t('product', 'Name'),
'brand_id' => Yii::t('product', 'Brand'),
'categories' => Yii::t('product', 'Categories'), // relation behavior field
'category' => Yii::t('product', 'Category'), // relation behavior field
'image' => Yii::t('product', 'Image'),
'images' => Yii::t('product', 'Images'),
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
110
111
112
113
114
|
'description' => Yii::t('product', 'Description'),
'video' => Yii::t('product', 'Video embeded'),
'variants' => Yii::t('product', 'Variants'),
'is_top' => Yii::t('product', 'Is top'),
'is_new' => Yii::t('product', 'Is new'),
|
dc2cd017
Karnovsky A
-
|
115
|
'akciya' => Yii::t('product', 'Is promo'),
|
3f2bc3d0
Administrator
first commit
|
116
117
118
|
];
}
|
02e6c2ba
Karnovsky A
-
|
119
120
121
122
|
public function getUrl() {
return '/product/'. $this->alias;
}
|
3f2bc3d0
Administrator
first commit
|
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
|
/**
* @return \yii\db\ActiveQuery
*/
public function getBrand()
{
return $this->hasOne(Brand::className(), ['brand_id' => 'brand_id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getImage()
{
return $this->hasOne(ProductImage::className(), ['product_id' => 'product_id']);
}
/**
|
dc2cd017
Karnovsky A
-
|
140
141
142
143
144
|
* fetch stored image url
* @return string
*/
public function getImageUrl()
{
|
4902c747
Karnovsky A
-
|
145
146
|
$image = empty($this->variant) ? null : $this->variant->image;
return !empty($image) ? $image->imageUrl : '/images/no_photo.png';
|
dc2cd017
Karnovsky A
-
|
147
148
149
|
}
/**
|
3f2bc3d0
Administrator
first commit
|
150
151
152
153
|
* @return \yii\db\ActiveQuery
*/
public function getImages()
{
|
1e55b4b8
Karnovsky A
-
|
154
|
return $this->hasMany(ProductImage::className(), ['product_id' => 'product_id'])->where(['product_variant_id' => null]);
|
3f2bc3d0
Administrator
first commit
|
155
156
|
}
|
3f2bc3d0
Administrator
first commit
|
157
158
159
160
161
|
/**
* @return \yii\db\ActiveQuery
*/
public function getVariant()
{
|
0a93b48a
Karnovsky A
-
|
162
|
return $this->hasOne(ProductVariant::className(), ['product_id' => 'product_id']);
|
3f2bc3d0
Administrator
first commit
|
163
164
|
}
|
d48d8bc0
Karnovsky A
-
|
165
166
167
168
169
170
171
|
/**
* @return \yii\db\ActiveQuery
*/
public function getEnabledVariant()
{
return $this->hasOne(ProductVariant::className(), ['product_id' => 'product_id'])->andOnCondition(['!=', ProductVariant::tableName() .'.stock', 0]);
}
|
e9f291a5
Karnovsky A
Similar products ...
|
172
|
|
3f2bc3d0
Administrator
first commit
|
173
174
175
|
public function getVariantPrice() {
return $this->variant->price;
}
|
1e55b4b8
Karnovsky A
-
|
176
|
|
d48d8bc0
Karnovsky A
-
|
177
|
public function getEnabledVariantPrice() {
|
c7852657
Karnovsky A
-
|
178
|
return $this->enabledVariants[0]->price;
|
d48d8bc0
Karnovsky A
-
|
179
180
|
}
|
3f2bc3d0
Administrator
first commit
|
181
182
183
184
185
|
/**
* @return \yii\db\ActiveQuery
*/
public function getVariants()
{
|
0a93b48a
Karnovsky A
-
|
186
|
return $this->hasMany(ProductVariant::className(), ['product_id' => 'product_id']);
|
3f2bc3d0
Administrator
first commit
|
187
188
|
}
|
1e55b4b8
Karnovsky A
-
|
189
190
|
public function getEnabledVariants()
{
|
1b898c16
Administrator
20.07.16
|
191
|
return $this->hasMany(ProductVariant::className(), ['product_id' => 'product_id'])->andOnCondition(['!=', ProductVariant::tableName() .'.stock', 0])->joinWith('image');
|
1e55b4b8
Karnovsky A
-
|
192
193
|
}
|
c7852657
Karnovsky A
-
|
194
195
196
197
198
199
200
|
/*
* Get variants grouped by type
*/
public function getEnabledVariantsGrouped()
{
$variants = [];
foreach ($this->enabledVariants as $variant) {
|
a57c9f4d
Karnovsky A
-
|
201
|
$variants[$variant->product_variant_type_id ? $variant->product_variant_type_id : 1][] = $variant;
|
c7852657
Karnovsky A
-
|
202
203
204
205
|
}
if (empty($variants)) {
return [];
}
|
a57c9f4d
Karnovsky A
-
|
206
|
$ids = array_keys($variants);
|
c7852657
Karnovsky A
-
|
207
|
$variants_type = [];
|
a57c9f4d
Karnovsky A
-
|
208
|
foreach(ProductVariantType::find()->select(['product_variant_type_id', 'name2'])->where(['product_variant_type_id' => $ids])->all() as $variant_type) {
|
c7852657
Karnovsky A
-
|
209
210
211
212
213
214
|
$variant_type->_variants = $variants[$variant_type->product_variant_type_id];
$variants_type[] = $variant_type;
}
return $variants_type;
}
|
3f2bc3d0
Administrator
first commit
|
215
216
217
218
219
220
221
222
223
224
|
public function setVariants($variants) {
$this->_variants = $variants;
}
public function getFullName()
{
return empty($this->brand) ? $this->name : $this->brand->name .' '. $this->name;
}
public function getCategories() {
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
225
226
|
return $this->hasMany(Category::className(), ['category_id' => 'category_id'])->viaTable('product_category', ['product_id' => 'product_id']);
// return $this->getRelations('product_categories');
|
3f2bc3d0
Administrator
first commit
|
227
|
}
|
96f5a822
Administrator
29.06.16
|
228
229
230
231
|
public function getCategoriesWithName() {
return $this->hasMany(Category::className(), ['category_id' => 'category_id'])->viaTable('product_category', ['product_id' => 'product_id'])->joinWith('categoryNames');
// return $this->getRelations('product_categories');
}
|
3f2bc3d0
Administrator
first commit
|
232
233
234
235
236
237
238
239
240
|
public function getCategoriesNames() {
$result = [];
foreach($this->categories as $category) {
$result[] = $category->name;
}
return $result;
}
|
96f5a822
Administrator
29.06.16
|
241
242
243
244
|
public function getVariantsWithFilters(){
return $this->hasMany(ProductVariant::className(), ['product_id' => 'product_id'])->with('filters');
}
|
3f2bc3d0
Administrator
first commit
|
245
|
public function getCategory() {
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
246
|
return $this->hasOne(Category::className(), ['category_id' => 'category_id'])->viaTable('product_category', ['product_id' => 'product_id']);
|
3f2bc3d0
Administrator
first commit
|
247
248
249
|
}
public function getOptions() {
|
c7852657
Karnovsky A
-
|
250
|
return $this->hasMany(TaxOption::className(), ['tax_option_id' => 'option_id'])->viaTable('product_option', ['product_id' => 'product_id']);
|
1aafb42d
Karnovsky A
-
|
251
252
253
254
255
256
257
258
259
260
261
262
263
264
|
}
public function getProperties() {
$groups = $options = [];
foreach ($this->options as $option) {
$options[$option->tax_group_id][] = $option;
}
foreach (TaxGroup::find()->where(['tax_group_id' => array_keys($options)])->all() as $group) {
if (!empty($options[$group->tax_group_id])) {
$group->_options = $options[$group->tax_group_id];
$groups[] = $group;
}
}
return $groups;
|
3f2bc3d0
Administrator
first commit
|
265
266
|
}
|
5ee9ab1f
Karnovsky A
-
|
267
268
269
270
|
public function getStocks() {
return $this->hasMany(Stock::className(), ['stock_id' => 'stock_id'])->viaTable(ProductStock::tableName(), ['product_id' => 'product_id']);
}
|
3f2bc3d0
Administrator
first commit
|
271
272
273
274
275
276
277
278
279
|
/**
* @inheritdoc
* @return ProductQuery the active query used by this AR class.
*/
public static function find()
{
return new ProductQuery(get_called_class());
}
|
1e55b4b8
Karnovsky A
-
|
280
281
282
283
284
285
|
public function getQuantity() {
return ProductStock::find()
->where(['product_id' => $this->product_id])
->sum('quantity');
}
|
3f2bc3d0
Administrator
first commit
|
286
287
288
289
|
public function afterSave($insert, $changedAttributes)
{
parent::afterSave($insert, $changedAttributes);
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
290
291
292
293
294
295
296
297
298
299
300
301
|
// $images = UploadedFile::getInstance($this, 'imagesUpload');
// var_dump($images);exit;
// if (!empty($this->imagesUpload)) {
// if (!is_array($this->imagesUpload)) {
// $this->imagesUpload = [$this->imagesUpload];
// }
// foreach($this->imagesUpload as $image) {
// $image->saveAs((Yii::getAlias('@frontend/web/storage/products/original/' . $image->baseName .'_'. uniqid() . '.' . $image->extension)));
// }
//
//
|
3f2bc3d0
Administrator
first commit
|
302
303
|
// }
|
4902c747
Karnovsky A
-
|
304
305
306
307
|
if (!empty($this->_variants)) {
$todel = [];
foreach ($this->variants ?: [] as $_variant) {
$todel[$_variant->product_variant_id] = $_variant->product_variant_id;
|
3f2bc3d0
Administrator
first commit
|
308
|
}
|
4902c747
Karnovsky A
-
|
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
|
foreach ($this->_variants as $_variant) {
if (!is_array($_variant)) {
return;
}
if (!empty($_variant['product_variant_id'])) {
unset($todel[$_variant['product_variant_id']]);
$model = ProductVariant::findOne($_variant['product_variant_id']);
} else {
$model = new ProductVariant();
}
$_variant['product_id'] = $this->product_id;
$model->load(['ProductVariant' => $_variant]);
$model->product_id = $this->product_id;
$model->save();
}
if (!empty($todel)) {
ProductVariant::deleteAll(['product_variant_id' => $todel]);
|
3f2bc3d0
Administrator
first commit
|
326
|
}
|
c9d723d7
Karnovsky A
-
|
327
|
}
|
3f2bc3d0
Administrator
first commit
|
328
|
}
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
329
|
|
868680ca
Karnovsky A
-
|
330
331
332
333
334
335
|
public function beforeDelete() {
ProductImage::deleteAll(['product_id' => $this->product_id]);
ProductCategory::deleteAll(['product_id' => $this->product_id]);
ProductVariant::deleteAll(['product_id' => $this->product_id]);
}
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
336
337
338
339
340
341
342
|
public function imagesUpload()
{
if ($this->validate()) {
$images = [];
foreach ($this->imagesUpload as $image) {
$imageName = $image->baseName .'.'. $image->extension;
$i = 0;
|
83be3cfb
Karnovsky A
-
|
343
|
while(file_exists(Yii::getAlias('@imagesDir/products/' . $imageName))) {
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
344
345
346
347
|
$i++;
$imageName = $image->baseName .'_'. $i .'.'. $image->extension;
}
|
83be3cfb
Karnovsky A
-
|
348
|
$image->saveAs(Yii::getAlias('@imagesDir/products/' .$imageName));
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
349
350
351
352
353
354
355
356
357
358
359
360
|
$images[] = $imageName;
}
return $images;
} else {
return false;
}
}
public function getImagesHTML() {
$op = [];
if ($this->images) {
foreach ($this->images as $image) {
|
83be3cfb
Karnovsky A
-
|
361
|
$op[] = \common\components\artboximage\ArtboxImageHelper::getImage($image->imageUrl, 'admin_thumb');
|
ccc7a9d3
Karnovsky A
Karnovsky 12052016
|
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
|
}
}
return $op;
}
public function getImagesConfig() {
$op = [];
if ($this->images) {
foreach ($this->images as $image) {
$op[] = [
'caption' => $image->image,
'width' => '120px',
'url' => \yii\helpers\Url::to(['/product/manage/delimg', 'id' => $image->product_image_id]),
'key' => $image->product_image_id,
'extra' => [
'id' => $image->product_image_id,
],
];
}
}
return $op;
}
|
e608c5f7
Yarik
Comment added
|
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
|
public function recalculateRating() {
/**
* @var ProductToRating $averageRating
*/
$average = $this->getComments()->joinWith('rating')->select(['average' => 'avg(rating.value)::float'])->scalar();
if(!$average) {
$average = 0;
}
$averageRating = $this->averageRating;
if(!empty($averageRating)) {
$averageRating->value = $average;
} else {
$averageRating = new ProductToRating(['product_id' => $this->product_id, 'value' => $average]);
}
if($averageRating->save()) {
return true;
} else {
return false;
}
}
public function getComments() {
return $this->hasMany(Comment::className(), ['model_id' => 'product_id'])->where(['comment.model' => self::className()]);
}
public function getAverageRating() {
return $this->hasOne(ProductToRating::className(), ['product_id' => 'product_id']);
}
|
3f2bc3d0
Administrator
first commit
|
413
|
}
|