Application\Handler\AbstractExcel

Complexity

Total Complexity

19

Size/Duplication

Total Lines	297
Duplicated Lines	0 %

Test Coverage

Coverage

92.86%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	write()	0	19	5
A	__construct()	0	8	1
A	handle()	0	22	2
A	generate()	0	22	1
B	writeHeaders()	0	32	10

<?php

declare(strict_types=1);

namespace Application\Handler;

use Application\Model\AbstractModel;
use DateTimeImmutable;
use DateTimeInterface;
use Doctrine\ORM\Query;
use Ecodev\Felix\Handler\AbstractHandler;
use Laminas\Diactoros\Response;
use Money\Currencies\ISOCurrencies;
use Money\Formatter\DecimalMoneyFormatter;
use Money\Money;
use PhpOffice\PhpSpreadsheet\Shared\Date;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Border;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use Psr\Http\Message\ResponseInterface;
use Psr\Http\Message\ServerRequestInterface;
use Psr\Http\Server\RequestHandlerInterface;

abstract class AbstractExcel extends AbstractHandler
{
    /**
     * Column of current cell we are writing in
     *
     * @var int
     */
    protected $column = 1;

    /**
     * Row of current cell we are writing in
     *
     * @var int
     */
    protected $row = 1;

    /**
     * @var Spreadsheet
     */
    protected $workbook;

    /**
     * @var string
     */
    protected $outputFileName = 'export.xlsx';

    /**
     * @var string
     */
    protected $tmpDir = 'data/tmp/excel';

    /**
     * @var string
     */
    protected $hostname;

    /**
     * @var string
     */
    protected $routeName;

    protected DecimalMoneyFormatter $moneyFormatter;

    /**
     * The model class name
     *
     * @return string
     */
    abstract protected function getModelClass();

    protected static $dateFormat = [
        'numberFormat' => ['formatCode' => NumberFormat::FORMAT_DATE_XLSX14],
    ];

    protected static $defaultFormat = [
        'font' => ['size' => 11],
        'alignment' => ['vertical' => Alignment::VERTICAL_CENTER],
    ];

    protected static array $titleFormat = [
        'font' => ['size' => 14],
    ];

    protected static $headerFormat = [
        'font' => ['bold' => true, 'color' => ['argb' => 'FFEAEAEA']],
        'alignment' => ['wrapText' => true],
        'fill' => [
            'fillType' => Fill::FILL_SOLID,
            'startColor' => [
                'argb' => 'FF666666',
            ],
        ],
    ];

    protected static $totalFormat = [
        'font' => ['bold' => true],
        'alignment' => ['wrapText' => true],
        'fill' => [
            'fillType' => Fill::FILL_SOLID,
            'startColor' => [
                'argb' => 'FFDDDDDD',
            ],
        ],
    ];

    protected static $centerFormat = [
        'alignment' => ['horizontal' => Alignment::HORIZONTAL_CENTER],
    ];

    protected static $rightFormat = [
        'alignment' => ['horizontal' => Alignment::HORIZONTAL_RIGHT],
    ];

    protected static $wrapFormat = [
        'alignment' => ['wrapText' => true],
    ];

    /**
     * Define border cells inside list of data (very light borders)
     *
     * @var array
     */
    protected static $bordersInside = [
        'borders' => [
            'inside' => [
                'borderStyle' => Border::BORDER_HAIR,
            ],
            'outline' => [
                'borderStyle' => Border::BORDER_MEDIUM,
            ],
        ],
    ];

    /**
     * Define border cells for total row (thick border)
     *
     * @var array
     */
    protected static $bordersTotal = [
        'borders' => [
            'outline' => [
                'borderStyle' => Border::BORDER_THICK,
            ],
        ],
    ];

    /**
     * @var array
     */
    protected static $bordersBottom = [
        'borders' => [
            'bottom' => [
                'borderStyle' => Border::BORDER_MEDIUM,
            ],
        ],
    ];

    /**
     * @var array
     */
    protected static $bordersBottomLight = [
        'borders' => [
            'bottom' => [
                'borderStyle' => Border::BORDER_HAIR,
            ],
        ],
    ];

    /**
     * Constructor
     */
    public function __construct(string $hostname, string $routeName)
    {
        $this->hostname = $hostname;
        $this->routeName = $routeName;
        $currencies = new ISOCurrencies();
        $this->moneyFormatter = new DecimalMoneyFormatter($currencies);
        $this->workbook = new Spreadsheet();
        $this->workbook->setActiveSheetIndex(0);
    }

