[Phpcompta-dev] r4178 - phpcompta/branches/rel560/include

[phpcompta-dev]

Author: danydb
Date: 2011-07-05 23:27:47 +0200 (Tue, 05 Jul 2011)
New Revision: 4178

Modified:
   phpcompta/branches/rel560/include/class_user.php
Log:
Fix bug : in parameter > extension all the users are seen

Modified: phpcompta/branches/rel560/include/class_user.php
===================================================================
--- phpcompta/branches/rel560/include/class_user.php    2011-07-05 21:27:16 UTC 
(rev 4177)
+++ phpcompta/branches/rel560/include/class_user.php    2011-07-05 21:27:47 UTC 
(rev 4178)
@@ -692,8 +692,11 @@
     {
         $sql="select distinct use_id,use_login,use_first_name,use_name from 
ac_users
              left outer join  jnt_use_dos using (use_id)
-             where
-             (dos_id=$1 or  use_admin=1) and use_active=1 order by 
use_login,use_name";
+            left join priv_user on (priv_jnt=jnt_id)
+              where
+              (dos_id=$1 or  use_admin=1) and use_active=1 and (use_admin=1 or 
priv_priv <> 'X') order by use_login,use_name";
+
+
         $repo=new Database();
         $array=$repo->get_array($sql,array($p_dossier));
         if ( $repo->size() == 0 ) throw new Exception ('Error inaccessible 
folder');