diff options
author | Simon Rettberg | 2020-10-22 15:48:32 +0200 |
---|---|---|
committer | Simon Rettberg | 2020-10-22 15:48:32 +0200 |
commit | d137be0ad4fcf4afafc88cf3f464cee63095d482 (patch) | |
tree | deb2ab6710a39b13ebadb459626af7aa3bb49d67 | |
parent | [statistics_reporting] Add missing group statement (diff) | |
download | slx-admin-d137be0ad4fcf4afafc88cf3f464cee63095d482.tar.gz slx-admin-d137be0ad4fcf4afafc88cf3f464cee63095d482.tar.xz slx-admin-d137be0ad4fcf4afafc88cf3f464cee63095d482.zip |
[statistics_reporting] Fix json types, add duration field
-rw-r--r-- | modules-available/statistics_reporting/inc/queries.inc.php | 5 |
1 files changed, 4 insertions, 1 deletions
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; |