public function findUsersBySection(Section $section) { return $this->createQueryBuilder('u')->where('u.section = :section')->setParameter('section', $section->getId())->orderBy('u.firstname, u.lastname', 'ASC')->getQuery()->getResult(); }
/** * Add a User * * @author Jeremie Samson <*****@*****.**> * * @param ModelUser $user */ protected function onSuccess(ModelUser $model, Section $section) { $user = new User(); $user->setEnabled(true); $user->setRandomPassword(); $user->setFirstname($model->getFirstname()); $user->setLastname($model->getLastname()); $user->setEmailgalaxy($model->getEmailGalaxy()); $user->setEmail($model->getEmail() ? $model->getEmail() : $model->getEmailGalaxy()); $user->setUsername($model->getEmailgalaxy()); $user->setMobile($model->getMobile()); $section->addUser($user); $this->em->persist($user); $this->em->flush(); }