AccountingReport::cellsToSum() - Code Metrics - Ecodev/my-ichtus - Measure and Improve Code Quality continuously with Scrutinizer

AccountingReport::cellsToSum() A
last analyzed 2025-06-19 12:49 UTC

↳ Parent: AccountingReport
Complexity

Conditions	4
Paths	1
Size

Total Lines	13
Code Lines	6
Duplication

Lines	0
Ratio	0 %
Code Coverage

Tests	8
CRAP Score	4
Importance

Changes
Metric	Value
eloc	6
dl	0
loc	13
ccs	8
cts	8
cp	1
rs	10
c	0
b	0
f	0
cc	4
nc	1
nop	3
crap	4
<?php

declare(strict_types=1);

namespace Application\Service\Exporter;

use Application\Enum\AccountType;
use Application\Model\Account;
use Cake\Chronos\ChronosDate;
use Ecodev\Felix\Api\Exception;
use Ecodev\Felix\Format;
use Money\Money;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Color;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\NumberFormat;
use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup;

/**
 * @extends AbstractExcel<Account>
 *
 * @phpstan-type Data array{
 *     account: ?Account,
 *     code: int | '',
 *     name: string,
 *     depth: int,
 *     balance: Money,
 *     balancePrevious: ?Money,
 *     budgetAllowed: ?Money,
 *     budgetBalance: ?Money,
 *     format?: array,
 *     formatPrevious?: array,
 * }
 */
class AccountingReport extends AbstractExcel
{
    private ChronosDate $date;

    private bool $showBudget = false;

    private ?ChronosDate $datePrevious = null;

    /**
     * @var Data[]
     */
    private array $assets = [];

    /**
     * @var Data[]
     */
    private array $liabilities = [];

    /**
     * @var Data[]
     */
    private array $expenses = [];

    /**
     * @var Data[]
     */
    private array $revenues = [];

    private static array $balanceFormat = [
        'fill' => [
            'fillType' => Fill::FILL_SOLID,
            'startColor' => [
                'argb' => 'FFDDDDDD',
            ],
        ],
        'numberFormat' => [
            'formatCode' => NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1, // eg. 12'345.67
        ],
    ];

    protected static array $ctrlFormat = [
        'font' => [
            'color' => [
                'bold' => false,
                'argb' => 'FF606060',
            ],
        ],
        'alignment' => ['wrapText' => true],
        'fill' => [
            'fillType' => Fill::FILL_SOLID,
            'startColor' => [
                'argb' => 'FFDDDDDD',
            ],
        ],
    ];

    private static array $wrappedFormat = [
        'alignment' => [
            'wrapText' => true,
        ],
    ];

    private static array $indentFormat = [
        'alignment' => [
            'horizontal' => Alignment::HORIZONTAL_LEFT,
            'indent' => 1,
        ],
    ];

    private static array $columnWidth = [
        'accountCode' => 14,
        'accountName' => 38,
        'balance' => 12,
    ];

    public function __construct(string $hostname, private readonly array $accountingConfig)
    {
        parent::__construct($hostname);

        $this->zebra = false;
        $this->autoFilter = false;
        $this->date = ChronosDate::today();

        $this->sheet->setTitle(_tr('Bilan') . ' & ' . _tr('Résultat'));
    }

    protected function getTitleForFilename(): string
    {
        return _tr('compta_rapport_%date%', ['date' => $this->date->format('Y-m-d')]);
    }

    public function setDate(ChronosDate $date): void
    {
        $this->date = $date;
    }

    public function setDatePrevious(?ChronosDate $datePrevious): void
    {
        $this->datePrevious = $datePrevious;
    }

    public function showBudget(bool $showBudget): void
    {
        $this->showBudget = $showBudget;
    }

    protected function writeTitle(): void
    {
        $this->column = 1;
        $this->sheet->mergeCells([$this->column, $this->row, $this->column + $this->getColspan(), $this->row]);
        $this->write(
            sprintf($this->hostname . ': rapport comptable au %s', $this->date->format('d.m.Y')),
            self::$titleFormat,
            self::$centerFormat
        );
        $this->sheet->getRowDimension($this->row)->setRowHeight(35);
        ++$this->row;
    }

