98 $sql .= "', brew_aeration_time='" . $_POST['brew_aeration_time']; |
98 $sql .= "', brew_aeration_time='" . $_POST['brew_aeration_time']; |
99 $sql .= "', brew_aeration_speed='" . $_POST['brew_aeration_speed']; |
99 $sql .= "', brew_aeration_speed='" . $_POST['brew_aeration_speed']; |
100 $sql .= "', brew_aeration_type='" . $_POST['brew_aeration_type']; |
100 $sql .= "', brew_aeration_type='" . $_POST['brew_aeration_type']; |
101 $sql .= "', brew_fermenter_volume='" . $_POST['brew_fermenter_volume']; |
101 $sql .= "', brew_fermenter_volume='" . $_POST['brew_fermenter_volume']; |
102 $sql .= "', brew_fermenter_extrawater='" . $_POST['brew_fermenter_extrawater']; |
102 $sql .= "', brew_fermenter_extrawater='" . $_POST['brew_fermenter_extrawater']; |
|
103 $sql .= "', brew_fermenter_tcloss='" . $_POST['brew_fermenter_tcloss']; |
103 $sql .= "', brew_fermenter_sg='" . $_POST['brew_fermenter_sg']; |
104 $sql .= "', brew_fermenter_sg='" . $_POST['brew_fermenter_sg']; |
104 $sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu']; |
105 $sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu']; |
|
106 $sql .= "', brew_fermenter_color='" . $_POST['brew_fermenter_color']; |
105 if ($stage > 2) { |
107 if ($stage > 2) { |
106 syslog(LOG_NOTICE, "write brewdate data end"); |
108 syslog(LOG_NOTICE, "write brewdate data end"); |
107 $sql .= "', brew_date_end='" . $_POST['brew_date_end']; |
109 $sql .= "', brew_date_end='" . $_POST['brew_date_end']; |
108 } |
110 } |
109 } |
111 } |
452 /* |
454 /* |
453 * Default, select all or a given record. |
455 * Default, select all or a given record. |
454 */ |
456 */ |
455 if (isset($_GET['record'])) { |
457 if (isset($_GET['record'])) { |
456 $query = "SELECT * FROM products WHERE record='" . $_GET['record'] . "';"; |
458 $query = "SELECT * FROM products WHERE record='" . $_GET['record'] . "';"; |
457 syslog(LOG_NOTICE, "get products record " . $_GET['record']); |
|
458 } else { |
459 } else { |
459 $query = "SELECT * FROM products ORDER BY birth,code;"; |
460 $query = "SELECT * FROM products ORDER BY birth,code;"; |
460 } |
461 } |
461 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
462 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
462 $brews = '['; |
463 $brews = '['; |
523 $brew .= ',"brew_whirlpool7":' . floatval($row['brew_whirlpool7']); |
524 $brew .= ',"brew_whirlpool7":' . floatval($row['brew_whirlpool7']); |
524 $brew .= ',"brew_whirlpool6":' . floatval($row['brew_whirlpool6']); |
525 $brew .= ',"brew_whirlpool6":' . floatval($row['brew_whirlpool6']); |
525 $brew .= ',"brew_whirlpool2":' . floatval($row['brew_whirlpool2']); |
526 $brew .= ',"brew_whirlpool2":' . floatval($row['brew_whirlpool2']); |
526 $brew .= ',"brew_fermenter_volume":' . floatval($row['brew_fermenter_volume']); |
527 $brew .= ',"brew_fermenter_volume":' . floatval($row['brew_fermenter_volume']); |
527 $brew .= ',"brew_fermenter_extrawater":' . floatval($row['brew_fermenter_extrawater']); |
528 $brew .= ',"brew_fermenter_extrawater":' . floatval($row['brew_fermenter_extrawater']); |
|
529 $brew .= ',"brew_fermenter_tcloss":' . floatval($row['brew_fermenter_tcloss']); |
528 $brew .= ',"brew_aeration_time":' . floatval($row['brew_aeration_time']); |
530 $brew .= ',"brew_aeration_time":' . floatval($row['brew_aeration_time']); |
529 $brew .= ',"brew_aeration_speed":' . floatval($row['brew_aeration_speed']); |
531 $brew .= ',"brew_aeration_speed":' . floatval($row['brew_aeration_speed']); |
530 $brew .= ',"brew_aeration_type":' . $row['brew_aeration_type']; |
532 $brew .= ',"brew_aeration_type":' . $row['brew_aeration_type']; |
531 $brew .= ',"brew_fermenter_sg":' . floatval($row['brew_fermenter_sg']); |
533 $brew .= ',"brew_fermenter_sg":' . floatval($row['brew_fermenter_sg']); |
532 $brew .= ',"brew_fermenter_ibu":' . floatval($row['brew_fermenter_ibu']); |
534 $brew .= ',"brew_fermenter_ibu":' . floatval($row['brew_fermenter_ibu']); |
|
535 $brew .= ',"brew_fermenter_color":' . floatval($row['brew_fermenter_color']); |
533 $brew .= ',"brew_date_end":"' . $row['brew_date_end']; |
536 $brew .= ',"brew_date_end":"' . $row['brew_date_end']; |
534 $brew .= '","og":' . floatval($row['og']); |
537 $brew .= '","og":' . floatval($row['og']); |
535 $brew .= ',"fg":' . floatval($row['fg']); |
538 $brew .= ',"fg":' . floatval($row['fg']); |
536 $brew .= ',"primary_start_temp":' . floatval($row['primary_start_temp']); |
539 $brew .= ',"primary_start_temp":' . floatval($row['primary_start_temp']); |
537 $brew .= ',"primary_max_temp":' . floatval($row['primary_max_temp']); |
540 $brew .= ',"primary_max_temp":' . floatval($row['primary_max_temp']); |