Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
CIEAttendanceNotEligible.php	3.28 KB	-rw-rw-r--
CIEpendingList.php	5.85 KB	-rw-rw-r--
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
DisplayPrintApplication_ru.php	65.63 KB	-rw-rw-r--
ECHblk.php	14.61 KB	-rwxr-xr-x
ECHblk_15042021.php	11.68 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	30.6 KB	-rw-rw-r--
MarkEntry-Setup_bf_gcg.php	22.89 KB	-rwxr-xr-x
MarkEntry-Setupx.php	30.61 KB	-rwxr-xr-x
SelectSubjType.php	3.05 KB	-rw-rw-r--
SubjectType.php	3.62 KB	-rw-rw-r--
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
UpdateCollDet.php	2.03 KB	-rwxr-xr-x
absentAndMalReportPdf.php	8.25 KB	-rw-rw-r--
absentEntryYearModewise.php	991 B	-rw-rw-r--
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	11.36 KB	-rwxr-xr-x
ack_adm_application.php	103.36 KB	-rwxr-xr-x
ack_adm_application.php.orig	58.73 KB	-rwxr-xr-x
ack_admentry_application.php	59.63 KB	-rwxr-xr-x
ack_exam_app_form.php	20.27 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.71 KB	-rwxr-xr-x
ack_report.php	3.69 KB	-rwxr-xr-x
ack_rv_rt_application.php	9.34 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
adm_delete_data.php	5.58 KB	-rwxr-xr-x
admapprove.php	10.33 KB	-rwxr-xr-x
admapprove_kus.php	9.28 KB	-rwxr-xr-x
admissionHallTicket.php	4.43 KB	-rw-r--r--
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	5.06 KB	-rwxr-xr-x
admlist.php	13.87 KB	-rwxr-xr-x
admstuddate.php	6.06 KB	-rwxr-xr-x
admuploadexsheet.php	20.48 KB	-rwxr-xr-x
affliation_fee.php	5.04 KB	-rwxrwxrwx
approve.php	41.53 KB	-rwxr-xr-x
approve_kus.php	24.12 KB	-rwxr-xr-x
assignUserMenu.php	13.66 KB	-rw-rw-r--
attCisshortList_sjbit.php	11.91 KB	-rw-r--r--
attEntTeachWise.php	2.07 KB	-rw-rw-r--
attEntryDaywise.php	26.9 KB	-rw-rw-r--
attTeachSum.php	3.63 KB	-rw-r--r--
attendEntry.php	5.32 KB	-rw-rw-r--
attendance.php	17.09 KB	-rwxr-xr-x
attendanceReportForm.php	6.36 KB	-rw-rw-r--
attendance_freez.php	8.51 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendanceentrydaywise.php	11.36 KB	-rw-r--r--
attendenceshort.php	7.58 KB	-rw-rw-r--
attshort.php	6.29 KB	-rwxr-xr-x
atttechblp.php	2.48 KB	-rw-r--r--
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.php	4.12 KB	-rwxr-xr-x
backup_1.php	7.85 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
backupold.php	2.73 KB	-rwxr-xr-x
bill_details.php	14.21 KB	-rw-rw-r--
board.php	4 KB	-rwxr-xr-x
bundle_dispatch.php	3.2 KB	-rwxr-xr-x
bundle_rec_ack.php	4.67 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
candidate-entry.php	50.68 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
challan_entries.php	15.05 KB	-rwxr-xr-x
challan_preparation.php	11.29 KB	-rwxr-xr-x
changeDegree.php	1.56 KB	-rwxr-xr-x
changeMobile.php	2.13 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
cntDeclaration.php	4.23 KB	-rwxr-xr-x
coll_exam_app_form.php	3.29 KB	-rwxr-xr-x
collbankdet.php	1.9 KB	-rwxr-xr-x
colldesp_ack.php	4.03 KB	-rw-rw-r--
college.php	5.39 KB	-rwxr-xr-x
college_approve.php	5.59 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
collegewisedownload.php	9.46 KB	-rw-rw-r--
colltransfer.php	6.83 KB	-rw-rw-r--
connect.php	2.58 KB	-rwxr-xr-x
convdet.php	8.02 KB	-rwxr-xr-x
convo.php	8.14 KB	-rw-rw-r--
copoMarksList.php	1.27 KB	-rw-rw-r--
copomarksentry.php	10.46 KB	-rw-r--r--
copomarksexternal.php	23.05 KB	-rw-r--r--
coporeport.php	4.56 KB	-rw-r--r--
courserep.php	1.68 KB	-rw-r--r--
coutput.php	1.84 KB	-rwxr-xr-x
createAdmission.php	14.91 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_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
createattclass.php	6.99 KB	-rw-rw-r--
createclassattend.php	22.03 KB	-rw-r--r--
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	6.67 KB	-rwxr-xr-x
degree.php	8.28 KB	-rwxr-xr-x
degree_SujectReport.php	893 B	-rw-rw-r--
degstudymat.php	6.51 KB	-rwxr-xr-x
degstudymatdet.php	6.27 KB	-rwxr-xr-x
degwiseIAreport.php	2.95 KB	-rw-rw-r--
display_details_in_grid.php	107.2 KB	-rw-rw-r--
display_details_in_grid_bf_231...	111.76 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.72 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
doc_verify.php	7.52 KB	-rwxr-xr-x
download_misc_files.php	5.19 KB	-rwxr-xr-x
download_misc_files_bcu_comm.p...	4.19 KB	-rwxr-xr-x
download_photo.php	35.98 KB	-rwxr-xr-x
download_photo_pgadm_photos.ph...	4.73 KB	-rw-rw-r--
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
editstddet.php	7.01 KB	-rw-rw-r--
enableStudReg.php	7.65 KB	-rwxr-xr-x
entregupd.php	1.91 KB	-rw-rw-r--
entryexitevents.php	3.09 KB	-rwxr-xr-x
error_log.php	749 B	-rwxr-xr-x
examappfeereport.php	2.12 KB	-rw-rw-r--
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
feepaidreports.php	2.77 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...	10.48 KB	-rwxr-xr-x
freeze_module_at_admin_college...	9.35 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
freezeiaprici.php	10.87 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getDegreeAndSem.php	4.32 KB	-rw-rw-r--
getMessages.php	11.39 KB	-rwxr-xr-x
getTestTotalMarksReport.php	11.96 KB	-rw-rw-r--
getdata.php	39.06 KB	-rwxrwxrwx
getdataold.php	29.62 KB	-rwxr-xr-x
getfeeinformation.php	7.26 KB	-rwxr-xr-x
getmoduledetails.php	23.77 KB	-rwxr-xr-x
getnumword.php	7.45 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
htblk.php	6.13 KB	-rwxr-xr-x
ia_room_allotment_datewise.php	12.13 KB	-rwxr-xr-x
iaabsententry.php	3.1 KB	-rw-r--r--
iamarks.php	7.68 KB	-rw-r--r--
iaroomdeclaration.php	2.6 KB	-rwxr-xr-x
iasectionwise.php	30.09 KB	-rw-r--r--
iasectionwisenew.php	35.77 KB	-rw-r--r--
iatimetable.php	7.61 KB	-rw-r--r--
identifyCoMarksNew.php	2.6 KB	-rw-rw-r--
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
invigilatorDairyRoomWise.php	6.07 KB	-rw-rw-r--
json.php	34.52 KB	-rwxr-xr-x
lateralentry.php	2.39 KB	-rwxr-xr-x
login.php	8.88 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
marksEntryExt.php	9.11 KB	-rwxr-xr-x
marksentryext.php	13.1 KB	-rw-rw-r--
marksentryquestionwise.php	41.93 KB	-rw-rw-r--
message_board.php	4.67 KB	-rwxr-xr-x
messagetext.php	1.68 KB	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	155.51 KB	-rwxr-xr-x
mregistry18.06.2021.php	99.46 KB	-rwxr-xr-x
mregistry_14092024.php	150.27 KB	-rw-rw-r--
mrn_approval.php	9 KB	-rwxr-xr-x
oldqnpaper.php	4.44 KB	-rw-rw-r--
pendingcie.php	4.21 KB	-rw-rw-r--
picharttesting.php	24.76 KB	-rw-r--r--
pmarks.php	5.97 KB	-rw-rw-r--
post.php	6 KB	-rwxr-xr-x
practicalMarks.php	8.67 KB	-rw-rw-r--
prbillreport.php	5.07 KB	-rw-r--r--
prientCodeStikers.php	6.35 KB	-rw-r--r--
principalFreeze.php	6.92 KB	-rw-rw-r--
principalfreezingsubject.php	1.9 KB	-rw-rw-r--
printAdmRegn.php	13.13 KB	-rwxr-xr-x
printApp_ru.php	1.12 KB	-rw-rw-r--
printMarkListDetailsWisenew_sj...	14.42 KB	-rw-r--r--
qnwiseMarksStats.php	6.14 KB	-rw-rw-r--
qnwisemarksentrynew.php	18.61 KB	-rw-rw-r--
qpSummaryReport.php	1.03 KB	-rw-rw-r--
receive_rv_rt_application.php	8.33 KB	-rwxr-xr-x
receive_teach_trans.php	2.49 KB	-rw-rw-r--
receive_teach_transfer.js	5.06 KB	-rw-rw-r--
remunerationEntry.php	7.14 KB	-rw-rw-r--
repeateriamarksentry.php	4.86 KB	-rw-rw-r--
report_bulk_applications.php	19.42 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	22.93 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	8.54 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
resetPasswordUser.php	2.69 KB	-rw-rw-r--
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
roomAllotment.php	37.45 KB	-rw-rw-r--
room_allotment.php	9.14 KB	-rwxr-xr-x
room_allotment_datewise.php	26.07 KB	-rwxr-xr-x
room_allotment_datewise_bf_rcu...	16.97 KB	-rwxr-xr-x
room_allotment_datewise_stph.p...	21.57 KB	-rwxr-xr-x
room_allotment_datewise_stph_n...	29.01 KB	-rwxr-xr-x
room_allotment_shifiting.php	3.34 KB	-rwxr-xr-x
roomallotmentExcel.php	8.23 KB	-rw-rw-r--
roomallotmentqpwise.php	10.22 KB	-rw-rw-r--
roomallotmentqpwisenew.php	13.92 KB	-rw-rw-r--
roomcreationnew.php	2.81 KB	-rw-rw-r--
roomdeclaration.php	2.2 KB	-rwxr-xr-x
roomdeclaration_stph.php	2.51 KB	-rwxr-xr-x
roomwiseinvigilatorsEntry.php	9.86 KB	-rw-rw-r--
rvdates.php	6.46 KB	-rw-rw-r--
rvrt_ack_exam_app.php	6 KB	-rw-rw-r--
rvrt_report.php	1.92 KB	-rw-rw-r--
savePassword.php	1.14 KB	-rw-rw-r--
saveclsdets.php	1.91 KB	-rw-rw-r--
savesspdetails.php	9.93 KB	-rw-rw-r--
sectionwisepermission.php	5.67 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
sendsmsapi.php	814 B	-rwxr-xr-x
sendusrandpws.php	1002 B	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
shortLists.php	1.65 KB	-rw-rw-r--
std_register_det.php	3.56 KB	-rw-rw-r--
stringspliter.php	693 B	-rwxr-xr-x
studSubIdent.php	11.23 KB	-rw-r--r--
stud_name_doc_upload.php	1.24 KB	-rw-rw-r--
stud_wise_report.php	3.02 KB	-rw-rw-r--
student.php	58.23 KB	-rwxr-xr-x
student_entry.php	61.39 KB	-rwxr-xr-x
student_entry_kswu.php	51.23 KB	-rwxr-xr-x
student_entry_nitte.php	88.09 KB	-rw-rw-r--
student_entry_rur.php	74.42 KB	-rw-rw-r--
student_entry_vku.php	66.58 KB	-rwxr-xr-x
student_rur.php	64.37 KB	-rw-rw-r--
student_vku.php	57.95 KB	-rwxr-xr-x
studentfeesandattiashortagedat...	11.38 KB	-rw-rw-r--
studentportal_remove.php	6.18 KB	-rwxr-xr-x
studentreport.php	15.37 KB	-rw-rw-r--
studnamecorr.php	6.69 KB	-rw-rw-r--
subIAMarksEntry.php	11.14 KB	-rw-rw-r--
subblock.php	6.12 KB	-rwxr-xr-x
subdet.php	9.61 KB	-rw-rw-r--
subjReg.php	12.04 KB	-rw-r--r--
subjectList_display.php	11.7 KB	-rwxr-xr-x
subject_freshExam.php	33.18 KB	-rwxr-xr-x
subject_freshExam_rcub.php	28.33 KB	-rwxr-xr-x
subjectfreez.php	13.02 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	12.43 KB	-rwxr-xr-x
subshort.php	8.97 KB	-rw-rw-r--
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	80.41 KB	-rwxr-xr-x
teachFreeze.php	8.17 KB	-rw-r--r--
teachOficerEntry.php	11.46 KB	-rwxr-xr-x
teachers.php	19.76 KB	-rwxr-xr-x
theoryMarksEntry.php	4.89 KB	-rw-rw-r--
thvalmarks.php	2.72 KB	-rw-r--r--
time_table_degreewise.php	5 KB	-rwxrwxrwx
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	4.74 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updatecopo.php	9.34 KB	-rw-r--r--
updatedegreegroup.php	3.21 KB	-rw-rw-r--
updateexamcnt.php	2.92 KB	-rwxr-xr-x
updatefreshexam.php	1.33 KB	-rw-rw-r--
updatestudentsem.php	2.03 KB	-rw-rw-r--
updatetimetable.php	9.14 KB	-rw-r--r--
updateuvcms.php	2.37 KB	-rw-rw-r--
updmarks.php	22.24 KB	-rw-r--r--
updnemp.php	1.78 KB	-rw-r--r--
upload_doc_demo.php	84 B	-rw-rw-r--
upload_studentPhoto.php	10.81 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadcopo.php	7.89 KB	-rw-r--r--
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadteacherattendance.php	5.23 KB	-rw-r--r--
userpasswordreset.php	754 B	-rw-rw-r--
usersetup.php	24.46 KB	-rwxr-xr-x
usersetupNew.php	12.76 KB	-rw-r--r--
usersubj_identification.php	5.15 KB	-rwxr-xr-x
viewNotifications.php	1.21 KB	-rw-rw-r--
view_ledger.php	3.64 KB	-rwxrwxrwx
yearmode.php	1.83 KB	-rw-rw-r--

