1 files changed, 120 insertions, 0 deletions
diff --git a/library/Director/Web/Table/GeneratedConfigFileTable.php b/library/Director/Web/Table/GeneratedConfigFileTable.php
new file mode 100644
index 0000000..97f7091
--- /dev/null
+++ b/library/Director/Web/Table/GeneratedConfigFileTable.php
@@ -0,0 +1,120 @@
+<?php
+
+namespace Icinga\Module\Director\Web\Table;
+
+use Icinga\Module\Director\Db;
+use Icinga\Module\Director\IcingaConfig\IcingaConfig;
+use gipfl\IcingaWeb2\Link;
+use gipfl\IcingaWeb2\Table\ZfQueryBasedTable;
+
+class GeneratedConfigFileTable extends ZfQueryBasedTable
+{
+    use DbHelper;
+
+    protected $searchColumns = ['file_path'];
+
+    protected $deploymentId;
+
+    protected $activeFile;
+
+    /** @var IcingaConfig */
+    protected $config;
+
+    public static function load(IcingaConfig $config, Db $db)
+    {
+        $table = new static($db);
+        $table->config = $config;
+        $table->getAttributes()->set('data-base-target', '_self');
+        return $table;
+    }
+
+    public function renderRow($row)
+    {
+        $counts = implode(' / ', [
+            $row->cnt_object,
+            $row->cnt_template,
+            $row->cnt_apply
+        ]);
+
+        $tr = $this::row([
+            $this->getFileLink($row),
+            $counts,
+            $row->size
+        ]);
+
+        if ($row->file_path === $this->activeFile) {
+            $tr->getAttributes()->add('class', 'active');
+        }
+
+        return $tr;
+    }
+
+    public function setActiveFilename($filename)
+    {
+        $this->activeFile = $filename;
+        return $this;
+    }
+
+    protected function getFileLink($row)
+    {
+        $params = [
+            'config_checksum' => $row->config_checksum,
+            'file_path'       => $row->file_path
+        ];
+
+        if ($this->deploymentId) {
+            $params['deployment_id'] = $this->deploymentId;
+        }
+
+        return Link::create($row->file_path, 'director/config/file', $params);
+    }
+
+    public function setDeploymentId($id)
+    {
+        if ($id) {
+            $this->deploymentId = (int) $id;
+        }
+
+        return $this;
+    }
+
+    public function getColumnsToBeRendered()
+    {
+        return [
+            $this->translate('File'),
+            $this->translate('Object/Tpl/Apply'),
+            $this->translate('Size'),
+        ];
+    }
+
+    public function prepareQuery()
+    {
+        $columns = [
+            'file_path'       => 'cf.file_path',
+            'size'            => 'LENGTH(f.content)',
+            'cnt_object'      => 'f.cnt_object',
+            'cnt_template'    => 'f.cnt_template',
+            'cnt_apply'       => 'f.cnt_apply',
+            'cnt_all'         => "f.cnt_object || ' / ' || f.cnt_template || ' / ' || f.cnt_apply",
+            'checksum'        => 'LOWER(HEX(f.checksum))',
+            'config_checksum' => 'LOWER(HEX(cf.config_checksum))',
+        ];
+
+        if ($this->isPgsql()) {
+            $columns['checksum'] = "LOWER(ENCODE(f.checksum, 'hex'))";
+            $columns['config_checksum'] = "LOWER(ENCODE(cf.config_checksum, 'hex'))";
+        }
+
+        return $this->db()->select()->from(
+            ['cf' => 'director_generated_config_file'],
+            $columns
+        )->join(
+            ['f' => 'director_generated_file'],
+            'cf.file_checksum = f.checksum',
+            []
+        )->where(
+            'config_checksum = ?',
+            $this->quoteBinary($this->config->getChecksum())
+        )->order('cf.file_path ASC');
+    }
+}