PHP PMA_Util::getListNavigator方法代码示例

/**
 * Returns the html for Database List
 *
 * @param Array  $databases         GBI return databases
 * @param int    $databases_count   database count
 * @param int    $pos               display pos
 * @param Array  $dbstats           database status
 * @param string $sort_by           sort by string
 * @param string $sort_order        sort order string
 * @param bool   $is_superuser      User status
 * @param Array  $cfg               configuration
 * @param string $replication_types replication types
 * @param string $replication_info  replication info
 * @param string $url_query         url query
 *
 * @return string
 */
function PMA_getHtmlForDatabase($databases, $databases_count, $pos, $dbstats, $sort_by, $sort_order, $is_superuser, $cfg, $replication_types, $replication_info, $url_query)
{
    $html = '<div id="tableslistcontainer">';
    reset($databases);
    $first_database = current($databases);
    // table col order
    $column_order = PMA_getColumnOrder();
    $_url_params = array('pos' => $pos, 'dbstats' => $dbstats, 'sort_by' => $sort_by, 'sort_order' => $sort_order);
    $html .= PMA_Util::getListNavigator($databases_count, $pos, $_url_params, 'server_databases.php', 'frame_content', $GLOBALS['cfg']['MaxDbList']);
    $_url_params['pos'] = $pos;
    $html .= '<form class="ajax" action="server_databases.php" ';
    $html .= 'method="post" name="dbStatsForm" id="dbStatsForm">' . "\n";
    $html .= PMA_URL_getHiddenInputs($_url_params);
    $_url_params['sort_by'] = 'SCHEMA_NAME';
    $_url_params['sort_order'] = $sort_by == 'SCHEMA_NAME' && $sort_order == 'asc' ? 'desc' : 'asc';
    $html .= '<table id="tabledatabases" class="data">' . "\n" . '<thead>' . "\n" . '<tr>' . "\n";
    $html .= PMA_getHtmlForColumnOrderWithSort($is_superuser, $cfg['AllowUserDropDatabase'], $_url_params, $sort_by, $sort_order, $column_order, $first_database);
    $html .= PMA_getHtmlForReplicationType($is_superuser, $replication_types, $cfg['ActionLinksMode']);
    $html .= '</tr>' . "\n" . '</thead>' . "\n";
    list($output, $column_order) = PMA_getHtmlAndColumnOrderForDatabaseList($databases, $is_superuser, $url_query, $column_order, $replication_types, $replication_info);
    $html .= $output;
    unset($output);
    $html .= PMA_getHtmlForTableFooter($cfg['AllowUserDropDatabase'], $is_superuser, $databases_count, $column_order, $replication_types, $first_database);
    $html .= '</table>' . "\n";
    $html .= PMA_getHtmlForTableFooterButtons($cfg['AllowUserDropDatabase'], $is_superuser, $sort_by, $sort_order, $dbstats);
    if (empty($dbstats)) {
        //we should put notice above database list
        $html = PMA_getHtmlForNoticeEnableStatistics($url_query, $html);
    }
    $html .= '</form>';
    $html .= '</div>';
    return $html;
}

 /**
  * Generates the HTML code for displaying the list pagination
  *
  * @param Node $node The node for whose children the page
  *                   selector will be created
  *
  * @return string
  */
 private function _getPageSelector($node)
 {
     $retval = '';
     if ($node === $this->_tree) {
         $retval .= PMA_Util::getListNavigator($this->_tree->getPresence('databases', $this->_searchClause), $this->_pos, array('server' => $GLOBALS['server']), 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['FirstLevelNavigationItems'], 'pos', array('dbselector'));
     } else {
         if ($node->type == Node::CONTAINER && !$node->is_group) {
             $paths = $node->getPaths();
             $level = isset($paths['aPath_clean'][4]) ? 3 : 2;
             $_url_params = array('aPath' => $paths['aPath'], 'vPath' => $paths['vPath'], 'pos' => $this->_pos, 'server' => $GLOBALS['server'], 'pos2_name' => $paths['aPath_clean'][2]);
             if ($level == 3) {
                 $pos = $node->pos3;
                 $_url_params['pos2_value'] = $node->pos2;
                 $_url_params['pos3_name'] = $paths['aPath_clean'][4];
             } else {
                 $pos = $node->pos2;
             }
             $num = $node->realParent()->getPresence($node->real_name, $this->_searchClause2);
             $retval .= PMA_Util::getListNavigator($num, $pos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxNavigationItems'], 'pos' . $level . '_value');
         }
     }
     return $retval;
 }

    }
    list($do, $ignored) = PMA_getServerSlaveStatus($server_slave_status, $truename);
    list($html_output, $odd_row) = PMA_getHtmlForStructureTableRow($i, $odd_row, $table_is_view, $current_table, $browse_table_label, $tracking_icon, $server_slave_status, $browse_table, $tbl_url_query, $search_table, $db_is_information_schema, $titles, $empty_table, $drop_query, $drop_message, $collation, $formatted_size, $unit, $overhead, isset($create_time) ? $create_time : '', isset($update_time) ? $update_time : '', isset($check_time) ? $check_time : '', $is_show_stats, $ignored, $do, $colspan_for_structure);
    $response->addHTML($html_output);
}
// end foreach
// Show Summary
$response->addHTML('</tbody>');
$response->addHTML(PMA_getHtmlBodyForTableSummary($num_tables, $server_slave_status, $db_is_information_schema, $sum_entries, $db_collation, $is_show_stats, $sum_size, $overhead_size, $create_time_all, $update_time_all, $check_time_all, $sum_row_count_pre));
$response->addHTML('</table>');
//check all
$response->addHTML(PMA_getHtmlForCheckAllTables($pmaThemeImage, $text_dir, $overhead_check, $db_is_information_schema, $hidden_fields));
$response->addHTML('</form>');
//end of form
// display again the table list navigator
$response->addHTML(PMA_Util::getListNavigator($total_num_tables, $pos, $_url_params, 'db_structure.php', 'frame_content', $GLOBALS['cfg']['MaxTableList']));
$response->addHTML('</div><hr />');
/**
 * Work on the database
 */
