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_rur.php

<?php

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

class applicationForm
{
	function __construct($aobj_context)
	{
		session_start();
		$this->aobj_context=$aobj_context;
		include_once("/JSON.php"); 
		$this->json = new Services_JSON();
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);	
		$this->aobj_context=$aobj_context;
		$this->ip=$_SERVER["REMOTE_ADDR"];
		$this->collcode = $_SESSION['collcode'];
		$this->login_cnt=$_SESSION['login_cnt'];
		$this->u_id = $_SESSION['user_id'];
		$this->log_name = $_SESSION['usr'];

}

function assignParams()
	{
		$this->add_edit=trim($aobj_context->mobj_data["add_edit"]);
		$this->edit_app_no = trim($this->aobj_context->mobj_data["stud_admno"]);
		$this->degree=trim($this->aobj_context->mobj_data["degree"]);
		$this->rgMultiMarks=trim($this->aobj_context->mobj_data["rgMultiMarks"]);

//$this->submarks_arr_data = get_object_vars($this->mobj_jsondata[0]);
	
	//	var_dump($query);
		//return;
		$this->examno='A';
		$this->stud_admno = trim($this->aobj_context->mobj_data["stud_admno"]);
		$this->db = trim($this->aobj_context->mobj_data["db"]);
		$this->candidate_name = strtoupper(trim($this->aobj_context->mobj_data["candidate_name"]));
		$this->fatname=strtoupper(trim($this->aobj_context->mobj_data["fname"]));
		$this->motname=strtoupper(trim($this->aobj_context->mobj_data["mname"]));
		$this->dob=trim($this->aobj_context->mobj_data["dob"]);
		$this->dobplace = trim($this->aobj_context->mobj_data["dobplace"]);
		$this->gender=trim($this->aobj_context->mobj_data["gender"]);
		$this->bloodgrp =  trim($this->aobj_context->mobj_data["bloodgrp"]); 
		$this->nationality=trim($this->aobj_context->mobj_data["nationality"]);
		$this->candidateNational=trim($this->aobj_context->mobj_data["candidateNational"]);
		$this->religion=trim($this->aobj_context->mobj_data["religion"]);
		$this->caste=trim($this->aobj_context->mobj_data["caste"]);
		$this->categoryByBirth=trim($this->aobj_context->mobj_data["categoryByBirth"]);
		$this->aadharno=trim($this->aobj_context->mobj_data["aadharno"]);
		$this->chkHydKar =  trim($this->aobj_context->mobj_data["chkHydKar"]);
		$this->area = trim($this->aobj_context->mobj_data["area"]);
		$this->state=trim($this->aobj_context->mobj_data["state"]);
		$this->peradd1=trim($this->aobj_context->mobj_data["peradd1"]);
		$this->peradd2=trim($this->aobj_context->mobj_data["peradd2"]);
		$this->peradd3=trim($this->aobj_context->mobj_data["peradd3"]);
		$this->peradd4=trim($this->aobj_context->mobj_data["peradd4"]);
		$this->commaddr1=trim($this->aobj_context->mobj_data["commaddr1"]);
		$this->commaddr2=trim($this->aobj_context->mobj_data["commaddr2"]);
		$this->commaddr3=trim($this->aobj_context->mobj_data["commaddr3"]);
		$this->commaddr4=trim($this->aobj_context->mobj_data["commaddr4"]);
		$this->email=trim($this->aobj_context->mobj_data["email"]);
		$this->mobile=trim($this->aobj_context->mobj_data["mobile"]);
		$this->incomeCrtificate = trim($this->aobj_context->mobj_data["incomeCrtificate"]);
		$this->acadyear=trim($this->aobj_context->mobj_data["acadyear"]);
		$this->admcat=trim($this->aobj_context->mobj_data["admcat"]);
		$this->sltCombination=trim($this->aobj_context->mobj_data["sltCombination"]);
		$this->sltSemester=trim($this->aobj_context->mobj_data["sltSemester"]);
		$this->admdate=trim($this->aobj_context->mobj_data["admdate"]);
		$this->admintake=trim($this->aobj_context->mobj_data["admintake"]);
		$this->admquota=trim($this->aobj_context->mobj_data["admquota"]);
		$this->lateralEnrty=trim($this->aobj_context->mobj_data["lateralEnrty"]);
		$this->rdbEnglish=trim($this->aobj_context->mobj_data["rdbEnglish"]);
		$this->rdbKannada=trim($this->aobj_context->mobj_data["rdbKannada"]);
		$this->sltLanguage1=trim($this->aobj_context->mobj_data["sltLanguage1"]);
		$this->sltLanguage2=trim($this->aobj_context->mobj_data["sltLanguage2"]);
		$this->fincome=trim($this->aobj_context->mobj_data["fincome"]);
		$this->mincome=trim($this->aobj_context->mobj_data["mincome"]);
		$this->phoneno=trim($this->aobj_context->mobj_data["phoneno"]);
		$this->lingMinority=trim($this->aobj_context->mobj_data["lingMinority"]);
		$this->regMinority=trim($this->aobj_context->mobj_data["regMinority"]);
		$this->padNational=trim($this->aobj_context->mobj_data["padNational"]);
		$this->padState=trim($this->aobj_context->mobj_data["padState"]);
		$this->typequlexam=trim($this->aobj_context->mobj_data["typequlexam"]);
		$this->instname=trim($this->aobj_context->mobj_data["instname"]);
		$this->location=trim($this->aobj_context->mobj_data["location"]);
		//$this->univname=trim($this->aobj_context->mobj_data["univname"]);
		$this->univname=trim($this->aobj_context->mobj_data["board"]);
		$this->examregno=trim($this->aobj_context->mobj_data["examregno"]);
		$this->language1=trim($this->aobj_context->mobj_data["language1"]);
		$this->specialization=trim($this->aobj_context->mobj_data["specialization"]);
		$this->modeEdu=trim($this->aobj_context->mobj_data["modeEdu"]);
		$this->interval=trim($this->aobj_context->mobj_data["interval"]);
		$this->degmarks=trim($this->aobj_context->mobj_data["degmarks"]);
		$this->entexammarks=trim($this->aobj_context->mobj_data["entexammarks"]);
		$this->unvregfee = trim($this->aobj_context->mobj_data["unvregfee"]);
		$this->unvregrecno = trim($this->aobj_context->mobj_data["unvregrecno"]);
		$this->admfee = trim($this->aobj_context->mobj_data["admfee"]);
		$this->admrecno = trim($this->aobj_context->mobj_data["admrecno"]);
		$this->yrpass = trim($this->aobj_context->mobj_data["yrpass"]);
		$this->mnthpass = trim($this->aobj_context->mobj_data["mnthpass"]);
		$this->mrksecure = trim($this->aobj_context->mobj_data["mrksecure"]);
		$this->mrktotal = trim($this->aobj_context->mobj_data["mrktotal"]);
		$this->mrkper = trim($this->aobj_context->mobj_data["mrkper"]);
		$this->wghtAvgMarks = trim($this->aobj_context->mobj_data["wghtAvgMarks"]);
		$this->nosemYear =  trim($this->aobj_context->mobj_data["nosemYear"]);  
		$this->phtype =  trim($this->aobj_context->mobj_data["phtype"]);
		$this->wrtExamLang = trim($this->aobj_context->mobj_data["wrtExamLanguage"]);
		$this->eligbFee =  trim($this->aobj_context->mobj_data["eligbFee"]);
		$this->eligbRecNo =  trim($this->aobj_context->mobj_data["eligbRecNo"]);
		$this->lstr_param = stripslashes($this->aobj_context->mobj_data["sub_arr"]);
		$this->mobj_jsondata = $this->json->decode($this->lstr_param);
		$this->sub_arr_data = get_object_vars($this->mobj_jsondata);
		$this->fee_com = stripslashes($this->aobj_context->mobj_data["fee_com"]);
		$this->fee_com_jsondata = $this->json->decode($this->fee_com);
		$this->fee_com_arr_data = get_object_vars($this->fee_com_jsondata);

$this->studdoc = stripslashes($this->aobj_context->mobj_data["studdoc"]);
		//var_dump("studdoc: ".$this->studdoc);
		$this->studdoc_jsondata = $this->json->decode($this->studdoc);
		//var_dump("studdoc_jsondata: ".$this->studdoc_jsondata);
		$this->studdoc_arr_data = get_object_vars($this->studdoc_jsondata);

$this->pnrno     = trim($this->aobj_context->mobj_data["pnrno"]);
		$this->univphoneno     = trim($this->aobj_context->mobj_data["univphoneno"]);
		$this->univaddres     = trim($this->aobj_context->mobj_data["univaddres"]);
		$this->institutephoneno     = trim($this->aobj_context->mobj_data["institutephoneno"]);

$this->trg = trim($this->aobj_context->mobj_data["trg"]);
		$this->kai = trim($this->aobj_context->mobj_data["kai"]);
		$this->exs = trim($this->aobj_context->mobj_data["exs"]);
		$this->dfp = trim($this->aobj_context->mobj_data["dfp"]);
		$this->nss = trim($this->aobj_context->mobj_data["nss"]);
		$this->ncc = trim($this->aobj_context->mobj_data["ncc"]);
		$this->phd = trim($this->aobj_context->mobj_data["phd"]);

$this->spr = trim($this->aobj_context->mobj_data["spr"]);
		$this->obs = trim($this->aobj_context->mobj_data["obs"]);
		$this->osb = trim($this->aobj_context->mobj_data["osb"]);
		$this->month      = trim($this->aobj_context->mobj_data["month"]);
		$this->year       = trim($this->aobj_context->mobj_data["year"]);
		$this->maxmarks   = trim($this->aobj_context->mobj_data["maxmarks"]);
		$this->secmarks   = trim($this->aobj_context->mobj_data["secmarks"]);
		$this->percentage = trim($this->aobj_context->mobj_data["percentage"]);
		/*
		******************	SSLC Details Begin **********************
		*/
		$this->examregno10 = trim($this->aobj_context->mobj_data["examregno10"]);
		$this->pnrno10 = trim($this->aobj_context->mobj_data["pnrno10"]);
		$this->instname10 = trim($this->aobj_context->mobj_data["instname10"]);
		$this->location10 = trim($this->aobj_context->mobj_data["location10"]);
		$this->padState10 = trim($this->aobj_context->mobj_data["padState10"]);
		$this->univname10 = trim($this->aobj_context->mobj_data["univname10"]);
		$this->univphoneno10 = trim($this->aobj_context->mobj_data["univphoneno10"]);
		$this->univaddres10 = trim($this->aobj_context->mobj_data["univaddres10"]);
		$this->institutephoneno10 = trim($this->aobj_context->mobj_data["institutephoneno10"]);
		$this->month10      = trim($this->aobj_context->mobj_data["month10"]);
		$this->year10       = trim($this->aobj_context->mobj_data["year10"]);
		$this->maxmarks10   = trim($this->aobj_context->mobj_data["maxmarks10"]);
		$this->secmarks10   = trim($this->aobj_context->mobj_data["secmarks10"]);
		$this->percentage10 = trim($this->aobj_context->mobj_data["percentage10"]);

/*
		******************	SSLC Details End **********************
		*/
		
		$get_year="SELECT FADYEAR FROM degree
		WHERE FDEGREE='{$this->degree}' AND FEXAMNO='{$this->examno}'";
		$lobj_get_year = $this->aobj_context->mobj_db->getRow($get_year);
		$this->f_year=$lobj_get_year['FADYEAR'];

}
		 
	function SaveDetails()
	{
		if(trim($this->collcode) == true)
		{
			//$check_adminsion_freeze ="  select FCADSTATUS, ifnull(fadmstop,'') as FADMSTOP from colldeg 
			//where FCOLLCODE='{$this->collcode}' 
			//and FDEGREE='{$this->degree}'";								
		//$lobj_check_adminsion_freeze = $this->aobj_context->mobj_db->getRow($check_adminsion_freeze);

$qry = "select * from collexam where fdegree = '{$this->degree}' and fcollcode = '{$this->collcode}' 
			and DATE_FORMAT(NOW(),'%Y-%m-%d') 
			BETWEEN DATE_FORMAT(fadmfrom,'%Y-%m-%d') 
			AND DATE_FORMAT(fadmto,'%Y-%m-%d')";
			$student_exam_details = $this->aobj_context->mobj_db->GetAll($qry);
		
			if(count($student_exam_details) <= 0)
			{
				$arr='Last date for student admission is over';
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
				return;		
			}

$get_last_no="select right(concat('0000',ifnull(max(FSLNO),0)+01),4) as app_no 
			from studadm
			WHERE FDEGREE='{$this->degree}' and FCOLLCODE = '{$this->collcode}'";
			$obj =  $this->aobj_context->mobj_db->GetRow($get_last_no); 
			$sl_no = "0000".$obj['app_no']; 
			$this->app_no= substr($sl_no, -4);

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

$query = "select internal_code+1 as FAUTOINCREMENT from studadm 
			order by internal_code desc limit 1";
			$results = $this->aobj_context->mobj_db->GetRow($query);
			$FAUTOINCREMENT = $results['FAUTOINCREMENT'];

$appno = $FADMPREFIX.$FAUTOINCREMENT;
			$this->fappno = $appno;

$totalfee = $this->unvregfee + $this->admfee + $this->eligbFee;

$insert_qry="insert into studadm 
			(FSLNO,FDEGREE,FCOLLCODE,FNAME,FGENDER,FDOB,											
			FEXAMNO,FFATNAME,FMOTNAME,FEMAIL,FCASTE,
			FCONTACT_NO,FNATIONAL,FCURRADD1,FCURRADD2,FCURRADD3,FCURRADD4,FPERMADD1,
			FPERMADD2,FPERMADD3,FPERMADD4,FLATERAL_ENTRY,FRELIGION,
			FCOMBCODE,FMOBILE_NO,
			FMARITALSTATUS,FNATCANDIDATE,FSTATE,FKARBIRTH,FCATBIRTH,
			FINCOMECRT,FACADYEAR,FADMCAT,FADMDATE,FADMINTAKE,FADMQUOTA,
			FLANGEXAM,FLANGUAGE1,FLANGUAGE2,FFATINCOME,FMOTHINCOME,
			FLINGMINORITY,FREGMINORITY,FAADHARNO,FNATQUALEXAM,FSTATEQUALEXM,
			FTYPEQUALEXAM,FINSTNAME,FINSTLOCAT,FUNIVNAME,FQUALEXREGNO,
			FLANGUAGE,FSUBSPECIAL,FMODEDU,FEXAMINTERVAL,FENTEXMARKS,
			FUSERID,  FLOGNAME, FLOGDATE, FUNIVFEE, FUNIVRECNO, FLATADMFEE, FLATRECNO,
			FPASSYER, FPASSMNTH, FMARKSECURED, FMARKTOTAL, FPERMARK, 
			FWGHTAVGMARKS, FNOSEMYEAR,FPHTYPE,
			FELIGFEE, FELIGRECNO,FHK,FAPPNO,FPOB,FAREA,FHANDICAP,FNCC,FNSS,FDEFENCE,FEXSERVE,FKASHIMG,
			FTRANS,FUNIVADD,FUNIVPHONE,FPRNNO,FCOLLPHONE,FSPORTS,FOBSATE,TOTAL_FEE,
			FWOBSATE,FQMONTH,FQYEAR,FQMAXMARKS,FQSECMARKS,FQPERCENTAGE,FBLOOD_GROUP, 
			FPRNNO10, FQUALEXREGNO10, FINSTNAME10, FCOLLADD10, FCOLLSTATE10,
			FCOLLPHONE10, FUNIVNAME10, FUNIVADD10, FUNIVPHONE10, FQMONTH10,
			FQYEAR10, FQMAXMARKS10,	FQSECMARKS10, FQPERCENTAGE10 )
			values   
			(  
			'{$this->app_no}','{$this->degree}','{$this->collcode}','{$this->candidate_name}',
			'{$this->gender}',
			date_format('{$this->dob}','%Y-%m-%d'),'{$this->examno}','{$this->fatname}',
			'{$this->motname}','{$this->email}',
			'{$this->caste}','{$this->phoneno}','{$this->nationality}',
			'{$this->commaddr1}','{$this->commaddr2}','{$this->commaddr3}','{$this->commaddr4}',
			'{$this->peradd1}','{$this->peradd2}','{$this->peradd3}','{$this->peradd4}',
			'{$this->lateralEnrty}','{$this->religion}','{$this->sltCombination}','{$this->mobile}',
			'{$this->maritalStatus}','{$this->candidateNational}',
			'{$this->state}','{$this->belkarbirth}','{$this->categoryByBirth}',
			'{$this->incomeCrtificate}','{$this->acadyear}','{$this->admcat}',
			date_format('{$this->admdate}','%Y-%m-%d'),
			'{$this->admintake}','{$this->admquota}','{$this->wrtExamLang}',
			'{$this->sltLanguage1}','{$this->sltLanguage2}','{$this->fincome}','{$this->mincome}',
			'{$this->lingMinority}','{$this->regMinority}',
			'{$this->aadharno}','{$this->padNational}','{$this->padState}','{$this->typequlexam}',
			'{$this->instname}','{$this->location}','{$this->univname}','{$this->examregno}',
			'{$this->language1}','{$this->specialization}','{$this->modeEdu}','{$this->interval}',
			'{$this->entexammarks}','{$this->u_id}','{$this->log_name}', NOW(), '{$this->unvregfee}',
			'{$this->unvregrecno}', '{$this->admfee}', '{$this->admrecno}',
			'{$this->yrpass}', '{$this->mnthpass}', '{$this->mrksecure}', '{$this->mrktotal}', 
			'{$this->mrkper}',
			'{$this->wghtAvgMarks}', '{$this->nosemYear}','{$this->phtype}',
			'{$this->eligbFee}','{$this->eligbRecNo}','{$this->chkHydKar}','{$appno}','{$this->dobplace}',
			'{$this->area}','{$this->phd}','{$this->ncc}','{$this->nss}','{$this->dfp}','{$this->exs}',
			'{$this->kai}','{$this->trg}','{$this->univaddres}','{$this->univphoneno}','{$this->pnrno}',
			'{$this->institutephoneno}','{$this->spr}','{$this->obs}','{$totalfee}','{$this->osb}','{$this->month}',
			'{$this->year}','{$this->maxmarks}','{$this->secmarks}','{$this->percentage}', '{$this->bloodgrp}','{$this->pnrno10 }',
			 '{$this->examregno10 }',  '{$this->instname10}','{$this->location10}',	'{$this->padState10 }',	'{$this->institutephoneno10 }', 
			 '{$this->univname10 }', '{$this->univaddres10 }', 
			 '{$this->univphoneno10}', '{$this->month10}',	'{$this->year10}',	
			 '{$this->maxmarks10}',	'{$this->secmarks10}',	'{$this->percentage10}')";     
					 
			$insert_obj=$this->aobj_context->mobj_db->Execute($insert_qry);	
			//var_dump($insert_qry);
			$this->last_inserted_id = $this->aobj_context->mobj_db->Insert_ID();
		
			if($this->last_inserted_id)
			{
				$this->UpdateApplicationUniqueNo();
			}
			else
			{
				$data="Error While Inserting" ;
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
				return;
			}
			
			$data['message'] = " Inserted Successful. Admission No :  ".$this->fappno;
			$data['fappno'] = $this->fappno;
			$data['fdegree'] = $this->degree;
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
		}
		else
		{
			$arr='Session Expired,please login';
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-9,"Failure");
			return;	
		}	
	}

