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 : student_entry_nitte.php

<?php
/* 
 *
 * FOR THE STUDENT ENTRY FORM
 * PROGRAMED BY NAVEEN
 * DATE: 12/03/09
 * TIME: 9:45 AM 
  *
 */

require_once("/var/www/html/aws/aws-autoloader.php");
use Aws\S3\S3Client;
use Aws\S3\Exception\S3Exception;

session_start();
function replaceChars($name)
{
	$spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","");
	$link_name = strtolower(str_replace($spl_char,"_",$name));
	return str_ireplace("__","_",$link_name);
}
function SaveStudentEntryNitte($aobj_context)
{
	session_start();
	 
	$college_code = $_SESSION['collcode'];
	$u_id = $_SESSION['user_id'];
	$log_name = $_SESSION['usr'];
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	if(trim($college_code) == true)
	{
		$add_edit= trim($aobj_context->mobj_data["add_edit"]);
		$edit_app_no=trim($aobj_context->mobj_data["edit_app_no"]);
		$stud_admno=trim($aobj_context->mobj_data["stud_admno"]);
		$degree=trim($aobj_context->mobj_data["degree"]);
		$db=trim($aobj_context->mobj_data["db"]);
		$degree_exam= trim($aobj_context->mobj_data["sem"]);//trim($aobj_context->mobj_data["degree_exam"]);
		$candidate_name= strtoupper(trim($aobj_context->mobj_data["candidate_name"]));
		$gender=trim($aobj_context->mobj_data["gender"]);
		$fname= strtoupper(trim($aobj_context->mobj_data["fname"]));
		$mname= strtoupper(trim($aobj_context->mobj_data["mname"]));
		$dob=trim($aobj_context->mobj_data["dob"]);
		$sem=trim($aobj_context->mobj_data["sem"]);
		$nationality=trim($aobj_context->mobj_data["nationality"]);
		$religion=trim($aobj_context->mobj_data["religion"]);
		$admdate=trim($aobj_context->mobj_data["admdate"]);
		$caste=trim($aobj_context->mobj_data["caste"]);
		$catecode=trim($aobj_context->mobj_data["catecode"]);
		$aadharno=trim($aobj_context->mobj_data["aadharno"]);
		$fatocc=trim($aobj_context->mobj_data["fatocc"]);
		$fatincome=trim($aobj_context->mobj_data["fatincome"]);
		$motocc=trim($aobj_context->mobj_data["motocc"]);
		$motincome=trim($aobj_context->mobj_data["motincome"]);
		$mottong=trim($aobj_context->mobj_data["mottong"]);
		$studystate=trim($aobj_context->mobj_data["studystate"]);
		$bloodgrp=trim($aobj_context->mobj_data["bloodgrp"]);
		
		$motmob=trim($aobj_context->mobj_data["motmob"]);
		$motemail=trim($aobj_context->mobj_data["motemail"]);
		$fatmob=trim($aobj_context->mobj_data["fatmob"]);
		$fatemail=trim($aobj_context->mobj_data["fatemail"]);
		$guamob=trim($aobj_context->mobj_data["guamob"]);
		$guaemail=trim($aobj_context->mobj_data["guaemail"]);
		$studmob=trim($aobj_context->mobj_data["studmob"]);
		$studemail=trim($aobj_context->mobj_data["studemail"]);
		$commadd1=trim($aobj_context->mobj_data["commadd1"]);
		$commadd2=trim($aobj_context->mobj_data["commadd2"]);
		$peradd1=trim($aobj_context->mobj_data["peradd1"]);
		$peradd2=trim($aobj_context->mobj_data["peradd2"]);
		$commpost=trim($aobj_context->mobj_data["commpost"]);
		$perpost=trim($aobj_context->mobj_data["perpost"]);
		$commtaluk=trim($aobj_context->mobj_data["commtaluk"]);
		$pertaluk=trim($aobj_context->mobj_data["pertaluk"]);
		$commdist=trim($aobj_context->mobj_data["commdist"]);
		$fperdist=trim($aobj_context->mobj_data["perdist"]);
		$perstate=trim($aobj_context->mobj_data["perstate"]);
		$commstate=trim($aobj_context->mobj_data["commstate"]);
		$commpin=trim($aobj_context->mobj_data["commpin"]);
		$perpin = trim($aobj_context->mobj_data["perpin"]);
		
		$qual=trim($aobj_context->mobj_data["qual"]);
		$qregno=trim($aobj_context->mobj_data["qregno"]);
		$collname=trim($aobj_context->mobj_data["collname"]);
		$areytype=trim($aobj_context->mobj_data["areytype"]);
		$board=trim($aobj_context->mobj_data["board"]); 
		$boardstate=trim($aobj_context->mobj_data["boardstate"]);
		$year=trim($aobj_context->mobj_data["year"]);
		$phymax=trim($aobj_context->mobj_data["phymax"]);
		$physec=trim($aobj_context->mobj_data["physec"]);
		$phyper=trim($aobj_context->mobj_data["phyper"]);
		$matmax=trim($aobj_context->mobj_data["matmax"]);
		$matsec=trim($aobj_context->mobj_data["matsec"]);
		$matper=trim($aobj_context->mobj_data["matper"]);
		$chemax=trim($aobj_context->mobj_data["chemax"]);
		$chesec=trim($aobj_context->mobj_data["chesec"]);
		$cheper=trim($aobj_context->mobj_data["cheper"]);
		$pcmmax=trim($aobj_context->mobj_data["pcmmax"]);
		$pcmsec=trim($aobj_context->mobj_data["pcmsec"]);
		$pcmper=trim($aobj_context->mobj_data["pcmper"]);
		$pumax=trim($aobj_context->mobj_data["pumax"]);
		$pusec=trim($aobj_context->mobj_data["pusec"]);
		$puper=trim($aobj_context->mobj_data["puper"]);
		$engmax=trim($aobj_context->mobj_data["engmax"]);
		$engsec=trim($aobj_context->mobj_data["engsec"]);
		$engper=trim($aobj_context->mobj_data["engper"]);
		$sanno= strtoupper(trim($aobj_context->mobj_data["sanno"]));		
		$colldist=trim($aobj_context->mobj_data["colldist"]);
		$seattype=trim($aobj_context->mobj_data["seattype"]);
		$scholar=trim($aobj_context->mobj_data["scholar"]);
		$sslc=trim($aobj_context->mobj_data["sslc"]);
		$nucatno=trim($aobj_context->mobj_data["nucatno"]);
		$nucatrank=trim($aobj_context->mobj_data["nucatrank"]);

$scholard=trim($aobj_context->mobj_data["scholard"]);
		$eligiblfee=trim($aobj_context->mobj_data["eligiblfee"]);
		$receiptNo=trim($aobj_context->mobj_data["receiptNo"]);
		$receiptDate=trim($aobj_context->mobj_data["receiptDate"]);
		$documents=trim($aobj_context->mobj_data["documents"]);		
		$passyrmonth=trim($aobj_context->mobj_data["passyrmonth"]);
		$regFee=trim($aobj_context->mobj_data["regFee"]);
		$regRecNo=trim($aobj_context->mobj_data["regRecNo"]);
		$regRecDate=trim($aobj_context->mobj_data["regRecDate"]);

$abcno=trim($aobj_context->mobj_data["abcno"]);

$query = "select funivcode from control";
		$results = $aobj_context->mobj_db->GetRow($query);
		$funivcode = $results['funivcode'];
		
		if($degree == '-SELECT-'){
			$arr='Select Degree';
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
			return;	
		}

$get_year="SELECT fadmyear
					FROM degree
					WHERE FDEGREE='{$degree}'
					AND FEXAMNO='{$degree_exam}'";
		$lobj_get_year = $aobj_context->mobj_db->getRow($get_year);
		$f_year=$lobj_get_year['fadmyear'];
		
		if($add_edit=='Add')
		{
			$get_generateAutoIncrementSlNo = "select right(concat('0000',ifnull(max(FSLNO),0)+01),4)  as  FSLNO 
							from studadm
							where  FDEGREE='{$degree}' and FCOLLCODE='{$college_code}'";

$lobj_get_generateAutoIncrementSlNo = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo);
			$degree_slno=$lobj_get_generateAutoIncrementSlNo['FSLNO'];

if($funivcode == '051')
			{
				$get_generateAutoIncrementSlNo = "select count(*) as cnt
							from studadm
							where  ifnull(frollno,'')='{$sanno}'
							and ifnull(fdeleted,'') <> 'T'";

$res9 = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo);
				$cnt=$res9['cnt'];
				
				if($cnt >0)
				{
					$arr='Please check USN this number already Entered. '.$sanno;
					echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
					return;		
				}
			}
		
		}

