HuasoFoundries / phpPgAdmin6

src/controllers/FulltextController.php

<?php

/**
 * PHPPgAdmin 6.1.3
 */

namespace PHPPgAdmin\Controller;

use PHPPgAdmin\Decorators\Decorator;

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

    /**
     * Default method to render the controller according to the action parameter.
     */
    public function render()
    {
        if ('tree' === $this->action) {
            return $this->doTree();
        }

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

        $this->printHeader();
        $this->printBody();

        if (null !== $this->getPostParam('cancel')) {
            if (isset($_POST['prev_action'])) {
                $this->action = $_POST['prev_action'];
            } else {
                $this->action = '';
            }
        }

        switch ($this->action) {
            case 'createconfig':
                if (null !== $this->getPostParam('create')) {
                    $this->doSaveCreateConfig();
                } else {
                    $this->doCreateConfig();
                }

                break;
            case 'alterconfig':
                if (null !== $this->getPostParam('alter')) {
                    $this->doSaveAlterConfig();
                } else {
                    $this->doAlterConfig();
                }

                break;
            case 'dropconfig':
                if (null !== $this->getPostParam('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 (null !== $this->getPostParam('create')) {
                    $this->doSaveCreateDict();
                } else {
                    $this->doCreateDict();
                }

                break;
            case 'alterdict':
                if (null !== $this->getPostParam('alter')) {
                    $this->doSaveAlterDict();
                } else {
                    $this->doAlterDict();
                }

                break;
            case 'dropdict':
                if (null !== $this->getPostParam('drop')) {
                    $this->doDropDict(false);
                } else {
                    $this->doDropDict(true);
                }

                break;
            case 'dropmapping':
                if (null !== $this->getPostParam('drop')) {
                    $this->doDropMapping(false);
                } else {
                    $this->doDropMapping(true);
                }

                break;
            case 'altermapping':
                if (null !== $this->getPostParam('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 = ''): void
    {
        $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' => $this->lang['strftsconfig'],
                'field' => Decorator::field('name'),
                'url' => "fulltext?action=viewconfig&amp;{$this->misc->href}&amp;",
                'vars' => ['ftscfg' => 'name'],
            ],
            'schema' => [
                'title' => $this->lang['strschema'],
                'field' => Decorator::field('schema'),
            ],
            'actions' => [
                'title' => $this->lang['stractions'],
            ],
            'comment' => [
                'title' => $this->lang['strcomment'],
                'field' => Decorator::field('comment'),
            ],
        ];

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

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

It seems like $cfgs can also be of type integer; however, parameter $tabledata of PHPPgAdmin\Controller\BaseController::printTable() does only seem to accept ADORecordSet|PHPPgAdmin\ArrayRecordSet, maybe add an additional type check?

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

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

    /**
     * Generate XML for the browser tree.
     */
    public function doTree()
    {
        $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',
                $reqvars,
                Decorator::field('urlvars')
            ),
            'branch' => Decorator::url(
                'fulltext',
                $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)
    {
        $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',
                $reqvars,
                $urlvars
            ),
            'branch' => Decorator::ifempty(
                Decorator::field('branch'),
                '',
                Decorator::url(
                    'fulltext',
                    $reqvars,
                    [
                        'action' => 'subtree',
                        'ftscfg' => Decorator::field('name'),
                    ]
                )
            ),
        ];

        return $this->printTree($items, $attrs, \mb_strtolower($what));

It seems like $items can also be of type integer; however, parameter $_treedata of PHPPgAdmin\Controller\BaseController::printTree() does only seem to accept PHPPgAdmin\ADORecordSet|PHPPgAdmin\ArrayRecordSet, maybe add an additional type check?

    }

    public function doDropConfig(bool $confirm): void
    {
        $data = $this->misc->getDatabaseAccessor();

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

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

            echo '<form action="' . \containerInstance()->subFolder . '/src/views/fulltext" method="post">' . \PHP_EOL;
            echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$this->lang['strcascade']}</label></p>" . \PHP_EOL;
            echo '<p><input type="hidden" name="action" value="dropconfig" />' . \PHP_EOL;
            echo '<input type="hidden" name="database" value="', \htmlspecialchars($_REQUEST['database']), '" />' . \PHP_EOL;
            echo '<input type="hidden" name="ftscfg" value="', \htmlspecialchars($_REQUEST['ftscfg']), '" />' . \PHP_EOL;
            echo $this->view->form;
            echo "<input type=\"submit\" name=\"drop\" value=\"{$this->lang['strdrop']}\" />" . \PHP_EOL;
            echo \sprintf('<input type="submit" name="cancel" value="%s"  /></p>%s', $this->lang['strcancel'], \PHP_EOL);
            echo '</form>' . \PHP_EOL;
        } else {
            $status = $data->dropFtsConfiguration($_POST['ftscfg'], isset($_POST['cascade']));

            if (0 === $status) {
                $this->view->setReloadBrowser(true);
                $this->doDefault($this->lang['strftsconfigdropped']);
            } else {
                $this->doDefault($this->lang['strftsconfigdroppedbad']);
            }
        }
    }

    public function doDropDict(bool $confirm): void
    {
        $data = $this->misc->getDatabaseAccessor();

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

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

            echo '<form action="' . \containerInstance()->subFolder . '/src/views/fulltext" method="post">' . \PHP_EOL;
            echo "<p><input type=\"checkbox\" id=\"cascade\" name=\"cascade\" /> <label for=\"cascade\">{$this->lang['strcascade']}</label></p>" . \PHP_EOL;
            echo '<p><input type="hidden" name="action" value="dropdict" />' . \PHP_EOL;
            echo '<input type="hidden" name="database" value="', \htmlspecialchars($_REQUEST['database']), '" />' . \PHP_EOL;
            echo '<input type="hidden" name="ftsdict" value="', \htmlspecialchars($_REQUEST['ftsdict']), '" />' . \PHP_EOL;
            //echo "<input type=\"hidden\" name=\"ftscfg\" value=\"", htmlspecialchars($_REQUEST['ftscfg']), "\" />".PHP_EOL;
            echo '<input type="hidden" name="prev_action" value="viewdicts" /></p>' . \PHP_EOL;
            echo $this->view->form;
            echo "<input type=\"submit\" name=\"drop\" value=\"{$this->lang['strdrop']}\" />" . \PHP_EOL;
            echo \sprintf('<input type="submit" name="cancel" value="%s"  /></p>%s', $this->lang['strcancel'], \PHP_EOL);
            echo '</form>' . \PHP_EOL;
        } else {
            $status = $data->dropFtsDictionary($_POST['ftsdict'], isset($_POST['cascade']));

            if (0 === $status) {
                $this->view->setReloadBrowser(true);
                $this->doViewDicts($this->lang['strftsdictdropped']);
            } else {
                $this->doViewDicts($this->lang['strftsdictdroppedbad']);
            }
        }
    }

    /**
     * Displays a screen where one can enter a new FTS configuration.
     *
     * @param mixed $msg
     */
    public function doCreateConfig($msg = ''): void
    {
        $data = $this->misc->getDatabaseAccessor();

        $this->coalesceArr($_POST, 'formName', '');

        $this->coalesceArr($_POST, 'formParser', '');

        $this->coalesceArr($_POST, 'formTemplate', '');

        $this->coalesceArr($_POST, 'formWithMap', '');

        $this->coalesceArr($_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($this->lang['strftscreateconfig'], 'pg.ftscfg.create');
        $this->printMsg($msg);

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

        // Template
        echo "\t<tr>\n\t\t<th class=\"data left\">{$this->lang['strftstemplate']}</th>" . \PHP_EOL;
        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>" . \PHP_EOL;

        // Parser
        echo "\t<tr>\n\t\t<th class=\"data left\">{$this->lang['strftsparser']}</th>" . \PHP_EOL;
        echo "\t\t<td class=\"data1\">" . \PHP_EOL;
        $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>" . \PHP_EOL;

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

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

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

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

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

        if ('' !== $err) {
            return $this->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->view->setReloadBrowser(true);
            $this->doDefault($this->lang['strftsconfigcreated']);
        } else {
            $this->doCreateConfig($this->lang['strftsconfigcreatedbad']);
        }
    }

    /**
     * Display a form to permit editing FTS configuration properies.
     *
     * @param mixed $msg
     */
    public function doAlterConfig($msg = ''): void
    {
        $data = $this->misc->getDatabaseAccessor();

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

        $ftscfg = $data->getFtsConfigurationByName($_REQUEST['ftscfg']);

        if (0 < $ftscfg->recordCount()) {
            $this->coalesceArr($_POST, 'formComment', $ftscfg->fields['comment']);

            $this->coalesceArr($_POST, 'ftscfg', $_REQUEST['ftscfg']);

            $this->coalesceArr($_POST, 'formName', $_REQUEST['ftscfg']);

            $this->coalesceArr($_POST, 'formParser', '');

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

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

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

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

    /**
     * Save the form submission containing changes to a FTS configuration.
     */
    public function doSaveAlterConfig(): void
    {
        $data = $this->misc->getDatabaseAccessor();
        $status = $data->updateFtsConfiguration($_POST['ftscfg'], $_POST['formComment'], $_POST['formName']);

        if (0 === $status) {
            $this->doDefault($this->lang['strftsconfigaltered']);
        } else {
            $this->doAlterConfig($this->lang['strftsconfigalteredbad']);
        }
    }

    /**
     * View list of FTS parsers.
     *
     * @param mixed $msg
     */
    public function doViewParsers($msg = ''): void
    {
        $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' => $this->lang['strschema'],
                'field' => Decorator::field('schema'),
            ],
            'name' => [
                'title' => $this->lang['strname'],
                'field' => Decorator::field('name'),
            ],
            'comment' => [
                'title' => $this->lang['strcomment'],
                'field' => Decorator::field('comment'),
            ],
        ];

        $actions = [];

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

It seems like $parsers can also be of type integer; however, parameter $tabledata of PHPPgAdmin\Controller\BaseController::printTable() does only seem to accept ADORecordSet|PHPPgAdmin\ArrayRecordSet, maybe add an additional type check?

        //TODO: navlink to "create parser"
    }

    /**
     * View list of FTS dictionaries.
     *
     * @param mixed $msg
     */
    public function doViewDicts($msg = ''): void
    {
        $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' => $this->lang['strschema'],
                'field' => Decorator::field('schema'),
            ],
            'name' => [
                'title' => $this->lang['strname'],
                'field' => Decorator::field('name'),
            ],
            'actions' => [
                'title' => $this->lang['stractions'],
            ],
            'comment' => [
                'title' => $this->lang['strcomment'],
                'field' => Decorator::field('comment'),
            ],
        ];

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

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

