<?php
/**
 * Created by PhpStorm.
 * User: Tsurkanov
 * Date: 21.10.2015
 * Time: 15:44
 */

namespace yii\multiparser;


use common\components\CustomVarDamp;


/**
 * Class XlsxParser
 * @package yii\multiparser
 */
class XlsxParser extends Parser {

    /**
     * @var string - путь куда будут распаковываться файлы, если не указанно - во временный каталог сервера
     */
    public $path_for_extract_files = '';
    /** @var bool
    имеет ли файл заголовок который будет установлен ключами возвращемого массива*/
    public $hasHeaderRow = false;

    /**
     * @var int - если указано то считывание будет производиться с этого листа, иначе со всех листов
     * при чтении со всех листов - выходной массив будет иметь номера листов первыми элементами
     */
    public $active_sheet = 0;

    protected $strings_arr = [];
    protected $sheets_arr = [];
    protected $result_arr = [];

    public function setup()
    {
        parent::setup();
        if ( $this->path_for_extract_files == '' ) {
            $this->path_for_extract_files = sys_get_temp_dir();
        }
    }


    public function read()
    {

 //       $this->extractFiles();

        $this->readSheets();
        $this->readStrings();
        $this->readValues();

        CustomVarDamp::dumpAndDie($this->result_arr);
       // return $this->$result_arr;
    }

    protected function extractFiles ()
    {
        $zip = new \ZipArchive;
        if ( $zip->open( $this->file->getPathname() ) === TRUE ) {
            $zip->extractTo( $this->path_for_extract_files );
            $zip->close();
        } else {
            throw new \Exception( 'Ошибка чтения xlsx файла' );
        }
    }

    protected function readSheets ()
    {
        if ( $this->active_sheet ) {
            $this->sheets_arr[ $this->active_sheet ] = 'Sheet' . $this->active_sheet;
            return;
        }

        $xml = simplexml_load_file( $this->path_for_extract_files . '/xl/workbook.xml' );
        foreach ( $xml->sheets->children() as $sheet ) {
            $sheet_name = '';
            $sheet_id = 0;
            $attr = $sheet->attributes();
            foreach ( $attr as $name => $value ) {
                if ($name == 'name')
                    $sheet_name = (string)$value;

                if ($name == 'sheetId')
                    $sheet_id = $value;

            }
            if ( $sheet_name && $sheet_id ) {
                $this->sheets_arr[$sheet_name] = 'Sheet' . $sheet_id;
            }
//
        }
    }

    protected function readStrings ()
    {
        $xml = simplexml_load_file( $this->path_for_extract_files . '/xl/sharedStrings.xml' );
        foreach ( $xml->children() as $item ) {
            $this->strings_arr[] = (string)$item->t;
        }
    }

    protected function readValues ()
    {
        //foreach ( glob($this->path_for_extract_files . '/xl/worksheets/*.xml' ) as $sheet ) {
        foreach ( $this->sheets_arr  as $sheet ) {
            //проходим по всем файлам из директории /xl/worksheets/
            //CustomVarDamp::dumpAndDie($sheet);
            $sheet_path = $this->path_for_extract_files . '/xl/worksheets/' . $sheet . '.xml';
            if ( file_exists( $sheet_path ) && is_readable( $sheet_path ) ) {
                $xml = simplexml_load_file( $sheet_path );
                //по каждой строке
                $current_row = 0;

                foreach ( $xml->sheetData->row as $row_values ) {
                   $this->readRowValues( $row_values, $sheet , $current_row );
                    $current_row++;
                }
            }
        }
    }

    protected function readRowValues ( $item, $sheet , $current_row )
    {
        $this->result_arr[$sheet][$current_row] = array();
        //по каждой ячейке строки
        $cell = 0;
        foreach ( $item as $child ) {
            $attr = $child->attributes();

            if( isset($child->v) ) {
                $value = (string)$child->v;
            }else{
                $value = false;
            }
            if ( isset( $attr['t'] ) ) {
                $this->result_arr[$sheet][$current_row][$cell] =  $this->strings_arr[ $value ];
            }else{
                $this->result_arr[$sheet][$current_row][$cell] =  $value;
            }
            $cell++;
        }

    }
}