function UpdateStuDocsTables()
	{
		
		$update="update studoc set app_no='{$this->app_no}', fdegree ='{$this->degree}'  
						where 
						login_cnt='{$this->login_cnt}'";
		$lobj_update= $this->aobj_context->mobj_db->Execute($update);

$delete="delete from studoc where 
					login_cnt='{$this->login_cnt}'
					and app_no is null";	
		$lobj_delete= $this->aobj_context->mobj_db->Execute($delete);	
	}

$studdoc_arr_data = $this->studdoc_arr_data;
		//var_dump($fee_arr_data);

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

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

for ($k = 0; $k < count($studdoc_arr_data); $k++) {

if($studdoc_arr_data[$k]->filepath != '')
			{

$db = $this->db;
		
				$root_file_name=$this->aobj_context->main_src.$db.'/'.$studdoc_arr_data[$k]->filepath;
				$attachement_path = $this->fappno.'/'.$studdoc_arr_data[$k]->filepath;

try {
						$s3->putObject(['Bucket' => ADMISSION_CERTIFICATES, 'Key' => $funivcode.'/'.$attachement_path, 'SourceFile' => $root_file_name]);
						
						$del_query = "delete from studoc
						where app_no='{$this->fappno}'
						and fdoctype='{$studdoc_arr_data[$k]->file}'";
						$up_obj=$this->aobj_context->mobj_db->Execute($del_query);

$insert_doc="INSERT INTO studoc(file_path, created_date, fcollcode,fdegree,app_no,fdoctype)
						values('{$studdoc_arr_data[$k]->filepath}',now(),'{$this->collcode}','{$this->degree}','{$this->fappno}','{$studdoc_arr_data[$k]->file}')";
						$up_obj=$this->aobj_context->mobj_db->Execute($insert_doc); 
						unlink($root_file_name);
					} catch(S3Exception $e){
						$arr['message'] = 'Unable to upload documents';
						echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
						return;
					}

}
		}