Code Editor : approve.php

<?php

function GetDegreeGroupDropdown($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	session_start();
	$collcode = $aobj_context->mobj_data["collcode"];

$degreeList="SELECT distinct fdeggrp as internal_code, concat(fdeggrp,' - ',fdescpn) as value 
	from deggrp where IFNULL(fdeleted,'F') <> 'T' 
	order by fdeggrp";
	$lobj_degreeList = $aobj_context->mobj_db->getAll($degreeList);
	
	if($lobj_degreeList)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_degreeList,0,"success"); 
	}
	else
	{
		$data = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function GetCollegeDegreeDropdown($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	session_start();
	$collcode = $aobj_context->mobj_data["collcode"];

$degreeList="SELECT distinct s.FDEGREE as internal_code, concat(s.fdegree,' - ',d.FDESCPN) as value from studadm s inner join degree d 
	on s.fdegree = d.fdegree and d.fexamno = s.fexamno 
	where s.fcollcode='{$collcode}' and IFNULL(s.FDELETED,'F') <> 'T' 
	order by d.FDEGREE";
	$lobj_degreeList = $aobj_context->mobj_db->getAll($degreeList);
	
	if($lobj_degreeList)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_degreeList,0,"success"); 
	}
	else
	{
		$data = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

$searchAppr = '';
	
	if($apprstatus ==  'Approval Pending')
	{
		$searchAppr = "and ifnull(FAPPRSTATUS,'') <> 'APPROVED'";
	}else if($apprstatus ==  'Approved')
	{
		$searchAppr = "and ifnull(FAPPRSTATUS,'') = 'APPROVED'";
	}else
	{
		$searchAppr = ' and 1=1';
	}	
	$url = "https://university-student-photos.s3.ap-south-1.amazonaws.com/{$_SESSION['FUNIVCODE']}/";	
	
	$admlist = "select s.*, ifnull(FAPPRREMARKS,'') as fremarks, c.FCOLLNAME,group_concat(o.fsubcode) as subject from studadm s 
				inner join college c on c.FCOLLCODE = s.FCOLLCODE
				inner join options o on s.fappno = o.fappno
				where 
				{$serchAll} {$searchColl} {$searchDegree} {$searchComb} {$searchAppr} 
				and ifnull(s.fdeleted,'') <> 'T' and ifnull(s.fappstatus,'') = 'verified' 
				and ifnull(s.ffinsub,'') = 'T' and s.fexamno = '{$examno}'
				group  by s.fappno,s.fdegree,s.fcollcode 
				order by s.fdegree,s.fcombcode,s.fname,s.fappno";
	//var_dump($admlist);			
	$lobj_admList = $aobj_context->mobj_db->getAll($admlist);
	
	$Table_Header.="<table  cellspacing='0' width='98%' class='tr_ventor_row' cellpadding='0' border='0' >";
	$Table_Header.="<tr class='ui-state-default ui-jqgrid-hdiv'>";	
	$Table_Header.="<td  style='padding:2px; width:60px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Sl. No.</center></td>";
	$Table_Header.="<td  style='padding:2px; width:60px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Photo</center></td>";
	$Table_Header.="<td  style='padding:2px; width:80px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Admission No.</center></td>";
	$Table_Header.="<td  style='padding:2px; width:300px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Student Name</td>";
	$Table_Header.="<td  style='padding:2px; width:30px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Gender</center></td>";
	$Table_Header.="<td  style='padding:2px; width:30px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Caste</center></td>";
	$Table_Header.="<td  style='padding:2px; width:30px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Degree</td>";
	$Table_Header.="<td  style='padding:2px; width:30px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Adm. Fee</td>";
	$Table_Header.="<td  style='padding:2px; width:30px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Approve<center><input type = 'checkbox' onclick='Checkalladmapplication(this.id);' id = 'arun'></center></td>";
	$Table_Header.="<td  style='padding:2px; width:30px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Remarks</td>";
	$Table_Header.="</tr>";
	$index=0;
	 $receive_checkbox="<input type='checkbox'  id='receive_check_box_{$FDOCNO}'><input type = 'hidden' id = 'ack_hidden{$sl_no}' value = '{$FDOCNO}'>";
	foreach($lobj_admList as $key=>$val)
	{
		++$index;
		$border_bottom="";
		//if($cnt==count($lobj_admList))
			$id = $val['FAPPNO'].'~'.$val['FDEGREE'].'~'.$val['FCOLLCODE'];
		//$id = $val['FSLNO'];
		if($val['FAPPRSTATUS'] == 'APPROVED')
			$disabled = "checked";//disabled
		else
			$disabled = "";// disabled
		$border_bottom="border-bottom:1px solid #ccc;";
		$data_details.="<tr class={$class} style='font-size:20px;' >";
		$data_details.="<td  align=center style='border:1px solid #ccc; {$border_bottom} border-left:1px solid #ccc; padding:2px;font-size:16px;'>{$index}</td>";			
		$data_details.="<td  align=center style='border:1px solid #ccc; {$border_bottom} border-left:1px solid #ccc; padding:2px;font-size:16px;'><img width='60px' height='60px' src='{$url}{$val['FPHOTOPATH']}'/></td>";			
		$data_details.="<td  align=center style='border:1px solid #ccc; {$border_bottom} border-left:1px solid #ccc; padding:2px;font-size:16px;'><a href='#' style='text-decoration:none;color:blue;' onclick=ViewStudentDetailsForApprove('{$val[FAPPNO]}','{$val[FDEGREE]}','{$val[FCOLLCODE]}')>{$val['FAPPNO']}</a> </td>";			
		$data_details.="<td align='left' style='border:1px solid #ccc;  {$border_bottom} solid #ccc; padding:2px;font-size:16px;'>{$val[FNAME]}</td>";
		$data_details.="<td  align='center' style='border:1px solid #ccc;  {$border_bottom} solid #ccc; padding:2px;font-size:16px;'>{$val[FGENDER]}</td>";
		$data_details.="<td  align='center' style='border:1px solid #ccc;  {$border_bottom} solid #ccc; padding:2px;font-size:16px;'>{$val[FCASTE]}</td>";
		$data_details.="<td  align=center style='{$border_bottom} border:1px solid #ccc; font-size:16px;'>{$val[FDEGREE]}</td>";
		$data_details.="<td  align=center style='{$border_bottom} border:1px solid #ccc; font-size:16px;'>{$val[FTOTFEE]}</td>";
		$data_details.="<td  align=center style='{$border_bottom} border:1px solid #ccc; font-size:16px;'><input type = 'checkbox' {$disabled} id='adm_check_box_{$id}'><input type = 'hidden' id = 'adm_check_box_{$index}' value = '{$id}'</td>";
		$data_details.="<td  align=center style='{$border_bottom} border:1px solid #ccc; font-size:16px;'><input type = 'text'  id='{$val['FAPPNO']}' value = '{$val['fremarks']}' class = 'remarks'></td>";
		$data_details.="</tr>";
		 $cnt++;
	}
	
	$e_data['admtable'] = $Table_Header.$data_details;
	$e_data['cnt'] = $index;
	echo $aobj_context->mobj_output->ToJSONEnvelope($e_data,0,"success"); 
}

function getAppStudentDetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 	
	session_start();   //and FDELETED = 'F'
	$fappno = $aobj_context->mobj_data["sl_no"]; 
	$degree = $aobj_context->mobj_data["degree"]; 
	$collcode = $aobj_context->mobj_data["collcode"];

$get_student_details_slno = "SELECT 
	fappno AS student_entry_admno,
	fcollcode AS collcode,
	fdegree as student_entry_degree_code,
	DATE_FORMAT(fadmdate,'%d/%m/%Y') AS student_entry_admdate,
	fdegree AS student_entry_degree_code,
	fcombcode  AS combination,
	fname AS student_entry_name,
	FFATNAME AS student_entry_fname,
	FMOTNAME AS student_entry_mname,
	DATE_FORMAT(fdob,'%d/%m/%Y') AS student_entry_dob,
	FPHOTOPATH AS student_entry_photo,
	FSIGNPATH AS student_signature_photo,
	FRELIGION AS student_entry_religion,
	FGENDER AS student_entry_gender,
	FBLOOD_GROUP AS student_entry_blood_grp,
	FNATIONAL AS student_entry_national,
	FCASTE AS degree_category,
	FCATBIRTH AS student_entry_caste,
	FAADHARNO AS seAadharNumber,
	FAREA AS farea,
	FEMAIL AS student_entry_email,
	FCONTACT_NO AS student_entry_mobile,
	FMOBILE_NO AS student_entry_phone,
	FINCOME AS student_entry_fincome,
	ifnull(FPERMADD1,'') AS student_entry_per_add1,
	IFNULL(FPERMADD2,'') AS student_entry_per_add2,
	IFNULL(FPERMADD3,'') AS student_entry_per_add3,
	IFNULL(FPERDIST,'') AS student_entry_per_dist,
	IFNULL(FPERSATE,'') AS  student_entry_per_state,
	IFNULL(FPERPINCODE,'') AS  student_entry_per_pin,
	IFNULL(FCURRADD1,'') AS student_entry_comm_addr1,
	IFNULL(FCURRADD2,'') AS student_entry_comm_addr2,
	IFNULL(FCURRADD3,'') AS student_entry_comm_addr3,
	IFNULL(FCOMDIST,'') AS student_entry_comm_dist,
	IFNULL(FCOMPINCODE,'') AS student_entry_comm_pin,
	IFNULL(FCOMSTATE,'') AS student_entry_comm_state,
	FTYPEQUALEXAM AS seTypeOfQualifyingExam,
	FQUALEXREGNO AS seExamRegNo,
	FUNIVNAME AS seUniversityName,
	FQMONTH AS fmonth,
	FQYEAR AS fyear,
	FQMAXMARKS AS maxmarks,
	FQSECMARKS AS secmarks,
	FQPERCENTAGE AS percentage,
	ifnull(FCONSTYPE,'') as constype
	from studadm  
	where fappno='{$fappno}' and FDEGREE='{$degree}' and ifnull(fdeleted,'') <> 'T'
	and FCOLLCODE='{$collcode}'";

