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

<?php

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

//echo $college_code; 
    $degree_code = $aobj_context->mobj_data["degree_code"];
    $search_field = $aobj_context->mobj_data["search_field"];
    $exam_code = $aobj_context->mobj_data["exam_code"];

$RegNo_start = substr("00000000" . $aobj_context->mobj_data["streg"], -8);
    $RegNo_end = substr("ZZZZZZZZ" . $aobj_context->mobj_data["edreg"], -8);

$main_src_obj = (explode("/", $_SERVER["REQUEST_URI"]));
    $main_src = $main_src_obj[1];
    $pdf_writer_class = $aobj_context->main_src . "/maya-pdf/fpdf.php";
    $root_pdf_file_download = $aobj_context->main_src . "/Report_details/output/report_candidate_list.pdf";

include($pdf_writer_class);
    /*  if($active_field === 'T')
	{	 */
    $pdf = new FPDF('L'); //Landscape
    $pdf->WhichReport = 'ReportCandidateList';
    /* }
	else
	{
		$pdf= new FPDF(); //A4
		$pdf->WhichReport = 'ReportCandidateNonActList';
	} */
    $pdf->SetFont('Times', 'B', 16);
    $pdf->SetMargins(2, 12);
    $pdf->AliasNbPages();
    //$pdf->SetAutoPageBreak('on' , 10);
    //header	
    $page_header_university = "select FUNIVNAME,FTOWN, date_format(now(),'%d/%m/%Y') as date from control";
    $lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university);

$page_header_college = "select concat('[',FCOLLCODE,']  ',FCOLLNAME,', ',FTOWN) as college_name
							from college where FCOLLCODE='{$college_code}'";
    $lobj_page_header_college = $aobj_context->mobj_db->GetRow($page_header_college);

$page_header_degree = "select now() as now_date,concat('[',FDEGREE,'] - ', FDESCPN) as Degree_name, FADYEAR  
							from degree where FDEGREE = '{$degree_code}' ";
    $lobj_page_header_degree = $aobj_context->mobj_db->GetRow($page_header_degree);

$page_header_REGROLL = "select FREGROLL from control";
    $lobj_page_header_REGROLL = $aobj_context->mobj_db->GetRow($page_header_REGROLL);

$pdf->aobj_context = $aobj_context;
    $pdf->date_time = 'ReportRegList';
    $pdf->WhichReport = 'ReportRegList';
    $pdf->FUNIVNAME = $lobj_page_header_university['FUNIVNAME'] . ', ' . $lobj_page_header_university['FTOWN'];
    $pdf->FTOWN = '';
    $pdf->date_1 = $lobj_page_header_university['date'];
    $pdf->college_name = $lobj_page_header_college['college_name'];
    $pdf->Degree_name = $lobj_page_header_degree['Degree_name'];
    $pdf->exam_code = $exam_code;
    $pdf->FADYEAR = $lobj_page_header_degree['FADYEAR'];
    $pdf->date_time = $lobj_page_header_degree['now_date'];
    $pdf->REGROLL = $lobj_page_header_REGROLL['FREGROLL'];
    $pdf->RFROM = $RegNo_start;
    $pdf->RTO = $RegNo_end;
    $pdf->head_cnt = 0;;
    //end header

$pdf->AddPage();
    PrintFooter($pdf);
    $pdf->SetFont('Times', 'B', 9);
    // body
    $get_fee_paid_REC_DATE = "select FREGNO,
	if(date_format(FRECPTDATEA,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATEA,'%d/%m/%y')) as FdateA, FRECPTNOA,
	if(date_format(FRECPTDATEB,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATEB,'%d/%m/%y')) as FdateB, FRECPTNOB,
	if(date_format(FRECPTDATEC,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATEC,'%d/%m/%y')) as FdateC, FRECPTNOC,
	 if(date_format(FRECPTDATED,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATED,'%d/%m/%y'))as FdateD, FRECPTNOD,    
	if(date_format(FRECPTDATEE,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATEE,'%d/%m/%y')) as FdateE, FRECPTNOE, 
	if(date_format(FRECPTDATEF,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATEF,'%d/%m/%y')) as FdateF, FRECPTNOF, 
	if(date_format(FRECPTDATEG,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATEG,'%d/%m/%y')) as FdateG, FRECPTNOG,
	if(date_format(FRECPTDATEH,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATEH,'%d/%m/%y'))as FdateH, FRECPTNOH,
	if(date_format(FRECPTDATEI,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATEI,'%d/%m/%y')) as FdateI, FRECPTNOI,
	if(date_format(FRECPTDATEJ,'%d/%m/%y')='00/00/00','',date_format(FRECPTDATEJ,'%d/%m/%y'))as FdateJ, FRECPTNOJ    
	from regcandsum
	WHERE  fdegree='{$degree_code}'
	and FREGNO>='{$RegNo_start}' and FREGNO<='{$RegNo_end}' 
    and fexamno = '{$exam_code}'
	and  FCOLLCODE='{$college_code}' and frecptdate is not null";
    $lobj_get_fee_paid_REC_DATE = $aobj_context->mobj_db->GetAll($get_fee_paid_REC_DATE);

