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.222.91.173
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
38.96
KB
-rw-r--r--
adm_master.php
17.13
KB
-rw-r--r--
adm_register.php
84.85
KB
-rw-r--r--
adm_session_start.php
899
B
-rw-r--r--
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
31.4
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
8.07
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.46
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.63
KB
-rw-r--r--
stud_payments.php
3.42
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.php
<?php // require_once("/var/www/html/aws/aws-autoloader.php"); // use Aws\S3\S3Client; include("/var/www/config.php"); function examDate($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $type = $aobj_context->mobj_data["type"]; if($type === "old"){ $query = "select distinct concat(dg.fdeggrp, '*', d.fyear, '-',d.fexamtype) as fexamyear, concat(p.fdescpn, '-' , d.fexamdate) as fdesexam from qpseterdet q inner join degexam d on q.fyear = d.fyear and q.fexamtype = d.fexamtype inner join degree dg on d.fdegree = dg.fdegree and dg.fexamno = d.fexamno inner join deggrp p on p.fdeggrp = dg.fdeggrp where ifnull(fqpfilepath,'') <> '' group by dg.fdeggrp,q.fyear,q.fexamtype"; }else{ $query = "select concat(fdeggrp,'*',fyear, '-', fexamtype) as fexamyear, concat(fdescpn, '-' , fexamdate)as fdesexam from deggrp where ifnull(fdeleted, '') <> 'T'"; } $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 getBoardDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $exam = $aobj_context->mobj_data["exam"]; $examarray = explode("*",$exam); $deggrp = $examarray[0]; $query = "select distinct fboardcode, fboardname from masboard m inner join subject s on m.fboardcode = s.fboard inner join degree d on s.fdegree = d.fdegree where ifnull(m.fdeleted,'') <>'T' and d.fdeggrp = '{$deggrp}'"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No Board Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getBoardSubj($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $board = $aobj_context->mobj_data["board"]; $exam = $aobj_context->mobj_data["exam"]; $examarray = explode("*",$exam); $deggrp = $examarray[0]; if($board === "All"){ $boardCond = ""; }else{ $boardCond = "and s.fboard = '{$board}'"; } $query = "select s.fqpcode, concat(s.fsubname,' ( ',s.fsubshort,' )', ' - ', s.fssubname) as fsubname from subject s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno where ifnull(s.fqpcode,'') <> '' $boardCond and d.fdeggrp = '{$deggrp}'"; $result = $aobj_context->pobj_db->GetAll($query); if(count($result) > 0) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $arr['msg'] = 'No QP Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getTeachDet($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"]; $subj = $aobj_context->mobj_data["subj"]; $examarray = explode("*",$exam); $deggrp = $examarray[0]; $exam = explode("-", $examarray[1]); $fyear = $exam[0]; $fexamtype = $exam[1]; if($board === "All"){ $boardCond = ""; }else{ $boardCond = "and qp.fboard = '{$board}'"; } $query = "select ifnull(m.fteachcode,'') as fteachcode,ifnull(m.fteachname,'') as fteachname, ifnull(m.fmobile,'') as fmobile,ifnull(m.femail,'') as femail, if(ifnull(qp.fteachcode,'') = '','F','T') as status from masteach m left join qpseter qp on m.fteachcode = qp.fteachcode and qp.fqpcode='{$subj}' and qp.fyear = '{$fyear}' and qp.fexamtype = '{$fexamtype}' and qp.fqpcode in(select distinct s.fqpcode from subject s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno where d.fdeggrp = '{$deggrp}') $boardCond group by m.fteachcode"; $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 saveQPSeter($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $mob = $aobj_context->mobj_data["mob"]; $req = $aobj_context->req_body; $data = $req['data']; $table = $data['table']; $board = $data['board']; $subj = $data['subj']; $exam = $data['exam']; $spl = explode('*',$exam); $split = explode('-',$spl[1]); $fyear = $split[0]; $fexamtype = $split[1]; $date = date('Y-m-d H:i:s'); $selteach = array(); $noteach = array(); foreach ($table as $k => $v) { if($v['status'] == 'T' ) array_push($selteach, $v['fteachcode']); else array_push($noteach, $v['fteachcode']); } foreach($selteach as $t=> $i ){ $query = "insert into qpseter (fyear,fexamtype,fboard,fqpcode,fteachcode,fcreated,fcreateduser) value('{$fyear}','{$fexamtype}','{$board}','{$subj}','{$i}',now(),'{$mob}')"; $result = $aobj_context->pobj_db->Execute($query); } foreach($noteach as $t=> $i ){ $query = "DELETE FROM qpseter WHERE fteachcode='{$i}' and fqpcode = '{$subj}' and fboard = '{$board}' and fyear = '{$fyear}' and fexamtype = '{$fexamtype}' and ifnull(fstatus,'') <> 'T'"; $result = $aobj_context->pobj_db->Execute($query); } if (!$result) { $arr['msg'] = 'Updation Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } if($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"Udated Success"); } else { $arr['msg'] = 'No Data found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function getSelTeachDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $board = $aobj_context->mobj_data["board"]; $subj = $aobj_context->mobj_data["subj"]; $exam = $aobj_context->mobj_data["exam"]; if($board === "All"){ $boardCond = ""; $boardcon= ""; }else{ $boardCond = "and qp.fboard = '{$board}'"; $boardcon = "and s.fboard = qp.fboard"; } $examarray = explode("*",$exam); $deggrp = $examarray[0]; $exam = explode("-", $examarray[1]); $fyear = $exam[0]; $fexamtype = $exam[1]; $query = "select m.fteachcode,m.fteachname,m.fmobile,m.femail,ifnull(fnoqp,'1') as fnoqp, if(ifnull(flastdate,'') = '','',date_format(flastdate,'%d/%m/%Y')) as flastdate, ifnull(qp.fappointed,'') as status,ifnull(qp.femailstatus,'') as femailstatus from masteach m inner join qpseter qp on m.fteachcode=qp.fteachcode inner join subject s on s.fqpcode = qp.fqpcode and s.fqpcode='{$subj}' $boardcon where qp.fqpcode='{$subj}' $boardCond and qp.fqpcode in(select distinct s.fqpcode from subject s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno where d.fdeggrp = '{$deggrp}') and qp.fyear = '{$fyear}' and qp.fexamtype = '{$fexamtype}' group by m.fteachcode"; $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 saveSelQPSeter($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'); $cond = ''; if($univcode == '030'){ $cond = ',fqpsettermail'; } $unishort = "select funivname, ffolder, pdf_logo_path $cond from control"; $resunishort = $aobj_context->pobj_db->GetRow($unishort); $univname = $resunishort['funivname']; $univshort = strtoupper($resunishort['ffolder']); $logopath = $resunishort['pdf_logo_path']; $fqpsettermail = $resunishort['fqpsettermail']; $query = "select ifnull(FQPPATREN,'') as FQPPATREN from subject where fqpcode = '{$subj}'"; $res = $aobj_context->pobj_db->GetRow($query); if($res['FQPPATREN'] == '') { $arr['msg'] = 'QP Pattren and Syllabus not uploaded for QP Code '.$subj; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } $query1 = "select distinct s.fdegree,s.fqpcode,s.fsubname,dg.fexamdate,d.fexamname,d.fdescpn,s.fsubshort from subject s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno inner join qpset_deggrp dg on dg.fdeggrp = d.fdeggrp where fqpcode = '{$subj}'"; $res1 = $aobj_context->pobj_db->GetRow($query1); $fdegree = $res1['fdegree']; $fqpcode = $res1['fqpcode']; $fsubname = $res1['fsubname']; $fexamdate = $res1['fexamdate']; $fexamnmae = $res1['fexamname']; $fdescpn = $res1['fdescpn']; $fsubshort = $res1['fsubshort']; $truearray = array(); $falsearray = array(); $qparray = array(); foreach ($table as $k => $v) { $lastdate = $v['flastdate']; $teachcode = $v['status']; $fnoqp = $v['fnoqp']; $fteachcode = $v['fteachcode']; $fteachname = $v['fteachname']; $spldate = explode('/',$lastdate); $flastdate = $spldate[2]."-".$spldate[1]."-".$spldate[0]; if($univcode == '030'){ $teachDet = "select concat(ifnull(FTITLE,''), ' ',ifnull(fteachname, ''))as fteachname, ifnull(fcollname, '')as fcollname from masteach where fteachcode = '{$fteachcode}'"; }else{ $teachDet = "select concat(ifnull(m.FTITLE,''), ' ',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 = '{$fteachcode}'"; } $teachDet1 = $aobj_context->pobj_db->GetRow($teachDet); $teachname = $teachDet1['fteachname']; $colladd = $teachDet1['fcollname']; $degn = $teachDet1['fdegndesc']; if($v['status'] == 'F' ) { $query = "update qpseter set fappointed = 'F', fappointdate = now(), fappointuser = '{$mob}', femailstatus = 'F' where fteachcode = '{$fteachcode}' and fqpcode = '{$subj}' and fyear = '{$fyear}' and fexamtype = '{$fexamtype}'"; $result = $aobj_context->pobj_db->Execute($query); $remarks = "Teacher ". $fteachcode. " removed for the Qp Code ".$fqpcode." Removed User: ".$mob; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "QP Setter", $mobile, $mobile); }else if($v['status' ] == 'T') { $query = "update qpseter set fappointed = 'T', fappointdate = '{$date}', femailstatus = '{$v['emailstatus']}', fappointuser = '{$mob}',fnoqp = '{$fnoqp}' ,ffrommdate= now(),flastdate = '{$flastdate}' where fteachcode = '{$fteachcode}' and fqpcode = '{$subj}' 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: ".$fnoqp." Last Date: ".$flastdate; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "QP Setter", $mobile, $mobile); if($v['emailstatus'] == 'T'){ $fteach = $v['fteachcode']; }else{ $fteach = ''; } if($fteach === ''){ }else{ $email = "select femail,fmobile from masteach where fteachcode = '{$fteach}'"; } $emailres = $aobj_context->pobj_db->GetRow($email); $emailid = $emailres['femail']; $mobile = $emailres['fmobile']; for($i = 1;$i<=$fnoqp;$i++) { $query = "INSERT ignore INTO qpseterdet (fyear, fexamtype, fqpcode, fteachcode, fset) values('{$fyear}','{$fexamtype}','{$subj}','{$fteachcode}','{$i}')"; $result = $aobj_context->pobj_db->Execute($query); $remarks = "Teacher ". $fteachcode. " set for the Qp Code ".$fqpcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "QP Setter", $mobile, $mobile); } if($univcode == "051"){ $logo_path = "img/dyp_elogo.jpeg"; }else if($univcode == "030"){ $logo_path = $logopath; } if($univcode == '030'){ $logo = "https://universitysolutions.in/".$resunishort['ffolder']. '/'.$logopath; }else{ $logo = "https://college.universitysolutions.in/".$resunishort['ffolder']. '/'.$logo_path; } if($univcode=="030" || $univcode=="098"){ $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'> <u>STRICTLY CONFIDENTIAL </u></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> From</p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> <b>Dr. Beena G</b></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> Controller of Examinations</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><b>"."$teachname"."</b><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'> Dear Sir/Madam,</p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> <b>Subject: Appointment as Question Paper setter for "." $univname"." of "."$fexamdate"." Semester End Examinations.</b></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> On the directions of the Vice-Chancellor, I am pleased to inform you of your appointment as the Question paper setter for the following course. All question papers are expected to be received <b> on or before "."$lastdate"."</p> </b>"; $message .= "<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> Please note that the QP portal will get auto disabled after the lastdate.</p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> The details are as follows:</p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> <table style='width: 100%;border: 1px solid'> <tr style='border: 1px solid'> <th style='width: 17%;text-align:left;border: 1px solid'>Program</th> <th style='width: 33%;text-align:center;border: 1px solid'>"."$fdegree - $fdescpn"."</th> <th style='width: 17%;text-align:left;border: 1px solid'>Semester</th> <th style='width: 33%;text-align:center;border: 1px solid'>"."$fexamnmae"."</th> </tr> <tr> <th style='width: 17%;text-align:left;border: 1px solid'>Course code</th> <th style='width: 33%;text-align:center;border: 1px solid'>"."$fsubshort"."</th> <th style='width: 17%;text-align:left;border: 1px solid'>Course Title</th> <th style='width: 33%;text-align:center;border: 1px solid'>"."$fsubname"."</th> </tr> <tr> <th style='width: 17%;text-align:left;border: 1px solid'>No. of sets</th> <th style='width: 33%;text-align:center;border: 1px solid'>"."$fnoqp"."</th> <th style='width: 17%;text-align:left;border: 1px solid'>To be submitted on or before</th> <th style='width: 33%;text-align:center;border: 1px solid'>"."$lastdate"."</th> </tr> </table> </p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> The question papers must be prepared as per the template provided.</p>"; $message.="$fqpsettermail"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> <b>The following details are attached:</b> <ul> <li>Prescribed syllabus</li> <li>Question paper pattern</li> </ul> </p>"; $message.="<u>Remuneration details:</u>"."<br>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> <table style='width: 70%'> <tr style='text-align:center;border: 1px solid'> <th style='width: 20%;border: 1px solid'>Sl No</th> <th style='width: 60%;border: 1px solid'>Particulars</th> <th style='width: 20%;border: 1px solid'>Remuneration (Rs)</th> </tr> <tr style='text-align:center'> <th style='width: 20%;border: 1px solid'>1</th> <th style='width: 60%;border: 1px solid'>Question Paper setting</th> <th style='width: 20%;border: 1px solid'>700</th> </tr> <tr style='text-align:center'> <th style='width: 20%;border: 1px solid'>2</th> <th style='width: 60%;border: 1px solid'>Detailed solution, scheme of instruction</th> <th style='width: 20%;border: 1px solid'>500</th> </tr> </table> </p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> <strong>The question paper needs to be prepared in the template provided and Submitted back as per the timeline </strong><br></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> <b>Note :</b></p>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif;color:red;'> <ol> <b> <li>Kindly use font Calibri, size 12 as a standard font for all QP’s.</li> <li>The QP submitted after the mentioned timeline will not be accepted.</li> </b> </ol> <br>"; $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> <b>Registration Steps are : </b> <ol> <li style='color:red;'>State: Karnataka</li> <li style='color:red;'>University : "."$univname"."</li> <li style='color:red;'>Select user type as Teacher</li> <li style='color:red;'>Enter Teacher code which is available in your mail</li> <li style='color:red;'>Click Validate</li> <li style='color:red;'>Fill details as: Enter your Email id and Password is your mobile number. Reenter the same password.</li> <li style='color:red;'>Click Send OTP. You will receive the OTP on your mobile and email also.</li> <li style='color:red;'>Enter OTP.</li> <li style='color:red;'>After this for Login: your mobile number will be the user id and password.</li> <li style='color:red;'>After Login in Question Paper setting Accept the Question Paper Request.</li> <li style='color:red;'>You can see the Question Paper Pattern and Syllabus.</li> <li style='color:red;'>Prepare the two separate word documents</li> <ul> <li style='color:red;'> Question Paper as per given pattern.</li> <li style='color:red;'> Brief Answer Keys.</li> </ul> <li style='color:red;'>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.</li> <li style='color:red;'>Update the Bank details.</li> </ol> </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'> In case if you have any technical issues, Kindly call 080-46966966,Ext.244 or revert to mail ru_qp.coe@reva.edu.in <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</p><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']; if($univcode == '030'){ $signpath = "https://universitysolutions.in/".$resunishort['ffolder']."/img/".$sign; }else{ $signpath = "https://college.universitysolutions.in/".$resunishort['ffolder']."/img/".$sign; } if($sign!==NULL){ $message .= "<img src='{$signpath}' width='100' height='50'/>"; $message .= "<br/>"; } $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'> Controller of Examinations<br> "." $univname"."<br> </p>"; $message.="</body>"; $message.="</html>"; }else{ $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'> <u>CONFIDENTIAL</u></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 in ".$fexamnmae." ".$fdescpn."</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'>Number of Question papers with Answer key</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'>"."$fnoqp"."</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("$univname".": Appointment as Question Paper Setter for the University ".$fexamdate." Semester End Examination"); $from = ""; $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 (!$resp) { $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 getQPDetails($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $teachcode = $aobj_context->mobj_data["userid"]; $query = "select qp.fqpcode, concat(s.fsubname, ' - ', s.fsubshort)as fsubname, s.fvalmax,qp.fset,concat(qp.fyear,'-', qp.fexamtype)as fexam, s.FQPPATREN,s.FQPSYLLABUS,s.fschpattern, ifnull(qp.fstatus, '')as fstatus from qpseterdet qp inner join subject s on qp.fqpcode = s.fqpcode inner join degree dg on s.fdegree = dg.fdegree and dg.fexamno = s.fexamno inner join qpset_deggrp du on dg.fdeggrp = du.fdeggrp and qp.fyear = du.fyear and du.fexamtype = qp.fexamtype where fteachcode = '{$teachcode}' group by qp.fyear, qp.fexamtype, fqpcode,fset ,fteachcode"; $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 uploadQPDet($aobj_context){ // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $univcode = $aobj_context->mobj_data["univcode"]; // $userid = $aobj_context->mobj_data["userid"]; // $qpcode = $aobj_context->mobj_data["qpcode"]; // $sets = $aobj_context->mobj_data["set"]; // $file = basename($_FILES['File']['name']); // $temp = file_get_contents($_FILES['File']['tmp_name']); // $host = 'logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com'; // $user = 'admin'; // $password = 'T0g3th3r@all'; // if($univcode == '041'){ // $db = 'logisys3_bcu'; // }else if($univcode == '042'){ // $db = 'logisys3_bnu'; // }else if($univcode == '046'){ // $db = 'logisys3_gach'; // }else if($univcode == '048'){ // $db = 'logisys3_rur'; // }else if($univcode == '052'){ // $db = 'logisys3_jssstu'; // }else if($univcode == '051'){ // $db = 'logisys3_dypatil'; // }else if($univcode == '050'){ // $db = 'logisys3_srun'; // }else if($univcode == '049'){ // $db = 'logisys3_nmamit'; // }else if($univcode == '029'){ // $db = 'logisys3_nitte'; // }else if($univcode == '026'){ // $db = 'logisys3_vku'; // }else if($univcode == '003'){ // $db = 'logisys3_kus'; // }else if($univcode == '023'){ // $db = 'logisys3_dud'; // }else if($univcode == '001'){ // $db = 'logisys3_gug'; // }else if($univcode == '027'){ // $db = 'logisys3_rcu'; // }else if($univcode == '008'){ // $db = 'logisys3_kswu'; // }else if($univcode == '030'){ // $db = 'logisys3_reva'; // }else if($univcode == '033'){ // $db = 'logisys3_gcg'; // }else if($univcode == '035'){ // $db = 'logisys3_gcc'; // }else if($univcode == '037'){ // $db = 'logisys3_gsh'; // }else if($univcode == '039'){ // $db = 'logisys3_stph'; // }else if($univcode == '040'){ // $db = 'logisys3_aims'; // }else if($univcode == '098'){ // $db = 'logisys3_demo'; // } // $conn = mysqli_connect($host, $user, $password,$db); // if (!$conn) { // die("Connection failed: " . mysqli_connect_error()); // } // $escaped_content = mysqli_real_escape_string($conn, $temp); // $date = date('Y-m-d H:i:s'); // if($file){ // if($file != '' && $file!=NULL){ // $query = "update qpseterdet set ffilename='{$file}', fqpduser = '{$userid}', fqpdtme = '{$date}', // fqpfile = '{$escaped_content}', fuploadstatus = 'T' // where fteachcode = '{$userid}' // and fqpcode = '{$qpcode}' // and fset = '{$sets}'"; // $result = $aobj_context->pobj_db->Execute($query); // } // } // if(count($result) > 0) // { // $arr['msg'] = 'Success'; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); // } // else // { // $arr['msg'] = 'No States Found'; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); // } // } // function viewQPDet($aobj_context){ // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $univcode = $aobj_context->mobj_data["univcode"]; // $teachcode = $aobj_context->mobj_data["tech"]; // $qpcode = $aobj_context->mobj_data["qpcode"]; // $host = 'logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com'; // $user = 'admin'; // $password = 'T0g3th3r@all'; // if($univcode == '041'){ // $db = 'logisys3_bcu'; // }else if($univcode == '042'){ // $db = 'logisys3_bnu'; // }else if($univcode == '046'){ // $db = 'logisys3_gach'; // }else if($univcode == '048'){ // $db = 'logisys3_rur'; // }else if($univcode == '052'){ // $db = 'logisys3_jssstu'; // }else if($univcode == '051'){ // $db = 'logisys3_dypatil'; // }else if($univcode == '050'){ // $db = 'logisys3_srun'; // }else if($univcode == '049'){ // $db = 'logisys3_nmamit'; // }else if($univcode == '029'){ // $db = 'logisys3_nitte'; // }else if($univcode == '026'){ // $db = 'logisys3_vku'; // }else if($univcode == '003'){ // $db = 'logisys3_kus'; // }else if($univcode == '023'){ // $db = 'logisys3_dud'; // }else if($univcode == '001'){ // $db = 'logisys3_gug'; // }else if($univcode == '027'){ // $db = 'logisys3_rcu'; // }else if($univcode == '008'){ // $db = 'logisys3_kswu'; // }else if($univcode == '030'){ // $db = 'logisys3_reva'; // }else if($univcode == '033'){ // $db = 'logisys3_gcg'; // }else if($univcode == '035'){ // $db = 'logisys3_gcc'; // }else if($univcode == '037'){ // $db = 'logisys3_gsh'; // }else if($univcode == '039'){ // $db = 'logisys3_stph'; // }else if($univcode == '040'){ // $db = 'logisys3_aims'; // }else if($univcode == '098'){ // $db = 'logisys3_demo'; // } // $conn = mysqli_connect($host, $user, $password,$db); // if (!$conn) { // die("Connection failed: " . mysqli_connect_error()); // } // if($qpcode == "" || null){ // $con = ""; // }else{ // $con = "and fqpcode = '{$qpcode}'"; // } // $query = "select ffilename,fqpfile from qpseter where fteachcode = '{$teachcode}' $con"; // $result = $aobj_context->pobj_db->GetRow($query); // $pdf_content = $result['fqpfile']; // $stmt = mysqli_prepare($conn, $query); // mysqli_stmt_bind_param($stmt, "i", $teachcode); // mysqli_stmt_execute($stmt); // mysqli_stmt_bind_result($stmt, $pdf_content); // mysqli_stmt_fetch($stmt); // header("Content-Type: application/pdf"); // header("Content-Disposition: attachment; filename={$result['ffilename']}"); // if(count($result) > 0) // { // echo $pdf_content; // } // else // { // $arr['msg'] = 'No States Found'; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); // } // } function displayQPDetails($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $board = $aobj_context->mobj_data["board"]; $typ = $aobj_context->mobj_data["typ"]; if($board == 'All'){ $con1=""; }else{ $con1 = "and qp.fqpcode = '{$board}'"; } if($typ == 'All'){ $con2=""; }elseif ($typ == 'not'){ $con2="and qp.fapprovedstatus <> 'T'"; }else{ $con2="and qp.fapprovedstatus = 'T'"; } $query = "select qp.fqpcode, qp.fteachcode,s.fsubname,m.fteachname,qp.fqpfile,fapprovedstatus from qpseter qp inner join subject s on qp.fqpcode = s.fqpcode and qp.fboard = s.fboard inner join masteach m on m.fteachcode = qp.fteachcode inner join teachsub t on m.fteachcode = t.fteachcode where qp.fqpfile <>'' $con1 $con2 group by qp.fteachcode"; $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 approvedQPDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $userid = $aobj_context->mobj_data["userid"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $teach = $aobj_context->mobj_data["teach"]; $file = basename($_FILES['File']['name']); $temp = file_get_contents($_FILES['File']['tmp_name']); $host = 'logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com'; $user = 'admin'; $password = 'T0g3th3r@all'; if($univcode == '041'){ $db = 'logisys3_bcu'; }else if($univcode == '042'){ $db = 'logisys3_bnu'; }else if($univcode == '046'){ $db = 'logisys3_gach'; }else if($univcode == '048'){ $db = 'logisys3_rur'; }else if($univcode == '052'){ $db = 'logisys3_jssstu'; }else if($univcode == '051'){ $db = 'logisys3_dypatil'; }else if($univcode == '050'){ $db = 'logisys3_srun'; }else if($univcode == '049'){ $db = 'logisys3_nmamit'; }else if($univcode == '029'){ $db = 'logisys3_nitte'; }else if($univcode == '026'){ $db = 'logisys3_vku'; }else if($univcode == '003'){ $db = 'logisys3_kus'; }else if($univcode == '023'){ $db = 'logisys3_dud'; }else if($univcode == '001'){ $db = 'logisys3_gug'; }else if($univcode == '027'){ $db = 'logisys3_rcu'; }else if($univcode == '008'){ $db = 'logisys3_kswu'; }else if($univcode == '030'){ $db = 'logisys3_reva'; }else if($univcode == '033'){ $db = 'logisys3_gcg'; }else if($univcode == '035'){ $db = 'logisys3_gcc'; }else if($univcode == '037'){ $db = 'logisys3_gsh'; }else if($univcode == '039'){ $db = 'logisys3_stph'; }else if($univcode == '040'){ $db = 'logisys3_aims'; }else if($univcode == '098'){ $db = 'logisys3_demo'; } $conn = mysqli_connect($host, $user, $password,$db); if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $escaped_content = mysqli_real_escape_string($conn, $temp); $date = date('Y-m-d H:i:s'); if($file){ if($file != '' && $file!=NULL){ $query = "update qpseter set ffilename='{$file}', fapprovedqpd = '{$escaped_content}' where fteachcode = '{$teach}' and fqpcode = '{$qpcode}'"; $result = $aobj_context->pobj_db->Execute($query); } } if(count($result) > 0) { $arr['msg'] = 'Success'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function saveAppQPDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $userid = $aobj_context->mobj_data["userid"]; $file = basename($_FILES['File']['name']); $temp = file_get_contents($_FILES['File']['tmp_name']); $req = $aobj_context->req_body; $data = $req['data']; $table = $data['table'][0]; $fapprovedstatus = $table['fapprovedstatus']; $fqpcode = $table['fqpcode']; $teachcode = $table['fteachcode']; $date = date('Y-m-d H:i:s'); $query = "update qpseter set fapprovedstatus = '{$fapprovedstatus}', fapproveduser = '{$userid}', fapproveddate = '{$date}' where fteachcode = '{$teachcode}' and fqpcode = '{$fqpcode}'"; $result = $aobj_context->pobj_db->Execute($query); if(count($result) > 0) { $arr['msg'] = 'Success'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function disAppQPDetails($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $board = $aobj_context->mobj_data["board"]; $type = $aobj_context->mobj_data["typ"]; $uptyp = $aobj_context->mobj_data["uptyp"]; if($board == 'All'){ $con1=""; }else{ $con1 = "and qp.fqpcode = '{$board}'"; } if($uptyp== 'All'){ $con2 = ""; }elseif($uptyp == 'T'){ $con2 = "and ifnull(qp.fqpfile,'') <> ''"; }elseif($uptyp == 'F'){ $con2 = "and ifnull(qp.fqpfile,'') = ''"; } if($uptyp == 'F'){ $typ = ""; }else{ $typ = $type; } if($typ == 'T'){ $con3 = "and qp.fapprovedstatus = 'T'"; }else{ $con3 = ""; } $query = "select qp.fqpcode, qp.fteachcode,s.fsubname,m.fteachname, if(ifnull(qp.fqpfile,'') = '','Not Uploaded', 'Uploaded') as taechstatus, if(ifnull(qp.fapprovedstatus,'F') = 'T','Approved', 'Not Approved') as appstatus from qpseter qp inner join subject s on qp.fqpcode = s.fqpcode and qp.fboard = s.fboard inner join masteach m on m.fteachcode = qp.fteachcode inner join teachsub t on m.fteachcode = t.fteachcode where qp.fappointed ='T' $con1 $con2 $con3 group by qp.fteachcode"; $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 viewApproveQP($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $teachcode = $aobj_context->mobj_data["tech"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $query = "select ffilename,fqpfile from qpseter where fapproveduser = '{$teachcode}' and fqpcode = '{$qpcode}'"; $result = $aobj_context->pobj_db->GetRow($query); $pdf_content = $result['fqpfile']; $stmt = mysqli_prepare($conn, $query); mysqli_stmt_bind_param($stmt, "i", $teachcode); mysqli_stmt_execute($stmt); mysqli_stmt_bind_result($stmt, $pdf_content); mysqli_stmt_fetch($stmt); header("Content-Type: application/pdf"); header("Content-Disposition: attachment; filename={$result['ffilename']}"); if(count($result) > 0) { echo $pdf_content; } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function uploadQPDet($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"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $sets = $aobj_context->mobj_data["set"]; $fexam = $aobj_context->mobj_data["fexam"]; $collcode = $aobj_context->mobj_data["collcode"]; $mobile = $aobj_context->mobj_data["mobileno"]; $file = $_FILES['File']['name']; $temp = $_FILES['File']['tmp_name']; $qpfile = $_FILES['QPFile']['name']; $qptemp = $_FILES['QPFile']['tmp_name']; $date = date('Y-m-d H:i:s'); $ext = pathinfo($file, PATHINFO_EXTENSION); $extend = pathinfo($qpfile, PATHINFO_EXTENSION); $splitExam = explode("-", $fexam); $fyear = $splitExam[0]; $fexamtype = $splitExam[1]; if($file !== "" || $file !== NULL){ // $name = $userid."-".$qpcode."-".$sets."_AnsKey"; // $file_name = $name.".".$ext; $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length = 30; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $file_name = $userid."_".$qpcode."_ans_".$randomString.".".$ext; mkdir($aobj_context->main_src."QP_Details/".$univcode."/".$fexam."/".$qpcode."/", 0777, true); move_uploaded_file($temp,"QP_Details/".$univcode."/".$fexam."/".$qpcode."/".$file_name); $file_path = "QP_Details/".$univcode."/".$fexam."/".$qpcode."/".$file_name; $file = $aobj_context->main_src."QP_Details/{$univcode}/{$fexam}/{$qpcode}/{$file_name}"; if(file_exists($file)){ if($file){ $query = "update qpseterdet set ffilename='{$file_name}', fqpduser = '{$userid}', fqpdtme = '{$date}', fuploadstatus = 'T',fanskeypath = '{$file_path}' where fteachcode = '{$userid}' and fqpcode = '{$qpcode}' and fset = '{$sets}' and fyear = '{$fyear}' and fexamtype = '{$fexamtype}'"; $result = $aobj_context->pobj_db->Execute($query); $remarks = "Upload Answer Key - uploaded answer key file against ".$qpcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Upload Question Paper Details - Upload Answer Key", $userid, $mobile); } } } if($qpfile !== "" || $qpfile !== NULL){ // $name = $qpcode."-".$sets; // $file_name1 = $userid."-".$qpcode."-".$sets.".".$extend; $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; $length = 30; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $file_name1 = $userid."_".$qpcode."_qp_".$sets."_".$randomString.".".$extend; $dir = mkdir($aobj_context->main_src."QP_Details/".$univcode."/".$fexam."/".$qpcode."/", 0777); move_uploaded_file($qptemp,"QP_Details/".$univcode."/".$fexam."/".$qpcode."/".$file_name1); $file_path = "QP_Details/".$univcode."/".$fexam."/".$qpcode."/".$file_name1; $qpfile = $aobj_context->main_src."QP_Details/{$univcode}/{$fexam}/{$qpcode}/{$file_name1}"; if(file_exists($qpfile)){ if($qpfile){ $query1 = "update qpseterdet set ffilename='{$file_name1}', fqpduser = '{$userid}', fqpdtme = '{$date}', fuploadstatus = 'T',fqpfilepath = '{$file_path}' where fteachcode = '{$userid}' and fqpcode = '{$qpcode}' and fset = '{$sets}' and fyear = '{$fyear}' and fexamtype = '{$fexamtype}'"; $result1 = $aobj_context->pobj_db->Execute($query1); $remarks = "Upload Question Paper - uploaded Question Paper file against ".$qpcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Upload Question Paper Details - Upload Question Paper", $userid, $mobile); } } } if($result) { $arr['msg'] = 'Success'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $arr['msg'] = 'File Not Uploaded'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function viewQPDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $teachcode = $aobj_context->mobj_data["tech"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $set = $aobj_context->mobj_data["set"]; $type = $aobj_context->mobj_data["type"]; if($type === "AK"){ $con = "fanskeypath"; }elseif($type === "QP"){ $con = "fqpfilepath"; } $query = "select $con from qpseterdet where fteachcode = '{$teachcode}' and fqpcode = '{$qpcode}' and fset = '{$set}'"; $result = $aobj_context->pobj_db->GetRow($query); if($type === "AK"){ $file_url = $result['fanskeypath']; }elseif($type === "QP"){ $file_url = $result['fqpfilepath']; } $file_data = $aobj_context->main_src."uploadqpscheme/{$file_url}"; header('Content-Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document'); header('Content-Type: application/octet-stream'); header("Content-Transfer-Encoding: Binary"); header("Content-disposition: attachment; filename=\"" . basename($file_data) . "\""); readfile($file_url); if(count($result) > 0) { echo $pdf_content; } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function acceptQPDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $fqpcode = $aobj_context->mobj_data["qpcode"]; $set = $aobj_context->mobj_data["set"]; $accept = $aobj_context->mobj_data["accept"]; $teachcode = $aobj_context->mobj_data["userid"]; $collcode = $aobj_context->mobj_data["collcode"]; $mobile = $aobj_context->mobj_data["mobile"]; $query1 = "update qpseter set fstatus = 'T' where fteachcode = '{$teachcode}' and fqpcode = '{$fqpcode}'"; $result1 = $aobj_context->pobj_db->Execute($query1); $query = "update qpseterdet set fstatus = '{$accept}' where fteachcode = '{$teachcode}' and fqpcode = '{$fqpcode}' and fset = '{$set}'"; $result = $aobj_context->pobj_db->Execute($query); $remarks = "Teacher ". $teachcode . " is ". $accept . " against QPCODE ". $fqpcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Upload QP Pattern and Syllabus Pattern", $teachcode, $mobile); if(count($result) > 0) { $arr['msg'] = 'Success'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $arr['msg'] = 'No data Found'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function acceptedUploadQP($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $teachcode = $aobj_context->mobj_data["userid"]; $query = "select qp.fqpcode, s.fsubname, s.fvalmax,qp.fset,concat(qp.fyear,'-', qp.fexamtype)as fexam, qp.fqpfilepath,qp.fanskeypath,s.FQPPATREN,s.FQPSYLLABUS, s.FSUBSHORT, s.FSHORTNAME, ifnull(qp.fqpdtme,'') as qpupd from qpseterdet qp inner join subject s on qp.fqpcode = s.fqpcode inner join degree d on s.fdegree = d.fdegree and d.fexamno = s.fexamno inner join qpset_deggrp dg on d.fdeggrp = dg.fdeggrp and qp.fyear = dg.fyear and qp.fexamtype = dg.fexamtype inner join qpseter q on qp.fqpcode = q.fqpcode and qp.fteachcode = q.fteachcode and qp.fyear = q.fyear and qp.fexamtype = q.fexamtype and q.fappointed = 'T' where qp.fteachcode = '{$teachcode}' and qp.fstatus = 'ACCEPTED' group by fqpcode,fset,qp.fyear,qp.fexamtype"; // "select qp.fqpcode, s.fsubname, s.fvalmax,qp.fset,concat(qp.fyear,'-', qp.fexamtype)as fexam, // qp.fqpfilepath,qp.fanskeypath,s.FQPPATREN,s.FQPSYLLABUS, s.FSUBSHORT, s.FSHORTNAME // from qpseterdet qp inner join subject s on qp.fqpcode = s.fqpcode // inner join qpseter q on qp.fqpcode = q.fqpcode // and qp.fteachcode = q.fteachcode and qp.fyear = q.fyear // and qp.fexamtype = q.fexamtype // and q.fappointed = 'T' // where qp.fteachcode = '{$teachcode}' // and qp.fstatus = 'ACCEPTED' // group by fqpcode,fset"; $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 downloadSyllabus($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $teachcode = $aobj_context->mobj_data["userid"]; $mobile = $aobj_context->mobj_data["mobile"]; $collcode = $aobj_context->mobj_data["collcode"]; $fvalmax = $aobj_context->mobj_data["fvalmax"]; $fset = $aobj_context->mobj_data["fset"]; $fqpcode = $aobj_context->mobj_data["fqpcode"]; $remarks = "Syllabus with COs - Max Marks ".$fvalmax. " and ".$fset." is downloaded by Teacher ". $teachcode . " against Qp Code ". $fqpcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Upload Question Paper Details", $teachcode, $mobile); } function downloadQPPattern($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include("error_log.php"); $univcode = $aobj_context->mobj_data["univcode"]; $teachcode = $aobj_context->mobj_data["userid"]; $mobile = $aobj_context->mobj_data["mobile"]; $collcode = $aobj_context->mobj_data["collcode"]; $fvalmax = $aobj_context->mobj_data["fvalmax"]; $fset = $aobj_context->mobj_data["fset"]; $fqpcode = $aobj_context->mobj_data["fqpcode"]; $remarks = "Question Paper Pattern - Max Marks ".$fvalmax. " and ".$fset." is downloaded by Teacher ". $teachcode . " against Qp Code ". $fqpcode; $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Upload Question Paper Details", $teachcode, $mobile); } ?>
Close