X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=gui%2Fbacula-web%2Fbweb.inc.php;h=8e2c68ec5b0df09252d2088d674ff225532afed2;hb=e72734faae318b19fed76d4667bb9ca15ba4034f;hp=2d584c30ce0738cc7f801a968c99747b920ee174;hpb=4addcb20e123871754e8a3a34e29a5e65da1cfd4;p=bacula%2Fbacula

diff --git a/gui/bacula-web/bweb.inc.php b/gui/bacula-web/bweb.inc.php
index 2d584c30ce..8e2c68ec5b 100644
--- a/gui/bacula-web/bweb.inc.php
+++ b/gui/bacula-web/bweb.inc.php
@@ -327,12 +327,16 @@ class Bweb extends DB {
 										}
 										// Media used bytes in a human format
 										$media['volbytes'] = $this->human_file_size( $media['volbytes'] );
-										//echo "volume " . $media['volumename'] . 'vol bytes' .$media['volbytes'] . '<br />';
 									} else {
 										$media['lastwritten'] = "N/A";
 										$media['expire']      = "N/A";
 										$media['volbytes'] 	  = "0 KB";
 									}								
+								
+								// Odd or even row
+								if( count(  $volumes[ $pool['name'] ] ) % 2)
+							        	$media['class'] = 'odd';
+
 								// Add the media in pool array
 								array_push( $volumes[ $pool['name']], $media);
 							}
@@ -366,11 +370,14 @@ class Bweb extends DB {
 						$where_status = "JobStatus = 'T' ";
 					break;
 					case 'failed':
-						$where_status = "JobStatus = 'f' ";
+						$where_status = "JobStatus IN ('f','E') ";
 					break;
 					case 'canceled':
 						$where_status = "JobStatus = 'A' ";
 					break;
+					case 'waiting':
+						$where_status = "JobStatus IN ('F','S','M','m','s','j','c','d','t') ";
+					break;
 				} // end switch
 			}
 			
@@ -428,6 +435,27 @@ class Bweb extends DB {
 			}
 		}
 		
+		// Return elasped time string for a job
+		function Get_ElapsedTime( $start_time, $end_time ) 
+		{ 
+			$diff = $end_time - $start_time;
+			
+			$daysDiff = sprintf("%02d", floor($diff/60/60/24) );
+			$diff -= $daysDiff*60*60*24;
+			
+			$hrsDiff = sprintf("%02d", floor($diff/60/60) );
+			$diff -= $hrsDiff*60*60;
+			
+			$minsDiff = sprintf("%02d", floor($diff/60) );
+			$diff -= $minsDiff*60;
+			$secsDiff = sprintf("%02d", $diff );
+			
+			if( $daysDiff > 0 )
+				return $daysDiff . 'day(s) ' . $hrsDiff.':' . $minsDiff . ':' . $secsDiff;
+			else
+				return $hrsDiff . ':' . $minsDiff . ':' . $secsDiff;
+		}
+		
 		public function Get_ElapsedTime_Job( $delay = LAST_DAY )
 		{
 			$query 			= "";
@@ -457,7 +485,7 @@ class Bweb extends DB {
 					$total_elapsed += $time['elapsed'];
 				}
 				// Verify if elapsed time is more than 1 day
-				if ( $total_elapsed > 86400 ) {
+				if ( $total_elapsed > LAST_DAY ) {
 					return date("%d days H:i:s", $total_elapsed );
 				}else {
 					return date("H:i:s", $total_elapsed );
@@ -492,9 +520,9 @@ class Bweb extends DB {
 					$where = "AND JobStatus = 'T' ";
 					$label = "Completed";
 				break;
-				case 'completed_errors':
-					$where = "AND JobStatus = 'E' ";
-					$label = "Completed with errors";
+				case 'terminated_errors':
+					$where = $interval_where . "JobStatus = 'E' ";
+					$label = "Terminated with errors";
 				break;
 				case 'failed':
 					$where = "AND JobStatus = 'f' ";
@@ -613,5 +641,33 @@ class Bweb extends DB {
 				return array( $day, $stored_bytes );
 			}
 		}
+		
+		public function GetStoredBytesByJob( $jobname, $start_date, $end_date )
+		{
+			$query  = "SELECT SUM(JobBytes) as stored_bytes, EndTime FROM Job ";
+			$query .= "WHERE EndTime BETWEEN ( '$start_date' AND '$end_date' ) AND ";
+			$query .= "Name = '$jobname'";
+			
+			echo 'query ' . $query . '<br />';
+			
+			$result = $this->db_link->query( $query );
+			
+			if( PEAR::isError( $result ) ) {
+				die( "Unable to get Job Bytes from catalog" );
+			}else{
+				$stored_bytes = 0;
+				$tmp = $result->fetchRow( DB_FETCHMODE_ASSOC );
+				
+				$day = date( "D d", strtotime($end_date) );
+				
+				if( isset( $tmp['stored_bytes'] ) ) {
+					$hbytes = $this->human_file_size( $tmp['stored_bytes'], 3, 'GB');
+					$hbytes = explode( " ", $hbytes );
+					$stored_bytes = $hbytes[0];
+				}
+				
+				return array( $day, $stored_bytes );
+			}			
+		}
 } // end class Bweb
 ?>