iwa-panda2

commit 786a19f736fd1217db14790bb7aed2afccc9d1ca
parent 4a205fa01e1dc2d5dee6fe1814cbbc5798896490
Author: LennartSchroot <[email protected]>
Date:   Thu, 29 Jun 2023 17:03:52 +0200

meuk

Diffstat:
M
.idea/workspace.xml
 | 
2
++
A
Controller/api/api.php
 | 
64
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
M
index.php
 | 
4
++++

3 files changed, 70 insertions(+), 0 deletions(-)
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
@@ -5,6 +5,7 @@
   </component>
   <component name="ChangeListManager">
     <list default="true" id="f1ac0514-5d96-49e8-8c16-ecccecd1bbe1" name="Changes" comment="">
+      <change afterPath="$PROJECT_DIR$/Controller/api/api.php" afterDir="false" />
       <change beforePath="$PROJECT_DIR$/.idea/workspace.xml" beforeDir="false" afterPath="$PROJECT_DIR$/.idea/workspace.xml" afterDir="false" />
       <change beforePath="$PROJECT_DIR$/index.php" beforeDir="false" afterPath="$PROJECT_DIR$/index.php" afterDir="false" />
     </list>
@@ -51,6 +52,7 @@
       <workItem from="1688047906916" duration="295000" />
       <workItem from="1688048224856" duration="968000" />
       <workItem from="1688049596887" duration="774000" />
+      <workItem from="1688050748885" duration="268000" />
     </task>
     <servers />
   </component>
diff --git a/Controller/api/api.php b/Controller/api/api.php
@@ -0,0 +1,64 @@
+<?php
+
+function storeZooData($dataArray): void{
+    if ($dataArray)
+        $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "panda");
+    $query = "INSERT INTO retrieve_zoos (city, wind_chill, date, country) VALUES (?, ?, ?, ?)";
+    $stmt = mysqli_prepare($db, $query);
+
+    foreach ($dataArray as $data) {
+        $city = $data->city;
+        $windchill = $data->windchill;
+        $date = $data->date;
+        $country = $data->country;
+
+        $stmt->bind_param("sdss", $city, $windchill, $date, $country);
+        $stmt->execute();
+    }
+
+    $stmt->close();
+    $db->close();
+}
+
+function storeFacData($dataArray): void{
+    $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "panda");
+    $query = "INSERT INTO retrieve_facilities (city, date_time, humidity) VALUES (?, ?, ?)";
+    $stmt = mysqli_prepare($db, $query);
+
+    foreach ($dataArray as $data) {
+        $city = $data->city;
+        $humidity = $data->humidity;
+        $date_time = $data->date_time;
+
+        $stmt->bind_param("ssd", $city, $date_time, $humidity);
+        $stmt->execute();
+    }
+
+    $stmt->close();
+    $db->close();
+}
+
+function get_windchill(){
+    $token = '3jvl/yb?sRr80s6lTdeOyxV9VTQZkCPRp/bKOWKFWxfL2vhsU4Hhpgcmz9qe0zEk';
+    if(isset($vars['since'])){
+        $since = $vars['since'];
+    }else{
+        $since = "curdate()";
+    }
+    $url = 'http://86.92.67.21/api/windchill/' . $since;
+    $connect = new Model\Connect($url, $token);
+    $response = $connect->connect();
+    storeZooData($response);
+};
+function get_graph(){
+    $token = 'ae9c50dc5cd58c538a0d6aedb17fffedcaffd568d22381dab3ae72baaeb24684';
+    if(isset($vars['since'])){
+        $since = $vars['since'];
+    }else{
+        $since = "curdate()";
+    }
+    $url = 'http://86.92.67.21/api/graph/' . $since;
+    $connect = new Model\Connect($url, $token);
+    $response = $connect->connect();
+    storeFacData($response);
+};
diff --git a/index.php b/index.php
@@ -20,6 +20,8 @@ $router->addRoute(["POST", "GET"], "/logout", $logout);
 $router->addRoute(["GET"], "/api/:data", function ($key) {
     $weather_data = [];
     if($key['data'] == ':3jvl7yb5sRr80s6lTdeOyxV9VTQZkCPRp7bKOWKFWxfL2vhsU4Hhpgcmz9qe0zEk') {
+        include 'Controller/api/api.php';
+        get_windchill();
         $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "panda");
         $query = "SELECT city, min(wind_chill) as wind_chill, country
                   FROM retrieve_zoos
@@ -41,6 +43,8 @@ $router->addRoute(["GET"], "/api/:data", function ($key) {
         header('Content-Type: application/json');
         echo json_encode($weather_data);
     } elseif($key['data'] == ':ae9c50dc5cd58c538a0d6aedb17fffedcaffd568d22381dab3ae72baaeb24684') {
+        include 'Controller/api/api.php';
+        get_graph();
         $db = new mysqli("86.92.67.21", "friedel", "hailiwa", "panda");
         $weather_data = [];
         $query = "SELECT distinct humidity, city, date_time