From 6f7e155ea0dd7f0e5894ec133be313bbdb4589ba Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Fri, 23 Mar 2018 09:14:32 +0100
Subject: web-scripts/statistics.php: add option to chose time axis differently

---
 web-scripts/statistics.php | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'web-scripts')

diff --git a/web-scripts/statistics.php b/web-scripts/statistics.php
index 01bbb52..c919f93 100644
--- a/web-scripts/statistics.php
+++ b/web-scripts/statistics.php
@@ -1,5 +1,10 @@
 <?php
 
+if (isset($_GET["from"]))
+  $min_time="from_base64(\"" . base64_encode("-".$_GET["from"]) . "\")";
+else
+  $min_time="\"-7 00:00:00\"";
+
 $mysql = new mysqli("localhost", "webserver", "empty", "buildmaster");
 if ($mysql->connect_error) {
   die("Connection failed: " . $mysql->connect_error);
@@ -19,7 +24,7 @@ if (! $result = $mysql -> query(
     "`statistics`.`blocked_tasks_count`," .
     "`statistics`.`next_tasks_count`" .
     "FROM `statistics` " .
-    "WHERE `statistics`.`date`>=ADDTIME(NOW(),\"-7 00:00:00\") " .
+    "WHERE `statistics`.`date`>=ADDTIME(NOW()," . $min_time . ") " .
     "ORDER BY `statistics`.`date`"
   ))
   die($mysql->error);
-- 
cgit v1.2.3