From 5740445472d2828a647152b3de34bbabc15f98e5 Mon Sep 17 00:00:00 2001
From: Eric Bollengier <eric@eb.homelinux.org>
Date: Fri, 29 Jun 2007 15:20:44 +0000
Subject: [PATCH] ebl  fix pool view with more than one media type

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@5115 91ce42f0-d328-0410-95d8-f526ca767f89
---
 gui/bweb/lang/es/tpl/display_pool.tpl |  8 +++++++-
 gui/bweb/lang/fr/tpl/display_pool.tpl | 18 ++++++++++++------
 gui/bweb/lib/Bweb.pm                  | 11 ++++++++---
 gui/bweb/tpl/display_pool.tpl         |  8 +++++++-
 4 files changed, 34 insertions(+), 11 deletions(-)

diff --git a/gui/bweb/lang/es/tpl/display_pool.tpl b/gui/bweb/lang/es/tpl/display_pool.tpl
index e1d3fd74e2..b75a9bfdd8 100644
--- a/gui/bweb/lang/es/tpl/display_pool.tpl
+++ b/gui/bweb/lang/es/tpl/display_pool.tpl
@@ -17,7 +17,7 @@
 
 <script type="text/javascript" language="JavaScript">
 
-var header = new Array("Nombre","Reciclado","Retención","Use Duration",
+var header = new Array("Nombre","Media Type","Reciclado","Retención","Use Duration",
                        "Máx Jobs/Volumen","Máx Archivos/Volumen", 
                        "Máx Tamaño/Volumen","Nb volumes", "Estado Volumen", "Uso", "Selección");
 
@@ -46,10 +46,16 @@ chkbox.type  = 'radio';
 chkbox.value = '<TMPL_VAR Name>';
 chkbox.name  = 'pool';
 
+chkbox = document.createElement('INPUT');
+chkbox.type  = 'radio';
+chkbox.value = '<TMPL_VAR mediatype>';
+chkbox.name  = 'mediatype';
+
 img2 = percent_usage(<TMPL_VAR poolusage>);
 
 data.push( new Array(
 "<TMPL_VAR Name>",
+"<TMPL_VAR mediatype>",
 "<TMPL_VAR Recycle>",
 human_sec(<TMPL_VAR VolRetention>),
 human_sec(<TMPL_VAR VolUseDuration>),
diff --git a/gui/bweb/lang/fr/tpl/display_pool.tpl b/gui/bweb/lang/fr/tpl/display_pool.tpl
index fc5c5e5c99..c53a552182 100644
--- a/gui/bweb/lang/fr/tpl/display_pool.tpl
+++ b/gui/bweb/lang/fr/tpl/display_pool.tpl
@@ -17,9 +17,9 @@
 
 <script type="text/javascript" language="JavaScript">
 
-var header = new Array("Nom","Recyclage","Rétention","Durée d'utilisation",
-	               "Nb job maxi par média","Nb fichier maxi par média", 
-                       "Taille maxi d'un média","Nb volumes", "Statut", "Utilisation", "Sélection");
+var header = new Array("Nom","Type","Recyclage","Rétention","Durée d'utilisation",
+//	               "Nb job maxi par média","Nb fichier maxi par média","Taille maxi d'un média",
+	               "Nb volumes", "Statut", "Utilisation", "Sélection");
 
 var data = new Array();
 var chkbox;
@@ -46,16 +46,22 @@ chkbox.type  = 'radio';
 chkbox.value = '<TMPL_VAR Name>';
 chkbox.name  = 'pool';
 
+chkbox = document.createElement('INPUT');
+chkbox.type  = 'radio';
+chkbox.value = '<TMPL_VAR mediatype>';
+chkbox.name  = 'mediatype';
+
 img2 = percent_usage(<TMPL_VAR poolusage>);
 
 data.push( new Array(
 "<TMPL_VAR Name>",
+"<TMPL_VAR mediatype>",
 "<TMPL_VAR Recycle>",
 human_sec(<TMPL_VAR VolRetention>),
 human_sec(<TMPL_VAR VolUseDuration>),
-"<TMPL_VAR MaxVolJobs>",
-"<TMPL_VAR MaxVolFiles>",
-human_size(<TMPL_VAR MaxVolBytes>),
+//"<TMPL_VAR MaxVolJobs>",
+//"<TMPL_VAR MaxVolFiles>",
+//human_size(<TMPL_VAR MaxVolBytes>),
 "<TMPL_VAR VolNum>",
 img,
 img2,
diff --git a/gui/bweb/lib/Bweb.pm b/gui/bweb/lib/Bweb.pm
index c22078a936..85d3414431 100644
--- a/gui/bweb/lib/Bweb.pm
+++ b/gui/bweb/lib/Bweb.pm
@@ -1050,6 +1050,7 @@ our %sql_func = (
 	      STARTTIME_PDAY => " date_part('day', Job.StartTime) ",
 	      STARTTIME_PMONTH => " date_part('month', Job.StartTime) ",
 	      DB_SIZE => " SELECT pg_database_size(current_database()) ",
+	      CAT_POOL_TYPE => " MediaType || '_' || Pool.Name ",
 	  },
 	  mysql => {
 	      UNIX_TIMESTAMP => 'UNIX_TIMESTAMP',
@@ -1068,6 +1069,7 @@ our %sql_func = (
 	      DB_SIZE => " SELECT 0 ",
 	      # works only with mysql 5
 	      # DB_SIZE => " SELECT sum(DATA_LENGTH) FROM INFORMATION_SCHEMA.TABLES ",
+	      CAT_POOL_TYPE => " CONCAT(MediaType,'_',Pool.Name) ",
 	  },
 	 );
 
@@ -2798,7 +2800,9 @@ SELECT subq.volmax        AS volmax,
        Pool.MaxVolJobs    AS maxvoljobs,
        Pool.MaxVolFiles   AS maxvolfiles,
        Pool.MaxVolBytes   AS maxvolbytes,
-       subq.PoolId        AS PoolId
+       subq.PoolId        AS PoolId,
+       subq.MediaType     AS mediatype,
+       $self->{sql}->{CAT_POOL_TYPE}  AS uniq
 FROM
   (
     SELECT COALESCE(media_avg_size.volavg,0) * count(Media.MediaId) AS volmax,
@@ -2819,7 +2823,7 @@ LEFT JOIN Pool ON (Pool.PoolId = subq.PoolId)
 $whereW
 ";
 
-    my $all = $self->dbh_selectall_hashref($query, 'name') ;
+    my $all = $self->dbh_selectall_hashref($query, 'uniq') ;
 
     $query = "
 SELECT Pool.Name AS name,
@@ -2845,7 +2849,8 @@ GROUP BY Pool.Name;
 	$query = "
   SELECT VolStatus AS volstatus, count(MediaId) AS nb
     FROM Media 
-   WHERE PoolId=$p->{poolid} 
+   WHERE PoolId=$p->{poolid}
+     AND Media.MediaType = '$p->{mediatype}'
          $whereA
 GROUP BY VolStatus
 ";
diff --git a/gui/bweb/tpl/display_pool.tpl b/gui/bweb/tpl/display_pool.tpl
index 9891c83715..4f8e01fedd 100644
--- a/gui/bweb/tpl/display_pool.tpl
+++ b/gui/bweb/tpl/display_pool.tpl
@@ -17,7 +17,7 @@
 
 <script type="text/javascript" language="JavaScript">
 
-var header = new Array("Name","Recycle","Retention","Use Duration",
+var header = new Array("Name","Media Type", "Recycle","Retention","Use Duration",
                        "Max jobs per volume","Max files per volume", 
                        "Max volume size","Nb volumes", "Vol Status", "Usage", "Select");
 
@@ -46,10 +46,16 @@ chkbox.type  = 'radio';
 chkbox.value = '<TMPL_VAR Name>';
 chkbox.name  = 'pool';
 
+chkbox = document.createElement('INPUT');
+chkbox.type  = 'radio';
+chkbox.value = '<TMPL_VAR mediatype>';
+chkbox.name  = 'mediatype';
+
 img2 = percent_usage(<TMPL_VAR poolusage>);
 
 data.push( new Array(
 "<TMPL_VAR Name>",
+"<TMPL_VAR mediatype>",
 "<TMPL_VAR Recycle>",
 human_sec(<TMPL_VAR VolRetention>),
 human_sec(<TMPL_VAR VolUseDuration>),
-- 
2.39.5