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

<?php

function printMarkListSubWisenew($aobj_context)
{	
	session_start();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $FUNIVCODE = $_SESSION['FUNIVCODE'];
    $collcode=$_SESSION['collcode'];
    $degree_ = $aobj_context->mobj_data['degree'];
	$deg = explode(' - ', $degree_);
	$degree = $deg[0];
    $dept = $deg[1];
    $sem_ = $aobj_context->mobj_data['sem'];
    
	$seme = explode(' - ', $sem_);
	$sem = $seme[0];
    $semester = $seme[1];
    $subject = $aobj_context->mobj_data["subject"];
    
    $section = $aobj_context->mobj_data["section"];

if(strtolower($section) == 'all'){
        $cond_sec = ' '; 
        $secList = 'All';

}else{  
        $cond_sec = "and at.fsection='{$section}'";
        $secList = $section;
    }
    $fregno = $aobj_context->mobj_data["fregno"];
    $tregno = $aobj_context->mobj_data["tregno"];
    $marks_ = $aobj_context->mobj_data["marks"];
    $markSplit = explode('_', $marks_);
    $marks = $markSplit[0];
    $college = $_SESSION['collcode'];

$pdf_writer_class=$aobj_context->main_src."/tcpdf/tcpdf.php";
	
	include($pdf_writer_class);		
	$pdf= new TCPDF();
	$pdf->SetFont('Times','',10);                  
   
    $page_header_university = "select FUNIVNAME as 'FUNIVNAME',FUNIVCODE,
        FUNIVADD1 as 'state', pdf_logo_path,
        ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";
	$lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university);

$get_coll_name = "select CONCAT(FCOLLCODE, ' - ', FCOLLNAME,', ',FTOWN) AS FCOLLNAME, ftown as FTOWN from college 
        where fcollcode = '{$college}'";
    $res_coll_name = $aobj_context->mobj_db->GetRow($get_coll_name); 
    
    $get_deg_name = "select fdescpn from degree 
        where fdegree = '{$degree}' and fexamno = 'A'";
    $res_deg_name = $aobj_context->mobj_db->GetRow($get_deg_name); 
    $fdescpn = $res_deg_name['fdescpn'];

$db=$aobj_context->mobj_data["db"];  
    $img_path = $aobj_context->main_src .$db.'/'. $lobj_page_header_university['pdf_logo_path'];
    $FUNIVNAME = $lobj_page_header_university['FUNIVNAME'];
    $STATE = $lobj_page_header_university['state'];
    $FUNIVCODE = $lobj_page_header_university['FUNIVCODE'];
    $COLLNAME = $res_coll_name['FCOLLNAME'];
    //$COLLNAME = $res_coll_name['FCOLLNAME'];

$query_marks = "select if(s.fqnno = '1',sum(s.fu1max),sum((s.fu1max+s.fu2max)))  as maxmarks,
    ifnull(fthonly,'A') as fthonly
    from subdet 
            where fdegree = '{$degree}' and fexamno = '{$sem}' and left(fcsubcode,4) = '{$subject}'";
    $res_marks = $aobj_context->mobj_db->GetRow($query_marks);
    $maxmarks =$res_marks['maxmarks'];
    $fthonly =$res_marks['fthonly'];
 
    
    if(strtolower($subject) == 'all')
        $maxmarks = '50';

$havcnd = "having if(CEIL(ifnull(prmarks, '0')) >0 and thmarks >0,(((CEIL(ifnull(prmarks, '0'))/20)*100) < '{$marks}' or ((CEIL(ifnull(thmarks, '0'))/30)*100) < '{$marks}'),((CEIL(ifnull(totmarks, '0'))/50)*100) < '{$marks}')";
    if($marks == '100')
           $havcnd ="";
    else if($fthonly == 'T')
        $havcnd = "having if(CEIL(ifnull(prmarks, '0')) >0 and thmarks >0,(((CEIL(ifnull(prmarks, '0'))/20)*100) < '{$marks}' or ((CEIL(ifnull(thmarks, '0'))/30)*100) < '{$marks}'),((CEIL(ifnull(totmarks, '0'))/50)*100) < '{$marks}')";
        
    if($subject == "All"){
        $cond_sub = " ";
    }else{
        $cond_sub = "and left(s.fcsubcode,4) = '{$subject}'";
    }

$teachcode = $_SESSION['usr'];
    
    $query_teach = "select fteachname, fteachcode from masteach 
                    where fcollcode = '{$college}' and fteachcode = '{$teachcode}'";
    $res_teach = $aobj_context->mobj_db->GetRow($query_teach);
    
    $teachname = $res_teach['fteachname'];

$query = "select * from s_sysdb where sysusr = '{$teachcode}'";
    $res0 = $aobj_context->mobj_db->GetRow($query);
    $user_type = $res0['user_type'];
  
    $cnd = "inner join attendsum a on s.fdegree = a.fdegree and s.fexamno = a.fexamno 
    and s.fcsubcode = a.fsubcode
    and a.fteachcode = '{$teachcode}'";
    
    if($user_type == '40' || $user_type == '14' || $_SESSION['super_wiser'] == 'T')
        $cnd = "";

$qry_subject = "select distinct s.fsubcode,s.fsubname,s.fsubshort from subject s
                        {$cnd}
                        where s.fdegree = '{$degree}'
                        and s.fexamno = '{$sem}'
                        {$cond_sub}";