    private function processAccount(Account $account, int $depth): void
    {
        $balance = $account->getBalanceAtDate($this->date);
        $balancePrevious = $this->datePrevious ? $account->getBalanceAtDate($this->datePrevious) : null;
        // Skip the account if:
        // - accounting is configured to hide accounts with zero balance
        // - AND account at report date has zero balance
        // - AND account at previous date has zero balance (but only if "show previous year" mode is enabled)
        if ($this->accountingConfig['report']['showAccountsWithZeroBalance'] === false && $depth > 1 && $balance->isZero() && (!$this->datePrevious || ($balancePrevious && $balancePrevious->isZero()))) {
            return;
        }

        if ($account->getType() === AccountType::Equity) {
            // Don't show special accounts since it's an interim statement, their balance will be computed manually
            return;
        }

        $data = [
            'code' => $account->getCode(),
            'name' => Format::truncate($account->getName(), 55),
            'depth' => $depth,
            'balance' => $balance,
            'balancePrevious' => $balancePrevious,
            'budgetAllowed' => $this->showBudget ? $account->getBudgetAllowed() : null,
            'budgetBalance' => $this->showBudget ? $account->getBudgetBalance() : null,
            'account' => $account,
        ];

        if ($this->isAccountType($account, AccountType::Asset)) {
            $this->assets[] = $data;
        } elseif ($this->isAccountType($account, AccountType::Liability)) {
            $this->liabilities[] = $data;
        } elseif ($this->isAccountType($account, AccountType::Revenue)) {
            $this->revenues[] = $data;
        } elseif ($this->isAccountType($account, AccountType::Expense)) {
            $this->expenses[] = $data;
        }

        if ($account->getType() === AccountType::Group && $depth <= $this->accountingConfig['report']['maxAccountDepth']) {
            foreach ($account->getChildren() as $child) {
                $this->processAccount($child, $depth + 1);
            }
        }
    }

    /**
     * @param Account $item
     */
    protected function writeItem($item): void
    {
        // This is unusual because we don't write anything but only collect data for later
        $this->processAccount($item, 1);
    }

    /**
     * Compute the profit or loss (at current and previous dates) and insert the result into the list of accounts.
     */
    private function insertProfitOrLoss(): void
    {
        $profitOrLoss = $this->getProfitOrLoss(false);

        if ($profitOrLoss->isZero()) {
            return; // If financial result is balanced, it likely a final accounting report so we don't show the intermediate result
        }

        $data = [
            'depth' => 1,
            'code' => '',
            'name' => _tr('Résultat intermédiaire (bénéfice / -perte)'),
            'account' => null,
            'balance' => $profitOrLoss, // can be positive of negative
            'balancePrevious' => null,
            'budgetAllowed' => null,
            'budgetBalance' => null,
            'format' => $this->color($profitOrLoss),
        ];

        if ($this->datePrevious) {
            $profitOrLossPrevious = $this->getProfitOrLoss(true);
            $data['balancePrevious'] = $profitOrLossPrevious;
            $data['formatPrevious'] = $this->color($profitOrLossPrevious);
        }

        // A profit is reported as a POSITIVE green number, and a loss is reported a NEGATIVE red number.
        // They are identical lines at the end of both LIABILITIES and EXPENSES columns
        $this->liabilities[] = $data;
        $this->expenses[] = $data;
    }

    /**
     * @param Data $data
     */
    private function maybeBold(array $data, int $untilDepth): array
    {
        return $data['depth'] <= $untilDepth ? ['font' => ['bold' => true]] : [];
    }

