comparison: www/includes/db_inventory_water.php
www/includes/db_inventory_water.php
- changeset 47
- 94cd5ac04b6a
- parent 46
- ff9be9dbcac0
- child 77
- a9f8de2d7b2b
equal
deleted
inserted
replaced
| 46:ff9be9dbcac0 | 47:94cd5ac04b6a |
|---|---|
| 13 * If a new default will be set, clear the old default. | 13 * If a new default will be set, clear the old default. |
| 14 */ | 14 */ |
| 15 function clear_default() { | 15 function clear_default() { |
| 16 global $connect; | 16 global $connect; |
| 17 | 17 |
| 18 $usql = "UPDATE inventory_water SET default_water='0' WHERE (default_water = '1');"; | 18 $usql = "UPDATE inventory_waters SET default_water='0' WHERE (default_water = '1');"; |
| 19 $result = mysqli_query($connect, $usql); | 19 $result = mysqli_query($connect, $usql); |
| 20 if (! $result) { | 20 if (! $result) { |
| 21 syslog(LOG_NOTICE, "db_inventory_water: " . $usql . " result: ".mysqli_error($connect)); | 21 syslog(LOG_NOTICE, "db_inventory_waters: " . $usql . " result: ".mysqli_error($connect)); |
| 22 } | 22 } |
| 23 } | 23 } |
| 24 | 24 |
| 25 | 25 |
| 26 // get data and store in a json array | 26 // get data and store in a json array |
| 27 $query = "SELECT * FROM inventory_water ORDER BY name"; | 27 $query = "SELECT * FROM inventory_waters ORDER BY name"; |
| 28 if (isset($_GET['insert'])) { | 28 if (isset($_GET['insert'])) { |
| 29 // INSERT COMMAND | 29 // INSERT COMMAND |
| 30 $sql = "INSERT INTO `inventory_water` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | 30 $sql = "INSERT INTO `inventory_waters` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
| 31 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | 31 ($_GET['unlimited_stock'] == 'true') ? $sql .= "', unlimited_stock='1" : $sql .= "', unlimited_stock='0"; |
| 32 $sql .= "', calcium='" . $_GET['calcium']; | 32 $sql .= "', calcium='" . $_GET['calcium']; |
| 33 $sql .= "', bicarbonate='" . $_GET['bicarbonate']; | 33 $sql .= "', bicarbonate='" . $_GET['bicarbonate']; |
| 34 $sql .= "', sulfate='" . $_GET['sulfate']; | 34 $sql .= "', sulfate='" . $_GET['sulfate']; |
| 35 $sql .= "', chloride='" . $_GET['chloride']; | 35 $sql .= "', chloride='" . $_GET['chloride']; |
| 36 $sql .= "', sodium='" . $_GET['sodium']; | 36 $sql .= "', sodium='" . $_GET['sodium']; |
| 47 $sql .= "', inventory='" . $_GET['inventory']; | 47 $sql .= "', inventory='" . $_GET['inventory']; |
| 48 $sql .= "', cost='" . $_GET['cost']; | 48 $sql .= "', cost='" . $_GET['cost']; |
| 49 $sql .= "';"; | 49 $sql .= "';"; |
| 50 $result = mysqli_query($connect, $sql); | 50 $result = mysqli_query($connect, $sql); |
| 51 if (! $result) { | 51 if (! $result) { |
| 52 syslog(LOG_NOTICE, "db_inventory_water: ".$sql." result: ".mysqli_error($connect)); | 52 syslog(LOG_NOTICE, "db_inventory_waters: ".$sql." result: ".mysqli_error($connect)); |
| 53 } else { | 53 } else { |
| 54 syslog(LOG_NOTICE, "db_inventory_water: inserted ".$_GET['name']); | 54 syslog(LOG_NOTICE, "db_inventory_waters: inserted ".$_GET['name']); |
| 55 } | 55 } |
| 56 echo $result; | 56 echo $result; |
| 57 | 57 |
| 58 } else if (isset($_GET['update'])) { | 58 } else if (isset($_GET['update'])) { |
| 59 // UPDATE COMMAND | 59 // UPDATE COMMAND |
| 60 $sql = "UPDATE `inventory_water` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); | 60 $sql = "UPDATE `inventory_waters` SET name='" . mysqli_real_escape_string($connect, $_GET['name']); |
| 61 ($_GET['always_on_stock'] == 'true') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | 61 ($_GET['unlimited_stock'] == 'true') ? $sql .= "', unlimited_stock='1" : $sql .= "', unlimited_stock='0"; |
| 62 $sql .= "', calcium='" . $_GET['calcium']; | 62 $sql .= "', calcium='" . $_GET['calcium']; |
| 63 $sql .= "', bicarbonate='" . $_GET['bicarbonate']; | 63 $sql .= "', bicarbonate='" . $_GET['bicarbonate']; |
| 64 $sql .= "', sulfate='" . $_GET['sulfate']; | 64 $sql .= "', sulfate='" . $_GET['sulfate']; |
| 65 $sql .= "', chloride='" . $_GET['chloride']; | 65 $sql .= "', chloride='" . $_GET['chloride']; |
| 66 $sql .= "', sodium='" . $_GET['sodium']; | 66 $sql .= "', sodium='" . $_GET['sodium']; |
| 77 $sql .= "', inventory='" . $_GET['inventory']; | 77 $sql .= "', inventory='" . $_GET['inventory']; |
| 78 $sql .= "', cost='" . $_GET['cost']; | 78 $sql .= "', cost='" . $_GET['cost']; |
| 79 $sql .= "' WHERE record='" . $_GET['record'] . "';"; | 79 $sql .= "' WHERE record='" . $_GET['record'] . "';"; |
| 80 $result = mysqli_query($connect, $sql); | 80 $result = mysqli_query($connect, $sql); |
| 81 if (! $result) { | 81 if (! $result) { |
| 82 syslog(LOG_NOTICE, "db_inventory_water: ".$sql." result: ".mysqli_error($connect)); | 82 syslog(LOG_NOTICE, "db_inventory_waters: ".$sql." result: ".mysqli_error($connect)); |
| 83 } else { | 83 } else { |
| 84 syslog(LOG_NOTICE, "db_inventory_water: updated record ".$_GET['record']); | 84 syslog(LOG_NOTICE, "db_inventory_waters: updated record ".$_GET['record']); |
| 85 } | 85 } |
| 86 echo $result; | 86 echo $result; |
| 87 | 87 |
| 88 } else if (isset($_GET['delete'])) { | 88 } else if (isset($_GET['delete'])) { |
| 89 // DELETE COMMAND | 89 // DELETE COMMAND |
| 90 $sql = "DELETE FROM `inventory_water` WHERE record='".$_GET['record']."';"; | 90 $sql = "DELETE FROM `inventory_waters` WHERE record='".$_GET['record']."';"; |
| 91 $result = mysqli_query($connect, $sql); | 91 $result = mysqli_query($connect, $sql); |
| 92 if (! $result) { | 92 if (! $result) { |
| 93 syslog(LOG_NOTICE, "db_inventory_water: ".$sql." result: ".mysqli_error($connect)); | 93 syslog(LOG_NOTICE, "db_inventory_waters: ".$sql." result: ".mysqli_error($connect)); |
| 94 } else { | 94 } else { |
| 95 syslog(LOG_NOTICE, "db_inventory_water: deleted record ".$_GET['record']); | 95 syslog(LOG_NOTICE, "db_inventory_waters: deleted record ".$_GET['record']); |
| 96 } | 96 } |
| 97 echo $result; | 97 echo $result; |
| 98 | 98 |
| 99 } else { | 99 } else { |
| 100 // SELECT COMMAND | 100 // SELECT COMMAND |
| 101 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); | 101 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
| 102 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | 102 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 103 $waters[] = array( | 103 $waters[] = array( |
| 104 'record' => $row['record'], | 104 'record' => $row['record'], |
| 105 'name' => $row['name'], | 105 'name' => $row['name'], |
| 106 'always_on_stock' => $row['always_on_stock'], | 106 'unlimited_stock' => $row['unlimited_stock'], |
| 107 'calcium' => $row['calcium'], | 107 'calcium' => $row['calcium'], |
| 108 'bicarbonate' => $row['bicarbonate'], | 108 'bicarbonate' => $row['bicarbonate'], |
| 109 'sulfate' => $row['sulfate'], | 109 'sulfate' => $row['sulfate'], |
| 110 'chloride' => $row['chloride'], | 110 'chloride' => $row['chloride'], |
| 111 'sodium' => $row['sodium'], | 111 'sodium' => $row['sodium'], |