/* DATABASE WORK */
/* Printable view of a table */
$response->addHTML(PMA_getHtmlForTablePrintViewLink($url_query) . PMA_getHtmlForDataDictionaryLink($url_query));
if (empty($db_is_information_schema)) {
    ob_start();
    include 'libraries/display_create_table.lib.php';
    $content = ob_get_contents();
    ob_end_clean();
    $response->addHTML($content);
}
// end if (Create Table dialog)

                _pgettext('short form', 'Create table'),
                array('id' => "icon_newtable")
            )
            . _pgettext('short form', 'Create table')
            . '</a></li></ul>';
    }
} elseif ($GLOBALS['cfg']['LeftFrameLight']) {
    /* No need to tell user to select database if we're showing complete list */
    if (!$list) {
        echo '<p>' . __('Please select a database') . '</p>';
    }
} else {
    echo '<div id="databaseList">' . "\n";
    $_url_params = array('pos' => $pos);
    echo PMA_Util::getListNavigator(
        count($GLOBALS['pma']->databases), $pos, $_url_params, 'navigation.php',
        'frame_navigation', $GLOBALS['cfg']['MaxDbList']
    );
    echo '</div>' . "\n";

    $common_url_query = PMA_generate_common_url();
    PMA_displayDbList(
        $GLOBALS['pma']->databases->getGroupedDetails(
            $_SESSION['tmp_user_values']['navi_limit_offset'],
            $GLOBALS['cfg']['MaxDbList']
        ),
        $_SESSION['tmp_user_values']['navi_limit_offset'],
        $GLOBALS['cfg']['MaxDbList']
    );
}

/**

if ($databases_count > 0) {
    echo '<div id="tableslistcontainer">';
    reset($databases);
    $first_database = current($databases);
    // table col order
    $column_order = PMA_getColumnOrder();

    $_url_params = array(
        'pos' => $pos,
        'dbstats' => $dbstats,
        'sort_by' => $sort_by,
        'sort_order' => $sort_order,
    );

    echo PMA_Util::getListNavigator(
        $databases_count, $pos, $_url_params, 'server_databases.php',
        'frame_content', $GLOBALS['cfg']['MaxDbList']
    );

    $_url_params['pos'] = $pos;

    echo '<form action="server_databases.php" method="post" name="dbStatsForm" id="dbStatsForm">' . "\n"
       . PMA_generate_common_hidden_inputs($_url_params);

    $_url_params['sort_by'] = 'SCHEMA_NAME';
    $_url_params['sort_order'] = ($sort_by == 'SCHEMA_NAME' && $sort_order == 'asc') ? 'desc' : 'asc';

    echo '<table id="tabledatabases" class="data">' . "\n"
       . '<thead>' . "\n"
       . '<tr>' . "\n"
       . ($is_superuser || $cfg['AllowUserDropDatabase'] ? '        <th></th>' . "\n" : '')
       . '    <th><a href="server_databases.php' . PMA_generate_common_url($_url_params) . '">' . "\n"