PHPPgAdmin\Controller\FunctionsController::doEdit()

Complexity

Conditions	23
Paths	1537

Size

Total Lines	188
Code Lines	130

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    /**
     * Function to allow editing of a Function.
     *
     * @param mixed $msg
     */
    public function doEdit($msg = ''): void
    {
        $data = $this->misc->getDatabaseAccessor();

        $this->printTrail('function');
        $this->printTabs('function', 'definition');
        $this->printTitle($this->lang['stralter'], 'pg.function.alter');
        $this->printMsg($msg);

        $fndata = $data->getFunction($_REQUEST['function_oid']);

        if (0 >= $fndata->RecordCount()) {
            echo \sprintf(
                '<p>%s</p>',
                $this->lang['strnodata']
            ) . \PHP_EOL;

            return;
        }
        $fndata->fields['proretset'] = $data->phpBool($fndata->fields['proretset']);

        // Initialise variables
        $_POST['formDefinition'] = $this->getPostParam('formDefinition', $fndata->fields['prosrc']);

        $_POST['formProperties'] = $this->getPostParam('formProperties', $data->getFunctionProperties($fndata->fields));

        $_POST['formFunction'] = $this->getPostParam('formFunction', $fndata->fields['proname']);

        $_POST['formComment'] = $this->getPostParam('formComment', $fndata->fields['procomment']);

        $_POST['formObjectFile'] = $this->getPostParam('formObjectFile', $fndata->fields['probin']);

        $_POST['formLinkSymbol'] = $this->getPostParam('formLinkSymbol', $fndata->fields['prosrc']);

        $_POST['formFuncOwn'] = $this->getPostParam('formFuncOwn', $fndata->fields['proowner']);

        $_POST['formFuncSchema'] = $this->getPostParam('formFuncSchema', $fndata->fields['proschema']);

        if ($data->hasFunctionCosting()) {
            $_POST['formCost'] = $this->getPostParam('formCost', $fndata->fields['procost']);

            $_POST['formRows'] = $this->getPostParam('formRows', $fndata->fields['prorows']);
        }

        // Deal with named parameters
        if ($data->hasNamedParams()) {
            $args = $this->_getNamedParamsArgs($data, $fndata);
        } else {
            $args = $fndata->fields['proarguments'];
        }

        echo '<form action="' . \containerInstance()->subFolder . '/src/views/functions" method="post">' . \PHP_EOL;
        echo '<table style="width: 95%">' . \PHP_EOL;
        echo '<tr>' . \PHP_EOL;
        echo \sprintf(
            '<th class="data required">%s</th>',
            $this->lang['strschema']
        ) . \PHP_EOL;
        echo \sprintf(
            '<th class="data required">%s</th>',
            $this->lang['strfunction']
        ) . \PHP_EOL;
        echo \sprintf(
            '<th class="data">%s</th>',
            $this->lang['strarguments']
        ) . \PHP_EOL;
        echo \sprintf(
            '<th class="data required">%s</th>',
            $this->lang['strreturns']
        ) . \PHP_EOL;
        echo \sprintf(
            '<th class="data required">%s</th>',
            $this->lang['strproglanguage']
        ) . \PHP_EOL;
        echo '</tr>' . \PHP_EOL;

        echo '<tr>' . \PHP_EOL;
        echo '<td class="data1">';
        echo '<input type="hidden" name="original_schema" value="', \htmlspecialchars($fndata->fields['proschema']), '" />' . \PHP_EOL;

        if ($data->hasFunctionAlterSchema()) {
            $schemas = $data->getSchemas();
            echo '<select name="formFuncSchema">';

            while (!$schemas->EOF) {
                $schema = $schemas->fields['nspname'];
                echo '<option value="', \htmlspecialchars($schema), '"',
                ($schema === $_POST['formFuncSchema']) ? ' selected="selected"' : '', '>', \htmlspecialchars($schema), '</option>' . \PHP_EOL;
                $schemas->MoveNext();
            }
            echo '</select>' . \PHP_EOL;
        } else {
            echo $fndata->fields['proschema'];
        }

        echo '</td>' . \PHP_EOL;
        echo '<td class="data1">';
        echo '<input type="hidden" name="original_function" value="', \htmlspecialchars($fndata->fields['proname']), '" />' . \PHP_EOL;
        echo \sprintf(
            '<input name="formFunction" style="width: 100%; box-sizing: border-box;" maxlength="%s" value="',
            $data->_maxNameLen
        ), \htmlspecialchars($_POST['formFunction']), '" />';
        echo '</td>' . \PHP_EOL;

        echo '<td class="data1">', $this->misc->printVal($args), \PHP_EOL;
        echo '<input type="hidden" name="original_arguments" value="', \htmlspecialchars($args), '" />' . \PHP_EOL;
        echo '</td>' . \PHP_EOL;

        echo '<td class="data1">';

        if ($fndata->fields['proretset']) {
            echo 'setof ';
        }

        echo $this->misc->printVal($fndata->fields['proresult']), \PHP_EOL;
        echo '<input type="hidden" name="original_returns" value="', \htmlspecialchars($fndata->fields['proresult']), '" />' . \PHP_EOL;

        if ($fndata->fields['proretset']) {
            echo '<input type="hidden" name="original_setof" value="yes" />' . \PHP_EOL;
        }

        echo '</td>' . \PHP_EOL;

        echo '<td class="data1">', $this->misc->printVal($fndata->fields['prolanguage']), \PHP_EOL;
        echo '<input type="hidden" name="original_lang" value="', \htmlspecialchars($fndata->fields['prolanguage']), '" />' . \PHP_EOL;
        echo '</td>' . \PHP_EOL;
        echo '</tr>' . \PHP_EOL;

        $fnlang = \mb_strtolower($fndata->fields['prolanguage']);

        if ('c' === $fnlang) {
            echo \sprintf(
                '<tr><th class="data required" colspan="2">%s</th>',
                $this->lang['strobjectfile']
            ) . \PHP_EOL;
            echo \sprintf(
                '<th class="data" colspan="2">%s</th></tr>',
                $this->lang['strlinksymbol']
            ) . \PHP_EOL;
            echo '<tr><td class="data1" colspan="2"><input type="text" name="formObjectFile" style="width:100%" value="',
            \htmlspecialchars($_POST['formObjectFile']), '" /></td>' . \PHP_EOL;
            echo '<td class="data1" colspan="2"><input type="text" name="formLinkSymbol" style="width:100%" value="',
            \htmlspecialchars($_POST['formLinkSymbol']), '" /></td></tr>' . \PHP_EOL;
        } elseif ('internal' === $fnlang) {
            echo \sprintf(
                '<tr><th class="data" colspan="5">%s</th></tr>',
                $this->lang['strlinksymbol']
            ) . \PHP_EOL;
            echo '<tr><td class="data1" colspan="5"><input type="text" name="formLinkSymbol" style="width:100%" value="',
            \htmlspecialchars($_POST['formLinkSymbol']), '" /></td></tr>' . \PHP_EOL;
        } else {
            echo \sprintf(
                '<tr><th class="data required" colspan="5">%s</th></tr>',
                $this->lang['strdefinition']
            ) . \PHP_EOL;
            echo '<tr><td class="data1" colspan="5">';
            $textarea_id = ('sql' === $fnlang || 'plpgsql' === $fnlang) ? 'query' : 'formDefinition';
            echo '<textarea style="width:100%;" rows="20" cols="50" id="' . $textarea_id . '" name="formDefinition">';
            echo \htmlspecialchars($_POST['formDefinition']);
            echo '</textarea></td></tr>' . \PHP_EOL;
        }

        // Display function comment
        echo \sprintf(
            '<tr><th class="data" colspan="5">%s</th></tr>',
            $this->lang['strcomment']
        ) . \PHP_EOL;
        echo '<tr><td class="data1" colspan="5">';
        echo '<textarea style="width:100%;" name="formComment" rows="3" cols="50">';
        echo \htmlspecialchars($_POST['formComment']);
        echo '</textarea></td></tr>' . \PHP_EOL;

        // Display function cost options
        if ($data->hasFunctionCosting()) {
            echo \sprintf(
                '<tr><th class="data required" colspan="5">%s</th></tr>',
                $this->lang['strfunctioncosting']
            ) . \PHP_EOL;
            echo \sprintf(
                '<td class="data1" colspan="2">%s: <input name="formCost" size="16" value="',
                $this->lang['strexecutioncost']
            ) .
            \htmlspecialchars($_POST['formCost']) . '" /></td>';
            echo \sprintf(