Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	20.82 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
MarkEntry-Setup_28102014.php	22.99 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.3 KB	-rwxr-xr-x
absent_entry_setup_old.php	7.61 KB	-rwxr-xr-x
ack_exam_app_form.php	12.09 KB	-rwxr-xr-x
ack_exam_app_form_07032014.php	9 KB	-rwxr-xr-x
ack_exam_app_form_14032014.php	9.6 KB	-rwxr-xr-x
ack_rv_rt_application.php	7.57 KB	-rwxr-xr-x
ack_rv_rt_application_5days.ph...	7.41 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
attendance.php	6.07 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
bundle_dispatch.php	2.84 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry-new.php	53.14 KB	-rw-rw-r--
candidate-entry.php	53.85 KB	-rwxr-xr-x
candidate-entry1.php	37 KB	-rwxr-xr-x
candidate-entry24082012.php	33.21 KB	-rwxr-xr-x
candidate-entry_02122017.php	42.72 KB	-rwxr-xr-x
candidate-entry_220413.php	33.21 KB	-rwxr-xr-x
candidate-entry_bf_aws.php	50.79 KB	-rwxr-xr-x
candidate-entry_new.php	43 KB	-rwxr-xr-x
candidate-entry_old_01122019.p...	43.31 KB	-rwxr-xr-x
candidate-entry_without_iapr_i...	34.88 KB	-rwxr-xr-x
candidate-entrybefore yearexam...	34.55 KB	-rwxr-xr-x
candidate-entrykus.php	33.23 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
challan_entries.php	13.34 KB	-rwxr-xr-x
challan_preparation.php	10.28 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
college.php	4.61 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_degree_status.php	5.86 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 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
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	4.86 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
degree1.php	6.78 KB	-rwxr-xr-x
display_details_in_grid.php	104.96 KB	-rwxr-xr-x
display_details_in_grid22.php	103.04 KB	-rwxr-xr-x
display_details_in_grid_240320...	98.86 KB	-rwxr-xr-x
display_details_in_grid_before...	98.71 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.68 KB	-rwxr-xr-x
display_details_in_grid_studta...	96.56 KB	-rwxr-xr-x
display_details_in_grid_withde...	97.45 KB	-rwxr-xr-x
download_misc_files.php	3.3 KB	-rwxr-xr-x
download_misc_files_19062014.p...	3.25 KB	-rwxr-xr-x
download_photo.php	6.98 KB	-rwxr-xr-x
download_photo_befor_newzip_fo...	6.97 KB	-rwxr-xr-x
download_photo_old.php	3.51 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_23.php	120 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
error_log.php	749 B	-rwxrwxrwx
execute_query.php	2.5 KB	-rwxr-xr-x
execute_query27062012.php	2.51 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.64 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.24 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.24 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	33.59 KB	-rwxr-xr-x
getdata110911.php	16.03 KB	-rwxr-xr-x
getdata18112016.php	32.82 KB	-rwxr-xr-x
getdata27062012.php	16.8 KB	-rwxr-xr-x
getdata_24032015.php	20.96 KB	-rwxr-xr-x
getdataold.php	23.25 KB	-rwxr-xr-x
getfeeinformation.php	6.14 KB	-rwxr-xr-x
getmoduledetails.php	23.7 KB	-rwxr-xr-x
getnumword.php	7.42 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	12.28 KB	-rwxr-xr-x
login.php_1	3.25 KB	-rwxr-xr-x
login11052016.php	4.48 KB	-rwxr-xr-x
login27062012.php	2.85 KB	-rwxr-xr-x
login_03032015.php	3.6 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
markEntry-Setup2.php	21.93 KB	-rwxr-xr-x
message_board.php	4.67 KB	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	72.49 KB	-rwxr-xr-x
mregistry22.php	66.7 KB	-rwxr-xr-x
mregistry24042015.php	55.01 KB	-rwxr-xr-x
mregistry_13012017.php	63.53 KB	-rwxr-xr-x
mregistry_before_subupdtostud_...	52.68 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
printapp_sum.php	31.82 KB	-rwxr-xr-x
receive_rv_rt_application.php	7.65 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	7.21 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
savesspdetails.php	9.8 KB	-rw-rw-r--
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
student_entry.php	36.46 KB	-rwxr-xr-x
student_entry1307.php	37.71 KB	-rwxr-xr-x
student_entry27062012.php	30.47 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.01 KB	-rwxr-xr-x
subject_freshExam.php	18.92 KB	-rwxr-xr-x
subjectfreez.html	2.8 KB	-rwxr-xr-x
subjectfreez.php	12.98 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	75.5 KB	-rwxr-xr-x
teachers.php	10.33 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	3.86 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
upload_studentPhoto.php	10.06 KB	-rwxr-xr-x
upload_studentPhoto02062015.ph...	11.58 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
usersetup.php	24.11 KB	-rwxr-xr-x
usersubj_identification.php	4.54 KB	-rwxr-xr-x

