PHPPgAdmin\Controller\TblpropertiesController::doAlter()

Complexity

Conditions	17
Paths	34

Size

Total Lines	110
Code Lines	78

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function doAlter($msg = ''): void
    {
        $misc = $this->misc;
        $data = $misc->getDatabaseAccessor();

        $this->printTrail('table');
        $this->printTitle($this->lang['stralter'], 'pg.table.alter');
        $this->printMsg($msg);

        // Fetch table info
        $table = $data->getTable($_REQUEST['table']);
        // Fetch all users
        $users = $data->getUsers();
        $tablespaces = null;
        // Fetch all tablespaces from the database
        if ($data->hasTablespaces()) {
            $tablespaces = $data->getTablespaces(true);
        }

        if (0 < $table->recordCount()) {
            $this->coalesceArr($_POST, 'name', $table->fields['relname']);

            $this->coalesceArr($_POST, 'owner', $table->fields['relowner']);

            $this->coalesceArr($_POST, 'newschema', $table->fields['nspname']);

            $this->coalesceArr($_POST, 'comment', $table->fields['relcomment']);

            if ($data->hasTablespaces() && !isset($_POST['tablespace'])) {
                $_POST['tablespace'] = $table->fields['tablespace'];
            }

            echo '<form action="' . \containerInstance()->subFolder . '/src/views/tblproperties" method="post">' . \PHP_EOL;
            echo '<table>' . \PHP_EOL;
            echo "<tr><th class=\"data left required\">{$this->lang['strname']}</th>" . \PHP_EOL;
            echo '<td class="data1">';
            echo "<input name=\"name\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
                \htmlspecialchars($_POST['name'], \ENT_QUOTES),
                '" /></td></tr>' . \PHP_EOL;

            if ($data->isSuperUser()) {
                echo "<tr><th class=\"data left required\">{$this->lang['strowner']}</th>" . \PHP_EOL;
                echo '<td class="data1"><select name="owner">';

                while (!$users->EOF) {
                    $uname = $users->fields['usename'];
                    echo '<option value="', \htmlspecialchars($uname), '"',
                        ($uname === $_POST['owner']) ? ' selected="selected"' : '',
                        '>',
                        \htmlspecialchars($uname),
                        '</option>' . \PHP_EOL;
                    $users->moveNext();
                }
                echo '</select></td></tr>' . \PHP_EOL;
            }

            if ($data->hasAlterTableSchema()) {
                $schemas = $data->getSchemas();
                echo "<tr><th class=\"data left required\">{$this->lang['strschema']}</th>" . \PHP_EOL;
                echo '<td class="data1"><select name="newschema">';

                while (!$schemas->EOF) {
                    $schema = $schemas->fields['nspname'];
                    echo '<option value="', \htmlspecialchars($schema), '"',
                        ($schema === $_POST['newschema']) ? ' selected="selected"' : '',
                        '>',
                        \htmlspecialchars($schema),
                        '</option>' . \PHP_EOL;
                    $schemas->moveNext();
                }
                echo '</select></td></tr>' . \PHP_EOL;
            }

            // Tablespace (if there are any)
            if ($data->hasTablespaces() && 0 < $tablespaces->recordCount()) {
                echo "\t<tr>\n\t\t<th class=\"data left\">{$this->lang['strtablespace']}</th>" . \PHP_EOL;
                echo "\t\t<td class=\"data1\">\n\t\t\t<select name=\"tablespace\">" . \PHP_EOL;
                // Always offer the default (empty) option
                echo "\t\t\t\t<option value=\"\"",
                    ('' === $_POST['tablespace']) ? ' selected="selected"' : '',
                    '></option>' . \PHP_EOL;
                // Display all other tablespaces
                while (!$tablespaces->EOF) {
                    $spcname = \htmlspecialchars($tablespaces->fields['spcname']);
                    echo "\t\t\t\t<option value=\"{$spcname}\"",
                        ($spcname === $_POST['tablespace']) ? ' selected="selected"' : '',
                        ">{$spcname}</option>" . \PHP_EOL;
                    $tablespaces->moveNext();
                }
                echo "\t\t\t</select>\n\t\t</td>\n\t</tr>" . \PHP_EOL;
            }
            echo '<tr><th class="data left"> </th>' . \PHP_EOL;
            echo '<td class="data1">';
            echo \sprintf('<input type="checkbox" name="with_oids" value="1" %s /> %s', $data->hasObjectID($table->fields['relname']) ? 'checked' : '', ' WITH OIDS');

            echo '</td></tr>';

            echo "<tr><th class=\"data left\">{$this->lang['strcomment']}</th>" . \PHP_EOL;
            echo '<td class="data1">';
            echo \sprintf('<textarea rows="3" cols="62" name="comment">%s</textarea>', \htmlspecialchars($_POST['comment']));
            echo \sprintf('</td></tr>%s</table>%s', \PHP_EOL, \PHP_EOL);
            echo '<p><input type="hidden" name="action" value="alter" />' . \PHP_EOL;
            echo \sprintf('<input type="hidden" name="table" value="%s"  />%s', \htmlspecialchars($_REQUEST['table']), \PHP_EOL);

            echo $this->view->form;
            echo "<input type=\"submit\" name=\"alter\" value=\"{$this->lang['stralter']}\" />" . \PHP_EOL;
            echo \sprintf('<input type="submit" name="cancel" value="%s"  /></p>%s', $this->lang['strcancel'], \PHP_EOL);
            echo '</form>' . \PHP_EOL;
        } else {
            echo "<p>{$this->lang['strnodata']}</p>" . \PHP_EOL;
        }