HuasoFoundries / phpPgAdmin6

src/controllers/FulltextController.php

<?php

You must use "/**" style comments for a file comment

/*
 * PHPPgAdmin v6.0.0-beta.30
 */

namespace PHPPgAdmin\Controller;

use PHPPgAdmin\Decorators\Decorator;

/**
 * Base controller class.
 */
class FulltextController extends BaseController
{
    public $controller_name = 'FulltextController';

    /**
     * Default method to render the controller according to the action parameter.
     */
    public function render()
    {
        $conf = $this->conf;

        $lang = $this->lang;

        $action = $this->action;
        if ('tree' == $action) {
            return $this->doTree();
        }
        if ('subtree' == $action) {
            return $this->doSubTree($_REQUEST['what']);
        }

        $this->printHeader($lang['strschemas']);
        $this->printBody();

        if (isset($_POST['cancel'])) {
            if (isset($_POST['prev_action'])) {
                $action = $_POST['prev_action'];
            } else {
                $action = '';
            }
        }

        switch ($action) {
            case 'createconfig':
                if (isset($_POST['create'])) {
                    $this->doSaveCreateConfig();
                } else {
                    $this->doCreateConfig();
                }

                break;
            case 'alterconfig':
                if (isset($_POST['alter'])) {
                    $this->doSaveAlterConfig();
                } else {
                    $this->doAlterConfig();
                }

                break;
            case 'dropconfig':
                if (isset($_POST['drop'])) {
                    $this->doDropConfig(false);
                } else {
                    $this->doDropConfig(true);
                }

                break;
            case 'viewconfig':
                $this->doViewConfig($_REQUEST['ftscfg']);

                break;
            case 'viewparsers':
                $this->doViewParsers();

                break;
            case 'viewdicts':
                $this->doViewDicts();

                break;
            case 'createdict':
                if (isset($_POST['create'])) {
                    $this->doSaveCreateDict();
                } else {
                    doCreateDict();
                }

                break;
            case 'alterdict':
                if (isset($_POST['alter'])) {
                    $this->doSaveAlterDict();
                } else {
                    $this->doAlterDict();
                }

                break;
            case 'dropdict':
                if (isset($_POST['drop'])) {
                    $this->doDropDict(false);
                } else {
                    $this->doDropDict(true);
                }

                break;
            case 'dropmapping':
                if (isset($_POST['drop'])) {
                    $this->doDropMapping(false);
                } else {
                    $this->doDropMapping(true);
                }

                break;
            case 'altermapping':
                if (isset($_POST['alter'])) {
                    $this->doSaveAlterMapping();
                } else {
                    $this->doAlterMapping();
                }

                break;
            case 'addmapping':
                if (isset($_POST['add'])) {
                    $this->doSaveAddMapping();
                } else {
                    $this->doAddMapping();
                }

                break;
            default:
                $this->doDefault();

                break;
        }

        return $this->printFooter();
    }

    public function doDefault($msg = '')
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $this->printTrail('schema');
        $this->printTabs('schema', 'fulltext');
        $this->printTabs('fulltext', 'ftsconfigs');
        $this->printMsg($msg);

        $cfgs = $data->getFtsConfigurations(false);

        $columns = [
            'configuration' => [
                'title' => $lang['strftsconfig'],
                'field' => Decorator::field('name'),
                'url'   => "fulltext.php?action=viewconfig&{$this->misc->href}&",
                'vars'  => ['ftscfg' => 'name'],
            ],
            'schema' => [
                'title' => $lang['strschema'],
                'field' => Decorator::field('schema'),
            ],
            'actions' => [
                'title' => $lang['stractions'],
            ],
            'comment' => [
                'title' => $lang['strcomment'],
                'field' => Decorator::field('comment'),
            ],
        ];

        $actions = [
            'drop' => [
                'content' => $lang['strdrop'],
                'attr'    => [
                    'href' => [
                        'url'     => 'fulltext.php',
                        'urlvars' => [
                            'action' => 'dropconfig',
                            'ftscfg' => Decorator::field('name'),
                        ],
                    ],
                ],
            ],
            'alter' => [
                'content' => $lang['stralter'],
                'attr'    => [
                    'href' => [
                        'url'     => 'fulltext.php',
                        'urlvars' => [
                            'action' => 'alterconfig',
                            'ftscfg' => Decorator::field('name'),
                        ],
                    ],
                ],
            ],
        ];

        echo $this->printTable($cfgs, $columns, $actions, 'fulltext-fulltext', $lang['strftsnoconfigs']);

        $navlinks = [
            'createconf' => [
                'attr' => [
                    'href' => [
                        'url'     => 'fulltext.php',
                        'urlvars' => [
                            'action'   => 'createconfig',
                            'server'   => $_REQUEST['server'],
                            'database' => $_REQUEST['database'],
                            'schema'   => $_REQUEST['schema'],
                        ],
                    ],
                ],
                'content' => $lang['strftscreateconfig'],
            ],
        ];

