<?php
/**
 * XlsxHelper
 *
 * @copyright Copyright © 2019 Firebear Studio. All rights reserved.
 * @author    fbeardev@gmail.com
 */

namespace Firebear\ImportExport\Helper;

use Magento\Framework\Exception\ValidatorException;
use OpenSpout\Common\Exception\IOException;
use OpenSpout\Reader\SheetInterface;
use OpenSpout\Reader\XLSX\ReaderInterface;
use OpenSpout\Reader\Common\Creator\ReaderFactory;
use Magento\Framework\App\Filesystem\DirectoryList;
use Magento\Framework\App\Helper\AbstractHelper;
use Magento\Framework\App\Helper\Context;
use Magento\Framework\Filesystem\Directory\ReadInterface;
use Magento\Framework\FilesystemFactory;
use Exception;

class XlsxHelper extends AbstractHelper
{
    /**
     * @var ReadInterface
     */
    private $directory;
    /**
     * @var ReaderInterface
     */
    private $reader;
    /**
     * @var Spout
     */
    private $spout;

    /**
     * XlsxHelper constructor
     *
     * @param Context $context
     * @param FilesystemFactory $filesystemFactory
     * @param Spout $spout
     */
    public function __construct(
        Context $context,
        FilesystemFactory $filesystemFactory,
        Spout $spout
    ) {
        parent::__construct($context);
        $this->directory = $filesystemFactory->create()->getDirectoryRead(DirectoryList::ROOT);
        $this->spout = $spout;
    }

    /**
     * @param string $file
     * @return array
     */
    public function getSheetsOptions(string $file)
    {
        $sheetsName = [];
        try {
            if ($this->spout->isSpoutInstall()) {
                $file = $this->directory->getAbsolutePath($file);
                if ($this->spout->isSpoutInstall() && empty($this->reader)) {
                    $this->reader = ReaderFactory::createFromFile($file);
                }
                $this->reader->open($file);
                /** @var SheetInterface $sheet */
                foreach ($this->reader->getSheetIterator() as $sheet) {
                    $sheetsName[] = ['label' => $sheet->getName(), 'value' => $sheet->getIndex() + 1];
                }
                $this->reader->close();
            }
        } catch (Exception $exception) {
            $this->_logger->critical($exception->getMessage());
        }
        return $sheetsName;
    }
}