QualityCode\ApiFeaturesBundle\Repository\PaginationAndSortingFeaturesTrait

Complexity

Total Complexity

8

Size/Duplication

Total Lines	79
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Test Coverage

Coverage

90.91%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
	createQueryBuilder()	0	1	?
	getClassMetadata()	0	1	?
A	findAllPaginated()	0	15	1
A	addOrderBy()	0	11	4
A	addSearchBy()	0	11	3

<?php

namespace QualityCode\ApiFeaturesBundle\Repository;

use Pagerfanta\Adapter\DoctrineORMAdapter;
use Pagerfanta\Pagerfanta;
use Doctrine\ORM\QueryBuilder;

trait PaginationAndSortingFeaturesTrait
{
    /**
     * Creates a new QueryBuilder instance that is prepopulated for this entity name.
     *
     * @param string $alias
     * @param string $indexBy The index for the from
     *
     * @return QueryBuilder
     */
    abstract public function createQueryBuilder($alias, $indexBy = null);

    /**
     * @return \Doctrine\ORM\Mapping\ClassMetadata
     */
    abstract protected function getClassMetadata();

    /**
     * @param int   $limit
     * @param int   $page
     * @param array $sorting
     * @param array $searching
     *
     * @return Pagerfanta
     */
    public function findAllPaginated($limit, $page, array $sorting = array(), array $searching = array())
    {
        $fields = array_keys($this->getClassMetadata()->fieldMappings);
        $queryBuilder = $this->createQueryBuilder('r');

        $queryBuilder = $this->addOrderBy($queryBuilder, $fields, $sorting);
        $queryBuilder = $this->addSearchBy($queryBuilder, $fields, $searching);

        $pagerAdapter = new DoctrineORMAdapter($queryBuilder);
        $pager = new Pagerfanta($pagerAdapter);
        $pager->setCurrentPage($page);
        $pager->setMaxPerPage($limit);

        return $pager;
    }

    /**
     * @param QueryBuilder $queryBuilder
     * @param array        $fields
     * @param array        $sorting
     *
     * @return QueryBuilder
     */
    protected function addOrderBy(QueryBuilder $queryBuilder, array $fields, array $sorting)
    {
        foreach ($fields as $field) {
            if (isset($sorting[$field])) {
                $direction = ($sorting[$field] === 'asc') ? 'asc' : 'desc';
                $queryBuilder->addOrderBy('r.'.$field, $direction);
            }
        }

        return $queryBuilder;
    }

    /**
     * @param QueryBuilder $queryBuilder
     * @param array        $fields
     * @param array        $searching
     *
     * @return QueryBuilder
     */
    protected function addSearchBy(QueryBuilder $queryBuilder, array $fields, array $searching)
    {
        foreach ($fields as $field) {
            if (isset($searching[$field])) {
                $queryBuilder->orWhere($queryBuilder->expr()->like('r.'.$field, ':'.$field));
                $queryBuilder->setParameter($field, '%'.$searching[$field].'%');
            }
        }

        return $queryBuilder;
    }
}