PHPPgAdmin\Controller\DisplayController::doBrowse()

Complexity

Conditions	16
Paths	90

Size

Total Lines	144
Code Lines	88

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

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

        // If current page is not set, default to first page
        $page = $this->coalesceArr($_REQUEST, 'page', 1)['page'];

        $save_history = !isset($_REQUEST['nohistory']);

        $subject = $this->coalesceArr($_REQUEST, 'subject', 'table')['subject'];

        $object = $this->coalesceArr($_REQUEST, $subject)[$subject];

        if ('column' === $subject && $object && isset($_REQUEST['f_schema'], $_REQUEST['f_table'])) {
            $f_schema = $_REQUEST['f_schema'];
            $f_table  = $_REQUEST['f_table'];

            $_REQUEST['query'] = "SELECT \"{$object}\",
            count(*) AS \"count\"
            FROM \"{$f_schema}\".\"{$f_table}\"
            GROUP BY \"{$object}\" ORDER BY \"{$object}\"";
        } elseif ('table' === $subject && !isset($_REQUEST['query'])) {
            $show   = $this->getPostParam('show', []);
            $values = $this->getPostParam('values', []);
            $ops    = $this->getPostParam('ops', []);
            $query  = $data->getSelectSQL(
                $_REQUEST['table'],
                \array_keys($show),
                $values,
                $ops
            );
            $_REQUEST['query']  = $query;
            $_REQUEST['return'] = 'selectrows';
            $this->prtrace($query);
        }

        //$object = $this->setIfIsset($object, $_REQUEST[$subject]);

        $this->printTrail($subject);

        $tabsPosition = 'browse';

        if ('database' === $subject) {
            $tabsPosition = 'sql';
        } elseif ('column' === $subject) {
            $tabsPosition = 'colproperties';
        }

        $this->printTabs($subject, $tabsPosition);

        [$query, $title, $type] = $this->getQueryTitleAndType($data, $object);
        $this->prtrace($query);

        $this->printTitle($this->lang[$title]);

        $this->printMsg($msg);

        // If 'sortkey' is not set, default to ''
        $sortkey = $this->coalesceArr($_REQUEST, 'sortkey', '')['sortkey'];

        // If 'sortdir' is not set, default to ''
        $sortdir = $this->coalesceArr($_REQUEST, 'sortdir', '')['sortdir'];

        // If 'strings' is not set, default to collapsed
        $strings = $this->coalesceArr($_REQUEST, 'strings', 'collapsed')['strings'];

        $this->coalesceArr($_REQUEST, 'schema')['schema'];
        $search_path = $this->coalesceArr($_REQUEST, 'search_path')['search_path'];

        // Set the schema search path
        if (isset($search_path) && (0 !== $data->setSearchPath(\array_map('trim', \explode(',', $search_path))))) {
            return;
        }

        try {
            // Retrieve page from query.  $max_pages is returned by reference.
            $resultset = $data->browseQuery(
                $type,
                $object,
                $query,
                $sortkey,
                $sortdir,
                $page,
                $this->conf['max_rows'],
                $max_pages
            );
        } catch (\PHPPgAdmin\ADOdbException $e) {
            return $this->halt($e->getMessage());
        }

        // Build strings for GETs in array
        $_gets = [
            'server'   => $_REQUEST['server'],
            'database' => $_REQUEST['database'],
        ];

        $this->coalesceArr($_REQUEST, 'query');
        $this->coalesceArr($_REQUEST, 'count');
        $this->coalesceArr($_REQUEST, 'return');
        $this->coalesceArr($_REQUEST, 'table');
        $this->coalesceArr($_REQUEST, 'nohistory');

        $this->setIfIsset($_gets['schema'], $_REQUEST['schema'], null, false);
        $this->setIfIsset($_gets[$subject], $object, null, false);
        $this->setIfIsset($_gets['subject'], $subject, null, false);
        $this->setIfIsset($_gets['query'], $_REQUEST['query'], null, false);
        $this->setIfIsset($_gets['count'], $_REQUEST['count'], null, false);
        $this->setIfIsset($_gets['return'], $_REQUEST['return'], null, false);
        $this->setIfIsset($_gets['search_path'], $_REQUEST['search_path'], null, false);
        $this->setIfIsset($_gets['table'], $_REQUEST['table'], null, false);
        $this->setIfIsset($_gets['nohistory'], $_REQUEST['nohistory'], null, false);
        $_gets['sortkey'] = $sortkey;
        $_gets['sortdir'] = $sortdir;
        $_gets['strings'] = $strings;

        if ($save_history && \is_object($resultset) && ('QUERY' === $type)) {
            //{
            $this->misc->saveScriptHistory($_REQUEST['query']);
        }

        $query = $query ? $query : \sprintf('SELECT * FROM %s.%s', $_REQUEST['schema'], $object);

        //$query = isset($_REQUEST['query'])? $_REQUEST['query'] : "select * from {$_REQUEST['schema']}.{$_REQUEST['table']};";

        //die(htmlspecialchars($query));

        echo '<form method="post" id="sqlform" action="' . $_SERVER['REQUEST_URI'] . '">';
        echo $this->misc->form;

        if ($object) {
            echo '<input type="hidden" name="' . $subject . '" value="', \htmlspecialchars($object), '" />' . \PHP_EOL;
        }
        echo '<textarea width="90%" name="query"  id="query" rows="5" cols="100" resizable="true">';
        echo \htmlspecialchars($query);
        echo '</textarea><br><input type="submit"/>';

        echo '</form>';

        $this->printResultsTable($resultset, $page, $max_pages, $_gets, $object);
        // Navigation links

        $navlinks = $this->getBrowseNavLinks($type, $_gets, $page, $subject, $object, $resultset);
        $this->printNavLinks($navlinks, 'display-browse', \get_defined_vars());
    }