$result_subject = $aobj_context->mobj_db->GetAll($qry_subject);
    $fsubshort1 = $result_subject[0]['fsubshort'];
    $fsubname1 = $result_subject[0]['fsubname'];
    foreach($result_subject as $sub)
    {

$fsubcode = $sub['fsubcode'];
        $fsubshort = $sub['fsubshort'];
        
        $exam_data = "select ifnull(d.fexamdate,'') as fexamdate from degree d 
                 inner join student s on s.fdegree = d.fdegree 
                 and d.fexamno = s.fexamno where d.fdegree = '{$degree}' and 
                 s.fexamno = '{$sem}' and s.fregno between '{$fregno}' 
                 and '{$tregno}' group by d.fexamdate";
        $lobj_get_exam_data = $aobj_context->mobj_db->GetRow($exam_data);  
    
        $examdate = $lobj_get_exam_data['fexamdate'];

if($marks == "100"){
             $cndCIE = 'Continuous Internal Evaluation Submission Form: '.$examdate;
        }else{
            $cndCIE = 'CIE Less Than '.$marks.'% for '.$examdate.'  Form C';
        }

$pdf->SetFont('Times','B',12);
        
        $degname = 'Degree: ';    
        if($FUNIVCODE == '049')
            $degname = 'Program: ';

$query1 = "select fsubname as fssubname from subdet 
                    where fexamno = '{$sem}'
                    and fdegree ='{$degree}'  
                    and left(fcsubcode,4) = '{$fsubcode}'
                    group by fsubname order by ifnull(forder,''),fsubname";
                    
        $res1 = $aobj_context->mobj_db->GetAll($query1);
        
        $totheader = count($res1);
        if($FUNIVCODE == '049' || $FUNIVCODE == '052'){
            $add = ", a1.attend,a1.conducted";
        }else{
            $add = "";
        }

if($FUNIVCODE == '052'){
            $cod="s.fsubname,'->',";
        }else{
            $cod = "";
        }
        
        //sum(if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks))) as totmarks,
        $first = true;

if($FUNIVCODE == '052' || $FUNIVCODE == '056'  || $FUNIVCODE == '057')
        {
            $get_subwise = "select m.fregno,mid(st.fname,1,18) as fname1, 
            mid(st.fname,19,37) as fname2,
            ifnull(left(m.fsubcode,4),'') as fsubcode,ifnull(s.fsubname,'') as fsubname, '{$fsubshort}' as coursecode,
            group_concat(concat(concat(s.fsubname))order by s.fsubcode separator '*') as sublist,
            GROUP_CONCAT(concat($cod right(concat(if(ifnull(m.fmarks,'-1.00') = '-1.00','0',m.fmarks)),9)) ORDER BY s.fsubcode ASC SEPARATOR '*') as markslist,
            (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))) as th,
            (sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))) as pr,
            (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6) as thmarks,
            (sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4) as prmarks,
            if((sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4) >0
            and (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6) >0,((sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6)+(sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4)),sum(if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)))) as totmarks
            $add
            from marksint m inner join subdet s on concat(s.fcsubcode,s.fsubcode) = m.fsubcode
            and m.fdegree = s.fdegree and m.fexamno = s.fexamno  
            inner join (select at.fdegree,at.fcollcode,at.fregno,at.fsubcode, at.fexamno, ifnull(FTOTC,'0') as conducted, ifnull(FTOTA,'0') as attend
            From attendsum at left join attend a on a.fexamno = at.fexamno and a.fdegree = at.fdegree and a.fsubcode = at.fsubcode and a.fregno = at.fregno and a.fcollcode = at.fcollcode 
            where at.fregno between '{$fregno}' and '{$tregno}' and at.fdegree = '{$degree}' $cond_sec group by at.fregno,at.fsubcode) a1 on a1.fdegree = m.fdegree
            and a1.fexamno = m.fexamno and a1.fregno = m.fregno  
            and left(a1.fsubcode,4) = left(m.fsubcode,4)
            inner join student st on st.fdegree = m.fdegree and 
            st.fcollcode = m.fcollcode and m.fregno = st.fregno 
            where m.fregno between '{$fregno}' and '{$tregno}' 
            and s.fdegree = '{$degree}' 
            and left(a1.fsubcode,4) = '{$fsubcode}'
            and s.fexamno='{$sem}' 
            and ifnull(st.fdeleted,'') <> 'T'
            and a1.fcollcode = '{$college}' 
            group by m.fregno,left(a1.fsubcode,4),coursecode
            {$havcnd} order by left(m.fsubcode,4)";
        }else{

if(strtolower($section) == 'all'){
                $cond_sec1 = ' '; 
            }else{  
                $cond_sec1 = "and st.fsection='{$section}'";
            }

$get_subwise = "select m.fregno,mid(st.fname,1,18) as fname1, 
                            mid(st.fname,19,37) as fname2,
                            ifnull(s.fprsub,'')  fprsub,
                            ifnull(s.fthonly,'A')  fthonly,
                            ifnull(left(m.fsubcode,4),'') as fsubcode,ifnull(s.fsubname,'') as fsubname, '{$fsubshort}' as coursecode,
                            group_concat(concat(concat(s.fsubname))order by s.fsubcode separator '*') as sublist,
                            GROUP_CONCAT(concat($cod right(concat(if(ifnull(m.fmarks,'-1.00') = '-1.00','0',m.fmarks)),9)) ORDER BY s.fsubcode ASC SEPARATOR '*') as markslist,
                            (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))) as th,
                            (sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))) as pr,
                            (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6) as thmarks,
                            if(ifnull(s.fthonly,'A') ='T', (sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))),(sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4)) as prmarks,
                            if((sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4) >0
                            and (sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6) >0,
                            ((sum(if(s.ftheory = 'T',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.6) +
                            if(ifnull(s.fthonly,'A') ='T' ,sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0)),(sum(if(s.ftheory = 'F',if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)),0))*.4))),
                            sum(if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks)))) as totmarks
                            $add
                            from marksint m inner join subdet s on concat(s.fcsubcode,s.fsubcode) = m.fsubcode
                            and m.fdegree = s.fdegree and m.fexamno = s.fexamno  
                            inner join ( select at.fdegree,at.fcollcode,at.fregno,at.fsubcode, at.fexamno,sum(fnoclass) as conducted, 
                            sum(if(fpresent = 'P',fnoclass,0)) as attend From attendsum at 
                            left join attend_det a on a.fexamno = at.fexamno and a.fdegree = at.fdegree and a.fsubcode = at.fsubcode 
                            and a.fregno = at.fregno and a.fcollcode = at.fcollcode
                            and a.fclassid = at.fclassid
                            inner join student st on at.fregno = st.fregno and st.fdegree = st.fdegree
                            where at.fregno between '{$fregno}' and '{$tregno}' and at.fdegree = '{$degree}' $cond_sec1
                            group by at.fregno,at.fsubcode) a1 on a1.fdegree = m.fdegree
                            and a1.fexamno = m.fexamno and a1.fregno = m.fregno  
                            and left(a1.fsubcode,4) = left(m.fsubcode,4)
                            inner join student st on st.fdegree = m.fdegree and 
                            st.fcollcode = m.fcollcode and m.fregno = st.fregno 
                            where m.fregno between '{$fregno}' and '{$tregno}' 
                            and s.fdegree = '{$degree}' 
                            and left(a1.fsubcode,4) = '{$fsubcode}'
                            and s.fexamno='{$sem}' 
                            and ifnull(st.fdeleted,'') <> 'T'
                            and a1.fcollcode = '{$college}' 
                            group by m.fregno,left(a1.fsubcode,4),coursecode
                            {$havcnd} order by left(m.fsubcode,4)";
        }
        $res2 = $aobj_context->mobj_db->GetAll($get_subwise);

