Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
adm_admin.php	35.81 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

Code Editor : qpsetterteach.php

<?php

function getQpSetterDetData($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data["univcode"];
    $teachcode = $aobj_context->mobj_data["teachcode"];
    
    $query = "select ifnull(qp.fqpcode, '')as fqpcode, 
              concat(ifnull(s.fsubname, ''), ' - ', ifnull(s.fsubshort, ''))as fsubname, 
              ifnull(s.fvalmax, '')as fvalmax, 
              ifnull(qp.fset, '')as fset,
              ifnull(qp.fqpcodeno, '')as fqpcodeno,
              ifnull(qp.fyear, '') as fyear,
              ifnull(qp.fexamtype, '') as fexamtype, 
              ifnull(qp.fsqppatren, '')as fqppattern, 
              ifnull(qp.fsqpsyllabus, '')as fqpsyllabus,
              ifnull(qp.fstatus, '')as fstatus 
              from qpseterdet1 qp inner join subject s on qp.fqpcode = s.fqpcode 
              where fteachcode = '{$teachcode}' 
              group by 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");
        return;
    }
}

$result = $aobj_context->pobj_db->Execute($query);
   
    if($result){
        $arr['msg'] = "successfully updated";
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
    } else {
        $arr['msg'] = 'failed to update';
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        return;
    }
}

function getUploadQPseterDetData($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data["univcode"];
    $teachcode = $aobj_context->mobj_data["teachcode"];
    
    $query = "select ifnull(qp.fqpcode, '')as fqpcode, 
            concat(ifnull(s.fsubname, ''), ' - ', ifnull(s.fsubshort, ''))as fsubname, 
            ifnull(s.fvalmax, '')as fvalmax, 
            ifnull(qp.fset, '')as fset,
            ifnull(qp.fqpcodeno, '')as fqpcodeno,
            ifnull(qp.fyear, '') as fyear,
            ifnull(qp.fexamtype, '') as fexamtype,
            ifnull(qp.fsqppatren, '')as fqppattern, 
            ifnull(qp.fsqpsyllabus, '')as fqpsyllabus,
            ifnull(qp.fqpfilepath, '')as fqpfilepath,
            ifnull(qp.fanskeypath, '')as fanskeypath
            from qpseterdet1 qp inner join subject s on qp.fqpcode = s.fqpcode 
            where qp.fstatus = 'ACCEPTED' and qp.fteachcode = '{$teachcode}'; ";

function uploadQpPrepareFiles($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["teachcode"];
    $mobile = $aobj_context->mobj_data["mobile"];
    $data = json_decode($aobj_context->mobj_data["data"], true);

$qpFile = $_FILES['qpfile'];
    $qpFileName = $qpFile['name'];
    $qpFileData = $qpFile['tmp_name'];
    $qpExt = pathinfo($qpFileName, PATHINFO_EXTENSION);

$date = date('Y-m-d H:i:s');
    
    $ansKeyFile = $_FILES['ansKeyFile'];
    $ansKeyFileName = $ansKeyFile['name'];
    $ansKeyFileData = $ansKeyFile['tmp_name'];
    $qpAnsKeyExt = pathinfo($ansKeyFileName, PATHINFO_EXTENSION);

$fexam = $data['fyear']."-".$data['fexamtype'];
    $qpcode = $data['fqpcode'];
    $set = $data['fset'];
    $section = $data['fqpcodeno'];

$qryMod = "select ifnull(fmodqpupd, '')as fmodqpupd from qpseterdet1 where 
               fteachcode = '{$teachcode}'
               and fqpcode = '{$data['fqpcode']}'
               and fset = '{$data['fset']}'
               and fqpcodeno = '{$data['fqpcodeno']}'
               and fyear = '{$data['fyear']}'
               and fexamtype = '{$data['fexamtype']}'";

$resMod = $aobj_context->pobj_db->GetRow($qryMod);

if($resMod['fmodqpupd'] !== ""){
        $arr['msg'] = 'cannot upload file. moderation completed';
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        return;
    }

if($qpFileName != "" || $qpFileName != NULL ){
        $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
        $length = 30; 
        $randomString = '';
        for ($i = 0; $i < $length; $i++) {
            $randomString .= $characters[rand(0, strlen($characters) - 1)];
        }
        
        $file_name = $teachcode."_".$qpcode."_".$set."_".$section."_qp_".$randomString.".".$qpExt;
        $dir = mkdir($aobj_context->main_src. "QP_Details/" .$univcode. "/" .$fexam. "/" .$qpcode. "/", 0777);
        move_uploaded_file($qpFileData, "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 qpseterdet1 set  fqpduser = '{$teachcode}', fqpdtme = '{$date}', 
                    fuploadstatus = 'T',fqpfilepath = '{$file_path}'
                    where fteachcode = '{$teachcode}'
                    and fqpcode = '{$qpcode}'
                    and fset = '{$set}'
                    and fqpcodeno = '{$section}'
                    and fyear = '{$data['fyear']}'
                    and fexamtype = '{$data['fexamtype']}'";

$result = $aobj_context->pobj_db->Execute($query);

$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", $teachcode, $mobile);
            }
        }

} 
    if($ansKeyFileName != "" || $ansKeyFileName != NULL){
        $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
        $length = 30; 
        $randomString = '';

for ($i = 0; $i < $length; $i++) {
            $randomString .= $characters[rand(0, strlen($characters) - 1)];
        }

$file_name = $teachcode. "_" .$qpcode. "_" .$set. "_" .$section. "_ans_" .$randomString. "." .$qpAnsKeyExt;

mkdir($aobj_context->main_src."QP_Details/" .$univcode. "/" .$fexam. "/" .$qpcode. "/", 0777, true);
        move_uploaded_file($ansKeyFileData, "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 qpseterdet1 set fqpduser = '{$teachcode}', fqpdtme = '{$date}', 
                    fuploadstatus = 'T', fanskeypath = '{$file_path}'
                    where fteachcode = '{$teachcode}'
                    and fqpcode = '{$qpcode}'
                    and fset = '{$set}'
                    and fqpcodeno='{$section}'
                    and fyear = '{$data['fyear']}'
                    and fexamtype = '{$data['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", $teachcode, $mobile);
            }
        }
    }
    if($res){
        $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");
        return;
    }
}