Code Editor : ggridmodel.php

<?php
  /*
            Author :  M.Srikanth
	 Date : 2009-08-25
	 Module : GRN

*/  
  
  
  class gGridModel
	{
    public $login_ctr;
    public $user_id;
    public $aobj_context;
    public $module_id;
    public $table_cols=array();
       //Start :  Constructor
	           function __construct($aobj_context)
	              {
		              session_start();
		              $this->aobj_context=$aobj_context;
		              $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
					  require_once("json.php"); 
		              $this->user_id = $_SESSION['user_id'];
					  $this->login_ctr=$aobj_context->mobj_data["login_ctr"];
					  $this->module_id=$aobj_context->mobj_data["module_id"];
					  $this->table_name="module_{$this->module_id}_{$this->login_ctr}";
					  $get_data_cols=" desc {$this->table_name}";
						$lobj_create_table =  $this->aobj_context->mobj_db->GetAll($get_data_cols);
						 foreach($lobj_create_table as $key=>$val)
						{
							array_push($this->table_cols,$val[Field]);
							 
						}
						 
		          }
		//End : Constructor 
		  function CreateggridTempTable()
		  {
				$get_query="select internal_code,s_grid_query from s_user_schema
							where internal_code={$this->module_id}";
				$lobj_get_query =  $this->aobj_context->mobj_db->GetRow($get_query);
				if($lobj_get_query)
				{	
				$grid_query= $lobj_get_query['s_grid_query'];
				$this->aobj_context->mobj_db->Execute("drop table {$this->table_name}");
				$function_exists=strpos($grid_query,'select');
				
				
					if ($function_exists === false) 
						{
						
						    
							 require_once($this->aobj_context->main_src."/custom_src/ggridGetQuery.php");
							 
							$grid_query= call_user_func($grid_query,$this->aobj_context);
												
							
						}
					else
						{					
							eval("\$grid_query = \"$grid_query\";");
						}	
							
							$create_table="create table if not exists  {$this->table_name}
											{$grid_query}";
							$lobj_create_table =  $this->aobj_context->mobj_db->Execute($create_table);				
						
					}
		}	
		  
		  function viewUserSchemaGGridDetails()
			{
				 
					$json = new Services_JSON(); 
					$limit = $_GET['rows']; 
					$sidx = $_GET['sidx']; 
					$sord = $_GET['sord']; 
					$page = $_GET['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}%' ";	
							}	
					} 
						
					if($search=='true')
					{		
						$count_id="select count(*) as count from
								{$this->table_name} 
							where 1=1  {$filter_toolbal_cond}";
						
					}
					else
					{
					$count_id="select count(*) as count from
								{$this->table_name}";
					}	
							$result = mysql_query($count_id);
							$row = mysql_fetch_array($result,MYSQL_ASSOC);
							$count = $row['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; 
					// the actual query for the grid data 
					if($search=='true')
					{
							
						$SQL="select * from {$this->table_name}						 
							where  1=1  {$filter_toolbal_cond}
							ORDER BY $sidx $sord LIMIT $start,$limit";
					 // echo $SQL;  
							
					}
					else
					{
					$SQL = "select * from {$this->table_name} 
							where 1=1   			
							 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);
					
					
					// return the formated data

}
			function getGGridGroupDetailsRowData()
			{
			$id=$this->aobj_context->mobj_data["id"];
			$get_data="select * from {$this->table_name} where id={$id}";
			$lobj_get_data =  $this->aobj_context->mobj_db->GetRow($get_data);
			return $lobj_get_data;
			}
		function UpdateGGridRowModuleDetails()
		{
			$id=$this->aobj_context->mobj_data["id"];
			$is_multiple_update=$this->aobj_context->mobj_data["is_multiple_update"];
			$selected_rows=$this->aobj_context->mobj_data["selected_rows"];
			$lstr_param = stripcslashes($this->aobj_context->mobj_data["GGridUpdatearr"]);
			$json = new Services_JSON(); 
			$mobj_jsondata = $json->decode($lstr_param);
			$larr_GGridUpdatearr = get_object_vars($mobj_jsondata);
			
			$desc_table="desc {$this->table_name}";
			$lobj_desc_table =  $this->aobj_context->mobj_db->GetAll($desc_table);
			$grid_row_colour=0;
			$table_ids=($is_multiple_update>0)?$selected_rows:$id;
			foreach($lobj_desc_table as $dk=>$dv)
			{
				if($dv['Field']=='grid_row_colour')
				{
				$grid_row_colour=1;				
				break;
				}				
			}
			 
			if(empty($larr_GGridUpdatearr))
				{
					$lstr_param = $this->aobj_context->mobj_data["GGridUpdatearr"];
					$mobj_jsondata = $json->decode($lstr_param);
					$larr_GGridUpdatearr = get_object_vars($mobj_jsondata);
				}			
			$update_cond="";			
			 foreach($larr_GGridUpdatearr as $key=>$val)
			 {
			 			  
			   foreach($val as $k=>$v);if(empty($k)) continue;
				$update_cond.=" {$k}='".addslashes($v)."' ,";
			 }
			 $update_cond=substr($update_cond,0,strlen($update_cond)-1);
			 $update_table="update {$this->table_name} set {$update_cond}
							where id in({$table_ids})";
			 //echo $update_table; die();
						
			$lobj_update_table =  $this->aobj_context->mobj_db->Execute($update_table);	
			if($grid_row_colour)
			{
			 $update_color_field="update {$this->table_name} set  grid_row_colour='1'
							where id in({$table_ids})";
			$lobj_update_color_field =  $this->aobj_context->mobj_db->Execute($update_color_field);	
						
			}
			 
			if($lobj_update_table)
				{
					$data="Successfully Updated";
					echo  $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success");
				}
				else
				{
					$data="Updation Failed     ->".mysql_error();
					echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success");
				}
		}	
		function UpdateGandhiWithCellEdit()
		{
	 
		$internal_code = $this->aobj_context->mobj_data["internal_code"];
		$this->table_name = $this->aobj_context->mobj_data["table_name"];
		$val = $this->aobj_context->mobj_data["val"];
		$system_name = $this->aobj_context->mobj_data["system_name"];

$update_gandhi_grid_table="update {$this->table_name} set {$system_name}='{$val}'
								where id={$internal_code}";			 			
		$lobj_update_gandhi_grid_table = $this->aobj_context->mobj_db->Execute($update_gandhi_grid_table);
		 
		$grid_row_colour=0;		
			if(!empty($lobj_update_gandhi_grid_table))
			{
				$desc_table="desc {$this->table_name}";
				$lobj_desc_table =  $this->aobj_context->mobj_db->GetAll($desc_table);
				foreach($lobj_desc_table as $dk=>$dv)
				{
					if($dv['Field']=='grid_row_colour')
					{
					$grid_row_colour=1;				
					break;
					}				
				}
				if($grid_row_colour)
				{
				 $update_color_field="update {$this->table_name} set  grid_row_colour='1'
									where id={$internal_code}";
				$lobj_update_color_field =  $this->aobj_context->mobj_db->Execute($update_color_field);							
				}			
				$data="Row Updated Successfully";
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
			}
			else
			{
			 $data="Updation Failed";
			 echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 		
			} 
		}	
                    
    }
		
		 
	
function  CreateggridTempTable($aobj_context) 
 {
    $class_obj=new gGridModel($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	
	
	  $class_obj->CreateggridTempTable();
	$data="true";
	echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
		
 }
 function  viewUserSchemaGGridDetails($aobj_context) 
 {
    $class_obj=new gGridModel($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->viewUserSchemaGGridDetails();
 
 } 
 function  getGGridGroupDetailsRowData($aobj_context) 
 {
    $class_obj=new gGridModel($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$lobj_get_data=$class_obj->getGGridGroupDetailsRowData();
	echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"success");
 } 
 function  UpdateGGridRowModuleDetails($aobj_context) 
 {
    $class_obj=new gGridModel($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$lobj_update_data=$class_obj->UpdateGGridRowModuleDetails();
	
 }function  UpdateGandhiWithCellEdit($aobj_context) 
 {
    $class_obj=new gGridModel($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$lobj_update_data=$class_obj->UpdateGandhiWithCellEdit();
	
 }

${this.title}

Code Editor : ggridmodel.php