hanze/iwa-panda2

commit b4dc5397444e56b3e223d6832229752d86d7ba1e
parent 318cdab830a4a421e19683e3991e436499510820
Author: Johs <[email protected]>
Date:   Tue, 13 Jun 2023 12:38:45 +0200

key looks for measurements from today

Diffstat:
M
Model/Key.php
6
++++--

1 file changed, 4 insertions(+), 2 deletions(-)
diff --git a/Model/Key.php b/Model/Key.php
@@ -24,8 +24,10 @@ Class Key{

                   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'
-                  GROUP BY nl.name";
+                  WHERE c.token = '3jvl/yb?sRr80s6lTdeOyxV9VTQZkCPRp/bKOWKFWxfL2vhsU4Hhpgcmz9qe0zEk' 
+                    AND date(wd.date_time) = '2023-06-13'
+                  GROUP BY nl.name
+                  ";
 
         $stmt = mysqli_prepare($db, $query);
         $stmt->execute();

Generated by gitin!