function selectModerator($aobj_context){
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
        $univcode = $aobj_context->mobj_data["univcode"];
        $board = $aobj_context->mobj_data["board"];
        $qpcode = $aobj_context->mobj_data["qpcode"];
        $deggrp = $aobj_context->mobj_data["deggrp"];

$split = explode("*", $deggrp);
        $dggrp = $split[0];

if($qpcode === "All"){
            $qpcond = " ";
        }else{
            $qpcond = "and s.fqpcode = '{$qpcode}'";
        }

if($board === "All"){
            $boardCond = " ";
        }else{
            $boardCond = "and s.fboard = '{$board}'";
        }

$get_data= "select distinct s.fqpcode, 
                        concat(s.fsubname, ' - ', s.fsubshort) as fsubname, 
                        q.fset, q.fqpcodeno, 
                        count(q.fset) - sum(ifnull(q.fqpfilepath, 1))as uploaded,
                        sum(ifnull(q.fqpfilepath, 1)) as not_uploaded, 
                        ifnull(q.fmodteach, '')as fmodteach,
                        ifnull(mas.fteachname, '')as fmodname,
                        ifnull(q.fmodfromdate,'') as fmodfromdate,
                        ifnull(q.fmodtodate,'') as fmodtodate,
                        ifnull(q.flogin, '')as fstatus 
                        from qpseterdet1 q inner join subject s on q.fqpcode = s.fqpcode
                        left join masteach mas on mas.fteachcode = q.fmodteach  
                        inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
                        where d.fdeggrp = '{$dggrp}' and ifnull(s.fqpcode, '') <> ''
                        {$qpcond} {$boardCond}
                        group by q.fqpcode, q.fset, q.fqpcodeno
                        order by q.fqpcode";
                
        $lobj_get_data = $aobj_context->pobj_db->GetAll($get_data);

$teach = "select fteachcode, fteachname, fmobile  from masteach where ifnull(fteachcode, '')<>''";
        $teach_res = $aobj_context->pobj_db->GetAll($teach);
        if($teach_res){
            $arr['teach'] = $teach_res;
            $arr['mod'] = $lobj_get_data;
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");  
        }else{
            $arr['msg'] = 'Failed to load';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        }
    }

