hanze/iwa-panda2

key looks for measurements from cuurent date (a21abe8c9d7d15d7888bc31984bec6337e6f9f62)
Repositories | README.md
commit a21abe8c9d7d15d7888bc31984bec6337e6f9f62
parent b4dc5397444e56b3e223d6832229752d86d7ba1e
Author: Johs <[email protected]>
Date:   Tue, 13 Jun 2023 12:42:28 +0200

key looks for measurements from cuurent date

Diffstat:

MModel/Key.php2+-


1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/Model/Key.php b/Model/Key.php
@@ -25,7 +25,7 @@ Class Key{

                   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' 
-                    AND date(wd.date_time) = '2023-06-13'
+                    AND date(wd.date_time) = date(curdate())
                   GROUP BY nl.name
                   ";