Mercurial > bms / file diff

--- a/www/includes/db_product.php	Mon Feb 04 15:21:49 2019 +0100
+++ b/www/includes/db_product.php	Mon Feb 04 20:30:41 2019 +0100
@@ -71,6 +71,7 @@
 	$sql .= "', eq_efficiency='" . $_POST['eq_efficiency'];
 
 	if ($stage > 1) {
+		syslog(LOG_NOTICE, "write brewdate data");
 		$sql .= "', brew_date_start='" . $_POST['brew_date_start'];
 		$sql .= "', brew_mash_ph='" . $_POST['brew_mash_ph'];
 		$sql .= "', brew_mash_sg='" . $_POST['brew_mash_sg'];
@@ -98,13 +99,17 @@
 		$sql .= "', brew_fermenter_extrawater='" . $_POST['brew_fermenter_extrawater'];
 		$sql .= "', brew_fermenter_sg='" . $_POST['brew_fermenter_sg'];
 		$sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu'];
-		$sql .= "', brew_date_end='" . $_POST['brew_date_end'];
+		if ($stage > 2) {
+			syslog(LOG_NOTICE, "write brewdate data end");
+			$sql .= "', brew_date_end='" . $_POST['brew_date_end'];
+		}
 		($_POST['brew_log_available'] == 'true') ? $sql .= "', brew_log_available='1" : $sql .= "', brew_log_available='0";
 	}
 	$sql .= "', og='" . $_POST['og'];
 	$sql .= "', fg='" . $_POST['fg'];
 
 	if ($stage > 2) {
+		syslog(LOG_NOTICE, "write primary data");
 		$sql .= "', primary_start_temp='" . $_POST['primary_start_temp'];
 		$sql .= "', primary_max_temp='" . $_POST['primary_max_temp'];
 		$sql .= "', primary_end_temp='" . $_POST['primary_end_temp'];
@@ -113,12 +118,14 @@
 	}
 
 	if ($stage > 3) {
+		syslog(LOG_NOTICE, "write secondary data");
 		$sql .= "', secondary_temp='" . $_POST['secondary_temp'];
 		$sql .= "', secondary_end_date='" . $_POST['secondary_end_date'];
 		$sql .= "', tertiary_temp='" . $_POST['tertiary_temp'];
 	}
 
 	if ($stage > 4) {
+		syslog(LOG_NOTICE, "write package data");
 		$sql .= "', package_date='" . $_POST['package_date'];
 		$sql .= "', bottle_amount='" . $_POST['bottle_amount'];
 		$sql .= "', bottle_carbonation='" . $_POST['bottle_carbonation'];
@@ -135,6 +142,7 @@
 	}
 
 	if ($stage > 8) {
+		syslog(LOG_NOTICE, "write taste data");
 		$sql .= "', taste_notes='" . mysqli_real_escape_string($connect, $_POST['taste_notes']);
 		$sql .= "', taste_rate='" . $_POST['taste_rate'];
 		$sql .= "', taste_date='" . $_POST['taste_date'];