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

<?php

function printMarkListSubWise($aobj_context)
{	
	session_start();
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $FUNIVCODE = $_SESSION['FUNIVCODE'];
    $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'];

// var_dump($marks);
	$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'];
    $COLLNAME = $res_coll_name['FCOLLNAME'];
    //$COLLNAME = $res_coll_name['FCOLLNAME'];

$query_marks = "select sum(FSMAXMARKS)as maxmarks from subject 
            where fdegree = '{$degree}' and fexamno = '{$sem}' and fretain='T' 
            and fintass = 'T' and fsubcode = '{$subject}'";
    $res_marks = $aobj_context->mobj_db->GetRow($query_marks);
    $maxmarks =$res_marks['maxmarks'];
    // var_dump($res_marks);
    
    if(strtolower($subject) == 'all')
        $maxmarks = '50';
    
    $havcnd = "having if(prmarks >0 and thmarks >0,(((prmarks/20)*100) < '{$marks}' or ((thmarks/30)*100) < '{$marks}'),((totmarks/50)*100) < '{$marks}')";
        if($marks == '100')
           $havcnd ="";

if($subject == "All"){
        $cond_sub = " ";
    }else{
        $cond_sub = "and left(s.fsubcode,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'];
  //  var_dump($user_type);
    $cnd = "inner join attendsum a on s.fdegree = a.fdegree and s.fexamno = a.fexamno 
    and s.fsubcode = left(a.fsubcode,4)
    and a.fteachcode = '{$teachcode}'";
    
    if($user_type == '40' || $user_type == '14')
        $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}";
//    var_dump($qry_subject);

$result_subject = $aobj_context->mobj_db->GetAll($qry_subject);

foreach($result_subject as $sub)
    {

$fsubcode = $sub['fsubcode'];
        
        $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 fssubname from subject 
                    where fintass='T' and fretain = 'T' 
                    and fexamno = '{$sem}'
                    and fdegree ='{$degree}'  
                    and fsubcode = '{$fsubcode}'
                    group by fssubname order by fssubcode";
    
        $res1 = $aobj_context->mobj_db->GetAll($query1);
        $totheader = count($res1);

//sum(if(fmarks = '-1',0,if(fmarks = '-2',0,fmarks))) as totmarks,
        $first = true;
        $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, ifnull(s.fsubshort,'')as coursecode,
                            group_concat(concat(concat(s.fssubname))order by s.fssubcode separator '*') as sublist,
                            GROUP_CONCAT(concat(right(concat(if(ifnull(m.fmarks,'-1.00') = '-1.00','0',m.fmarks)),9)) ORDER BY s.fssubcode 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,
                            a1.attend,a1.conducted
                            from marks m inner join subject s on s.fcsubcode = 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
                            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 and 
                            m.fexamno = st.fexamno
                            where m.fregno between '{$fregno}' and '{$tregno}' 
                            and s.fdegree = '{$degree}' 
                            and left(a1.fsubcode,4) = '{$fsubcode}'
                            and fintass = 'T' 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)";
        //var_dump($get_subwise);                            
        $res2 = $aobj_context->mobj_db->GetAll($get_subwise);
        $count = 1;
        $z=0;
        foreach($res2 as $value)
        {   
             
            if($z == 15 || $first){
                $first = false;
            
                $pdf->AddPage('L');
                $pdf->SetMargins(3,10);
                if (file_exists($img_path)) {
                    $pdf->Image($img_path, 115, 2, 60);
                }

$pdf->SetFont('Times', 'B', 16);
                $pdf->ln(12);
                $pdf->SetFont('Times', 'B', 16);
                $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: '.$sub['fsubshort'].'     '.'Course Title: '.$sub['fsubname'], 0, 1, 'C');
                if($_SESSION['usr']!="admin"){
                    $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')
                {
                    $pdf->SetFont('Times', '', 8);

$pdf->Cell(7,4,'Sl.','LRT',0,'C');
                    $pdf->Cell(20,4,'USN','LRT',0,'C');
                    $pdf->Cell(35,4,'Name','LRT',0,'C');	
                    $pdf->Cell(10,4,'Classes','LRT',0,'C');										
                    $pdf->Cell(10,4,'Classes','LRT',0,'C');

foreach($res1 as $ssub)
                    {
                        $pdf->Cell(14,4,$ssub['fssubname'],'LRT',0,'C');
                    }
                    
                    if($value['prmarks'] >0 && $value['thmarks']>0)
                    {
                        $pdf->Cell(10,4,'Th.','LRT',0,'C');
                        $pdf->Cell(10,4,'Pr.','LRT',0,'C');
                        $pdf->Cell(10,4,'Th.','LRT',0,'C');
                        $pdf->Cell(10,4,'Pr.','LRT',0,'C');    
                    }

$pdf->Cell(13,4,'Total','LRT',0,'C');
                    $pdf->Cell(13,4,'Total','LRT',0,'C');
                    $pdf->Cell(10,4,'NE','LRT',0,'C');
                    $pdf->Cell(22,4,'Student','LRT',1,'C');

$pdf->Cell(7,4,'No.','LRB',0,'C');
                    $pdf->Cell(20,4,'','LRB',0,'C');
                    $pdf->Cell(35,4,'','LRB',0,'C');	
                    $pdf->Cell(10,4,'Held','LRB',0,'C');										
                    $pdf->Cell(10,4,'Attend','LRB',0,'C');

foreach($res1 as $ssub)
                    {
                        
                        $pdf->Cell(14,4,"",'LRB',0,'C');

}
                    
                    if($value['prmarks'] >0 && $value['thmarks'] >0)
                    {
                        $pdf->Cell(10,4,'Tot.(50)','LRB',0,'C'); 
                        $pdf->Cell(10,4,'Tot.(50)','LRB',0,'C');
                        $pdf->Cell(10,4,'(60%)','LRB',0,'C'); 
                        $pdf->Cell(10,4,'(40%)','LRB',0,'C');     
                    }

$pdf->Cell(13,4,'','LRB',0,'C'); 
                    $pdf->Cell(13,4,'Rounded','LRB',0,'C');
                    $pdf->Cell(10,4,'','LRB',0,'C');
                    $pdf->Cell(22,4,'Signature','LRB',1,'C');
                    $z=0; 
                }
                else
                {
                    if($totheader <5)
                        $pdf->Cell(15,4,'','',0,'C'); 
                    $pdf->SetFont('Times', 'B', 9);
                    $pdf->Cell(10,4,'Sl.','LRT',0,'C');
                    $pdf->Cell(25,4,'USN','LRT',0,'C');
                    $pdf->Cell(46,4,'Name','LRT',0,'C');	
                    $pdf->Cell(14,4,'Classes','LRT',0,'C');										
                    $pdf->Cell(14,4,'Classes','LRT',0,'C');

foreach($res1 as $ssub)
                    {
                        
                        $pdf->Cell(19,4,$ssub['fssubname'],'LRT',0,'C');

}
                    $pdf->Cell(18,4,'Total','LRT',0,'C');
                    $pdf->Cell(18,4,'Total','LRT',0,'C');
                    $pdf->Cell(30,4,'Student','LRT',1,'C');
                    
                    if($totheader <=5)
                        $pdf->Cell(15,4,'','',0,'C');

$pdf->Cell(10,4,'No.','LRB',0,'C');
                    $pdf->Cell(25,4,'','LRB',0,'C');
                    $pdf->Cell(46,4,'','LRB',0,'C');	
                    $pdf->Cell(14,4,'Held','LRB',0,'C');										
                    $pdf->Cell(14,4,'Attend','LRB',0,'C');

foreach($res1 as $ssub)
                    {
                        $pdf->Cell(19,4,"",'LRB',0,'C');
                    }
                    $pdf->Cell(18,4,'','LRB',0,'C'); 
                    $pdf->Cell(18,4,'Rounded','LRB',0,'C');
                    $pdf->Cell(30,4,'Signature','LRB',1,'C');
                    $z=0; 
                }  
                
            }

if($college == '1001')
            {
                $pdf->SetFont('Times', '', 8);
                
                if($value['fname2'] != '') 
                {
                    $pdf->Cell(7,4,$count,'LRT',0,'C');			
                    $pdf->Cell(20,4,$value['fregno'],'LRT',0,'C');
                    $pdf->Cell(35,4,$value['fname1'],'LRT',0,'L');
                    $pdf->Cell(10,4,$value['conducted'],'LRT',0,'C');
                    $pdf->Cell(10,4,$value['attend'],'LRT',0,'C');
                    
                    foreach(explode('*',$value['markslist']) as $re)
                    { 
                        $pdf->Cell(14,4,$re,'LRT',0,'C'); 
                    }    
                    $na = "";
                    if($value['prmarks'] >0 && $value['thmarks']>0)
                    {
                        $pdf->Cell(10,4,$value['th'],'LRT',0,'C');
                        $pdf->Cell(10,4,$value['pr'],'LRT',0,'C');
                        $pdf->Cell(10,4,$value['thmarks'],'LRT',0,'C');
                        $pdf->Cell(10,4,$value['prmarks'],'LRT',0,'C');
                        
                        if(((($value['prmarks']/20)*100) < '40') || ((($value['thmarks']/30)*100) < '40'))
                            $na = "NE";
                    }

$pdf->Cell(13,4,$value['totmarks'],'LRT',0,'C');
                    $pdf->Cell(13,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";
                    }

$pdf->Cell(10,4,$na,'LRT',0,'C');
                    $pdf->Cell(22,4,'','LRT',1,'C');
                   
                    $pdf->Cell(7,4,'','LRB',0,'C');			
                    $pdf->Cell(20,4,'','LRB',0,'C');
                    $pdf->Cell(35,4,$value['fname2'],'LRB',0,'L');
                    $pdf->Cell(10,4,'','LRB',0,'C');
                    $pdf->Cell(10,4,'','LRB',0,'C');
                    
                    foreach(explode('*',$value['markslist']) as $re)
                    { 
                        $pdf->Cell(14,4,'','LRB',0,'C'); 
                    }
                    
                    if($value['prmarks'] >0 && $value['thmarks'] >0)
                    {
                        
                        $pdf->Cell(10,4,'','LRB',0,'C');
                        $pdf->Cell(10,4,'','LRB',0,'C');
                        $pdf->Cell(10,4,'','LRB',0,'C');
                        $pdf->Cell(10,4,'','LRB',0,'C');
                    }

$pdf->Cell(13,4,'','LRB',0,'C');
                    $pdf->Cell(13,4,'','LRB',0,'C');
                    $pdf->Cell(10,4,'','LRB',0,'C');
                    $pdf->Cell(22,4,'','LRB',1,'C');

}else
                {
                    $pdf->Cell(7,7,$count,'LRBT',0,'C');			
                    $pdf->Cell(20,7,$value['fregno'],'LRBT',0,'C');
                    $pdf->Cell(35,7,$value['fname1'],'LRBT',0,'L');
                    $pdf->Cell(10,7,$value['conducted'],'LRBT',0,'C');
                    $pdf->Cell(10,7,$value['attend'],'LRBT',0,'C');
                    
                    $na = "";

foreach(explode('*',$value['markslist']) as $re)
                    { 
                        $pdf->Cell(14,7,$re,'LRBT',0,'C'); 
                    }    
                    
                    if($value['prmarks'] >0 && $value['thmarks']>0)
                    {
                        $pdf->Cell(10,7,$value['th'],'LRBT',0,'C');
                        $pdf->Cell(10,7,$value['pr'],'LRBT',0,'C');
                        $pdf->Cell(10,7,$value['thmarks'],'LRBT',0,'C');
                        $pdf->Cell(10,7,$value['prmarks'],'LRBT',0,'C');
                        if(((($value['prmarks']/20)*100) < '40') || ((($value['thmarks']/30)*100) < '40'))
                            $na = "NE";
                    }

$pdf->Cell(13,7,$value['totmarks'],'LRBT',0,'C');
                    $pdf->Cell(13,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";
                    }
                    $pdf->Cell(10,7,$na,'LRBT',0,'C');
                    $pdf->Cell(22,7,'','LRBT',1,'C'); 	
                }       
            
                $count++;
                $z++;  
            }
            else{
                 $pdf->SetFont('Times', '', 10);
            if($college == '1002'){
                if($totheader <5)
                        $pdf->Cell(15,4,'','',0,'C'); 
            }
             if($value['fname2'] != '') 
             {
                $pdf->Cell(10,4,$count,'LRT',0,'C');			
                $pdf->Cell(25,4,$value['fregno'],'LRT',0,'C');
                $pdf->Cell(46,4,$value['fname1'],'LRT',0,'L');
                $pdf->Cell(14,4,$value['conducted'],'LRT',0,'C');
                $pdf->Cell(14,4,$value['attend'],'LRT',0,'C');
                
                foreach(explode('*',$value['markslist']) as $re)
                { 
                    $pdf->Cell(19,4,$re,'LRT',0,'C'); 
                }    
                $pdf->Cell(18,4,$value['totmarks'],'LRT',0,'C');
                $pdf->Cell(18,4,number_format((float)ceil($value['totmarks']),2),'LRT',0,'C');
                $pdf->Cell(30,4,'','LRT',1,'C');
                if($college == '1002'){
                    if($totheader <=5)
                        $pdf->Cell(15,4,'','',0,'C'); 
                }
                $pdf->Cell(10,4,'','LRB',0,'C');			
                $pdf->Cell(25,4,'','LRB',0,'C');
                $pdf->Cell(46,4,$value['fname2'],'LRB',0,'L');
                $pdf->Cell(14,4,'','LRB',0,'C');
                $pdf->Cell(14,4,'','LRB',0,'C');
                
                foreach(explode('*',$value['markslist']) as $re)
                { 
                    $pdf->Cell(19,4,'','LRB',0,'C'); 
                }
                
                $pdf->Cell(18,4,'','LRB',0,'C');
                $pdf->Cell(18,4,'','LRB',0,'C');
                $pdf->Cell(30,4,'','LRB',1,'C');

}else
             {
                $pdf->Cell(10,7,$count,'LRBT',0,'C');			
                $pdf->Cell(25,7,$value['fregno'],'LRBT',0,'C');
                $pdf->Cell(46,7,$value['fname1'],'LRBT',0,'L');
                $pdf->Cell(14,7,$value['conducted'],'LRBT',0,'C');
                $pdf->Cell(14,7,$value['attend'],'LRBT',0,'C');
                
                foreach(explode('*',$value['markslist']) as $re)
                { 
                    $pdf->Cell(19,7,$re,'LRBT',0,'C'); 
                }    
                $pdf->Cell(18,7,$value['totmarks'],'LRBT',0,'C');
                $pdf->Cell(18,7,number_format((float)ceil($value['totmarks']),2),'LRBT',0,'C');
                $pdf->Cell(30,7,'','LRBT',1,'C'); 	
             }       
            
            $count++;
            $z++;  
            }
        }

$pdf->SetFont('Times', 'B', 10);
        $pdf->ln(15);
        $pdf->Cell(25,4,"        Name and Signature of Faculty",'0',0,'L');
        $pdf->Cell(0,4,"Signature of the H.O.D/Principal                          ",'0',1,'R');
           
    }
	$pdf->Output("nitteIaMarksSubjectWise.pdf","I");

}
?>

${this.title}

Code Editor : markListReportPdf.php