function saveAssignModeratorDet($aobj_context){
        include("sendGridMail.php");
        include("error_log.php");
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
        $univcode = $aobj_context->mobj_data["univcode"];
        $user = $aobj_context->mobj_data["user"];
        $year = $aobj_context->mobj_data["exam"];
        $board = $aobj_context->mobj_data["board"];
        $qpcode = $aobj_context->mobj_data["qpcode"];
        $data = json_decode($aobj_context->mobj_data["data"], true);
        
        $onldate = date('d-m-Y');
        $split = explode("*",$year);
        $degree = $split[0];
        $splitagain = explode("-",$split[1]);
        $year = $splitagain[0];
        $mode = $splitagain[1];

$new_arr = [];
        foreach($data as $value){
            if($value['femail'] === 'T'){
                array_push($new_arr, $value['fmodteach']);
            }
        }

$teachArr = array_unique($new_arr);
        
        foreach($data as $val){
            $query = "update qpseterdet1 set fmodteach='{$val['fmodteach']}', 
                      fmodfromdate='{$val['fmodfromdate']}', flogin='{$val['fstatus']}',
                      fmodtodate='{$val['fmodtodate']}'
                      where fqpcode='{$val['fqpcode']}' 
                      and fset='{$val['fset']}'
                      and fqpcodeno='{$val['fqpcodeno']}'
                      and fyear='{$year}'
                      and fexamtype='{$mode}'";

$result = $aobj_context->pobj_db->Execute($query);
            $remarks = "Moderator is Assigned for teacher ".$val['fmodteach']." and qpcode ".$val['fqpcode']." and exam year and number ".$year."-".$mode;
            $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Assign Moderator", $user, $user);
        }

foreach($teachArr as $val){
            $qryMobile = "select ifnull(fmobile, '')as fmobileno, 
                              ifnull(femail, '')as femail from masteach where
                              fteachcode = '{$val}'";

$resMobile = $aobj_context->pobj_db->GetRow($qryMobile);
            $mobileno = $resMobile['fmobileno'];          
            $emailid = $resMobile['femail'];

$slt = "select fmobileno, fusertype, fpasswd, femail from 
                        logisys3_comexam.masuser where 
                        fregno = '{$val}' 
                        and funivcode='{$univcode}'
                        and fmobileno='{$mobileno}'";

$reslt = $aobj_context->pobj_db->GetRow($slt);
            $usertype = $reslt['fusertype'];

if(count($reslt) > 0){
                $queryIns = "update logisys3_comexam.masuser set 
                                fusertype = concat('{$usertype}','*','502'), ftype = 'M', ftemp = 'M'
                                where fmobileno = '{$mobileno}' and funivcode = '{$univcode}'";
            }else{
                $queryIns = "insert ignore into logisys3_comexam.masuser(FUNIVCODE, FREGNO, FMOBILENO,
                                FUSERTYPE, FPASSWD, ftype, FTEMP, FACTIVE)
                                values('{$univcode}', '{$val}', '{$mobileno}',
                                '502', '{$mobileno}', 'M', 'M', 'T')";
            }

$resultIns = $aobj_context->pobj_db->Execute($queryIns);
            $remarks = "Added new Usertype for ".$mobileno." and Univcode ".$univcode;
            $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "Assign Moderator", $user, $user);

$unishort = "select funivname, ffolder, pdf_logo_path, FTOWN, fmodemail, ftdvs_helplineno  from control";
            $resunishort = $aobj_context->pobj_db->GetRow($unishort);

$univname = $resunishort['funivname'];
            $town = $resunishort['FTOWN'];
            $univshort = strtoupper($resunishort['ffolder']);

$teachDet = "select ifnull(m.fteachname, '')as fteachname, 
                        ifnull(m.fcollname, '')as fcollname, d.fdegncode, 
                        ifnull(d.fdegndesc, '')as fdegndesc 
                        from masteach m inner join masdegn d on d.fdegncode = m.fdegncode 
                        where fteachcode = '{$val}'";

$teachDet1 = $aobj_context->pobj_db->GetRow($teachDet);
            $teachname = $teachDet1['fteachname'];
            $colladd = $teachDet1['fcollname'];
            $degn = $teachDet1['fdegndesc'];

$query1 = "select distinct s.fqpcode, s.fsubname, d.fexamdate, 
                        d.fexamname, d.fdescpn from subject s 
                        inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno
                        where fqpcode = '{$qpcode}'";
                               
            $res1 = $aobj_context->pobj_db->GetRow($query1);
            $fqpcode = $res1['fqpcode'];
            $fsubname = $res1['fsubname'];
            $fexamdate = $res1['fexamdate'];
            $fexamnmae = $res1['fexamname'];
            $fdescpn = $res1['fdescpn'];
            
            $qur1 = "select fexamdate from deggrp where fdeggrp = '{$degree}'
                    and fyear='{$year}' and fexamtype='{$mode}'";
            $resn1 = $aobj_context->pobj_db->GetRow($qur1);

$exm =$resn1['fexamdate'];

