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
DownloadExamAppFormApplication...	5.12 KB	-rwxr-xr-x
ECHblk.php	11.03 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MC_033_S1720418_A_2017_2.pdf	0 B	-rwxr-xr-x
MarkEntry-Setup.php	26.29 KB	-rwxr-xr-x
MarkEntry-Setup22.php	21.76 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...	26.92 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
UpdateCollDet.php	1.67 KB	-rwxr-xr-x
XLSXReader.php	9.31 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.28 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
ack_adm_application.php	55 KB	-rwxr-xr-x
ack_admentry_application.php	48.17 KB	-rwxr-xr-x
ack_application.php	7.71 KB	-rwxr-xr-x
ack_exam_app_form.php	16.56 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.58 KB	-rwxr-xr-x
ack_exam_app_form_oldformat.ph...	12.53 KB	-rwxr-xr-x
ack_registration.php	7.77 KB	-rwxr-xr-x
ack_report.php	2.27 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.55 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
adm_challan_entries.php	13.83 KB	-rwxr-xr-x
adm_delete_data.php	5.58 KB	-rwxr-xr-x
admapprove.php	9.37 KB	-rwxr-xr-x
admchallanpreparation.php	8.83 KB	-rwxr-xr-x
admission_entry_reg.php	39.89 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admission_sms_push.php	2.26 KB	-rwxr-xr-x
admissionapplist.php	9.15 KB	-rwxr-xr-x
admissionapplist_old_10092019....	0 B	-rwxr-xr-x
admregisterlist.php	14.43 KB	-rwxr-xr-x
admstuddate.php	6.1 KB	-rwxr-xr-x
admsumsendsms.php	6.12 KB	-rwxr-xr-x
admuploadexsheet.php	12.4 KB	-rwxr-xr-x
admuploadexsheet_07082019.php	8.79 KB	-rwxr-xr-x
ansbookcancel.php	9.49 KB	-rwxr-xr-x
answer_book_issued.php	10.34 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	25.94 KB	-rwxr-xr-x
apprCandidReport.php	6.95 KB	-rwxr-xr-x
approve.php	37.52 KB	-rwxr-xr-x
attendance.php	10.23 KB	-rwxr-xr-x
attendance_freez.php	8.45 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendance_freez_old.php	8.55 KB	-rwxr-xr-x
attshort.php	6.29 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.js	2.73 KB	-rwxr-xr-x
backup.php	2.87 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
basic_old.css	13.33 KB	-rwxr-xr-x
batch_close.php	4.31 KB	-rwxr-xr-x
board.php	2.71 KB	-rwxr-xr-x
boeselection.php	1.64 KB	-rwxr-xr-x
bundle_dispatch.php	3.09 KB	-rwxr-xr-x
bundle_rec_ack.php	4.06 KB	-rwxr-xr-x
bundledispatchdatewise.php	12.74 KB	-rwxr-xr-x
bundlereceive.php	1.08 KB	-rwxr-xr-x
bundlestatus.php	5.3 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry.php	43.79 KB	-rwxr-xr-x
candidate-entry_new.php	42.85 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-entrynewformat.php	44.16 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
candidate_list.js	39.62 KB	-rwxr-xr-x
cappcontext.php	2.63 KB	-rwxr-xr-x
cconfig_wait.php	1.12 KB	-rwxr-xr-x
challan_entries.php	15.38 KB	-rwxr-xr-x
challan_preparation.php	11.69 KB	-rwxr-xr-x
changeDegree.php	1.56 KB	-rwxr-xr-x
changeMobile.php	2.43 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
cntDeclaration.php	4.12 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
coll_exam_app_form.php	981 B	-rwxr-xr-x
collbankdet.php	1.82 KB	-rwxr-xr-x
colldesp_ack.php	4 KB	-rwxr-xr-x
college.php	5.01 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_approve.php	5.61 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
collegebank.php	1.82 KB	-rwxr-xr-x
collfundtransfer.php	2.23 KB	-rwxr-xr-x
connect.php	2.24 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
createAdmission.php	3.94 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
cronjob_sendsms.php	2.94 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
database.php	472 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	7.9 KB	-rwxr-xr-x
degree.php	6.49 KB	-rwxr-xr-x
degreeGroup.php	2 B	-rwxr-xr-x
display_details_in_grid.php	105.4 KB	-rwxr-xr-x
display_details_in_grid22.php	104.95 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.61 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
display_details_in_gridold.php	102.19 KB	-rwxr-xr-x
doc_verify.php	7.31 KB	-rwxr-xr-x
doc_verify_12102019.php	6.99 KB	-rwxr-xr-x
downloadFeeStatement.php	5.32 KB	-rwxr-xr-x
download_misc_files.php	4.59 KB	-rwxr-xr-x
download_misc_files_old.php	4.3 KB	-rwxr-xr-x
download_photo.php	3.68 KB	-rwxr-xr-x
download_photo22.php	6.83 KB	-rwxr-xr-x
download_photo_new.php	4.82 KB	-rwxr-xr-x
download_photo_sikkim.php	5.07 KB	-rwxr-xr-x
download_photoold.php	3.58 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
examAppChallan.php	7.71 KB	-rwxr-xr-x
execute_query.php	2.5 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
forgotpassword.php	3.11 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.63 KB	-rwxr-xr-x
freeze_module_at_admin_college...	10.07 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.76 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.81 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
freezeiaprici.php	9.9 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getMessages.php	11.16 KB	-rwxr-xr-x
getdata.php	34.99 KB	-rwxr-xr-x
getdata22.php	32.91 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	7.12 KB	-rwxr-xr-x
getfeeinformation_bulk.php	7.54 KB	-rwxr-xr-x
getmoduledetails.php	23.4 KB	-rwxr-xr-x
getnumword.php	7.43 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
index.php	5.06 KB	-rwxr-xr-x
json.php	33.72 KB	-rwxr-xr-x
krvw.html	1.5 KB	-rwxr-xr-x
login.php	18.39 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
login_wait.php	11.48 KB	-rwxr-xr-x
mascomb.php	10.02 KB	-rwxr-xr-x
mcverifydet.php	14.26 KB	-rwxr-xr-x
message_board.php	4.7 KB	-rwxr-xr-x
messagetext.php	980 B	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	89.11 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
nobleRegn.php	3.96 KB	-rwxr-xr-x
payment_gateway.php	7.78 KB	-rwxr-xr-x
pclzip.lib.php	192.53 KB	-rwxr-xr-x
photoupload.php	9.28 KB	-rwxr-xr-x
post.php	5.05 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
push_data_to_studentportal.php	1.8 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.57 KB	-rwxr-xr-x
remove_exam_ack.php	3.53 KB	-rwxr-xr-x
report_admission_ticket.php	46.77 KB	-rwxr-xr-x
report_hall_ticket.php	11.18 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
result.php	5.06 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.91 KB	-rwxr-xr-x
room_allotment_datewise.php	15.59 KB	-rwxr-xr-x
room_allotment_datewise_new.ph...	15.3 KB	-rwxr-xr-x
room_allotment_old.php	16.44 KB	-rwxr-xr-x
room_allotmentnew.php	9.24 KB	-rwxr-xr-x
room_allotmentold.php	15.27 KB	-rwxr-xr-x
roomdeclaration.php	1.81 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sample.php	2.04 KB	-rwxr-xr-x
sectionwisepermission.php	5.53 KB	-rwxr-xr-x
sendGridMail.php	1.2 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
sendsmsapi.php	760 B	-rwxr-xr-x
sendusrandpws.php	1002 B	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
servfeehead.php	3.84 KB	-rwxr-xr-x
services.php	3.47 KB	-rwxr-xr-x
sfeehead.php	5.45 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
stuIAMarksPending.php	5.92 KB	-rwxr-xr-x
student.php	55.86 KB	-rwxr-xr-x
student_14062018.php	43.9 KB	-rwxr-xr-x
student_entry.php	60.55 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entry_14062018.php	48.28 KB	-rwxr-xr-x
student_entry_24112017.php	42.7 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
studentportal_remove.php	6.18 KB	-rwxr-xr-x
subjectList_display.php	11.05 KB	-rwxr-xr-x
subject_freshExam.php	19.73 KB	-rwxr-xr-x
subjectfreez.php	13.2 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	9.95 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	80.06 KB	-rwxr-xr-x
teachers.php	15.1 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
teachersnew.php	16.95 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
update.php	720 B	-rwxr-xr-x
updateSection.php	4.79 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
update_query.php	334 B	-rwxr-xr-x
updateexamcnt.php	2.92 KB	-rwxr-xr-x
upload_studentPhoto.php	8.63 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadzip.php	9.18 KB	-rwxr-xr-x
usersetup.php	25.11 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	5.58 KB	-rwxr-xr-x

Code Editor : display_details_in_grid22.php

<?php
include_once("/JSON.php"); 
$json = new Services_JSON(); 
function getsearchcondition($cond,$val)
{
	switch($cond)
		{
		case 'eq':
		$cond="="; 
		$value="'".$val."'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		case 'ne':
		$cond="!="; 
		$value="'".$val."'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		case 'lt':
		$cond="<"; 
		$value="'".$val."'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		case 'le':
		$cond="<="; 
		$value="'".$val."'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		case 'gt':
		$cond=">"; 
		$value="'".$val."'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		case 'ge':
		$cond=">="; 
		$value="'".$val."'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		case 'cn':
		$cond="like '%"; 
		$value=$val."%'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		case 'nc':// Doesnot Contain
		$cond="not like '%"; 
		$value=$val."%'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		
		case 'bw':
		$cond="like '"; 
		$value=trim($val)."%'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		case 'bn'://Does Not Begin With
		$cond="not like '"; 
		$value=trim($val)."%'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		
		case 'ew':
		$cond="like '%"; 
		$value=$val."'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		
		case 'en'://Does Not Ends With
		$cond="not like '%"; 
		$value=$val."'";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		
		case 'in'://Is in
		$cond="in '("; 
		$value=$val."')";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
		
		case 'in'://Is not in
		$cond="notin '("; 
		$value=$val."')";
		$final_value[0]=$cond;
		$final_value[1]=$value;
		return $final_value;
		break;
	}
}

