diff options
| author | Simon Rettberg | 2020-12-03 09:53:09 +0100 |
|---|---|---|
| committer | Simon Rettberg | 2020-12-03 09:53:09 +0100 |
| commit | 4e9f2a4f71699ba7922d096b7b2679400560d03d (patch) | |
| tree | 83da0c473f2ab3fddfda1c097f832396cd7c157d /modules-available/statistics_reporting/inc/queries.inc.php | |
| parent | [webinterface] Include satellite's CA in config.tgz (diff) | |
| download | slx-admin-4e9f2a4f71699ba7922d096b7b2679400560d03d.tar.gz slx-admin-4e9f2a4f71699ba7922d096b7b2679400560d03d.tar.xz slx-admin-4e9f2a4f71699ba7922d096b7b2679400560d03d.zip | |
[statistics_reporting/statistics] Include system/runmode total counts
References #3781
Diffstat (limited to 'modules-available/statistics_reporting/inc/queries.inc.php')
| -rw-r--r-- | modules-available/statistics_reporting/inc/queries.inc.php | 16 |
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`"); + } + } |