        $this->printNavLinks($navlinks, 'fulltext-fulltext', get_defined_vars());
    }

    /**
     * Generate XML for the browser tree.
     */
    public function doTree()
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $tabs  = $this->misc->getNavTabs('fulltext');
        $items = $this->adjustTabsForTree($tabs);

        $reqvars = $this->misc->getRequestVars('ftscfg');

        $attrs = [
            'text'   => Decorator::field('title'),
            'icon'   => Decorator::field('icon'),
            'action' => Decorator::actionurl(
                'fulltext.php',
                $reqvars,
                Decorator::field('urlvars')
            ),
            'branch' => Decorator::url(
                'fulltext.php',
                $reqvars,
                [
                    'action' => 'subtree',
                    'what'   => Decorator::field('icon'), // IZ: yeah, it's ugly, but I do not want to change navigation tabs arrays
                ]
            ),
        ];

        return $this->printTree($items, $attrs, 'fts');
    }

    public function doSubTree($what)
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        switch ($what) {
            case 'FtsCfg':
                $items   = $data->getFtsConfigurations(false);
                $urlvars = ['action' => 'viewconfig', 'ftscfg' => Decorator::field('name')];

                break;
            case 'FtsDict':
                $items   = $data->getFtsDictionaries(false);
                $urlvars = ['action' => 'viewdicts'];

                break;
            case 'FtsParser':
                $items   = $data->getFtsParsers(false);
                $urlvars = ['action' => 'viewparsers'];

                break;
            default:
                return;
        }

        $reqvars = $this->misc->getRequestVars('ftscfg');

        $attrs = [
            'text'    => Decorator::field('name'),
            'icon'    => $what,
            'toolTip' => Decorator::field('comment'),
            'action'  => Decorator::actionurl(
                'fulltext.php',
                $reqvars,
                $urlvars
            ),
            'branch' => Decorator::ifempty(
                Decorator::field('branch'),
                '',
                Decorator::url(
                    'fulltext.php',
                    $reqvars,
                    [
                        'action' => 'subtree',
                        'ftscfg' => Decorator::field('name'),
                    ]
                )
            ),
        ];

        return $this->printTree($items, $attrs, strtolower($what));
    }

    public function doDropConfig($confirm)
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        if ($confirm) {
            $this->printTrail('ftscfg');
            $this->printTitle($lang['strdrop'], 'pg.ftscfg.drop');

            echo '<p>', sprintf($lang['strconfdropftsconfig'], $this->misc->printVal($_REQUEST['ftscfg'])), "</p>\n";

            echo '<form action="'.\SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n";
            echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$lang['strcascade']}</label></p>\n";
            echo "<p><input type=\"hidden\" name=\"action\" value=\"dropconfig\" />\n";
            echo '<input type="hidden" name="database" value="', htmlspecialchars($_REQUEST['database']), "\" />\n";
            echo '<input type="hidden" name="ftscfg" value="', htmlspecialchars($_REQUEST['ftscfg']), "\" />\n";
            echo $this->misc->form;
            echo "<input type=\"submit\" name=\"drop\" value=\"{$lang['strdrop']}\" />\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
            echo "</form>\n";
        } else {
            $status = $data->dropFtsConfiguration($_POST['ftscfg'], isset($_POST['cascade']));
            if (0 == $status) {
                $this->misc->setReloadBrowser(true);
                $this->doDefault($lang['strftsconfigdropped']);
            } else {
                $this->doDefault($lang['strftsconfigdroppedbad']);
            }
        }
    }

    public function doDropDict($confirm)
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        if ($confirm) {
            $this->printTrail('ftscfg'); // TODO: change to smth related to dictionary
            $this->printTitle($lang['strdrop'], 'pg.ftsdict.drop');

            echo '<p>', sprintf($lang['strconfdropftsdict'], $this->misc->printVal($_REQUEST['ftsdict'])), "</p>\n";

            echo '<form action="'.\SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n";
            echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$lang['strcascade']}</label></p>\n";
            echo "<p><input type=\"hidden\" name=\"action\" value=\"dropdict\" />\n";
            echo '<input type="hidden" name="database" value="', htmlspecialchars($_REQUEST['database']), "\" />\n";
            echo '<input type="hidden" name="ftsdict" value="', htmlspecialchars($_REQUEST['ftsdict']), "\" />\n";
            //echo "<input type=\"hidden\" name=\"ftscfg\" value=\"", htmlspecialchars($_REQUEST['ftscfg']), "\" />\n";
            echo "<input type=\"hidden\" name=\"prev_action\" value=\"viewdicts\" /></p>\n";
            echo $this->misc->form;
            echo "<input type=\"submit\" name=\"drop\" value=\"{$lang['strdrop']}\" />\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
            echo "</form>\n";
        } else {
            $status = $data->dropFtsDictionary($_POST['ftsdict'], isset($_POST['cascade']));
            if (0 == $status) {
                $this->misc->setReloadBrowser(true);
                $this->doViewDicts($lang['strftsdictdropped']);
            } else {
                $this->doViewDicts($lang['strftsdictdroppedbad']);
            }
        }
    }

    /**
     * Displays a screen where one can enter a new FTS configuration.
     *
     * @param mixed $msg

Missing parameter comment

     */
    public function doCreateConfig($msg = '')
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $server_info = $this->misc->getServerInfo();

        if (!isset($_POST['formName'])) {
            $_POST['formName'] = '';
        }

        if (!isset($_POST['formParser'])) {
            $_POST['formParser'] = '';
        }

        if (!isset($_POST['formTemplate'])) {
            $_POST['formTemplate'] = '';
        }

        if (!isset($_POST['formWithMap'])) {
            $_POST['formWithMap'] = '';
        }

        if (!isset($_POST['formComment'])) {
            $_POST['formComment'] = '';
        }

        // Fetch all FTS configurations from the database
        $ftscfgs = $data->getFtsConfigurations();
        // Fetch all FTS parsers from the database
        $ftsparsers = $data->getFtsParsers();

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

        echo '<form action="'.\SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n";
        echo "<table>\n";
        // conf name
        echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strname']}</th>\n";
        echo "\t\t<td class=\"data1\"><input name=\"formName\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
        htmlspecialchars($_POST['formName']), "\" /></td>\n\t</tr>\n";

        // Template
        echo "\t<tr>\n\t\t<th class=\"data left\">{$lang['strftstemplate']}</th>\n";
        echo "\t\t<td class=\"data1\">";

        $tpls   = [];
        $tplsel = '';
        while (!$ftscfgs->EOF) {
            $data->fieldClean($ftscfgs->fields['schema']);
            $data->fieldClean($ftscfgs->fields['name']);
            $tplname        = $ftscfgs->fields['schema'].'.'.$ftscfgs->fields['name'];
            $tpls[$tplname] = serialize([
                'name'   => $ftscfgs->fields['name'],
                'schema' => $ftscfgs->fields['schema'],
            ]);
            if ($_POST['formTemplate'] == $tpls[$tplname]) {
                $tplsel = htmlspecialchars($tpls[$tplname]);
            }
            $ftscfgs->moveNext();
        }
        echo \PHPPgAdmin\XHtml\HTMLController::printCombo($tpls, 'formTemplate', true, $tplsel, false);
        echo "\n\t\t</td>\n\t</tr>\n";

        // Parser
        echo "\t<tr>\n\t\t<th class=\"data left\">{$lang['strftsparser']}</th>\n";
        echo "\t\t<td class=\"data1\">\n";
        $ftsparsers_ = [];
        $ftsparsel   = '';
        while (!$ftsparsers->EOF) {
            $data->fieldClean($ftsparsers->fields['schema']);
            $data->fieldClean($ftsparsers->fields['name']);
            $parsername = $ftsparsers->fields['schema'].'.'.$ftsparsers->fields['name'];

            $ftsparsers_[$parsername] = serialize([
                'parser' => $ftsparsers->fields['name'],
                'schema' => $ftsparsers->fields['schema'],
            ]);
            if ($_POST['formParser'] == $ftsparsers_[$parsername]) {
                $ftsparsel = htmlspecialchars($ftsparsers_[$parsername]);
            }
            $ftsparsers->moveNext();
        }
        echo \PHPPgAdmin\XHtml\HTMLController::printCombo($ftsparsers_, 'formParser', true, $ftsparsel, false);
        echo "\n\t\t</td>\n\t</tr>\n";

        // Comment
        echo "\t<tr>\n\t\t<th class=\"data left\">{$lang['strcomment']}</th>\n";
        echo "\t\t<td class=\"data1\"><textarea name=\"formComment\" rows=\"3\" cols=\"32\">",
        htmlspecialchars($_POST['formComment']), "</textarea></td>\n\t</tr>\n";

        echo "</table>\n";
        echo "<p>\n";
        echo "<input type=\"hidden\" name=\"action\" value=\"createconfig\" />\n";
        echo '<input type="hidden" name="database" value="', htmlspecialchars($_REQUEST['database']), "\" />\n";
        echo $this->misc->form;
        echo "<input type=\"submit\" name=\"create\" value=\"{$lang['strcreate']}\" />\n";
        echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" />\n";
        echo "</p>\n";
        echo "</form>\n";
    }

    /**
     * Actually creates the new FTS configuration in the database.
     */
    public function doSaveCreateConfig()
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $err = '';
        // Check that they've given a name
        if ('' == $_POST['formName']) {
            $err .= "{$lang['strftsconfigneedsname']}<br />";
        }

        if (('' != $_POST['formParser']) && ('' != $_POST['formTemplate'])) {
            $err .= "{$lang['strftscantparsercopy']}<br />";
        }

        if ('' != $err) {

The condition '' != $err can never be true.

            return doCreateConfig($err);
        }

        if ('' != $_POST['formParser']) {
            $formParser = unserialize($_POST['formParser']);
        } else {
            $formParser = '';
        }

        if ('' != $_POST['formTemplate']) {
            $formTemplate = unserialize($_POST['formTemplate']);
        } else {
            $formTemplate = '';
        }

        $status = $data->createFtsConfiguration($_POST['formName'], $formParser, $formTemplate, $_POST['formComment']);
        if (0 == $status) {
            $this->misc->setReloadBrowser(true);
            $this->doDefault($lang['strftsconfigcreated']);
        } else {
            $this->doCreateConfig($lang['strftsconfigcreatedbad']);
        }
    }

    /**
     * Display a form to permit editing FTS configuration properies.
     *
     * @param mixed $msg

Missing parameter comment

     */
    public function doAlterConfig($msg = '')
    {
        $conf = $this->conf;

The assignment to $conf is dead and can be removed.

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

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

        $ftscfg = $data->getFtsConfigurationByName($_REQUEST['ftscfg']);
        if ($ftscfg->recordCount() > 0) {
            if (!isset($_POST['formComment'])) {
                $_POST['formComment'] = $ftscfg->fields['comment'];
            }

            if (!isset($_POST['ftscfg'])) {
                $_POST['ftscfg'] = $_REQUEST['ftscfg'];
            }

            if (!isset($_POST['formName'])) {
                $_POST['formName'] = $_REQUEST['ftscfg'];
            }

            if (!isset($_POST['formParser'])) {
                $_POST['formParser'] = '';
            }

            // Fetch all FTS parsers from the database
            $ftsparsers = $data->getFtsParsers();

            echo '<form action="'.\SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n";
            echo "<table>\n";

            echo "\t<tr>\n";
            echo "\t\t<th class=\"data left required\">{$lang['strname']}</th>\n";
            echo "\t\t<td class=\"data1\">";
            echo "\t\t\t<input name=\"formName\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
            htmlspecialchars($_POST['formName']), "\" />\n";
            echo "\t\t</td>\n";
            echo "\t</tr>\n";

            // Comment
            echo "\t<tr>\n";
            echo "\t\t<th class=\"data\">{$lang['strcomment']}</th>\n";
            echo "\t\t<td class=\"data1\"><textarea cols=\"32\" rows=\"3\"name=\"formComment\">", htmlspecialchars($_POST['formComment']), "</textarea></td>\n";
            echo "\t</tr>\n";
            echo "</table>\n";
            echo "<p><input type=\"hidden\" name=\"action\" value=\"alterconfig\" />\n";
            echo '<input type="hidden" name="ftscfg" value="', htmlspecialchars($_POST['ftscfg']), "\" />\n";
            echo $this->misc->form;
            echo "<input type=\"submit\" name=\"alter\" value=\"{$lang['stralter']}\" />\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
            echo "</form>\n";
        } else {
            echo "<p>{$lang['strnodata']}</p>\n";
        }
    }

    /**
     * Save the form submission containing changes to a FTS configuration.
     */
    public function doSaveAlterConfig()
    {
        $conf = $this->conf;

        $lang   = $this->lang;
        $data   = $this->misc->getDatabaseAccessor();
        $status = $data->updateFtsConfiguration($_POST['ftscfg'], $_POST['formComment'], $_POST['formName']);
        if (0 == $status) {
            $this->doDefault($lang['strftsconfigaltered']);
        } else {
            $this->doAlterConfig($lang['strftsconfigalteredbad']);
        }
    }

    /**
     * View list of FTS parsers.
     *
     * @param mixed $msg

Missing parameter comment

     */
    public function doViewParsers($msg = '')
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $this->printTrail('schema');
        $this->printTabs('schema', 'fulltext');
        $this->printTabs('fulltext', 'ftsparsers');
        $this->printMsg($msg);

        $parsers = $data->getFtsParsers(false);

        $columns = [
            'schema' => [
                'title' => $lang['strschema'],
                'field' => Decorator::field('schema'),
            ],
            'name' => [
                'title' => $lang['strname'],
                'field' => Decorator::field('name'),
            ],
            'comment' => [
                'title' => $lang['strcomment'],
                'field' => Decorator::field('comment'),
            ],
        ];

        $actions = [];

        echo $this->printTable($parsers, $columns, $actions, 'fulltext-viewparsers', $lang['strftsnoparsers']);

        //TODO: navlink to "create parser"
    }

    /**
     * View list of FTS dictionaries.
     *
     * @param mixed $msg

Missing parameter comment

     */
    public function doViewDicts($msg = '')
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $this->printTrail('schema');
        $this->printTabs('schema', 'fulltext');
        $this->printTabs('fulltext', 'ftsdicts');
        $this->printMsg($msg);

        $dicts = $data->getFtsDictionaries(false);

        $columns = [
            'schema' => [
                'title' => $lang['strschema'],
                'field' => Decorator::field('schema'),
            ],
            'name' => [
                'title' => $lang['strname'],
                'field' => Decorator::field('name'),
            ],
            'actions' => [
                'title' => $lang['stractions'],
            ],
            'comment' => [
                'title' => $lang['strcomment'],
                'field' => Decorator::field('comment'),
            ],
        ];

        $actions = [
            'drop' => [
                'content' => $lang['strdrop'],
                'attr'    => [
                    'href' => [
                        'url'     => 'fulltext.php',
                        'urlvars' => [
                            'action'  => 'dropdict',
                            'ftsdict' => Decorator::field('name'),
                        ],
                    ],
                ],
            ],
            'alter' => [
                'content' => $lang['stralter'],
                'attr'    => [
                    'href' => [
                        'url'     => 'fulltext.php',
                        'urlvars' => [
                            'action'  => 'alterdict',
                            'ftsdict' => Decorator::field('name'),
                        ],
                    ],
                ],
            ],
        ];

        echo $this->printTable($dicts, $columns, $actions, 'fulltext-viewdicts', $lang['strftsnodicts']);

        $navlinks = [
            'createdict' => [
                'attr' => [
                    'href' => [
                        'url'     => 'fulltext.php',
                        'urlvars' => [
                            'action'   => 'createdict',
                            'server'   => $_REQUEST['server'],
                            'database' => $_REQUEST['database'],
                            'schema'   => $_REQUEST['schema'],
                        ],
                    ],
                ],
                'content' => $lang['strftscreatedict'],
            ],
        ];

        $this->printNavLinks($navlinks, 'fulltext-viewdicts', get_defined_vars());
    }

    /**
     * View details of FTS configuration given.
     *
     * @param mixed $ftscfg

Missing parameter comment

     * @param mixed $msg

Missing parameter comment

     */
    public function doViewConfig($ftscfg, $msg = '')
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $this->printTrail('ftscfg');
        $this->printTabs('schema', 'fulltext');
        $this->printTabs('fulltext', 'ftsconfigs');
        $this->printMsg($msg);

        echo "<h3>{$lang['strftsconfigmap']}</h3>\n";

        $map = $data->getFtsConfigurationMap($ftscfg);

        $columns = [
            'name' => [
                'title' => $lang['strftsmapping'],
                'field' => Decorator::field('name'),
            ],
            'dictionaries' => [
                'title' => $lang['strftsdicts'],
                'field' => Decorator::field('dictionaries'),
            ],
            'actions' => [
                'title' => $lang['stractions'],
            ],
            'comment' => [
                'title' => $lang['strcomment'],
                'field' => Decorator::field('description'),
            ],
        ];

        $actions = [
            'drop' => [
                'multiaction' => 'dropmapping',
                'content'     => $lang['strdrop'],
                'attr'        => [
                    'href' => [
                        'url'     => 'fulltext.php',
                        'urlvars' => [
                            'action'  => 'dropmapping',
                            'mapping' => Decorator::field('name'),
                            'ftscfg'  => Decorator::field('cfgname'),
                        ],
                    ],
                ],
            ],
            'alter' => [
                'content' => $lang['stralter'],
                'attr'    => [
                    'href' => [
                        'url'     => 'fulltext.php',
                        'urlvars' => [
                            'action'  => 'altermapping',
                            'mapping' => Decorator::field('name'),
                            'ftscfg'  => Decorator::field('cfgname'),
                        ],
                    ],
                ],
            ],
            'multiactions' => [
                'keycols' => ['mapping' => 'name'],
                'url'     => 'fulltext.php',
                'default' => null,
                'vars'    => ['ftscfg' => $ftscfg],
            ],
        ];

        echo $this->printTable($map, $columns, $actions, 'fulltext-viewconfig', $lang['strftsemptymap']);

        $navlinks = [
            'addmapping' => [
                'attr' => [
                    'href' => [
                        'url'     => 'fulltext.php',
                        'urlvars' => [
                            'action'   => 'addmapping',
                            'server'   => $_REQUEST['server'],
                            'database' => $_REQUEST['database'],
                            'schema'   => $_REQUEST['schema'],
                            'ftscfg'   => $ftscfg,
                        ],
                    ],
                ],
                'content' => $lang['strftsaddmapping'],
            ],
        ];

        $this->printNavLinks($navlinks, 'fulltext-viewconfig', get_defined_vars());
    }

    /**
     * Displays a screen where one can enter a details of a new FTS dictionary.
     *
     * @param mixed $msg

Missing parameter comment

     */
    public function doCreateDict($msg = '')
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $server_info = $this->misc->getServerInfo();

        if (!isset($_POST['formName'])) {
            $_POST['formName'] = '';
        }

        if (!isset($_POST['formIsTemplate'])) {
            $_POST['formIsTemplate'] = false;
        }

        if (!isset($_POST['formTemplate'])) {
            $_POST['formTemplate'] = '';
        }

        if (!isset($_POST['formLexize'])) {
            $_POST['formLexize'] = '';
        }

        if (!isset($_POST['formInit'])) {
            $_POST['formInit'] = '';
        }

        if (!isset($_POST['formOption'])) {
            $_POST['formOption'] = '';
        }

        if (!isset($_POST['formComment'])) {
            $_POST['formComment'] = '';
        }

        // Fetch all FTS dictionaries from the database
        $ftstpls = $data->getFtsDictionaryTemplates();

        $this->printTrail('schema');
        // TODO: create doc links
        $this->printTitle($lang['strftscreatedict'], 'pg.ftsdict.create');
        $this->printMsg($msg);

        echo '<form action="'.\SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n";
        echo "<table>\n";
        echo "\t<tr>\n\t\t<th class=\"data left required\">{$lang['strname']}</th>\n";
        echo "\t\t<td class=\"data1\"><input name=\"formName\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
        htmlspecialchars($_POST['formName']), '" />&nbsp;',
        '<input type="checkbox" name="formIsTemplate" id="formIsTemplate"', $_POST['formIsTemplate'] ? ' checked="checked" ' : '', " />\n",
            "<label for=\"formIsTemplate\">{$lang['strftscreatedicttemplate']}</label></td>\n\t</tr>\n";

        // Template
        echo "\t<tr>\n\t\t<th class=\"data left\">{$lang['strftstemplate']}</th>\n";
        echo "\t\t<td class=\"data1\">";
        $tpls   = [];
        $tplsel = '';
        while (!$ftstpls->EOF) {
            $data->fieldClean($ftstpls->fields['schema']);
            $data->fieldClean($ftstpls->fields['name']);
            $tplname        = $ftstpls->fields['schema'].'.'.$ftstpls->fields['name'];
            $tpls[$tplname] = serialize([
                'name'   => $ftstpls->fields['name'],
                'schema' => $ftstpls->fields['schema'],
            ]);
            if ($_POST['formTemplate'] == $tpls[$tplname]) {
                $tplsel = htmlspecialchars($tpls[$tplname]);
            }
            $ftstpls->moveNext();
        }
        echo \PHPPgAdmin\XHtml\HTMLController::printCombo($tpls, 'formTemplate', true, $tplsel, false);
        echo "\n\t\t</td>\n\t</tr>\n";

        // TODO: what about maxlengths?
        // Lexize
        echo "\t<tr>\n\t\t<th class=\"data left\">{$lang['strftslexize']}</th>\n";
        echo "\t\t<td class=\"data1\"><input name=\"formLexize\" size=\"32\" maxlength=\"1000\" value=\"",
        htmlspecialchars($_POST['formLexize']), '" ', isset($_POST['formIsTemplate']) ? '' : ' disabled="disabled" ',
            "/></td>\n\t</tr>\n";

        // Init
        echo "\t<tr>\n\t\t<th class=\"data left\">{$lang['strftsinit']}</th>\n";
        echo "\t\t<td class=\"data1\"><input name=\"formInit\" size=\"32\" maxlength=\"1000\" value=\"",
        htmlspecialchars($_POST['formInit']), '"', @$_POST['formIsTemplate'] ? '' : ' disabled="disabled" ',
            "/></td>\n\t</tr>\n";

        // Option
        echo "\t<tr>\n\t\t<th class=\"data left\">{$lang['strftsoptionsvalues']}</th>\n";
        echo "\t\t<td class=\"data1\"><input name=\"formOption\" size=\"32\" maxlength=\"1000\" value=\"",
        htmlspecialchars($_POST['formOption']), "\" /></td>\n\t</tr>\n";

        // Comment
        echo "\t<tr>\n\t\t<th class=\"data left\">{$lang['strcomment']}</th>\n";
        echo "\t\t<td class=\"data1\"><textarea name=\"formComment\" rows=\"3\" cols=\"32\">",
        htmlspecialchars($_POST['formComment']), "</textarea></td>\n\t</tr>\n";

        echo "</table>\n";
        echo "<p>\n";
        echo "<input type=\"hidden\" name=\"action\" value=\"createdict\" />\n";
        echo '<input type="hidden" name="database" value="', htmlspecialchars($_REQUEST['database']), "\" />\n";
        echo $this->misc->form;
        echo "<input type=\"submit\" name=\"create\" value=\"{$lang['strcreate']}\" />\n";
        echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" />\n";
        echo "</p>\n";
        echo "</form>\n",
            "<script type=\"text/javascript\">
				function templateOpts() {
					isTpl = document.getElementsByName('formIsTemplate')[0].checked;
					{$this->document}.getElementsByName('formTemplate')[0].disabled = isTpl;
					{$this->document}.getElementsByName('formOption')[0].disabled = isTpl;
					{$this->document}.getElementsByName('formLexize')[0].disabled = !isTpl;
					{$this->document}.getElementsByName('formInit')[0].disabled = !isTpl;
				}

				{$this->document}.getElementsByName('formIsTemplate')[0].onchange = templateOpts;

				templateOpts();
			</script>\n";
    }

    /**
     * Actually creates the new FTS dictionary in the database.
     */
    public function doSaveCreateDict()
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        // Check that they've given a name
        if ('' == $_POST['formName']) {
            $this->doCreateDict($lang['strftsdictneedsname']);
        } else {
            if (!isset($_POST['formIsTemplate'])) {
                $_POST['formIsTemplate'] = false;
            }

            if (isset($_POST['formTemplate'])) {
                $formTemplate = unserialize($_POST['formTemplate']);
            } else {
                $formTemplate = '';
            }

            if (!isset($_POST['formLexize'])) {
                $_POST['formLexize'] = '';
            }

            if (!isset($_POST['formInit'])) {
                $_POST['formInit'] = '';
            }

            if (!isset($_POST['formOption'])) {
                $_POST['formOption'] = '';
            }

            $status = $data->createFtsDictionary(
                $_POST['formName'],
                $_POST['formIsTemplate'],
                $formTemplate,
                $_POST['formLexize'],
                $_POST['formInit'],
                $_POST['formOption'],
                $_POST['formComment']
            );

            if (0 == $status) {
                $this->misc->setReloadBrowser(true);
                $this->doViewDicts($lang['strftsdictcreated']);
            } else {
                $this->doCreateDict($lang['strftsdictcreatedbad']);
            }
        }
    }

    /**
     * Display a form to permit editing FTS dictionary properies.
     *
     * @param mixed $msg

Missing parameter comment

     */
    public function doAlterDict($msg = '')
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $this->printTrail('ftscfg'); // TODO: change to smth related to dictionary
        $this->printTitle($lang['stralter'], 'pg.ftsdict.alter');
        $this->printMsg($msg);

        $ftsdict = $data->getFtsDictionaryByName($_REQUEST['ftsdict']);
        if ($ftsdict->recordCount() > 0) {
            if (!isset($_POST['formComment'])) {
                $_POST['formComment'] = $ftsdict->fields['comment'];
            }

            if (!isset($_POST['ftsdict'])) {
                $_POST['ftsdict'] = $_REQUEST['ftsdict'];
            }

            if (!isset($_POST['formName'])) {
                $_POST['formName'] = $_REQUEST['ftsdict'];
            }

            echo '<form action="'.\SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n";
            echo "<table>\n";

            echo "\t<tr>\n";
            echo "\t\t<th class=\"data left required\">{$lang['strname']}</th>\n";
            echo "\t\t<td class=\"data1\">";
            echo "\t\t\t<input name=\"formName\" size=\"32\" maxlength=\"{$data->_maxNameLen}\" value=\"",
            htmlspecialchars($_POST['formName']), "\" />\n";
            echo "\t\t</td>\n";
            echo "\t</tr>\n";

            // Comment
            echo "\t<tr>\n";
            echo "\t\t<th class=\"data\">{$lang['strcomment']}</th>\n";
            echo "\t\t<td class=\"data1\"><textarea cols=\"32\" rows=\"3\"name=\"formComment\">", htmlspecialchars($_POST['formComment']), "</textarea></td>\n";
            echo "\t</tr>\n";
            echo "</table>\n";
            echo "<p><input type=\"hidden\" name=\"action\" value=\"alterdict\" />\n";
            echo '<input type="hidden" name="ftsdict" value="', htmlspecialchars($_POST['ftsdict']), "\" />\n";
            echo "<input type=\"hidden\" name=\"prev_action\" value=\"viewdicts\" /></p>\n";
            echo $this->misc->form;
            echo "<input type=\"submit\" name=\"alter\" value=\"{$lang['stralter']}\" />\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
            echo "</form>\n";
        } else {
            echo "<p>{$lang['strnodata']}</p>\n";
        }
    }

    /**
     * Save the form submission containing changes to a FTS dictionary.
     */
    public function doSaveAlterDict()
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $status = $data->updateFtsDictionary($_POST['ftsdict'], $_POST['formComment'], $_POST['formName']);
        if (0 == $status) {
            $this->doViewDicts($lang['strftsdictaltered']);
        } else {
            $this->doAlterDict($lang['strftsdictalteredbad']);
        }
    }

    /**
     * Show confirmation of drop and perform actual drop of FTS mapping.
     *
     * @param mixed $confirm

Missing parameter comment

     */
    public function doDropMapping($confirm)
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        if (empty($_REQUEST['mapping']) && empty($_REQUEST['ma'])) {
            $this->doDefault($lang['strftsspecifymappingtodrop']);

            return;
        }

        if (empty($_REQUEST['ftscfg'])) {
            $this->doDefault($lang['strftsspecifyconfigtoalter']);

            return;
        }

        if ($confirm) {
            $this->printTrail('ftscfg'); // TODO: proper breadcrumbs
            $this->printTitle($lang['strdrop'], 'pg.ftscfg.alter');

            echo '<form action="'.\SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n";

            // Case of multiaction drop
            if (isset($_REQUEST['ma'])) {
                foreach ($_REQUEST['ma'] as $v) {
                    $a = unserialize(htmlspecialchars_decode($v, ENT_QUOTES));
                    echo '<p>', sprintf($lang['strconfdropftsmapping'], $this->misc->printVal($a['mapping']), $this->misc->printVal($_REQUEST['ftscfg'])), "</p>\n";
                    printf('<input type="hidden" name="mapping[]" value="%s" />', htmlspecialchars($a['mapping']));
                }
            } else {
                echo '<p>', sprintf($lang['strconfdropftsmapping'], $this->misc->printVal($_REQUEST['mapping']), $this->misc->printVal($_REQUEST['ftscfg'])), "</p>\n";
                echo '<input type="hidden" name="mapping" value="', htmlspecialchars($_REQUEST['mapping']), "\" />\n";
            }

            echo "<input type=\"hidden\" name=\"ftscfg\" value=\"{$_REQUEST['ftscfg']}\" />\n";
            echo "<input type=\"hidden\" name=\"action\" value=\"dropmapping\" />\n";
            echo "<input type=\"hidden\" name=\"prev_action\" value=\"viewconfig\" /></p>\n";
            echo $this->misc->form;
            echo "<input type=\"submit\" name=\"drop\" value=\"{$lang['strdrop']}\" />\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" />\n";
            echo "</form>\n";
        } else {
            // Case of multiaction drop
            if (is_array($_REQUEST['mapping'])) {
                $status = $data->changeFtsMapping($_REQUEST['ftscfg'], $_REQUEST['mapping'], 'drop');
                if (0 != $status) {
                    $this->doViewConfig($_REQUEST['ftscfg'], $lang['strftsmappingdroppedbad']);

                    return;
                }
                $this->doViewConfig($_REQUEST['ftscfg'], $lang['strftsmappingdropped']);
            } else {
                $status = $data->changeFtsMapping($_REQUEST['ftscfg'], [$_REQUEST['mapping']], 'drop');
                if (0 == $status) {
                    $this->doViewConfig($_REQUEST['ftscfg'], $lang['strftsmappingdropped']);
                } else {
                    $this->doViewConfig($_REQUEST['ftscfg'], $lang['strftsmappingdroppedbad']);
                }
            }
        }
    }

    public function doAlterMapping($msg = '')
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();
        $this->printTrail('ftscfg');
        $this->printTitle($lang['stralter'], 'pg.ftscfg.alter');
        $this->printMsg($msg);

        $ftsdicts = $data->getFtsDictionaries();
        if ($ftsdicts->recordCount() > 0) {
            if (!isset($_POST['formMapping'])) {
                $_POST['formMapping'] = @$_REQUEST['mapping'];
            }

            if (!isset($_POST['formDictionary'])) {
                $_POST['formDictionary'] = '';
            }

            if (!isset($_POST['ftscfg'])) {
                $_POST['ftscfg'] = $_REQUEST['ftscfg'];
            }

            echo '<form action="'.\SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n";

            echo "<table>\n";
            echo "\t<tr>\n";
            echo "\t\t<th class=\"data left required\">{$lang['strftsmapping']}</th>\n";
            echo "\t\t<td class=\"data1\">";

            // Case of multiaction drop
            if (isset($_REQUEST['ma'])) {
                $ma_mappings       = [];
                $ma_mappings_names = [];
                foreach ($_REQUEST['ma'] as $v) {
                    $a = unserialize(htmlspecialchars_decode($v, ENT_QUOTES));
                    printf('<input type="hidden" name="formMapping[]" value="%s" />', htmlspecialchars($a['mapping']));
                    $ma_mappings[]       = $data->getFtsMappingByName($_POST['ftscfg'], $a['mapping']);
                    $ma_mappings_names[] = $a['mapping'];
                }
                echo implode(', ', $ma_mappings_names);
            } else {
                $mapping = $data->getFtsMappingByName($_POST['ftscfg'], $_POST['formMapping']);
                echo $mapping->fields['name'];
                echo '<input type="hidden" name="formMapping" value="', htmlspecialchars($_POST['formMapping']), "\" />\n";
            }

            echo "\t\t</td>\n";
            echo "\t</tr>\n";

            // Dictionary
            echo "\t<tr>\n";
            echo "\t\t<th class=\"data left required\">{$lang['strftsdict']}</th>\n";
            echo "\t\t<td class=\"data1\">";
            echo "\t\t\t<select name=\"formDictionary\">\n";
            while (!$ftsdicts->EOF) {
                $ftsdict = htmlspecialchars($ftsdicts->fields['name']);
                echo "\t\t\t\t<option value=\"{$ftsdict}\"",
                ($ftsdict == $_POST['formDictionary'] || $ftsdict == @$mapping->fields['dictionaries'] || $ftsdict == @$ma_mappings[0]->fields['dictionaries']) ? ' selected="selected"' : '', ">{$ftsdict}</option>\n";
                $ftsdicts->moveNext();
            }

            echo "\t\t</td>\n";
            echo "\t</tr>\n";

            echo "</table>\n";
            echo "<p><input type=\"hidden\" name=\"action\" value=\"altermapping\" />\n";
            echo '<input type="hidden" name="ftscfg" value="', htmlspecialchars($_POST['ftscfg']), "\" />\n";
            echo "<input type=\"hidden\" name=\"prev_action\" value=\"viewconfig\" /></p>\n";

            echo $this->misc->form;
            echo "<input type=\"submit\" name=\"alter\" value=\"{$lang['stralter']}\" />\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
            echo "</form>\n";
        } else {
            echo "<p>{$lang['strftsnodictionaries']}</p>\n";
        }
    }

    /**
     * Save the form submission containing changes to a FTS mapping.
     */
    public function doSaveAlterMapping()
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $mappingArray = (is_array($_POST['formMapping']) ? $_POST['formMapping'] : [$_POST['formMapping']]);
        $status       = $data->changeFtsMapping($_POST['ftscfg'], $mappingArray, 'alter', $_POST['formDictionary']);
        if (0 == $status) {
            $this->doViewConfig($_POST['ftscfg'], $lang['strftsmappingaltered']);
        } else {
            $this->doAlterMapping($lang['strftsmappingalteredbad']);
        }
    }

    /**
     * Show the form to enter parameters of a new FTS mapping.
     *
     * @param mixed $msg

Missing parameter comment

     */
    public function doAddMapping($msg = '')
    {
        $conf = $this->conf;

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

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

        $ftsdicts = $data->getFtsDictionaries();
        if ($ftsdicts->recordCount() > 0) {
            if (!isset($_POST['formMapping'])) {
                $_POST['formMapping'] = '';
            }

            if (!isset($_POST['formDictionary'])) {
                $_POST['formDictionary'] = '';
            }

            if (!isset($_POST['ftscfg'])) {
                $_POST['ftscfg'] = $_REQUEST['ftscfg'];
            }

            $mappings = $data->getFtsMappings($_POST['ftscfg']);

            echo '<form action="'.\SUBFOLDER."/src/views/fulltext.php\" method=\"post\">\n";
            echo "<table>\n";
            echo "\t<tr>\n";
            echo "\t\t<th class=\"data left required\">{$lang['strftsmapping']}</th>\n";
            echo "\t\t<td class=\"data1\">";
            echo "\t\t\t<select name=\"formMapping\">\n";
            while (!$mappings->EOF) {
                $mapping      = htmlspecialchars($mappings->fields['name']);
                $mapping_desc = htmlspecialchars($mappings->fields['description']);
                echo "\t\t\t\t<option value=\"{$mapping}\"",
                $mapping == $_POST['formMapping'] ? ' selected="selected"' : '', ">{$mapping}", $mapping_desc ? " - {$mapping_desc}" : '', "</option>\n";
                $mappings->moveNext();
            }
            echo "\t\t</td>\n";
            echo "\t</tr>\n";

            // Dictionary
            echo "\t<tr>\n";
            echo "\t\t<th class=\"data left required\">{$lang['strftsdict']}</th>\n";
            echo "\t\t<td class=\"data1\">";
            echo "\t\t\t<select name=\"formDictionary\">\n";
            while (!$ftsdicts->EOF) {
                $ftsdict = htmlspecialchars($ftsdicts->fields['name']);
                echo "\t\t\t\t<option value=\"{$ftsdict}\"",
                $ftsdict == $_POST['formDictionary'] ? ' selected="selected"' : '', ">{$ftsdict}</option>\n";
                $ftsdicts->moveNext();
            }

            echo "\t\t</td>\n";
            echo "\t</tr>\n";

            echo "</table>\n";
            echo "<p><input type=\"hidden\" name=\"action\" value=\"addmapping\" />\n";
            echo '<input type="hidden" name="ftscfg" value="', htmlspecialchars($_POST['ftscfg']), "\" />\n";
            echo "<input type=\"hidden\" name=\"prev_action\" value=\"viewconfig\" /></p>\n";
            echo $this->misc->form;
            echo "<input type=\"submit\" name=\"add\" value=\"{$lang['stradd']}\" />\n";
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$lang['strcancel']}\" /></p>\n";
            echo "</form>\n";
        } else {
            echo "<p>{$lang['strftsnodictionaries']}</p>\n";
        }
    }

    /**
     * Save the form submission containing parameters of a new FTS mapping.
     */
    public function doSaveAddMapping()
    {
        $conf = $this->conf;

The assignment to $conf is dead and can be removed.

        $lang = $this->lang;
        $data = $this->misc->getDatabaseAccessor();

        $mappingArray = (is_array($_POST['formMapping']) ? $_POST['formMapping'] : [$_POST['formMapping']]);
        $status       = $data->changeFtsMapping($_POST['ftscfg'], $mappingArray, 'add', $_POST['formDictionary']);
        if (0 == $status) {
            $this->doViewConfig($_POST['ftscfg'], $lang['strftsmappingadded']);
        } else {
            $this->doAddMapping($lang['strftsmappingaddedbad']);
        }
    }
}