Blame view

common/modules/product/models/Product.php 10.1 KB
3f2bc3d0   Administrator   first commit
1
2
3
4
5
6
7
8
9
  <?php

  

  namespace common\modules\product\models;

  

  use common\behaviors\Slug;

  use common\modules\rubrication\models\TaxOption;

  use Yii;

  use common\modules\relation\relationBehavior;

  use yii\db\ActiveQuery;

868680ca   Karnovsky A   -
10
  use yii\db\ActiveRecord;

ccc7a9d3   Karnovsky A   Karnovsky 12052016
11
12
  use yii\helpers\Html;

  use yii\web\UploadedFile;

3f2bc3d0   Administrator   first commit
13
14
15
16
  

  /**

   * This is the model class for table "{{%product}}".

   *

3f2bc3d0   Administrator   first commit
17
   * @property string $name

3f2bc3d0   Administrator   first commit
18
   * @property integer $brand_id

ccc7a9d3   Karnovsky A   Karnovsky 12052016
19
   * @property integer $product_id

3f2bc3d0   Administrator   first commit
20
21
   * @property Category $category

   * @property array $categories

ccc7a9d3   Karnovsky A   Karnovsky 12052016
22
   * @property array of ProductVariant $variants

3f2bc3d0   Administrator   first commit
23
   * @property ProductVariant $variant

3f2bc3d0   Administrator   first commit
24
25
   * @property ProductImage $image

   * @property array $images

ccc7a9d3   Karnovsky A   Karnovsky 12052016
26
27
   * @property boolean $is_top

   * @property boolean $is_new

dc2cd017   Karnovsky A   -
28
   * @property boolean $akciya

3f2bc3d0   Administrator   first commit
29
30
31
32
33
34
35
36
   */

  class Product extends \yii\db\ActiveRecord

  {

      /** @var array $_variants */

      public $_variants = [];

  

      /** @var array $_images */

      public $imagesUpload = [];

83be3cfb   Karnovsky A   -
37
      public $variantImagesUpload = [];

3f2bc3d0   Administrator   first commit
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
71
72
73
      /**

       * @inheritdoc

       */

      public function behaviors()

      {

          return [

              [

                  'class' => relationBehavior::className(),

                  'relations' => [

                      'product_categories' => 'entity1', // Product category

                      'product_option' => 'entity1' // Product category

                  ]

              ],

              [

                  '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   -
74
  //            [['categories'], 'required'],

3f2bc3d0   Administrator   first commit
75
76
77
              [['brand_id'], 'integer'],

              [['name'], 'string', 'max' => 150],

              [['alias'], 'string', 'max' => 250],

ccc7a9d3   Karnovsky A   Karnovsky 12052016
78
              [['categories', 'variants', 'options', 'imagesUpload'], 'safe'],

dc2cd017   Karnovsky A   -
79
  //            [['imagesUpload'], 'file', 'skipOnEmpty' => false, 'extensions' => 'png, jpg, gif', 'maxFiles' => 50],

3f2bc3d0   Administrator   first commit
80
              [['description', 'video'], 'safe'],

dc2cd017   Karnovsky A   -
81
              [['is_top', 'is_new', 'akciya'], 'boolean'],

3f2bc3d0   Administrator   first commit
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
  //            [['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
99
100
101
102
103
              '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   -
104
              'akciya' => Yii::t('product', 'Is promo'),

3f2bc3d0   Administrator   first commit
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
          ];

      }

  

      /**

       * @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   -
125
126
127
128
129
       * fetch stored image url

       * @return string

       */

      public function getImageUrl()

      {

4902c747   Karnovsky A   -
130
131
          $image = empty($this->variant) ? null : $this->variant->image;

          return !empty($image) ? $image->imageUrl : '/images/no_photo.png';

dc2cd017   Karnovsky A   -
132
133
134
      }

  

      /**

3f2bc3d0   Administrator   first commit
135
136
137
138
       * @return \yii\db\ActiveQuery

       */

      public function getImages()

      {

067092f7   Karnovsky A   -
139
          return $this->hasMany(ProductImage::className(), ['product_id' => 'product_id']);

3f2bc3d0   Administrator   first commit
140
141
      }

  

3f2bc3d0   Administrator   first commit
142
143
144
145
146
      /**

       * @return \yii\db\ActiveQuery

       */

      public function getVariant()

      {

0a93b48a   Karnovsky A   -
147
          return $this->hasOne(ProductVariant::className(), ['product_id' => 'product_id']);

3f2bc3d0   Administrator   first commit
148
149
150
151
152
153
154
155
156
157
      }

  

      public function getVariantPrice() {

          return $this->variant->price;

      }

      /**

       * @return \yii\db\ActiveQuery

       */

      public function getVariants()

      {

0a93b48a   Karnovsky A   -
158
          return $this->hasMany(ProductVariant::className(), ['product_id' => 'product_id']);

3f2bc3d0   Administrator   first commit
159
160
161
162
163
164
165
166
167
168
169
170
      }

  

      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
171
172
          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
173
174
175
176
177
178
179
180
181
182
183
      }

  

      public function getCategoriesNames() {

          $result = [];

          foreach($this->categories as $category) {

              $result[] = $category->name;

          }

          return $result;

      }

  

      public function getCategory() {

ccc7a9d3   Karnovsky A   Karnovsky 12052016
184
          return $this->hasOne(Category::className(), ['category_id' => 'category_id'])->viaTable('product_category', ['product_id' => 'product_id']);

3f2bc3d0   Administrator   first commit
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
      }

  

      public function getOptions() {

          return $this->getRelations('product_option');

      }

  

      /**

       * @inheritdoc

       * @return ProductQuery the active query used by this AR class.

       */

      public static function find()

      {

          return new ProductQuery(get_called_class());

      }

  

      public function afterSave($insert, $changedAttributes)

      {

          parent::afterSave($insert, $changedAttributes);

  

ccc7a9d3   Karnovsky A   Karnovsky 12052016
204
205
206
207
208
209
210
211
212
213
214
215
  //        $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
216
217
  //        }

  

4902c747   Karnovsky A   -
218
219
220
221
          if (!empty($this->_variants)) {

              $todel = [];

              foreach ($this->variants ?: [] as $_variant) {

                  $todel[$_variant->product_variant_id] = $_variant->product_variant_id;

3f2bc3d0   Administrator   first commit
222
              }

4902c747   Karnovsky A   -
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
              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
240
              }

c9d723d7   Karnovsky A   -
241
          }

3f2bc3d0   Administrator   first commit
242
      }

