1 files changed, 16 insertions, 0 deletions
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`");
+	}
+
 }