X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/6176927836d9b190c78d59e1a986b3e7ee79e065..98678a4ceae46a7488223de343abfb16712be72c:/Repository/UserRepository.php

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;