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.140.185.250
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 /
admission /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
adm_admin.php
36.49
KB
-rw-r--r--
adm_master.php
14.07
KB
-rw-r--r--
adm_register.php
78.86
KB
-rw-r--r--
adm_session_start.php
893
B
-rw-r--r--
cappcontext.php
4.58
KB
-rw-rw-r--
constants.php
818
B
-rw-rw-r--
coutput.php
1.75
KB
-rw-rw-r--
create_user.php
27.69
KB
-rw-rw-r--
creditMaster.php
2.31
KB
-rwxr-xr-x
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
514
B
-rwxr-xr-x
cuser.php
3.41
KB
-rwxr-xr-x
cuser1.php
3.41
KB
-rwxr-xr-x
customappcontext.php
2.35
KB
-rwxr-xr-x
dailyValuation.php
1.6
KB
-rwxr-xr-x
dashboard.php
3
KB
-rwxr-xr-x
dashboardNew.php
31.05
KB
-rw-r--r--
database.php
744
B
-rw-rw-r--
dateMaster.php
2.83
KB
-rwxr-xr-x
dateupdate.php
8.88
KB
-rw-r--r--
define_heads.php
1.89
KB
-rw-r--r--
degcollege.php
7.32
KB
-rwxr-xr-x
deggrp.php
13.84
KB
-rwxr-xr-x
deggrpNew.php
4.04
KB
-rw-r--r--
degree.php
3.34
KB
-rwxr-xr-x
degreeEntry.php
5.46
KB
-rwxr-xr-x
degreeLoad.php
12.26
KB
-rw-r--r--
dispatchmarkscard.php
19.14
KB
-rwxr-xr-x
drawer.php
552
B
-rw-r--r--
dropDownOptions.php
400
B
-rwxr-xr-x
eGovSignin.php
4.22
KB
-rwxr-xr-x
error_log.php
749
B
-rwxr-xr-x
examAttendance.php
23.9
KB
-rwxr-xr-x
examCntr.php
6.73
KB
-rwxr-xr-x
examCntrdurexm.php
4.05
KB
-rwxr-xr-x
examHappeningCentre.php
19.76
KB
-rwxr-xr-x
examTimetable.php
26.1
KB
-rwxr-xr-x
examTimetableErrorReport.php
7.77
KB
-rwxr-xr-x
exam_app_acknowledge.php
8.41
KB
-rw-r--r--
examapprpt.php
2.9
KB
-rw-r--r--
examattendanceunivadmin.php
19.73
KB
-rwxr-xr-x
exceptionhandler.php
236
B
-rwxr-xr-x
fee-str.php
17.08
KB
-rwxr-xr-x
fee_summary_report.php
43.28
KB
-rwxr-xr-x
fee_summary_report_090120202.p...
43.79
KB
-rwxr-xr-x
finalQp.php
11.07
KB
-rw-r--r--
financeMenuItems.php
1.51
KB
-rw-r--r--
freezeTimetable.php
2.98
KB
-rwxr-xr-x
getBoards.php
1.34
KB
-rwxr-xr-x
getDegSemList.php
7.75
KB
-rwxr-xr-x
getFaculty.php
602
B
-rwxr-xr-x
getMenus.php
3.92
KB
-rwxr-xr-x
getNotifications.php
1.13
KB
-rwxr-xr-x
getPaymentTypes.php
1.77
KB
-rw-rw-r--
getQPdet.php
7
KB
-rw-r--r--
getRvPcReport.php
4.99
KB
-rwxr-xr-x
getStudentRegisteredReport.php
8.91
KB
-rw-r--r--
getUnivName.php
516
B
-rw-r--r--
get_result_table.php
109
B
-rw-r--r--
getdeggrpvalcntr.php
1.88
KB
-rw-r--r--
getinwordstatus.php
3.46
KB
-rw-r--r--
getpgetSavedData.php
4.29
KB
-rwxr-xr-x
getrvpc.php
8.89
KB
-rw-r--r--
getstuddetforrt.php
5.85
KB
-rw-r--r--
getunivs.php
816
B
-rwxr-xr-x
groupMessages.php
9.1
KB
-rwxr-xr-x
grv.php
12.12
KB
-rwxr-xr-x
holidayListing.php
696
B
-rwxr-xr-x
holidayMaster.php
2.11
KB
-rwxr-xr-x
hostNotification.php
1.61
KB
-rwxr-xr-x
htdwonload.php
7.5
KB
-rwxr-xr-x
iNeedHelp.php
3.02
KB
-rwxr-xr-x
iamarkssummary.php
6.25
KB
-rw-r--r--
insertOrEditCollege.php
21.88
KB
-rwxr-xr-x
inward.php
3.09
KB
-rwxr-xr-x
json.php
33.2
KB
-rwxr-xr-x
jwt.php
13.16
KB
-rwxr-xr-x
kswuomr.php
2.8
KB
-rw-r--r--
lastDateUpdate.php
3.95
KB
-rwxr-xr-x
lastDateUpdateCorrection.php
4.81
KB
-rw-r--r--
ledgerview.php
3.2
KB
-rwxr-xr-x
loadclgdettab.php
2.26
KB
-rw-r--r--
loadclgnm.php
1.3
KB
-rw-r--r--
loaddegdet.php
1.45
KB
-rw-r--r--
loaddegreedettab.php
2.49
KB
-rw-r--r--
loadupdclgnm.php
741
B
-rw-r--r--
login.php
1.72
KB
-rwxr-xr-x
loginDet.php
1.04
KB
-rw-r--r--
loginDetails.php
842
B
-rw-r--r--
loginattendance.php
2.21
KB
-rw-r--r--
marks_enter.php
5.74
KB
-rw-r--r--
marksentryupdate.php
4.78
KB
-rw-r--r--
marksmodreport.php
1.49
KB
-rw-r--r--
masQP.php
3.37
KB
-rwxr-xr-x
masterDegree.php
1.16
KB
-rw-r--r--
mcfverify.php
6.65
KB
-rw-r--r--
mpcmanage.php
2.57
KB
-rw-r--r--
mregistry.php
7.59
KB
-rwxr-xr-x
mregistry.php.orig
39.87
KB
-rwxr-xr-x
mregistry_01042021.php
45.75
KB
-rwxr-xr-x
mregistry_arun.php
18.94
KB
-rwxr-xr-x
mregistry_old.php
6.82
KB
-rwxr-xr-x
mregistry_old_03072020.php
33.09
KB
-rwxr-xr-x
mregistry_old_08052020.php
29.86
KB
-rwxr-xr-x
notificationPush.php
9.36
KB
-rwxr-xr-x
oldquestionpaper.php
4.87
KB
-rw-r--r--
omrqnentry.php
8.18
KB
-rw-r--r--
online-test.php
12.77
KB
-rwxr-xr-x
orderReportExcel.php
7.35
KB
-rw-r--r--
paymentReport.php
3.64
KB
-rwxr-xr-x
pgetDashboard.php
0
B
-rwxr-xr-x
pgprevmarks.php
13.41
KB
-rw-r--r--
photoCrop.php
5.57
KB
-rwxr-xr-x
practicalMarks.php
7.09
KB
-rw-r--r--
prbatchdet.php
3.26
KB
-rwxr-xr-x
prifreeze.php
3.11
KB
-rw-r--r--
pushmarks.php
1.18
KB
-rw-r--r--
pushnitification.php
8.1
KB
-rwxr-xr-x
pushnotif_ra.php
3.94
KB
-rwxr-xr-x
qpIndent.php
37.42
KB
-rwxr-xr-x
qpIndent_04032019.php
15.36
KB
-rwxr-xr-x
qpIndent_old.php
37.05
KB
-rwxr-xr-x
qp_dashboard.php
11.31
KB
-rw-r--r--
qp_issue.php
8.46
KB
-rw-r--r--
qp_setter.php
59.66
KB
-rw-r--r--
qp_setter_new.php
53.28
KB
-rw-r--r--
qpboardupdate.php
4.26
KB
-rw-r--r--
qpcrosscheck.php
11.96
KB
-rw-r--r--
qpindentstudlist.php
11.16
KB
-rw-r--r--
qpschemeupload.php
5.84
KB
-rw-r--r--
qpsetterteach.php
22.96
KB
-rw-r--r--
qpsummarynew.php
4.58
KB
-rw-r--r--
qptranlogin.php
1.64
KB
-rw-r--r--
qptranmenu.php
2.22
KB
-rw-r--r--
qpupload.php
8.11
KB
-rwxr-xr-x
qpupload_240621.php
6.49
KB
-rwxr-xr-x
rauspush.php
4.03
KB
-rw-r--r--
razorPayConfig.php
250
B
-rwxr-xr-x
reasonMaster.php
1.73
KB
-rwxr-xr-x
refund.php
2.68
KB
-rwxr-xr-x
register_rrit.php
28.44
KB
-rw-r--r--
releaseTimetable.php
4.73
KB
-rwxr-xr-x
reports_bkp.php
12.25
KB
-rwxr-xr-x
resultStats.php
4.69
KB
-rwxr-xr-x
result_pushnotif_bcu.php
2.33
KB
-rwxr-xr-x
result_pushnotif_bnu.php
2.33
KB
-rwxr-xr-x
result_pushnotif_dud.php
2.33
KB
-rwxr-xr-x
result_pushnotif_kus.php
2.33
KB
-rwxr-xr-x
result_pushnotif_rcub.php
2.33
KB
-rwxr-xr-x
resultdate.php
6.39
KB
-rw-r--r--
resultsApp.php
55
B
-rwxr-xr-x
results_new.php
31.65
KB
-rw-r--r--
resultstat.php
1.72
KB
-rw-r--r--
resultstatsrpt.php
13.82
KB
-rwxr-xr-x
retBatchDet.php
955
B
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
ruaspush.php
618
B
-rw-r--r--
rvMarksEntry.php
4.78
KB
-rwxr-xr-x
rvStatus.php
769
B
-rw-r--r--
rv_result_pushnotif_bcu.php
1.96
KB
-rwxr-xr-x
rvpc.php
1.76
KB
-rw-r--r--
rvrtReport.php
12.39
KB
-rwxr-xr-x
rvrt_Block.php
3.23
KB
-rw-r--r--
rvrtapp.php
22.11
KB
-rw-r--r--
rvrtblock.php
2.97
KB
-rw-r--r--
saveBKMCStdDet.php
2.22
KB
-rw-r--r--
saveBankDetails.php
1.54
KB
-rwxr-xr-x
saveBarcodeDeatils.php
2.87
KB
-rwxr-xr-x
saveDegSemDet.php
14.09
KB
-rwxr-xr-x
saveFinbkmh.php
2.1
KB
-rw-r--r--
savePGETApp.php
4.45
KB
-rwxr-xr-x
savePostNotification.php
2.94
KB
-rwxr-xr-x
scheduleqp.php
2.58
KB
-rw-r--r--
script.php
14.27
KB
-rwxr-xr-x
sdqpmenus.php
163
B
-rw-r--r--
searchregcode.php
5.17
KB
-rw-r--r--
selectFinalQpNew.php
4.69
KB
-rw-r--r--
sendConfMail.php
19.43
KB
-rwxr-xr-x
sendGridMail.php
1.72
KB
-rwxr-xr-x
sendOTP.php
5.51
KB
-rw-r--r--
sendOrder.php
12.33
KB
-rw-r--r--
sendnotification.php
0
B
-rwxr-xr-x
sendsms.php
11.83
KB
-rwxr-xr-x
sendsms_05092020.php
4.34
KB
-rwxr-xr-x
sendsms_15022019.php
6.66
KB
-rwxr-xr-x
sendsms_27012018.php
4.3
KB
-rwxr-xr-x
sendsmsapi.php
802
B
-rwxr-xr-x
sendzohomail.php
1.46
KB
-rw-r--r--
session_start.php
149
B
-rw-r--r--
session_start_rr.php
864
B
-rw-r--r--
sessionmaster.php
1.49
KB
-rw-r--r--
setDGExamTimetableReport.php
19.63
KB
-rwxr-xr-x
setDGExamTimetableReport_bcu_p...
11.51
KB
-rwxr-xr-x
setExamTimetable.php
5.01
KB
-rwxr-xr-x
setExamTimetableReport.php
9.84
KB
-rwxr-xr-x
settlement.php
9.06
KB
-rw-r--r--
sms-new.php
26.55
KB
-rw-r--r--
sms-notification.php
21.17
KB
-rwxr-xr-x
ssp_error_data.php
31.1
KB
-rwxr-xr-x
sspdata-auto-upload.php
11.12
KB
-rwxr-xr-x
sspdata.php
23.9
KB
-rwxr-xr-x
sspdata1.php
11.41
KB
-rw-r--r--
sspdata1_rcub.php
13.96
KB
-rw-r--r--
std_registrtion.php
1.4
KB
-rw-r--r--
studDoc.php
913
B
-rw-r--r--
studReg.php
1.64
KB
-rw-r--r--
stud_ack.php
9.89
KB
-rw-r--r--
stud_det.php
1.62
KB
-rw-r--r--
stud_payments.php
3.24
KB
-rw-rw-r--
student.php
26.71
KB
-rwxr-xr-x
studexamappblock.php
1.18
KB
-rw-r--r--
studymaterial.php
3.07
KB
-rwxr-xr-x
subject.php
2.42
KB
-rwxr-xr-x
subjectEntryScrn.php
8
KB
-rwxr-xr-x
subjectFreeze.php
4.91
KB
-rw-r--r--
sublisting.php
2.39
KB
-rw-r--r--
tdvsCreatePanel.php
1.26
KB
-rw-r--r--
tdvsQPteach.php
2.17
KB
-rw-r--r--
tdvsViewStatus.php
3.52
KB
-rw-r--r--
tdvs_Deviation.php
8.61
KB
-rw-r--r--
tdvs_batch.php
5.89
KB
-rw-r--r--
tdvs_createuser.php
6.5
KB
-rw-r--r--
tdvs_dashboard.php
3.58
KB
-rw-r--r--
tdvs_mail.php
5.93
KB
-rw-r--r--
tdvs_pergeval.php
11.55
KB
-rw-r--r--
tdvs_register.php
1.57
KB
-rw-r--r--
tdvs_saveRecieveQPCount.php
3.53
KB
-rwxr-xr-x
tdvs_saveScript.php
11.74
KB
-rw-r--r--
tdvs_script_cross_check.php
9.35
KB
-rw-r--r--
tdvs_stats.php
21.48
KB
-rw-r--r--
tdvs_subject.php
4.45
KB
-rw-r--r--
tdvs_subjectcreate.php
6.11
KB
-rw-r--r--
tdvs_teacher_valdet.php
2.87
KB
-rw-r--r--
tdvs_teacherpanel.php
3.38
KB
-rw-r--r--
tdvs_teachval.php
1.88
KB
-rw-r--r--
tdvs_teachwisevaldet.php
3.28
KB
-rw-r--r--
tdvs_valcenter.php
2.84
KB
-rw-r--r--
tdvs_verifyqppattern.php
1.03
KB
-rw-r--r--
tdvsdecoding.php
34.16
KB
-rw-r--r--
teachReport.php
5.27
KB
-rwxr-xr-x
teachValBill.php
990
B
-rwxr-xr-x
teachcoderange.php
1.71
KB
-rw-r--r--
teacherEmail.php
20.45
KB
-rw-r--r--
teacherEntry.php
67.04
KB
-rw-r--r--
teacherid.php
2
KB
-rw-r--r--
teachval.php
8.56
KB
-rwxr-xr-x
teachvaluationcount.php
21.07
KB
-rw-r--r--
teachworkapi.php
2.37
KB
-rwxr-xr-x
teachworksum.php
2.42
KB
-rwxr-xr-x
timetablesownload.php
9.98
KB
-rwxr-xr-x
timetablesownload_29062019.php
10.51
KB
-rwxr-xr-x
ttUpload.php
2.5
KB
-rwxr-xr-x
uChangeEmail.php
4.38
KB
-rwxr-xr-x
uChangeMobNum.php
5.17
KB
-rwxr-xr-x
uChangeRegNum.php
4.04
KB
-rwxr-xr-x
uDegPassCrit.php
1.32
KB
-rwxr-xr-x
uDeleteSpecificCollege.php
611
B
-rwxr-xr-x
uExamApplication.php
907
B
-rwxr-xr-x
uExamApplicationForm.php
30.97
KB
-rwxr-xr-x
uForgotPws.php
4.85
KB
-rwxr-xr-x
uGetDetailResult.php
2.17
KB
-rwxr-xr-x
uGetExamCenter.php
1.04
KB
-rwxr-xr-x
uGetResult.php
26.94
KB
-rwxr-xr-x
uGetResultSemester.php
896
B
-rwxr-xr-x
uGetSpecificCollege.php
1.43
KB
-rwxr-xr-x
uGrievances.php
2.97
KB
-rwxr-xr-x
uHallticket.php
5.33
KB
-rwxr-xr-x
uIAMarks.php
3.41
KB
-rwxr-xr-x
uINeedHelp.php
2.82
KB
-rwxr-xr-x
uInsertOrUpdateCollegeDetails....
2.42
KB
-rwxr-xr-x
uMenu_new.php
2.27
KB
-rwxr-xr-x
uNotification.php
3.1
KB
-rwxr-xr-x
uOldQuestionPaper.php
3.46
KB
-rwxr-xr-x
uPracticaltt.php
2.41
KB
-rwxr-xr-x
uProfile.php
1.27
KB
-rwxr-xr-x
uRegistration.php
16.86
KB
-rwxr-xr-x
uRevaluation.php
26.39
KB
-rwxr-xr-x
uRvAppStatus.php
2.42
KB
-rwxr-xr-x
uSubjectList.php
1.53
KB
-rwxr-xr-x
uSupport.php
1023
B
-rwxr-xr-x
uTheorytt.php
2.5
KB
-rwxr-xr-x
uansbookdet.php
2.85
KB
-rwxr-xr-x
uansbookdet0.php
11.83
KB
-rwxr-xr-x
uansbookupdate.php
1.29
KB
-rwxr-xr-x
ulogin.php
2.54
KB
-rwxr-xr-x
ultRoomDet.php
1.96
KB
-rw-r--r--
umenu.php
1.07
KB
-rwxr-xr-x
uniAttEntry.php
1.03
KB
-rw-r--r--
uniContctFrom.php
1.29
KB
-rwxr-xr-x
univRefund.php
9.81
KB
-rwxr-xr-x
unotification.php
3.1
KB
-rwxr-xr-x
upcomingnotification.php
4.55
KB
-rw-r--r--
updateIAMarks.php
1.42
KB
-rw-r--r--
updateRvPcChkList.php
1.13
KB
-rwxr-xr-x
update_dates.php
11.89
KB
-rw-r--r--
upload-sms-excel.php
3.58
KB
-rwxr-xr-x
uploadAnsBook.php
3.38
KB
-rwxr-xr-x
uploadCodeSlips.php
4.1
KB
-rw-r--r--
uploadData.php
6.24
KB
-rwxr-xr-x
uploadDummy.php
761
B
-rw-r--r--
uploadMCdetails.php
4.17
KB
-rw-r--r--
uploadMultipleFiles.php
3.99
KB
-rwxr-xr-x
uploadSSPData.php
5.9
KB
-rw-r--r--
uploadSSPData_bonf.php
11.86
KB
-rw-r--r--
upload_ans_book.php
5.25
KB
-rwxr-xr-x
upload_qp.php
1.85
KB
-rw-r--r--
upload_sms_file.php
7.94
KB
-rw-rw-r--
uploadbackup.php
5.16
KB
-rw-r--r--
uploadcorr_qp.php
4.74
KB
-rw-r--r--
uploadcorrdoc.php
4.09
KB
-rw-r--r--
uploadpwd.php
1.92
KB
-rw-r--r--
uploadqp.php
6.43
KB
-rw-r--r--
uploadqpMultipleFiles.php
678
B
-rw-r--r--
uploadscripts.php
333
B
-rw-r--r--
utils.php
4.19
KB
-rw-r--r--
uucmsdecoding.php
1.86
KB
-rw-r--r--
valuatordet.php
3.29
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : examattendanceunivadmin.php
<?php $main_src=substr($_SERVER['SCRIPT_FILENAME'],0,strlen($_SERVER['SCRIPT_FILENAME'])-7); //$pdf_writer_class =$main_src."/tarka_pdf/fpdf.php"; $pdf_writer_class =$main_src."/tcpdf/tcpdf.php"; require_once($pdf_writer_class); // ini_set('memory_limit','900M'); // ini_set('max_execution_time',0); class MYPDF extends TCPDF { public $aobj_context; public function setData($aobj_context,$sessionfull){ $this->aobj_context = $aobj_context; $this->doe = $aobj_context->mobj_data["doe"]; $this->sessionfull = $sessionfull; $this->reportType = $aobj_context->mobj_data["reportType"]; $this->qprngfrom = $aobj_context->mobj_data["qprngfrom"]; $this->qprngto = $aobj_context->mobj_data["qprngto"]; $fdeggrp = $aobj_context->mobj_data["dgp"]; } 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); // set bacground image // $Degree = $aobj_context->mobj_data["deggrp"]; // $this->SetMargins(6,30,5,true); $this->SetFillColor(248, 248 ,255); $img_path = $this->aobj_context->main_src."/img/logo.jpg"; if(file_exists($img_path)) $this->Image($img_path,6,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,' Exam Attendance List - '.$this->reportType,'0',1,'C'); $this->SetFont('Times','',12); $this->Cell(0,6," Date Of Exam : ".$this->doe,"0",1,"C"); $this->Cell(0,6,"Exam Session : ".$this->sessionfull, "0",1,"C"); $this->Cell(0,6," QPcode Range : ".$this->qprngfrom." - ".$this->qprngto,"0",0,"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); $this->Cell(90, 10,'IP : '.$_SERVER["REMOTE_ADDR"], 0, 0, 'L'); $this->Cell(100, 10,'Date : '.date("d-m-Y "), 0, 0, 'C'); $this->Cell(90, 10,'Page ' .$this->getPageNumGroupAlias().'/'.$this->getPageGroupAlias(), 0, 1, 'R'); } } class ExamAttendance { function DefaultConstructor($aobj_context,$qprngfrom,$qprngto,$doe,$sessionfull,$reportType) { $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); $db = $this->db; $this->reportType = $reportType; $get_coll_name="select FUNIVNAME as 'FUNIVNAME',FUNIVCODE, FUNIVADD1 as 'state', pdf_logo_path, ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From {$db}.control"; $lobj_get_coll_name=$this->aobj_context->mobj_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']; $this->pdf= new MYPDF('L'); $this->pdf->setData($aobj_context,$sessionfull); } function tableHeader($pdf) { $pdf->SetFont('Times','B',10); if($this->reportType == 'Center Wise'){ $pdf->Cell(8,6,"Sl.","LRT",0,"C"); $pdf->Cell(11,6,"Center","LRT",0,"C"); $pdf->Cell(79,6,"Center","LRT",0,"C"); $pdf->Cell(31,6,"Town","LRT",0,"C"); $pdf->Cell(13,6,"QP","LRT",0,"C"); $pdf->Cell(79,6,"Subject","LRT",0,"C"); $pdf->Cell(12,6,"Total","LRT",0,"C"); $pdf->Cell(12,6,"Absent","LRT",0,"C"); $pdf->Cell(15,6,"Malpract.","LRT",0,"C"); $pdf->Cell(12,6,"Present","LRT",1,"C"); $pdf->Cell(8,6,"No","LRB",0,"C"); $pdf->Cell(11,6,"Code","LRB",0,"C"); //w h txt brd pos align $pdf->Cell(79,6,"Name","LBR",0,"C"); $pdf->Cell(31,6,"","LBR",0,"C"); $pdf->Cell(13,6,"Code","LBR",0,"C"); $pdf->Cell(79,6,"","LBR",0,"L"); $pdf->Cell(12,6,"Count","LBR",0,"C"); $pdf->Cell(12,6,"Count","LBR",0,"C"); $pdf->Cell(15,6,"Count","LBR",0,"C"); $pdf->Cell(12,6,"Count","LBR",1,"C"); $pdf->SetFont('Times','',10); } if($this->reportType == 'QPCode wise'){ $pdf->Cell(8,6,"Sl.","LRT",0,"C"); $pdf->Cell(13,6,"QP","LRT",0,"C"); $pdf->Cell(79,6,"Subject","LRT",0,"C"); $pdf->Cell(11,6,"Center","LRT",0,"C"); $pdf->Cell(79,6,"Center","LRT",0,"C"); $pdf->Cell(31,6,"Town","LRT",0,"C"); $pdf->Cell(12,6,"Total","LRT",0,"C"); $pdf->Cell(12,6,"Absent","LRT",0,"C"); $pdf->Cell(15,6,"Malpract.","LRT",0,"C"); $pdf->Cell(12,6,"Present","LRT",1,"C"); $pdf->Cell(8,6,"No","LRB",0,"C"); $pdf->Cell(13,6,"Code","LBR",0,"C"); $pdf->Cell(79,6,"","LBR",0,"L"); $pdf->Cell(11,6,"Code","LRB",0,"C"); //w h txt brd pos align $pdf->Cell(79,6,"Name","LBR",0,"C"); $pdf->Cell(31,6,"","LBR",0,"C"); $pdf->Cell(12,6,"Count","LBR",0,"C"); $pdf->Cell(12,6,"Count","LBR",0,"C"); $pdf->Cell(15,6,"Count","LBR",0,"C"); $pdf->Cell(12,6,"Count","LBR",1,"C"); $pdf->SetFont('Times','',10); } } function writeReport($exattendancelist) { $pdf=$this->pdf; $pdf->SetMargins(6,42); $pdf->startPageGroup(); $pdf->AddPage("L"); $pdf->SetFont('Times','',10); $this->tableHeader($pdf); $oldCode= ""; $newCode = ""; foreach ($exattendancelist as $key => $value) { // $sl_no++; // var_dump($this->reportType); $landline = 0; $colname1 = strtolower(substr($value['fcollname'],0,42)); $colname2 = strtolower(substr($value['fcollname'],42)); $town1 = substr($value['ftown'],0,17); $town2 = substr($value['ftown'],17); $sub1 = substr($value['fsubname'],0,50); $sub2 = substr($value['fsubname'],50); if($this->reportType == 'Center Wise'){ $newCode = $value['fcntrcode']; if($newCode != $oldCode) { $sl_no++; $pdf->Cell(8,6,$sl_no,"LRT",0); $pdf->cell(11,6,$value['fcntrcode'],"LRT",0,"C"); $pdf->cell(79,6,ucwords($colname1),"LRT",0,"L"); $pdf->cell(31,6,$town1,"LRT",0,"L"); }else { $pdf->Cell(8,6,"","LR",0); $pdf->cell(11,6,"","LR",0,"C"); $pdf->cell(79,6,"","LR",0,"L"); $pdf->cell(31,6,"","LR",0,"L"); } if($colname2 || $town2 || $sub2){ $pdf->cell(13,6,$value['fqpcode'],"LRT",0,"L"); $pdf->cell(79,6,$sub1,"LRT",0,"L"); $pdf->cell(12,6,$value['tcount'],"LRT",0,"R"); $pdf->cell(12,6,$value['abcount'],"LRT",0,"R"); $pdf->cell(15,6,$value['mpcount'],"LRT",0,"R"); $pdf->cell(12,6,$value['prcount'],"LRT",1,"R"); if($pdf->getY() > 182){ $this->tableHeader($pdf); } if($colname2){ if($newCode != $oldCode){ $pdf->Cell(8,6,"","LR",0); $pdf->cell(11,6,"","LR",0,"C"); $pdf->cell(79,6,$colname2,"LR",0,"L"); $pdf->cell(31,6,"","LR",0,"L"); }else{ $pdf->Cell(8,6,"","LR",0); $pdf->cell(11,6,"","LR",0,"C"); $pdf->cell(79,6,"","LR",0,"L"); $pdf->cell(31,6,"","LR",0,"C"); } $pdf->cell(13,6,$value['fqpcode'],"LRT",0,"L"); $pdf->cell(79,6,$sub1,"LRT",0,"L"); $pdf->cell(12,6,$value['tcount'],"LRT",0,"R"); $pdf->cell(12,6,$value['abcount'],"LRT",0,"R"); $pdf->cell(15,6,$value['mpcount'],"LRT",0,"R"); $pdf->cell(12,6,$value['prcount'],"LRT",1,"R"); } else if($town2){ if($newCode != $oldCode){ $pdf->Cell(8,6,"","LR",0); $pdf->cell(11,6,"","LR",0,"C"); $pdf->cell(79,6,"","LR",0,"L"); $pdf->cell(31,6,$town2,"LR",0,"L"); }else{ $pdf->Cell(8,6,"","LR",0); $pdf->cell(11,6,"","LR",0,"C"); $pdf->cell(79,6,"","LR",0,"L"); $pdf->cell(31,6,"","LR",0,"C"); } $pdf->cell(13,6,$value['fqpcode'],"LRT",0,"L"); $pdf->cell(79,6,$sub1,"LRT",0,"L"); $pdf->cell(12,6,$value['tcount'],"LRT",0,"R"); $pdf->cell(12,6,$value['abcount'],"LRT",0,"R"); $pdf->cell(15,6,$value['mpcount'],"LRT",0,"R"); $pdf->cell(12,6,$value['prcount'],"LRT",1,"R"); } else if($sub2){ if($newCode != $oldCode){ $pdf->Cell(8,6,"","LR",0); $pdf->cell(11,6,"","LR",0,"C"); $pdf->cell(79,6,"","LR",0,"L"); $pdf->cell(31,6,"","LR",0,"L"); }else{ $pdf->Cell(8,6,"","LR",0); $pdf->cell(11,6,"","LR",0,"C"); $pdf->cell(79,6,"","LR",0,"L"); $pdf->cell(31,6,"","LR",0,"L"); $pdf->cell(13,6,"","LR",0,"C"); $pdf->cell(79,6,$sub2,"LBR",0,"L"); $pdf->cell(12,6,"","LBR",0,"R"); $pdf->cell(12,6,"","LBR",0,"R"); $pdf->cell(15,6,"","LBR",0,"R"); $pdf->cell(12,6,"","LBR",1,"R"); } } if($pdf->getY() > 181){ // $pdf->cell(268,"","","T",1); $this->tableHeader($pdf); } }else{ $pdf->cell(13,6,$value['fqpcode'],"1",0,"L"); $pdf->cell(79,6,$sub1,"1",0,"L"); $pdf->cell(12,6,$value['tcount'],"1",0,"R"); $pdf->cell(12,6,$value['abcount'],"1",0,"R"); $pdf->cell(15,6,$value['mpcount'],"1",0,"R"); $pdf->cell(12,6,$value['prcount'],"1",1,"R"); if($pdf->getY() > 182){ $this->tableHeader($pdf); } } $oldCode = $newCode; } if($this->reportType == 'QPCode wise'){ $sl_no++; $pdf->Cell(8,6,$sl_no,"LRT",0); $pdf->cell(13,6,$value['fqpcode'],"LRT",0,"C"); $pdf->cell(79,6,$sub1,"LRT",0,"L"); $pdf->cell(11,6,$value['fcntrcode'],"LRT",0,"C"); $pdf->cell(79,6,ucwords($colname1),"LRT",0,"L"); $pdf->cell(31,6,$town1,"LRT",0,"L"); $pdf->cell(12,6,$value['tcount'],"LRT",0,"R"); $pdf->cell(12,6,$value['abcount'],"LRT",0,"R"); $pdf->cell(15,6,$value['mpcount'],"LRT",0,"R"); $pdf->cell(12,6,$value['prcount'],"LRT",1,"R"); if($pdf->getY() > 182){ $this->tableHeader($pdf); } if($colname2 || $town2 || $sub2){ if($sub2){ $pdf->Cell(8,6,"","LBR",0); $pdf->cell(13,6,"","LBR",0,"C"); $pdf->cell(79,6,$sub2,"LBR",0,"L"); $pdf->cell(11,6,"","LRT",0,"C"); $pdf->cell(79,6,"","LRT",0,"L"); $pdf->cell(31,6,"","LRT",0,"L"); $pdf->cell(12,6,"","LRT",0,"R"); $pdf->cell(12,6,"","LRT",0,"R"); $pdf->cell(15,6,"","LRT",0,"R"); $pdf->cell(12,6,"","LRT",1,"R"); } if($colname2){ $pdf->Cell(8,6,"","LBR",0); $pdf->cell(13,6,"","LBR",0,"C"); $pdf->cell(79,6,"","LBR",0,"L"); $pdf->cell(11,6,"","LBR",0,"C"); $pdf->cell(79,6,$colname2,"LBR",0,"L"); $pdf->cell(31,6,$town2,"LBR",0,"L"); $pdf->cell(12,6,"","LBR",0,"R"); $pdf->cell(12,6,"","LBR",0,"R"); $pdf->cell(15,6,"","LBR",0,"R"); $pdf->cell(12,6,"","LBR",1,"R"); } // if($town2){ // $pdf->Cell(8,6,"","LBR",0); // $pdf->cell(13,6,"","LBR",0,"C"); // $pdf->cell(79,6,"","LBR",0,"L"); // $pdf->cell(11,6,"","LBR",0,"C"); // $pdf->cell(79,6,"","LBR",0,"L"); // $pdf->cell(31,6,$town2,"LBR",0,"L"); // $pdf->cell(12,6,"","LBR",0,"R"); // $pdf->cell(12,6,"","LBR",0,"R"); // $pdf->cell(15,6,"","LBR",0,"R"); // $pdf->cell(12,6,"","LBR",1,"R"); // } if($pdf->getY() > 182){ // $pdf->cell(268,"","","T",1); $this->tableHeader($pdf); } } } } $pdf->cell(272,"","","T",1); } function SendOutput() { // ob_end_clean(); $this->pdf->Output("ExamAttendanceList".$this->reportType.".pdf","D"); } } function getExamAttendance($aobj_context){ // $univcode = $aobj_context->mobj_data["univcode"]; // $doe = $aobj_context->mobj_data["doe"]; // $sessionType = $aobj_context->mobj_data["sessionType"]; // $reportType = $aobj_context->mobj_data["reportType"]; // $qprngfrom = $aobj_context->mobj_data["qprngfrom"]; // $qprngto = $aobj_context->mobj_data["qprngto"]; $univcode = $aobj_context->mobj_data["univcode"]; $doe = $aobj_context->mobj_data["doe"]; $sessionType = $aobj_context->mobj_data["sessionType"]; $reportType = $aobj_context->mobj_data["reportType"]; $qprngfrom = $aobj_context->mobj_data["qprngfrom"]; $qprngto = $aobj_context->mobj_data["qprngto"]; $fdeggrp = $aobj_context->mobj_data["dgp"]; $date = date("Y-m-d",strtotime(str_replace('/', '-', $doe))); $query = "SELECT fdbname FROM dbname WHERE funivcode = $univcode"; $result = $aobj_context->mobj_db->GetRow($query); $db = $result['fdbname']; $session = ""; $sessionfull =""; if($sessionType == 'm'){ $session = 'AM'; $sessionfull = 'Morning'; }else{ $session = 'PM'; $sessionfull = 'Afternoon'; } if($reportType == 'Center Wise'){ $query = "SELECT s.fcntrcode, cl.fcollname, cl.ftown, s.fqpcode, fsubname,s.fdoe, pcount AS tcount, IFNULL(abcount,0) AS abcount, IFNULL(mpcount,0) AS mpcount, (pcount-IFNULL(abcount,0)-IFNULL(mpcount,0)) AS prcount FROM (SELECT a.fcntrcode, a.fqpcode,a.fdoe, a.fsubname, COUNT(a.fregno) AS pcount FROM (SELECT cs.fcntrcode, s.fqpcode, s.fsubname,date_format(s.fdoe, '%d/%m/%Y') as fdoe, cd.fregno FROM {$db}.canddet cd INNER JOIN {$db}.candsum cs ON cd.fregno = cs.fregno AND cd.fdegree = cs.fdegree AND cd.fcollcode = cs.fcollcode INNER JOIN {$db}.subject s ON s.fdegree = cd.fdegree AND s.fexamno = cd.fexamno AND s.fsubcode = cd.fsubcode AND IFNULL(s.ftheory, '') = 'T' AND IFNULL(s.fintass,'') = 'F' WHERE IFNULL(fpresent,'') = 'P' AND IFNULL(fpassmth,'') = '' AND IFNULL(s.fdoe, '0000-00-00') = '$date' AND s.fsession LIKE '{$sessionType}%' AND s.fqpcode BETWEEN '{$qprngfrom}' AND '{$qprngto}') a GROUP BY a.fcntrcode, a.fqpcode) s INNER JOIN {$db}.college cl ON s.fcntrcode = cl.fcollcode LEFT JOIN (SELECT a.fcollcode, a.fqpcode, SUM(IF(fabstype = 'QpA', 1, 0))AS abcount, SUM(IF(fabstype = 'QpM', 1, 0))AS mpcount FROM {$db}.absent a WHERE a.fregno <> 'nil' AND a.fregno <> '0' AND '$date' = DATE_FORMAT(a.fdoe,'%Y-%m-%d') AND fsession like '{$sessionType}%' AND fcollcode <> '' AND a.fqpcode BETWEEN '{$qprngfrom}' AND '{$qprngto}' GROUP BY fcollcode, fqpcode) t ON s.fcntrcode = t.fcollcode AND s.fqpcode = t.fqpcode ORDER BY s.fcntrcode, s.fqpcode"; }else if($reportType == 'QPCode wise'){ $query = "SELECT s.fcntrcode, cl.fcollname, cl.ftown, s.fqpcode, fsubname, s.fdoe, pcount AS tcount, IFNULL(abcount,0) AS abcount, IFNULL(mpcount,0) AS mpcount, (pcount-IFNULL(abcount,0)-IFNULL(mpcount,0)) AS prcount FROM (SELECT a.fcntrcode, a.fqpcode,a.fdoe, a.fsubname, COUNT(a.fregno) AS pcount FROM (SELECT cs.fcntrcode, s.fqpcode, s.fsubname, cd.fregno, date_format(s.fdoe, '%d/%m/%Y') as fdoe FROM {$db}.canddet cd INNER JOIN {$db}.candsum cs ON cd.fregno = cs.fregno AND cd.fdegree = cs.fdegree AND cd.fcollcode = cs.fcollcode INNER JOIN {$db}.subject s ON s.fdegree = cd.fdegree AND s.fexamno = cd.fexamno AND s.fsubcode = cd.fsubcode AND IFNULL(s.ftheory, '') = 'T' AND IFNULL(s.fintass,'') = 'F' WHERE IFNULL(fpresent,'') = 'P' AND IFNULL(fpassmth,'') = '' AND IFNULL(s.fdoe, '0000-00-00') = '$date' AND s.fsession LIKE '{$sessionType}%' AND s.fqpcode BETWEEN '{$qprngfrom}' AND '{$qprngto}') a GROUP BY a.fcntrcode, a.fqpcode) s INNER JOIN {$db}.college cl ON s.fcntrcode = cl.fcollcode LEFT JOIN (SELECT a.fcollcode, a.fqpcode, SUM(IF(fabstype = 'QpA', 1, 0))AS abcount, SUM(IF(fabstype = 'QpM', 1, 0))AS mpcount FROM {$db}.absent a WHERE a.fregno <> 'nil' AND a.fregno <> '0' AND '$date' = DATE_FORMAT(a.fdoe,'%Y-%m-%d') AND fsession like '{$sessionType}%' AND fcollcode <> '' AND a.fqpcode BETWEEN '{$qprngfrom}' AND '{$qprngto}' GROUP BY fcollcode, fqpcode) t ON s.fcntrcode = t.fcollcode AND s.fqpcode = t.fqpcode ORDER BY s.fqpcode,s.fcntrcode"; //var_dump($query); } $result = $aobj_context->mobj_db->GetAll($query); $class_obj = new ExamAttendance(); $class_obj->univcode = $univcode; $class_obj->db = $db; $class_obj->DefaultConstructor($aobj_context,$qprngfrom,$qprngto,$doe,$sessionfull,$reportType); // If No data found Generate Blank Report if(count($result) > 0) $class_obj->writeReport($result); $class_obj->SendOutput(); } ?>
Close
