Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.144.23.138
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
oasis /
Report_details /
[ HOME SHELL ]
Name
Size
Permission
Action
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--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : markListReportPdfnew_24112023.php
<?php function printMarkListSubWisenew($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 if(s.fqnno = '1',sum(s.fu1max),sum((s.fu1max+s.fu2max))) as maxmarks 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']; 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 =""; 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 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') { $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)"; // var_dump($get_subwise); // die(); }else{ $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,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 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); $count = 1; $z=0; foreach($res2 as $value) { // if($value['fregno'] === "NNM22CS001") // var_dump($value); // die(); if($z == 15 || $first){ $first = false; $pdf->SetMargins(3,10); $pdf->AddPage('L'); if($FUNIVCODE == '052') { if (file_exists($img_path)) { $pdf->Image($img_path, 30, 2, 25,15); } }else { if (file_exists($img_path)) { $pdf->Image($img_path, 115, 2, 60); } } $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: '.$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' && $FUNIVCODE != '052') { $pdf->SetFont('Times', '', 8); if($totheader<6) $pdf->Cell(15,4,'','',0,'C'); $pdf->Cell(7,4,'Sl.','LRT',0,'C'); $pdf->Cell(22,4,'USN','LRT',0,'C'); $pdf->Cell(35,4,'Name','LRT',0,'C'); if($FUNIVCODE != '052') { $pdf->Cell(10,4,'Classes','LRT',0,'C'); $pdf->Cell(10,4,'Classes','LRT',0,'C'); } if($FUNIVCODE == '052'){ foreach($res1 as $ssub) { $pdf->Cell(20,4,$ssub['fssubname'],'LRT',0,'C'); } }else{ foreach($res1 as $ssub) { if(strlen($ssub['fssubname']) <= 6){ $pdf->Cell(12,4,$ssub['fssubname'],'LRT',0,'C'); }else{ $pdf->Cell(18,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'); if($FUNIVCODE != '052') $pdf->Cell(10,4,'NE','LRT',0,'C'); $pdf->Cell(22,4,'Student','LRT',1,'C'); if($totheader<6) $pdf->Cell(15,4,'','',0,'C'); $pdf->Cell(7,4,'No.','LRB',0,'C'); $pdf->Cell(22,4,'','LRB',0,'C'); $pdf->Cell(35,4,'','LRB',0,'C'); if($FUNIVCODE != '052') { $pdf->Cell(10,4,'Held','LRB',0,'C'); $pdf->Cell(10,4,'Attend','LRB',0,'C'); } if($FUNIVCODE == '052'){ foreach($res1 as $ssub) { $pdf->Cell(20,4,"",'LRB',0,'C'); } }else { foreach($res1 as $ssub) { if(strlen($ssub['fssubname']) <= 6){ $pdf->Cell(12,4,"",'LRB',0,'C'); }else{ $pdf->Cell(18,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'); if($FUNIVCODE != '052') $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(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'); // if($FUNIVCODE != '052'){ $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; } } if($college == '1001' && $FUNIVCODE != '052') { $pdf->SetFont('Times', '', 8); if($value['fname2'] != '') { if($totheader<6) $pdf->Cell(15,4,'','',0,'C'); $pdf->Cell(7,4,$count,'LRT',0,'C'); $pdf->Cell(22,4,$value['fregno'],'LRT',0,'C'); $pdf->Cell(35,4,$value['fname1'],'LRT',0,'L'); if($FUNIVCODE != '052') { $pdf->Cell(10,4,$value['conducted'],'LRT',0,'C'); $pdf->Cell(10,4,$value['attend'],'LRT',0,'C'); // $pdf->Cell(10,4,$value['attend'],'LRT',0,'C'); } if($FUNIVCODE == '052'){ foreach(explode('*',$value['markslist']) as $re) { $pdf->Cell(20,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(12,4,$re,'LR',0,'C'); } else{ $pdf->Cell(18,4,$re,'LR',0,'C'); } } $j++; } $i++; } } $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"; } if(ceil($value['attend']/$value['conducted']*100)<75) $na = "NE"; if($FUNIVCODE != '052') $pdf->Cell(10,4,$na,'LRT',0,'C'); $pdf->Cell(22,4,'','LRT',1,'C'); if($totheader<6) $pdf->Cell(15,4,'','',0,'C'); $pdf->Cell(7,4,'','LRB',0,'C'); $pdf->Cell(22,4,'','LRB',0,'C'); $pdf->Cell(35,4,$value['fname2'],'LRB',0,'L'); if($FUNIVCODE != '052') { $pdf->Cell(10,4,'','LRB',0,'C'); $pdf->Cell(10,4,'','LRB',0,'C'); } if($FUNIVCODE == '052'){ foreach(explode('*',$value['markslist']) as $re) { $pdf->Cell(20,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(12,4,'','LRB',0,'C'); } else{ $pdf->Cell(18,4,'','LRB',0,'C'); } } $j++; } $i++; } } 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'); if($FUNIVCODE != '052') $pdf->Cell(10,4,'','LRB',0,'C'); $pdf->Cell(22,4,'','LRB',1,'C'); }else { if($totheader<6) $pdf->Cell(15,4,'','',0,'C'); $pdf->Cell(7,7,$count,'LRBT',0,'C'); $pdf->Cell(22,7,$value['fregno'],'LRBT',0,'C'); $pdf->Cell(35,7,$value['fname1'],'LRBT',0,'L'); if($FUNIVCODE != '052') { $pdf->Cell(10,7,$value['conducted'],'LRBT',0,'C'); $pdf->Cell(10,7,$value['attend'],'LRBT',0,'C'); } $na = ""; if($FUNIVCODE == '052'){ foreach(explode('*',$value['markslist']) as $re) { $pdf->Cell(20,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(12,7,$re,'LB',0,'C'); } else{ $pdf->Cell(18,7,$re,'LB',0,'C'); } } $j++; } $i++; } } 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"; } // if($value['fregno'] == 'NNM22EE052') // var_dump(ceil($value['attend']/$value['conducted']*100)); if(ceil($value['attend']/$value['conducted']*100)<75) $na = "NE"; if($FUNIVCODE != '052') $pdf->Cell(10,7,$na,'LRBT',0,'C'); $pdf->Cell(22,7,'','LRBT',1,'C'); } $count++; $z++; } else{ $pdf->SetFont('Times', '', 10); // } if($value['fname2'] != '') { if($totheader <5) $pdf->Cell(15,4,'','',0,'C'); $pdf->Cell(10,4,$count,'LRT',0,'C'); $pdf->Cell(27,4,$value['fregno'],'LRT',0,'C'); $pdf->Cell(46,4,$value['fname1'],'LRT',0,'L'); // if($FUNIVCODE != '052') // { // $per = $value['attend'] /$value['conducted'] * 100; // var_dump($per);die(); $pdf->Cell(14,4,$value['conducted'],'LRT',0,'C'); $pdf->Cell(14,4,$value['attend'],'LRT',0,'C'); if($FUNIVCODE == "052"){ $per = $value['attend'] /$value['conducted'] * 100; $pdf->Cell(16,4,round($per,2),'LRT',0,'C'); } // } if($FUNIVCODE != "052"){ foreach(explode('*',$value['markslist']) as $re) { $pdf->Cell(15,7,$re,'L',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(15,7,$mark,'LRT',0,'C'); } } if($FUNIVCODE !="052"){ $pdf->Cell(16,4,$value['totmarks'],'LRT',0,'C'); $pdf->Cell(16,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(16,4,$total,'LRT',0,'C'); $pdf->Cell(16,4,number_format((float)ceil($total),2),'LRT',0,'C'); }else{ $pdf->Cell(16,4,$value['totmarks'],'LRT',0,'C'); $pdf->Cell(16,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 != '052') $pdf->Cell(10,4,$na,'LRT',0,'C'); $pdf->Cell(30,4,'','LRT',1,'C'); if($totheader <5) $pdf->Cell(15,4,'','',0,'C'); $pdf->Cell(10,4,'','LRB',0,'C'); $pdf->Cell(27,4,'','LRB',0,'C'); $pdf->Cell(46,4,$value['fname2'],'LRB',0,'L'); // if($FUNIVCODE != '052') // { $pdf->Cell(14,4,'','LRB',0,'C'); $pdf->Cell(14,4,'','LRB',0,'C'); // } foreach(explode('*',$value['markslist']) as $re) { $pdf->Cell(15,4,'','LRB',0,'C'); } $pdf->Cell(16,4,'','LRB',0,'C'); $pdf->Cell(16,4,'','LRB',0,'C'); if($FUNIVCODE != '052') $pdf->Cell(10,4,"",'LRB',0,'C'); $pdf->Cell(30,4,'','LRB',1,'C'); }else { if($totheader <5) $pdf->Cell(15,4,'','',0,'C'); $pdf->Cell(10,7,$count,'LRBT',0,'C'); $pdf->Cell(27,7,$value['fregno'],'LRBT',0,'C'); $pdf->Cell(46,7,$value['fname1'],'LRBT',0,'L'); // if($FUNIVCODE != '052'){ $pdf->Cell(14,7,$value['conducted'],'LRBT',0,'C'); $pdf->Cell(14,7,$value['attend'],'LRBT',0,'C'); if($FUNIVCODE == "052"){ $per = $value['attend'] /$value['conducted'] * 100; $pdf->Cell(16,4,round($per,2),'LRT',0,'C'); } // } if($FUNIVCODE != "052"){ foreach(explode('*',$value['markslist']) as $re) { $pdf->Cell(15,7,$re,'LR',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(15,7,$mark,'LRBT',0,'C'); } } if($FUNIVCODE !="052"){ $pdf->Cell(16,7,$value['totmarks'],'LRBT',0,'C'); $pdf->Cell(16,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(16,7,$total,'LRBT',0,'C'); $pdf->Cell(16,7,number_format((float)ceil($total),2),'LRBT',0,'C'); }else{ $pdf->Cell(16,7,$value['totmarks'],'LRBT',0,'C'); $pdf->Cell(16,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 != '052') $pdf->Cell(10,7,$na,'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'); 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("nitteIaMarksSubjectWise.pdf","I"); } ?>
Close