<?php
class Gridonly{
    private $rowPerPage = 50;
    private $page;
    private $totalPages;
    private $maxPages = 5;
    private $data;
    private $paging;
    private $totalData = 0;
    private $limit = 0;
    private $offset = 0;
	
	function build() {
		return new Gridonly;
	}
	
	public function execute($sql, $arrMap){
		
		$page=isset($_POST['page']) ? $_POST['page'] : 1;
		
		$resultRow = mysql_query($sql);
		$totalRows = mysql_num_rows($resultRow);
		
		
        $this->totalData = $totalRows;
        $this->totalPages=intval($totalRows/$this->rowPerPage) + ($totalRows%$this->rowPerPage==0 ? 0 : 1);
        if($this->totalPages<1){
          $this->totalPages=1;
        }
		
		 $this->page=intval($page);
            if($this->page<1){
                    $this->page=1;
            }
            if($this->page>$this->totalPages){
                    $this->page=$this->totalPages;
            }

            $this->page-=1;
            if($this->page<0){
                    $this->page=0;
            }
		
		$data = array();
		$limit = " LIMIT " . $this->page * $this->rowPerPage.", ".$this->rowPerPage;
		$query = $sql . " " . $limit;
        $result = mysql_query($query);
        $i = 0;
        while($rowData = mysql_fetch_assoc($result)){
			$data[$i]   = $rowData;
			$i++;
        }
		
		$this->page+=1;
		
		$this->createPaging();
		
		$arrHeader = array();
		$arrClass  = array();
		foreach($arrMap as $key => $val) {
			$arrHeader[$key] = $val['name'];
			$arrClass[$key]	 = isset($val['class']) ? $val['class'] : '';
		}
		
		$to = (($this->page * $this->rowPerPage) > $this->totalData) ? $this->totalData : ($this->page * $this->rowPerPage);
		$arrData = array(
			"header"	=> $arrHeader, 
			"class"		=> $arrClass,
			"data" 		=>  $data, 
			"paging" 	=> $this->paging, 
			"pagelabel" => "Showing " . ((($this->page * $this->rowPerPage) - $this->rowPerPage) + 1)  . " to " . $to ." of " . $this->totalData ." entries"
		);
		
        return $arrData;
    }
	
	public function createPaging(){
		$start=((($this->page%$this->maxPages==0) ? ($this->page/$this->maxPages) : intval($this->page/$this->maxPages)+1)-1)*$this->maxPages+1;
		$end=((($start+$this->maxPages-1)<=$this->totalPages) ? ($start+$this->maxPages-1) : $this->totalPages);
		$paging=($end < 2) ? '' : '<span>Go to Page </span><input type="text" name="page" id="page" value="'.$this->page.'">';
		//$paging='';
                if($end > 1) {
                    //$paging.= '<ul>';
                    if($this->page>1){
                            $paging.='<a rel="1"  title="First page" class="icoFirst"></a>';
                            //$paging.='<a rel="'.($this->page-1).'" title="Previous page" class="icoBack"></a>';
                    }

                    if($start>$this->maxPages){
                            $paging.='<a rel="'.($start-1).'" title="Page '.($start-1).'" class="icoBack"></a></li>';
                    }

                    for($i=$start;$i<=$end;$i++){
                            if($this->page==$i){
                                    $paging.='<a href="#" class="active">'.$i.'</a>';
                            }
                            else{
                                    $paging.='<a rel="'.$i.'" title="Page '.$i.'">'.$i.'</a>';
                            }
                    }

                    if($end<$this->totalPages){
                            $paging.='<a rel="'.($end+1).'" title="Page '.($end+1).'" class="icoNext"></a>';
                    }

                    if($this->page<$this->totalPages){
                            //$paging.='<a rel="'.($this->page+1).'" title="Next page" class="icoNext"></a>';
                            $paging.='<a rel="'.$this->totalPages.'" title="Last page" class="icoLast"></a>';
                    }
                    //$paging.= '<div class="clearfix"></div></ul>';
                }
				
                $this->paging = $paging;
		return $this;
    }
    
    
}