ccc7a9d3   Karnovsky A   Karnovsky 12052016
243
  

868680ca   Karnovsky A   -
244
245
246
247
248
249
      public function beforeDelete() {

          ProductImage::deleteAll(['product_id' => $this->product_id]);

          ProductCategory::deleteAll(['product_id' => $this->product_id]);

          ProductVariant::deleteAll(['product_id' => $this->product_id]);

      }

  

83be3cfb   Karnovsky A   -
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
      public function variantImagesUpload()

      {

          if ($this->validate()) {

              $images = [];

              foreach ($this->variantImagesUpload as $product_variant_id => $image) {

                  $imageName = $image->baseName .'.'. $image->extension;

                  $i = 0;

                  while(file_exists(Yii::getAlias('@imagesDir/products/' . $imageName))) {

                      $i++;

                      $imageName = $image->baseName .'_'. $i .'.'. $image->extension;

                  }

  

                  $image->saveAs(Yii::getAlias('@imagesDir/products/' .$imageName));

                  $images[$product_variant_id] = $imageName;

              }

              return $images;

          } else {

              return false;

          }

      }

  

ccc7a9d3   Karnovsky A   Karnovsky 12052016
271
272
273
274
275
276
277
      public function imagesUpload()

      {

          if ($this->validate()) {

              $images = [];

              foreach ($this->imagesUpload as $image) {

                  $imageName = $image->baseName .'.'. $image->extension;

                  $i = 0;

83be3cfb   Karnovsky A   -
278
                  while(file_exists(Yii::getAlias('@imagesDir/products/' . $imageName))) {

ccc7a9d3   Karnovsky A   Karnovsky 12052016
279
280
281
282
                      $i++;

                      $imageName = $image->baseName .'_'. $i .'.'. $image->extension;

                  }

  

83be3cfb   Karnovsky A   -
283
                  $image->saveAs(Yii::getAlias('@imagesDir/products/' .$imageName));

ccc7a9d3   Karnovsky A   Karnovsky 12052016
284
285
286
287
288
289
290
291
292
293
294
295
                  $images[] = $imageName;

              }

              return $images;

          } else {

              return false;

          }

      }

  

      public function getImagesHTML() {

          $op = [];

          if ($this->images) {

              foreach ($this->images as $image) {

83be3cfb   Karnovsky A   -
296
                  $op[] = \common\components\artboximage\ArtboxImageHelper::getImage($image->imageUrl, 'admin_thumb');

ccc7a9d3   Karnovsky A   Karnovsky 12052016
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
              }

          }

          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;

      }

3f2bc3d0   Administrator   first commit
319
  }