CountTrait::createQueryBuilder() - Code Metrics - steevanb/sf2-entity-utils - Measure and Improve Code Quality continuously with Scrutinizer

CountTrait::createQueryBuilder()
last analyzed 2017-03-15 09:14 UTC

↳ Parent: CountTrait

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	1
c	0
b	0
f	0
nc	1

<?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();
    }
}


1			<?php
2
3			namespace steevanb\EntityUtils\Repository;
4
5			use Doctrine\ORM\QueryBuilder;
6
7			trait CountTrait
8			{
9			/**
10			* @param string $alias
11			* @param string $indexBy
12			* @return QueryBuilder
13			*/
14			abstract public function createQueryBuilder($alias, $indexBy = null);
15
16			/**
17			* @return int
18			*/
19			public function countAll()
20			{
21			return $this
22			->createQueryBuilder('a')
23			->select('COUNT(a)')
24			->getQuery()
25			->getSingleScalarResult();
26			}
27
28			/**
29			* @param array $criteria
30			* @return int
31			*/
32			public function countBy(array $criteria)
33			{
34			$queryBuilder = $this->createQueryBuilder('a')->select('COUNT(a)')
35			;
36			foreach ($criteria as $name => $criterion) {
37			$queryBuilder
38			->andWhere($name . ' = :criterion_' . $name)
39			->setParameter('criterion_' . $name, $criterion);
40			}
41
42			return $queryBuilder->getQuery()->getSingleScalarResult();
43			}
44			}
45

steevanb / sf2-entity-utils

CountTrait::createQueryBuilder() last analyzed 2017-03-15 09:14 UTC

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

CountTrait::createQueryBuilder()
last analyzed 2017-03-15 09:14 UTC