From 4e9f2a4f71699ba7922d096b7b2679400560d03d Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Thu, 3 Dec 2020 09:53:09 +0100
Subject: [statistics_reporting/statistics] Include system/runmode total counts

References #3781
---
 .../statistics_reporting/inc/queries.inc.php             | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'modules-available/statistics_reporting/inc/queries.inc.php')

diff --git a/modules-available/statistics_reporting/inc/queries.inc.php b/modules-available/statistics_reporting/inc/queries.inc.php
index fc61c68a..128d8e7d 100644
--- a/modules-available/statistics_reporting/inc/queries.inc.php
+++ b/modules-available/statistics_reporting/inc/queries.inc.php
@@ -437,5 +437,21 @@ class Queries
 		return (int)$res['total'];
 	}
 
+	public static function getBaseSystemStats(int $from, int $to)
+	{
+		return Database::queryAll("SELECT `data` AS `system`, Count(*) AS `count`
+			FROM statistic
+			WHERE (dateline BETWEEN $from AND $to) AND typeid = 'boot-system'
+			GROUP BY `system`");
+	}
+
+	public static function getRunmodeStats(int $from, int $to)
+	{
+		return Database::queryAll("SELECT `data` AS `mode`, Count(*) AS `count`
+			FROM statistic
+			WHERE (dateline BETWEEN $from AND $to) AND typeid = 'boot-runmode'
+			GROUP BY `mode`");
+	}
+
 }
 
-- 
cgit v1.2.3-55-g7522