commit f3bdf1e8de440e89d2fbeb73d22182b0db90ee2a
parent 1d075f55986f112b62464ff3b8b47f2103c0aa8b
Author: LennartSchroot <[email protected]>
Date: Mon, 12 Jun 2023 23:49:10 +0200
Update Key.php
Diffstat:
| M | Model/Key.php | 86 | +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ |
1 file changed, 86 insertions(+), 0 deletions(-)
diff --git a/Model/Key.php b/Model/Key.php
@@ -71,6 +71,92 @@ Class Key{
header('Content-Type: application/json');
echo json_encode($weather_data);
}
+
+ function retrieveHData($key, $generateXml = false) {
+ $html = '';
+ $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "wap2");
+ $query = "SELECT distinct temperature, wind_speed, dew_point, DATE(date_time) AS date, nl.name as city
+ FROM weather_data wd
+ JOIN station s ON wd.station_name = s.name
+ JOIN contract_station cs ON cs.station_name = s.name
+ JOIN nearestlocation nl ON nl.station_name = s.name
+ JOIN country co ON co.country_code = nl.country_code
+ JOIN geolocation geo ON geo.country_code = co.country_code
+ JOIN contract c ON cs.contract_id = c.contract_id
+ WHERE c.token = '3jvl/yb?sRr80s6lTdeOyxV9VTQZkCPRp/bKOWKFWxfL2vhsU4Hhpgcmz9qe0zEk'
+ ORDER BY date DESC, temperature, wind_speed
+ ";
+
+ $stmt = mysqli_prepare($db, $query);
+ $stmt->execute();
+ $data = $stmt->get_result();
+
+ $results = array();
+ $locations = array();
+
+ while ($row = $data->fetch_assoc()) {
+ $humidity = humid($row["temperature"], $row["dew_point"]);
+ $wind_chill = windchill($row["temperature"], $row["wind_speed"]);
+ $current_date = $row['date'];
+ $city = $row['city'];
+
+ if (!isset($results[$current_date])) {
+ $results[$current_date] = array();
+ $locations[$current_date] = array();
+ }
+
+ if (!in_array($city, $locations[$current_date]) && count($results[$current_date]) < 5) {
+ $results[$current_date][] = array(
+ 'city' => $city,
+ 'windchill' => $wind_chill,
+ 'humidity' => $humidity
+ );
+
+ $locations[$current_date][] = $city;
+ }
+ }
+
+ $html .= '<table>';
+
+ foreach ($results as $date => $entries) {
+ $html .= '<tr><th id="tabledate" colspan="4">' . $date . '</th></tr>';
+ $html .= '<tr><th>Location</th><th>Windchill</th></tr>';
+
+ foreach ($entries as $entry) {
+ $html .= '<tr>';
+ $html .= '<td>'.$entry['city'].'</td>';
+ $html .= '<td>'.$entry['windchill'].'</td>';
+ $html .= '</tr>';
+ }
+ }
+
+ $html .= '</table>';
+
+ if ($generateXml) {
+ $xml = new SimpleXMLElement('<data></data>');
+
+ foreach ($results as $date => $entries) {
+ $dateElement = $xml->addChild('date', $date);
+
+ foreach ($entries as $entry) {
+ $locationElement = $dateElement->addChild('location');
+ $locationElement->addChild('city', $entry['city']);
+ $locationElement->addChild('windchill', $entry['windchill']);
+ }
+ }
+
+ $xmlString = $xml->asXML();
+
+ header('Content-Type: application/xml');
+ header('Content-Disposition: attachment; filename="data.xml"');
+
+ echo $xmlString;
+ exit();
+ }
+ $html .= '<a href="?downloadXml=true" class="download-button">Download XML</a>';
+
+ return $html;
+ }
}
function windchill($temp, $wind): float
