--- a/www/includes/db_product.php Fri Feb 08 11:30:22 2019 +0100
+++ b/www/includes/db_product.php Sat Feb 09 15:43:13 2019 +0100
@@ -100,8 +100,10 @@
$sql .= "', brew_aeration_type='" . $_POST['brew_aeration_type'];
$sql .= "', brew_fermenter_volume='" . $_POST['brew_fermenter_volume'];
$sql .= "', brew_fermenter_extrawater='" . $_POST['brew_fermenter_extrawater'];
+ $sql .= "', brew_fermenter_tcloss='" . $_POST['brew_fermenter_tcloss'];
$sql .= "', brew_fermenter_sg='" . $_POST['brew_fermenter_sg'];
$sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu'];
+ $sql .= "', brew_fermenter_color='" . $_POST['brew_fermenter_color'];
if ($stage > 2) {
syslog(LOG_NOTICE, "write brewdate data end");
$sql .= "', brew_date_end='" . $_POST['brew_date_end'];
@@ -454,7 +456,6 @@
*/
if (isset($_GET['record'])) {
$query = "SELECT * FROM products WHERE record='" . $_GET['record'] . "';";
- syslog(LOG_NOTICE, "get products record " . $_GET['record']);
} else {
$query = "SELECT * FROM products ORDER BY birth,code;";
}
@@ -525,11 +526,13 @@
$brew .= ',"brew_whirlpool2":' . floatval($row['brew_whirlpool2']);
$brew .= ',"brew_fermenter_volume":' . floatval($row['brew_fermenter_volume']);
$brew .= ',"brew_fermenter_extrawater":' . floatval($row['brew_fermenter_extrawater']);
+ $brew .= ',"brew_fermenter_tcloss":' . floatval($row['brew_fermenter_tcloss']);
$brew .= ',"brew_aeration_time":' . floatval($row['brew_aeration_time']);
$brew .= ',"brew_aeration_speed":' . floatval($row['brew_aeration_speed']);
$brew .= ',"brew_aeration_type":' . $row['brew_aeration_type'];
$brew .= ',"brew_fermenter_sg":' . floatval($row['brew_fermenter_sg']);
$brew .= ',"brew_fermenter_ibu":' . floatval($row['brew_fermenter_ibu']);
+ $brew .= ',"brew_fermenter_color":' . floatval($row['brew_fermenter_color']);
$brew .= ',"brew_date_end":"' . $row['brew_date_end'];
$brew .= '","og":' . floatval($row['og']);
$brew .= ',"fg":' . floatval($row['fg']);
@@ -713,8 +716,6 @@
$brews .= $brew;
}
$brews .= ']';
- if (isset($_GET['record']))
- syslog(LOG_NOTICE, "ready to sent");
header("Content-type: application/json");
echo $brews;
}