Mercurial > bms / annotate

www/includes/db_profile_styles.php@08c92cb740b9 (annotated)

www/includes/db_profile_styles.php

Sat, 17 Nov 2018 19:44:39 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 17 Nov 2018 19:44:39 +0100
changeset 100
08c92cb740b9
parent 77
a9f8de2d7b2b
child 217
318aab371497
permissions
-rw-r--r--

Fix for missing coor info on fermentables during recipes import. Log when srm or ebc values are negatie during conversions. Load setup record in global.inc.php and make some variables available for PHP and JS.

28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 <?php
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 require($_SERVER['DOCUMENT_ROOT']."/config.php");
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 require($_SERVER['DOCUMENT_ROOT']."/version.php");
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6 #Connect to the database
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7 $connect = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 if (! $connect) {
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
10 }
77
a9f8de2d7b2b Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents: 48
diff changeset
11 mysqli_set_charset($connect, "utf8" );
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13 // get data and store in a json array
48
bdd1ec9b9c06 Start recipes import and menus.
Michiel Broek <mbroek@mbse.eu>
parents: 45
diff changeset
14 $query = "SELECT * FROM profile_styles ORDER BY style_guide,style_letter,name";
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 if (isset($_GET['insert'])) {
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
16 // INSERT COMMAND
45
95251bedfab4 Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents: 37
diff changeset
17 $sql = "INSERT INTO `profile_styles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
18 $sql .= "', category='" . mysqli_real_escape_string($connect, $_GET['category']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
19 $sql .= "', category_number='" . $_GET['category_number'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20 $sql .= "', style_letter='" . mysqli_real_escape_string($connect, $_GET['style_letter']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 $sql .= "', style_guide='" . mysqli_real_escape_string($connect, $_GET['style_guide']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
22 $sql .= "', type='" . $_GET['type'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
23 $sql .= "', og_min='" . $_GET['og_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
24 $sql .= "', og_max='" . $_GET['og_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
25 $sql .= "', fg_min='" . $_GET['fg_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
26 $sql .= "', fg_max='" . $_GET['fg_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
27 $sql .= "', ibu_min='" . $_GET['ibu_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
28 $sql .= "', ibu_max='" . $_GET['ibu_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29 $sql .= "', color_min='" . $_GET['color_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
30 $sql .= "', color_max='" . $_GET['color_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
31 $sql .= "', carb_min='" . $_GET['carb_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32 $sql .= "', carb_max='" . $_GET['carb_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
33 $sql .= "', abv_min='" . $_GET['abv_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
34 $sql .= "', abv_max='" . $_GET['abv_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
35 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
36 $sql .= "', profile='" . mysqli_real_escape_string($connect, $_GET['profile']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
37 $sql .= "', ingredients='" . mysqli_real_escape_string($connect, $_GET['ingredients']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
38 $sql .= "', examples='" . mysqli_real_escape_string($connect, $_GET['examples']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
39 $sql .= "';";
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
40 $result = mysqli_query($connect, $sql);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
41 if (! $result) {
45
95251bedfab4 Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents: 37
diff changeset
42 syslog(LOG_NOTICE, "db_profile_styles: ".$sql." result: ".mysqli_error($connect));
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
43 } else {
45
95251bedfab4 Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents: 37
diff changeset
44 syslog(LOG_NOTICE, "db_profile_styles: inserted ".$_GET['name']);
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
45 }
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
46 echo $result;
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
47
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
48 } else if (isset($_GET['update'])) {
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
49 // UPDATE COMMAND
45
95251bedfab4 Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents: 37
diff changeset
50 $sql = "UPDATE `profile_styles` SET name='" . mysqli_real_escape_string($connect, $_GET['name']);
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
51 $sql .= "', category='" . mysqli_real_escape_string($connect, $_GET['category']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
52 $sql .= "', category_number='" . $_GET['category_number'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
53 $sql .= "', style_letter='" . mysqli_real_escape_string($connect, $_GET['style_letter']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
54 $sql .= "', style_guide='" . mysqli_real_escape_string($connect, $_GET['style_guide']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
55 $sql .= "', type='" . $_GET['type'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
56 $sql .= "', og_min='" . $_GET['og_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
57 $sql .= "', og_max='" . $_GET['og_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
58 $sql .= "', fg_min='" . $_GET['fg_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59 $sql .= "', fg_max='" . $_GET['fg_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
60 $sql .= "', ibu_min='" . $_GET['ibu_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
61 $sql .= "', ibu_max='" . $_GET['ibu_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
62 $sql .= "', color_min='" . $_GET['color_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
63 $sql .= "', color_max='" . $_GET['color_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
64 $sql .= "', carb_min='" . $_GET['carb_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
65 $sql .= "', carb_max='" . $_GET['carb_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66 $sql .= "', abv_min='" . $_GET['abv_min'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
67 $sql .= "', abv_max='" . $_GET['abv_max'];
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
68 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_GET['notes']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
69 $sql .= "', profile='" . mysqli_real_escape_string($connect, $_GET['profile']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
70 $sql .= "', ingredients='" . mysqli_real_escape_string($connect, $_GET['ingredients']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
71 $sql .= "', examples='" . mysqli_real_escape_string($connect, $_GET['examples']);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
72 $sql .= "' WHERE record='" . $_GET['record'] . "';";
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73 $result = mysqli_query($connect, $sql);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74 if (! $result) {
45
95251bedfab4 Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents: 37
diff changeset
75 syslog(LOG_NOTICE, "db_profile_styles: ".$sql." result: ".mysqli_error($connect));
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
76 } else {
45
95251bedfab4 Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents: 37
diff changeset
77 syslog(LOG_NOTICE, "db_profile_styles: updated record ".$_GET['record']);
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78 }
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79 echo $result;
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81 } else if (isset($_GET['delete'])) {
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
82 // DELETE COMMAND
45
95251bedfab4 Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents: 37
diff changeset
83 $sql = "DELETE FROM `profile_styles` WHERE record='".$_GET['record']."';";
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 $result = mysqli_query($connect, $sql);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85 if (! $result) {
45
95251bedfab4 Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents: 37
diff changeset
86 syslog(LOG_NOTICE, "db_profile_styles: ".$sql." result: ".mysqli_error($connect));
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87 } else {
45
95251bedfab4 Moved three inventory tables and screens to profiles
Michiel Broek <mbroek@mbse.eu>
parents: 37
diff changeset
88 syslog(LOG_NOTICE, "db_profile_styles: deleted record ".$_GET['record']);
28
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89 }
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90 echo $result;
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 } else {
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 // SELECT COMMAND
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94 $result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96 $styles[] = array(
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
97 'record' => $row['record'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
98 'name' => $row['name'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
99 'category' => $row['category'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
100 'category_number' => $row['category_number'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
101 'style_letter' => $row['style_letter'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
102 'style_guide' => $row['style_guide'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
103 'type' => $row['type'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
104 'og_min' => $row['og_min'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
105 'og_max' => $row['og_max'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
106 'fg_min' => $row['fg_min'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
107 'fg_max' => $row['fg_max'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
108 'ibu_min' => $row['ibu_min'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
109 'ibu_max' => $row['ibu_max'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
110 'color_min' => $row['color_min'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
111 'color_max' => $row['color_max'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
112 'carb_min' => $row['carb_min'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
113 'carb_max' => $row['carb_max'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
114 'abv_min' => $row['abv_min'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
115 'abv_max' => $row['abv_max'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
116 'notes' => $row['notes'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
117 'profile' => $row['profile'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
118 'ingredients' => $row['ingredients'],
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
119 'examples' => $row['examples']
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
120 );
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
121 }
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
122 echo json_encode($styles);
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
123 }
ac959f98e107 Added inventory styles
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
124 ?>

Mercurial Repository: bms

mercurial