From: Raphaël Gertz <git@rapsys.eu>
Date: Wed, 9 Dec 2020 20:42:43 +0000 (+0100)
Subject: Cleanup findAllApplicantBySession
X-Git-Tag: 0.1.6~10
X-Git-Url: https://git.rapsys.eu/.gitweb.cgi/airbundle/commitdiff_plain/98678a4ceae46a7488223de343abfb16712be72c?ds=inline

Cleanup findAllApplicantBySession
---

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;