$upd = "update studadm set TOTAL_FEE = '{$totfee}'
		where internal_code = '{$this->last_inserted_id}'";
		$upd = $this->aobj_context->mobj_db->Execute($upd);

$this->mobj_jsondata = json_decode($this->rgMultiMarks,true);
		//var_dump($this->mobj_jsondata);
		
		$sub_marks = array();
		for($i=0; $i<count($this->mobj_jsondata); $i++)
		{
			
			for($j=0;$j<count($this->mobj_jsondata[$i]);$j++)
			{
				$sub_marks[$i][$this->mobj_jsondata[$i][$j]['name']] = $this->mobj_jsondata[$i][$j]['value'];

}	
		}

$sql = array();
		$j=0;
		for($i=1; $i<=count($sub_marks);$i++)
		{
			$sql[] = "('{$this->app_no}'
			,'{$this->fappno}'
			,'{$this->collcode}'
			,'{$this->degree}'
			,'{$sub_marks[$j]["subsem1_$i"]}',
			'{$sub_marks[$j]["subsem1mo_$i"]}'
			,'{$sub_marks[$j]["subsem1mm_$i"]}'
			,'{$sub_marks[$j]["subsem2mo_$i"]}'
			,'{$sub_marks[$j]["subsem2mm_$i"]}'
			,'{$sub_marks[$j]["subsem3mo_$i"]}'
			,'{$sub_marks[$j]["subsem3mm_$i"]}'
			,'{$sub_marks[$j]["subsem4mo_$i"]}'
			,'{$sub_marks[$j]["subsem4mm_$i"]}'
			,'{$sub_marks[$j]["subsem5mo_$i"]}'
			,'{$sub_marks[$j]["subsem5mm_$i"]}'
			,'{$sub_marks[$j]["subsem6mo_$i"]}'
			,'{$sub_marks[$j]["subsem6mm_$i"]}'
			,'{$sub_marks[$j]["subtotalmo_$i"]}'
			,'{$sub_marks[$j]["subtotalmm_$i"]}'
			,'{$sub_marks[$j]["subpercentagemm_$i"]}')";
			
			$j++;
		}

