git.sur5r.net Git - bacula/bacula/blob - gui/bacula-web/jobs.php

   1 <?php
   2 /*
   3 +-------------------------------------------------------------------------+
   4 | Copyright 2010-2011, Davide Franco                                              |
   5 |                                                                         |
   6 | This program is free software; you can redistribute it and/or           |
   7 | modify it under the terms of the GNU General Public License             |
   8 | as published by the Free Software Foundation; either version 2          |
   9 | of the License, or (at your option) any later version.                  |
  10 |                                                                         |
  11 | This program is distributed in the hope that it will be useful,         |
  12 | but WITHOUT ANY WARRANTY; without even the implied warranty of          |
  13 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the           |
  14 | GNU General Public License for more details.                            |
  15 +-------------------------------------------------------------------------+
  16 */
  17   session_start();
  18   include_once( 'config/global.inc.php' );
  19
  20   $dbSql = new Bweb();
  21   // Jobs list
  22   $query            = "";
  23   $last_jobs    = array();
  24
  25   // Job Status list
  26   define( 'STATUS_ALL',           0 );
  27   define( 'STATUS_RUNNING',   1 );
  28   define( 'STATUS_WAITING',   2 );
  29   define( 'STATUS_COMPLETED', 3 );
  30   define( 'STATUS_FAILED',        4 );
  31   define( 'STATUS_CANCELED',  5 );
  32
  33   $job_status = array( STATUS_ALL       => 'All',
  34                                            STATUS_RUNNING   => 'Running',
  35                                            STATUS_WAITING   => 'Waiting',
  36                                            STATUS_COMPLETED => 'Completed',
  37                                            STATUS_FAILED        => 'Failed',
  38                                            STATUS_CANCELED      => 'Canceled' );
  39
  40   $dbSql->tpl->assign( 'job_status', $job_status );
  41
  42   // Global variables
  43   $job_level = array( 'D' => 'Diff', 'I' => 'Incr', 'F' => 'Full' );
  44
  45   $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 ";
  46   $query .= "FROM Job ";
  47   $query .= "LEFT JOIN Pool ON Job.PoolId=Pool.PoolId ";
  48   $query .= "LEFT JOIN Status ON Job.JobStatus = Status.JobStatus ";
  49
  50   // Filter by status
  51   if( isset( $_POST['status'] ) ) {
  52         switch( $_POST['status'] )
  53         {
  54                 case STATUS_RUNNING:
  55                         $query .= "WHERE Job.JobStatus = 'R' ";
  56                 break;
  57                 case STATUS_WAITING:
  58                         $query .= "WHERE Job.JobStatus IN ('F','S','M','m','s','j','c','d','t','p','C') ";
  59                 break;
  60                 case STATUS_COMPLETED:
  61                         $query .= "WHERE Job.JobStatus = 'T' ";
  62                 break;
  63                 case STATUS_FAILED:
  64                         $query .= "WHERE Job.JobStatus IN ('f', 'E') ";
  65                 break;
  66                 case STATUS_CANCELED:
  67                         $query .= "WHERE Job.JobStatus = 'A' ";
  68                 break;
  69         }
  70     $dbSql->tpl->assign('job_status_filter', $_POST['status'] );
  71   }
  72
  73   // order by
  74   $query .= "ORDER BY Job.JobId DESC ";
  75
  76   // Jobs per page
  77   $jobs_per_page = array( 25 => '25', 50 => '50', 75 => '75', 100 => '100', 150 => '150' );
  78
  79   // Determine how many jobs to display
  80   if( isset($_POST['jobs_per_page']) ) {
  81         $query .= "LIMIT " . $_POST['jobs_per_page'];
  82     $dbSql->tpl->assign( 'jobs_per_page_selected', $_POST['jobs_per_page'] );
  83   }else
  84         $query .= "LIMIT 25 ";
  85   $dbSql->tpl->assign( 'jobs_per_page', $jobs_per_page );
  86
  87   try {
  88         $jobsresult = $dbSql->db_link->runQuery( $query );
  89
  90         if( !is_a($jobsresult,'CDBResult') ) {
  91                 throw new PDOException("Unable to get jobs list from catalog");
  92         }else {
  93                 foreach( $jobsresult->fetchAll() as $job ) {
  94
  95                         // Determine icon for job status
  96                         switch( $job['jobstatus'] ) {
  97                                 case J_RUNNING:
  98                                         $job['Job_icon'] = "running.png";
  99                                 break;
 100                                 case J_COMPLETED:
 101                                         $job['Job_icon'] = "ok.png";
 102                                 break;
 103                                 case J_CANCELED:
 104                                         $job['Job_icon'] = "canceled.png";
 105                                 break;
 106                                 case J_COMPLETED_ERROR:
 107                                         $job['Job_icon'] = "warning.png";
 108                                 break;
 109                                 case J_FATAL:
 110                                         $job['Job_icon'] = "error.png";
 111                                 break;
 112                                 case J_WAITING_CLIENT:
 113                                 case J_WAITING_SD:
 114                                 case J_WAITING_MOUNT_MEDIA:
 115                                 case J_WAITING_NEW_MEDIA:
 116                                 case J_WAITING_STORAGE_RES:
 117                                 case J_WAITING_JOB_RES:
 118                                 case J_WAITING_CLIENT_RES:
 119                                 case J_WAITING_MAX_JOBS:
 120                                 case J_WAITING_START_TIME:
 121                                 case J_NOT_RUNNING:
 122                                         $job['Job_icon'] = "waiting.png";
 123                                 break;
 124                         } // end switch
 125
 126                         // Odd or even row
 127                         if( count($last_jobs) % 2)
 128                                 $job['Job_classe'] = 'odd';
 129
 130                         // Elapsed time for the job
 131                         $start = $job['starttime'];
 132                         $end   = $job['endtime'];
 133
 134                         // Job execution execution time
 135                         $job['elapsed_time'] = CTimeUtils::Get_Elapsed_Time( $start, $end);
 136                         // Job Level
 137                         $job['level'] = $job_level[ $job['level'] ];
 138                         // Job Size
 139                         $job['jobbytes'] = CUtils::Get_Human_Size( $job['jobbytes'] );
 140
 141                         array_push( $last_jobs, $job);
 142                 } // end foreach
 143         } // end if/else
 144
 145   }catch(PDOException $e) {
 146         CDBError::raiseError($e);
 147   }
 148
 149   $dbSql->tpl->assign( 'last_jobs', $last_jobs );
 150
 151   // Count jobs
 152   if( isset( $_POST['status'] ) )
 153         $total_jobs = $dbSql->countJobs( FIRST_DAY, NOW, $_POST['status'] );
 154   else
 155         $total_jobs = $dbSql->countJobs( FIRST_DAY, NOW );
 156
 157   $dbSql->tpl->assign( 'total_jobs', $total_jobs );
 158
 159   // Process and display the template
 160   $dbSql->tpl->display('jobs.tpl');
 161 ?>