From b18bc644404e02b57635bfcc8258e85abb141146 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Sat, 13 Apr 2024 13:44:46 +0200
Subject: Adding upstream version 1.1.1.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 .../ProvidedHook/Reporting/ServiceSlaReport.php    | 72 ++++++++++++++++++++++
 1 file changed, 72 insertions(+)
 create mode 100644 library/Icingadb/ProvidedHook/Reporting/ServiceSlaReport.php

(limited to 'library/Icingadb/ProvidedHook/Reporting/ServiceSlaReport.php')

diff --git a/library/Icingadb/ProvidedHook/Reporting/ServiceSlaReport.php b/library/Icingadb/ProvidedHook/Reporting/ServiceSlaReport.php
new file mode 100644
index 0000000..46a0684
--- /dev/null
+++ b/library/Icingadb/ProvidedHook/Reporting/ServiceSlaReport.php
@@ -0,0 +1,72 @@
+<?php
+
+/* Icinga DB Web | (c) 2022 Icinga GmbH | GPLv2 */
+
+namespace Icinga\Module\Icingadb\ProvidedHook\Reporting;
+
+use Icinga\Application\Icinga;
+use Icinga\Module\Icingadb\Model\Service;
+use Icinga\Module\Reporting\ReportData;
+use Icinga\Module\Reporting\ReportRow;
+use Icinga\Module\Reporting\Timerange;
+use ipl\Sql\Expression;
+use ipl\Stdlib\Filter\Rule;
+
+use function ipl\I18n\t;
+
+class ServiceSlaReport extends SlaReport
+{
+    public function getName()
+    {
+        $name = t('Service SLA');
+        if (Icinga::app()->getModuleManager()->hasEnabled('idoreports')) {
+            $name .= ' (Icinga DB)';
+        }
+
+        return $name;
+    }
+
+    protected function createReportData()
+    {
+        return (new ReportData())
+            ->setDimensions([t('Hostname'), t('Service Name')])
+            ->setValues([t('SLA in %')]);
+    }
+
+    protected function createReportRow($row)
+    {
+        if ($row->sla === null) {
+            return null;
+        }
+
+        return (new ReportRow())
+            ->setDimensions([$row->host->display_name, $row->display_name])
+            ->setValues([(float) $row->sla]);
+    }
+
+    protected function fetchSla(Timerange $timerange, Rule $filter = null)
+    {
+        $sla = Service::on($this->getDb())
+            ->columns([
+                'host.display_name',
+                'display_name',
+                'sla' => new Expression(sprintf(
+                    "get_sla_ok_percent(%s, %s, '%s', '%s')",
+                    'service.host_id',
+                    'service.id',
+                    $timerange->getStart()->format('Uv'),
+                    $timerange->getEnd()->format('Uv')
+                ))
+            ]);
+
+        $sla->resetOrderBy()->orderBy('host.display_name')->orderBy('display_name');
+
+        $this->applyRestrictions($sla);
+
+        if ($filter !== null) {
+            $sla->filter($filter);
+        }
+
+        return $sla;
+    }
+}
-- 
cgit v1.2.3