本文整理汇总了PHP中Paginator::BlockStartIndex方法的典型用法代码示例。如果您正苦于以下问题：PHP Paginator::BlockStartIndex方法的具体用法？PHP Paginator::BlockStartIndex怎么用？PHP Paginator::BlockStartIndex使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Paginator的用法示例。
在下文中一共展示了Paginator::BlockStartIndex方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: IN
$where .= " AND p.pid=e.pid AND f.encounter_nr=e.encounter_nr";
}
}
}
$sql = "{$select}{$from} WHERE {$where} AND e.encounter_status <> 'cancelled' AND e.status NOT IN ('void','inactive','hidden','deleted') ORDER by ";
$_SESSION['sess_searchkey'] = $sql;
}
if (!empty($where)) {
# Filter the encounter nr:
if ($oitem == 'encounter_nr' || $oitem == 'encounter_date') {
$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示例2: AND
}
# default, ascending alphabetic
}
}
$sql2 .= " AND enc.pid=reg.pid\n\t\t\t\t\t AND enc.encounter_status <> 'cancelled'\n\t\t\t\t\t AND (enc.is_discharged = '' OR enc.is_discharged=0)\n\t\t\t\t\t AND enc.status NOT IN ('void','hidden','inactive','deleted') ORDER BY ";
# Filter if it is personnel nr
if ($oitem == 'encounter_nr') {
$sql2 .= 'enc.' . $oitem . ' ' . $odir;
} else {
$sql2 .= 'reg.' . $oitem . ' ' . $odir;
}
$dbtable = 'FROM care_encounter as enc,care_person as reg ';
$sql = 'SELECT enc.encounter_nr, enc.encounter_class_nr, enc.is_discharged,
reg.pid, reg.name_2, reg.name_last, reg.name_first, reg.date_birth, reg.selian_pid,reg.sex, reg.selian_pid ' . $dbtable . $sql2;
// echo $sql;
if ($ergebnis = $db->SelectLimit($sql, $pagen->MaxCount(), $pagen->BlockStartIndex())) {
if ($linecount = $ergebnis->RecordCount()) {
// $pharmacy is delivered searching patients from pharmacy-module (cross link)
// This is empty when it is not defined.
if ($linecount == 1 && $numeric && $mode == 'search') {
$zeile = $ergebnis->FetchRow();
if (!empty($pharmacy)) {
$_SESSION['sess_pid'] = $zeile['pid'];
//echo 'Location:../registration_admission/show_prescription.php'.URL_REDIRECT_APPEND.'&pid='.$zeile['pid'].'&back_path='.$back_path.'&externalcall=true';
header('Location:../registration_admission/show_prescription.php' . URL_REDIRECT_APPEND . '&pid=' . $zeile['pid'] . '&back_path=' . $back_path . '&externalcall=true');
exit;
} else {
//echo 'Location:aufnahme_daten_zeigen.php'.URL_REDIRECT_APPEND.'&from=such&encounter_nr='.$zeile['encounter_nr'].'&target=search';
header('Location:aufnahme_daten_zeigen.php' . URL_REDIRECT_APPEND . '&from=such&encounter_nr=' . $zeile['encounter_nr'] . '&target=search');
exit;
}示例3: display
/**
* 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) {
//.........这里部分代码省略.........
示例4: AND
OR enc.encounter_nr LIKE "'.addslashes($suchbuffer).'"
)
AND enc.pid=reg.pid
AND enc.encounter_status<>"cancelled"
AND NOT enc.is_discharged
AND (enc.in_ward OR enc.in_dept)
AND enc.status NOT IN ("void","hidden","deleted","inactive")
ORDER BY ';
*/
if ($oitem == 'encounter_nr') {
$sql3 = " ORDER BY enc.{$oitem} {$odir}";
} else {
$sql3 = " ORDER BY reg.{$oitem} {$odir}";
}
//echo $sql.$dbtable.$sql2;
if ($ergebnis = $db->SelectLimit($sql . $dbtable . $sql2 . $sql3, $pagen->MaxCount(), $pagen->BlockStartIndex())) {
if ($linecount = $ergebnis->RecordCount()) {
if ($linecount == 1 && $numeric && $mode == 'search') {
$zeile = $ergebnis->FetchRow();
header("location:aufnahme_daten_zeigen.php" . URL_REDIRECT_APPEND . "&from=such&target=search&pid=" . $zeile['pid'] . "&encounter_nr=" . $zeile['encounter_nr'] . "&sem=" . !$zeile['is_discharged']);
exit;
}
$pagen->setTotalBlockCount($linecount);
# If more than one count all available
if (isset($totalcount) && $totalcount) {
$pagen->setTotalDataCount($totalcount);
} else {
# Count total available data
$sql = 'SELECT COUNT(enc.encounter_nr) AS maxnr ' . $dbtable . $sql2;
//$sql='SELECT enc.encounter_nr '.$dbtable.$sql2;
//echo $sql;