// to take th e parameters from Search field
	$filter_toolbal_cond="";
	if($search=='true')
	{
		$Colcode =$aobj_context->mobj_data["FCOLLCODE"];
		$Desc =$aobj_context->mobj_data["FCOLLNAME"];
		
		if(isset($Colcode) && !empty($Colcode))
		$filter_toolbal_cond.="FCOLLCODE like '{$Colcode}%'";
			
		/* if(isset($Desc) && !empty($Desc))
			$filter_toolbal_cond.=" and FDESCPN like '{$Desc}%'"; */
	}	
	
	if($search=='true')
	{
		$count_id="select count(distinct FCOLLCODE) as count from
					college where {$filter_toolbal_cond}";
	}
	else
	{
		$count_id="select count(distinct FCOLLCODE) as count from
					college ";
	}	
	
	$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 (select FCOLLCODE as id,FCOLLCODE,FCOLLNAME from college)a where  {$filter_toolbal_cond}
			group by FCOLLCODE
			ORDER BY $sidx $sord LIMIT $start,$limit";					
	}
	else
	{
	        $SQL = "select FCOLLCODE as id,FCOLLCODE,FCOLLNAME from college  
			ORDER BY $sidx $sord LIMIT $start , $limit"; 			 			
	}
	
	// echo $SQL;
	$result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error());
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count;

$i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
	{ 
	  $responce->rows[$i]['id']=$row[id]; //id
	  $responce->rows[$i]['cell']=array($row[FCOLLCODE],$row[FCOLLNAME]); 	
	  $i++; 
	} 	
	echo json_encode($responce);
	
}

// to take th e parameters from Search field
	$filter_toolbal_cond="";
	if($search=='true')
	{
		$Degcode =$aobj_context->mobj_data["FDEGREE"];
		$Desc =$aobj_context->mobj_data["FDESCPN"];
		
		if(isset($Degcode) && !empty($Degcode))
			$filter_toolbal_cond.=" d.FDEGREE like '{$Degcode}%'";
		/* if(isset($Desc) && !empty($Desc))
			$filter_toolbal_cond.=" and FDESCPN like '{$Desc}%'"; */
	}	
	
	if($search=='true')
	{
		$count_id="select count(distinct FDEGREE) as count from
					colldeg where {$filter_toolbal_cond}";
	}
	else
	{
		$count_id="select count(distinct FDEGREE) as count from
					colldeg ";
	}	
	
	$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 c.FDEGREE as id, c.FDEGREE,d.FDESCPN
			 from colldeg c inner join degree d on
			 d.FDEGREE=c.FDEGREE and FCOLLCODE='{$college_code}'
			 and c.FDELETED = 'F'
			 {$cond} where  {$filter_toolbal_cond}  group by FDEGREE
			ORDER BY $sidx $sord LIMIT $start,$limit";	
	}
	else
	{
	$SQL = " select c.FDEGREE as id, c.FDEGREE,d.FDESCPN
			 from colldeg c inner join degree d on
			 d.FDEGREE=c.FDEGREE and FCOLLCODE='{$college_code}'
			 and c.FDELETED = 'F'
			 {$cond} group by FDEGREE
			 ORDER BY $sidx $sord LIMIT $start , $limit"; 
			
	}
	// echo $SQL;
	$result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error());
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count;

$i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
	{ $responce->rows[$i]['id']=$row[id]; //id
	$responce->rows[$i]['cell']=array($row[FDEGREE],$row[FDESCPN]); 
	$i++; 
	} 
	echo json_encode($responce);
	
}
function degreeDetailsPopup($aobj_context)
{
	session_start();
	$college_code = $_SESSION['collcode'];
	$userid = $_SESSION['user_id'];
	$user_type = $_SESSION['user_type'];
	//var_dump($user_type);
	$type = ($aobj_context->mobj_data["type"]);
	$module = $aobj_context->mobj_data["module"]; 
	//var_dump($module);
	if($mod_type == '')
	{
		$cond=' ';		
	}
	else 
	{
		$cond= "and c.{$mod_type} is NULL";		
	}
	if($type == 'FCADSTATUS')
	{
		$fadmdeg = "inner join mascomb mc on c.fdegree = mc.fdegree and ifnull(mc.fdeleted,'') <> 'T'";
	}else
	{
		$fadmdeg = " ";
	}
	if($type == "FCMESTATUS" || $type == "FCPRSTATUS")
	{
		if(strtoupper($_SESSION['user_type']) =='ADMIN' || strtoupper($_SESSION['user_type']) =='SUPERUSER')
		{
			$ltable = "inner join degree d on d.FDEGREE=c.FDEGREE and FCOLLCODE='{$college_code}'";
		}
		else
		{
			$ltable = "inner join degree d on d.FDEGREE=c.FDEGREE and c.FCOLLCODE='{$college_code}' 
			inner join usersub us on d.fdegree = us.fdegree and c.fcollcode = us.fcollegecode and us.fuser = '{$userid}'";
		}
	}else
	{
		$ltable = "inner join degree d on d.FDEGREE=c.FDEGREE and FCOLLCODE='{$college_code}'";
	}
		
	
	include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
		$display_obj=new display_details_in_grid($aobj_context);
		$display_obj->table_cols=array('FDEGREE','FDESCPN');
	
		if(strtolower($college_code) == 'lsys' || strtolower($user_type) == 'lsys')
		{
			$display_obj->display_qry = " select distinct FDEGREE as id,FDEGREE,FDESCPN
			 from degree where ifnull(FDELETED,'') <> 'T' "; 		 
		}
		else
		{
			$display_obj->display_qry = " select distinct c.FDEGREE as id, c.FDEGREE,d.FDESCPN 
			from colldeg c {$ltable}
			and ifnull(c.FDELETED,'') <> 'T'
			{$cond}  {$fadmdeg}
			where 1=1 "; 
		}
	//	var_dump($display_obj->display_qry);
		$display_obj->DisplayDetailsInGrid();
	 
}

if($search=='true')
	{
		$count_id="select count(*)as count from degree where {$filter_toolbal_cond}";		
	}
	else
	{
		$count_id="select count(*)as count from degree where fdegree ='".$DegCode."'";
	}

/* $result = mysql_query($count_id);
	$row = mysql_fetch_array($result,MYSQL_ASSOC); */
	$result=$aobj_context->mobj_db->getRow($count_id);
	$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 (select fexamno as id, fexamno,fexamname from degree where {$filter_toolbal_cond})a 
		ORDER BY $sidx $sord LIMIT $start,$limit";
		//where  $field_name $cond$value
	}
	
	else
	{
	$SQL = "select fexamno as id, fexamno,fexamname from degree where fdegree='".$DegCode."' 
			 ORDER BY $sidx $sord LIMIT $start , $limit"; 
			// echo $SQL;  	
	}
	 //echo $SQL;
		//$result = mysql_query($SQL) or die("Could not execute query.".$count);
	$result = $aobj_context->mobj_db->getAll($SQL);
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count;

$i=0; 
	/* while($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
	{ 
		$responce->rows[$i]['id']=$row[id]; //id
		$responce->rows[$i]['cell']=array($row[fexamno],$row[fexamname]); 
		$i++; 
	}  */
	foreach($result as $key=>$val)
	{
		$responce->rows[$i]['id']=$val[id]; //id
		$responce->rows[$i]['cell']=array($val[fexamno],$val[fexamname]); 
		$i++; 
	}
	echo json_encode($responce);
}

$obj_get_status = $aobj_context->mobj_db->GetRow($get_freezed_subject);
			$freezed_cond="";
			if($univcode != 18)
			{	
				if(trim($obj_get_status['type']) == '')
					$freezed_cond ="";
				else
				{
					//$count_type = strlen($obj_get_status['type'])-1; 
					$freezed_module1 = $obj_get_status['type']; //substr($obj_get_status['type'],0,$count_type);
					$frz_module = "'".str_replace("*","','",$freezed_module1)."'";
					$freezed_cond = "and s.FCSUBCODE NOT IN ({$frz_module}) ";
				}
			}	
		}
		//var_dump($_SESSION['user_type']);
		if($module == 'ME')
		{
			if(strtoupper($_SESSION['user_type']) =='ADMIN' || strtoupper($_SESSION['user_type']) =='SUPERUSER')
			{
				$ltable = 'inner join marks m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode';
			}
			else
			{
				$ltable = "inner join marks m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode 
				inner join usersub us on m.fdegree = us.fdegree and instr(us.fsubcode,m.fsubcode) > 0 and m.fcollcode = us.fcollegecode and us.fuser = '{$userID}'";
			}
		}
		elseif($module == 'PR')
		{
			if(strtoupper($_SESSION['user_type']) =='ADMIN' || strtoupper($_SESSION['user_type']) =='SUPERUSER')
			{
				$ltable = 'inner join marks_pr m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode';
			}
			else
			{
				$ltable = "inner join marks_pr m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode 
				inner join usersub us on m.fdegree = us.fdegree and instr(us.fprsubcode,m.fsubcode) > 0 and m.fcollcode = us.fcollegecode and us.fuser = '{$userID}'";
		
			}
		}
		else
		{
			$ltable = 'inner join colldeg m on s.fdegree = m.fdegree';
		}
		
		if($module == 'PR')
		{
			$collcode = "1=1";
		}else
		{
			$collcode = "m.FCOLLCODE = '{$college_code}'";
		}

