+
+ /**
+ * Find all applicant by session
+ *
+ * @param $session The Session
+ */
+ public function findAllApplicantBySession($session) {
+ //Get entity manager
+ $em = $this->getEntityManager();
+
+ //Fetch sessions
+ $ret = $this->getEntityManager()
+ ->createQuery('SELECT u.id, u.pseudonym FROM RapsysAirBundle:Application a JOIN RapsysAirBundle:User u WITH u.id = a.user WHERE a.session = :session')
+ ->setParameter('session', $session)
+ ->getResult();
+
+ //Process result
+ $ret = array_column($ret, 'id', 'pseudonym');
+
+ //Send result
+ return $ret;
+ }