$query = 'INSERT INTO qualdet(fslno, fappno,
		fcollcode, fdegree, 
		fsubname, fsecmarksa , fmaxmarksa, 
		fsecmarksb, fmaxmarksb,
		fsecmarksc, fmaxmarksc,
		fsecmarksd, fmaxmarksd,
		fsecmarkse, fmaxmarkse,
		fsecmarksf, fmaxmarksf,
		ftotsecmarks, ftotmaxmarks,
		fsubpercent
		) VALUES '.implode(',', $sql);
		$resultqualdets = $this->aobj_context->mobj_db->Execute($query);
		//var_dump($query);
		include_once($this->aobj_context->main_src."/JSON.php"); 
		$json = new Services_JSON();
		
			for($k=0;$k<count($this->sub_arr_data);$k++)
			{
				$this->sub_arr_data[$k]->sub_code = strtoupper($this->sub_arr_data[$k]->sub_code);
				
				$insert_options="insert into options(FYEAR, FDEGREE,
				FEXAMNO,
				FCOLLCODE,
				FSLNO,
				FSUBCODE,
				FDELETED,fappno)
				values
				(
				{$this->f_year},
				'{$this->degree}',
				'{$this->examno}',
				'{$this->collcode}',
				'{$this->app_no}',
				'{$this->sub_arr_data[$k]->sub_code}',
				'F','{$this->fappno}')";
				 
				$lobj_insert_options = $this->aobj_context->mobj_db->Execute($insert_options);
				
			}
			
		$lstr_save_schema_details_arr = stripslashes($this->exam_obj);
		$mobj_jsondata = $json->decode($lstr_save_schema_details_arr);
		
			$college_path=$this->aobj_context->main_src."/student_photos/{$this->collcode}";
			$degree_path=$this->aobj_context->main_src."/student_photos/{$this->collcode}/".$this->degree;;
			$folder_path=$this->aobj_context->main_src."/student_photos/{$this->collcode}/".$this->degree;;
			$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.'/'.$this->f_year."_".$this->degree."_".$this->app_no."_".$file_name;;
			$image_path="student_photos/{$this->collcode}/".$this->degree.'/'.$this->f_year."_".$this->degree."_".$this->app_no."_".$file_name;;
 		  
		if(!file_exists($college_path))
		{
			mkdir($college_path);
		}

if(!file_exists($degree_path))
		{
			mkdir($degree_path);
		}
		
		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))
			 {

$s3 = S3Client::factory(
						array(
							'credentials' => array(
								'key' => IAM_KEY,
								'secret' => IAM_SECRET
							),
							'version' => "latest",
							'region'  => 'ap-south-1'
						)
					);
	
						$query = "select funivcode from control";
						$results = $this->aobj_context->mobj_db->GetRow($query);
						$funivcode = $results['funivcode'];
						$unlink_file = $this->aobj_context->main_src.$image_path;
					
						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) {
								$data = 'Unable to upload Photo';
								echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
								return;
							}
						}

$update="update studadm set FPHOTOPATH='{$image_path}' 
						where internal_code=  {$this->last_inserted_id} ";
				$up_obj=$this->aobj_context->mobj_db->Execute($update); 
				$arr['app_no']=$this->app_no;
				//echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
				
			 }
			 else
			 {
			 	$data="Error While Moving the Image";
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
				return;
			 }
		}
			
		$file_name=basename($_FILES['student_entry_signupload']['name']);
		$path_arr=pathinfo($_FILES['student_entry_signupload']['name']);
		$file_ext=$path_arr['extension'];
		$full_file_signpath= $folder_path.'/'.$this->f_year."_".$this->degree."_".$this->app_no."_s_".$file_name;;
		$image_signpath="student_photos/{$this->collcode}/".$this->degree.'/'.$this->f_year."_".$this->degree."_".$this->app_no."_s_".$file_name;;

if(isset($_FILES['student_entry_signupload']['name']) && $_FILES['student_entry_signupload']['name'] != '')         
		{ 
			if(move_uploaded_file($_FILES['student_entry_signupload']['tmp_name'],$full_file_signpath))
			 {

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

$query = "select funivcode from control";
					$results = $this->aobj_context->mobj_db->GetRow($query);
					$funivcode = $results['funivcode'];
					$unlink_file = $this->aobj_context->main_src.$image_signpath;
				//	var_dump($unlink_file);
					if(file_exists($unlink_file)) 
					{
						try {
							$res = $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $funivcode."/".$image_signpath, 'SourceFile' => $unlink_file]);
							unlink($unlink_file);
						}catch(S3Exception $e) {
							$data = 'Unable to upload Sinature';
							echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
							return;
						}
					}