$display_obj->display_qry ="select distinct fcsubcode as id,fcsubcode,fsubname,fssubname,
		concat(fshortname,'(',fsubshort,')') as fshortname,FVALMAX from 
		subject s  {$ltable}
		where {$collcode}  and s.fdegree = '{$Degree_code}' and s.fexamno = '{$Exam_no}' 
		{$cat_cond} {$freezed_cond} ";
	}	//var_dump($display_obj->display_qry);
	$display_obj->DisplayDetailsInGrid();	
	/*	$display_obj->display_qry ="select distinct fcsubcode as id,fcsubcode,fsubname,fssubname,
	concat(fshortname,'(',fsubshort,')') as fshortname,fsmaxmarks from 
	subject s 
	inner join colldeg c on
	s.FDEGREE = c.FDEGREE 
	and s.fdegree = '{$Degree_code}' and s.fexamno='{$Exam_no}' 
	inner join marks m on s.fdegree = m.fdegree and s.fexamno = m.fexamno and s.fcsubcode = m.fsubcode and c.fcollcode = m.fcollcode
	left join usersub us on INSTR(us.fsubcode,s.fsubcode) 
	where  c.FCOLLCODE='{$college_code}' and fuser = '{$userID}' and us.fdegree = '{$Degree_code}' {$cat_cond} {$freezed_cond} 
	";

}		*/
	//var_dump($display_obj->display_qry ); 	
	/* 	include_once("/JSON.php"); 
	session_start();	
	$college_code = $_SESSION['collcode'];

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	$Degree_code = $aobj_context->mobj_data["DegCode"]; 
	$Exam_no = $aobj_context->mobj_data["Examno"]; 
	$module = $aobj_context->mobj_data["module"]; 
	$category = $aobj_context->mobj_data["category"]; 
	$search =$aobj_context->mobj_data["_search"];

$select_category_cond="select * from markentrycodition where Code={$category}";	
	$cat_cond='';
	$freezed_cond='';	
	$lobj_select_category_cond = $aobj_context->mobj_db->GetRow($select_category_cond);
	//var_dump($lobj_select_category_cond);

$json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	$DegCode =$_GET['DegCode'];
	if(!$sidx) 
	$sidx =1; 
	$cond='';
	$value='';
	// the actual query for the grid data

//echo $frz_module; die();

$filter_toolbal_cond="";
	// to take th e parameters from Search field
	if($search=='true')
	//if(isset($_GET['searchField']) &&  $_GET["searchField"]!='')
	{

$ffsubcode =$aobj_context->mobj_data["ffsubcode"];
	$fshortname =$aobj_context->mobj_data["fshortname"];

if(isset($DegCode) && !empty($DegCode))
	$filter_toolbal_cond.=" fdegree = '{$DegCode}'";
	if(isset($Exam_no) && !empty($Exam_no))
	$filter_toolbal_cond.="AND fexamno ='{$Exam_no}'";
	if(isset($ffsubcode) && !empty($ffsubcode))
	$filter_toolbal_cond.="AND fcsubcode like '{$ffsubcode}%'";
	if(isset($fshortname) && !empty($fshortname))
	$filter_toolbal_cond.="AND fshortname like '{$fshortname}%'";

$filter_toolbal_cond.="and fretain='T' and fintass='T'";	
	}		
	if($search=='true')
	{
	$count_id="select count(*) as count from subject where {$filter_toolbal_cond} ";

}
	else
	{
	$count_id="select count(*) as count from subject where fdegree = '".$Degree_code."'and fexamno='".$Exam_no."' and fretain='T' and fintass='T'";				
	//echo $count_id; die();
	}
	$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; 	
	//var_dump($obj_get_status); die();	
	if( $_GET["_search"]=='true')
	{			
	$SQL="select * from (select fcsubcode,fsubname,fssubname,fshortname,fsmaxmarks subject where fdegree = '".$Degree_code."'and fexamno='".$Exam_no."' and fretain='T' and fintass='T')a 
	where  $field_name $cond$value
	ORDER BY $sidx $sord LIMIT $start,$limit";			
	}	
	else
	{
	$SQL = " select fcsubcode as id,fcsubcode,fsubname,fssubname,fshortname,fsmaxmarks from 
	subject s inner join colldeg c on
	s.FDEGREE = c.FDEGREE 
	and s.fdegree = '{$Degree_code}' and s.fexamno='{$Exam_no}' 
	where  c.FCOLLCODE='{$college_code}'
	{$cat_cond} {$freezed_cond}
	ORDER BY $sidx $sord LIMIT $start , $limit"; 
	//echo $SQL; die();		  
	}

$result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error());

$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count;

$i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
	{ 
	$responce->rows[$i]['id']=$row[id]; //id
	$responce->rows[$i]['cell']=array($row[fcsubcode],$row[fsubname],
					$row[fssubname],$row[fshortname],$row[fsmaxmarks]); 
	$i++; 
	} 
	echo json_encode($responce); */
	
}

$i=0; while($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
	{ $responce->rows[$i]['id']=$row[id]; //id
	$responce->rows[$i]['cell']=array($row[fshortname]); 
	$i++; 
	} 
	echo json_encode($responce);
	
}

function StudentRegisterNoPopup($aobj_context)
{

session_start();
	$CollegeCode = $_SESSION['collcode'];
	$degree = $aobj_context->mobj_data["degree"]; 
	$module_name_for_save = $aobj_context->mobj_data["module_name_for_save"]; 
	
	include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
	$display_obj=new display_details_in_grid($aobj_context);
	$display_obj->table_cols=array('Fregno','Fname','FDoB');
//		if($module_name_for_save=="SaveAbsentEntrySubjectwiseQP" || $module_name_for_save=="candidate_list")
	if($module_name_for_save=="SaveAbsentEntrySubjectwiseQP" || $module_name_for_save=="candidate_list" || $module_name_for_save=="IdentifySubjFreshEx")
	{
		$display_obj->display_qry ="select distinct Fregno as id ,Fregno,Fname,FDoB from student  
		where fregno!=''  and   fcollcode= '{$CollegeCode}'  ";	
	}
	else
	{
		$display_obj->display_qry ="select s.Fregno as id ,s.Fregno,s.Fname,s.FDoB from 
		 student s 
		 inner join candsum c
		 on s.fcollcode=c.fcollcode
		 and s.fregno=c.fregno
		 where s.fcollcode= '{$CollegeCode}' 
		 and s.FDEGREE = '{$degree}'
		 and s.fregno!='' and ifnull(s.fdeleted,'F') <> 'T'";

}
		//var_dump($display_obj);
	$display_obj->DisplayDetailsInGrid();
}

//jijo updated
function RegnoDetailsPopup($aobj_context)
{
	session_start();
	$CollegeCode = $_SESSION['collcode'];
	$degree = $aobj_context->mobj_data["degree"]; 
	
	include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
		$display_obj=new display_details_in_grid($aobj_context);
		$display_obj->table_cols=array('Regno');
		 $display_obj->display_qry ="select internal_code as id ,FREGNO from 
									 mresult where FCOLLCODE= '{$CollegeCode}'";
			//echo $display_obj->display_qry; die();						
		$display_obj->DisplayDetailsInGrid();
		
}

function deleteUserSchemaDeiatls($aobj_context)
{
$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
		$main_src=$main_src_obj[1];		
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];

$lstr_qry = "delete  
			from s_user_schema 
			 where internal_code in (".$lstr_ids.")"; 
			  $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
			  
			$drop_table="drop table module_{$lstr_ids}";
			 $lobj_rs = $aobj_context->mobj_db->Execute($drop_table);
			 
			 $drop_table="drop table module_{$lstr_ids}_details";
			 $lobj_rs = $aobj_context->mobj_db->Execute($drop_table);
 
	
	
	 $root_file_name=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/Report_details/report_result_".$lstr_ids.".php";
	 $root_js_name=$_SERVER["DOCUMENT_ROOT"]."/".$main_src."/grid_display_files/module_".$lstr_ids.".js";
	
	   
	   if(file_exists($root_file_name))
	   unlink($root_file_name);
		   if(file_exists($root_js_name))
	   unlink($root_js_name); 
     
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}

function delete_user_schema_group_master_setup_details($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];

//to drop the Group user schema Tables
	$qry="select CONCAT('user_schema_',ms.INTERNAL_CODE,'_group_',msg.internal_code) as  group_table_name
					from s_user_schema_group msg inner join s_user_schema ms on ms.internal_code=msg.ref_s_user_schema_code
					where msg.internal_code=$lstr_ids";
					$lobj_rs = $aobj_context->mobj_db->GetRow($qry);
			
	$drop_qry="drop table IF EXISTS ". $lobj_rs['group_table_name'];
					$lobj_rs = $aobj_context->mobj_db->Execute($drop_qry);
	  
	   $lstr_qry = "delete  
			from s_user_schema_group 
			 where internal_code in (".$lstr_ids.")"; 
	//	echo $lstr_qry 
	$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
	
	$delete_eles="delete from s_user_schema_elements where ref_s_user_schema_group_code={$lstr_ids}";
		$lobj_rs = $aobj_context->mobj_db->Execute($delete_eles);
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}

$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); 
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count; 
	$lobj_rs = $aobj_context->mobj_db->GetAll($SQL);

$i=0; 
	while($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
	{ 
		$responce->rows[$i]['id']=$row[id]; 
		$responce->rows[$i]['cell']=array($row[grid_Schema_name],$row[grid_name],$row[grid_data_type],$row[grid_sequence],
		$row[grid_group_name],$row[grid_description],$row[grid_default_value],$row[grid_optional],$row[grid_ref_module_name],$row[grid_meta_type]); 
		$i++; 
	} 
	// return the formated data 
	echo $json->encode($responce); 
	// return the formated data 
	
}

function delete_user_schema_element_master_setup_details($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];	
				//to drop field in File
			$lstr_get_schema = "select ref_s_user_schema_code  
			from s_user_schema_elements 
			 where internal_code in (".$lstr_ids.")"; 
	 
	 $lobj_lstr_get_schema = $aobj_context->mobj_db->GetRow($lstr_get_schema);
	 $schema_id= $lobj_lstr_get_schema[ref_s_user_schema_code];
