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.153.31
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 /
tdvsreports /
[ HOME SHELL ]
Name
Size
Permission
Action
DYPIndent.php
6.77
KB
-rw-rw-r--
TDVSValuationReport.php
8.73
KB
-rw-rw-r--
generatebill.php
29.55
KB
-rw-r--r--
generatebillDownload.php
18.18
KB
-rw-rw-r--
generatebill_acu.php
24.14
KB
-rw-r--r--
generatebill_new.php
28.88
KB
-rw-r--r--
generatetadabill.php
18.4
KB
-rw-r--r--
generateworkdonereport.php
19.84
KB
-rw-r--r--
generateworkdonereport_gcg.php
19.35
KB
-rw-r--r--
getPanelViewReport.php
40
KB
-rw-r--r--
getPanelViewReportExcel.php
10.13
KB
-rw-r--r--
getQpStatsReport.php
41.58
KB
-rw-rw-r--
getnumword.php
7.45
KB
-rwxr-xr-x
photocopydownload.php
15.53
KB
-rw-rw-r--
qppatternreport.php
9.59
KB
-rw-r--r--
revaluationReport.php
19.03
KB
-rw-rw-r--
reviewercodeData.php
34.18
KB
-rw-rw-r--
tdvsDecodeReport.php
8.38
KB
-rw-rw-r--
tdvsDecodeReportExcel.php
6.72
KB
-rw-rw-r--
tdvsQpPatranTest.php
10.25
KB
-rw-r--r--
tdvs_TeachValReport.php
14.06
KB
-rw-rw-r--
tdvs_TeachWiseValReport.php
37.71
KB
-rw-rw-r--
tdvs_deviationdet.php
9.19
KB
-rw-rw-r--
tdvs_getQpNotStartedReprot.php
7.28
KB
-rw-rw-r--
tdvs_studentMarksReport.php
18.24
KB
-rw-rw-r--
tdvs_studentMarksReportCOWise....
15.84
KB
-rw-rw-r--
tdvs_studentMarksReportNew.php
11.64
KB
-rw-r--r--
tdvsmarkslist.php
34.84
KB
-rw-rw-r--
teachersList.php
15.47
KB
-rw-rw-r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : DYPIndent.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); ini_set('max_execution_time', 300); ini_set('memory_limit', '512M'); 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); // Redirect output to a client’s web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="' . $fileName . '.CSV"'); 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_clean(); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV'); $objWriter->save('php://output'); } function DYPIndent($aobj_context) { $objPHPExcel = new PHPExcel(); $univcode = $aobj_context->mobj_data["univcode"]; $fileName = 'QP Indent'; $objPHPExcel->getProperties()->setCreator("Me") ->setLastModifiedBy("Me")->setTitle("My Excel Sheet") ->setSubject("My Excel Sheet")->setDescription("Excel Sheet") ->setKeywords("Excel Sheet")->setCategory("Me"); // 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); $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() ->setCellValue('A1', 'Exam Date') ->setCellValue('B1', 'Session') ->setCellValue('C1', 'School Code') ->setCellValue('D1', 'School Name') ->setCellValue('E1', 'Program Code') ->setCellValue('F1', 'Program Name') ->setCellValue('G1', 'Exam No') ->setCellValue('H1', 'Subject Code') ->setCellValue('I1', 'Qpcode') ->setCellValue('J1', 'Course Name') ->setCellValue('K1', 'Course Code') ->setCellValue('L1', 'Subject Type') ->setCellValue('M1', 'Student Count') ->setCellValue('N1', 'Student Received') ->setCellValue('O1', 'Signature'); $j = 3; $slNo = 1; $sum = array(); // $query = "select mt.fteachcode, fteachname, mt.fmobile, ifnull(fboardcode,'xxx') as fboard1 // from masteach mt left join teachsub ts on mt.fteachcode = ts.fteachcode // left join masqp mq on ts.fqpcode = mq.fqpcode left join // masboard mb on mq.fboard = mb.fboardcode // where mt.fcollcode between '0000' and 'zzzz' // and ifnull(fboardcode,'000000') between '0000' and 'zzzz' // group by fteachcode // order by mt.fcollcode, fboardcode, fteachcode"; //$univcode = $aobj_context->mobj_data["fdeggrp"]; $fdatefrom = $aobj_context->mobj_data["fdatefrom"]; $fdateto = $aobj_context->mobj_data["fdateto"]; // $fdeggrp = $aobj_context->mobj_data["fdeggrp"]; //#and fackdate between '{$fdatefrom}' and '{$fdateto}' $query ="select s.fdoe as fdate, r.fdescpn as fsession, c.fcollcode as college, cl.fcollname as name,c.fdegree as degree,g.fdescpn as descp ,c.fexamno as exam,s.fcsubcode as subcode,s.FQPCODE as qpcode, concat(s.fmarkdesc1,s.fmarkdesc2) as fsubname,s.fsubshort as short,s.fssubname as subtype, count(c.fregno) as count from subject s,canddet c,candsum d,degree g, college cl, reason r where s.fdegree=c.fdegree and s.fsubcode=c.fsubcode and ifnull(c.fpassmth,'')='' and ifnull(c.fpresent,'')='P' and c.fregno=d.fregno and ifnull(d.frecptdate,'')<>'' and r.freasoncd = s.fsession and c.fdegree like '%' and c.fdegree=g.fdegree and c.fexamno=g.fexamno and c.fcollcode = cl.fcollcode and d.fcollcode =cl.fcollcode and ifnull(s.fqpcode,'') <> '' and s.fdoe between date_format(str_to_date('{$fdatefrom}','%d/%m/%Y'),'%Y-%m-%d') and date_format(str_to_date('{$fdateto}','%d/%m/%Y'),'%Y-%m-%d') group by fdate, fsession, college, name, degree, descp , exam, subcode, qpcode, fsubname, short order by s.fdoe, r.fdescpn, c.fcollcode,cl.fcollname,c.fdegree,c.fexamno,s.fcsubcode,s.fqpcode;"; $result = $aobj_context->pobj_db->GetAll($query); $i = 2; $totamt=0; foreach ($result as $key => $value) { $objPHPExcel->getActiveSheet() ->setCellValue('A' . $i, $value["fdate"]); $objPHPExcel->getActiveSheet() ->setCellValue('B' . $i, $value["fsession"]); $objPHPExcel->getActiveSheet() ->setCellValue('C' . $i, $value["college"]); $objPHPExcel->getActiveSheet() ->setCellValue('D' . $i, $value["name"]); $objPHPExcel->getActiveSheet() ->setCellValue('E' . $i, $value["degree"]); $objPHPExcel->getActiveSheet() ->setCellValue('F' . $i, $value["descp"]); $objPHPExcel->getActiveSheet() ->setCellValue('G' . $i, $value['examno']); $objPHPExcel->getActiveSheet() ->setCellValue('H' . $i, $value["subcode"]); $objPHPExcel->getActiveSheet() ->setCellValue('I' . $i, $value["qpcode"]); $objPHPExcel->getActiveSheet() ->setCellValue('J' . $i, $value["fsubname"]); $objPHPExcel->getActiveSheet() ->setCellValue('K' . $i, $value["short"]); $objPHPExcel->getActiveSheet() ->setCellValue('L' . $i, $value["subtype"]); $objPHPExcel->getActiveSheet() ->setCellValue('M' . $i, $value["count"]); $i++; } getheaders($objPHPExcel, $fileName); }
Close