steevanb\EntityUtils\Repository\CountTrait

Complexity

Total Complexity

3

Size/Duplication

Total Lines	38
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
	createQueryBuilder()	0	1	?
A	countAll()	0	8	1
A	countBy()	0	12	2

<?php

namespace steevanb\EntityUtils\Repository;

use Doctrine\ORM\QueryBuilder;

trait CountTrait
{
    /**
     * @param string $alias
     * @param string $indexBy
     * @return QueryBuilder
     */
    abstract public function createQueryBuilder($alias, $indexBy = null);

    /**
     * @return int
     */
    public function countAll()
    {
        return $this
            ->createQueryBuilder('a')
            ->select('COUNT(a)')
            ->getQuery()
            ->getSingleScalarResult();
    }

    /**
     * @param array $criteria
     * @return int
     */
    public function countBy(array $criteria)
    {
        $queryBuilder = $this->createQueryBuilder('a')->select('COUNT(a)')
        ;
        foreach ($criteria as $name => $criterion) {
            $queryBuilder
                ->andWhere($name . ' = :criterion_' . $name)
                ->setParameter('criterion_' . $name, $criterion);
        }

        return $queryBuilder->getQuery()->getSingleScalarResult();
    }
}