Mercurial > bms / file diff

--- a/www/includes/db_product.php	Fri May 03 21:02:54 2024 +0200
+++ b/www/includes/db_product.php	Thu Jun 13 17:12:00 2024 +0200
@@ -73,6 +73,8 @@
 	$sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume'];
 	$sql .= "', eq_mash_max='" . $_POST['eq_mash_max'];
 	$sql .= "', eq_efficiency='" . $_POST['eq_efficiency'];
+	$sql .= "', eq_HLT_volume='" . $_POST['eq_HLT_volume'];
+	$sql .= "', eq_HLT_deadspace='" . $_POST['eq_HLT_deadspace'];
 	// brewdate
 	if ($_POST['brew_date_start'] == '')
 		$sql .= "', brew_date_start=NULL";
@@ -247,7 +249,15 @@
         $sql .= "', wb_sodium='" . $_POST['wb_sodium'];
         $sql .= "', wb_magnesium='" . $_POST['wb_magnesium'];
         $sql .= "', wb_total_alkalinity='" . $_POST['wb_total_alkalinity'];
-        $sql .= "', wb_ph='" . $_POST['wb_ph'];
+	$sql .= "', wb_ph='" . $_POST['wb_ph'];
+	$sql .= "', tw_name='" . $_POST['tw_name'];
+	$sql .= "', tw_calcium='" . $_POST['tw_calcium'];
+        $sql .= "', tw_sulfate='" . $_POST['tw_sulfate'];
+        $sql .= "', tw_chloride='" . $_POST['tw_chloride'];
+        $sql .= "', tw_sodium='" . $_POST['tw_sodium'];
+        $sql .= "', tw_magnesium='" . $_POST['tw_magnesium'];
+        $sql .= "', tw_total_alkalinity='" . $_POST['tw_total_alkalinity'];
+	$sql .= "', tw_ph='" . $_POST['tw_ph'];
 	$sql .= "', wa_acid_name='" . $_POST['wa_acid_name'];
 	$sql .= "', wa_acid_perc='" . $_POST['wa_acid_perc'];
 	$sql .= "', wa_base_name='" . $_POST['wa_base_name'];
@@ -718,6 +728,8 @@
 		$brew .= ',"eq_chiller_volume":' . floatval($row['eq_chiller_volume']);
 		$brew .= ',"eq_chiller_lpm":' . floatval($row['eq_chiller_lpm']);
 		$brew .= ',"eq_chiller_loss":' . floatval($row['eq_chiller_loss']);
+		$brew .= ',"eq_HLT_volume":' . floatval($row['eq_HLT_volume']);
+		$brew .= ',"eq_HLT_deadspace":' . floatval($row['eq_HLT_deadspace']);
 		$brew .= ',"brew_date_start":"' . $row['brew_date_start'];
 		$brew .= '","brew_mash_ph":' . floatval($row['brew_mash_ph']);
 		$brew .= ',"brew_mash_sg":' . floatval($row['brew_mash_sg']);
@@ -865,7 +877,15 @@
                 $brew .= ',"wb_sodium":' . floatval($row['wb_sodium']);
                 $brew .= ',"wb_magnesium":' . floatval($row['wb_magnesium']);
                 $brew .= ',"wb_total_alkalinity":' . floatval($row['wb_total_alkalinity']);
-                $brew .= ',"wb_ph":' . floatval($row['wb_ph']);
+		$brew .= ',"wb_ph":' . floatval($row['wb_ph']);
+		$brew .= ',"tw_name":"' . str_replace($escapers, $replacements, $row['tw_name']);
+		$brew .= '","tw_calcium":' . floatval($row['tw_calcium']);
+                $brew .= ',"tw_sulfate":' . floatval($row['tw_sulfate']);
+                $brew .= ',"tw_chloride":' . floatval($row['tw_chloride']);
+                $brew .= ',"tw_sodium":' . floatval($row['tw_sodium']);
+                $brew .= ',"tw_magnesium":' . floatval($row['tw_magnesium']);
+                $brew .= ',"tw_total_alkalinity":' . floatval($row['tw_total_alkalinity']);
+                $brew .= ',"tw_ph":' . floatval($row['tw_ph']);
 		$brew .= ',"wa_acid_name":' . $row['wa_acid_name'];
 		$brew .= ',"wa_acid_perc":' . $row['wa_acid_perc'];
 		$brew .= ',"wa_base_name":' . $row['wa_base_name'];