$unlink_file=trim($aobj_context->mobj_data["unlink_file"]);

include_once("/JSON.php"); 
		$json = new Services_JSON();
	 
	$lstr_param = stripslashes($aobj_context->mobj_data["sub_arr"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$sub_arr_data = get_object_vars($mobj_jsondata);

$prevsub_param = stripslashes($aobj_context->mobj_data["prev_sub"]);
	$prevsub_jsondata = $json->decode($prevsub_param);
	$prevsub_arr_data = get_object_vars($prevsub_jsondata);

$check_adminsion_freeze ="  select FCADSTATUS, ifnull(fadmstop,'') as FADMSTOP from colldeg 
									where FCOLLCODE='{$college_code}' 
									and FDEGREE='{$degree}'";								
	$lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); 
	
	if($lobj_check_adminsion_freeze['FADMSTOP']=='T')
	{
		$arr='Last date for student admission is over';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
		return;		
	}
	else
	{
	
	$college_path=$aobj_context->main_src."/student_photos/{$college_code}";
	$folder_path=$aobj_context->main_src."/student_photos/{$college_code}/".replaceChars($degree_code);
	 $file_name=basename($_FILES['student_entry_upload']['name']);
				$path_arr=pathinfo($_FILES['student_entry_upload']['name']);
				$file_ext=$path_arr['extension'];
	$full_file_path= $folder_path.'/'.$degree_slno."_".$file_name;;
	$image_path="student_photos/{$college_code}/".replaceChars($degree).'/'.$degree_slno."_".date("Y")."_".$file_name;
	// var_dump($sub_arr_data,$prevsub_arr_data,$studystate);die();
	//student_entry_upload
	if(!file_exists($college_path))
	{
		mkdir($college_path);
	}if(!file_exists($folder_path))
	{
		mkdir($folder_path);
	}
	if(is_null($lobj_check_adminsion_freeze['FCADSTATUS']))
	{
	
		if($add_edit=='Add')
		{
		$photo_path="";

$s3 = S3Client::factory(
			array(
				'credentials' => array(
					'key' => IAM_KEY,
					'secret' => IAM_SECRET
				),
				'version' => "latest",
				'region'  => 'ap-south-1'
			)
		);

$query = "select funivcode from control";
		$results = $aobj_context->mobj_db->GetRow($query);
		$funivcode = $results['funivcode'];

$unlink_file = $aobj_context->main_src.$db."/".$unlink_file;

if(file_exists($unlink_file)) 
		{

try {
				$res = $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $funivcode."/".$image_path, 'SourceFile' => $unlink_file]);
				$photo_path=$image_path; 
				unlink($unlink_file);
			}catch(S3Exception $e) {
				$arr['message'] = 'Unable to upload Photo';
				echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
				return;
			}
		}

$queryaadhar = "Select faadharno from studadm
		where faadharno = '{$aadharno}' and ifnull(fdeleted,'') <> 'T'";
		$res_queryaadhar = $aobj_context->mobj_db->GetRow($queryaadhar);
			if($funivcode == '050'){
				$cond =",fpevmonth,feligiblityfee,fregfee,frecpno,fregrecpno,fregrecpdate,frecpdate,
				fscholership,fdocument";
				$cond2 = ",'{$passyrmonth}','{$eligiblfee}','{$regFee}','{$receiptNo}','{$regRecNo}','{$regRecDate}','{$receiptDate}','{$scholard}',
				'{$documents}'";
			}
			$dypcnd1 = "";
			$dypcnd2 = "";

if($funivcode == '051')
			{
				$dypcnd1 = ",fapprstatus,fappstatus,fstudstatus";
				$dypcnd2 = ",'APPROVED','verified','APPROVED'";
			}

if(!$res_queryaadhar){
				$lstr_qry = "insert into studadm(fabcno,fayear,fadmyear,fslno,fdegree,fexamno,fcollcode,fname,ffatname,fmotname,fgender,
				fdob,fnational,freligion,fadmdate,fcaste,fcatecode,faadharno,ffatocc,ffatincome,fmotocc,
				fmotincome,fmottong,ftudystate,fmotmob,fmotemail,ffatmob,ffatemail,fguamob,fguaemail,fstudmob,fstudemail,
				fcommadd1,fcommadd2,fperadd1,fperadd2,fcommpost,fperpost,fcommtaluk,fpertaluk,fcommdist,fcommstate,fperstate,fcommpin,fperpin,
				fqual,fqregno,fqcollname,fareatype,fboard,fboardstate,fqyear,fphymax,fphysec,fphyper,fmatmax,fmatsec,
				fmatper,fchemax,fchesec,fcheper,fpcmmax,fpcmsec,fpcmper,fpumax,fpusec,fpuper,fengmax,fengsec,fengper,fphotopath,
				frollno,fcolldist,fblood_group,fseattype,flogname,fsscperc,fnucatno,fnucatrank,fperdist $cond $dypcnd1
				) values('{$abcno}','{$f_year}','{$f_year}','{$degree_slno}','{$degree}','{$degree_exam}','{$college_code}',
				'{$candidate_name}','{$fname}','{$mname}','{$gender}','{$dob}','{$nationality}','{$religion}','{$admdate}',
				'{$catecode}','{$caste}','{$aadharno}','{$fatocc}','{$fatincome}','{$motocc}','{$motincome}','{$mottong}','{$studystate}',
				'{$motmob}','{$motemail}','{$fatmob}','{$fatemail}','{$guamob}','{$guaemail}','{$studmob}',
				'{$studemail}','{$commadd1}','{$commadd2}','{$peradd1}','{$peradd2}','{$commpost}','{$perpost}','{$commtaluk}','{$pertaluk}',
				'{$commdist}','{$commstate}','{$perstate}','{$commpin}','{$perpin}','{$qual}','{$qregno}','{$collname}','{$areytype}','{$board}','{$boardstate}',
				'{$year}','{$phymax}','{$physec}','{$phyper}','{$matmax}','{$matsec}','{$matper}','{$chemax}','{$chesec}',
				'{$cheper}','{$pcmmax}','{$pcmsec}','{$pcmper}','{$pumax}','{$pusec}','{$puper}','{$engmax}',
				'{$engsec}','{$engper}','{$photo_path}','{$sanno}','{$colldist}','{$bloodgrp}','{$seattype}','{$log_name}',
				'{$sslc}','{$nucatno}','{$nucatrank}','{$fperdist}' $cond2 $dypcnd2)";
				// var_dump($lstr_qry);die();
				$lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry);
				$appno = $aobj_context->mobj_db->insert_id($Insertquery);
			}else{
				$arr='Aadhar No. Already Exists';
				echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Failure"); 
				return;
			}
			
	 			
						
					for($k=0;$k<count($prevsub_arr_data);$k++)
					{
						$insert_options="insert into studprevsub(fdegree,
						fcollcode,
						fappno,
						fsubcode,
						fmaxmarks,
						fsecmarks,
						fpercent)
						values
						(
						'{$degree}',
						'{$college_code}',
						'{$appno}',
						'{$prevsub_arr_data[$k]->subcode}',
						'{$prevsub_arr_data[$k]->maxmarks}',
						'{$prevsub_arr_data[$k]->secmarks}',
						'{$prevsub_arr_data[$k]->perct}'
						)
						";
							
						$lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options);
					}

