Mercurial > bms / file diff

--- a/www/includes/db_product.php	Sun Dec 29 14:43:04 2019 +0100
+++ b/www/includes/db_product.php	Fri Jan 03 15:21:22 2020 +0100
@@ -563,7 +563,7 @@
 	}
 
 	if (isset($_GET['select']) && ($_GET['select'] == "archname")) {
-		$query = "SELECT record,name,code,brew_date_start,st_name,og,fg,batch_size FROM products WHERE stage = '11' ORDER BY name,brew_date_start;";
+		$query = "SELECT record,name,code,brew_date_start,st_name,brew_fermenter_sg,fg,batch_size FROM products WHERE stage = '11' ORDER BY name,brew_date_start;";
 		$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 		while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 			$brews[] = array(
@@ -572,7 +572,7 @@
 				'code' => $row['code'],
 				'date' => substr($row['brew_date_start'], 0, 10),
 				'style' => $row['st_name'],
-				'og' => $row['og'],
+				'og' => $row['brew_fermenter_sg'],
 				'fg' => $row['fg'],
 				'batch_size' => $row['batch_size']
 			);
@@ -583,7 +583,7 @@
 	}
 
 	if (isset($_GET['select']) && ($_GET['select'] == "archcode")) {
-		$query = "SELECT record,name,code,brew_date_start,st_name,og,fg,batch_size FROM products WHERE stage = '11' ORDER BY code;";
+		$query = "SELECT record,name,code,brew_date_start,st_name,brew_fermenter_sg,fg,batch_size FROM products WHERE stage = '11' ORDER BY code;";
 		$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 		while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 			$brews[] = array(
@@ -592,7 +592,7 @@
 				'code' => $row['code'],
 				'date' => substr($row['brew_date_start'], 0, 10),
 				'style' => $row['st_name'],
-				'og' => $row['og'],
+				'og' => $row['brew_fermenter_sg'],
 				'fg' => $row['fg'],
 				'batch_size' => $row['batch_size']
 			);
@@ -603,7 +603,7 @@
 	}
 
 	if (isset($_GET['select']) && ($_GET['select'] == "archdate")) {
-		$query = "SELECT record,name,code,brew_date_start,st_name,og,fg,batch_size FROM products WHERE stage = '11' ORDER BY brew_date_start;";
+		$query = "SELECT record,name,code,brew_date_start,st_name,brew_fermenter_sg,fg,batch_size FROM products WHERE stage = '11' ORDER BY brew_date_start;";
 		$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 		while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
 			$brews[] = array(
@@ -613,7 +613,7 @@
 				'year' => substr($row['brew_date_start'], 0, 4),
 				'date' => substr($row['brew_date_start'], 0, 10),
 				'style' => $row['st_name'],
-				'og' => $row['og'],
+				'og' => $row['brew_fermenter_sg'],
 				'fg' => $row['fg'],
 				'batch_size' => $row['batch_size']
 			);