From 98678a4ceae46a7488223de343abfb16712be72c Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Gertz?= Date: Wed, 9 Dec 2020 21:42:43 +0100 Subject: [PATCH] Cleanup findAllApplicantBySession --- Repository/UserRepository.php | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/Repository/UserRepository.php b/Repository/UserRepository.php index 8b490c4..9f112ee 100644 --- a/Repository/UserRepository.php +++ b/Repository/UserRepository.php @@ -102,22 +102,22 @@ class UserRepository extends \Doctrine\ORM\EntityRepository { } /** - * Find all user's pseudonym from session applications + * Find all applicant by session * - * @param $session The Session instance + * @param $session The Session */ - public function findAllPseudonymBySession($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 INNER JOIN RapsysAirBundle:User u WHERE u.id = a.user AND a.session = :session') + ->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, 'pseudonym', 'id'); + $ret = array_column($ret, 'id', 'pseudonym'); //Send result return $ret; -- 2.41.1