for($k=0;$k<count($sub_arr_data);$k++)
					{
						$insert_options="insert into options(FDEGREE,
						FEXAMNO,
						FCOLLCODE,
						FSLNO,
						FSUBCODE,
						FDELETED,
						FAPPNO)
						values
						(
						'{$degree}',
						'{$degree_exam}',
						'{$college_code}',
						'{$degree_slno}',
						'{$sub_arr_data[$k]->sub_code}',
						'F',
						'{$appno}'
						)
						";
						
						$lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options);
					}
					
					if($lobj_rs) 
					{
							$arr='Updated Successfully. Application No.: '.$appno;
				             echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
							 return;
					}	
			        else
					{
						 $arr='Insertion Failed';
							echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
						   return; 
						   
					}
		}
		else if($add_edit=='Edit') // 
		{  
			$get_existing_data="select fphotopath from studadm where 
				fappno='{$stud_admno}' and 
				FDEGREE='{$degree}' and 
				FCOLLCODE='{$college_code}'";
			$lobj_get_existing_data = $aobj_context->mobj_db->GetRow($get_existing_data);
			$image_path= $lobj_get_existing_data['fphotopath'] ;
			if($image_path == '')
				$image_path="student_photos/{$college_code}/".replaceChars($degree).'/'.$stud_admno."_".date("Y").".jpg";

//$unlink_file = $aobj_context->main_src.$db."/".$unlink_file;
			//  if(isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '')         
			// 			{	
						 
			// 			if(move_uploaded_file($_FILES['student_entry_upload']['tmp_name'],$full_file_path))
			// 			 {	
			// 				$unlink_file=$aobj_context->main_src."/".$existing_photo_path;
			// 				 unlink($unlink_file);						 
			// 				//rename($unlink_file,$unlink_file."_tmp");						 
			// 				$existing_photo_path=$image_path;
			// 			 }
			// 			}

$query = "select funivcode from control";
			$results = $aobj_context->mobj_db->GetRow($query);
			$funivcode = $results['funivcode'];
			$s3 = S3Client::factory(
				array(
					'credentials' => array(
						'key' => IAM_KEY,
						'secret' => IAM_SECRET
					),
					'version' => "latest",
					'region'  => 'ap-south-1'
				)
			);
			$unlink_file = $aobj_context->main_src.$db."/".$unlink_file;
			if(file_exists($unlink_file)) 
			{
				try {
					$res = $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $funivcode."/".$image_path, 'SourceFile' => $unlink_file]);
					$image_path=$image_path; 
					unlink($unlink_file);
				}catch(S3Exception $e) {
					$arr['message'] = 'Unable to upload Photo';
					echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
					return;
				}
			}

$queryaadhar = "Select faadharno from studadm
				where fappno = '{$stud_admno}' and ifnull(faregno,'') <> ''
				and ifnull(fedit,'') <> 'T'";
				$res_queryaadhar = $aobj_context->mobj_db->GetRow($queryaadhar);
				if($res_queryaadhar)
				{
					$arr='USN No. Generated. Modification not allowed';
					echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
					return;

}else
				{
					
					if($funivcode == '050'){
						$cond =",fpevmonth = '{$passyrmonth}',feligiblityfee = '{$eligiblfee}',
						fregfee = '{$regFee}',frecpno = '{$receiptNo}',fregrecpno = '{$regRecNo}',
						fregrecpdate = '{$regRecDate}',frecpdate = '{$receiptDate}',
						fscholership = '{$scholard}',fdocument = '{$documents}'";
					}
					$update_qry = "update studadm set 
					fname  = '{$candidate_name}',
					ffatname = '{$fname}',
					fdegree = '{$degree}',
					fexamno = '{$degree_exam}',
					fmotname = '{$mname}',
					fgender = '{$gender}',
					fdob = '{$dob}',
					frollno = '{$sanno}',
					fseattype = '{$seattype}',
					fnational = '{$nationality}',
					freligion = '{$religion}',
					fadmdate = '{$admdate}',
					fcaste = '{$catecode}',
					fcatecode = '{$caste}',
					faadharno = '{$aadharno}',
					ffatocc = '{$fatocc}',
					ffatincome = '{$fatincome}',
					fmotocc = '{$motocc}',
					fmotincome = '{$motincome}',
					fmottong = '{$mottong}',
					ftudystate = '{$studystate}',
					fblood_group = '{$bloodgrp}',
					fmotmob = '{$motmob}',
					fmotemail = '{$motemail}',
					ffatmob = '{$fatmob}',
					ffatemail = '{$fatemail}',
					fguamob = '{$guamob}',
					fguaemail = '{$guaemail}',
					fstudmob = '{$studmob}',
					fstudemail = '{$studemail}',
					fperadd1 = '{$peradd1}',
					fperadd2 = '{$peradd2}',
					fcommpost = '{$commpost}',
					fperpost = '{$perpost}',
					fcommadd1 = '{$commadd1}',
					fcommadd2 = '{$commadd2}',
					fcurradd1 = '{$commadd1}',
					fcurradd2 = '{$commadd1}',
					fperstate = '{$perstate}',
					fcommpin = '{$commpin}',
					fperpin = '{$perpin}',
					fperdist = '{$fperdist}',
					fcommdist = '{$commdist}',
					fqual = '{$qual}',
					fqregno = '{$qregno}',
					fqcollname = '{$collname}',
					fareatype = '{$areytype}',
					fboard = '{$board}',
					fboardstate = '{$boardstate}',
					fqyear = '{$year}',
					fupduser = '{$log_name}',
					fupddate = now(),
					fphotopath = '{$image_path}',
					fsscperc = '{$sslc}',
					fnucatno= '{$nucatno}',
					fnucatrank= '{$nucatrank}',
					fabcno = '{$abcno}'
					$cond
					where fappno = '{$stud_admno}'
					and fcollcode = '{$college_code}'";
					// var_dump($update_qry);
					$lobj_rs = $aobj_context->mobj_db->Execute($update_qry);
				}	
						
			 
				$delete_from_options="delete from studprevsub where FCOLLCODE='{$college_code}' 
							and fappno='{$stud_admno}'";
				$lobj_delete_from_options = $aobj_context->mobj_db->Execute($delete_from_options);