It seems like $dicts can also be of type integer; however, parameter $tabledata of PHPPgAdmin\Controller\BaseController::printTable() does only seem to accept ADORecordSet|PHPPgAdmin\ArrayRecordSet, maybe add an additional type check?

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

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

    /**
     * View details of FTS configuration given.
     *
     * @param mixed $ftscfg
     * @param mixed $msg
     */
    public function doViewConfig($ftscfg, $msg = ''): void
    {
        $data = $this->misc->getDatabaseAccessor();

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

        echo "<h3>{$this->lang['strftsconfigmap']}</h3>" . \PHP_EOL;

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

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

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

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

It seems like $map can also be of type integer; however, parameter $tabledata of PHPPgAdmin\Controller\BaseController::printTable() does only seem to accept ADORecordSet|PHPPgAdmin\ArrayRecordSet, maybe add an additional type check?

        $navlinks = [
            'addmapping' => [
                'attr' => [
                    'href' => [
                        'url' => 'fulltext',
                        'urlvars' => [
                            'action' => 'addmapping',
                            'server' => $_REQUEST['server'],
                            'database' => $_REQUEST['database'],
                            'schema' => $_REQUEST['schema'],
                            'ftscfg' => $ftscfg,
                        ],
                    ],
                ],
                'content' => $this->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
     */
    public function doCreateDict($msg = ''): void
    {
        $data = $this->misc->getDatabaseAccessor();

        $this->coalesceArr($_POST, 'formName', '');

        $this->coalesceArr($_POST, 'formIsTemplate', false);

        $this->coalesceArr($_POST, 'formTemplate', '');

        $this->coalesceArr($_POST, 'formLexize', '');

        $this->coalesceArr($_POST, 'formInit', '');

        $this->coalesceArr($_POST, 'formOption', '');

        $this->coalesceArr($_POST, 'formComment', '');

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

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

        echo '<form action="' . \containerInstance()->subFolder . '/src/views/fulltext" 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=\"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\">{$this->lang['strftscreatedicttemplate']}</label></td>\n\t</tr>" . \PHP_EOL;

        // Template
        echo "\t<tr>\n\t\t<th class=\"data left\">{$this->lang['strftstemplate']}</th>" . \PHP_EOL;
        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>" . \PHP_EOL;

        // TODO: what about maxlengths?
        // Lexize
        echo "\t<tr>\n\t\t<th class=\"data left\">{$this->lang['strftslexize']}</th>" . \PHP_EOL;
        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>" . \PHP_EOL;

        // Init
        echo "\t<tr>\n\t\t<th class=\"data left\">{$this->lang['strftsinit']}</th>" . \PHP_EOL;
        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>" . \PHP_EOL;

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

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

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

				document.getElementsByName('formIsTemplate')[0].onchange = templateOpts;

				templateOpts();
			</script>" . \PHP_EOL;
    }

    /**
     * Actually creates the new FTS dictionary in the database.
     */
    public function doSaveCreateDict(): void
    {
        $data = $this->misc->getDatabaseAccessor();

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

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

            $this->coalesceArr($_POST, 'formLexize', '');

            $this->coalesceArr($_POST, 'formInit', '');

            $this->coalesceArr($_POST, 'formOption', '');

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

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

    /**
     * Display a form to permit editing FTS dictionary properies.
     *
     * @param mixed $msg
     */
    public function doAlterDict($msg = ''): void
    {
        $data = $this->misc->getDatabaseAccessor();

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

        $ftsdict = $data->getFtsDictionaryByName($_REQUEST['ftsdict']);

        if (0 < $ftsdict->recordCount()) {
            $this->coalesceArr($_POST, 'formComment', $ftsdict->fields['comment']);

            $this->coalesceArr($_POST, 'ftsdict', $_REQUEST['ftsdict']);

            $this->coalesceArr($_POST, 'formName', $_REQUEST['ftsdict']);

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

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

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

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

        $status = $data->updateFtsDictionary($_POST['ftsdict'], $_POST['formComment'], $_POST['formName']);

        if (0 === $status) {
            $this->doViewDicts($this->lang['strftsdictaltered']);
        } else {
            $this->doAlterDict($this->lang['strftsdictalteredbad']);
        }
    }

    /**
     * Show confirmation of drop and perform actual drop of FTS mapping.
     *
     * @param mixed $confirm
     */
    public function doDropMapping($confirm): void
    {
        $data = $this->misc->getDatabaseAccessor();

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

            return;
        }

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

            return;
        }

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

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

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

            echo "<input type=\"hidden\" name=\"ftscfg\" value=\"{$_REQUEST['ftscfg']}\" />" . \PHP_EOL;
            echo '<input type="hidden" name="action" value="dropmapping" />' . \PHP_EOL;
            echo '<input type="hidden" name="prev_action" value="viewconfig" /></p>' . \PHP_EOL;
            echo $this->view->form;
            echo "<input type=\"submit\" name=\"drop\" value=\"{$this->lang['strdrop']}\" />" . \PHP_EOL;
            echo "<input type=\"submit\" name=\"cancel\" value=\"{$this->lang['strcancel']}\" />" . \PHP_EOL;
            echo '</form>' . \PHP_EOL;
        } 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'], $this->lang['strftsmappingdroppedbad']);

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

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

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

        $ftsdicts = $data->getFtsDictionaries();

        if (0 < $ftsdicts->recordCount()) {
            $this->coalesceArr($_POST, 'formMapping', $_REQUEST['mapping']);

            $this->coalesceArr($_POST, 'formDictionary', '');

            $this->coalesceArr($_POST, 'ftscfg', $_REQUEST['ftscfg']);

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

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

            $ma_mappings = [];
            // Case of multiaction drop
            if (isset($_REQUEST['ma'])) {
                $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']), '" />' . \PHP_EOL;
            }

            echo "\t\t</td>" . \PHP_EOL;
            echo "\t</tr>" . \PHP_EOL;

            // Dictionary
            echo "\t<tr>" . \PHP_EOL;
            echo "\t\t<th class=\"data left required\">{$this->lang['strftsdict']}</th>" . \PHP_EOL;
            echo "\t\t<td class=\"data1\">";
            echo "\t\t\t<select name=\"formDictionary\">" . \PHP_EOL;

            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>" . \PHP_EOL;
                $ftsdicts->moveNext();
            }

            echo "\t\t</td>" . \PHP_EOL;
            echo "\t</tr>" . \PHP_EOL;

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

            echo $this->view->form;
            echo "<input type=\"submit\" name=\"alter\" value=\"{$this->lang['stralter']}\" />" . \PHP_EOL;
            echo \sprintf('<input type="submit" name="cancel" value="%s"  /></p>%s', $this->lang['strcancel'], \PHP_EOL);
            echo '</form>' . \PHP_EOL;
        } else {
            echo "<p>{$this->lang['strftsnodictionaries']}</p>" . \PHP_EOL;
        }
    }

    /**
     * Save the form submission containing changes to a FTS mapping.
     */
    public function doSaveAlterMapping(): void
    {
        $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'], $this->lang['strftsmappingaltered']);
        } else {
            $this->doAlterMapping($this->lang['strftsmappingalteredbad']);
        }
    }

    /**
     * Show the form to enter parameters of a new FTS mapping.
     *
     * @param mixed $msg
     */
    public function doAddMapping($msg = ''): void
    {
        $data = $this->misc->getDatabaseAccessor();

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

        $ftsdicts = $data->getFtsDictionaries();

        if (0 < $ftsdicts->recordCount()) {
            $this->coalesceArr($_POST, 'formMapping', '');

            $this->coalesceArr($_POST, 'formDictionary', '');

            $this->coalesceArr($_POST, 'ftscfg', $_REQUEST['ftscfg']);

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

            echo '<form action="' . \containerInstance()->subFolder . '/src/views/fulltext" method="post">' . \PHP_EOL;
            echo '<table>' . \PHP_EOL;
            echo "\t<tr>" . \PHP_EOL;
            echo "\t\t<th class=\"data left required\">{$this->lang['strftsmapping']}</th>" . \PHP_EOL;
            echo "\t\t<td class=\"data1\">";
            echo "\t\t\t<select name=\"formMapping\">" . \PHP_EOL;

            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>' . \PHP_EOL;
                $mappings->moveNext();
            }
            echo "\t\t</td>" . \PHP_EOL;
            echo "\t</tr>" . \PHP_EOL;

            // Dictionary
            echo "\t<tr>" . \PHP_EOL;
            echo "\t\t<th class=\"data left required\">{$this->lang['strftsdict']}</th>" . \PHP_EOL;
            echo "\t\t<td class=\"data1\">";
            echo "\t\t\t<select name=\"formDictionary\">" . \PHP_EOL;

            while (!$ftsdicts->EOF) {
                $ftsdict = \htmlspecialchars($ftsdicts->fields['name']);
                echo "\t\t\t\t<option value=\"{$ftsdict}\"",
                $ftsdict === $_POST['formDictionary'] ? ' selected="selected"' : '', ">{$ftsdict}</option>" . \PHP_EOL;
                $ftsdicts->moveNext();
            }

            echo "\t\t</td>" . \PHP_EOL;
            echo "\t</tr>" . \PHP_EOL;

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

    /**
     * Save the form submission containing parameters of a new FTS mapping.
     */
    public function doSaveAddMapping(): void
    {
        $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'], $this->lang['strftsmappingadded']);
        } else {
            $this->doAddMapping($this->lang['strftsmappingaddedbad']);
        }
    }
}