PHP Paginator::setTotalBlockCount方法代码示例

     $tab = 'e';
 } else {
     $tab = 'p';
 }
 //echo "$sql $tab.$oitem $odir";
 if ($ergebnis = $db->SelectLimit("{$sql} {$tab}.{$oitem} {$odir}", $pagen->MaxCount(), $pagen->BlockStartIndex())) {
     $rows = $ergebnis->RecordCount();
     if (AUTOSHOW_ONERESULT) {
         if ($rows == 1) {
             # If result is single item, display the data immediately
             $result = $ergebnis->FetchRow();
             header("location:aufnahme_daten_zeigen.php" . URL_REDIRECT_APPEND . "&target=archiv&origin=archiv&encounter_nr=" . $result['encounter_nr']);
             exit;
         }
     }
     $pagen->setTotalBlockCount($rows);
     # If more than one count all available
     if (isset($totalcount) && $totalcount) {
         $pagen->setTotalDataCount($totalcount);
     } else {
         # Count total available data
         $sql = "{$sql} {$tab}.{$oitem} {$odir}";
         if ($result = $db->Execute($sql)) {
             $totalcount = $result->RecordCount();
         }
         $pagen->setTotalDataCount($totalcount);
     }
     # Set the sort parameters
     $pagen->setSortItem($oitem);
     $pagen->setSortDirection($odir);
 } else {

if (empty($GLOBAL_CONFIG['pagin_address_list_max_block_rows'])) {
    $GLOBAL_CONFIG['pagin_address_list_max_block_rows'] = MAX_BLOCK_ROWS;
}
# Last resort, use the default defined at the start of this page
#Load and create paginator object
require_once $root_path . 'include/care_api_classes/class_paginator.php';
$pagen = new Paginator($pgx, $thisfile, $_SESSION['sess_searchkey'], $root_path);
# Adjust the max nr of rows in a block
$pagen->setMaxCount($GLOBAL_CONFIG['pagin_address_list_max_block_rows']);
# Get all the active firms info
//$address=$address_obj->getAllActiveCityTown();
$address =& $address_obj->getLimitActiveCityTown($GLOBAL_CONFIG['pagin_address_list_max_block_rows'], $pgx, $oitem, $odir);
# Get the resulting record count
//echo $address_obj->getLastQuery();
$linecount = $address_obj->LastRecordCount();
$pagen->setTotalBlockCount($linecount);
# Count total available data
if (isset($totalcount) && $totalcount) {
    $pagen->setTotalDataCount($totalcount);
} else {
    $totalcount = $address_obj->countAllActiveCityTown();
    $pagen->setTotalDataCount($totalcount);
}
$pagen->setSortItem($oitem);
$pagen->setSortDirection($odir);
# Start Smarty templating here
/**
 * LOAD Smarty
 */
# Note: it is advisable to load this after the inc_front_chain_lang.php so
# that the smarty script can use the user configured template theme

    /**
     * Displaying the GUI
     */
    function display($skey = '')
    {
        global $db, $searchkey, $root_path, $firstname_too, $HTTP_POST_VARS, $HTTP_GET_VARS, $sid, $lang, $mode, $totalcount, $pgx, $odir, $oitem, $HTTP_SESSION_VARS, $dbf_nodate, $user_origin, $parent_admit, $status, $target, $origin;
        $this->thisfile = $filename;
        $this->searchkey = $skey;
        $this->mode = $mode;
        if (empty($this->targetfile)) {
            $withtarget = FALSE;
            $navcolspan = 5;
        } else {
            $withtarget = TRUE;
            $navcolspan = 6;
        }
        if (!empty($skey)) {
            $searchkey = $skey;
        }
        # Load the language tables
        $lang_tables = $this->langfile;
        include $root_path . 'include/inc_load_lang_tables.php';
        # Initialize pages control variables
        if ($mode == 'paginate') {
            $searchkey = $HTTP_SESSION_VARS['sess_searchkey'];
            //$searchkey='USE_SESSION_SEARCHKEY';
            //$mode='search';
        } else {
            # Reset paginator variables
            $pgx = 0;
            $totalcount = 0;
            $odir = '';
            $oitem = '';
        }
        # Create an array to hold the config values
        $GLOBAL_CONFIG = array();
        #Load and create paginator object
        include_once $root_path . 'include/care_api_classes/class_paginator.php';
        $pagen = new Paginator($pgx, $this->thisfile, $HTTP_SESSION_VARS['sess_searchkey'], $root_path);
        include_once $root_path . 'include/care_api_classes/class_globalconfig.php';
        $glob_obj = new GlobalConfig($GLOBAL_CONFIG);
        $glob_obj->getConfig('person_id_%');
        # Get the max nr of rows from global config
        $glob_obj->getConfig('pagin_person_search_max_block_rows');
        if (empty($GLOBAL_CONFIG['pagin_person_search_max_block_rows'])) {
            # Last resort, use the default defined at the start of this page
            $pagen->setMaxCount($max_block_rows);
        } else {
            $pagen->setMaxCount($GLOBAL_CONFIG['pagin_person_search_max_block_rows']);
        }
        //$db->debug=true;
        if (!defined('SHOW_FIRSTNAME_CONTROLLER')) {
            define('SHOW_FIRSTNAME_CONTROLLER', $this->show_firstname_controller);
        }
        if (SHOW_FIRSTNAME_CONTROLLER) {
            if (isset($HTTP_POST_VARS['firstname_too'])) {
                if ($HTTP_POST_VARS['firstname_too']) {
                    $firstname_too = 1;
                } elseif ($mode == 'paginate' && isset($HTTP_GET_VARS['firstname_too']) && $HTTP_GET_VARS['firstname_too']) {
                    $firstname_too = 1;
                }
            } elseif ($mode != 'search') {
                $firstname_too = TRUE;
            }
        }
        if (($this->mode == 'search' || $this->mode == 'paginate') && !empty($searchkey)) {
            # Translate *? wildcards
            $searchkey = strtr($searchkey, '*?', '%_');
            include_once $root_path . 'include/inc_date_format_functions.php';
            include_once $root_path . 'include/care_api_classes/class_person.php';
            $person =& new Person();
            # Set the sorting directive
            if (isset($oitem) && !empty($oitem)) {
                $sql3 = " ORDER BY {$oitem} {$odir}";
            }
            //$sql='SELECT * FROM '.$dbtable.$sql2;
            if ($mode == 'paginate') {
                $fromwhere = $HTTP_SESSION_VARS['sess_searchkey'];
                $sql = 'SELECT pid, name_last, name_first, date_birth, addr_zip, sex, death_date, status FROM ' . $fromwhere . $sql3;
                $ergebnis = $db->SelectLimit($sql, $pagen->MaxCount(), $pagen->BlockStartIndex());
                $linecount = $ergebnis->RecordCount();
            } else {
                $ergebnis = $person->SearchSelect($searchkey, $pagen->MaxCount(), $pagen->BlockStartIndex(), $oitem, $odir, $firstname_too);
                #Retrieve the sql fromwhere portion
                $fromwhere = $person->buffer;
                $HTTP_SESSION_VARS['sess_searchkey'] = $fromwhere;
                $sql = $person->getLastQuery();
                $linecount = $person->LastRecordCount();
            }
            if ($ergebnis) {
                if ($linecount == 1) {
                    if ($this->auto_show_bynumeric && $person->is_nr || $this->auto_show_byalphanumeric) {
                        $zeile = $ergebnis->FetchRow();
                        header("location:" . $this->targetfile . "?sid=" . $sid . "&lang=" . $lang . "&pid=" . $zeile['pid'] . "&edit=1&status=" . $status . "&user_origin=" . $user_origin . "&noresize=1&mode=");
                        exit;
                    }
                }
                $pagen->setTotalBlockCount($linecount);
                # If more than one count all available
                if (isset($totalcount) && $totalcount) {
//.........这里部分代码省略.........