$update="update studadm set FSIGNPATH = '{$image_signpath}' 
						where internal_code=  {$this->last_inserted_id} ";
				$up_obj=$this->aobj_context->mobj_db->Execute($update); 
				//$arr['app_no']=$this->app_no;
				//echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 	
			 }
			 else
			 {
				$data="Error While Moving the Image";
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
				return;
			 }
		}
	}	
		 
	function GetApplicationDetails()
	{
		$this->app_no = trim($this->aobj_context->mobj_data["app_no"]);

$get_data = "select internal_code, app_no, pget_val, subject, candidate_name, 
					mother_name, father_name, spouse_name, 
					date_format(dob,'%d/%m/%Y') as dob, sex, 
					s.pob, pob_others, 
					nationality,
					s.college,
					college_others, 
					s.univ ,univ_others, cncl_reg_no, 
					cncl_reg_name, date_format(rotary,'%d/%m/%Y') as rotary, marks, 
					u_pg, phq, religion, 
					s.category, category_others, 
					caste, sub_caste, dd_amt, dd_no, date_format(dd_date,'%d/%m/%Y') as dd_date,
					dd_bank, address, pin,IFNULL(debared,'No') as debared, email, phone, 
					mobile, in_service_status,  
					s.dept , '' as dept_others, plc_of_working, 
					 date_format(date_of_entry,'%d/%m/%Y') as date_of_entry, prob_period, date_format(prob_date,'%d/%m/%Y') as  prob_date,
					 doing_pg, pg_degree_course, 
					date_format(pg_degree_date,'%d/%m/%Y') as pg_degree_date, 
					pg_diploma_course, date_format(pg_diploma_date,'%d/%m/%Y') as pg_diploma_date, 
					speciality, enq_pending, suspension, absence, remarks, photo_path, 
					created_date, f_max_marksa, f_sec_marksa, 
					f_no_attaa, f_max_marksb, f_sec_marksb, 
					f_no_attbb, f_max_marksc, f_sec_marksc, 
					f_no_attcc, f_max_marksd, f_sec_marksd, 
					f_no_attdd, f_tot_max_marks, f_tot_sec_marks ,ip_address,created_date,
					FAPPNO,FPOB,FAREA,FHANDICAP,FNCC,FNSS,FDEFENCE,FEXSERVE,FKASHIMG,
					FTRANS,FUNIVADD,FUNIVPHONE,FPRNNO,FCOLLPHONE 
					from 
					student s						 
					where app_no={$this->app_no}";
					//echo $get_data;die();
	   $lobj_get_data = $this->aobj_context->mobj_db->GetRow($get_data); 
	   $data="Error While Moving the Image";
	 
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"Success"); 
		return;
	}
	 
	function UpdateDetails()
	{
		//$check_adminsion_freeze ="select FCADSTATUS, ifnull(fadmstop,'') as FADMSTOP 
		//from colldeg 
		//where FCOLLCODE='{$this->collcode}' 
		//and FDEGREE='{$this->degree}'";								
		//$lobj_check_adminsion_freeze = $this->aobj_context->mobj_db->getRow($check_adminsion_freeze); 
		
		$qry = "select * from collexam where fdegree = '{$this->degree}' and fcollcode = '{$this->collcode}' 
		and DATE_FORMAT(NOW(),'%Y-%m-%d') 
		BETWEEN DATE_FORMAT(fadmfrom,'%Y-%m-%d') 
		AND DATE_FORMAT(fadmto,'%Y-%m-%d')";
		$student_exam_details = $this->aobj_context->mobj_db->GetAll($qry);

if(count($student_exam_details) <= 0)
		{
			$arr = 'Last date for student admission is over';
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
			return;		
		}

$update = "update studadm set 
		FNAME='{$this->candidate_name}',FGENDER='{$this->gender}',
		FDOB= date_format('{$this->dob}','%Y-%m-%d'),				
		FFATNAME='{$this->fatname}',FMOTNAME='{$this->motname}',
		FEMAIL='{$this->email}',FCASTE='{$this->caste}', FCONTACT_NO='{$this->phoneno}', FNATIONAL='{$this->nationality}', FCURRADD1='{$this->commaddr1}',
		FCURRADD2='{$this->commaddr2}', FCURRADD3='{$this->commaddr3}', 
		FCURRADD4='{$this->commaddr4}', FPERMADD1='{$this->peradd1}',
		FPERMADD2='{$this->peradd2}', FPERMADD3='{$this->peradd3}',
		FPERMADD4='{$this->peradd4}', FRELIGION='{$this->religion}',
		FCOMBCODE='{$this->sltCombination}',FMOBILE_NO='{$this->mobile}',
		FMARITALSTATUS='{$this->maritalStatus}',
		FNATCANDIDATE='{$this->candidateNational}',
		FSTATE='{$this->state}',FKARBIRTH='{$this->belkarbirth}', 
		FCATBIRTH='{$this->categoryByBirth}', FINCOMECRT='{$this->incomeCrtificate}',
		FACADYEAR='{$this->acadyear}', FADMCAT='{$this->admcat}',
		FADMDATE=date_format('{$this->admdate}','%Y-%m-%d'), 
		FADMINTAKE='{$this->admintake}',FADMQUOTA='{$this->admquota}',
		FLANGEXAM='{$this->wrtExamLang}', FLANGUAGE1='{$this->sltLanguage1}', 
		FLANGUAGE2='{$this->sltLanguage2}',
		FFATINCOME='{$this->fincome}',FMOTHINCOME='{$this->mincome}',
		FLINGMINORITY='{$this->lingMinority}',FREGMINORITY='{$this->regMinority}', 
		FAADHARNO='{$this->aadharno}', FNATQUALEXAM='{$this->padNational}', 
		FSTATEQUALEXM='{$this->padState}', FTYPEQUALEXAM='{$this->typequlexam}', 
		FINSTNAME='{$this->instname}', FINSTLOCAT='{$this->location}', 
		FUNIVNAME='{$this->univname}', FQUALEXREGNO='{$this->examregno}',
		FLANGUAGE='{$this->language1}', FSUBSPECIAL='{$this->specialization}', 
		FMODEDU='{$this->modeEdu}', FEXAMINTERVAL='{$this->interval}', 
		FENTEXMARKS='{$this->entexammarks}',
		FUSERID='{$this->u_id}',  FLOGNAME='{$this->log_name}', FLOGDATE=NOW(), FUNIVFEE='{$this->unvregfee}',
		FUNIVRECNO='{$this->unvregrecno}', FLATADMFEE='{$this->admfee}', FLATRECNO='{$this->admrecno}',
		FPASSYER='{$this->yrpass}', FPASSMNTH='{$this->mnthpass}', FMARKSECURED='{$this->mrksecure}',
		FMARKTOTAL='{$this->mrktotal}', FPERMARK='{$this->mrkper}', 
		FWGHTAVGMARKS='{$this->wghtAvgMarks}',
		FNOSEMYEAR='{$this->nosemYear}',FPHTYPE='{$this->phtype}',
		FELIGFEE='{$this->eligbFee}', FELIGRECNO='{$this->eligbRecNo}', FHK='{$this->chkHydKar}',
		FPOB = '{$this->dobplace}',
		FAREA = '{$this->area}',
		FHANDICAP = '{$this->phd}',
		FNCC = '{$this->ncc}',
		FNSS = '{$this->nss}',
		FDEFENCE = '{$this->dfp}',
		FEXSERVE = '{$this->exs}',
		FKASHIMG = '{$this->kai}',
		FTRANS = '{$this->trg}',
		FUNIVADD = '{$this->univaddres}',
		FUNIVPHONE = '{$this->univphoneno}',
		FCOLLPHONE = '{$this->institutephoneno}',
		FPRNNO = '{$this->pnrno}',
		FWOBSATE = '{$this->osb}',
		FQMONTH = '{$this->month}',
		FQYEAR = '{$this->year}',
		FQMAXMARKS = '{$this->maxmarks}',
		FQSECMARKS = '{$this->secmarks}',
		FQPERCENTAGE = '{$this->percentage}',
		FPRNNO10='{$this->pnrno10}',
		FQUALEXREGNO10='{$this->examregno10}',
		FINSTNAME10='{$this->instname10}',
		FCOLLADD10='{$this->location10}',
		FCOLLSTATE10='{$this->padState10}',
		FCOLLPHONE10='{$this->institutephoneno10}',
		FUNIVNAME10='{$this->univname10}',
		FUNIVADD10='{$this->univaddres10}',
		FUNIVPHONE10='{$this->univphoneno10}',
		FQMONTH10='{$this->month10}',
		FQYEAR10='{$this->year10}',
		FQMAXMARKS10='{$this->maxmarks10}',
		FQSECMARKS10='{$this->secmarks10}',
		FQPERCENTAGE10='{$this->percentage10}',
		FBLOOD_GROUP = '{$this->bloodgrp}'
		where FCOLLCODE='{$this->collcode}' and FSLNO='{$this->edit_app_no}' 
		and FDEGREE = '{$this->degree}'";
		$up_obj=$this->aobj_context->mobj_db->Execute($update);
				
	
		$delete_from_options="delete from options where FDEGREE='{$this->degree}'
						and FEXAMNO='{$this->examno}' and FCOLLCODE='{$_SESSION['collcode']}' 
						and FSLNO='{$this->edit_app_no}' and fyear = '{$this->f_year}'";
		$lobj_delete_from_options = $this->aobj_context->mobj_db->Execute($delete_from_options);
			 $insert_optionquy= count($this->sub_arr_data);

$query = "select fappno, fdegree from studadm 
		where FCOLLCODE='{$this->collcode}' and FSLNO='{$this->edit_app_no}' 
		and FDEGREE = '{$this->degree}'";
		$results = $this->aobj_context->mobj_db->GetRow($query);

$appno = $results['fappno'];
			
		for($k=0;$k<count($this->sub_arr_data);$k++)
		{
			$this->sub_arr_data[$k]->sub_code = strtoupper($this->sub_arr_data[$k]->sub_code);
			$insert_options="insert into options(FYEAR, FDEGREE,
			FEXAMNO,
			FCOLLCODE,
			FSLNO,
			FSUBCODE,
			FDELETED,fappno)
			values
			(
			'{$this->f_year}',
			'{$this->degree}',
			'{$this->examno}',
			'{$this->collcode}',
			'{$this->edit_app_no}',
			'{$this->sub_arr_data[$k]->sub_code}',
			'F','{$appno}')";
			$insert_optionquy = $lobj_insert_options;
			$lobj_insert_options = $this->aobj_context->mobj_db->Execute($insert_options);
		}	 
		
		
		/************* for queldet only for pg */