// to drop the multiple group field name if exstis			
 $drop_field="select CONCAT('user_schema_',sus.INTERNAL_CODE,'_group_',susg.internal_code) 
							as table_name,
							concat('u_',sus.internal_code,'_g_',susg.internal_code,'_ele_',suse.internal_code) as field_name
							from 
							s_user_schema_elements suse 
							inner join s_user_schema_group susg 
							on susg.internal_code=suse.ref_s_user_schema_group_code  
							inner join s_user_schema sus on sus.internal_code=susg.ref_s_user_schema_code
							where suse.internal_code=". $lstr_ids ." and multiple=1";
		$lobj_rs_drop_field = $aobj_context->mobj_db->GetRow($drop_field);
					if(count($lobj_rs_drop_field['table_name'])>0)
							{
							$table_count="show tables like '".$lobj_rs_drop_field['table_name']."'";
							$lobj_rs_table_count = $aobj_context->mobj_db->GetRow($table_count);
								if(count($lobj_rs_table_count)>0)
								{	
								foreach ($lobj_rs_table_count as $key=>$value)
								$alter_qr="alter table ". $value ." drop ".$lobj_rs_drop_field['field_name']   ;
							$lobj_rs_drop = $aobj_context->mobj_db->Execute($alter_qr); 
								}
							}
							
		$drop_meta="select CONCAT('module_',sus.INTERNAL_CODE)

as table_name,CONCAT('m_',sus.INTERNAL_CODE,'_ele_',suse.internal_code) as field_name
					from

s_user_schema_elements suse

inner join s_user_schema sus on sus.internal_code=suse.ref_s_user_schema_code

inner join s_ref_type s1 on s1.internal_code=suse.s_ref_type_meta

where suse.internal_code={$lstr_ids} and s1.value='Meta'";
			$lobj_drop_meta = $aobj_context->mobj_db->GetRow($drop_meta);	
			if(!empty($lobj_drop_meta['table_name']))
							{
							$table_count="show tables like '".$lobj_drop_meta['table_name']."'";
							$lobj_rs_table_count = $aobj_context->mobj_db->GetRow($table_count);
								if(count($lobj_rs_table_count)>0)
								{	
								foreach ($lobj_rs_table_count as $key=>$value)
								$alter_qr="alter table ". $value ." drop ".$lobj_drop_meta['field_name']   ;
							$lobj_rs_drop = $aobj_context->mobj_db->Execute($alter_qr); 
								}
							}			
					
		$lstr_qry = "delete  
			from s_user_schema_elements 
			 where internal_code in (".$lstr_ids.")"; 
		//echo $lstr_qry ;
	 $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
	   		
		
	 	require_once(dirname(__FILE__)."\create_file.php");
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
}
function getUserSchemaDetailsForRefrencedata($aobj_context)
{
include_once("/JSON.php");

//echo $lstr_ids;
$json = new Services_JSON();
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];
$page = $_GET['page'];
$module_id = $_GET['ref_module_code'];
if(!$sidx)
$sidx =1;

// to take th e parameters from Search field
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{
$field_name=$_GET['searchField'];
$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
$cond=$final_value[0];
$value=$final_value[1];
}
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{
$count_id="select count(*) as count from (select internal_code as id,
data1 as grid_field1,
data2 as grid_field2

from s_ref_data where ref_s_user_schema_code = $module_id)a where $field_name $cond$value";

}
else
{
$count_id="select count(*) as count
from s_ref_data where ref_s_user_schema_code = $module_id";
}
$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(isset($_GET['searchField']) && $_GET["_search"]=='true')
{

$SQL="select * from (select internal_code as id,
data1 as grid_field1,
data2 as grid_field2
from s_ref_data where ref_s_user_schema_code = $module_id )a where $field_name $cond$value
ORDER BY $sidx $sord LIMIT $start,$limit";
}
else
{
$SQL = "select internal_code as id,
data1 as grid_field1,
data2 as grid_field2
from s_ref_data where ref_s_user_schema_code = $module_id
ORDER BY $sidx $sord LIMIT $start , $limit";
// echo $SQL;
}
//echo $SQL;
//$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$lobj_rs = $aobj_context->mobj_db->GetAll($SQL);
foreach($lobj_rs as $key =>$value)
{
$responce->rows[$key]['id']=$value[id];
$responce->rows[$key]['cell']=array($value[grid_field1],$value[grid_field2]);
}
/* $i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$responce->rows[$i]['id']=$row[id];
$responce->rows[$i]['cell']=array($row[grid_module_name],$row[grid_field1],$row[grid_field2],$row[grid_field3],
$row[grid_field4],$row[grid_field5],$row[grid_tree_data] );
$i++;
} */
//var_dump($responce->rows);
echo $json->encode($responce);
}
function viewUserSchemaModuleDetails($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
include_once("/JSON.php");

//echo $lstr_ids;
$json = new Services_JSON();
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];
$page = $_GET['page'];

if(!$sidx)
$sidx =1;
$s_indx=explode("grid_",$sidx);
if(!empty($s_indx[1]))
$sidx =$s_indx[1];
 
$table_name=$_GET['table_name'];
$schema_ids=explode("_",$table_name);
$schema_id=$schema_ids[1];
// this field we are not using for main query display selection since we need to get the data from REference tables, we are mannualy doing the quey below
$table_field_name=stripcslashes($_GET['field_name']);
$details_array=$_GET['details_array'];

if($start <0)
$start = 0;
// the actual query for the grid data
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{

$SQL="select * from ( select internal_code as id,$table_field_name from  $table_name )a where $field_name $cond$value
ORDER BY $sidx $sord LIMIT $start,$limit";
 
}
else
{
$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000");
$aobj_context->mobj_db->execute("set @a:=0");
 
$select_ref_module_code="select GROUP_CONCAT(join_table_name SEPARATOR ' ') as qry from 
(select   @a:=@a+1,ref_module_code,
concat(' left join module_',ref_module_code, ' as module_',ref_module_code,'_',@a,' on module_',ref_module_code,'_',@a,'.internal_code =m_',ref_s_user_schema_code, '_ele_',internal_code) as join_table_name
from s_user_schema_elements
where ref_s_user_schema_code=$schema_id and is_multiple_group=0 and ref_module_code>0)j";
$obj_select_ref_module_code =  $aobj_context->mobj_db->GetRow($select_ref_module_code);
$join_qry=(count($obj_select_ref_module_code)>0)?$obj_select_ref_module_code[qry]:'';
				
			$get_display_cols="select GROUP_CONCAT(field_name) as field_name  from (select table_name,name,field_name as grid_field_name,
								if(ref_module_code=0,concat('module_',internal_code,'.',field_name),concat(\"concat(\",(field_id),\") as \",field_name)) as field_name
								,ref_module_code from 
								(select  s.internal_code, ref_module_code,concat('module_',s.internal_code) as table_name ,
								field_id,
								su.name,ifnull(multiple,0) as multiple,ifnull(ug.name,'0None') as group_name,concat('m_',s.internal_code,'_ele_',su.internal_code) as field_name from s_user_schema s inner join s_user_schema_elements su on 
								su.ref_s_user_schema_code=s.internal_code
								inner join s_ref_type t on t.internal_code=su.s_ref_type_meta
								left join s_user_schema_group ug on ug.internal_code=su.ref_s_user_schema_group_code
								left join module_meta_columns mmc on mmc.module_id=su.ref_module_code
								where s.internal_code={$schema_id} and t.value='Meta' order by ug.sequence,su.sequence,su.internal_code ) l 
								where   multiple=0 ) a ";
						 
			 
		$lobj_get_display_cols = $aobj_context->mobj_db->GetRow($get_display_cols);

$SQL = " select $table_name.internal_code as id,".$lobj_get_display_cols[field_name]."  from  $table_name  $join_qry
ORDER BY $sidx $sord LIMIT $start , $limit";
 //echo $SQL;
 $SQL1 = " select internal_code as id,$table_field_name from  $table_name  
ORDER BY $sidx $sord LIMIT $start , $limit"; 
}
//echo $SQL;
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count; 
$lobj_rs =$aobj_context->mobj_db->GetAll($SQL); 
  if((mysql_error()!=''))
 $lobj_rs =$aobj_context->mobj_db->GetAll($SQL1);  
 
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);
}	
function viewUserSchemaSrefDataDetails($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
include_once("/JSON.php");

//echo $lstr_ids;
$json = new Services_JSON();
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];
$page = $_GET['page'];
$search_by_user = trim($_GET['search_by_user']);
if(!empty($search_by_user))
{
$table_field_name=stripcslashes($_GET['field_name']);
	if(strpos($table_field_name,",")===false)
	{
	$search_by_user= " where grid_data1 like '%{$search_by_user}%' ";
	}
	else
	{
	$search_by_user= " where (grid_data1 like '%{$search_by_user}%' or  grid_data2 like '%{$search_by_user}%' or concat(grid_data2,'-',grid_data1) like '%{$search_by_user}%' or concat(grid_data1,'-',grid_data2) like '%{$search_by_user}%' ) ";
	}
}

if(!$sidx)
$sidx =1;
$table_name=$_GET['table_name'];
$table_field_name=stripcslashes($_GET['field_name']);
$details_array=$_GET['details_array'];