$rec_date_array = array();
    foreach ($lobj_get_fee_paid_REC_DATE as $key => $value) {
        $rec_date_array[$value['FREGNO']]['A']['Date'] = $value['FdateA'];
        $rec_date_array[$value['FREGNO']]['A']['Rec'] = $value['FRECPTNOA'];

$rec_date_array[$value['FREGNO']]['B']['Date'] = $value['FdateB'];
        $rec_date_array[$value['FREGNO']]['B']['Rec'] = $value['FRECPTNOB'];

$rec_date_array[$value['FREGNO']]['C']['Date'] = $value['FdateC'];
        $rec_date_array[$value['FREGNO']]['C']['Rec'] = $value['FRECPTNOC'];

$rec_date_array[$value['FREGNO']]['D']['Date'] = $value['FdateD'];
        $rec_date_array[$value['FREGNO']]['D']['Rec'] = $value['FRECPTNOD'];

$rec_date_array[$value['FREGNO']]['E']['Date'] = $value['FdateE'];
        $rec_date_array[$value['FREGNO']]['E']['Rec'] = $value['FRECPTNOE'];

$rec_date_array[$value['FREGNO']]['F']['Date'] = $value['FdateF'];
        $rec_date_array[$value['FREGNO']]['F']['Rec'] = $value['FRECPTNOF'];

$rec_date_array[$value['FREGNO']]['G']['Date'] = $value['FdateG'];
        $rec_date_array[$value['FREGNO']]['G']['Rec'] = $value['FRECPTNOG'];

$rec_date_array[$value['FREGNO']]['H']['Date'] = $value['FdateH'];
        $rec_date_array[$value['FREGNO']]['H']['Rec'] = $value['FRECPTNOH'];

$rec_date_array[$value['FREGNO']]['I']['Date'] = $value['FdateI'];
        $rec_date_array[$value['FREGNO']]['I']['Rec'] = $value['FRECPTNOI'];

$rec_date_array[$value['FREGNO']]['J']['Date'] = $value['FdateJ'];
        $rec_date_array[$value['FREGNO']]['J']['Rec'] = $value['FRECPTNOJ'];
    }
    $fee_cond = " ifnull(cs.ftotalfee,0) > 0 ";
    if ($all_data == "Yes")
        $fee_cond = "";

$get_candidate_data = "  select a.*,b.FEXAMNAME,b.Fee_ShortName,b.fee  ,a.fregfee as total_fee 
		from (SELECT s.FSLNO,s.FNAME,s.FFATNAME,s.FMOTNAME,
		if(date_format(s.FDOB,'%d/%m/%y')='00/00/00','',date_format(s.FDOB,'%d/%m/%y'))
              as FDOB,date_format(ifnull(cs.fpaymentdate,''),'%d/%m/%y') as frecptdate,
              ifnull(cs.fappno,'') as fappno,
              cs.fregfee,
              s.FSEX,s.FCASTE as FCASTE,cd.FDEGREE, cd.FEXAMNO,cd.FCOLLCODE, cd.FREGNO, cs.fregfee  AS FTOTALFEE,
		GROUP_CONCAT(distinct sub.FSUBCODE order by cd.FSUBCODE separator '|') as subjects 
		from regcanddet cd inner join student s on s.FREGNO=cd.FREGNO 
		and s.FDEGREE=cd.FDEGREE 
		and s.FCOLLCODE=cd.FCOLLCODE 
		INNER JOIN subject sub on sub.FDEGREE=cd.FDEGREE and sub.FEXAMNO=cd.FEXAMNO and sub.FSUBCODE=cd.FSUBCODE
		inner join regcandsum cs on 
		cs.FDEGREE=cd.FDEGREE  and cs.FCOLLCODE=cd.FCOLLCODE and
		cs.FREGNO=cd.FREGNO and ifnull(cs.fregfee,0) > 0
		WHERE   cd.fregno>='{$RegNo_start}' and cd.fregno<='{$RegNo_end}' 
		and cd.fdegree='{$degree_code}' and  cd.FCOLLCODE='{$college_code}'
        and  cd.fexamno = '{$exam_code}'
        and ifnull(cs.fpaymentdate,'') <> ''
		GROUP BY cd.FDEGREE,cd.FEXAMNO, 
		cd.FCOLLCODE,cd.FREGNO ORDER BY cd.FREGNO) a left join 
		(select sf.FDEGREE,sf.FEXAMNO,sf.FCOLLCODE,sf.FREGNO,deg.FEXAMNAME, 
		GROUP_CONCAT(mf.FSHORT order by mf.FFEECODE) as Fee_ShortName,
		GROUP_CONCAT(if(ROUND(sf.FAMOUNT,0)=0,'',ROUND(sf.FAMOUNT,0)) order by sf.FFEECODE separator '|') as fee,
		sum(FAMOUNT) as total_fee
		from masfee mf left join regstudfee sf on sf.FFEECODE=mf.FFEECODE inner join degree deg on 
		deg.FDEGREE=sf.FDEGREE and deg.FEXAMNO=sf.FEXAMNO
		where sf.fregno>='{$RegNo_start}' and sf.fregno<='{$RegNo_end}' and sf.fdegree='{$degree_code}' 
		and  sf.FCOLLCODE='{$college_code}'	
        and  sf.fexamno = '{$exam_code}'	
		group by FDEGREE,FEXAMNO,FCOLLCODE,FREGNO having sum(FAMOUNT) > 0) b on
		a.FDEGREE=b.FDEGREE and a.FEXAMNO=b.FEXAMNO and a.FCOLLCODE=b.FCOLLCODE and a.FREGNO=b.FREGNO 
		#where b.fexamname is not null	 
        order by a.FREGNO,FEXAMNO"; //FPRESENT='P'
    //echo $get_candidate_data; die();
    //var_dump($get_candidate_data);
    $lobj_get_candidate_data = $aobj_context->mobj_db->GetAll($get_candidate_data);
    // echo "<pre>".$get_candidate_data;die();
    $final_arr = array();
    $for_page_break = array();
    $k = 0;
    $full_fee_arr = array();
    $unique_fee_arr = array();
    $grand_total = 0;

