www/includes/db_product.php

changeset 254
3d61397fe9cd
parent 252
b558f3dfcda3
child 278
dc22dd5d77fd
equal deleted inserted replaced
253:296caca18161 254:3d61397fe9cd
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']);
711 $brew .= '}'; 714 $brew .= '}';
712 // syslog(LOG_NOTICE, $brew); 715 // syslog(LOG_NOTICE, $brew);
713 $brews .= $brew; 716 $brews .= $brew;
714 } 717 }
715 $brews .= ']'; 718 $brews .= ']';
716 if (isset($_GET['record']))
717 syslog(LOG_NOTICE, "ready to sent");
718 header("Content-type: application/json"); 719 header("Content-type: application/json");
719 echo $brews; 720 echo $brews;
720 } 721 }
721 ?> 722 ?>

mercurial