$query ="delete from qualdet 
		where fdegree='{$this->degree}' 
		and fcollcode='{$_SESSION['collcode']}' 
		and fslno ='{$this->edit_app_no}'";
		$resultqualdets = $this->aobj_context->mobj_db->Execute($query);

}	
		}

$sql = array();
		$j=0;
		for($i=1; $i<=count($sub_marks);$i++)
		{
			$sql[] = "('{$this->edit_app_no}'
			,'{$appno}'
			,'{$this->collcode}'
			,'{$this->degree}'
			,'{$sub_marks[$j]["subsem1_$i"]}',
			'{$sub_marks[$j]["subsem1mo_$i"]}'
			,'{$sub_marks[$j]["subsem1mm_$i"]}'
			,'{$sub_marks[$j]["subsem2mo_$i"]}'
			,'{$sub_marks[$j]["subsem2mm_$i"]}'
			,'{$sub_marks[$j]["subsem3mo_$i"]}'
			,'{$sub_marks[$j]["subsem3mm_$i"]}'
			,'{$sub_marks[$j]["subsem4mo_$i"]}'
			,'{$sub_marks[$j]["subsem4mm_$i"]}'
			,'{$sub_marks[$j]["subsem5mo_$i"]}'
			,'{$sub_marks[$j]["subsem5mm_$i"]}'
			,'{$sub_marks[$j]["subsem6mo_$i"]}'
			,'{$sub_marks[$j]["subsem6mm_$i"]}'
			,'{$sub_marks[$j]["subtotalmo_$i"]}'
			,'{$sub_marks[$j]["subtotalmm_$i"]}'
			,'{$sub_marks[$j]["subpercentagemm_$i"]}')";
			
			$j++;
		}

$college_path=$this->aobj_context->main_src."/student_photos/{$this->collcode}";
		$folder_path=$this->aobj_context->main_src."/student_photos/{$this->collcode}/".$this->degree;;
		$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.'/'.$this->f_year."_".$this->degree."_".$this->edit_app_no."_".$file_name;;
		$image_path="student_photos/{$this->collcode}/".$this->degree.'/'.$this->f_year."_".$this->degree."_".$this->edit_app_no."_".$file_name;;
		
		if(!file_exists($college_path))
		{
			mkdir($college_path);
		}
		if(!file_exists($folder_path))
		{
			mkdir($folder_path);
		}
		// $this->UpdateStuDocsTables();
		
		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))
			{

$query = "select funivcode from control";
					$results = $this->aobj_context->mobj_db->GetRow($query);
					$funivcode = $results['funivcode'];
					$unlink_file = $this->aobj_context->main_src.$image_path;
				//	var_dump($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) {
							$data = 'Unable to upload Photo';
							echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
							return;
						}
					}

$update="update studadm set FPHOTOPATH='{$image_path}' 
				where FCOLLCODE='{$this->collcode}' and FSLNO='{$this->edit_app_no}' and FDEGREE = '{$this->degree}'";
				$up_obj=$this->aobj_context->mobj_db->Execute($update); 
				$arr['app_no']=$this->edit_app_no;
			}
			else
			{
			 	$data="Error While Moving the Image";
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
				return;
			}
		}
			
		$file_name=basename($_FILES['student_entry_signupload']['name']);
		$path_arr=pathinfo($_FILES['student_entry_signupload']['name']);
		$file_ext=$path_arr['extension'];
		$full_file_signpath= $folder_path.'/'.$this->f_year."_".$this->degree."_".$this->edit_app_no."_s_".$file_name;;
		$image_signpath="student_photos/{$this->collcode}/".$this->degree.'/'.$this->f_year."_".$this->degree."_".$this->edit_app_no."_s_".$file_name;;

$update="update studadm set FSIGNPATH = '{$image_signpath}' 
						where FCOLLCODE='{$this->collcode}' and FSLNO='{$this->edit_app_no}' and FDEGREE = '{$this->degree}'";
				$up_obj=$this->aobj_context->mobj_db->Execute($update); 
				$arr['app_no']=$this->edit_app_no;
				//echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 	
			 }
			 else
			 {
			 	$data="Error While Moving the Image";
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
				return;
			 }
		}

$studdoc_arr_data = $this->studdoc_arr_data;
		//var_dump($fee_arr_data);

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

