PHPPgAdmin\Controller\TypesController::doCreateComposite()

Complexity

Conditions	27
Paths	26

Size

Total Lines	169
Code Lines	117

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $this->coalesceArr($_REQUEST, 'stage', 1);

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

        $this->coalesceArr($_REQUEST, 'fields', '');

        $this->coalesceArr($_REQUEST, 'typcomment', '');

        switch ($_REQUEST['stage']) {
            case 1:
                $this->printTrail('type');
                $this->printTitle($this->lang['strcreatecomptype'], 'pg.type.create');
                $this->printMsg($msg);

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

                echo "\t<tr>\n\t\t<th class=\"data left\">{$this->lang['strcomment']}</th>" . \PHP_EOL;
                echo "\t\t<td><textarea name=\"typcomment\" rows=\"3\" cols=\"32\">",
                \htmlspecialchars($_REQUEST['typcomment']), "</textarea></td>\n\t</tr>" . \PHP_EOL;

                echo '</table>' . \PHP_EOL;
                echo '<p><input type="hidden" name="action" value="create_comp" />' . \PHP_EOL;
                echo '<input type="hidden" name="stage" value="2" />' . \PHP_EOL;
                echo $this->view->form;
                echo "<input type=\"submit\" value=\"{$this->lang['strnext']}\" />" . \PHP_EOL;
                echo \sprintf('<input type="submit" name="cancel" value="%s"  /></p>%s', $this->lang['strcancel'], \PHP_EOL);
                echo '</form>' . \PHP_EOL;

                break;
            case 2:
                // Check inputs
                $fields = \trim($_REQUEST['fields']);

                if ('' === \trim($_REQUEST['name'])) {
                    $_REQUEST['stage'] = 1;
                    $this->doCreateComposite($this->lang['strtypeneedsname']);

                    return;
                }

                if ('' === $fields || !\is_numeric($fields) || (int) $fields !== $fields || 1 > $fields) {
                    $_REQUEST['stage'] = 1;
                    $this->doCreateComposite($this->lang['strtypeneedscols']);

                    return;
                }

                $types = $data->getTypes(true, false, true);

                $this->printTrail('schema');
                $this->printTitle($this->lang['strcreatecomptype'], 'pg.type.create');
                $this->printMsg($msg);

                echo '<form action="' . \containerInstance()->subFolder . '/src/views/types" method="post">' . \PHP_EOL;

                // Output table header
                echo '<table>' . \PHP_EOL;
                echo "\t<tr><th colspan=\"2\" class=\"data required\">{$this->lang['strfield']}</th><th colspan=\"2\" class=\"data required\">{$this->lang['strtype']}</th>";
                echo "<th class=\"data\">{$this->lang['strlength']}</th><th class=\"data\">{$this->lang['strcomment']}</th></tr>" . \PHP_EOL;

                for ($i = 0; $i < $_REQUEST['fields']; ++$i) {
                    if (!isset($_REQUEST['field'][$i])) {
                        $_REQUEST['field'][$i] = '';
                    }

                    if (!isset($_REQUEST['length'][$i])) {
                        $_REQUEST['length'][$i] = '';
                    }

                    if (!isset($_REQUEST['colcomment'][$i])) {
                        $_REQUEST['colcomment'][$i] = '';
                    }

                    echo "\t<tr>\n\t\t<td>", $i + 1, '.&nbsp;</td>' . \PHP_EOL;
                    echo "\t\t<td><input name=\"field[{$i}]\" size=\"16\" maxlength=\"{$data->_maxNameLen}\" value=\"",
                    \htmlspecialchars($_REQUEST['field'][$i]), '" /></td>' . \PHP_EOL;
                    echo "\t\t<td>\n\t\t\t<select name=\"type[{$i}]\">" . \PHP_EOL;
                    $types->moveFirst();

                    while (!$types->EOF) {
                        $typname = $types->fields['typname'];
                        echo "\t\t\t\t<option value=\"", \htmlspecialchars($typname), '"',
                        (isset($_REQUEST['type'][$i]) && $_REQUEST['type'][$i] === $typname) ? ' selected="selected"' : '', '>',
                        $this->misc->printVal($typname), '</option>' . \PHP_EOL;
                        $types->moveNext();
                    }
                    echo "\t\t\t</select>\n\t\t</td>" . \PHP_EOL;

                    // Output array type selector
                    echo "\t\t<td>\n\t\t\t<select name=\"array[{$i}]\">" . \PHP_EOL;
                    echo "\t\t\t\t<option value=\"\"", (isset($_REQUEST['array'][$i]) && '' === $_REQUEST['array'][$i]) ? ' selected="selected"' : '', '></option>' . \PHP_EOL;
                    echo "\t\t\t\t<option value=\"[]\"", (isset($_REQUEST['array'][$i]) && '[]' === $_REQUEST['array'][$i]) ? ' selected="selected"' : '', '>[ ]</option>' . \PHP_EOL;
                    echo "\t\t\t</select>\n\t\t</td>" . \PHP_EOL;

                    echo "\t\t<td><input name=\"length[{$i}]\" size=\"10\" value=\"",
                    \htmlspecialchars($_REQUEST['length'][$i]), '" /></td>' . \PHP_EOL;
                    echo "\t\t<td><input name=\"colcomment[{$i}]\" size=\"40\" value=\"",
                    \htmlspecialchars($_REQUEST['colcomment'][$i]), "\" /></td>\n\t</tr>" . \PHP_EOL;
                }
                echo '</table>' . \PHP_EOL;
                echo '<p><input type="hidden" name="action" value="create_comp" />' . \PHP_EOL;
                echo '<input type="hidden" name="stage" value="3" />' . \PHP_EOL;
                echo $this->view->form;
                echo '<input type="hidden" name="name" value="', \htmlspecialchars($_REQUEST['name']), '" />' . \PHP_EOL;
                echo '<input type="hidden" name="fields" value="', \htmlspecialchars($_REQUEST['fields']), '" />' . \PHP_EOL;
                echo '<input type="hidden" name="typcomment" value="', \htmlspecialchars($_REQUEST['typcomment']), '" />' . \PHP_EOL;
                echo "<input type=\"submit\" value=\"{$this->lang['strcreate']}\" />" . \PHP_EOL;
                echo \sprintf('<input type="submit" name="cancel" value="%s"  /></p>%s', $this->lang['strcancel'], \PHP_EOL);
                echo '</form>' . \PHP_EOL;

                break;
            case 3:
                // Check inputs
                $fields = \trim($_REQUEST['fields']);

                if ('' === \trim($_REQUEST['name'])) {
                    $_REQUEST['stage'] = 1;
                    $this->doCreateComposite($this->lang['strtypeneedsname']);

                    return;
                }

                if ('' === $fields || !\is_numeric($fields) || (int) $fields !== $fields || 0 >= $fields) {
                    $_REQUEST['stage'] = 1;
                    $this->doCreateComposite($this->lang['strtypeneedscols']);

                    return;
                }

                $status = $data->createCompositeType(
                    $_REQUEST['name'],
                    $_REQUEST['fields'],
                    $_REQUEST['field'],
                    $_REQUEST['type'],
                    $_REQUEST['array'],
                    $_REQUEST['length'],
                    $_REQUEST['colcomment'],
                    $_REQUEST['typcomment']
                );

                if (0 === $status) {
                    $this->doDefault($this->lang['strtypecreated']);
                } elseif (-1 === $status) {
                    $_REQUEST['stage'] = 2;
                    $this->doCreateComposite($this->lang['strtypeneedsfield']);

                    return;
                } else {
                    $_REQUEST['stage'] = 2;
                    $this->doCreateComposite($this->lang['strtypecreatedbad']);

                    return;
                }

                break;

            default:
                echo "<p>{$this->lang['strinvalidparam']}</p>" . \PHP_EOL;
        }