www/includes/db_inventory_yeasts.php

Sun, 19 Aug 2018 21:46:56 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Sun, 19 Aug 2018 21:46:56 +0200
changeset 33
2ee6ad5d6f14
parent 20
22271f3598ac
child 37
9362eb9e9e5b
permissions
-rw-r--r--

More weight/volmes standards in the database.

14
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 <?php
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 require($_SERVER['DOCUMENT_ROOT']."/config.php");
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 require($_SERVER['DOCUMENT_ROOT']."/version.php");
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6 #Connect to the database
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 if (! $connect) {
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
10 }
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
11
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 // get data and store in a json array
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13 $query = "SELECT * FROM inventory_yeasts";
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
14 if (isset($_GET['insert'])) {
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 // INSERT COMMAND
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
16 $sql = "INSERT INTO `inventory_yeasts` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
17 $sql .= "', type='" . $_GET['type'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
18 $sql .= "', form='" . $_GET['form'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
19 $sql .= "', laboratory='" . mysqli_real_escape_string($connect, $_GET['laboratory']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20 $sql .= "', product_id='" . mysqli_real_escape_string($connect, $_GET['product_id']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 $sql .= "', min_temperature='" . $_GET['min_temperature'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
22 $sql .= "', max_temperature='" . $_GET['max_temperature'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
23 $sql .= "', flocculation='" . $_GET['flocculation'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
24 $sql .= "', attenuation='" . $_GET['attenuation'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
25 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
26 $sql .= "', best_for='" . mysqli_real_escape_string($connect, $_GET['best_for']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
27 $sql .= "', max_reuse='" . $_GET['max_reuse'];
33
2ee6ad5d6f14 More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
28 $sql .= "', inventory='" . floatval($_GET['inventory']) / 1000.0;
14
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29 $sql .= "', cost='" . $_GET['cost'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
30 $sql .= "', production_date='" . $_GET['production_date'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
31 $sql .= "', tht_date='" . $_GET['tht_date'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32 $sql .= "';";
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
33 $result = mysqli_query($connect, $sql);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
34 if (! $result) {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
35 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect));
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
36 } else {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
37 syslog(LOG_NOTICE, "db_inventory_yeasts: inserted ".$_GET['name']);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
38 }
14
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
39 echo $result;
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
40
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
41 } else if (isset($_GET['update'])) {
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
42 // UPDATE COMMAND
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
43 $sql = "UPDATE `inventory_yeasts` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
44 $sql .= "', type='" . $_GET['type'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
45 $sql .= "', form='" . $_GET['form'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
46 $sql .= "', laboratory='" . mysqli_real_escape_string($connect, $_GET['laboratory']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
47 $sql .= "', product_id='" . mysqli_real_escape_string($connect, $_GET['product_id']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
48 $sql .= "', min_temperature='" . $_GET['min_temperature'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
49 $sql .= "', max_temperature='" . $_GET['max_temperature'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
50 $sql .= "', flocculation='" . $_GET['flocculation'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
51 $sql .= "', attenuation='" . $_GET['attenuation'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
52 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
53 $sql .= "', best_for='" . mysqli_real_escape_string($connect, $_GET['best_for']);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
54 $sql .= "', max_reuse='" . $_GET['max_reuse'];
33
2ee6ad5d6f14 More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
55 $sql .= "', inventory='" . floatval($_GET['inventory']) / 1000.0;
14
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
56 $sql .= "', cost='" . $_GET['cost'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
57 $sql .= "', production_date='" . $_GET['production_date'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
58 $sql .= "', tht_date='" . $_GET['tht_date'];
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59 $sql .= "' WHERE record='" . $_GET['record'] . "';";
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
60 $result = mysqli_query($connect, $sql);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
61 if (! $result) {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
62 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect));
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
63 } else {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
64 syslog(LOG_NOTICE, "db_inventory_yeasts: updated record ".$_GET['record']);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
65 }
14
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66 echo $result;
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
67
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
68 } else if (isset($_GET['delete'])) {
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
69 // DELETE COMMAND
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
70 $sql = "DELETE FROM `inventory_yeasts` WHERE record='".$_GET['record']."';";
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
71 $result = mysqli_query($connect, $sql);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
72 if (! $result) {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
73 syslog(LOG_NOTICE, "db_inventory_yeasts: ".$sql." result: ".mysqli_error($connect));
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
74 } else {
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
75 syslog(LOG_NOTICE, "db_inventory_yeasts: deleted record ".$_GET['record']);
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 14
diff changeset
76 }
14
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
77 echo $result;
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79 } else {
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80 // SELECT COMMAND
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
82 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
83 $yeasts[] = array(
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 'record' => $row['record'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85 'name' => $row['name'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
86 'type' => $row['type'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87 'form' => $row['form'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88 'laboratory' => $row['laboratory'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89 'product_id' => $row['product_id'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90 'min_temperature' => $row['min_temperature'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91 'max_temperature' => $row['max_temperature'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 'flocculation' => $row['flocculation'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 'attenuation' => $row['attenuation'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94 'notes' => $row['notes'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95 'best_for' => $row['best_for'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96 'max_reuse' => $row['max_reuse'],
33
2ee6ad5d6f14 More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
97 'inventory' => floatval($row['inventory']) * 1000.0,
14
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
98 'cost' => $row['cost'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
99 'production_date' => $row['production_date'],
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
100 'tht_date' => $row['tht_date']
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
101 );
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
102 }
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
103 echo json_encode($yeasts);
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
104 }
d9dfd703df83 Added yeast inventory screens
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
105 ?>

mercurial