$count = 1;
        $z=0;
        foreach($res2 as $value)
        {   
            // if($value['fregno'] === "NNM22CS001")

if($z == 15 || $first){
                $first = false;
                 if($FUNIVCODE=="062"){
                    if($collcode=="1002"){
                        $pdf->SetMargins(3,10); 
                    }else{
                        $pdf->SetMargins(25,10);  
                    }
                }else{
                    $pdf->SetMargins(3,10);
                  }
               
              
                    $pdf->AddPage('L'); 
              
               
                
                if($FUNIVCODE == '049' || $FUNIVCODE == '098' || $FUNIVCODE == 'P005')
                {
                    if (file_exists($img_path)) {
                        if($FUNIVCODE == '098')
                            $pdf->Image($img_path,115, 2, 30);
                        else if($FUNIVCODE == 'P005')
                            $pdf->Image($img_path,115, 2, 50,20);
                        else
                            $pdf->Image($img_path,135, 2, 25);
                    }
                }else if($FUNIVCODE == '062')
                {
                    if($collcode=="1001"){
                        if (file_exists($img_path)) {
                            $pdf->Image($img_path, 12, 8, 25,25);
                        } 
                    }else{
                        if (file_exists($img_path)) {
                            $pdf->Image($img_path, 25, 8, 25,25);
                        } 
                    }
                     
                }
                else
                {
                    if (file_exists($img_path)) {
                        $pdf->Image($img_path, 30, 2, 25,15);
                    }   
                }

$pdf->SetFont('Times', 'B', 16);
                if($FUNIVCODE != '052' && $FUNIVCODE != '056' && $FUNIVCODE != '062' && $FUNIVCODE != '057')
                    $pdf->ln(12);
                if($FUNIVCODE == '052')
                {
                    $pdf->SetFont('Times','B',10);
                    $pdf->Cell(0,4,"JSS MAHAVIDYAPEETHA",0,1,'C'); 
                    $pdf->SetFont('Times','B',13);
                    $pdf->Cell(0,4,$FUNIVNAME,0,1,'C');                    
                }

$pdf->SetFont('Times', 'B', 16);
              if($FUNIVCODE=="062"){
                $pdf->Cell(0, 1, $COLLNAME, 0, 0, 'C');
                $pdf->ln(2);
                $pdf->SetFont('Times', 'B', 10);
                $pdf->Cell(0,2,"Page".$pdf->getAliasNumPage().'/'.$pdf->getAliasNbPages(),0,1,'R');
              }else{
                $pdf->Cell(0, 5, $COLLNAME, 0, 1, 'C');
              }
           
                $pdf->SetFont('Times','B',12);
                $pdf->Cell(0, 5, $cndCIE, 0, 1, 'C');
               
                    $pdf->Cell(0, 5, 'Department: '.$fdescpn, 0, 1, 'C');
                    $pdf->Cell(0, 5, 'Course Code: '.$fsubshort1.'     '.'Course Title: '.$fsubname1, 0, 1, 'C');
                    
                    if($_SESSION['usr']!="admin" && $_SESSION['super_wiser'] != 'T'){
                        $pdf->Cell(0, 5, 'Faculty Name: '.$teachname.'      '.'Section: '.$secList.'     '.'Semester: '.$semester, 0, 1, 'C');
                    }else{
                        $pdf->Cell(0, 5, 'Section: '.$secList.'     '.'Semester: '.$semester, 0, 1, 'C'); 
                    } 
                   
                $pdf->ln(5);
                $totheader = count($res1);

if(($college == '1001' || $college == '1827') && $FUNIVCODE != '052' && $FUNIVCODE != '056' && $FUNIVCODE != '057')
                {
                    $pdf->SetFont('Times', 'B', 9);
                    if($totheader<6)
                        $pdf->Cell(17,4,'','',0,'C');
                    $pdf->Cell(9,4,'Sl.','LRT',0,'C');
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(24,4,'Reg.No','LRT',0,'C');
                    }else{
                        $pdf->Cell(24,4,'USN','LRT',0,'C');
                    }
                
                    $pdf->Cell(37,4,'Name','LRT',0,'C');
                    if($FUNIVCODE != '052')
                    {
                        if($FUNIVCODE!="062"){
                            $pdf->Cell(12,4,'Classes','LRT',0,'C');										
                            $pdf->Cell(12,4,'Classes','LRT',0,'C');
                        }
                           
                    }
                    
                    if($FUNIVCODE == '052'){
                        foreach($res1 as $ssub)
                        {
                            $pdf->Cell(22,4,$ssub['fssubname'],'LRT',0,'C');
                        }
                    }else{
                        
                        foreach($res1 as $ssub)
                        {
                            if(strlen($ssub['fssubname']) <= 6){
                                $pdf->Cell(14,4,$ssub['fssubname'],'LRT',0,'C');
                            }else{
                                $pdf->Cell(20,4,$ssub['fssubname'],'LRT',0,'C');
                            }   
                        }
                    }
                    if($value['fprsub'] == 'T')
                    {
                        $pdf->Cell(12,4,'Th.','LRT',0,'C');
                        $pdf->Cell(12,4,'Pr.','LRT',0,'C');
                        $pdf->Cell(12,4,'Th.','LRT',0,'C');
                        $pdf->Cell(12,4,'Pr.','LRT',0,'C');    
                    }

$pdf->Cell(15,4,'Total','LRT',0,'C');
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(15,4,'Total','LRT',1,'C'); 
                    }else{
                    $pdf->Cell(15,4,'Total','LRT',0,'C');}
                    if($FUNIVCODE != '052')
                    if($FUNIVCODE!="062"){
                        $pdf->Cell(12,4,'NE','LRT',0,'C');
                        $pdf->Cell(24,4,'Student','LRT',1,'C');
                    }

if($totheader<6)
                        $pdf->Cell(17,4,'','',0,'C');

$pdf->Cell(9,4,'No.','LRB',0,'C');
                    
                    $pdf->Cell(24,4,'','LRB',0,'C');
                    $pdf->Cell(37,4,'','LRB',0,'C');	
                    
                    if($FUNIVCODE != '052')
                    {
                        if($FUNIVCODE!="062"){
                            $pdf->Cell(12,4,'Held','LRB',0,'C');										
                            $pdf->Cell(12,4,'Attend','LRB',0,'C');
                        }
                                
                    }

if($FUNIVCODE == '052'){
                        foreach($res1 as $ssub)
                        { 
                            $pdf->Cell(22,4,"",'LRB',0,'C');
                        }
                    }else {
                        foreach($res1 as $ssub)
                        { 
                            if(strlen($ssub['fssubname']) <= 6){
                                $pdf->Cell(14,4,"",'LRB',0,'C');
                            }else{
                                $pdf->Cell(20,4,"",'LRB',0,'C');
                            }
                        }
                    }
                    
                    if($value['fprsub'] == 'T')
                    {

$pdf->Cell(12,4,'Tot.(50)','LRB',0,'C'); 
                        if($value['fthonly'] == 'T')
                            $pdf->Cell(12,4,'Tot.(20)','LRB',0,'C');
                        else
                            $pdf->Cell(12,4,'Tot.(50)','LRB',0,'C');
    
                        $pdf->Cell(12,4,'(60%)','LRB',0,'C'); 
                        if($value['fthonly'] == 'T')
                            $pdf->Cell(12,4,'(100%)','LRB',0,'C'); 
                        else    
                            $pdf->Cell(12,4,'Tot.(40%)','LRB',0,'C');    
                    }

$pdf->Cell(15,4,'','LRB',0,'C'); 
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(15,4,'Rounded','LRB',1,'C');
                    }else{
                    $pdf->Cell(15,4,'Rounded','LRB',0,'C');
                    }
                    if($FUNIVCODE != '052'){
                    if($FUNIVCODE!="062"){
                        $pdf->Cell(12,4,'','LRB',0,'C'); 
                        $pdf->Cell(24,4,'Signature','LRB',1,'C');
                    }
                        $z=0;
                }
                    
                }
                else
                {
                    if($totheader <5)
                        $pdf->Cell(17,4,'','',0,'C'); 
                    $pdf->SetFont('Times', 'B', 9);
                    $pdf->Cell(12,4,'Sl.','LRT',0,'C');
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(29,4,'Reg.No','LRT',0,'C');
                    }else{
                    $pdf->Cell(29,4,'USN','LRT',0,'C');
                }

