<?php
+/*
++-------------------------------------------------------------------------+
+| Copyright 2010-2011, Davide Franco |
+| |
+| This program is free software; you can redistribute it and/or |
+| modify it under the terms of the GNU General Public License |
+| as published by the Free Software Foundation; either version 2 |
+| of the License, or (at your option) any later version. |
+| |
+| This program is distributed in the hope that it will be useful, |
+| but WITHOUT ANY WARRANTY; without even the implied warranty of |
+| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
+| GNU General Public License for more details. |
++-------------------------------------------------------------------------+
+*/
session_start();
- require_once ("paths.php");
- require_once ($smarty_path."Smarty.class.php");
- require_once ("bweb.inc.php");
- require_once ("config.inc.php");
+ include_once( 'config.inc.php' );
- $smarty = new Smarty();
$dbSql = new Bweb();
-
- require("lang.php");
-
- // Smarty configuration
- $smarty->compile_check = true;
- $smarty->debugging = false;
- $smarty->force_compile = true;
-
- $smarty->template_dir = "./templates";
- $smarty->compile_dir = "./templates_c";
- $smarty->config_dir = "./configs";
-
- // Running jobs
- $running_jobs = array();
-
- $query = "SELECT Job.JobId, Job.JobStatus, Status.JobStatusLong, Job.Name, Job.StartTime, Job.Level, Pool.Name AS Pool_name ";
- $query .= "FROM Job ";
- $query .= "JOIN Status ON Job.JobStatus = Status.JobStatus ";
- $query .= "LEFT JOIN Pool ON Job.PoolId = Pool.PoolId ";
- $query .= "WHERE Job.JobStatus IN ('F','S','M','m','s','j','c','d','t','C','R')";
-
- $jobsresult = $dbSql->db_link->query( $query );
-
- if( PEAR::isError( $jobsresult ) ) {
- echo "SQL query = $query <br />";
- die("Unable to get last failed jobs from catalog" . $jobsresult->getMessage() );
- }else {
- while( $job = $jobsresult->fetchRow( DB_FETCHMODE_ASSOC ) ) {
- $elapsed = 'N/A';
-
- if( $job['JobStatus'] == 'R') {
- $elapsed = mktime() - strtotime($job['StartTime']);
- if( $elapsed > 3600 )
- $elapsed = date( "H:i:s", $elapsed );
- elseif( $elapsed > 86400 )
- $elapsed = date( "d day(s) i:s", $elapsed );
- else
- $elapsed = date( "i:s", $elapsed );
- }
- $job['elapsed_time'] = $elapsed;
-
- array_push( $running_jobs, $job);
- }
- }
-
- $smarty->assign( 'running_jobs', $running_jobs );
-
- // Get the last jobs list
- $query = "";
- $last_jobs = array();
-
- switch( $dbSql->driver )
- {
- case 'mysql':
- $query = "SELECT SEC_TO_TIME( UNIX_TIMESTAMP(Job.EndTime)-UNIX_TIMESTAMP(Job.StartTime) ) AS elapsed, ";
- break;
- case 'pgsql':
- $query = "SELECT (Job.EndTime - Job.StartTime ) AS elapsed, ";
- break;
- }
-
- $query .= "Job.JobId, Job.Name AS Job_name, Job.StartTime, Job.EndTime, Job.Level, Pool.Name, Job.JobStatus, Pool.Name AS Pool_name, Status.JobStatusLong ";
+ // Jobs list
+ $query = "";
+ $last_jobs = array();
+
+ // Job Status list
+ define( 'STATUS_ALL', 0 );
+ define( 'STATUS_RUNNING', 1 );
+ define( 'STATUS_WAITING', 2 );
+ define( 'STATUS_COMPLETED', 3 );
+ define( 'STATUS_FAILED', 4 );
+ define( 'STATUS_CANCELED', 5 );
+
+ $job_status = array( STATUS_ALL => 'All',
+ STATUS_RUNNING => 'Running',
+ STATUS_WAITING => 'Waiting',
+ STATUS_COMPLETED => 'Completed',
+ STATUS_FAILED => 'Failed',
+ STATUS_CANCELED => 'Canceled' );
+
+ $dbSql->tpl->assign( 'job_status', $job_status );
+
+ // Global variables
+ $job_level = array( 'D' => 'Diff', 'I' => 'Incr', 'F' => 'Full' );
+
+ $query .= "SELECT Job.JobId, Job.Name AS Job_name, Job.StartTime, Job.EndTime, Job.Level, Job.JobBytes, Job.JobFiles, Pool.Name, Job.JobStatus, Pool.Name AS Pool_name, Status.JobStatusLong ";
$query .= "FROM Job ";
$query .= "LEFT JOIN Pool ON Job.PoolId=Pool.PoolId ";
$query .= "LEFT JOIN Status ON Job.JobStatus = Status.JobStatus ";
// Filter by status
if( isset( $_POST['status'] ) ) {
- switch( $_POST['status'] )
+ switch( $_POST['status'] )
{
- case 'completed':
- $query .= "WHERE Job.JobStatus = 'T' ";
+ case STATUS_RUNNING:
+ $query .= "WHERE Job.JobStatus = 'R' ";
+ break;
+ case STATUS_WAITING:
+ $query .= "WHERE Job.JobStatus IN ('F','S','M','m','s','j','c','d','t','p','C') ";
break;
- case 'failed':
+ case STATUS_COMPLETED:
+ $query .= "WHERE Job.JobStatus IN ('T', 'E') ";
+ break;
+ case STATUS_FAILED:
$query .= "WHERE Job.JobStatus = 'f' ";
break;
- case 'canceled':
+ case STATUS_CANCELED:
$query .= "WHERE Job.JobStatus = 'A' ";
break;
}
+ $dbSql->tpl->assign('job_status_filter', $_POST['status'] );
}
- $query .= "ORDER BY Job.EndTime DESC ";
+ // order by
+ $query .= "ORDER BY Job.JobId DESC ";
+ // Jobs per page
+ $jobs_per_page = array( 25 => '25', 50 => '50', 75 => '75', 100 => '100', 150 => '150' );
+
// Determine how many jobs to display
- if( isset($_POST['limit']) )
- $query .= "LIMIT " . $_POST['limit'];
- else
- $query .= "LIMIT 20 ";
+ if( isset($_POST['jobs_per_page']) ) {
+ $query .= "LIMIT " . $_POST['jobs_per_page'];
+ $dbSql->tpl->assign( 'jobs_per_page_selected', $_POST['jobs_per_page'] );
+ }else
+ $query .= "LIMIT 25 ";
+ $dbSql->tpl->assign( 'jobs_per_page', $jobs_per_page );
$jobsresult = $dbSql->db_link->query( $query );
- //var_dump( $_POST );
-
if( PEAR::isError( $jobsresult ) ) {
- echo "SQL query = $query <br />";
- die("Unable to get last failed jobs from catalog" . $jobsresult->getMessage() );
+ $dbSql->TriggerDBError( "Unable to get last failed jobs from catalog", $jobresult );
}else {
while( $job = $jobsresult->fetchRow( DB_FETCHMODE_ASSOC ) ) {
- // Determine icon for job
- if( $job['JobStatus'] == 'T' )
- $job['Job_icon'] = "s_ok.gif";
- else
- $job['Job_icon'] = "s_error.gif";
+
+ // Determine icon for job status
+ switch( $job['jobstatus'] ) {
+ case J_RUNNING:
+ $job['Job_icon'] = "running.png";
+ break;
+ case J_COMPLETED:
+ $job['Job_icon'] = "ok.png";
+ break;
+ case J_CANCELED:
+ $job['Job_icon'] = "canceled.png";
+ break;
+ case J_COMPLETED_ERROR:
+ $job['Job_icon'] = "warning.png";
+ break;
+ case J_FATAL:
+ $job['Job_icon'] = "error.png";
+ break;
+ case J_WAITING_CLIENT:
+ case J_WAITING_SD:
+ case J_WAITING_MOUNT_MEDIA:
+ case J_WAITING_NEW_MEDIA:
+ case J_WAITING_STORAGE_RES:
+ case J_WAITING_JOB_RES:
+ case J_WAITING_CLIENT_RES:
+ case J_WAITING_MAX_JOBS:
+ case J_WAITING_START_TIME:
+ case J_NOT_RUNNING:
+ $job['Job_icon'] = "waiting.png";
+ break;
+ } // end switch
// Odd or even row
if( count($last_jobs) % 2)
$job['Job_classe'] = 'odd';
-
+
+ // Elapsed time for the job
+ $start = $job['starttime'];
+ $end = $job['endtime'];
+
+ // Job execution execution time
+ $job['elapsed_time'] = CTimeUtils::Get_Elapsed_Time( $start, $end);
+ // Job Level
+ $job['Level'] = $job_level[ $job['level'] ];
+ // Job Size
+ $job['jobbytes'] = CUtils::Get_Human_Size( $job['jobbytes'] );
+
array_push( $last_jobs, $job);
}
}
- $smarty->assign( 'last_jobs', $last_jobs );
+ $dbSql->tpl->assign( 'last_jobs', $last_jobs );
+ // Count jobs
if( isset( $_POST['status'] ) )
$total_jobs = $dbSql->CountJobs( ALL, $_POST['status'] );
else
$total_jobs = $dbSql->CountJobs( ALL );
- $smarty->assign( 'total_jobs', $total_jobs );
+ $dbSql->tpl->assign( 'total_jobs', $total_jobs );
// Process and display the template
- $smarty->display('jobs.tpl');
+ $dbSql->tpl->display('jobs.tpl');
?>
projects / bacula / bacula / blobdiff