//var_dump($pdf->Degree_name);die();

//$pdf->Cell(20,5,"Degree".$pdf->Degree_name,'1',1,'C');
    foreach ($lobj_get_candidate_data as  $sk => $sv) {
        $reg_no = $sv['FREGNO'];
        $fslno = $sv['FSLNO'];
        $frecptdate = $sv['frecptdate'];
        $fappno = $sv['fappno'];
        $fname = $sv['FNAME'];
        $fatname = $sv['FFATNAME'];
        $mname = $sv['FMOTNAME'];
        $dob = $sv['FDOB'];
        $fsex = $sv['FSEX'];
        $fcaste = $sv['FCASTE'];
        $fdegree = $sv['FDEGREE'];
        $fexam = $sv['FEXAMNO'];
        $total_fee = $sv['FTOTALFEE'];
        $subjects = $sv['subjects'];
        $exam_name = $sv['FEXAMNAME'];
        $fee_shortname = $sv['Fee_ShortName'];
        $fee = $sv['fee'];
        $explode_fee_short_name_arr = explode(",", $fee_shortname);
        $explode_fee_arr = explode("|", $fee);

foreach ($explode_fee_short_name_arr as $ffk => $ffv) {
            $full_fee_arr[$reg_no][$ffv] += $explode_fee_arr[$ffk];
            $grand_total += $explode_fee_arr[$ffk];
            if (!in_array($ffv, $unique_fee_arr))
                array_push($unique_fee_arr, $ffv);
        }

//$total_fee=$sv[total_fee];
        $student_exams_arr[$reg_no][$k] = $fexam;
        $k++;
        $final_arr[$reg_no]['reg_no'] = $reg_no;
        $final_arr[$reg_no]['fslno'] = $fslno;
        $final_arr[$reg_no]['fname'] = $fname;
        $final_arr[$reg_no]['fatname'] = $fatname;
        $final_arr[$reg_no]['mname'] = $mname;
        $final_arr[$reg_no]['dob'] = $dob;
        $final_arr[$reg_no]['fsex'] = $fsex;
        $final_arr[$reg_no]['fcaste'] = $fcaste;
        $final_arr[$reg_no]['fee_shortname'] = $fee_shortname;
        $final_arr[$reg_no]['fee'] = $fee;
        $final_arr[$reg_no]['total_fee'] = $total_fee;
        $final_arr[$reg_no]['fexam'][$fexam]['exam_name'] = $exam_name;
        $final_arr[$reg_no]['fexam'][$fexam]['fee'] = $fee;
        $final_arr[$reg_no]['fexam'][$fexam]['subjects'] = $subjects;
        $final_arr[$reg_no]['exam_name'] = $exam_name;
    }

foreach ($student_exams_arr as $skk => $svv) {
        $for_page_break[$skk] = count($svv) + 2;
    }

$line_counter = 0;
    $arr_w = array(12, 25, 110, 35, 63, 10, 20, 45, 12, 18);
    $arr_h = array(5, 6);
    $sl_no = 1;
    $grand_tot_arr = array();
    $page_tot_arr = array();
    $footer_student_fee_arr = array();

