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.149.254.35
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
admission /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
adm_admin.php
36.49
KB
-rw-r--r--
adm_master.php
14.07
KB
-rw-r--r--
adm_register.php
78.86
KB
-rw-r--r--
adm_session_start.php
893
B
-rw-r--r--
cappcontext.php
4.58
KB
-rw-rw-r--
constants.php
818
B
-rw-rw-r--
coutput.php
1.75
KB
-rw-rw-r--
create_user.php
27.69
KB
-rw-rw-r--
creditMaster.php
2.31
KB
-rwxr-xr-x
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
514
B
-rwxr-xr-x
cuser.php
3.41
KB
-rwxr-xr-x
cuser1.php
3.41
KB
-rwxr-xr-x
customappcontext.php
2.35
KB
-rwxr-xr-x
dailyValuation.php
1.6
KB
-rwxr-xr-x
dashboard.php
3
KB
-rwxr-xr-x
dashboardNew.php
31.05
KB
-rw-r--r--
database.php
744
B
-rw-rw-r--
dateMaster.php
2.83
KB
-rwxr-xr-x
dateupdate.php
8.88
KB
-rw-r--r--
define_heads.php
1.89
KB
-rw-r--r--
degcollege.php
7.32
KB
-rwxr-xr-x
deggrp.php
13.84
KB
-rwxr-xr-x
deggrpNew.php
4.04
KB
-rw-r--r--
degree.php
3.34
KB
-rwxr-xr-x
degreeEntry.php
5.46
KB
-rwxr-xr-x
degreeLoad.php
12.26
KB
-rw-r--r--
dispatchmarkscard.php
19.14
KB
-rwxr-xr-x
drawer.php
552
B
-rw-r--r--
dropDownOptions.php
400
B
-rwxr-xr-x
eGovSignin.php
4.22
KB
-rwxr-xr-x
error_log.php
749
B
-rwxr-xr-x
examAttendance.php
23.9
KB
-rwxr-xr-x
examCntr.php
6.73
KB
-rwxr-xr-x
examCntrdurexm.php
4.05
KB
-rwxr-xr-x
examHappeningCentre.php
19.76
KB
-rwxr-xr-x
examTimetable.php
26.1
KB
-rwxr-xr-x
examTimetableErrorReport.php
7.77
KB
-rwxr-xr-x
exam_app_acknowledge.php
8.41
KB
-rw-r--r--
examapprpt.php
2.9
KB
-rw-r--r--
examattendanceunivadmin.php
19.73
KB
-rwxr-xr-x
exceptionhandler.php
236
B
-rwxr-xr-x
fee-str.php
17.08
KB
-rwxr-xr-x
fee_summary_report.php
43.28
KB
-rwxr-xr-x
fee_summary_report_090120202.p...
43.79
KB
-rwxr-xr-x
finalQp.php
11.07
KB
-rw-r--r--
financeMenuItems.php
1.51
KB
-rw-r--r--
freezeTimetable.php
2.98
KB
-rwxr-xr-x
getBoards.php
1.34
KB
-rwxr-xr-x
getDegSemList.php
7.75
KB
-rwxr-xr-x
getFaculty.php
602
B
-rwxr-xr-x
getMenus.php
3.92
KB
-rwxr-xr-x
getNotifications.php
1.13
KB
-rwxr-xr-x
getPaymentTypes.php
1.77
KB
-rw-rw-r--
getQPdet.php
7
KB
-rw-r--r--
getRvPcReport.php
4.99
KB
-rwxr-xr-x
getStudentRegisteredReport.php
8.91
KB
-rw-r--r--
getUnivName.php
516
B
-rw-r--r--
get_result_table.php
109
B
-rw-r--r--
getdeggrpvalcntr.php
1.88
KB
-rw-r--r--
getinwordstatus.php
3.46
KB
-rw-r--r--
getpgetSavedData.php
4.29
KB
-rwxr-xr-x
getrvpc.php
8.89
KB
-rw-r--r--
getstuddetforrt.php
5.85
KB
-rw-r--r--
getunivs.php
816
B
-rwxr-xr-x
groupMessages.php
9.1
KB
-rwxr-xr-x
grv.php
12.12
KB
-rwxr-xr-x
holidayListing.php
696
B
-rwxr-xr-x
holidayMaster.php
2.11
KB
-rwxr-xr-x
hostNotification.php
1.61
KB
-rwxr-xr-x
htdwonload.php
7.5
KB
-rwxr-xr-x
iNeedHelp.php
3.02
KB
-rwxr-xr-x
iamarkssummary.php
6.25
KB
-rw-r--r--
insertOrEditCollege.php
21.88
KB
-rwxr-xr-x
inward.php
3.09
KB
-rwxr-xr-x
json.php
33.2
KB
-rwxr-xr-x
jwt.php
13.16
KB
-rwxr-xr-x
kswuomr.php
2.8
KB
-rw-r--r--
lastDateUpdate.php
3.95
KB
-rwxr-xr-x
lastDateUpdateCorrection.php
4.81
KB
-rw-r--r--
ledgerview.php
3.2
KB
-rwxr-xr-x
loadclgdettab.php
2.26
KB
-rw-r--r--
loadclgnm.php
1.3
KB
-rw-r--r--
loaddegdet.php
1.45
KB
-rw-r--r--
loaddegreedettab.php
2.49
KB
-rw-r--r--
loadupdclgnm.php
741
B
-rw-r--r--
login.php
1.72
KB
-rwxr-xr-x
loginDet.php
1.04
KB
-rw-r--r--
loginDetails.php
842
B
-rw-r--r--
loginattendance.php
2.21
KB
-rw-r--r--
marks_enter.php
5.74
KB
-rw-r--r--
marksentryupdate.php
4.78
KB
-rw-r--r--
marksmodreport.php
1.49
KB
-rw-r--r--
masQP.php
3.37
KB
-rwxr-xr-x
masterDegree.php
1.16
KB
-rw-r--r--
mcfverify.php
6.65
KB
-rw-r--r--
mpcmanage.php
2.57
KB
-rw-r--r--
mregistry.php
7.59
KB
-rwxr-xr-x
mregistry.php.orig
39.87
KB
-rwxr-xr-x
mregistry_01042021.php
45.75
KB
-rwxr-xr-x
mregistry_arun.php
18.94
KB
-rwxr-xr-x
mregistry_old.php
6.82
KB
-rwxr-xr-x
mregistry_old_03072020.php
33.09
KB
-rwxr-xr-x
mregistry_old_08052020.php
29.86
KB
-rwxr-xr-x
notificationPush.php
9.36
KB
-rwxr-xr-x
oldquestionpaper.php
4.87
KB
-rw-r--r--
omrqnentry.php
8.18
KB
-rw-r--r--
online-test.php
12.77
KB
-rwxr-xr-x
orderReportExcel.php
7.35
KB
-rw-r--r--
paymentReport.php
3.64
KB
-rwxr-xr-x
pgetDashboard.php
0
B
-rwxr-xr-x
pgprevmarks.php
13.41
KB
-rw-r--r--
photoCrop.php
5.57
KB
-rwxr-xr-x
practicalMarks.php
7.09
KB
-rw-r--r--
prbatchdet.php
3.26
KB
-rwxr-xr-x
prifreeze.php
3.11
KB
-rw-r--r--
pushmarks.php
1.18
KB
-rw-r--r--
pushnitification.php
8.1
KB
-rwxr-xr-x
pushnotif_ra.php
3.94
KB
-rwxr-xr-x
qpIndent.php
37.42
KB
-rwxr-xr-x
qpIndent_04032019.php
15.36
KB
-rwxr-xr-x
qpIndent_old.php
37.05
KB
-rwxr-xr-x
qp_dashboard.php
11.31
KB
-rw-r--r--
qp_issue.php
8.46
KB
-rw-r--r--
qp_setter.php
59.66
KB
-rw-r--r--
qp_setter_new.php
53.28
KB
-rw-r--r--
qpboardupdate.php
4.26
KB
-rw-r--r--
qpcrosscheck.php
11.96
KB
-rw-r--r--
qpindentstudlist.php
11.16
KB
-rw-r--r--
qpschemeupload.php
5.84
KB
-rw-r--r--
qpsetterteach.php
22.96
KB
-rw-r--r--
qpsummarynew.php
4.58
KB
-rw-r--r--
qptranlogin.php
1.64
KB
-rw-r--r--
qptranmenu.php
2.22
KB
-rw-r--r--
qpupload.php
8.11
KB
-rwxr-xr-x
qpupload_240621.php
6.49
KB
-rwxr-xr-x
rauspush.php
4.03
KB
-rw-r--r--
razorPayConfig.php
250
B
-rwxr-xr-x
reasonMaster.php
1.73
KB
-rwxr-xr-x
refund.php
2.68
KB
-rwxr-xr-x
register_rrit.php
28.44
KB
-rw-r--r--
releaseTimetable.php
4.73
KB
-rwxr-xr-x
reports_bkp.php
12.25
KB
-rwxr-xr-x
resultStats.php
4.69
KB
-rwxr-xr-x
result_pushnotif_bcu.php
2.33
KB
-rwxr-xr-x
result_pushnotif_bnu.php
2.33
KB
-rwxr-xr-x
result_pushnotif_dud.php
2.33
KB
-rwxr-xr-x
result_pushnotif_kus.php
2.33
KB
-rwxr-xr-x
result_pushnotif_rcub.php
2.33
KB
-rwxr-xr-x
resultdate.php
6.39
KB
-rw-r--r--
resultsApp.php
55
B
-rwxr-xr-x
results_new.php
31.65
KB
-rw-r--r--
resultstat.php
1.72
KB
-rw-r--r--
resultstatsrpt.php
13.82
KB
-rwxr-xr-x
retBatchDet.php
955
B
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
ruaspush.php
618
B
-rw-r--r--
rvMarksEntry.php
4.78
KB
-rwxr-xr-x
rvStatus.php
769
B
-rw-r--r--
rv_result_pushnotif_bcu.php
1.96
KB
-rwxr-xr-x
rvpc.php
1.76
KB
-rw-r--r--
rvrtReport.php
12.39
KB
-rwxr-xr-x
rvrt_Block.php
3.23
KB
-rw-r--r--
rvrtapp.php
22.11
KB
-rw-r--r--
rvrtblock.php
2.97
KB
-rw-r--r--
saveBKMCStdDet.php
2.22
KB
-rw-r--r--
saveBankDetails.php
1.54
KB
-rwxr-xr-x
saveBarcodeDeatils.php
2.87
KB
-rwxr-xr-x
saveDegSemDet.php
14.09
KB
-rwxr-xr-x
saveFinbkmh.php
2.1
KB
-rw-r--r--
savePGETApp.php
4.45
KB
-rwxr-xr-x
savePostNotification.php
2.94
KB
-rwxr-xr-x
scheduleqp.php
2.58
KB
-rw-r--r--
script.php
14.27
KB
-rwxr-xr-x
sdqpmenus.php
163
B
-rw-r--r--
searchregcode.php
5.17
KB
-rw-r--r--
selectFinalQpNew.php
4.69
KB
-rw-r--r--
sendConfMail.php
19.43
KB
-rwxr-xr-x
sendGridMail.php
1.72
KB
-rwxr-xr-x
sendOTP.php
5.51
KB
-rw-r--r--
sendOrder.php
12.33
KB
-rw-r--r--
sendnotification.php
0
B
-rwxr-xr-x
sendsms.php
11.83
KB
-rwxr-xr-x
sendsms_05092020.php
4.34
KB
-rwxr-xr-x
sendsms_15022019.php
6.66
KB
-rwxr-xr-x
sendsms_27012018.php
4.3
KB
-rwxr-xr-x
sendsmsapi.php
802
B
-rwxr-xr-x
sendzohomail.php
1.46
KB
-rw-r--r--
session_start.php
149
B
-rw-r--r--
session_start_rr.php
864
B
-rw-r--r--
sessionmaster.php
1.49
KB
-rw-r--r--
setDGExamTimetableReport.php
19.63
KB
-rwxr-xr-x
setDGExamTimetableReport_bcu_p...
11.51
KB
-rwxr-xr-x
setExamTimetable.php
5.01
KB
-rwxr-xr-x
setExamTimetableReport.php
9.84
KB
-rwxr-xr-x
settlement.php
9.06
KB
-rw-r--r--
sms-new.php
26.55
KB
-rw-r--r--
sms-notification.php
21.17
KB
-rwxr-xr-x
ssp_error_data.php
31.1
KB
-rwxr-xr-x
sspdata-auto-upload.php
11.12
KB
-rwxr-xr-x
sspdata.php
23.9
KB
-rwxr-xr-x
sspdata1.php
11.41
KB
-rw-r--r--
sspdata1_rcub.php
13.96
KB
-rw-r--r--
std_registrtion.php
1.4
KB
-rw-r--r--
studDoc.php
913
B
-rw-r--r--
studReg.php
1.64
KB
-rw-r--r--
stud_ack.php
9.89
KB
-rw-r--r--
stud_det.php
1.62
KB
-rw-r--r--
stud_payments.php
3.24
KB
-rw-rw-r--
student.php
26.71
KB
-rwxr-xr-x
studexamappblock.php
1.18
KB
-rw-r--r--
studymaterial.php
3.07
KB
-rwxr-xr-x
subject.php
2.42
KB
-rwxr-xr-x
subjectEntryScrn.php
8
KB
-rwxr-xr-x
subjectFreeze.php
4.91
KB
-rw-r--r--
sublisting.php
2.39
KB
-rw-r--r--
tdvsCreatePanel.php
1.26
KB
-rw-r--r--
tdvsQPteach.php
2.17
KB
-rw-r--r--
tdvsViewStatus.php
3.52
KB
-rw-r--r--
tdvs_Deviation.php
8.61
KB
-rw-r--r--
tdvs_batch.php
5.89
KB
-rw-r--r--
tdvs_createuser.php
6.5
KB
-rw-r--r--
tdvs_dashboard.php
3.58
KB
-rw-r--r--
tdvs_mail.php
5.93
KB
-rw-r--r--
tdvs_pergeval.php
11.55
KB
-rw-r--r--
tdvs_register.php
1.57
KB
-rw-r--r--
tdvs_saveRecieveQPCount.php
3.53
KB
-rwxr-xr-x
tdvs_saveScript.php
11.74
KB
-rw-r--r--
tdvs_script_cross_check.php
9.35
KB
-rw-r--r--
tdvs_stats.php
21.48
KB
-rw-r--r--
tdvs_subject.php
4.45
KB
-rw-r--r--
tdvs_subjectcreate.php
6.11
KB
-rw-r--r--
tdvs_teacher_valdet.php
2.87
KB
-rw-r--r--
tdvs_teacherpanel.php
3.38
KB
-rw-r--r--
tdvs_teachval.php
1.88
KB
-rw-r--r--
tdvs_teachwisevaldet.php
3.28
KB
-rw-r--r--
tdvs_valcenter.php
2.84
KB
-rw-r--r--
tdvs_verifyqppattern.php
1.03
KB
-rw-r--r--
tdvsdecoding.php
34.16
KB
-rw-r--r--
teachReport.php
5.27
KB
-rwxr-xr-x
teachValBill.php
990
B
-rwxr-xr-x
teachcoderange.php
1.71
KB
-rw-r--r--
teacherEmail.php
20.45
KB
-rw-r--r--
teacherEntry.php
67.04
KB
-rw-r--r--
teacherid.php
2
KB
-rw-r--r--
teachval.php
8.56
KB
-rwxr-xr-x
teachvaluationcount.php
21.07
KB
-rw-r--r--
teachworkapi.php
2.37
KB
-rwxr-xr-x
teachworksum.php
2.42
KB
-rwxr-xr-x
timetablesownload.php
9.98
KB
-rwxr-xr-x
timetablesownload_29062019.php
10.51
KB
-rwxr-xr-x
ttUpload.php
2.5
KB
-rwxr-xr-x
uChangeEmail.php
4.38
KB
-rwxr-xr-x
uChangeMobNum.php
5.17
KB
-rwxr-xr-x
uChangeRegNum.php
4.04
KB
-rwxr-xr-x
uDegPassCrit.php
1.32
KB
-rwxr-xr-x
uDeleteSpecificCollege.php
611
B
-rwxr-xr-x
uExamApplication.php
907
B
-rwxr-xr-x
uExamApplicationForm.php
30.97
KB
-rwxr-xr-x
uForgotPws.php
4.85
KB
-rwxr-xr-x
uGetDetailResult.php
2.17
KB
-rwxr-xr-x
uGetExamCenter.php
1.04
KB
-rwxr-xr-x
uGetResult.php
26.94
KB
-rwxr-xr-x
uGetResultSemester.php
896
B
-rwxr-xr-x
uGetSpecificCollege.php
1.43
KB
-rwxr-xr-x
uGrievances.php
2.97
KB
-rwxr-xr-x
uHallticket.php
5.33
KB
-rwxr-xr-x
uIAMarks.php
3.41
KB
-rwxr-xr-x
uINeedHelp.php
2.82
KB
-rwxr-xr-x
uInsertOrUpdateCollegeDetails....
2.42
KB
-rwxr-xr-x
uMenu_new.php
2.27
KB
-rwxr-xr-x
uNotification.php
3.1
KB
-rwxr-xr-x
uOldQuestionPaper.php
3.46
KB
-rwxr-xr-x
uPracticaltt.php
2.41
KB
-rwxr-xr-x
uProfile.php
1.27
KB
-rwxr-xr-x
uRegistration.php
16.86
KB
-rwxr-xr-x
uRevaluation.php
26.39
KB
-rwxr-xr-x
uRvAppStatus.php
2.42
KB
-rwxr-xr-x
uSubjectList.php
1.53
KB
-rwxr-xr-x
uSupport.php
1023
B
-rwxr-xr-x
uTheorytt.php
2.5
KB
-rwxr-xr-x
uansbookdet.php
2.85
KB
-rwxr-xr-x
uansbookdet0.php
11.83
KB
-rwxr-xr-x
uansbookupdate.php
1.29
KB
-rwxr-xr-x
ulogin.php
2.54
KB
-rwxr-xr-x
ultRoomDet.php
1.96
KB
-rw-r--r--
umenu.php
1.07
KB
-rwxr-xr-x
uniAttEntry.php
1.03
KB
-rw-r--r--
uniContctFrom.php
1.29
KB
-rwxr-xr-x
univRefund.php
9.81
KB
-rwxr-xr-x
unotification.php
3.1
KB
-rwxr-xr-x
upcomingnotification.php
4.55
KB
-rw-r--r--
updateIAMarks.php
1.42
KB
-rw-r--r--
updateRvPcChkList.php
1.13
KB
-rwxr-xr-x
update_dates.php
11.89
KB
-rw-r--r--
upload-sms-excel.php
3.58
KB
-rwxr-xr-x
uploadAnsBook.php
3.38
KB
-rwxr-xr-x
uploadCodeSlips.php
4.1
KB
-rw-r--r--
uploadData.php
6.24
KB
-rwxr-xr-x
uploadDummy.php
761
B
-rw-r--r--
uploadMCdetails.php
4.17
KB
-rw-r--r--
uploadMultipleFiles.php
3.99
KB
-rwxr-xr-x
uploadSSPData.php
5.9
KB
-rw-r--r--
uploadSSPData_bonf.php
11.86
KB
-rw-r--r--
upload_ans_book.php
5.25
KB
-rwxr-xr-x
upload_qp.php
1.85
KB
-rw-r--r--
upload_sms_file.php
7.94
KB
-rw-rw-r--
uploadbackup.php
5.16
KB
-rw-r--r--
uploadcorr_qp.php
4.74
KB
-rw-r--r--
uploadcorrdoc.php
4.09
KB
-rw-r--r--
uploadpwd.php
1.92
KB
-rw-r--r--
uploadqp.php
6.43
KB
-rw-r--r--
uploadqpMultipleFiles.php
678
B
-rw-r--r--
uploadscripts.php
333
B
-rw-r--r--
utils.php
4.19
KB
-rw-r--r--
uucmsdecoding.php
1.86
KB
-rw-r--r--
valuatordet.php
3.29
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : qp_setter_new.php
<?php require_once("/var/www/html/aws/aws-autoloader.php"); require_once(_DIR_."/../../aws/aws-autoloader.php"); use Aws\S3\S3Client; use Aws\S3\Exception\S3Exception; include("/var/www/config.php"); function submitQPDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $exam = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $status = $aobj_context->mobj_data["status"]; $examval = explode('*',$exam); $deggrp = $examval[0]; $yearmode = explode('-',$examval[1]); $year = $yearmode[0]; $mode = $yearmode[1]; if($board !== 'All'){ $cond = "and s.fboard = '{$board}'"; }else{ $cond = ""; } if($status == "Not Assiged"){ $cond1 = "and ifnull(q.fteachcode,'') = ''"; }else if($status == "Assiged"){ $cond1 = "and ifnull(q.fteachcode,'') <> ''"; }else{ $cond1 = ""; } $query = "select distinct ifnull(q.fqpcode, '')as fqpcode, concat(s.fsubname, ' - ', s.fsubshort) as subname, q.fset,q.fqpcodeno,ifnull(q.fteachcode,'') as fteachcode, q.flastdate, if(ifnull(fqpfilepath,'') <> '','QP Uploaded',if(ifnull(q.fstatus,'') <> '',q.fstatus, if(ifnull(q.fteachcode,'') <> '','Not Viewd','Not Assined'))) as fstatus,ifnull(s.fboard,'All') as fboard, s.fvalmax, ifnull(m.fteachname, '')as fteachname from qpseterdet1 q inner join subject s on q.fqpcode = s.fqpcode left join masteach m on m.fteachcode = q.fteachcode where ifnull(s.fdeleted,'') <> '' and s.fdegree in(select distinct fdegree from degree where fdeggrp = '{$deggrp}') and q.fyear = '{$year}' and q.fexamtype = '{$mode}' $cond $cond1"; $result = $aobj_context->pobj_db->GetAll($query); $teach = "select fteachcode, fteachname, fmobile from masteach where ifnull(fteachcode, '')<>''"; $teach_res = $aobj_context->pobj_db->GetAll($teach); $res['res']=$result; $res['teach'] = $teach_res; if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveSelQPSeterNew($aobj_context){ include("sendGridMail.php"); include("error_log.php"); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $mob = $aobj_context->mobj_data["mob"]; $user = $aobj_context->mobj_data["user"]; $exam = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $subj = $aobj_context->mobj_data["subj"]; $collcode = $aobj_context->mobj_data["collcode"]; $mobile = $aobj_context->mobj_data["mobile"]; $table = json_decode($aobj_context->mobj_data["data"], true); $spl = explode('*',$exam); $split = explode('-',$spl[1]); $fyear = $split[0]; $fexamtype = $split[1]; $date = date('Y-m-d H:i:s'); $onldate = date('d-m-Y'); $unishort = "select funivname, ffolder, pdf_logo_path from control"; $resunishort = $aobj_context->pobj_db->GetRow($unishort); $univname = $resunishort['funivname']; $univshort = strtoupper($resunishort['ffolder']); $logopath = $resunishort['pdf_logo_path']; foreach ($table as $k => $v) { $lastdate = $v['flastdate']; $fqpcode = $v['fqpcode']; $fset = $v['fset']; $fsec = $v['fqpcodeno']; $fqpcodeno = $v['fqpcodeno']; $fteachcode = $v['fteachcode']; $fsubname = $v['subname']; $teachDet = "select ifnull(m.fteachname, '')as fteachname, femail,fmobile, 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 = '{$fteachcode}'"; $teachDet1 = $aobj_context->pobj_db->GetRow($teachDet); $teachname = $teachDet1['fteachname']; $emailid = $teachDet1['femail']; $mobile = $teachDet1['fmobile']; $colladd = $teachDet1['fcollname']; $degn = $teachDet1['fdegndesc']; $query = "update qpseterdet1 set fappointdate = '{$date}', fappointuser = '{$user}', fteachcode = '{$fteachcode}',flastdate = '{$lastdate}' where fqpcode = '{$fqpcode}' and fset = '{$fset}' and fqpcodeno = '{$fqpcodeno}' and fyear = '{$fyear}' and fexamtype = '{$fexamtype}'"; $result = $aobj_context->pobj_db->Execute($query); $remarks = "Teacher ". $fteachcode. " Added for the Qp Code ".$fqpcode." No. of Sets: ".$fset." Section: ".$fqpcodeno." Last Date: ".$lastdate; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "QP Setter", $mobile, $mobile); if($univcode == "051"){ $logo_path = "/img/dyp_elogo.jpeg"; }else{ $logo_path = $logopath; } $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>To,<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 Setter for the University Examination.</p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> Respected Sir / Madam,</p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> I am pleased to inform you that this university has appointed you as Question Paper Setter for the following course</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'>Set No.</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'>"."$fset"."-"."$fsec"."</td> </tr></table></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'> Also share the brief answer key (All Sections) for all questions with proper mark split up.</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.="<b>Registration Steps are:</b>"; $message.="<p>1. State: Maharashtra</p>"; $message.="<p>2. University: D Y Patil University, Navi Mumbai</p>"; $message.="<p>3. Select user type as Teacher</p>"; $message.="<p>4. Enter Teacher code which is available in your mail</p>"; $message.="<p>5. Click Validate</p>"; $message.="<p>6. Fill details as: Enter your Email id and Password is your mobile number. Reenter the same password.</p>"; $message.="<p>7. Click Send OTP. You will receive the OTP on your mobile and email also.</p>"; $message.="<p>8. Enter OTP.</p>"; $message.="<p>9. After this for Login: your mobile number will be the user id and password.</p>"; $message.="<p>10. After Login in Question Paper setting Accept the Question Paper Request.</p>"; $message.="<p>11. You can see the Question Paper Pattern and Syllabus.</p>"; $message.="<p>12. Prepare the two separate word documents</p>"; $message.= "<ul><li>Question Paper as per given pattern.</li><li>Brief Answer Keys.</li></ul>"; $message.="<p>13. For Uploading the Question Paper, first upload the answer key then upload the question paper and click upload button. Repeat the same steps for uploading second set of question paper.</p>"; $message.="<p>14. Update the Bank details.</p>"; $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:"." $fteachcode"."<br>"; $message.="Mobile No.:"." $mobile"."<br></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> Kindly call to 022-30965931/32 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>"; $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> Navi Mumbai </p>"; $message.="</body>"; $message.="</html>"; $subject= strtoupper("$univshort".": Appointment as Question Paper Setter for the University Examination"); $from = ""; if($v['emailstatus' ] == 'T') $resp = sendGridMail($emailid,$subject,$message,$univcode); $qrySlt = "select fmobileno, fusertype from logisys3_comexam.masuser where fmobileno='{$mobile}'"; $resQrySlt = $aobj_context->pobj_db->GetRow($qrySlt); $uType = $resQrySlt['fusertype']; $split = explode("*", $uType); foreach($split as $val){ if($val!==""){ $userType = $val."*"; } } if(count($resQrySlt)>0){ if(strpos($uType, '600')===false){ $qry = "update logisys3_comexam.masuser set fusertype=concat('$userType', '600') where funivcode='{$univcode}' and fmobileno='{$mobile}'"; $resQry = $aobj_context->pobj_db->GetRow($qry); } } } if (!$result) { $arr['msg'] = 'Updation Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; }else { $arr['msg'] = 'Updated Success'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Udated Success"); } } function getProgramDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $exam = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $examval = explode('*',$exam); $deggrp = $examval[0]; $yearmode = explode('-',$examval[1]); $year = $yearmode[0]; $mode = $yearmode[1]; if($board !== 'All'){ $cond = "and s.fboard = '{$board}'"; }else{ $cond = ""; } $query = "select distinct d.fprogcode from degree d inner join subject s on d.fdegree = s.fdegree and d.fexamno = s.fexamno where d.fdeggrp = '{$deggrp}' $cond "; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getQPDeta($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $exam = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $progr = $aobj_context->mobj_data["progr"]; $examval = explode('*',$exam); $deggrp = $examval[0]; $yearmode = explode('-',$examval[1]); $year = $yearmode[0]; $mode = $yearmode[1]; if($board !== 'All'){ $cond = "and s.fboard = '{$board}'"; }else{ $cond = ""; } if($progr !== 'All'){ $cond1 = "and d.fprogcode = '{$progr}'"; }else{ $cond1 = ""; } $query = "SELECT d.fdegree,s.fexamno,s.fsubcode,s.fsubname,s.fvalmax, s.fqpcode,ifnull(totbal,'0') as totbal, ifnull(s.fboard,'') as fboard FROM subject s LEFT JOIN(select sum(IF(ifnull(ffinalpaper,'') <> 'T',1,0)) as totbal, fqpcode from qpseterdet1 where fyear = '{$year}' and fexamtype = '{$mode}' and ifnull(fqpfilepath,'') <> '' group by fqpcode) qpdata on s.fqpcode = qpdata.fqpcode inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp where ifnull(s.fqpcode,'') <> '' and d.fdeggrp = '{$deggrp}' and dg.fyear = '{$year}' and dg.fexamtype = '{$mode}' $cond $cond1"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getModeratorDet($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.fteachcode, q.fsqpsyllabus,s.fsubshort, q.fset,q.fqpcodeno as section,q.fyear,q.fexamtype, if(ifnull(fmodqpupd,'') = '','Not Uploaded','Uploaded') fmod from qpseterdet1 q inner join subject s on s.fqpcode = q.fqpcode inner join degree d on s.fdegree = d.fdegree and s.fexamno= d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp and q.fyear = dg.fyear and q.fexamtype = dg.fexamtype where q.fmodteach = '{$teachcode}' and ifnull(q.fqpfilepath,'') <> '' and q.flogin = 'T' group by q.fqpcode,fset,fqpcodeno"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getModQPData($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"]; $section = $aobj_context->mobj_data["section"]; $query = "select * from qpseterdet1 where fmodteach = '{$user}' and flogin = 'T' and fqpcode = '{$qpcode}'"; $res = $aobj_context->pobj_db->GetRow($query); if($res) { $query = "select fset, ifnull(fqpfilepath,'')as fqpfilepath, ifnull(fanskeypath, '') as fanskeypath, ifnull(fmodqppath, '') as fmodqppath, ifnull(fmodqpupd, '') as fmodqpupd, ifnull(fmodanskey, '') as fmodanskey, ifnull(fmodform, '') as fmodform, ifnull(fteachcode,'') as fteachcode,fqpcodeno from qpseterdet1 where fqpcode = '{$qpcode}' and fmodteach = '{$user}' and ifnull(fqpfilepath, '') <> '' and flogin = 'T' and fteachcode = '{$teachcode}' and fset = '{$fset}' and fqpcodeno = '{$section}'"; $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 upldQPMODFile($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"]; $fqpcodeno = $aobj_context->mobj_data["fqpcodeno"]; $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_QP_".$randomString.".".$ext; if($filename!=="" && $filename!==NULL){ $qur = "select distinct dg.fyear,dg.fexamtype from subject s inner join degree d on s.fdegree= d.fdegree and s.fexamno = d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp where fqpcode = '{$qpcode}'"; $resyerexm = $aobj_context->pobj_db->GetRow($qur); $fyearmode = $resyerexm['fyear']; $fexammode = $resyerexm['fexamtype']; $yearMode = "select concat(fyear,'-',fexamtype) as yearMode from qpseterdet1 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 qpseterdet1 set fmodqpupd='{$key}', fmodqpdate=now() where fqpcode = '{$qpcode}' and fset='{$set}' and fteachcode = '{$teachcode}' and fqpcodeno = '{$fqpcodeno}' and fyear = '{$fyearmode}' and fexamtype = '{$fexammode}'"; $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 upldAnsMODFile($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"]; $fqpcodeno = $aobj_context->mobj_data["fqpcodeno"]; $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_Ans_".$randomString.".".$ext; if($filename!=="" && $filename!==NULL){ $qur = "select distinct dg.fyear,dg.fexamtype from subject s inner join degree d on s.fdegree= d.fdegree and s.fexamno = d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp where fqpcode = '{$qpcode}'"; $resyerexm = $aobj_context->pobj_db->GetRow($qur); $fyearmode = $resyerexm['fyear']; $fexammode = $resyerexm['fexamtype']; $yearMode = "select concat(fyear,'-',fexamtype) as yearMode from qpseterdet1 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 qpseterdet1 set fmodanskey='{$key}', fmodansdate=now() where fqpcode = '{$qpcode}' and fset='{$set}' and fteachcode = '{$teachcode}' and fqpcodeno = '{$fqpcodeno}' and fyear = '{$fyearmode}' and fexamtype = '{$fexammode}'"; $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 upldMODFormFile($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"]; $fqpcodeno = $aobj_context->mobj_data["fqpcodeno"]; $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_Form_".$randomString.".".$ext; if($filename!=="" && $filename!==NULL){ $qur = "select distinct dg.fyear,dg.fexamtype from subject s inner join degree d on s.fdegree= d.fdegree and s.fexamno = d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp where fqpcode = '{$qpcode}'"; $resyerexm = $aobj_context->pobj_db->GetRow($qur); $fyearmode = $resyerexm['fyear']; $fexammode = $resyerexm['fexamtype']; $yearMode = "select concat(fyear,'-',fexamtype) as yearMode from qpseterdet1 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 qpseterdet1 set fmodform='{$key}', fmodformdate=now() where fqpcode = '{$qpcode}' and fset='{$set}' and fteachcode = '{$teachcode}' and fqpcodeno = '{$fqpcodeno}' and fyear = '{$fyearmode}' and fexamtype = '{$fexammode}'"; $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 getFinQPData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $exam = $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"]; $status = $aobj_context->mobj_data["status"]; $examval = explode('*',$exam); $deggrp = $examval[0]; $yearmode = explode('-',$examval[1]); $year = $yearmode[0]; $mode = $yearmode[1]; if($board !== 'All'){ $cond = "and s.fboard = '{$board}'"; }else{ $cond = ""; } if($qpcode !== 'All'){ $cond1 = "and q.fqpcode = '{$qpcode}'"; }else{ $cond1 = ""; } if($degree !== 'All'){ $cond2 = "and d.fdegree = '{$degree}'"; }else{ $cond2 = ""; } if($sem !== 'All'){ $cond3 = "and s.fexamno = '{$sem}'"; }else{ $cond3 = ""; } if($status == "Not Uploaded"){ $cond4 = "and ifnull(q.ffinalqppath,'') = ''"; }else if($status == "Uploaded"){ $cond4 = "and ifnull(q.ffinalqppath,'') <> ''"; }else{ $cond4 = ""; } $query = "select q.fqpcode, concat(s.fsubname, ' - ', s.fsubshort) as fsubname, ifnull(q.ffinalqppath,'') as ffinalqppath, ifnull(q.ffinalanspath,'') as ffinalanspath from qpseterdet1 q inner join subject s on s.fqpcode = q.fqpcode inner join degree d on s.fdegree = d.fdegree and s.fexamno= d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp and q.fyear = dg.fyear and q.fexamtype = dg.fexamtype where dg.fdeggrp = '{$deggrp}' and dg.fyear ='{$year}' and dg.fexamtype= '{$mode}' $cond2 $cond3 $cond1 $cond $cond4 group by q.fqpcode"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function uploadFinalQPFile($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $userid = $aobj_context->mobj_data["userid"]; $exam = $aobj_context->mobj_data["exam"]; $data = json_decode($aobj_context->mobj_data["data"], true); $qpcode = $data['fqpcode']; $finQPFile = $_FILES['finQPFile']; $finalQPFile = $finQPFile['name']; $finalQPData = $finQPFile['tmp_name']; $qpExt = pathinfo($finalQPFile, PATHINFO_EXTENSION); $date = date('Y-m-d H:i:s'); $finAnsFile = $_FILES['finAnsFile']; $finalAnsFile = $finAnsFile['name']; $finalAnsData = $finAnsFile['tmp_name']; $ansExt = pathinfo($finalAnsFile, PATHINFO_EXTENSION); $qur = "select distinct dg.fyear,dg.fexamtype from subject s inner join degree d on s.fdegree= d.fdegree and s.fexamno = d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp where fqpcode = '{$qpcode}'"; $resyerexm = $aobj_context->pobj_db->GetRow($qur); $fyearmode = $resyerexm['fyear']; $fexammode = $resyerexm['fexamtype']; $yearMode = "select concat(fyear,'-',fexamtype) as yearMode from qpseterdet1 where fqpcode = '{$qpcode}'"; $resultyearMode = $aobj_context->pobj_db->GetRow($yearMode); $yearmode = $resultyearMode['yearMode']; if($finQPFile!=="" && $finQPFile!==NULL){ $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length = 30; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $file_name = $qpcode."_Final_QP_".$randomString.".".$qpExt; $server_path = move_uploaded_file($finalQPData, "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; $s3->putObject(['Bucket' => "moderator-upd", 'Key' => $key, 'SourceFile' => $file_path]); $query = "update qpseterdet1 set ffinalqppath='{$key}', ffinalqpdate=now(), ffinalqpuser = '{$userid}' where fqpcode = '{$qpcode}' and fyear = '{$fyearmode}' and fexamtype = '{$fexammode}'"; $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);} } } if($finAnsFile!=="" && $finAnsFile!==NULL){ $characters1 = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length1 = 30; $randomString1 = ''; for ($i = 0; $i < $length1; $i++) { $randomString1 .= $characters1[rand(0, strlen($characters1) - 1)]; } $file_name = $qpcode."_Final_Ans_".$randomString1.".".$ansExt; $server_path = move_uploaded_file($finalAnsData, "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; $s3->putObject(['Bucket' => "moderator-upd", 'Key' => $key, 'SourceFile' => $file_path]); $query1 = "update qpseterdet1 set ffinalanspath='{$key}', ffinalansdate=now(), ffinalansuser = '{$userid}' where fqpcode = '{$qpcode}' and fyear = '{$fyearmode}' and fexamtype = '{$fexammode}'"; $result1 = $aobj_context->pobj_db->Execute($query1); $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($result1) {unlink($file_path);} } } if($result || $result1){ $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; } } function getFinalQPAns($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $exam = $aobj_context->mobj_data["exam"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $board = $aobj_context->mobj_data["board"]; $degree = $aobj_context->mobj_data["degree"]; $sem = $aobj_context->mobj_data["sem"]; $examval = explode('*',$exam); $deggrp = $examval[0]; $yearmode = explode('-',$examval[1]); $year = $yearmode[0]; $mode = $yearmode[1]; if($board !== 'All'){ $cond = "and s.fboard = '{$board}'"; }else{ $cond = ""; } if($qpcode !== 'All'){ $cond1 = "and q.fqpcode = '{$qpcode}'"; }else{ $cond1 = ""; } if($degree !== 'All'){ $cond2 = "and d.fdegree = '{$degree}'"; }else{ $cond2 = ""; } if($sem !== 'All'){ $cond3 = "and s.fexamno = '{$sem}'"; }else{ $cond3 = ""; } $query = "select q.fqpcode, concat(s.fsubname, ' - ', s.fsubshort) as fsubname,fqpcodeno, d.fdegree,ifnull(q.fmodqpupd,'') as fmodqpupd, ifnull(q.fmodanskey,'') as fmodanskey from qpseterdet1 q inner join subject s on s.fqpcode = q.fqpcode inner join degree d on s.fdegree = d.fdegree and s.fexamno= d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp and q.fyear = dg.fyear and q.fexamtype = dg.fexamtype where ifnull(ffinalpaper,'') = 'T' and dg.fdeggrp = '{$deggrp}' $cond $cond1 $cond2 $cond3"; // var_dump($query);die(); $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); return; }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } function getSysPatrDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $exam = $aobj_context->mobj_data["exam"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $board = $aobj_context->mobj_data["board"]; $degree = $aobj_context->mobj_data["degree"]; $sem = $aobj_context->mobj_data["sem"]; $status = $aobj_context->mobj_data["status"]; $examval = explode('*',$exam); $deggrp = $examval[0]; $yearmode = explode('-',$examval[1]); $year = $yearmode[0]; $mode = $yearmode[1]; if($board !== 'All'){ $cond = "and s.fboard = '{$board}'"; }else{ $cond = ""; } if($qpcode !== 'All'){ $cond1 = "and q.fqpcode = '{$qpcode}'"; }else{ $cond1 = ""; } if($degree !== 'All'){ $cond2 = "and d.fdegree = '{$degree}'"; }else{ $cond2 = ""; } if($sem !== 'All'){ $cond3 = "and s.fexamno = '{$sem}'"; }else{ $cond3 = ""; } if($status == 'Uploaded'){ $cond4 = "and ifnull(q.FSQPPATREN,'') <> '' and ifnull(q.FSQPSYLLABUS,'') <> ''"; }else if($status == "Not Uploaded"){ $cond4 = "and ifnull(q.FSQPPATREN,'') = '' and ifnull(q.FSQPSYLLABUS,'') = ''"; }else{ $cond4 = ""; } $query = "select q.fqpcode, concat(s.fsubname, ' - ', s.fsubshort) as fsubname, q.fset,q.fqpcodeno,ifnull(q.FSQPPATREN,'') as FSQPPATREN, ifnull(q.FSQPSYLLABUS,'') as FSQPSYLLABUS from qpseterdet1 q inner join subject s on s.fqpcode = q.fqpcode inner join degree d on s.fdegree = d.fdegree and s.fexamno= d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp and q.fyear = dg.fyear and q.fexamtype = dg.fexamtype where dg.fdeggrp = '{$deggrp}' and dg.fyear ='{$year}' and dg.fexamtype= '{$mode}' $cond2 $cond3 $cond1 $cond4"; // var_dump($query);die(); $result = $aobj_context->pobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); return; }else{ $arr['msg'] = 'No data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } function upldSyllPatrn($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $userid = $aobj_context->mobj_data["userid"]; $exam = $aobj_context->mobj_data["exam"]; $data = json_decode($aobj_context->mobj_data["data"], true); $qpcode = $data['fqpcode']; $fset = $data['fset']; $fqpcodeno = $data['fqpcodeno']; $qpSyllanusFile = $_FILES['qpSyllanusFile']; $qpSyllaFile = $qpSyllanusFile['name']; $qpSyllaData = $qpSyllanusFile['tmp_name']; $qpSyllExt = pathinfo($qpSyllaFile, PATHINFO_EXTENSION); $date = date('Y-m-d H:i:s'); $qpPatternFile = $_FILES['qpPatternFile']; $qpPattFile = $qpPatternFile['name']; $qpPattData = $qpPatternFile['tmp_name']; $qppatExt = pathinfo($qpPattFile, PATHINFO_EXTENSION); $qur = "select distinct dg.fyear,dg.fexamtype from subject s inner join degree d on s.fdegree= d.fdegree and s.fexamno = d.fexamno inner join deggrp dg on d.fdeggrp = dg.fdeggrp where fqpcode = '{$qpcode}'"; $resyerexm = $aobj_context->pobj_db->GetRow($qur); $fyearmode = $resyerexm['fyear']; $fexammode = $resyerexm['fexamtype']; $yearMode = "select concat(fyear,'-',fexamtype) as yearMode from qpseterdet1 where fqpcode = '{$qpcode}'"; $resultyearMode = $aobj_context->pobj_db->GetRow($yearMode); $yearmode = $resultyearMode['yearMode']; if($qpSyllanusFile!==" " && $qpSyllanusFile!==null){ $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length = 30; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $file_name = $qpcode."_QP_SYLLABUS_".$randomString.".".$qpSyllExt; $server_path = move_uploaded_file($qpSyllaData, "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."/"."syllabus"."/".$file_name; $s3->putObject(['Bucket' => "qp-scheme", 'Key' => $key, 'SourceFile' => $file_path]); $query = "update qpseterdet1 set FSQPSYLLABUS='{$key}' where fqpcode = '{$qpcode}' and fset = '{$fset}' and fqpcodeno = '{$fqpcodeno}' and fyear = '{$fyearmode}' and fexamtype = '{$fexammode}'"; $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);} } } if($qpPatternFile!==" " && $qpPatternFile!==null){ $characters1 = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length1 = 30; $randomString1 = ''; for ($i = 0; $i < $length1; $i++) { $randomString1 .= $characters1[rand(0, strlen($characters1) - 1)]; } $file_name = $qpcode."_QP_PATTERN_".$randomString1.".".$qppatExt; $server_path = move_uploaded_file($qpPattData, "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."/"."pattern"."/".$file_name; $s3->putObject(['Bucket' => "qp-scheme", 'Key' => $key, 'SourceFile' => $file_path]); $query1 = "update qpseterdet1 set FSQPPATREN='{$key}' where fqpcode = '{$qpcode}' and fset = '{$fset}' and fqpcodeno = '{$fqpcodeno}' and fyear = '{$fyearmode}' and fexamtype = '{$fexammode}'"; $result1 = $aobj_context->pobj_db->Execute($query1); $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($result1) {unlink($file_path);} } } if($result || $result1){ $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; } } function saveQPSetData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $exam = $aobj_context->mobj_data["exam"]; $board = $aobj_context->mobj_data["board"]; $progr = $aobj_context->mobj_data["progr"]; $data = json_decode($aobj_context->mobj_data["data"], true); // var_dump($data);die(); $examval = explode('*',$exam); $deggrp = $examval[0]; $yearmode = explode('-',$examval[1]); $year = $yearmode[0]; $mode = $yearmode[1]; if($board !== 'All'){ $cond = "and s.fboard = '{$board}'"; }else{ $cond = ""; } if($qpcode !== 'All'){ $cond1 = "and q.fqpcode = '{$qpcode}'"; }else{ $cond1 = ""; } $alphabet = ["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"]; foreach($data as $val){ for($j=0; $j< intval($val['fnoset']); $j++){ for($i=0; $i < intval($val['fsec']); $i++){ $count = $j+1; $query = "insert into qpseterdet1 (fyear, fexamtype, fqpcode, fset, fqpcodeno) values('{$year}', '{$mode}', '{$val['fqpcode']}', '{$count}', '{$alphabet[$i]}')"; $result = $aobj_context->pobj_db->Execute($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 saveFinalQPData($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $userid = $aobj_context->mobj_data["userid"]; $exam = $aobj_context->mobj_data["exam"]; $data = json_decode($aobj_context->mobj_data["data"], true); $qpcode = $data['fqpcode']; $fremarks = $data['fremarks']; $fteachcode = $data['fteachcode']; $ffinalqpstatus = $data['ffinalqpstatus']; $set = $data['fset']; // var_dump($data);die(); $examexplode= explode('*',$exam); $exmexplde= explode('-',$examexplode[1]); $curyear = $exmexplde[0]; $curexam = $exmexplde[1]; $curyearexam = $examexplode[1]; $fyearmode = $data['fyear']; $fexammode = $data['fexamtype']; $yearmode = $data['fyear']."-".$data['fexamtype'] ; $finQPFile = $_FILES['finQPFile']; $finalQPFile = $finQPFile['name']; $finalQPData = $finQPFile['tmp_name']; $qpExt = pathinfo($finalQPFile, PATHINFO_EXTENSION); $finAnsFile = $_FILES['finAnsFile']; $finalAnsFile = $finAnsFile['name']; $finalAnsData = $finAnsFile['tmp_name']; $ansExt = pathinfo($finalAnsFile, PATHINFO_EXTENSION); $date = date('Y-m-d H:i:s'); if($finQPFile!=="" && $finQPFile!==NULL){ $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length = 30; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $file_name = $qpcode."_Final_QP_".$randomString.".".$qpExt; $server_path = move_uploaded_file($finalQPData, "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."/".$curyearexam."/".$qpcode."/".$file_name; $s3->putObject(['Bucket' => "moderator-upd", 'Key' => $key, 'SourceFile' => $file_path]); } $qur = "select * from tdvs_qpfile where fqpcode = '{$qpcode}' and fyear = '{$curyear}' and fexamtype = '{$curexam}'"; $res = $aobj_context->pobj_db->GetRow($qur); if(count($res) !== 0){ $insrt_tdvs = "update tdvs_qpfile set FQPFILEPATH='{$key}', FQPDATE=now() where fqpcode = '{$qpcode}' and fyear = '{$curyear}' and fexamtype = '{$curexam}'"; }else{ $insrt_tdvs = "INSERT INTO tdvs_qpfile (FQPCODE, FYEAR, FEXAMTYPE,FQPFILEPATH,FQPDATE) VALUES('{$qpcode}','{$curyear}','{$curexam}','{$key}',now())"; } $result1 = $aobj_context->pobj_db->Execute($insrt_tdvs); $consd = ",ffinalqppath='{$key}', ffinalqpdate=now(), ffinalqpuser = '{$userid}'"; } if($finAnsFile!=="" && $finAnsFile!==NULL){ $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length = 30; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $file_name = $qpcode."_Final_ANS_".$randomString.".".$ansExt; $server_path = move_uploaded_file($finalAnsData, "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' )); $Anskey = $univcode."/".$curyearexam."/".$qpcode."/".$file_name; $s3->putObject(['Bucket' => "moderator-upd", 'Key' => $Anskey, 'SourceFile' => $file_path]); } $qur = "select * from tdvs_qpfile where fqpcode = '{$qpcode}' and fyear = '{$curyear}' and fexamtype = '{$curexam}'"; $res = $aobj_context->pobj_db->GetRow($qur); if(count($res) !== 0){ $insrt_tdvs = "update tdvs_qpfile set FSCHEMA='{$Anskey}', FQPDATE=now() where fqpcode = '{$qpcode}' and fyear = '{$curyear}' and fexamtype = '{$curexam}'"; }else{ $insrt_tdvs = "INSERT INTO tdvs_qpfile (FQPCODE, FYEAR, FEXAMTYPE,FSCHEMA,FQPDATE) VALUES('{$qpcode}','{$curyear}','{$curexam}','{$Anskey}',now())"; } $result1 = $aobj_context->pobj_db->Execute($insrt_tdvs); $consd1 = ",ffinalanspath='{$Anskey}', ffinalansdate=now(),ffinalansuser = '{$userid}'"; } // var_dump($Anskey,$key); $query = "update qpseterdet set fremarks = '{$fremarks}', ffinalqpstatus = '{$ffinalqpstatus}', fcuryear = '{$curyear}',fcurexamtype = '{$curexam}' $consd $consd1 where fqpcode = '{$qpcode}' and fyear = '{$fyearmode}' and fexamtype = '{$fexammode}' and ffinalpaper = 'T' and fteachcode = '{$fteachcode}' and fset='{$set}'"; // var_dump($query); $result = $aobj_context->pobj_db->Execute($query); if($result) {unlink($file_path);} if($result || $result1){ $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; } } ?>
Close
