Fri, 28 Dec 2018 23:18:42 +0100
Some pH calculations cane use twice as much loops, probably because we have better float precision then the original pascal code. More variables to prevent html reads. Use predicted mash pH (the grist in demi water) to calculate the pH shift from the tapwater to the target pH. It's better but not right yet. Or it is right and brouwhulp is far off.
12 | 1 | <?php |
2 | ||
3 | require($_SERVER['DOCUMENT_ROOT']."/config.php"); | |
4 | require($_SERVER['DOCUMENT_ROOT']."/version.php"); | |
5 | ||
18
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
6 | |
12 | 7 | #Connect to the database |
8 | $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | |
9 | if (! $connect) { | |
10 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
11 | } | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
37
diff
changeset
|
12 | mysqli_set_charset($connect, "utf8" ); |
12 | 13 | |
14 | // get data and store in a json array | |
37
9362eb9e9e5b
Sorting the inventory and changes some grid tables.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
15 | $query = "SELECT * FROM inventory_hops ORDER BY origin,name"; |
12 | 16 | if (isset($_GET['insert'])) { |
17 | // INSERT COMMAND | |
18 | $sql = "INSERT INTO `inventory_hops` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | |
19 | $sql .= "', alpha='" . $_GET['alpha']; | |
20 | $sql .= "', beta='" . $_GET['beta']; | |
21 | $sql .= "', humulene='" . $_GET['humulene']; | |
22 | $sql .= "', caryophyllene='" . $_GET['caryophyllene']; | |
23 | $sql .= "', cohumulone='" . $_GET['cohumulone']; | |
24 | $sql .= "', myrcene='" . $_GET['myrcene']; | |
13 | 25 | $sql .= "', hsi='" . $_GET['hsi']; |
12 | 26 | $sql .= "', type='" . $_GET['type']; |
27 | $sql .= "', form='" . $_GET['form']; | |
28 | $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | |
29 | $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); | |
30 | $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); | |
31 | ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
32 | $sql .= "', inventory='" . floatval($_GET['inventory']) / 1000.0; |
12 | 33 | $sql .= "', cost='" . $_GET['cost']; |
34 | $sql .= "', production_date='" . $_GET['production_date']; | |
35 | $sql .= "', tht_date='" . $_GET['tht_date']; | |
19 | 36 | $sql .= "', total_oil='" . $_GET['total_oil']; |
12 | 37 | $sql .= "';"; |
18
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
38 | $result = mysqli_query($connect, $sql); |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
39 | if (! $result) { |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
40 | syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
41 | } else { |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
42 | syslog(LOG_NOTICE, "db_inventory_hops: inserted ".$_GET['name']); |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
43 | } |
12 | 44 | echo $result; |
45 | ||
46 | } else if (isset($_GET['update'])) { | |
47 | // UPDATE COMMAND | |
48 | $sql = "UPDATE `inventory_hops` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | |
49 | $sql .= "', alpha='" . $_GET['alpha']; | |
50 | $sql .= "', beta='" . $_GET['beta']; | |
51 | $sql .= "', humulene='" . $_GET['humulene']; | |
52 | $sql .= "', caryophyllene='" . $_GET['caryophyllene']; | |
53 | $sql .= "', cohumulone='" . $_GET['cohumulone']; | |
54 | $sql .= "', myrcene='" . $_GET['myrcene']; | |
13 | 55 | $sql .= "', hsi='" . $_GET['hsi']; |
12 | 56 | $sql .= "', type='" . $_GET['type']; |
57 | $sql .= "', form='" . $_GET['form']; | |
58 | $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']); | |
59 | $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']); | |
60 | $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']); | |
61 | ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
62 | $sql .= "', inventory='" . floatval($_GET['inventory']) / 1000.0; |
12 | 63 | $sql .= "', cost='" . $_GET['cost']; |
64 | $sql .= "', production_date='" . $_GET['production_date']; | |
65 | $sql .= "', tht_date='" . $_GET['tht_date']; | |
19 | 66 | $sql .= "', total_oil='" . $_GET['total_oil']; |
12 | 67 | $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
18
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
68 | $result = mysqli_query($connect, $sql); |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
69 | if (! $result) { |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
70 | syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
71 | } else { |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
72 | syslog(LOG_NOTICE, "db_inventory_hops: updated record ".$_GET['record']); |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
73 | } |
12 | 74 | echo $result; |
75 | ||
76 | } else if (isset($_GET['delete'])) { | |
77 | // DELETE COMMAND | |
78 | $sql = "DELETE FROM `inventory_hops` WHERE record='".$_GET['record']."';"; | |
18
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
79 | $result = mysqli_query($connect, $sql); |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
80 | if (! $result) { |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
81 | syslog(LOG_NOTICE, "db_inventory_hops: ".$sql." result: ".mysqli_error($connect)); |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
82 | } else { |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
83 | syslog(LOG_NOTICE, "db_inventory_hops: deleted record ".$_GET['record']); |
395833e20f88
Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents:
13
diff
changeset
|
84 | } |
12 | 85 | echo $result; |
86 | ||
87 | } else { | |
88 | // SELECT COMMAND | |
89 | $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | |
90 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
91 | $hops[] = array( | |
92 | 'record' => $row['record'], | |
93 | 'name' => $row['name'], | |
94 | 'alpha' => $row['alpha'], | |
95 | 'beta' => $row['beta'], | |
96 | 'humulene' => $row['humulene'], | |
97 | 'caryophyllene' => $row['caryophyllene'], | |
98 | 'cohumulone' => $row['cohumulone'], | |
99 | 'myrcene' => $row['myrcene'], | |
13 | 100 | 'hsi' => $row['hsi'], |
12 | 101 | 'type' => $row['type'], |
102 | 'form' => $row['form'], | |
103 | 'notes' => $row['notes'], | |
104 | 'origin' => $row['origin'], | |
105 | 'substitutes' => $row['substitutes'], | |
106 | 'always_on_stock' => $row['always_on_stock'], | |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
107 | 'inventory' => floatval($row['inventory']) * 1000.0, |
12 | 108 | 'cost' => $row['cost'], |
109 | 'production_date' => $row['production_date'], | |
110 | 'tht_date' => $row['tht_date'], | |
13 | 111 | 'total_oil' => $row['total_oil'] |
12 | 112 | ); |
113 | } | |
114 | echo json_encode($hops); | |
115 | } | |
116 | ?> |