foreach ($final_arr as $stdk => $stdv) {
        $reg_no = $stdv['reg_no'];
        $fslno = $stdv['fslno'];
        $fname = $stdv['fname'];
        $fatname = $stdv['fatname'];
        $mname = $stdv['mname'];
        $dob = $stdv['dob'];
        $fsex = $stdv['fsex'];
        $fcaste = $stdv['fcaste'];
        $total_fee = $stdv['total_fee'];

if (($line_counter + ($for_page_break[$reg_no])) >= 20) {
            //echo $line_counter+($for_page_break[$reg_no]); die();
            $pdf->ln(1);
            $sum_arr = array();
            foreach ($footer_student_fee_arr as $sk => $sv) {
                foreach ($unique_fee_arr as $ak => $av) {
                    $sum_arr[$av] += $full_fee_arr[$sv][$av];
                }
            }

foreach ($sum_arr as $ak => $av) {
                $pdf->Cell(20, 5, $ak, '1', 0, 'C');
            }
            $pdf->Cell(20, 5, "Total", '1', 1, 'C');
            $tot = 0;
            foreach ($sum_arr as $ak => $av) {
                $pdf->Cell(20, 5, $av, '1', 0, 'C');
                $tot += $av;
            }
            $pdf->Cell(20, 5, $tot, '1', 1, 'C');
            $footer_student_fee_arr = array();

$pdf->AddPage();
            PrintFooter($pdf);
            $line_counter = 0;
        }

//$pdf->Ln(1);	
        $line_counter += 1;
        $pdf->SetFont('Times', 'B', 9);
        $pdf->Cell($arr_w[0], $arr_h[1], $sl_no, 'LRT', 0, 'C');
        $pdf->Cell($arr_w[1], $arr_h[1], $reg_no, 'LRT', 0, 'C');
        array_push($footer_student_fee_arr, $reg_no);
        $pdf->Cell($arr_w[2], $arr_h[1], $fname, '1', 0, 'L');
        $pdf->SetFont('Times', '', 9);
        $pdf->Cell($arr_w[4] - 3, $arr_h[1], 'Fat.:   ' . $fatname, '1', 0, 'L');
        $pdf->Cell($arr_w[4] + 12 + 5, $arr_h[1], 'Mot.:   ' . $mname, '1', 1, 'L');
        $pdf->Cell($arr_w[0], $arr_h[1], '', 'LR', 0, 'C');
        $pdf->Cell($arr_w[1], $arr_h[1], '', 'LR', 0, 'L');
        $pdf->Cell($arr_w[3], $arr_h[1], 'DOB.:   ' . $dob, '1', 0, 'L');
        $pdf->Cell($arr_w[6], $arr_h[1], 'Gen.:   ' . $fsex, '1', 0, 'L');
        $pdf->Cell($arr_w[6], $arr_h[1], 'Grp.:   ' . $fcaste, '1', 0, 'L');
        $pdf->SetFont('Times', 'B', 9);
        $pdf->Cell($arr_w[7] - $arr_w[5], $arr_h[1], 'Total Fee:  ' . $total_fee, '1', 0, 'C');
        $pdf->SetFont('Times', '', 9);
        //Fee Short Name Details

$fee_shortname = $stdv['fee_shortname'];
        $free_name_array = explode(",", $fee_shortname);
        //echo "<pre>";print_r($free_name_array);die();
        /* if(empty($free_name_array))
			{
			$free_name_array[0]="";
			$free_name_array[1]="";
			$free_name_array[2]="";
			}
			 */

for ($m = 0; $m < count($free_name_array); $m++) {
            if (($m) <= 7) {

$pdf->Cell($arr_w[8], $arr_h[1], $free_name_array[$m], '1', 0, 'C');
            } else {
                //					$pdf->Cell($arr_w[8],$arr_h[1],'Others','1',0,'C');							
                break;
            }
        }
        $diff = 8 - count($free_name_array);
        if ($diff > 0) //writing empty if it comes less than 8
        {
            for ($d = 0; $d < $diff; $d++)
                $pdf->Cell($arr_w[8], $arr_h[1], "", '1', 0, 'C');
        }

$pdf->Cell($arr_w[8], $arr_h[1], 'Total', '1', 0, 'C');
        $pdf->SetFont('Times', '', 9);
        $pdf->Cell($arr_w[8], $arr_h[1], 'Date', '1', 0, 'C');
        $pdf->Cell($arr_w[6], $arr_h[1], 'Rec. No.', '1', 1, 'C');
        $line_counter++;
        //Exam Fee Details
        //echo "<pre>";

$fexam_arr = $stdv['fexam']; //print_r($fexam_arr);die();

foreach ($fexam_arr as $ek => $ev) {
            $line_counter++;
            $exam_no = $ek;
            $exam_name = $ev['exam_name'];
            $pdf->Cell(($arr_w[0] + $arr_w[1]), $arr_h[1], $exam_name, '1', 0, 'L');

$subjects = $ev['subjects'];
            $subject_array = explode("|", $subjects);
            $remeber_cell = 0;
            for ($m = 0; $m < count($subject_array); $m++) {
                $pdf->Cell($arr_w[5], $arr_h[1], $subject_array[$m], '1', 0, 'C');
                $remeber_cell++;
            }
            for ($j = $remeber_cell; $j < 11; $j++) {
                $pdf->Cell($arr_w[5], $arr_h[1], '', '1', 0, 'C');
            }

$fee = $ev['fee'];
            $free_array = explode("|", $fee);
            $other_sum = 0;
            $other_flag = 0;
            $total_exam_fee = 0;
            for ($m = 0; $m < count($free_array); $m++) {
                if (($m) < 7) {
                    $pdf->Cell($arr_w[8], $arr_h[1], $free_array[$m], '1', 0, 'C');
                    $grand_tot_arr[$free_name_array[$m]] += $free_array[$m];
                    $page_tot_arr[$free_name_array[$m]] += $free_array[$m];
                    $total_exam_fee += $free_array[$m];
                    $other_flag = 0;
                    $other_sum = 0;
                } else {
                    $other_sum += $free_array[$m];
                    $total_exam_fee += $free_array[$m];
                    $other_flag = 1;
                }
            }
            if ($other_flag)
                $pdf->Cell($arr_w[8], $arr_h[1], $other_sum, '1', 0, 'C');
            $diff = 8 - count($free_name_array);

if ($diff > 0) //writing empty if it comes less than 8
            {
                for ($d = 0; $d < $diff; $d++)
                    $pdf->Cell($arr_w[8], $arr_h[1], "", '1', 0, 'C');
            }

$pdf->Cell($arr_w[8], $arr_h[1], $total_fee, '1', 0, 'C');

$pdf->Cell($arr_w[8], $arr_h[1], $frecptdate, '1', 0, 'C');
            $pdf->Cell($arr_w[6], $arr_h[1], $fappno, '1', 1, 'C');
            //$pdf->Cell($arr_w[8],$arr_h[1],$rec_date_array[$reg_no][$exam_no]['Date'],'1',0,'C');
            //$pdf->Cell($arr_w[6],$arr_h[1],$rec_date_array[$reg_no][$exam_no]['Rec'] ,'1',1,'C');
        }

$sl_no++;
        $sum_arr = array();
        foreach ($footer_student_fee_arr as $sk => $sv) {
            foreach ($unique_fee_arr as $ak => $av) {
                $sum_arr[$av] += $full_fee_arr[$sv][$av];
            }
        }
    }
    $pdf->ln(2);;
    foreach ($sum_arr as $ak => $av) {
        $pdf->Cell(20, 5, $ak, '1', 0, 'C');
    }
    $pdf->Cell(20, 5, "Total", '1', 1, 'C');
    $tot = 0;
    foreach ($sum_arr as $ak => $av) {
        $pdf->Cell(20, 5, $av, '1', 0, 'C');
        $tot += $av;
    }
    $pdf->Cell(20, 5, $tot, '1', 1, 'C');