    private function realWrite(): void
    {
        $this->insertProfitOrLoss();

        /*
         * Page 1
         * BALANCE SHEET (Asset vs Liabilities)
         */

        $this->lastDataColumn = 1 + $this->getColspan();
        $this->column = $initialColumn = 1;

        $this->balanceSheetHeaders($initialColumn);

        // Assets
        $this->column = $initialColumn;
        $initialRow = $this->row;
        $this->lastDataRow = $this->row;
        $this->balanceSheet($initialColumn, $this->assets);

        // Liabilities
        $this->row = $initialRow;
        $this->column = $initialColumn = $initialColumn + $this->getColspan() / 2 + 1;
        $this->balanceSheet($initialColumn, $this->liabilities);

        $this->row = $this->lastDataRow + 1;
        $this->writeTotals($this->assets, $this->liabilities);

        $this->applyExtraFormatting(5);
        // set printing area for page 1
        $this->sheet->getPageSetup()->setPrintAreaByColumnAndRow(1, 1, $this->lastDataColumn, $this->lastDataRow, 0, 'I');

        /*
         * Page 2
         * INCOME STATEMENT (Profit vs Loss)
         */

        // start at the bottom of the balance sheet
        $this->row = $this->lastDataRow + 1;
        $this->column = $initialColumn = 1;
        $this->incomeStatementHeaders($initialColumn);

        // Expenses
        $initialRow = ++$this->row;
        $this->column = $initialColumn;
        $this->incomeStatement($initialColumn, $this->expenses);

        // Revenues
        $this->row = $initialRow;
        $this->column = $initialColumn = $initialColumn + $this->getColspan() / 2 + 1;
        $this->incomeStatement($initialColumn, $this->revenues);

        $this->row = $this->lastDataRow + 1;
        $this->writeTotals($this->expenses, $this->revenues);

        $this->applyExtraFormatting($initialRow);
        // set printing area for page 2
        $this->sheet->getPageSetup()->setPrintAreaByColumnAndRow(1, $initialRow - 3, $this->lastDataColumn, $this->lastDataRow + 1, 1, 'I');
    }

    private function getProfitOrLoss(bool $isPreviousDate): Money
    {
        // Sum the profit and loss root accounts
        $totalRevenues = $this->sumBalance($this->revenues, $isPreviousDate);

        $totalExpenses = $this->sumBalance($this->expenses, $isPreviousDate);

        return $totalRevenues->subtract($totalExpenses);
    }

    protected function finalize(string $path): void
    {
        // Once we collected all data, we can actually write them all
        $this->realWrite();

        // Print on A4 portrait, scale to full page width, variable height (depending on number of accounts)
        $pageSetup = $this->sheet->getPageSetup();
        $pageSetup->setOrientation(PageSetup::ORIENTATION_PORTRAIT);
        $pageSetup->setPaperSize(PageSetup::PAPERSIZE_A4);
        $pageSetup->setFitToWidth(1);
        $pageSetup->setFitToHeight(0);
        $pageSetup->setHorizontalCentered(true);
        $margins = $this->sheet->getPageMargins();
        $margins->setTop(0.5);
        $margins->setRight(0.2);
        $margins->setLeft(0.2);
        $margins->setBottom(0.5);

        parent::finalize($path);
    }