$lobj_get_student_details = $aobj_context->mobj_db->getRow($get_student_details_slno);

$arr['perdetl'] = $lobj_get_student_details;

$combination =  $lobj_get_student_details['combination'];

$query3 = "SELECT FCATEGORY AS int_code,FDESCPN AS val FROM category 
	where ifnull(FDELETED,'') <> 'T' order by FCATEGORY asc ";
	$rst3 = $aobj_context->mobj_db->GetAll($query3);
	$arr['category'] = $rst3;

$query3 = "SELECT distinct fdegree AS int_code,FDESCPN AS val FROM degree 
	where ifnull(fadmdeg,'') = 'T' and  fdegree = '{$degree}' 
	and ifnull(FDELETED,'') <> 'T' order by fdegree";
	$rst3 = $aobj_context->mobj_db->GetAll($query3);
	$arr['degree'] = $rst3;

$query3 = "SELECT distinct fcombcode AS int_code,fcombdesc AS val FROM mascomb 
	WHERE fdegree = '{$degree}' AND IFNULL(FDELETED,'') <> 'T' ORDER BY fcombcode ";
	$rst3   = $aobj_context->mobj_db->GetAll($query3);
	$arr['mascomb'] = $rst3;

$query4 = "select fboardcode as int_code, fboardname as val from masboard order by forder";
	$rst4   = $aobj_context->mobj_db->GetAll($query4);
	$arr['boards'] = $rst4;

