3 require_once ("paths.php");
4 require_once ($smarty_path."Smarty.class.php");
5 require_once ("bweb.inc.php");
6 require_once ("config.inc.php");
8 $smarty = new Smarty();
13 // Smarty configuration
14 $smarty->compile_check = true;
15 $smarty->debugging = false;
16 $smarty->force_compile = true;
18 $smarty->template_dir = "./templates";
19 $smarty->compile_dir = "./templates_c";
20 $smarty->config_dir = "./configs";
27 $job_status = array( 'Any', 'Waiting', 'Running', 'Completed', 'Failed', 'Canceled' );
28 $smarty->assign( 'job_status', $job_status );
31 $jobs_per_page = array( 25,50,75,100,150 );
32 $smarty->assign( 'jobs_per_page', $jobs_per_page );
35 $job_level = array( 'D' => 'Diff', 'I' => 'Incr', 'F' => 'Full' );
37 $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 ";
38 $query .= "FROM Job ";
39 $query .= "LEFT JOIN Pool ON Job.PoolId=Pool.PoolId ";
40 $query .= "LEFT JOIN Status ON Job.JobStatus = Status.JobStatus ";
43 if( isset( $_POST['status'] ) ) {
44 switch( strtolower( $_POST['status'] ) )
47 $query .= "WHERE Job.JobStatus = 'R' ";
50 $query .= "WHERE Job.JobStatus IN ('F','S','M','m','s','j','c','d','t','C') ";
53 $query .= "WHERE Job.JobStatus = 'T' ";
56 $query .= "WHERE Job.JobStatus IN ('f','E') ";
59 $query .= "WHERE Job.JobStatus = 'A' ";
65 $query .= "ORDER BY Job.JobId DESC ";
67 // Determine how many jobs to display
68 if( isset($_POST['jobs_per_page']) )
69 $query .= "LIMIT " . $_POST['jobs_per_page'];
71 $query .= "LIMIT 25 ";
73 //echo $query . '<br />';
75 $jobsresult = $dbSql->db_link->query( $query );
77 if( PEAR::isError( $jobsresult ) ) {
78 echo "SQL query = $query <br />";
79 die("Unable to get last failed jobs from catalog" . $jobsresult->getMessage() );
81 while( $job = $jobsresult->fetchRow( DB_FETCHMODE_ASSOC ) ) {
83 // Determine icon for job status
84 switch( $job['JobStatus'] ) {
86 $job['Job_icon'] = "running.png";
89 $job['Job_icon'] = "s_ok.png";
94 $job['Job_icon'] = "s_error.gif";
106 $job['Job_icon'] = "waiting.png";
111 if( count($last_jobs) % 2)
112 $job['Job_classe'] = 'odd';
114 // Elapsed time for the job
115 if( $job['StartTime'] == '0000-00-00 00:00:00' )
116 $job['elapsed_time'] = 'N/A';
117 elseif( $job['EndTime'] == '0000-00-00 00:00:00' )
118 $job['elapsed_time'] = $dbSql->Get_ElapsedTime( strtotime($job['StartTime']), mktime() );
120 $job['elapsed_time'] = $dbSql->Get_ElapsedTime( strtotime($job['StartTime']), strtotime($job['EndTime']) );
123 $job['Level'] = $job_level[ $job['Level'] ];
126 $job['JobBytes'] = $dbSql->human_file_size( $job['JobBytes'] );
128 array_push( $last_jobs, $job);
131 $smarty->assign( 'last_jobs', $last_jobs );
134 if( isset( $_POST['status'] ) )
135 $total_jobs = $dbSql->CountJobs( ALL, $_POST['status'] );
137 $total_jobs = $dbSql->CountJobs( ALL );
139 $smarty->assign( 'total_jobs', $total_jobs );
141 // Process and display the template
142 $smarty->display('jobs.tpl');