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