From bc1ee8524e0769ad37e3c4c02cfe96d2f60e52f6 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Nicolas=20L=C5=93uillet?= <nicolas.loeuillet@gmail.com>
Date: Wed, 7 Aug 2013 14:24:07 +0200
Subject: postgres

---
 inc/3rdparty/paginator.php | 354 +++++++++++++++++++++++----------------------
 1 file changed, 179 insertions(+), 175 deletions(-)

(limited to 'inc/3rdparty/paginator.php')

diff --git a/inc/3rdparty/paginator.php b/inc/3rdparty/paginator.php
index e8801555..306756c0 100644
--- a/inc/3rdparty/paginator.php
+++ b/inc/3rdparty/paginator.php
@@ -9,99 +9,103 @@
 class Paginator{
 
         /**
-	 * set the number of items per page.
-	 *
-	 * @var numeric
-	*/
-	private $_perPage;
-
-	/**
-	 * set get parameter for fetching the page number
-	 *
-	 * @var string
-	*/
-	private $_instance;
-
-	/**
-	 * sets the page number.
-	 *
-	 * @var numeric
-	*/
-	private $_page;
-
-	/**
-	 * set the limit for the data source
-	 *
-	 * @var string
-	*/
-	private $_limit;
-
-	/**
-	 * set the total number of records/items.
-	 *
-	 * @var numeric
-	*/
-	private $_totalRows = 0;
-
-
-
-	/**
-	 *  __construct
-	 *  
-	 *  pass values when class is istantiated 
-	 *  
-	 * @param numeric  $_perPage  sets the number of iteems per page
-	 * @param numeric  $_instance sets the instance for the GET parameter
-	 */
-	public function __construct($perPage,$instance){
-		$this->_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(){
-        	return "LIMIT ".$this->get_start().",$this->_perPage";
+     * set the number of items per page.
+     *
+     * @var numeric
+    */
+    private $_perPage;
+
+    /**
+     * set get parameter for fetching the page number
+     *
+     * @var string
+    */
+    private $_instance;
+
+    /**
+     * sets the page number.
+     *
+     * @var numeric
+    */
+    private $_page;
+
+    /**
+     * set the limit for the data source
+     *
+     * @var string
+    */
+    private $_limit;
+
+    /**
+     * set the total number of records/items.
+     *
+     * @var numeric
+    */
+    private $_totalRows = 0;
+
+
+
+    /**
+     *  __construct
+     *  
+     *  pass values when class is istantiated 
+     *  
+     * @param numeric  $_perPage  sets the number of iteems per page
+     * @param numeric  $_instance sets the instance for the GET parameter
+     */
+    public function __construct($perPage,$instance){
+        $this->_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
@@ -112,87 +116,87 @@ class Paginator{
          * @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 .= "<div class='pagination'>";
-		if ($this->_page > 1)
-		    $pagination.= "<a href='".$path."$this->_instance=$prev"."$ext'>« previous</a>";
-		else
-		    $pagination.= "<span class='disabled'>« previous</span>";   
-
-		if ($lastpage < 7 + ($adjacents * 2))
-		{   
-		for ($counter = 1; $counter <= $lastpage; $counter++)
-		{
-		if ($counter == $this->_page)
-		    $pagination.= "<span class='current'>$counter</span>";
-		else
-		    $pagination.= "<a href='".$path."$this->_instance=$counter"."$ext'>$counter</a>";                   
-		}
-		}
-		elseif($lastpage > 5 + ($adjacents * 2))
-		{
-		if($this->_page < 1 + ($adjacents * 2))       
-		{
-		for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
-		{
-		if ($counter == $this->_page)
-		    $pagination.= "<span class='current'>$counter</span>";
-		else
-		    $pagination.= "<a href='".$path."$this->_instance=$counter"."$ext'>$counter</a>";                   
-		}
-		    $pagination.= "...";
-		    $pagination.= "<a href='".$path."$this->_instance=$lpm1"."$ext'>$lpm1</a>";
-		    $pagination.= "<a href='".$path."$this->_instance=$lastpage"."$ext'>$lastpage</a>";       
-		}
-		elseif($lastpage - ($adjacents * 2) > $this->_page && $this->_page > ($adjacents * 2))
-		{
-		    $pagination.= "<a href='".$path."$this->_instance=1"."$ext'>1</a>";
-		    $pagination.= "<a href='".$path."$this->_instance=2"."$ext'>2</a>";
-		    $pagination.= "...";
-		for ($counter = $this->_page - $adjacents; $counter <= $this->_page + $adjacents; $counter++)
-		{
-		if ($counter == $this->_page)
-		    $pagination.= "<span class='current'>$counter</span>";
-		else
-		    $pagination.= "<a href='".$path."$this->_instance=$counter"."$ext'>$counter</a>";                   
-		}
-		    $pagination.= "..";
-		    $pagination.= "<a href='".$path."$this->_instance=$lpm1"."$ext'>$lpm1</a>";
-		    $pagination.= "<a href='".$path."$this->_instance=$lastpage"."$ext'>$lastpage</a>";       
-		}
-		else
-		{
-		    $pagination.= "<a href='".$path."$this->_instance=1"."$ext'>1</a>";
-		    $pagination.= "<a href='".$path."$this->_instance=2"."$ext'>2</a>";
-		    $pagination.= "..";
-		for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
-		{
-		if ($counter == $this->_page)
-		    $pagination.= "<span class='current'>$counter</span>";
-		else
-		    $pagination.= "<a href='".$path."$this->_instance=$counter"."$ext'>$counter</a>";                   
-		}
-		}
-		}
-
-		if ($this->_page < $counter - 1)
-		    $pagination.= "<a href='".$path."$this->_instance=$next"."$ext'>next »</a>";
-		else
-		    $pagination.= "<span class='disabled'>next »</span>";
-		    $pagination.= "</div>\n";       
-		}
-
-
-	return $pagination;
-	}
+    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 .= "<div class='pagination'>";
+        if ($this->_page > 1)
+            $pagination.= "<a href='".$path."$this->_instance=$prev"."$ext'>« previous</a>";
+        else
+            $pagination.= "<span class='disabled'>« previous</span>";   
+
+        if ($lastpage < 7 + ($adjacents * 2))
+        {   
+        for ($counter = 1; $counter <= $lastpage; $counter++)
+        {
+        if ($counter == $this->_page)
+            $pagination.= "<span class='current'>$counter</span>";
+        else
+            $pagination.= "<a href='".$path."$this->_instance=$counter"."$ext'>$counter</a>";                   
+        }
+        }
+        elseif($lastpage > 5 + ($adjacents * 2))
+        {
+        if($this->_page < 1 + ($adjacents * 2))       
+        {
+        for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
+        {
+        if ($counter == $this->_page)
+            $pagination.= "<span class='current'>$counter</span>";
+        else
+            $pagination.= "<a href='".$path."$this->_instance=$counter"."$ext'>$counter</a>";                   
+        }
+            $pagination.= "...";
+            $pagination.= "<a href='".$path."$this->_instance=$lpm1"."$ext'>$lpm1</a>";
+            $pagination.= "<a href='".$path."$this->_instance=$lastpage"."$ext'>$lastpage</a>";       
+        }
+        elseif($lastpage - ($adjacents * 2) > $this->_page && $this->_page > ($adjacents * 2))
+        {
+            $pagination.= "<a href='".$path."$this->_instance=1"."$ext'>1</a>";
+            $pagination.= "<a href='".$path."$this->_instance=2"."$ext'>2</a>";
+            $pagination.= "...";
+        for ($counter = $this->_page - $adjacents; $counter <= $this->_page + $adjacents; $counter++)
+        {
+        if ($counter == $this->_page)
+            $pagination.= "<span class='current'>$counter</span>";
+        else
+            $pagination.= "<a href='".$path."$this->_instance=$counter"."$ext'>$counter</a>";                   
+        }
+            $pagination.= "..";
+            $pagination.= "<a href='".$path."$this->_instance=$lpm1"."$ext'>$lpm1</a>";
+            $pagination.= "<a href='".$path."$this->_instance=$lastpage"."$ext'>$lastpage</a>";       
+        }
+        else
+        {
+            $pagination.= "<a href='".$path."$this->_instance=1"."$ext'>1</a>";
+            $pagination.= "<a href='".$path."$this->_instance=2"."$ext'>2</a>";
+            $pagination.= "..";
+        for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
+        {
+        if ($counter == $this->_page)
+            $pagination.= "<span class='current'>$counter</span>";
+        else
+            $pagination.= "<a href='".$path."$this->_instance=$counter"."$ext'>$counter</a>";                   
+        }
+        }
+        }
+
+        if ($this->_page < $counter - 1)
+            $pagination.= "<a href='".$path."$this->_instance=$next"."$ext'>next »</a>";
+        else
+            $pagination.= "<span class='disabled'>next »</span>";
+            $pagination.= "</div>\n";       
+        }
+
+
+    return $pagination;
+    }
 }
-- 
cgit v1.2.3