/* 
		$pdf->Cell(35,5,"Page Wise Head Count",'0',1,'L');	 	
		foreach($page_tot_arr as $ak=>$av)
		{
		$pdf->Cell(15,5,$ak,'1',0,'C');	 	
		}
		$pdf->Cell(2,5,"",'0',1,'L');	 
		foreach($page_tot_arr as $ak=>$av)
		{
		$pdf->Cell(15,5,$av,'1',0,'C');	 	
		}
		$pdf->ln(2);;
		 $sum_arr=array();
			foreach($footer_student_fee_arr as $sk=>$sv)
			{
			foreach($unique_fee_arr as $ak=>$av)
					{
					 $sum_arr[$av]+=$full_fee_arr[$sv][$av];
					}
			} */
    $pdf->ln(5);
    $pdf->SetFont('Times', 'B', 9);
    $pdf->Cell(35, 5, "Grand Total", '0', 1, 'L');
    $s = 0;
    foreach ($grand_tot_arr as $ak => $av) {
        $pdf->Cell(15, 5, $ak, '1', 0, 'C');
    }
    $pdf->Cell(15, 5, "Total", '1', 1, 'C');
    foreach ($grand_tot_arr as $ak => $av) {
        $pdf->Cell(15, 5, $av, '1', 0, 'C');
        $s += $av;
    }
    $pdf->Cell(15, 5, $s, '1', 1, 'C');

$pdf->ln(5);;
    $pdf->SetFont('Times', 'B', 12);
    $pdf->Cell(210, 5, "Grand Total Rs {$grand_total}/", '0', 1, 'L');

/* 	$check_same_reg_no_for_pb = $lobj_get_candidate_data[0]['FREGNO'];
	$for_page_break = array();
	$page_break_counter=2;
	foreach($lobj_get_candidate_data as $key => $value)
	{
		if($check_same_reg_no_for_pb ==$value['FREGNO'])		
		{
			$page_break_counter++;
		}
		else 
		{
			$page_break_counter=3;
			$check_same_reg_no_for_pb=$value['FREGNO'];
		}
		$for_page_break[$value['FREGNO']]=$page_break_counter;
		
	}

$line_counter=0;
	$check_same_reg_no = $lobj_get_candidate_data[0]['FREGNO'];
	$check_same_sl_no = $lobj_get_candidate_data[0]['FSLNO'];
	$first_time_printing = 1;
	$arr_w = array(12,25,111,35,67,10,20,45,15,18);
	$arr_h = array(5,6);
	$page_temp_flag=0;

foreach($lobj_get_candidate_data as $key => $value)
	{	
	 if(($line_counter+($for_page_break[$value['FREGNO']])) >= 23 && $check_same_reg_no !=$value['FREGNO'])
	  {
		$pdf->AddPage();		
		$line_counter=0;
		$page_temp_flag=1;
	  }	   	
	  else
	  {
		$page_temp_flag=1;
	  } */
    /* if($page_temp_flag)
	  {
		  if(($first_time_printing) || $check_same_reg_no !=$value['FREGNO'] && $check_same_sl_no != $value['FSLNO'])		
			{
				$pdf->Ln(2);
				$line_counter += 2;
				$pdf->SetFont('Times','B',9);	
					$pdf->Cell($arr_w[0],$arr_h[1],$value['FSLNO'],'LRT',0,'C');
					$pdf->Cell($arr_w[1],$arr_h[1],$value['FREGNO'],'LRT',0,'C');		
					$pdf->Cell($arr_w[2],$arr_h[1],$value['FNAME'],'1',0,'L');		
				$pdf->SetFont('Times','',9);		
					$pdf->Cell($arr_w[4],$arr_h[1],'Fat.:   '.$value['FFATNAME'],'1',0,'L');		
					$pdf->Cell($arr_w[4],$arr_h[1],'Mot.:   '.$value['FMOTNAME'],'1',1,'L');	
					
					$pdf->Cell($arr_w[0],$arr_h[1],'','LR',0,'C');
					$pdf->Cell($arr_w[1],$arr_h[1],'','LR',0,'L');		
					$pdf->Cell($arr_w[3],$arr_h[1],'DOB.:   '.$value['FDOB'],'1',0,'L');
					$pdf->Cell($arr_w[6],$arr_h[1],'Gen.:   '.$value['FSEX'],'1',0,'L');		
					$pdf->Cell($arr_w[6],$arr_h[1],'Grp.:   '.$value['FCASTE'],'1',0,'L');
				$pdf->SetFont('Times','B',9);
					$pdf->Cell($arr_w[7],$arr_h[1],'Total Fee:  '.$value['FTOTALFEE'],'1',0,'C');
				$pdf->SetFont('Times','',9);
// stars FEE NAMEs			
				$free_name_array = explode(",",$value['Fee_ShortName']);	
				for($m=0; $m<count($free_name_array); $m++)
				{				
					if(($m) <= 3)
					$pdf->Cell($arr_w[8],$arr_h[1],$free_name_array[$m],'1',0,'C');			
					else
					{
						$pdf->Cell($arr_w[8],$arr_h[1],'Others','1',0,'C');							
						break;
					}	
				}
				$pdf->Cell($arr_w[8],$arr_h[1],'Exam Fee','1',0,'C');	
$pdf->SetFont('Times','',9);			
				$pdf->Cell($arr_w[8],$arr_h[1],'Date','1',0,'C');
				$pdf->Cell($arr_w[6],$arr_h[1],'Rec. No.','1',1,'C');
// End FEE NAMEs			
				$first_time_printing=0;	
				$check_same_reg_no=$value['FREGNO'];
				$check_same_sl_no = $value['FSLNO'];	
			}
//subjects		
			$line_counter++;
				$pdf->Cell(($arr_w[0]+$arr_w[1]),$arr_h[1],$value['FEXAMNAME'],'1',0,'L');				
				$subject_array = explode("|",$value['subjects']);	
			
				$remeber_cell=0;
				for($m=0;$m<count($subject_array);$m++)
				{			
					$pdf->Cell($arr_w[5],$arr_h[1],$subject_array[$m],'1',0,'C');
			
					$remeber_cell++;
				}
				 
				for($j=$remeber_cell; $j<12; $j++)
				{
					 $pdf->Cell($arr_w[5],$arr_h[1],'','1',0,'C');
				}		
//end subjects
//fee stratrs here
				$free_array = explode("|",$value['fee']);
			
				$other_sum=0;
				$other_flag=0;	
				for($m=0; $m<count($free_array); $m++)
				{		
					if(($m) <= 3)
					{
						$pdf->Cell($arr_w[8],$arr_h[1],$free_array[$m],'1',0,'C');	
						$other_flag=0;	
						$other_sum=0;
					}	
					else
					{
						$other_sum += $free_array[$m];			
						$other_flag=1;
					}				
				}
			
				if($other_flag)
					$pdf->Cell($arr_w[8],$arr_h[1],$other_sum,'1',0,'C');
				
				$pdf->Cell($arr_w[8],$arr_h[1],$value['total_fee'],'1',0,'C');				
				
				$pdf->Cell($arr_w[8],$arr_h[1],$rec_date_array[$value['FREGNO']][$value['FEXAMNO']]['Date'],'1',0,'C');
				$pdf->Cell($arr_w[6],$arr_h[1],$rec_date_array[$value['FREGNO']][$value['FEXAMNO']]['Rec'] ,'1',1,'C');
				$page_temp_flag=0;
			} */
    $pdf->Ln(20);
    $pdf->Cell(20, 4, "Date :", '0', 0, 'L');
    $pdf->Cell(250, 4, "Signature of the principal(With seal)", '0', 1, 'R');
    PrintFooter($pdf);