$query = "SELECT DISTINCT m.internal_code AS int_code, 
	FCERTDESC AS doc_type ,
	IFNULL(FFILENAME,REPLACE(REPLACE(FCERTDESC,' ','_'),'+','_')) AS FFILENAME,
	ifnull(s.file_path,'') as file_path
	FROM masdoc m
	inner  JOIN studoc s 
	ON s.fdegree = m.fdegree AND login_cnt = '{$fappno}' AND s.fdoctype = m.FFILENAME 
	AND fcollcode = '{$collcode}' where m.fdegree = '{$degree}' 
	ORDER BY forder";

$results = $aobj_context->mobj_db->GetAll($query);
	$arr['masdoc'] = $results;

$get_sub_total  = "select FTOTSUB from degree where FDEGREE= '{$degree}' and FEXAMNO='A'";
	$lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total);
		
	$total_sub      = $lobj_sub_total['FTOTSUB'];
		
	$get_exsting_data = "select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from 
	(select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options
	where fappno = '{$fappno}' and FCOLLCODE='{$collcode}' 
	and FEXAMNO='A' and FDEGREE='{$degree}') a
	left join 
	(select s.FDEGREE,
	FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	where d.FDEGREE='{$degree}' and s.FEXAMNO='A') b 
	on a.FSUBCODE=b.FSUBCODE
	and a.FDEGREE=b.FDEGREE
	group by FSUBCODE limit {$total_sub}";
	 
	$lobj_get_exsting_data = $aobj_context->mobj_db->getAll($get_exsting_data);

