49 $myfermentables = simplexml_load_file($brouwhulp . '/fermentables.xml'); |
49 $myfermentables = simplexml_load_file($brouwhulp . '/fermentables.xml'); |
50 |
50 |
51 foreach ($myfermentables->FERMENTABLE as $fermentable) { |
51 foreach ($myfermentables->FERMENTABLE as $fermentable) { |
52 |
52 |
53 $sql = "INSERT INTO inventory_fermentables SET name='" . mysqli_real_escape_string($db, $fermentable->NAME); |
53 $sql = "INSERT INTO inventory_fermentables SET name='" . mysqli_real_escape_string($db, $fermentable->NAME); |
54 $sql .= "', type='" . $fermentable->TYPE; |
54 if ($fermentable->TYPE == 'Grain') |
|
55 $sql .= "', type='0"; |
|
56 else if ($fermentable->TYPE == 'Sugar') |
|
57 $sql .= "', type='1"; |
|
58 else if ($fermentable->TYPE == 'Extract') |
|
59 $sql .= "', type='2"; |
|
60 else if ($fermentable->TYPE == 'Dry extract') |
|
61 $sql .= "', type='3"; |
|
62 else if ($fermentable->TYPE == 'Adjunct') |
|
63 $sql .= "', type='4"; |
|
64 else |
|
65 echo "Unknown TYPE " . $fermentable->TYPE . PHP_EOL; |
55 if ($fermentable->YIELD) |
66 if ($fermentable->YIELD) |
56 $sql .= "', yield='" . floatval($fermentable->YIELD); |
67 $sql .= "', yield='" . floatval($fermentable->YIELD); |
57 if ($fermentable->COLOR) { |
68 if ($fermentable->COLOR) { |
58 $srm = floatval($fermentable->COLOR); |
69 $sql .= "', color='" . srm_to_ebc(floatval($fermentable->COLOR)); |
59 $ebc = srm_to_ebc($srm); |
|
60 $sql .= "', color='" . $ebc; |
|
61 } |
70 } |
62 ($fermentable->ADD_AFTER_BOIL == "TRUE") ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0"; |
71 ($fermentable->ADD_AFTER_BOIL == "TRUE") ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0"; |
|
72 if ($fermentable->ADDED == 'Mash') |
|
73 $sql .= "', added='0"; |
|
74 else if ($fermentable->ADDED == 'Boil') |
|
75 $sql .= "', added='1"; |
|
76 else if ($fermentable->ADDED == 'Fermentation') |
|
77 $sql .= "', added='2"; |
|
78 else if ($fermentable->ADDED == 'Lagering') |
|
79 $sql .= "', added='3"; |
|
80 else if ($fermentable->ADDED == 'Bottle') |
|
81 $sql .= "', added='4"; |
|
82 else |
|
83 echo "Unknown ADDED " . $fermentable->ADDED . PHP_EOL; |
|
84 |
63 $sql .= "', origin='" . mysqli_real_escape_string($db, $fermentable->ORIGIN); |
85 $sql .= "', origin='" . mysqli_real_escape_string($db, $fermentable->ORIGIN); |
64 $sql .= "', supplier='" . mysqli_real_escape_string($db, $fermentable->SUPPLIER); |
86 $sql .= "', supplier='" . mysqli_real_escape_string($db, $fermentable->SUPPLIER); |
65 $sql .= "', notes='" . mysqli_real_escape_string($db, $fermentable->NOTES); |
87 $sql .= "', notes='" . mysqli_real_escape_string($db, $fermentable->NOTES); |
66 if ($fermentable->COARSE_FINE_DIFF) |
88 if ($fermentable->COARSE_FINE_DIFF) |
67 $sql .= "', coarse_fine_diff='" . floatval($fermentable->COARSE_FINE_DIFF); |
89 $sql .= "', coarse_fine_diff='" . floatval($fermentable->COARSE_FINE_DIFF); |
69 $sql .= "', moisture='" . floatval($fermentable->MOISTURE); |
91 $sql .= "', moisture='" . floatval($fermentable->MOISTURE); |
70 if ($fermentable->DIASTATIC_POWER) |
92 if ($fermentable->DIASTATIC_POWER) |
71 $sql .= "', diastatic_power='" . floatval($fermentable->DIASTATIC_POWER); |
93 $sql .= "', diastatic_power='" . floatval($fermentable->DIASTATIC_POWER); |
72 if ($fermentable->PROTEIN) |
94 if ($fermentable->PROTEIN) |
73 $sql .= "', protein='" . floatval($fermentable->PROTEIN); |
95 $sql .= "', protein='" . floatval($fermentable->PROTEIN); |
|
96 if ($fermentable->DISSOLVED_PROTEIN) |
|
97 $sql .= "', dissolved_protein='" . floatval($fermentable->DISSOLVED_PROTEIN); |
74 if ($fermentable->MAX_IN_BATCH) |
98 if ($fermentable->MAX_IN_BATCH) |
75 $sql .= "', max_in_batch='" . floatval($fermentable->MAX_IN_BATCH); |
99 $sql .= "', max_in_batch='" . floatval($fermentable->MAX_IN_BATCH); |
76 ($fermentable->RECOMMEND_MASH == "TRUE") ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0"; |
100 ($fermentable->RECOMMEND_MASH == "TRUE") ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0"; |
77 if ($fermentable->IBU_GAL_PER_LB) |
101 if ($fermentable->IBU_GAL_PER_LB) |
78 $sql .= "', ibu_gal_per_lb='" . floatval($fermentable->IBU_GAL_PER_LB); |
102 $sql .= "', ibu_gal_per_lb='" . floatval($fermentable->IBU_GAL_PER_LB); |
86 */ |
110 */ |
87 if ($fermentable->DI_pH) |
111 if ($fermentable->DI_pH) |
88 $sql .= "', di_ph='" . floatval($fermentable->DI_pH); |
112 $sql .= "', di_ph='" . floatval($fermentable->DI_pH); |
89 if ($fermentable->{'ACID_TO_pH_5.7'}) |
113 if ($fermentable->{'ACID_TO_pH_5.7'}) |
90 $sql .= "', acid_to_ph_57='" . floatval($fermentable->{'ACID_TO_pH_5.7'}); |
114 $sql .= "', acid_to_ph_57='" . floatval($fermentable->{'ACID_TO_pH_5.7'}); |
91 $sql .= "', graintype='" . $fermentable->GRAINTYPE; |
115 if ($fermentable->GRAINTYPE == 'Base') |
|
116 $sql .= "', graintype='0"; |
|
117 else if ($fermentable->GRAINTYPE == 'Roast') |
|
118 $sql .= "', graintype='1"; |
|
119 else if ($fermentable->GRAINTYPE == 'Crystal') |
|
120 $sql .= "', graintype='2"; |
|
121 else if ($fermentable->GRAINTYPE == 'Kilned') |
|
122 $sql .= "', graintype='3"; |
|
123 else if ($fermentable->GRAINTYPE == 'Sour malt') |
|
124 $sql .= "', graintype='4"; |
|
125 else if ($fermentable->GRAINTYPE == 'Special') |
|
126 $sql .= "', graintype='5"; |
|
127 else if ($fermentable->GRAINTYPE == 'No malt') |
|
128 $sql .= "', graintype='6"; |
|
129 else |
|
130 echo "Unknown GRAINTYPE " . $fermentable->GRAINTYPE . PHP_EOL; |
92 $sql .= "';"; |
131 $sql .= "';"; |
93 if (! $result = mysqli_query($db, $sql)) { |
132 if (! $result = mysqli_query($db, $sql)) { |
94 printf("Error: %s\n", mysqli_error($db)); |
133 printf("Error: %s\n", mysqli_error($db)); |
95 } |
134 } |
96 } |
135 } |