www/includes/db_inventory_fermentables.php

changeset 195
2ac491548d8d
parent 77
a9f8de2d7b2b
child 296
69fadd1aded2
equal deleted inserted replaced
194:d202777ebae5 195:2ac491548d8d
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); 10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
11 } 11 }
12 mysqli_set_charset($connect, "utf8" ); 12 mysqli_set_charset($connect, "utf8" );
13 13
14 // get data and store in a json array 14 // get data and store in a json array
15 $query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name"; 15 if (isset($_POST['insert']) || isset($_POST['update'])) {
16 if (isset($_GET['insert'])) { 16 if (isset($_POST['insert'])) {
17 // INSERT COMMAND 17 $sql = "INSERT INTO `inventory_fermentables` SET ";
18 $sql = "INSERT INTO `inventory_fermentables` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); 18 }
19 $sql .= "', type='" . $_GET['type']; 19 if (isset($_POST['update'])) {
20 $sql .= "', yield='" . $_GET['yield']; 20 $sql = "UPDATE `inventory_fermentables` SET ";
21 $sql .= "', color='" . $_GET['color']; 21 }
22 ($_GET['add_after_boil'] == 'true') ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0"; 22
23 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); 23 $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']);
24 $sql .= "', supplier='" . mysqli_real_escape_string($connect, $_GET['supplier']); 24 $sql .= "', type='" . $_POST['type'];
25 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); 25 $sql .= "', yield='" . $_POST['yield'];
26 $sql .= "', coarse_fine_diff='" . $_GET['coarse_fine_diff']; 26 $sql .= "', color='" . $_POST['color'];
27 $sql .= "', moisture='" . $_GET['moisture']; 27 ($_POST['add_after_boil'] == 'true') ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0";
28 $sql .= "', diastatic_power='" . $_GET['diastatic_power']; 28 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_POST['origin']);
29 $sql .= "', protein='" . $_GET['protein']; 29 $sql .= "', supplier='" . mysqli_real_escape_string($connect, $_POST['supplier']);
30 $sql .= "', max_in_batch='" . $_GET['max_in_batch']; 30 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']);
31 ($_GET['recommend_mash'] == 'true') ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0"; 31 $sql .= "', coarse_fine_diff='" . $_POST['coarse_fine_diff'];
32 $sql .= "', ibu_gal_per_lb='" . $_GET['ibu_gal_per_lb']; 32 $sql .= "', moisture='" . $_POST['moisture'];
33 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; 33 $sql .= "', diastatic_power='" . $_POST['diastatic_power'];
34 $sql .= "', di_ph='" . $_GET['di_ph']; 34 $sql .= "', protein='" . $_POST['protein'];
35 $sql .= "', acid_to_ph_57='" . $_GET['acid_to_ph_57']; 35 $sql .= "', dissolved_protein='" . $_POST['dissolved_protein'];
36 $sql .= "', graintype='" . mysqli_real_escape_string($connect, $_GET['graintype']); 36 $sql .= "', max_in_batch='" . $_POST['max_in_batch'];
37 $sql .= "', inventory='" . $_GET['inventory']; 37 ($_POST['recommend_mash'] == 'true') ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0";
38 $sql .= "', cost='" . $_GET['cost']; 38 $sql .= "', added='" . $_POST['added'];
39 $sql .= "', production_date='" . $_GET['production_date']; 39 ($_POST['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
40 $sql .= "', tht_date='" . $_GET['tht_date']; 40 $sql .= "', di_ph='" . $_POST['di_ph'];
41 //$sql .= "', supplier_rec='" . $_GET['supplier_rec']; 41 $sql .= "', acid_to_ph_57='" . $_POST['acid_to_ph_57'];
42 $sql .= "';"; 42 $sql .= "', graintype='" . $_POST['graintype'];
43 $sql .= "', inventory='" . $_POST['inventory'];
44 $sql .= "', cost='" . $_POST['cost'] . "'";
45 if ($_POST['production_date'] == '')
46 $sql .= ", production_date=NULL";
47 else
48 $sql .= ", production_date='" . $_POST['production_date'] . "'";
49 if ($_POST['tht_date'] == '')
50 $sql .= ", tht_date=NULL";
51 else
52 $sql .= ", tht_date='" . $_POST['tht_date'] . "'";
53 if (isset($_POST['insert'])) {
54 $sql .= ";";
55 }
56 if (isset($_POST['update'])) {
57 $sql .= " WHERE record='" . $_POST['record'] . "';";
58 }
59 syslog(LOG_NOTICE, $sql);
60
43 $result = mysqli_query($connect, $sql); 61 $result = mysqli_query($connect, $sql);
44 if (! $result) { 62 if (! $result) {
45 syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect)); 63 syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect));
46 } else { 64 } else {
47 syslog(LOG_NOTICE, "db_inventory_fermentables: inserted ".$_GET['name']); 65 if (isset($_POST['update'])) {
66 syslog(LOG_NOTICE, "db_inventory_fermentables: updated record ".$_POST['record']);
67 } else {
68 $lastid = mysqli_insert_id($connect);
69 syslog(LOG_NOTICE, "db_inventory_fermentables: inserted record ".$lastid);
70 }
48 } 71 }
49 echo $result; 72 echo $result;
50 73
51 } else if (isset($_GET['update'])) { 74 } else if (isset($_POST['delete'])) {
52 // UPDATE COMMAND 75 // DELETE COMMAND
53 $sql = "UPDATE `inventory_fermentables` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); 76 $sql = "DELETE FROM `inventory_fermentables` WHERE record='".$_POST['record']."';";
54 $sql .= "', type='" . $_GET['type'];
55 $sql .= "', yield='" . $_GET['yield'];
56 $sql .= "', color='" . $_GET['color'];
57 ($_GET['add_after_boil'] == 'true') ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0";
58 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']);
59 $sql .= "', supplier='" . mysqli_real_escape_string($connect, $_GET['supplier']);
60 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
61 $sql .= "', coarse_fine_diff='" . $_GET['coarse_fine_diff'];
62 $sql .= "', moisture='" . $_GET['moisture'];
63 $sql .= "', diastatic_power='" . $_GET['diastatic_power'];
64 $sql .= "', protein='" . $_GET['protein'];
65 $sql .= "', max_in_batch='" . $_GET['max_in_batch'];
66 ($_GET['recommend_mash'] == 'true') ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0";
67 $sql .= "', ibu_gal_per_lb='" . $_GET['ibu_gal_per_lb'];
68 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
69 $sql .= "', di_ph='" . $_GET['di_ph'];
70 $sql .= "', acid_to_ph_57='" . $_GET['acid_to_ph_57'];
71 $sql .= "', graintype='" . mysqli_real_escape_string($connect, $_GET['graintype']);
72 $sql .= "', inventory='" . $_GET['inventory'];
73 $sql .= "', cost='" . $_GET['cost'];
74 $sql .= "', production_date='" . $_GET['production_date'];
75 $sql .= "', tht_date='" . $_GET['tht_date'];
76 //$sql .= "', supplier_rec='" . $_GET['supplier_rec'];
77 $sql .= "' WHERE record='" . $_GET['record'] . "';";
78 $result = mysqli_query($connect, $sql); 77 $result = mysqli_query($connect, $sql);
79 if (! $result) { 78 if (! $result) {
80 syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect)); 79 syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect));
81 } else { 80 } else {
82 syslog(LOG_NOTICE, "db_inventory_fermentables: updated record ".$_GET['record']); 81 syslog(LOG_NOTICE, "db_inventory_fermentables: deleted record ".$_POST['record']);
83 }
84 echo $result;
85
86 } else if (isset($_GET['delete'])) {
87 // DELETE COMMAND
88 $sql = "DELETE FROM `inventory_fermentables` WHERE record='".$_GET['record']."';";
89 $result = mysqli_query($connect, $sql);
90 if (! $result) {
91 syslog(LOG_NOTICE, "db_inventory_fermentables: ".$sql." result: ".mysqli_error($connect));
92 } else {
93 syslog(LOG_NOTICE, "db_inventory_fermentables: deleted record ".$_GET['record']);
94 } 82 }
95 echo $result; 83 echo $result;
96 84
97 } else { 85 } else {
98 // SELECT COMMAND 86 // SELECT COMMAND
87 $query = "SELECT * FROM inventory_fermentables ORDER BY supplier,name";
99 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); 88 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
100 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { 89 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
101 $fermentables[] = array( 90 $fermentables[] = array(
102 'record' => $row['record'], 91 'record' => $row['record'],
103 'name' => $row['name'], 92 'name' => $row['name'],
110 'notes' => $row['notes'], 99 'notes' => $row['notes'],
111 'coarse_fine_diff' => $row['coarse_fine_diff'], 100 'coarse_fine_diff' => $row['coarse_fine_diff'],
112 'moisture' => $row['moisture'], 101 'moisture' => $row['moisture'],
113 'diastatic_power' => $row['diastatic_power'], 102 'diastatic_power' => $row['diastatic_power'],
114 'protein' => $row['protein'], 103 'protein' => $row['protein'],
104 'dissolved_protein' => $row['dissolved_protein'],
115 'max_in_batch' => $row['max_in_batch'], 105 'max_in_batch' => $row['max_in_batch'],
116 'recommend_mash' => $row['recommend_mash'], 106 'recommend_mash' => $row['recommend_mash'],
117 'ibu_gal_per_lb' => $row['ibu_gal_per_lb'], 107 'added' => $row['added'],
118 'always_on_stock' => $row['always_on_stock'], 108 'always_on_stock' => $row['always_on_stock'],
119 'di_ph' => $row['di_ph'], 109 'di_ph' => $row['di_ph'],
120 'acid_to_ph_57' => $row['acid_to_ph_57'], 110 'acid_to_ph_57' => $row['acid_to_ph_57'],
121 'graintype' => $row['graintype'], 111 'graintype' => $row['graintype'],
122 'inventory' => $row['inventory'], 112 'inventory' => $row['inventory'],

mercurial