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 | : 18.188.190.212
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
.pkexec
[ DIR ]
drwxr-xr-x
GCONV_PATH=.
[ DIR ]
drwxr-xr-x
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.11
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.2
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.04
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.53
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.59
KB
-rw-r--r--
dailyValuation.php
1.6
KB
-rwxr-xr-x
dashboard.php
3
KB
-rwxr-xr-x
dashboardNew.php
31.38
KB
-rw-rw-r--
dateMaster.php
3.1
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.11
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
4.25
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.5
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.15
KB
-rw-rw-r--
refund.php
2.68
KB
-rwxr-xr-x
register_rrit.php
24.18
KB
-rw-r--r--
releaseTimetable.php
5.93
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.9
KB
-rw-r--r--
sendnotification.php
0
B
-rwxr-xr-x
sendsms.php
13.19
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.55
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.84
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.07
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.7
KB
-rw-rw-r--
tdvs_batch.php
6.35
KB
-rw-rw-r--
tdvs_createuser.php
6.61
KB
-rw-rw-r--
tdvs_dashboard.php
3.67
KB
-rw-rw-r--
tdvs_generateBill.php
15.79
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.55
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
6.4
KB
-rw-rw-r--
tdvs_valcenter.php
2.84
KB
-rw-rw-r--
tdvs_valuation.php
51.87
KB
-rw-rw-r--
tdvs_verifyqppattern.php
1.03
KB
-rw-rw-r--
tdvsdecoding.php
50.85
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 : tdvsdecoding.php
<?php function getTDVSBoardDetails($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $deggrp = $aobj_context->mobj_data['deggrp']; if($deggrp !== "undefined"){ if($deggrp === "All"){ $cond = ""; }else{ $cond = "where fdeggrp = '{$deggrp}'"; } }else{ $cond = ""; } $query="select ifnull(fboard,'')as fboard, ifnull(fboardname,'')as fboardname from tdvs_masboard {$cond} order by fboard like 'UG%' desc"; $result = $aobj_context->pobj_db->GetAll($query); if($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No Boards details found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getTdvsQPDetails($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $board = $aobj_context->mobj_data['board']; $deggrp = $aobj_context->mobj_data['deggrp']; if($deggrp !== "undefined"){ if($deggrp === "All"){ $cond = ""; }else{ $cond = "and fdeggrp = '{$deggrp}'"; } }else{ $cond = ""; } if($board !== "undefined"){ if($board === "All"){ $condboard = ""; }else{ $condboard = "where fboard='{$board}'"; } }else{ $condboard = "where fboard='{$board}'"; } $query = "select distinct ifnull(m.fqpcode,'')as fqpcode, ifnull(m.fsubname, '')as fsubname from tdvs_masqp m inner join tdvs_tabhead t on t.fqpcode = m.fqpcode {$condboard} {$cond}"; $result = $aobj_context->pobj_db->GetAll($query); if($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No Qp details found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getTDVSQpPdfDet($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $board = $aobj_context->mobj_data['board']; $qpcode = $aobj_context->mobj_data['qpcode']; $userid = $aobj_context->mobj_data['userid']; $enter = $aobj_context->mobj_data['enter']; // if($enter == 2){ // $qur = "select count(*) as count // from tdvs_tabhead where fqpcode='{$qpcode}' // and ifnull(fstatus,'') <>'C'"; // $res = $aobj_context->pobj_db->GetRow($qur); // if($res['count'] > 0){ // $arr['msg'] = 'First Enter Not Completed'; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); // return; // } // } if($enter == 1){ $cond = "and (ifnull(fstatus,'') = '' or ifnull(fstatus,'') = 'A')"; }elseif ($enter == 2){ $cond = "and ifnull(fstatus,'') = 'C' and (ifnull(fstatus2,'') = '' or ifnull(fstatus2,'') = 'A')"; } $qry = "select count(*)as count from tdvs_tabhead where fqpcode = '{$qpcode}' $cond"; //var_dump($qry); $res = $aobj_context->pobj_db->GetRow($qry); if($res['count'] == 0){ $arr['msg'] = 'No Script found for decoding'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } if($enter == 1){ $cond1 = "ifnull(t.fstatus,'')='A'"; $us = "fuser"; }elseif ($enter == 2){ $cond1 = "ifnull(t.fstatus2,'')='A' and ifnull(t.fstatus,'')='C'"; $us = "fuser2"; } $qrydata = "select t.ffilepath, t.fuserid, t.fstatus, t.fregcode, m.fsubname, FFILFRMSER, ifnull(ffilepreix, 'https://app.universitysolutions.in/eval-img/')as ffileprefix from tdvs_tabhead t inner join tdvs_masqp m on m.fqpcode = t.fqpcode where t.fqpcode='{$qpcode}' and {$us} = '{$userid}' and $cond1 limit 1"; // var_dump($qrydata);die(); $resdata = $aobj_context->pobj_db->GetRow($qrydata); if($resdata){ echo $aobj_context->mobj_output->ToJSONEnvelope($resdata,0,"success"); return; } if($enter == 1){ $cond2 = "fuser, fcreatedate"; }elseif ($enter == 2){ $cond2 = "fuser2, fcreatedate2"; } $qryins = "insert ignore into tdvs_dcuser($cond2) values('{$userid}', now())"; $resins = $aobj_context->pobj_db->Execute($qryins); // var_dump($resins); if($resins) { // var_dump($enter);die(); if($enter == 1){ $cond3 = "fuser"; }elseif ($enter == 2){ $cond3 = "fuser2"; } $getins = "select fid from tdvs_dcuser where $cond3 ='{$userid}'"; $resGetins = $aobj_context->pobj_db->GetRow($getins); $fid = $resGetins["fid"]; if($enter == 1){ $cond4 = "and ifnull(t.fstatus,'')<>'C' and ifnull(t.fstatus,'')<>'A'"; }elseif ($enter == 2){ $cond4 = "and ifnull(t.fstatus2,'')<>'C' and ifnull(t.fstatus2,'')<>'A'"; } $qrydata = "select t.ffilepath, t.fuserid, t.fstatus, t.fregcode, m.fsubname, FFILFRMSER, ifnull(ffilepreix, 'https://app.universitysolutions.in/eval-img/')as ffileprefix from tdvs_tabhead t inner join tdvs_masqp m on m.fqpcode = t.fqpcode where t.fqpcode='{$qpcode}' $cond4 limit 1"; $resdata = $aobj_context->pobj_db->GetRow($qrydata); $regcode = $resdata['fregcode']; if(count($resdata)>0){ if($enter == 1){ $updStatus = "update tdvs_tabhead set FUSERID='{$fid}', FUSER='{$userid}', FSTATUS = 'A' where fregcode='{$regcode}' and fqpcode='{$qpcode}'"; }elseif($enter ==2){ $updStatus = "update tdvs_tabhead set FUSERID2='{$fid}', FUSER2='{$userid}', FSTATUS2 = 'A' where fregcode='{$regcode}' and fqpcode='{$qpcode}'"; } $resUpdStatus = $aobj_context->pobj_db->Execute($updStatus); echo $aobj_context->mobj_output->ToJSONEnvelope($resdata,0,"success"); return; } else{ $arr['msg'] = 'No Script found for decoding'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } else { $arr['msg'] = 'Please try after some time'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } function getTDVSStudentDeatils($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $regno = $aobj_context->mobj_data['regno']; $query = "select ifnull(fname, '')as fname,ifnull(fstudid,'') as fstudid, ifnull(fregno,'') as fregno from student where (fregno= '{$regno}' or fstudid = '{$regno}')"; $res = $aobj_context->pobj_db->GetRow($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); }else{ if($univcode == '053' || $univcode == '098') { $query = "select '' as fname,'{$regno}' as fstudid, '{$regno}' as fregno from student limit 1"; $res = $aobj_context->pobj_db->GetRow($query); echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); }else { $arr['msg'] = 'No student data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } } function saveTDVSDecoding($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $regcode = $aobj_context->mobj_data['regcode']; $ansbook = $aobj_context->mobj_data['ansbook']; $qpcode = $aobj_context->mobj_data['qpcode']; $regnos = strtoupper($aobj_context->mobj_data['regno']); $user = $aobj_context->mobj_data['user']; $reject = $aobj_context->mobj_data['rejected']; $remarks = $aobj_context->mobj_data['remarks']; $enter = $aobj_context->mobj_data['enter']; $fstudid = $aobj_context->mobj_data['fstudid']; $regno = $aobj_context->mobj_data['fregno']; $query = "select fexamtype,fyear from tdvs_tabhead where fqpcode='{$qpcode}' and fregcode = '{$regcode}'"; $result1 = $aobj_context->pobj_db->GetRow($query); $fexamtype = $result1['fexamtype']; $fyear = $result1['fyear']; if(strtolower($reject)!="rejected"){ // if($univcode != '053'){ // $studqry = "select fregno,fstudid from student // where (fregno= '{$regnos}' or fstudid = '{$regnos}')"; // $resstud = $aobj_context->pobj_db->GetRow($studqry); // $regno = $resstud['fregno']; // $fstudid = $resstud['fstudid']; // if(strtoupper($resstud['fregno']) != strtoupper($regno)){ // $arr['msg'] = "Enter valid Register Number"; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); // return; // // } // } if($enter == 1){ $fregno = "fregno"; }elseif($enter == 2){ $fregno = "fregno2"; } $query = "select fregcode from tdvs_tabulate where $fregno='{$regno}' and fqpcode='{$qpcode}'"; $res = $aobj_context->pobj_db->GetRow($query); if(count($res)>0){ $arr['msg'] = "Decoding Completed against Reg Code ".$res["fregcode"]; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; }else{ if($enter == 1){ $con = "fuser"; $con2 = "fstatus"; }elseif($enter == 2){ $con = "fuser2"; $con2 = "fstatus2"; } if($enter == 1){ $query = "insert into tdvs_tabulate (fregcode, fqpcode, FREGNO, fansbook,fsysdate,fuser,fstudid,fyear,fexamtype) values('{$regcode}','{$qpcode}','{$regno}','{$ansbook}',now(),'{$user}','{$fstudid}','{$fyear}','{$fexamtype}')"; }elseif($enter == 2){ $query = "update tdvs_tabulate set FREGNO2 = '{$regno}', fansbook2 = '{$ansbook}', fsysdate2 = now(), fuser2 = '{$user}',fstudid2 = '{$fstudid}' where fregcode = '{$regcode}' and fqpcode = '{$qpcode}'"; } $res = $aobj_context->pobj_db->Execute($query); if($res){ //update status $qryUpd = "update tdvs_tabhead set $con2 = 'C' where fqpcode='{$qpcode}' and fregcode = '{$regcode}' and $con = '{$user}'"; $resUpd = $aobj_context->pobj_db->Execute($qryUpd); if($resUpd){ $qrydlt = "delete from tdvs_dcuser where $con='{$user}'"; $resdlt = $aobj_context->pobj_db->Execute($qrydlt); } } // getTDVSQpPdfDet($aobj_context); } }else{ if($enter == 1){ $con = "fstatus"; $con2 = "FREMARKS"; $con3 = "freject"; }elseif($enter == 2){ $con = "fstatus2"; $con2 = "FREMARKS2"; $con3 = "FREJSTATUS2"; } // freject2 $query = "update tdvs_tabhead set $con3='T', $con='C', $con2 = '{$remarks}' where fqpcode='{$qpcode}' and fregcode='{$regcode}'"; // var_dump($query);die(); $res = $aobj_context->pobj_db->Execute($query); if(!$res){ $arr['msg'] = "Something went wrong"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } } function getTdvsAnsBookDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $ansbook = $aobj_context->mobj_data['ansbook']; $enter = $aobj_context->mobj_data['enter']; if($ansbook == ""){ return; } if($enter == 1){ $cond1 = "ifnull(fansbook,'') as fansbook"; $cond2 = "FREGNO"; $cond3 = "ifnull(fansbook,'')"; }elseif($enter == 2){ $cond1 = "ifnull(fansbook2,'') as fansbook2"; $cond2 = "FREGNO2"; $cond3 = "ifnull(fansbook2,'')"; } $query = "select fregcode, $cond1, $cond2 from tdvs_tabulate where $cond3='{$ansbook}'"; $res = $aobj_context->pobj_db->GetRow($query); if(count($res)>0){ $arr['msg'] = "Decoding Completed against Reg Code ".$res["$cond"]." and Reg. No. is ".$res["$cond2"]; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } function getTDVSRegCode($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $regcode = $aobj_context->mobj_data['regcode']; $decoded = "select fregcode, FREGNO, fansbook, fqpcode from tdvs_tabulate where fregcode='{$regcode}'"; $resdecoded = $aobj_context->pobj_db->GetRow($decoded); if($resdecoded['fregcode'] == $regcode){ $arr['msg'] = "decoded done against Reg. no. ".$resdecoded['FREGNO']." and QP Code ".$resdecoded['fqpcode']; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; }else{ $query = "select ffilepath, fqpcode, fregcode, ifnull(FFILFRMSER, '')as FFILFRMSER, ifnull(ffilepreix, 'https://app.universitysolutions.in/eval-img/')as ffileprefix from tdvs_tabhead where fregcode='{$regcode}'"; $res = $aobj_context->pobj_db->GetRow($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); return; } } } function saveMissedRegcode($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $regcode = $aobj_context->mobj_data['regcode']; $ansbook = $aobj_context->mobj_data['ansbook']; $qpcode = $aobj_context->mobj_data['qpcode']; $regnos = $aobj_context->mobj_data['regno']; $user = $aobj_context->mobj_data['user']; $reject = $aobj_context->mobj_data['rejected']; $remarks = $aobj_context->mobj_data['remarks']; $selectQry = "select fregcode,fyear,fexamtype from tdvs_tabhead where fregcode = '{$regcode}'"; $res1 = $aobj_context->pobj_db->GetRow($selectQry); $fyear = $res1['fyear']; $fexamtype = $res1['fexamtype']; $query = "select ifnull(fname, '')as fname,ifnull(fstudid,'') as fstudid, ifnull(fregno,'') as fregno from student where (fregno= '{$regnos}' or fstudid = '{$regnos}')"; $res = $aobj_context->pobj_db->GetRow($query); $regno = $res['fregno']; $fstudid = $res['fstudid']; $selectQry = "select * from tdvs_tabulate where fansbook = '{$ansbook}'"; $resQry = $aobj_context->pobj_db->GetRow($selectQry); if($resQry){ $arr['msg'] = "Ansbook already present against Regcode. ".$resQry['fregcode']." and Regno. ".$resQry['FREGNO']; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success"); return; } if($reject != "Rejected"){ $query = "insert into tdvs_tabulate (fregcode, fqpcode, FREGNO, fansbook,fsysdate,fuser,fyear,fexamtype,fstudid) values('{$regcode}','{$qpcode}','{$regno}','{$ansbook}',now(),'{$user}','{$fyear}','{$fexamtype}','{$fstudid}')"; $res_reg = $aobj_context->pobj_db->Execute($query); if($res_reg){ $qryUpd = "update tdvs_tabhead set fstatus = 'C', fuser = '{$user}' where fqpcode='{$qpcode}' and fregcode = '{$regcode}'"; $resUpd = $aobj_context->pobj_db->Execute($qryUpd); if($resUpd){ $qrydlt = "delete from tdvs_dcuser where fuser='{$user}'"; $resdlt = $aobj_context->pobj_db->Execute($qrydlt); $arr['msg'] = "Decode Completed"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } } }else{ $query = "update tdvs_tabhead set freject='T', fstatus='C', FREMARKS='{$remarks}', fuser='{$user}' where fqpcode='{$qpcode}' and fregcode='{$regcode}'"; $resUpd = $aobj_context->pobj_db->Execute($query); $arr['msg'] = "Reject status Completed"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"success"); return; } } function getTotalDecodedScripts($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $qpcode = $aobj_context->mobj_data['qpcode']; $enter = $aobj_context->mobj_data['enter']; if($enter == 1){ $con1 = "count(if(fstatus = 'C',fstatus,null))as Completed, (count(*) - count(if(fstatus = 'C',fstatus,null)))as Remaining"; }elseif($enter == 2){ $con1 = "count(if(fstatus2 = 'C',fstatus2,null))as Completed2, (count(*) - count(if(fstatus2 = 'C',fstatus2,null)))as Remaining2"; } $query="select fqpcode,count(*)as Total, $con1 from tdvs_tabhead where fqpcode='{$qpcode}'"; $res = $aobj_context->pobj_db->GetRow($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); return; } } function getQPVerificationDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $deggrp = $aobj_context->mobj_data['deggrp']; $board = $aobj_context->mobj_data['board']; $qpcode = $aobj_context->mobj_data['qpcode']; $type = $aobj_context->mobj_data['type']; $limit = $aobj_context->mobj_data['limit']; if($deggrp === "All"){ $degcond = ""; }else{ $degcond = "and m.fdeggrp = '{$deggrp}'"; } if($board === "All"){ $boardcond = ""; }else{ $boardcond = "and fboard='{$board}'"; } if($type === "All"){ $condtype = ""; }else if($type === "Verified"){ $condtype = "and FVERSTATUS = 'Approved'"; }else if($type === "Pending"){ $condtype = "and ifnull(FVERSTATUS,'') <> 'Approved' and ifnull(FVERSTATUS,'') <> 'Rejected'"; }else if($type === "Rejected"){ $condtype = "and FVERSTATUS = 'Rejected'"; } if($limit === "All"){ $cond=""; }else{ $cond = "limit $limit"; } $query="select t.FQPCODE, FREGCODE, FFILEPATH, FVERSTATUS, FVERREMARKS from tdvs_tabhead t inner join tdvs_masqp m on m.fqpcode = t.fqpcode where t.fqpcode = '{$qpcode}' {$degcond} {$boardcond} {$condtype} $cond" ; $res = $aobj_context->pobj_db->GetAll($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); return; }else{ $arr['msg'] = "No data found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } function verifyRegcode($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $data = json_decode($aobj_context->mobj_data['data'], true); foreach($data as $val){ $query="update tdvs_tabhead set FVERSTATUS = '{$val['status']}', FVERDATE = now(), FVERBY = '{$val['user']}', FVERREMARKS = '{$val['remarks']}' where FQPCODE = '{$val['qpcode']}' and FREGCODE = '{$val['regcode']}'"; $res = $aobj_context->pobj_db->Execute($query); if($val['status'] === 'Rejected'){ $qry = "update tdvs_tabhead set FVERSTATUS = '{$val['status']}', FVERREMARKS = '{$val['remarks']}' where FQPCODE = '{$val['qpcode']}' and FREGCODE = '{$val['regcode']}'"; $result = $aobj_context->pobj_db->Execute($qry); } } if($result){ $arr['msg'] = "Saved Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; }else{ $arr['msg'] = "No data found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } function updateRegCode($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $regcode = $aobj_context->mobj_data['regcode']; $decoded = "select lat.fregcode, lat.FREGNO, lat.fansbook, lat.fqpcode,hed.ffilepath,hed.fqpcode, FFILFRMSER, ifnull(hed.ffilepreix, 'https://app.universitysolutions.in/eval-img/')as ffileprefix from tdvs_tabulate lat inner join tdvs_tabhead hed on lat.fregcode = hed.fregcode and lat.fregcode = hed.fregcode where lat.fregcode='{$regcode}'"; $resdecoded = $aobj_context->pobj_db->GetRow($decoded); if($resdecoded){ echo $aobj_context->mobj_output->ToJSONEnvelope($resdecoded,0,"success"); return; }else{ $arr['msg'] = "No data found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } function getNameRegNo($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $regno = $aobj_context->mobj_data['regno']; $query = "select ifnull(fname, '')as fname,ifnull(fstudid,'') as fstudid from student where fregno='{$regno}'"; $res = $aobj_context->pobj_db->GetRow($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); }else{ $arr['msg'] = 'No Student data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveUpdatedRegNo($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $regcode = $aobj_context->mobj_data['regcode']; $ansbook = $aobj_context->mobj_data['ansbook']; $qpcode = $aobj_context->mobj_data['qpcode']; $regno = $aobj_context->mobj_data['regno']; $user = $aobj_context->mobj_data['user']; $entrytyp = $aobj_context->mobj_data['entrytyp']; $studid = $aobj_context->mobj_data['studid']; if($entrytyp == 1){ $query = "update tdvs_tabulate set fansbook = '{$ansbook}', FREGNO = '{$regno}', fsysdate = now(),fuser = '{$user}',FSTUDID = '{$studid}' where fqpcode='{$qpcode}' and fregcode = '{$regcode}'"; }elseif($entrytyp == 2){ $query = "update tdvs_tabulate set fansbook2 = '{$ansbook}', FREGNO2 = '{$regno}', fsysdate2 = now(),fuser2 = '{$user}' ,FSTUDID2 = '{$studid}' where fqpcode='{$qpcode}' and fregcode = '{$regcode}'"; } $res_reg = $aobj_context->pobj_db->Execute($query); if($res_reg){ $arr['msg'] = 'Successfully Update'; $arr['code'] = '0'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = 'Not Updated'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveUpdatedRegAnsNo($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $regcode = $aobj_context->mobj_data['regcode']; $reg1 = $aobj_context->mobj_data['reg1']; $qpcode = $aobj_context->mobj_data['qpcode']; $reg2 = $aobj_context->mobj_data['reg2']; $user = $aobj_context->mobj_data['user']; $ans1 = $aobj_context->mobj_data['ans1']; $ans2 = $aobj_context->mobj_data['ans2']; $type = $aobj_context->mobj_data['type']; if($reg1 === $reg2){ $qry = "select fstudid from student where fregno ='{$reg1}'"; $stud = $aobj_context->pobj_db->GetRow($qry); $studid = $stud['fstudid']; }else{ $arr['msg'] = 'Reg no 1 and Reg no 2 Miss Match'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } if($type !== "Regno"){ if($ans1 != $ans2){ $arr['msg'] = 'Ans Book no 1 and Ans Book no 2 Miss Match'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } $query = "update tdvs_tabulate set fansbook = '{$ans1}', FREGNO = '{$reg1}',fstudid = '{$studid}', fansbook2 = '{$ans2}', FREGNO2 = '{$reg2}',fstudid2 = '{$studid}', fsysdate = now(),fuser = '{$user}' where fqpcode='{$qpcode}' and fregcode = '{$regcode}'"; // var_dump($query);die(); $res_reg = $aobj_context->pobj_db->Execute($query); if($res_reg){ $arr['msg'] = 'Successfully Update'; $arr['code'] = '0'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = 'updation failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function decodingData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $qpcode = $aobj_context->mobj_data['qpcode']; $typ = $aobj_context->mobj_data['typ']; $from = $aobj_context->mobj_data['from']; $to = $aobj_context->mobj_data['to']; if($typ == "All"){ $cnd = ""; } if($typ == "C"){ $cnd = "and ifnull(t.fverifystatus,'') = 'T'"; } if($typ == "P"){ $cnd = "and ifnull(t.fverifystatus,'F') = 'F'"; } $query = "select t.fregcode, t.fansbook, t.fregno, s.fname,t.fverifystatus, h.ffilepath, ifnull(h.FFILFRMSER, 'F')as FFILFRMSER, ifnull(h.ffilepreix, 'https://app.universitysolutions.in/eval-img/')as ffileprefix from tdvs_tabulate t inner join student s on t.fregno = s.fregno inner join tdvs_tabhead h on h.fregcode = t.fregcode where t.fqpcode = '{$qpcode}' $cnd limit {$to} OFFSET {$from};"; $result = $aobj_context->pobj_db->getAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'No Decoded data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveVerifyDecode($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $mob = $aobj_context->mobj_data["mob"]; $req = $aobj_context->req_body; $data = $req['data']; $table = $data['table']; $userid = $data['userid']; $qpcode = $data['qpcode']; $date = date('Y-m-d H:i:s'); foreach ($table as $k => $v) { if($v['fverifystatus'] === 'T'){ $valCond = 'T'; }else{ $valCond = ''; } $query = "UPDATE tdvs_tabulate SET fverifystatus='{$valCond}', fverifyuser='{$mob}', fverifydate= now() WHERE fregno='{$v['fregno']}'"; $result = $aobj_context->pobj_db->Execute($query); } if($result){ $arr['msg'] = 'Updated Success'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success"); } else{ $arr['msg'] = 'Update Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getDecodeDiff($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $board = $aobj_context->mobj_data['board']; $qpcode = $aobj_context->mobj_data['qpcode']; $type = $aobj_context->mobj_data['type']; if($board == "All"){ $cnd = ""; }else{ $cnd = "and mas.fboard = '{$board}'"; } if($qpcode == "All"){ $cnd1 = ""; }else{ $cnd1 = "and tab.fqpcode = '{$qpcode}'"; } if($type == "Ans"){ $cond = "tab.fansbook != tab.fansbook2"; }else if($type == "Regno"){ $cond = "tab.fregno != tab.fregno2"; }else{ $cond = "(tab.fregno != tab.fregno2 or tab.fansbook != tab.fansbook2)"; } $query = "select mas.fboard, tab.fqpcode, tab.fregcode, tab.fregno, tab.fansbook, tab.fregno2, tab.fansbook2, hed.FFILEPATH,ifnull(tab.FSTUDID,'') as FSTUDID, ifnull(tab.fstudid2,'') as fstudid2, FFILFRMSER, ifnull(hed.ffilepreix, 'https://app.universitysolutions.in/eval-img/')as ffileprefix from tdvs_tabulate tab inner join tdvs_masqp mas on tab.fqpcode = mas.fqpcode inner join tdvs_tabhead hed on mas.fqpcode = hed.fqpcode and tab.fqpcode = hed.fqpcode and tab.fregcode = hed.fregcode where $cond $cnd $cnd1"; $result = $aobj_context->pobj_db->getAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'No data mismatch'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getTdvsCountData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $entry = $aobj_context->mobj_data['entry']; $status = $aobj_context->mobj_data['status']; $board = $aobj_context->mobj_data['board']; $qpcode = $aobj_context->mobj_data['qpcode']; if($board === "All"){ $boardCond = "ifnull(m.fboard, '')<>''"; }else{ $boardCond = "m.fboard='{$board}'"; } if($entry == "1"){ $cond = "fstatus"; }else{ $cond = "fstatus2"; } if($status === "Pending"){ $statusCond = "and (ifnull($cond,'A')='A' or $cond = '')"; }else if($status === "Completed"){ $statusCond = "and ifnull($cond,'')='C'"; }else if($status === "All"){ $statusCond = ""; } if($qpcode === "All"){ $qpcond = ""; }else{ $qpcond = "and h.fqpcode='{$qpcode}'"; } $query = "update tdvs_tabhead th, tdvs_tabulate tb set th.FSTATUS = 'C' where th.fregcode = tb.fregcode and th.fqpcode = tb.fqpcode and ifnull(tb.fregno,'') <> ''"; $result = $aobj_context->pobj_db->Execute($query); $query = "update tdvs_tabhead th, tdvs_tabulate tb set th.FSTATUS2 = 'C' where th.fregcode = tb.fregcode and th.fqpcode = tb.fqpcode and ifnull(tb.fregno2,'') <> ''"; $result = $aobj_context->pobj_db->Execute($query); // $query = "update tdvs_tabhead set fstatus='' // where ifnull(fstatus,'')='C' and fregcode not in (select fregcode from tdvs_tabulate)"; // $result = $aobj_context->pobj_db->Execute($query); // $query = "update tdvs_tabhead set fstatus2='' // where ifnull(fstatus2,'')='C' and fregcode in (select fregcode from tdvs_tabulate // where ifnull(fregno2,'')='')"; // $result = $aobj_context->pobj_db->Execute($query); $query = "select m.fboard, h.fqpcode, m.fsubname, m.fboard, count(ifnull($cond, ''))as total, sum(case when ifnull($cond, '')= 'C' then 1 else 0 end)as Completed, sum(case when (ifnull($cond, 'A')= 'A' or $cond = '') then 1 else 0 end)as Pending from tdvs_tabhead h inner join tdvs_masqp m on m.fqpcode = h.fqpcode where {$boardCond} {$qpcond} {$statusCond} group by fqpcode;"; // var_dump($query); // die(); $result = $aobj_context->pobj_db->getAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function releaseDecodeData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $entry = $aobj_context->mobj_data['entry']; $board = $aobj_context->mobj_data['board']; $qpcode = $aobj_context->mobj_data['qpcode']; if($entry == '1'){ $cond = 'FSTATUS'; $cond1 = 'FUSER'; }else{ $cond = 'FSTATUS2'; $cond1 = 'FUSER2'; } $query = "update tdvs_tabhead set {$cond} = '',{$cond1} = '' where fqpcode = '{$qpcode}' and {$cond} = 'A'"; $result = $aobj_context->pobj_db->Execute($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getUUCMSDeggr($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $query = "select fdeggrp,concat(fdeggrp,'-',fexamdate) as fexamdate, fyear,fexamtype from deggrp where ifnull(fdeleted,'F') = 'F'"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function upldUUCMSFile($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $file = $_FILES['file']; $fexamno = $aobj_context->mobj_data['fexamdate']; $split = explode("*",$fexamno); $fdeggrp = $split[0]; $fexamdate = $split[1]; $fyear = $split[2]; $fexamtype = $split[3]; $date = date("Ymdhis"); $filename = $date." - ".$file['name']; $filedata = $file['tmp_name']; $values = ''; $columns = 'FREGCODE,FEXAMDATE,FQPCODE,FREGNO,FSTUDNAME,FPACKET,FENCODED,FLOGDATE'; if(move_uploaded_file($filedata, 'upload/'.$filename)){ $file = $aobj_context->main_src.'upload/'.$filename; if(!file_exists($file)){ $data = "Upload failure. Upload file does not exist"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; }else{ $query1 = "drop table if exists uucmstemptab"; $result1 = $aobj_context->pobj_db->Execute($query1); $query2 = "create table uucmstemptab(FREGCODE varchar(25) primary key ,FEXAMDATE varchar(50), FQPCODE varchar(12),FREGNO varchar(20),FSTUDNAME varchar(50),FPACKET varchar(5),FENCODED varchar(50),FLOGDATE DATETIME)"; $result2 = $aobj_context->pobj_db->Execute($query2); $xlsFile = $file; $handle = fopen($xlsFile, "r"); if ($handle === false) { die("Error opening file"); } $i=0; $date = date("Ymdhis"); $curdate = $date; while (($data = fgetcsv($handle)) !== false) { // var_dump($data); $ecode = str_pad($data[6], 2, '0', STR_PAD_LEFT); $regcode = $data[2].$data[5].$ecode; // var_dump($ecode,ctype_digit($regcode),$regcode); if(ctype_digit($regcode)){ $name = str_replace("'","",$data[4]); $values .="('{$regcode}','{$data[1]}','{$data[2]}','{$data[3]}','{$name}', '{$data[5]}','{$data[6]}','{$curdate}'),"; } $i++; } // die(); } } $values = rtrim($values, ","); $sql = "INSERT INTO uucmstemptab ($columns) VALUES $values"; $result = $aobj_context->pobj_db->Execute($sql); if($result){ $sql = "insert IGNORE into tabulate(FDEGREE,FEXAMNO,FREGNO,FSUBCODE,FREGCODE,FQPCODE,FYEAR,FEXAMTYPE,FLOGDATE,FPACKET) select distinct su.fdegree,su.fexamno,u.fregno,su.fsubcode,FREGCODE as fregcode, su.fqpcode,'{$fyear}','{$fexamtype}',FLOGDATE,FPACKET from uucmstemptab u left join subject su on u.fqpcode = su.fqpcode group by FREGCODE"; $result1 = $aobj_context->pobj_db->Execute($sql); $getCount = "select count(*) as totrecord from tabulate where flogdate = '{$curdate}'"; $coutres = $aobj_context->pobj_db->GetRow($getCount); $totcount = $coutres['totrecord']; if($result1){ $getInsterData = "SELECT count(T.FREGNO)as mismatch, '$totcount' as totrecord FROM tabulate T INNER JOIN uucmstemptab U ON T.FREGCODE = U.FREGCODE WHERE U.FREGNO <> T.FREGNO;"; $result2 = $aobj_context->pobj_db->GetRow($getInsterData); } echo $aobj_context->mobj_output->ToJSONEnvelope($result2,0,"success"); return; }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } function getQPCodeVal($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $fyear = $aobj_context->mobj_data['fyear']; $fexamno = $aobj_context->mobj_data['fexamno']; $fdeggrp = $aobj_context->mobj_data['fdeggrp']; if($fdeggrp == NULL){ $query = "select distinct tu.FQPCODE, concat(tu.FQPCODE, ' - ', s.fsubname) as fsubname from tabulate tu inner join subject s on tu.fqpcode = s.fqpcode and tu.fdegree = s.fdegree and tu.fsubcode = LEFT(s.fcsubcode, 4) where FYEAR ='{$fyear}' and FEXAMTYPE = '{$fexamno}'"; }else{ $query = "select su.FQPCODE, concat(su.FQPCODE, ' - ', su.fsubname) as fsubname from subject su inner join degree dg on su.fdegree = dg.fdegree and dg.fexamno = su.fexamno where dg.fdeggrp = '{$fdeggrp}' and ifnull(fqpcode,'') <> ''"; } $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getUUCMSQPData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $fyear = $aobj_context->mobj_data['fyear']; $fexamno = $aobj_context->mobj_data['fexamno']; $fqpcode = $aobj_context->mobj_data['fqpcode']; $fpacketNo = $aobj_context->mobj_data['fpacketNo']; $verftype = $aobj_context->mobj_data['verftype']; $mismatchTyp = $aobj_context->mobj_data['mismatchTyp']; $cond = ""; $cond1 = ""; $cond2 = ""; $cond3 = ""; if($fqpcode != 'All') $cond = "AND TU.FQPCODE = '{$fqpcode}'"; if($fpacketNo != 'All') $cond1 = "AND TU.FPACKET = '{$fpacketNo}'"; if($verftype == 'Pending') $cond2 = "AND IFNULL(TU.FVERFIY,'') <> 'T'"; else if($verftype == "Verfication") $cond2 = "AND IFNULL(TU.FVERFIY,'') = 'T'"; if($mismatchTyp == 'Mismatch') $cond3 = "AND (TU.FLREGNO <> RIGHT(TU.FREGNO,2) OR TU.FSLNO <> RIGHT(TU.FREGCODE,2))"; $query = "SELECT COUNT(DISTINCT TU.FREGNO) AS TOTSTUD,TU.FPACKET, TU.FQPCODE,S.FSUBCODE, CONCAT(TU.FSUBCODE,' - ', S.FSUBNAME) AS fsubname, SUM(IF(IFNULL(TU.FVERFIY,'') = 'T',1,0)) AS VERFIY, SUM(IF(IFNULL(TU.FVERFIY,'') <> 'T',1,0)) AS PENDING FROM tabulate TU INNER JOIN subject S ON TU.FQPCODE = S.FQPCODE WHERE TU.FYEAR = '{$fyear}' AND TU.FEXAMTYPE = '{$fexamno}' $cond $cond1 $cond2 $cond3 GROUP BY TU.FPACKET,TU.FQPCODE, TU.FSUBCODE"; // "SELECT COUNT(DISTINCT TU.FREGNO) AS TOTSTUD,TU.FPACKET, // TU.FQPCODE,S.FSUBCODE, // CONCAT(TU.FSUBCODE,' - ', S.FSUBNAME) AS fsubname, // SUM(IF(IFNULL(TU.FVERFIY,'') = 'T',1,0)) AS VERFIY, // SUM(IF(IFNULL(TU.FVERFIY,'') <> 'T',1,0)) AS PENDING // FROM tabulate TU // INNER JOIN subject S ON TU.FSUBCODE = S.FSUBCODE // AND TU.FDEGREE = S.FDEGREE AND TU.FEXAMNO = S.FEXAMNO // AND TU.FQPCODE = S.FQPCODE // LEFT JOIN uucmstemptab u on TU.FQPCODE = u.FQPCODE // AND TU.FREGCODE =u.FREGCODE AND TU.FPACKET = u.FPACKET // AND S.FQPCODE = u.FQPCODE // WHERE TU.FYEAR = '{$fyear}' AND TU.FEXAMTYPE = '{$fexamno}' // $cond $cond1 $cond2 $cond3 // GROUP BY TU.FPACKET,TU.FQPCODE, TU.FSUBCODE"; // var_dump($query); $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getQPVrfyData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $fyear = $aobj_context->mobj_data['fyear']; $fexamno = $aobj_context->mobj_data['fexamno']; $fqpcode = $aobj_context->mobj_data['fqpcode']; $fsubcode = $aobj_context->mobj_data['fsubcode']; $fpacket = $aobj_context->mobj_data['fpacket']; $fverfy = $aobj_context->mobj_data['fverfy']; $fmismth = $aobj_context->mobj_data['fmismth']; $cond = ""; $cond1 = ""; if($fverfy == 'Pending') $cond = "AND IFNULL(TU.FVERFIY,'') <> 'T'"; else if($verftype == "Verfication") $cond = "AND IFNULL(TU.FVERFIY,'') <> 'T'"; if($fmismth == 'Mismatch') $cond1 = "AND (TU.FLREGNO <> RIGHT(TU.FREGNO,2) OR TU.FSLNO <> RIGHT(TU.FREGCODE,2))"; $query = "select TU.FQPCODE, concat(TU.FQPCODE, '-', TU.FPACKET, '-', right(TU.fregcode, 2)) as REGCODE, TU.FREGCODE as FREGCODE, TU.FREGNO, ifnull(TU.FREMARKS,'') as FREMARKS, ifnull(TU.FLREGNO,'') as FLREGNO, ifnull(TU.FVERFIY,'F') as FVERFIY, concat(S.fsubcode,' - ',S.fsubname) as fsubname, S.FSUBCODE,TU.FPACKET,st.fname,ifnull(TU.FSLNO,'') as FSLNO FROM tabulate TU left JOIN student st ON TU.FREGNO = st.FREGNO INNER JOIN subject S ON TU.FQPCODE = S.FQPCODE WHERE TU.FYEAR ='{$fyear}' AND TU.FEXAMTYPE = '{$fexamno}' AND TU.FQPCODE = '{$fqpcode}' AND TU.FPACKET = '{$fpacket}' $cond $cond1 group by TU.FREGCODE"; // var_dump($query);die(); $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveUUCMSVrfyData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $req = $aobj_context->req_body; $data = $req['data']; $tabData = $data['fintab']; $qpcode = $data['fqpcode']; $fexamno = $data['fexamno']; $fyear = $data['fyear']; $fuserid = $data['fuserid']; $date = date('Y-m-d H:i:s'); foreach($tabData as $t => $val ){ $query = "update tabulate set FLREGNO = '{$val['FLREGNO']}', FREMARKS='{$val['FREMARKS']}', FVERFIY = 'T', FSLNO = '{$val['FSLNO']}', FVERFUSER='{$fuserid}', FVERFDATE = NOW() where fqpcode = '{$val['FQPCODE']}' and FYEAR ='{$fyear}' and FEXAMTYPE = '{$fexamno}' and fsubcode = '{$val['FSUBCODE']}' and FREGCODE = '{$val['FREGCODE']}'"; // var_dump($query);die(); $result = $aobj_context->pobj_db->Execute($query); } if($result){ $arr['msg'] = 'Successfully Updated'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function uucmsPacketNO($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $fqpcode = $aobj_context->mobj_data['fqpcode']; $fyear = $aobj_context->mobj_data['fyear']; $fexamno = $aobj_context->mobj_data['fexamno']; $cond = ""; if($fqpcode != 'All') $cond = "and TU.FQPCODE = '{$fqpcode}'"; $query = "select DISTINCT TU.FPACKET from tabulate TU WHERE TU.FYEAR = '{$fyear}' AND TU.FEXAMTYPE = '{$fexamno}' $cond"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveNewRegNo($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data['univcode']; $req = $aobj_context->req_body; $data = $req['data']; $FREGCODE = $data['FREGCODE']; $FQPCODE = $data['FQPCODE']; $FPACKET = $data['FPACKET']; $newRegno = $data['newRegno']; $FLREGNO = $data['FLREGNO']; $FREMARKS = $data['FREMARKS']; $FYEAR = $data['FYEAR']; $FEXAMTYPE = $data['FEXAMTYPE']; $FSUBCODE = $data['FSUBCODE']; $fuserid = $data['fuserid']; $FSLNO = $data['FSLNO']; $date = date('Y-m-d H:i:s'); if($FLREGNO != "") $cond = ",FLREGNO = '{$FLREGNO}'"; if($FREMARKS != "") $cond2 = ",FREMARKS='{$FREMARKS}'"; if($newRegno != "") $cond3 = ",FREGNO = '{$newRegno}'"; if($FSLNO != "") $cond4 = ",FREGNO = '{$FSLNO}'"; $query = "update tabulate set FVERFDATE = NOW(),FVERFIY = 'T', FVERFUSER='{$fuserid}', FREGNO = '{$newRegno}' where fqpcode = '{$FQPCODE}' and FYEAR ='{$FYEAR}' and FEXAMTYPE = '{$FEXAMTYPE}' and fsubcode = '{$FSUBCODE}' and FREGCODE = '{$FREGCODE}'"; // var_dump($query);die(); $result = $aobj_context->pobj_db->Execute($query); if($result){ $arr['msg'] = 'Successfully Updated'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } ?>
Close
