Omatech\Mage\Core\Adapters\Translations\Importers\ImporterFromExcel

Complexity

Total Complexity

11

Size/Duplication

Total Lines	60
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	import()	0	6	1
A	parseTranslations()	0	19	5
A	importSheets()	0	11	2
A	getSheets()	0	16	3

<?php

namespace Omatech\Mage\Core\Adapters\Translations\Importers;

use Box\Spout\Common\Type;
use Box\Spout\Reader\ReaderFactory;
use Omatech\Mage\Core\Domains\Translations\Contracts\ImportTranslationInterface;
use Rap2hpoutre\FastExcel\FastExcel;

class ImporterFromExcel implements ImportTranslationInterface
{
    public function import(string $path, string $locale = ''): array
    {
        $sheetNames = $this->getSheets($path, $locale);
        $sheets = $this->importSheets($path, $sheetNames);

        return $this->parseTranslations($sheetNames, $sheets);
    }

    private function getSheets(string $path, string $locale = ''): array
    {
        $sheetNames = [];

        $reader = ReaderFactory::create(Type::XLSX);
        $reader->open($path);

        foreach ($reader->getSheetIterator() as $sheet) {
            array_push($sheetNames, $sheet->getName());
        }

        if ('' != $locale) {
            $sheetNames = [0 => $locale];
        }

        return $sheetNames;
    }

    private function importSheets(string $path, array $sheetNames): array
    {
        $sheets = (new FastExcel());

        if (count($sheetNames) > 1) {
            $sheets = $sheets->importSheets($path)->toArray();
        } else {
            $sheets = [$sheets->sheet(key($sheetNames) + 1)->import($path)->toArray()];
        }

        return $sheets;
    }

    private function parseTranslations(array $sheetNames, array $sheets): array
    {
        $translations = [];
        $parsedKeys = [];

        foreach ($sheets as $lang => $trans) {
            $translations[$sheetNames[$lang]] = $trans;
        }

        foreach ($translations as $lang => $keys) {
            foreach ($keys as $key) {
                if ('' != $key['key2']) {
                    $parsedKeys[$key['key2']]['key'] = $key['key2'];
                    $parsedKeys[$key['key2']]['value'][$lang] = $key['value'];
                }
            }
        }

        return array_values($parsedKeys);
    }
}