comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 841
- 60bb365fb48d
- parent 840
- ba607babc468
- child 842
- 897bf2a43253
equal
deleted
inserted
replaced
| 840:ba607babc468 | 841:60bb365fb48d |
|---|---|
| 531 $lastid = mysqli_insert_id($connect); | 531 $lastid = mysqli_insert_id($connect); |
| 532 } | 532 } |
| 533 } | 533 } |
| 534 echo json_encode($response); | 534 echo json_encode($response); |
| 535 | 535 |
| 536 } else if (isset($_POST['splitit'])) { | |
| 537 /* | |
| 538 * Update split batch details | |
| 539 */ | |
| 540 $sql = "UPDATE `products` SET "; | |
| 541 $sql .= "divide_type='" . $_POST['divide_type']; | |
| 542 $sql .= "', divide_size='" . $_POST['divide_size']; | |
| 543 $sql .= "', divide_parts='" . $_POST['divide_parts']; | |
| 544 $sql .= "' WHERE record='" . $_POST['record'] . "';"; | |
| 545 syslog(LOG_NOTICE, $sql); | |
| 546 | |
| 547 $result = mysqli_query($connect, $sql); | |
| 548 if (! $result) { | |
| 549 syslog(LOG_NOTICE, "db_product: result: ".mysqli_error($connect)); | |
| 550 $response['error'] = true; | |
| 551 $response['msg'] = "SQL update fout: ".mysqli_error($connect); | |
| 552 } else { | |
| 553 syslog(LOG_NOTICE, "db_product: updated (divide) record ".$_POST['record']); | |
| 554 } | |
| 555 echo json_encode($response); | |
| 556 | |
| 557 } else if (isset($_POST['delete'])) { | 536 } else if (isset($_POST['delete'])) { |
| 558 /* | 537 /* |
| 559 * DELETE command. | 538 * DELETE command. |
| 560 */ | 539 */ |
| 561 $sql = "DELETE FROM `products` WHERE uuid='".$_POST['uuid']."';"; | 540 $sql = "DELETE FROM `products` WHERE uuid='".$_POST['uuid']."';"; |
| 721 $brew .= ',"eq_tun_height":' . floatval($row['eq_tun_height']); | 700 $brew .= ',"eq_tun_height":' . floatval($row['eq_tun_height']); |
| 722 $brew .= ',"eq_top_up_water":' . floatval($row['eq_top_up_water']); | 701 $brew .= ',"eq_top_up_water":' . floatval($row['eq_top_up_water']); |
| 723 $brew .= ',"eq_trub_chiller_loss":' . floatval($row['eq_trub_chiller_loss']); | 702 $brew .= ',"eq_trub_chiller_loss":' . floatval($row['eq_trub_chiller_loss']); |
| 724 $brew .= ',"eq_evap_rate":' . floatval($row['eq_evap_rate']); | 703 $brew .= ',"eq_evap_rate":' . floatval($row['eq_evap_rate']); |
| 725 $brew .= ',"eq_boil_time":' . floatval($row['eq_boil_time']); | 704 $brew .= ',"eq_boil_time":' . floatval($row['eq_boil_time']); |
| 726 $brew .= ',"eq_calc_boil_volume":' . $row['eq_calc_boil_volume']; | 705 $brew .= ',"xeq_calc_boil_volume":' . floatval($row['eq_calc_boil_volume']); |
| 727 $brew .= ',"eq_calc_boil_volume":' . floatval($row['eq_calc_boil_volume']); | |
| 728 $brew .= ',"eq_top_up_kettle":' . floatval($row['eq_top_up_kettle']); | 706 $brew .= ',"eq_top_up_kettle":' . floatval($row['eq_top_up_kettle']); |
| 729 $brew .= ',"eq_lauter_volume":' . floatval($row['eq_lauter_volume']); | 707 $brew .= ',"xeq_lauter_volume":' . floatval($row['eq_lauter_volume']); |
| 730 $brew .= ',"eq_lauter_height":' . floatval($row['eq_lauter_height']); | 708 $brew .= ',"xeq_lauter_height":' . floatval($row['eq_lauter_height']); |
| 731 $brew .= ',"eq_lauter_deadspace":' . floatval($row['eq_lauter_deadspace']); | 709 $brew .= ',"eq_lauter_deadspace":' . floatval($row['eq_lauter_deadspace']); |
| 732 $brew .= ',"eq_kettle_volume":' . floatval($row['eq_kettle_volume']); | 710 $brew .= ',"eq_kettle_volume":' . floatval($row['eq_kettle_volume']); |
| 733 $brew .= ',"eq_kettle_height":' . floatval($row['eq_kettle_height']); | 711 $brew .= ',"eq_kettle_height":' . floatval($row['eq_kettle_height']); |
| 734 $brew .= ',"eq_mash_volume":' . floatval($row['eq_mash_volume']); | 712 $brew .= ',"eq_mash_volume":' . floatval($row['eq_mash_volume']); |
| 735 $brew .= ',"eq_mash_max":' . floatval($row['eq_mash_max']); | 713 $brew .= ',"eq_mash_max":' . floatval($row['eq_mash_max']); |
| 736 $brew .= ',"eq_efficiency":' . floatval($row['eq_efficiency']); | 714 $brew .= ',"eq_efficiency":' . floatval($row['eq_efficiency']); |
| 737 $brew .= ',"eq_top_up_water":' . floatval($row['eq_top_up_water']); | 715 $brew .= ',"eq_top_up_water":' . floatval($row['eq_top_up_water']); |
| 716 $brew .= ',"eq_chiller_type":' . $row['eq_chiller_type']; | |
| 717 $brew .= ',"eq_chiller_to79":' . floatval($row['eq_chiller_to79']); | |
| 718 $brew .= ',"eq_chiller_volume":' . floatval($row['eq_chiller_volume']); | |
| 719 $brew .= ',"eq_chiller_lpm":' . floatval($row['eq_chiller_lpm']); | |
| 720 $brew .= ',"eq_chiller_loss":' . floatval($row['eq_chiller_loss']); | |
| 738 $brew .= ',"brew_date_start":"' . $row['brew_date_start']; | 721 $brew .= ',"brew_date_start":"' . $row['brew_date_start']; |
| 739 $brew .= '","brew_mash_ph":' . floatval($row['brew_mash_ph']); | 722 $brew .= '","brew_mash_ph":' . floatval($row['brew_mash_ph']); |
| 740 $brew .= ',"brew_mash_sg":' . floatval($row['brew_mash_sg']); | 723 $brew .= ',"brew_mash_sg":' . floatval($row['brew_mash_sg']); |
| 741 $brew .= ',"brew_mash_efficiency":' . floatval($row['brew_mash_efficiency']); | 724 $brew .= ',"brew_mash_efficiency":' . floatval($row['brew_mash_efficiency']); |
| 742 $brew .= ',"brew_sparge_est":' . floatval($row['brew_sparge_est']); | 725 $brew .= ',"brew_sparge_est":' . floatval($row['brew_sparge_est']); |