for ($k = 0; $k < count($studdoc_arr_data); $k++) {

if($studdoc_arr_data[$k]->filepath != '')
			{

$db = $this->db;
		
				$root_file_name=$this->aobj_context->main_src.$db.'/'.$studdoc_arr_data[$k]->filepath;
				$attachement_path = $appno.'/'.$studdoc_arr_data[$k]->filepath;

try {
						$s3->putObject(['Bucket' => ADMISSION_CERTIFICATES, 'Key' => $funivcode.'/'.$attachement_path, 'SourceFile' => $root_file_name]);
						
						$del_query = "delete from studoc
						where app_no='{$appno}'
						and fdoctype='{$studdoc_arr_data[$k]->file}'";
						$up_obj=$this->aobj_context->mobj_db->Execute($del_query);

$insert_doc="INSERT INTO studoc(file_path, created_date, fcollcode,fdegree,app_no,fdoctype)
						values('{$studdoc_arr_data[$k]->filepath}',now(),'{$this->collcode}','{$this->degree}','{$appno}','{$studdoc_arr_data[$k]->file}')";
						$up_obj=$this->aobj_context->mobj_db->Execute($insert_doc); 
						unlink($root_file_name);
					} catch(S3Exception $e){
						$arr['message'] = 'Unable to upload documents';
						echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
						return;
					}

}
		}

$fee_arr_data = $this->fee_com_arr_data;
		//var_dump($fee_arr_data);
		$totfee = 0;
		if(count($fee_arr_data) > 0){
			$qry = "delete from admfeedetl where fdegree = '{$this->degree}' and fcollcode = '{$this->collcode}' and fappno = '{$appno}'";
			// var_dump($qry);
			$lobj_update = $this->aobj_context->mobj_db->Execute($qry);
		}
		for ($k = 0; $k < count($fee_arr_data); $k++) {
			$insert_options = "insert into admfeedetl 
				(FYEAR,FDEGREE,
				FEXAMNO,FCOLLCODE,
				FSLNO,FHEADCODE,
				FAMOUNT,FAPPNO)
				values
				(
				'2021',
				'{$this->degree}',
				'{$this->examno}',
				'{$this->collcode}',
				'{$this->edit_app_no}',
				'{$fee_arr_data[$k]->head_id}',
				'{$fee_arr_data[$k]->fee_paid}',
				'{$appno}' 
				)
				";
				//var_dump($insert_options);
				$totfee = $totfee+$fee_arr_data[$k]->fee_paid;
			$lobj_insert_options = $this->aobj_context->mobj_db->Execute($insert_options);
			// var_dump($insert_options);
		}
		// var_dump($totfee);

$upd_qry = "update studadm set ftotfee = '{$totfee}',TOTAL_FEE = '{$totfee}'  where fappno = '{$appno}'";
		$lobj_upd = $this->aobj_context->mobj_db->Execute($upd_qry);
		// var_dump($lobj_upd);

if($up_obj)
		{
			//$data="Updated Successfully" ;
			//echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
			$data['message'] = " Updated Successful. Admission No :  ".$results['fappno'];
			$data['fappno'] = $results['fappno'];
			$data['fdegree'] = $results['fdegree'];
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
			return;
		}
		else
		{
			$data="Updation Failed";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
			return;
		}	
	}		
	function GetCMSDropDownMenuValues()
	{
		$get_coll_data="SELECT FCOLLCODE AS int_code,CONCAT(FCOLLCODE,' - ',FCOLLNAME) AS val FROM college";
		$up_obj=$this->aobj_context->mobj_db->GetAll($get_coll_data);
		$arr['college']=$up_obj;
		$get_data="SELECT FDEGREE AS int_code,CONCAT(FDEGREE,' - ',FDESCPN) AS val FROM degree";
		$up_obj=$this->aobj_context->mobj_db->GetAll($get_data);
		$arr['degree']=$up_obj;
		$get_data="SELECT FCATCODE AS int_code,CONCAT(FCATCODE,' - ',FCATDESC) AS val FROM mascat ORDER BY FORDER";
		$up_obj=$this->aobj_context->mobj_db->GetAll($get_data);
		$arr['category']=$up_obj;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
		return;
	}

function GetCMSAmountValue()
	{
		$degree=trim($this->aobj_context->mobj_data["degree"]);
		$nationality=trim($this->aobj_context->mobj_data["nationality"]);
	
		$amt=empty($amt)?0:$amt;
		$arr['amount']=$amt;
		
		//$sub_arr=$this->GetSubjectDetails($degree);
		$doc_arr=$this->GetStudentDocumentsTable($degree,$nationality);
		$arr['subjects']=$sub_arr;
		$arr['doc_arr']=$doc_arr;
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	}

$s3_url = "https://admission-certificates.s3.ap-south-1.amazonaws.com/";
			
			$query = "select funivcode from control";
			$results = $aobj_context->mobj_db->GetRow($query);

$funivcode = $results['funivcode'];
			$doc_url = $s3_url.$funivcode.'/'.$doc_file_path;
			
			if(!empty($attachment_path))
				$selected=" <span class='label label-success' id='uploded_{$int_code}'>Yes</span> ";
			else
				$selected=" <span class='label label-warning' id='uploded_{$int_code}'>No</span>";
				 
			 
			$this->html.='<tr>						
						<td>'.$sl.'. </td>						
						<td id="doc_upload_'.$int_code.'">'.$doc_type.'</td>						
						<td><div style="float:left;"><input type="file"  name='.'"'.$file_type_id.'"'.'  id='.'"'.$file_type_id.'"'.' style="width:120px;padding:5px 0px;" /></div><div style="float:left;padding-left:20px;"><button><a class="btn btn-sm blue" href="#" style = "text-decoration:none;" onclick=UploadEmployeeDocuments("'.$int_code.'","'.$FFILENAME.'")>&nbsp;Upload</a></button></div></td>';	
			if(!empty($attachment_path))
			{
				$this->html.='<td><a style="color:#AB45F9; padding-right:5px;" href="'.$doc_url.'" target="_blank">'.$file_name.'</a><span style="cursor:pointer;" class="label label-danger" onclick=CMS.DeleteEmployeeDocuments("'.$int_code.'")>Delete</span></td>';
			}
			else
			{
				$this->html.='<td id="attach_td_'.$int_code.'">&nbsp;</td>';
			}
		 
			
			$this->html.='</tr>';	$sl++;	
		}
		$this->html.='</tbody></table>
						</div>
					</div>
					</div>
					</div>
					';
		return $this->html;							
	} 
	function UploadEmployeeDocuments()
	{		 
	  
			 $dir_path=$this->aobj_context->main_src."/certificates/{$this->login_cnt}";
			mkdir($dir_path);
			chmod($dir_path,7777);
			$cert_file_name=trim($this->aobj_context->mobj_data["file_name"]);
			$this->doc_type_int_code=trim($this->aobj_context->mobj_data["doc_type_int_code"]);
		 
		 
		$file_id="ed_{$this->doc_type_int_code}";
		$file_name=$_FILES[$file_id]['name'];
		if(isset($file_name) && $file_name != '')         
		{ 		
				$path_arr=pathinfo($_FILES[$file_id]['name']);
				$file_ext=$path_arr['extension'];
				
		$root_file_name=$dir_path."/{$cert_file_name}.".$file_ext;	
		$attachement_path="certificates/{$this->login_cnt}/{$cert_file_name}.".$file_ext;	
		if(move_uploaded_file($_FILES[$file_id]['tmp_name'],$root_file_name))
		  {
				
				
				$arr['path']=$attachement_path;					
				$arr['id']=$this->doc_type_int_code;					
				$arr['file_name']=$file_name;	
				$delete="delete from studoc where 
							ref_mas_doc_code='{$this->doc_type_int_code}'
							and login_cnt='{$this->login_cnt}'
							";	
				$lobj_delete= $this->aobj_context->mobj_db->Execute($delete);			
				$insert="INSERT INTO studoc
					( 
					ref_mas_doc_code, 
					login_cnt, 
					file_path, 
					created_date
					)
					values
					(
					'{$this->doc_type_int_code}',
					'{$this->login_cnt}',
					'{$attachement_path}',now()
					)";	
					
				$lobj_insert= $this->aobj_context->mobj_db->Execute($insert);
				// echo $insert;
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");	
				return; 
			 			
		  }
		  else
		  {
				$data = "Moving {$file_name} to emp_doc_attchments failed";						
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
				return;
		  }
		} 
		else
		{
			$data="File is empty, not moved";						
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure");	
			return;
		}
	}	
	function SendMailOtPToUser()
	{
		$mobile_no=trim($this->aobj_context->mobj_data["s_mobile_no"]);
		$s_email_id=$this->aobj_context->mobj_data['s_email_id'];
 
		require_once("cManualMailer.php");
		$otp="1234";
			$message="<html>";
			$message.="<body>";
			$message.="<style>";		
			$message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;}";	
			$message.="</style>";
			$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Hi,</p>";
			$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Your OTP Password is :{$otp}</p>";			
			 
			$message.="</br>";			
		//	$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Regards,</p>";
			//$message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>PF Team</p>";
			$message.="</body>";
			$message.="</html>";
		
			$subject="OTP Password" ;	 
			$data='true';
			 $data= send_manual_mail($s_email_id,$subject,$message,$replay_to=null,$cc=null,$bcc=null);
			 if($data=='true')
			{
			$data="Please Enter OTP Password has been sent to you Mail/Mobile";
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
			}
			else
			{
			 
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); 
			}
			
	}

}

