Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxr-xr-x
AttDateWiseReportexcel.php	4.39 KB	-rw-r--r--
Attdet.php	7.1 KB	-rw-rw-r--
AttdetPdf.php	8.74 KB	-rw-rw-r--
AttdetPdfUniclare.php	7.49 KB	-rw-rw-r--
AttdetexcelUniclare.php	5.48 KB	-rw-rw-r--
CIEAttendanceNotEligiblepdf.ph...	6.83 KB	-rw-rw-r--
CIEpendingListpdf.php	9.05 KB	-rw-rw-r--
DegreeWiseStudLstUSN.php	7.69 KB	-rw-rw-r--
DownloadExamAppFormApplication...	10.92 KB	-rwxr-xr-x
DownloadRvRtAckApplications.ph...	4.6 KB	-rwxr-xr-x
Generatecollegeiamarkspendingr...	7.49 KB	-rwxrwxrwx
PrintChallanEntryDetails.php	8.27 KB	-rwxr-xr-x
RVApplicationsReport.php	8.9 KB	-rwxr-xr-x
RvPcListDetailedReport.php	12.51 KB	-rwxrwxrwx
RvRtApplicationReport.php	8.86 KB	-rwxr-xr-x
absentAndMalReportPdf.php	11.5 KB	-rw-rw-r--
absentandmalpracticereport.php	10.16 KB	-rw-rw-r--
ack_exam_app_form_bulk.php	11.76 KB	-rwxr-xr-x
admlist.php	13.87 KB	-rwxrwxrwx
admregisterlist.php	7.39 KB	-rwxr-xr-x
affliation_detailed_report.php	12.56 KB	-rwxrwxrwx
appear_list_center_qp_wise.php	13.07 KB	-rwxr-xr-x
appear_list_qp_wise.php	6.32 KB	-rwxr-xr-x
appfeedetails.php	7.67 KB	-rwxr-xr-x
approval_report.php	19.63 KB	-rwxr-xr-x
attCisshortList.php	15.61 KB	-rw-r--r--
attCisshortList_sjbit.php	12.82 KB	-rw-r--r--
attDegwiseReport.php	14.2 KB	-rw-r--r--
attendanceReportForm.php	5.69 KB	-rw-rw-r--
attendanceform_pdf.php	12.35 KB	-rw-r--r--
attiacombined.php	9.52 KB	-rw-r--r--
attiacombinedReportnewexcel_sj...	12.94 KB	-rw-rw-r--
attiacombinednew.php	12.66 KB	-rw-r--r--
attiacombinednew_1.php	12.34 KB	-rw-r--r--
attiacombinednew_2.php	12.33 KB	-rw-r--r--
attiacombinednew_sjbit.php	8.7 KB	-rw-r--r--
attshortlist.php	10.72 KB	-rw-r--r--
basic_data_coll.php	6.79 KB	-rwxr-xr-x
basic_data_sum.php	6.98 KB	-rwxr-xr-x
batch_wise_details.php	4.45 KB	-rwxr-xr-x
board.php	3.86 KB	-rw-rw-r--
bundle_ack.php	13.58 KB	-rwxr-xr-x
candidatelist.php	10 KB	-rw-rw-r--
categorywisereport.php	13.27 KB	-rwxr-xr-x
categorywisereportpdf.php	7.57 KB	-rw-rw-r--
cntrtagcollstud.php	4.99 KB	-rw-rw-r--
code39.php	6.38 KB	-rwxr-xr-x
college_pending_markslist.php	6.78 KB	-rwxrwxrwx
college_pending_markslist19032...	6.48 KB	-rwxr-xr-x
convoreport.php	5.56 KB	-rw-rw-r--
copomarksexternalreportexcel.p...	7.02 KB	-rw-rw-r--
daterange.php	6.27 KB	-rw-rw-r--
degreeDetailsReport.php	7 KB	-rw-rw-r--
degreewiseMarksEntryStats.php	8.44 KB	-rw-rw-r--
elememntWiseReport.php	16.11 KB	-rw-rw-r--
empty_report_admission_det.php	8.91 KB	-rw-rw-r--
enterCOPOmarks.php	2.94 KB	-rw-rw-r--
exam_attendance_det.php	8.61 KB	-rwxr-xr-x
exam_attendance_summary.php	9.78 KB	-rwxr-xr-x
excelreport.php	27.36 KB	-rw-rw-r--
fpdf.php	147.08 KB	-rw-rw-r--
generate.php	7.32 KB	-rw-rw-r--
generateCorseRep.php	7.93 KB	-rw-r--r--
generateDaliyReportQpNitteExce...	16.34 KB	-rw-rw-r--
generatePostAdmissionTicket.ph...	51.8 KB	-rwxr-xr-x
generatePostAdmissionTicketJss...	58.53 KB	-rwxr-xr-x
generatePostAdmissionTicket_25...	47.13 KB	-rwxr-xr-x
generatePostAdmissionTicket_ol...	37.45 KB	-rwxr-xr-x
generatePrintIaMarks.php	16.19 KB	-rw-rw-r--
generatePrintIaMarksnew.php	16.28 KB	-rw-r--r--
generatePrintIaMarksnewXl.php	13.22 KB	-rw-rw-r--
generateQuestionWiseIAReportPD...	18.73 KB	-rw-rw-r--
generateThValReport.php	7.4 KB	-rw-r--r--
generateXlGraph.php	3.87 KB	-rw-rw-r--
generateadmissionreg.php	11.81 KB	-rw-r--r--
generatecoporeport_xl.php	21.08 KB	-rw-rw-r--
gerderwiseresultsheet.php	12.08 KB	-rwxr-xr-x
getDegree.php	2.27 KB	-rw-rw-r--
getDegreeAndSem.php	4.32 KB	-rw-r--r--
getIaSubjWiseReport.php	0 B	-rw-rw-r--
getNitteAdmXlreport.php	14.74 KB	-rw-rw-r--
getReportClassStud.php	6.03 KB	-rw-rw-r--
getTestTotalMarksReport.php	9.49 KB	-rw-rw-r--
getiaabsentreport.php	6.8 KB	-rw-r--r--
gradewisesubjectanalysisreport...	24.66 KB	-rw-r--r--
gradewisesubjectanalysisreport...	20.73 KB	-rw-r--r--
headerNfooter.php	4.89 KB	-rw-rw-r--
iaDegwiseIAReport.php	12.58 KB	-rw-rw-r--
iaMarksQnWiseReportExcel.php	25.41 KB	-rw-rw-r--
iaMarksReportPDF.php	10.84 KB	-rw-r--r--
iaSubjectWiseReport.php	10.74 KB	-rw-rw-r--
ia_room_allotment_datewise.php	9.08 KB	-rwxr-xr-x
iaemptyformat.php	9.63 KB	-rwxr-xr-x
iaroomallotmantsummary.php	5.28 KB	-rwxr-xr-x
iasectionwisenew.php	36.02 KB	-rw-rw-r--
invig_report.php	10.18 KB	-rw-rw-r--
invig_report_summary.php	7.74 KB	-rw-rw-r--
latEntryRprt.php	6.4 KB	-rwxr-xr-x
markListReportPdf.php	21.32 KB	-rw-rw-r--
markListReportPdfnew.php	49.6 KB	-rw-r--r--
markListReportPdfnew_24112023....	42.93 KB	-rw-r--r--
marksEntryQnWiseNewReport.php	13.13 KB	-rw-rw-r--
marksentryquestionwise.php	23.83 KB	-rw-rw-r--
mregistry.php	152.75 KB	-rw-rw-r--
pdfacknowledgeAppNo.php	10.95 KB	-rw-rw-r--
pendingcie.php	0 B	-rw-rw-r--
photo_report.php	7.04 KB	-rw-rw-r--
pi_test.php	3.45 KB	-rw-r--r--
picharttesting.php	24.78 KB	-rw-rw-r--
prbillreports.php	16.32 KB	-rw-rw-r--
principalFreeze_report.php	7.23 KB	-rw-rw-r--
printIaMarks.php	12.74 KB	-rw-r--r--
printIaMarks_old.php	12.74 KB	-rw-rw-r--
printMarkListDetailsWisenew.ph...	10.1 KB	-rw-r--r--
printMarkListDetailsWisenewExc...	15.52 KB	-rw-rw-r--
printMarkListDetailsWisenew_CI...	3.98 KB	-rw-r--r--
printMarkListDetailsWisenew_sj...	15.69 KB	-rw-r--r--
printMarkListDetailsWisenew_sj...	14.54 KB	-rw-r--r--
printMarkListSubWiseJssstu.php	28.4 KB	-rw-rw-r--
print_applications_ru.php	26.59 KB	-rw-rw-r--
progDegwiseReportPdf.php	14.15 KB	-rw-rw-r--
provisionExcelReportSrun.php	12.73 KB	-rw-rw-r--
qp_issue.php	8.47 KB	-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...	56.9 KB	-rwxr-xr-x
qrcodeGeneratePostAdmissionTic...	33.16 KB	-rwxr-xr-x
qrhallticket.php	56.1 KB	-rw-rw-r--
r	9.23 KB	-rwxr-xr-x
regNoAllot.php	35.56 KB	-rw-rw-r--
reg_stud_list.php	8.65 KB	-rwxr-xr-x
reportAttClassCreate.php	5.14 KB	-rw-rw-r--
reportAttCount.php	12.89 KB	-rw-r--r--
reportAttCount_old_08112022.ph...	11.11 KB	-rw-r--r--
report_Xl_getpendingstudentLis...	7.93 KB	-rw-rw-r--
report_adm_lat_studwise.php	10.13 KB	-rwxr-xr-x
report_admission_details.php	26.8 KB	-rwxr-xr-x
report_admission_list.php	49.63 KB	-rwxr-xr-x
report_admission_list_bf_gcg.p...	26.39 KB	-rwxr-xr-x
report_admission_list_kswu.php	15.12 KB	-rwxr-xr-x
report_admission_list_rur.php	28 KB	-rw-rw-r--
report_admission_list_wop.php	10.31 KB	-rwxr-xr-x
report_admission_ticket.php	77.87 KB	-rw-rw-r--
report_admission_ticket_bf_uuc...	37.63 KB	-rwxr-xr-x
report_admission_ticket_jsstu....	70.16 KB	-rw-r--r--
report_admission_ticket_new.ph...	65.79 KB	-rw-rw-r--
report_attendance_sheet.php	23.77 KB	-rwxr-xr-x
report_attendance_shortage.php	9.23 KB	-rw-rw-r--
report_attendance_summary.php	11.48 KB	-rwxr-xr-x
report_attendance_summary_old....	7.19 KB	-rwxr-xr-x
report_bacth_preparation_dairy...	7 KB	-rwxr-xr-x
report_batch_practical_dairy.p...	15.35 KB	-rwxr-xr-x
report_batch_wise_details.php	8.86 KB	-rwxr-xr-x
report_batch_worksheet_details...	20.02 KB	-rwxr-xr-x
report_bulk_applications.php	26.15 KB	-rwxr-xr-x
report_bulk_applications_nitte...	26 KB	-rw-rw-r--
report_bundle_dispatch.php	15.36 KB	-rwxr-xr-x
report_candidate_list.php	31.41 KB	-rwxr-xr-x
report_candidate_list_old.php	29.91 KB	-rwxr-xr-x
report_copoMarksList.php	23.88 KB	-rw-rw-r--
report_daliy_report.php	10.47 KB	-rwxr-xr-x
report_daliy_report_qp.php	10.21 KB	-rwxr-xr-x
report_daliy_report_qp_nitte.p...	20.31 KB	-rwxr-xr-x
report_daliy_report_qp_sjbit.p...	17.49 KB	-rwxr-xr-x
report_data_sent.php	8.41 KB	-rwxr-xr-x
report_degree_list.php	4.71 KB	-rwxr-xr-x
report_deviation_report.php	7.67 KB	-rwxr-xr-x
report_evaluation_report.php	9.31 KB	-rwxr-xr-x
report_ia_ra_invigilator_dairy...	20.87 KB	-rwxr-xr-x
report_ia_ra_roomwise_register...	27.06 KB	-rw-r--r--
report_iamarks_pending.php	8.19 KB	-rwxr-xr-x
report_invigilatorDairy.php	46.77 KB	-rw-rw-r--
report_marks_deviation_report....	5.38 KB	-rwxr-xr-x
report_marks_elementwise.php	3.13 KB	-rwxr-xr-x
report_marks_entry_student_lis...	6.55 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	21.94 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.43 KB	-rwxr-xr-x
report_marks_pending.php	12.02 KB	-rwxr-xr-x
report_online_eam.php	11.59 KB	-rwxr-xr-x
report_practical_marks_details...	13.35 KB	-rwxr-xr-x
report_practical_marks_details...	23.65 KB	-rwxr-xr-x
report_practical_marks_details...	13.33 KB	-rwxr-xr-x
report_practical_marks_details...	13.32 KB	-rwxr-xr-x
report_practical_misc.php	8.24 KB	-rwxr-xr-x
report_qpcount_univ.php	5.17 KB	-rwxr-xr-x
report_ra_exl_report.php	6.89 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	46.94 KB	-rwxr-xr-x
report_ra_invigilator_dairy_bf...	22.69 KB	-rwxr-xr-x
report_ra_invigilator_dairy_gu...	19.86 KB	-rwxr-xr-x
report_ra_invigilator_dairy_ne...	49.39 KB	-rwxr-xr-x
report_ra_invigilator_dairy_sj...	32.35 KB	-rwxr-xr-x
report_ra_invigilator_dairy_st...	19.82 KB	-rw-rw-r--
report_ra_invigilators_dairy.p...	9.27 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	10.97 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	8.74 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	11.21 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	10.67 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	26.44 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	27.15 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	17.6 KB	-rwxr-xr-x
report_reg_list.php	33.33 KB	-rw-rw-r--
report_reg_list_gcg.php	33.55 KB	-rw-rw-r--
report_reg_list_gcg_new_040120...	33.12 KB	-rw-rw-r--
report_registerNoListNoticeBoa...	25.84 KB	-rw-rw-r--
report_registerNoListRoomBoard...	22.08 KB	-rw-rw-r--
report_revaluation.php	6.42 KB	-rwxr-xr-x
report_roomallotmentExcel.php	8.31 KB	-rw-rw-r--
report_subject_admcl_list.php	3.68 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.89 KB	-rwxr-xr-x
resultsheet.php	12.82 KB	-rwxr-xr-x
resultsheetExcel.php	6.37 KB	-rw-r--r--
resultsheet_x.php	9.15 KB	-rwxr-xr-x
resultsheetsubwise.php	11.24 KB	-rwxr-xr-x
revaluation.php	15.65 KB	-rwxr-xr-x
roomAllotment.php	37.45 KB	-rw-rw-r--
room_allotment_datewise_stph.p...	21.46 KB	-rwxr-xr-x
roomallotmantsummary.php	6.66 KB	-rwxr-xr-x
roomallotmantsummarynew.php	7.09 KB	-rwxr-xr-x
roomallotmantsummarysubjwise.p...	9.26 KB	-rw-rw-r--
roomallotmantsummarysubjwisene...	9.89 KB	-rw-r--r--
roomallotmentqpwise.php	10.22 KB	-rw-rw-r--
roomwise_register_nos_list.php	27.87 KB	-rwxr-xr-x
roomwise_register_nos_list_new...	29.38 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
semesterWiseResultReportpdf.ph...	11.03 KB	-rw-rw-r--
shortageReport.php	11.05 KB	-rw-rw-r--
std_regstr_det_reprt_xl.php	7.6 KB	-rw-rw-r--
stringspliter.php	718 B	-rwxr-xr-x
stud_wise_report.php	8.97 KB	-rw-rw-r--
studentHisResult.php	8.34 KB	-rw-r--r--
student_count.php	4.16 KB	-rwxr-xr-x
studentwiseresult.php	18.02 KB	-rw-rw-r--
studentwiseresultExcelReport.p...	10.29 KB	-rw-rw-r--
subWiseFailedStudExcelReport.p...	9.02 KB	-rw-rw-r--
subWiseFailedStudSummary.php	7.78 KB	-rw-rw-r--
subjRegReport.php	8.42 KB	-rw-r--r--
subjectDetailsReport.php	13.93 KB	-rw-rw-r--
subject_wise_student_list.php	6.2 KB	-rwxr-xr-x
subjwisepasspercentage.php	10.99 KB	-rw-rw-r--
subjwisepasspercentagePie.php	10.92 KB	-rw-r--r--
subjwiseressheet.php	12.92 KB	-rwxr-xr-x
subwiseGrafAnalysis.php	20.04 KB	-rw-r--r--
subwiseGrafAnalysis1.php	22.44 KB	-rw-r--r--
subwiseResultReport.php	12.75 KB	-rw-rw-r--
tatkal.php	4.84 KB	-rwxr-xr-x
teachFreeze_report.php	8.96 KB	-rw-r--r--
teacher_report.php	11.26 KB	-rwxr-xr-x
teacher_val_report.php	10.59 KB	-rwxr-xr-x
timetabledegreewiserpt.php	6.73 KB	-rwxrwxrwx
topsheet.php	8.59 KB	-rwxr-xr-x
verifystud.php	8.38 KB	-rwxr-xr-x
viewexamcentrenew.php	20.7 KB	-rw-rw-r--
xl_AckAppReport.php	10.02 KB	-rw-rw-r--

