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

<?php

function replaceChars($name)
{
    $spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ","");
    $link_name = strtolower(str_replace($spl_char,"_",$name));
    return str_ireplace("__","_",$link_name);
}
function PopulateFreshExamSubject($aobj_context)
{
    session_start();

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $college_code = $_SESSION['collcode'];
    $Regno = $aobj_context->mobj_data["Regno"];
    $degree = $aobj_context->mobj_data["degree"];
    $exam = $aobj_context->mobj_data["Examno"];
    $prevFreshSub = $aobj_context->mobj_data["prevFreshSub"];
    $exam_appear=array();

$query = "select * from collexam where fdegree = '{$degree}' 
	and fcollcode = '{$college_code}' 
	and fexamno = '{$exam}'
	and DATE_FORMAT(NOW(),'%Y-%m-%d') 
	BETWEEN DATE_FORMAT(fsubcrfrom,'%Y-%m-%d') 
	AND DATE_FORMAT(fsubcrto,'%Y-%m-%d') ";
	$student_exam_details = $aobj_context->mobj_db->GetRow($query);

if(count($student_exam_details) > 0)
	{

}else
	{

$id="<tr style='height: 20'>";
        $id.="<td colspan=9 align = 'center'><b>Subject corrections are not available now!<b></td>";
        $id.="</tr>";
        $arr['html_data']=$id;
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success");
		return;
		
	}

$qry = " select c.FDEGREE,c.FEXAMNO,c.FCOLLCODE,c.FREGNO,
			IF(IFNULL(c.FCATEGORY,'')='',if(ifnull(s.FCASTE,'') = '', 'GM', s.FCASTE) ,c.FCATEGORY) AS FCATEGORY,
			if(c.Fgender='',s.Fgender,c.Fgender) as Fgender,c.FAPPEARA,c.FEXAMFEEA,
			c.FAPPEARB,c.FEXAMFEEB,c.FAPPEARC,c.FEXAMFEEC,c.FAPPEARD,c.FEXAMFEED,c.FAPPEARE,
			c.FEXAMFEEE,c.FAPPEARF,c.FEXAMFEEF,c.FAPPEARG,c.FEXAMFEEG,c.FAPPEARH,c.FEXAMFEEH,
			c.FAPPEARI,c.FEXAMFEEI,c.FAPPEARJ,c.FEXAMFEEJ,round(c.FTOTALFEE,2) as FTOTALFEE,
			c.FYEAR,c.FEXAMTYPE,c.FDELETED,FRECPTNO,DATE_FORMAT(FRECPTDATE,'%d/%m/%Y') as FRECPTDATE
			,FREMARKS,c.FTOTSUBA,c.FTOTSUBB,c.FTOTSUBC,c.FTOTSUBD,c.FTOTSUBE,c.FTOTSUBF,c.FTOTSUBG,c.FTOTSUBH,
			c.FTOTSUBI,c.FTOTSUBJ,concat('*',c.FCONSTYPE) as FCONSTYPE,ifnull(c.FELIG,'0123456789') as FELIG,
			sum(if(t.fexamno = 'A',1,0)) as fcnta, sum(if(t.fexamno = 'B',1,0)) as fcntb,
			sum(if(t.fexamno = 'C',1,0)) as fcntc, sum(if(t.fexamno = 'D',1,0)) as fcntd,
			sum(if(t.fexamno = 'E',1,0)) as fcnte, sum(if(t.fexamno = 'F',1,0)) as fcntf,
			sum(if(t.fexamno = 'G',1,0)) as fcntg, sum(if(t.fexamno = 'H',1,0)) as fcnth,
			sum(if(t.fexamno = 'I',1,0)) as fcnti, sum(if(t.fexamno = 'J',1,0)) as fcntj,
			FRECPTNOA,DATE_FORMAT(FRECPTDATEA,'%d/%m/%Y') AS FRECPTDATEA,
			FRECPTNOB,DATE_FORMAT(FRECPTDATEB,'%d/%m/%Y') AS FRECPTDATEB,
			FRECPTNOC,DATE_FORMAT(FRECPTDATEC,'%d/%m/%Y') AS FRECPTDATEC ,
			FRECPTNOD,DATE_FORMAT(FRECPTDATED,'%d/%m/%Y') AS FRECPTDATED ,
			FRECPTNOE,DATE_FORMAT(FRECPTDATEE,'%d/%m/%Y') AS FRECPTDATEE ,
			FRECPTNOF,DATE_FORMAT(FRECPTDATEF,'%d/%m/%Y') AS FRECPTDATEF ,
			FRECPTNOG,DATE_FORMAT(FRECPTDATEG,'%d/%m/%Y') AS FRECPTDATEG ,
			FRECPTNOH,DATE_FORMAT(FRECPTDATEH,'%d/%m/%Y') AS FRECPTDATEH ,
			FRECPTNOI,DATE_FORMAT(FRECPTDATEI,'%d/%m/%Y') AS FRECPTDATEI ,
			FRECPTNOJ,DATE_FORMAT(FRECPTDATEJ,'%d/%m/%Y') AS FRECPTDATEJ ,
			FFRESHEXAM  
			from candsum c left join student s on s.FDEGREE=c.FDEGREE 
			and s.FREGNO=c.FREGNO
			left outer join canddet t
			on c.fdegree = t.fdegree and c.fregno = t.fregno
			where c.FDEGREE='{$degree}' 
			and c.FCOLLCODE='{$college_code}'
            and c.FREGNO='{$Regno}' 
            and ifnull(c.FFRESHEXAM,'') = '{$exam}'";
            
    $student_exam_details = $aobj_context->mobj_db->GetRow($qry);
    if($student_exam_details)
    {
                
        $fcnta  = $student_exam_details['fcnta'];
		$fcntb  = $student_exam_details['fcntb'];
		$fcntc  = $student_exam_details['fcntc'];	
		$fcntd  = $student_exam_details['fcntd'];
		$fcnte  = $student_exam_details['fcnte'];
		$fcntf  = $student_exam_details['fcntf'];
		$fcntg  = $student_exam_details['fcntg'];
		$fcnti  = $student_exam_details['fcnti'];
        $fcntj  = $student_exam_details['fcntj'];
        
        if($student_exam_details['FAPPEAR'.$exam]=='N')
        {
            $arr['html_data']="<tr style='height: 20px;color:red;font-size:18px;'><td COLSPAN=3 align = 'center'><b>Student is not eligible for the given examination<b></td></tr>";
            
            //$id=" id ='cand_entry_".$exam."'";
        }
        else if($student_exam_details['FAPPEAR'.$exam]=='P')
        {
            $arr['html_data']="<tr style='height: 20px;color:green;font-size:18px;'><td COLSPAN=3 align = 'center'><b>Student has already passed in the given examination.<b></td></tr>";
            
            //$id=" id ='cand_entry_".chr($i)."'";
        }
        else  if($student_exam_details['FAPPEAR'.$exam]=='A' || $student_exam_details['FAPPEAR'.$exam]=='E')
        {
            array_push($exam_appear,$exam);
        //$id=" id='cand_entry_".$exam."'";
        //$td_data="<Input  onclick=showExamNosDiv('{$html_id}'); {$id}  name='radio_common' type='radio'>";
        //$id='';
        }
        //if($exam ==$exam_appear);
    
         
        // $get_total_sub_for_degree="select * from degree where FDEGREE='{$degree}'";
        // $lobj_get_total_sub_for_degree = $aobj_context->mobj_db->GetAll($get_total_sub_for_degree);
         
        // for($j=0;$j<count($lobj_get_total_sub_for_degree);$j++)
        // {
        //     if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='A')
        //     {
        //         $exam_A_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['A']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='B')
        //     {
        //         $exam_B_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['B']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='C')
        //     {
        //         $exam_C_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['C']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='D')
        //     {
        //         $exam_D_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['D']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='E')
        //     {
        //         $exam_E_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['E']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='F')
        //     {
        //         $exam_F_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['F']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='G')
        //     {
        //         $exam_G_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['G']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='H')
        //     {
        //         $exam_H_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['H']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='I')
        //     {
        //         $exam_I_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['I']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        //     else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='J')
        //     {
        //         $exam_J_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
        //         $semister_names['J']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
        //     }
        // }

$get_total_sub_for_degree="select * from degree where FDEGREE='{$degree}'";
		$lobj_get_total_sub_for_degree = $aobj_context->mobj_db->GetAll($get_total_sub_for_degree); 
		$totsub = explode(',',$totsub);		 
		for($j=0;$j<count($lobj_get_total_sub_for_degree);$j++)
		{
			if($lobj_get_total_sub_for_degree[$j]['FEXAMNO'] == 'A')
			{

//var_dump($fcnta.' - '.$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']);
				if($totsub[$j] > 0)
					$exam_A_limit = $totsub[$j];
				else if($fcnta > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_A_limit = $fcnta;
				else
					$exam_A_limit = $lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['A'] = $lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='B')
			{ 
				if($totsub[$j] > 0)
					$exam_B_limit = $totsub[$j];
				else if($fcntb > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_B_limit = $fcntb;
				else
					$exam_B_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['B']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='C')
			{
				if($totsub[$j] > 0)
					$exam_C_limit = $totsub[$j];
				else if($fcntc > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_C_limit = $fcntc;
				else
					$exam_C_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['C']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='D')
			{
				if($totsub[$j] > 0)
					$exam_D_limit = $totsub[$j];
				else if($fcntd > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_D_limit = $fcntd;
				else
					$exam_D_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];

$semister_names['D']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='E')
			{
				if($totsub[$j] > 0)
					$exam_E_limit = $totsub[$j];
				else if($fcnte > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_E_limit = $fcnte;
				else
					$exam_E_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['E']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='F')
			{
				if($totsub[$j] > 0)
					$exam_F_limit = $totsub[$j];
				else if($fcntf > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_F_limit = $fcntf;
				else
					$exam_F_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['F']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}	
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='G')
			{
				if($totsub[$j] > 0)
					$exam_G_limit = $totsub[$j];
				else if($fcntg > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_G_limit = $fcntg;
				else
					$exam_G_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['G']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='H')
			{
				if($totsub[$j] > 0)
					$exam_H_limit = $totsub[$j];
				else if($fcnth > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_H_limit = $fcnth;
				else
					$exam_H_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['H']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='I')
			{
				if($totsub[$j] > 0)
					$exam_I_limit = $totsub[$j];
				else if($fcnti > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_I_limit = $fcnti;
				else
					$exam_I_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['I']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
			else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='J')
			{
				if($totsub[$j] > 0)
					$exam_J_limit = $totsub[$j];
				else if($fcntj > $lobj_get_total_sub_for_degree[$j]['FTOTSUB'])
					$exam_J_limit = $fcntj;
				else
					$exam_J_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB'];
				
				$semister_names['J']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME'];
			}
        }
        
        if(in_array($exam,$exam_appear))
        {
            $id='';
            $remaining_count=0;
            $id="\$exam_".$exam;
            $html_id="candidate_list_exam_".$exam."_details";
         
             $char_name=$exam;
             $max_limit="\$exam_".$char_name."_limit";
             eval("\$max_limit = \"$max_limit\";");
         
            $FEXAMNO=$exam;
            $id="<table  class='tr_ventor_row content-tbl' width='100%' border='0' cellspacing='0' cellpadding='0'>";
            $id.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:10px; padding-left:6px; height:20px;'>{$semister_names[$FEXAMNO]}</th>";
            $id.="<tr class='ui-state-default ui-jqgrid-hdiv'>";
            $id.="<td align='center' style='  font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;width:100px;padding:5px 5px;'>Sub Code</td>";
            $id.="<td align='center' style='  font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;width:100px;padding:5px 5px;'>QP Code</td>";
            $id.="<td align='center' style='  font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;padding:5px 5px;'>Subject / Paper Name </td>";
            $id.="</tr>";
          
            $get_header_exam_details ="select c.FSUBCODE,s.FSUBNAME,ifnull(c.FPASSMTH,'') as FPASSMTH,
                                s.FQPCODE AS FSUBSHORT,c.FEXAMTYPE,
                                ifnull(c.FPRESENT,'N') as FPRESENT,
                                if(c.FINSERTED='','F',c.FINSERTED) as FINSERTED, 
                                s.fmandatory from canddet c
                                inner join subject s on s.FDEGREE=c.FDEGREE
                                and s.FSUBCODE=c.FSUBCODE
                                where c.FDEGREE='{$degree}' and c.FCOLLCODE='{$college_code}' and
                                c.FEXAMNO='{$FEXAMNO}'  and
                                c.FREGNO='{$Regno}' and (s.fsubcode = ifnull(s.fvarsubgrp,'') or ifnull(s.fvarsubgrp,'') = '')
                                 group by c.FSUBCODE 
                                 order by c.FSUBCODE, FINSERTED,s.fmandatory desc
                                 limit $max_limit";
                                //var_dump($get_header_exam_details);
        $lobj_rs = $aobj_context->mobj_db->GetAll($get_header_exam_details);
        $remaining_count = $max_limit-count($lobj_rs);
        //var_dump($get_header_exam_details);
        $k=0;
        $txt_id=0;
          
                
        $subjectList='';
        for($m=0;$m<count($lobj_rs);$m++)
        {
            $code_pop_up_field="";
            $FSUBCODE=$lobj_rs[$m]['FSUBCODE'];
            $FSUBSHORT=$lobj_rs[$m]['FSUBSHORT'];
            $FSUBNAME=$lobj_rs[$m]['FSUBNAME'];
            if($lobj_rs[$m]['FPASSMTH']=='' or is_null($lobj_rs[$m]['FPASSMTH']))// to display pass M/Y based on the  value
            {
                $checked=($lobj_rs[$m]['FPRESENT']=='P')?" checked ":"";
                $FPASSMTH="<input type='checkbox' {$checked} id='exam_{$char_name}_ce_pass_{$txt_id}'>";
                $FPASSMTH_TD="";
                $code_pop_up_field="";
            }
            else
            {
                $FPASSMTH=$lobj_rs[$m]['FPASSMTH'];
                $FPASSMTH_TD=" id='exam_{$char_name}_ce_pass_{$txt_id}' ";
                $code_pop_up_field='readonly=true;';
			}
			
            if($lobj_rs[$m]['fmandatory'] !='T' && $lobj_rs[$m]['FINSERTED'] == 'T')// to display text box for the value if FINSERTED=''T
            {
                //$subjectInstList.=$FSUBCODE."*";
                $sub_code_input_border=    "background-color:#fff";
                $sub_code_input_popup=" onblur='getSubDetails(this.id,{$txt_id});'  onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'";
                $sub_code_input_name="di";
                $input_tab_indx=" tabindex={$txt_id}";
                $read_only=" ";
            }
            else
            {
                $subjectPrevList.=$FSUBCODE."*";
                $sub_code_input_border=    " border:none;";
                $sub_code_input_popup=    "";
                $sub_code_input_name="update";
                $input_tab_indx=" tabindex=-1";
                $read_only=" readonly";
            }
            if($k%2==0)
            {
                $class='tbl_row';
                $inp_class='tbl_row_input';
            }
            else
            {
                $input_class='tbl_row1';
                $inp_class='tbl_row1_input';
            }
			$subjectList.=$FSUBCODE."*";
			
			$idsub = "exam_{$char_name}_ce_sub_code_{$txt_id}";

$id.="<tr>";
            $id.="<td align='center' style='  font-size:12px;   border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input {$code_pop_up_field} {$inp_class} type=text style='width:60px; text-align:center;{$sub_code_input_border}' {$read_only} {$sub_code_input_popup} name='{$sub_code_input_name}'   id='exam_{$char_name}_ce_sub_code_{$txt_id}'  {$input_tab_indx} value='{$FSUBCODE}'> <input  style='text-align:center;' type = 'hidden' id = 'old_exam_{$char_name}_ce_sub_code_{$txt_id}' value='{$FSUBCODE}'> </td>";
            $id.="<td align='center'  style='  font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}' > {$FSUBSHORT}</td>";
            $id.="<td align='left' id='exam_{$char_name}_ce_desc_{$txt_id}'  style='  font-size:12px;    border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;padding:5px 5px;'>   {$FSUBNAME}</td>";
            $id.="</tr>";
            $k++;
            $txt_id++;
        }
        
        $subject_prev_query = "select distinct FSUBCODE,FSUBNAME,FQPCODE AS FSUBSHORT from subject
        where  INSTR('{$prevFreshSub}',FSUBCODE) and fdegree='{$degree}' group by  FSUBCODE";
        $lobj_subject_prev = $aobj_context->mobj_db->GetAll($subject_prev_query);

if($remaining_count>0)
        {
            $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';
                }
                
                $FSUBCODE=$lobj_subject_prev[$j]['FSUBCODE'];
                $FSUBSHORT=$lobj_subject_prev[$j]['FSUBSHORT'];
                $FSUBNAME=$lobj_subject_prev[$j]['FSUBNAME'];
				$idsub = "exam_{$char_name}_ce_sub_code_{$txt_id}";
				
                 $id.="<tr>";
                 $id.="<td align='center'   style=' font-size:12px;   border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input  type='text' {$inp_class} name='new_insert'  onblur='getSubDetails(this.id,{$txt_id});'  onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' style='width:60px;background-color:none' tabindex={$txt_id}   id='exam_{$char_name}_ce_sub_code_{$txt_id}' value='{$FSUBCODE}'> <input type = 'hidden'  id = 'old_exam_{$char_name}_ce_sub_code_{$txt_id}' value='{$FSUBCODE}'></td>";
                 $id.="<td align='center'  style=' font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}'>{$FSUBSHORT}</td>";
                 $id.="<td align='left'  id='exam_{$char_name}_ce_desc_{$txt_id}'   style=' font-size:12px;   border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>{$FSUBNAME}</td>";
                 $id.="</tr>";
                 $k++;
                 $txt_id++;
            }
        }
        
            // if(empty($lobj_rs))
            // {
            //     $id.="<tr style='height: 20'>";
            //     $id.="<td COLSPAN=3 align = 'center'><b>No Records Found For this Search<b></td>";
            //     $id.="</tr>";
            // }
            $total_count_of_each_div[$html_id]=$txt_id;
            $exam_fee_val=$exam_fee[$html_id];
        
            $exam_receipt_no_val=$exam_receipt_no[$html_id];
            $exam_receipt_no_date_val=$exam_receipt_no_date[$html_id];
            
            $arr['html_data']=$id;
            $arr['total_count_of_each_div']=$total_count_of_each_div;
            
            $arr['subject_pre']=$subjectPrevList;
            /* if($remaining_count>0)
            $arr['subject_pre']=$subjectPrevList;
            else
            $arr['subject_pre']=$subjectInstList; */
        }
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
        return;
    }
    else
    {
        $id="<tr style='height: 20'>";
        $id.="<td COLSPAN=3 align = 'center'><b>No Records Found For this Search<b></td>";
        $id.="</tr>";
        $arr['html_data']=$id;
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success");
        return;
    }
        
}

function saveFreshExamEntry($aobj_context)
{
    session_start();
    include_once("/JSON.php");
    $json = new Services_JSON();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $college_code = $_SESSION['collcode'];
    $FLOGNAME =  $_SESSION['usr'];
    $reg_no = $aobj_context->mobj_data["reg_no"];
    $degree = $aobj_context->mobj_data["degree"];
    $exam = $aobj_context->mobj_data["fresh_exam"];
    $lstr_param = stripslashes($aobj_context->mobj_data["details"]);
    $mobj_jsondata = $json->decode($lstr_param);
    $sub_arr_data = get_object_vars($mobj_jsondata);
    $sub_prev= $aobj_context->mobj_data["prevSubj"];
    $sub_prev_in = str_replace("*", "','", $sub_prev);
    // var_dump($sub_prev);
    $sub_prev = explode("*", $sub_prev);
    // var_dump($sub_prev);
    $check_adminsion_freeze ="  select distinct c.FCCLSTATUS, d.fmeyear, d.fmeexamtyp from colldeg c, degree d
                                    where c.fdegree = d.fdegree and c.FCOLLCODE='{$college_code}'
                                    and c.FDEGREE='{$degree}'";
	$lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze);

$qry ="select distinct * from candsum c
                                    where c.FCOLLCODE='{$college_code}'
									and c.FDEGREE='{$degree}'
									and c.fregno = '{$reg_no}'
									and ifnull(ffreshexam,'') ='{$exam}'";
	$res = $aobj_context->mobj_db->getRow($qry);
	
	
	
	$semexamfee = $res["FEXAMFEE{$exam}"]; 
	
	
	$prs = "";
	if($semexamfee > 0)
	{	
		$prs = "P";
	}	
	
	
	
    
        $lstr_sub_fee = stripslashes($aobj_context->mobj_data["sub_fee"]);
        $mobj_lstr_sub_fee = $json->decode($lstr_sub_fee);
        $sub_fee_data = get_object_vars($mobj_lstr_sub_fee);

//delete Newly inserted records
        
        $exam_data='';
        $char_id=$exam;
        $exam_data=get_object_vars($sub_arr_data[$char_id]);
        
        // var_dump($exam_data);
        $SubjectArray[1]=$exam_data;
        $exam_Subjdata='';
        $exam_Subjdata=get_object_vars($sub_arr_data[$char_id]);
        
// do insert/update
        $sub_fresh='';
        $char_id=$exam;
        
        
        if(!empty($exam_Subjdata))
        {
            for($k=0;$k<count($exam_Subjdata);$k++)
            {
                    
                if (!in_array($exam_Subjdata[$k]->sub, $sub_prev, true)) {
                        $sub_fresh.=$exam_Subjdata[$k]->sub.'*';
                    }
                    
				if($exam_Subjdata[$k]->sub != $exam_Subjdata[$k]->oldsub)
				{
					
					if($exam_Subjdata[$k]->oldsub == "")
					{
						$query="insert into canddet
						(FDEGREE,
						FEXAMNO,
						FCOLLCODE,
						FREGNO,
						FSUBCODE,
						FINSERTED,
						FPRESENT, fyear, fexamtype, fmoduser, fmoddate) values
						(
						'{$degree}',
						'{$exam_Subjdata[$k]->ex}',
						'{$college_code}',
						'{$reg_no}',
						'{$exam_Subjdata[$k]->sub}',
						'T',
						'{$prs}', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}',
						'{$FLOGNAME}',now()
						)";
						$lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($query);
					}else
					{
						$query = "update canddet set fsubcode = '{$exam_Subjdata[$k]->sub}',
						fpresent = '{$prs}', fmoduser = '{$FLOGNAME}', fmoddate = now()
						where fregno = '{$reg_no}' and fcollcode = '{$college_code}' and fdegree = '{$degree}' 
						and fsubcode = '{$exam_Subjdata[$k]->oldsub}'";
						$lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($query);

$query1 = "update appcanddet set fsubcode = '{$exam_Subjdata[$k]->sub}',
						fpresent = '{$prs}'
						where fregno = '{$reg_no}' and fcollcode = '{$college_code}' and fdegree = '{$degree}' 
						and fsubcode = '{$exam_Subjdata[$k]->oldsub}'";
						$res = $aobj_context->mobj_db->Execute($query1);

}

$query1 = "insert ignore into marks (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks, fyear, fexamtype)
                    select c.fdegree,c.fexamno,c.fcollcode,c.fregno,
                    s.fcsubcode,'-1', c.fyear,c.fexamtype
                    from candsum c inner join 
                    subject s on c.fdegree = s.fdegree and  s.fexamno = '{$exam_Subjdata[$k]->ex}'
                    and s.FSUBCODE	= '{$exam_Subjdata[$k]->sub}'
                    where c.fregno = '{$reg_no}'
                    and c.fcollcode = '{$college_code}' and c.fdegree = '{$degree}'
                    and s.fintass = 'T' and s.fretain = 'T'";
                    $res = $aobj_context->mobj_db->Execute($query1); 
                    
                    $query = "insert ignore into marks_pr (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks11, fyear, fexamtype)
                    select cd.fdegree,cd.fexamno,cd.fcollcode,cd.fcollcode,s.fcsubcode,'-1', 
                    cd.fyear,cd.fexamtype
                    from subject s inner join candsum cd on s.fdegree = cd.fdegree 
                    and s.fsubcode = '{$exam_Subjdata[$k]->sub}'
                    and cd.fregno = '{$reg_no}'
                    and ifnull(cd.fpassmth,'') = '' 
                    and ifnull(cd.fthpr,'') <> 'F'
                    where s.fdegree = '{$degree}' 
                    and cd.fcollcode = '{$college_code}'
                    and s.ftheory = 'F'
                    and ifnull(s.fintass,'F') <> 'T'";
                    $res = $aobj_context->mobj_db->Execute($query);
					
				}	
            }
        }
            
        if($lobj_insert_canddet_records)
        {
            $select_nxtreg_query="select FREGNO from student where FREGNO > '{$reg_no}' and FCOLLCODE='{$college_code}' order by FREGNO limit 1";
            $lobj_select_nxtreg=$aobj_context->mobj_db->getRow($select_nxtreg_query);
            $preg_details=array();
            $preg_details[0]=$reg_no;
            $preg_details[1]=$degree;
            $preg_details[2]=$exam;
            $arr['prev_reg']=$preg_details;
            $arr['next_reg']=$lobj_select_nxtreg;
            $arr['prev_subjects']=$sub_fresh;
            //$arr='Details Updated Successfully';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
            return;
        }
        else
        {
            $arr='Updation failed';
            $arr['prev_subjects']='';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success");
            return;
        }
    
}
?>

${this.title}

Code Editor : subject_freshExam_rcub.php