Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
adm_admin.php	35.05 KB	-rw-r--r--
adm_master.php	14.07 KB	-rw-r--r--
adm_register.php	78.86 KB	-rw-r--r--
adm_session_start.php	893 B	-rw-r--r--
cappcontext.php	4.58 KB	-rw-rw-r--
constants.php	818 B	-rw-rw-r--
coutput.php	1.75 KB	-rw-rw-r--
create_user.php	27.69 KB	-rw-rw-r--
creditMaster.php	2.31 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
cuser1.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.35 KB	-rwxr-xr-x
dailyValuation.php	1.6 KB	-rwxr-xr-x
dashboard.php	3 KB	-rwxr-xr-x
dashboardNew.php	31.05 KB	-rw-r--r--
database.php	744 B	-rw-rw-r--
dateMaster.php	2.83 KB	-rwxr-xr-x
dateupdate.php	8.88 KB	-rw-r--r--
define_heads.php	1.89 KB	-rw-r--r--
degcollege.php	7.32 KB	-rwxr-xr-x
deggrp.php	13.84 KB	-rwxr-xr-x
deggrpNew.php	4.04 KB	-rw-r--r--
degree.php	3.34 KB	-rwxr-xr-x
degreeEntry.php	5.46 KB	-rwxr-xr-x
degreeLoad.php	12.26 KB	-rw-r--r--
dispatchmarkscard.php	19.14 KB	-rwxr-xr-x
drawer.php	552 B	-rw-r--r--
dropDownOptions.php	400 B	-rwxr-xr-x
eGovSignin.php	4.22 KB	-rwxr-xr-x
error_log.php	749 B	-rwxr-xr-x
examAttendance.php	23.9 KB	-rwxr-xr-x
examCntr.php	6.73 KB	-rwxr-xr-x
examCntrdurexm.php	4.05 KB	-rwxr-xr-x
examHappeningCentre.php	19.76 KB	-rwxr-xr-x
examTimetable.php	26.1 KB	-rwxr-xr-x
examTimetableErrorReport.php	7.77 KB	-rwxr-xr-x
exam_app_acknowledge.php	8.41 KB	-rw-r--r--
examapprpt.php	2.9 KB	-rw-r--r--
examattendanceunivadmin.php	19.73 KB	-rwxr-xr-x
exceptionhandler.php	236 B	-rwxr-xr-x
fee-str.php	17.08 KB	-rwxr-xr-x
fee_summary_report.php	43.28 KB	-rwxr-xr-x
fee_summary_report_090120202.p...	43.79 KB	-rwxr-xr-x
finalQp.php	11.07 KB	-rw-r--r--
financeMenuItems.php	1.51 KB	-rw-r--r--
freezeTimetable.php	2.98 KB	-rwxr-xr-x
getBoards.php	1.34 KB	-rwxr-xr-x
getDegSemList.php	7.75 KB	-rwxr-xr-x
getFaculty.php	602 B	-rwxr-xr-x
getMenus.php	3.92 KB	-rwxr-xr-x
getNotifications.php	1.13 KB	-rwxr-xr-x
getPaymentTypes.php	1.77 KB	-rw-rw-r--
getQPdet.php	7 KB	-rw-r--r--
getRvPcReport.php	4.99 KB	-rwxr-xr-x
getStudentRegisteredReport.php	8.91 KB	-rw-r--r--
getUnivName.php	516 B	-rw-r--r--
get_result_table.php	109 B	-rw-r--r--
getdeggrpvalcntr.php	1.88 KB	-rw-r--r--
getinwordstatus.php	3.46 KB	-rw-r--r--
getpgetSavedData.php	4.29 KB	-rwxr-xr-x
getrvpc.php	8.89 KB	-rw-r--r--
getstuddetforrt.php	5.85 KB	-rw-r--r--
getunivs.php	816 B	-rwxr-xr-x
groupMessages.php	9.1 KB	-rwxr-xr-x
grv.php	12.12 KB	-rwxr-xr-x
holidayListing.php	696 B	-rwxr-xr-x
holidayMaster.php	2.11 KB	-rwxr-xr-x
hostNotification.php	1.61 KB	-rwxr-xr-x
htdwonload.php	7.5 KB	-rwxr-xr-x
iNeedHelp.php	3.02 KB	-rwxr-xr-x
iamarkssummary.php	6.25 KB	-rw-r--r--
insertOrEditCollege.php	21.88 KB	-rwxr-xr-x
inward.php	3.09 KB	-rwxr-xr-x
json.php	33.2 KB	-rwxr-xr-x
jwt.php	13.16 KB	-rwxr-xr-x
kswuomr.php	2.8 KB	-rw-r--r--
lastDateUpdate.php	3.95 KB	-rwxr-xr-x
lastDateUpdateCorrection.php	4.81 KB	-rw-r--r--
ledgerview.php	3.2 KB	-rwxr-xr-x
loadclgdettab.php	2.26 KB	-rw-r--r--
loadclgnm.php	1.3 KB	-rw-r--r--
loaddegdet.php	1.45 KB	-rw-r--r--
loaddegreedettab.php	2.49 KB	-rw-r--r--
loadupdclgnm.php	741 B	-rw-r--r--
login.php	1.72 KB	-rwxr-xr-x
loginDet.php	1.04 KB	-rw-r--r--
loginDetails.php	842 B	-rw-r--r--
loginattendance.php	2.21 KB	-rw-r--r--
marks_enter.php	5.74 KB	-rw-r--r--
marksentryupdate.php	4.78 KB	-rw-r--r--
marksmodreport.php	1.49 KB	-rw-r--r--
masQP.php	3.37 KB	-rwxr-xr-x
masterDegree.php	1.16 KB	-rw-r--r--
mcfverify.php	6.65 KB	-rw-r--r--
mpcmanage.php	2.57 KB	-rw-r--r--
mregistry.php	7.59 KB	-rwxr-xr-x
mregistry.php.orig	39.87 KB	-rwxr-xr-x
mregistry_01042021.php	45.75 KB	-rwxr-xr-x
mregistry_arun.php	18.94 KB	-rwxr-xr-x
mregistry_old.php	6.82 KB	-rwxr-xr-x
mregistry_old_03072020.php	33.09 KB	-rwxr-xr-x
mregistry_old_08052020.php	29.86 KB	-rwxr-xr-x
notificationPush.php	9.36 KB	-rwxr-xr-x
oldquestionpaper.php	4.87 KB	-rw-r--r--
omrqnentry.php	8.18 KB	-rw-r--r--
online-test.php	12.77 KB	-rwxr-xr-x
orderReportExcel.php	7.35 KB	-rw-r--r--
paymentReport.php	3.64 KB	-rwxr-xr-x
pgetDashboard.php	0 B	-rwxr-xr-x
pgprevmarks.php	13.41 KB	-rw-r--r--
photoCrop.php	5.57 KB	-rwxr-xr-x
practicalMarks.php	7.09 KB	-rw-r--r--
prbatchdet.php	3.26 KB	-rwxr-xr-x
prifreeze.php	3.11 KB	-rw-r--r--
pushmarks.php	1.18 KB	-rw-r--r--
pushnitification.php	8.1 KB	-rwxr-xr-x
pushnotif_ra.php	3.94 KB	-rwxr-xr-x
qpIndent.php	37.42 KB	-rwxr-xr-x
qpIndent_04032019.php	15.36 KB	-rwxr-xr-x
qpIndent_old.php	37.05 KB	-rwxr-xr-x
qp_dashboard.php	11.31 KB	-rw-r--r--
qp_issue.php	8.46 KB	-rw-r--r--
qp_setter.php	59.66 KB	-rw-r--r--
qp_setter_new.php	53.28 KB	-rw-r--r--
qpboardupdate.php	4.26 KB	-rw-r--r--
qpcrosscheck.php	11.96 KB	-rw-r--r--
qpindentstudlist.php	11.16 KB	-rw-r--r--
qpschemeupload.php	5.84 KB	-rw-r--r--
qpsetterteach.php	22.96 KB	-rw-r--r--
qpsummarynew.php	4.58 KB	-rw-r--r--
qptranlogin.php	1.64 KB	-rw-r--r--
qptranmenu.php	2.22 KB	-rw-r--r--
qpupload.php	8.11 KB	-rwxr-xr-x
qpupload_240621.php	6.49 KB	-rwxr-xr-x
rauspush.php	4.03 KB	-rw-r--r--
razorPayConfig.php	250 B	-rwxr-xr-x
reasonMaster.php	1.73 KB	-rwxr-xr-x
refund.php	2.68 KB	-rwxr-xr-x
register_rrit.php	28.44 KB	-rw-r--r--
releaseTimetable.php	4.73 KB	-rwxr-xr-x
reports_bkp.php	12.25 KB	-rwxr-xr-x
resultStats.php	4.69 KB	-rwxr-xr-x
result_pushnotif_bcu.php	2.33 KB	-rwxr-xr-x
result_pushnotif_bnu.php	2.33 KB	-rwxr-xr-x
result_pushnotif_dud.php	2.33 KB	-rwxr-xr-x
result_pushnotif_kus.php	2.33 KB	-rwxr-xr-x
result_pushnotif_rcub.php	2.33 KB	-rwxr-xr-x
resultdate.php	6.39 KB	-rw-r--r--
resultsApp.php	55 B	-rwxr-xr-x
results_new.php	31.65 KB	-rw-r--r--
resultstat.php	1.72 KB	-rw-r--r--
resultstatsrpt.php	13.82 KB	-rwxr-xr-x
retBatchDet.php	955 B	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
ruaspush.php	618 B	-rw-r--r--
rvMarksEntry.php	4.78 KB	-rwxr-xr-x
rvStatus.php	769 B	-rw-r--r--
rv_result_pushnotif_bcu.php	1.96 KB	-rwxr-xr-x
rvpc.php	1.76 KB	-rw-r--r--
rvrtReport.php	12.39 KB	-rwxr-xr-x
rvrt_Block.php	3.23 KB	-rw-r--r--
rvrtapp.php	22.11 KB	-rw-r--r--
rvrtblock.php	2.97 KB	-rw-r--r--
saveBKMCStdDet.php	2.22 KB	-rw-r--r--
saveBankDetails.php	1.54 KB	-rwxr-xr-x
saveBarcodeDeatils.php	2.87 KB	-rwxr-xr-x
saveDegSemDet.php	14.09 KB	-rwxr-xr-x
saveFinbkmh.php	2.1 KB	-rw-r--r--
savePGETApp.php	4.45 KB	-rwxr-xr-x
savePostNotification.php	2.94 KB	-rwxr-xr-x
scheduleqp.php	2.58 KB	-rw-r--r--
script.php	14.27 KB	-rwxr-xr-x
sdqpmenus.php	163 B	-rw-r--r--
searchregcode.php	5.17 KB	-rw-r--r--
selectFinalQpNew.php	4.69 KB	-rw-r--r--
sendConfMail.php	19.43 KB	-rwxr-xr-x
sendGridMail.php	1.72 KB	-rwxr-xr-x
sendOTP.php	5.51 KB	-rw-r--r--
sendOrder.php	12.33 KB	-rw-r--r--
sendnotification.php	0 B	-rwxr-xr-x
sendsms.php	11.83 KB	-rwxr-xr-x
sendsms_05092020.php	4.34 KB	-rwxr-xr-x
sendsms_15022019.php	6.66 KB	-rwxr-xr-x
sendsms_27012018.php	4.3 KB	-rwxr-xr-x
sendsmsapi.php	802 B	-rwxr-xr-x
sendzohomail.php	1.46 KB	-rw-r--r--
session_start.php	149 B	-rw-r--r--
session_start_rr.php	864 B	-rw-r--r--
sessionmaster.php	1.49 KB	-rw-r--r--
setDGExamTimetableReport.php	19.63 KB	-rwxr-xr-x
setDGExamTimetableReport_bcu_p...	11.51 KB	-rwxr-xr-x
setExamTimetable.php	5.01 KB	-rwxr-xr-x
setExamTimetableReport.php	9.84 KB	-rwxr-xr-x
settlement.php	9.06 KB	-rw-r--r--
sms-new.php	26.55 KB	-rw-r--r--
sms-notification.php	21.17 KB	-rwxr-xr-x
ssp_error_data.php	31.1 KB	-rwxr-xr-x
sspdata-auto-upload.php	11.12 KB	-rwxr-xr-x
sspdata.php	23.9 KB	-rwxr-xr-x
sspdata1.php	11.41 KB	-rw-r--r--
sspdata1_rcub.php	13.96 KB	-rw-r--r--
std_registrtion.php	1.4 KB	-rw-r--r--
studDoc.php	913 B	-rw-r--r--
studReg.php	1.64 KB	-rw-r--r--
stud_ack.php	9.89 KB	-rw-r--r--
stud_det.php	1.62 KB	-rw-r--r--
stud_payments.php	3.24 KB	-rw-rw-r--
student.php	26.71 KB	-rwxr-xr-x
studexamappblock.php	1.18 KB	-rw-r--r--
studymaterial.php	3.07 KB	-rwxr-xr-x
subject.php	2.42 KB	-rwxr-xr-x
subjectEntryScrn.php	8 KB	-rwxr-xr-x
subjectFreeze.php	4.91 KB	-rw-r--r--
sublisting.php	2.39 KB	-rw-r--r--
tdvsCreatePanel.php	1.26 KB	-rw-r--r--
tdvsQPteach.php	2.17 KB	-rw-r--r--
tdvsViewStatus.php	3.52 KB	-rw-r--r--
tdvs_Deviation.php	8.61 KB	-rw-r--r--
tdvs_batch.php	5.89 KB	-rw-r--r--
tdvs_createuser.php	6.5 KB	-rw-r--r--
tdvs_dashboard.php	3.58 KB	-rw-r--r--
tdvs_mail.php	5.93 KB	-rw-r--r--
tdvs_pergeval.php	11.55 KB	-rw-r--r--
tdvs_register.php	1.57 KB	-rw-r--r--
tdvs_saveRecieveQPCount.php	3.53 KB	-rwxr-xr-x
tdvs_saveScript.php	11.74 KB	-rw-r--r--
tdvs_script_cross_check.php	9.35 KB	-rw-r--r--
tdvs_stats.php	21.48 KB	-rw-r--r--
tdvs_subject.php	4.45 KB	-rw-r--r--
tdvs_subjectcreate.php	6.11 KB	-rw-r--r--
tdvs_teacher_valdet.php	2.87 KB	-rw-r--r--
tdvs_teacherpanel.php	3.38 KB	-rw-r--r--
tdvs_teachval.php	1.88 KB	-rw-r--r--
tdvs_teachwisevaldet.php	3.28 KB	-rw-r--r--
tdvs_valcenter.php	2.84 KB	-rw-r--r--
tdvs_verifyqppattern.php	1.03 KB	-rw-r--r--
tdvsdecoding.php	34.16 KB	-rw-r--r--
teachReport.php	5.27 KB	-rwxr-xr-x
teachValBill.php	990 B	-rwxr-xr-x
teachcoderange.php	1.71 KB	-rw-r--r--
teacherEmail.php	20.45 KB	-rw-r--r--
teacherEntry.php	67.04 KB	-rw-r--r--
teacherid.php	2 KB	-rw-r--r--
teachval.php	8.56 KB	-rwxr-xr-x
teachvaluationcount.php	21.07 KB	-rw-r--r--
teachworkapi.php	2.37 KB	-rwxr-xr-x
teachworksum.php	2.42 KB	-rwxr-xr-x
timetablesownload.php	9.98 KB	-rwxr-xr-x
timetablesownload_29062019.php	10.51 KB	-rwxr-xr-x
ttUpload.php	2.5 KB	-rwxr-xr-x
uChangeEmail.php	4.38 KB	-rwxr-xr-x
uChangeMobNum.php	5.17 KB	-rwxr-xr-x
uChangeRegNum.php	4.04 KB	-rwxr-xr-x
uDegPassCrit.php	1.32 KB	-rwxr-xr-x
uDeleteSpecificCollege.php	611 B	-rwxr-xr-x
uExamApplication.php	907 B	-rwxr-xr-x
uExamApplicationForm.php	30.97 KB	-rwxr-xr-x
uForgotPws.php	4.85 KB	-rwxr-xr-x
uGetDetailResult.php	2.17 KB	-rwxr-xr-x
uGetExamCenter.php	1.04 KB	-rwxr-xr-x
uGetResult.php	26.94 KB	-rwxr-xr-x
uGetResultSemester.php	896 B	-rwxr-xr-x
uGetSpecificCollege.php	1.43 KB	-rwxr-xr-x
uGrievances.php	2.97 KB	-rwxr-xr-x
uHallticket.php	5.33 KB	-rwxr-xr-x
uIAMarks.php	3.41 KB	-rwxr-xr-x
uINeedHelp.php	2.82 KB	-rwxr-xr-x
uInsertOrUpdateCollegeDetails....	2.42 KB	-rwxr-xr-x
uMenu_new.php	2.27 KB	-rwxr-xr-x
uNotification.php	3.1 KB	-rwxr-xr-x
uOldQuestionPaper.php	3.46 KB	-rwxr-xr-x
uPracticaltt.php	2.41 KB	-rwxr-xr-x
uProfile.php	1.27 KB	-rwxr-xr-x
uRegistration.php	16.86 KB	-rwxr-xr-x
uRevaluation.php	26.39 KB	-rwxr-xr-x
uRvAppStatus.php	2.42 KB	-rwxr-xr-x
uSubjectList.php	1.53 KB	-rwxr-xr-x
uSupport.php	1023 B	-rwxr-xr-x
uTheorytt.php	2.5 KB	-rwxr-xr-x
uansbookdet.php	2.85 KB	-rwxr-xr-x
uansbookdet0.php	11.83 KB	-rwxr-xr-x
uansbookupdate.php	1.29 KB	-rwxr-xr-x
ulogin.php	2.54 KB	-rwxr-xr-x
ultRoomDet.php	1.96 KB	-rw-r--r--
umenu.php	1.07 KB	-rwxr-xr-x
uniAttEntry.php	1.03 KB	-rw-r--r--
uniContctFrom.php	1.29 KB	-rwxr-xr-x
univRefund.php	9.81 KB	-rwxr-xr-x
unotification.php	3.1 KB	-rwxr-xr-x
upcomingnotification.php	4.55 KB	-rw-r--r--
updateIAMarks.php	1.42 KB	-rw-r--r--
updateRvPcChkList.php	1.13 KB	-rwxr-xr-x
update_dates.php	11.89 KB	-rw-r--r--
upload-sms-excel.php	3.58 KB	-rwxr-xr-x
uploadAnsBook.php	3.38 KB	-rwxr-xr-x
uploadCodeSlips.php	4.1 KB	-rw-r--r--
uploadData.php	6.24 KB	-rwxr-xr-x
uploadDummy.php	761 B	-rw-r--r--
uploadMCdetails.php	4.17 KB	-rw-r--r--
uploadMultipleFiles.php	3.99 KB	-rwxr-xr-x
uploadSSPData.php	5.9 KB	-rw-r--r--
uploadSSPData_bonf.php	11.86 KB	-rw-r--r--
upload_ans_book.php	5.25 KB	-rwxr-xr-x
upload_qp.php	1.85 KB	-rw-r--r--
upload_sms_file.php	7.94 KB	-rw-rw-r--
uploadbackup.php	5.16 KB	-rw-r--r--
uploadcorr_qp.php	4.74 KB	-rw-r--r--
uploadcorrdoc.php	4.09 KB	-rw-r--r--
uploadpwd.php	1.92 KB	-rw-r--r--
uploadqp.php	6.43 KB	-rw-r--r--
uploadqpMultipleFiles.php	678 B	-rw-r--r--
uploadscripts.php	333 B	-rw-r--r--
utils.php	4.19 KB	-rw-r--r--
uucmsdecoding.php	1.86 KB	-rw-r--r--
valuatordet.php	3.29 KB	-rwxr-xr-x

