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.188.190.212
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 : teacherEntry.php
<?php require_once(_DIR_."/../../aws/aws-autoloader.php"); use Aws\S3\S3Client; use Aws\S3\Exception\S3Exception; function getDesignation($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select FDEGNCODE, FDEGNDESC from masdegn"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getTeachBoardDetails($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $deggrp = $aobj_context->mobj_data["deggrp"]; $get_data= "select distinct m.fboard as code, b.fboardname as value from subject m inner join masboard b on m.fboard = b.fboardcode where ifnull(fboard, '') <> '' and m.fdegree in(select distinct fdegree from degree where fdeggrp = '{$deggrp}')"; $lobj_get_data = $aobj_context->pobj_db->GetAll($get_data); if($lobj_get_data){ echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getQPSubjects($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $deggrp = $aobj_context->mobj_data["deggrp"]; $sem = trim($aobj_context->mobj_data["sem"]); $board = trim($aobj_context->mobj_data["board"]); // $db = trim($aobj_context->mobj_data["db"]); if($board === "ALL"){ $boardCond = " "; }else{ $boardCond = "and fboard = '{$board}'"; } if($sem == 'ODD') $examno = "A', 'C', 'E"; else if($sem == 'EVEN') $examno = "B', 'D', 'F"; else if($sem == 'ALL') $examno = "A', 'B', 'C', 'D', 'E', 'F"; else $examno = $fexamno; if($univcode == '026') { $query = "select fexamno, fboard, fqpcode, fsubname, '' as fdegrees from subject where fboard = '{$fdeggrp}' and fexamno in ('$examno') and ifnull(fqpcode,'') <> ''"; }else if($univcode == '050' || $univcode == '051') { $query = "select s.fexamno, ifnull(s.fboard,'') as fboard, s.fqpcode, s.fsubname, group_concat(distinct s.fdegree SEPARATOR ', ') as fdegrees from subject s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno where d.fdeggrp = '{$deggrp}' and d.fexamno in ('$examno') and ifnull(s.fqpcode,'') <>'' and s.fexamno in ('$examno') {$boardCond} group by s.fexamno, s.fqpcode order by s.fexamno, s.fqpcode"; } else { $query = "select fexamno, fboard, fqpcode, fsubname, fdegreerange as fdegrees from masqp where fboard = '{$board}' and fdeggrp = '{$deggrp}' and fexamno in ('$examno') order by fexamno, fqpcode"; } $lobj_get_data = $aobj_context->pobj_db->GetAll($query); if($lobj_get_data){ echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"success"); }else{ $arr['msg'] = 'no data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveTeacherEntry($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $college = $aobj_context->mobj_data["college"]; $staff = $aobj_context->mobj_data["staff"]; $nameTitle = $aobj_context->mobj_data["nameTitle"]; $teachcode = $aobj_context->mobj_data["teachcode"]; $teachname = $aobj_context->mobj_data["teachname"]; $gender = $aobj_context->mobj_data["gender"]; $dob = $aobj_context->mobj_data["dob"]; $mobile = $aobj_context->mobj_data["mobile"]; $landline = $aobj_context->mobj_data["landline"]; $email = $aobj_context->mobj_data["email"]; $aadhaar = $aobj_context->mobj_data["aadhaar"]; $address = $aobj_context->mobj_data["address"]; $designation = $aobj_context->mobj_data["designation"]; $qualification = $aobj_context->mobj_data["qualification"]; $salscale = $aobj_context->mobj_data["salscale"]; $collegeJoinDate = $aobj_context->mobj_data["collegeJoinDate"]; $teacherJoinDate = $aobj_context->mobj_data["teacherJoinDate"]; $ugcTeachDate = $aobj_context->mobj_data["ugcTeachDate"]; $fullTime = $aobj_context->mobj_data["fullTime"]; $permanent = $aobj_context->mobj_data["permanent"]; $anyMember = $aobj_context->mobj_data["anyMember"]; $eligibleValuation = $aobj_context->mobj_data["eligibleValuation"]; $workStatus = $aobj_context->mobj_data["workStatus"]; $remarks = $aobj_context->mobj_data["remarks"]; $accno = $aobj_context->mobj_data["accno"]; $ifsc = $aobj_context->mobj_data["ifsc"]; $bankname = $aobj_context->mobj_data["bankname"]; $pan = $aobj_context->mobj_data["pan"]; $deggrp = $aobj_context->mobj_data["deggrp"]; if($college === "9999"){ $collname = $aobj_context->mobj_data["collname"]; }else{ $collname = ""; } if($designation === "10"){ $desnname = $aobj_context->mobj_data["desnname"]; }else{ $desnname = ""; } $experience = $aobj_context->mobj_data["experience"]; $sem = $aobj_context->mobj_data["sem"]; $board = $aobj_context->mobj_data["board"]; $data = json_decode($aobj_context->mobj_data["data"], true); $filename = $_FILES["File"]["name"]; $tempname = $_FILES["File"]["tmp_name"]; $qryTeach = "select fteachcode from masteach where fteachcode = '{$teachcode}'"; $resultTeach = $aobj_context->pobj_db->GetRow($qryTeach); // if($filename !== '' && $filename !== NULL){ // $server_path = move_uploaded_file($tempname, 'photocopy/'. $filename); // $file_path = $aobj_context->main_src."photocopy/{$filename}"; // if(file_exists($file_path)){ // $s3 = S3Client::factory( // array( // 'credentials' => array( // 'key' => IAM_KEY, // 'secret' => IAM_SECRET // ), // 'version' => "latest", // 'region' => 'ap-south-1' // )); // $key = $univcode."/".$college."/".$filename; // try { // $s3->putObject(['Bucket' => "teacher-photos", 'Key' => $key, 'SourceFile' => $file_path]); if($resultTeach['fteachcode'] === $teachcode){ $updQuery = "update masteach set FCOLLCODE='{$college}', FSTAFFTYPE='{$staff}', FTEACHNAME='{$teachname}', FGENDER='{$gender}', FDOB=date_format(str_to_date('{$dob}', '%d/%m/%Y'), '%Y-%m-%d'), FQUAL='{$qualification}', FDEGNCODE='{$designation}',FMOBILE='{$mobile}', FPHONE='{$landline}', FEMAIL='{$email}', FAADHARNO='{$aadhaar}', FADDR1='{$address}', FSCALE='{$salscale}', FDOA=date_format(str_to_date('{$teacherJoinDate}', '%d/%m/%Y'), '%Y-%m-%d'), FDOJUGC=date_format(str_to_date('{$ugcTeachDate}', '%d/%m/%Y'), '%Y-%m-%d'), fdoc=date_format(str_to_date('{$collegeJoinDate}', '%d/%m/%Y'), '%Y-%m-%d'), FFULLTIME='{$fullTime}', FPERMANENT='{$permanent}', FMEMBER='{$anyMember}', fvalelig='{$eligibleValuation}', FSTATUS='{$workStatus}', FREMARKS='{$remarks}', FACCNO='{$accno}', FIFSCCODE='{$ifsc}', FBANKNAME='{$bankname}', FPANNO='{$pan}', FPHOTO='{$key}', FTITLE='{$nameTitle}', FDEGGRP='{$deggrp}', FBOARD='{$board}', FEXP='{$experience}',fdesname = '{$desnname}', FCOLLNAME = '{$collname}' where FTEACHCODE = '{$teachcode}'"; $result = $aobj_context->pobj_db->Execute($updQuery); }else{ $chkMob = "select FMOBILE from masteach where fmobile = '{$mobile}'"; $resultMob = $aobj_context->pobj_db->GetRow($chkMob); if(count($resultMob)>0){ $arr['msg'] = 'Mobile Number already existed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } if($univcode == "021" || $univcode == "030" || $univcode == "098") { if($teachcode == '') { $teach = $mobile; }else { $teach = $teachcode; } }else{ $teach = $mobile; } $query = "insert into masteach (FCOLLCODE, FSTAFFTYPE, FTEACHCODE, FTEACHNAME, FGENDER, FDOB, FQUAL, FDEGNCODE, FMOBILE, FPHONE, FEMAIL, FAADHARNO, FADDR1, FSCALE, FDOA, FDOJUGC, fdoc, FFULLTIME, FPERMANENT, FMEMBER, fvalelig, FSTATUS, FREMARKS, FACCNO, FIFSCCODE, FBANKNAME, FPANNO, FPHOTO, FTITLE, FDEGGRP, FBOARD, FEXP,fdesname,FCOLLNAME) values('{$college}', '{$staff}', '{$teach}', '{$teachname}', '{$gender}', date_format(str_to_date('{$dob}', '%d/%m/%Y'), '%Y-%m-%d'), '{$qualification}', '{$designation}', '{$mobile}', '{$landline}', '{$email}', '{$aadhaar}', '{$address}', '{$salscale}', date_format(str_to_date('{$teacherJoinDate}', '%d/%m/%Y'), '%Y-%m-%d'), date_format(str_to_date('{$ugcTeachDate}', '%d/%m/%Y'), '%Y-%m-%d'), date_format(str_to_date('{$collegeJoinDate}', '%d/%m/%Y'), '%Y-%m-%d'), '{$fullTime}', '{$permanent}', '{$anyMember}', '{$eligibleValuation}', '{$workStatus}', '{$remarks}', '{$accno}', '{$ifsc}', '{$bankname}', '{$pan}', '{$key}', '{$nameTitle}', '{$deggrp}', '{$board}', '{$experience}','{$desnname}','{$collname}')"; $result = $aobj_context->pobj_db->Execute($query); $getTeachcode = "select internal_code from masteach where fteachcode = '{$mobile}'"; $resultTeachCode = $aobj_context->pobj_db->GetRow($getTeachcode); $teachcode = $resultTeachCode['internal_code']; $insTeachcode = "update masteach set fteachcode='{$resultTeachCode['internal_code']}' where fteachcode = '{$mobile}'"; $resultTeachcode = $aobj_context->pobj_db->Execute($insTeachcode); } foreach($data as $val){ if($val['fdeleted'] === 'T'){ if($resultTeach['fteachcode'] === $teachcode){ $queryDlt = "delete from teachsub where fqpcode = '{$val['fqpcode']}' and fteachcode = '{$teachcode}'"; $resultDlt = $aobj_context->pobj_db->Execute($queryDlt); }else{ $queryDlt = "delete from teachsub where fqpcode = '{$val['fqpcode']}' and fteachcode = '{$resultTeachCode['internal_code']}'"; $resultDlt = $aobj_context->pobj_db->Execute($queryDlt); } }else{ if($resultTeach['fteachcode'] === $teachcode){ $queryIns = "insert into teachsub (fteachcode, fqpcode) values('{$teachcode}','{$val['fqpcode']}')"; $resultIns= $aobj_context->pobj_db->Execute($queryIns); }else{ $queryIns = "insert into teachsub (fteachcode, fqpcode) values('{$resultTeachCode['internal_code']}','{$val['fqpcode']}')"; $resultIns= $aobj_context->pobj_db->Execute($queryIns); } } } if($result){ // unlink($file_path); $query1 = "insert ignore into logisys3_comexam.pushstud(funivcode, fregno,fname,fdob,FCOLLCODE,FUSERTYPE) values('{$univcode}','{$teachcode}','{$teachname}',date_format(str_to_date('{$dob}', '%d/%m/%Y'), '%Y-%m-%d'),'{$college}','600')"; $resul1 = $aobj_context->pobj_db->Execute($query1); $arr['msg'] = 'Saved Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success"); return; }else{ $arr['msg'] = 'Failed to save'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } // }catch(S3Exception $e) { // $arr['msg'] = 'Failed to upload'; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); // return; // } // } // } } function viewTeacherEntry($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $query = "select * from masteach"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getTeacherData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $teachcode = $aobj_context->mobj_data["teachcode"]; $collcode = $aobj_context->mobj_data["collcode"]; $query = "select * from masteach where fteachcode='{$teachcode}' and fcollcode='{$collcode}'"; $result = $aobj_context->pobj_db->GetRow($query); $subQuery = "select m.fexamno, ifnull(m.fboard,'') as fboard, t.fqpcode, m.fsubname, group_concat(distinct m.fdegree SEPARATOR ', ') as fdegrees from teachsub t inner join subject m on t.fqpcode = m.fqpcode where t.fteachcode = '{$teachcode}' group by t.fqpcode,t.fteachcode order by m.fexamno, t.fqpcode"; $subResult = $aobj_context->pobj_db->GetAll($subQuery); if($result){ $arr['det'] = $result; $arr['sub'] = $subResult; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function assignModerator($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $board = $aobj_context->mobj_data["board"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $deggrp = $aobj_context->mobj_data["deggrp"]; $split = explode("*", $deggrp); $dggrp = $split[0]; $yearmode = explode('-',$split[1]); $year = $yearmode[0]; $fexamtype = $yearmode[1]; if($qpcode === "All"){ $qpcond = " "; }else{ $qpcond = "and s.fqpcode = '{$qpcode}'"; } if($board === "All"){ $boardCond = " "; }else{ $boardCond = "and s.fboard = '{$board}'"; } $get_data= "select distinct s.fqpcode, concat(s.fsubname, ' - ', s.fsubshort) as fsubname, m.fteachcode, ifnull(m.flogin, '')as fstatus, m.fdeleted, mas.fteachname, mas.fmobile,count(q.fset) as fset, SUM(IFNULL(q.fqpfilepath, 1)) AS not_uploaded, (count(q.fset) - SUM(IFNULL(q.fqpfilepath, 1))) AS uploaded,ifnull(m.ffromdate,'') as ffromdate,ifnull(m.ftodate,'') as ftodate, ifnull(m.femailstatus,'') as emailstatus from moderator m right join subject s on m.fqpcode = s.fqpcode left join masteach mas on mas.fteachcode = m.fteachcode inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno left join qpseterdet q on s.fqpcode = q.fqpcode where d.fdeggrp = '{$dggrp}' and ifnull(s.fqpcode, '') <> '' and q.fyear = '{$year}' and q.fexamtype = '{$fexamtype}' {$boardCond} {$qpcond} group by s.fqpcode"; $lobj_get_data = $aobj_context->pobj_db->GetAll($get_data); $teach = "select fteachcode, fteachname, fmobile from masteach where ifnull(fteachcode, '')<>''"; $teach_res = $aobj_context->pobj_db->GetAll($teach); if($teach_res){ $arr['teach'] = $teach_res; $arr['mod'] = $lobj_get_data; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveAssignModerator($aobj_context){ include("sendGridMail.php"); include("error_log.php"); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $user = $aobj_context->mobj_data["user"]; $year = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $data = json_decode($aobj_context->mobj_data["data"], true); $onldate = date('d-m-Y'); $split = explode("*",$year); $degree = $split[0]; $splitagain = explode("-",$split[1]); $year = $splitagain[0]; $mode = $splitagain[1]; foreach($data as $val){ $query = "select fqpcode from moderator where fqpcode = '{$val['fqpcode']}'"; $res = $aobj_context->pobj_db->GetRow($query); if($val['fteachcode']!==NULL && $val['fteachcode']!=="" && $val['fteachcode']!=="Select"){ if($res['fqpcode'] == $val['fqpcode']){ $Qry = "update moderator set fyear='{$year}', fexamtype='{$mode}', fteachcode='{$val['fteachcode']}', flogin='{$val['fstatus']}', fdeleted='{$val['fdeleted']}', fcreateduser='{$user}',ffromdate = '{$val['ffromdate']}', ftodate = '{$val['ftodate']}',fcreatedate=now(), femailstatus = '{$val['emailstatus']}' where fqpcode='{$val['fqpcode']}'"; }else{ $Qry = "insert ignore into moderator (fyear, fexamtype, fqpcode, fteachcode, flogin, fdeleted, fcreateduser, fcreatedate, femailstatus,ffromdate,ftodate) values('{$year}', '{$mode}', '{$val['fqpcode']}', '{$val['fteachcode']}', '{$val['fstatus']}', '{$val['fdeleted']}', '{$user}', now(), '{$val['emailstatus']}','{$val['ffromdate']}','{$val['ftodate']}')"; } $result = $aobj_context->pobj_db->Execute($Qry); $remarks = "Moderator is Assigned for teacher ".$val['fteachcode']." and qpcode ".$val['fqpcode']." and exam year and number ".$year."-".$mode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Assign Moderator", $user, $user); } if($result){ $slt = "select FMOBILENO, FUSERTYPE, FPASSWD, FEMAIL from logisys3_comexam.masuser where FMOBILENO = '{$val['fmobile']}'"; $reslt = $aobj_context->pobj_db->GetRow($slt); $usertype = $reslt['FUSERTYPE']; $emailid = $reslt['FEMAIL']; if(count($reslt) > 0){ $queryIns = "update logisys3_comexam.masuser set FUSERTYPE = concat('{$usertype}','*','502'), ftype = 'M', FTEMP = 'M' where FMOBILENO = '{$val['fmobile']}' and funivcode = '{$univcode}'"; }else{ $queryIns = "insert ignore into logisys3_comexam.masuser(FUNIVCODE, FREGNO, FMOBILENO, FUSERTYPE, FPASSWD, ftype, FTEMP, FACTIVE) values('{$univcode}', '{$val['fteachcode']}', '{$val['fmobile']}', '502', '{$val['fmobile']}', 'M', 'M', 'T')"; } // var_dump($queryIns);die(); $resultIns = $aobj_context->pobj_db->Execute($queryIns); $remarks = "Added new Usertype for ".$val['fmobile']." and Univcode ".$univcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Assign Moderator", $user, $user); if($resultIns){ $sentStat = "select ifnull(fsent, '')as fsent from moderator where fteachcode='{$val['fteachcode']}'"; $sentRes = $aobj_context->pobj_db->GetRow($sentStat); // if($sentRes['fsent'] !== 'T'){ if($val['emailstatus'] == 'T'){ $slt = "select FMOBILENO, FUSERTYPE, FPASSWD, FEMAIL from logisys3_comexam.masuser where FMOBILENO = {$val['fmobile']}"; $reslt = $aobj_context->pobj_db->GetRow($slt); $usertype = $reslt['FUSERTYPE']; $emailid = $reslt['FEMAIL']; $getEmail = "select FEMAIL from masteach where FMOBILE = '{$val['fmobile']}'"; $ret = $aobj_context->pobj_db->GetRow($getEmail); $emailsent = $ret['FEMAIL']; $unishort = "select funivname, ffolder, pdf_logo_path,FTOWN from control"; $resunishort = $aobj_context->pobj_db->GetRow($unishort); $univname = $resunishort['funivname']; $town = $resunishort['FTOWN']; $univshort = strtoupper($resunishort['ffolder']); $teachDet = "select ifnull(m.fteachname, '')as fteachname, ifnull(m.fcollname, '')as fcollname, d.fdegncode, ifnull(d.fdegndesc, '')as fdegndesc from masteach m inner join masdegn d on d.fdegncode = m.fdegncode where fteachcode = '{$val['fteachcode']}'"; $teachDet1 = $aobj_context->pobj_db->GetRow($teachDet); $teachname = $teachDet1['fteachname']; $colladd = $teachDet1['fcollname']; $degn = $teachDet1['fdegndesc']; $query1 = "select distinct s.fqpcode,s.fsubname,d.fexamdate,d.fexamname,d.fdescpn from subject s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno where fqpcode = '{$val['fqpcode']}'"; $res1 = $aobj_context->pobj_db->GetRow($query1); $fqpcode = $res1['fqpcode']; $fsubname = $res1['fsubname']; $fexamdate = $res1['fexamdate']; $fexamnmae = $res1['fexamname']; $fdescpn = $res1['fdescpn']; $qur = "select fmodemail,ftdvs_helplineno from control"; $resn = $aobj_context->pobj_db->GetRow($qur); $mailmtr =$resn['fmodemail']; $helplineno =$resn['ftdvs_helplineno']; $qur1 = "select fexamdate from deggrp where fdeggrp = '{$degree}'"; $resn1 = $aobj_context->pobj_db->GetRow($qur1); $exm =$resn1['fexamdate']; $frmdate = date("d-m-Y", strtotime($val['ffromdate'])); $todate = date("d-m-Y", strtotime($val['ftodate'])); if($univcode == "051"){ $logo_path = "/img/dyp_elogo.jpeg"; }else{ $logo_path = $resunishort['pdf_logo_path']; } $logo = "https://college.universitysolutions.in/".$resunishort['ffolder']. $logo_path; $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='200px'/></center>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif; text-align:center; color:red'> CONFIDENTIAL</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // Ref.: DYPU/COE/AYU/2022-23/EP/C-041.</p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif; text-align:right'>Date.:"." $onldate "."</p>"; $message.="<p>Dear Sir/Madam,<br><br><br></p>"; // $message.="<p style='line-height: 0;'>"."$teachname".",<br></p>"; // if($degn != ""){ // $message.="<p style='line-height: 2;'>"."$degn".",<br></p>"; // } // if($colladd != ""){ // $message.="<p style='line-height: 0;'>"."$colladd".",<br></p>"; // } // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // Sub: Appointment as Question Paper moderator for the University Examination – Summer 2023.</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // Dear Sir / Madam,</p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> The University is pleased to appoint you as the Question paper moderator for the course "."$fqpcode"."–"."$fsubname"." of $fdescpn, University exams.<br> You are asked to report to the CoE office on {$todate} and complete the Question paper moderation on the same day.</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // <table style='width: 100%;border: 1px solid'><tr><th style='border: 1px solid'>Course Code</th> // <th style='border: 1px solid'>Course Name</th><th style='border: 1px solid'>Total No of QP for the code (both Internal & external)</th></tr> // <tr style='text-align:center'><td style='border: 1px solid'>"."$fqpcode"."</td><td style='border: 1px solid'>"."$fsubname"."</td> // <td style='border: 1px solid'>"."{$val['fset']}"."</td></tr></table></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> {$mailmtr}</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // You are asked to report at CoE office on DATE at TIME</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // Kindly submit your bank details at the portal.</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // Syllabus with Course Outcomes (CO) and Question Paper Pattern are provided. Kindly prepare question paper as per the requirements // of COs and Blooms Taxonomy (Preferably higher cognitive levels) and indicate them at the appropriate places in the question paper along with the marks allotted.</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // The Question paper and the answer key (All Sections) are to be uploaded only in the portal on or before "."$lastdate"."</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // Kindly submit your bank details at the portal.</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // Kindly inform your acceptance within three days of the receipt of this communication</p><br>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> Portal Login details are as follows.<br><br>"; $message.="Portal Link: https://egov.universitysolutions.in/#/register"."<br>"; $message.="Teacher Code:"."{$val['fteachcode']}"."<br>"; $message.="Mobile No.:"."{$val['fmobile']}"."<br></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> Kindly call to "."$helplineno"." in case if you have any technical issues.<br></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> Thanking You,</p>"; // $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> // Yours Sincerely<br><br><br>"; $querySign = "select distinct s.fqpcode, d.fsignpath from degree d inner join subject s on s.fdegree = d.fdegree and s.fexamno = d.fexamno where s.fqpcode='{$fqpcode}' and ifnull(fsignpath,'')<>''"; $ressign = $aobj_context->pobj_db->GetRow($querySign); $sign = $ressign['fsignpath']; $signpath = "https://college.universitysolutions.in/".$resunishort['ffolder']."/img/".$sign; if($sign!==NULL){ $message .= "<img src='{$signpath}' width='100' height='50'/>"; $message .= "<br/>"; } $message.="Controller of Examinations<br>"."$univname"."<br> $town </p>"; $message.="</body>"; $message.="</html>"; $subject= strtoupper("$univshort".": Appointment as Moderator for the University ".$fexamdate." Examination"); $from = ""; $resp = sendGridMail($emailsent,$subject,$message,$univcode); $insQry = "update moderator set fsent='T' where fteachcode='{$val['fteachcode']}'"; $res = $aobj_context->pobj_db->Execute($insQry); } // } } } } if($resultIns){ $arr['msg'] = 'Saved Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else{ $arr['msg'] = 'Failed to save'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function qpModeratorSummary($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $year = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $degree = $aobj_context->mobj_data["degree"]; $sem = $aobj_context->mobj_data["sem"]; $teachstatus = $aobj_context->mobj_data["status"]; $modstatus = $aobj_context->mobj_data["modstatus"]; $split = explode("*", $year); $deggrp = $split[0]; $splitYearAndMode = explode("-", $split[1]); $year = $splitYearAndMode[0]; $type = $splitYearAndMode[1]; if($board === "All"){ $boardCond = " "; }else{ $boardCond = "and s.fboard='{$board}'"; } if($qpcode === "All"){ $qpCond = " "; }else{ $qpcond = "and qd.fqpcode='{$qpcode}'"; } $degreeArr = explode(",", $degree); foreach($degreeArr as $key => $val){ if($val != 'All'){ $fdegree .= "'".$val."',"; } } $degArray = substr_replace($fdegree ,"",-1); if($degree === "All"){ $degCond = " "; }else{ $degCond = "and d.fdegree in ({$degArray})"; } if($sem === "All"){ $semCond = " "; }else{ $semCond = "and d.fexamno = '{$sem}'"; } if($teachstatus === "uploaded"){ $teachUpdCond = "and ifnull(qd.fqpfilepath, '') <> '' and ifnull(fanskeypath, '') <> '' "; }else if($teachstatus === "not_uploaded"){ $teachUpdCond = "and ifnull(qd.fqpfilepath, '') = '' and ifnull(fanskeypath, '') = ''"; }else{ $teachUpdCond = " "; } if($modstatus === "uploaded"){ $modstatusCond = "and ifnull(qd.fmodqppath, '') <> ''"; }else if($modstatus === "not_uploaded"){ $modstatusCond = "and ifnull(qd.fmodqppath, '') = ''"; }else{ $modstatusCond = " "; } $query = "select q.fqpcode,concat(s.fsubname, ' - ', s.fsubshort) as fsubname,q.fnoqp, group_concat(distinct concat('Set: ',fset,' - ',if(ifnull(fqpfilepath,'') = '','Not Uploaded','Uploaded')) separator ', ')as fstatus, group_concat(distinct concat('Set: ',fset,' - ',if(ifnull(fmodqpupd,'') = '','Not Uploaded','Uploaded')) separator ', ')as fmodstatus, q.fteachcode, m.fteachname, group_concat(distinct concat('Set: ',fset,' - ',if(ifnull(qd.fstatus,'') = '','',qd.fstatus)) separator ', ')as status from qpseter q inner join qpseterdet qd on q.fqpcode = qd.fqpcode and qd.fteachcode = q.fteachcode inner join subject s on q.fqpcode = s.fqpcode inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno inner join masteach m on q.fteachcode = m.fteachcode WHERE ifnull(q.fappointed,'') = 'T' and d.fdeggrp = '{$deggrp}' and qd.fyear='{$year}' and qd.fexamtype='{$type}' {$boardCond} {$qpcond} {$degCond} {$semCond} {$teachUpdCond} {$modstatusCond} group by q.fqpcode,q.fteachcode order by q.fqpcode,q.fteachcode;"; // var_dump($query);die(); $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function viewQuestionPaper($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $year = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $degree = $aobj_context->mobj_data["degree"]; $sem = $aobj_context->mobj_data["sem"]; $stype = $aobj_context->mobj_data["stype"]; $status = $aobj_context->mobj_data["status"]; $split = explode("*", $year); $deggrp = $split[0]; $splitYearAndMode = explode("-", $split[1]); $year = $splitYearAndMode[0]; $type = $splitYearAndMode[1]; if($board === "All"){ $boardCond = " "; }else{ $boardCond = "and qd.fboard='{$board}'"; } if($qpcode === "All"){ $qpCond = " "; }else{ $qpCond = " and qd.fqpcode = '{$qpcode}'"; } if($degree === "All"){ $degCond = " "; }else{ $degCond = "and d.fdegree = '{$degree}'"; } if($sem === "All"){ $semCond = " "; }else{ $semCond = "and d.fexamno = '{$sem}'"; } if($status === "All"){ $statCond = " "; }else if($status === "uploaded"){ $statCond = "and ifnull(fqpfilepath, '')<>'' and ifnull(fanskeypath, '')<>'' and ifnull(fmodqppath, '')<>''"; }else if($status === "not_uploaded"){ $statCond = "and ifnull(fqpfilepath, '')='' and ifnull(fanskeypath, '')='' and ifnull(fmodqppath, '')=''"; } if(strtoupper($stype) == 'OLD') { $query = "select q.fqpcode, concat(s.fsubname, ' - ', s.fsubshort) as fsubname, q.fset, m.fteachcode, m1.fteachname as fmodteachname, q.fmodteach, ifnull(q.fqpfilepath, '')as fqpfilepath, ifnull(q.fmodqppath, '')as fmodqppath, date_format(fqpdtme, '%d/%m/%Y %H:%i:%s')as fqpupddate, m.fteachname, ifnull(q.ffinalpaper, '') as ffinalpaper, ifnull(q.fanskeypath, '')as fanskeypath, ifnull(q.fstatus, '') as status from qpseterdet q inner join subject s on s.fqpcode = q.fqpcode inner join masteach m on m.fteachcode = q.fteachcode left join masteach m1 on m1.fteachcode = q.fmodteach inner join qpseter qd on qd.fqpcode = q.fqpcode and qd.fteachcode = q.fteachcode inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno where d.fdeggrp = '{$deggrp}' {$boardCond} {$qpCond} {$degCond} {$semCond} {$statCond} group by q.fqpcode, m.fteachcode, q.fset, qd.fyear, qd.fexamtype order by q.fqpcode, m.fteachcode, q.fset, qd.fyear, qd.fexamtype"; }else { $query = "select q.fqpcode, concat(s.fsubname, ' - ', s.fsubshort) as fsubname, q.fset, m.fteachcode, m1.fteachname as fmodteachname, q.fmodteach, ifnull(q.fqpfilepath, '')as fqpfilepath, ifnull(q.fmodqppath, '')as fmodqppath, date_format(fqpdtme, '%d/%m/%Y %H:%i:%s')as fqpupddate, m.fteachname, ifnull(q.ffinalpaper, '') as ffinalpaper, ifnull(q.fanskeypath, '')as fanskeypath, ifnull(q.fstatus, '') as status from qpseterdet q inner join subject s on s.fqpcode = q.fqpcode inner join masteach m on m.fteachcode = q.fteachcode left join masteach m1 on m1.fteachcode = q.fmodteach inner join qpseter qd on qd.fqpcode = q.fqpcode and qd.fteachcode = q.fteachcode inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno where qd.fyear = '{$year}' and qd.fexamtype = '{$type}' and d.fdeggrp = '{$deggrp}' {$boardCond} {$qpCond} {$degCond} {$semCond} {$statCond} group by q.fqpcode, m.fteachcode,q.fset,qd.fyear,qd.fexamtype order by q.fqpcode, m.fteachcode, q.fset,qd.fyear,qd.fexamtype"; } $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveViewQuestionPaper($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $year = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $data = json_decode($aobj_context->mobj_data["data"], true); $split = explode("*", $year); $splitYearAndMode = explode("-", $split[1]); $fyear = $splitYearAndMode[0]; $fexamtype = $splitYearAndMode[1]; foreach($data as $value){ $query = "update qpseterdet set ffinalpaper='{$value['ffinalpaper']}' where fyear = '{$fyear}' and fexamtype = '{$fexamtype}' and fqpcode = '{$value['fqpcode']}' and fteachcode = '{$value['fteachcode']}' and fset = '{$value['fset']}'"; $result = $aobj_context->pobj_db->Execute($query); } if($result){ $arr['msg'] = "successfully updated"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function viewQPPatternHandler($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $year = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $status = $aobj_context->mobj_data["status"]; $sem = $aobj_context->mobj_data["sem"]; if($sem === "All"){ $semCond = " "; }else{ $semCond = "and d.fexamno='{$sem}'"; } if($status === "pending"){ $statusCond = "and ifnull(FQPPATREN, '') = ''"; }else if($status === "uploaded"){ $statusCond = "and ifnull(FQPPATREN, '') <> '' or ifnull(FSCHPATTERN, '') <> '' or ifnull(FQPSYLLABUS, '') <> ''"; }else{ $statusCond = " "; } $split = explode("*", $year); $deggrp = $split[0]; $splitYearAndMode = explode("-", $split[1]); $year = $splitYearAndMode[0]; $type = $splitYearAndMode[1]; if($board === "All"){ $boardCond = " "; }else{ $boardCond = "and fboard='{$board}'"; } if($qpcode === "All"){ $qpCond = "where ifnull(fqpcode, '') <> ''"; }else{ $qpCond = "where fqpcode = '{$qpcode}'"; } $query = "select distinct ifnull(fqpcode, '')as fqpcode, concat(s.fsubname, ' - ', s.fsubshort) as fsubname, ifnull(FSUBSHORT, '')as FSUBSHORT, ifnull(FQPPATREN, '')as FQPPATREN, ifnull(FQPSYLLABUS, '')as FQPSYLLABUS, ifnull(FSCHPATTERN, '')as FSCHPATTERN, fboard from subject s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno left join deggrp dg on d.fdeggrp = dg.fdeggrp {$qpCond} {$boardCond} {$statusCond} and d.fdeggrp = '{$deggrp}' {$semCond}"; // var_dump($query);die(); $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function uploadQpSyllabusFile($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $year = $aobj_context->mobj_data["year"]; $board = $aobj_context->mobj_data["board"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $collcode = $aobj_context->mobj_data["collcode"]; $mobile = $aobj_context->mobj_data["mobile"]; $fuserid = $aobj_context->mobj_data["fuserid"]; $qpfile = $_FILES['qpFile']['name']; $temp_qpfile = $_FILES['qpFile']['tmp_name']; $syllabusfile = $_FILES['syllabusFile']['name']; $temp_syllabusfile = $_FILES['syllabusFile']['tmp_name']; $schemefile = $_FILES['schemeFile']['name']; $temp_schemefile = $_FILES['schemeFile']['tmp_name']; $date = date('Y-m-d H:i:s'); try{ $s3 = S3Client::factory( array( 'credentials' => array( 'key' => IAM_KEY, 'secret' => IAM_SECRET ), 'version' => "latest", 'region' => 'ap-south-1' )); if($qpfile !== null){ $qpfileExt = pathinfo($qpfile, PATHINFO_EXTENSION); $qpfile = $qpcode."_pattern".".".$qpfileExt; $moveQp = move_uploaded_file($temp_qpfile, "uploadqpscheme/".$qpfile); $qpfile_path = $aobj_context->main_src."uploadqpscheme/{$qpfile}"; $Qpkey = $univcode."/"."pattern/".$qpfile; $s3->putObject(['Bucket' => "qp-scheme", 'Key' => $Qpkey, 'SourceFile' => $qpfile_path]); $query = "update subject set FQPPATREN = '{$Qpkey}', FQPDATE = '{$date}', FUSERID = '{$fuserid}' where fqpcode = '{$qpcode}'"; $result = $aobj_context->pobj_db->Execute($query); } if($syllabusfile !== null){ $syllabusfileExt = pathinfo($syllabusfile, PATHINFO_EXTENSION); $syllabusfile = $qpcode."_syllabus".".".$syllabusfileExt; $moveSyllabus = move_uploaded_file($temp_syllabusfile, "uploadqpscheme/".$syllabusfile); $syllabusfile_path = $aobj_context->main_src."uploadqpscheme/{$syllabusfile}"; $Schemekey = $univcode."/"."syllabus/".$syllabusfile; $s3->putObject(['Bucket' => "qp-scheme", 'Key' => $Schemekey, 'SourceFile' => $syllabusfile_path]); $query = "update subject set FQPSYLLABUS='{$Schemekey}', FQPDATE = '{$date}', FUSERID = '{$fuserid}' where fqpcode = '{$qpcode}'"; $result = $aobj_context->pobj_db->Execute($query); } if($schemefile !== null){ $schemefileExt = pathinfo($schemefile, PATHINFO_EXTENSION); $schemefile = $qpcode."_scheme".".".$schemefileExt; $moveScheme = move_uploaded_file($temp_schemefile, "uploadqpscheme/".$schemefile); $schemefile_path = $aobj_context->main_src."uploadqpscheme/{$schemefile}"; $Schemefilekey = $univcode."/"."scheme/".$schemefile; $s3->putObject(['Bucket' => "qp-scheme", 'Key' => $Schemefilekey, 'SourceFile' => $schemefile_path]); $query = "update subject set FSCHPATTERN = '{$Schemefilekey}', FQPDATE = '{$date}', FUSERID = '{$fuserid}' where fqpcode = '{$qpcode}'"; $result = $aobj_context->pobj_db->Execute($query); } if($result){ unlink($qpfile_path); unlink($syllabusfile_path); unlink($schemefile_path); $remarks = "uploaded qppattern and syllabus pattern file against qpcode ".$qpcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Upload QP Pattern and Syllabus Pattern", $mobile, $mobile); $arr['msg'] = 'File uploaded'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success"); return; }else{ $arr['msg'] = 'Failed to upload'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } catch(S3Exception $e) { $arr['msg'] = 'Failed to upload'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } // $split = explode("*", $year); // $splitYearAndMode = explode("-", $split[1]); // $year = $splitYearAndMode[0]; // $type = $splitYearAndMode[1]; } function viewFinalQp($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $year = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $split = explode("*", $year); $degree = $split[0]; $splitYearAndMode = explode("-", $split[1]); $fyear = $splitYearAndMode[0]; $fexamtype = $splitYearAndMode[1]; if($board === "All"){ $boardCond = " "; }else{ $boardCond = "and s.fboard = '{$board}'"; } if($qpcode === "All"){ $qpCond = " "; }else{ $qpCond = "and q.fqpcode='{$qpcode}'"; } $query = "select distinct q.fqpcode, concat(s.fsubname, ' - ', s.fsubshort) as fsubname, ifnull(fmodqppath, '')as modqppath,q.* from qpseterdet q inner join subject s on s.fqpcode = q.fqpcode inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno left join deggrp dg on d.fdeggrp = dg.fdeggrp where ffinalpaper = 'T' and d.fdeggrp = '{$degree}' and dg.fyear = '{$fyear}' and dg.fexamtype = '{$fexamtype}' {$qpCond} {$boardCond}"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function downloadQPFinal($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $fcollcode = $aobj_context->mobj_data["fcollcode"]; $fmobileno = $aobj_context->mobj_data["fmobileno"]; $fuserid = $aobj_context->mobj_data["fuserid"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $remarks = "View Question Paper - ". $fuserid ."Downloaded or viewed question paper qpcode ". $qpcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "View Final Question Paper", $fuserid, $fmobileno); } function getModeratorData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $teachcode = $aobj_context->mobj_data["teachcode"]; $query = "select q.fqpcode, concat(s.fsubname, ' - ', s.fsubshort)as fsubname, q.fset, q.fteachcode, s.fqpsyllabus, q.fexamtype,q.fyear,ifnull(q.fmodqpdate,'') as fmodqpdate from qpseterdet q inner join (select distinct fqpcode, fsubname, fqpsyllabus, fsubshort from subject where ifnull(fqpcode, '') <> '') s on s.fqpcode = q.fqpcode inner join moderator m on m.fqpcode = q.fqpcode where m.fteachcode = '{$teachcode}' and ifnull(q.fqpfilepath, '') <> '' and m.flogin = 'T' order by fmodqpdate = '',fmodqpdate desc"; $result = $aobj_context->pobj_db->GetAll($query); if($result){ 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 getModUpdData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $teachcode = $aobj_context->mobj_data["teachcode"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $user = $aobj_context->mobj_data["userId"]; $fset = $aobj_context->mobj_data["setnos"]; $fyear = $aobj_context->mobj_data["fyear"]; $fexamtype = $aobj_context->mobj_data["fexamtype"]; $query = "select * from moderator where fteachcode = '{$user}' and flogin = 'T' and fqpcode = '{$qpcode}'"; $res = $aobj_context->pobj_db->GetRow($query); if($res) { $query = "select q.fset, ifnull(q.fqpfilepath,'')as fqpfilepath, ifnull(q.fanskeypath, '') as fanskeypath, ifnull(q.fmodqppath, '') as fmodqppath, ifnull(q.fmodqpupd, '') as fmodqpupd, ifnull(q.fmodanskey, '') as fmodanskey, ifnull(q.fmodform, '') as fmodform, ifnull(q.fteachcode,'') as fteachcode, q.fyear,q.fexamtype from qpseterdet q inner join moderator m on m.fqpcode = q.fqpcode where q.fqpcode = '{$qpcode}' and m.fteachcode = '{$user}' and ifnull(q.fqpfilepath, '') <> '' and m.flogin = 'T' and q.fteachcode = '{$teachcode}' and q.fset = '{$fset}' and q.fyear = '{$fyear}' and q.fexamtype = '{$fexamtype}'"; $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; } }else { $arr['msg'] = 'Login Disabled. Kindly contact admin'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } function uploadQPMODFIle($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $filename = $_FILES['qpmodfile']['name']; $tempname = $_FILES['qpmodfile']['tmp_name']; $teachcode = $aobj_context->mobj_data["teachcode"]; $set = $aobj_context->mobj_data["set"]; $fexamtype = $aobj_context->mobj_data["fexamtype"]; $fyear = $aobj_context->mobj_data["fyear"]; $yearmode = $fyear."-".$fexamtype; $ext = pathinfo($filename, PATHINFO_EXTENSION); $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length = 30; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $file_name = $qpcode."_QP_".$randomString.".".$ext; if($filename!=="" && $filename!==NULL){ // $yearMode = "select concat(fyear,'-',fexamtype) as yearMode from qpseterdet where fteachcode = '{$teachcode}' and fqpcode = '{$qpcode}'"; // $resultyearMode = $aobj_context->pobj_db->GetRow($yearMode); // $yearmode = $resultyearMode['yearMode']; $server_path = move_uploaded_file($tempname, "QP_Details/". $file_name); $file_path = $aobj_context->main_src."QP_Details/{$file_name}"; if(file_exists($file_path)){ $s3 = S3Client::factory( array( 'credentials' => array( 'key' => IAM_KEY, 'secret' => IAM_SECRET ), 'version' => "latest", 'region' => 'ap-south-1' )); $key = $univcode."/".$yearmode."/".$qpcode."/".$file_name; try { $s3->putObject(['Bucket' => "moderator-upd", 'Key' => $key, 'SourceFile' => $file_path]); $query = "update qpseterdet set fmodqpupd='{$key}', fmodqpdate=now() where fqpcode = '{$qpcode}' and fset='{$set}' and fteachcode = '{$teachcode}' and fyear = '{$fyear}' and fexamtype = '{$fexamtype}'"; $result = $aobj_context->pobj_db->Execute($query); $remarks = "Moderator QP Details - uploaded QPMODFILE against QP CODE: ".$qpcode. " ,set: ".$set. " and Moderator: ".$teachcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Moderator QP Details", $teachcode, $teachcode); if($result){ unlink($file_path); $arr['msg'] = "File Uploaded Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = "Something went wrong"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } }catch(S3Exception $e) { $arr['msg'] = 'Failed to upload'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } } } function uploadAnsMODFIle($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $filename = $_FILES['ansmodfile']['name']; $tempname = $_FILES['ansmodfile']['tmp_name']; $teachcode = $aobj_context->mobj_data["teachcode"]; $set = $aobj_context->mobj_data["set"]; $fexamtype = $aobj_context->mobj_data["fexamtype"]; $fyear = $aobj_context->mobj_data["fyear"]; $yearmode = $fyear."-".$fexamtype; $ext = pathinfo($filename, PATHINFO_EXTENSION); $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length = 30; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $file_name = $qpcode."_Ans_".$randomString.".".$ext; if($filename!=="" && $filename!==NULL){ // $yearMode = "select concat(fyear,'-',fexamtype) as yearMode from qpseterdet where fteachcode = '{$teachcode}' and fqpcode = '{$qpcode}'"; // $resultyearMode = $aobj_context->pobj_db->GetRow($yearMode); // $yearmode = $resultyearMode['yearMode']; $server_path = move_uploaded_file($tempname, "QP_Details/". $file_name); $file_path = $aobj_context->main_src."QP_Details/{$file_name}"; if(file_exists($file_path)){ $s3 = S3Client::factory( array( 'credentials' => array( 'key' => IAM_KEY, 'secret' => IAM_SECRET ), 'version' => "latest", 'region' => 'ap-south-1' )); $key = $univcode."/".$yearmode."/".$qpcode."/".$file_name; try { $s3->putObject(['Bucket' => "moderator-upd", 'Key' => $key, 'SourceFile' => $file_path]); $query = "update qpseterdet set fmodanskey='{$key}', fmodansdate=now() where fqpcode = '{$qpcode}' and fset='{$set}' and fteachcode = '{$teachcode}' and fyear = '{$fyear}' and fexamtype = '{$fexamtype}'"; $result = $aobj_context->pobj_db->Execute($query); $remarks = "Moderator QP Details - uploaded ANSMODFILE against QP CODE: ".$qpcode. " ,set: ".$set. " and Moderator: ".$teachcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Moderator QP Details", $teachcode, $teachcode); if($result){ unlink($file_path); $arr['msg'] = "File Uploaded"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = "Something went wrong"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } }catch(S3Exception $e) { $arr['msg'] = 'Failed to upload'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } } } function uploadMODFormFIle($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $filename = $_FILES['modfile']['name']; $tempname = $_FILES['modfile']['tmp_name']; $teachcode = $aobj_context->mobj_data["teachcode"]; $set = $aobj_context->mobj_data["set"]; $fexamtype = $aobj_context->mobj_data["fexamtype"]; $fyear = $aobj_context->mobj_data["fyear"]; $yearmode = $fyear."-".$fexamtype; $ext = pathinfo($filename, PATHINFO_EXTENSION); $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length = 30; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $file_name = $qpcode."_mod_".$randomString.".".$ext; if($filename!=="" && $filename!==NULL){ // $yearMode = "select concat(fyear,'-',fexamtype) as yearMode from qpseterdet where fteachcode = '{$teachcode}' and fqpcode = '{$qpcode}'"; // $resultyearMode = $aobj_context->pobj_db->GetRow($yearMode); // $yearmode = $resultyearMode['yearMode']; $server_path = move_uploaded_file($tempname, "QP_Details/". $file_name); $file_path = $aobj_context->main_src."QP_Details/{$file_name}"; if(file_exists($file_path)){ $s3 = S3Client::factory( array( 'credentials' => array( 'key' => IAM_KEY, 'secret' => IAM_SECRET ), 'version' => "latest", 'region' => 'ap-south-1' )); $key = $univcode."/".$yearmode."/".$qpcode."/".$file_name; try { $s3->putObject(['Bucket' => "moderator-upd", 'Key' => $key, 'SourceFile' => $file_path]); $query = "update qpseterdet set fmodform='{$key}', fmodformdate=now() where fqpcode = '{$qpcode}' and fset='{$set}' and fteachcode = '{$teachcode}' and fyear = '{$fyear}' and fexamtype = '{$fexamtype}'"; $result = $aobj_context->pobj_db->Execute($query); $remarks = "Moderator QP Details - uploaded MODFORM against QP CODE: ".$qpcode. " ,set: ".$set. " and Moderator: ".$teachcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Moderator QP Details", $teachcode, $teachcode); if($result){ unlink($file_path); $arr['msg'] = "File Uploaded"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else{ $arr['msg'] = "Something went wrong"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } }catch(S3Exception $e) { $arr['msg'] = 'Failed to upload'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } }else{ $arr['msg'] = 'Failed to upload'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } } function checkTeachEntryMobile($aobj_context){ $univcode = $aobj_context->mobj_data["univcode"]; $mobile = $aobj_context->mobj_data["mobileno"]; $query = "select * from masteach where fmobile = '{$mobile}'"; $result = $aobj_context->pobj_db->GetAll($query); // var_dump($result);die(); if(count($result) > 0){ $arr['msg'] = 'Mobile number already present'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } ?>
Close
