From 91a0f1a7469dceef6a10b3422d440d5c1f5e48b4 Mon Sep 17 00:00:00 2001
From: Eric Bollengier <eric@eb.homelinux.org>
Date: Thu, 21 Jun 2007 20:58:45 +0000
Subject: [PATCH] ebl  Add a synthetic display_job_by_group view

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@5058 91ce42f0-d328-0410-95d8-f526ca767f89
---
 gui/bweb/cgi/bweb.pl                      | 16 +++++++
 gui/bweb/lang/es/tpl/display_form_job.tpl | 10 ++++-
 gui/bweb/lang/fr/tpl/display_form_job.tpl | 10 ++++-
 gui/bweb/lib/Bweb.pm                      | 53 +++++++++++++++++++++++
 gui/bweb/tpl/display_form_job.tpl         | 10 ++++-
 5 files changed, 96 insertions(+), 3 deletions(-)

diff --git a/gui/bweb/cgi/bweb.pl b/gui/bweb/cgi/bweb.pl
index 443b82f347..b6d1e97dfa 100755
--- a/gui/bweb/cgi/bweb.pl
+++ b/gui/bweb/cgi/bweb.pl
@@ -306,6 +306,22 @@ if ($action eq 'begin') {		# main display
 		       offset => $arg->{offset},
 		       limit => $arg->{limit});
     print "</td></tr></table></div>";