for($k=0;$k<count($prevsub_arr_data);$k++)
				{
					$insert_options="insert into studprevsub(fdegree,
					fcollcode,
					fappno,
					fsubcode,
					fmaxmarks,
					fsecmarks,
					fpercent)
					values
					(
					'{$degree}',
					'{$college_code}',
					'{$stud_admno}',
					'{$prevsub_arr_data[$k]->subcode}',
					'{$prevsub_arr_data[$k]->maxmarks}',
					'{$prevsub_arr_data[$k]->secmarks}',
					'{$prevsub_arr_data[$k]->perct}'
					)
					";
					
					$lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options);
					// var_dump($lobj_insert_options);
				}
						//  die();
				$delete_from_options="delete from options where FDEGREE='{$degree}'
				and FEXAMNO='{$degree_exam}' and FCOLLCODE='{$_SESSION['collcode']}' 
				and fappno='{$stud_admno}'";
				$lobj_delete_from_options = $aobj_context->mobj_db->Execute($delete_from_options);
				
				for($k=0;$k<count($sub_arr_data);$k++)
				{
					$insert_options="insert into options(FDEGREE,
					FEXAMNO,
					FCOLLCODE,
					FSLNO,
					FSUBCODE,
					FDELETED,FAPPNO)
					values
					(
					'{$degree}',
					'{$degree_exam}',
					'{$_SESSION['collcode']}',
					'{$degree_slno}',
					'{$sub_arr_data[$k]->sub_code}',
					'F',
					'{$stud_admno}'
					)";
					
					$lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options);
					// var_dump($insert_options);
				}
				// die();
					if($lobj_rs) 
					{
							$arr='Student Record Updated Successfully';
				             echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
							 return;
					}	
			        else
					{
							$arr='Updation Failed';
							echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
						   return;
					}
			}
	 }
	else
	{
			$arr='Student Admission Freezed By Admin';
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
			return;		
	}
	}
	}
	else
	{
		$arr='Session Expired,please login';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-9,"Failure");
		return;	
	
	}
}		
// delete Record 
function disableRecord($aobj_context)
{
	$sl_no = $aobj_context->mobj_data["sl_no"]; 
	$degree_code = $aobj_context->mobj_data["degree_code"]; 	
	$exam = $aobj_context->mobj_data["exam"]; 	
	
	include_once("/JSON.php"); 
	$json = new Services_JSON();
	
	$lstr_param = stripslashes($aobj_context->mobj_data["delete_arr"]);
	$mobj_jsondata = $json->decode($lstr_param);
	$delete_arr_data = get_object_vars($mobj_jsondata);
	
	for($k=0;$k<count($delete_arr_data);$k++)
	{	   
 	    /* $lstr_qry = "delete  
			from student 
			 where FDEGREE='{$delete_arr_data[$k]->degree_code}'
			       AND 
			       FEXAMNO='{$delete_arr_data[$k]->exam}'
				   AND
				   FSLNO ='{$delete_arr_data[$k]->sl_no}'
				   ";  */
	//echo $lstr_qry ;
     
	   
	    $disable_student_record = 	"	UPDATE studadm SET FDELETED='T' 
								WHERE  FDEGREE='{$delete_arr_data[$k]->degree_code}' 
								and FEXAMNO='{$delete_arr_data[$k]->exam}'
								and FSLNO='{$delete_arr_data[$k]->sl_no}' and FCOLLCODE ='{$_SESSION['collcode']}' ";	
								
		  $lobj_rs = $aobj_context->mobj_db->Execute($disable_student_record);	
 	  
								
	}
	
/* 	
//FDELETED	
    $disable_student_record = 	"	UPDATE student SET FDELETED='T' 
								WHERE  FDEGREE='{$degree_code}' and FEXAMNO='{$exam}' 
								and FSLNO='{$sl_no}' and FCOLLCODE ='{$_SESSION['collcode']}' ";	
								
	$disable_options_record = 	"	UPDATE options SET FDELETED='T' 
								WHERE  FDEGREE='{$degree_code}' and FEXAMNO='{$exam}' 
								and FSLNO='{$sl_no}' and FCOLLCODE='{$_SESSION['collcode']}' ";								
	//echo $disable_student_record; die();	
	$lobj_disable_student_record = $aobj_context->mobj_db->Execute($disable_student_record);	
	$lobj_disable_options_record = $aobj_context->mobj_db->Execute($disable_options_record); */	
	
	if($lobj_rs) 
	{			
			 echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); 
			 return;
	}	
	else
	{			
			echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure");
		   return;
	}
	
}
function getSubjectNames($aobj_context) // purpose to put subject name to dynamic text boxes -- naveen
{
	$subject_code = $aobj_context->mobj_data["subject_code"]; 
	$degree_code = $aobj_context->mobj_data["degree_code"]; 	
	$exam = $aobj_context->mobj_data["exam"]; 	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 	
	$get_sub_names="select FSUBCODE as id,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_code}' and s.FEXAMNO='{$exam}'  
						and FSUBCODE='{$subject_code}'
						group by  FSUBCODE";
	$lobj_get_sub_names = $aobj_context->mobj_db->getRow($get_sub_names);	
	
	echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_sub_names,0,"success"); 
	return;
	
}
//   $g_student_retain_per_mode=1; 
function getsubjectAppearingTotal($aobj_context)
{
	session_start();
	$degree_code = $aobj_context->mobj_data["degree_code"]; 	
	$exam = $aobj_context->mobj_data["exam"]; 	
	$sl_no = $aobj_context->mobj_data["sl_no"]; 
	$pmode = $aobj_context->mobj_data["pmode"]; 
	$sub_degree = trim($aobj_context->mobj_data["sub_degree"]); 
	$college_code=$_SESSION['collcode'];	
	$combination = trim($aobj_context->mobj_data["combination"]);
	$degree_code=(!empty($sub_degree))?$sub_degree:$degree_code;
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 	
	$get_sub_total=" select FTOTSUB from degree where FDEGREE= '{$degree_code}' and FEXAMNO='{$exam}'";
	$lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total);
		
		$total_sub=$lobj_sub_total['FTOTSUB'];
		//echo $total_sub; die();
	
		
		$get_exsting_data="	select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from 
							(select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options
							where FSLNO='{$sl_no}' and FCOLLCODE='{$_SESSION['collcode']}' 
							and FEXAMNO='{$exam}' and FDEGREE='{$degree_code}') 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_code}' and s.FEXAMNO='{$exam}') 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
		 
		$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_code}' 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_code}'  and INSTR(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.="<th align='left' colspan='3' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Subjects Appearing</th>";		
		$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);
		//echo 'aa';			
			foreach($lobj_get_true_sub_names as $key=>$value)
			{
			  /* 
				if($k%2==0)
				{
				$class='tbl_row';
				$inp_class='tbl_row_input';
				}
				else
				{
				$input_class='tbl_row1'; 
				$inp_class='tbl_row1_input';
				} */  
				 $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow'>";
				 $e_data.="<td class='tbl_row_new' 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=''; 			
			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='{$college_code}' and
											s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and
											s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and 
											d.fslno = 
											( select MAX(s.fslno) from studadm s 
											where s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' 
											AND FCOLLCODE='{$college_code}' ) 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' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' 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":''; 
				$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' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} {$on_blur } {$name} {$read_only} 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' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' 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;
		
	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	return;  			
}

}

