From c24b7b4d69f71b2c954db603a9d3d87315ef62a9 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Rapha=C3=ABl=20Gertz?= <git@rapsys.eu>
Date: Mon, 19 Oct 2020 09:47:47 +0200
Subject: [PATCH] Add findAllPseudonymBySession function

---
 Repository/UserRepository.php | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

diff --git a/Repository/UserRepository.php b/Repository/UserRepository.php
index 0d0ee4e..8b490c4 100644
--- a/Repository/UserRepository.php
+++ b/Repository/UserRepository.php
@@ -100,4 +100,26 @@ class UserRepository extends \Doctrine\ORM\EntityRepository {
 		//Send result
 		return $ret;
 	}
+
+	/**
+	 * Find all user's pseudonym from session applications
+	 *
+	 * @param $session The Session instance
+	 */
+	public function findAllPseudonymBySession($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')
+			->setParameter('session', $session)
+			->getResult();
+
+		//Process result
+		$ret = array_column($ret, 'pseudonym', 'id');
+
+		//Send result
+		return $ret;
+	}
 }
-- 
2.41.1