Blame view

common/modules/product/models/Export.php 3.24 KB
4253cbec   root   first commit
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
  <?php
  
  namespace common\modules\product\models;
  
  use common\modules\product\helpers\ProductHelper;
  use yii\base\Model;
  use yii\helpers\ArrayHelper;
  
  class Export extends Model {
      public $errors = [];
      public $output = [];
  
      public function process($dirName, $filename = null, $use_not_enables = false) {
          if (is_null($filename)) {
              $filename = 'products_'. date('d_m_Y_H_i') .'.csv';
          }
          setlocale(LC_ALL, 'ru_RU.CP1251');
          $handle = fopen($dirName .'/'. $filename, "w");
          ///$products = Product::find()->joinWith(['variants'])->where(['!=', ProductVariant::tableName() .'.stock', 0])->select('product.product_id')->all();
          $products = Product::find()
6583ee6b   Administrator   big commti
21
              ->joinWith(['variantsWithFilters','brand','categories'])->with('filters')->all();
c4015198   Administrator   big commti
22
  
4253cbec   root   first commit
23
  
a1a60fa5   Administrator   big commti
24
  
6583ee6b   Administrator   big commti
25
          foreach ($products as $product)
4253cbec   root   first commit
26
27
28
          {
  
  
6583ee6b   Administrator   big commti
29
  
4253cbec   root   first commit
30
31
32
33
34
              /*if ($i>1e2) {
                  break;
              }*/
              $mods = [];
  
6583ee6b   Administrator   big commti
35
              $filterString = $this->convertFilterToString($product->filters);
4253cbec   root   first commit
36
  
6583ee6b   Administrator   big commti
37
              foreach ($product->variantsWithFilters as $variant)
4253cbec   root   first commit
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
              {
  
                  $color = $variant->name;
  
                  $mods[] = $variant->sku .
                      '=' . $this->convertFilterToString($variant->filters) .
                      '=' . $color .
                      '=' . ((!empty($variant->image)) ? $variant->image->image: '').
                      '=' . $variant->stock;
              }
  
  
              $fotos = [];
  
  //            foreach ($product->images as $image)
  //            {
  //                $fotos[] = $image->imageUrl;
  //            }
  
  //            $filters = $product->properties;
              $categories = [];
6583ee6b   Administrator   big commti
59
              foreach($product->categories as $value){
aefe93aa   Administrator   big commti
60
61
  
                  $categories[] = $value->name;
4253cbec   root   first commit
62
63
64
65
66
67
68
  
              }
  
  
              $categories = implode(',',$categories);
  
              $list = [
aefe93aa   Administrator   big commti
69
  
4253cbec   root   first commit
70
                  $categories,
6583ee6b   Administrator   big commti
71
72
                  $product->brand->name,
                  $product->name,
4253cbec   root   first commit
73
                  '',
6583ee6b   Administrator   big commti
74
                  ((! empty($product->description)) ? $product->description : ''),
4253cbec   root   first commit
75
                  $filterString,
6583ee6b   Administrator   big commti
76
77
78
                  (!empty($product->variant)) ? $product->variant->price_old : '',
                  (!empty($product->variant)) ? $product->variant->price : '',
                  intval($product->akciya),
4253cbec   root   first commit
79
                  '',
6583ee6b   Administrator   big commti
80
81
82
                  intval($product->is_new),
                  intval($product->is_top),
                  $product->video,
4253cbec   root   first commit
83
84
85
86
                  implode (',', $fotos),
              ];
  
              $to_write = array_merge ($list, $mods);
73028f91   Administrator   big commti
87
88
89
              foreach($to_write as &$cell) {
                  $cell = iconv("UTF-8", "WINDOWS-1251", $cell);
              }
4253cbec   root   first commit
90
91
92
  
  
              fputcsv($handle, $to_write, ';');
6583ee6b   Administrator   big commti
93
              unset($product);
af56ba2f   Administrator   big commti
94
              die('first');
4253cbec   root   first commit
95
96
97
98
99
100
101
102
103
104
105
106
107
108
          }
  
  
  
          fclose ($handle);
  
          return $dirName .'/'. $filename;
      }
  
  
      public function convertFilterToString($filters){
          $fittersArray = [];
          foreach($filters as $filter){
              $fittersArray[$filter->taxGroup->alias][] =  $filter->name;
4253cbec   root   first commit
109
110
111
112
113
114
115
116
          }
          $filterString=[];
  
          foreach($fittersArray as $filterName =>$filterRows ){
              $row = implode(',',$filterRows);
              $filterString[] = "[{$filterName}:{$row}]";
  
          }
4253cbec   root   first commit
117
118
119
          return implode('*',$filterString);
      }
  }