1 files changed, 68 insertions, 0 deletions
diff --git a/modules/monitoring/library/Monitoring/Backend/Ido/Query/ProgramstatusQuery.php b/modules/monitoring/library/Monitoring/Backend/Ido/Query/ProgramstatusQuery.php
new file mode 100644
index 0000000..9e9f5f6
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/Backend/Ido/Query/ProgramstatusQuery.php
@@ -0,0 +1,68 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\Backend\Ido\Query;
+
+/**
+ * Program status query
+ */
+class ProgramstatusQuery extends IdoQuery
+{
+    /**
+     * {@inheritdoc}
+     */
+    protected $columnMap = array(
+        'programstatus' => array(
+            'id'                    => 'programstatus_id',
+            'status_update_time'    => 'UNIX_TIMESTAMP(programstatus.status_update_time)',
+            'program_version'       => 'program_version',
+            'program_start_time'    => 'UNIX_TIMESTAMP(programstatus.program_start_time)',
+            'program_end_time'      => 'UNIX_TIMESTAMP(programstatus.program_end_time)',
+            'is_currently_running'  => 'CASE WHEN (UNIX_TIMESTAMP(programstatus.status_update_time) + 60 > UNIX_TIMESTAMP(NOW()))
+                THEN
+                    1
+                ELSE
+                    0
+                END',
+            'process_id'                        => 'process_id',
+            'endpoint_name'                     => 'endpoint_name',
+            'daemon_mode'                       => 'daemon_mode',
+            'last_command_check'                => 'UNIX_TIMESTAMP(programstatus.last_command_check)',
+            'last_log_rotation'                 => 'UNIX_TIMESTAMP(programstatus.last_log_rotation)',
+            'notifications_enabled'             => 'notifications_enabled',
+            'disable_notif_expire_time'         => 'UNIX_TIMESTAMP(programstatus.disable_notif_expire_time)',
+            'active_service_checks_enabled'     => 'active_service_checks_enabled',
+            'passive_service_checks_enabled'    => 'passive_service_checks_enabled',
+            'active_host_checks_enabled'        => 'active_host_checks_enabled',
+            'passive_host_checks_enabled'       => 'passive_host_checks_enabled',
+            'event_handlers_enabled'            => 'event_handlers_enabled',
+            'flap_detection_enabled'            => 'flap_detection_enabled',
+            'failure_prediction_enabled'        => 'failure_prediction_enabled',
+            'process_performance_data'          => 'process_performance_data',
+            'obsess_over_hosts'                 => 'obsess_over_hosts',
+            'obsess_over_services'              => 'obsess_over_services',
+            'modified_host_attributes'          => 'modified_host_attributes',
+            'modified_service_attributes'       => 'modified_service_attributes',
+            'global_host_event_handler'         => 'global_host_event_handler',
+            'global_service_event_handler'      => 'global_service_event_handler',
+        )
+    );
+
+    /**
+     * {@inheritdoc}
+     */
+    protected function joinBaseTables()
+    {
+        parent::joinBaseTables();
+
+        if (version_compare($this->getIdoVersion(), '1.11.7', '<')) {
+            $this->columnMap['programstatus']['endpoint_name'] = '(0)';
+        }
+        if (version_compare($this->getIdoVersion(), '1.11.8', '<')) {
+            $this->columnMap['programstatus']['program_version'] = '(NULL)';
+        }
+        if (version_compare($this->getIdoVersion(), '1.8', '<')) {
+            $this->columnMap['programstatus']['disable_notif_expire_time'] = '(NULL)';
+        }
+    }
+}