$get_true_sub_names="select FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	where d.FDEGREE='{$degree}' and s.FEXAMNO='{$exam}' and FMANDATORY='T' group by  s.FSUBCODE
	union
	select s.FSUBCODE,s.FSUBNAME,s.FSUBSHORT ,'T' as FMANDATORY from degree d inner join subject s on 
	s.FDEGREE=d.FDEGREE  and  d.FEXAMNO=s.FEXAMNO
	left join mascomb m on m.FDEGREE=d.FDEGREE and m.fcombcode = '{$combination}'
	where d.FDEGREE='{$degree}'  and m.FSUBCODE = s.FSUBCODE  
	group by  s.FSUBCODE";	
	$lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names);	
	 
	$e_data.="<table  width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >";
	$e_data.="<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>";		
	$e_data.="<td  style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>";
	$e_data.="<td  style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>";
	$e_data.="<td  style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>";
	$e_data.="</tr>";
	
	$k=0;
	$id=0;
	 
	if(empty($lobj_get_exsting_data))
	{
		$remaining_count=$total_sub-count($lobj_get_true_sub_names);
			
		foreach($lobj_get_true_sub_names as $key=>$value)
		{
		  
			$e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow'>";
			$e_data.="<td class='tbl_row_new subcode' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;'><input  tabindex=-1  {$inp_class} type=text style='width:60px;border:none;' readonly id='se_sub_code_{$id}' value='{$value['FSUBCODE']}' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'></td>";
			$e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:60px;' {$inp_class}  tabindex=-1  readonly id='se_short_name_{$id}' value='{$value['FSUBSHORT']}'></td>";
			$e_data.="<td  class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:290px;' {$inp_class} id='se_sub_name_{$id}'  tabindex=-1   readonly value='{$value['FSUBNAME']}'> </td>";
			$e_data.="</tr>";
			 $k++;
			 $id++;
		}

$name=''; 
		$pmode = 1;			
		if($pmode == 0)
		{
			$last_slno_execution ="  select s.FSUBCODE, s.FSUBSHORT, s.FSUBNAME 
			from subject s inner join options d on 									
			s.FDEGREE=d.FDEGREE  and  s.FEXAMNO=d.FEXAMNO and 
			d.fsubcode = s.fsubcode and d.FCOLLCODE='{$collcode}' and
			s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and
			s.FDEGREE='{$degree}' and s.FEXAMNO='A' and 
			d.fslno = 
			( select MAX(s.fslno) from studadm s 
			where s.FDEGREE='{$degree}' and s.FEXAMNO='A' 
			AND FCOLLCODE='{$collcode}' ) group by    s.FSUBCODE
			";
			$lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution);	
		}	
			 
		
			for($j=0;$j<$remaining_count;$j++)
			{				 
				if($k%2==0)
				{
				$class='tbl_row';
				$inp_class='tbl_row_input';
				}
				else
				{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
				}  
				if($j==0)
				$name="name='focus'";
				else
				$name='';
				 
				 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
				 $e_data.="<td class='tbl_row_new subcode' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' readonly onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name}  onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>";
				 $e_data.="<td class='tbl_row_new' align='center'  style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'  tabindex=-1  readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}'  ></td>";
				 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1  readonly  style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}'  ></td>";
				 $e_data.="</tr>";
				 $k++;
				 $id++;
			}  
		}
		else
		{
		$flag=0;
		$remaining_count=$total_sub-count($lobj_get_exsting_data);
			for($h=0;$h<count($lobj_get_exsting_data);$h++)
			{
				$read_only=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?"readOnly":''; 
				$read_only = "readOnly";
				$border=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?" border:none;":''; 
				$on_blur =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onblur='getSubDetails( this.id,{$id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' ":'';
				$focus_id =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onfocus=\$g_focus_element='se_sub_code_{$id}' ":'';
				   
				if($k%2==0)
				{
				$class='tbl_row';
				$inp_class='tbl_row_input';
				}
				else
				{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
				}
				if(($lobj_get_exsting_data[$h]['FMANDATORY']=='F') && $flag==0)
				{
				$name="name='focus'";
				$flag=1;
				}else
				$name='';
			 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
			 $e_data.="<td class='tbl_row_new subcode' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} readonly
			 	onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' 
			 	onblur='getSubDetails( this.id,{$id});'
			 	 {$name}  align='center' {$focus_id} value='{$lobj_get_exsting_data[$h]['FSUBCODE']}' style = 'width:60px;{$border}' id='se_sub_code_{$id}'>  </td>";
			 $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'   {$read_only} style = 'width:60px;border:none;'  {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBSHORT']}' id='se_short_name_{$id}'></td>";
			 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text'   {$read_only} style = 'width:290px;border:none;' {$inp_class}  value='{$lobj_get_exsting_data[$h]['FSUBNAME']}' id='se_sub_name_{$id}'></td>";
			 $e_data.="</tr>";
			 $k++;
			 $id++;
			}
			$k=0;
			for($j=0;$j<$remaining_count;$j++)
			{				 
				if($k%2==0)
				{
				$class='tbl_row';
				$inp_class='tbl_row_input';
				}
				else
				{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
				}  
				if($j==0)
				$name="name='focus'";
				else
				$name='';
				 
				 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >";
				 $e_data.="<td class='tbl_row_new subcode' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' readonly onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name}  onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>";
				 $e_data.="<td class='tbl_row_new' align='center'  style='border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'  tabindex=-1  readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}'  ></td>";
				 $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1  readonly  style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}'  ></td>";
				 $e_data.="</tr>";
				 $k++;
				 $id++;
			}
		}		
		 
		$e_data.="</table>";
		$arr['html']=$e_data;
		$arr['table_data']=$lobj_get_true_sub_names;
		$arr['remaining_count']=$remaining_count;
		$arr['total_count']=$id;

