[1011]XOOPS 2.5 模組開發
<?php
//取得某筆分類資料陣列
function get_cate($cate_sn=null){
global $xoopsDB;
$sql="select * from ".$xoopsDB->prefix("tad_note_cate")." where `cate_sn` = '{$cate_sn}'";
$result = $xoopsDB->query($sql) or redirect_header('cate.php', 3, mysql_error());
$cate=$xoopsDB->fetchArray($result);
return $cate;
}
//分頁物件
class PageBar{
// 目前所在頁碼
var $current;
// 所有的資料數量 (rows)
var $total;
// 每頁顯示幾筆資料
var $limit;
// 目前在第幾層的頁數選項？
var $pCurrent;
// 總共分成幾頁？
var $pTotal;
// 每一層最多有幾個頁數選項可供選擇，如：3 = {[1][2][3]}
var $pLimit;
var $prev;
var $next;
var $prev_layer = ' ';
var $next_layer = ' ';
var $first;
var $last;
var $bottons = array();
// 要使用的 URL 頁數參數名？
var $url_page = "g2p";
// 要使用的 URL 讀取時間參數名？
var $url_loadtime = "loadtime";
// 會使用到的 URL 變數名，給 process_query() 過濾用的。
var $used_query = array();
// 目前頁數顏色
var $act_color = "#990000";
var $query_str; // 存放 URL 參數列
function PageBar($total, $limit, $page_limit){
$mydirname = basename( dirname( __FILE__ ) ) ;
$this->prev = "<img src='".XOOPS_URL."/modules/{$mydirname}/images/1leftarrow.gif' alt='"._BP_BACK_PAGE."' align='absmiddle' hspace=3>"._BP_BACK_PAGE;
$this->next = "<img src='".XOOPS_URL."/modules/{$mydirname}/images/1rightarrow.gif' alt='"._BP_NEXT_PAGE."' align='absmiddle' hspace=3>"._BP_NEXT_PAGE;
$this->first = "<img src='".XOOPS_URL."/modules/{$mydirname}/images/2leftarrow.gif' alt='"._BP_FIRST_PAGE."' align='absmiddle' hspace=3>"._BP_FIRST_PAGE;
$this->last = "<img src='".XOOPS_URL."/modules/{$mydirname}/images/2rightarrow.gif' alt='"._BP_LAST_PAGE."' align='absmiddle' hspace=3>"._BP_LAST_PAGE;
$this->limit = $limit;
$this->total = $total;
$this->pLimit = $page_limit;
}
function init(){
$this->used_query = array($this->url_page, $this->url_loadtime);
$this->query_str = $this->processQuery($this->used_query);
$this->glue = ($this->query_str == "")?'?':
'&';
$this->current = (isset($_GET["$this->url_page"]))? $_GET["$this->url_page"]:
1;
$this->pTotal = ceil($this->total / $this->limit);
$this->pCurrent = ceil($this->current / $this->pLimit);
}
//初始設定
function set($active_color = "none", $buttons = "none"){
if ($active_color != "none"){
$this->act_color = $active_color;
}
if ($buttons != "none"){
$this->buttons = $buttons;
$this->prev = $this->buttons['prev'];
$this->next = $this->buttons['next'];
$this->prev_layer = $this->buttons['prev_layer'];
$this->next_layer = $this->buttons['next_layer'];
$this->first = $this->buttons['first'];
$this->last = $this->buttons['last'];
}
}
// 處理 URL 的參數，過濾會使用到的變數名稱
function processQuery($used_query){
// 將 URL 字串分離成二維陣列
$vars = explode("&", $_SERVER['QUERY_STRING']);
for($i = 0; $i < count($vars); $i++){
$var[$i] = explode("=", $vars[$i]);
}
// 過濾要使用的 URL 變數名稱
for($i = 0; $i < count($var); $i++){
for($j = 0; $j < count($used_query); $j++){
if (isset($var[$i][0]) && $var[$i][0] == $used_query[$j]) $var[$i] = array();
}
}
// 合併變數名與變數值
for($i = 0; $i < count($var); $i++){
$vars[$i] = implode("=", $var[$i]);
}
// 合併為一完整的 URL 字串
$processed_query = "";
for($i = 0; $i < count($vars); $i++){
$glue = ($processed_query == "")?'?':
'&';
// 開頭第一個是 '?' 其餘的才是 '&'
if ($vars[$i] != "") $processed_query .= $glue.$vars[$i];
}
return $processed_query;
}
// 製作 sql 的 query 字串 (LIMIT)
function sqlQuery(){
$row_start = ($this->current * $this->limit) - $this->limit;
$sql_query = " LIMIT {$row_start}, {$this->limit}";
return $sql_query;
}
// 製作 bar
function makeBar($url_page = "none"){
if ($url_page != "none"){
$this->url_page = $url_page;
}
$this->init();
// 取得目前時間
$loadtime = '&loadtime='.time();
// 取得目前頁框(層)的第一個頁數啟始值，如 6 7 8 9 10 = 6
$i = ($this->pCurrent * $this->pLimit) - ($this->pLimit - 1);
$bar_center = "";
while ($i <= $this->pTotal && $i <= ($this->pCurrent * $this->pLimit)){
if ($i == $this->current){
$bar_center = "{$bar_center}<font color='{$this->act_color}'>[{$i}]</font>";
}else{
$bar_center .= " <a href='{$_SERVER['PHP_SELF']}{$this->query_str}{$this->glue}{$this->url_page}={$i}{$loadtime}'' title='{$i}'>{$i}</a> ";
}
$i++;
}
$bar_center = $bar_center . "";
// 往前跳一頁
if ($this->current <= 1){
$bar_left = " {$this->prev} ";
$bar_first = " {$this->first} ";
} else{
$i = $this->current-1;
$bar_left = " <a href='{$_SERVER['PHP_SELF']}{$this->query_str}{$this->glue}{$this->url_page}={$i}{$loadtime}' title='"._BP_BACK_PAGE."'>{$this->prev}</a> ";
$bar_first = " <a href='{$_SERVER['PHP_SELF']}{$this->query_str}{$this->glue}{$this->url_page}=1{$loadtime}' title='"._BP_FIRST_PAGE."'>{$this->first}</a> ";
}
// 往後跳一頁
if ($this->current >= $this->pTotal){
$bar_right = " {$this->next} ";
$bar_last = " {$this->last} ";
} else{
$i = $this->current + 1;
$bar_right = " <a href='{$_SERVER['PHP_SELF']}{$this->query_str}{$this->glue}{$this->url_page}={$i}{$loadtime}' title='"._BP_NEXT_PAGE."'>{$this->next}</a> ";
$bar_last = " <a href='{$_SERVER['PHP_SELF']}{$this->query_str}{$this->glue}{$this->url_page}={$this->pTotal}{$loadtime}' title='"._BP_LAST_PAGE."'>{$this->last}</a> ";
}
// 往前跳一整個頁框(層)
if (($this->current - $this->pLimit) < 1){
$bar_l = " {$this->prev_layer} ";
} else{
$i = $this->current - $this->pLimit;
$bar_l = " <a href='{$_SERVER['PHP_SELF']}{$this->query_str}{$this->glue}{$this->url_page}={$i}{$loadtime}' title='".sprintf($this->pLimit,_BP_GO_BACK_PAGE)."'>{$this->prev_layer}</a> ";
}
//往後跳一整個頁框(層)
if (($this->current + $this->pLimit) > $this->pTotal){
$bar_r = " {$this->next_layer} ";
} else{
$i = $this->current + $this->pLimit;
$bar_r = " <a href='{$_SERVER['PHP_SELF']}{$this->query_str}{$this->glue}{$this->url_page}={$i}{$loadtime}' title='".sprintf($this->pLimit,_BP_GO_NEXT_PAGE)."'>{$this->next_layer}</a> ";
}
$page_bar['center'] = $bar_center;
$page_bar['left'] = $bar_first . $bar_l . $bar_left;
$page_bar['right'] = $bar_right . $bar_r . $bar_last;
$page_bar['current'] = $this->current;
$page_bar['total'] = $this->pTotal;
$page_bar['sql'] = $this->sqlQuery();
return $page_bar;
}
}
?>