1 files changed, 47 insertions, 0 deletions
diff --git a/application/controllers/TestController.php b/application/controllers/TestController.php
new file mode 100644
index 0000000..f666085
--- /dev/null
+++ b/application/controllers/TestController.php
@@ -0,0 +1,47 @@
+<?php
+// Icinga Reporting | (c) 2018 Icinga GmbH | GPLv2
+
+namespace Icinga\Module\Reporting\Controllers;
+
+use Icinga\Module\Reporting\Database;
+use Icinga\Module\Reporting\Timeframe;
+use Icinga\Module\Reporting\Web\Controller;
+use ipl\Html\Table;
+use ipl\Sql\Select;
+
+class TestController extends Controller
+{
+    use Database;
+
+    public function timeframesAction()
+    {
+        $select = (new Select())
+            ->from('timeframe')
+            ->columns('*');
+
+        $table = new Table();
+
+        $table->getAttributes()->add('class', 'common-table');
+
+        $table->getHeader()->add(Table::row(['Name', 'Title', 'Start', 'End'], null, 'th'));
+
+        foreach ($this->getDb()->select($select) as $row) {
+            $timeframe = (new Timeframe())
+                ->setName($row->name)
+                ->setTitle($row->title)
+                ->setStart($row->start)
+                ->setEnd($row->end);
+
+            $table->getBody()->add(Table::row([
+                $timeframe->getName(),
+                $timeframe->getTitle(),
+                $timeframe->getTimerange()->getStart()->format('Y-m-d H:i:s'),
+                $timeframe->getTimerange()->getEnd()->format('Y-m-d H:i:s')
+            ]));
+        }
+
+        $this->addTitleTab('Timeframes');
+
+        $this->addContent($table);
+    }
+}