$query = "select * from admfeedetl where fcollcode = '{$collcode}' 
	and fappno = '{$fappno}'";
	$results = $aobj_context->mobj_db->GetAll($query);

if($results)
	{	
		$get_details="SELECT ma.FHEADCODE,IFNULL(ta.FAMOUNT ,ma.FFEE) as FFEE,ma.FMODIFY,ifnull(ta.FAMOUNT ,ma.FFEE) as fee_paid,
		FCOMBCODE,FCATCODE
		FROM admfeestr ma
		left join admfeedetl ta
	 	on ma.fdegree = ta.fdegree and ma.fexamno = ta.fexamno and ma.fheadcode = ta.fheadcode
	 	WHERE ma.FDEGREE='{$degree}'
		AND ma.FEXAMNO='A'
		AND ma.FCOMBCODE='ADM' and ta.fcollcode = '{$collcode}' and ta.fappno = '{$fappno}'
		AND ma.FCATCODE='GM' order by ma.fheadcode ";
		//var_dump($get_details);
		$lobj_rs = $aobj_context->mobj_db->GetAll($get_details);
	}
	else
	{
		$get_details="SELECT ma.FHEADCODE,ma.FFEE,ma.FMODIFY,ifnull(ma.FFEE,'') as fee_paid,
		FCOMBCODE,FCATCODE
		FROM admfeestr ma
	 	WHERE ma.FDEGREE='{$degree}' and FCATCODE = 'GM'
		AND ma.FEXAMNO='A'
		AND ma.FCOMBCODE='ADM' order by ma.fheadcode";
		$lobj_rs = $aobj_context->mobj_db->GetAll($get_details);
	}

$str_reval="";
	$str_reval.="<table width='60%' style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>";
	$str_reval.="<th align='left' colspan='4' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Fee Details</th>";
	$str_reval.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
	$str_reval.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl.No</td>";
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Description</td>";
	/*$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee</td>";*/
	$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee Paid</td>";
 
	$str_reval.="</tr>";
	$sl_no=1;
	$total=0;
	$total_fee_paid=0;
	foreach($lobj_rs  as $ak=>$av)
	{
		$FHEADCODE=$av['FHEADCODE'];
		$FFEE=$av['FFEE'];
		$fee_paid=$av['fee_paid'];
		$total+=$FFEE;
		$total_fee_paid+=$fee_paid;
		$str_reval.="<tr class='ui-widget-content jqgrow'>";		
		$str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;  ' >{$sl_no}</td>";
		$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='left' id='head_{$sl_no}'>{$FHEADCODE}</td>";
		/*$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;width:50px;'align='right' >{$FFEE}</td>";*/
		$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right'><input onblur=\"CalculateTotalFeePaid();\" onkeypress='return acceptNumbersOnlyForModule(event);'  type='text'  style='text-align:right;width:50px;' readonly id='fee_paying_{$sl_no}' value='{$fee_paid}'/></td>";
		$str_reval.="</tr>";
		$sl_no++;
	}
		$str_reval.="<tr class='ui-widget-content jqgrow' style='font-weight:bold;'>";		
		$str_reval.="<td colspan=2 class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;'  align='right'>Total </td>";
		 
		/*$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='total_comb_fee'>{$total}</td>";*/
		$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='total_fee_paid'>{$total_fee_paid}</td>";
	
		$str_reval.="</tr>";
		$str_reval.="</table>";
		$arr['fee_html']=	$str_reval;

if(!empty($lobj_get_student_details))
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;
	}
	else if(empty($lobj_get_student_details) )
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-2,"Failure"); 
		return;
	}
}

function updateAdmissionStatus($aobj_context)
{

session_start();
	$u_id = $_SESSION['user_id'];
	$log_name = $_SESSION['usr'];
	$checked_app_nos = $obj_context->mobj_data["arun"];

$exp_arr=explode(",",$checked_app_nos);

foreach($exp_arr as $apk)
	{
		$college = explode('-',$apk);
	}
	$fappno = $aobj_context->mobj_data["fappno"]; 
	$degree = $aobj_context->mobj_data["degree"]; 
	$collcode = $aobj_context->mobj_data["college"]; 
	//$sl_no=substr($sl_no, -4);  
	$degree = $aobj_context->mobj_data["degree"];
	$appr_status = $aobj_context->mobj_data["appstatus"]; 
	
	
	$updateAdmStatus = "update studadm set FAPPRSTATUS = '{$appr_status}',FAPPRDATE =now(),FAPPRUSERNAME = '{$log_name}', FAPPRUSERID = '{$u_id}' where 
	fappno = '{$fappno}'";
	$lobj_updateAdmStatus = $aobj_context->mobj_db->Execute($updateAdmStatus);
	var_dump($updateAdmStatus);	
	if($lobj_updateAdmStatus)
	{
		$data = 'Status Updated Succesfully';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
	}
	else
	{
		$data = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($updateAdmStatus,-1,"failure"); 
	}
}

function getCombinationapproved($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	session_start();
	$collcode = $_SESSION['collcode'];  
	$degreecode = $aobj_context->mobj_data["degree"];
	$fcollcode = $aobj_context->mobj_data["fcollcode"];
	$get_honours = "SELECT  m.FCOMBCODE as internal_code, m.FCOMBDESC as value from mascomb m
	inner join studadm s on m.fcombcode = s.fcombcode
	where m.fdegree = '{$degreecode}' 
	and s.fcollcode = '{$fcollcode}' 
	group by m.FCOMBCODE";

// var_dump($get_honour);
	// die();

$lobj_get_honours = $aobj_context->mobj_db->getAll($get_honours);

$arr['mascomb']=$lobj_get_honours; 
	if($lobj_get_honours)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	else
	{
		$data = '';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}

}

