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

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 .../Backend/Ido/Query/AllcontactsQuery.php         | 75 ++++++++++++++++++++++
 1 file changed, 75 insertions(+)
 create mode 100644 modules/monitoring/library/Monitoring/Backend/Ido/Query/AllcontactsQuery.php

(limited to 'modules/monitoring/library/Monitoring/Backend/Ido/Query/AllcontactsQuery.php')

diff --git a/modules/monitoring/library/Monitoring/Backend/Ido/Query/AllcontactsQuery.php b/modules/monitoring/library/Monitoring/Backend/Ido/Query/AllcontactsQuery.php
new file mode 100644
index 0000000..3598726
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/Backend/Ido/Query/AllcontactsQuery.php
@@ -0,0 +1,75 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\Backend\Ido\Query;
+
+use Zend_Db_Select;
+
+class AllcontactsQuery extends IdoQuery
+{
+    protected $columnMap = array(
+        'contacts' => array(
+            'contact_name'        => 'c.contact_name',
+            'host_object_id'      => 'c.host_object_id',
+            'host_name'           => 'c.host_name',
+            'service_object_id'   => 'c.service_object_id',
+            'service_host_name'   => 'c.service_host_name',
+            'service_description' => 'c.service_description',
+
+            'contact_alias'  => 'c.contact_alias',
+            'contact_email'  => 'c.contact_email',
+            'contact_pager'  => 'c.contact_pager',
+            'contact_has_host_notfications'    => 'c.contact_has_host_notfications',
+            'contact_has_service_notfications' => 'c.contact_has_service_notfications',
+            'contact_can_submit_commands'      => 'c.contact_can_submit_commands',
+            'contact_notify_service_recovery'  => 'c.notify_service_recovery',
+            'contact_notify_service_warning'   => 'c.notify_service_warning',
+            'contact_notify_service_critical'  => 'c.notify_service_critical',
+            'contact_notify_service_unknown'   => 'c.notify_service_unknown',
+            'contact_notify_service_flapping'  => 'c.notify_service_flapping',
+            'contact_notify_service_downtime'  => 'c.notify_service_downtime',
+            'contact_notify_host_recovery'     => 'c.notify_host_recovery',
+            'contact_notify_host_down'         => 'c.notify_host_down',
+            'contact_notify_host_unreachable'  => 'c.notify_host_unreachable',
+            'contact_notify_host_flapping'     => 'c.notify_host_flapping',
+            'contact_notify_host_downtime'     => 'c.notify_host_downtime',
+
+
+        )
+    );
+
+    protected $contacts;
+    protected $contactgroups;
+    protected $baseQuery;
+    protected $useSubqueryCount = true;
+
+    public function requireColumn($alias)
+    {
+        $this->contacts->addColumn($alias);
+        $this->contactgroups->addColumn($alias);
+        return parent::requireColumn($alias);
+    }
+
+    protected function joinBaseTables()
+    {
+        $this->contacts = $this->createSubQuery(
+            'contact',
+            array('contact_name')
+        );
+        $this->contactgroups = $this->createSubQuery(
+            'contactgroup',
+            array('contact_name')
+        );
+        $sub = $this->db->select()->union(
+            array($this->contacts, $this->contactgroups),
+            Zend_Db_Select::SQL_UNION_ALL
+        );
+
+        $this->baseQuery = $this->db->select()->distinct()->from(
+            array('c' => $sub),
+            array()
+        );
+
+        $this->joinedVirtualTables = array('contacts' => true);
+    }
+}
-- 
cgit v1.2.3