-// generaldata.tpl & last_run_report.tpl (last24bytes)
-$client = $dbSql->link->query("select count(*) from Client")
- or die ("Error query: 1");
-$totalfiles = $dbSql->link->query("select count(FilenameId) from Filename")
- or die ("Error query: 2");
-if ( $dbSql->driver == "mysql")
- $last24bytes = $dbSql->link->query("select sum(JobBytes),count(*) from Job where Endtime <= NOW() and UNIX_TIMESTAMP(EndTime) > UNIX_TIMESTAMP(NOW())-86400")
- or die ("Error query: 3");
-if ( $dbSql->driver == "pgsql")
- $last24bytes = $dbSql->link->query("select sum(JobBytes),count(*) from Job where Endtime <= NOW() and EndTime > NOW() - 86400 * interval '1 second'")
- or die ("Error query: 3");
-$bytes_stored =& $dbSql->link->getOne("select SUM(VolBytes) from Media")
- or die ("Error query: 4");
-
-$smarty->assign('database_size', $dbSql->GetDbSize());
-$smarty->assign('bytes_stored',$bytes_stored);
-
-$tmp = $client->fetchRow();
-$smarty->assign('clientes_totales',$tmp[0]);
-
-$tmp = $last24bytes->fetchRow();
-/*if ( empty($tmp[0]) ) { // No data for last 24, search last 48
- if ( $dbSql->driver == "mysql" )
- $last24bytes = $dbSql->link->query("select sum(JobBytes) from Job where Endtime <= NOW() and UNIX_TIMESTAMP(EndTime) > UNIX_TIMESTAMP(NOW())-172800" );
- if ( $dbSql->driver == "pgsql")
- $last24bytes = $dbSql->link->query("select sum(JobBytes) from Job where Endtime <= NOW() and EndTime > NOW()-172800 * interval '1 second'" )
- or die ("Error query: 4.1");
- $smarty->assign('when',"yesterday");
- $tmp = $last24bytes->fetchRow();
-}*/
-
-$smarty->assign('bytes_totales',$tmp[0]);
-$smarty->assign('total_jobs', $tmp[1]);
-
-$tmp = $totalfiles->fetchRow();
-$smarty->assign('files_totales',$tmp[0]);
-
-$client->free();
-$totalfiles->free();
-$last24bytes->free();
-
-
-
-// report_select.tpl & last_run_report.tpl
-$res = $dbSql->link->query("select Name from Job group by Name");
-$a_jobs = array();
-while ( $tmp = $res->fetchRow() )
- array_push($a_jobs, $tmp[0]);
-$smarty->assign('total_name_jobs',$a_jobs);
-$smarty->assign('time2',( (time())-2678400) ); // Current time - 1 month. <select> date
-$res->free();
-
-// volumes.tpl
-$volumes = $dbSql->GetDataVolumes(); // Obtain array with info
-$pools = array_keys($volumes); // Extract Pools
-$smarty->assign('pools',$pools);
-$smarty->assign('volumes',$volumes);
-
-// last_run_report.tpl
-if ($mode == "Lite" && $_GET['Full_popup'] != "yes") {
- $tmp = array();
- if ( $dbSql->driver == "mysql" )
- $status = $dbSql->link->query("select JobId,Name,EndTime,JobStatus from Job where EndTime <= NOW() and UNIX_TIMESTAMP(EndTime) >UNIX_TIMESTAMP(NOW())-86400 and JobStatus!='T'" )
- or die ("Error: query at row 95");
- if ( $dbSql->driver == "pgsql" )
- $status = $dbSql->link->query("select JobId,Name,EndTime,JobStatus from Job where EndTime <= NOW() and EndTime >NOW() - 86400 * interval '1 second' and JobStatus!= 'T'")
- or die ( "Error: query at row 98" );
- $smarty->assign('status', $status->numRows());
- if ( $status->numRows() ) {
- while ( $res = $status->fetchRow() )
- array_push($tmp, $res);
- $smarty->assign('errors_array',$tmp);
- }
- $status->free();
-
- // Total Elapsed Time. Only for single Job.
- if ( $dbSql->driver == "mysql" )
- $ret = $dbSql->link->query("select UNIX_TIMESTAMP(EndTime)-UNIX_TIMESTAMP(StartTime) as elapsed from Job where EndTime <= NOW() and UNIX_TIMESTAMP(EndTime) > UNIX_TIMESTAMP(NOW())-84600")
- or die ("Error at row 110");
- if ( $dbSql->driver == "pgsql" )
- $ret = $dbSql->link->query("select EndTime - StartTime as elapsed from Job where EndTime <= NOW() and EndTime > NOW() - 84600 * interval '1 second'")
- or die ("Error at row 113");
- while ( $res = $ret->fetchRow() ) {
- if ( $TotalElapsed < 1000000000 ) // Temporal "workaround" ;) Fix later
- $TotalElapsed += $res[0];
- }
- if ($TotalElapsed > 86400) // More than 1 day!
- $TotalElapsed = gmstrftime("%d days %H:%M:%S", $TotalElapsed);
- else
- $TotalElapsed = gmstrftime("%H:%M:%S", $TotalElapsed);
- $smarty->assign('TotalElapsed',$TotalElapsed);
- $ret->free();
+// Get volumes list (volumes.tpl)
+$dbSql->tpl->assign('pools', $dbSql->GetVolumeList() );
+
+// Last 24 hours completed jobs number
+$dbSql->tpl->assign( 'completed_jobs', $dbSql->CountJobs( LAST_DAY, 'completed' ) );
+
+// Last 24 hours failed jobs number
+$dbSql->tpl->assign( 'failed_jobs', $dbSql->CountJobs( LAST_DAY, 'failed' ) );
+
+// Last 24 hours waiting jobs number
+$dbSql->tpl->assign( 'waiting_jobs', $dbSql->CountJobs( LAST_DAY, 'waiting' ) );
+
+// Last 24 hours elapsed time (last_run_report.tpl)
+//$smarty->assign( 'elapsed_jobs', $dbSql->Get_ElapsedTime_Job() );
+
+// Last 24 hours Job Levels
+$dbSql->tpl->assign( 'incr_jobs', $dbSql->CountJobsbyLevel( LAST_DAY, 'I') );
+$dbSql->tpl->assign( 'diff_jobs', $dbSql->CountJobsbyLevel( LAST_DAY, 'D') );
+$dbSql->tpl->assign( 'full_jobs', $dbSql->CountJobsbyLevel( LAST_DAY, 'F') );
+
+// Last 24 hours Job status graph
+$data = array();
+$status = array( 'completed', 'terminated_errors', 'failed', 'waiting', 'created', 'running', 'error' );
+
+foreach( $status as $job_status ) {
+ array_push( $data, $dbSql->GetJobsStatistics( $job_status ) );