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.78.203
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 /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
assets
[ DIR ]
drwxrwxr-x
phpseclib3
[ DIR ]
drwxrwxr-x
razorpay
[ DIR ]
drwxr-xr-x
wordlib
[ DIR ]
drwxrwxr-x
AdmStrFeeReport.php
10.18
KB
-rwxr-xr-x
CreateUserType.php
4.13
KB
-rwxr-xr-x
Demo_Screen.php
2.37
KB
-rw-rw-r--
ECH_Pushnotif_bcu.php
2.17
KB
-rwxr-xr-x
ExamStats.php
2.21
KB
-rwxr-xr-x
ExmStatsSumm.php
1.85
KB
-rwxr-xr-x
NewLoginPage.php
3.85
KB
-rw-rw-r--
PaytmChecksum.php
3.91
KB
-rw-rw-r--
QPDegreeGroup.php
2.48
KB
-rw-r--r--
QPMaster.php
3.95
KB
-rw-r--r--
RVRTFeeUpdate.php
5.75
KB
-rwxr-xr-x
Tickets.php
7.99
KB
-rw-rw-r--
UpdateScanCodeList.php
1.11
KB
-rwxr-xr-x
acknowlege_direct.php
3.7
KB
-rw-r--r--
activateTT.php
2.07
KB
-rwxr-xr-x
admLogin.php
1.32
KB
-rw-rw-r--
admStats.php
414
B
-rwxr-xr-x
admStatsCollwise.php
4.78
KB
-rwxr-xr-x
admStatsDegwise.php
2.4
KB
-rwxr-xr-x
adm_admin.php
11.8
KB
-rw-r--r--
admapprove.php
7.75
KB
-rw-r--r--
admdet.php
1.17
KB
-rw-r--r--
admin-Copy.html
5.68
KB
-rwxr-xr-x
admisiondegree.php
1.52
KB
-rw-rw-r--
appNotification.php
3.46
KB
-rwxr-xr-x
approvestudename.php
2.71
KB
-rw-rw-r--
assignUserMenus.php
4.01
KB
-rwxr-xr-x
attend_block.php
3.46
KB
-rw-r--r--
attendance_report.php
7.64
KB
-rw-r--r--
attshortupdate.php
4.27
KB
-rw-rw-r--
attupd.php
2.4
KB
-rwxr-xr-x
avlQP.php
6.59
KB
-rw-rw-r--
bkmhconfirm.php
3.86
KB
-rw-r--r--
boardMaster.php
6.74
KB
-rwxr-xr-x
boardMember.php
1.89
KB
-rw-rw-r--
bundNotRecvRprt.php
6.92
KB
-rwxrwxrwx
bundRecvReport.php
6.92
KB
-rwxr-xr-x
bundleReceive.php
1.11
KB
-rwxr-xr-x
bundledispatchrpt.php
2.66
KB
-rw-r--r--
caccesscontext.php
1.24
KB
-rwxr-xr-x
cappcontext.php
4.58
KB
-rwxr-xr-x
cappcontext1.php
3.64
KB
-rwxr-xr-x
category.php
1.33
KB
-rwxr-xr-x
centrealloction.php
1.37
KB
-rw-r--r--
centrereports.php
2.36
KB
-rw-r--r--
certificatestatus.php
13.08
KB
-rw-r--r--
changeMobile.php
3.74
KB
-rwxr-xr-x
changePasswd.php
1.23
KB
-rwxr-xr-x
checkMob.php
961
B
-rw-r--r--
code39.php
6.38
KB
-rwxr-xr-x
collegeSubjects.php
3.19
KB
-rwxr-xr-x
college_list.php
5.93
KB
-rwxr-xr-x
college_reports.php
17.63
KB
-rwxr-xr-x
collegemasters.php
1.36
KB
-rw-r--r--
collegereports.php
6.21
KB
-rw-r--r--
combSubjects.php
711
B
-rwxr-xr-x
combination.php
6.06
KB
-rwxr-xr-x
compileQpIndent.php
7.89
KB
-rw-rw-r--
compileQpIndent_22032022.php
7.99
KB
-rwxr-xr-x
compileQpIndent_old.php
4.43
KB
-rwxr-xr-x
constants.php
818
B
-rwxr-xr-x
convoedit.php
7.43
KB
-rwxr-xr-x
coutput.php
1.75
KB
-rwxr-xr-x
createExam.php
4.85
KB
-rw-r--r--
createGroup.php
8.88
KB
-rwxr-xr-x
createReval.php
860
B
-rw-r--r--
createTemp.php
7.84
KB
-rw-r--r--
createUser.php
8.04
KB
-rwxr-xr-x
createboard.php
3.16
KB
-rw-rw-r--
createboe.php
6.19
KB
-rwxrwxrwx
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
dailyFeeReport.php
11.48
KB
-rw-r--r--
dailyValuation.php
1.6
KB
-rwxr-xr-x
dashboard.php
3
KB
-rwxr-xr-x
dashboardNew.php
31.2
KB
-rw-rw-r--
dateMaster.php
2.83
KB
-rwxr-xr-x
dateupdate.php
8.88
KB
-rw-rw-r--
decodngstats.php
656
B
-rw-rw-r--
define_heads.php
1.89
KB
-rw-rw-r--
degcollege.php
7.32
KB
-rwxr-xr-x
deggrp.php
13.84
KB
-rwxr-xr-x
deggrpNew.php
2.74
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-rw-r--
dispatchmarkscard.php
19.14
KB
-rwxrwxrwx
drawer.php
552
B
-rw-rw-r--
dropDownOptions.php
400
B
-rwxr-xr-x
eGovSignin.php
5.09
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
5.95
KB
-rwxr-xr-x
examHappeningCentre.php
22.44
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-rw-r--
examapprpt.php
2.93
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
feedback.php
2.97
KB
-rw-rw-r--
finalQp.php
12.7
KB
-rw-rw-r--
financeMenuItems.php
1.51
KB
-rw-rw-r--
format.php
7.43
KB
-rwxr-xr-x
freezeTimetable.php
3.37
KB
-rwxrwxrwx
generatebill_acu.php
21.07
KB
-rw-r--r--
generatebill_new.php
29.07
KB
-rw-r--r--
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.97
KB
-rwxr-xr-x
getNotifications.php
1.13
KB
-rwxr-xr-x
getQPdet.php
7
KB
-rw-rw-r--
getRvPcReport.php
4.99
KB
-rwxr-xr-x
getStudentRegisteredReport.php
8.91
KB
-rw-rw-r--
getUnivName.php
516
B
-rw-r--r--
get_result_table.php
109
B
-rw-r--r--
getdeggrpvalcntr.php
1.88
KB
-rw-rw-r--
getinwordstatus.php
3.46
KB
-rw-rw-r--
getpgetSavedData.php
4.29
KB
-rwxr-xr-x
getrvpc.php
8.89
KB
-rw-r--r--
getstuddetforrt.php
5.85
KB
-rw-rw-r--
getunivs.php
816
B
-rwxr-xr-x
groupMessages.php
9.1
KB
-rwxr-xr-x
grv.php
12.23
KB
-rwxrwxrwx
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-rw-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-rw-r--
lastDateUpdate.php
4.23
KB
-rwxr-xr-x
lastDateUpdateCorrection.php
4.96
KB
-rw-rw-r--
ledgerview.php
3.79
KB
-rwxrwxrwx
loadclgdettab.php
2.26
KB
-rw-rw-r--
loadclgnm.php
1.3
KB
-rw-rw-r--
loaddegdet.php
1.45
KB
-rw-rw-r--
loaddegreedettab.php
2.49
KB
-rw-rw-r--
loadupdclgnm.php
741
B
-rw-rw-r--
log.php
521
B
-rw-rw-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-rw-r--
marksentryupdate.php
4.78
KB
-rw-r--r--
marksmodreport.php
1.49
KB
-rw-rw-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
5.2
KB
-rw-rw-r--
mregistry.php
125.02
KB
-rwxrwxrwx
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
5.03
KB
-rw-rw-r--
omrqnentry.php
17.52
KB
-rw-rw-r--
online-test.php
12.77
KB
-rwxr-xr-x
orderReportExcel.php
7.35
KB
-rw-rw-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-rw-r--
prbatchdet.php
3.26
KB
-rwxr-xr-x
preparethqp.php
20.89
KB
-rw-rw-r--
prifreeze.php
3.11
KB
-rw-rw-r--
pushmarks.php
1.18
KB
-rw-rw-r--
pushnitification.php
9.89
KB
-rwxr-xr-x
pushnotif_ra.php
5.59
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.45
KB
-rw-rw-r--
qp_issue.php
8.46
KB
-rw-rw-r--
qp_setter.php
76.37
KB
-rw-r--r--
qp_setter_new.php
53.28
KB
-rw-r--r--
qpboardupdate.php
4.26
KB
-rw-rw-r--
qpcrosscheck.php
11.96
KB
-rw-r--r--
qpdaylog.php
433
B
-rw-rw-r--
qpindentstudlist.php
11.16
KB
-rw-r--r--
qplog.php
938
B
-rw-rw-r--
qpschemeupload.php
5.84
KB
-rw-rw-r--
qpsetterteach.php
22.96
KB
-rw-rw-r--
qpsummary.php
7.01
KB
-rw-rw-r--
qpsummarynew.php
4.58
KB
-rw-rw-r--
qptranlogin.php
1.84
KB
-rw-rw-r--
qptranmenu.php
2.22
KB
-rw-rw-r--
qptranqpupd.php
1.36
KB
-rw-r--r--
qpupload.php
8.11
KB
-rwxrwxrwx
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
receivescript.php
8.03
KB
-rw-rw-r--
refund.php
2.68
KB
-rwxr-xr-x
register_rrit.php
24.18
KB
-rw-r--r--
releaseTimetable.php
5.85
KB
-rwxrwxrwx
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-rw-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-rw-r--
rvMarksEntry.php
4.78
KB
-rwxrwxrwx
rvStatus.php
7.69
KB
-rw-rw-r--
rv_result_pushnotif_bcu.php
1.96
KB
-rwxr-xr-x
rvpc.php
1.76
KB
-rw-rw-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-rw-r--
saveAbstractForm.php
8.03
KB
-rw-r--r--
saveBKMCStdDet.php
2.22
KB
-rw-r--r--
saveBankDetails.php
1.64
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
4.02
KB
-rw-rw-r--
script.php
14.27
KB
-rwxr-xr-x
sdqpmenus.php
163
B
-rw-rw-r--
searchregcode.php
5.17
KB
-rw-rw-r--
selectFinalQpNew.php
4.69
KB
-rw-rw-r--
sendGridMail.php
1.72
KB
-rwxr-xr-x
sendOTP.php
5.51
KB
-rw-r--r--
sendOrder.php
12.78
KB
-rw-r--r--
sendnotification.php
0
B
-rwxr-xr-x
sendsms.php
11.8
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-rw-r--
session_start.php
149
B
-rw-r--r--
session_start_rr.php
430
B
-rw-r--r--
sessionmaster.php
1.49
KB
-rw-r--r--
setDGExamTimetableReport.php
20.08
KB
-rwxr-xr-x
setDGExamTimetableReport_bcu_p...
11.51
KB
-rwxr-xr-x
setExamTimetable.php
5.01
KB
-rwxr-xr-x
setExamTimetableReport.php
9.05
KB
-rwxr-xr-x
settlement.php
9.06
KB
-rw-rw-r--
sms-new.php
28.1
KB
-rw-rw-r--
sms-notification.php
21.17
KB
-rwxr-xr-x
ssp_error_data.php
31.1
KB
-rwxrwxrwx
sspdata-auto-upload.php
11.12
KB
-rwxr-xr-x
sspdata.php
23.87
KB
-rwxr-xr-x
sspdata1.php
11.41
KB
-rw-rw-r--
sspdata1_rcub.php
13.96
KB
-rw-rw-r--
std_registrtion.php
1.4
KB
-rw-rw-r--
studReg.php
1.64
KB
-rw-r--r--
stud_ack.php
10.89
KB
-rw-rw-r--
student.php
26.37
KB
-rwxr-xr-x
studexamappblock.php
1.18
KB
-rw-rw-r--
studymaterial.php
3.07
KB
-rwxrwxrwx
subject.php
2.42
KB
-rwxr-xr-x
subjectEntryScrn.php
8
KB
-rwxr-xr-x
subjectFreeze.php
4.91
KB
-rw-rw-r--
sublisting.php
2.39
KB
-rw-rw-r--
tdvsCreatePanel.php
1.26
KB
-rw-r--r--
tdvsQPteach.php
2.17
KB
-rw-r--r--
tdvsViewStatus.php
3.52
KB
-rw-rw-r--
tdvs_Deviation.php
8.68
KB
-rw-rw-r--
tdvs_batch.php
5.89
KB
-rw-rw-r--
tdvs_createuser.php
6.53
KB
-rw-rw-r--
tdvs_dashboard.php
3.59
KB
-rw-rw-r--
tdvs_generateBill.php
14.16
KB
-rw-rw-r--
tdvs_mail.php
5.93
KB
-rw-rw-r--
tdvs_pergeval.php
14.43
KB
-rw-rw-r--
tdvs_register.php
1.57
KB
-rw-rw-r--
tdvs_resetVal.php
2.42
KB
-rw-rw-r--
tdvs_saveRecieveQPCount.php
3.53
KB
-rwxr-xr-x
tdvs_saveScript.php
12.32
KB
-rw-r--r--
tdvs_script_cross_check.php
9.41
KB
-rw-r--r--
tdvs_stats.php
21.7
KB
-rw-rw-r--
tdvs_subject.php
4.43
KB
-rw-rw-r--
tdvs_subjectcreate.php
6.07
KB
-rw-rw-r--
tdvs_teacher_valdet.php
2.87
KB
-rw-rw-r--
tdvs_teacherpanel.php
3.38
KB
-rw-rw-r--
tdvs_teachval.php
1.88
KB
-rw-rw-r--
tdvs_teachwisevaldet.php
5.64
KB
-rw-rw-r--
tdvs_valcenter.php
2.84
KB
-rw-rw-r--
tdvs_valuation.php
43.54
KB
-rw-rw-r--
tdvs_verifyqppattern.php
1.03
KB
-rw-rw-r--
tdvsdecoding.php
48.81
KB
-rw-rw-r--
teachReport.php
5.27
KB
-rwxr-xr-x
teachValBill.php
990
B
-rwxr-xr-x
teachcoderange.php
1.71
KB
-rw-rw-r--
teacherEmail.php
20.94
KB
-rw-rw-r--
teacherEntry.php
75.04
KB
-rw-rw-r--
teacherid.php
2
KB
-rw-rw-r--
teachval.php
8.56
KB
-rwxr-xr-x
teachvaluationcount.php
21.07
KB
-rw-rw-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
17.36
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.53
KB
-rwxr-xr-x
ultRoomDet.php
1.96
KB
-rw-rw-r--
umenu.php
1.07
KB
-rwxr-xr-x
uniAttEntry.php
1.03
KB
-rw-rw-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-rw-r--
updateIAMarks.php
1.42
KB
-rw-rw-r--
updateRvPcChkList.php
1.13
KB
-rwxr-xr-x
update_dates.php
11.89
KB
-rw-rw-r--
upload-sms-excel.php
3.58
KB
-rwxr-xr-x
uploadAnsBook.php
4.5
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-rw-r--
uploadFile.php
388
B
-rw-rw-r--
uploadMCdetails.php
4.17
KB
-rw-r--r--
uploadMultipleFiles.php
4.03
KB
-rwxr-xr-x
uploadSSPData.php
5.9
KB
-rw-rw-r--
uploadSSPData_bonf.php
11.86
KB
-rw-rw-r--
upload_ans_book.php
5.25
KB
-rwxr-xr-x
upload_qp.php
1.85
KB
-rw-rw-r--
uploadbackup.php
5.16
KB
-rw-rw-r--
uploadcorr_qp.php
6.21
KB
-rw-rw-r--
uploadcorrdoc.php
4.09
KB
-rw-r--r--
uploadpwd.php
3.75
KB
-rw-r--r--
uploadqp.php
6.61
KB
-rw-r--r--
uploadqpMultipleFiles.php
678
B
-rw-rw-r--
uploadscripts.php
333
B
-rw-rw-r--
utils.php
4.19
KB
-rw-rw-r--
uucmsdecoding.php
1.86
KB
-rw-rw-r--
valuatordet.php
3.29
KB
-rwxr-xr-x
verify.php
9.57
KB
-rw-rw-r--
verifyapponlineserv.php
3.18
KB
-rwxr-xr-x
viewTimeTabledurExm.php
3.84
KB
-rwxr-xr-x
viewexamcentrenew.php
20.44
KB
-rw-r--r--
viewfootnote.php
1.97
KB
-rw-r--r--
viewteachattendance.php
2.18
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : examHappeningCentre.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["fdatefrom"]; $this->sessionfull = $sessionfull; $this->reportType = $aobj_context->mobj_data["rtype"]; $this->qprngfrom = $aobj_context->mobj_data["qpfrm"]; $this->qprngto = $aobj_context->mobj_data["qpto"]; $fdeggrp = $aobj_context->mobj_data["dgp"]; // var_dump($fdeggrp,'ewfwefwwe'); // die(); } 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', 'B', 12); // var_dump($this->doe); $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(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'); } } class ExamHappeningCenters { public function DefaultConstructor($aobj_context, $sessionfull) { $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']; $this->pdf = new MYPDF('L'); $this->pdf->setData($aobj_context, $sessionfull); } public function cwtableHeader($pdf) { $pdf->SetFont('Times', 'B', 10); $pdf->Cell(8, 6, "Sl.", "LRT", 0, "C"); $pdf->Cell(15, 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", 0, "C"); $pdf->Cell(12, 6, "Script", "LRT", 0, "C"); $pdf->Cell(12, 6, "Bund.", "LRT", 1, "C"); $pdf->Cell(8, 6, "No", "LRB", 0, "C"); $pdf->Cell(15, 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", 0, "C"); $pdf->Cell(12, 6, "Count", "LBR", 0, "C"); $pdf->Cell(12, 6, "Count", "LBR", 1, "C"); $pdf->SetFont('Times', '', 10); } public function qwtableHeader($pdf) { $pdf->SetFont('Times', 'B', 10); $pdf->Cell(8, 6, "Sl.", "LRT", 0, "C"); $pdf->Cell(13, 6, "Center", "LRT", 0, "C"); $pdf->Cell(79, 6, "Center Name", "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", 0, "C"); $pdf->Cell(12, 6, "Script", "LRT", 0, "C"); $pdf->Cell(12, 6, "Bund.", "LRT", 1, "C"); $pdf->Cell(8, 6, "No", "LRB", 0, "C"); $pdf->Cell(13, 6, "Code", "LRB", 0, "C"); //w h txt brd pos align $pdf->Cell(79, 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", 0, "C"); $pdf->Cell(12, 6, "Count", "LBR", 0, "C"); $pdf->Cell(12, 6, "Count", "LBR", 1, "C"); $pdf->SetFont('Times', '', 10); } public function cwwriteReport($exattendancelist) { $pdf = $this->pdf; $pdf->SetMargins(15, 40); $pdf->startPageGroup(); $pdf->AddPage("P"); $pdf->SetFont('Times', '', 10); $oldCode = ""; $newCode = ""; $sl_no = 1; $pdf->doe = $exattendancelist[0]['fdoe']; $olddoe = $exattendancelist[0]['fdoe']; $newdoe = ""; $tcount = 0; $abcount = 0; $mpcount = 0; $prcount = 0; $ftotscript = 0; $fbundcount = 0; $first = true; // var_dump($exattendancelist); foreach ($exattendancelist as $key => $value) { // $sl_no++ $newCode = $value['fcntrcode']; $newdoe = $value['fdoe']; if ($olddoe !== $newdoe) { $pdf->SetFont('Times', 'B', 10); $pdf->Cell(102, 6, "Total", "1", 0, "C"); $pdf->cell(12, 6, $tcount, "1", 0, "C"); $pdf->cell(12, 6, $abcount, "1", 0, "C"); $pdf->cell(15, 6, $mpcount, "1", 0, "C"); $pdf->cell(12, 6, $prcount, "1", 0, "C"); $pdf->cell(12, 6, $ftotscript, "1", 0, "C"); $pdf->cell(12, 6, $fbundcount, "1", 1, "C"); $first = true; $pdf->doe = $value['fdoe']; $pdf->AddPage("P"); } if ($newCode != $oldCode) { $sl_no = 1; if (!$first) { $pdf->SetFont('Times', 'B', 10); $pdf->Cell(102, 6, "Total", "1", 0, "C"); $pdf->cell(12, 6, $tcount, "1", 0, "C"); $pdf->cell(12, 6, $abcount, "1", 0, "C"); $pdf->cell(15, 6, $mpcount, "1", 0, "C"); $pdf->cell(12, 6, $prcount, "1", 0, "C"); $pdf->cell(12, 6, $ftotscript, "1", 0, "C"); $pdf->cell(12, 6, $fbundcount, "1", 1, "C"); } $first = false; $tcount = 0; $abcount = 0; $mpcount = 0; $prcount = 0; $ftotscript = 0; $fbundcount = 0; $pdf->SetFont('Times', 'B', 12); $pdf->cell(0, 12, $value['fcntrcode'] . ' - ' . $value['fcollname'] . ', ' . $value['ftown'], 0, 1, "C"); $this->cwtableHeader($pdf); $pdf->SetFont('Times', '', 10); } if ($pdf->getY() > 260) { $pdf->AddPage("P"); } $x = $pdf->GetX(); $y = $pdf->GetY(); $pdf->SetX($x + 23); $pdf->MultiCell(79, 6, $value['fsubname'], 1, "L"); $y1 = $pdf->GetY(); $h = $y1 - $y; $pdf->SetXY($x, $y); $pdf->Cell(8, $h, $sl_no, "1", 0, "C"); $pdf->cell(15, $h, $value['fqpcode'], "1", 0, "C"); $pdf->SetXY($x + 102, $y); // $pdf->cell(79, $h, $value['fsubname'], "1", 0, "L"); $pdf->cell(12, $h, $value['tcount'], "1", 0, "C"); $pdf->cell(12, $h, $value['abcount'], "1", 0, "C"); $pdf->cell(15, $h, $value['mpcount'], "1", 0, "C"); $pdf->cell(12, $h, $value['prcount'], "1", 0, "C"); $pdf->cell(12, $h, $value['ftotscript'], "1", 0, "C"); $pdf->cell(12, $h, $value['fbundcount'], "1", 1, "C"); $tcount += $value['tcount']; $abcount += $value['abcount']; $mpcount += $value['mpcount']; $prcount += $value['prcount']; $ftotscript += $value['ftotscript']; $fbundcount += $value['fbundcount']; if ($pdf->getY() > 260) { $pdf->AddPage("P"); $pdf->SetFont('Times', 'B', 12); $pdf->cell(0, 12, $value['fcntrcode'] . ' - ' . $value['fcollname'], 0, 1, "C"); $this->cwtableHeader($pdf); $pdf->SetFont('Times', '', 10); } $oldCode = $newCode; $olddoe = $newdoe; $sl_no++; } $pdf->SetFont('Times', 'B', 10); $pdf->Cell(102, 6, "Total", "1", 0, "C"); $pdf->cell(12, 6, $tcount, "1", 0, "C"); $pdf->cell(12, 6, $abcount, "1", 0, "C"); $pdf->cell(15, 6, $mpcount, "1", 0, "C"); $pdf->cell(12, 6, $prcount, "1", 0, "C"); $pdf->cell(12, 6, $ftotscript, "1", 0, "C"); $pdf->cell(12, 6, $fbundcount, "1", 1, "C"); } public function qpwriteReport($exattendancelist) { $pdf = $this->pdf; $pdf->SetMargins(15, 40); $pdf->startPageGroup(); $pdf->AddPage("P"); $pdf->SetFont('Times', '', 10); $oldCode = ""; $newCode = ""; $sl_no = 1; $pdf->doe = $exattendancelist[0]['fdoe']; $olddoe = $exattendancelist[0]['fdoe']; $newdoe = ""; $tcount = 0; $abcount = 0; $mpcount = 0; $prcount = 0; $ftotscript = 0; $fbundcount = 0; $first = true; // var_dump($exattendancelist); foreach ($exattendancelist as $key => $value) { // $sl_no++ // var_dump($value); $newCode = $value['fqpcode']; $newdoe = $value['fdoe']; if ($olddoe !== $newdoe) { $pdf->SetFont('Times', 'B', 10); $pdf->Cell(100, 6, "Total", "1", 0, "C"); $pdf->cell(12, 6, $tcount, "1", 0, "C"); $pdf->cell(12, 6, $abcount, "1", 0, "C"); $pdf->cell(15, 6, $mpcount, "1", 0, "C"); $pdf->cell(12, 6, $prcount, "1", 0, "C"); $pdf->cell(12, 6, $ftotscript, "1", 0, "C"); $pdf->cell(12, 6, $fbundcount, "1", 1, "C"); $first = true; $pdf->doe = $value['fdoe']; $pdf->AddPage("P"); } if ($newCode != $oldCode) { $sl_no = 1; if (!$first) { $pdf->SetFont('Times', 'B', 10); $pdf->Cell(100, 6, "Total", "1", 0, "C"); $pdf->cell(12, 6, $tcount, "1", 0, "C"); $pdf->cell(12, 6, $abcount, "1", 0, "C"); $pdf->cell(15, 6, $mpcount, "1", 0, "C"); $pdf->cell(12, 6, $prcount, "1", 0, "C"); $pdf->cell(12, 6, $ftotscript, "1", 0, "C"); $pdf->cell(12, 6, $fbundcount, "1", 1, "C"); } $first = false; $tcount = 0; $abcount = 0; $mpcount = 0; $prcount = 0; $ftotscript = 0; $fbundcount = 0; $pdf->SetFont('Times', 'B', 12); $pdf->cell(0, 12, $value['fqpcode'] . ' - ' . $value['fsubname'], 0, 1, "C"); $this->qwtableHeader($pdf); $pdf->SetFont('Times', '', 10); } if ($pdf->getY() > 260) { $pdf->AddPage("P"); } $x = $pdf->GetX(); $y = $pdf->GetY(); $pdf->SetX($x + 21); $pdf->MultiCell(79, 6, $value['fcollname'], 1, "L"); $y1 = $pdf->GetY(); $h = $y1 - $y; $pdf->SetXY($x, $y); $pdf->Cell(8, $h, $sl_no, "1", 0, "C"); $pdf->cell(13, $h, $value['fcntrcode'], "1", 0, "C"); $pdf->SetXY($x + 100, $y); // $pdf->cell(79, $h, $value['fsubname'], "1", 0, "L"); $pdf->cell(12, $h, $value['tcount'], "1", 0, "C"); $pdf->cell(12, $h, $value['abcount'], "1", 0, "C"); $pdf->cell(15, $h, $value['mpcount'], "1", 0, "C"); $pdf->cell(12, $h, $value['prcount'], "1", 0, "C"); $pdf->cell(12, $h, $value['ftotscript'], "1", 0, "C"); $pdf->cell(12, $h, $value['fbundcount'], "1", 1, "C"); $tcount += $value['tcount']; $abcount += $value['abcount']; $mpcount += $value['mpcount']; $prcount += $value['prcount']; $ftotscript += $value['ftotscript']; $fbundcount += $value['fbundcount']; if ($pdf->getY() > 260) { $pdf->AddPage("P"); $pdf->SetFont('Times', 'B', 12); $pdf->cell(0, 12, $value['fqpcode'] . ' - ' . $value['fsubname'], 0, 1, "C"); $this->qwtableHeader($pdf); $pdf->SetFont('Times', '', 10); } $oldCode = $newCode; $olddoe = $newdoe; $sl_no++; } $pdf->SetFont('Times', 'B', 10); $pdf->Cell(100, 6, "Total", "1", 0, "C"); $pdf->cell(12, 6, $tcount, "1", 0, "C"); $pdf->cell(12, 6, $abcount, "1", 0, "C"); $pdf->cell(15, 6, $mpcount, "1", 0, "C"); $pdf->cell(12, 6, $prcount, "1", 0, "C"); $pdf->cell(12, 6, $ftotscript, "1", 0, "C"); $pdf->cell(12, 6, $fbundcount, "1", 1, "C"); } public function SendOutput() { // ob_end_clean(); $this->pdf->Output("ExamAttendanceList" . $this->reportType . ".pdf", "I"); } } function getExamAttendance($aobj_context) { $univcode = $aobj_context->mobj_data["univcode"]; $fdatefrom = $aobj_context->mobj_data["fdatefrom"]; $fdateto = $aobj_context->mobj_data["fdateto"]; $sessionType = $aobj_context->mobj_data["stype"]; $reportType = $aobj_context->mobj_data["rtype"]; $qprngfrom = $aobj_context->mobj_data["qpfrm"]; $qprngto = $aobj_context->mobj_data["qpto"]; $fdeggrp = $aobj_context->mobj_data["dgp"]; $fcntrfrom = $aobj_context->mobj_data["fcntrfrom"]; $fcntrto = $aobj_context->mobj_data["fcntrto"]; $session = ""; $sessionfull = "Both Morning and Afternoon"; if ($sessionType == 'm') { $session = "AND fsession ='AM'"; $sessionfull = 'Morning'; } else if ($sessionType == 'n') { $session = "AND fsession ='PM'"; $sessionfull = 'Afternoon'; } $session_cond = ""; if ($sessionType != 'b') { $session_cond = "AND s.fsession LIKE '{$sessionType}%'"; } $order = "s.fcntrcode, s.fqpcode"; if ($reportType == 'Center Wise') { $order = "s.fdoe, s.fcntrcode, s.fqpcode"; } else if ($reportType == 'QPCode wise') { $order = "s.fqpcode, s.fcntrcode"; } $datecond1 = ""; $datecond2 = ""; if ($fdatefrom != '' && $fdateto != "") { $fdatefrom = date("Y-m-d", strtotime(str_replace('/', '-', $fdatefrom))); $fdateto = date("Y-m-d", strtotime(str_replace('/', '-', $fdateto))); if($univcode == '030') $datecond1 = "AND IFNULL(t.fdoe, '0000-00-00') between '{$fdatefrom}' and '{$fdateto}'"; else $datecond1 = "AND IFNULL(s.fdoe, '0000-00-00') between '{$fdatefrom}' and '{$fdateto}'"; $datecond2 = "AND IFNULL(a.fdoe, '0000-00-00') between '{$fdatefrom}' and '{$fdateto}'"; } if($univcode == '041x' || $univcode == '042x') { $candsum = "examcandsum"; $canddet = "examcanddet"; }else { $candsum = "candsum"; $canddet = "canddet"; } if($fdeggrp != "All"){ $deggpCond = "where fdeggrp = '{$fdeggrp}'"; }else{ $deggpCond = ""; } if($univcode == '030') { $query = "SELECT s.fcntrcode, concat(cl.fcollname, ', ', cl.ftown) as fcollname, s.fqpcode, fsubname, date_format(s.fdoe, '%d/%m/%Y') as fdoe, pcount AS tcount, IFNULL(abcount,0) AS abcount, IFNULL(mpcount,0) AS mpcount, (pcount-IFNULL(abcount,0)-IFNULL(mpcount,0)) AS prcount, ifnull(fbundcount,'0') as fbundcount, ifnull(c.ftotscript,'0') as ftotscript FROM (SELECT a.fcntrcode, a.fqpcode,a.fdoe, a.fsubname, COUNT(a.fregno) AS pcount FROM (SELECT cs.fcntrcode, s.fqpcode, s.fsubname,s.fdoe, cd.fregno FROM $canddet cd INNER JOIN $candsum cs ON cd.fregno = cs.fregno AND cd.fdegree = cs.fdegree AND cd.fcollcode = cs.fcollcode AND cs.fcntrcode BETWEEN '{$fcntrfrom}' AND '{$fcntrto}' INNER JOIN 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' inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno inner join timetable t on s.fqpcode = t.fqpcode and d.fdeggrp = t.fdeggrp WHERE IFNULL(fpresent,'') = 'P' AND IFNULL(fpassmth,'') = '' and ifnull(t.fdoe,'0000-00-00') <> '0000-00-00' {$datecond1} {$session_cond} AND s.fqpcode BETWEEN '{$qprngfrom}' AND '{$qprngto}' and INSTR(cs.fhtenable,cd.fexamno) >0 and cd.fdegree in (select distinct fdegree from degree $deggpCond)) a GROUP BY a.fcntrcode, a.fqpcode) s INNER JOIN 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 absent a WHERE a.fregno <> 'nil' AND a.fregno <> '0' {$datecond2} {$session} AND fcollcode <> '' AND a.fqpcode BETWEEN '{$qprngfrom}' AND '{$qprngto}' AND fcollcode BETWEEN '{$fcntrfrom}' AND '{$fcntrto}' GROUP BY fcollcode, fqpcode) t ON s.fcntrcode = t.fcollcode AND s.fqpcode = t.fqpcode left join (select date_format(fdoe, '%d/%m/%Y') as fdoe, fcollcode, fqpcode, count(fbuno) as fbundcount, sum(ftotscript) as ftotscript from colldesp WHERE fcollcode BETWEEN '{$fcntrfrom}' AND '{$fcntrto}' group by fcollcode, fqpcode) c on s.fcntrcode = c.fcollcode and s.fqpcode = c.fqpcode ORDER BY $order"; }else { $query = "SELECT s.fcntrcode, concat(cl.fcollname, ', ', cl.ftown) as fcollname, s.fqpcode, fsubname, date_format(s.fdoe, '%d/%m/%Y') as fdoe, pcount AS tcount, IFNULL(abcount,0) AS abcount, IFNULL(mpcount,0) AS mpcount, (pcount-IFNULL(abcount,0)-IFNULL(mpcount,0)) AS prcount, ifnull(fbundcount,'0') as fbundcount, ifnull(c.ftotscript,'0') as ftotscript FROM (SELECT a.fcntrcode, a.fqpcode,a.fdoe, a.fsubname, COUNT(a.fregno) AS pcount FROM (SELECT cs.fcntrcode, s.fqpcode, s.fsubname,s.fdoe, cd.fregno FROM $canddet cd INNER JOIN $candsum cs ON cd.fregno = cs.fregno AND cd.fdegree = cs.fdegree AND cd.fcollcode = cs.fcollcode AND cs.fcntrcode BETWEEN '{$fcntrfrom}' AND '{$fcntrto}' INNER JOIN 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') <> '0000-00-00' {$datecond1} {$session_cond} AND s.fqpcode BETWEEN '{$qprngfrom}' AND '{$qprngto}' and INSTR(cs.fhtenable,cd.fexamno) >0 and cd.fdegree in (select distinct fdegree from degree $deggpCond)) a GROUP BY a.fcntrcode, a.fqpcode) s INNER JOIN 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 absent a WHERE a.fregno <> 'nil' AND a.fregno <> '0' {$datecond2} {$session} AND fcollcode <> '' AND a.fqpcode BETWEEN '{$qprngfrom}' AND '{$qprngto}' AND fcollcode BETWEEN '{$fcntrfrom}' AND '{$fcntrto}' GROUP BY fcollcode, fqpcode) t ON s.fcntrcode = t.fcollcode AND s.fqpcode = t.fqpcode left join (select date_format(fdoe, '%d/%m/%Y') as fdoe, fcollcode, fqpcode, count(fbuno) as fbundcount, sum(ftotscript) as ftotscript from colldesp WHERE fcollcode BETWEEN '{$fcntrfrom}' AND '{$fcntrto}' group by fcollcode, fqpcode) c on s.fcntrcode = c.fcollcode and s.fqpcode = c.fqpcode ORDER BY $order"; } $result = $aobj_context->pobj_db->GetAll($query); // var_dump($query); // die(); //var_dump($result) ;return; $class_obj = new ExamHappeningCenters(); $class_obj->univcode = $univcode; $class_obj->DefaultConstructor($aobj_context, $sessionfull); // If No data found Generate Blank Report if (count($result) > 0) { // var_dump($reportType); if ($reportType == 'Center Wise') { $class_obj->cwwriteReport($result); } else { $class_obj->qpwriteReport($result); } } $class_obj->SendOutput(); }
Close