Add sql requests

[airbundle] / Repository / UserRepository.php

diff --git a/Repository/UserRepository.php b/Repository/UserRepository.php
index cc51ea088d565510b1a753dfb8722afdeddabcd1..9f112ee10e322ba2656ea393ad83bd0956ba809d 100644 (file)
--- a/Repository/UserRepository.php
+++ b/Repository/UserRepository.php
@@ -85,7 +85,7 @@ class UserRepository extends \Doctrine\ORM\EntityRepository {
                //Process result
                foreach($res as $data) {
                        //Get translated group
-                       $group = $translator->trans($data['g_title']?:'ROLE_USER');
+                       $group = $translator->trans($data['g_title']?:'User');
                        //Get translated title
                        $title = $translator->trans($data['t_short']);
                        //Init group subarray
@@ -100,4 +100,26 @@ class UserRepository extends \Doctrine\ORM\EntityRepository {
                //Send result
                return $ret;
        }
+
+       /**
+        * Find all applicant by session
+        *
+        * @param $session The 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 JOIN RapsysAirBundle:User u WITH u.id = a.user WHERE a.session = :session')
+                       ->setParameter('session', $session)
+                       ->getResult();
+
+               //Process result
+               $ret = array_column($ret, 'id', 'pseudonym');
+
+               //Send result
+               return $ret;
+       }
 }