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

diff --git a/gui/bacula-web/bweb.inc.php b/gui/bacula-web/bweb.inc.php
index 51f46aed0f..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
 			}
 			
@@ -634,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
 ?>