ebl Fix a bug in user edition

[bacula/bacula] / gui / bacula-web / report.php

diff --git a/gui/bacula-web/report.php b/gui/bacula-web/report.php
index 83eb921531b838abc8df75ac252ca42a981503fb..8dc2c163dc7706f61a900e2abbdecfd386762988 100644 (file)
--- a/gui/bacula-web/report.php
+++ b/gui/bacula-web/report.php
@@ -1,7 +1,7 @@
 <?
 /* 
 +-------------------------------------------------------------------------+
-| Copyright (C) 2004 Juan Luis Francés Jiménez                            |
+| Copyright (C) 2004-2005 Juan Luis Frances Jiminez                       |
 |                                                                         |
 | This program is free software; you can redistribute it and/or           |
 | modify it under the terms of the GNU General Public License             |
@@ -14,7 +14,7 @@
 | GNU General Public License for more details.                            |
 +-------------------------------------------------------------------------+ 
 */
-
+session_start();
 require ("paths.php");
 require($smarty_path."Smarty.class.php");
 include "classes.inc";
@@ -24,21 +24,21 @@ $smarty = new Smarty;
 //$smarty->compile_check = true;
 //$smarty->debugging = true;
 
-$smarty->template_dir  = "./templates";
-$smarty->compile_dir   = "./templates_c";
-$smarty->config_dir    = "./configs";
+$smarty->template_dir   = "./templates";
+$smarty->compile_dir    = "./templates_c";
+$smarty->config_dir     = "./configs";
 $smarty->config_load("bacula.conf");
 require("lang.php");
 
 $dbSql = new Bweb();
 
-if ( $_GET['default'] == 1) {                                                                                                  // Default params, 1 month
-       $dbSql->StartDate = strftime("%Y-%m-%d %H:%M:%S",time()-2678400);
-       $dbSql->EndDate = strftime("%Y-%m-%d %H:%M:%S",time());
+if ( $_GET['default'] == 1) {                                                                                                   // Default params, 1 month
+        $dbSql->StartDate = strftime("%Y-%m-%d %H:%M:%S",time()-2678400);
+        $dbSql->EndDate = strftime("%Y-%m-%d %H:%M:%S",time());
 }
-else                                                                                                                                           // With params
-       $dbSql->PrepareDate($_GET['StartDateMonth'],$_GET['StartDateDay'],$_GET['StartDateYear'],$_GET['EndDateMonth'],$_GET['EndDateDay'],$_GET['EndDateYear']);
-       
+else                                                                                                                                            // With params
+        $dbSql->PrepareDate($_GET['StartDateMonth'],$_GET['StartDateDay'],$_GET['StartDateYear'],$_GET['EndDateMonth'],$_GET['EndDateDay'],$_GET['EndDateYear']);
+        
 $bytes = $dbSql->CalculateBytesPeriod($_GET['server'],$dbSql->StartDate,$dbSql->EndDate);
 $files = $dbSql->CalculateFilesPeriod($_GET['server'],$dbSql->StartDate,$dbSql->EndDate);
 $smarty->assign('startperiod',$dbSql->StartDate);
@@ -48,14 +48,18 @@ $smarty->assign('filesperiod',$files);
 
 // Array with jobs data
 $a_jobs = array();
-$res_jobs = $dbSql->link->query("select *,SEC_TO_TIME( UNIX_TIMESTAMP(Job.EndTime)-UNIX_TIMESTAMP(Job.StartTime) ) as elapsed from Job where EndTime < '$dbSql->EndDate' and EndTime > '$dbSql->StartDate' and Name='$_GET[server]' order by EndTime")
-       or die("Error query row 50");
-       
+if ($dbSql->driver == "mysql")
+        $res_jobs = $dbSql->link->query("select *,SEC_TO_TIME( UNIX_TIMESTAMP(Job.EndTime)-UNIX_TIMESTAMP(Job.StartTime) ) as elapsed from Job where EndTime < '$dbSql->EndDate' and EndTime > '$dbSql->StartDate' and Name='$_GET[server]' order by EndTime")
+                or die("Error query row 50");
+else if ($dbSql->driver == "pgsql")
+        $res_jobs = $dbSql->link->query("select jobid as \"JobId\",job as \"Job\",name as \"Name\",type as \"Type\",level as \"Level\",clientid as \"ClientId\",jobstatus as \"JobStatus\",schedtime as \"SchedTime\",starttime as \"StartTime\",endtime as \"EndTime\",jobtdate as \"JobtDate\",volsessionid as \"VolSessionId\",volsessiontime as \"VolSessionTime\",jobfiles as \"JobFiles\",jobbytes as \"JobBytes\",joberrors as \"JobErrors\",jobmissingfiles as \"JobMissingFiles\",poolid as \"PoolId\",filesetid as \"FilesetId\",purgedfiles as \"PurgedFiles\",hasbase,Job.EndTime::timestamp-Job.StartTime::timestamp as elapsed from Job where EndTime < '$dbSql->EndDate' and EndTime > '$dbSql->StartDate' and Name='$_GET[server]' order by EndTime")
+                or die("Error query row 56");
+
 while ( $tmp = $res_jobs->fetchRow(DB_FETCHMODE_ASSOC) ) {
-       $tdate = explode (":",$tmp[elapsed]);                                                                           // Temporal "workaround" ;) Fix later
-       if ( $tdate[0] > 300000 )
-               $tmp[elapsed] = "00:00:00";
-       array_push($a_jobs,$tmp);
+        $tdate = explode (":",$tmp['elapsed']);                                                                           // Temporal "workaround" ;) Fix later
+        if ( $tdate[0] > 300000 )
+                $tmp['elapsed'] = "00:00:00";
+        array_push($a_jobs,$tmp);
 }
 $smarty->assign('jobs',$a_jobs);
 
@@ -63,7 +67,7 @@ $smarty->assign('jobs',$a_jobs);
 $res = $dbSql->link->query("select Name from Job group by Name");
 $a_jobs = array();
 while ( $tmp = $res->fetchRow() )
-       array_push($a_jobs, $tmp[0]);
+        array_push($a_jobs, $tmp[0]);
 $smarty->assign('total_name_jobs',$a_jobs);
 $res->free();
 $smarty->assign('time2',( (time())-2678400) );                                  // Current time - 1 month. <select> date
@@ -72,4 +76,3 @@ $smarty->assign('time2',( (time())-2678400) );
 
 $smarty->display('report.tpl');
 ?>
-