Administrator / test_1

  <?php
  /**
   * Created by PhpStorm.
   * User: Cibermag
   * Date: 26.08.2015
   * Time: 17:00
   */
  

  namespace backend\components\parsers;

  
  use Yii;
  use yii\base\ErrorException;

  use common\components\debug\CustomVarDamp;

  class CsvParser  {

  
      /** @var bool */

      public $hasHeaderRow = false;

      /** @var resource */

      public $file;

  
      /** @var out encoding charset */

      public $out_charset = 'UTF-8';

      /** @var out encoding charset */

      public $in_charset = 'windows-1251';

      /** @var int - first line for parsing */

      public $first_line = 0;

      /** @var int - first column for parsing */

      public $first_column = 0;

      /** @var array - array of headers values */

      public $keys;
      public $delimiter = ';';
      public $auto_detect_start_position = false;
      public $min_column_quantity = 5;

      public function setup()
      {

          if ($this->auto_detect_start_position) {
              $this->first_line = $this->detectStartPosition();
          }
          CustomVarDamp::dumpAndDie( $this->first_line );
          $this->file->setCsvControl($this->$delimiter);

          $this->file->setFlags(\SplFileObject::READ_CSV);
          $this->file->seek( $this->first_line );
  

      }
  

      protected function detectStartPosition ()
      {
          $first_column = 0;
          $find = false;
          while (!$find) {
  
          $j = 0;
          $row = $this->readRow();
              $first_column++;
          for ($i = 1; $i<=count($row); $i++) {
              if (!$row[$i]) {
                  $j++;
              }
              if ( $j >= $this->min_column_quantity ) {
                  $find = true;
                  break;
              }
          }
          }
  
          return $first_column;
  
      }

  
      /**
       * @return array
       * @throws InvalidFileException
       */
      public function read()
      {

          // @todo add comments

          $return = [];
  

          $line = 0;

          $this->keys = NULL;

  
          while (($row = $this->readRow()) !== FALSE) {
              $line++;
  
              if ($this->hasHeaderRow) {

                  if ($this->keys === NULL) {
                      $this->keys = array_values($row);

                  } else {
  

                      if (count($this->keys) !== count($row)) {

  //
                          Yii::warning("Invalid columns detected on line #$line .");
                          return $return;
                      }
  

                      $return[] = array_combine($this->keys, $row);

                  }
              } else {
                  $return[] = $row;
              }
          }
  
          $this->closeHandler();
  
          return $return;
      }
  

      protected function closeHandler()

      {

          $this->file = NULL;

      }
  

      protected function readRow()

          // @todo add comments

      {

  
          $row = $this->file->fgetcsv(  );
          //
          if (is_array($row)) {
              $row = array_slice( $row, $this->first_column );
              $row = Encoder::encodeArray( $this->in_charset, $this->out_charset, $row );
          } else{
              $row = false;
          }
  

  
  //        if ($this->keys !== NULL)

  //            @$clear_arr[3] = ValueFilter::pricefilter($clear_arr[3]);{}{}{}

          return $row;

  
      }
  

  
  }