www/import/from_brouwhulp.php

changeset 56
d4f4762e59b3
parent 54
294dda7f1779
child 57
bb9a06aa9acd
equal deleted inserted replaced
55:3e29755638b6 56:d4f4762e59b3
529 foreach ($recipe->FERMENTABLES->FERMENTABLE as $fermentable) { 529 foreach ($recipe->FERMENTABLES->FERMENTABLE as $fermentable) {
530 if ($comma) 530 if ($comma)
531 $fermentables .= ','; 531 $fermentables .= ',';
532 $comma = TRUE; 532 $comma = TRUE;
533 $fermentables .= '{"f_name":"' . mysqli_real_escape_string($db, $fermentable->NAME) . '"'; 533 $fermentables .= '{"f_name":"' . mysqli_real_escape_string($db, $fermentable->NAME) . '"';
534 $fermentables .= ',"f_origin":"' . mysqli_real_escape_string($db, $fermentable->ORIGIN) . '"';
535 $fermentables .= ',"f_supplier":"' . mysqli_real_escape_string($db, $fermentable->SUPPLIER) . '"';
534 $fermentables .= ',"f_amount":' . floatval($fermentable->AMOUNT); 536 $fermentables .= ',"f_amount":' . floatval($fermentable->AMOUNT);
535 $fermentables .= ',"f_cost":' . floatval($fermentable->COST); 537 $fermentables .= ',"f_cost":' . floatval($fermentable->COST);
536 $fermentables .= ',"f_type":"' . mysqli_real_escape_string($db, $fermentable->TYPE) . '"'; 538 $fermentables .= ',"f_type":"' . mysqli_real_escape_string($db, $fermentable->TYPE) . '"';
537 $fermentables .= ',"f_yield":' . floatval($fermentable->YIELD); 539 $fermentables .= ',"f_yield":' . floatval($fermentable->YIELD);
538 if ($fermentable->COLOR) { 540 if ($fermentable->COLOR) {
559 $fermentables .= ',"f_graintype":"' . mysqli_real_escape_string($db, $fermentable->GRAINTYPE) . '"'; 561 $fermentables .= ',"f_graintype":"' . mysqli_real_escape_string($db, $fermentable->GRAINTYPE) . '"';
560 } 562 }
561 if ($fermentable->ADDED) { 563 if ($fermentable->ADDED) {
562 $fermentables .= ',"f_added":"' . mysqli_real_escape_string($db, $fermentable->ADDED) . '"'; 564 $fermentables .= ',"f_added":"' . mysqli_real_escape_string($db, $fermentable->ADDED) . '"';
563 } 565 }
566 ($fermentable->ADD_AFTER_BOIL== "TRUE") ? $fermentables .= ',"f_add_after_boil":true' : $fermentables .= ',"f_add_after_boil":false';
567 ($fermentable->RECOMMEND_MASH== "TRUE") ? $fermentables .= ',"f_recommend_mash":true' : $fermentables .= ',"f_recommend_mash":false';
564 if ($fermentable->DISSOLVED_PROTEIN) { 568 if ($fermentable->DISSOLVED_PROTEIN) {
565 $fermentables .= ',"f_dissolved_protein":' . floatval($fermentable->DISSOLVED_PROTEIN); 569 $fermentables .= ',"f_dissolved_protein":' . floatval($fermentable->DISSOLVED_PROTEIN);
566 } 570 }
567 ($fermentable->ADJUST_TO_TOTAL_100 == "TRUE") ? $fermentables .= ',"f_adjust_to_total_100":true' : $fermentables .= ',"f_adjust_to_total_100":false'; 571 ($fermentable->ADJUST_TO_TOTAL_100 == "TRUE") ? $fermentables .= ',"f_adjust_to_total_100":true' : $fermentables .= ',"f_adjust_to_total_100":false';
568 if ($fermentable->DI_pH) { 572 if ($fermentable->DI_pH) {

mercurial