www/includes/db_product.php

changeset 857
150485d06b30
parent 842
897bf2a43253
equal deleted inserted replaced
856:2ae5a4697a45 857:150485d06b30
71 $sql .= "', eq_kettle_volume='" . $_POST['eq_kettle_volume']; 71 $sql .= "', eq_kettle_volume='" . $_POST['eq_kettle_volume'];
72 $sql .= "', eq_kettle_height='" . $_POST['eq_kettle_height']; 72 $sql .= "', eq_kettle_height='" . $_POST['eq_kettle_height'];
73 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume']; 73 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume'];
74 $sql .= "', eq_mash_max='" . $_POST['eq_mash_max']; 74 $sql .= "', eq_mash_max='" . $_POST['eq_mash_max'];
75 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency']; 75 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency'];
76 $sql .= "', eq_HLT_volume='" . $_POST['eq_HLT_volume'];
77 $sql .= "', eq_HLT_deadspace='" . $_POST['eq_HLT_deadspace'];
76 // brewdate 78 // brewdate
77 if ($_POST['brew_date_start'] == '') 79 if ($_POST['brew_date_start'] == '')
78 $sql .= "', brew_date_start=NULL"; 80 $sql .= "', brew_date_start=NULL";
79 else 81 else
80 $sql .= "', brew_date_start='" . $_POST['brew_date_start'] . "'"; 82 $sql .= "', brew_date_start='" . $_POST['brew_date_start'] . "'";
245 $sql .= "', wb_sulfate='" . $_POST['wb_sulfate']; 247 $sql .= "', wb_sulfate='" . $_POST['wb_sulfate'];
246 $sql .= "', wb_chloride='" . $_POST['wb_chloride']; 248 $sql .= "', wb_chloride='" . $_POST['wb_chloride'];
247 $sql .= "', wb_sodium='" . $_POST['wb_sodium']; 249 $sql .= "', wb_sodium='" . $_POST['wb_sodium'];
248 $sql .= "', wb_magnesium='" . $_POST['wb_magnesium']; 250 $sql .= "', wb_magnesium='" . $_POST['wb_magnesium'];
249 $sql .= "', wb_total_alkalinity='" . $_POST['wb_total_alkalinity']; 251 $sql .= "', wb_total_alkalinity='" . $_POST['wb_total_alkalinity'];
250 $sql .= "', wb_ph='" . $_POST['wb_ph']; 252 $sql .= "', wb_ph='" . $_POST['wb_ph'];
253 $sql .= "', tw_name='" . $_POST['tw_name'];
254 $sql .= "', tw_calcium='" . $_POST['tw_calcium'];
255 $sql .= "', tw_sulfate='" . $_POST['tw_sulfate'];
256 $sql .= "', tw_chloride='" . $_POST['tw_chloride'];
257 $sql .= "', tw_sodium='" . $_POST['tw_sodium'];
258 $sql .= "', tw_magnesium='" . $_POST['tw_magnesium'];
259 $sql .= "', tw_total_alkalinity='" . $_POST['tw_total_alkalinity'];
260 $sql .= "', tw_ph='" . $_POST['tw_ph'];
251 $sql .= "', wa_acid_name='" . $_POST['wa_acid_name']; 261 $sql .= "', wa_acid_name='" . $_POST['wa_acid_name'];
252 $sql .= "', wa_acid_perc='" . $_POST['wa_acid_perc']; 262 $sql .= "', wa_acid_perc='" . $_POST['wa_acid_perc'];
253 $sql .= "', wa_base_name='" . $_POST['wa_base_name']; 263 $sql .= "', wa_base_name='" . $_POST['wa_base_name'];
254 if ($_POST['starter_enable'] == 0) { 264 if ($_POST['starter_enable'] == 0) {
255 $sql .= "', starter_enable='0', starter_type='0', starter_sg='1.037', starter_viability='97"; 265 $sql .= "', starter_enable='0', starter_type='0', starter_sg='1.037', starter_viability='97";
716 $brew .= ',"eq_chiller_type":' . $row['eq_chiller_type']; 726 $brew .= ',"eq_chiller_type":' . $row['eq_chiller_type'];
717 $brew .= ',"eq_chiller_to79":' . floatval($row['eq_chiller_to79']); 727 $brew .= ',"eq_chiller_to79":' . floatval($row['eq_chiller_to79']);
718 $brew .= ',"eq_chiller_volume":' . floatval($row['eq_chiller_volume']); 728 $brew .= ',"eq_chiller_volume":' . floatval($row['eq_chiller_volume']);
719 $brew .= ',"eq_chiller_lpm":' . floatval($row['eq_chiller_lpm']); 729 $brew .= ',"eq_chiller_lpm":' . floatval($row['eq_chiller_lpm']);
720 $brew .= ',"eq_chiller_loss":' . floatval($row['eq_chiller_loss']); 730 $brew .= ',"eq_chiller_loss":' . floatval($row['eq_chiller_loss']);
731 $brew .= ',"eq_HLT_volume":' . floatval($row['eq_HLT_volume']);
732 $brew .= ',"eq_HLT_deadspace":' . floatval($row['eq_HLT_deadspace']);
721 $brew .= ',"brew_date_start":"' . $row['brew_date_start']; 733 $brew .= ',"brew_date_start":"' . $row['brew_date_start'];
722 $brew .= '","brew_mash_ph":' . floatval($row['brew_mash_ph']); 734 $brew .= '","brew_mash_ph":' . floatval($row['brew_mash_ph']);
723 $brew .= ',"brew_mash_sg":' . floatval($row['brew_mash_sg']); 735 $brew .= ',"brew_mash_sg":' . floatval($row['brew_mash_sg']);
724 $brew .= ',"brew_mash_efficiency":' . floatval($row['brew_mash_efficiency']); 736 $brew .= ',"brew_mash_efficiency":' . floatval($row['brew_mash_efficiency']);
725 $brew .= ',"brew_sparge_est":' . floatval($row['brew_sparge_est']); 737 $brew .= ',"brew_sparge_est":' . floatval($row['brew_sparge_est']);
863 $brew .= ',"wb_sulfate":' . floatval($row['wb_sulfate']); 875 $brew .= ',"wb_sulfate":' . floatval($row['wb_sulfate']);
864 $brew .= ',"wb_chloride":' . floatval($row['wb_chloride']); 876 $brew .= ',"wb_chloride":' . floatval($row['wb_chloride']);
865 $brew .= ',"wb_sodium":' . floatval($row['wb_sodium']); 877 $brew .= ',"wb_sodium":' . floatval($row['wb_sodium']);
866 $brew .= ',"wb_magnesium":' . floatval($row['wb_magnesium']); 878 $brew .= ',"wb_magnesium":' . floatval($row['wb_magnesium']);
867 $brew .= ',"wb_total_alkalinity":' . floatval($row['wb_total_alkalinity']); 879 $brew .= ',"wb_total_alkalinity":' . floatval($row['wb_total_alkalinity']);
868 $brew .= ',"wb_ph":' . floatval($row['wb_ph']); 880 $brew .= ',"wb_ph":' . floatval($row['wb_ph']);
881 $brew .= ',"tw_name":"' . str_replace($escapers, $replacements, $row['tw_name']);
882 $brew .= '","tw_calcium":' . floatval($row['tw_calcium']);
883 $brew .= ',"tw_sulfate":' . floatval($row['tw_sulfate']);
884 $brew .= ',"tw_chloride":' . floatval($row['tw_chloride']);
885 $brew .= ',"tw_sodium":' . floatval($row['tw_sodium']);
886 $brew .= ',"tw_magnesium":' . floatval($row['tw_magnesium']);
887 $brew .= ',"tw_total_alkalinity":' . floatval($row['tw_total_alkalinity']);
888 $brew .= ',"tw_ph":' . floatval($row['tw_ph']);
869 $brew .= ',"wa_acid_name":' . $row['wa_acid_name']; 889 $brew .= ',"wa_acid_name":' . $row['wa_acid_name'];
870 $brew .= ',"wa_acid_perc":' . $row['wa_acid_perc']; 890 $brew .= ',"wa_acid_perc":' . $row['wa_acid_perc'];
871 $brew .= ',"wa_base_name":' . $row['wa_base_name']; 891 $brew .= ',"wa_base_name":' . $row['wa_base_name'];
872 $brew .= ',"starter_enable":' . $row['starter_enable']; 892 $brew .= ',"starter_enable":' . $row['starter_enable'];
873 $brew .= ',"starter_type":' . $row['starter_type']; 893 $brew .= ',"starter_type":' . $row['starter_type'];

mercurial