/** * @param Section $section * @param \DateTime $start * @param \DateTime $end * * @return mixed */ public function getSectionsNewUsersBetweenDates(Section $section, \DateTime $start, \DateTime $end) { $qb = $this->createQueryBuilder('s'); $qb->leftJoin('s.users', 'u')->where($qb->expr()->eq('u.section', $section->getId()))->andWhere('u.joindate BETWEEN :start AND :end')->setParameter('start', $start->format('Y/m/d'))->setParameter('end', $end->format('Y/m/d')); return $qb->getQuery()->getResult(); }
/** * @param Section $section * @param $querybuilder * * @return \Doctrine\ORM\QueryBuilder|array */ public function getUniversitiesBySection(Section $section, $querybuilder = false) { $qb = $this->createQueryBuilder('uni'); $qb->where($qb->expr()->eq('uni.section', $section->getId()))->orderBy('uni.univercity', 'ASC'); return $querybuilder ? $qb : $qb->getQuery()->getResult(); }
public function findBCBysection(Section $section) { $qb = $this->createQueryBuilder('u'); $qb->where('u.roles LIKE :bc')->setParameter('bc', "%ROLE_BUDDYCOORDINATOR%")->andWhere($qb->expr()->eq('u.section', $section->getId())); return $qb->getQuery()->getResult(); }