Artprima\QueryFilterBundle\Query\Mysql\PaginationWalker

Complexity

Total Complexity

3

Size/Duplication

Total Lines	28
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	walkSelectClause()	0	13	3

<?php declare(strict_types=1);

namespace Artprima\QueryFilterBundle\Query\Mysql;

use Doctrine\ORM\Query\SqlWalker;
use Doctrine\ORM\Query\AST\SelectClause;

/**
 * Class PaginationWalker
 *
 * @author Denis Voytyuk <ask@artprima.cz>
 */
class PaginationWalker extends SqlWalker
{
    /**
     * Walks down a SelectClause AST node, thereby generating the appropriate SQL.
     *
     * @param SelectClause $selectClause
     * @return string The SQL.
     *
     * Usage:
     *
     * <pre>
     * $query->setHint(DoctrineQuery::HINT_CUSTOM_OUTPUT_WALKER, PaginationWalker::class);
     * $query->setHint('mysqlWalker.sqlCalcFoundRows', true);
     * </pre>
     */
    public function walkSelectClause($selectClause): string
    {
        $sql = parent::walkSelectClause($selectClause);

        if ($this->getQuery()->getHint('mysqlWalker.sqlCalcFoundRows') === true) {
            if ($selectClause->isDistinct) {
                $sql = str_replace('SELECT DISTINCT', 'SELECT DISTINCT SQL_CALC_FOUND_ROWS', $sql);
            } else {
                $sql = str_replace('SELECT', 'SELECT SQL_CALC_FOUND_ROWS', $sql);
            }
        }

        return $sql;
    }
}