PHPPgAdmin\Controller\TablesController::formInsertRow()

Complexity

Conditions	20
Paths	21

Size

Total Lines	123
Code Lines	86

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

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

        $this->printTrail('table');
        $this->printTabs('table', 'insert');

        $this->printMsg($msg);

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

        if (('disable' != $this->conf['autocomplete'])) {
            $fksprops = $this->misc->getAutocompleteFKProperties($_REQUEST['table']);
            if (false !== $fksprops) {
                echo $fksprops['code'];
            }
        } else {
            $fksprops = false;
        }
        $this->coalesceArr($_REQUEST, 'values', []);
        $this->coalesceArr($_REQUEST, 'nulls', []);
        $this->coalesceArr($_REQUEST, 'format', []);

        echo '<form action="'.\SUBFOLDER."/src/views/tables\" method=\"post\" id=\"ac_form\">\n";
        if ($attrs->recordCount() > 0) {
            echo "<table>\n";

            // Output table header
            echo "<tr><th class=\"data\">{$this->lang['strcolumn']}</th><th class=\"data\">{$this->lang['strtype']}</th>";
            echo "<th class=\"data\">{$this->lang['strformat']}</th>";
            echo "<th class=\"data\">{$this->lang['strnull']}</th><th class=\"data\">{$this->lang['strvalue']}</th></tr>";

            $i      = 0;
            $fields = [];
            while (!$attrs->EOF) {
                $fields[$attrs->fields['attnum']] = $attrs->fields['attname'];
                $attrs->fields['attnotnull']      = $data->phpBool($attrs->fields['attnotnull']);
                // Set up default value if there isn't one already
                if (!isset($_REQUEST['values'][$attrs->fields['attnum']])) {
                    $_REQUEST['values'][$attrs->fields['attnum']] = $attrs->fields['adsrc'];
                    if ($attrs->fields['adsrc'] === null && !$attrs->fields['attnotnull']) {
                        $_REQUEST['nulls'][$attrs->fields['attnum']] = true;
                    }
                }

                // Default format to 'VALUE' if there is no default,
                // otherwise default to 'EXPRESSION'
                if (!isset($_REQUEST['format'][$attrs->fields['attnum']])) {
                    $_REQUEST['format'][$attrs->fields['attnum']] = (null === $attrs->fields['adsrc']) ? 'VALUE' : 'EXPRESSION';
                }

                // Continue drawing row
                $id = (0 == ($i % 2) ? '1' : '2');
                echo "<tr class=\"data{$id}\">\n";
                echo '<td style="white-space:nowrap;">', $this->misc->printVal($attrs->fields['attname']), '</td>';
                echo "<td style=\"white-space:nowrap;\">\n";
                echo $this->misc->printVal($data->formatType($attrs->fields['type'], $attrs->fields['atttypmod']));
                echo "<input type=\"hidden\" name=\"types[{$attrs->fields['attnum']}]\" value=\"",
                htmlspecialchars($attrs->fields['type']), '" /></td>';
                echo "<td style=\"white-space:nowrap;\">\n";
                echo "<select name=\"format[{$attrs->fields['attnum']}]\">\n";
                echo '<option value="VALUE"', ($_REQUEST['format'][$attrs->fields['attnum']] == 'VALUE') ? ' selected="selected"' : '', ">{$this->lang['strvalue']}</option>\n";
                echo '<option value="EXPRESSION"', ($_REQUEST['format'][$attrs->fields['attnum']] == 'EXPRESSION') ? ' selected="selected"' : '', ">{$this->lang['strexpression']}</option>\n";
                echo "</select>\n</td>\n";
                echo '<td style="white-space:nowrap;">';
                // Output null box if the column allows nulls (doesn't look at CHECKs or ASSERTIONS)
                if (!$attrs->fields['attnotnull']) {
                    echo "<label><span><input type=\"checkbox\" class=\"nullcheckbox\" name=\"nulls[{$attrs->fields['attnum']}]\"";
                    echo isset($_REQUEST['nulls'][$attrs->fields['attnum']]) ? ' checked="checked"' : '';
                    echo ' /></span></label>';
                }
                echo '</td>';

                echo "<td id=\"row_att_{$attrs->fields['attnum']}\" style=\"white-space:nowrap;\">";

                if ((false !== $fksprops) && isset($fksprops['byfield'][$attrs->fields['attnum']])) {
                    echo $data->printField(
                        "values[{$attrs->fields['attnum']}]",
                        $_REQUEST['values'][$attrs->fields['attnum']],
                        'fktype' /*force FK*/,
                        [
                            'id'           => "attr_{$attrs->fields['attnum']}",
                            'autocomplete' => 'off',
                            'class'        => 'insert_row_input',
                        ]
                    );
                } else {
                    echo $data->printField("values[{$attrs->fields['attnum']}]", $_REQUEST['values'][$attrs->fields['attnum']], $attrs->fields['type'], ['class' => 'insert_row_input']);
                }
                echo "</td>\n";
                echo "</tr>\n";
                ++$i;
                $attrs->moveNext();
            }
            echo "</table>\n";

            if (!isset($_SESSION['counter'])) {
                $_SESSION['counter'] = 0;
            }

            echo "<input type=\"hidden\" name=\"action\" value=\"insertrow\" />\n";
            echo '<input type="hidden" name="fields" value="', htmlentities(serialize($fields), ENT_QUOTES, 'UTF-8'), "\" />\n";
            echo '<input type="hidden" name="protection_counter" value="'.$_SESSION['counter']."\" />\n";
            echo '<input type="hidden" name="table" value="', htmlspecialchars($_REQUEST['table']), "\" />\n";
            echo "<p><input type=\"submit\" name=\"insert\" value=\"{$this->lang['strinsert']}\" />\n";
            echo "<input type=\"submit\" name=\"insertandrepeat\" accesskey=\"r\" value=\"{$this->lang['strinsertandrepeat']}\" />\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$this->lang['strcancel']}\" />\n";

            if (false !== $fksprops) {
                if ('default off' != $this->conf['autocomplete']) {
                    echo "<input type=\"checkbox\" id=\"no_ac\" value=\"1\" checked=\"checked\" /><label for=\"no_ac\">{$this->lang['strac']}</label>\n";
                } else {
                    echo "<input type=\"checkbox\" id=\"no_ac\" value=\"0\" /><label for=\"no_ac\">{$this->lang['strac']}</label>\n";
                }
            }
            echo "</p>\n";
        } else {
            echo "<p>{$this->lang['strnofieldsforinsert']}</p>\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$this->lang['strcancel']}\" />\n";
        }
        echo $this->misc->form;
        echo "</form>\n";
        echo '<script src="'.\SUBFOLDER.'/assets/js/insert_or_edit_row.js" type="text/javascript"></script>';
    }