if($start <0)
$start = 0;
// the actual query for the grid data
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{

$SQL="select * from ( select internal_code as id,$table_field_name from  $table_name )a where $field_name $cond$value
ORDER BY $sidx $sord LIMIT $start,$limit";
 
 
}
else
{
$SQL = " select * from (select internal_code as id,$table_field_name from  $table_name ) a  $search_by_user  
ORDER BY $sidx $sord LIMIT $start , $limit";

}
//echo $SQL;
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count; 
$lobj_rs =$aobj_context->mobj_db->GetAll($SQL); 
 
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);
}	
function deleteUserSchemaModuleDetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];	 
			$table = $aobj_context->mobj_data["table_name"];
			$schema_code_obj=explode("_",$table);		
			$schema_code=$schema_code_obj[1];
 
		$lstr_del_meta_qry = "delete  
			from {$table} 
			 where internal_code in (".$lstr_ids.")"; 
		
	 $lobj_rs = $aobj_context->mobj_db->Execute($lstr_del_meta_qry);
	   
	  
	 $lstr_del_details_qry = "delete  
			from {$table}_details 
			 where ref_s_module_code in (".$lstr_ids.")"; 
		//echo  $lstr_del_details_qry;
	 $lobj_rs = $aobj_context->mobj_db->Execute($lstr_del_details_qry);
	 // delete from grup details
		 $lstr_del_group_details_qry="select concat('user_schema_',ref_s_user_schema_code,'_group_', ref_s_user_schema_group_code)
		 as group_table,
		ref_s_user_schema_group_code from s_user_schema_elements where ref_s_user_schema_code={$schema_code}
		and ref_s_user_schema_group_code>0 group by ref_s_user_schema_group_code";
      $obj_lstr_del_group_details_qry = $aobj_context->mobj_db->GetAll($lstr_del_group_details_qry);
		  if(count($obj_lstr_del_group_details_qry)>0)
		  {
			foreach($obj_lstr_del_group_details_qry as $key=>$value)
			{
			$delete_group="delete from ".$value["group_table"]." where ref_s_ref_data_code={$lstr_ids}";
			$lobj_delete_group = $aobj_context->mobj_db->Execute($delete_group);
			}
		  }
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}	
function deleteUserSchemaModuleGroupDetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$s_ref_data_code = $aobj_context->mobj_data["s_ref_data_code"];	 
			$table_name = $aobj_context->mobj_data["table_name"];
			$id = $aobj_context->mobj_data["id"];
			 
 
		$lstr_del_meta_qry = "delete  
			from {$table_name} 
			 where ref_s_ref_data_code in ({$s_ref_data_code}) and internal_code in({$id})"; 
		echo $lstr_del_meta_qry;
	 $lobj_rs = $aobj_context->mobj_db->Execute($lstr_del_meta_qry);
	   
	  
	  
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}	
function displayFormulaSetUpDetails($aobj_context)
  {
   include_once("/JSON.php"); 
	$json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	// to get the Componnet Name
	$get_table_name="select concat('module_',s.internal_code) as table_name,
				concat('m_',s.internal_code,'_ele_',su.internal_code) as field_name
				 from s_user_schema s inner join s_user_schema_elements su 
				on su.ref_s_user_schema_code=s.internal_code
				 where module_name='Salary Components' and su.name='Name'";
			 	$lobj_rs = $aobj_context->mobj_db->getRow($get_table_name);
			$table_name=$lobj_rs[table_name];	
			$display_name=$lobj_rs[field_name];

if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
		$field_name=$_GET['searchField'];
		$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
		$cond=$final_value[0];
		$value=$final_value[1];
	}	
if(!$sidx)
$sidx =1;
else
$indx=explode("grid_",$sidx);
$sidx=empty($indx[1])?'1':$indx[1];
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{		
		$count_id="select count(*) as count from (
		select formula_name as grid_formula_name,t.{$display_name} as grid_formula_component,formula as grid_formula_value 
			from formula_header fh inner join
			formula_details fd on fh.internal_code=fd.ref_formula_header_code 
			left join {$table_name} t on t.internal_code=ref_component_code)a 
			 where $field_name $cond$value";
		
	}
	else
	{
	$count_id="select count(*) as count from (
		select formula_name as grid_formula_name,t.{$display_name} as grid_formula_component,
			formula as grid_formula_value 
			 
			from formula_header fh inner join
			formula_details fd on fh.internal_code=fd.ref_formula_header_code 
			left join {$table_name} t on t.internal_code=ref_component_code)a ";
	}		 
			$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(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
			
			$SQL="select * from (select fd.internal_code as id,formula_name as grid_formula_name,
			t.{$display_name} as grid_formula_component,formula_for_ui as grid_formula_value 
			 
			from formula_header fh inner join
			formula_details fd on fh.internal_code=fd.ref_formula_header_code 
			left join {$table_name} t on t.internal_code=ref_component_code )
			a where  $field_name $cond$value
			ORDER BY $sidx $sord LIMIT $start,$limit";
	
	}
	else
	{
		$SQL = "select fd.internal_code as id,formula_name as grid_formula_name,t.{$display_name} as grid_formula_component,
			formula_for_ui as grid_formula_value 
			from formula_header fh inner join
			formula_details fd on fh.internal_code=fd.ref_formula_header_code 
			left join {$table_name} t on t.internal_code=ref_component_code
			 ORDER BY $sidx $sord LIMIT $start , $limit"; 
	}	  
		$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
		//$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); 
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count; 
	$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
	 foreach($lobj_rs as $key =>$value)
	 {
	 $responce->rows[$key]['id']=$value[id];
	 $responce->rows[$key]['cell']=array($value[grid_formula_name],$value[grid_formula_component],$value[grid_formula_value] );
	}
	
	// return the formated data 
	echo $json->encode($responce); 
}

function deleteFormulaSetUpDetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];

//to drop the Group user schema Tables
$get_header_id="select ref_formula_header_code from formula_details where internal_code={$lstr_ids}";
$lobj_get_header_id = $aobj_context->mobj_db->getRow($get_header_id);
$selct_count="select count(ref_formula_header_code) as count from formula_details
			where ref_formula_header_code={$lobj_get_header_id[ref_formula_header_code]}";
		$lobj_selct_count = $aobj_context->mobj_db->getRow($selct_count);
		 
if($lobj_selct_count[count]=='1')
{		
	$drop_qry_header="delete from formula_header where internal_code={$lobj_get_header_id[ref_formula_header_code]}";
					$lobj_rs = $aobj_context->mobj_db->Execute($drop_qry_header);
			
	$drop_qry_header_details="delete from formula_details where internal_code={$lstr_ids}";
					$lobj_rs = $aobj_context->mobj_db->Execute($drop_qry_header_details);
	  
}	   
else
{
		
	$drop_qry_header_details="delete from formula_details where internal_code={$lstr_ids}";
	$lobj_rs = $aobj_context->mobj_db->Execute($drop_qry_header_details);
	 echo $drop_qry_header_details;
}

if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}
function displayUserSetUpDetails($aobj_context)
  {
  include_once("/JSON.php"); 
	session_start();
	$college_code=$_SESSION['collcode'];
	$user_id= $_SESSION['user_id'];
	$user_type=$_SESSION['user_type'];
//echo 	$lstr_ids;		
	$json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	if(!$sidx) 
	$sidx =1; 
	$where_cond='';
	if(strtolower($user_type)==strtolower('System'))
	{
	$where_cond=" where t.value='Admin'";
	}
	else
	{
	$where_cond=" where college_code='{$college_code}' ";
	}
	// to take th e parameters from Search field
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
		$field_name=$_GET['searchField'];
		$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
		$cond=$final_value[0];
		$value=$final_value[1];
	}	
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{		
		$count_id="select count(*) as count  from 
		(select s.internal_code as id,college_code as grid_college_code,
			s.sysusr as grid_sysusr,
			s.sysusrkey as grid_sysusrkey,
			t.value as  grid_user_type,
			ifnull(s.real_name,'') as grid_real_name,
			ifnull(s.email_id,'') as grid_email_id
			from s_sysdb s inner join s_ref_type t on t.internal_code=s.user_type
			{$where_cond} and s.internal_code!={$user_id}
			)a 
			where $field_name $cond$value";
		
	}
	else
	{
	$count_id="	select count(*) as count
				from s_sysdb s  {$where_cond} and s.internal_code!={$user_id}
				";
	}	
			$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(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
			
		$SQL="select * from (select s.internal_code as id,college_code as grid_college_code,
					s.sysusr as grid_sysusr,
					s.sysusrkey as grid_sysusrkey,
					t.value as  grid_user_type,
					ifnull(s.real_name,'') as grid_real_name,
					ifnull(s.email_id,'') as grid_email_id
					 
					from s_sysdb s inner join s_ref_type t on t.internal_code=s.user_type
					{$where_cond} and s.internal_code!={$user_id}
					 )a where  $field_name $cond$value
			ORDER BY $sidx $sord LIMIT $start,$limit";
			
			
	}
	else
	{
	$SQL = "select s.internal_code as id,college_code  as grid_college_code,
			s.sysusr as grid_sysusr,
			s.sysusrkey as grid_sysusrkey,
			t.value as  grid_user_type,
			ifnull(s.real_name,'') as grid_real_name,
			ifnull(s.email_id,'') as grid_email_id
			 
			from s_sysdb s inner join s_ref_type t on t.internal_code=s.user_type
			{$where_cond} and s.internal_code!={$user_id}
			 
			
			 ORDER BY $sidx $sord LIMIT $start , $limit"; 
			// echo $SQL;  	
	}
 
	
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count; 
	$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
	 foreach($lobj_rs as $key =>$value)
	 {
	 $responce->rows[$key]['id']=$value[id];
	 $responce->rows[$key]['cell']=array($value[grid_college_code],$value[grid_sysusr],$value[grid_sysusrkey],$value[grid_user_type],
						 $value[grid_real_name],$value[grid_email_id]);
	}
	
	
	
	
	// return the formated data 
	echo $json->encode($responce); 
}

function deleteUserSetUpDetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];

