PHPPgAdmin\Controller\ConstraintsController::formAddForeignKey()

Complexity

Conditions	5
Paths	6

Size

Total Lines	71
Code Lines	50

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

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

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

        $attrs  = $data->getTableAttributes($_REQUEST['table']);
        $tables = $data->getTables(true);

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

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

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

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

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

        echo "<table>\n";
        echo "<tr><th class=\"data\" colspan=\"3\">{$this->lang['strname']}</th></tr>\n";
        echo "<tr><td class=\"data1\" colspan=\"3\"><input type=\"text\" name=\"name\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" /></td></tr>\n";
        echo "<tr><th class=\"data\">{$this->lang['strtablecolumnlist']}</th><th class=\"data\">&nbsp;</th><th class=\"data required\">{$this->lang['strfkcolumnlist']}</th></tr>\n";
        echo '<tr><td class="data1">'.$selColumns->fetch()."</td>\n";
        echo '<td class="data1" style="text-align: center">'.$buttonRemove->fetch().$buttonAdd->fetch()."</td>\n";
        echo '<td class=data1>'.$selIndex->fetch()."</td></tr>\n";
        echo "<tr><th class=\"data\" colspan=\"3\">{$this->lang['strfktarget']}</th></tr>";
        echo '<tr>';
        echo '<td class="data1" colspan="3"><select class="select2" name="target">';
        while (!$tables->EOF) {
            $key = ['schemaname' => $tables->fields['nspname'], 'tablename' => $tables->fields['relname']];
            $key = serialize($key);
            echo '<option value="', htmlspecialchars($key), '">';
            if ($tables->fields['nspname'] != $_REQUEST['schema']) {
                echo htmlspecialchars($tables->fields['nspname']), '.';
            }
            echo htmlspecialchars($tables->fields['relname']), "</option>\n";
            $tables->moveNext();
        }
        echo "</select>\n";
        echo '</td></tr>';
        echo "</table>\n";

        echo $this->getFormInputsAndButtons(
            [
                ['name' => 'action', 'type' => 'hidden', 'value' => 'select_referenced_columns'],
                ['name' => 'table', 'type' => 'hidden', 'value' => htmlspecialchars($_REQUEST['table'])],
            ],
            [
                ['type' => 'submit', 'name' => '', 'value' => $this->lang['stradd']],
                ['type' => 'submit', 'name' => 'cancel', 'value' => $this->lang['strcancel']],
            ]
        );

        echo sprintf('</form>%s', "\n");
    }