Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup_restore.php	9.12 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
cmailer_new.php	3.48 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
coutput_24042018.php	1.75 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.35 KB	-rwxr-xr-x
db_sync.php	7.54 KB	-rwxr-xr-x
display_custom_html.php	8.47 KB	-rwxr-xr-x
display_details_in_grid.php	71.04 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.67 KB	-rwxr-xr-x
forgot_password.php	3.76 KB	-rwxr-xr-x
format.php	6.75 KB	-rwxr-xr-x
getnumword.php	6.19 KB	-rwxr-xr-x
header.php	306 B	-rwxr-xr-x
jsmin.php	10.69 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	6.76 KB	-rwxr-xr-x
mregistry.php	2.96 KB	-rwxr-xr-x
sendLoginPassword.php	3.11 KB	-rwxr-xr-x
send_mail.php	2.88 KB	-rwxr-xr-x
system_utility.php	4.71 KB	-rwxr-xr-x

Code Editor : display_details_in_grid_custom.php

<?php
  /*
            Author :  Natesha
	 Date : 2010-04-29
	 Module : Purchase Order

*/    
  
  class display_details_in_grid
	{
	   public $table_cols;
	   public $display_qry;
	           function __construct($aobj_context)
	              {
		              session_start();
		              $this->aobj_context=$aobj_context;
		              $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
					  $this->user_id = $_SESSION['user_id'];	
					  require_once("json.php"); 	
		           }
		//End : Constructor 
		function DisplayDetailsInGrid()
		{ 
				$json = new Services_JSON(); 
				$limit = $this->aobj_context->mobj_data["rows"];
				$sidx = $this->aobj_context->mobj_data["sidx"];
				$sord = $this->aobj_context->mobj_data["sord"];
				$page = $this->aobj_context->mobj_data["page"];
				if(!$sidx) 
				$sidx =1; 
				$search =$this->aobj_context->mobj_data["_search"];					 
				$filter_toolbal_cond="";
				if($search=='true')
				{	 
					foreach($this->aobj_context->mobj_data as $search_k=>$search_v)
						{
							$s_val=trim($search_v);
							if(in_array($search_k,$this->table_cols))
							$filter_toolbal_cond.=" and {$search_k} like '{$s_val}%' ";	
						}
					$count_id="select count(*) as count from ({$this->display_qry} {$filter_toolbal_cond}) a ";		
				}				 
				else
				{
					$count_id="select count(*) as count from ({$this->display_qry}) a ";	
				}
				
				$count_id_obj=$this->aobj_context->mobj_db->GetRow($count_id);	
				$count = $count_id_obj['count'];
				 
				 // calculation of total pages for the query 
					if( $count >0 ) 
					{ 
						$total_pages = ceil($count/$limit); 
					} 
					else 
					{ 
						$total_pages = 0; 
					} 
					if ($page > $total_pages) 
					$page=$total_pages; 
					$start = $limit*$page - $limit;					
					if($start <0) 
					$start = 0; 
					
					if($search=='true')
					{
							
						$SQL="select * from ({$this->display_qry}) a  where 1=1					 
								{$filter_toolbal_cond}
							ORDER BY $sidx $sord LIMIT $start,$limit";
						//echo $SQL;	
					}
					else
					{
					$SQL = " {$this->display_qry} 
							ORDER BY $sidx $sord LIMIT $start , $limit"; 
								
					}
					 
					$lobj_rs =$this->aobj_context->mobj_db->GetAll($SQL);
					
					$responce->page = $page; 
					$responce->total = $total_pages; 
					$responce->records = $count; 
					foreach($lobj_rs as $key =>$value)
					{
					$val='';
					$responce->rows[$key]['id']=$value[id];
					$l=0;
						foreach($value as $key1 =>$value1)
						{	 
							if($key1!='id'){ 
							$val[$l]=$value[$key1];
							 $l++; 
							}
						} 
					$responce->rows[$key]['cell']=($val);
					}
					 
					echo $json->encode($responce);
					 
		}
	}
  
     
?>

${this.title}

Code Editor : display_details_in_grid_custom.php