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.14.132.221
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.43
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 : script.php
<?php function get_deggrp($aobj_context) { $univcode = $aobj_context->mobj_data["univcode"]; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $query = "SELECT fdbname FROM dbname WHERE funivcode = $univcode"; $result = $aobj_context->mobj_db->GetRow($query); $db = $result['fdbname']; $query = "SELECT DISTINCT fdeggrp FROM {$db}.masqp WHERE IFNULL(fdeggrp,'') <> ''"; $result = $aobj_context->mobj_db->GetAll($query); // var_dump($result); if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { $arr['msg'] = 'Degree group not found for the selected university'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getfboard($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $deggrp = $aobj_context->mobj_data["deggrp"]; foreach($deggrp as $key => $value){ $deg .= "'".$value."',"; } $deggrp_arr = substr_replace($deg ,"",-1); $query = "select DISTINCT fboardcode, fboardname FROM masboard mb, masqp mq WHERE mb.fboardcode=mq.fboard AND mq.fdeggrp = '{$deggrp}' order by fboardcode"; $result = $aobj_context->pobj_db->GetAll($query); if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { $arr['msg'] = 'No Boards for selected University or Degree grp'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getscript($aobj_context) { $univcode = $aobj_context->mobj_data["univcode"]; $Degree = $aobj_context->mobj_data["deggrp"]; $fboard = $aobj_context->mobj_data["fboard"]; $fexamno = $aobj_context->mobj_data["fexamno"]; $status = $aobj_context->mobj_data["status"]; if($fboard == 'All'){ $cnd1 = ""; }else{ $cnd1 = "and m.fboard = '{$fboard}'"; } if ($status == "All") { $cnd2 = ""; } else if ($status == "completed") { if($Degree == 'PG') { $cnd2 = "and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) = 0 and (ifnull(ftotpkt2,0) - ifnull(fvalpkt2,0)) = 0"; }else { $cnd2 = "and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) = 0"; } //$cnd2 = "and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) = 0"; } else if ($status == "pending") { if($Degree == 'PG') { $cnd2 = "and ((ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) <> 0 or (ifnull(ftotpkt2,0) - ifnull(fvalpkt2,0)) <> 0)"; }else { $cnd2 = "and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) <> 0"; } } $examnoStr = strtoupper($fexamno); $splitexamno = str_split($examnoStr); $examno = implode("','", $splitexamno); $query = "SELECT fqpcode, m.fboard, b.fboardname, fsubname, IFNULL(fspresent,0) AS fspresent, IFNULL(fapresent,0) AS fapresent, IFNULL(fcodecount,0) AS fcodecount, IFNULL(ftotpkt1,0) AS ftotpkt1, IFNULL(fvalpkt1,0) AS fvalpkt1, ifnull(ftotpkt2,0) as ftotpkt2, ifnull(fvalpkt2,0) as fvalpkt2, ifnull(ftotpkt3,0) as ftotpkt3, ifnull(fvalpkt3,0) as fvalpkt3 FROM masqp m, control c, masboard b WHERE m.fboard=b.fboardcode AND m.fdeggrp = '{$Degree}' {$cnd1} and fexamno in ('{$examno}') {$cnd2} HAVING fcodecount>0 ORDER BY m.fboard,fqpcode"; // var_dump($query); // die(); $result = $aobj_context->pobj_db->GetAll($query); if (!$result && gettype($result) == 'boolean') { $arr['msg'] = "Error while fetching data"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure"); return; } if (count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getscriptSummary($aobj_context) { $univcode = $aobj_context->mobj_data["univcode"]; $Degree = $aobj_context->mobj_data["deggrp"]; $fexamno = $aobj_context->mobj_data["fexamno"]; $fboard = $aobj_context->mobj_data["fboard"]; $status = $aobj_context->mobj_data["status"]; if($fboard == "All"){ $cnd = ''; }else{ $cnd = "AND fboard = '{$fboard}'"; } // if ($status == "All") { // $cnd2 = ""; // } else if ($status == "completed") { // $cnd2 = "AND fpend = 0"; // } else if ($status == "pending") { // $cnd2 = "AND fpend <> 0"; // } if ($status == "All") { $cnd2 = ""; } else if ($status == "completed") { if($Degree == 'PG') { $cnd2 = "and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) = 0 and (ifnull(ftotpkt2,0) - ifnull(fvalpkt2,0)) = 0"; }else { $cnd2 = "and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) = 0"; } //$cnd2 = "and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) = 0"; } else if ($status == "pending") { if($Degree == 'PG') { $cnd2 = "and ((ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) <> 0 or (ifnull(ftotpkt2,0) - ifnull(fvalpkt2,0)) <> 0)"; }else { $cnd2 = "and (ifnull(ftotpkt1,0) - ifnull(fvalpkt1,0)) <> 0"; } } $examnoStr = strtoupper($fexamno); $splitexamno = str_split($examnoStr); $examno = implode("','", $splitexamno); $query = "select m.fboard, b.fboardname, sum(ifnull(fapresent,0)) as fapresent, sum(ifnull(fcodecount,0)) as fcodecount, if((sum(ifnull(fapresent,0)) - sum(ifnull(fcodecount,0))) < 0, 0, (sum(ifnull(fapresent,0)) - sum(ifnull(fcodecount,0)))) as fcodepend, sum(ifnull(ftotpkt1,0)) as ftotpkt, sum(ifnull(fvalpkt1,0)) as fvalpkt, (sum(ifnull(ftotpkt1,0))- sum(ifnull(fvalpkt1,0)) ) as fpend, sum(ifnull(ftotpkt2,0)) as ftotpkt1, sum(ifnull(fvalpkt2,0)) as fvalpkt1, (sum(ifnull(ftotpkt2,0))- sum(ifnull(fvalpkt2,0)) ) as fpend1, sum(ifnull(ftotpkt3,0)) as ftotpkt3, sum(ifnull(fvalpkt3,0)) as fvalpkt3, (sum(ifnull(ftotpkt3,0))- sum(ifnull(fvalpkt3,0)) ) as fpend3 from masqp m inner join masboard b on m.fboard = b.fboardcode where fexamno in ('{$examno}') and fdeggrp = '{$Degree}' {$cnd} {$cnd2} group by m.fboard having ftotpkt >0 order by m.fboard"; //var_dump($query); $result = $aobj_context->pobj_db->GetAll($query); if (!$result && gettype($result) == 'boolean') { $arr['msg'] = "Error while fetching data"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure"); return; } if (count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function loadboardvaluationstats($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Degree = $aobj_context->mobj_data["deggrp"]; $univcode = $aobj_context->mobj_data["univcode"]; $query = "select DISTINCT fboardcode, fboardname FROM masboard mb, masqp mq WHERE mb.fboardcode=mq.fboard AND mq.fdeggrp= '{$Degree}' order by fboardcode"; // var_dump($query); // die(); $result = $aobj_context->pobj_db->GetAll($query); if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { $arr['msg'] = 'No Boards for selected University or Degree grp'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getTeachCode($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $deggrp = $aobj_context->mobj_data["deggrp"]; $univcode = $aobj_context->mobj_data["univcode"]; foreach($deggrp as $key => $value){ $deg .= "'".$value."',"; } $deggrp_arr = substr_replace($deg,"",-1); if($univcode == '051') { $query = " select distinct m.fteachcode, m.fteachname from masteach m group by fteachcode"; $result = $aobj_context->pobj_db->GetAll($query); }else { $query = " select distinct m.fteachcode, m.fteachname from teachsub t inner join masqp q on t.fqpcode = q.fqpcode inner join masteach m on t.fteachcode = m.fteachcode where m.fdeggrp in({$deggrp_arr}) group by fteachcode"; $result = $aobj_context->pobj_db->GetAll($query); } if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { // $arr['msg'] = 'failed to load the teachcode'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getcolList($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $deggrp = $aobj_context->mobj_data["deggrp"]; $teachcode = $aobj_context->mobj_data["teach"]; $univcode = $aobj_context->mobj_data["univcode"]; foreach($deggrp as $key => $value){ $deg .= "'".$value."',"; } $deggrp_arr = substr_replace($deg, "",-1); foreach($teachcode as $key => $value){ $teach .= "'".$value."',"; } $teachcode_arr = substr_replace($teach, "",-1); $query = "select distinct m.fcollcode, concat(c.fcollname,' - ', c.ftown)as fcollname from masteach m inner join college c on c.fcollcode = m.fcollcode where fdeggrp in ({$deggrp_arr}) and fteachcode in({$teachcode_arr}) group by m.fcollcode;"; // var_dump($query); // die(); $result = $aobj_context->pobj_db->GetAll($query); if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { // $arr['msg'] = 'failed to load the college'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getcolListfromdeggrp($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $deggrp = $aobj_context->mobj_data["deggrp"]; $univcode = $aobj_context->mobj_data["univcode"]; foreach($deggrp as $key => $value){ $deg .= "'".$value."',"; } $deggrp_arr = substr_replace($deg, "",-1); $query = "select distinct m.fcollcode, concat(c.fcollname,' - ', c.ftown)as fcollname from masteach m inner join college c on c.fcollcode = m.fcollcode where fdeggrp in ({$deggrp_arr}) group by m.fcollcode;"; $result = $aobj_context->pobj_db->GetAll($query); if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { // $arr['msg'] = 'failed to load the college'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getTeachCodeRange($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $deggrp = $aobj_context->mobj_data["deggrp"]; $univcode = $aobj_context->mobj_data["univcode"]; $query = " select distinct m.fteachcode, m.fteachname from teachsub t inner join masqp q on t.fqpcode = q.fqpcode inner join masteach m on t.fteachcode = m.fteachcode where m.fdeggrp ='{$deggrp}' group by fteachcode"; $result = $aobj_context->pobj_db->GetAll($query); if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { // $arr['msg'] = 'failed to load the teachcode'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getfboarddailyval($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select DISTINCT fboardcode, fboardname FROM masboard mb, masqp mq WHERE mb.fboardcode=mq.fboard order by fboardcode"; $result = $aobj_context->pobj_db->GetAll($query); if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { $arr['msg'] = 'No Boards for selected University or Degree grp'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getfbaordName($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $code = $aobj_context->mobj_data["code"]; $query = "select DISTINCT fboardcode, fboardname FROM masboard mb, masqp mq WHERE mb.fboardcode=mq.fboard AND fboardcode = '{$code}'"; $result = $aobj_context->pobj_db->GetRow($query); if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { $arr['msg'] = 'No Boards for selected University or Degree grp'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getTeachCodeOnBoard($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"]; foreach($board as $key => $value){ $board_a .= "'".$value."',"; } $board_arr = substr_replace($board_a, "",-1); if($board_arr == "'all'"){ $cnd = "fboard <> ''"; }else{ $cnd = "fboard in ({$board_arr})"; } $query = "select distinct ifnull(fteachcode, '')as fteachcode, ifnull(fteachname, '')as fteachname, ifnull(femail,'')as femail, ifnull(fmobile, '')as fmobile from masteach where $cnd and fdeggrp = '{$deggrp}'"; $result = $aobj_context->pobj_db->GetAll($query); // var_dump($query); // die(); if ($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; } else { $arr['msg'] = 'No Boards for selected University or Degree grp'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } }
Close