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.138.175.132
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
admission /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
admLeadReport.php
1.67
KB
-rw-rw-r--
adm_admin.php
75.41
KB
-rw-r--r--
adm_master.php
23.4
KB
-rw-r--r--
adm_register.php
133.02
KB
-rw-r--r--
adm_session_start.php
899
B
-rw-r--r--
app.php
416
B
-rwxr-xr-x
callCandMob.php
4.72
KB
-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
45.14
KB
-rw-rw-r--
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
9.42
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.22
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
2.46
KB
-rw-r--r--
stud_payments.php
3.33
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
whatsup.php
14.77
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : tdvs_pergeval.php
<?php function tdvs_yearmode($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $deggrp = $aobj_context->mobj_data["deggrp"]; $query = "select ifnull(FYEAR, '')as fyear, ifnull(FEXAMTYPE, '')as fexamtype from tdvs_deggrp where fdeggrp='{$deggrp}'"; $res = $aobj_context->pobj_db->GetRow($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res, 0, "success"); } else { $arr['msg'] = 'No Data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); } } function tdvs_getPergeValCount($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $deggrp = $aobj_context->mobj_data["deggrp"]; $year = $aobj_context->mobj_data["year"]; $mode = $aobj_context->mobj_data["mode"]; $sem = $aobj_context->mobj_data["sem"]; $sem_split = explode(",", $sem); foreach($sem_split as $key => $value){ $sem_val .= "'".$value."',"; } $sem_arr = substr_replace($sem_val ,"",-1); if($sem_arr === "'All'"){ $semCon = " "; }else{ $semCon = "and m.fexamno in ({$sem_arr})"; } $query = "select t.fqpcode, m.fsubname, t.fyear, t.fexamtype, sum(if(t.fvalno = 1,1,0)) as val1, sum(case when t.fvalno = '1' and ifnull(t.fstatus,'')='Final' then 1 else 0 end) as completed1, sum(if(t.fvalno = 2,1,0)) as val2, sum(case when t.fvalno = '2' and ifnull(t.fstatus,'')='Final' then 1 else 0 end) as completed2, sum(if(t.fvalno = 3,1,0)) as val3, sum(case when t.fvalno = '3' and ifnull(t.fstatus,'')='Final' then 1 else 0 end) as completed3, sum(if(t.fvalno = 4,1,0)) as val4, sum(case when t.fvalno = '4' and ifnull(t.fstatus,'')='Final' then 1 else 0 end) as completed4, sum(if(t.fvalno = 'D',1,0)) as valD, sum(case when t.fvalno = 'D' and ifnull(t.fstatus,'')='Final' then 1 else 0 end) as completedD, count(*) as totcnt, sum(case when ifnull(t.fstatus,'')='Final' then 1 else 0 end)as totcomp, m.fdeggrp, m.fexamno from tdvs_tabsum t inner join tdvs_masqp m on m.fqpcode = t.fqpcode where t.fexamtype = '{$mode}' and t.fyear = '{$year}' and m.fdeggrp='{$deggrp}' {$semCon} group by t.fqpcode order by fexamno"; // var_dump($query); // die(); $res = $aobj_context->pobj_db->GetAll($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res, 0, "success"); } else { $arr['msg'] = 'No Data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); } } function tdvs_saveTdvsPergeVal($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $data = json_decode($aobj_context->mobj_data["data"], true); $fsuccess = []; $ffailure = []; foreach($data as $val){ $condQry = "select count(*)as fcount from tdvs_tabsum where fqpcode='{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}' and ifnull(fstatus, '') <> 'final'"; $res = $aobj_context->pobj_db->GetRow($condQry); if($res['fcount'] <= 0){ $query = "insert ignore into tdvs_tabsum_bkp select * from tdvs_tabsum where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $res = $aobj_context->pobj_db->Execute($query); $delts = "delete from tdvs_tabsum where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $resdelts = $aobj_context->pobj_db->Execute($delts); $inshead = "insert ignore into tdvs_tabhead_bkp select * from tdvs_tabhead where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $resinshead = $aobj_context->pobj_db->Execute($inshead); $delhead = "delete from tdvs_tabhead where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $resdelhead = $aobj_context->pobj_db->Execute($delhead); $insdetl = "insert ignore into tdvs_tabdetl_bkp select * from tdvs_tabdetl where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $restabdetl = $aobj_context->pobj_db->Execute($insdetl); $deldetl = "delete from tdvs_tabdetl where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $resdeldetl = $aobj_context->pobj_db->Execute($deldetl); $instabulate = "insert ignore into tdvs_tabulate_bkp select * from tdvs_tabulate where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $restabulate = $aobj_context->pobj_db->Execute($instabulate); $deltabulate = "delete from tdvs_tabulate where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $resdeltabulate = $aobj_context->pobj_db->Execute($deltabulate); $delmasrev = "INSERT ignore INTO tdvs_masrev_bkp (FQPCODE, FVALNO, FTEACHCODE, FREVCODE, FBOARD, FMAXSCR, FYEAR, FEXAMTYPE, FSUSPEND, FDELETED, FLASTDATE, fstartdate, FEMAILSENT, FEMAILDATE, FCREATEDATE, FUPDATEDATE, FCREATEUSER, FUPDATEUSER) select FQPCODE, FVALNO, FTEACHCODE, FREVCODE, FBOARD, FMAXSCR, FYEAR, FEXAMTYPE, FSUSPEND, FDELETED, FLASTDATE, fstartdate, FEMAILSENT, FEMAILDATE, FCREATEDATE, FUPDATEDATE, FCREATEUSER, FUPDATEUSER from tdvs_masrev where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $resdelmasrev = $aobj_context->pobj_db->Execute($delmasrev); $deltabulate = "delete from tdvs_masrev where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $resdeltabulate = $aobj_context->pobj_db->Execute($deltabulate); $delmasrev = "INSERT ignore INTO tdvs_tabpkt_bkp (FBATCHNO, FDEGGRP, FQPCODE, FTEACHCODE, FVALNO, FISSUEDATE, FNOSCRIPT, FVALSCRIPT, FREVSCRIPT, FVALSTATUS, FREVSTATUS, FVALDATE, FREVDATE, FSYSDATE, FREVCODE, FPRINT, FPRINTDATE, fyear, fexamtype) select FBATCHNO, FDEGGRP, FQPCODE, FTEACHCODE, FVALNO, FISSUEDATE, FNOSCRIPT, FVALSCRIPT, FREVSCRIPT, FVALSTATUS, FREVSTATUS, FVALDATE, FREVDATE, FSYSDATE, FREVCODE, FPRINT, FPRINTDATE, fyear, fexamtype from tdvs_tabpkt where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $resdelmasrev = $aobj_context->pobj_db->Execute($delmasrev); $deltabulate = "delete from tdvs_tabpkt where fqpcode = '{$val['fqpcode']}' and fexamtype = '{$val['fexamtype']}' and fyear = '{$val['fyear']}'"; $resdeltabulate = $aobj_context->pobj_db->Execute($deltabulate); $qpcode = "update tdvs_masqp set ftempcode = NULL, ffreeze = NULL, fqppath = NULL, fschempath=NULL where fqpcode = '{$val['fqpcode']}'"; $qpcode = $aobj_context->pobj_db->Execute($qpcode); $det['success'] = $val['fqpcode']; array_push($fsuccess, $det); } else{ $arr['failure'] = $val['fqpcode']; array_push($ffailure, $arr); } } $newArr['fsuccess'] = $fsuccess; $newArr['ffailure'] = $ffailure; $resdeldetl = true; if($resdeldetl){ $newArr['msg'] = 'Updated Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($newArr, 0, "success"); }else { $arr['msg'] = 'Something went wrong'; echo $aobj_context->mobj_output->ToJSONEnvelope($newArr, -1, "failure"); } } function tdvs_getDevDet($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $board = $aobj_context->mobj_data["board"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $qp_split = explode(",", $qpcode); foreach($qp_split as $key => $value){ $qp_val .= "'".$value."',"; } $qp_arr = substr_replace($qp_val ,"",-1); if($qp_arr === "'All'"){ $qpCon = " "; }else{ $qpCon = "and s.fqpcode in ({$qp_arr})"; } $query = "select distinct s.fqpcode,concat(s.fsubname, ' - ', sub.fsubshort)as fsubname,s.fsmaxmarks, t.fregcode,t1.fvalno as fvalno1,t1.fteachcode as fteachcode1,m1.fteachname as fteachname1,t1.fsysmarks as fsysmarks1, t2.fvalno as fvalno2,t2.fteachcode as fteachcode2,m2.fteachname as fteachname2,t2.fsysmarks as fsysmarks2, ABS(t1.fsysmarks-t2.fsysmarks) as difmarks from tdvs_masqp s inner join tdvs_tabsum t on s.fqpcode = t.fqpcode and t.fvalno = 'D' inner join tdvs_tabsum t1 on t.fqpcode = t1.fqpcode and t.fregcode = t1.fregcode and t1.fvalno = '1' inner join tdvs_masteach m1 on t1.fteachcode = m1.fteachcode inner join tdvs_tabsum t2 on t.fqpcode = t2.fqpcode and t.fregcode = t2.fregcode and t2.fvalno = '2' inner join tdvs_masteach m2 on t2.fteachcode = m2.fteachcode inner join subject sub on s.fqpcode = sub.fqpcode where t.fvalno = 'D' {$qpCon} and s.fboard = '{$board}';"; $res = $aobj_context->pobj_db->GetAll($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res, 0, "success"); } else { $arr['msg'] = 'No Data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); } } function tdvs_deleteTemplateCode($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $tempcode = $aobj_context->mobj_data["tempcode"]; $sltQry = "select ftempcode from tdvs_masqp where ftempcode='{$tempcode}'"; $res = $aobj_context->pobj_db->GetAll($sltQry); if(count($res) === 0){ $query = "delete from tdvs_qptempdetl where ftempcode='{$tempcode}'"; $result = $aobj_context->pobj_db->Execute($query); $query = "delete from tdvs_qptemphead where ftempcode='{$tempcode}'"; $result = $aobj_context->pobj_db->Execute($query); } if($result){ $arr['msg'] = 'Deleted Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); } else { $arr['msg'] = 'Something Went wrong'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); } } ?>
Close
