MisterIcy\ExcelWriter\Handlers\DataHandler

Complexity

Total Complexity

9

Size/Duplication

Total Lines	65
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	replaceProperties()	0	14	5
A	handle()	0	37	4

<?php
declare(strict_types=1);

namespace MisterIcy\ExcelWriter\Handlers;

use MisterIcy\ExcelWriter\Generator\AbstractGenerator;
use MisterIcy\ExcelWriter\Generator\GeneratorInterface;
use MisterIcy\ExcelWriter\Properties\AbstractProperty;
use MisterIcy\ExcelWriter\Properties\PropertyCollection;
use PhpOffice\PhpSpreadsheet\Cell\Cell;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;

/**
 * Class DataHandler - Reference Implementation
 * @package MisterIcy\ExcelWriter\Handlers
 */
final class DataHandler extends AbstractHandler
{
    /**
     * @param AbstractGenerator $generator
     * @return HandlerInterface
     */
    public function handle(GeneratorInterface $generator)
    {
        /** @scrutinizer ignore-call */
        $spreadsheet = $generator->getSpreadsheet();
        /** @scrutinizer ignore-call */
        $properties = $generator->getProperties();
        /** @scrutinizer ignore-call */
        $data = $generator->getData();

        $row = 2;
        $column = 1;

        foreach ($data as $object) {
            /** @var AbstractProperty $property */
            foreach ($properties->getProperties() as $property) {
                $value = $property->renderProperty($object);
                if ($property->isFormula()) {
                    $value = str_replace("{row}", strval($row), $value);
                    $value = str_replace("{col}", Coordinate::stringFromColumnIndex($column), $value);

                    $value = $this->replaceProperties($properties, $value);
                }
                $spreadsheet->getActiveSheet()
                    ->setCellValueByColumnAndRow($column, $row, $value);

                $spreadsheet
                    ->getActiveSheet()
                    ->getCellByColumnAndRow($column, $row)
                    ->getStyle()
                    ->getNumberFormat()
                    ->setFormatCode($property->getFormatCode());
                $column++;
            }
            $column = 1;
            $row++;
        }
        return parent::handle($generator);
    }

    /**
     * @param PropertyCollection $properties
     * @param string $value
     * @return string
     * @throws \MisterIcy\ExcelWriter\Exceptions\PropertyException
     */
    private function replaceProperties(PropertyCollection $properties, string $value) : string
    {
        $matches = [];
        preg_match_all("/\[(.*?)\]/", $value, $matches, PREG_UNMATCHED_AS_NULL);

        if (count($matches) > 0) {
            if (count($matches[0]) > 0 && count($matches[1]) > 0) {
                foreach ($matches[1] as $match) {
                    $propColumn = $properties->getExcelColumnOfPropertyPath($match);
                    $value = str_replace("[" . $match . "]", $propColumn, $value);
                }
            }
        }
        return $value;
    }
}