    // Insert a row with the control totals
    protected function writeTotals(array $accountsColumn1, array $accountsColumn2): void
    {
        $this->column = $this->firstDataColumn;
        foreach ([$accountsColumn1, $accountsColumn2] as $col => $accounts) {
            // Account.code
            $this->write(mb_strtoupper(_tr('Contrôle')));
            // Account.name
            $this->write('');
            // Account.balance
            $cellsToSum = $this->cellsToSum($accounts, 1);
            $this->write($cellsToSum ? '=SUM(' . implode(',', $cellsToSum) . ')' : '', self::$balanceFormat, self::$totalFormat);
            // Account previous balance (optional)
            if ($this->datePrevious) {
                $cellsToSum = $this->cellsToSum($accounts, 1, 'cellPrevious');
                $this->write($cellsToSum ? '=SUM(' . implode(',', $cellsToSum) . ')' : '', self::$balanceFormat, self::$totalFormat);
            }
            // Budget columns (optional)
            if ($this->showBudget) {
                $cellsToSum = $this->cellsToSum($accounts, 1, 'cellBudgetAllowed');
                $this->write($cellsToSum ? '=SUM(' . implode(',', $cellsToSum) . ')' : '', self::$balanceFormat, self::$totalFormat);
                $cellsToSum = $this->cellsToSum($accounts, 1, 'cellBudgetBalance');
                $this->write($cellsToSum ? '=SUM(' . implode(',', $cellsToSum) . ')' : '', self::$balanceFormat, self::$totalFormat);
            }
            if ($col === 0) {
                // Inner columns gap
                $this->write('');
            }
        }
        $this->lastDataRow = $this->row;
        // Apply style
        $range = Coordinate::stringFromColumnIndex($this->firstDataColumn) . $this->row . ':' . Coordinate::stringFromColumnIndex($this->column - 1) . $this->row;
        $this->sheet->getStyle($range)->applyFromArray(self::$ctrlFormat);
    }

    private function applyExtraFormatting(int $startRow): void
    {
        if ($this->datePrevious && !$this->showBudget) {
            $columnsToFormat = [3, 4, 8, 9];
        } elseif (!$this->datePrevious && $this->showBudget) {
            $columnsToFormat = [3, 4, 5, 9, 10, 11];
        } elseif ($this->datePrevious && $this->showBudget) {
            $columnsToFormat = [3, 4, 5, 6, 10, 11, 12, 13];
        } else {
            // Only current balance cols
            $columnsToFormat = [3, 7];
        }
        foreach ($columnsToFormat as $colIndex) {
            // Format balance numbers
            $range = Coordinate::stringFromColumnIndex($colIndex) . $startRow . ':' . Coordinate::stringFromColumnIndex($colIndex) . $this->lastDataRow;
            $this->sheet->getStyle($range)->applyFromArray(self::$balanceFormat);
        }

        // Increase row height since account names can wrap on multiple lines
        for ($r = $startRow; $r <= $this->lastDataRow; ++$r) {
            $this->sheet->getRowDimension($r)->setRowHeight(30);
        }
    }

    private function cellsToSum(array $data, int $depth, string $dataIndex = 'cell'): array
    {
        $equityAccountsClasses = $this->accountingConfig['report']['accountClasses']['equity'];
        $cells = array_reduce($data, function (array $carry, $data) use ($equityAccountsClasses, $depth, $dataIndex) {
            // We only sum accounts at the given depth, plus equity special accounts
            if (isset($data[$dataIndex]) && ($data['depth'] === $depth || in_array(mb_substr((string) $data['code'], 0, 1), $equityAccountsClasses, true))) {
                $carry[] = $data[$dataIndex];
            }

            return $carry;
        }, []);

        return $cells;
    }

    /**
     * Sum root or special accounts balance (for the profit and loss calculation)
     * - Root accounts have depth = 1
     * - Special accounts have code 7xxx, 8xxx, 9xxx.
     *
     * @param Data[] $data profits or expenses
     */
    private function sumBalance(array $data, bool $isPreviousDate): Money
    {
        $sum = array_reduce($data, function (Money $carry, $data) use ($isPreviousDate) {
            if ($data['depth'] === 1 || (int) mb_substr((string) $data['code'], 0, 1) > 6) {
                return $carry->add($isPreviousDate ? $data['balancePrevious'] : $data['balance']);
            }

            return $carry;
        }, Money::CHF(0));

        return $sum;
    }