$query = "select funivcode from control";
	$results = $aobj_context->mobj_db->GetRow($query);

$funivcode = $results['funivcode'];
	
	$get_student_details_slno = "select s.*, s.FSLNO,s.FDEGREE,d.FDESCPN,
	s.FEXAMNO,s.FCOLLCODE,s.FNAME, 
	s.FFATNAME,s.FMOTNAME,ifnull(FPASSMNTH,'') as FPASSMNTH,ifnull(FPASSYER,'') as FPASSYER,
	ifnull(FMARKSECURED,'') as FMARKSECURED,
	ifnull(FMARKTOTAL,'') as FMARKTOTAL, ifnull(FPERMARK,'') as FPERMARK,
	DATE_FORMAT(s.FDOB,'%d/%m/%Y') as FDOBirth  ,FCATBIRTH,
	s.Fgender,s.FCASTE,s.FNATIONAL,s.FENGLISH,s.FCURRADD1,
	REG_FEE,EXAM_FEE,GRADE_CARD_FEE,TOTAL_FEE,
	s.FCURRADD2,
	s.FCURRADD3,
	s.FCURRADD4,
	s.FPERMADD1,
	s.FPERMADD2,
	s.FPERMADD3,
	s.FPERMADD4,
	DATE_FORMAT(s.FADMDATE,'%d/%m/%Y') as FADMISDATE,
	s.FSUBDEGREE,
	concat('https://university-student-photos.s3.ap-south-1.amazonaws.com/','{$funivcode}','/',s.FPHOTOPATH) as FPHOTOPATH,
	concat('https://university-student-photos.s3.ap-south-1.amazonaws.com/','{$funivcode}','/',s.FSIGNPATH) as FSIGNPATH,
	s.FLATERAL_ENTRY,s.FBLOOD_GROUP,s.FCONTACT_NO,s.FEMAIL,s.FMOT_OCC,
	s.FFAT_OCC,
	s.FREC_ORDER_NO,
	DATE_FORMAT(s.FREC_ORDER_DATE,'%d/%m/%Y') as FREC_ORDER_DATE,
	s.FAFF_ORDER_NO,
	DATE_FORMAT(s.FAFF_ORDER_DATE,'%d/%m/%Y') as FAFF_ORDER_DATE,
	s.FRELIGION,
	ifnull(s.FDELETED,'F') as FDELETED,FFEEPAID,FRECNO,
	date_format(FRECDATE,'%d/%m/%Y') as FRECDATE,
	FREMARKS,FCOMBCODE,FMOBILE_NO,
	s.fasty,s.faqty
	from studadm s 
	inner join  degree d on d.FDEGREE=s.FDEGREE
	where s.FSLNO='{$sl_no}' and s.FDEGREE='{$degree}' 
	and s.FCOLLCODE='{$_SESSION['collcode']}' and d.FEXAMNO='A'";	 
 
	$lobj_get_student_details = $aobj_context->mobj_db->getRow($get_student_details_slno);
	 //echo $get_student_details_slno; die();
	
	$query = "select * from qualdet where fslno = '{$sl_no}' and fdegree = '{$degree}' 
	and fcollcode ='{$_SESSION['collcode']}'";
	$results = $aobj_context->mobj_db->getAll($query);

$arr['studdet'] = $lobj_get_student_details;
	$arr['qualdet'] = $results;
	$arr['qualcount'] = 0;//count($results);;
	
	if(!empty($lobj_get_student_details) && $lobj_get_student_details['FDELETED'] == 'F' )
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;
	}
	else if(!empty($lobj_get_student_details) && $lobj_get_student_details[FDELETED] == 'T' )
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-1,"Disabled"); 
		return;		
	}
	else if(empty($lobj_get_student_details) )
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-2,"Failure"); 
		return;
	}
}
function generateAutoIncrementSlNo($aobj_context)
{
 $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	session_start();
	$degree = $aobj_context->mobj_data["degree"]; 
	$get_generateAutoIncrementSlNo = "select right(concat('0000',ifnull(max(FSLNO),0)+01),4)  as  FSLNO 
					from studadm
					where  FDEGREE='{$degree}' and FCOLLCODE='{$_SESSION['collcode']}'";
		 //echo $get_generateAutoIncrementSlNo;
	$lobj_get_generateAutoIncrementSlNo = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo);
	 
	if($lobj_get_generateAutoIncrementSlNo)
	{
	echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_generateAutoIncrementSlNo['FSLNO'],0,"success"); 
	return;
	}
	else
	{
	echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-1,"success"); 
	return;
	}
	
}

/* 
function ViewStudentDetails($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('grid_sl_no','grid_degree','grid_sub_degree','grid_exam','grid_count');
		$display_obj->display_qry="select concat(FDEGREE,FSLNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree,FSUBDEGREE as grid_sub_degree,
						FEXAMNO as  grid_exam,
						FNAME as grid_name,
						concat(real_name,date_format(FLOGDATE,' %d-%b-%Y')) as created_by
						from 
					studadm st
					left join s_sysdb s on s.internal_code=FUSERID
					where 1=1 and ifnull(st.FDELETED,'F')='F' 
					and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}'";	
 			
		$display_obj->DisplayDetailsInGrid();
} */

function ViewStudentDetailsVKU($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('grid_sl_no','grid_degree','grid_exam','grid_count');
		$display_obj->display_qry="select concat(FDEGREE,FEXAMNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree,
						FEXAMNO as  grid_exam, count(*) as grid_count from studadm st left join s_sysdb s on s.internal_code=FUSERID
					where 1=1 and ifnull(st.FDELETED,'F')='F' 
					and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}' group by FDEGREE,FEXAMNO";	
 			
		$display_obj->DisplayDetailsInGrid();
}

function ViewDegreeWiseStudentDetailsVKU($aobj_context)
{
	session_start();
	 
	$college_code = $_SESSION['collcode'];	
	$degid = $aobj_context->mobj_data["degid"];
	  include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php');
		$display_obj=new display_details_in_grid($aobj_context);

$cnd = "concat(FDEGREE,FSLNO) as id, FSLNO as grid_sl_no,";
	if($_SESSION['FUNIVCODE'] == '023' || $_SESSION['FUNIVCODE'] == '035' || $_SESSION['FUNIVCODE'] == '048')
	{
		$cnd = "concat(FDEGREE,fappno) as id, fappno as grid_sl_no,";
	}

$display_obj->table_cols=array('grid_sl_no','grid_degree','grid_sub_degree','grid_exam','grid_name','created_by');
		$display_obj->display_qry="select {$cnd}  FDEGREE as grid_degree,FSUBDEGREE as grid_sub_degree,
						FEXAMNO as  grid_exam,
						FNAME as grid_name,
						concat(real_name,date_format(FLOGDATE,' %d-%b-%Y')) as created_by
						from 
					studadm st
					left join s_sysdb s on s.internal_code=FUSERID
					where 1=1 and ifnull(st.FDELETED,'F')='F' 
					and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}' and concat(FDEGREE,FEXAMNO) ='{$degid}'";	
 			
		$display_obj->DisplayDetailsInGrid();
}

