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 | : 52.15.210.243
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 : dashboardNew.php
<?php function getAllCollDetial($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $fcollcode = $aobj_context->mobj_data["fcollcode"]; $usertype = $aobj_context->mobj_data["usertype"]; $date = date("Y/m/d"); $con = ""; // var_dump(strpos(" ".$usertype, "308"));die(); if($univcode == '021' && $usertype !== "308"){ if($fcollcode != ""){ $con = "and fcollcode = '{$fcollcode}'"; $con1 = "and std.fcollcode = '{$fcollcode}'"; $con2 = "and cs.fcollcode = '{$fcollcode}'"; $con3 = "and m.fcollcode = '{$fcollcode}'"; } } $query = "select count(distinct d.fdegree) as degree from degree d left join student std on d.fdegree = std.fdegree where ifnull(d.fdeleted,'') <> 'T' $con1"; $result = $aobj_context->pobj_db->GetRow($query); $query1 = "select count(distinct fcollcode) as coll from college where ifnull(fdeleted,'') <> 'T' $con"; $result1 = $aobj_context->pobj_db->GetRow($query1); $query2 = "select count(distinct fteachcode) as teach from masteach where ifnull(fdeleted,'') <> 'T' $con"; //var_dump($query2);die(); $result2 = $aobj_context->pobj_db->GetRow($query2); $query3 = "select count(s.fregno) as std from student s, degree d where s.fdegree = d.fdegree and trim(s.ftotpass) <> trim(d.fleastexam) and ifnull(d.fleastexam,'') <> '' and ifnull(d.fnextexam,'') = '' and ifnull(s.fpdcnumber,'') = '' and ifnull(s.fdcnumber,'') = '' and ifnull(s.fdeleted,'') <> 'T' $con"; $result3 = $aobj_context->pobj_db->GetRow($query3); if($univcode === "021"){ $cond = "count(distinct fsubname)as subj"; }else{ $cond = "count(distinct fsubcode) as subj"; } $query4 = "select {$cond} from subject s left join student std on s.fdegree = std.fdegree where ifnull (s.fdeleted,'') <> 'T' $con1"; $result4 = $aobj_context->pobj_db->GetRow($query4); $query5 = "select distinct dg.fdeggrp,dg.fdescpn,dg.fexamdate, count(cs.fregno) as stdtotal, sum(if(ifnull(frecptdate,'') = '',0,1)) as total from deggrp dg inner join degree d on dg.fdeggrp = d.fdeggrp and d.fexamno = 'A' inner join candsum cs on dg.fyear =cs.fyear and dg.fexamtype = cs.fexamtype and d.fdegree = cs.fdegree where ifnull(cs.fdeleted,'') <> 'T' $con2 group by dg.fdeggrp"; $result5 = $aobj_context->pobj_db->GetAll($query5); $query6 = "select distinct dg.fdeggrp,dg.fdescpn,dg.fexamdate, count(m.fregno) as stdtotal, sum(if(ifnull(fmarks,'-1') = '-1',0,1)) as total from deggrp dg inner join degree d on dg.fdeggrp = d.fdeggrp inner join marks m on dg.fyear =m.fyear and dg.fexamtype = m.fexamtype and d.fdegree = m.fdegree and m.fexamno = d.fexamno and m.fyear = dg.fyear and m.fexamtype = dg.fexamtype where ifnull(m.fdeleted,'') <> 'T' $con3 group by dg.fdeggrp"; $result6 = $aobj_context->pobj_db->GetAll($query6); $query7 = "select distinct dg.fdeggrp,dg.fdescpn,dg.fexamdate, count(m.fregno) as stdtotal, sum(if(ifnull(fmarks11,'-1') = '-1',0,1)) as total from deggrp dg inner join degree d on dg.fdeggrp = d.fdeggrp inner join marks_pr m on dg.fyear =m.fyear and dg.fexamtype = m.fexamtype and d.fdegree = m.fdegree and m.fexamno = d.fexamno and m.fyear = dg.fyear and m.fexamtype = dg.fexamtype where ifnull(m.fdeleted,'') <> 'T' $con3 group by dg.fdeggrp"; $result7 = $aobj_context->pobj_db->GetAll($query7); $query8 = "select distinct ifnull(cs.FCNTRCODE,'') as fcntrcode, concat(ifnull(cl.FCOLLNAME,''),', ',cl.ftown) as fcollname, date_format(ifnull(s.fdoe,''),'%d/%m/%Y') as fdoe,r.FDESCPN, count(cd.fregno) as cnt from canddet cd inner join subject s on cd.fdegree = s.fdegree and cd.fexamno = s.fexamno and cd.fsubcode = s.fsubcode inner join candsum cs on cs.fdegree = cd.fdegree and cd.fcollcode = cs.fcollcode and cd.fregno = cs.fregno inner join college cl on cl.FCOLLCODE = cs.FCNTRCODE inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp inner join reason r on s.fsession = r.FREASONCD where cd.fpresent = 'P' and s.fdoe = '{$date}' and ifnull(cs.frecptdate,'') <> '' $con2 group by cs.FCNTRCODE,s.fsession order by cs.FCNTRCODE,s.fsession"; // and cd.fyear = dg.fyear // and cd.fexamtype = dg.fexamtype // and cs.fyear = dg.fyear // and cs.fexamtype = dg.fexamtype $result8 = $aobj_context->pobj_db->GetAll($query8); $query9 = "select distinct ifnull(s.fqpcode,'') as fqpcode,ifnull(s.fsubname,'') as fsubname, date_format(ifnull(s.fdoe,''),'%d/%m/%Y') as fdoe,r.FDESCPN, count(cd.fregno) as cnt from canddet cd inner join subject s on cd.fdegree = s.fdegree and cd.fexamno = s.fexamno and cd.fsubcode = s.fsubcode inner join candsum cs on cs.fdegree = cd.fdegree and cd.fcollcode = cs.fcollcode and cd.fregno = cs.fregno inner join college cl on cl.FCOLLCODE = cs.FCNTRCODE inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp inner join reason r on s.fsession = r.FREASONCD where cd.fpresent = 'P' and s.fdoe = '{$date}' and ifnull(cs.frecptdate,'') <> '' $con2 group by s.fqpcode,s.fsession order by s.fqpcode,s.fsession"; // var_dump($query9);die(); // and cd.fyear = dg.fyear // and cd.fexamtype = dg.fexamtype // and cs.fyear = dg.fyear // and cs.fexamtype = dg.fexamtype $result9 = $aobj_context->pobj_db->GetAll($query9); if(count($result) > 0) { $arr['alldeg'] = $result; $arr['allcoll'] = $result1; $arr['alltech'] = $result2; $arr['stdcount'] = $result3; $arr['subjcount'] = $result4; $arr['examapp'] = $result5; $arr['iamarks'] = $result6; $arr['pramarks'] = $result7; $arr['exmxentwise'] = $result8; $arr['qpcodewise'] = $result9; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getAllDegree($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select count(distinct fdegree) as degree from degree where ifnull(fdeleted,'') <> 'T'"; $result = $aobj_context->pobj_db->GetRow($query); // var_dump($result); // die(); if(count($result) > 0) { // $arr['states'] = $result; echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getAllDegreeDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $degree = $aobj_context->mobj_data["degree"]; if($degree == 'All'){ $query = "SELECT fdegree, fdescpn, GROUP_CONCAT(ifnull(fexamno,''),' - ' ,ifnull(fexamname,''),'- ',ifnull(ftotsub,'')) as fexamsub ,fexamdate, fdeggrp, ffaculty FROM degree WHERE IFNULL(fdeleted,'') <> 'T' group by fdegree"; }else{ $query = "SELECT fdegree, fdescpn, GROUP_CONCAT(ifnull(fexamno,''),' - ' ,ifnull(fexamname,''),'- ',ifnull(ftotsub,'')) as fexamsub ,fexamdate, fdeggrp, ffaculty FROM degree where fdegree = '{$degree}' and IFNULL(fdeleted,'') <> 'T' group by fdegree "; } $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getAllCollCount($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select count(distinct fcollcode) as coll from college where ifnull(fdeleted,'') <> 'T' and ifnull(fupdated,'F') = 'T'"; $result = $aobj_context->pobj_db->GetRow($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getAllCollDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select ifnull(fcollcode,'') as fcode, ifnull(fcollname,'') as fcoll, ifnull(ftown,'')as town from college order by fcode"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getDegreeNam($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select fdegree, fdescpn,fexamno, fexamname, ftotsub from degree "; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { // $arr['states'] = $result; echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getSelDegrSem($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $degree = $aobj_context->mobj_data["degr"]; $query = "select fexamno,fexamname from degree where fdegree = '{$degree}'"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getSubj($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; if($univcode === "021"){ $cond = "count(distinct fsubname)as subj"; }else{ $cond = "count(distinct fsubcode) as subj"; } $query = "select {$cond} from subject where ifnull(fdeleted,'') <> 'T'"; $result = $aobj_context->pobj_db->GetRow($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getTeachCount($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select count(distinct fteachcode) as teach from masteach where ifnull(fdeleted,'') <> 'T'"; $result = $aobj_context->pobj_db->GetRow($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getStdCount($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select count(distinct s.fregno) as std from student s inner join degree d on s.fdegree = d.fdegree and d.fexamno = 'A' inner join college c on c.fcollcode = s.fcollcode left join logisys3_comexam.masuser m on s.fregno = m.fregno and m.funivcode = '{$univcode}' and m.factive = 'T' where ifnull(s.fdeleted,'') <> 'T';"; $result = $aobj_context->pobj_db->GetRow($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No States Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getSelSem($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $degree = $aobj_context->mobj_data["degree"]; $sem = $aobj_context->mobj_data["sem"]; $query = "select fsubcode, fsubname, fvalmax, ifnull(fqpcode,'') as qpcode from subject where fdegree = '{$degree}' and fexamno = '{$sem}' group by fsubcode"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { 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 viewStdDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $regno = $aobj_context->mobj_data["regno"]; $query = "select s.fdegree,s.fname, s.fcollcode, c.fcollname,c.ftown, d.fdescpn from student s inner join college c on s.fcollcode = c.fcollcode inner join degree d on s.fdegree = d.fdegree where s.fregno ='{$regno}' group by s.fdegree,s.fcollcode,s.fregno"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { 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 getComStdDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $regno = $aobj_context->mobj_data["regno"]; $query = "select s.fdegree,s.fname, s.fcollcode, c.fcollname,c.ftown, d.fdescpn, fstudid, ifnull(fmarksa,'') as fst, ifnull(fmarksb,'') as sec,ifnull(fmarksc,'') as third,ifnull(fmarksd,'') as four, ifnull(fmarkse,'') as five, ifnull(fmarksf,'') as six, ifnull(fmarksg,'') as sevn,ifnull(fmarksh,'') as eigh,ifnull(fmarksi,'') as nine,ifnull(fmarksj,'') as ten, ifnull(fmaxmarksa,'') as mfst, ifnull(fmaxmarksb,'') as msec,ifnull(fmaxmarksc,'') as mthird,ifnull(fmaxmarksd,'') as mfour, ifnull(fmaxmarkse,'') as mfive, ifnull(fmaxmarksf,'') as msix, ifnull(fmaxmarksg,'') as msevn,ifnull(fmaxmarksh,'') as meigh,ifnull(fmaxmarksi,'') as mnine, ifnull(fmaxmarksj,'') as mten, ifnull(ffexama,'') as efst, ifnull(ffexamb,'') as esec,ifnull(ffexamc,'') as ethird,ifnull(ffexamd,'') as efour, ifnull(ffexame,'') as efive, ifnull(ffexamf,'') as esix, ifnull(ffexamg,'') as esevn,ifnull(ffexamh,'') as eeigh,ifnull(ffexami,'') as enine, ifnull(ffexamj,'') as eten, ifnull(fcra,'') as cfst, ifnull(fcrb,'') as csec,ifnull(fcrc,'') as cthird,ifnull(fcrd,'') as cfour, ifnull(fcre,'') as cfive, ifnull(fcrf,'') as csix, ifnull(fcrg,'') as csevn,ifnull(fcrh,'') as ceigh,ifnull(fcri,'') as cnine, ifnull(fcrj,'') as cten, ifnull(fsgpaa,'') as sfst, ifnull(fsgpab,'') as ssec,ifnull(fsgpac,'') as sthird,ifnull(fsgpad,'') as sfour, ifnull(fsgpae,'') as sfive, ifnull(fsgpaf,'') as ssix, ifnull(fsgpae,'') as ssevn,ifnull(fsgpah,'') as seigh,ifnull(fsgpai,'') as snine, ifnull(fsgpaj,'') as sten, ifnull(fgpa,'') as gfst, ifnull(fgpb,'') as gsec,ifnull(fgpc,'') as gthird,ifnull(fgpd,'') as gfour, ifnull(fgpe,'') as gfive, ifnull(fgpf,'') as gsix, ifnull(fgpe,'') as gsevn,ifnull(fgph,'') as geigh,ifnull(fgpi,'') as gnine, ifnull(fgpj,'') as gten,ftotpass from student s inner join college c on s.fcollcode = c.fcollcode inner join degree d on s.fdegree = d.fdegree where fregno ='{$regno}' group by fregno"; $result = $aobj_context->pobj_db->GetRow($query); if(count($result) > 0) { 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 examAppl($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select distinct dg.fdeggrp,dg.fdescpn,dg.fexamdate, count(c.fregno) as stdtotal, sum(if(ifnull(frecptdate,'') = '',0,1)) as total from deggrp dg inner join degree d on dg.fdeggrp = d.fdeggrp and d.fexamno = 'A' inner join candsum c on dg.fyear =c.fyear and dg.fexamtype = c.fexamtype and d.fdegree = c.fdegree where ifnull(c.fdeleted,'') <> 'T' group by dg.fdeggrp"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No Data'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function iaMarks($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select distinct dg.fdeggrp,dg.fdescpn,dg.fexamdate, count(m.fregno) as stdtotal, sum(if(ifnull(fmarks,'-1') = '-1',0,1)) as total from deggrp dg inner join degree d on dg.fdeggrp = d.fdeggrp inner join marks m on dg.fyear =m.fyear and dg.fexamtype = m.fexamtype and d.fdegree = m.fdegree and m.fexamno = d.fexamno and m.fyear = dg.fyear and m.fexamtype = dg.fexamtype where ifnull(m.fdeleted,'') <> 'T' group by dg.fdeggrp"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No Data'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function praMarks($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select distinct dg.fdeggrp,dg.fdescpn,dg.fexamdate, count(m.fregno) as stdtotal, sum(if(ifnull(fmarks11,'-1') = '-1',0,1)) as total from deggrp dg inner join degree d on dg.fdeggrp = d.fdeggrp inner join marks_pr m on dg.fyear =m.fyear and dg.fexamtype = m.fexamtype and d.fdegree = m.fdegree and m.fexamno = d.fexamno and m.fyear = dg.fyear and m.fexamtype = dg.fexamtype where ifnull(m.fdeleted,'') <> 'T' group by dg.fdeggrp"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No Data'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function currActive($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $fcollcode = $aobj_context->mobj_data["fcollcode"]; $arr = []; $loopdata = ["concat('IA Marks Enabled. Last Date: ',c.fiato)", "concat('PR Marks Enabled. Last Date: ',c.fprto)","concat('Admission Enabled. Last Date: ',c.fadmto)","concat('Hall Ticket Enabled. Last Date: ',c.fhtto)","concat('Attendance Enabled. Last Date: ',c.fattto)","concat('Subject Enabled. Last Date: ',c.fsubcrto)","concat('Room Alert Enabled. Last Date: ',c.frato)"]; $con = ["fiafrom and fiato", "fprfrom and fprto","fadmfrom and fadmto","fhtfrom and fhtto","fattfrom and fattto","fsubcrfrom and fsubcrto","frafrom and frato"]; $cond = ""; if($fcollcode != null){ $cond = "and c.fcollcode = '{$fcollcode}'"; } for($i=0; $i<count($loopdata); $i++){ $query = "select dg.fdeggrp,dg.fdescpn,{$loopdata[$i]} as IA from collexam c inner join degree d on c.fdegree = d.fdegree and c.fexamno = d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp where date_format(now(),'%Y-%m-%d') between {$con[$i]} $cond group by dg.fdeggrp"; $result = $aobj_context->pobj_db->GetAll($query); foreach($result as $value){ array_push($arr,$value); } } if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $arr['msg'] = 'No Activity'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function examCentreWise($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $date = date("Y/m/d"); $query = "select distinct ifnull(cs.FCNTRCODE,'') as fcntrcode, concat(ifnull(cl.FCOLLNAME,''),', ',cl.ftown) as fcollname, date_format(ifnull(s.fdoe,''),'%d/%m/%Y') as fdoe,r.FDESCPN, count(cd.fregno) as cnt from canddet cd inner join subject s on cd.fdegree = s.fdegree and cd.fexamno = s.fexamno and cd.fsubcode = s.fsubcode inner join candsum cs on cs.fdegree = cd.fdegree and cd.fcollcode = cs.fcollcode and cd.fregno = cs.fregno inner join college cl on cl.FCOLLCODE = cs.FCNTRCODE inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp inner join reason r on s.fsession = r.FREASONCD where cd.fpresent = 'P' and s.fdoe = '{$date}' and ifnull(cs.frecptdate,'') <> '' group by cs.FCNTRCODE,s.fsession order by cs.FCNTRCODE,s.fsession"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No Activity'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function qpCodeWise($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $date = date("Y/m/d"); $query = "select distinct ifnull(s.fqpcode,'') as fqpcode,ifnull(s.fsubname,'') as fsubname, date_format(ifnull(s.fdoe,''),'%d/%m/%Y') as fdoe,r.FDESCPN, count(cd.fregno) as cnt from canddet cd inner join subject s on cd.fdegree = s.fdegree and cd.fexamno = s.fexamno and cd.fsubcode = s.fsubcode inner join candsum cs on cs.fdegree = cd.fdegree and cd.fcollcode = cs.fcollcode and cd.fregno = cs.fregno inner join college cl on cl.FCOLLCODE = cs.FCNTRCODE inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp inner join reason r on s.fsession = r.FREASONCD where cd.fpresent = 'P' and s.fdoe = '{$date}' and ifnull(cs.frecptdate,'') <> '' group by s.fqpcode,s.fsession order by s.fqpcode,s.fsession"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No Activity'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getStudHistory($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $fcollcode = $aobj_context->mobj_data["fcollcode"]; $usertype = $aobj_context->mobj_data["usertype"]; $con = ""; if($univcode == '021' && $usertype !== "308"){ if($fcollcode != ""){ $con = "and fcollcode = '{$fcollcode}'"; } } $queryHistory = "select (select count(*) from student where ifnull(fdcnumber,'') <> '') + (select count(*) from studhist where ifnull(fdcnumber,'') <> '' $con ) as fhistorycount"; $resultHistory = $aobj_context->pobj_db->GetRow($queryHistory); $queryCourse = "select (select count(s.fregno) as fcnt from student s, degree d where s.fdegree = d.fdegree and trim(s.ftotpass) = trim(d.fleastexam) and ifnull(d.fleastexam,'') <> '' and ifnull(d.fnextexam,'') = '' and ifnull(s.fpdcnumber,'') = '' and ifnull(s.fdcnumber,'') = '' and ifnull(s.fdeleted,'') <> 'T' $con and s.fregno not in(select fregno from studhist)) + (select count(s.fregno) as fcnt from studhist s, degree d where s.fdegree = d.fdegree and trim(s.ftotpass) = trim(d.fleastexam) and ifnull(d.fleastexam,'') <> '' and ifnull(d.fnextexam,'') = '' and ifnull(s.fpdcnumber,'') = '' and ifnull(s.fdcnumber,'') = '' and ifnull(s.fdeleted,'') <> 'T' $con) as fcccnt "; $resuCourse = $aobj_context->pobj_db->GetRow($queryCourse); $queryGrad = "select (select count(s.fregno) as fcnt from student s, degree d where s.fdegree = d.fdegree and trim(s.ftotpass) = trim(d.fleastexam) and ifnull(d.fleastexam,'') <> '' and ifnull(d.fnextexam,'') = '' and ifnull(s.fpdcnumber,'') <> '' and ifnull(s.fdcnumber,'') = '' and ifnull(s.fdeleted,'') <> 'T' $con and s.fregno not in(select fregno from studhist)) + (select count(s.fregno) as fcnt from studhist s, degree d where s.fdegree = d.fdegree and trim(s.ftotpass) = trim(d.fleastexam) and ifnull(d.fleastexam,'') <> '' and ifnull(d.fnextexam,'') = '' and ifnull(s.fpdcnumber,'') <> '' and ifnull(s.fdcnumber,'') = '' and ifnull(s.fdeleted,'') <> 'T' $con) as fcccnt"; $resuGrad = $aobj_context->pobj_db->GetRow($queryGrad); if(true) { // $arr['deleted'] = $resultDelted; $arr['history'] = $resultHistory; $arr['intern'] = $resuCourse; $arr['graduands'] = $resuGrad; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $arr['msg'] = 'No Data'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getStudDelHistory($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $fcollcode = $aobj_context->mobj_data["fcollcode"]; $usertype = $aobj_context->mobj_data["usertype"]; $con = ""; if($univcode == '021' && $usertype !== "308"){ if($fcollcode != ""){ $con = "and fcollcode = '{$fcollcode}'"; } } $queryDeleted = "select (select count(*)as fdeletedcount from student where fdeleted = 'T' $con) + (select count(*)as fdeletedcount from studhist where fdeleted = 'T' $con) as fdeletedcount"; $resultDelted = $aobj_context->pobj_db->GetRow($queryDeleted); if(true) { echo $aobj_context->mobj_output->ToJSONEnvelope($resultDelted,0,"success"); } else { $arr['msg'] = 'No Data'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } ?>
Close
