bacula-web: Fixed SQL query bug in GetStoredBytesByJob() function

[bacula/bacula] / gui / bacula-web / bweb.inc.php

diff --git a/gui/bacula-web/bweb.inc.php b/gui/bacula-web/bweb.inc.php
index ba2685e5d18408deacf7423ed3bde83c2b4ff70f..2c638ff76ef23614116124a5c2b9eecc72bbc175 100644 (file)
--- 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);
                                                        }
@@ -641,7 +645,7 @@ class Bweb extends DB {
                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 .= "WHERE ( EndTime BETWEEN '$start_date' AND '$end_date' ) AND ";
                        $query .= "Name = '$jobname'";
                        
                        echo 'query ' . $query . '<br />';