PHPPgAdmin\Controller\AdminTrait::doAdmin()

Complexity

Conditions	18
Paths	2304

Size

Total Lines	222
Code Lines	159

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function doAdmin($type, $msg = '')
    {
        $this->script = ('database' == $type) ? 'database.php' : 'tables.php';

        $script = $this->script;

        $lang = $this->lang;

The property lang does not exist on PHPPgAdmin\Controller\AdminTrait. Did you maybe forget to declare it?

        $data = $this->misc->getDatabaseAccessor();

        $this->printTrail($type);
        $this->printTabs($type, 'admin');
        $this->printMsg($msg);

        if ('database' == $type) {
            printf("<p>{$lang['stradminondatabase']}</p>\n", $this->misc->printVal($_REQUEST['object']));
        } else {
            printf("<p>{$lang['stradminontable']}</p>\n", $this->misc->printVal($_REQUEST['object']));
        }

        echo "<table style=\"width: 50%\">\n";
        echo "<tr>\n";
        echo '<th class="data">';
        $this->misc->printHelp($lang['strvacuum'], 'pg.admin.vacuum') . "</th>\n";
        echo '</th>';
        echo '<th class="data">';
        $this->misc->printHelp($lang['stranalyze'], 'pg.admin.analyze');
        echo '</th>';
        if ($data->hasRecluster()) {
            echo '<th class="data">';
            $this->misc->printHelp($lang['strclusterindex'], 'pg.index.cluster');
            echo '</th>';
        }
        echo '<th class="data">';
        $this->misc->printHelp($lang['strreindex'], 'pg.index.reindex');
        echo '</th>';
        echo '</tr>';

        // Vacuum
        echo "<tr class=\"row1\">\n";
        echo "<td style=\"text-align: center; vertical-align: bottom\">\n";
        echo '<form action="' . \SUBFOLDER . "/src/views/{$script}\" method=\"post\">\n";

        echo "<p><input type=\"hidden\" name=\"action\" value=\"confirm_vacuum\" />\n";
        echo $this->misc->form;
        if ('table' == $type) {
            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['object']), "\" />\n";
            echo "<input type=\"hidden\" name=\"subject\" value=\"table\" />\n";
        }
        echo "<input type=\"submit\" value=\"{$lang['strvacuum']}\" /></p>\n";
        echo "</form>\n";
        echo "</td>\n";

        // Analyze
        echo "<td style=\"text-align: center; vertical-align: bottom\">\n";
        echo '<form action="' . \SUBFOLDER . "/src/views/{$script}\" method=\"post\">\n";
        echo "<p><input type=\"hidden\" name=\"action\" value=\"confirm_analyze\" />\n";
        echo $this->misc->form;
        if ('table' == $type) {
            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['object']), "\" />\n";
            echo "<input type=\"hidden\" name=\"subject\" value=\"table\" />\n";
        }
        echo "<input type=\"submit\" value=\"{$lang['stranalyze']}\" /></p>\n";
        echo "</form>\n";
        echo "</td>\n";

        // Cluster
        if ($data->hasRecluster()) {
            $disabled = '';
            echo "<td style=\"text-align: center; vertical-align: bottom\">\n";
            echo '<form action="' . \SUBFOLDER . "/src/views/{$script}\" method=\"post\">\n";
            echo $this->misc->form;
            if ('table' == $type) {
                echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['object']), "\" />\n";
                echo "<input type=\"hidden\" name=\"subject\" value=\"table\" />\n";
                if (!$data->alreadyClustered($_REQUEST['object'])) {
                    $disabled = 'disabled="disabled" ';
                    echo "{$lang['strnoclusteravailable']}<br />";
                }
            }
            echo "<p><input type=\"hidden\" name=\"action\" value=\"confirm_cluster\" />\n";
            echo "<input type=\"submit\" value=\"{$lang['strclusterindex']}\" ${disabled}/></p>\n";
            echo "</form>\n";
            echo "</td>\n";
        }

        // Reindex
        echo "<td style=\"text-align: center; vertical-align: bottom\">\n";
        echo '<form action="' . \SUBFOLDER . "/src/views/{$script}\" method=\"post\">\n";
        echo "<p><input type=\"hidden\" name=\"action\" value=\"confirm_reindex\" />\n";
        echo $this->misc->form;
        if ('table' == $type) {
            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['object']), "\" />\n";
            echo "<input type=\"hidden\" name=\"subject\" value=\"table\" />\n";
        }
        echo "<input type=\"submit\" value=\"{$lang['strreindex']}\" /></p>\n";
        echo "</form>\n";
        echo "</td>\n";
        echo "</tr>\n";
        echo "</table>\n";

        // Autovacuum
        if ($data->hasAutovacuum()) {
            // 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>{$lang['strvacuumpertable']}</h2>";
            echo '<p>' . (('on' == $defaults['autovacuum']) ? $lang['strturnedon'] : $lang['strturnedoff']) . '</p>';
            echo "<p class=\"message\">{$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' => $lang['strschema'],
                    'field' => Decorator::field('nspname'),
                    'url'   => \SUBFOLDER . "/redirect/schema?{$this->misc->href}&amp;",
                    'vars'  => ['schema' => 'nspname'],
                ],
                'relname'                         => [
                    'title' => $lang['strtable'],
                    'field' => Decorator::field('relname'),
                    'url'   => \SUBFOLDER . "/redirect/table?{$this->misc->href}&amp;",
                    'vars'  => ['table' => 'relname', 'schema' => 'nspname'],
                ],
                'autovacuum_enabled'              => [
                    'title' => $lang['strenabled'],
                    'field' => Decorator::callback($enlight, ['autovacuum_enabled', $defaults['autovacuum']]),
                    'type'  => 'verbatim',
                ],
                'autovacuum_vacuum_threshold'     => [
                    'title' => $lang['strvacuumbasethreshold'],
                    'field' => Decorator::callback($enlight, ['autovacuum_vacuum_threshold', $defaults['autovacuum_vacuum_threshold']]),
                    'type'  => 'verbatim',
                ],
                'autovacuum_vacuum_scale_factor'  => [
                    'title' => $lang['strvacuumscalefactor'],
                    'field' => Decorator::callback($enlight, ['autovacuum_vacuum_scale_factor', $defaults['autovacuum_vacuum_scale_factor']]),
                    'type'  => 'verbatim',
                ],
                'autovacuum_analyze_threshold'    => [
                    'title' => $lang['stranalybasethreshold'],
                    'field' => Decorator::callback($enlight, ['autovacuum_analyze_threshold', $defaults['autovacuum_analyze_threshold']]),
                    'type'  => 'verbatim',
                ],
                'autovacuum_analyze_scale_factor' => [
                    'title' => $lang['stranalyzescalefactor'],
                    'field' => Decorator::callback($enlight, ['autovacuum_analyze_scale_factor', $defaults['autovacuum_analyze_scale_factor']]),
                    'type'  => 'verbatim',
                ],
                'autovacuum_vacuum_cost_delay'    => [
                    'title' => $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' => $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' => $lang['stractions']];

            $actions = [
                'edit'   => [
                    'content' => $lang['stredit'],
                    'attr'    => [
                        'href' => [
                            'url'     => $script,
                            'urlvars' => [
                                'subject' => $type,
                                'action'  => 'confeditautovac',
                                'schema'  => Decorator::field('nspname'),
                                'table'   => Decorator::field('relname'),
                            ],
                        ],
                    ],
                ],
                'delete' => [
                    'content' => $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'],

The opening parenthesis of a multi-line function call should be the last content on the line.

                    $actions['delete']['vars']['schema'],
                    $columns['namespace'],
                    $columns['relname']
                );
            }

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

            if (('table' == $type) and (0 == $autovac->recordCount())) {
                echo '<br />';
                echo "<a href=\"tables.php?action=confeditautovac&amp;{$this->misc->href}&amp;table=", htmlspecialchars($_REQUEST['table'])
                , "\">{$lang['straddvacuumtable']}</a>";
            }