    private function balanceSheetHeaders(int $initialColumn): void
    {
        $this->sheet->mergeCells([$this->column, $this->row, $this->column + $this->getColspan(), $this->row]);
        $this->write(
            _tr('Bilan'),
            self::$titleFormat,
            self::$centerFormat
        );
        $this->sheet->getRowDimension($this->row)->setRowHeight(40);
        ++$this->row;

        // Header line 1
        $headers = [
            ['label' => _tr('Actifs'), 'formats' => [self::$headerFormat, self::$centerFormat], 'colspan' => $this->getColspan() / 2],
            ['label' => '', 'width' => 3, 'formats' => []], // gap
            ['label' => _tr('Passifs'), 'formats' => [self::$headerFormat, self::$centerFormat], 'colspan' => $this->getColspan() / 2],
        ];
        $this->column = $initialColumn;
        $this->writeHeaders($headers);
        ++$this->row;

        // Header line 2: date(s) of balance
        $headers = [
            ['label' => '', 'colspan' => 2], // empty margin
            ['label' => $this->date->format('d.m.Y'), 'formats' => [self::$headerFormat, self::$centerFormat]], // current date
        ];
        if ($this->datePrevious) {
            $headers[] = ['label' => $this->datePrevious->format('d.m.Y'), 'formats' => [self::$headerFormat, self::$centerFormat]]; // previous date
        }
        if ($this->showBudget) {
            $headers[] = ['label' => _tr('Budget prévu'), 'formats' => [self::$headerFormat, self::$centerFormat]];
            $headers[] = ['label' => _tr('Budget restant'), 'formats' => [self::$headerFormat, self::$centerFormat]];
        }

        $headers[] = ['label' => '', 'formats' => []]; // gap
        $headers[] = ['label' => '', 'colspan' => 2]; // empty margin
        $headers[] = ['label' => $this->date->format('d.m.Y'), 'formats' => [self::$headerFormat, self::$centerFormat]]; // current date
        if ($this->datePrevious) {
            $headers[] = ['label' => $this->datePrevious->format('d.m.Y'), 'formats' => [self::$headerFormat, self::$centerFormat]]; // previous date
        }
        if ($this->showBudget) {
            $headers[] = ['label' => _tr('Budget prévu'), 'formats' => [self::$headerFormat, self::$centerFormat]];
            $headers[] = ['label' => _tr('Budget restant'), 'formats' => [self::$headerFormat, self::$centerFormat]];
        }

        $this->column = $initialColumn;
        $this->writeHeaders($headers);
        ++$this->row;
    }

    /**
     * @param Data[] $allData
     */
    private function balanceSheet(int $initialColumn, array &$allData): void
    {
        // Store coordinates (ie. E3) of the 2nd level account budget cells to later use in formula
        $budgetAllowedTotalCells = '';
        $budgetBalanceTotalCells = '';

        $firstLine = true;

        foreach ($allData as $index => $data) {
            // Column: account code
            if ($firstLine) {
                $this->sheet->getColumnDimensionByColumn($this->column)->setWidth(self::$columnWidth['accountCode']);
            }
            $maybeBold = $this->maybeBold($data, 2);
            if (!$firstLine && $maybeBold) {
                ++$this->row;
            }

            $this->write(
                str_repeat('  ', $data['depth'] - 1) . $data['code'],
                self::$indentFormat,
                $maybeBold
            );

            // Column: account name
            if ($firstLine) {
                $this->sheet->getColumnDimensionByColumn($this->column)->setWidth(self::$columnWidth['accountName']);
            }
            $this->write($data['name'], self::$wrappedFormat, $maybeBold);

            // Column: balance at date
            if ($firstLine) {
                $this->sheet->getColumnDimensionByColumn($this->column)->setWidth(self::$columnWidth['balance']);
            }
            // Store the coordinate of the cell to later compute totals
            $allData[$index]['cell'] = $this->sheet->getCell([$this->column, $this->row])->getCoordinate();
            $this->write($data['balance'], self::$balanceFormat, $maybeBold, $data['format'] ?? []);

            // Column: balance at previous date (optional)
            if ($this->datePrevious) {
                $allData[$index]['cellPrevious'] = $this->sheet->getCell([$this->column, $this->row])->getCoordinate();
                if ($firstLine) {
                    $this->sheet->getColumnDimensionByColumn($this->column)->setWidth(self::$columnWidth['balance']);
                }
                $this->write($data['balancePrevious'], $maybeBold, $data['formatPrevious'] ?? []);
            }

            // Budget columns (optional)
            if ($this->showBudget) {
                $allData[$index]['cellBudgetAllowed'] = $this->sheet->getCell([$this->column, $this->row])->getCoordinate();
                if ($firstLine) {
                    $this->sheet->getColumnDimensionByColumn($this->column)->setWidth(self::$columnWidth['balance']);
                    $budgetAllowedTotalCells = Coordinate::stringFromColumnIndex($this->column) . $this->row;
                }
                $this->write($data['budgetAllowed'] ?? '', self::$balanceFormat, $maybeBold);

                $allData[$index]['cellBudgetBalance'] = $this->sheet->getCell([$this->column, $this->row])->getCoordinate();
                if ($firstLine) {
                    $this->sheet->getColumnDimensionByColumn($this->column)->setWidth(self::$columnWidth['balance']);
                    $budgetBalanceTotalCells = Coordinate::stringFromColumnIndex($this->column) . $this->row;
                }
                $this->write($data['budgetBalance'] ?? '', self::$balanceFormat, $maybeBold);
            }

            $firstLine = false;
            ++$this->row;
            $this->column = $initialColumn;

            $this->lastDataRow = max($this->lastDataRow, $this->row);
        }

        // Compute the sum of budgets columns using an Excel formula
        // We don't do it for account balance, since the total of group accounts is computed in DB
        // Level 2 (= direct child accounts)
        if ($this->showBudget) {
            $cellsToSum = $this->cellsToSum($allData, 2, 'cellBudgetAllowed');
            if ($cellsToSum) {
                $this->sheet->setCellValue($budgetAllowedTotalCells, '=SUM(' . implode(',', $cellsToSum) . ')');
            }
            $cellsToSum = $this->cellsToSum($allData, 2, 'cellBudgetBalance');
            if ($cellsToSum) {
                $this->sheet->setCellValue($budgetBalanceTotalCells, '=SUM(' . implode(',', $cellsToSum) . ')');
            }
        }
    }