$pdf->WhichReport = 'ReportRegListSummary';
    $pdf->AddPage();
    $pdf->SetMargins(2, 12);

$sql = "select fdegree, fcollcode, FCATEGORY, max(fcount) as fcount, fmale, ffemale,
			group_concat(heads order by heads) as headfee  from (select concat(masfee.ffeecode, '->',sum(famount)) as heads,
			regcandsum.fdegree,regcandsum.fcollcode, student.fcaste as FCATEGORY,count(distinct student.fregno) as fcount,
			sum(if(student.fsex='M',1,0)) as fmale,
			sum(if(student.fsex='F',1,0)) as ffemale
			from  regcandsum, regstudfee,student,masfee
			where student.fdegree=regcandsum.fdegree
			and student.fregno=regcandsum.fregno 
			and regstudfee.fdegree=regcandsum.fdegree
            and regstudfee.ffeecode = masfee.ffeecode
			and regstudfee.fregno=regcandsum.fregno and regcandsum.fdegree ='{$degree_code}' and regcandsum.fcollcode='{$college_code}'
			and regcandsum.fregno>='{$RegNo_start}' and regcandsum.fregno<='{$RegNo_end}' 
			and regstudfee.fcollcode=regcandsum.fcollcode
            and ifnull(regcandsum.fpaymentdate,'') <> ''
            and  regstudfee.fexamno = '{$exam_code}'
			group by regcandsum.fdegree,regcandsum.fcollcode,student.fcaste, masfee.ffeecode) x
			group by fdegree, fcollcode, FCATEGORY";
    //var_dump($sql);
    $rst = $aobj_context->mobj_db->GetAll($sql);
    //matching the feehead codes
    $sql = "SELECT DISTINCT fshortname, s.ffeecode as fheadcode FROM regstudfee s 
            inner join masfee m on s.ffeecode = m.ffeecode WHERE fdegree='{$degree_code}'
            and fcollcode = '{$college_code}'
            order by m.ffeecode";
    //var_dump($sql);
    $feeheads = $aobj_context->mobj_db->GetAll($sql);
    $slno = 1;
    $totmale = 0;
    $totfemale = 0;
    $totstud = 0;
    $totamount = 0;

//$pdf->Cell(2, 6, '', '0', 0, 'C');
    $pdf->Cell(10, 6, 'Sl. No.', '1', 0, 'C');
    $pdf->Cell(20, 6, 'Category', '1', 0, 'C');
    $pdf->Cell(20, 6, 'Tot. Stud.', '1', 0, 'C');
    foreach ($feeheads as $value) {
        $pdf->Cell(20, 6, $value['fshortname'], '1', 0, 'C');
    }
    $pdf->Cell(20, 6, 'Total Fee', '1', 1, 'C');

