www/import/from_brouwhulp.php

changeset 195
2ac491548d8d
parent 175
da16371538c3
child 196
531d5458782f
equal deleted inserted replaced
194:d202777ebae5 195:2ac491548d8d
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 }

mercurial