Blame view

common/modules/product/models/Product.php 10.3 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
      }

  

      public function getOptions() {

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

      }

  

5ee9ab1f   Karnovsky A   -
191
192
193
194
      public function getStocks() {

          return $this->hasMany(Stock::className(), ['stock_id' => 'stock_id'])->viaTable(ProductStock::tableName(), ['product_id' => 'product_id']);

      }

  

3f2bc3d0   Administrator   first commit
195
196
197
198
199
200
201
202
203
204
205
206
207
      /**

       * @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
208
209
210
211
212
213
214
215
216
217
218
219
  //        $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
220
221
  //        }

  

4902c747   Karnovsky A   -
222
223
224
225
          if (!empty($this->_variants)) {

              $todel = [];

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

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

3f2bc3d0   Administrator   first commit
226
              }

4902c747   Karnovsky A   -
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
              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
244
              }

c9d723d7   Karnovsky A   -
245
          }

3f2bc3d0   Administrator   first commit
246
      }

ccc7a9d3   Karnovsky A   Karnovsky 12052016
247
  

868680ca   Karnovsky A   -
248
249
250
251
252
253
      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   -
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
      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
275
276
277
278
279
280
281
      public function imagesUpload()

      {

          if ($this->validate()) {

              $images = [];

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

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

                  $i = 0;

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

ccc7a9d3   Karnovsky A   Karnovsky 12052016
283
284
285
286
                      $i++;

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

                  }

  

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

ccc7a9d3   Karnovsky A   Karnovsky 12052016
288
289
290
291
292
293
294
295
296
297
298
299
                  $images[] = $imageName;

              }

              return $images;

          } else {

              return false;

          }

      }

  

      public function getImagesHTML() {

          $op = [];

          if ($this->images) {

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

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

ccc7a9d3   Karnovsky A   Karnovsky 12052016
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
              }

          }

          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
323
  }