+} elsif ($action eq 'job_group') {
+
+    print "<div><table border='0'><tr><td valign='top'>\n";
+    my $fields = $bweb->get_form(qw/limit level age 
+                                    db_client_groups qclient_groups/); # drop this to hide 
+
+    $fields->{hide_status} = 1;
+    $fields->{hide_type} = 1;
+    $fields->{action} = 'job_group';
+
+    $bweb->display($fields, "display_form_job.tpl");
+
+    print "</td><td valign='top'>";
+    $bweb->display_job_group(age => $arg->{age},  # last 7 days
+			     limit => $arg->{limit});
+    print "</td></tr></table></div>";
 } elsif ($action eq 'client_stats') {
 
     foreach my $client (CGI::param('client')) {
diff --git a/gui/bweb/lang/es/tpl/display_form_job.tpl b/gui/bweb/lang/es/tpl/display_form_job.tpl
index 4d8c8a0628..fa49a45d48 100644
--- a/gui/bweb/lang/es/tpl/display_form_job.tpl
+++ b/gui/bweb/lang/es/tpl/display_form_job.tpl
@@ -16,6 +16,7 @@
     </select>     
   </td>
 </tr>
+<TMPL_UNLESS hide_status>
 <tr>
  <td valign='top'>
     <h2>Estado</h2>
@@ -28,6 +29,8 @@
     </select>     
   </td>
 </tr>
+</TMPL_UNLESS>
+<TMPL_IF db_pools>
 <tr>
  <td valign='top'>
     <h2>Pool</h2>
@@ -39,6 +42,7 @@
     </select>
   </td>
 </tr>
+</TMPL_IF>
 <tr>
   <td valign='top'>
     <h2>Tiempo</h2>
@@ -56,6 +60,7 @@
 	class='formulaire' size='4'>
   </td>
 </tr>
+<TMPL_UNLESS hide_type>
 <tr>
   <td valign='top'> 
     <h2>Tipo Job</h2>
@@ -66,6 +71,7 @@
     </select>
   </td>
 </tr>
+</TMPL_UNLESS>
 <TMPL_IF db_clients>
 <tr>
   <td valign='top'> 
@@ -103,7 +109,9 @@
 </tr>
 -->
 </table>
-  <input type="image" name='action' value='job' src='/bweb/update.png'>
+  <input type="image" name='action'
+         value='<TMPL_IF action><TMPL_VAR action><TMPL_ELSE>job</TMPL_IF>'
+         src='/bweb/update.png'>
 
 </form>
 </div>
diff --git a/gui/bweb/lang/fr/tpl/display_form_job.tpl b/gui/bweb/lang/fr/tpl/display_form_job.tpl
index a75ba9f584..d4bd3981b6 100644
--- a/gui/bweb/lang/fr/tpl/display_form_job.tpl
+++ b/gui/bweb/lang/fr/tpl/display_form_job.tpl
@@ -16,6 +16,7 @@
     </select>     
   </td>
 </tr>
+<TMPL_UNLESS hide_status>
 <tr>
  <td valign='top'>
     <h2>Statut</h2>
@@ -28,6 +29,8 @@
     </select>     
   </td>
 </tr>
+</TMPL_UNLESS>
+<TMPL_IF db_pools>
 <tr>
  <td valign='top'>
     <h2>Pool</h2>
@@ -39,6 +42,7 @@
     </select>
   </td>
 </tr>
+</TMPL_IF>
 <tr>
   <td valign='top'>
     <h2>P&eacute;riode</h2>
@@ -57,6 +61,7 @@
 	class='formulaire' size='4'>
   </td>
 </tr>
+<TMPL_UNLESS hide_type>
 <tr>
   <td valign='top'> 
     <h2>Type</h2>
@@ -67,6 +72,7 @@
     </select>
   </td>
 </tr>
+</TMPL_UNLESS>
 <TMPL_IF db_clients>
 <tr>
   <td valign='top'> 
@@ -92,7 +98,9 @@
 </tr>
 </TMPL_IF>
 </table>
-  <input type="image" name='action' value='job' src='/bweb/update.png'>
+  <input type="image" name='action'
+         value='<TMPL_IF action><TMPL_VAR action><TMPL_ELSE>job</TMPL_IF>'
+         src='/bweb/update.png'>
 
 </form>
 </div>
diff --git a/gui/bweb/lib/Bweb.pm b/gui/bweb/lib/Bweb.pm
index 96c6d11970..e9c4bdf082 100644
--- a/gui/bweb/lib/Bweb.pm
+++ b/gui/bweb/lib/Bweb.pm
@@ -2068,6 +2068,59 @@ WHERE Job.JobId = $jobid
     $self->display($row, "display_job_zoom.tpl");
 }
 
+sub display_job_group
+{
+    my ($self, %arg) = @_;
+
+    my ($limit, $label) = $self->get_limit(groupby => 'client_group_name',  %arg);
+
+    my ($where, undef) = $self->get_param('client_groups',
+					  'level',
+					  'pools');
+    
+    my $query = 
+"
+SELECT client_group_name AS client_group_name,
+       jobok.jobfiles  + joberr.jobfiles  AS jobfiles,
+       jobok.jobbytes  + joberr.jobbytes  AS jobbytes,
+       jobok.joberrors + joberr.joberrors AS joberrors,
+       jobok.nbjobs  AS nbjobok,
+       joberr.nbjobs AS nbjoberr
+
+FROM (
+    SELECT client_group_name AS client_group_name, COUNT(1) AS nbjobs, 
+           SUM(JobFiles) AS jobfiles, SUM(JobBytes) AS jobbytes, 
+           SUM(JobErrors) AS joberrors
+    FROM Job JOIN client_group_member ON (Job.ClientId = client_group_member.ClientId)
+             JOIN client_group USING (client_group_id)
+    
+    WHERE JobStatus = 'T'
+    $where
+    $limit
+) AS jobok LEFT JOIN
+
+(
+    SELECT client_group_name AS client_group_name, COUNT(1) AS nbjobs, 
+           SUM(JobFiles) AS jobfiles, SUM(JobBytes) AS jobbytes, 
+           SUM(JobErrors) AS joberrors
+    FROM Job JOIN client_group_member ON (Job.ClientId = client_group_member.ClientId)
+             JOIN client_group USING (client_group_id)
+    
+    WHERE JobStatus IN ('f','E', 'A')
+    $where
+    $limit
+) AS joberr USING (client_group_name)
+
+    ";
+
+    my $all = $self->dbh_selectall_hashref($query, 'client_group_name');
+
+    my $rep = { groups => [ values %$all ], age => $arg{age} };
+                
+    $self->debug($rep);
+    $self->display($rep, "display_job_group.tpl");
+}
+
 sub display_media
 {
     my ($self, %arg) = @_ ;
diff --git a/gui/bweb/tpl/display_form_job.tpl b/gui/bweb/tpl/display_form_job.tpl
index 7947819419..857796b8cf 100644
--- a/gui/bweb/tpl/display_form_job.tpl
+++ b/gui/bweb/tpl/display_form_job.tpl
@@ -16,6 +16,7 @@
     </select>     
   </td>
 </tr>
+<TMPL_UNLESS hide_status>
 <tr>
  <td valign='top'>
     <h2>Status</h2>
@@ -28,6 +29,8 @@
     </select>     
   </td>
 </tr>
+</TMPL_UNLESS>
+<TMPL_IF db_pools>
 <tr>
  <td valign='top'>
     <h2>Pool</h2>
@@ -39,6 +42,7 @@
     </select>
   </td>
 </tr>
+</TMPL_IF>
 <tr>
   <td valign='top'>
     <h2>Age</h2>
@@ -56,6 +60,7 @@
 	class='formulaire' size='4'>
   </td>
 </tr>
+<TMPL_UNLESS hide_type>
 <tr>
   <td valign='top'> 
     <h2>Job Type</h2>
@@ -66,6 +71,7 @@
     </select>
   </td>
 </tr>
+</TMPL_UNLESS>
 <TMPL_IF db_clients>
 <tr>
   <td valign='top'> 
@@ -103,7 +109,9 @@
 </tr>
 -->
 </table>
-  <input type="image" name='action' value='job' src='/bweb/update.png'>
+  <input type="image" name='action' 
+         value='<TMPL_IF action><TMPL_VAR action><TMPL_ELSE>job</TMPL_IF>'
+         src='/bweb/update.png'>
 
 </form>
 </div>
-- 
2.39.5