PHPPgAdmin\Traits\ViewsMatviewsTrait::printParamsCreateForm()

Complexity

Conditions	14
Paths	1800

Size

Total Lines	132
Code Lines	85

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

        $tblCount = \count($_POST['formTables']);
        $arrSelTables = [];
        //unserialize our schema/table information and store in arrSelTables
        for ($i = 0; $i < $tblCount; ++$i) {
            $arrSelTables[] = \unserialize($_POST['formTables'][$i]);
        }

        //get linking keys
        $rsLinkKeys = $data->getLinkingKeys($arrSelTables);
        $linkCount = $rsLinkKeys->recordCount() > $tblCount ? $rsLinkKeys->recordCount() : $tblCount;

        $arrFields = []; //array that will hold all our table/field names

        //if we have schemas we need to specify the correct schema for each table we're retrieiving
        //with getTableAttributes
        $curSchema = $data->_schema;

        for ($i = 0; $i < $tblCount; ++$i) {
            if ($arrSelTables[$i]['schemaname'] !== $data->_schema) {
                $data->setSchema($arrSelTables[$i]['schemaname']);
            }

            $attrs = $data->getTableAttributes($arrSelTables[$i]['tablename']);

            while (!$attrs->EOF) {
                $arrFields["{$arrSelTables[$i]['schemaname']}.{$arrSelTables[$i]['tablename']}.{$attrs->fields['attname']}"] = \serialize(
                    [
                        'schemaname' => $arrSelTables[$i]['schemaname'],
                        'tablename' => $arrSelTables[$i]['tablename'],
                        'fieldname' => $attrs->fields['attname'], ]
                );
                $attrs->moveNext();
            }

            $data->setSchema($curSchema);
        }
        \asort($arrFields);

        echo '<form action="' . \containerInstance()->subFolder . '/src/views/materializedviews" method="post">' . \PHP_EOL;
        echo '<table>' . \PHP_EOL;
        echo "<tr><th class=\"data\">{$this->lang['strviewname']}</th></tr>";
        echo "<tr>\n<td class=\"data1\">" . \PHP_EOL;
        // View name
        echo '<input name="formView" value="' . \htmlspecialchars($_REQUEST['formView']) . "\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" />" . \PHP_EOL;
        echo "</td>\n</tr>" . \PHP_EOL;
        echo "<tr><th class=\"data\">{$this->lang['strcomment']}</th></tr>";
        echo "<tr>\n<td class=\"data1\">" . \PHP_EOL;
        // View comments
        echo '<textarea name="formComment" rows="3" cols="32">' . \htmlspecialchars($_REQUEST['formComment']) . '</textarea>' . \PHP_EOL;
        echo "</td>\n</tr>" . \PHP_EOL;
        echo '</table>' . \PHP_EOL;

        // Output selector for fields to be retrieved from view
        echo '<table>' . \PHP_EOL;
        echo "<tr><th class=\"data\">{$this->lang['strcolumns']}</th></tr>";
        echo "<tr>\n<td class=\"data1\">" . \PHP_EOL;
        echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrFields, 'formFields[]', false, '', true);
        echo "</td>\n</tr>";
        echo '<tr><td>';
        echo \sprintf('<input type="radio" name="dblFldMeth" id="dblFldMeth1" value="rename" /><label for="dblFldMeth1">%s</label><br>', $this->lang['strrenamedupfields']);
        echo \sprintf('<input type="radio" name="dblFldMeth" id="dblFldMeth2" value="drop" /><label for="dblFldMeth2">%s</label><br>', $this->lang['strdropdupfields']);
        echo \sprintf('<input type="radio" name="dblFldMeth" id="dblFldMeth3" value="" checked="checked" /><label for="dblFldMeth3">%s</label>', $this->lang['strerrordupfields']);
        echo '</td></tr></table><br />';

        // Output the Linking keys combo boxes
        echo '<table>' . \PHP_EOL;
        echo "<tr><th class=\"data\">{$this->lang['strviewlink']}</th></tr>";
        $rowClass = 'data1';
        $formLink = [];

        for ($i = 0; $i < $linkCount; ++$i) {
            // Initialise variables
            $formLink[$i] = $formLink[$i] ?? [];
            $this->coalesceArr($formLink[$i], 'operator', 'INNER JOIN');

            echo "<tr>\n<td class=\"{$rowClass}\">" . \PHP_EOL;

            if (!$rsLinkKeys->EOF) {
                $curLeftLink = \htmlspecialchars(\serialize(['schemaname' => $rsLinkKeys->fields['p_schema'], 'tablename' => $rsLinkKeys->fields['p_table'], 'fieldname' => $rsLinkKeys->fields['p_field']]));

This line exceeds maximum limit of 190 characters; contains 206 characters

                $curRightLink = \htmlspecialchars(\serialize(['schemaname' => $rsLinkKeys->fields['f_schema'], 'tablename' => $rsLinkKeys->fields['f_table'], 'fieldname' => $rsLinkKeys->fields['f_field']]));

This line exceeds maximum limit of 190 characters; contains 207 characters

                $rsLinkKeys->moveNext();
            } else {
                $curLeftLink = '';
                $curRightLink = '';
            }

            echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrFields, "formLink[{$i}][leftlink]", true, $curLeftLink, false);
            echo \PHPPgAdmin\XHtml\HTMLController::printCombo($data->joinOps, "formLink[{$i}][operator]", true, $formLink[$i]['operator']);
            echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrFields, "formLink[{$i}][rightlink]", true, $curRightLink, false);
            echo "</td>\n</tr>" . \PHP_EOL;
            $rowClass = 'data1' === $rowClass ? 'data2' : 'data1';
        }
        echo "</table>\n<br />" . \PHP_EOL;

        // Build list of available operators (infix only)
        $arrOperators = [];

        foreach ($data->selectOps as $k => $v) {
            if ('i' === $v) {
                $arrOperators[$k] = $k;
            }
        }

        // Output additional conditions, note that this portion of the wizard treats the right hand side as literal values
        //(not as database objects) so field names will be treated as strings, use the above linking keys section to perform joins
        echo '<table>' . \PHP_EOL;
        echo "<tr><th class=\"data\">{$this->lang['strviewconditions']}</th></tr>";
        $rowClass = 'data1';

        for ($i = 0; $i < $linkCount; ++$i) {
            echo "<tr>\n<td class=\"{$rowClass}\">" . \PHP_EOL;
            echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrFields, "formCondition[{$i}][field]");
            echo \PHPPgAdmin\XHtml\HTMLController::printCombo($arrOperators, "formCondition[{$i}][operator]", false, '', false);
            echo "<input type=\"text\" name=\"formCondition[{$i}][txt]\" />" . \PHP_EOL;
            echo "</td>\n</tr>" . \PHP_EOL;
            $rowClass = 'data1' === $rowClass ? 'data2' : 'data1';
        }
        echo '</table>' . \PHP_EOL;
        echo '<p><input type="hidden" name="action" value="save_create_wiz" />' . \PHP_EOL;

        foreach ($arrSelTables as $curTable) {
            echo '<input type="hidden" name="formTables[]" value="' . \htmlspecialchars(\serialize($curTable)) . '" />' . \PHP_EOL;
        }

        echo $this->view->form;
        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;
    }