Code Editor : viewexamcentrenew.php

<?php

if($univcode == '051')
  {
    $query="select ifnull(fdeggrp,'') as fdeggrp,ifnull(fdescpn,'') as fdescpn,
    ifnull(fyear,'') as fyear,ifnull(fexamtype,'') as fexamtype
    from notif_deggrp
    where ifnull(fdeleted,'') <> 'T'";
  }elseif ($univcode == '021'){
    $query = "select distinct ifnull(d.fdeggrp,'') as fdeggrp,ifnull(d.fdescpn,'') as fdescpn,
    ifnull(d.fyear,'') as fyear,ifnull(d.fexamtype,'') as fexamtype
    from deggrp d left join degree dg on d.fdeggrp = dg.fdeggrp
    left join student s on dg.fdegree = s.fdegree 
    where ifnull(d.fdeleted,'') <> 'T' $cond";
  }
  else
  {
    $query="select ifnull(fdeggrp,'') as fdeggrp,ifnull(fdescpn,'') as fdescpn,
    ifnull(fyear,'') as fyear,ifnull(fexamtype,'') as fexamtype
    from deggrp
    where ifnull(fdeleted,'') <> 'T'";
  }
  $result = $aobj_context->pobj_db->GetAll($query);

if($result){
      
    echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success");
  }
  else{
    $arr['msg']="Failed to Load";
    echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
  }
}

