www/import/from_brouwhulp.php

changeset 61
3469979f83be
parent 60
dbbe408108ea
child 64
5d5fc6f7cbfe
equal deleted inserted replaced
60:dbbe408108ea 61:3469979f83be
674 $comma = TRUE; 674 $comma = TRUE;
675 $yeasts .= '{"y_name":"' . mysqli_real_escape_string($db, $yeast->NAME) . '"'; 675 $yeasts .= '{"y_name":"' . mysqli_real_escape_string($db, $yeast->NAME) . '"';
676 $yeasts .= ',"y_amount":' . floatval($yeast->AMOUNT); 676 $yeasts .= ',"y_amount":' . floatval($yeast->AMOUNT);
677 if ($yeast->COST) 677 if ($yeast->COST)
678 $yeasts .= ',"y_cost":' . floatval($yeast->COST); 678 $yeasts .= ',"y_cost":' . floatval($yeast->COST);
679 else
680 $yeasts .= ',"y_cost":0';
679 $yeasts .= ',"y_laboratory":"' . mysqli_real_escape_string($db, $yeast->LABORATORY) . '"'; 681 $yeasts .= ',"y_laboratory":"' . mysqli_real_escape_string($db, $yeast->LABORATORY) . '"';
680 $yeasts .= ',"y_product_id":"' . mysqli_real_escape_string($db, $yeast->PRODUCT_ID) . '"'; 682 $yeasts .= ',"y_product_id":"' . mysqli_real_escape_string($db, $yeast->PRODUCT_ID) . '"';
681 $yeasts .= ',"y_type":"' . mysqli_real_escape_string($db, $yeast->TYPE) . '"'; 683 $yeasts .= ',"y_type":"' . mysqli_real_escape_string($db, $yeast->TYPE) . '"';
682 $yeasts .= ',"y_form":"' . mysqli_real_escape_string($db, $yeast->FORM) . '"'; 684 $yeasts .= ',"y_form":"' . mysqli_real_escape_string($db, $yeast->FORM) . '"';
683 ($yeast->AMOUNT_IS_WEIGHT== "TRUE") ? $yeasts .= ',"y_amount_is_weight":true' : $yeasts.= ',"y_amount_is_weight":false'; 685 ($yeast->AMOUNT_IS_WEIGHT== "TRUE") ? $yeasts .= ',"y_amount_is_weight":true' : $yeasts.= ',"y_amount_is_weight":false';
686 } else if ($yeast->PRODUCT_ID=="F2") { 688 } else if ($yeast->PRODUCT_ID=="F2") {
687 $yeasts .= ',"y_use":"Bottle"'; 689 $yeasts .= ',"y_use":"Bottle"';
688 } else { 690 } else {
689 $yeasts .= ',"y_use":"Secondary"'; 691 $yeasts .= ',"y_use":"Secondary"';
690 } 692 }
693 $yeasts .= ',"y_min_temperature":' . floatval($yeast->MIN_TEMPERATURE);
694 $yeasts .= ',"y_max_temperature":' . floatval($yeast->MAX_TEMPERATURE);
695 $yeasts .= ',"y_attenuation":' . floatval($yeast->ATTENUATION);
691 $yeasts .= "}"; 696 $yeasts .= "}";
692 } 697 }
693 698
694 $yeasts .= ']'; 699 $yeasts .= ']';
695 // echo $yeasts . PHP_EOL; 700 // echo $yeasts . PHP_EOL;

mercurial