www/import/from_brouwhulp.php

changeset 102
679ddf512b65
parent 100
08c92cb740b9
child 104
0c6ad9e0f143
equal deleted inserted replaced
101:5b6bb99bc52a 102:679ddf512b65
499 $sql .= "', color_method='" . mysqli_real_escape_string($db, $recipe->COLOR_METHOD); 499 $sql .= "', color_method='" . mysqli_real_escape_string($db, $recipe->COLOR_METHOD);
500 if ($recipe->IBU) 500 if ($recipe->IBU)
501 $sql .= "', est_ibu='" . floatval($recipe->IBU); 501 $sql .= "', est_ibu='" . floatval($recipe->IBU);
502 if ($recipe->IBU_METHOD) 502 if ($recipe->IBU_METHOD)
503 $sql .= "', ibu_method='" . mysqli_real_escape_string($db, $recipe->IBU_METHOD); 503 $sql .= "', ibu_method='" . mysqli_real_escape_string($db, $recipe->IBU_METHOD);
504 if ($recipe->CARBONATION)
505 $sql .= "', est_carb='" . floatval($recipe->CARBONATION);
504 506
505 if ($recipe->STYLE) { 507 if ($recipe->STYLE) {
506 if ($recipe->STYLE->NAME) 508 if ($recipe->STYLE->NAME)
507 $sql .= "', st_name='" . mysqli_real_escape_string($db, $recipe->STYLE->NAME); 509 $sql .= "', st_name='" . mysqli_real_escape_string($db, $recipe->STYLE->NAME);
508 if ($recipe->STYLE->STYLE_LETTER) 510 if ($recipe->STYLE->STYLE_LETTER)
623 $percent = floatval($fermentable->PERCENTAGE); 625 $percent = floatval($fermentable->PERCENTAGE);
624 $fermentables .= ',"f_percentage":' . $percent; 626 $fermentables .= ',"f_percentage":' . $percent;
625 if ($fermentable->DI_pH) 627 if ($fermentable->DI_pH)
626 $fermentables .= ',"f_di_ph":' . floatval($fermentable->DI_pH); 628 $fermentables .= ',"f_di_ph":' . floatval($fermentable->DI_pH);
627 else 629 else
628 $fermentables .= ',"f_di_ph":5.6'; 630 $fermentables .= ',"f_di_ph":0.0';
629 $fermentables .= "}"; 631 $fermentables .= "}";
630 /* Sugars */ 632 /* Sugars */
631 $d = $famount * ($fyield / 100) * (1 - $fmoisture / 100); 633 $d = $famount * ($fyield / 100) * (1 - $fmoisture / 100);
632 if ($fadded == "Mash") 634 if ($fadded == "Mash")
633 $d = floatval($efficiency) / 100 * $d; 635 $d = floatval($efficiency) / 100 * $d;

mercurial