public function getAvailableDayoffs(User $user) { $total = 0 + $user->getPaidDayoffs(); $used = $this->getEntityManager()->createQueryBuilder()->from('AcmeEdelaBundle:Dayoff', 'd')->select('COUNT(d) as cnt')->where('d.user = :user')->setParameter('user', $user)->andWhere('d.dateAt >= :date')->setParameter('date', (new \DateTime())->setTimeZone(new \DateTimeZone('+' . $user->getTimezone()))->modify('first day of this month')); $used = $used->getQuery()->getSingleResult(Query::HYDRATE_SCALAR); return $total - $used['cnt']; }