Exemplos de Acme\UserBundle\Entity User::getPaidDayoffs em PHP

Exemplo n.º 1

Arquivo: UserRepository.php Projeto: Alex223124/edela

 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'];
 }