$pdf->Cell(48,4,'Name','LRT',0,'C');
                    if($FUNIVCODE!="062"){
                        $pdf->Cell(16,4,'Classes','LRT',0,'C');										
                        $pdf->Cell(16,4,'Classes','LRT',0,'C');
                    }
                       
                    if($FUNIVCODE == "052")
                        $pdf->Cell(18,4,'Attendance','LRT',0,'C');

if($FUNIVCODE != '052'){
                        $subList = $res1;
                    }else{
                       $newSub = $res2[0]['sublist'];
                        $subList = explode("*", $newSub);
                    }
                  
                    foreach($subList as $ssub)
                    {
                    
                        if($FUNIVCODE != '052'){
                          $split=explode(' ',$ssub['fssubname']);
                            $pdf->Cell(25,4,$split[0],'LRT',0,'C');
                        }else{
                            $pdf->Cell(17,4,$ssub,'LRT',0,'C');
                        }
                        
                    }
               
                    $pdf->Cell(18,4,'Total','LRT',0,'C');

if($FUNIVCODE=="062"){
                        $pdf->Cell(18,4,'Grand','LRT',1,'C');
                    }else{
                        $pdf->Cell(18,4,'Grand','LRT',0,'C');
                    }
                
                    if($FUNIVCODE != '052')
                    if($FUNIVCODE!="062"){
                        $pdf->Cell(12,4,'NE','LRT',0,'C');
                        $pdf->Cell(32,4,'Student','LRT',1,'C');
                    }
                  
                    
                    if($totheader <5)
                        $pdf->Cell(17,4,'','',0,'C');