function ViewCourseWiseStudentDetails($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('grid_sl_no','grid_degree','grid_sub_degree','grid_exam','grid_name','created_by');
		$display_obj->display_qry="select concat(FDEGREE,FSLNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree,FSUBDEGREE as grid_sub_degree,
						FEXAMNO as  grid_exam,
						FNAME as grid_name,
						concat(real_name,date_format(FLOGDATE,' %d-%b-%Y')) as created_by
						from 
					studadm st
					left join s_sysdb s on s.internal_code=FUSERID
					where 1=1 and ifnull(st.FDELETED,'F')='F' 
					and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}'";	
 			
		$display_obj->DisplayDetailsInGrid();
}

}

function getCombinationNamesVKU($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	session_start();
	$collcode = $_SESSION['collcode'];  
	$degreecode = $aobj_context->mobj_data["degree"];
	$get_honours="SELECT  FCOMBCODE as internal_code, FCOMBDESC as value from mascomb 
	where fdegree = '{$degreecode}'";
	$lobj_get_honours = $aobj_context->mobj_db->getAll($get_honours);

$get_data="SELECT distinct FDEGREE AS internal_code,CONCAT(FDEGREE,' - ',FDESCPN) AS value FROM degree
	where fdegree like 'b%' and fexamno = 'A'";
	$up_obj=$aobj_context->mobj_db->GetAll($get_data);
	$arr['degree']=$up_obj;
	$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"); 
	}

}

$s3 = S3Client::factory(
			array(
				'credentials' => array(
					'key' => IAM_KEY,
					'secret' => IAM_SECRET
				),
				'version' => "latest",
				'region'  => 'ap-south-1'
			)
		);

if(move_uploaded_file($_FILES[$file_id]['tmp_name'],$root_file_name))
		  {

$query = "select funivcode from control";
					$results = $aobj_context->mobj_db->GetRow($query);

$funivcode = $results['funivcode'];

$arr['path']=$attachement_path;					
					$arr['id']=$doc_type_int_code;					
					$arr['file_name']=$file_name;
					try {
						$s3->putObject(['Bucket' => ADMISSION_CERTIFICATES, 'Key' => $funivcode.'/'.$attachement_path, 'SourceFile' => $root_file_name]);
						$del_query = "delete from studoc
						where ref_mas_doc_code='{$doc_type_int_code}'
						and login_cnt='{$login_cnt}'";
						$up_obj=$aobj_context->mobj_db->Execute($del_query);

$insert_doc="INSERT INTO studoc(ref_mas_doc_code, login_cnt, file_path, created_date, fcollcode,fdegree,app_no)
						values('{$doc_type_int_code}','{$login_cnt}','{$attachement_path}',now(),'{$college_code}','{$degree}','{$slno}')";
						$up_obj=$aobj_context->mobj_db->Execute($insert_doc); 
						unlink($root_file_name);
						echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");

return;
					} catch(S3Exception $e){
						$arr['message'] = 'Unable to upload documents';
						echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
						return;
					}
				
								
			 			
		  }
		  else
		  {
				$data="Moving {$file_name} failed";						
				echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
				return;
		  }
		} 
		else
		{
		$data="File is empty, not moved";						
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
		return;
		}
	}	
	
	function UploadEditEmployeeDocumentsRUR($aobj_context)
	{	
		session_start();
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		$college_code = $_SESSION['collcode'];
		$login_cnt = $_SESSION['login_cnt'];
		$degree = $aobj_context->mobj_data["degree"];
		$collcode = $aobj_context->mobj_data["collcode"];
		$slno = $aobj_context->mobj_data["slno"];
		$db = $aobj_context->mobj_data["db"];
		
		$dir_path=$aobj_context->main_src.$db."/certificates/";
		mkdir($dir_path);
		chmod($dir_path,7777);
		$cert_file_name=trim($aobj_context->mobj_data["file_name"]);
		$doc_type_int_code=trim($aobj_context->mobj_data["doc_type_int_code"]);
			
		$file_id="ed_{$doc_type_int_code}";
		
		$file_name=replaceChars(basename($_FILES[$file_id]['name']));
		//$file_ext=$path_arr['extension'];
		$arr['file_name']=$file_name;	
		if(trim($college_code) != '')
		{
			
			if(isset($file_name) && $file_name != '')         
			{ 		
				$time = date("Ymdhms");
				$path_arr=pathinfo($_FILES[$file_id]['name']);
				$file_ext=$path_arr['extension'];
				$root_file_name=$dir_path."{$time}_{$cert_file_name}.".$file_ext;	
				$attachement_path="certificates/{$time}_{$cert_file_name}.".$file_ext;

// $s3 = S3Client::factory(
				// 	array(
				// 		'credentials' => array(
				// 			'key' => IAM_KEY,
				// 			'secret' => IAM_SECRET
				// 		),
				// 		'version' => "latest",
				// 		'region'  => 'ap-south-1'
				// 	)
				// );
				
				if(move_uploaded_file($_FILES[$file_id]['tmp_name'],$root_file_name))
				{
					$query = "select funivcode from control";
					$results = $aobj_context->mobj_db->GetRow($query);

$funivcode = $results['funivcode'];

$arr['path']=$attachement_path;					
					$arr['id']=$doc_type_int_code;					
					$arr['file_name']=$file_name;
					$arr['cert_file_name']=$cert_file_name;
					// try {
					// 	$s3->putObject(['Bucket' => ADMISSION_CERTIFICATES, 'Key' => $funivcode.'/'.$attachement_path, 'SourceFile' => $root_file_name]);
					// 	$del_query = "delete from studoc
					// 	where ref_mas_doc_code='{$doc_type_int_code}'
					// 	and login_cnt='{$login_cnt}'";
					// 	$up_obj=$aobj_context->mobj_db->Execute($del_query);

// 	$insert_doc="INSERT INTO studoc(ref_mas_doc_code, login_cnt, file_path, created_date, fcollcode,fdegree,app_no)
					// 	values('{$doc_type_int_code}','{$login_cnt}','{$attachement_path}',now(),'{$college_code}','{$degree}','{$slno}')";
					// 	$up_obj=$aobj_context->mobj_db->Execute($insert_doc); 
					// 	unlink($root_file_name);
					// 	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");

// 	return;
					// } catch(S3Exception $e){
					// 	$arr['message'] = 'Unable to upload documents';
					// 	echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
					// 	return;
					// }
					
					
					// $arr['path']=$attachement_path;					
					// $arr['id']=$doc_type_int_code;					
					// $arr['file_name']=$file_name;	
					// $delete="delete from studoc
					// where ref_mas_doc_code='{$doc_type_int_code}'
					// and login_cnt='{$login_cnt}'
					// 			";	
					// $lobj_delete= $aobj_context->mobj_db->Execute($delete);			
					// $insert="INSERT INTO studoc(ref_mas_doc_code, login_cnt, file_path, created_date, fcollcode,fdegree,app_no)
					// values('{$doc_type_int_code}','{$login_cnt}','{$attachement_path}',now(),'{$college_code}','{$degree}','{$slno}')";	
					// $lobj_insert= $aobj_context->mobj_db->Execute($insert);
					// // echo $insert;
					echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
					return; 		
			  	}
			  else
			  {
					$data="Moving {$file_name} failed";						
					echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
					return;
			  }
			} 
			else
			{
				$data="File is empty, not moved";						
				echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
				return;
			}
		}
		else
		{
			$data="Moving {$file_name} failed";						
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
			return;
		}	
	}	
	
	function setAdmLoginCntr($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		session_start();
		$login_counter="select (ifnull(login_cnt,0) +1)as login_cnt from login_counter";		
		$lobj_rs_counter = $aobj_context->mobj_db->GetRow($login_counter);	
		$count_val=$lobj_rs_counter['login_cnt'];

$update_log_cnt="update login_counter set login_cnt={$count_val}";         		 				
		$lobj_update_log_cnt = $aobj_context->mobj_db->Execute($update_log_cnt);
		setcookie("login_cnt",$count_val,time()+36000333, '/' );
		$_SESSION['login_cnt']=$count_val;	
		echo $aobj_context->mobj_output->ToJSONEnvelope($count_val,0,"success");
		return;
	}