$pdf->SetFont('Times', '', 10);
    foreach ($rst as $key => $val) {
        $Toatlfee = 0;
       // $pdf->Cell(2, 6, '', '0', 0, 'C');
        $pdf->Cell(10, 6, $slno, '1', 0, 'C');
        $pdf->Cell(20, 6, $val['FCATEGORY'], '1', 0, 'C');
        $pdf->Cell(20, 6, $val['fcount'], '1', 0, 'R');
        $totmale += $val['fmale'];
        $totfemale += $val['ffemale'];
        $totstud += $val['fcount'];
        $headfeearr = explode(',', $val['headfee']);

$fappfee = array();
        $rowtotfee = 0;
        $i = 0;
        foreach ($feeheads as $feekey => $feeval) {
            $feeheadcode[$i] = $feeval['fheadcode'];
            $i++;
        }
        //$i=0;
        foreach ($headfeearr as $hdkey => $hdval) {

$feearr = explode('->', $hdval);
            $rowtotfee += $feearr[1];
            $i = 0;
            foreach ($feeheads as $feekey => $feeval) {
                $feeheadcode[$i] = $feeval['fheadcode'];
                if (strtoupper($feearr[0]) == strtoupper($feeheadcode[$i])) {
                    $fappfee[$i] += $feearr[1];
                    //$totappfee[$feeval['fheadcode']] += $feearr[1];
                } else {
                    $fappfee[$i] += 0;
                }
                $i++;
            }
        }

for ($i = 0; $i < count($fappfee); $i++) {
            $pdf->Cell(20, 6, $fappfee[$i], '1', 0, 'R');
            $totfees[$i] += $fappfee[$i];
        }
        $pdf->Cell(20, 6, $rowtotfee, '1', 1, 'R');
        $totregfee += 0;
        $totothfee += 0;
        $totfine += 0;
        $totamount += $rowtotfee;
        ++$slno;
    }

$pdf->SetFont('Times', 'B', 10);
   // $pdf->Cell(5, 6, '', '0', 0, 'C');
    $pdf->Cell(30, 6, 'Total', '1', 0, 'C');
    $pdf->Cell(20, 6, $totstud, '1', 0, 'R');
    for ($i = 0; $i < count($totfees); $i++)
        $pdf->Cell(20, 6, $totfees[$i], '1', 0, 'R');
    $pdf->Cell(20, 6, $totamount, '1', 1, 'R');
    $pdf->Output("report_student_list.pdf", "I");
}

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

//echo $college_code; 
    $degree_code = $aobj_context->mobj_data["degree_code"];
    $freshexam = $aobj_context->mobj_data["freshexam"];
    $RegNo_start = substr("00000000" . $aobj_context->mobj_data["streg"], -8);
    $RegNo_end = substr("ZZZZZZZZ" . $aobj_context->mobj_data["edreg"], -8);

include($pdf_writer_class);

$pdf = new FPDF(); //A4
    $pdf->WhichReport = 'ReportCandidateNonActList';

$pdf->SetFont('Times', 'B', 16);
    $pdf->SetMargins(5, 12);
    $pdf->AliasNbPages();
    //$pdf->SetAutoPageBreak('on' , 10);
    //header	
    $page_header_university = "select FUNIVNAME,FTOWN, date_format(now(),'%d/%m/%Y') as date from control";
    $lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university);

$page_header_degree = "select now() as now_date,concat('[',FDEGREE,'] - ', FDESCPN,space(2),'-',space(2),FEXAMDATE) as Degree_name, FADYEAR  
							from degree where FDEGREE = '{$degree_code}' ";
    $lobj_page_header_degree = $aobj_context->mobj_db->GetRow($page_header_degree);

$page_header_REGROLL = "select FREGROLL from control";
    $lobj_page_header_REGROLL = $aobj_context->mobj_db->GetRow($page_header_REGROLL);

$pdf->aobj_context = $aobj_context;
    $pdf->date_time = 'ReportCandidateList';
    $pdf->WhichReport = 'ReportCandidateList';
    $pdf->FUNIVNAME = $lobj_page_header_university['FUNIVNAME'] . ', ' . $lobj_page_header_university['FTOWN'];
    $pdf->FTOWN = '';
    $pdf->date_1 = $lobj_page_header_university['date'];
    $pdf->college_name = $lobj_page_header_college['college_name'];
    $pdf->Degree_name = $lobj_page_header_degree['Degree_name'];
    $pdf->date_time = $lobj_page_header_degree['now_date'];
    $pdf->REGROLL = $lobj_page_header_REGROLL['FREGROLL'];
    $pdf->RFROM = $RegNo_start;
    $pdf->RTO = $RegNo_end;
    $pdf->head_cnt = 0;;
    //end header

$pdf->AddPage();
    PrintFooter($pdf);
    $pdf->SetFont('Times', '', 9);
    // body

if ($freshexam == 'T') {
        $fresh = "and cs.FFRESHEXAM = cd.FEXAMNO";
    } else {
        $fresh = '';
    }

