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

<?php

function printMarkListSubWiseJssstu($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'];
    $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'];
    //var_dump($teachcode);
    //die();
    $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.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 ifnull(fdactive,'F') <> 'T'
                    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 = ", ifnull(a1.attend, '-') as attend,ifnull(a1.conducted, '-')as 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')
        {

$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, s.fmtype,
                            GROUP_CONCAT(concat($cod right(concat(if(ifnull(m.fmarks,'-1.00') = '-1.00','-',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, FTOTC as conducted, FTOTA 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(s.fdactive,'F') <> 'T'
                            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);                
            // die();
        }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)";
        }
        // var_dump($get_subwise);
        // die();
        $res2 = $aobj_context->mobj_db->GetAll($get_subwise);

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

// var_dump($value);
            // die();
             
            if($z == 14 || $first){
                $first = false;
                
                $pdf->SetMargins(3,10);
                $pdf->AddPage('L');    
                //var_dump($FUNIVCODE);
                if($FUNIVCODE == '049' || $FUNIVCODE == '098')
                {
                    if (file_exists($img_path)) {
                        if($FUNIVCODE == '098')
                            $pdf->Image($img_path,115, 2, 30);
                        else
                            $pdf->Image($img_path,135, 2, 25);
                    }
                }else
                {

if (file_exists($img_path)) {
                        $pdf->Image($img_path, 30, 2, 25,15);
                    }
                    
                }

$pdf->SetFont('Times', 'B', 16);
                if($FUNIVCODE != '052')
                    $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);
                $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" && $_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($totheader <5)
                        $pdf->Cell(15,4,'','',0,'C'); 
                    $pdf->SetFont('Times', 'B', 9);
                    $pdf->Cell(10,4,'Sl.','LRT',0,'C');
                    $pdf->Cell(27,4,'USN','LRT',0,'C');
                    $pdf->Cell(46,4,'Name','LRT',0,'C');

// if($FUNIVCODE != '052'){
                    $pdf->Cell(14,4,'Classes','LRT',0,'C');										
                    $pdf->Cell(14,4,'Classes','LRT',0,'C');
                    if($FUNIVCODE == "052")
                        $pdf->Cell(16,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'){
                            $pdf->Cell(15,4,$ssub['fssubname'],'LRT',0,'C');
                        }else{
                            $pdf->Cell(15,4,$ssub,'LRT',0,'C');
                        }
                        
                    }
                    
                    $pdf->Cell(16,4,'Total','LRT',0,'C');
                    $pdf->Cell(16,4,'Grand','LRT',0,'C');
                    if($FUNIVCODE != '052')
                        $pdf->Cell(10,4,'NE','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(27,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');
                    
                    if($FUNIVCODE == "052")
                        $pdf->Cell(16,4,'%','LRB',0,'C');

if($FUNIVCODE != '052'){
                        $subList = $res1;
                    }else{
                       $newSub = $res2[0]['sublist'];
                        $subList = explode("*", $newSub);
                    }
                    foreach($subList as $ssub)
                    {
                        $pdf->Cell(15,4,"",'LRB',0,'C');
                    }
                    $pdf->Cell(16,4,'','LRB',0,'C'); 
                    $pdf->Cell(16,4,'Total','LRB',0,'C');
                    if($FUNIVCODE != '052')
                        $pdf->Cell(10,4,'','LRB',0,'C');
                    $pdf->Cell(30,4,'Signature','LRB',1,'C');
                    $z=0; 
       
                
            }

$pdf->SetFont('Times', '', 10);
         
                 if($value['fname2'] !==''){
                    $cond='LRT';
                 }else{
                    $cond=1;
                 }
                if($totheader <5)
                    $pdf->Cell(15,4,'','',0,'C'); 
                $pdf->Cell(10,7,$count,$cond,0,'C');			
                $pdf->Cell(27,7,$value['fregno'],$cond,0,'C');
                $pdf->Cell(46,7,$value['fname1'],$cond,0,'L');
               
                
                // if($FUNIVCODE != '052'){
                    $pdf->Cell(14,7,$value['conducted'],$cond,0,'C');
                    $pdf->Cell(14,7,$value['attend'],$cond,0,'C');
                    if($FUNIVCODE == "052"){
                        $per = $value['attend'] /$value['conducted'] * 100;
                        $pdf->Cell(16,7,round($per,2),$cond,0,'C');
                    }
                // }

if($FUNIVCODE != "052"){
                    foreach(explode('*',$value['markslist']) as $re)
                    { 
                        $pdf->Cell(15,7,$re,'LR',0,'C'); 
                    }
                }else
                {
                    $test1 = "";
                    $test2 = "";
                    $test3 = "";
                    $makeup = "";
                    $event = "";
                    $event1 = "";
                    $event2 = "";
                    $test1marks = 0;
                    $test2marks = 0;
                    $test3marks = 0;
                    $makeupmarks = 0;
                    $eventmarks = 0;
                    $event1marks = 0;
                    $event2marks = 0;
                    
                    $split = explode('*',$value['markslist']);
                    // var_dump($value);
                    $istest3 = false;
                    if(strpos($value['markslist'],"Test 3"))
                    {
                        $istest3 = true;
                    }
                    
                    foreach($split as $val){
                        $marksSplit = explode('->',$val);
                        $subname = $marksSplit[0];
                        
                            // var_dump($marksSplit);
                            
                       
                        if(trim($subname) === "Test 1"){
                                $test1 = $subname;
                                $test1marks = $marksSplit[1];
                            }else if(trim($subname) === "Test 2"){
                                $test2 = $subname;
                                $test2marks = $marksSplit[1];
                            }else if(rtrim($subname) === "Test 3"){
                                $test3 = $subname;
                                $test3marks = $marksSplit[1];
                                //$test3marks = $marksSplit[1] === "0.00" ? "test 3": $marksSplit[1];
                            }else if(trim($subname) === "Makeup"){
                                $makeup = $subname;
                                $makeupmarks = $marksSplit[1];
                            }else if(trim($subname) === "Event"){
                                $event = $subname;
                                $eventmarks = $marksSplit[1];
                            }else if(trim($subname) === "Event 1"){
                                $event1 = $subname;
                                $event1marks = $marksSplit[1];
                            }else if(trim($subname) === "Event 2"){
                                $event2 = $subname;
                                $event2marks = $marksSplit[1];
                            } 
                            
                            if($marksSplit[1] == -2){
                                $mark = "AB";
                            }else{
                                $mark = $marksSplit[1];
                            }
                            $pdf->Cell(15,7,$mark,$cond,0,'C');

}
                    
                }

$test1 = 0;
                    $test2 = 0;
                    $test3 = 0;
                    $tot3 = 0;
                    $tot2 = 0;
                    
                    if($istest3)
                    {
                        $tot = [];
                        $test1marks = $test1marks === "-2.00" ? "0": $test1marks;
                        $test2marks = $test2marks === "-2.00" ? "0": $test2marks;
                        $test3marks = $test3marks === "-2.00" ? "0": $test3marks;
                        $makeupmarks = $makeupmarks === "-2.00" ? "0": $makeupmarks;
                        array_push($tot,$test1marks);
                        array_push($tot,$test2marks);
                        array_push($tot,$test3marks);
                        array_push($tot,$makeupmarks);
                        $tot3 = (($test1marks+$test2marks+$test3marks+$makeupmarks)-min($tot));
                        
                        //$tot = (int)$test1marks.','.(int)$test2marks.','.(int)$test1marks.','.(int)$makeupmarks;
                        
                    }else 
                    {
                        $tot = [];
                        $test1marks = $test1marks === "-2.00" ? "0": $test1marks;
                        $test2marks = $test2marks === "-2.00" ? "0": $test2marks;
                        $makeupmarks = $makeupmarks === "-2.00" ? "0": $makeupmarks;
                        array_push($tot,$test1marks);
                        array_push($tot,$test2marks);
                        array_push($tot,$makeupmarks);
                        $tot2 = (($test1marks+$test2marks+$makeupmarks)-min($tot));
                    }

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

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

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

if($istest3)
                    {
                        $total = $tot3 + $event1marks + $event2marks;
                        
                        $cond = 2;
                    }else
                    {
                        $total = $tot2 + $eventmarks;
                        $cond = 2;
                    }

if($value['fname2'] !==''){
                        $bcond='LRT';
                    }else{
                        $bcond=1;
                    }
                    
                    
                    if($subname !== "CIE" && $subname !== "Assessment"){
                        $pdf->Cell(16,7,$total,$bcond,0,'C');
                        if($value['fmtype'] == "D"){
                            $pdf->Cell(16,7,round($total),$bcond,0,'C');
                        }else{
                            $pdf->Cell(16,7,ceil(number_format((float)ceil($total),2) / $cond),$bcond,0,'C');   
                        }
                    }else{
                        $pdf->Cell(16,7,$value['totmarks'],$bcond,0,'C');
                        $pdf->Cell(16,7,ceil(number_format((float)ceil($value['totmarks']),2)),$bcond,0,'C');
                    }
             
                $na = "";

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

if($FUNIVCODE != '052')
                    $pdf->Cell(10,7,$na,'LRBT',0,'C');

$pdf->Cell(30,7,'',$bcond,1,'C');

if($value['fname2'] !==''){

if($count % 14 == 0 || $rescount == $count){
                        $cond = 'LRB';
                    }else{
                        $cond = 'LR';
                    }

if($totheader <5){
                        $pdf->Cell(15,4,'','',0,'C'); 
                     }
                    $pdf->Cell(10,7,'',$cond,0,'C');			
                    $pdf->Cell(27,7,'',$cond,0,'C');               
                    $pdf->Cell(46,7,$value['fname2'],$cond,0,'L');
                    $pdf->Cell(14,7,'',$cond,0,'C');
                    $pdf->Cell(14,7,'',$cond,0,'C');
                    $pdf->Cell(16,7,'',$cond,0,'C');
                     if(strpos($value['markslist'],"Test 3"))
                    {
                        $istest3 = true;
                    }
                    
                    foreach($split as $val){
                        $pdf->Cell(15,7,'',$cond,0,'C');     
                    }
                    if($subname !== "CIE" && $subname !== "Assessment"){
                        $pdf->Cell(16,7,'',$cond,0,'C');
                        $pdf->Cell(16,7,'',$cond,0,'C');
                    }else{
                        $pdf->Cell(16,7,'',$cond,0,'C');
                        $pdf->Cell(16,7,'',$cond,0,'C');
                    }
                    
                    $pdf->Cell(30,7,'',$cond,1,'C');

}

// }       
            
            $count++;
            $z++;  
            //}
            
        }
        if(count($res2) != 0){
            $pdf->SetFont('Times', 'B', 10);
            $pdf->ln(15);
            $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
                $pdf->Cell(0,4,"Signature of the H.O.D/Principal                          ",'0',1,'R');
        }
    }
    
	$pdf->Output("MarksList.pdf","I");

}
?>

${this.title}

Code Editor : printMarkListSubWiseJssstu.php