PHPPgAdmin\Traits\AdminTrait::_printAutoVacuumConf()

Complexity

Conditions	9
Paths	9

Size

Total Lines	127
Code Lines	87

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    private function _printAutoVacuumConf($data, $type)
    {
        if (!$data->hasAutovacuum()) {
            return;
        }
        $script = $this->script;
        // get defaults values for autovacuum
        $defaults = $data->getAutovacuum();
        // Fetch the autovacuum properties from the database or table if != ''
        if ('table' == $type) {
            $autovac = $data->getTableAutovacuum($_REQUEST['table']);
        } else {
            $autovac = $data->getTableAutovacuum();
        }

        echo "<br /><br /><h2>{$this->lang['strvacuumpertable']}</h2>";
        echo '<p>'.(('on' == $defaults['autovacuum']) ? $this->lang['strturnedon'] : $this->lang['strturnedoff']).'</p>';
        echo "<p class=\"message\">{$this->lang['strnotdefaultinred']}</p>";

        $enlight = function ($f, $p) {
            if (isset($f[$p[0]]) and ($f[$p[0]] != $p[1])) {
                return '<span style="color:#F33;font-weight:bold">'.htmlspecialchars($f[$p[0]]).'</span>';
            }

            return htmlspecialchars($p[1]);
        };

        $columns = [
            'namespace'                       => [
                'title' => $this->lang['strschema'],
                'field' => Decorator::field('nspname'),
                'url'   => \SUBFOLDER."/redirect/schema?{$this->misc->href}&amp;",
                'vars'  => ['schema' => 'nspname'],
            ],
            'relname'                         => [
                'title' => $this->lang['strtable'],
                'field' => Decorator::field('relname'),
                'url'   => \SUBFOLDER."/redirect/table?{$this->misc->href}&amp;",
                'vars'  => ['table' => 'relname', 'schema' => 'nspname'],
            ],
            'autovacuum_enabled'              => [
                'title' => $this->lang['strenabled'],
                'field' => Decorator::callback($enlight, ['autovacuum_enabled', $defaults['autovacuum']]),
                'type'  => 'verbatim',
            ],
            'autovacuum_vacuum_threshold'     => [
                'title' => $this->lang['strvacuumbasethreshold'],
                'field' => Decorator::callback($enlight, ['autovacuum_vacuum_threshold', $defaults['autovacuum_vacuum_threshold']]),
                'type'  => 'verbatim',
            ],
            'autovacuum_vacuum_scale_factor'  => [
                'title' => $this->lang['strvacuumscalefactor'],
                'field' => Decorator::callback($enlight, ['autovacuum_vacuum_scale_factor', $defaults['autovacuum_vacuum_scale_factor']]),
                'type'  => 'verbatim',
            ],
            'autovacuum_analyze_threshold'    => [
                'title' => $this->lang['stranalybasethreshold'],
                'field' => Decorator::callback($enlight, ['autovacuum_analyze_threshold', $defaults['autovacuum_analyze_threshold']]),
                'type'  => 'verbatim',
            ],
            'autovacuum_analyze_scale_factor' => [
                'title' => $this->lang['stranalyzescalefactor'],
                'field' => Decorator::callback($enlight, ['autovacuum_analyze_scale_factor', $defaults['autovacuum_analyze_scale_factor']]),
                'type'  => 'verbatim',
            ],
            'autovacuum_vacuum_cost_delay'    => [
                'title' => $this->lang['strvacuumcostdelay'],
                'field' => Decorator::concat(Decorator::callback($enlight, ['autovacuum_vacuum_cost_delay', $defaults['autovacuum_vacuum_cost_delay']]), 'ms'),
                'type'  => 'verbatim',
            ],
            'autovacuum_vacuum_cost_limit'    => [
                'title' => $this->lang['strvacuumcostlimit'],
                'field' => Decorator::callback($enlight, ['autovacuum_vacuum_cost_limit', $defaults['autovacuum_vacuum_cost_limit']]),
                'type'  => 'verbatim',
            ],
        ];

        // Maybe we need to check permissions here?
        $columns['actions'] = ['title' => $this->lang['stractions']];

        $actions = [
            'edit'   => [
                'content' => $this->lang['stredit'],
                'attr'    => [
                    'href' => [
                        'url'     => $script,
                        'urlvars' => [
                            'subject' => $type,
                            'action'  => 'confeditautovac',
                            'schema'  => Decorator::field('nspname'),
                            'table'   => Decorator::field('relname'),
                        ],
                    ],
                ],
            ],
            'delete' => [
                'content' => $this->lang['strdelete'],
                'attr'    => [
                    'href' => [
                        'url'     => $script,
                        'urlvars' => [
                            'subject' => $type,
                            'action'  => 'confdelautovac',
                            'schema'  => Decorator::field('nspname'),
                            'table'   => Decorator::field('relname'),
                        ],
                    ],
                ],
            ],
        ];

        if ('table' == $type) {
            unset($actions['edit']['vars']['schema'],
                $actions['delete']['vars']['schema'],
                $columns['namespace'],
                $columns['relname']
            );
        }

        echo $this->printTable($autovac, $columns, $actions, 'admin-admin', $this->lang['strnovacuumconf']);

        if (('table' == $type) and (0 == $autovac->RecordCount())) {
            echo '<br />';

            echo '<a href="'.\SUBFOLDER."/src/views/tables?action=confeditautovac&amp;{$this->misc->href}&amp;table=";
            echo htmlspecialchars($_REQUEST['table']);
            echo "\">{$this->lang['straddvacuumtable']}</a>";
        }