www/includes/db_inventory_hops.php

Sun, 19 Aug 2018 15:36:13 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Sun, 19 Aug 2018 15:36:13 +0200
changeset 30
f5ab22446aa5
parent 19
057a6256bd7b
child 33
2ee6ad5d6f14
permissions
-rw-r--r--

Inventory fermentables and hops to standard weight format.

12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 <?php
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 require($_SERVER['DOCUMENT_ROOT']."/config.php");
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 require($_SERVER['DOCUMENT_ROOT']."/version.php");
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
6
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7 #Connect to the database
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9 if (! $connect) {
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
11 }
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13 // get data and store in a json array
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
14 $query = "SELECT * FROM inventory_hops";
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 if (isset($_GET['insert'])) {
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
16 // INSERT COMMAND
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
17 $sql = "INSERT INTO `inventory_hops` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
18 $sql .= "', alpha='" . $_GET['alpha'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
19 $sql .= "', beta='" . $_GET['beta'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20 $sql .= "', humulene='" . $_GET['humulene'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 $sql .= "', caryophyllene='" . $_GET['caryophyllene'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
22 $sql .= "', cohumulone='" . $_GET['cohumulone'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
23 $sql .= "', myrcene='" . $_GET['myrcene'];
13
b8c3ca152984 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents: 12
diff changeset
24 $sql .= "', hsi='" . $_GET['hsi'];
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
25 $sql .= "', type='" . $_GET['type'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
26 $sql .= "', form='" . $_GET['form'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
27 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
28 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
30 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
30
f5ab22446aa5 Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents: 19
diff changeset
31 $sql .= "', inventory='" . $_GET['inventory'] / 1000.0;
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32 $sql .= "', cost='" . $_GET['cost'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
33 $sql .= "', production_date='" . $_GET['production_date'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
34 $sql .= "', tht_date='" . $_GET['tht_date'];
19
057a6256bd7b Fixed inventory_hops
Michiel Broek <mbroek@mbse.eu>
parents: 18
diff changeset
35 $sql .= "', total_oil='" . $_GET['total_oil'];
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
36 $sql .= "';";
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
37 $result = mysqli_query($connect, $sql);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
38 if (! $result) {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
39 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
40 } else {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
41 syslog(LOG_NOTICE, "db_inventory_hops: inserted ".$_GET['name']);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
42 }
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
43 echo $result;
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
44
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
45 } else if (isset($_GET['update'])) {
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
46 // UPDATE COMMAND
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
47 $sql = "UPDATE `inventory_hops` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
48 $sql .= "', alpha='" . $_GET['alpha'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
49 $sql .= "', beta='" . $_GET['beta'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
50 $sql .= "', humulene='" . $_GET['humulene'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
51 $sql .= "', caryophyllene='" . $_GET['caryophyllene'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
52 $sql .= "', cohumulone='" . $_GET['cohumulone'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
53 $sql .= "', myrcene='" . $_GET['myrcene'];
13
b8c3ca152984 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents: 12
diff changeset
54 $sql .= "', hsi='" . $_GET['hsi'];
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
55 $sql .= "', type='" . $_GET['type'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
56 $sql .= "', form='" . $_GET['form'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
57 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
58 $sql .= "', origin='" . mysqli_real_escape_string($connect, $_GET['origin']);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59 $sql .= "', substitutes='" . mysqli_real_escape_string($connect, $_GET['substitutes']);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
60 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
30
f5ab22446aa5 Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents: 19
diff changeset
61 $sql .= "', inventory='" . $_GET['inventory'] / 1000.0;
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
62 $sql .= "', cost='" . $_GET['cost'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
63 $sql .= "', production_date='" . $_GET['production_date'];
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
64 $sql .= "', tht_date='" . $_GET['tht_date'];
19
057a6256bd7b Fixed inventory_hops
Michiel Broek <mbroek@mbse.eu>
parents: 18
diff changeset
65 $sql .= "', total_oil='" . $_GET['total_oil'];
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66 $sql .= "' WHERE record='" . $_GET['record'] . "';";
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
67 $result = mysqli_query($connect, $sql);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
68 if (! $result) {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
69 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
70 } else {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
71 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
72 }
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73 echo $result;
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
75 } else if (isset($_GET['delete'])) {
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
76 // DELETE COMMAND
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
77 $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
78 $result = mysqli_query($connect, $sql);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
79 if (! $result) {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
80 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
81 } else {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 13
diff changeset
82 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
83 }
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 echo $result;
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
86 } else {
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87 // SELECT COMMAND
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90 $hops[] = array(
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91 'record' => $row['record'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 'name' => $row['name'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 'alpha' => $row['alpha'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94 'beta' => $row['beta'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95 'humulene' => $row['humulene'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96 'caryophyllene' => $row['caryophyllene'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
97 'cohumulone' => $row['cohumulone'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
98 'myrcene' => $row['myrcene'],
13
b8c3ca152984 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents: 12
diff changeset
99 'hsi' => $row['hsi'],
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
100 'type' => $row['type'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
101 'form' => $row['form'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
102 'notes' => $row['notes'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
103 'origin' => $row['origin'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
104 'substitutes' => $row['substitutes'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
105 'always_on_stock' => $row['always_on_stock'],
30
f5ab22446aa5 Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents: 19
diff changeset
106 'inventory' => $row['inventory'] * 1000,
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
107 'cost' => $row['cost'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
108 'production_date' => $row['production_date'],
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
109 'tht_date' => $row['tht_date'],
13
b8c3ca152984 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents: 12
diff changeset
110 'total_oil' => $row['total_oil']
12
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
111 );
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
112 }
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
113 echo json_encode($hops);
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
114 }
c26af32428a4 Added hops inventory
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
115 ?>

mercurial