class XY_Pagination
{
  private $_navigationItemCount = 10; //導航欄顯示導航總頁數
  private $_pageSize = null; //每頁項目數
  private $_align = "right"; //導航欄顯示位置
  private $_itemCount = null; //總項目數
  private $_pageCount = null; //總頁數
  private $_currentPage = null; //當前頁
  private $_front = null; //前端控制器
  private $_PageParaName = "page"; //頁面參數名稱
  private $_firstPageString = "|<<"; //導航欄中第一頁顯示的字符
  private $_nextPageString = ">>"; //導航欄中前一頁顯示的字符
  private $_previousPageString = "<<"; //導航欄中后一頁顯示的字符
  private $_lastPageString = ">>|"; //導航欄中最后一頁顯示的字符
  private $_splitString = " | ";
         //頁數字間的間隔符 /
  public function __construct($itemCount, $pageSize)
  {
    if(!is_numeric($itemCount) || (!is_numeric($pageSize)))
    throw new Exception("Pagination Error:not Number");
    $this->_itemCount = $itemCount;
    $this->_pageSize = $pageSize;
    $this->_front = Zend_Controller_Front::getInstance();
    $this->_pageCount = ceil($itemCount/$pageSize); //總頁數
    $page = $this->_front->getRequest()->getParam($this->_PageParaName);
    if(empty($page) || (!is_numeric($page))) //為空或不是數字，設置當前頁為1
    {
      $this->_currentPage = 1;
    }
    else
    {
      if($page < 1)
        $page = 1;
      if($page > $this->_pageCount)
        $page = $this->_pageCount;
      $this->_currentPage = $page;
    }
  }
  /**
   * 返回當前頁
   * @param int 當前頁
   */
  public function getCurrentPage()
  {
    return $this->_currentPage;
  }
  /**
   * 返回導航欄目
   * @return string 導航html class="PageNavigation"
   */
  public function getNavigation()
  {
    $navigation = '';
    $pageCote = ceil($this->_currentPage / ($this->_navigationItemCount - 1)) - 1; //當前頁處于第幾欄分頁
    $pageCoteCount = ceil($this->_pageCount / ($this->_navigationItemCount - 1)); //總分頁欄
    $pageStart = $pageCote * ($this->_navigationItemCount -1) + 1; //分頁欄中起始頁
    $pageEnd = $pageStart + $this->_navigationItemCount - 1; //分頁欄中終止頁
    if($this->_pageCount < $pageEnd)
    {
      $pageEnd = $this->_pageCount;
    }
        $navigation .= "總共：{$this->_itemCount}條　{$this->_pageCount}頁\n";
    if($pageCote > 0) //首頁導航
    {
      $navigation .= '$this->_firstPageString ";
    }
    if($this->_currentPage != 1) //上一頁導航
    {
      $navigation .= '$this->_previousPageString ";
    }
    while ($pageStart <= $pageEnd) //構造數字導航區(qū)
    {
      if($pageStart == $this->_currentPage)
      {
        $navigation .= "$pageStart".$this->_splitString;
      }
      else
      {
        $navigation .= '$pageStart".$this->_splitString;
      }
      $pageStart++;
    }
    if($this->_currentPage != $this->_pageCount) //下一頁導航
    {
      $navigation .= ' $this->_nextPageString ";
    }
    if($pageCote < $pageCoteCount-1) //未頁導航
    {
      $navigation .= '$this->_lastPageString ";
    }
    //添加直接導航框
    //$navigation .= '';
    //2008年8月27號補充輸入非正確頁碼后出現的錯誤——begin
    $navigation .= ' ';
    //2008年8月27號補充輸入非正確頁碼后出現的錯誤——end
    $navigation .= " ";
    return $navigation;
  }
  /**
   * 取得導航欄顯示導航總頁數
   *
   * @return int 導航欄顯示導航總頁數
   */
  public function getNavigationItemCount()
  {
    return $this->_navigationItemCount;
  }
  /**
   * 設置導航欄顯示導航總頁數
   *
   * @param int $navigationCount:導航欄顯示導航總頁數
   */
  public function setNavigationItemCoun($navigationCount)
  {
    if(is_numeric($navigationCount))
    {
      $this->_navigationItemCount = $navigationCount;
    }
  }
  /**
   * 設置首頁顯示字符
   * @param string $firstPageString 首頁顯示字符
   */
  public function setFirstPageString($firstPageString)
  {
    $this->_firstPageString = $firstPageString;
  }
  /**
   * 設置上一頁導航顯示字符
   * @param string $previousPageString:上一頁顯示字符
   */
  public function setPreviousPageString($previousPageString)
  {
    $this->_previousPageString = $previousPageString;
  }
  /**
   * 設置下一頁導航顯示字符
   * @param string $nextPageString:下一頁顯示字符
   */
  public function setNextPageString($nextPageString)
  {
    $this->_nextPageString = $nextPageString;
  }
  /**
   * 設置未頁導航顯示字符
   * @param string $nextPageString:未頁顯示字符
   */
  public function setLastPageString($lastPageString)
  {
    $this->_lastPageString = $lastPageString;
  }
  /**
   * 設置導航字符顯示位置
   * @param string $align:導航位置
   */
  public function setAlign($align)
  {
    $align = strtolower($align);
    if($align == "center")
    {
      $this->_align = "center";
    }elseif($align == "right")
    {
      $this->_align = "right";
    }else
    {
      $this->_align = "left";
    }
  }
  /**
   * 設置頁面參數名稱
   * @param string $pageParamName:頁面參數名稱
   */
  public function setPageParamName($pageParamName)
  {
    $this->_PageParaName = $pageParamName;
  }
  /**
   * 獲取頁面參數名稱
   * @return string 頁面參數名稱
   */
  public function getPageParamName()
  {
    return $this->_PageParaName;
  }
  /**
   * 生成導航鏈接地址
   * @param int $targetPage:導航頁
   * @return string 鏈接目標地址
   */
  private function createHref($targetPage = null)
  {
    $params = $this->_front->getRequest()->getParams();
        $module = $params["module"];
    $controller = $params["controller"];
    $action = $params["action"];
    $targetUrl = $this->_front->getBaseUrl()."/$module/$controller/$action";
    foreach ($params as $key => $value)
    {
      if($key != "controller" && $key != "module" && $key != "action" && $key != $this->_PageParaName)
      {
        $targetUrl .= "/$key/$value";
      }
    }
    if(isset($targetPage)) //指定目標頁
      $targetUrl .= "/$this->_PageParaName/$targetPage";
    else
      $targetUrl .= "/$this->_PageParaName/";
    return $targetUrl;
  }
}
?>

require_once 'Zend/Pagination.php';
$Users = new Users();
//$rows = $Users->getAdapter()->fetchOne("select count(*) from users where `role`!='admin'"); //recorde count
$rows = $Users->fetchAll("`role`!='admin'")->count(); //查詢記錄總數
$rowsPerPage = 5; //perPage recordes
$curPage = 1;
if($this->_request->getParam('page'))
{
    $curPage = $this->_request->getParam('page');
}
//search data and display
$this->view->users = $Users->fetchAll("`role`!='admin'",'id desc',$rowsPerPage,($curPage-1)*$rowsPerPage)->toArray();
$Pager = new XY_Pagination($rows,$rowsPerPage);
$this->view->pagebar = $Pager->getNavigation();