comparison: www/import/from_brouwhulp.php
www/import/from_brouwhulp.php
- changeset 107
- 8b4fdadf320c
- parent 106
- c64d979613ab
- child 108
- a466373bc23f
equal
deleted
inserted
replaced
| 106:c64d979613ab | 107:8b4fdadf320c |
|---|---|
| 1099 $rsql .= "', est_color='" . floatval($color); | 1099 $rsql .= "', est_color='" . floatval($color); |
| 1100 $rsql .= "';"; | 1100 $rsql .= "';"; |
| 1101 if (! $rresult = mysqli_query($db, $rsql)) { | 1101 if (! $rresult = mysqli_query($db, $rsql)) { |
| 1102 printf("Error: %s\n", mysqli_error($db)); | 1102 printf("Error: %s\n", mysqli_error($db)); |
| 1103 } | 1103 } |
| 1104 $psql .= "', code='" . mysqli_real_escape_string($db, $recipe->NR_RECIPE); | |
| 1104 | 1105 |
| 1105 if ($recipe->EQUIPMENT) { | 1106 if ($recipe->EQUIPMENT) { |
| 1106 $psql .= "', eq_name='" . mysqli_real_escape_string($db, $recipe->EQUIPMENT->NAME); | 1107 $psql .= "', eq_name='" . mysqli_real_escape_string($db, $recipe->EQUIPMENT->NAME); |
| 1107 $psql .= "', eq_boil_size='" . floatval($recipe->EQUIPMENT->BOIL_SIZE); | 1108 $psql .= "', eq_boil_size='" . floatval($recipe->EQUIPMENT->BOIL_SIZE); |
| 1108 $psql .= "', eq_batch_size='" . floatval($recipe->EQUIPMENT->BATCH_SIZE); | 1109 $psql .= "', eq_batch_size='" . floatval($recipe->EQUIPMENT->BATCH_SIZE); |
| 1125 $psql .= "', eq_kettle_height='" . floatval($recipe->EQUIPMENT->KETTLE_HEIGHT); | 1126 $psql .= "', eq_kettle_height='" . floatval($recipe->EQUIPMENT->KETTLE_HEIGHT); |
| 1126 $psql .= "', eq_mash_volume='" . floatval($recipe->EQUIPMENT->MASH_VOLUME); | 1127 $psql .= "', eq_mash_volume='" . floatval($recipe->EQUIPMENT->MASH_VOLUME); |
| 1127 $psql .= "', eq_efficiency='" . floatval($recipe->EQUIPMENT->EFFICIENCY); | 1128 $psql .= "', eq_efficiency='" . floatval($recipe->EQUIPMENT->EFFICIENCY); |
| 1128 } | 1129 } |
| 1129 | 1130 |
| 1131 if (($recipe->DATE) && ($recipe->TIME_STARTED) && ($recipe->TIME_ENDED)) { | |
| 1132 /* We have brew data */ | |
| 1133 $date_start = substr($recipe->DATE, 6, 4).substr($recipe->DATE,2,4).substr($recipe->DATE,0,2).' '.$recipe->TIME_STARTED; | |
| 1134 $date_end = substr($recipe->DATE, 6, 4).substr($recipe->DATE,2,4).substr($recipe->DATE,0,2).' '.$recipe->TIME_ENDED; | |
| 1135 $psql .= "', brew_date_start='" . $date_start; | |
| 1136 | |
| 1137 if ($recipe->PH_ADJUSTED) | |
| 1138 $psql .= "', brew_mash_ph='" . floatval($recipe->PH_ADJUSTED); | |
| 1139 if (floatval($recipe->SG_END_MASH) != 1.0) | |
| 1140 $psql .= "', brew_mash_sg='" . floatval($recipe->SG_END_MASH); | |
| 1141 if ($recipe->MASH->SPARGE_TEMP) | |
| 1142 $psql .= "', brew_sparge_temperature='" . floatval($recipe->MASH->SPARGE_TEMP); | |
| 1143 if ($recipe->VOLUME_HLT) | |
| 1144 $psql .= "', brew_sparge_volume='" . floatval($recipe->VOLUME_HLT); | |
| 1145 if ($recipe->VOLUME_BEFORE_BOIL) | |
| 1146 $psql .= "', brew_preboil_volume='" . floatval($recipe->VOLUME_BEFORE_BOIL); | |
| 1147 if (floatval($recipe->OG_BEFORE_BOIL) != 1.0) | |
| 1148 $psql .= "', brew_preboil_sg='" . floatval($recipe->OG_BEFORE_BOIL); | |
| 1149 if ($recipe->PH_BEFORE_BOIL) | |
| 1150 $psql .= "', brew_preboil_ph='" . floatval($recipe->PH_BEFORE_BOIL); | |
| 1151 if ($recipe->VOLUME_AFTER_BOIL) | |
| 1152 $psql .= "', brew_aboil_volume='" . floatval($recipe->VOLUME_AFTER_BOIL); | |
| 1153 $psql .= "', brew_aboil_sg='" . floatval($recipe->OG); | |
| 1154 if ($recipe->PH_AFTER_BOIL) | |
| 1155 $psql .= "', brew_aboil_ph='" . floatval($recipe->PH_AFTER_BOIL); | |
| 1156 if ($recipe->ACTUAL_EFFICIENCY) | |
| 1157 $psql .= "', brew_aboil_efficiency='" . floatval($recipe->ACTUAL_EFFICIENCY); | |
| 1158 $psql .= "', brew_whirlpool2='" . floatval($recipe->WHIRLPOOL_TIME); | |
| 1159 $psql .= "', brew_cooling_method='" . mysqli_real_escape_string($db, $recipe->COOLING_METHOD); | |
| 1160 $psql .= "', brew_cooling_time='" . floatval($recipe->COOLING_TIME); | |
| 1161 $psql .= "', brew_cooling_to='" . floatval($recipe->COOLING_TO); | |
| 1162 if ($recipe->VOLUME_FERMENTER) | |
| 1163 $psql .= "', brew_fermenter_volume='" . floatval($recipe->VOLUME_FERMENTER); | |
| 1164 if ($recipe->EQUIPMENT->TOP_UP_WATER_BREWDAY) | |
| 1165 $psql .= "', brew_fermenter_extrawater='" . floatval($recipe->EQUIPMENT->TOP_UP_WATER_BREWDAY); | |
| 1166 $psql .= "', brew_fermenter_sg='" . floatval($recipe->OG_FERMENTER); | |
| 1167 $psql .= "', brew_fermenter_ibu='" . floatval($recipe->IBU); | |
| 1168 $psql .= "', brew_aeration_type='" . mysqli_real_escape_string($db, $recipe->AERATION_TYPE); | |
| 1169 if ($recipe->AERATION_TYPE != "None") { | |
| 1170 $psql .= "', brew_aeration_speed='" . floatval($recipe->AERATION_SPEED); | |
| 1171 $psql .= "', brew_aeration_time='" . floatval($recipe->AERATION_TIME); | |
| 1172 } | |
| 1173 $psql .= "', brew_date_end='" . $date_end; | |
| 1174 echo $date_start . PHP_EOL; | |
| 1175 } | |
| 1176 /* | |
| 1177 * AGE = onduidelijk | |
| 1178 * INVENTORY_REDUCED | |
| 1179 * LOCKED | |
| 1180 * ABV | |
| 1181 */ | |
| 1182 | |
| 1183 /* | |
| 1184 * FERMENTATION_STAGES | |
| 1185 * PRIMARY_AGE | |
| 1186 * PRIMARY_TEMP | |
| 1187 * SECONDARY_AGE | |
| 1188 * SECONDARY_TEMP | |
| 1189 * TERTIARY_AGE | |
| 1190 * TERTIARY_TEMP | |
| 1191 * SG_END_PRIMARY | |
| 1192 * START_TEMP_PRIMARY | |
| 1193 * MAX_TEMP_PRIMARY | |
| 1194 * END_TEMP_PRIMARY | |
| 1195 */ | |
| 1196 | |
| 1197 /* | |
| 1198 * DATE_BOTTLING | |
| 1199 * AMOUNT_BOTTLING | |
| 1200 * CARBONATION | |
| 1201 * FORCED_CARB_KEGS | |
| 1202 * AMOUNT_PRIMING | |
| 1203 * AMOUNT_PRIMING_KEGS | |
| 1204 * KEG_PRESSURE | |
| 1205 * PRIMING_SUGAR_BOTTLES | |
| 1206 * PRIMING_SUGAR_KEGS | |
| 1207 */ | |
| 1208 /* | |
| 1209 * TASTE | |
| 1210 * TASTE_NOTES | |
| 1211 * TASTING_RATE | |
| 1212 * TASTE_DATE | |
| 1213 * TASTE_COLOR | |
| 1214 * TASTE_TRANSPARENCY | |
| 1215 * TASTE_HEAD | |
| 1216 * TASTE_AROMA | |
| 1217 * TASTE_TASTE | |
| 1218 * TASTE_MOUTHFEEL | |
| 1219 * TASTE_AFTERTASTE | |
| 1220 */ | |
| 1130 $psql .= "';"; | 1221 $psql .= "';"; |
| 1131 if (! $presult = mysqli_query($db, $psql)) { | 1222 if (! $presult = mysqli_query($db, $psql)) { |
| 1132 printf("Error: %s\n", mysqli_error($db)); | 1223 printf("Error: %s\n", mysqli_error($db)); |
| 1133 } | 1224 } |
| 1134 } | 1225 } |