$pdf->Cell(12,4,'No.','LRB',0,'C');
                    $pdf->Cell(29,4,'','LRB',0,'C');
                    $pdf->Cell(48,4,'','LRB',0,'C');	
                    if($FUNIVCODE!="062"){
                        $pdf->Cell(16,4,'Held','LRB',0,'C');										
                        $pdf->Cell(16,4,'Attend','LRB',0,'C');
                    }
                    if($FUNIVCODE == "052")
                        $pdf->Cell(18,4,'%','LRB',0,'C');       
              
                    if($FUNIVCODE != '052'){
                        $subList = $res1;
                    }else{
                       $newSub = $res2[0]['sublist'];
                        $subList = explode("*", $newSub);
                    }
                    foreach($subList as $ssub)
                    {
                        $split=explode(' ',$ssub['fssubname']);
                        $pdf->Cell(25,4,$split[1],'LRB',0,'C');
                    }
                    $pdf->Cell(18,4,'','LRB',0,'C'); 
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(18,4,'Total','LRB',1,'C');  
                    }else{
                    $pdf->Cell(18,4,'Total','LRB',0,'C');
                }
                    if($FUNIVCODE != '052')
                    if($FUNIVCODE!="062"){
                        $pdf->Cell(12,4,'','LRB',0,'C');
                        $pdf->Cell(32,4,'Signature','LRB',1,'C');
                    }  
                    $z=0;
                }  
                
            }

if(($college == '1001' || $college == '1827') && $FUNIVCODE != '052' && $FUNIVCODE != '056' && $FUNIVCODE != '057')
            {
                $pdf->SetFont('Times', '', 8);
                
                if($value['fname2'] != '') 
                {
                    if($totheader<6)
                    $pdf->Cell(17,4,'','',0,'C');
                    $pdf->Cell(9,4,$count,'LRT',0,'C');			
                    $pdf->Cell(24,4,$value['fregno'],'LRT',0,'C');
                    $pdf->Cell(37,4,$value['fname1'],'LRT',0,'L');
                    
                    if($FUNIVCODE != '052')
                    {
                        if($FUNIVCODE!='062'){
                            $pdf->Cell(12,4,$value['conducted'],'LRT',0,'C');
                            $pdf->Cell(12,4,$value['attend'],'LRT',0,'C');
                        }
                       
                    }
                    
                    if($FUNIVCODE == '052'){
                        foreach(explode('*',$value['markslist']) as $re)
                        { 
                            if($FUNIVCODE!='062'){
                            $pdf->Cell(22,4,$re,'LRT',0,'C'); }
                        }    
                    }else{

$i=0;
                        foreach(explode('*',$value['markslist']) as $re)
                        { 
                            $j=0;
                            foreach(explode('*',$value['sublist']) as $sub)
                            {
                                if($i === $j){
                                    if(strlen($sub)<=6){
                                        $pdf->Cell(14,4,$re,'LR',0,'C'); 
                                    } else{
                                        $pdf->Cell(20,4,$re,'LR',0,'C'); 
                                    } 
                                }
                                $j++;  
                            }  
                            $i++;
                        } 
                         
                    }
                    $na = "";

if($value['fprsub'] == 'T')
                    {
                        $pdf->Cell(12,4,$value['th'],'LRT',0,'C');
                        $pdf->Cell(12,4,$value['pr'],'LRT',0,'C');
                        $pdf->Cell(12,4,$value['thmarks'],'LRT',0,'C');
                        $pdf->Cell(12,4,$value['prmarks'],'LRT',0,'C');
                        
                        if(((($value['prmarks']/20)*100) < '40') || ((($value['thmarks']/30)*100) < '40'))
                            $na = "NE";
                    }

$pdf->Cell(15,4,$value['totmarks'],'LRT',0,'C');
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(15,4,number_format((float)ceil($value['totmarks']),2),'LRT',1,'C');
                    }else{
                        $pdf->Cell(15,4,number_format((float)ceil($value['totmarks']),2),'LRT',0,'C');
                    }
                  
                    
                    if($na == '')
                    {
                        if(((number_format((float)ceil($value['totmarks']),2)/50)*100)<40)
                            $na = "NE";
                    }

if(ceil($value['attend']/$value['conducted']*100)<75 && $value['fprsub'] != 'A')
                        $na = "NE";
                    if($FUNIVCODE != '052')
                    if($FUNIVCODE!="062"){
                        $pdf->Cell(12,4,$na,'LRT',0,'C');
                        $pdf->Cell(24,4,'','LRT',1,'C');
                    }

if($totheader<6)
                        $pdf->Cell(17,4,'','',0,'C');

$pdf->Cell(9,4,'','LRB',0,'C');	
                    $pdf->Cell(24,4,'','LRB',0,'C');
                    $pdf->Cell(37,4,$value['fname2'],'LRB',0,'L');
                    
                    if($FUNIVCODE != '052')
                    {
                        if($FUNIVCODE!="062"){
                        $pdf->Cell(12,4,'','LRB',0,'C');
                        $pdf->Cell(12,4,'','LRB',0,'C');}     
                     }
                    
                    if($FUNIVCODE == '052'){
                        foreach(explode('*',$value['markslist']) as $re)
                        { 
                           
                            $pdf->Cell(22,4,'','LRB',0,'C'); 
                        }
                    }else{
                        
                        //  foreach(explode('*',$value['markslist']) as $re)
                        // { 
                           
                        //     $pdf->Cell(18,7,'','LR',0,'C'); 
                           
                        // }
                        $i=0;
                        foreach(explode('*',$value['markslist']) as $re)
                        { 
                            $j=0;
                            foreach(explode('*',$value['sublist']) as $sub)
                            {
                                if($i === $j){
                                    if(strlen($sub)<=6){
                                        $pdf->Cell(14,4,'','LRB',0,'C'); 
                                    } else{
                                        $pdf->Cell(20,4,'','LRB',0,'C'); 
                                    } 
                                }
                                $j++;  
                            }  
                            $i++;
                        }  
                    }
                    if($value['fprsub'] == 'T')
                    {
                        
                        $pdf->Cell(12,4,'','LRB',0,'C');
                        $pdf->Cell(12,4,'','LRB',0,'C');
                        $pdf->Cell(12,4,'','LRB',0,'C');
                        $pdf->Cell(12,4,'','LRB',0,'C');
                    }

$pdf->Cell(15,4,'','LRB',0,'C');
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(15,4,'','LRB',1,'C');  
                    }else{
                    $pdf->Cell(15,4,'','LRB',0,'C');}
                    if($FUNIVCODE != '052'){
                        if($FUNIVCODE!="062"){
                        $pdf->Cell(12,4,'','LRB',0,'C');
                        $pdf->Cell(24,4,'','LRB',1,'C');
                    }
                   
                    }
                }else
                {
                    if($totheader<6)
                        $pdf->Cell(17,4,'','',0,'C');

$pdf->Cell(9,7,$count,'LRBT',0,'C');			
                    $pdf->Cell(24,7,$value['fregno'],'LRBT',0,'C');
                    $pdf->Cell(37,7,$value['fname1'],'LRBT',0,'L');
                    
                    if($FUNIVCODE != '052')
                    {
                        if($FUNIVCODE!="062"){
                            $pdf->Cell(12,7,$value['conducted'],'LRBT',0,'C');
                            $pdf->Cell(12,7,$value['attend'],'LRBT',0,'C');
                        }
                        
                    }
                    
                    $na = "";

if($FUNIVCODE == '052'){
                        foreach(explode('*',$value['markslist']) as $re)
                        { 
                            $pdf->Cell(22,7,$re,'LRBT',0,'C');
                        }    
                    }else{
                       
                        
                        $i=0;
                        foreach(explode('*',$value['markslist']) as $re)
                        { 
                            $j=0;
                            foreach(explode('*',$value['sublist']) as $sub)
                            {
                                if($i === $j){
                                    if(strlen($sub)<=6){
                                        $pdf->Cell(14,7,$re,'LB',0,'C'); 
                                    } else{
                                        $pdf->Cell(20,7,$re,'LB',0,'C'); 
                                    } 
                                }
                                $j++;  
                            }  
                            $i++;
                        }  
                        
                    }
                    
                        if($value['fprsub'] == 'T')
                        {
                            $pdf->Cell(12,7,$value['th'],'LRBT',0,'C');
                            $pdf->Cell(12,7,$value['pr'],'LRBT',0,'C');
                            $pdf->Cell(12,7,$value['thmarks'],'LRBT',0,'C');
                            $pdf->Cell(12,7,$value['prmarks'],'LRBT',0,'C');
                            if(((($value['prmarks']/20)*100) < '40') || ((($value['thmarks']/30)*100) < '40'))
                                $na = "NE";
                        }  
                    
                    $pdf->Cell(15,7,$value['totmarks'],'LRBT',0,'C');
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(15,7,number_format((float)ceil($value['totmarks']),2),'LRBT',1,'C');  
                    }else{
                        $pdf->Cell(15,7,number_format((float)ceil($value['totmarks']),2),'LRBT',0,'C');
                    }

