From c24b7b4d69f71b2c954db603a9d3d87315ef62a9 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Rapha=C3=ABl=20Gertz?= 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