function getstudfee($aobj_context)
	{

$aqty=trim($aobj_context->mobj_data["aqty"]);
		$degree=trim($aobj_context->mobj_data["degree"]);
		$asty=trim($aobj_context->mobj_data["asty"]);

$qery = "select ffee from admfeestr where fdegree = '{$degree}' and fexamno = 'A' and fcombcode = '{$aqty}'
		and fcatcode = 'GM' and FCONSTYPE = '{$asty}'";
		
		$res = $aobj_context->mobj_db->GetRow($qery);	
		
		if($res)
		{
			$arr['fee'] = $res['ffee'];
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
			return;
		}else
		{
			$data = "Fee Deatils not Defined.";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
			return;	
		}

}

function loadAdmDegCode($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
		session_start();
		$collcode = $_SESSION['collcode'];

$cnd = "and fcollcode = '{$collcode}'";

if(strtolower($collcode) == 'lsys')
		{
			$cnd = "and fcollcode = '8305'";
		}

$query = "select d.fdegree as internal_code,concat(d.fdegree,' - ',d.fdescpn) as value 
		from degree d inner join colldeg c on d.fdegree = c.fdegree and d.fexamno  = 'A'
		where d.fadmdeg = 'T'
		{$cnd}";
		$res = $aobj_context->mobj_db->GetAll($query);

if($res)
		{
			$arr['degcode'] = $res;
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
			return;
		}else
		{
			$data = "Admission Degree Not Found. Concat University";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
			return;	
		}

}

function GetCombinationFeeListRUR($aobj_context)
	{
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
		$fdegree = $aobj_context->mobj_data["degree_code"];
		$fexamno = $aobj_context->mobj_data["exam"];
		$state = $aobj_context->mobj_data["state"];
		$adate = $aobj_context->mobj_data["adate"];
		$board = $aobj_context->mobj_data["board"];
		$db = $aobj_context->mobj_data["db"];
	
		session_start();
		$collcode = $_SESSION['collcode'];
		
		if($state == '0')
			$state = 'Karnataka';
		if($db == 'vskub')
		{
			$get_details = "select '500' as fee from control where 
			date_format(str_to_date('{$adate}','%d/%m/%Y'),'%Y-%m-%d')
			between '2022-03-26' and '2022-12-13'";
			$res1 = $aobj_context->mobj_db->GetRow($get_details);

// $get_details = "select '2000' as fee from control where 
			// date_format(str_to_date('{$adate}','%d/%m/%Y'),'%Y-%m-%d')
			// between '2021-10-14' and '2021-10-30'";
			// $res2 = $aobj_context->mobj_db->GetRow($get_details);

// $query = "select ('2000'+DATEDIFF(date_format(str_to_date('{$adate}','%d/%m/%Y'),'%Y-%m-%d'), '2021-10-31')*200) as fee from control where 
			// date_format(str_to_date('{$adate}','%d/%m/%Y'),'%Y-%m-%d')
			// between '2021-10-31' and date_format(now(),'%Y-%m-%d')";
			// $res3 = $aobj_context->mobj_db->GetRow($query);
					
			$fine=0;
			if($res1)
				$fine = '500';
			else if($res2)	
				$fine = '2000';
			else if($res3)	
				$fine = $res3['fee'];
			$feetype = "Normal Fee";
			if($board == 'State Board')	
				$feetype = "Normal Fee";
			else if($board == 'CBSE Board')	
				$feetype = "CBSE Board";
			else if($board == 'Other Board')	
				$feetype = "Other Board";
			else if($board == 'VSKU University')
				$feetype =  "VSKU University";
			else if($board == 'Other University')
				$feetype =  "Other University";
			else if($board == 'Other State')
				$feetype =  "Other State";	
				
			$get_details = "SELECT FHEADCODE,if(FHEADCODE = '02 Fine','{$fine}',FFEE) as FFEE,
							ifnull(FMODIFY,'F') as FMODIFY,
							if(FHEADCODE = '02 Fine','{$fine}',FFEE) as fee_paid,
							FCOMBCODE,FCATCODE
							FROM admfeestr
							WHERE FDEGREE='{$fdegree}'
							AND FEXAMNO='{$fexamno}'
							AND FCOMBCODE='ADM'
							and fconstype = '{$feetype}'
							AND FCATCODE='GM' order by fheadcode";
						
		}else
		{

$get_details = "SELECT FHEADCODE,if('$state' = 'Karnataka',FFEE,FPRFEE) as FFEE,
							ifnull(FMODIFY,'F') as FMODIFY,
							if('$state' = 'Karnataka',FFEE,FPRFEE) as fee_paid,
							FCOMBCODE,FCATCODE
							FROM admfeestr
							WHERE FDEGREE='{$fdegree}'
							AND FEXAMNO='{$fexamno}'
							AND FCOMBCODE='ADM'
							and fconstype = 'Normal Fee'
							AND FCATCODE='GM' order by 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'];

$FMODIFY = $av['FMODIFY']; 
			$cnd = "disabled = true";

if($FMODIFY == 'T')
			{
				$cnd = "";
			}

$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();\" {$cnd} onkeypress='return acceptNumbersOnlyForModule(event);'  type='text'  style='text-align:right;width:50px;'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['html'] =	$str_reval;
		print_r($aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"));
		return $html;
	}

$div = "";
		if($res)
		{
			foreach($res as $value)
			{
				$subtype = $value['fsubtype'];
				
				$options = "";
				$options = "<option value = ''>--Select---</option>";

$query = "select fsubcode,fsubname from subject where fdegree = '{$fdegree}' and fexamno = '{$exam}' and fsubtype = '{$subtype}'
				group by fsubcode";
				$res1 = $aobj_context->mobj_db->GetAll($query);

foreach($res1 as $optval)
				{
					$options .= "<option value = '".$optval['fsubcode']."'>".$optval['fsubname']."</option>";	
				}

$div .= "<span>".$value['fdescpn']."</span>";
				$div .="<table  style='display:'block'; overflow:auto' cellpadding='5' cellspacing='2'>
				<tbody>
					<tr>";
				for($i=1;$i<=$value['ftotsub'];$i++)
				{
					$div  .="<td>
					<select id = '".$value['fsubtype'].$i."'  style = 'width: 180px;'>".
					$options	
					."</select>
					</td>";
				}
				$div .="</tr>
					</tbody>
				</table>";
							
				
			}
		}else
		{
			$div = "<h4>No Subject Details Found</h4>";
		}

$arr['html'] =	$div;
		$arr['madsub'] = $res2;
		$arr['totsub'] = $res;
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
		return;
	}

$str_reval .= "<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>";
        $str_reval .= "<tr class='ui-state-default ui-jqgrid-hdiv'>";
        $str_reval .= "<td align='center' style='padding:4px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Sl No</td>";
        $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>App. No.</td>";
        $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Student Name</td>";
        $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Degree</td>";
        $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Cat.</td>";
        $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Adm. Date</td>";
		
		if($_SESSION['FUNIVCODE'] == '051')
			$str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>USN</td>";
		
        $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Print</td>";
        $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Action</td>";
        $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Remove</td>";
        /*$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>  &nbsp;  &nbsp;  &nbsp;  &nbsp;</td>"; */
        $str_reval .= "</tr>";

$edit = "";
        $remove = "";
        $k = 0;
        $sl_no = 1;
        if ($lobj_get_data) {
            foreach ($lobj_get_data as $ak => $av) {

//Verified
				$remove = "<center><span class='raval_submit1' style='background-color: #FF0000; border: none; color: white; padding: 4px 15px; text-align: center; text-decoration: none; display: inline-block; font-size: 12px; cursor: pointer;' onclick='RemoveApplicationNitte(\"{$av['fappno']}\", \"{$av['fdegree']}\")'><b>Remove</b></span></center>";
				$edit = "<center><span  class='raval_submit1' style='background-color:  #566573 ; border: none; color: white; padding: 4px 15px; text-align: center; text-decoration: none; display: inline-block; font-size: 12px; cursor: pointer;' onclick='EditStudentDetailsNitte(\"{$av['fappno']}\", \"{$av['fdegree']}\", \"ACK\")'><b>Edit</b></span></center>";
                $print = "<center><span class='raval_submit1' style='background-color: #008CBA; border: none; color: white; padding: 4px 15px; text-align: center; text-decoration: none; display: inline-block; font-size: 12px; cursor: pointer;' onclick='printapplicationNitte(\"{$av['fappno']}\", \"{$av['fdegree']}\")'><b>Print</b></span></center>";

/*$edit="<img  onclick='EditStudentDetails(\"{$av['fappno']}\", \"{$av['fdegree']}\")'  src='img/edit.png' title='Edit' style='width: 80px;height:25px' /> ";*/
                
                $challprint = "";
                if ($k % 2 == 0)
                    $class = 'tbl_row1';
                else
                    $class = 'tbl_row_alter1';

$str_reval .= "<tr>";
                $str_reval .= "<td class='{$class} tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >{$sl_no}</td>";
                $str_reval .= "<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;  ;text-align:center;  ' >{$av['fappno']}&nbsp;</td>";
                $str_reval .= "<td class='{$class} tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:11px;text-align:left; ' > {$av['fname']}</td>";
                $str_reval .= "<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;  ;text-align:center;  ' > {$av['fdegree']}</td>";
                $str_reval .= "<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;  ;text-align:center; ' >{$av['fcaste']}</td>";
                $str_reval .= "<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;  ;text-align:center; ' >{$av['fadmdate']}</td>";
				
				if($_SESSION['FUNIVCODE'] == '051')
					$str_reval .= "<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;  ;text-align:center; ' >{$av['frollno']}</td>";

$str_reval .= "<td class='{$class} tbl_row_new' align='center' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  padding:2px;text-align:center; cursor:pointer; ' >{$print}</td>";
                $str_reval .= "<td class='{$class} tbl_row_new' align='center' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  padding:2px;text-align:center;  ' >{$edit}</td>";
                $str_reval .= "<td class='{$class} tbl_row_new' align='center' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  padding:2px;text-align:center; ' >{$remove}</td>";

$str_reval .= "</tr>";

$sl_no++;
                $k++;
            }
        } else {
            $str_reval .= "<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-left:1px solid #C5DBEC;padding:2px;text-align:center; cursor:pointer; ' colspan = '10'><b>No deatils found for the given deatils.</b></td>";
            $str_reval .= "</tr>";
        }

$str_reval .= "</table>";
        $arr['html'] = $str_reval;
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success");
    }

