From d6efb578186f1b0277533516ad5d18fcfe1e7d34 Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Sat, 19 Mar 2011 19:35:06 +0100
Subject: [PATCH] Lists xnet accounts without any group.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Stéphane Jacob <sj@m4x.org>
---
 modules/admin.php         | 11 +++++++++++
 templates/admin/index.tpl |  2 ++
 2 files changed, 13 insertions(+)

diff --git a/modules/admin.php b/modules/admin.php
index 2daedea..7d4923a 100644
--- a/modules/admin.php
+++ b/modules/admin.php
@@ -51,6 +51,7 @@ class AdminModule extends PLModule
             'admin/accounts'               => $this->make_hook('accounts',               AUTH_MDP, 'admin'),
             'admin/account/watch'          => $this->make_hook('account_watch',          AUTH_MDP, 'admin'),
             'admin/account/types'          => $this->make_hook('account_types',          AUTH_MDP, 'admin'),
+            'admin/xnet_without_group'     => $this->make_hook('xnet_without_group',     AUTH_MDP, 'admin'),
             'admin/jobs'                   => $this->make_hook('jobs',                   AUTH_MDP, 'admin,edit_directory'),
             'admin/profile'                => $this->make_hook('profile',                AUTH_MDP, 'admin,edit_directory')
         );
@@ -1698,6 +1699,16 @@ class AdminModule extends PLModule
                                              ORDER BY  a.hruid'));
     }
 
+    function handler_xnet_without_group($page)
+    {
+        $page->changeTpl('admin/xnet_without_group.tpl');
+        $page->assign('accounts', XDB::iterator('SELECT  a.hruid, a.state
+                                                   FROM  accounts      AS a
+                                              LEFT JOIN  group_members AS m ON (a.uid = m.uid)
+                                                  WHERE  a.type = \'xnet\' AND m.uid IS NULL
+                                               ORDER BY  a.state, a.hruid'));
+    }
+
     function handler_jobs($page, $id = -1)
     {
         $page->changeTpl('admin/jobs.tpl');
diff --git a/templates/admin/index.tpl b/templates/admin/index.tpl
index d937e5e..0c01066 100644
--- a/templates/admin/index.tpl
+++ b/templates/admin/index.tpl
@@ -106,6 +106,8 @@
     <td>
       <a href="admin/dead-but-active">Décédés actifs</a>
       &nbsp;&nbsp;|&nbsp;&nbsp;
+      <a href="admin/xnet_without_group">Comptes xnet sans groupe</a>
+      &nbsp;&nbsp;|&nbsp;&nbsp;
       <a href="admin/account/watch">Administrateurs/Désactivations</a>
       &nbsp;&nbsp;|&nbsp;&nbsp;
       <a href="admin/googleapps">Google Apps</a>
-- 
2.1.4