    private function getColspan(): int
    {
        $colspan = 6;
        if ($this->datePrevious) {
            $colspan += 2;
        }
        if ($this->showBudget) {
            $colspan += 4;
        }

        return $colspan;
    }

    private function incomeStatementHeaders(int $initialColumn): void
    {
        $this->sheet->mergeCells([$this->column, $this->row, $this->column + $this->getColspan(), $this->row]);
        $this->write(
            _tr('Compte de résultat'),
            self::$titleFormat,
            self::$centerFormat
        );
        $this->sheet->getRowDimension($this->row)->setRowHeight(40);
        ++$this->row;

        // Header line 1
        $headers = [
            ['label' => _tr('Charges'), 'formats' => [self::$headerFormat, self::$centerFormat], 'colspan' => $this->getColspan() / 2],
            ['label' => '', 'width' => 3, 'formats' => []], // gap
            ['label' => _tr('Profits'), 'formats' => [self::$headerFormat, self::$centerFormat], 'colspan' => $this->getColspan() / 2],
        ];
        $this->column = $initialColumn;
        $this->writeHeaders($headers);
        ++$this->row;

        // Header line 2: date(s) of balance
        $headers = [
            ['label' => '', 'colspan' => 2], // empty margin
            ['label' => $this->date->format('d.m.Y'), 'formats' => [self::$headerFormat, self::$centerFormat]], // current date
        ];
        if ($this->datePrevious) {
            $headers[] = ['label' => $this->datePrevious->format('d.m.Y'), 'formats' => [self::$headerFormat, self::$centerFormat]]; // previous date
        }
        if ($this->showBudget) {
            $headers[] = ['label' => _tr('Budget prévu'), 'formats' => [self::$headerFormat, self::$centerFormat]];
            $headers[] = ['label' => _tr('Budget restant'), 'formats' => [self::$headerFormat, self::$centerFormat]];
        }

        $headers[] = ['label' => '', 'formats' => []]; // gap
        $headers[] = ['label' => '', 'colspan' => 2]; // empty margin
        $headers[] = ['label' => $this->date->format('d.m.Y'), 'formats' => [self::$headerFormat, self::$centerFormat]]; // current date
        if ($this->datePrevious) {
            $headers[] = ['label' => $this->datePrevious->format('d.m.Y'), 'formats' => [self::$headerFormat, self::$centerFormat]]; // previous date
        }
        if ($this->showBudget) {
            $headers[] = ['label' => _tr('Budget prévu'), 'formats' => [self::$headerFormat, self::$centerFormat]];
            $headers[] = ['label' => _tr('Budget restant'), 'formats' => [self::$headerFormat, self::$centerFormat]];
        }

        $this->column = $initialColumn;
        $this->writeHeaders($headers);
        $this->sheet->getRowDimension($this->row)->setRowHeight(1.2, 'cm');
    }