function GetCMSAmountValue($aobj_context)
{ 
$obj=new applicationForm($aobj_context);
$obj->GetCMSAmountValue();
}

function GetUploadedStudentDocumentsRUR($aobj_context)
{
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$degree = $aobj_context->mobj_data["degree"];
	$appno = $aobj_context->mobj_data["appno"];
	session_start();

if($appno == '')
		$appno = 'X';
	$collcode = $_SESSION['collcode'];
	if(strtoupper($collcode) == 'VKU')
	{
		$collcode  = $aobj_context->mobj_data["collcode"];
	}

// $get_document_data ="select md.FORDER, md.internal_code as int_code, md.FCERTDESC as doc_type ,
	// IFNULL(md.FFILENAME,REPLACE(REPLACE(md.FCERTDESC,' ','_'),'+','_')) as FFILENAME,
	// sd.file_path from masdoc md left outer join studoc sd on md.internal_code = sd.ref_mas_doc_code  and md.fdegree = sd.fdegree
	// WHERE md.fdegree='{$degree}'  and app_no = '{$appno}' and fcollcode ='{$collcode}' 
	// union
	// select distinct md.FORDER,md.internal_code as int_code, md.FCERTDESC as doc_type ,
	// IFNULL(md.FFILENAME,REPLACE(REPLACE(md.FCERTDESC,' ','_'),'+','_')) as FFILENAME,'' as file_path
	// from masdoc md where md.fdegree='{$degree}' and  md.internal_code NOT IN(select  md2.internal_code as int_code1 
	// from masdoc md2 left outer join studoc sd2 on md2.internal_code = sd2.ref_mas_doc_code  
	// WHERE md2.fdegree='{$degree}'  and sd2.app_no = '{$appno}' and sd2.fcollcode ='{$collcode}')
	// order by FORDER";

$query = "select ifnull(fappno,'x') as fappno from studadm where fcollcode = '{$collcode}' and fdegree = '{$degree}' and fslno = '{$appno}'";
	$res= $aobj_context->mobj_db->GetRow($query);
	$fappno = $res['fappno'];

$get_document_data ="select md.FORDER, md.internal_code as int_code, md.FCERTDESC as doc_type ,
	md.FFILENAME as FFILENAME, sd.file_path from masdoc md 
	left outer join studoc sd on md.fdegree = sd.fdegree and md.FFILENAME = sd.fdoctype
	and app_no = '{$fappno}' and fcollcode ='{$collcode}'
	WHERE md.fdegree='{$degree}'";

//var_dump($get_document_data);return;
	$lobj_get_document_data= $aobj_context->mobj_db->GetAll($get_document_data);
	$html="";
	$html.='	
				
					<div class="span11"><div class="portlet box blue">
						
						<div class="portlet-body">
						<div class="scroller" data-height="380px">
							<table id="rurupload_table" class="table table-bordered table-hover" cellpadding="2" cellspacing="2">
								<thead>
									<tr>											
										<th style="width:20px;"></th>																	
										<th style="width:300px;text-align:left;"><i class="icon-briefcase"></i>&nbsp;Docoment Type</th>																		
																		
										<th style="width:200px;">Attachment</th>	
												
									</tr>
								</thead>
								<tbody>';
								$sl=1;
	foreach($lobj_get_document_data as $mk=>$mv)
	{

$int_code=$mv['int_code'];
		$doc_type=$mv['doc_type'];
	   // $attachment_path=$mv[attachment_path];
		$FFILENAME=$mv['FFILENAME'];
		$file_path=$mv['file_path'];
		$file_type_id="ed_{$int_code}";
		$s3_url = "https://admission-certificates.s3.ap-south-1.amazonaws.com/";
			
		$query = "select funivcode from control";
		$results = $aobj_context->mobj_db->GetRow($query);

$funivcode = $results['funivcode'];
		$doc_url = $s3_url.$funivcode.'/'.$fappno.'/'.$file_path;
		/* $doc_file_path=$attachment_path;
			if(!empty($attachment_path))
			$selected=" <span class='label label-success' id='uploded_{$int_code}'>Yes</span> ";
			else
			$selected=" <span class='label label-warning' id='uploded_{$int_code}'>No</span>";
		 */	 
		 
		$html.='<tr>						
					<td>'.$sl.'</td>						
					<td id="doc_upload_'.$int_code.'">'.$doc_type.'</td>						
					<td><div style="float:left;"><input type="file"  name='.'"'.$file_type_id.'"'.'  id='.'"'.$file_type_id.'"'.' style="width:120px;padding:5px 0px;" /></div><div style="float:left;padding-left:20px;"><a class="btn btn-sm blue" href="#" onclick=UploadEditEmployeeDocuments("'.$int_code.'","'.$FFILENAME.'","'.$degree.'","'.$collcode.'","'.$appno.'","'.$funivcode.'")><i class="fa fa-upload"></i>&nbsp;Upload</a></div></td>';	
		$html.='<td><a style="color:#AB45F9; padding-right:5px;" href="'.$doc_url.'"  id="attach_td_'.$int_code.'" target="_blank">'.$file_path.'</a> <input type = "hidden"  id = "attach_td_h_'.$int_code.'_'.$FFILENAME.'" value = ""/> </td>';
		
		
		$html.='</tr>';	$sl++;	
	}
	$html.='</tbody></table>
					</div>
				</div>
				</div>
				</div>
				';	
		echo $aobj_context->mobj_output->ToJSONEnvelope($html,0,"success");
} 
?>

${this.title}

Code Editor : student_rur.php