PHPPgAdmin\Controller\ConstraintsController::_selectFKColumns()

Complexity

Conditions	19
Paths	129

Size

Total Lines	185
Code Lines	124

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    private function _selectFKColumns($msg = '')
    {
        $data = $this->misc->getDatabaseAccessor();

        $this->coalesceArr($_POST, 'name', '');

        $this->coalesceArr($_POST, 'target', '');

        // Check that they've given at least one source column
        if (!isset($_REQUEST['SourceColumnList']) && (!isset($_POST['IndexColumnList']) ||
            !\is_array($_POST['IndexColumnList']) ||
            0 === \count($_POST['IndexColumnList']))) {
            return $this->formAddForeignKey($this->lang['strfkneedscols']);
        }
        // Copy the IndexColumnList variable from stage 1
        if (isset($_REQUEST['IndexColumnList']) && !isset($_REQUEST['SourceColumnList'])) {
            $_REQUEST['SourceColumnList'] = \serialize($_REQUEST['IndexColumnList']);
        }

        // Initialise variables
        $this->coalesceArr($_POST, 'upd_action', null);

        $this->coalesceArr($_POST, 'del_action', null);

        $this->coalesceArr($_POST, 'match', null);

        $this->coalesceArr($_POST, 'deferrable', null);

        $this->coalesceArr($_POST, 'initially', null);

        $_REQUEST['target'] = \unserialize($_REQUEST['target']);

        $this->printTrail('table');
        $this->printTitle($this->lang['straddfk'], 'pg.constraint.foreign_key');
        $this->printMsg($msg);

        // Unserialize target and fetch appropriate table. This is a bit messy
        // because the table could be in another schema.
        $data->setSchema($_REQUEST['target']['schemaname']);
        $attrs = $data->getTableAttributes($_REQUEST['target']['tablename']);
        $data->setSchema($_REQUEST['schema']);

        $selColumns = new XHtmlSelect('TableColumnList', true, 10);
        $selColumns->set_style('width: 15em;');

        if (0 < $attrs->recordCount()) {
            while (!$attrs->EOF) {
                $xmloption = new XHtmlOption($attrs->fields['attname']);
                $selColumns->add($xmloption);
                $attrs->moveNext();
            }
        }

        $selIndex = new XHtmlSelect('IndexColumnList[]', true, 10);
        $selIndex->set_style('width: 15em;');
        $selIndex->set_attribute('id', 'IndexColumnList');
        $buttonAdd = new XHtmlButton('add', '>>');
        $buttonAdd->set_attribute('onclick', 'buttonPressed(this);');
        $buttonAdd->set_attribute('type', 'button');

        $buttonRemove = new XHtmlButton('remove', '<<');
        $buttonRemove->set_attribute('onclick', 'buttonPressed(this);');
        $buttonRemove->set_attribute('type', 'button');

        echo '<form onsubmit="doSelectAll();" name="formIndex" action="constraints" method="post">' . \PHP_EOL;

        echo '<table>' . \PHP_EOL;
        echo \sprintf(
            '<tr><th class="data" colspan="3">%s</th></tr>',
            $this->lang['strfktarget']
        );
        echo \sprintf(
            '<tr><th class="data">%s</th><th class="data">&nbsp;</th><th class=data>%s</th></tr>',
            $this->lang['strtablecolumnlist'],
            $this->lang['strfkcolumnlist']
        ) . \PHP_EOL;
        echo '<tr><td class="data1">' . $selColumns->fetch() . '</td>' . \PHP_EOL;
        echo '<td class="data1" style="text-align: center">' . $buttonRemove->fetch() . $buttonAdd->fetch() . '</td>';
        echo '<td class="data1">' . $selIndex->fetch() . '</td></tr>' . \PHP_EOL;
        echo \sprintf(
            '<tr><th class="data" colspan="3">%s</th></tr>',
            $this->lang['stractions']
        );
        echo '<tr>';
        echo '<td class="data1" colspan="3">' . \PHP_EOL;
        // ON SELECT actions
        echo \sprintf(
            '%s <select name="upd_action">',
            $this->lang['stronupdate']
        );

        foreach ($data->fkactions as $v) {
            echo \sprintf(
                '<option value="%s"',
                $v
            ), ($_POST['upd_action'] === $v) ? ' selected="selected"' : '', \sprintf(
                '>%s</option>',
                $v
            ) . \PHP_EOL;
        }

        echo '</select><br />' . \PHP_EOL;

        // ON DELETE actions
        echo \sprintf(
            '%s <select name="del_action">',
            $this->lang['strondelete']
        );

        foreach ($data->fkactions as $v) {
            echo \sprintf(
                '<option value="%s"',
                $v
            ), ($_POST['del_action'] === $v) ? ' selected="selected"' : '', \sprintf(
                '>%s</option>',
                $v
            ) . \PHP_EOL;
        }

        echo '</select><br />' . \PHP_EOL;

        // MATCH options
        echo '<select name="match">';

        foreach ($data->fkmatches as $v) {
            echo \sprintf(
                '<option value="%s"',
                $v
            ), ($_POST['match'] === $v) ? ' selected="selected"' : '', \sprintf(
                '>%s</option>',
                $v
            ) . \PHP_EOL;
        }

        echo '</select><br />' . \PHP_EOL;

        // DEFERRABLE options
        echo '<select name="deferrable">';

        foreach ($data->fkdeferrable as $v) {
            echo \sprintf(
                '<option value="%s"',
                $v
            ), ($_POST['deferrable'] === $v) ? ' selected="selected"' : '', \sprintf(
                '>%s</option>',
                $v
            ) . \PHP_EOL;
        }

        echo '</select><br />' . \PHP_EOL;

        // INITIALLY options
        echo '<select name="initially">';

        foreach ($data->fkinitial as $v) {
            echo \sprintf(
                '<option value="%s"',
                $v
            ), ($_POST['initially'] === $v) ? ' selected="selected"' : '', \sprintf(
                '>%s</option>',
                $v
            ) . \PHP_EOL;
        }

        echo '</select>' . \PHP_EOL;
        echo '</td></tr>' . \PHP_EOL;
        echo '</table>' . \PHP_EOL;

        echo '<p>';

        echo '<input type="hidden" name="name" value="', \htmlspecialchars($_REQUEST['name']), '" />' . \PHP_EOL;
        echo '<input type="hidden" name="target" value="', \htmlspecialchars(\serialize($_REQUEST['target'])), '" />' . \PHP_EOL;
        echo '<input type="hidden" name="SourceColumnList" value="', \htmlspecialchars($_REQUEST['SourceColumnList']), '" />' . \PHP_EOL;

        echo $this->getActionTableAndButtons(
            'save_add_foreign_key',
            \htmlspecialchars($_REQUEST['table']),
            $this->lang['stradd'],
            $this->lang['strcancel']
        );

        echo \sprintf(
            '</p>%s</form>%s',
            \PHP_EOL,
            \PHP_EOL
        );