Administrator / liniya-svitla

  <?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) {

          set_time_limit(0);

          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()

              ->joinWith(['variantsWithFilters','brand','categories'])->with('filters')->all();

          foreach ($products as $product)

          {
  
  

              /*if ($i>1e2) {
                  break;
              }*/
              $mods = [];
  

              $filterString = $this->convertFilterToString($product->filters);

              foreach ($product->variantsWithFilters as $variant)

              {
  
                  $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 = [];

              foreach($product->categories as $value){

  
                  $categories[] = $value->name;

  
              }
  
  
              $categories = implode(',',$categories);
  
              $list = [

                  $categories,

                  $product->brand->name,
                  $product->name,

                  '',

                  ((! empty($product->description)) ? $product->description : ''),

                  $filterString,

                  (!empty($product->variant)) ? $product->variant->price_old : '',
                  (!empty($product->variant)) ? $product->variant->price : '',
                  intval($product->akciya),

                  '',

                  intval($product->is_new),
                  intval($product->is_top),
                  $product->video,

                  implode (',', $fotos),
              ];
  
              $to_write = array_merge ($list, $mods);

              foreach($to_write as &$cell) {
                  $cell = iconv("UTF-8", "WINDOWS-1251", $cell);
              }

  
  
              fputcsv($handle, $to_write, ';');

              unset($product);

          }
  
  
  
          fclose ($handle);
  
          return $dirName .'/'. $filename;
      }
  
  
      public function convertFilterToString($filters){
          $fittersArray = [];
          foreach($filters as $filter){
              $fittersArray[$filter->taxGroup->alias][] =  $filter->name;

          }
          $filterString=[];
  
          foreach($fittersArray as $filterName =>$filterRows ){
              $row = implode(',',$filterRows);
              $filterString[] = "[{$filterName}:{$row}]";
  
          }

          return implode('*',$filterString);
      }
  }