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_levels = array( 'D' => 'Diff', 'I' => 'Incr', 'F' => 'Full' );
  44
  45   $query .= "SELECT Job.JobId, Job.Name AS Job_name, Job.Type, 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   $posts = CHttpRequest::getRequestVars( $_POST );
  51
  52   if( $posts != false ) {
  53         switch( $posts['status'] )
  54         {
  55                 case STATUS_RUNNING:
  56                         $query .= "WHERE Job.JobStatus = 'R' ";
  57                 break;
  58                 case STATUS_WAITING:
  59                         $query .= "WHERE Job.JobStatus IN ('F','S','M','m','s','j','c','d','t','p','C') ";
  60                 break;
  61                 case STATUS_COMPLETED:
  62                         $query .= "WHERE Job.JobStatus = 'T' ";
  63                 break;
  64                 case STATUS_FAILED:
  65                         $query .= "WHERE Job.JobStatus IN ('f', 'E') ";
  66                 break;
  67                 case STATUS_CANCELED:
  68                         $query .= "WHERE Job.JobStatus = 'A' ";
  69                 break;
  70         }
  71         $dbSql->tpl->assign('job_status_filter', $posts['status'] );
  72   }
  73
  74   // order by
  75   $query .= "ORDER BY Job.JobId DESC ";
  76
  77   // Jobs per page
  78   $jobs_per_page = array( 25 => '25', 50 => '50', 75 => '75', 100 => '100', 150 => '150' );
  79
  80   // Determine how many jobs to display
  81   if( isset($posts['jobs_per_page']) ) {
  82         $query .= "LIMIT " . $posts['jobs_per_page'];
  83     $dbSql->tpl->assign( 'jobs_per_page_selected', $posts['jobs_per_page'] );
  84   }else
  85         $query .= "LIMIT 25 ";
  86   $dbSql->tpl->assign( 'jobs_per_page', $jobs_per_page );
  87
  88   try {
  89         $jobsresult = $dbSql->db_link->runQuery( $query );
  90
  91         if( !is_a($jobsresult,'CDBResult') ) {
  92                 throw new PDOException("Unable to get jobs list from catalog");
  93         }else {
  94                 foreach( $jobsresult->fetchAll() as $job ) {
  95
  96                         // Determine icon for job status
  97                         switch( $job['jobstatus'] ) {
  98                                 case J_RUNNING:
  99                                         $job['Job_icon'] = "running.png";
 100                                 break;
 101                                 case J_COMPLETED:
 102                                         $job['Job_icon'] = "ok.png";
 103                                 break;
 104                                 case J_CANCELED:
 105                                         $job['Job_icon'] = "canceled.png";
 106                                 break;
 107                                 case J_COMPLETED_ERROR:
 108                                         $job['Job_icon'] = "warning.png";
 109                                 break;
 110                                 case J_FATAL:
 111                                         $job['Job_icon'] = "error.png";
 112                                 break;
 113                                 case J_WAITING_CLIENT:
 114                                 case J_WAITING_SD:
 115                                 case J_WAITING_MOUNT_MEDIA:
 116                                 case J_WAITING_NEW_MEDIA:
 117                                 case J_WAITING_STORAGE_RES:
 118                                 case J_WAITING_JOB_RES:
 119                                 case J_WAITING_CLIENT_RES:
 120                                 case J_WAITING_MAX_JOBS:
 121                                 case J_WAITING_START_TIME:
 122                                 case J_NOT_RUNNING:
 123                                         $job['Job_icon'] = "waiting.png";
 124                                 break;
 125                         } // end switch
 126
 127                         // Odd or even row
 128                         if( count($last_jobs) % 2)
 129                                 $job['Job_classe'] = 'odd';
 130
 131                         // Elapsed time for the job
 132                         $start = $job['starttime'];
 133                         $end   = $job['endtime'];
 134
 135                         if( $start == '0000-00-00 00:00:00' or is_null($start) )
 136                                 $job['starttime'] = 'N/A';
 137
 138                         if( $end == '0000-00-00 00:00:00' or is_null($end) )
 139                                 $job['endtime'] = 'N/A';
 140
 141                         $job['elapsed_time'] = CTimeUtils::Get_Elapsed_Time( $start, $end);
 142
 143                         // Job Level
 144                         $job['level'] = $job_levels[ $job['level'] ];
 145
 146                         // Job files
 147                         $job['jobfiles'] = number_format( $job['jobfiles'], 0, '.', "'");
 148
 149                         // Job size
 150                         $job['jobbytes'] = CUtils::Get_Human_Size( $job['jobbytes'] );
 151
 152                         array_push( $last_jobs, $job);
 153                 } // end foreach
 154         } // end if/else
 155
 156   }catch(PDOException $e) {
 157         CDBError::raiseError($e);
 158   }
 159
 160   $dbSql->tpl->assign( 'last_jobs', $last_jobs );
 161
 162   // Count jobs
 163   if( isset( $posts['status'] ) )
 164         $total_jobs = $dbSql->countJobs( FIRST_DAY, NOW, $posts['status'] );
 165   else
 166         $total_jobs = $dbSql->countJobs( FIRST_DAY, NOW );
 167
 168   $dbSql->tpl->assign( 'total_jobs', $total_jobs );
 169
 170   // Process and display the template
 171   $dbSql->tpl->display('jobs.tpl');
 172 ?>