    /**
     * @param AbstractModel[] $items
     */
    protected function writeHeaders(Worksheet $sheet, array $items): void
    {
        $initialColumn = $this->column;

The assignment to $initialColumn is dead and can be removed.

        // Headers
        foreach ($this->getHeaders() as $header) {
            // Apply width
            if (isset($header['width'])) {
                $colDimension = $sheet->getColumnDimensionByColumn($this->column);
                if ($header['width'] === 'auto') {
                    $colDimension->setAutoSize(true);
                } else {
                    $colDimension->setWidth($header['width']);
                }
            }
            // Apply default format
            if (!isset($header['formats'])) {
                $header['formats'] = [self::$headerFormat];
            }

            if (isset($header['colspan']) && $header['colspan'] > 1) {
                $sheet->mergeCellsByColumnAndRow($this->column, $this->row, $this->column + (int) $header['colspan'] - 1, $this->row);
            }

            if (isset($header['autofilter'])) {
                $sheet->setAutoFilterByColumnAndRow($this->column, $this->row, $this->column - 1, $this->row + count($items));
            }

            $this->write($sheet, $header['label'], ...$header['formats']);

            if (isset($header['colspan']) && $header['colspan'] > 1) {
                $this->column += (int) $header['colspan'] - 1;
            }
        }
    }

    /**
     * Write the items, one per line, in the body part of the sheet
     *
     * @param AbstractModel[] $items
     */
    abstract protected function writeData(Worksheet $sheet, array $items): void;

    /**
     * Write the footer line
     *
     * @param AbstractModel[] $items
     */
    abstract protected function writeFooter(Worksheet $sheet, array $items): void;

    abstract protected function getHeaders(): array;

    /**
     * Write the value and style in the cell selected by `column` and `row` variables and move to next column
     *
     * @param mixed $value
     * @param array[] ...$formats optional list of formats to be applied successively
     */
    protected function write(Worksheet $sheet, $value, array ...$formats): void
    {
        $cell = $sheet->getCellByColumnAndRow($this->column++, $this->row);
        if ($formats) {

The expression $formats of type array<integer,array> is implicitly converted to a boolean; are you sure this is intended? If so, consider using ! empty($expr) instead to make it clear that you intend to check for an array without elements.

            $style = $cell->getStyle();
            foreach ($formats as $format) {
                $style->applyFromArray($format);
            }
        }

        // Automatic conversion of date to Excel format
        if ($value instanceof DateTimeInterface) {
            $dateTime = new DateTimeImmutable($value->format('c'));
            $value = Date::PHPToExcel($dateTime);
        } elseif ($value instanceof Money) {
            $value = $this->moneyFormatter->format($value);
        }

        $cell->setValue($value);
    }

    /**
     * Called by the field resolver or repository to generate a spreadsheet from the query builder
     *
     * @return string the generated spreadsheet file path
     */
    public function generate(Query $query): string
    {
        $items = $query->getResult();

        $this->workbook->getDefaultStyle()->applyFromArray(self::$defaultFormat);
        $sheet = $this->workbook->getActiveSheet();
        $this->row = 1;
        $this->column = 1;
        $this->writeHeaders($sheet, $items);
        ++$this->row;
        $this->column = 1;
        $this->writeData($sheet, $items);
        $this->column = 1;
        $this->writeFooter($sheet, $items);

        $writer = new Xlsx($this->workbook);

        $tmpFile = bin2hex(random_bytes(16));
        @mkdir($this->tmpDir);
        $writer->save($this->tmpDir . '/' . $tmpFile);

        return 'https://' . $this->hostname . '/export/' . $this->routeName . '/' . $tmpFile . '/' . $this->outputFileName;
    }

    /**
     * Process the GET query to download previously generated spreasheet on disk
     */
    public function handle(ServerRequestInterface $request): ResponseInterface
    {
        // Read file from disk
        $tmpFile = $this->tmpDir . '/' . $request->getAttribute('key');

        if (!file_exists($tmpFile)) {
            return new Response\EmptyResponse(404);
        }

        $size = filesize($tmpFile);
        $output = fopen($tmpFile, 'rb');

        $response = new Response($output, 200, [

It seems like $output can also be of type false; however, parameter $body of Laminas\Diactoros\Response::__construct() does only seem to accept Psr\Http\Message\StreamInterface|resource|string, maybe add an additional type check?

            'Content-Type' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
            'Content-Disposition' => sprintf('attachment; filename=%s', $request->getAttribute('name')),
            'Access-Control-Expose-Headers' => 'Content-Disposition',
            'Expire' => 0,
            'Pragma' => 'public',
            'Content-Length' => $size,
        ]);

        return $response;
    }
}