/**
* {@inheritdoc}
*/
protected function getCountQueryBuilder(ListFilterInterface $filter = null)
{
$qb = $this->createQueryBuilder('e')->select('count(DISTINCT e.id)');
$access = $filter instanceof StockFilter ? $filter->getAccess() : null;
if ($access == 'mtnt') {
$date = new \DateTime();
$date->sub(new \DateInterval('P2M'));
return $qb->join('e.vials', 'v')->andWhere('v.setupDate > :date')->andWhere('v.trashed = false')->setParameter('date', $date->format('Y-m-d'));
}
return $qb;
}
