From d137be0ad4fcf4afafc88cf3f464cee63095d482 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Thu, 22 Oct 2020 15:48:32 +0200
Subject: [statistics_reporting] Fix json types, add duration field

---
 modules-available/statistics_reporting/inc/queries.inc.php | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/modules-available/statistics_reporting/inc/queries.inc.php b/modules-available/statistics_reporting/inc/queries.inc.php
index 47a07375..fc61c68a 100644
--- a/modules-available/statistics_reporting/inc/queries.inc.php
+++ b/modules-available/statistics_reporting/inc/queries.inc.php
@@ -384,11 +384,14 @@ class Queries
 						AND dateline BETWEEN :from AND :to", $data);
 			} else {
 				$data['locs'] = explode(',', $row['locs']);
-				$exam = Database::queryFirst("SELECT Count(*) AS `event`, Avg(s.data) AS length FROM statistic s
+				$exam = Database::queryFirst("SELECT Count(*) AS `sessions`, Avg(s.data) AS length FROM statistic s
 						INNER JOIN machine m USING (machineuuid)
 						WHERE typeid = '~session-length' AND m.locationid IN (:locs)
 						AND dateline BETWEEN :from AND :to", $data);
 			}
+			settype($exam['length'], 'int');
+			settype($exam['sessions'], 'int');
+			$exam['duration'] = $row['endtime'] - $row['starttime'];
 			$return[] = $exam;
 		}
 		return $return;
-- 
cgit v1.2.3-55-g7522