$lstr_qry = "update   
			 s_sysdb  set FDELETED='T'
			 where internal_code in (".$lstr_ids.")"; 
		
	
	 $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
	 
     
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}	
function viewTransactionSeriesGrid($aobj_context)
  {
  include_once("/JSON.php"); 
 
//echo 	$lstr_ids;		
	$json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	if(!$sidx) 
	$sidx =1; 
	
	// to take th e parameters from Search field
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
		$field_name=$_GET['searchField'];
		$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
		$cond=$final_value[0];
		$value=$final_value[1];
	}	
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{		
		$count_id="select count(*) as count  from 
		(select tsp.internal_code as id,
						us.module_name as grid_ref_module_code,
						uss.name as grid_ref_module_element_code,
						series_name as grid_series_name,
						prefix as grid_prefix,
						starting_no as grid_starting_no,
						ending_no as grid_ending_no,
						last_no as grid_last_no,
						starting_date as grid_starting_date,
						ending_date as grid_ending_date
						from transaction_series_prefix tsp 
						inner join s_user_schema us on us.internal_code=ref_module_code
						inner join s_user_schema_elements uss on uss.internal_code=ref_module_element_code
						 )a 
			where $field_name $cond$value";
		
	}
	else
	{
	$count_id="select count(*) as count from
			transaction_series_prefix";
	}	
			$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(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
			
		$SQL="select * from (select tsp.internal_code as id,
						us.module_name as grid_ref_module_code,
						uss.name as grid_ref_module_element_code,
						series_name as grid_series_name,
						prefix as grid_prefix,
						starting_no as grid_starting_no,
						ending_no as grid_ending_no,
						last_no as grid_last_no,
						DATE_FORMAT(starting_date,'%d/%m/%Y') as grid_starting_date,
						DATE_FORMAT(ending_date,'%d/%m/%Y')  as grid_ending_date
						from transaction_series_prefix tsp 
						inner join s_user_schema us on us.internal_code=ref_module_code
						inner join s_user_schema_elements uss on uss.internal_code=ref_module_element_code
						  )a where  $field_name $cond$value
			ORDER BY $sidx $sord LIMIT $start,$limit";
			
			
	}
	else
	{
	$SQL = "select tsp.internal_code as id,
			us.module_name as grid_ref_module_code,
			uss.name as grid_ref_module_element_code,
			series_name as grid_series_name,
			prefix as grid_prefix,
			starting_no as grid_starting_no,
			ending_no as grid_ending_no,
			last_no as grid_last_no,
			DATE_FORMAT(starting_date,'%d/%m/%Y') as grid_starting_date,
			DATE_FORMAT(ending_date,'%d/%m/%Y')  as grid_ending_date
			from transaction_series_prefix tsp 
			inner join s_user_schema us on us.internal_code=ref_module_code
			inner join s_user_schema_elements uss on uss.internal_code=ref_module_element_code

ORDER BY $sidx $sord LIMIT $start , $limit"; 
			//echo $SQL;  	
	}
	//echo $SQL;
	
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count; 
	$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
	 foreach($lobj_rs as $key =>$value)
	 {
	 $responce->rows[$key]['id']=$value[id];
	 $responce->rows[$key]['cell']=array($value[grid_ref_module_code],$value[grid_ref_module_element_code],
										$value[grid_series_name],$value[grid_prefix],$value[grid_starting_no],
										$value[grid_ending_no],$value[grid_last_no],$value[grid_starting_date],$value[grid_ending_date]);
	}
	
	
	
	
	// return the formated data 
	echo $json->encode($responce); 
}	
function deleteTransactionSeries($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];

$lstr_qry = "delete  
			from transaction_series_prefix 
			 where internal_code in (".$lstr_ids.")"; 
		$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); 	 
		  if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
}
function viewUserSchemaModuleGroupDetails($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
include_once("/JSON.php");

//echo $lstr_ids;
$json = new Services_JSON();
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];
$page = $_GET['page'];
$s_ref_data_code=$_GET['s_ref_data_code'];
if(!$sidx)
$sidx =1;
$s_indx=explode("grid_",$sidx);
if(!empty($s_indx[1]))
$sidx =$s_indx[1];
 
$table_name=$_GET['table_name'];
$schema_ids=explode("_",$table_name);
$schema_id=$schema_ids[2]; 
$group_id=$schema_ids[4];

// this field we are not using for main query display selection since we need to get the data from REference tables, we are mannualy doing the quey below
$table_field_name=stripcslashes($_GET['field_name']);
$details_array=$_GET['details_array'];

// to take th e parameters from Search field
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{
$field_name_value=explode('grid_',$_GET['searchField']);
$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
$cond=$final_value[0];
$search_value=$final_value[1];
}
$pos = strpos($_GET['searchField'], "grid_d");
if ($pos === false) {
$field_name=$field_name_value[1];}
else 
{ $field_name=$_GET['searchField'];}
			$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000");
						$select_ref_module_code="select GROUP_CONCAT(join_table_name SEPARATOR ' ') as qry from 
						(select  ref_module_code,concat('u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as field_id,
								concat(' left join module_',ref_module_code, ' on module_',ref_module_code,'.internal_code =u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as join_table_name
								from s_user_schema_elements
									where ref_s_user_schema_code={$schema_id} and ref_s_user_schema_group_code={$group_id} and ref_module_code>0)j";
							$obj_select_ref_module_code =  $aobj_context->mobj_db->GetRow($select_ref_module_code);
							 $join_qry=(count($obj_select_ref_module_code)>0)?$obj_select_ref_module_code[qry]:'';
							// to form the fields   dynamically 
							$select_field_ids="select concat('u_',{$schema_id},'_g_',{$group_id},'_ele_',internal_code) as field_id,name,
							ref_module_code from s_user_schema_elements	where ref_s_user_schema_code={$schema_id} and ref_s_user_schema_group_code={$group_id} order by internal_code";
							$lobj_select_field_ids =  $aobj_context->mobj_db->GetAll($select_field_ids);
							
							foreach($lobj_select_field_ids as $key =>$value)
							{
								if($value[ref_module_code]=='0')
								{
								$fields.=$value[field_id].",";
								$sum_field.="sum(".$value[field_id].") as ".$value[field_id].",";
								}
								else
								{
								$aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=10000");
								$qry=" select concat('module_',schema_id) as table_name,GROUP_CONCAT(name SEPARATOR '-ele-') as name,
									GROUP_CONCAT(field_name separator ',\'-\',') as field_name from 
									(select * from 
									(select s.internal_code as schema_id,su.name,ifnull(multiple,0) as multiple,ifnull(ug.name,'0None') as group_name,concat('m_',s.internal_code,'_ele_',su.internal_code) as field_name from s_user_schema s inner join s_user_schema_elements su on 
									su.ref_s_user_schema_code=s.internal_code
									inner join s_ref_type t on t.internal_code=su.s_ref_type_meta
									left join s_user_schema_group ug on ug.internal_code=su.ref_s_user_schema_group_code
									where s.internal_code=$value[ref_module_code] and t.value='Meta' order by ug.sequence,su.sequence,su.internal_code ) l where   multiple=0 limit 2) a group by schema_id"; 
															 
									$lobj_rs = $aobj_context->mobj_db->GetRow($qry);
								$fields.="concat(".$lobj_rs[field_name].") as $value[field_id]".",";
								$sum_field.="'' as ".$value[field_id].",";
								}
							}
							$fields=substr($fields,0,strlen($fields)-1);
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{
$count_id="select count(*) as count from 
( select $table_name.internal_code as id,$fields from 	$table_name  $join_qry  
							 where ref_s_ref_data_code= $s_ref_data_code )a where $field_name $cond$search_value";
 
}
else
{
$count_id="select count(*) as count from $table_name where ref_s_ref_data_code=$s_ref_data_code";
}
$result = mysql_query($count_id);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];

if($start <0)
$start = 0;

// the actual query for the grid data
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{

$SQL="select * from ( select $table_name.internal_code as id,$fields from 	$table_name  $join_qry  
							 where ref_s_ref_data_code= $s_ref_data_code )a where $field_name $cond$search_value
ORDER BY $sidx $sord LIMIT $start,$limit";
 
}
else
{

$SQL="select $table_name.internal_code as id,$fields from 	$table_name  $join_qry  
							 where ref_s_ref_data_code= $s_ref_data_code ORDER BY $sidx $sord LIMIT $start , $limit";
							// echo $SQL;
							 
//echo $SQL;
 $SQL1 = " select internal_code as id,$table_field_name from  $table_name  where ref_s_ref_data_code=$s_ref_data_code
ORDER BY $sidx $sord LIMIT $start , $limit"; 
}
  //echo $SQL;
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count; 
$lobj_rs =$aobj_context->mobj_db->GetAll($SQL); 
  if((mysql_error()!=''))
 $lobj_rs =$aobj_context->mobj_db->GetAll($SQL1);  
 
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);
}
function showGridForFormulaMapping($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
include_once("/JSON.php");

//echo $lstr_ids;
$json = new Services_JSON();
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];
$page = $_GET['page'];
$module_id = trim($_GET['module_id']);
$id = trim($_GET['id']);
$search_by_user = trim($_GET['search_by_user_map']);
$qry="select a.*,meta_cols.field_id as field_name,ifnull(field_name,a.name) as name,ifnull(table_name,0) as table_name from 
			(select   s.internal_code as schema_id,t.value as meta, su.internal_code,name ,t1.value as data_type,su.ref_module_code,db_field  from
				s_user_schema s inner join s_user_schema_elements su on 
				su.ref_s_user_schema_code=s.internal_code
				inner join s_ref_type t on t.internal_code=su.s_ref_type_meta
				inner join s_ref_type t1 on t1.internal_code=su.data_type
				where  module_name='Employee'  and  is_multiple_group=0  and su.internal_code={$id}
				and ((
				t1.value in('List Of Values','Reference Data')) or (t.value='meta' and is_unique=1))) a
			left join module_meta_columns meta_cols on meta_cols.module_id=ref_module_code"; 
		//echo $qry;
		$get_source_details = $aobj_context->mobj_db->GetRow($qry);
if($get_source_details["ref_module_code"]<>0)
$table_name="module_".$module_id;
else if ($get_source_details["meta"]=='Meta')
$table_name="module_".$get_source_details["schema_id"];
else if ($get_source_details["meta"]=='User')
$table_name="module_".$get_source_details["schema_id"]."_details";
 
if(!empty($search_by_user))
{
$table_field_name=stripcslashes($_GET['field_name']);
	if(strpos($table_field_name,",")===false)
	{
	$search_by_user= " where grid_data1 like '%{$search_by_user}%' ";
	}
	else
	{
	$search_by_user= " where (grid_data1 like '%{$search_by_user}%' or  grid_data2 like '%{$search_by_user}%' or concat(grid_data2,'-',grid_data1) like '%{$search_by_user}%' or concat(grid_data1,'-',grid_data2) like '%{$search_by_user}%' ) ";
	}
}

