Bluz\Grid\Source\SelectSource::process()

Complexity

Conditions	2
Paths	2

Size

Total Lines	45
Code Lines	23

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	21
CRAP Score	2.0078

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function process(int $page, int $limit, array $filters = [], array $orders = []): Data
    {
        // process filters
        $this->applyFilters($filters);

        // process orders
        $this->applyOrders($orders);

        // process pages
        $this->getSource()->setLimit($limit);
        $this->getSource()->setPage($page);

        // prepare query
        $type = Proxy\Db::getOption('connect', 'type');

        if (strtolower($type) === 'mysql') {
            // MySQL
            $selectPart = $this->getSource()->getSelect();
            $selectPart[0] = 'SQL_CALC_FOUND_ROWS ' . $selectPart[0];

Are you sure $selectPart[0] of type array can be used in concatenation?

            $this->getSource()->select(...$selectPart);

$selectPart of type array is incompatible with the type string expected by parameter $select of Bluz\Db\Query\Select::select().

            $totalSql = 'SELECT FOUND_ROWS()';
        } else {
            // other
            $totalSource = clone $this->getSource();
            $totalSource->select('COUNT(*)');

            $totalSql = $totalSource->getSql();
        }

        $data = [];
        $total = 0;

        // run queries
        // use transaction to avoid errors
        Proxy\Db::transaction(
            function () use (&$data, &$total, $totalSql) {
                $data = $this->source->execute();
                $total = (int)Proxy\Db::fetchOne($totalSql);
            }
        );

        $gridData = new Data($data);
        $gridData->setTotal($total);
        return $gridData;
    }