$qry = "select q.fqpcode, q.fyear, q.fexamtype, count(fset)as fset, 
                    date_format(q.fmodfromdate, '%d/%m/%Y')as fmodfromdate,
                    s.fsubname, dg.fexamdate from qpseterdet1 q inner join subject s on 
                    s.fqpcode = q.fqpcode 
                    inner join degree d on d.fdegree = s.fdegree 
                    and d.fexamno = s.fexamno inner join deggrp dg
                    on dg.fdeggrp = d.fdeggrp and dg.fexamtype = q.fexamtype
                    and dg.fyear = q.fyear 
                    where q.fqpcode='{$qpcode}' and q.fmodteach='{$val}'
                    and q.fyear='{$year}' and q.fexamtype='{$mode}'
                    group by q.fqpcode";
            $res = $aobj_context->pobj_db->GetRow($qry);

$masQry = "select fmobileno, fusertype, fpasswd, femail from 
                        logisys3_comexam.masuser where 
                        fregno = '{$val}' 
                        and funivcode='{$univcode}'
                        and fmobileno='{$mobileno}'";

$resMasQry = $aobj_context->pobj_db->GetRow($slt);
            $password = $resMasQry['fpasswd'];

$fromdate=$res['fmodfromdate'];
            if($univcode == "051"){
                $logo_path = "/img/dyp_elogo.jpeg";
            }else{
                $logo_path = $resunishort['pdf_logo_path'];
            }
            $logo = "https://college.universitysolutions.in/".$resunishort['ffolder']. $logo_path;

$message="<html>";
            $message.="<body>";
            $message.="<style>";  
            $message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; 
                        font-family: Verdana, Arial, Helvetica, sans-serif;}
                         table,td, th{
                            border: 1px solid black;
                            border-collapse: collapse;
                        } ";  
            $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; text-align:right'>Date.:"." $onldate "."</p>";
            $message.="<p>Dear Sir/Madam,<br><br></p>";
            $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>
                        The University is pleased to appoint you as the Question paper moderator for the course "."$fqpcode"."–"."$fsubname"." of $fdescpn, University exams.<br>
                        You are asked to report to the CoE office on {$fromdate} and complete the Question paper moderation on the same day.</p>";

$message.="<div style='justify-content:center; align-itmes:center;'>";
            $message.="<table style='width: 40%;border: 1px solid;'>  
                            <thead>
                                <tr>
                                    <th style='border: 1px solid;text-align:center;'>Course Code</th>
                                    <th style='border: 1px solid;text-align:center;'>Subject Name</th>
                                    
                                </tr>
                            </thead>
                        <tbody>";
            
            $message.="<tr>";
            $message.="<td style='border: 1px solid;text-align:center;'>".$res['fqpcode']."</td>";
            $message.="<td style='border: 1px solid;text-align:initial; padding-left:10px'>".$res['fsubname']."</td>";
            // $message.="<td style='border: 1px solid;text-align:initial; padding-left:10px'>".$res['fexamdate']."</td>";
            // $message.="<td style='border: 1px solid;text-align:center;'>".$res['fset']."</td>";
            //  <th style='border: 1px solid;text-align:center;'>Set No.</th><th style='border: 1px solid;text-align:center;'>Exam Date</th>
            $message.="</tr>";
            $message.="</tbody>
                       </table>";
            $message.="</div>";
            $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>{$mailmtr}</p>";
            $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>
                        Portal Login details are as follows.<br><br>";
            $message.="Portal Link: https://egov.universitysolutions.in/#/"."<br>";
            $message.="Mobile No.:"."{$mobileno}"."<br>";
            $message.="Password.:"."{$password}"."<br></p>";
            $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>
                        Kindly call to "."$helplineno"." in case if you have any technical issues.<br></p>";
            $message.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>
                        Thanking You,</p>";
            $querySign = "select distinct s.fqpcode, d.fsignpath from degree d inner join subject s on 
                                s.fdegree = d.fdegree and s.fexamno = d.fexamno 
                                where s.fqpcode='{$fqpcode}' and ifnull(fsignpath,'')<>''";
            $ressign = $aobj_context->pobj_db->GetRow($querySign);
            $sign = $ressign['fsignpath'];
            $signpath = "https://college.universitysolutions.in/".$resunishort['ffolder']."/img/".$sign;

if($sign!==NULL){
                $message .= "<img src='{$signpath}' width='100' height='50'/>";
                $message .= "<br/>";
            }
            $message.="Controller of Examinations<br>"."$univname"."<br>
            $town
            </p>";

$message.="</body>";
            $message.="</html>";

$subject= strtoupper("$univshort".": Appointment as Moderator for the University ".$fexamdate." Examination"); 
            $from = "";
        
            $resp = sendGridMail($emailid,$subject,$message,$univcode);

}

if($result){
            $arr['msg'] = 'successfully updated';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
        }else{
             $arr['msg'] = 'failed to update';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
            return;
        }
    }

${this.title}

Code Editor : qpsetterteach.php