Key.php (8806B) download
1<?php
2class Key
3{
4
5 protected array $data;
6 function retrieveData($key)
7 {
8 $validKeys = [
9 ':3jvl7yb5sRr80s6lTdeOyxV9VTQZkCPRp7bKOWKFWxfL2vhsU4Hhpgcmz9qe0zEk' => 'retrieveZooData',
10 ':ae9c50dc5cd58c538a0d6aedb17fffedcaffd568d22381dab3ae72baaeb24684' => 'retrieveRBData',
11 ];
12 if (array_key_exists($key['data'], $validKeys)) {
13 $method = $validKeys[$key['data']];
14 $this->$method($key);
15 } else {
16 echo "You have no access here!";
17 }
18 }
19
20 function retrieveZooData($key){
21 $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "panda");
22 $weather_data = [];
23 $query = "SELECT distinct windchill, city, date
24 FROM retrieve_zoos
25 AND date = curdate()
26 GROUP BY city
27 ";
28
29 $stmt = mysqli_prepare($db, $query);
30 $stmt->execute();
31 $data = $stmt->get_result();
32
33 while ($row = $data->fetch_assoc()) {
34 $wind_chill = windchill($row["temperature"], $row["wind_speed"]);
35 $weather_data[] = [
36 'windchill' => $wind_chill,
37 'location' => $row['city'],
38// 'country' => $row['country']
39 ];
40 }
41 header('Content-Type: application/json');
42 echo json_encode($weather_data);
43 }
44
45 function retrieveRBData($key)
46 {
47 $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "wap2");
48 $weather_data = [];
49 $query = "SELECT distinct temperature, dew_point, nl.name as city, date_time
50 FROM weather_data wd
51 JOIN station s ON wd.station_name = s.name
52 JOIN contract_station cs ON cs.station_name = s.name
53 JOIN nearestlocation nl ON nl.station_name = s.name
54 JOIN country co ON co.country_code = nl.country_code
55 JOIN geolocation geo ON geo.country_code = co.country_code
56 JOIN contract c ON cs.contract_id = c.contract_id
57 WHERE c.token = 'ae9c50dc5cd58c538a0d6aedb17fffedcaffd568d22381dab3ae72baaeb24684'
58 ";
59 $stmt = mysqli_prepare($db, $query);
60 $stmt->execute();
61 $data = $stmt->get_result();
62
63 while ($row = $data->fetch_assoc()) {
64 $humidity = humid($row["temperature"], $row["dew_point"]);
65 $weather_data[] = [
66 'humidity' => $humidity,
67 'location' => $row['city'],
68 'datetime' => $row['date_time']
69 ];
70
71 }
72
73 header('Content-Type: application/json');
74 echo json_encode($weather_data);
75 }
76
77
78 function retrieveHumidityTable($key, $generateXml = false)
79 {
80 $html = '<table>';
81 $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "wap2");
82 $query = "SELECT distinct temperature, dew_point, nl.name as city, date_time
83 FROM weather_data wd
84 JOIN station s ON wd.station_name = s.name
85 JOIN contract_station cs ON cs.station_name = s.name
86 JOIN nearestlocation nl ON nl.station_name = s.name
87 JOIN country co ON co.country_code = nl.country_code
88 JOIN geolocation geo ON geo.country_code = co.country_code
89 JOIN contract c ON cs.contract_id = c.contract_id
90 WHERE c.token = ?
91 ORDER BY date_time DESC";
92 $stmt = mysqli_prepare($db, $query);
93 $stmt->bind_param("s", $key);
94 $stmt->execute();
95 $data = $stmt->get_result();
96
97 $results = array();
98
99 $table1 = '<tr><th id="tabledate" colspan="4">Chengdu Humidity Data</th></tr>';
100 $table1 .= '<tr><th>Date</th><th>Humidity</th></tr>';
101 $table2 = '<tr><th id="tabledate" colspan="4">Kangding Humidity Data</th></tr>';
102 $table2 .= '<tr><th>Date</th><th>Humidity</th></tr>';
103 $xml1 = '<location name="Chengdu">';
104 $xml2 = '<location name="Kangding">';
105 while ($row = $data->fetch_assoc()) {
106 $humidity = humid($row["temperature"], $row["dew_point"]);
107 $current_date = $row['date_time'];
108 $correct_date = date("d M Y H:i:s", strtotime($current_date));
109 $city = $row['city'];
110
111 $results[$city] = array();
112
113 $results[$city][] = array(
114 'date' => $correct_date,
115 'humidity' => $humidity
116 );
117
118 // Table and Generate XML
119 if ($city == 'Chengdu') {
120 $table1 .= '<tr><td>' . $correct_date . '</td><td>' . $humidity . '</td></tr>';
121 $xml1 .= '<data>' . '<date>' . $correct_date . '</date><humidity>' . $humidity . '</humidity>' . '</data>';
122 } else {
123 $table2 .= '<tr><td>' . $correct_date . '</td><td>' . $humidity . '</td></tr>';
124 $xml2 .= '<data>' . '<date>' . $correct_date . '</date><humidity>' . $humidity . '</humidity>' . '</data>';
125 }
126 }
127 $xml1 .= '</location>';
128 $xml2 .= '</location>';
129 $xml = $xml1 . $xml2;
130 $html .= $table1 . $table2;
131 if ($generateXml) {
132 return $xml; // Return SimpleXMLElement object
133 }
134 return $html;
135 }
136
137
138 function retrieveHData($key, $generateXml = false)
139 {
140 $html = '';
141 $citycity = '';
142 $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "wap2");
143 $query = "SELECT distinct temperature, wind_speed, dew_point, DATE(date_time) AS date, nl.name as city
144 FROM weather_data wd
145 JOIN station s ON wd.station_name = s.name
146 JOIN contract_station cs ON cs.station_name = s.name
147 JOIN nearestlocation nl ON nl.station_name = s.name
148 JOIN country co ON co.country_code = nl.country_code
149 JOIN geolocation geo ON geo.country_code = co.country_code
150 JOIN contract c ON cs.contract_id = c.contract_id
151 WHERE c.token = ?
152 ORDER BY date DESC, temperature, wind_speed
153 ";
154
155 $stmt = mysqli_prepare($db, $query);
156 $stmt->bind_param("s", $key);
157 $stmt->execute();
158 $data = $stmt->get_result();
159 $xml = '<WCTPD name="Windchill corrected temperature per day">';
160
161 $results = array();
162 $locations = array();
163
164 while ($row = $data->fetch_assoc()) {
165 $wind_chill = windchill($row["temperature"], $row["wind_speed"]);
166 $current_date = $row['date'];
167 $city = $row['city'];
168
169 if (!isset($results[$current_date])) {
170 $results[$current_date] = array();
171 $locations[$current_date] = array();
172 }
173
174 if (!in_array($city, $locations[$current_date]) && count($results[$current_date]) < 5) {
175 $results[$current_date][] = array(
176 'city' => $city,
177 'windchill' => $wind_chill,
178 );
179
180 $locations[$current_date][] = $city;
181 }
182 }
183 $html .= $this->retrieveHumidityTable('ae9c50dc5cd58c538a0d6aedb17fffedcaffd568d22381dab3ae72baaeb24684');
184
185 $html .= '<table id="htmlTable">';
186 $html .= '<div class="space"></div>';
187 $html .= '<div class="content-title"><h2>Windchill corrected temperature per day</h2></div>';
188
189 foreach ($results as $date => $entries) {
190 $html .= '<tr><th id="tabledate" colspan="4">' . date("d M Y", strtotime($date)) . '</th></tr>';
191 $html .= '<tr><th>Location</th><th>Windchill</th></tr>';
192
193 foreach ($entries as $entry) {
194 $xml .= '<data city="' . $entry['city'] . '">' . '<wind_chill>' . $entry['windchill'] . '</wind_chill>' . '</data>';
195 $html .= '<tr>';
196 $html .= '<td>' . $entry['city'] . '</td>';
197 $html .= '<td>' . $entry['windchill'] . '</td>';
198 $html .= '</tr>';
199 }
200 }
201
202 $html .= '</table>';
203 $html .= '<a href="?downloadXml=true" class="download-button">Download XML</a>';
204 $xml .= '</WCTPD>';
205 if ($generateXml) {
206 return $xml; // Return SimpleXMLElement object
207 }
208 return $html;
209 }
210}
211
212function windchill($temp, $wind): float
213{
214 $result = 13.12 + 0.6215 * $temp - 11.37 * pow($wind, 0.16) + 0.3965 * $temp * pow($wind, 0.16);
215 return round($result, 2);
216}
217
218function humid($temp, $dewp): float|int
219{
220 $specific_humidity = exp((17.625 * $dewp) / (243.04 + $dewp));
221 $saturation_point = exp((17.625 * $temp) / (243.04 + $temp));
222
223 return round(($specific_humidity / $saturation_point) * 100, 2);
224}
225
226function checkHumid($temp, $dewp): string
227{
228 $humidity = humid($temp, $dewp);
229 if ($humidity < 50) {
230 return "warning";
231 } else {
232 return "dontchu worry";
233 }
234}
235?>