<?php
/****************************************************************************
* pagination.class.php
*
* version 1.0
*
* This script can be used to generate dynamically pagination for any list of rows or items from MySQL Database
* 
* ----------------------------------------------------------------
*
* A demo example is included in demo folder.
*
* Copyright (C) 2012 Fakhri Alsadi <fakrhi.s@hotmail.com>
*
*******************************************************************************/

if(!class_exists('cf_pagination')){
class cf_pagination{

private $rows=15;					//The rows per page.
private $table_rows_count;			//The total rows to show.
private $pages_count;				//The pages number to generate.
private $current_page=1;			//The number of the current page displayed.
private $start=0;					//The start of the mysql limit keyword.
private $printed_pages=7;			//Number of pages to display.
private $parameter='page_num';			//The pgination paramerter name.
private $url_rewrite='';			//The URL rewrite structure.
private $data_source;				//The MySQL Table or Tables used.
private $filter;					//The MySQL Where clouse.
private $current_parameters;		//The existing query string parameters
private $prev_page;					//The previous page.
private $next_page;					//The next page
private $run_count=0;				//Times that the funtion run() invoked.
private $show_pages_number=true;	//Pages number box status.
private $show_go_button=true;		//Showing Go button status.
private $show_prev_next=true;		//Showing pervious and next page buttons status.
private $show_first_last=true;		//Showing first and last page buttons status.
private $direction='';				//The direction of pagination.
private $alignment='';				//The alignment of pagination.
private $go_button_text= "GO";		//Set text of Go button
private $pages_number_text= "of pages"; //Set text of pages number
private $next_page_text= ">";		//Set text of next page button
private $prev_page_text= "<";		//Set text of previous button
private $first_page_text= "<<";	//Set text of first page button
private $last_page_text= ">>";		//Set text of last button
private $invalid_page_number_text= "invalid page number!";		//Set text of invalid page number error

public function __construct($data_source='',$filter='',$rows=15,$parameter='page_num')
	{
	$this->data_source=$data_source;
	$this->set_filter($filter);
	$this->rows=$rows;
	$this->parameter= $parameter;
	}


//------------------------------------------------------------------------

private function run()
{	
global $wpdb;
	
	if($this->run_count == 0)
	{
		
		if($this->data_source== '')
		{
			echo 'You must set the Data Source using the function set_data_source($data_source)';
			exit(0);
		}
		
		
		$sql=" select count(*) as cnt from {$this->data_source} {$this->filter} ";
		$result=$wpdb->get_row($sql);
		$this->table_rows_count = intval($result->cnt);
		
	
		$this->pages_count = intval($this->table_rows_count/$this->rows);
		if($this->table_rows_count%$this->rows !=0)
		$this->pages_count=$this->pages_count+1;
		if($this->pages_count ==0)
		$this->pages_count=1;
		
	    if(array_key_exists($this->parameter,$_GET))
		$this->current_page = intval($_GET[$this->parameter]);
		else
		$this->current_page =1;
		
		if($this->current_page<1)
		$this->current_page=1;
		else if($this->current_page > $this->pages_count)
		$this->current_page=$this->pages_count;	
			
		$this->current_parameters	= $this->WPSR_get_current_parameters($this->parameter);
		$this->prev_page= $this->current_page -1;
		$this->next_page= $this->current_page +1;
		
		$this->start = (($this->current_page - 1) * $this->rows);
			
	}
	
	$this->run_count ++;

}


//------------------------------------------------------------------------


public function print_pagination()
	{
	
	$this->run();
	
	$this->pagination_header_html();
	
	
	$stop=0;
	$half_pages="";
	$frompage="";
	$topage ="";
	
	if($this->printed_pages>1){
	
		$half_pages= intval($this->printed_pages/2);
		if($this->printed_pages%$half_pages ==0)
		$half_pages--;
		
		$frompage=($this->current_page - $half_pages );
		$topage = ($this->current_page + $this->printed_pages);
		
	}
	
	if($this->printed_pages==1)
	{
		$frompage = $this->current_page;
		$topage = $this->current_page;
	}	

	if($this->printed_pages==3)
	{
		$frompage = $this->current_page -1;
		$topage = $this->current_page + 1 ;
	}	


	if($this->current_page > ( $this->pages_count - ($this->printed_pages - $half_pages ) ))
	{
		$topage =  $this->pages_count ;
		$frompage= ( $this->pages_count - $this->printed_pages +1 );
	}
	
	for($i=$frompage;$i<=$topage;$i++)
	{

		if($i>0 && $i<=$this->pages_count && $this->pages_count>1)
		{
			if($i==$this->current_page)
				echo  $this->get_current_page_html($i);
			else
				echo  $this->get_page_html($i,$i);
				
			$stop++;
			if($stop >= $this->printed_pages)
			break;
		}

	}
	
	
	echo esc_html($this->get_go_button_html());	
	
	$this->pagination_footer_html();

	}


//------------------------------------------------------------------------

private function get_page_html($page,$name)
	{
		return '<a href="' . esc_url($this->get_page_url($page))  . '">' . esc_html($name) . '</a>';
	}
	
//------------------------------------------------------------------------

private function get_current_page_html($name)
	{

		return '<span class="currentpage">' . esc_html($name) . '</span>';
	}
	
//------------------------------------------------------------------------

private function pagination_header_html()
	{ 
		
		$options="";
		if($this->direction!='')
		$options= $options . ' dir="' . esc_attr($this->direction) . '" ';
		
		if($this->alignment!='')
		$options= $options . ' align="' . esc_attr($this->alignment) . '" ';
		
		
		echo '<div style="text-align:right;" class="pagination tablenav-page" ' . esc_attr($options) . ' >';
		
		
	}

//------------------------------------------------------------------------

private function pagination_footer_html()
	{
		echo '</div>'; 
	}
	
//------------------------------------------------------------------------

private function random_id()
	{
		srand ((double) microtime( )*1000000000);
		return rand();
	}

//------------------------------------------------------------------------
private function get_go_button_html()
	{
		
		$id='gopage' . $this->random_id();
		
		$url_structure="";
		if($this->url_rewrite !='')
		$url_structure = $this->url_rewrite;
		else
		$url_structure = $this->get_page_url_parameter() . '{pagination}';
		
		if($this->show_go_button)
		echo '<script>
		function fun_'. esc_js($id) .'()
			{
				var page=parseInt(document.getElementById(\''. esc_js($id) .'\').value);
				var url = "' . esc_js($url_structure) . '";
				if(page>0)
				{
					window.location= url.replace(/{pagination}/gi, page);
				}else
				{
					alert(\'' . esc_js($this->invalid_page_number_text) . '\');
				}
			}
		function keypress_'. esc_js($id) .'(event)
		{
   			var key=event.keyCode;

     			if(key == 13)
     			{
	     			fun_'. esc_js($id) .'();
	     			return false; 
   				}
		}
		</script><input onkeydown="return keypress_'. esc_js($id) .'(event)" type="text" name="' . esc_js($id) . '" id="' . esc_js($id) . '" size="3" value="' . esc_js($this->current_page) . '"  ><a onclick="fun_'. esc_js($id) .'()" href="#">' . esc_js($this->go_button_text) .'</a>'; 
	}	
	

//------------------------------------------------------------------------


public function get_page_url($page)
	{
		if($this->url_rewrite == '')
		{
			if($this->current_parameters =="")
			return "?" . $this->parameter . "=" . $page;
			else
			return $this->current_parameters . "&" . $this->parameter . "=" . $page;
		}else
		{
			return str_replace('{pagination}',$page, $this->url_rewrite);
		}
	}
	

//------------------------------------------------------------------------


private function get_page_url_parameter()
	{
		if($this->current_parameters =="")
		return "?" . $this->parameter . "=";
		else
		return $this->current_parameters . "&" . $this->parameter . "=";
	}

//------------------------------------------------------------------------

private function WPSR_get_current_parameters($remove_parameter="")
{	
	
	if($_SERVER['QUERY_STRING']!='')
	{
		$qry = '?' . sanitize_text_field($_SERVER['QUERY_STRING']); 
		if($remove_parameter!='')
		{
			if(array_key_exists($remove_parameter,$_GET)){
    			$string_remove = '&' . $remove_parameter . "=" . sanitize_text_field($_GET[$remove_parameter]);
    			$qry=str_replace($string_remove,"",$qry);
    			$string_remove = '?' . $remove_parameter . "=" . sanitize_text_field($_GET[$remove_parameter]);
    			$qry=str_replace($string_remove,"",$qry);
			}
		}
		
		return $qry;
	}else
	{
		return "";
	}
} 	

//------------------------------------------------------------------------


public function get_sql_limit()
	{
		$this->run();
		return " limit  {$this->start},{$this->rows} ";
	}
	
//------------------------------------------------------------------------

public function get_rows()
	{
		return $this->rows;
	}

//------------------------------------------------------------------------

public function set_rows($rows)
	{
		if(intval($rows)>0)
		{
			$this->rows=$rows;
			$this->run_count=0;
		}
	}

//------------------------------------------------------------------------

public function get_total_records()
	{
		return $this->table_rows_count;
	}


//------------------------------------------------------------------------

public function get_printed_pages()
	{
	 	return $this->printed_pages;
	}

//------------------------------------------------------------------------

public function set_printed_pages($printed_pages)
	{
		if(intval($printed_pages)>0)
		{
			$this->printed_pages=$printed_pages;
			$this->run_count=0;
		}
	}

//------------------------------------------------------------------------

public function get_parameter_name()
	{
	 	return $this->parameter;
	}

//------------------------------------------------------------------------

public function set_parameter_name($parameter)
	{
		$this->parameter=$parameter;
		$this->run_count=0;
	}
//------------------------------------------------------------------------

public function get_url_rewrite()
	{
	 	return $this->url_rewrite;
	}

//------------------------------------------------------------------------

public function set_url_rewrite($url_rewrite)
	{
		$this->url_rewrite=$url_rewrite;
		$this->run_count=0;
	}
//------------------------------------------------------------------------


public function get_data_source()
	{
	 	return $this->data_source;
	}

//------------------------------------------------------------------------

public function set_data_source($data_source)
	{
		$this->data_source=$data_source;
		$this->run_count=0;
	}

//------------------------------------------------------------------------

public function get_filter()
	{
	 	return $this->filter;
	}

//------------------------------------------------------------------------

public function set_filter($filter)
	{
		if($filter!='')
		$this->filter= ' where ' . $filter;
		$this->run_count=0;
	}
	
//------------------------------------------------------------------------

public function get_go_button_text()
	{
	 	return $this->go_button_text;
	}

//------------------------------------------------------------------------

public function set_go_button_text($go_button_text)
	{
		$this->go_button_text=$go_button_text;
		$this->run_count=0;
	}

//------------------------------------------------------------------------

public function get_pages_number_text()
	{
	 	return $this->pages_number_text;
	}

//------------------------------------------------------------------------

public function set_pages_number_text($pages_number_text)
	{
		$this->pages_number_text=$pages_number_text;
		$this->run_count=0;
	}
//------------------------------------------------------------------------

public function get_next_page_text()
	{
	 	return $this->next_page_text;
	}

//------------------------------------------------------------------------

public function set_next_page_text($next_page_text)
	{
		$this->next_page_text=$next_page_text;
		$this->run_count=0;
	}		

//------------------------------------------------------------------------

public function get_prev_page_text()
	{
	 	return $this->prev_page_text;
	}

//------------------------------------------------------------------------

public function set_prev_page_text($prev_page_text)
	{
		$this->prev_page_text=$prev_page_text;
		$this->run_count=0;
	}	

//------------------------------------------------------------------------

public function get_first_page_text()
	{
	 	return $this->first_page_text;
	}

//------------------------------------------------------------------------

public function set_first_page_text($first_page_text)
	{
		$this->first_page_text=$first_page_text;
		$this->run_count=0;
	}	

//------------------------------------------------------------------------

public function get_last_page_text()
	{
	 	return $this->last_page_text;
	}

//------------------------------------------------------------------------

public function set_last_page_text($last_page_text)
	{
		$this->last_page_text=$last_page_text;
		$this->run_count=0;
	}	

//------------------------------------------------------------------------

public function get_invalid_page_number_text()
	{
	 	return $this->invalid_page_number_text;
	}

//------------------------------------------------------------------------

public function set_invalid_page_number_text($invalid_page_number_text)
	{
		$this->invalid_page_number_text=$invalid_page_number_text;
		$this->run_count=0;
	}	

//------------------------------------------------------------------------

public function get_alignment()
	{
	 	return $this->$alignment;
	}

//------------------------------------------------------------------------

public function set_alignment($alignment)
	{
		$this->alignment=$alignment;
		$this->run_count=0;
	}	

//------------------------------------------------------------------------

public function get_direction()
	{
	 	return $this->$direction;
	}

//------------------------------------------------------------------------

public function set_direction($direction)
	{
		$this->direction=$direction;
		$this->run_count=0;
	}
	
//------------------------------------------------------------------------

public function show_pages_number($value)
	{
		
		if($value)
		$this->show_pages_number = true;
		else
		$this->show_pages_number = false;
		
		$this->run_count=0;
		
	}
//------------------------------------------------------------------------

public function can_show_pages_number()
	{
		return $this->show_pages_number;
	}

//------------------------------------------------------------------------

public function show_go_button($value)
	{
		
		if($value)
		$this->show_go_button = true;
		else
		$this->show_go_button = false;
		
		$this->run_count=0;
		
	}

//------------------------------------------------------------------------

public function can_show_go_button()
	{
		return $this->show_go_button;
	}

//------------------------------------------------------------------------

public function show_prev_next($value)
	{
		
		if($value)
		$this->show_prev_next = true;
		else
		$this->show_prev_next = false;
		
		$this->run_count=0;
		
	}

//------------------------------------------------------------------------

public function can_show_prev_next()
	{
		return $this->show_prev_next;
	}

//------------------------------------------------------------------------

public function show_first_last($value)
	{
		
		if($value)
		$this->show_first_last = true;
		else
		$this->show_first_last = false;
		
		$this->run_count=0;
		
	}

//------------------------------------------------------------------------

public function can_show_first_last()
	{
		return $this->show_first_last;
	}


//------------------------------------------------------------------------

}}

?>