OCA\Analytics\Datasource\Excel::readData()

Complexity

Conditions	8
Paths	32

Size

Total Lines	57
Code Lines	35

Duplication

Lines	0
Ratio	0 %

Importance

Changes	4
Bugs	0	Features	0

<?php
    public function readData($option): array
    {
        include_once __DIR__ . '/../../vendor/autoload.php';
        $header = $dataClean = $data = array();
        $headerrow = $error = 0;

        $file = $this->rootFolder->getUserFolder($option['user_id'])->get($option['link']);
        $fileName = $file->getStorage()->getLocalFile($file->getInternalPath());

        $inputFileType = IOFactory::identify($fileName);
        $reader = IOFactory::createReader($inputFileType);
        //$reader->setReadDataOnly(true); disabled as idDate is not working otherwise
        if (strlen($option['sheet']) > 0) {
            $reader->setLoadSheetsOnly([$option['sheet']]);
        }
        $spreadsheet = $reader->load($fileName);

        // separated columns can be selected via ranges e.g. "A1:B9,C1:C9"
        // these ranges are read and linked
        $ranges = str_getcsv($option['range']);
        foreach ($ranges as $range) {
            $values = $spreadsheet->getActiveSheet()->rangeToArray(
                $range,                // The worksheet range that we want to retrieve
                NULL,         // Value that should be returned for empty cells
                TRUE,   // Should formulas be calculated (the equivalent of getCalculatedValue() for each cell)
                TRUE,        // Should values be formatted (the equivalent of getFormattedValue() for each cell)
                FALSE       // Should the array be indexed by cell row and cell column
            );

            $values = $this->convertExcelDate($spreadsheet, $values, $range);

            if (empty($data)) {
                // first range will fill the array with all rows
                $data = $values;
            } else {
                // further columns will be attached to the first ones
                foreach ($data as $key => $value) {
                    $data[$key] = array_merge($value, $values[$key]);
                }

            }
        }

        foreach ($data as $key => $value) {
            if ($headerrow === 0) {
                $header = array_values($value);
                $headerrow = 1;
            } else if (!$this->containsOnlyNull($value)) {
                array_push($dataClean, array_values($value));
            }
        }

        return [
            'header' => $header,
            'dimensions' => array_slice($header, 0, count($header) - 1),
            'data' => $dataClean,
            'error' => $error,
        ];
}