execut\import\components\ToArrayConverter::convert()

Complexity

Conditions	29
Paths	6966

Size

Total Lines	129
Code Lines	81

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	64
CRAP Score	33.0449

Importance

Changes

0

<?php
    public function convert() {
        $file = $this->file;
        if (!is_string($file)) {
            $isUnlinkFile = true;
            $fileContent = stream_get_contents($file);
            $file = tempnam('/tmp', 'test_');
            file_put_contents($file, $fileContent);
        } else {
            $isUnlinkFile = false;
        }

        if ($this->mimeType === 'application/x-rar' || ($this->mimeType === null && mime_content_type($file) === 'application/x-rar')) {
            exec('unrar lb "' . $file . '"', $out);
            $unpackedFile = tempnam('/tmp', 'test_') . $out[0];
            exec('unrar p -inul "' . $file . '" > "' . $unpackedFile . '"');
            if ($isUnlinkFile) {
                unlink($file);
            }

            $file = $unpackedFile;
            $isUnlinkFile = true;
        }

        if ($this->mimeType === 'application/zip' || ($this->mimeType === null && mime_content_type($file) === 'application/zip')) {
            $unpackedFile = '/tmp/' . exec('unzip -l "' . $file . '" | awk \'/-----/ {p = ++p % 2; next} p {print $NF}\'');
            exec('unzip -cqq "' . $file . '" > ' . $unpackedFile);
            if ($isUnlinkFile) {
                unlink($file);
            }

            $file = $unpackedFile;
            $isUnlinkFile = true;
        }

        $cache = $this->getCache();
        if ($cache) {
            $md5 = md5_file($file);
            $cacheKey = $md5 . $this->delimiter . '-' . $this->enclosure . '-' . $this->encoding . '-' . $this->trim;
            if ($result = $cache->get($cacheKey)) {
//                $result = array_splice($result, 0, 10);
                return $result;
            }
        }

//        \PHPExcel_Settings::setLocale('ru_RU');
        \PhpOffice\PhpSpreadsheet\Shared\StringHelper::setDecimalSeparator('.');
        \PhpOffice\PhpSpreadsheet\Shared\StringHelper::setThousandsSeparator('');
        try {
            $reader = IOFactory::createReaderForFile($file);
        } catch (\PhpOffice\PhpSpreadsheet\Reader\Exception $e) {
            $ext = pathinfo($file, PATHINFO_EXTENSION);
            if ($ext === 'xls') {
                $reader = IOFactory::createReader('Xls');
            } else {
                throw $e;
            }
        }

        if (($reader instanceof Csv) || ($reader instanceof Html)) {
            $result = [];
            $content = str_replace(["\r\n", "\n\r", "\r"], "\n", file_get_contents($file));
            $content = explode("\n", $content);
            $delimiter = $this->delimiter;
            foreach ($content as $value) {
                $value = $this->convertEncoding($value);
                if ($this->delimiter) {
                    if (strlen($this->delimiter) == 2) {
                        $delimiter = '~';
                        $value = str_replace($this->delimiter, $delimiter, $value);
                    }
                }

                $parts = str_getcsv($value, $delimiter, $this->enclosure);
                $result[] = $parts;
            }
        } else {
//            $cacheMethod = \PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp;
//            $cacheSettings = array( 'memoryCacheSize' => '500MB');
//            \PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);
//            $reader->setReadDataOnly(true);
            $oldReporting = error_reporting();
            error_reporting(E_ALL & ~E_NOTICE);
            try {
                $table = $reader->load($file);
            } catch (\PhpOffice\PhpSpreadsheet\Reader\Exception $e) {
                $reader = \PHPExcel_IOFactory::createReaderForFile($file);

The type PHPExcel_IOFactory was not found. Maybe you did not declare it correctly or list all dependencies?

                $table = $reader->load($file);
            }

            error_reporting($oldReporting);

            $result = [];
            $sheets = $table->getAllSheets();
            foreach ($sheets as $sheet) {
                $result = array_merge($result, $sheet->toArray(null, false));
            }

            if ($this->encoding !== null) {
                foreach ($result as &$row) {
                    foreach ($row as $key => $value) {
                        $value = $this->convertEncoding($value);

                        $row[$key] = $value;
                    }
                }
            }
        }

        if ($this->trim !== null) {
            foreach ($result as &$row) {
                foreach ($row as $key => $value) {
                    $value = trim($value, $this->trim);

                    $row[$key] = $value;
                }
            }
        }


        if ($isUnlinkFile) {
            unlink($file);
        }

        $cache = $this->getCache();
        if ($cache) {
            $cache->set($cacheKey, $result, 3600);

The variable $cacheKey does not seem to be defined for all execution paths leading up to this point.

        }

        return $result;
    }
}