comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 500
- 8d53ad389204
- parent 499
- 4f14a18b581e
- child 515
- 9d771385a8a0
equal
deleted
inserted
replaced
| 499:4f14a18b581e | 500:8d53ad389204 |
|---|---|
| 263 $sql .= "', prop4_volume='" . $_POST['prop4_volume']; | 263 $sql .= "', prop4_volume='" . $_POST['prop4_volume']; |
| 264 } | 264 } |
| 265 $sql .= "', divide_type='" . $_POST['divide_type']; | 265 $sql .= "', divide_type='" . $_POST['divide_type']; |
| 266 $sql .= "', divide_size='" . $_POST['divide_size']; | 266 $sql .= "', divide_size='" . $_POST['divide_size']; |
| 267 $sql .= "', divide_parts='" . $_POST['divide_parts']; | 267 $sql .= "', divide_parts='" . $_POST['divide_parts']; |
| 268 $sql .= "', divide_from='" . $_POST['divide_from']; | 268 //syslog(LOG_NOTICE, $sql); |
| 269 syslog(LOG_NOTICE, $sql); | |
| 270 | 269 |
| 271 $fermentables = '['; | 270 $fermentables = '['; |
| 272 $comma = FALSE; | 271 $comma = FALSE; |
| 273 if (isset($_POST['fermentables'])) { | 272 if (isset($_POST['fermentables'])) { |
| 274 $array = $_POST['fermentables']; | 273 $array = $_POST['fermentables']; |
| 496 $lastid = mysqli_insert_id($connect); | 495 $lastid = mysqli_insert_id($connect); |
| 497 syslog(LOG_NOTICE, "db_product: inserted record ".$lastid); | 496 syslog(LOG_NOTICE, "db_product: inserted record ".$lastid); |
| 498 } | 497 } |
| 499 } | 498 } |
| 500 echo $result; | 499 echo $result; |
| 500 | |
| 501 } else if (isset($_POST['splitit'])) { | |
| 502 /* | |
| 503 * Update split batch details | |
| 504 */ | |
| 505 $sql = "UPDATE `products` SET "; | |
| 506 $sql .= "divide_type='" . $_POST['divide_type']; | |
| 507 $sql .= "', divide_size='" . $_POST['divide_size']; | |
| 508 $sql .= "', divide_parts='" . $_POST['divide_parts']; | |
| 509 $sql .= "' WHERE record='" . $_POST['record'] . "';"; | |
| 510 syslog(LOG_NOTICE, $sql); | |
| 511 | |
| 512 $result = mysqli_query($connect, $sql); | |
| 513 if (! $result) { | |
| 514 syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect)); | |
| 515 } else { | |
| 516 syslog(LOG_NOTICE, "db_product: updated (divide) record ".$_POST['record']); | |
| 517 } | |
| 518 echo $result; | |
| 501 | 519 |
| 502 } else if (isset($_POST['delete'])) { | 520 } else if (isset($_POST['delete'])) { |
| 503 /* | 521 /* |
| 504 * DELETE command. | 522 * DELETE command. |
| 505 */ | 523 */ |
| 846 $brew .= ',"prop4_volume":' . $row['prop4_volume']; | 864 $brew .= ',"prop4_volume":' . $row['prop4_volume']; |
| 847 | 865 |
| 848 $brew .= ',"divide_type":' . $row['divide_type']; | 866 $brew .= ',"divide_type":' . $row['divide_type']; |
| 849 $brew .= ',"divide_size":' . floatval($row['divide_size']); | 867 $brew .= ',"divide_size":' . floatval($row['divide_size']); |
| 850 $brew .= ',"divide_parts":' . $row['divide_parts']; | 868 $brew .= ',"divide_parts":' . $row['divide_parts']; |
| 851 $brew .= ',"divide_from":"' . str_replace($escapers, $replacements, $row['divide_from']) . '"'; | |
| 852 | 869 |
| 853 if (isset($_GET['record'])) { | 870 if (isset($_GET['record'])) { |
| 854 // Append stock information. | 871 // Append stock information. |
| 855 $fermentables = json_decode($row['json_fermentables'], true); | 872 $fermentables = json_decode($row['json_fermentables'], true); |
| 856 for ($i = 0; $i < count($fermentables); $i++) { | 873 for ($i = 0; $i < count($fermentables); $i++) { |