$get_candidateNack_data = "select d.fdescpn, d.FEXAMNAME, s.FSLNO,LEFT(s.FNAME,40) as FNAME ,
		LEFT(s.FFATNAME,40) as FFATNAME,LEFT(s.FMOTNAME,40) as FMOTNAME,
		if(date_format(s.FDOB,'%d/%m/%y')='00/00/00','',date_format(s.FDOB,'%d/%m/%y')) as FDOB,
		s.FSEX,	s.FCASTE,cd.FDEGREE, cd.FEXAMNO,cd.FCOLLCODE, cd.FREGNO, 
		GROUP_CONCAT(distinct case when ifnull('','')='' then concat(' ',sub.fsubcode,' ') else concat('[',sub.fsubcode,']') end order by cd.FSUBCODE separator '') as subjects 
		from regcanddet cd inner join student s on s.FREGNO=cd.FREGNO 
		and s.FDEGREE=cd.FDEGREE and s.FCOLLCODE=cd.FCOLLCODE
		INNER JOIN subject sub on sub.FDEGREE=cd.FDEGREE and sub.FEXAMNO=cd.FEXAMNO and sub.FSUBCODE=cd.FSUBCODE
		inner join regcandsum cs on 
		cs.FDEGREE=cd.FDEGREE  and cs.FCOLLCODE=cd.FCOLLCODE and 
		cs.FREGNO=cd.FREGNO {$fresh}
		inner join degree d on cd.fdegree = d.fdegree and cd.fexamno = d.fexamno
		WHERE cd.fregno>='{$RegNo_start}' and cd.fregno<='{$RegNo_end}' 
		and cd.fdegree='{$degree_code}' and  cd.FCOLLCODE='{$college_code}'
		GROUP BY cd.FDEGREE,cd.FEXAMNO, 
		cd.FCOLLCODE,cd.FREGNO ORDER BY cd.FREGNO,cd.FEXAMNO";
//var_dump($get_candidateNack_data);
    $lobj_get_candidateNack_data = $aobj_context->mobj_db->GetAll($get_candidateNack_data);

//$header=array('Sl No.','Reg No.' ,'Name','Subjects');

//$pdf->SetFillColor(255);
    //$pdf->SetLineWidth(.2);
    //$pdf->SetFont('','B',10);

$w = array(10, 35, 155);
    //for($i=0;$i<count($header);$i++)
    //	$pdf->Cell($w[$i],10,$header[$i],1,0,'C',true);
    $pdf->Ln();
    //$pdf->SetFillColor(224,235,255);
    //$pdf->SetTextColor(0);

$adm_ln_counter = 0;
    $sln = 0000;
    $counter = 0;
    $count = count($lobj_get_candidateNack_data);
    foreach ($lobj_get_candidateNack_data as $key => $value) {

$y  = $pdf->GetY();
        if ($y >= 260) {

$pdf->Ln(3);

$pdf->AddPage();
            PrintFooter($pdf);
            $adm_ln_counter = 0;
            $pdf->Ln(10);

//$pdf->SetLineWidth(.4);
            $pdf->SetFont('', '', 10);
            //for($i=0;$i<count($header);$i++)
            //$pdf->Cell($w[$i],10,$header[$i],1,0,'C',true);
            $pdf->Ln();
        }

$ltmpregno = "";
        $ltmpname = "";
        $ltmpslno = "";
        $ltmpfathname = "";
        $ltmpmothname = "";
        if ($lregno != $value['FREGNO']) {
            $sln++;
            $lregno = $value['FREGNO'];
            $y  = $pdf->GetY();
            if ($y >= 250) {
                $pdf->Ln(3);

$pdf->AddPage();
                PrintFooter($pdf);
                $adm_ln_counter = 0;
                $pdf->Ln(10);

//$pdf->SetLineWidth(.4);
                $pdf->SetFont('', '', 10);
                //for($i=0;$i<count($header);$i++)
                //$pdf->Cell($w[$i],10,$header[$i],1,0,'C',true);
                $pdf->Ln();
            }

$pdf->SetFont('Courier', '', 11);
            $pdf->Cell($w[0], 6, $sln, 'LRT', 0, 'C');
            $pdf->Cell($w[1], 6, $value['FREGNO'], 'LRT', '', 'L');
            $pdf->Cell($w[2], 6, 'Student Name  : ' . $value['FNAME'], 'RT', '1', 'L');
            $pdf->Cell($w[0], 6, '', 'LR', 0, 'C');
            $pdf->Cell($w[1], 6, 'Cat.: ' . $value['FCASTE'], 'LR', '', 'L');
            $pdf->Cell($w[2], 6, "Father's Name : " . $value['FFATNAME'], 'R', '1', 'L');
            $pdf->Cell($w[0], 6, '', 'LR', 0, 'C');
            $pdf->Cell($w[1], 6, '', 'LRB', '', 'C');
            $pdf->Cell($w[2], 6, "Mother's Name : " . $value['FMOTNAME'], 'RB', '1', 'L');
        }

$pdf->SetFont('Courier', '', 11);
        $pdf->Cell($w[0], 6, '', 'LR', 0, 'C');
        $pdf->Cell($w[1], 6, $value['FEXAMNAME'], 1, '', 'L');
        $pdf->Cell($w[2], 6, $value['subjects'], '1', 1, 'L');
        $adm_ln_counter++;

//$fill=!$fill;
    }

PrintFooter($pdf);
    $pdf->Output("Student_List_College.pdf", "I");
}

function PrintFooter($pdf)
{
    $new_x = $pdf->GetX();
    $new_y = $pdf->GetY();
    $ip = $_SERVER["REMOTE_ADDR"];
    $pdf->SetY(-17);
    $pdf->SetFont('Times', 'B', 8);

$pdf->Cell(140, 6, 'Printed   : IP Address : ' . $ip . ", Date : " . $pdf->date_time, '0', 0, 'L');
    $pdf->SetXY($new_x, $new_y);
}

${this.title}

Code Editor : report_reg_list_gcg_new_04012021.php