Zikula\SearchModule\Entity\Repository\RepositoryGetResultsTrait::doGetPaginatedResults()

Complexity

Conditions	5
Paths	4

Size

Total Lines	25
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	0

<?php
    public function doGetPaginatedResults(
        QueryBuilder $qb,
        array $filters = [],
        array $sorting = [],
        int $page = 1,
        int $pageSize = 25
    ): PaginatorInterface {
        $alias = $qb->getRootAliases()[0];
        // add clauses for where
        if (count($filters) > 0) {
            $i = 1;
            foreach ($filters as $w_key => $w_value) {
                $qb->andWhere($qb->expr()->eq($alias . '.' . $w_key, '?' . $i))
                    ->setParameter($i, $w_value);
                $i++;
            }
        }
        // add clause for ordering
        if (count($sorting) > 0) {
            foreach ($sorting as $sort => $sortdir) {
                $qb->addOrderBy($alias . '.' . $sort, $sortdir);
            }
        }

        return (new Paginator($qb, $pageSize))->paginate($page);
    }