diff -r 4f14a18b581e -r 8d53ad389204 www/includes/db_product.php --- 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.