X-Git-Url: https://git.rapsys.eu/userbundle/blobdiff_plain/ac82424b6b1631f6b224d171a97d48d57be842b9..23944f72bf54cef447e2034434e1c5df303f3083:/Repository/UserRepository.php

diff --git a/Repository/UserRepository.php b/Repository/UserRepository.php
index 85dad14..6cb6cc3 100644
--- a/Repository/UserRepository.php
+++ b/Repository/UserRepository.php
@@ -32,7 +32,7 @@ class UserRepository extends Repository implements PasswordUpgraderInterface {
 		//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
@@ -76,11 +76,11 @@ FROM (
 		u.mail,
 		u.forename,
 		u.surname,
-		IFNULL(g.id, 0) AS g_id,
-		IFNULL(g.title, :defaultgroup) 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
@@ -118,7 +118,7 @@ SQL;
 		//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])) {