_instance = $instance; $this->_perPage = $perPage; $this->set_instance(); } /** * get_start * * creates the starting point for limiting the dataset * @return numeric */ private function get_start(){ return ($this->_page * $this->_perPage) - $this->_perPage; } /** * set_instance * * sets the instance parameter, if numeric value is 0 then set to 1 * * @var numeric */ private function set_instance(){ $this->_page = (int) (!isset($_GET[$this->_instance]) ? 1 : $_GET[$this->_instance]); $this->_page = ($this->_page == 0 ? 1 : $this->_page); } /** * set_total * * collect a numberic value and assigns it to the totalRows * * @var numeric */ public function set_total($_totalRows){ $this->_totalRows = $_totalRows; } /** * get_limit * * returns the limit for the data source, calling the get_start method and passing in the number of items perp page * * @return string */ public function get_limit(){ if (STORAGE == 'postgres') { return "LIMIT ".$this->_perPage." OFFSET ".$this->get_start(); } else { return "LIMIT ".$this->get_start().",".$this->_perPage; } } /** * page_links * * create the html links for navigating through the dataset * * @var sting $path optionally set the path for the link * @var sting $ext optionally pass in extra parameters to the GET * @return string returns the html menu */ public function page_links($path='?',$ext=null) { $adjacents = "2"; $prev = $this->_page - 1; $next = $this->_page + 1; $lastpage = ceil($this->_totalRows/$this->_perPage); $lpm1 = $lastpage - 1; $pagination = ""; if($lastpage > 1) { $pagination .= "

"; if ($this->_page > 1) $pagination.= "« previous"; else $pagination.= "« previous"; if ($lastpage < 7 + ($adjacents * 2)) { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $this->_page) $pagination.= "$counter"; else $pagination.= "$counter"; } } elseif($lastpage > 5 + ($adjacents * 2)) { if($this->_page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $this->_page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= "..."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } elseif($lastpage - ($adjacents * 2) > $this->_page && $this->_page > ($adjacents * 2)) { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $this->_page - $adjacents; $counter <= $this->_page + $adjacents; $counter++) { if ($counter == $this->_page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= ".."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } else { $pagination.= "1"; $pagination.= "2"; $pagination.= ".."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $this->_page) $pagination.= "$counter"; else $pagination.= "$counter"; } } } if ($this->_page < $counter - 1) $pagination.= "next »"; else $pagination.= "next »"; $pagination.= "

\n"; } return $pagination; } }