function EditStudentDetailsNitte($aobj_context)
	{
		$appno = trim($aobj_context->mobj_data["appno"]);
		$db = trim($aobj_context->mobj_data["db"]);
		$collcode=$_SESSION['collcode'];

if($db == 'srun'){
			$cond = "date_format(fregrecpdate,'%d/%m/%Y') as fregrecdate,
			date_format(frecpdate,'%d/%m/%Y') as frecdate,";
		}

$query = "select date_format(fdob,'%d/%m/%Y') as dob,
		date_format(fadmdate,'%d/%m/%Y') as admdate,$cond
		s.* From studadm s 
		where fappno = '{$appno}' and fcollcode = '{$collcode}'";
		$res = $aobj_context->mobj_db->GetRow($query);
		$arr['studdet'] = $res;
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
		return;
	}

$res2 = $aobj_context->mobj_db->GetAll($query);

// var_dump($query);
		// die();
		$div = "<table width='80%' id = 'qalsemdetx' class='tr_ventor_row qaltable' cellspacing='0' cellpadding='0' border='0' >
		<thead>	
			<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>
				<td class='qaltablefisrtrd'>
					Subject
				</td>
				<td class='qaltablefisrtrd'>
					Max. Marks
				</td>
				<td class='qaltablefisrtrd'>
					Sec. Marks
				</td>
				<td class='qaltablefisrtrd'>
					Percentage
				</td>
			</tr>
		</thead>	
		<tbody>";
			
		$i = 1;
		if($res2)
		{
			foreach($res2 as $value)
			{
				$div .="<tr  class='ui-widget-content jqgrow'>
					<td class='tbl_row_new'>
						<input type='text' name='name_$i' value = '".$value['fsubname']."' disabled id = 'name_$i' style='width: 175px !important;'>
						<input type='hidden' name='code_$i' value = '".$value['fsubcode']."'  id = 'code_$i' style='width: 175px !important;'>
					</td>
					<td class='tbl_row_new'>
						<input type='text' name='max_$i' value = '".$value['fmaxmarks']."'  onchange='getperdet(\"$i\")'  id = 'max_$i' style='width: 175px !important;'>
					</td>	
					<td class='tbl_row_new'>
						<input type='text' name='sec_$i' value = '".$value['fsecmarks']."'  onchange='getperdet(\"$i\")'  id = 'sec_$i' style='width: 175px !important;'>
					</td>
					<td class='tbl_row_new'>
						<input type='text' name='per_$i' value = '".$value['fpercent']."'  disabled id = 'per_$i' style='width: 175px !important;'>
					</td>	
				</tr>";
				
							
				$i++;
			}

$div .="
					</tbody>
				</table>";
		}else
		{
			$div = "<h4>No Subject Details Found</h4>";
		}

$arr['html'] =	$div;
		
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
		return;
	}

function RemoveApplicationNitte($aobj_context)
	{

$fdegree = $aobj_context->mobj_data["fdegree"];
		$appno = $aobj_context->mobj_data["appno"];
		$collcode = $_SESSION['collcode'];
		$log_name = $_SESSION['usr'];

$upd = "update studadm set fdeleted = 'T',fdeleteusr = '{$log_name}', fdeletedate=now() 
		where fappno = '{$appno}' and fcollcode = '{$collcode}' and fdegree = '{$fdegree}'";
		$res = $aobj_context->mobj_db->Execute($upd);

if($res)
		{
			$data = "Deleted Successfully";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success");	
			return;
		}else
		{
			$data = "Try after some time";
			echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
			return;
		}

}

${this.title}

Code Editor : student_entry_nitte.php