Newscoop\CommunityTickerBundle\Entity\Repository\CommunityTickerEventRepository::findByCount PHP Метод

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