function loaddeggrpnotif($aobj_context){
  $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
  $univcode = $aobj_context->mobj_data['univcode'];

if($univcode == '051')
  {
    $query="select ifnull(fdeggrp,'') as fdeggrp,
    concat(ifnull(fdescpn,''),' - ',fexamdate) as fdescpn,
    ifnull(fyear,'') as fyear,ifnull(fexamtype,'') as fexamtype
    from notif_deggrp
    where ifnull(fdeleted,'') <> 'T'";
  }else{
    $query="select ifnull(fdeggrp,'') as fdeggrp,
    concat(ifnull(fdescpn,''),' - ',fexamdate) as fdescpn,
    ifnull(fyear,'') as fyear,ifnull(fexamtype,'') as fexamtype
    from tdvs_deggrp
    where ifnull(fdeleted,'') <> 'T'";
  }
  $result = $aobj_context->pobj_db->GetAll($query);

function loadmastersdeg($aobj_context){
  $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
  $univcode = $aobj_context->mobj_data['univcode'];
  $deggrp = $aobj_context->mobj_data['deggrp'];

if($deggrp === "All"){
    $deggrpCond = "ifnull(fdeggrp, '') <> ''";
  }else{
    $deggrpCond = "fdeggrp = '{$deggrp}'";
  }

$query="select ifnull(fdegree,'') as fdegree,ifnull(fdescpn,'') as fdescpn
   from degree 
   where {$deggrpCond}
   group by fdegree";

$result = $aobj_context->pobj_db->GetAll($query);
  if($result){
      
    echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success");
  }
  else{
    $arr['msg']="Failed to Load";
    echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
  }
}

function loadsubrptsem($aobj_context){
  $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
  $univcode = $aobj_context->mobj_data['univcode'];
  $degree = $aobj_context->mobj_data['degree'];

foreach($degree as $key => $val){
      $deg .= "'".$val."',";
  }
  $degarr = substr_replace($deg ,"",-1);

if($degarr == "'All'" || $degarr == ""){
      $cnd = "";
    }else{
      $cnd = "and fdegree in ($degarr)";
    }

$query="select ifnull(fexamno,'') as fexamno,ifnull(fexamname,'') as fexamname
   from degree
   where ifnull(FDELETED,'') <> 'T' and  ifnull(fexamname,'') <> '' $cnd
   group by fexamno";

function loadallexamcentre($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data['univcode'];
    $deggrp = $aobj_context->mobj_data['deggrp'];
    $req = $aobj_context->req_body;

$data = $req['data'];
    $date = $data['date'];
    $subject = $data['subject'];
    $degree = $data['degree'];
    $centre = $data['centre'];
    $session = $data['session'];

if($deggrp == "All"){
      $deggcond = "dg.fdeggrp <> ''";
    }else{
      $deggcond = "dg.fdeggrp = '{$deggrp}'";
    }

foreach($date as $key => $val){
        $dat .= "date_format(STR_TO_DATE("."'".$val."'".", '%d/%m/%Y'),'%Y-%m-%d')".",";
    }
    $datearr = substr_replace($dat ,"",-1);

foreach($subject as $key => $val){
        $sub .= "'".$val."',";
    }
    $subarr = substr_replace($sub ,"",-1);

foreach($degree as $key => $val){
        $deg .= "'".$val."',";
    }
    $degarr = substr_replace($deg ,"",-1);

foreach($centre as $key => $val){
        $cen .= "'".$val."',";
    }
    $centrearr = substr_replace($cen ,"",-1);

foreach($session as $key => $val){
        $sess .= "'".$val."',";
    }
    $sessionarr = substr_replace($sess ,"",-1);

if(strpos($datearr,"All") != "" || $datearr == ""){
      $cnd1 = "";
  }else{
    $cnd1 = "and s.fdoe in ($datearr)";
  }

if($subarr == "'All'" || $subarr == ""){
    $cnd2 = "";
  }else{
    $cnd2 = "and s.fsubcode in ($subarr)";
  }

if($degarr == "'All'" || $degarr == ""){
    $cnd3 = "";
  }else{
    $cnd3 = "and d.fdegree in ($degarr)";
  }

if($centrearr == "'All'" || $centrearr == ""){
    $cnd4 = "";
  }else{
    $cnd4 = "and cs.FCNTRCODE in ($centrearr)";
  }

if($sessionarr == "'All'" || $sessionarr == ""){
    $cnd5 = "";
  }else{
    $cnd5 = "and s.fsession in ($sessionarr)";
  }

$querydate = "select distinct ifnull(date_format(s.FDOE,'%d/%m/%Y'),'') as fdoe 
    from subject s
    inner join degree d on s.FDEGREE = d.fdegree and s.fexamno = d.fexamno
    inner join deggrp dg on d.fdeggrp = dg.fdeggrp
    inner join candsum cs on s.fdegree = cs.fdegree
    where $deggcond 
    and ifnull(s.fdoe,'0000-00-00') <> '0000-00-00' $cnd2 $cnd3 $cnd4 $cnd5";

$resdate = $aobj_context->pobj_db->GetAll($querydate);

$querysub = "select distinct ifnull(s.FSUBCODE,'') as fsubcode,ifnull(s.FSUBNAME,'') as fsubname
    from subject s 
    inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno
    inner join deggrp dg on d.fdeggrp = dg.fdeggrp
    inner join candsum cs on s.fdegree = cs.fdegree
    where $deggcond $cnd1 $cnd3 $cnd4 $cnd5";

$ressub = $aobj_context->pobj_db->GetAll($querysub);

$querydegree = "select distinct ifnull(d.FDEGREE,'') as fdegree,ifnull(d.FDESCPN,'') as fdescpn 
    from degree d 
    inner join deggrp dg on d.fdeggrp = dg.fdeggrp
    inner join subject s on s.FDEGREE = d.fdegree and s.fexamno = d.fexamno
    inner join candsum cs on s.fdegree = cs.fdegree
    where $deggcond $cnd1 $cnd2 $cnd4 $cnd5";
// var_dump($querydegree);
// die();

$resdegree = $aobj_context->pobj_db->GetAll($querydegree);

$querycentre = "select distinct ifnull(cs.FCNTRCODE,'') as fcntrcode, 
   concat(cs.fcntrcode,' - ',cl.fcollname,', ',cl.ftown) as collanme
   from candsum cs inner join degree d on cs.fdegree = d.fdegree and d.fexamno = 'A'
      inner join deggrp dg on d.fdeggrp = dg.fdeggrp
      inner join subject s on cs.fdegree = s.fdegree
      inner join college cl on cs.fcntrcode = cl.fcollcode
   where $deggcond 
   and cs.FCNTRCODE <> '' and cs.FCNTRCODE <> '0' $cnd1 $cnd2 $cnd3 $cnd5";

$rescentre = $aobj_context->pobj_db->GetAll($querycentre);

$querysession = "select distinct ifnull(s.fsession,'') as fsession 
   from subject s 
   inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
   inner join deggrp dg on d.fdeggrp = dg.fdeggrp
   inner join candsum cs on s.fdegree = cs.fdegree
   where $deggcond and fsession <> '' $cnd1 $cnd2 $cnd3 $cnd4ß";

$ressession = $aobj_context->pobj_db->GetAll($querysession);
   
     $arr['date'] = $resdate;
     $arr['sub'] = $ressub;
     $arr['degree'] = $resdegree;
     $arr['centre'] = $rescentre;
     $arr['session'] = $ressession;

if($querydate){
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success");
    }
    else{
      $arr['msg']="Failed to Save";
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
    }
  }

function loadtableexamcentre($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data['univcode'];
    $req = $aobj_context->req_body;
    $deggrp = $aobj_context->mobj_data['deggrp'];
    $reportorder = $aobj_context->mobj_data['reportorder'];
    $data = $req['data'];
    $date = $data['date'];
    $subject = $data['subject'];
    $degree = $data['degree'];
    $centre = $data['centre'];
    $session = $data['session'];
    $frmdates = $data['frmdate'];
    $todates = $data['todate'];
    $qpfrm = $data['qpfrm'];
    $qpto = $data['qpto'];

if($frmdates !== "" && $todate !== ""){
      $frm = date_create($frmdates);
      $to = date_create($todates);
      $frmdate = date_format($frm,"Y-m-d");
      $todate = date_format($to,"Y-m-d");
    }
    
    if($deggrp == "All"){
      $deggcond = "dg.fdeggrp <> ''";
    }else{
      $deggcond = "dg.fdeggrp = '{$deggrp}'";
    }

foreach($date as $key => $val){
    if($val != 'All'){
      $dat .= "date_format(STR_TO_DATE("."'".$val."'".", '%d/%m/%Y'),'%Y-%m-%d')".",";
    }else{
      $all .= "All";
    }
  }
  if($all != 'All'){
    $datearr = substr_replace($dat ,"",-1);
  }else{
    $datearr = "";
  }

foreach($subject as $key => $val){
      $sub .= "'".$val."',";
  }
  $subarr = substr_replace($sub ,"",-1);

foreach($degree as $key => $val){
      $deg .= "'".$val."',";
  }
  $degarr = substr_replace($deg ,"",-1);

foreach($centre as $key => $val){
      $cen .= "'".$val."',";
  }
  $centrearr = substr_replace($cen ,"",-1);

foreach($session as $key => $val){
      $sess .= "'".$val."',";
  }
  $sessionarr = substr_replace($sess ,"",-1);
  
  if(strpos($datearr,"All") != "" || $datearr == ""){
    if($frmdate != "" && $todate != ""){
      $cnd1 = "and s.fdoe between '{$frmdate}' and '{$todate}'";
    }else{
      $cond1 = "";
    }
  }else{
    $cnd1 = "and s.fdoe in ($datearr)";
  }

if($subarr == "'All'" || $subarr == ""){
    $cnd2 = "";
  }else{
    $cnd2 = "and s.fsubcode in ($subarr)";
  }

if($degarr == "'All'" || $degarr == ""){
    $cnd3 = "";
  }else{
    $cnd3 = "and d.fdegree in ($degarr)";
  }

if($centrearr == "'All'" || $centrearr == ""){
    $cnd4 = "";
  }else{
    $cnd4 = "and cs.FCNTRCODE in ($centrearr)";
  }

if($sessionarr == "'All'" || $sessionarr == ""){
    $cnd5 = "";
  }else{
    $cnd5 = "and s.fsession in ($sessionarr)";
  }

if($reportorder == "qpwisedatewisecentrewise"){
    $query="select distinct ifnull(s.fqpcode,'') as fqpcode,ifnull(s.fsubname,'') as fsubname,
    ifnull(cs.FCNTRCODE,'') as fcntrcode,ifnull(s.fsession,'') as fsession,
    r.FDESCPN,
    date_format(ifnull(s.fdoe,''),'%d/%m/%Y') as fdoe,
    concat(ifnull(cl.FCOLLNAME,''),', ',cl.ftown) as fcollname,
    count(cd.fregno) as cnt
    from canddet cd
    inner join subject s on cd.fdegree = s.fdegree and cd.fexamno = s.fexamno 
    and cd.fsubcode = s.fsubcode
    inner join candsum cs on cs.fdegree = cd.fdegree 
    and cd.fcollcode = cs.fcollcode
    and cd.fregno = cs.fregno
    inner join college cl on cl.FCOLLCODE = cs.FCNTRCODE
    inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
    inner join deggrp dg on d.fdeggrp = dg.fdeggrp
    inner join reason r on s.fsession = r.FREASONCD
    where $deggcond $cnd1 $cnd2 $cnd3 $cnd4 $cnd5
    and cd.fpresent = 'P'
    and ifnull(cs.frecptdate,'') <> ''
    and s.fqpcode between '{$qpfrm}' and '{$qpto}' 
    group by s.fqpcode,cs.fcntrcode,s.fdoe,s.fsession
    order by s.fdoe,s.fsession,cs.FCNTRCODE";

}else{
    $query = "select distinct ifnull(cs.FCNTRCODE,'') as fcntrcode,
    concat(ifnull(cl.FCOLLNAME,''),', ',cl.ftown) as fcollname,
    date_format(ifnull(s.fdoe,''),'%d/%m/%Y') as fdoe,
    sum(if(INSTR(s.fsession, 'M') >0,1,0)) as m_cnt,
    count(distinct if(INSTR(s.fsession, 'M') >0,ifnull(cd.fhallno,''),NULL)) as m_hall,
    sum(if(INSTR(s.fsession, 'N') >0,1,0)) as a_cnt,
    count(distinct if(INSTR(s.fsession, 'N') >0,ifnull(cd.fhallno,''),NULL)) as a_hall
    from canddet cd
    inner join subject s on cd.fdegree = s.fdegree and cd.fexamno = s.fexamno 
    and cd.fsubcode = s.fsubcode
    inner join candsum cs on cs.fdegree = cd.fdegree 
    and cd.fcollcode = cs.fcollcode
    and cd.fregno = cs.fregno
    inner join college cl on cl.FCOLLCODE = cs.FCNTRCODE
    inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
    inner join deggrp dg on d.fdeggrp = dg.fdeggrp
    inner join reason r on s.fsession = r.FREASONCD
    where $deggcond $cnd1 $cnd2 $cnd3 $cnd4 $cnd5
    and cd.fpresent = 'P'
    and ifnull(cs.frecptdate,'') <> ''
    and s.fqpcode between '{$qpfrm}' and '{$qpto}' 
    group by cs.fcntrcode,s.fdoe
    order by s.fdoe,s.fsession,cs.FCNTRCODE";

}

$result = $aobj_context->pobj_db->GetAll($query);   
    
  if($result){
      
    echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success");
  }
  else{
    $arr['msg']="No Data Found";
    echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
  }
  }

if($fstatus == 'ALL'){
      $cond2 = "";
    }elseif($fstatus == 'Pending'){
      $cond2 = "and ifnull(fstatus,'') <> 'T'";
    }elseif($fstatus == 'Verified'){
      $cond2 = "and ifnull(fstatus,'') = 'T'";
    }

$query="select fnotifname,fnotifdate,ifnull(fstatus,'F') as action,ifnull(fdeleted,'F') as fdeleted,
    if(ifnull(fstatus,'') = 'T','Approved','Draft') as statu,fnotifid,ifnull(fdeggrp,'') as fdeggrp
    from notifsum where ifnull(fdeleted,'F') <> 'T' $cond $cond2
    order by fnotifdate desc";
    // var_dump($query);die();
    // "select fnotifname,fnotifdate,ifnull(fstatus,'F') as action,
    // if(ifnull(fstatus,'') = 'T','Verification','Pending') as statu,fnotifid
    // from notifsum where $cond $cond2";
    
    $result = $aobj_context->pobj_db->GetAll($query);
    if($result){
      echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success");
    }
    else{
      $arr['msg']="Failed to Load";
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
    }
  }

function saveVerifyNotifi($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data['univcode'];
    $userid = $aobj_context->mobj_data['userid'];
    $usertype = $aobj_context->mobj_data['usertype'];
    $findata = json_decode($aobj_context->mobj_data['findata'],true);
    $date = date("Y-m-d h:i:sa");
    $datatru = true;
    foreach($findata as $val){
      
      if($val['statu'] == 'Approved')
      {
        $query = "select count(distinct cs.fregno) as cnt 
        from notifdet n 
        inner join candsum cs on n.fdegree = cs.fdegree
        and n.fyear = cs.fyear and n.fexamtype = cs.fexamtype
        inner join canddet cd on cs.fregno = cd.fregno 
        and cd.fyear = cs.fyear and cd.fexamtype = cs.fexamtype
        and cd.fexamno = n.fexamno
        where fnotifid = '{$val['fnotifid']}'";
        $res = $aobj_context->pobj_db->GetRow($query);
        
        if($res['cnt'] <=0)
        {
          $datatru = false;

$query="update notifsum set fdataready = 'N'
          where fnotifid = '{$val['fnotifid']}'";
    
          $result = $aobj_context->pobj_db->Execute($query);
          
        }

}

// if($usertype == '100' || $usertype == '200')
    // {
    //   $datatru = true;
    // }

if($datatru)
    {

}else
    {

// $arr['msg']="Examination data is not available for approval.";
      // echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
      // return;

}

foreach($findata as $val){

$query="update notifsum set fstatus = '{$val['action']}',fverifdate='{$date}',
      fverifuser = '{$userid}',fdeleted = '{$val['fdeleted']}'
      where fnotifid = '{$val['fnotifid']}'";

$result = $aobj_context->pobj_db->Execute($query);
      
      $query="select distinct fdeggrp,fyear,fexamtype 
      from notifdet where fnotifid = '{$val['fnotifid']}'";
      $res = $aobj_context->pobj_db->GetRow($query);
      
      $dgp = $res['fdeggrp'];
      $year = $res['fyear'];
      $examtype = $res['fexamtype'];
      $notifid = $val['fnotifid'];

if($val['statu'] == 'Approved')
      {

$query= "select max(fenddate) as fenddate, min(fstartdate) as fstartdate 
        from notifdet where fnotifid = '{$val['fnotifid']}'
        and fheadid in('5','6','7')";
        $res9 = $aobj_context->pobj_db->GetRow($query);
        $fenddate = $res9['fenddate'];
        $fstartdate = $res9['fstartdate'];

$query = "UPDATE timetable SET 
        ffreeze = 'T', ffreezeuser = '{$user}', ffreezedate=NOW(),
        frelease = 'T'
        WHERE fdeggrp = '{$dgp}' AND fyear = '{$year}' 
        AND fexamtype = '{$examtype}' AND fqpcode in(
          select distinct fqpcode from subject where ifnull(fqpcode,'') <> '' and concat(fdegree,fexamno)in(select distinct concat(fdegree,fexamno) 
          from notifdet where fnotifid = '{$notifid}')
        )";
        $res=$aobj_context->pobj_db->Execute($query);

$query = "update subject s, timetable t, masdate m,
        (select distinct fqpcode from subject where ifnull(fqpcode,'') <> '' and concat(fdegree,fexamno)in(select distinct concat(fdegree,fexamno) 
          from notifdet where fnotifid = '{$notifid}')) r
        set s.fdoe = m.fdate,
        s.fsession = t.fsessiont
        where t.fdatecodet = m.fdatecode
        and t.fdeggrp  = m.fdeggrp and t.fyear = m.fyear 
        and t.fexamtype = m.fexamtype
        and t.fqpcode = s.fqpcode
        and s.fdegree in (select distinct fdegree from degree where fdeggrp = '{$dgp}')
        and m.fdeggrp = '{$dgp}' and m.fyear = '{$year}' 
        and ifnull(t.frelease,'') = 'T'
        and s.fqpcode =r.fqpcode  
        and m.fexamtype = '{$examtype}'";

$res1=$aobj_context->pobj_db->Execute($query);

$upd = "update collexam cs, notifdet d set cs.fappfrom = '{$fstartdate}', cs.fappto = '{$fenddate}'
        where cs.fdegree = d.fdegree and cs.fexamno = d.fexamno
        and d.fnotifid = '{$val['fnotifid']}'";
        $res10=$aobj_context->pobj_db->Execute($upd);

$upd = "update collexam cs, notifdet d set cs.fiafrom = d.fstartdate  , cs.fiato = d.fenddate
        where cs.fdegree = d.fdegree and cs.fexamno = d.fexamno
        and d.fnotifid = '{$val['fnotifid']}'
        and d.fheadid = '9'";
        $res10=$aobj_context->pobj_db->Execute($upd);

$upd = "update collexam cs, notifdet d set cs.fattfrom = d.fstartdate, cs.fattto = d.fenddate
        where cs.fdegree = d.fdegree and cs.fexamno = d.fexamno
        and d.fnotifid = '{$val['fnotifid']}'
        and d.fheadid = '10'";
        $res11=$aobj_context->pobj_db->Execute($upd);

$upd = "update collexam cs, notifdet d set cs.fhtfrom = d.fstartdate, cs.fhtto = d.fenddate
        where cs.fdegree = d.fdegree and cs.fexamno = d.fexamno
        and d.fnotifid = '{$val['fnotifid']}'
        and d.fheadid = '11'";
        $res12=$aobj_context->pobj_db->Execute($upd);

$upd = "update collexam cs, notifdet d set cs.fprfrom = d.fstartdate, cs.fprto = d.fenddate
        where cs.fdegree = d.fdegree and cs.fexamno = d.fexamno
        and d.fnotifid = '{$val['fnotifid']}'
        and d.fheadid = '12'";
        $res13=$aobj_context->pobj_db->Execute($upd);

}else if($val['statu'] == 'Draft')
      {
        $query = "UPDATE timetable SET 
        ffreeze = 'F', ffreezeuser = '{$user}', ffreezedate=NOW(),
        frelease = 'F'
        WHERE fdeggrp = '{$dgp}' AND fyear = '{$year}' 
        AND fexamtype = '{$examtype}' AND fqpcode in(
          select distinct fqpcode from subject where ifnull(fqpcode,'') <> '' and concat(fdegree,fexamno)in(select distinct concat(fdegree,fexamno) 
          from notifdet where fnotifid = '{$notifid}')
        )";
        $res=$aobj_context->pobj_db->Execute($query);
      }
    }
    
    if($result){
      $arr['msg']="SuccessFully Updated";
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success");
    }
    else{
      $arr['msg']="Failed to Update";
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
    }
  }

${this.title}

Code Editor : viewexamcentrenew.php