1 <?php |
1 <?php |
2 //require_once('config.php'); |
2 require_once('config.php'); |
3 //require_once('includes/formulas.php'); |
3 require_once('includes/formulas.php'); |
4 require_once($_SERVER['DOCUMENT_ROOT'].'/config.php'); |
4 //require_once($_SERVER['DOCUMENT_ROOT'].'/config.php'); |
5 require_once($_SERVER['DOCUMENT_ROOT'].'/includes/formulas.php'); |
5 //require_once($_SERVER['DOCUMENT_ROOT'].'/includes/formulas.php'); |
6 |
6 |
7 |
7 |
8 $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
8 $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
9 if (! $link) { |
9 if (! $link) { |
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
183 xmlwriter_end_element($xw); // HOPS |
183 xmlwriter_end_element($xw); // HOPS |
184 |
184 |
185 xmlwriter_start_element($xw, 'FERMENTABLES'); |
185 xmlwriter_start_element($xw, 'FERMENTABLES'); |
186 $arr = json_decode($row['json_fermentables'], true); |
186 $arr = json_decode($row['json_fermentables'], true); |
187 foreach($arr as $item) { //foreach element in $arr |
187 foreach($arr as $item) { //foreach element in $arr |
|
188 if ($item['f_added'] <= 3) { |
188 xmlwriter_start_element($xw, 'FERMENTABLE'); |
189 xmlwriter_start_element($xw, 'FERMENTABLE'); |
189 field($xw, 'VERSION', '1'); |
190 field($xw, 'VERSION', '1'); |
190 field($xw, 'NAME', $item['f_name']); |
191 field($xw, 'NAME', $item['f_name']); |
191 field($xw, 'TYPE', $fermentabletype[$item['f_type']]); |
192 field($xw, 'TYPE', $fermentabletype[$item['f_type']]); |
192 field($xw, 'AMOUNT', sprintf("%.4f",floatval($item['f_amount']))); |
193 field($xw, 'AMOUNT', sprintf("%.4f",floatval($item['f_amount']))); |
206 if (floatval($item['f_max_in_batch'])) |
207 if (floatval($item['f_max_in_batch'])) |
207 field($xw, 'MAX_IN_BATCH', sprintf("%.1f",floatval($item['f_max_in_batch']))); |
208 field($xw, 'MAX_IN_BATCH', sprintf("%.1f",floatval($item['f_max_in_batch']))); |
208 field($xw, 'RECOMMEND_MASH', ($item['f_recommend_mash']) ? 'TRUE':'FALSE'); |
209 field($xw, 'RECOMMEND_MASH', ($item['f_recommend_mash']) ? 'TRUE':'FALSE'); |
209 field($xw, 'GRAINTYPE', $graintype[$item['f_graintype']]); |
210 field($xw, 'GRAINTYPE', $graintype[$item['f_graintype']]); |
210 xmlwriter_end_element($xw); // FERMENTABLE |
211 xmlwriter_end_element($xw); // FERMENTABLE |
|
212 } |
211 } |
213 } |
212 xmlwriter_end_element($xw); // FERMENTABLES |
214 xmlwriter_end_element($xw); // FERMENTABLES |
213 |
215 |
214 xmlwriter_start_element($xw, 'MISCS'); |
216 xmlwriter_start_element($xw, 'MISCS'); |
215 $arr = json_decode($row['json_miscs'], true); |
217 $arr = json_decode($row['json_miscs'], true); |