if(!$sidx)
$sidx =1;
 
$table_field_name=stripcslashes($_GET['field_name']);
$details_array=$_GET['details_array'];

}
else
{
	if($get_source_details["ref_module_code"]<>0)
	 {
	$count_id = " select count(*) as count from (select internal_code as id,$table_field_name from  $table_name ) a   $search_by_user
	 ";
	}
	else if ($get_source_details["meta"]=='Meta')
	{
	$count_id = " select count(*) as count from (select internal_code as id,  ".$get_source_details["db_field"].  "  as grid_data1,''
	 as grid_data2 from  $table_name group by grid_data1) a   $search_by_user
	 ";
	 
	}
	else if ($get_source_details["meta"]=='User')
	{
	$count_id = " select count(*) as count from (select    value  as grid_data1,'' as grid_data2,internal_code as id
	 from  $table_name  where ref_s_user_schema_elements_code={$id} group by value ) a  $search_by_user  
	 ";
	}
 
}
//echo $count_id;
$result = mysql_query($count_id);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];

if($start <0)
$start = 0;
// the actual query for the grid data
if(isset($_GET['searchField']) && $_GET["_search"]=='true')
{

if($get_source_details["ref_module_code"]<>0)
 {
$SQL = " select * from (select internal_code as id,$table_field_name from  $table_name ) a  where $field_name $cond$value
ORDER BY $sidx $sord LIMIT $start , $limit";
}
else if ($get_source_details["meta"]=='Meta')
{
$SQL = " select * from (select internal_code as id,  ".$get_source_details["db_field"].  "  as grid_data1,''
 as grid_data2 from  $table_name group by grid_data1) a  where $field_name $cond$value 
ORDER BY $sidx $sord LIMIT $start , $limit";
 
}
else if ($get_source_details["meta"]=='User')
{
$SQL = " select * from (select    value  as grid_data1,'' as grid_data2,internal_code as id
 from  $table_name  where ref_s_user_schema_elements_code={$id} group by value ) a where $field_name $cond$value  
ORDER BY $sidx $sord LIMIT $start , $limit";
}
 
}
else
{
 if($get_source_details["ref_module_code"]<>0)
 {
$SQL = " select * from (select internal_code as id,$table_field_name from  $table_name ) a  $search_by_user  
ORDER BY $sidx $sord LIMIT $start , $limit";
}
else if ($get_source_details["meta"]=='Meta')
{
$SQL = " select * from (select internal_code as id,  ".$get_source_details["db_field"].  "  as grid_data1,''
 as grid_data2 from  $table_name group by grid_data1) a  $search_by_user  
ORDER BY $sidx $sord LIMIT $start , $limit";
 
}
else if ($get_source_details["meta"]=='User')
{
$SQL = " select * from (select    value  as grid_data1,'' as grid_data2,internal_code as id
 from  $table_name  where ref_s_user_schema_elements_code={$id} group by value ) a  $search_by_user  
ORDER BY $sidx $sord LIMIT $start , $limit";
}

}
 
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count; 
$lobj_rs =$aobj_context->mobj_db->GetAll($SQL); 
 
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);
}
function displayFormulaMappingDetails($aobj_context)
  {
   include_once("/JSON.php"); 
	$json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
		$field_name=$_GET['searchField'];
		$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
		$cond=$final_value[0];
		$value=$final_value[1];
	}	
	if(!$sidx) 
	$sidx =1; 
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{		
		$count_id="select count(*) as count from (select map_at as grid_map_at ,map_value ,
				formula_name as grid_formula_name 
				from emp_formula_map efm inner join formula_header fh 
				 on efm.ref_formula_code=fh.internal_code
				left join module_meta_columns mtc on mtc.module_id=ref_module_code)a 
			 where $field_name $cond$value";
		
	}
	else
	{
	$count_id="select count(*) as count from (select map_at as grid_map_at ,map_value  ,
				formula_name as grid_formula_name 
				from emp_formula_map efm inner join formula_header fh 
				 on efm.ref_formula_code=fh.internal_code
				left join module_meta_columns mtc on mtc.module_id=ref_module_code)a ";
	}		 
			$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(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
			
			$SQL="select * from (select efm.internal_code  as id,map_at as grid_map_at ,map_value as grid_map_value,
					formula_name as grid_formula_name 
					from emp_formula_map efm inner join formula_header fh 
					 on efm.ref_formula_code=fh.internal_code
					left join module_meta_columns mtc on mtc.module_id=ref_module_code )
			a where  $field_name $cond$value
			ORDER BY $sidx $sord LIMIT $start,$limit";
	
	}
	else
	{
		$SQL = "select efm.internal_code  as id,map_at as grid_map_at ,map_value as grid_map_value,
				formula_name as grid_formula_name 
				from emp_formula_map efm inner join formula_header fh 
				 on efm.ref_formula_code=fh.internal_code
				left join module_meta_columns mtc on mtc.module_id=ref_module_code
			 ORDER BY $sidx $sord LIMIT $start , $limit"; 
	}	 // echo 	$SQL ;
		$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
		//$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); 
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count; 
	$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
	 foreach($lobj_rs as $key =>$value)
	 {
	 $responce->rows[$key]['id']=$value[id];
	 $responce->rows[$key]['cell']=array($value[grid_map_at],$value[grid_map_value],$value[grid_formula_name] );
	}
	
	// return the formated data 
	echo $json->encode($responce); 
}

function deleteFormulaMappingDetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];

$delete_eles="delete from emp_formula_map where internal_code in ( {$lstr_ids} )";
		$lobj_rs = $aobj_context->mobj_db->Execute($delete_eles);
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}
function showGridForSalarySetup($aobj_context)
  {
   include_once("/JSON.php"); 
	$json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	$search_by_user = trim($_GET['search_by_user_map']);
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
		$field_name=$_GET['searchField'];
		$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
		$cond=$final_value[0];
		$value=$final_value[1];
	}	
	if(!$sidx) 
	$sidx =1; 
	if(!empty($search_by_user))
{
$table_field_name=stripcslashes($_GET['field_name']);
	if(strpos($table_field_name,",")===false)
	{
	$search_by_user= " where grid_data1 like '%{$search_by_user}%' ";
	}
	else
	{
	$search_by_user= " where (grid_data1 like '%{$search_by_user}%' or  grid_data2 like '%{$search_by_user}%' or concat(grid_data2,'-',grid_data1) like '%{$search_by_user}%' or concat(grid_data1,'-',grid_data2) like '%{$search_by_user}%' ) ";
	}
}

function deleteFormulaSalarySetup($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];

$delete_eles="delete from emp_formula_map where internal_code in ( {$lstr_ids} )";
		$lobj_rs = $aobj_context->mobj_db->Execute($delete_eles);
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}
function displaySalarySetupHeader($aobj_context)
  {
   include_once("/JSON.php"); 
	$json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	$ref_emp_code = $_GET['emp_id'];
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
		$field_name=$_GET['searchField'];
		$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
		$cond=$final_value[0];
		$value=$final_value[1];
	}	
	if(!$sidx) 
	$sidx =1; 
		$check_type="select * from 
				(select concat('module_',ref_s_user_schema_code) as table_name,
									concat('m_',ref_s_user_schema_code,'_ele_',us.internal_code) as field_name
									from s_user_schema_elements us 
									inner join s_user_schema s on s.internal_code=ref_s_user_schema_code
									where module_name='Salary Components'
									and name in('name','Type')  order by name)a
				union

select concat('module_',ref_s_user_schema_code) as table_name,
									concat('m_',ref_s_user_schema_code,'_ele_',us.internal_code) as field_name
									from s_user_schema_elements us 
									inner join s_user_schema s on s.internal_code=ref_s_user_schema_code
									where module_name='Component Type'
									and name in('Component type')";
				
				 	$lobj_check_type = $aobj_context->mobj_db->GetAll($check_type);	
					$get_comp_qry="(select c.internal_code as ref_component_code,{$lobj_check_type[0][field_name]} as component,{$lobj_check_type[2][field_name]} as type
					from {$lobj_check_type[0][table_name]} c inner join {$lobj_check_type[2][table_name]} d on 
					d.internal_code={$lobj_check_type [1][field_name]} )";
					
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{		
		$count_id="select count(*) as count from (select ssh.internal_code as id,component as grid_ref_source_component,
				source_value as grid_source_value,DATE_FORMAT(effective_date,'%d/%m/%Y') as effective_date
				from salary_setup_header ssh inner join 
				$get_comp_qry a on a.ref_component_code=ssh.ref_source_component
				where  ref_emp_code=$ref_emp_code)a 
			 where $field_name $cond$value";
		
	}
	else
	{
	$count_id="select count(*) as count from (select ssh.internal_code as id,component as grid_ref_source_component,
				source_value as grid_source_value,DATE_FORMAT(effective_date,'%d/%m/%Y') as effective_date
				from salary_setup_header ssh inner join 
				$get_comp_qry a on a.ref_component_code=ssh.ref_source_component
				where  ref_emp_code=$ref_emp_code )a ";
	}		 
			$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(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
			
			$SQL="select * from (select ssh.internal_code as id,component as grid_ref_source_component,
				source_value as grid_source_value,DATE_FORMAT(effective_date,'%d/%m/%Y') as effective_date
				from salary_setup_header ssh inner join 
				$get_comp_qry a on a.ref_component_code=ssh.ref_source_component 
				where  ref_emp_code=$ref_emp_code)
			a where  $field_name $cond$value
			ORDER BY $sidx $sord LIMIT $start,$limit";
	
	}
	else
	{
		$SQL = " select ssh.internal_code as id,component as grid_ref_source_component,
				source_value as grid_source_value,DATE_FORMAT(effective_date,'%d/%m/%Y') as effective_date
				from salary_setup_header ssh inner join 
				$get_comp_qry a on a.ref_component_code=ssh.ref_source_component
				where  ref_emp_code=$ref_emp_code
			 ORDER BY $sidx $sord LIMIT $start , $limit"; 
	}	 
	//echo $SQL;
		$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
		//$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); 
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count; 
	$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
	 foreach($lobj_rs as $key =>$value)
	 {
	 $responce->rows[$key]['id']=$value[id];
	 $responce->rows[$key]['cell']=array($value[grid_ref_source_component],$value[grid_source_value],$value[effective_date] );
	}
	
	// return the formated data 
	echo $json->encode($responce); 
}
function 	deleteSalarySetupHeader($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];

