1 files changed, 82 insertions, 0 deletions
diff --git a/modules/monitoring/library/Monitoring/DataView/Comment.php b/modules/monitoring/library/Monitoring/DataView/Comment.php
new file mode 100644
index 0000000..3a035bc
--- /dev/null
+++ b/modules/monitoring/library/Monitoring/DataView/Comment.php
@@ -0,0 +1,82 @@
+<?php
+/* Icinga Web 2 | (c) 2013 Icinga Development Team | GPLv2+ */
+
+namespace Icinga\Module\Monitoring\DataView;
+
+/**
+ * Host and service comments view
+ */
+class Comment extends DataView
+{
+    /**
+     * {@inheritdoc}
+     */
+    public function getColumns()
+    {
+        return array(
+            'comment_author_name',
+            'comment_data',
+            'comment_expiration',
+            'comment_internal_id',
+            'comment_is_persistent',
+            'comment_name',
+            'comment_timestamp',
+            'comment_type',
+            'host_display_name',
+            'host_name',
+            'object_type',
+            'service_description',
+            'service_display_name',
+            'service_host_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getStaticFilterColumns()
+    {
+        return array(
+            'comment_author',
+            'host', 'host_alias',
+            'hostgroup', 'hostgroup_alias', 'hostgroup_name',
+            'instance_name',
+            'service',
+            'servicegroup', 'servicegroup_alias', 'servicegroup_name'
+        );
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSearchColumns()
+    {
+        return array('host_display_name', 'service_display_name');
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function getSortRules()
+    {
+        return array(
+            'comment_timestamp' => array(
+                'order' => self::SORT_DESC
+            ),
+            'host_display_name' => array(
+                'columns' => array(
+                    'host_display_name',
+                    'service_display_name'
+                ),
+                'order' => self::SORT_ASC
+            ),
+            'service_display_name' => array(
+                'columns' => array(
+                    'service_display_name',
+                    'host_display_name'
+                ),
+                'order' => self::SORT_ASC
+            )
+        );
+    }
+}