function checkadmapprovelist($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$degree = $aobj_context->mobj_data["fdegree"];
	$collcode = $aobj_context->mobj_data["fcollcode"];
	$combcode = $aobj_context->mobj_data["fcombcode"];
	$examno = $aobj_context->mobj_data["examno"];
	$deggrp = $aobj_context->mobj_data["deggrp"];

$cnd = "AND d.fdeggrp = '{$deggrp}'";

if($deggrp == 'MBA/MCA')
		$cnd = "and d.fdegree in ('MBA1', 'MCA1', 'MBE1' )";

$list = $aobj_context->mobj_data["list"];

if($list == 1)
	{
		$first_list = "and s.fadmrnd <> '2'"; 
	}
	else if($list == 2)
	{
		$first_list = "and s.fadmrnd = '2'"; 
	}
	else
	{
		$first_list = "";
	}

$degcond = '';
	if(strtolower($degree) != 'all')
	{
		$degcond = "and s.fdegree = '{$degree}'";
	}
	$combcond = '';
	if($combcode != 'all')
	{
		$combcond = "and s.fcombcode = '{$combcode}'";
	}

$admCollDataQuery = "select s.fappno, s.fcollcode, s.fdegree, d.fdescpn, s.fcombcode,'{$deggrp}' as fdeggrp,
	m.FCOMBDESC, upper(trim(s.fname)) as fname, ifnull(s.faregno,'') as  fregno,
	ifnull(s.fstudid,'') as fstudid,
	GROUP_CONCAT(DISTINCT ifnull(s.FAPPRREMARKS,'') separator '') AS fapprremarks,
	GROUP_CONCAT(DISTINCT ifnull(su.fsubname,'') separator '') AS fsubcode
	FROM studadm s
	inner join degree d on s.fdegree = d.fdegree and s.fexamno = '{$examno}'
	INNER JOIN options o ON s.fappno = o.fappno AND s.fdegree = o.fdegree 
	AND s.fcollcode = o.fcollcode
	left  join subject su ON s.fdegree = su.fdegree AND o.fexamno = su.fexamno 
	AND o.fsubcode = su.fsubcode AND
	IFNULL(su.fintass,'') <> 'T' AND su.fsubcode BETWEEN 'A002' AND 'A015'
	INNER JOIN mascomb m ON s.fdegree = m.fdegree AND m.fcombcode = s.fcombcode
	WHERE IFNULL(s.FAPPRSTATUS,'') = 'Approved'  {$cnd}
	and s.fcollcode = '{$collcode}' and IFNULL(s.FAPPSTATUS,'') = 'verified'
	and ifnull(s.fdeleted,'') <> 'T' and IFNULL(s.ffinsub,'') = 'T'
	{$first_list} {$degcond} 
	GROUP BY s.fappno 
	ORDER BY s.fdegree,s.fcombcode,s.fname,s.fappno";
	//var_dump($admCollDataQuery);
	// die();
	$apprCollData = $aobj_context->mobj_db->GetAll($admCollDataQuery);

$admNotCollDataQuery = "select s.fappno, s.fcollcode, s.fdegree, d.fdescpn, s.fcombcode,'{$deggrp}' as fdeggrp,
	m.FCOMBDESC, upper(trim(s.fname)) as fname, ifnull(s.faregno,'') as  fregno,s.fnaremarks,
	ifnull(s.fstudid,'') as fstudid,
	GROUP_CONCAT(DISTINCT ifnull(su.fsubname,'') separator '') AS fsubcode,
	GROUP_CONCAT(DISTINCT ifnull(s.FAPPRREMARKS,'') separator '') AS fapprremarks
	FROM studadm s
	inner join degree d on s.fdegree = d.fdegree and s.fexamno = '{$examno}'
	INNER JOIN options o ON s.fappno = o.fappno AND s.fdegree = o.fdegree 
	AND s.fcollcode = o.fcollcode
	left  join subject su ON s.fdegree = su.fdegree AND o.fexamno = su.fexamno 
	AND o.fsubcode = su.fsubcode AND
	IFNULL(su.fintass,'') <> 'T' AND su.fsubcode BETWEEN 'A002' AND 'A015'
	INNER JOIN mascomb m ON s.fdegree = m.fdegree AND m.fcombcode = s.fcombcode
	WHERE IFNULL(s.FAPPRSTATUS,'') <> 'APPROVED'  {$cnd}
	and s.fcollcode = '{$collcode}' and IFNULL(s.FAPPSTATUS,'') = 'verified'
	and ifnull(s.fdeleted,'') <> 'T' and IFNULL(s.ffinsub,'') = 'T' {$degcond}
	GROUP BY s.fappno 
	ORDER BY s.fdegree,s.fcombcode,s.fname,s.fappno";
	// var_dump($admNotCollDataQuery);
	// die();
	$apprNotCollData = $aobj_context->mobj_db->GetAll($admNotCollDataQuery);

$query = "select *,date_format(now(),'%d/%m/%Y') as fdate, '{$deggrp}' as fdeggrp 
	from college where fcollcode = '{$collcode}' and ifnull(fdeleted,'') <>'T'";
	$apprColldet = $aobj_context->mobj_db->GetRow($query);

if(count($apprCollData) > 0 || count($apprNotCollData) > 0 )
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}
	else
	{
		$data = 'No data found...!';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}

}

${this.title}

Code Editor : approve.php