    /**
     * @param Data[] $allData
     */
    private function incomeStatement(int $initialColumn, array &$allData): void
    {
        $firstLine = true;
        foreach ($allData as $index => $data) {
            // Column: account code
            $maybeBold = $this->maybeBold($data, 1);
            if (!$firstLine && $maybeBold) {
                ++$this->row;
            }

            $this->write(
                str_repeat('  ', $data['depth'] - 1) . $data['code'],
                self::$indentFormat,
                $maybeBold
            );

            // Column: account name
            $this->write($data['name'], self::$wrappedFormat, $maybeBold);

            // Column: balance at date
            // Store the coordinate of the cell to later compute totals
            $allData[$index]['cell'] = $this->sheet->getCell([$this->column, $this->row])->getCoordinate();
            $this->write($data['balance'], self::$balanceFormat, $maybeBold, $data['format'] ?? []);

            // Column: balance at previous date (optional)
            if ($this->datePrevious) {
                $allData[$index]['cellPrevious'] = $this->sheet->getCell([$this->column, $this->row])->getCoordinate();
                $this->write($data['balancePrevious'], $maybeBold, $data['formatPrevious'] ?? []);
            }

            // Budget columns (optional)
            if ($this->showBudget) {
                $allData[$index]['cellBudgetAllowed'] = $this->sheet->getCell([$this->column, $this->row])->getCoordinate();
                $this->write($data['budgetAllowed'] ?? '', self::$balanceFormat, $maybeBold);

                $allData[$index]['cellBudgetBalance'] = $this->sheet->getCell([$this->column, $this->row])->getCoordinate();
                $this->write($data['budgetBalance'] ?? '', self::$balanceFormat, $maybeBold);
            }

            ++$this->row;
            $this->column = $initialColumn;

            $this->lastDataRow = max($this->lastDataRow, $this->row);
            $firstLine = false;
        }
    }

    private function color(Money $profitOrLoss): array
    {
        return [
            'font' => [
                'color' => [
                    'argb' => $profitOrLoss->isPositive() ? Color::COLOR_DARKGREEN : Color::COLOR_RED,
                ],
            ],
        ];
    }

    private function isAccountType(Account $account, AccountType $accountType): bool
    {
        return $account->getType() === $accountType
            || (
                $account->getType() === AccountType::Group
                && $this->isCodeAccountType($account->getCode(), $accountType)
            );
    }

    private function isCodeAccountType(string|int $code, AccountType $accountType): bool
    {
        $accountClasses = $this->accountingConfig['report']['accountClasses'];
        $class = match ($accountType) {
            AccountType::Asset => $accountClasses['assets'],
            AccountType::Liability => $accountClasses['liabilities'],
            AccountType::Revenue => $accountClasses['revenues'],
            AccountType::Expense => $accountClasses['expenses'],
            default => throw new Exception('Non supported related account type: ' . $accountType->value),
        };

        return in_array(mb_substr((string) $code, 0, 1), $class, true);
    }
}

Ecodev / my-ichtus

AccountingReport::cellsToSum() A last analyzed 2025-06-19 12:49 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

AccountingReport::cellsToSum() A
last analyzed 2025-06-19 12:49 UTC