Code Editor : results_new.php

<?php

include 'database.php';

error_reporting(E_ALL);
ini_set('display_errors', 'on');

if($_REQUEST['a']== 'getResAll')
	{

$univcode = $_SESSION['UNIVCODE'];
		$regno    = $_SESSION['REGNO'];
		
		$res=array();
		$final_arr=array();

$num = mysqli_num_rows($result);

while($row = mysqli_fetch_assoc($result)){
			$final_arr['year']=$row['fyear'];
			$final_arr['examdate']=$row['fexamdate'];
			$final_arr['examname']=$row['fexamname'];
			$final_arr['resultdate']=$row['fresultdate'];
			$final_arr['regno']=$row['fregno'];
			$final_arr['name']=$row['fname'];
			$final_arr['degree']=$row['degree'];
			$final_arr['college']=$row['college'];
			array_push($res,$final_arr);
		}

if(empty($result))
		{
			$res['error_code'] = 1;
			$res['status'] = 'Failure';
			echo json_encode($res);
			return;	
		}
		$res1['error_code']=0;
		$res1['data']=$res;

echo json_encode($res1); 
		return;
	}else if($_REQUEST['a']== 'getRvAll')
	{

$univcode = $_SESSION['UNIVCODE'];
		$regno    = $_SESSION['REGNO'];
		
		$res=array();
		$final_arr=array();

$query = "select concat(d.fexamno,'-',d.fyear,'-',d.fexamtype) as fyear, 
		d.fexamdate, dg.fexamname,date_format(r.fresultdate,'%d/%m/%Y') as fresultdate,r.fregno,
		concat(dg.fdegree,' - ',dg.fdescpn) as degree,
		concat(c.fcollcode,' - ',c.fcollname,', ',ftown) as college, 
		concat(
		
			if(date_format(ifnull(FRVLASTDATE,'00/00/000'),'%d/%m/%Y') = '00/00/0000','',
			concat('RV: ', date_format(FRVLASTDATE,'%d/%m/%Y'))),
			
			if(date_format(ifnull(FXEROXLASTDATE,'00/00/000'),'%d/%m/%Y') = '00/00/0000','',
			concat(' PC: ', date_format(FXEROXLASTDATE,'%d/%m/%Y'))),
			
			if(date_format(ifnull(FRTLASTDATE,'00/00/000'),'%d/%m/%Y') = '00/00/0000','',
			concat(' RT: ', date_format(FRTLASTDATE,'%d/%m/%Y'))),
			
			if(date_format(ifnull(FCVLASTDATE,'00/00/000'),'%d/%m/%Y') = '00/00/0000','',
			concat(' CV: ', date_format(FCVLASTDATE,'%d/%m/%Y')))
			
			) as rvdates,
		s.fname as fname,
		if(
		(
		(r.FRVLASTDATE >=date_format(now(),'%Y-%m-%d')) or
		(r.FRTLASTDATE >=date_format(now(),'%Y-%m-%d')) or 
		(r.FXEROXLASTDATE >=date_format(now(),'%Y-%m-%d')) or 
		(r.FCVLASTDATE >=date_format(now(),'%Y-%m-%d'))
		),1,0) as rvenable
		from degexam d inner join res_fee r on d.fdegree = r.fdegree 
		and d.fexamno = r.fexamno
		and d.fyear = r.fyear
		and d.fexamtype = r.fexamtype
		inner join degree dg on r.fdegree = dg.fdegree	
		and r.fexamno = dg.fexamno
		inner join student s on s.fregno = r.fregno
		inner join college c on s.fcollcode = c.fcollcode
		where r.fregno = '{$regno}'
		order by rvenable desc, r.fexamno";
		$result =mysqli_query($conn,$query);

$num = mysqli_num_rows($result);

if(empty($result))
		{
			$res['error_code'] = 1;
			$res['status'] = 'Failure';
			echo json_encode($res);
			return;	
		}
		$res1['error_code']=0;
		$res1['data']=$res;

echo json_encode($res1); 
		return;
	}
	else if($_REQUEST['a']== 'getResults'){

// include 'database.php';

$univcode = $_SESSION['UNIVCODE'];

// include("commandb.php");

$fexamnoarry = $_GET['examno'];
		$examarry = explode("-",$fexamnoarry);	
		$fexamno = $examarry[0];
		$year = $examarry[1];
		$examtype = $examarry[2];
		$res = array();

//===Get Basic Student Details===//
		$qry = "select s.fregno,s.FDEGREE,d.FDESCPN, s.FEXAMNO,d.FEXAMNAME,s.FCOLLCODE,concat(c.FCOLLNAME,', ', c.FTOWN) as FCOLLNAME,
		de.fexamdate as FRESEXAMDATE,
		s.FREGNO,s.FNAME,d.FELIGREM01,d.FELIGREM02,ifnull(s.FFATNAME,'') as FFATNAME,
		ifnull(s.FMOTNAME,'') as MOTNAME,ifnull(FNEXTEXAM,'-') as fnextexam 
		from student s inner join college c on c.FCOLLCODE=s.FCOLLCODE 
		inner join degree d on d.FDEGREE=s.FDEGREE 
		inner join degexam de on d.fdegree = de.fdegree and d.fexamno = de.fexamno
		and de.fyear = '{$year}'
		and de.fexamtype = '{$examtype}'
		where s.FREGNO = '{$_SESSION['REGNO']}' and d.fexamno = '{$fexamno}' ";
		
	
		$result1 = $conn->query($qry);
		$result1 = $result1->fetch_assoc();//mysqli_fetch_assoc($result1);
		$fnextexam = $result1['fnextexam'];	
		$FDEGREE = $result1['FDEGREE'];	
	// 	die();
		//====Get the dates for Reval n etc ====//
		$get_result_date="select FCOLLCODE,
		DATE_FORMAT(FRESULTDATE,'%d/%m/%Y') as FRESULTDATE,
		DATE_FORMAT(IFNULL(FRVLASTDATE,'0000-00-00'),'%d/%m/%Y') as FRVLASTDATE,
		DATE_FORMAT(IFNULL(FRTLASTDATE,'0000-00-00'),'%d/%m/%Y') as FRTLASTDATE,
		DATE_FORMAT(IFNULL(FXEROXLASTDATE,'0000-00-00'),'%d/%m/%Y') as FXEROXLASTDATE,
		DATE_FORMAT(IFNULL(FCVLASTDATE,'0000-00-00'),'%d/%m/%Y') as FCVLASTDATE,
		DATE_FORMAT(IFNULL(FRILASTDATE,'0000-00-00'),'%d/%m/%Y') as FRILASTDATE,
		ifnull(fdeleted,'') as fdeleted
		from res_fee
		where FREGNO='{$_SESSION['REGNO']}'
		and FEXAMNO='{$fexamno}'
		and fyear = '{$year}'
		and fexamtype = '{$examtype}'";

$result_dates=$conn->query($get_result_date);
		$result_dates = $result_dates->fetch_assoc();

$_SESSION['g_FCOLLCODE']=$result_dates['FCOLLCODE'];
		$FRESULTDATE=$result_dates['FRESULTDATE'];		
		$FRVLASTDATE=$result_dates['FRVLASTDATE'];		
		$FRTLASTDATE=$result_dates['FRTLASTDATE'];		
		$FCVLASTDATE=$result_dates['FCVLASTDATE'];		
		$FXEROXLASTDATE=$result_dates['FXEROXLASTDATE'];	
		$dates['accDate'] = $FRESULTDATE;
		$dates['scroll_txt']=" ";

if($FRVLASTDATE!="00/00/0000" || $FRTLASTDATE!="00/00/0000" || $FXEROXLASTDATE!="00/00/0000" || $FCVLASTDATE!="00/00/0000"){
			$dates['scroll_txt'] .="Last Date for";
		}

if($FRVLASTDATE!="00/00/0000")
		{
			$dates['scroll_txt'].=" RV : {$FRVLASTDATE} &nbsp;&nbsp;";
		}
		if($FRTLASTDATE!="00/00/0000")
		{
			$dates['scroll_txt'].=" RT : {$FRTLASTDATE} &nbsp;&nbsp; ";

}if($FXEROXLASTDATE!="00/00/0000")
		{
			$dates['scroll_txt'].=" Photo Copy : {$FXEROXLASTDATE} &nbsp;&nbsp;";

}if($FCVLASTDATE!="00/00/0000")
		{
			$dates['scroll_txt'].=" CV : {$FCVLASTDATE} &nbsp;&nbsp;";
		}
		// if($scroll_txt = " Last Date for ")
		// 	$scroll_txt = "";			
		
		//==if fee paid and result announced==//
		$get_rvrtStatus="select ifnull(fcorrtype,'') as fcorrtype from res_stud 
		where fregno = '{$_SESSION['REGNO']}' and fexamno = '{$fexamno}' and fpaymentstatus = 'success'
		and fcorrtype <> 'RT'
		and FEXAMNO='{$fexamno}'
		and fyear = '{$year}'
		order by FCORRTYPE desc";
		
		$obj_get_rvrtStatus = $conn->query($get_rvrtStatus);
		$obj_get_rvrtStatus = $obj_get_rvrtStatus->fetch_assoc();

//$obj_get_rvrtStatus = $obj_get_rvrtStatus->fetch_assoc();
		//$rows = mysqli_fetch_assoc($obj_get_rvrtStatus);
		
		
		$rvDesp = '';
		$rtDesp = '';
		$cvDesp = '';
		$vrSlash = 0;
		$vrSlashSymb ='';
		$vrSlash2 = 0;
		$corrtype='';
			if(@count($obj_get_rvrtStatus) >0)
			{
				foreach($obj_get_rvrtStatus as $rvrtVal)
				{
					//var_dump($rvrtVal);
					if($rvrtVal == 'RV')
					{
						$rvDesp = 'Re-valuation';
						$vrSlash =1;
					}
					if($rvrtVal == 'RT')
					{
						if($vrSlash == 1)
						$vrSlashSymb = ' / ';
						$vrSlash2 =1;
						$rtDesp = $vrSlashSymb.'Re-totalling';
					}
					if($rvrtVal == 'CV')
					{	
						if($vrSlash == 1 || $vrSlash2 == 1)
						$vrSlashSymb = ' / ';
						$cvDesp = $vrSlashSymb.'Challenge valuation';
					}
				}
		}

// }

// $display = "T";
		$rcrtcvDesp = '';
	//	if(count($obj_get_rvrtStatus)>0)
		//{	
			$get_rvrtFeeStatus="select if(fcorrtype = '','',ifnull(fcorrtype,'')) as fcorrtype from res_fee 
			where fregno = '{$_SESSION['REGNO']}' and fexamno = '{$fexamno}'
			and fyear = '{$year}'
			and fexamtype = '{$examtype}'";
			$obj_get_rvrtFeeStatus=$conn->query($get_rvrtFeeStatus);
			$obj_get_rvrtFeeStatus = $obj_get_rvrtFeeStatus->fetch_assoc();
			
			$rvrtArray = (explode(",",$obj_get_rvrtFeeStatus['fcorrtype']));
			
			if($obj_get_rvrtFeeStatus)
			{
				if($obj_get_rvrtFeeStatus['fcorrtype'] != '')
				{
					$vrSlash =0;
					$vrSlashSymb ='';
					$slashRV = 0;
					$slashRT = 0;
					$slashCV = 0;

$rvFeeDesp = "";
					$rtFeeDesp = "";
					$cvFeeDesp = "";
					$vrSlashSymb2 = "";

foreach($rvrtArray as $rvrtArrayVal)
					{
						if($rvrtArrayVal == 'RV')
						{
							$rvFeeDesp = 'Re-valuation';
							$slashRV =1;
						}
						if($rvrtArrayVal == 'RT')
						{
							$rtFeeDesp = 'Re-totalling';
							$slashRT =1;
						}
						if($rvrtArrayVal == 'CV')
						{
							$cvFeeDesp = $vrSlashSymb.'Challenge valuation';
							$slashCV =1;
						}
						if($rvrtArrayVal == 'RI')
						{
							$cvFeeDesp = $vrSlashSymb.'Result Improvement';
							$slashCV =1;
						}
						
					}
						if($slashRV == 1 && $slashRT == 1)
							$vrSlashSymb = ' / ';
						if($slashRT == 1 && $slashCV == 1)
							$vrSlashSymb2 = ' / ';
						if($slashRV == 1 && $slashCV == 1)
							$vrSlashSymb2 = ' / ';	
							
						$rcrtcvDesp = $rvFeeDesp .' '.$vrSlashSymb.$rtFeeDesp.' '.$vrSlashSymb2.$cvFeeDesp.' '.'Result';
						//var_dump($rcrtcvDesp);
						$corrtype.="<div style='text-align:center;font-size:18px;width:100%;font-weight:bold;color:green;margin-bottom:10px;'>{$rcrtcvDesp}</div>";
				}
				else
				{
					//var_dump(count($obj_get_rvrtStatus));
					if(@count($obj_get_rvrtStatus) >0)
					{
						$display = 'F';	
						$rcrtcvDesp = $rvDesp .' '.$rtDesp.' '.$cvDesp.' '.'Result pending';
						//var_dump($rcrtcvDesp);
						if(trim($rcrtcvDesp) == 'Result pending')
							$rcrtcvDesp = "";
						$corrtype.="<div style='text-align:center;font-size:18px;width:100%;font-weight:bold;color:red;margin-bottom:10px;'>{$rcrtcvDesp}</div>";
					}
			
				}
			}
			
	//	}
		//====END====//
		//var_dump($corrtype);

//===Get the Note (remarks) to display at the footer====//
		$get_remarks="SELECT FRESULT_REMARKS, FUNIVCODE FROM control";
		$remarksDet=$conn->query($get_remarks);
		$remarksDet = $remarksDet->fetch_assoc();

$revadeg = "SELECT ifnull(fmctype,'') as fmctype,fdeggrp FROM degree where fdegree = '{$FDEGREE}' and fexamno = '{$fexamno}'";
		$resrevadeg=$conn->query($revadeg);
		$revadegdata = $resrevadeg->fetch_assoc();
		$fmctype = $revadegdata['fmctype'];
		$fdeggrp = $revadegdata['fdeggrp'];
		//===END====//
		
		//====Get Withheld Details===//
		//if($univcode == '003D' || $univcode == '041' || $univcode == '042'){
						//for withhelds

$get_data="select  count(1) as held_cnt, if(ifnull(fmcnumber,'')='','',concat(fmcnumber)) as fwhrem						 
			from resmarks rm					 
			where FREGNO='{$_SESSION['REGNO']}' and 
			rm.FEXAMNO='{$fexamno}' and FCLASS='WITHHELD'
			and fyear = '{$year}'
			and fexamtype = '{$examtype}'";
			$rest=mysqli_query($conn,$get_data);
			$count =  mysqli_num_rows($rest);

$data = mysqli_fetch_assoc($rest);
			$held_cnt = $data['held_cnt'];
			if($held_cnt != 0)
			{
				$res['studDet']=$result1;
				$res['univcode'] = $_SESSION['UNIVCODE'];
				$res['body'] = $data;
				$res['error_code'] = 0;
				$res['dates'] = $dates;
				$res['corrtype'] = $corrtype;
				$res['footerRemarks'] = $remarksDet;
				$res['error_code'] = 0;
				echo json_encode($res); 
				return;
			}
    //}
		// else{
		
			//=====Get Results Details to display=====//
		$query = "select if(FSUBSIDARY = 'T',concat(s.FSUBNAME,' **'),s.FSUBNAME) as FSUBNAME,if(ifnull(s.FLTP,'') = '','',s.FLTP) as FLTP,
		sum(s.FSMAXMARKS) as FSMAXMARKS,
		if(rm.FTHUE='','-',rm.FTHUE) as FTHUE ,
		if(rm.FPRUE='','-',rm.FPRUE) as FPRUE ,
		if(rm.FTHVV='','-',rm.FTHVV) as FTHVV ,
		if(rm.FPRVV='','-',rm.FPRVV) as FPRVV,
		if(rm.FTHIA='','-',rm.FTHIA) as FTHIA,
		if(rm.FPRIA='','-',rm.FPRIA) as FPRIA,
		if(rm.FTHTOT='','-',rm.FTHTOT) as FTHTOT,
		if(rm.FPRTOT='','-',rm.FPRTOT) as FPRTOT,
		if(rm.FTHPASSMTH='','-',rm.FTHPASSMTH) as FTHPASSMTH,
		if(rm.FPRPASSMTH='','-',rm.FPRPASSMTH) as FPRPASSMTH,
		if(rm.FCREDITS = '','-',rm.FCREDITS) as FCREDITS,
		if(ifnull(rm.FGP,'') = '','-',rm.FGP) as FGP,
		if(ifnull(rm.FCP,'') = '','-',rm.FCP) as FCP,
		if(ifnull(rm.FGRADE,'') = '','-',rm.FGRADE) as FGRADE,
		if(ifnull(rm.FSGPA,'') = '','-',rm.FSGPA) as FSGPA,
		if(ifnull(rm.FCGPA,'') = '','-',rm.FCGPA) as FCGPA,
		rm.FMAXMARKS,rm.FTOTMARKS,rm.FPREVMAX,rm.FPREVTOT,rm.FPERCENT,rm.FCLASS,FMCNUMBER,rm.FYEAR,rm.FEXAMTYPE, rm.FSCHEME
		from resmarks rm
		inner join subject s on s.FDEGREE=rm.FDEGREE
		and s.FEXAMNO=rm.FEXAMNO and s.FSUBCODE=rm.FSUBCODE 
		where rm.FREGNO='{$_SESSION['REGNO']}' and rm.fexamno='{$fexamno}'
		and rm.fyear = '{$year}'
		and rm.fexamtype = '{$examtype}'
		group by s.FSUBCODE
		order by s.FPRINTORD,s.fsubcode";
		var_dump($query);
		$result = $conn->query($query);

$title1 = array();
		$send_data = array();
		$final_data = array();
		$marks = "";
		if($row = mysqli_fetch_assoc($result))
		{
			$FSCHEME = $row['FSCHEME'];

if($FSCHEME == 'CR')
			{
			//$w      = array('5','50','5','8','8','8','8','10');
									
				if($univcode == '023')
				{						
					$title1 = ['Sl. No.','Subject Name',
					"Th. / Pr.",
					'Univ.Exam',
					'Viva',
					'IA',
					'Total',
					"Credit Hrs",
					"Grade Points",
					"Credit Points",
					'Remarks'];
				}
				else if($univcode == '045'){
					//$rem = "Remarks";
					$title1 = ['Sl. No.','Subject Name',
							"Credits",
							"Grade Points",
							"Credit Points",
							'Remarks'];
				}
				else if($univcode == '017'){
					//$rem = "Remarks";
					$title1 = ['Sl. No.','Subject Name','L:T:P',
							"Credits",
							"Grade Points",
							"Credit Points",
							'Remarks'];
				}else if($univcode == '041' || $univcode == '042' || $univcode == '044'){ 
					$title1 = ['Sl. No.','Subject Name',
					"Max. Marks",
							"Sec. Marks",	
							"Credit Hrs",
							"Grade Points",
							"Credit Points",
							'Remarks'];
				}else if($univcode == '001'){
					$title1 = ['Sl. No.','Subject Name','Th. / Pr.',
					"Max. Marks",
							"Sec. Marks",	
							"Credit Hrs",
							"Grade Points",
							"Credit Points",
							'Remarks'];
				}
				else if($univcode == '040'){
					if($fdeggrp == 'PHD')
					{
						$title1 = ['Sl. No.','Subject Name',"Th. / Pr.",
						"L:T:P",
						"Credits Hrs",					
						'Grade',
						'Remarks'];
					}else
					{
							$title1 = ['Sl. No.','Subject Name',"Th. / Pr.",
							"L:T:P",
							"Credits Hrs",
							"Grade Points",
							"Credit Points",
							'Grade'];
					}
				}
				else if($univcode == '034'){
					$title1 = ['Sl. No.','Subject Name',"Th. / Pr.",
					"Total Marks",
							"Credits Hrs",
							"Grade Points",
							"Credit Points",
							'Grade'];
				}
				else if($univcode == '030'){

if($fmctype == '21')
					{
						$title1 = ['Sl. No.','Course',
						"Max. Marks",
							"Marks Sec.",
						"No. of Credits",
						"Grade Points",
						"Credit Points",
						'Grade'];

}else
						$title1 = ['Sl. No.','Course',"Th. / Pr.",
							"No. of Credits",
							"Grade Points",
							"Credit Points",
							'Grade'];
				}
				else if($univcode == '039' || $univcode == '035'){
					$title1 = ['Sl. No.','Subject Name',
					"Th. / Pr.",
							"Sem. End Exam",	'Viva',
							'IA',
							'Total',
							"Credit Hrs",
							"Grade Points",
							"Credit Points",
							'Remarks'];
				}
				else if($univcode == '027'){
					$title1 = ['Sl. No.','Subject Name',
							"Th. / Pr.",
							"Univ Exam",
							'Viva',
							'IA',
							'Total',
							'Credit',
							'Grade Point',
							'Credit Point',
							'Remarks'];
				}
				else if($univcode == '036'){
					$title1 = ['Sl. No.','Subject Name',
					"Max. Marks",
							"Sec. Marks",	
							"Credit Hours",
							"Grade Point",
							"Credit Point",
							'Grade'];
				}else if($univcode == '038'){
					$title1 = ['Sl. No.','Course Title',"Th Pr",
					"Sem. End Exam",
							"Credits Hrs",
							"Grade Points",
							"Credit Points",
							'Remarks'];
				}else if($univcode == '008'){
					$title1 = ['Sl. No.','Subject Name','L:T:P',
					"Total Marks",
							"Credit Hours",
							"Grade Point",
							"Credit Point",
							'Grade'];
				}else if($univcode == '037'){
					$title1 = ['Sl. No.','Subject Name',
					"Total Marks",
							"Credits",
							"Grade Points",
							"Credit Points",
							'Grade'];
				}else if($univcode == '032'){//PG
					$title1 = ['Sl. No.','Subject Name','Th. / Pr.',
					"Total Marks",
							"Credit Hours",
							"Grade Point",
							"Credit Point",
							'Grade'];
				}
				else
				{
					$title1 = ['Sl. No.','Subject Name',
							"Th. / Pr.",
							"Univ Exam",
							"Credit Hrs",
							"Grade Points",
							"Credit Points",
							'Remarks'];
				}	
						
				$w = ['5','50','5','8','8','8','8','8','8','8','10'];
					
			}else
			{		
				if($univcode == '034' || $univcode == '033' || $univcode == '032'){
					$title1 = ['Sl. No.','Subject Name',
					"Th. / Pr.",
							"Sem. End Exam",	'Viva',
							'IA',
							'Total',
							'Remarks'];
				}else if($univcode == '035'){
					$title1 = ['Sl. No.','Subject Name',
					"Th. / Pr.",
							"Sem. End Exam",	'Viva',
							'IA',
							'Total',
							'Remarks'];
				}else if($univcode == '040'){
					$title1 = ['Sl.No.','Subject Name',
					"Th. / Pr.",
					'Univ Exam',
					'IA',
					'Total',
					'Remarks'];
				}else if($univcode == '003' || $univcode == '008' ){
					$title1 = ['Sl.No.','Subject Name',
					"Th. / Pr.",
					'Univ Exam',
					'Viva','IA',
					'Total',
					'Remarks'];
				}
				else{
					$title1 = ['Sl.No.','Subject Name',
					"Th. / Pr.",
					'Univ Exam',
					'Viva','IA',
					'Total',
					'Remarks'];
					$w = ['5','50','5','8','8','8','8','10'];
				}
			}

$FMAXMARKS = $row['FMAXMARKS'];
			$FTOTMARKS = $row['FTOTMARKS'];
			$FPREVMAX  = $row['FPREVMAX'];
			$FPREVTOT  = $row['FPREVTOT'];
			$FPERCENT  = $row['FPERCENT'];
			$FCLASS    = $row['FCLASS'];
			$FMCNUMBER = $row['FMCNUMBER'];
			$FYEAR     = $row['FYEAR'];
			$FEXAMTYPE = $row['FEXAMTYPE'];	
			$FSCHEME   = $row['FSCHEME'];	
			
			$sl_no=0;
			foreach($result as $k=>$v)
			{
				
				$sl_no++;
				$FSUBNAME   = $v['FSUBNAME'];
				$FSMAXMARKS = $v['FSMAXMARKS']; 
				$FLTP       = $v['FLTP'];
				$FTHUE      = $v['FTHUE'];
				$FPRUE      = $v['FPRUE'];
				$FTHVV      = $v['FTHVV'];
				$FPRVV      = $v['FPRVV'];
				$FTHIA      = $v['FTHIA'];
				$FPRIA      = $v['FPRIA'];
				$FTHTOT     = $v['FTHTOT'];
				$FPRTOT     = $v['FPRTOT'];
				$FGRADE     = $v['FGRADE']; 
				
				$FTHPASSMTH1 = trim($v['FTHPASSMTH']);
				$FPRPASSMTH1 = trim($v['FPRPASSMTH']);

if($FSCHEME == 'CR' && ($univcode == '040' || $univcode == '027'))
				{	
					$FTHPASSMTH = $FGRADE;
					$FPRPASSMTH = $FGRADE;
				}	
				else
				{
					$FTHPASSMTH = trim($v['FTHPASSMTH']);
					$FPRPASSMTH = trim($v['FPRPASSMTH']);
				}

// $FTHPASSMTH = preg_replace("/[^A-Za-z0-9+-]/","",$FTHPASSMTH); 
				// $FPRPASSMTH = preg_replace("/[^A-Za-z0-9+-]/","",$FPRPASSMTH); 
				// var_dump($FLTP);
				// $FEXAMNO       = $v['FEXAMNO'];
				// $FEXAMNAME     = $v['FEXAMNAME'];
				// $FRESULTDATE   = $v['FRESULTDATE'];
				// $FRESULTSCHEME = $v['FRESULTSCHEME'];
				$FCREDITS      = $v['FCREDITS'];
			
				$FGP  = $v['FGP'];
				$FCP  = $v['FCP'];
				$FCGPA= $v['FCGPA'];
				
				$FSGPA         = $v['FSGPA'];

if($FTHUE != "-" && $FPRUE != "-")
				{
					$mthprue = "Th. Pr.";
					$uni_exam = "{$FTHUE} {$FPRUE}";
				}
				else if($FTHUE != "-")
				{
					$mthprue = "Th.";
					$uni_exam = "{$FTHUE}";
				}
				else
				{
					$mthprue = "Pr.";
					$uni_exam = "{$FPRUE}";
				}
					
				if($univcode=='018')
				{
						$mthprue = "-";
				}

#########viva$########
				if($FTHVV!="-" && $FPRVV!="-")
				{					
					if(empty($FPRVV))
							$viva_exam = $FTHVV;
					else
							$viva_exam = $FPRVV;
				}
				else if($FTHVV!="-")
				{
						$viva_exam = $FTHVV;
				}
				else
				{
						$viva_exam = $FPRVV; 
				}
						#########IA########
				if($FTHIA!="-" && $FPRIA!="-")
				{
					if(empty($FPRIA))
							$ia_exam = $FTHIA;
					else
							$ia_exam = $FPRIA;
							$ia_exam = "{$FTHIA} {$FPRIA}";

}
				else if($FTHIA != "-")
				{
						$ia_exam = $FTHIA;
				}
				else
				{
						$ia_exam = $FPRIA; 
				}
							#########TOTAl########
				if($FTHTOT!="-" && $FPRTOT!="-")
				{
						if(empty($FPRTOT))
								$total = $FTHTOT;
						else
								$total = $FPRTOT;
					$total = "{$FTHTOT} {$FPRTOT}";					
				}
				else if($FTHTOT != "-")
				{
						$total= $FTHTOT;
				}else
				{
						$total= $FPRTOT; 
				}
							#########Remarks########
				if($univcode == '018')
				{
						$FPRPASSMTH="";
				}

if(strtolower($FTHPASSMTH) == strtolower($FPRPASSMTH))
				{
						$remarks = $FTHPASSMTH; 
				}
				else if(strtolower($FTHPASSMTH)=="pass" && strtolower($FPRPASSMTH)=="pass")
				{
						$remarks = "Pass"; 
				}
				else if(strtolower($FTHPASSMTH)=="fail" && strtolower($FPRPASSMTH)=="fail")
				{
						$remarks    = "Fail"; 
				}
				else if(strtolower($FTHPASSMTH)!="-" && strtolower($FPRPASSMTH)=="-")
				{
						$remarks  = $FTHPASSMTH; 
				}
				else if(strtolower($FTHPASSMTH)=="-" && strtolower($FPRPASSMTH)!="-")
				{
						$remarks  = $FPRPASSMTH; 
				}else
				{

if(empty($FPRPASSMTH))
						$remarks = $FTHPASSMTH;
					else{
						if(strtolower($FTHPASSMTH) == 'fail')
							$thfailStatus = "{$FTHPASSMTH}";
						else 
							$thfailStatus = "{$FTHPASSMTH}";
						
						if(strtolower($FPRPASSMTH) == 'fail')
							$prpassStatus = "{$FPRPASSMTH}";
						else
							$prpassStatus = "{$FPRPASSMTH}";

$remarks = $thfailStatus." ".$prpassStatus;
					}

}

if(strtolower($FTHPASSMTH1) == strtolower($FPRPASSMTH1))
				{
						$remarks1 = $FTHPASSMTH1; 
				}
				else if(strtolower($FTHPASSMTH1)=="pass" && strtolower($FPRPASSMTH1)=="pass")
				{
						$remarks1 = "Pass"; 
				}
				else if(strtolower($FTHPASSMTH1)=="fail" && strtolower($FPRPASSMTH1)=="fail")
				{
						$remarks1    = "Fail"; 
				}
				else if(strtolower($FTHPASSMTH1)!="-" && strtolower($FPRPASSMTH1)=="-")
				{
						$remarks1  = $FTHPASSMTH1; 
				}
				else if(strtolower($FTHPASSMTH1)=="-" && strtolower($FPRPASSMTH1)!="-")
				{
						$remarks1  = $FPRPASSMTH1; 
				}else
				{

if(empty($FPRPASSMTH1))
						$remarks1 = $FTHPASSMTH1;
					else{
						if(strtolower($FTHPASSMTH1) == 'fail')
							$thfailStatus = "{$FTHPASSMTH1}";
						else 
							$thfailStatus = "{$FTHPASSMTH1}";
						
						if(strtolower($FPRPASSMTH1) == 'fail')
							$prpassStatus = "{$FPRPASSMTH1}";
						else
							$prpassStatus = "{$FPRPASSMTH1}";

$remarks1 = $thfailStatus." ".$prpassStatus;
					}

}

//--remarks--//
				$send_data['sl_no'] = $sl_no;
				$send_data['subject'] = $FSUBNAME;
				$send_data['remarks1'] = $remarks1;
				
				if($univcode == '040' && $FSCHEME == 'CR'){
					
					if($FSGPA != '-')
					{
						$send_data['mthprue'] = $mthprue;
						$send_data['uni_exam'] = $FLTP; 
						$send_data['viva_exam'] = $FCREDITS; 
						$send_data['ia_exam'] = $FGP; 
						$send_data['thtot'] = $FCP;
					}else
					{
						$send_data['mthprue'] = $mthprue;
						$send_data['uni_exam'] = $FLTP; 
						$send_data['viva_exam'] = $viva_exam; 
						$send_data['ia_exam'] = $ia_exam; 
						$send_data['thtot'] = $total;
					}
				}else if($univcode == "037" && $FSCHEME!="CR"){
					$send_data['mthprue'] = $mthprue;
					$send_data['uni_exam'] = $uni_exam; 
					$send_data['viva_exam'] = $viva_exam; 
					$send_data['ia_exam'] = $ia_exam; 
					$send_data['thtot'] = $total;
				}else
				{
					$send_data['mthprue'] = $mthprue;
					$send_data['uni_exam'] = $uni_exam; 
					$send_data['viva_exam'] = $viva_exam; 
					$send_data['ia_exam'] = $ia_exam;
					if($univcode == '027')
					{
						$send_data['FGP'] =$FGP;
						$send_data['FCP'] =$FCP; 
						if($FSCHEME =="CR" )
							$send_data['FGRADE'] =$FCREDITS;
						else	
							$send_data['FGRADE'] =$FGRADE; 
					}	
					$send_data['thtot'] = $total;
				}

if($univcode == '035' || $univcode == '039' || $univcode == '023' || $univcode == '027')
				{	
					if($FSCHEME == 'CR')
					{	
							$send_data['FCREDITS'] =$FCREDITS;
							$send_data['FGP'] =$FGP;
							$send_data['FCP'] =$FCP;
							$send_data['FSGPA'] =$FSGPA;
							if($FCGPA != '0.00')
									$send_data['FCGPA'] =$FCGPA;
					}
				}

if(($univcode == '017' || $univcode == '008' || $univcode == '045' )&& $FSCHEME == 'CR' ){
					$send_data['mthprue']= $FLTP;
				}

if($univcode == '036' && $FSCHEME == 'CR' ){
					$send_data['mthprue']= $FSMAXMARKS;
				}

if(($univcode == '041' || $univcode == '042' || $univcode == '001' || $univcode == '044') && $FSCHEME == 'CR' )
					$send_data['fsmaxmarks']= $FSMAXMARKS;
				
				
				if($univcode == '030')
				{	
					if($fmctype == '21')	
					{	
						$send_data['fsmaxmarks']= $FSMAXMARKS;
					}	
					$send_data['fmctype']= $fmctype;
				}else 
					$send_data['fmctype']= "";

if(($univcode == '035' || $univcode == '039' || $univcode == '023') && $FSCHEME == 'CR')
			{	
				if($FCLASS == 'Fail, Promoted')
					$result =$FCLASS;//grade
				else
					$result = $FCLASS;
			}else
				$result = $FCLASS;
								
			$send_data['result'] = $result;
			$send_data['remarks'] = $remarks;
			if($FSCHEME != 'CR' || ($univcode == '035' || $univcode == '039' || $univcode == '023')){
				$send_data['FMAXMARKS'] = $FMAXMARKS;
				$send_data['FTOTMARKS'] = $FTOTMARKS;
			}
			if($FSCHEME == 'CR' && $univcode == '033' || $univcode == '008' || $univcode == '034' || $univcode == '036' || $univcode == '032' || $univcode == '027' || $univcode == '001' || $univcode == '047' ){
				$send_data['FMAXMARKS'] = $FMAXMARKS;
				$send_data['FTOTMARKS'] = $FTOTMARKS;
			}
			if($FSCHEME == 'CR')
			{	
				//var_dump($FSGPA);
			
				if($FCGPA != '0.00'){
					$send_data['FCGPA'] = $FCGPA;
					$send_data['FSGPA'] = $FSGPA;
					if($univcode == '040' && $FSGPA !='-')
					{	
						$send_data['FPERCENT'] = $FSGPA;
						if($fnextexam=="-")
							$send_data['FQPALPERCT'] = $FPERCENT;
					}	
					else if($univcode == '027' && $FPERCENT ==$FSGPA)
					{
						$send_data['FPERCENT'] = round((($FTOTMARKS / $FMAXMARKS)*100),2);
					}else
						$send_data['FPERCENT'] = $FPERCENT;
				}
				else{

if($univcode == '040' && $FSGPA !='-')
					{	
						$send_data['FPERCENT'] = $FSGPA;
						if($fnextexam=="-")
					  	$send_data['FQPALPERCT'] = $FPERCENT;
					}else
					{
						$send_data['FPERCENT'] = $FPERCENT;
					}
				}

}else
				$send_data['FPERCENT'] = $FPERCENT;

if($FCGPA == '-' && $FPREVTOT !="0000")
				$send_data['FCGPA'] = $FPREVTOT;
			// if($ $FPREVMAX != "0000" && !empty($FPREVMAX))
			// 	$send_data['FCGPA'] = $FPREVTOT;
				
				$send_data['FPREVMAX'] = $FPREVMAX;

$send_data['FSCHEME'] =$FSCHEME;
			$send_data['fnextexam'] =$fnextexam;
			array_push($final_data,$send_data);
		}
		//===END Result Det==//
			$res['studDet']=$result1;
			$res['headers'] = $title1;
			$res['body'] = $final_data;
			$res['fdeggrp'] = $fdeggrp;
			$res['corrtype'] = $corrtype;
			$res['error_code'] = 0;
			$res['dates'] = $dates;
			$res['corrtype'] = $corrtype;
			$res['footerRemarks'] = $remarksDet;
			$res['univcode'] = $_SESSION['UNIVCODE'];

echo json_encode($res); 
			return;
		}
	else
		{
			$res['error_code'] = 1;
			$res['status'] = 'Failure';
			echo json_encode($res);
			return;
		}
	// }
	}
	else if($_REQUEST['a']== 'getResDet'){
		// include 'database.php';

$univcode = $_SESSION['UNIVCODE'];

// include("commandb.php");
		//$fexamno = $_GET['examno'];

$fexamnoarry = $_GET['examno'];
		$examarry = explode("-",$fexamnoarry);	
		$fexamno = $examarry[0];
		$year = $examarry[1];
		$examtype = $examarry[2];

$query = "select s.FSUBNAME,  rm.fsubcode, rm.fssubname, rm.fmarks, rm.fyear, rm.fexamtype,
	if(s.ftheory = 'T','Th.','Pr.') as thpr
    from resmarksdet rm left join subject s on s.FDEGREE = rm.fdegree
    and s.FEXAMNO = rm.fexamno and s.FCSUBCODE = rm.fsubcode
    where fregno = '{$_SESSION['REGNO']}' 
	and rm.fexamno = '{$fexamno}'
	and rm.fyear = '{$year}'
	and rm.fexamtype = '{$examtype}'
	order by s.fsubcode, s.fssubcode";
		var_dump($query);
		$result =$conn->query($query);
		$row= mysqli_fetch_assoc($result);
		// var_dump($result);
    if(empty($result))
    {
			$res['error_code'] = 1;
			$res['status'] = 'Failure';
			echo json_encode($res);
			return;	
    }
    $final_arr=array();

foreach($result as $k=>$v)
    {			
			$FSUBNAME=$v['FSUBNAME'];
			$fssubname=$v['fssubname'];
			$fmarks=$v['fmarks'];
			$fsubcode=$v['fsubcode'];
			$fthpr=$v['thpr'];

$final_arr[$FSUBNAME][$fsubcode]['s']=$fssubname;
			$final_arr[$FSUBNAME][$fsubcode]['m']=$fmarks;
			$final_arr[$FSUBNAME][$fsubcode]['thpr']=$fthpr;

}
		$res['error_code']=0;
		$res['data']=$final_arr;
    echo json_encode($res); 
	}
	else if ($_REQUEST['a']=='getExamno'){
		// include 'database.php';

$univcode = $_SESSION['UNIVCODE'];

// include "commandb.php";
		$regno = $_SESSION['REGNO'];
		$res=array();
		$final_arr=array();
		$query = "SELECT DISTINCT d.fexamno,d.fexamname FROM res_fee r
		inner join degree d on d.fexamno = r.fexamno and d.fdegree=r.fdegree
		inner join resmarks rm on rm.fregno = r.fregno and rm.fexamno = r.fexamno
		WHERE r.fregno = '{$regno}' 
		and ifnull(r.fdeleted,'') <> 'T'
		order by fexamno desc";
		//var_dump($query,$conn);
		$result =mysqli_query($conn,$query);

//	$row = mysqli_fetch_assoc($result);
	$num = mysqli_num_rows($result);
	//var_dump($num);	
		while($row = mysqli_fetch_assoc($result)){
			$final_arr['fexamno']=$row['fexamno'];
			$final_arr['fexamname']=$row['fexamname'];
				array_push($res,$final_arr);
		}

if(empty($result))
    {
		$res['error_code'] = 1;
		$res['status'] = 'Failure';
		echo json_encode($res);
		return;	
    }
	$res1['error_code']=0;
	$res1['data']=$res;

// $res['data']=$row;
		echo json_encode($res1); 	
	}

${this.title}

Code Editor : results_new.php