if($na == '')
                    {
                        if(((number_format((float)ceil($value['totmarks']),2)/50)*100)<40)
                            $na = "NE";
                    }
                    // if($value['fregno'] == 'NNM22EE052')
                    
                    if(ceil($value['attend']/$value['conducted']*100)<75 && $value['fprsub'] != 'A')
                        $na = "NE";
                    if($FUNIVCODE != '052'){
                       
                    if($FUNIVCODE!="062"){
                        $pdf->Cell(12,7,$na,'LRBT',0,'C');
                        $pdf->Cell(24,7,'','LRBT',1,'C'); 
                    }
                }
                }       
            
                $count++;
                $z++;  
            }
           
            else{
                 $pdf->SetFont('Times', '', 10);
        
                
                //    }
             if($value['fname2'] != '' && $FUNIVCODE != '052' && $FUNIVCODE != '056' && $FUNIVCODE != '057') 
             {
                if($totheader <5)
                $pdf->Cell(17,4,'','',0,'C');    
                $pdf->Cell(12,4,$count,'LRT',0,'C');			
                $pdf->Cell(29,4,$value['fregno'],'LRT',0,'C');
                $pdf->Cell(48,4,$value['fname1'],'LRT',0,'L');
              
                if($FUNIVCODE!="062"){
                    $pdf->Cell(16,4,$value['conducted'],'LRT',0,'C');
                    $pdf->Cell(16,4,$value['attend'],'LRT',0,'C');
                }
                   
                    if($FUNIVCODE == "052"){
                        $per = $value['attend'] /$value['conducted'] * 100;
                        if($FUNIVCODE!="062"){
                        $pdf->Cell(18,4,round($per,2),'LRT',0,'C');
                    }
                    }
               
                if($FUNIVCODE != "052"){
                      
                    foreach(explode('*',$value['markslist']) as $re)
                    {  
                        
                        $pdf->Cell(25,7,$re,'LRT',0,'C'); 
                    }

}else{
                    $test1 = "";
                    $test2 = "";
                    $makeup = "";
                    $event = "";
                    $test1marks = 0;
                    $test2marks = 0;
                    $makeupmarks = 0;
                    $eventmarks = 0;
                    
                    $split = explode('*',$value['markslist']);
                    foreach($split as $val){
                        $marksSplit = explode('->',$val);
                        $subname = $marksSplit[0];

if($subname === "Test 1"){
                                $test1 = $subname;
                                $test1marks = $marksSplit[1];
                            }else if($subname === "Test 2"){
                                $test2 = $subname;
                                $test2marks = $marksSplit[1];
                            }else if($subname === "Makeup"){
                                $makeup = $subname;
                                $makeupmarks = $marksSplit[1];
                            }else if($subname === "Event"){
                                $event = $subname;
                                $eventmarks = $marksSplit[1];
                            }  
                            if($marksSplit[1] == -2){
                                $mark = "AB";
                            }else{
                                $mark = $marksSplit[1];
                            }
                        $pdf->Cell(17,7,$mark,'LRT',0,'C'); 
                    }
                    
                }
                if($FUNIVCODE !="052"){
                    $pdf->Cell(18,4,$value['totmarks'],'LRT',0,'C');
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(18,4,number_format((float)ceil($value['totmarks']),2),'LRT',1,'C');
                    }else{
                        $pdf->Cell(18,4,number_format((float)ceil($value['totmarks']),2),'LRT',0,'C');
                    }
                    
                }else{
                    $test1 = 0;
                    $test2 = 0;
                    if($test1marks < $test2marks && $test1marks < $makeupmarks){
                        $test1 = $makeupmarks;
                        $test2 = $test2marks;
                    }else if($test2marks < $test1marks && $test2marks < $makeupmarks){
                        $test1 = $test1marks;
                        $test2 = $makeupmarks;
                    }else if($test2marks == $test1marks && $test1marks > $makeupmarks){
                        $test1 = $test1marks;
                        $test2 = $test2marks ;
                    }else if($test2marks == $test1marks && $test2marks > $makeupmarks){
                        $test1 = $test1marks;
                        $test2 = $test2marks ;
                    }else if($test2marks == $test1marks && $test2marks < $makeupmarks){
                        $test1 = $test1marks;
                        $test2 = $makeupmarks ;
                    }
                    else{
                        $test1 = $test1marks;
                        $test2 = $test2marks;
                    }

if($test1 == "-2.00"){
                        $test1 = 0;
                    }

if($test2 == "-2.00"){
                        $test2 = 0;
                    }

if($eventmarks == "-2.00"){
                        $eventmarks = 0;
                    }
                    
                    //  if($test1marks < $test2marks && $test1marks < $makeupmarks){
                    //     $test1 = $makeupmarks === -2 ? 0 : $makeupmarks;
                    //     $test2 = $test2marks === -2 ? 0 : $test2marks;
                    // }else if($test2marks < $test1marks && $test2marks < $makeupmarks){
                    //     $test1 = $test1marks === -2 ? 0 : $test1marks;
                    //     $test2 = $makeupmarks === -2 ? 0 : $makeupmarks;
                    // }else if($test1marks === -2 && $makeupmarks === -2){
                    //     $test1 = 0;
                    // }else if($test2marks === -2 && $makeupmarks === -2){
                    //     $test2 = 0;
                    // }
                    // else{
                    //     $test1 = $test1marks === -2 ? 0 : $test1marks;;
                    //     $test2 = $test2marks === -2 ? 0 : $test2marks;
                    // }

$total = $test1 + $test2 + $eventmarks;

if($subname !== "CIE" && $subname !== "Assessment" ){
                        $pdf->Cell(18,4,$total,'LRT',0,'C');
                        $pdf->Cell(18,4,number_format((float)ceil($total),2),'LRT',0,'C');  
                    }else{
                        $pdf->Cell(18,4,$value['totmarks'],'LRT',0,'C');
                        // if($FUNIVCODE=="062"){
                        //     $pdf->Cell(16,4,number_format((float)ceil($value['totmarks']),2),'LRT',1,'C');
                        // }else{
                            $pdf->Cell(18,4,number_format((float)ceil($value['totmarks']),2),'LRT',0,'C');
                        // }
                       
                    }
                    // $pdf->Cell(16,4,$total,'LRT',0,'C');
                    // $pdf->Cell(16,4,number_format((float)ceil($total),2),'LRT',0,'C');
                }
                
                $na = "";

if($na == '')
                {
                    if(((number_format((float)ceil($value['totmarks']),2)/50)*100)<40)
                        $na = "NE";
                }

if($FUNIVCODE == 'P005')
                    $na = '';

if($FUNIVCODE != '052')
                if($FUNIVCODE!="062"){
                    $pdf->Cell(12,4,$na,'LRT',0,'C');
                    $pdf->Cell(32,4,'','LRT',1,'C');
                }
                    if($totheader <5){
                      $pdf->Cell(17,4,'','',0,'C');
                     $pdf->Cell(12,4,'','LRB',0,'C');
                $pdf->Cell(29,4,'','LRB',0,'C');
                $pdf->Cell(48,4,$value['fname2'],'LRB',0,'L');
                if($FUNIVCODE!="062"){
                    $pdf->Cell(16,4,'','LRB',0,'C');
                    $pdf->Cell(16,4,'','LRB',0,'C');
                }
            }   
                
                foreach(explode('*',$value['markslist']) as $re)
                { 
                    $pdf->Cell(25,4,'','LRB',0,'C'); 
                }
                $pdf->Cell(18,4,'','LRB',0,'C');
                if($FUNIVCODE!="062"){
                    if($collcode!="1002"){
                        $pdf->Cell(18,4,'','LRB',0,'C');
                    }
                }
                
                if($FUNIVCODE != '052')
                if($FUNIVCODE=="062"){
                    $pdf->Cell(18,4,'','LRB',1,'C');
                    // $pdf->Cell(12,4,"",'LRB',1,'C');
                }else{
                    $pdf->Cell(12,4,"",'LRB',0,'C');  
                }
                if($FUNIVCODE!="062"){
                    $pdf->Cell(32,4,'','LRB',1,'C');
                }
             }else
             {
                 
                if($totheader <5)
                    $pdf->Cell(17,4,'','',0,'C'); 
                $pdf->Cell(12,7,$count,'LRBT',0,'C');			
                $pdf->Cell(29,7,$value['fregno'],'LRBT',0,'C');
                $pdf->Cell(48,7,$value['fname1'],'LRBT',0,'L');
                if($FUNIVCODE!="062"){
                    $pdf->Cell(16,7,$value['conducted'],'LRBT',0,'C');
                    $pdf->Cell(16,7,$value['attend'],'LRBT',0,'C');
                }
                  
                    if($FUNIVCODE == "052"){
                        $per = $value['attend'] /$value['conducted'] * 100;
                        $pdf->Cell(18,4,round($per,2),'LRT',0,'C');
                    }
             
                if($FUNIVCODE != "052"){
                    foreach(explode('*',$value['markslist']) as $re)
                    { 
                        $pdf->Cell(25,7,$re,'1',0,'C'); 
                    }
                 }else{
                    $test1 = "";
                    $test2 = "";
                    $makeup = "";
                    $event = "";
                    $test1marks = 0;
                    $test2marks = 0;
                    $makeupmarks = 0;
                    $eventmarks = 0;
                    $split = explode('*',$value['markslist']);
                    foreach($split as $val){
                        $marksSplit = explode('->',$val);
                        $subname = $marksSplit[0];
                        if($subname === "Test 1"){
                                $test1 = $subname;
                                $test1marks = $marksSplit[1];
                            }else if($subname === "Test 2"){
                                $test2 = $subname;
                                $test2marks = $marksSplit[1];
                            }else if($subname === "Makeup"){
                                $makeup = $subname;
                                $makeupmarks = $marksSplit[1];
                            }else if($subname === "Event"){
                                $event = $subname;
                                $eventmarks = $marksSplit[1];
                            } 
                            
                            if($marksSplit[1] == -2){
                                $mark = "AB";
                            }else{
                                $mark = $marksSplit[1];
                            }
                            $pdf->Cell(17,7,$mark,'LRBT',0,'C'); 
                    }
                    
                }

if($FUNIVCODE !="052"){
                    $pdf->Cell(18,7,$value['totmarks'],'LRBT',0,'C');
                    if($FUNIVCODE=="062"){
                        $pdf->Cell(18,7,number_format((float)ceil($value['totmarks']),2),'LRBT',1,'C');
                    }else{
                        $pdf->Cell(18,7,number_format((float)ceil($value['totmarks']),2),'LRBT',0,'C');
                    }
                    
                }else{
                    $test1 = 0;
                    $test2 = 0;
                    
                    if($test1marks < $test2marks && $test1marks < $makeupmarks){
                        $test1 = $makeupmarks;
                        $test2 = $test2marks;
                    }else if($test2marks < $test1marks && $test2marks < $makeupmarks){
                        $test1 = $test1marks;
                        $test2 = $makeupmarks;
                    }else if($test2marks == $test1marks && $test1marks > $makeupmarks){
                        $test1 = $test1marks;
                        $test2 = $test2marks ;
                    }else if($test2marks == $test1marks && $test2marks > $makeupmarks){
                        $test1 = $test1marks;
                        $test2 = $test2marks ;
                    }else if($test2marks == $test1marks && $test2marks < $makeupmarks){
                        $test1 = $test1marks;
                        $test2 = $makeupmarks ;
                    }else{
                        $test1 = $test1marks;
                        $test2 = $test2marks;
                    }
                    
                    if($test1 == "-2.00"){
                        $test1 = 0;
                    }
                    if($test2 == "-2.00"){
                        $test2 = 0;
                    }
                    if($eventmarks == "-2.00"){
                        $eventmarks = 0;
                    }
                    $total = $test1 + $test2 + $eventmarks;
                    if($subname !== "CIE" && $subname !== "Assessment"){
                        $pdf->Cell(18,7,$total,'LRBT',0,'C');
                        $pdf->Cell(18,7,number_format((float)ceil($total),2),'LRBT',0,'C');
                    }else{
                        $pdf->Cell(18,7,$value['totmarks'],'LRBT',0,'C');
                        $pdf->Cell(18,7,number_format((float)ceil($value['totmarks']),2),'LRBT',0,'C');
                    }
                }
               
             
                $na = "";

if($na == '')
                {
                    if(((number_format((float)ceil($value['totmarks']),2)/50)*100)<40)
                        $na = "NE";
                }

if($FUNIVCODE == 'P005')
                    $na = '';

if($FUNIVCODE != '052'){
                if($FUNIVCODE!="062"){
                    $pdf->Cell(12,7,$na,'LRBT',0,'C');
                    $pdf->Cell(32,7,'','LRBT',1,'C');
                }
               }
             }       
            
            $count++;
            $z++; 
           
            }
           
        }

if(count($res2) != 0){
            $pdf->SetFont('Times', 'B', 10);
            if($FUNIVCODE!="062"){
                $pdf->ln(15);
            }else{
                $pdf->ln(30);  
            }
         
            $pdf->Cell(25,4,"        Name and Signature of Faculty",'0',0,'L');
            
            if($college == '1003'){
                $pdf->Cell(0,4,"Signature of director                              ",'0',1,'R');
            }
            else{
               if($FUNIVCODE=="062"){
                $pdf->Cell(0,4,"Signature of the H.O.D                          ",'0',1,'R');
              
               }else{
                $pdf->Cell(0,4,"Signature of the H.O.D/Principal                          ",'0',1,'R');
               }
                
            }
        }
    }
    
	$pdf->Output("IaMarksSubjectWise.pdf","I");

}
?>

${this.title}

Code Editor : markListReportPdfnew.php