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'], |