Replace hardcoded role by configurable key

[userbundle] / Repository / UserRepository.php

diff --git a/Repository/UserRepository.php b/Repository/UserRepository.php
index ec5ffa36837cdd122c8ad386d7963c3381260685..13dc2f0984618ffc24e2bbf8164712b403bce1c3 100644 (file)
--- a/Repository/UserRepository.php
+++ b/Repository/UserRepository.php
@@ -26,13 +26,13 @@ class UserRepository extends Repository implements PasswordUpgraderInterface {
        /**
         * Find user count as int
         *
        /**
         * Find user count as int
         *

-        * @return integer The keywords count
+        * @return integer The users count

         */
        public function findCountAsInt(): int {
                //Set the request
                $req = <<<SQL
 SELECT COUNT(u.id) AS count
         */
        public function findCountAsInt(): int {
                //Set the request
                $req = <<<SQL
 SELECT COUNT(u.id) AS count

-FROM RapsysUserBundle:User AS u
+FROM Rapsys\UserBundle\Entity\User AS u

 SQL;
 
                //Get result set mapping instance
 SQL;
 
                //Get result set mapping instance


@@ -76,11 +76,11 @@ FROM (
                u.mail,
                u.forename,
                u.surname,
                u.mail,
                u.forename,
                u.surname,

-               IFNULL(g.id, :guestid) AS g_id,
-               IFNULL(g.title, :guesttitle) AS g_title
-       FROM RapsysUserBundle:User AS u
-       LEFT JOIN RapsysUserBundle:UserGroup AS gu ON (gu.user_id = u.id)
-       LEFT JOIN RapsysUserBundle:Group AS g ON (g.id = gu.group_id)
+               g.id AS g_id,
+               g.title AS g_title
+       FROM Rapsys\UserBundle\Entity\User AS u
+       LEFT JOIN Rapsys\UserBundle\Entity\UserGroup AS gu ON (gu.user_id = u.id)
+       LEFT JOIN Rapsys\UserBundle\Entity\Group AS g ON (g.id = gu.group_id)

        ORDER BY NULL
        LIMIT 0, :limit
 ) AS t
        ORDER BY NULL
        LIMIT 0, :limit
 ) AS t


@@ -103,7 +103,6 @@ SQL;
                        ->addScalarResult('mail', 'mail', 'string')
                        ->addScalarResult('forename', 'forename', 'string')
                        ->addScalarResult('surname', 'surname', 'string')
                        ->addScalarResult('mail', 'mail', 'string')
                        ->addScalarResult('forename', 'forename', 'string')
                        ->addScalarResult('surname', 'surname', 'string')

-                       ->addScalarResult('g_id', 'g_id', 'integer')

                        ->addScalarResult('g_title', 'g_title', 'string');
 
                //Fetch result
                        ->addScalarResult('g_title', 'g_title', 'string');
 
                //Fetch result


@@ -119,7 +118,7 @@ SQL;
                //Process result
                foreach($res as $data) {
                        //Get translated group
                //Process result
                foreach($res as $data) {
                        //Get translated group

-                       $group = $this->translator->trans($data['g_title'], [], $this->alias);
+                       $group = $this->translator->trans($data['g_title']?:'Null', [], $this->alias);

 
                        //Init group subarray
                        if (!isset($ret[$group])) {
 
                        //Init group subarray
                        if (!isset($ret[$group])) {