lib/XlsxParser.php

<?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 TableParser {
    /**
     * @var string - путь куда будут распаковываться файлы, если не указанно - во временный каталог сервера
     */
    public $path_for_extract_files = '';
    /**
     * @var int - если указано то считывание будет производиться с этого листа, иначе со всех листов
     * при чтении со всех листов - выходной массив будет иметь номера листов первыми элементами
     */
    public $active_sheet = 0;
    protected $strings_arr = [];
    protected $sheets_arr = [];
    protected $current_node;
    protected $current_sheet;
    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();
        foreach ( $this->sheets_arr  as $sheet ) {
            //проходим по всем файлам из директории /xl/worksheets/
            $this->current_sheet = $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, "SimpleXMLIterator" );
                $this->current_node = $xml->sheetData->row;
                $this->current_node->rewind();
                if ( $this->current_node->valid() ) {
                    parent::read();
                }
            }
        }
        if ( $this->active_sheet ) {
            // в настройках указан конкретный лист с которогшо будем производить чтение, поэтому и возвращаем подмассив
            return $this->result[ $this->current_sheet ];
        }else{
            return $this->result;
        }
    }
    protected function extractFiles ()
    {
        $this->path_for_extract_files = $this->path_for_extract_files . session_id();
        if ( !mkdir($this->path_for_extract_files) )
        {
            throw new \Exception( 'Ошибка создания временного каталога - ' . $this->path_for_extract_files );
            }
        $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[ ] = '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 readRow ( $item, $sheet , $current_row )
    protected function readRow ( )
    {
        $this->row = [];
        $node = $this->current_node->getChildren();
        if ($node === NULL) {
            return;
        }
        //foreach ( $node as $child ) {
        for ( $node->rewind(); $node->valid(); $node->next() ) {
            $child = $node->current();
            $attr = $child->attributes();
            if( isset($child->v) ) {
                $value = (string)$child->v;
            }else{
                $value = '';
            }
            if ( isset( $attr['t'] ) ) {
              //  $this->result_arr[$sheet][$current_row][$cell] =  $this->strings_arr[ $value ];
                $this->row[] =  $this->strings_arr[ $value ];
            }else{
             //   $this->result_arr[$sheet][$current_row][$cell] =  $value;
                $this->row[] =  $value;
            }
        }
        // дополним ряд пустыми значениями если у нас ключей больше чем значений
        if ( $this->has_header_row && ( count( $this->keys ) > count( $this->row ) ) ) {
            $extra_coloumn = count( $this->keys ) - count( $this->row );
            for ( $i = 1; $i <= $extra_coloumn; $i++ ) {
                $this->row[] =  '';
            }
        }
        $this->current_node->next();
    }
    protected  function isEmptyRow(){
        $is_empty = false;
       // CustomVarDamp::dump(count( $this->row ), $this->current_row_number);
        if ( !count( $this->row ) || !$this->current_node->valid() ) {
            return true;
        }
        $j = 0;
        for ($i = 1; $i <= count( $this->row ); $i++) {
            if ( $this->isEmptyColumn( $this->row[$i - 1] ) ) {
                $j++;
            }
            if ( $j >= $this->min_column_quantity ) {
                $is_empty = true;
                break;
            }
        }
        return $is_empty;
    }
    protected  function isEmptyColumn( $val ){
        return $val == '';
    }
    protected  function setResult(  ){
        $this->result[ $this->current_sheet ][] = $this->row;
    }
    protected function deleteExtractFiles ()
    {
            $this->removeDir( $this->path_for_extract_files );
    }
    protected function removeDir($dir) {
        if (is_dir($dir)) {
            $objects = scandir($dir);
            foreach ($objects as $object) {
                if ($object != "." && $object != "..") {
                    if (filetype($dir."/".$object) == "dir")
                        $this->removeDir($dir."/".$object);
                    else
                        unlink($dir."/".$object);
                }
            }
            reset($objects);
            rmdir($dir);
        }
    }
    function __destruct()
    {
        $this->deleteExtractFiles();
    }
}