Sun, 11 Jul 2021 15:55:44 +0200
More efficient code for get*sources.php form dropdown lists.
27 | 1 | <?php |
2 | require($_SERVER['DOCUMENT_ROOT']."/config.php"); | |
3 | require($_SERVER['DOCUMENT_ROOT']."/version.php"); | |
4 | ||
5 | #Connect to the database | |
6 | $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME); | |
7 | if (! $connect) { | |
8 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
9 | } | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
37
diff
changeset
|
10 | mysqli_set_charset($connect, "utf8" ); |
27 | 11 | |
766
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
12 | $response = array( |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
13 | 'error' => false, |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
14 | 'msg' => 'Ok', |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
15 | ); |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
16 | |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
17 | if (isset($_POST['insert']) || isset($_POST['update'])) { |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
18 | if (isset($_POST['insert'])) { |
115
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
19 | // INSERT COMMAND |
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
20 | $sql = "INSERT INTO `inventory_equipments` SET "; |
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
21 | } |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
22 | if (isset($_POST['update'])) { |
115
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
23 | // UPDATE COMMAND |
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
24 | $sql = "UPDATE `inventory_equipments` SET "; |
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
25 | } |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
26 | $sql .= "name='" . mysqli_real_escape_string($connect, $_POST['name']); |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
27 | $sql .= "', boil_size='" . $_POST['boil_size']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
28 | $sql .= "', batch_size='" . $_POST['batch_size']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
29 | $sql .= "', tun_volume='" . $_POST['tun_volume']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
30 | $sql .= "', tun_weight='" . $_POST['tun_weight']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
31 | $sql .= "', tun_specific_heat='" . $_POST['tun_specific_heat']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
32 | $sql .= "', tun_material='" . $_POST['tun_material']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
33 | $sql .= "', tun_height='" . floatval($_POST['tun_height']) / 100.0; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
34 | $sql .= "', top_up_water='" . $_POST['top_up_water']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
35 | $sql .= "', trub_chiller_loss='" . $_POST['trub_chiller_loss']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
36 | $sql .= "', evap_rate='" . $_POST['evap_rate']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
37 | $sql .= "', boil_time='" . $_POST['boil_time']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
38 | ($_POST['calc_boil_volume'] == 'true') ? $sql .= "', calc_boil_volume='1" : $sql .= "', calc_boil_volume='0"; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
39 | $sql .= "', top_up_kettle='" . $_POST['top_up_kettle']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
40 | $sql .= "', hop_utilization='" . $_POST['hop_utilization']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
41 | $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
42 | $sql .= "', lauter_volume='" . $_POST['lauter_volume']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
43 | $sql .= "', lauter_height='" . floatval($_POST['lauter_height']) / 100.0; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
44 | $sql .= "', lauter_deadspace='" . $_POST['lauter_deadspace']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
45 | $sql .= "', kettle_volume='" . $_POST['kettle_volume']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
46 | $sql .= "', kettle_height='" . floatval($_POST['kettle_height']) / 100.0; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
47 | $sql .= "', mash_volume='" . $_POST['mash_volume']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
48 | $sql .= "', mash_max='" . $_POST['mash_max']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
49 | $sql .= "', efficiency='" . $_POST['efficiency']; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
50 | if (isset($_POST['insert'])) { |
115
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
51 | $sql .= "';"; |
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
52 | } |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
53 | if (isset($_POST['update'])) { |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
54 | $sql .= "' WHERE record='" . $_POST['record'] . "';"; |
115
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
55 | } |
27 | 56 | $result = mysqli_query($connect, $sql); |
57 | if (! $result) { | |
58 | syslog(LOG_NOTICE, "db_inventory_equipment: ".$sql." result: ".mysqli_error($connect)); | |
766
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
59 | $response['error'] = true; |
767
08c0343b622b
Improved error handling for inventory equipments, fermentables, hops, miscs, suppliers, water and yeasts.
Michiel Broek <mbroek@mbse.eu>
parents:
766
diff
changeset
|
60 | $response['msg'] = "SQL fout: ".mysqli_error($connect); |
27 | 61 | } |
766
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
62 | exit(json_encode($response)); |
27 | 63 | |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
64 | } else if (isset($_POST['delete'])) { |
766
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
65 | // DELETE COMMAND. check if this record is in use. |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
66 | $sql = "SELECT name FROM `inventory_equipments` WHERE record='".$_POST['record']."';"; |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
67 | $result = mysqli_query($connect, $sql) or die("SQL Error 1: " . mysqli_error($connect)); |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
68 | if (! $result) { |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
69 | syslog(LOG_NOTICE, "db_inventory_equipment: ".$sql." result: ".mysqli_error($connect)); |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
70 | $response['error'] = true; |
767
08c0343b622b
Improved error handling for inventory equipments, fermentables, hops, miscs, suppliers, water and yeasts.
Michiel Broek <mbroek@mbse.eu>
parents:
766
diff
changeset
|
71 | $response['msg'] = "SQL fout: ".mysqli_error($connect); |
766
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
72 | exit(json_encode($response)); |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
73 | } |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
74 | if ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
75 | $sql = "SELECT eq_name FROM products WHERE eq_name='" . $row['name'] . "';"; |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
76 | $result2 = mysqli_query($connect, $sql); |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
77 | $ar = mysqli_affected_rows($connect); |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
78 | if ($ar > 0) { |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
79 | $response['error'] = true; |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
80 | $response['msg'] = "Installatie wordt ".$ar." maal gebruikt."; |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
81 | exit(json_encode($response)); |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
82 | } |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
83 | } |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
84 | // Record not used, delete it. |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
85 | $sql = "DELETE FROM `inventory_equipments` WHERE record='".$_POST['record']."';"; |
27 | 86 | $result = mysqli_query($connect, $sql); |
87 | if (! $result) { | |
88 | syslog(LOG_NOTICE, "db_inventory_equipment: ".$sql." result: ".mysqli_error($connect)); | |
766
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
89 | $response['error'] = true; |
767
08c0343b622b
Improved error handling for inventory equipments, fermentables, hops, miscs, suppliers, water and yeasts.
Michiel Broek <mbroek@mbse.eu>
parents:
766
diff
changeset
|
90 | $response['msg'] = "SQL fout: ".mysqli_error($connect); |
27 | 91 | } |
766
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
92 | exit(json_encode($response)); |
27 | 93 | |
94 | } else { | |
95 | // SELECT COMMAND | |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
96 | $query = "SELECT * FROM inventory_equipments ORDER BY name"; |
27 | 97 | $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect)); |
98 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
99 | $equipments[] = array( | |
100 | 'record' => $row['record'], | |
101 | 'name' => $row['name'], | |
102 | 'boil_size' => $row['boil_size'], | |
103 | 'batch_size' => $row['batch_size'], | |
104 | 'tun_volume' => $row['tun_volume'], | |
105 | 'tun_weight' => $row['tun_weight'], | |
115
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
106 | 'tun_specific_heat' => $row['tun_specific_heat'], |
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
107 | 'tun_material' => $row['tun_material'], |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
108 | 'tun_height' => floatval($row['tun_height']) * 100.0, |
27 | 109 | 'top_up_water' => $row['top_up_water'], |
110 | 'trub_chiller_loss' => $row['trub_chiller_loss'], | |
111 | 'evap_rate' => $row['evap_rate'], | |
112 | 'boil_time' => $row['boil_time'], | |
115
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
113 | 'calc_boil_volume' => $row['calc_boil_volume'], |
27 | 114 | 'top_up_kettle' => $row['top_up_kettle'], |
115 | 'hop_utilization' => $row['hop_utilization'], | |
116 | 'notes' => $row['notes'], | |
117 | 'lauter_volume' => $row['lauter_volume'], | |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
118 | 'lauter_height' => floatval($row['lauter_height']) * 100.0, |
115
ad31f4bd4036
Inventory database script added missing fields. Product database script added JOIN with the prod_recipes table.
Michiel Broek <mbroek@mbse.eu>
parents:
77
diff
changeset
|
119 | 'lauter_deadspace' => $row['lauter_deadspace'], |
27 | 120 | 'kettle_volume' => $row['kettle_volume'], |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
149
diff
changeset
|
121 | 'kettle_height' => floatval($row['kettle_height']) * 100.0, |
27 | 122 | 'mash_volume' => $row['mash_volume'], |
149
ff45488d480e
Added some icons from Brewersfriend. They should be replaced someday. Added maximum mash weight setting to the equipment database. Usefull for brew automate and RIMS systems. During recipes import acid and base additions are translated. Brews and recipes now have 2 water sources. Added water mixer. Added basic water treatment, but not for pH yet. Redesigned the fermentables and water tabs.
Michiel Broek <mbroek@mbse.eu>
parents:
116
diff
changeset
|
123 | 'mash_max' => $row['mash_max'], |
27 | 124 | 'efficiency' => $row['efficiency'] |
125 | ); | |
126 | } | |
296
69fadd1aded2
Updated design document. Add content header application/json to all scripts that produce json output. Chart prints show the beer code and name in the header. Charts don't display the menu anymore.
Michiel Broek <mbroek@mbse.eu>
parents:
209
diff
changeset
|
127 | header("Content-type: application/json"); |
766
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
128 | exit(json_encode($equipments)); |
27 | 129 | } |
766
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
130 | |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
131 | syslog(LOG_NOTICE, "db_inventory_equipment: missing arguments"); |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
132 | $response['error'] = true; |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
133 | $response['msg'] = "missing arguments"; |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
134 | echo json_encode($response); |
86289b0c4a27
Version 0.3.38. Better error handling in inventory equipments. Check if equipment is in use before delete.
Michiel Broek <mbroek@mbse.eu>
parents:
715
diff
changeset
|
135 | |
27 | 136 | ?> |