Adding upstream version 2.11.4.upstream/2.11.4upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 61 insertions, 0 deletions

diff --git a/modules/monitoring/library/Monitoring/Backend/Ido/Query/CommandQuery.php b/modules/monitoring/library/Monitoring/Backend/Ido/Query/CommandQuery.php
new file mode 100644
index 0000000..59a4ccb
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/Backend/Ido/Query/CommandQuery.php
@@ -0,0 +1,61 @@
+<?php
+/* Icinga Web 2 | (c) 2014 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\Backend\Ido\Query;
+
+/**
+ * Query for commands
+ */
+class CommandQuery extends IdoQuery
+{
+    /**
+     * @var array
+     */
+    protected $columnMap = array(
+        'commands'  => array(
+            'command_id'            => 'c.command_id',
+            'command_instance_id'   => 'c.instance_id',
+            'command_config_type'   => 'c.config_type',
+            'command_line'          => 'c.command_line',
+            'command_name'          => 'co.name1'
+        ),
+
+        'contacts'  => array(
+            'contact_id'    => 'con.contact_id',
+            'contact_alias' => 'con.contact_alias'
+        )
+    );
+
+    /**
+     * Fetch basic information about commands
+     */
+    protected function joinBaseTables()
+    {
+        $this->select->from(
+            array('c' => $this->prefix . 'commands'),
+            array()
+        )->join(
+            array('co' => $this->prefix . 'objects'),
+            'co.object_id = c.object_id',
+            array()
+        );
+
+        $this->joinedVirtualTables = array('commands' => true);
+    }
+
+    /**
+     * Join contacts
+     */
+    protected function joinContacts()
+    {
+        $this->select->join(
+            array('cnc' => $this->prefix . 'contact_notificationcommands'),
+            'cnc.command_object_id = co.object_id',
+            array()
+        )->join(
+            array('con' => $this->prefix . 'contacts'),
+            'con.contact_id = cnc.contact_id',
+            array()
+        );
+    }
+}