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";
23 $running_jobs = array();
25 $query = "SELECT Job.JobId, Job.JobStatus, Status.JobStatusLong, Job.Name, Job.StartTime, Job.EndTime, Job.Level, Pool.Name AS Pool_name ";
26 $query .= "FROM Job ";
27 $query .= "JOIN Status ON Job.JobStatus = Status.JobStatus ";
28 $query .= "LEFT JOIN Pool ON Job.PoolId = Pool.PoolId ";
29 $query .= "WHERE Job.JobStatus IN ('F','S','M','m','s','j','c','d','t','C','R')";
30 $query .= "ORDER BY JobId";
32 $jobsresult = $dbSql->db_link->query( $query );
34 if( PEAR::isError( $jobsresult ) ) {
35 echo "SQL query = $query <br />";
36 die("Unable to get last failed jobs from catalog" . $jobsresult->getMessage() );
38 while( $job = $jobsresult->fetchRow( DB_FETCHMODE_ASSOC ) ) {
43 if( $job['JobStatus'] == 'R') {
44 $elapsed = mktime() - strtotime($job['StartTime']);
46 $elapsed = date( "H:i:s", $elapsed );
47 elseif( $elapsed > 86400 )
48 $elapsed = date( "d day(s) i:s", $elapsed );
50 $elapsed = date( "i:s", $elapsed );
53 // Elapsed time for this job
54 if( $job['JobStatus'] == 'R' )
55 $job['elapsed_time'] = $dbSql->Get_ElapsedTime( strtotime($job['StartTime']), time() );
57 $job['elapsed_time'] = 'N/A';
60 if( count($running_jobs) % 2)
61 $job['Job_classe'] = 'odd';
63 array_push( $running_jobs, $job);
67 $smarty->assign( 'running_jobs', $running_jobs );
69 // Get the last jobs list
73 $query .= "SELECT Job.JobId, Job.Name AS Job_name, Job.StartTime, Job.EndTime, Job.Level, Pool.Name, Job.JobStatus, Pool.Name AS Pool_name, Status.JobStatusLong ";
74 $query .= "FROM Job ";
75 $query .= "LEFT JOIN Pool ON Job.PoolId=Pool.PoolId ";
76 $query .= "LEFT JOIN Status ON Job.JobStatus = Status.JobStatus ";
79 if( isset( $_POST['status'] ) ) {
80 switch( $_POST['status'] )
83 $query .= "WHERE Job.JobStatus = 'T' ";
86 $query .= "WHERE Job.JobStatus = 'f' ";
89 $query .= "WHERE Job.JobStatus = 'A' ";
94 $query .= "ORDER BY Job.EndTime DESC ";
96 // Determine how many jobs to display
97 if( isset($_POST['limit']) )
98 $query .= "LIMIT " . $_POST['limit'];
100 $query .= "LIMIT 20 ";
102 $jobsresult = $dbSql->db_link->query( $query );
104 if( PEAR::isError( $jobsresult ) ) {
105 echo "SQL query = $query <br />";
106 die("Unable to get last failed jobs from catalog" . $jobsresult->getMessage() );
108 while( $job = $jobsresult->fetchRow( DB_FETCHMODE_ASSOC ) ) {
109 // Determine icon for job
110 if( $job['JobStatus'] == 'T' )
111 $job['Job_icon'] = "s_ok.gif";
113 $job['Job_icon'] = "s_error.gif";
116 if( count($last_jobs) % 2)
117 $job['Job_classe'] = 'odd';
119 // Elapsed time for this job
120 $job['elapsed_time'] = $dbSql->Get_ElapsedTime( strtotime($job['StartTime']), strtotime($job['EndTime']) );
121 array_push( $last_jobs, $job);
124 $smarty->assign( 'last_jobs', $last_jobs );
126 if( isset( $_POST['status'] ) )
127 $total_jobs = $dbSql->CountJobs( ALL, $_POST['status'] );
129 $total_jobs = $dbSql->CountJobs( ALL );
131 $smarty->assign( 'total_jobs', $total_jobs );
133 // Process and display the template
134 $smarty->display('jobs.tpl');