Mercurial > bms / file diff

--- a/www/includes/db_product.php	Thu Sep 19 22:35:02 2019 +0200
+++ b/www/includes/db_product.php	Fri Sep 20 20:12:36 2019 +0200
@@ -265,8 +265,7 @@
 	$sql .= "', divide_type='" . $_POST['divide_type'];
 	$sql .= "', divide_size='" . $_POST['divide_size'];
 	$sql .= "', divide_parts='" . $_POST['divide_parts'];
-	$sql .= "', divide_from='" . $_POST['divide_from'];
-	syslog(LOG_NOTICE, $sql);
+	//syslog(LOG_NOTICE, $sql);
 
 	$fermentables = '[';
 	$comma = FALSE;
@@ -499,6 +498,25 @@
 	}
 	echo $result;
 
+} else if (isset($_POST['splitit'])) {
+	/*
+	 * Update split batch details
+	 */
+	$sql  = "UPDATE `products` SET ";
+	$sql .=    "divide_type='" . $_POST['divide_type'];
+        $sql .= "', divide_size='" . $_POST['divide_size'];
+        $sql .= "', divide_parts='" . $_POST['divide_parts'];
+	$sql .= "' WHERE record='" . $_POST['record'] . "';";
+        syslog(LOG_NOTICE, $sql);
+
+	$result = mysqli_query($connect, $sql);
+        if (! $result) {
+		syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect));
+        } else {
+                syslog(LOG_NOTICE, "db_product: updated (divide) record ".$_POST['record']);
+        }
+        echo $result;
+
 } else if (isset($_POST['delete'])) {
 	/*
 	 * DELETE command.
@@ -848,7 +866,6 @@
 		$brew .= ',"divide_type":' . $row['divide_type'];
 		$brew .= ',"divide_size":' . floatval($row['divide_size']);
 		$brew .= ',"divide_parts":' . $row['divide_parts'];
-		$brew .= ',"divide_from":"' . str_replace($escapers, $replacements, $row['divide_from']) . '"';
 
 		if (isset($_GET['record'])) {
 			// Append stock information.