www/includes/db_product.php

changeset 617
f962f1e5936e
parent 616
2cbf21bb9bdc
child 667
1246550451ca
equal deleted inserted replaced
616:2cbf21bb9bdc 617:f962f1e5936e
263 $sql .= "', prop3_type='" . $_POST['prop3_type']; 263 $sql .= "', prop3_type='" . $_POST['prop3_type'];
264 $sql .= "', prop3_volume='" . $_POST['prop3_volume']; 264 $sql .= "', prop3_volume='" . $_POST['prop3_volume'];
265 $sql .= "', prop4_type='" . $_POST['prop4_type']; 265 $sql .= "', prop4_type='" . $_POST['prop4_type'];
266 $sql .= "', prop4_volume='" . $_POST['prop4_volume']; 266 $sql .= "', prop4_volume='" . $_POST['prop4_volume'];
267 } 267 }
268 $sql .= "', divide_type='" . $_POST['divide_type']; 268 if ($_POST['yeast_prod_date'] == '')
269 $sql .= "', yeast_prod_date=NULL";
270 else
271 $sql .= "', yeast_prod_date='" . $_POST['yeast_prod_date'] . "'";
272 $sql .= ", divide_type='" . $_POST['divide_type'];
269 $sql .= "', divide_size='" . floatval($_POST['divide_size']); 273 $sql .= "', divide_size='" . floatval($_POST['divide_size']);
270 $sql .= "', divide_factor='" . floatval($_POST['divide_factor']); 274 $sql .= "', divide_factor='" . floatval($_POST['divide_factor']);
271 $sql .= "', divide_parts='" . $_POST['divide_parts']; 275 $sql .= "', divide_parts='" . $_POST['divide_parts'];
272 $sql .= "', divide_part='" . $_POST['divide_part']; 276 $sql .= "', divide_part='" . $_POST['divide_part'];
273 //syslog(LOG_NOTICE, $sql); 277 //syslog(LOG_NOTICE, $sql);
867 $brew .= ',"wa_base_name":' . $row['wa_base_name']; 871 $brew .= ',"wa_base_name":' . $row['wa_base_name'];
868 $brew .= ',"starter_enable":' . $row['starter_enable']; 872 $brew .= ',"starter_enable":' . $row['starter_enable'];
869 $brew .= ',"starter_type":' . $row['starter_type']; 873 $brew .= ',"starter_type":' . $row['starter_type'];
870 $brew .= ',"starter_sg":' . $row['starter_sg']; 874 $brew .= ',"starter_sg":' . $row['starter_sg'];
871 $brew .= ',"starter_viability":' . $row['starter_viability']; 875 $brew .= ',"starter_viability":' . $row['starter_viability'];
872 $brew .= ',"prop1_type":' . $row['prop1_type']; 876 $brew .= ',"yeast_prod_date":"' . $row['yeast_prod_date'];
877 $brew .= '","prop1_type":' . $row['prop1_type'];
873 $brew .= ',"prop1_volume":' . $row['prop1_volume']; 878 $brew .= ',"prop1_volume":' . $row['prop1_volume'];
874 $brew .= ',"prop2_type":' . $row['prop2_type']; 879 $brew .= ',"prop2_type":' . $row['prop2_type'];
875 $brew .= ',"prop2_volume":' . $row['prop2_volume']; 880 $brew .= ',"prop2_volume":' . $row['prop2_volume'];
876 $brew .= ',"prop3_type":' . $row['prop3_type']; 881 $brew .= ',"prop3_type":' . $row['prop3_type'];
877 $brew .= ',"prop3_volume":' . $row['prop3_volume']; 882 $brew .= ',"prop3_volume":' . $row['prop3_volume'];

mercurial