<?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;

    }


}