From 13030e545b0e0102a000ce234eb77645c022e108 Mon Sep 17 00:00:00 2001
From: Eric Bollengier <eric@eb.homelinux.org>
Date: Tue, 10 Jul 2007 13:18:11 +0000
Subject: [PATCH] ebl  Add a page to see Clients where not in a group

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@5141 91ce42f0-d328-0410-95d8-f526ca767f89
---
 gui/bweb/lang/es/tpl/display_groups.tpl |  5 +++++
 gui/bweb/lang/fr/tpl/display_groups.tpl |  5 +++++
 gui/bweb/lib/Bweb.pm                    | 10 +++++++++-
 gui/bweb/tpl/display_groups.tpl         |  5 +++++
 4 files changed, 24 insertions(+), 1 deletion(-)

diff --git a/gui/bweb/lang/es/tpl/display_groups.tpl b/gui/bweb/lang/es/tpl/display_groups.tpl
index 5959906f9e..592656e223 100644
--- a/gui/bweb/lang/es/tpl/display_groups.tpl
+++ b/gui/bweb/lang/es/tpl/display_groups.tpl
@@ -17,6 +17,11 @@
      src='/bweb/zoom.png'>&nbsp;
     <input type="image" name='action' value='group_stats' title='Estadísticas del groups' src='/bweb/chart.png'>&nbsp;
    </form>
+   <form action='?' method='get'>
+    <input type='hidden' name='action' value='client'>
+    <input type="image" name='notingroup' value='yes' title='View non-members'
+     src='/bweb/zoom.png'>&nbsp;
+   </form>
  </div>
 
 <script type="text/javascript" language="JavaScript">
diff --git a/gui/bweb/lang/fr/tpl/display_groups.tpl b/gui/bweb/lang/fr/tpl/display_groups.tpl
index 1e67bf4c7d..7d74c0b7fd 100644
--- a/gui/bweb/lang/fr/tpl/display_groups.tpl
+++ b/gui/bweb/lang/fr/tpl/display_groups.tpl
@@ -17,6 +17,11 @@
      src='/bweb/zoom.png'>&nbsp;
     <input type="image" name='action' value='group_stats' title='Statistiques sur le groupe' src='/bweb/chart.png'>&nbsp;
    </form>
+   <form action='?' method='get'>
+    <input type='hidden' name='action' value='client'>
+    <input type="image" name='notingroup' value='yes' title='Voir les clients sans groupe'
+     src='/bweb/zoom.png'>&nbsp;
+   </form>
  </div>
 
 <script type="text/javascript" language="JavaScript">
diff --git a/gui/bweb/lib/Bweb.pm b/gui/bweb/lib/Bweb.pm
index 77a013d48a..27fbb0b12f 100644
--- a/gui/bweb/lib/Bweb.pm
+++ b/gui/bweb/lib/Bweb.pm
@@ -1259,7 +1259,7 @@ sub display_clients
     my ($self) = @_;
 
     my $where='';
-    my $arg = $self->get_form("client", "qre_client", "jclient_groups");
+    my $arg = $self->get_form("client", "qre_client", "jclient_groups", "qnotingroup");
 
     if ($arg->{qre_client}) {
 	$where = "WHERE Name $self->{sql}->{MATCH} $arg->{qre_client} ";
@@ -1269,6 +1269,14 @@ sub display_clients
 	$where = "JOIN client_group_member ON (Client.ClientId = client_group_member.clientid) 
                   JOIN client_group USING (client_group_id)
                   WHERE client_group_name IN ($arg->{jclient_groups})";
+    } elsif ($arg->{qnotingroup}) {
+	$where =   "
+  WHERE NOT EXISTS
+   (SELECT 1 FROM client_group_member
+     WHERE Client.ClientId = client_group_member.ClientId
+   )
+";
+   
     }
 
     my $query = "
diff --git a/gui/bweb/tpl/display_groups.tpl b/gui/bweb/tpl/display_groups.tpl
index 3600d4094d..f678ce8e88 100644
--- a/gui/bweb/tpl/display_groups.tpl
+++ b/gui/bweb/tpl/display_groups.tpl
@@ -17,6 +17,11 @@
      src='/bweb/zoom.png'>&nbsp;
     <input type="image" name='action' value='group_stats' title='Statistics' src='/bweb/chart.png'>&nbsp;
    </form>
+   <form action='?' method='get'>
+    <input type='hidden' name='action' value='client'>
+    <input type="image" name='notingroup' value='yes' title='View non-members'
+     src='/bweb/zoom.png'>&nbsp;
+   </form>
  </div>
 
 <script type="text/javascript" language="JavaScript">
-- 
2.39.5