Newscoop\Entity\Repository\AuditRepository::countBy PHP Метод

    public function countBy(array $criteria)
    {
        $queryBuilder = $this->getEntityManager()->createQueryBuilder()->select('COUNT(a)')->from($this->getEntityName(), 'a');
        foreach ($criteria as $property => $value) {
            if (!is_array($value)) {
                $queryBuilder->andWhere("a.{$property} = :{$property}");
            }
        }
        $query = $queryBuilder->getQuery();
        foreach ($criteria as $property => $value) {
            if (!is_array($value)) {
                $query->setParameter($property, $value);
            }
        }
        return (int) $query->getSingleScalarResult();
    }