PHPPgAdmin\Controller\FunctionsController::doEdit()

Complexity

Conditions	23
Paths	1537

Size

Total Lines	178
Code Lines	129

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

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

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

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

        if ($fndata->recordCount() <= 0) {
            echo "<p>{$this->lang['strnodata']}</p>\n";
            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="' . \SUBFOLDER . "/src/views/functions\" method=\"post\">\n";
        echo "<table style=\"width: 90%\">\n";
        echo "<tr>\n";
        echo "<th class=\"data required\">{$this->lang['strschema']}</th>\n";
        echo "<th class=\"data required\">{$this->lang['strfunction']}</th>\n";
        echo "<th class=\"data\">{$this->lang['strarguments']}</th>\n";
        echo "<th class=\"data required\">{$this->lang['strreturns']}</th>\n";
        echo "<th class=\"data required\">{$this->lang['strproglanguage']}</th>\n";
        echo "</tr>\n";

        echo "<tr>\n";
        echo '<td class="data1">';
        echo '<input type="hidden" name="original_schema" value="', htmlspecialchars($fndata->fields['proschema']), "\" />\n";
        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>\n";
                $schemas->moveNext();
            }
            echo "</select>\n";
        } else {
            echo $fndata->fields['proschema'];
        }

        echo "</td>\n";
        echo '<td class="data1">';
        echo '<input type="hidden" name="original_function" value="', htmlspecialchars($fndata->fields['proname']), "\" />\n";
        echo "<input name=\"formFunction\" style=\"width: 100%\" maxlength=\"{$data->_maxNameLen}\" value=\"", htmlspecialchars($_POST['formFunction']), '" />';
        echo "</td>\n";

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

        echo '<td class="data1">';
        if ($fndata->fields['proretset']) {
            echo 'setof ';
        }

        echo $this->misc->printVal($fndata->fields['proresult']), "\n";
        echo '<input type="hidden" name="original_returns" value="', htmlspecialchars($fndata->fields['proresult']), "\" />\n";
        if ($fndata->fields['proretset']) {
            echo "<input type=\"hidden\" name=\"original_setof\" value=\"yes\" />\n";
        }

        echo "</td>\n";

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

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

        // Display function comment
        echo "<tr><th class=\"data\" colspan=\"5\">{$this->lang['strcomment']}</th></tr>\n";
        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>\n";

        // Display function cost options
        if ($data->hasFunctionCosting()) {
            echo "<tr><th class=\"data required\" colspan=\"5\">{$this->lang['strfunctioncosting']}</th></tr>\n";
            echo "<td class=\"data1\" colspan=\"2\">{$this->lang['strexecutioncost']}: <input name=\"formCost\" size=\"16\" value=\"" .
            htmlspecialchars($_POST['formCost']) . '" /></td>';
            echo "<td class=\"data1\" colspan=\"2\">{$this->lang['strresultrows']}: <input name=\"formRows\" size=\"16\" value=\"",
            htmlspecialchars($_POST['formRows']), '"', (!$fndata->fields['proretset']) ? 'disabled' : '', '/></td>';
        }

        // Display function properties
        if (is_array($data->funcprops) && sizeof($data->funcprops) > 0) {
            echo "<tr><th class=\"data\" colspan=\"5\">{$this->lang['strproperties']}</th></tr>\n";
            echo "<tr><td class=\"data1\" colspan=\"5\">\n";
            $i = 0;
            foreach ($data->funcprops as $k => $v) {
                echo "<select name=\"formProperties[{$i}]\">\n";
                foreach ($v as $p) {
                    echo '<option value="', htmlspecialchars($p), '"',
                    ($_POST['formProperties'][$i] == $p) ? ' selected="selected"' : '',
                    '>', $this->misc->printVal($p), "</option>\n";
                }
                echo "</select><br />\n";
                ++$i;
            }
            echo "</td></tr>\n";
        }

        // function owner
        if ($data->hasFunctionAlterOwner()) {
            $users = $data->getUsers();
            echo "<tr><td class=\"data1\" colspan=\"5\">{$this->lang['strowner']}: <select name=\"formFuncOwn\">";
            while (!$users->EOF) {
                $uname = $users->fields['usename'];
                echo '<option value="', htmlspecialchars($uname), '"',
                ($uname == $_POST['formFuncOwn']) ? ' selected="selected"' : '', '>', htmlspecialchars($uname), "</option>\n";
                $users->moveNext();
            }
            echo "</select>\n";
            echo '<input type="hidden" name="original_owner" value="', htmlspecialchars($fndata->fields['proowner']), "\" />\n";
            echo "</td></tr>\n";
        }
        echo "</table>\n";
        echo "<p><input type=\"hidden\" name=\"action\" value=\"save_edit\" />\n";
        echo '<input type="hidden" name="function" value="', htmlspecialchars($_REQUEST['function']), "\" />\n";
        echo '<input type="hidden" name="function_oid" value="', htmlspecialchars($_REQUEST['function_oid']), "\" />\n";
        echo $this->misc->form;
        echo "<input type=\"submit\" value=\"{$this->lang['stralter']}\" />\n";
        echo "<input type=\"submit\" name=\"cancel\" value=\"{$this->lang['strcancel']}\" /></p>\n";
        echo "</form>\n";
    }