$delete_eles="delete from salary_setup_header where internal_code in ( {$lstr_ids} )";
		$lobj_rs = $aobj_context->mobj_db->Execute($delete_eles);
		$delete_details="delete from salary_setup_result where ref_salary_setup_header_code in ( {$lstr_ids} )";
		$lobj_rs = $aobj_context->mobj_db->Execute($delete_details);
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}	
function showEmployeeGridForIncometaxMaster($aobj_context)
  {
   include_once("/JSON.php"); 
	$json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	$search_by_user = trim($_GET['search_by_user_map']);
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
		$field_name=$_GET['searchField'];
		$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
		$cond=$final_value[0];
		$value=$final_value[1];
	}	
	if(!$sidx) 
	$sidx =1; 
	if(!empty($search_by_user))
{
$table_field_name=stripcslashes($_GET['field_name']);
	if(strpos($table_field_name,",")===false)
	{
	$search_by_user= " where grid_data1 like '%{$search_by_user}%' ";
	}
	else
	{
	$search_by_user= " where (grid_data1 like '%{$search_by_user}%' or  grid_data2 like '%{$search_by_user}%' or concat(grid_data2,'-',grid_data1) like '%{$search_by_user}%' or concat(grid_data1,'-',grid_data2) like '%{$search_by_user}%' ) ";
	}
}

/* $get_table_name_ele_name="select concat('module_',sus.internal_code) as table_name,db_field from s_user_schema sus 
			inner join s_user_schema_elements suse on suse.ref_s_user_schema_code=sus.internal_code
			where module_name='Employee' and name in('Emp Code','Name');"; */
		$get_table_name_ele_name="select table_name,field_name1,field_id1,field_name2,field_id2 from module_meta_columns
				where module_name='Employee'" ;
			
			$lobj_get_table_name_ele_name = $aobj_context->mobj_db->GetRow($get_table_name_ele_name); 
			 if($lobj_get_table_name_ele_name[field_id2]=='')
			{
			 
				$field_id2="' '";
			}
			else
			$field_id2=$lobj_get_table_name_ele_name[field_id2];
			
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{		
		$count_id="select count(*) as count from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1,
				".$field_id2." as grid_data2 from
				".$lobj_get_table_name_ele_name[table_name].") a 
			 where $field_name $cond$value";
		
	}
	else
	{
	$count_id="select count(*) as count from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1,
				".$field_id2." as grid_data2 from
				".$lobj_get_table_name_ele_name[table_name].") a $search_by_user";
	}		 
			$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(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
			
			$SQL="select * from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1,
				 ".$field_id2."  as grid_data2 from
				".$lobj_get_table_name_ele_name[table_name].")
			a where  $field_name $cond$value
			ORDER BY $sidx $sord LIMIT $start,$limit";	
	}
	else
	{
		$SQL = "select * from (select internal_code as id,".$lobj_get_table_name_ele_name[field_id1]." as grid_data1,
		 ". $field_id2."  as grid_data2 from
		".$lobj_get_table_name_ele_name[table_name]."   
			 ORDER BY $sidx $sord LIMIT $start , $limit ) a $search_by_user"; 
	}	    
	   
		$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
		//$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); 
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count; 
	$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
	 foreach($lobj_rs as $key =>$value)
	 {
	 $responce->rows[$key]['id']=$value[id];
	 $responce->rows[$key]['cell']=array($value[ grid_data1],$value[grid_data2]  );
	}
	
	// return the formated data 
	echo $json->encode($responce); 
}
//module setup	
function display_module_setup_grid($aobj_context)
{
   include_once("/JSON.php"); 
	$json = new Services_JSON(); 
	$limit = $_GET['rows']; 
	$sidx = $_GET['sidx']; 
	$sord = $_GET['sord']; 
	$page = $_GET['page'];
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
		$field_name=$_GET['searchField'];
		$final_value=getsearchcondition($_GET['searchOper'],$_GET['searchString']);
		$cond=$final_value[0];
		$value=$final_value[1];
	}	
	if(!$sidx) 
	$sidx =1; 
	if(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{		
		$count_id="select count(*) as count from(
                   select Code as id,Code as grid_m_code,Name as grid_m_name,FMODULE as grid_module_code,Value as grid_module_value
                   from markentrycodition)a 
			       where $field_name $cond$value";
		
	}
	else
	{
	$count_id="select count(*) as count
			 from markentrycodition";
	}		 
			$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(isset($_GET['searchField']) && $_GET["_search"]=='true')
	{
			
			$SQL="select * from (select Code as id,Code as grid_m_code,Name as grid_m_name,FMODULE as grid_module_code,Value as grid_module_value
                   from markentrycodition)a 
			       where $field_name $cond$value 
			       ORDER BY $sidx $sord LIMIT $start,$limit";
	
	}
	else
	{
		$SQL = "select Code as id,Code as grid_m_code,Name as grid_m_name,FMODULE as grid_module_code,Value as grid_module_value
                   from markentrycodition
			 ORDER BY $sidx $sord LIMIT $start , $limit"; 
	}	//echo 	$SQL ;
		$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
		//$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error()); 
	
	$responce->page = $page; 
	$responce->total = $total_pages; 
	$responce->records = $count; 
	$lobj_rs = $aobj_context->mobj_db->GetAll($SQL); 
	 foreach($lobj_rs as $key =>$value)
	 {
	 $responce->rows[$key]['id']=$value[id];
	 $responce->rows[$key]['cell']=array($value[grid_m_code],$value[grid_m_name],$value[grid_module_code],$value[grid_module_value]);
	}
	
	// return the formated data 
	echo $json->encode($responce); 
}		
function delete_module_setup_grid($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$lstr_ids = $aobj_context->mobj_data["id"];	 	
	  
	   $lstr_qry = "delete  
					from markentrycodition 
					where Code in (".$lstr_ids.")"; 
	//	echo $lstr_qry 
	$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
        if($lobj_rs) 
		{
		$rdata="Deleted Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"); 
		return 	$rdata;
		}
		 else
		{	$rdata="Deletion Failed";
            echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure");
			return 	$rdata;
		}
	
}

//JIJO UPDAED ON 01/08/2011.
function QpPopup($aobj_context)
{	
	session_start();
	$college_code = $_SESSION['collcode'];	
	include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
		$display_obj=new display_details_in_grid($aobj_context);
		$display_obj->table_cols=array('FQPCODE','QPSUBJECT','QPMAXMARK');
		$display_obj->display_qry = "SELECT FQPCODE as id,FQPCODE,FSUBNAME as QPSUBJECT,FMAXMARKS  as QPMAXMARK
										FROM masqp	  
										where 1=1"; 
//echo $display_obj->display_qry; die();										
		$display_obj->DisplayDetailsInGrid();
	 
}
function openDeptDetailsPopup($aobj_context)
{	
	session_start();
	$college_code = $_SESSION['collcode'];	
	include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
		$display_obj=new display_details_in_grid($aobj_context);
		$display_obj->table_cols=array('FDEPTCODE','FDEPTNAME');
		$display_obj->display_qry = "SELECT FDEPTCODE as id,FDEPTCODE,FDEPTNAME
										FROM masdept	  
										where 1=1"; 
//echo $display_obj->display_qry; die();										
		$display_obj->DisplayDetailsInGrid();
	 
}function openDesDetailsPopup($aobj_context)
{	
	session_start();
	$college_code = $_SESSION['collcode'];	
	include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
		$display_obj=new display_details_in_grid($aobj_context);
		$display_obj->table_cols=array('FDEGNCODE','FDEGNDESC');
		$display_obj->display_qry = "SELECT FDEGNCODE as id,FDEGNCODE,FDEGNDESC
										FROM masdegn	  
										where 1=1"; 
//echo $display_obj->display_qry; die();										
		$display_obj->DisplayDetailsInGrid();
	 
}
function OpenQpSubjectPopup($aobj_context)
{	
	session_start();
	$college_code = $_SESSION['collcode'];	
	include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
		$display_obj=new display_details_in_grid($aobj_context);
		$display_obj->table_cols=array('FQPCODE','FSUBCODE','FSSUBNAME');
		$display_obj->display_qry = "SELECT TRIM(FQPCODE) AS id,TRIM(FQPCODE) AS FQPCODE,FSUBNAME AS FSUBCODE,FSSUBNAME
									from subject
									where TRIM(FQPCODE)<>'' 
									and FTHEORY='T'
									and FINTASS<>'T'"; 
									
//echo $display_obj->display_qry; 										
		$display_obj->DisplayDetailsInGrid();
	 
}
function OpenStudSectionPopup($aobj_context)
{	
	session_start();
	$college_code = $_SESSION['collcode'];	
	$degree_code=$aobj_context->mobj_data["degCode"];
	$exam_no=$aobj_context->mobj_data['examNo'];
	
	include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
	$display_obj=new display_details_in_grid($aobj_context);
	$display_obj->table_cols=array('FSECTION');
	$display_obj->display_qry = " SELECT distinct  FSECTION ,FSECTION as id from student where FCOLLCODE='{$college_code}' and 
								FDEGREE='{$degree_code}' and FEXAMNO='{$exam_no}' and FSECTION IS NOT NULL and FSECTION <>'' UNION ALL Select 'All' as FSECTION ,'All' as id"; 										
	//var_dump($display_obj);
	$display_obj->DisplayDetailsInGrid();
	 
}
?>

${this.title}

Code Editor : display_details_in_grid22.php