Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxrwxr-x
phpseclib3	[ DIR ]	drwxrwxr-x
razorpay	[ DIR ]	drwxr-xr-x
wordlib	[ DIR ]	drwxrwxr-x
.mad-root	0 B	-rw-r--r--
AdmStrFeeReport.php	10.18 KB	-rwxr-xr-x
CreateUserType.php	4.13 KB	-rwxr-xr-x
Demo_Screen.php	2.37 KB	-rw-rw-r--
ECH_Pushnotif_bcu.php	2.17 KB	-rwxr-xr-x
ExamStats.php	2.21 KB	-rwxr-xr-x
ExmStatsSumm.php	1.85 KB	-rwxr-xr-x
NewLoginPage.php	3.85 KB	-rw-rw-r--
PaytmChecksum.php	3.91 KB	-rw-rw-r--
QPDegreeGroup.php	2.48 KB	-rw-r--r--
QPMaster.php	3.95 KB	-rw-r--r--
RVRTFeeUpdate.php	5.75 KB	-rwxr-xr-x
Tickets.php	7.99 KB	-rw-rw-r--
UpdateScanCodeList.php	1.11 KB	-rwxr-xr-x
acknowlege_direct.php	3.7 KB	-rw-r--r--
activateTT.php	2.07 KB	-rwxr-xr-x
admLogin.php	1.32 KB	-rw-rw-r--
admStats.php	414 B	-rwxr-xr-x
admStatsCollwise.php	4.78 KB	-rwxr-xr-x
admStatsDegwise.php	2.4 KB	-rwxr-xr-x
adm_admin.php	11.8 KB	-rw-r--r--
admapprove.php	7.75 KB	-rw-r--r--
admdet.php	1.17 KB	-rw-r--r--
admin-Copy.html	5.68 KB	-rwxr-xr-x
admisiondegree.php	1.52 KB	-rw-rw-r--
appNotification.php	3.46 KB	-rwxr-xr-x
approvestudename.php	2.71 KB	-rw-rw-r--
assignUserMenus.php	4.11 KB	-rwxr-xr-x
attend_block.php	3.46 KB	-rw-r--r--
attendance_report.php	7.64 KB	-rw-r--r--
attshortupdate.php	4.27 KB	-rw-rw-r--
attupd.php	2.4 KB	-rwxr-xr-x
avlQP.php	6.59 KB	-rw-rw-r--
bkmhconfirm.php	3.86 KB	-rw-r--r--
boardMaster.php	6.74 KB	-rwxr-xr-x
boardMember.php	1.89 KB	-rw-rw-r--
bundNotRecvRprt.php	6.92 KB	-rwxrwxrwx
bundRecvReport.php	6.92 KB	-rwxr-xr-x
bundleReceive.php	1.11 KB	-rwxr-xr-x
bundledispatchrpt.php	2.66 KB	-rw-r--r--
caccesscontext.php	1.24 KB	-rwxr-xr-x
cappcontext.php	4.58 KB	-rwxr-xr-x
cappcontext1.php	3.64 KB	-rwxr-xr-x
category.php	1.33 KB	-rwxr-xr-x
centrealloction.php	1.37 KB	-rw-r--r--
centrereports.php	2.36 KB	-rw-r--r--
certificatestatus.php	13.08 KB	-rw-r--r--
changeMobile.php	3.74 KB	-rwxr-xr-x
changePasswd.php	1.23 KB	-rwxr-xr-x
checkMob.php	961 B	-rw-r--r--
code39.php	6.38 KB	-rwxr-xr-x
collegeSubjects.php	3.2 KB	-rwxr-xr-x
college_list.php	5.93 KB	-rwxr-xr-x
college_reports.php	17.63 KB	-rwxr-xr-x
collegemasters.php	1.36 KB	-rw-r--r--
collegereports.php	6.21 KB	-rw-r--r--
combSubjects.php	711 B	-rwxr-xr-x
combination.php	6.04 KB	-rwxr-xr-x
compileQpIndent.php	7.89 KB	-rw-rw-r--
compileQpIndent_22032022.php	7.99 KB	-rwxr-xr-x
compileQpIndent_old.php	4.43 KB	-rwxr-xr-x
constants.php	818 B	-rwxr-xr-x
convoedit.php	7.43 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
createExam.php	4.85 KB	-rw-r--r--
createGroup.php	8.88 KB	-rwxr-xr-x
createReval.php	860 B	-rw-r--r--
createTemp.php	7.84 KB	-rw-r--r--
createUser.php	8.04 KB	-rwxr-xr-x
createboard.php	3.16 KB	-rw-rw-r--
createboe.php	6.19 KB	-rwxrwxrwx
creditMaster.php	2.31 KB	-rwxr-xr-x
crequestbroker.php	2.53 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
dailyFeeReport.php	11.59 KB	-rw-r--r--
dailyValuation.php	1.6 KB	-rwxr-xr-x
dashboard.php	3 KB	-rwxr-xr-x
dashboardNew.php	31.38 KB	-rw-rw-r--
dateMaster.php	3.1 KB	-rwxr-xr-x
dateupdate.php	8.88 KB	-rw-rw-r--
decodngstats.php	656 B	-rw-rw-r--
define_heads.php	1.89 KB	-rw-rw-r--
degcollege.php	7.32 KB	-rwxr-xr-x
deggrp.php	13.84 KB	-rwxr-xr-x
deggrpNew.php	2.74 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-rw-r--
dispatchmarkscard.php	19.14 KB	-rwxrwxrwx
drawer.php	552 B	-rw-rw-r--
dropDownOptions.php	400 B	-rwxr-xr-x
eGovSignin.php	5.09 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	5.95 KB	-rwxr-xr-x
examHappeningCentre.php	22.44 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-rw-r--
examapprpt.php	2.93 KB	-rw-r--r--
examattendanceunivadmin.php	19.73 KB	-rwxr-xr-x
exceptionhandler.php	236 B	-rwxr-xr-x
fee-str.php	17.11 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
feedback.php	2.97 KB	-rw-rw-r--
finalQp.php	12.7 KB	-rw-rw-r--
financeMenuItems.php	1.51 KB	-rw-rw-r--
format.php	7.43 KB	-rwxr-xr-x
freezeTimetable.php	3.37 KB	-rwxrwxrwx
generatebill_acu.php	21.07 KB	-rw-r--r--
generatebill_new.php	29.07 KB	-rw-r--r--
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	4.25 KB	-rwxr-xr-x
getNotifications.php	1.13 KB	-rwxr-xr-x
getQPdet.php	7 KB	-rw-rw-r--
getRvPcReport.php	4.99 KB	-rwxr-xr-x
getStudentRegisteredReport.php	8.91 KB	-rw-rw-r--
getUnivName.php	516 B	-rw-r--r--
get_result_table.php	109 B	-rw-r--r--
getdeggrpvalcntr.php	1.88 KB	-rw-rw-r--
getinwordstatus.php	3.46 KB	-rw-rw-r--
getpgetSavedData.php	4.29 KB	-rwxr-xr-x
getrvpc.php	8.89 KB	-rw-r--r--
getstuddetforrt.php	5.85 KB	-rw-rw-r--
getunivs.php	816 B	-rwxr-xr-x
groupMessages.php	9.1 KB	-rwxr-xr-x
grv.php	12.23 KB	-rwxrwxrwx
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-rw-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-rw-r--
lastDateUpdate.php	4.23 KB	-rwxr-xr-x
lastDateUpdateCorrection.php	4.96 KB	-rw-rw-r--
ledgerview.php	3.79 KB	-rwxrwxrwx
loadclgdettab.php	2.26 KB	-rw-rw-r--
loadclgnm.php	1.3 KB	-rw-rw-r--
loaddegdet.php	1.45 KB	-rw-rw-r--
loaddegreedettab.php	2.49 KB	-rw-rw-r--
loadupdclgnm.php	741 B	-rw-rw-r--
log.php	521 B	-rw-rw-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-rw-r--
marksentryupdate.php	4.78 KB	-rw-r--r--
marksmodreport.php	1.49 KB	-rw-rw-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	5.2 KB	-rw-rw-r--
mregistry.php	125.5 KB	-rwxrwxrwx
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	5.03 KB	-rw-rw-r--
omrqnentry.php	17.52 KB	-rw-rw-r--
online-test.php	12.77 KB	-rwxr-xr-x
orderReportExcel.php	7.35 KB	-rw-rw-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-rw-r--
prbatchdet.php	3.26 KB	-rwxr-xr-x
preparethqp.php	20.89 KB	-rw-rw-r--
prifreeze.php	3.11 KB	-rw-rw-r--
pushmarks.php	1.18 KB	-rw-rw-r--
pushnitification.php	9.89 KB	-rwxr-xr-x
pushnotif_ra.php	5.59 KB	-rwxr-xr-x
pwnkit	0 B	-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.45 KB	-rw-rw-r--
qp_issue.php	8.46 KB	-rw-rw-r--
qp_setter.php	76.37 KB	-rw-r--r--
qp_setter_new.php	53.28 KB	-rw-r--r--
qpboardupdate.php	4.26 KB	-rw-rw-r--
qpcrosscheck.php	11.96 KB	-rw-r--r--
qpdaylog.php	433 B	-rw-rw-r--
qpindentstudlist.php	11.16 KB	-rw-r--r--
qplog.php	938 B	-rw-rw-r--
qpschemeupload.php	5.84 KB	-rw-rw-r--
qpsetterteach.php	22.96 KB	-rw-rw-r--
qpsummary.php	7.01 KB	-rw-rw-r--
qpsummarynew.php	4.58 KB	-rw-rw-r--
qptranlogin.php	1.84 KB	-rw-rw-r--
qptranmenu.php	2.22 KB	-rw-rw-r--
qptranqpupd.php	1.36 KB	-rw-r--r--
qpupload.php	8.11 KB	-rwxrwxrwx
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
receivescript.php	8.15 KB	-rw-rw-r--
refund.php	2.68 KB	-rwxr-xr-x
register_rrit.php	24.18 KB	-rw-r--r--
releaseTimetable.php	5.93 KB	-rwxrwxrwx
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-rw-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-rw-r--
rvMarksEntry.php	4.78 KB	-rwxrwxrwx
rvStatus.php	7.69 KB	-rw-rw-r--
rv_result_pushnotif_bcu.php	1.96 KB	-rwxr-xr-x
rvpc.php	1.76 KB	-rw-rw-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-rw-r--
saveAbstractForm.php	8.03 KB	-rw-r--r--
saveBKMCStdDet.php	2.22 KB	-rw-r--r--
saveBankDetails.php	1.64 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	4.02 KB	-rw-rw-r--
script.php	14.27 KB	-rwxr-xr-x
sdqpmenus.php	163 B	-rw-rw-r--
searchregcode.php	5.17 KB	-rw-rw-r--
selectFinalQpNew.php	4.69 KB	-rw-rw-r--
sendGridMail.php	1.72 KB	-rwxr-xr-x
sendOTP.php	5.51 KB	-rw-r--r--
sendOrder.php	12.9 KB	-rw-r--r--
sendnotification.php	0 B	-rwxr-xr-x
sendsms.php	13.19 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.55 KB	-rw-rw-r--
session_start.php	149 B	-rw-r--r--
session_start_rr.php	430 B	-rw-r--r--
sessionmaster.php	1.49 KB	-rw-r--r--
setDGExamTimetableReport.php	20.84 KB	-rwxr-xr-x
setDGExamTimetableReport_bcu_p...	11.51 KB	-rwxr-xr-x
setExamTimetable.php	5.01 KB	-rwxr-xr-x
setExamTimetableReport.php	9.05 KB	-rwxr-xr-x
settlement.php	9.06 KB	-rw-rw-r--
sms-new.php	28.07 KB	-rw-rw-r--
sms-notification.php	21.17 KB	-rwxr-xr-x
ssp_error_data.php	31.1 KB	-rwxrwxrwx
sspdata-auto-upload.php	11.12 KB	-rwxr-xr-x
sspdata.php	23.87 KB	-rwxr-xr-x
sspdata1.php	11.41 KB	-rw-rw-r--
sspdata1_rcub.php	13.96 KB	-rw-rw-r--
std_registrtion.php	1.4 KB	-rw-rw-r--
studReg.php	1.64 KB	-rw-r--r--
stud_ack.php	10.89 KB	-rw-rw-r--
student.php	26.37 KB	-rwxr-xr-x
studexamappblock.php	1.18 KB	-rw-rw-r--
studymaterial.php	3.07 KB	-rwxrwxrwx
subject.php	2.42 KB	-rwxr-xr-x
subjectEntryScrn.php	8 KB	-rwxr-xr-x
subjectFreeze.php	4.91 KB	-rw-rw-r--
sublisting.php	2.39 KB	-rw-rw-r--
tdvsCreatePanel.php	1.26 KB	-rw-r--r--
tdvsQPteach.php	2.17 KB	-rw-r--r--
tdvsViewStatus.php	3.52 KB	-rw-rw-r--
tdvs_Deviation.php	8.7 KB	-rw-rw-r--
tdvs_batch.php	6.35 KB	-rw-rw-r--
tdvs_createuser.php	6.61 KB	-rw-rw-r--
tdvs_dashboard.php	3.67 KB	-rw-rw-r--
tdvs_generateBill.php	15.79 KB	-rw-rw-r--
tdvs_mail.php	5.93 KB	-rw-rw-r--
tdvs_pergeval.php	14.43 KB	-rw-rw-r--
tdvs_register.php	1.57 KB	-rw-rw-r--
tdvs_resetVal.php	2.42 KB	-rw-rw-r--
tdvs_saveRecieveQPCount.php	3.55 KB	-rwxr-xr-x
tdvs_saveScript.php	12.32 KB	-rw-r--r--
tdvs_script_cross_check.php	9.41 KB	-rw-r--r--
tdvs_stats.php	21.7 KB	-rw-rw-r--
tdvs_subject.php	4.43 KB	-rw-rw-r--
tdvs_subjectcreate.php	6.07 KB	-rw-rw-r--
tdvs_teacher_valdet.php	2.87 KB	-rw-rw-r--
tdvs_teacherpanel.php	3.38 KB	-rw-rw-r--
tdvs_teachval.php	1.88 KB	-rw-rw-r--
tdvs_teachwisevaldet.php	6.4 KB	-rw-rw-r--
tdvs_valcenter.php	2.84 KB	-rw-rw-r--
tdvs_valuation.php	51.87 KB	-rw-rw-r--
tdvs_verifyqppattern.php	1.03 KB	-rw-rw-r--
tdvsdecoding.php	52.77 KB	-rw-rw-r--
teachReport.php	5.27 KB	-rwxr-xr-x
teachValBill.php	990 B	-rwxr-xr-x
teachcoderange.php	1.71 KB	-rw-rw-r--
teacherEmail.php	20.94 KB	-rw-rw-r--
teacherEntry.php	75.04 KB	-rw-rw-r--
teacherid.php	2 KB	-rw-rw-r--
teachval.php	8.56 KB	-rwxr-xr-x
teachvaluationcount.php	21.07 KB	-rw-rw-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	17.36 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.53 KB	-rwxr-xr-x
ultRoomDet.php	1.96 KB	-rw-rw-r--
umenu.php	1.07 KB	-rwxr-xr-x
uniAttEntry.php	1.03 KB	-rw-rw-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-rw-r--
updateIAMarks.php	1.42 KB	-rw-rw-r--
updateRvPcChkList.php	1.13 KB	-rwxr-xr-x
update_dates.php	11.89 KB	-rw-rw-r--
upload-sms-excel.php	3.58 KB	-rwxr-xr-x
uploadAnsBook.php	4.5 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-rw-r--
uploadFile.php	388 B	-rw-rw-r--
uploadMCdetails.php	4.17 KB	-rw-r--r--
uploadMultipleFiles.php	4.03 KB	-rwxr-xr-x
uploadSSPData.php	5.9 KB	-rw-rw-r--
uploadSSPData_bonf.php	11.86 KB	-rw-rw-r--
upload_ans_book.php	5.25 KB	-rwxr-xr-x
upload_qp.php	1.85 KB	-rw-rw-r--
uploadbackup.php	5.16 KB	-rw-rw-r--
uploadcorr_qp.php	6.21 KB	-rw-rw-r--
uploadcorrdoc.php	4.09 KB	-rw-r--r--
uploadpwd.php	3.75 KB	-rw-r--r--
uploadqp.php	6.61 KB	-rw-r--r--
uploadqpMultipleFiles.php	678 B	-rw-rw-r--
uploadscripts.php	333 B	-rw-rw-r--
utils.php	4.19 KB	-rw-rw-r--
uucmsdecoding.php	1.86 KB	-rw-rw-r--
valuatordet.php	3.29 KB	-rwxr-xr-x
verify.php	9.57 KB	-rw-rw-r--
verifyapponlineserv.php	3.18 KB	-rwxr-xr-x
viewTimeTabledurExm.php	3.84 KB	-rwxr-xr-x
viewexamcentrenew.php	20.44 KB	-rw-r--r--
viewfootnote.php	1.97 KB	-rw-r--r--
viewteachattendance.php	2.18 KB	-rw-r--r--

Code Editor : generatebill_new.php

<?php
$main_src = substr($_SERVER['SCRIPT_FILENAME'], 0, strlen($_SERVER['SCRIPT_FILENAME']) - 7);
$pdf_writer_class = $main_src . "/tcpdf/tcpdf.php";
require_once $pdf_writer_class;
ini_set('max_execution_time', '300');
include('getnumword.php');
// ini_set('memory_limit','900M');
// ini_set('max_execution_time',0);

class MYPDF extends TCPDF
{
    public function Header($resbill)
    {

// get the current page break margin
        $bMargin = $this->getBreakMargin();
        // get current auto-page-break mode
        $auto_page_break = $this->AutoPageBreak;
        // disable auto-page-break
        $this->SetAutoPageBreak(false, 0);
        $this->SetTitle("VALUATION BILL");

// set bacground image
        $this->SetFillColor(248, 248, 255);
        $img_path = $this->aobj_context->main_src . "/img/".$this->aobj_context->FUNIVCODE."_logo.jpg";
        
        if (file_exists($img_path)) {
            $this->Image($img_path, 6, 6, 25, 25);
        }

$this->SetFont('Times', 'B', 14);
        $this->SetY(5);
        $this->Cell(0, 7, $this->aobj_context->FUNIVNAME, 0, 1, 'C');
        //state
        $this->SetFont('Times', 'B', 11);
        $this->Cell(0, 4, $this->aobj_context->s_state, 0, 1, 'C');

$this->SetFont('Times', 'B', 12);
        if($this->aobj_context->FUNIVCODE == '033' || $this->aobj_context->FUNIVCODE == '040')
        {
            $this->Cell(0, 7, 'REMUNERATION BILL', '0', 1, 'C');
        }else
            $this->Cell(0, 7, 'TRAVELLING ALLOWANCE AND REMUNERATION BILL', '0', 1, 'C');

// restore auto-page-break status
        $this->SetAutoPageBreak($auto_page_break, $bMargin);
        // set the starting point for the page content
    }

public function Footer()
    {
        $this->SetY(-15);
        $this->SetFont('helvetica', 'I', 8);
        // var_dump();
        if($this->CurOrientation == 'P')
        {
            $this->Cell(60, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L');
            $this->Cell(60, 10, 'Date : ' . date("d-m-Y h:i:s A"), 0, 0, 'C');
            $this->Cell(60, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R');
        }
        else {
            $this->Cell(90, 10, 'IP : ' . $_SERVER["REMOTE_ADDR"], 0, 0, 'L');
            $this->Cell(90, 10, 'Date : ' . date("d-m-Y h:i:s A"), 0, 0, 'C');
            $this->Cell(90, 10, 'Page ' . $this->getPageNumGroupAlias() . '/' . $this->getPageGroupAlias(), 0, 1, 'R');
        }
    }
}

class ReprtObject
{

public function DefaultConstructor($aobj_context)
    {
        $this->aobj_context = $aobj_context;
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$this->ip = $_SERVER["REMOTE_ADDR"];
        $get_date = "select DATE_FORMAT(now(), '%d/%m/%Y') as now_date";
        $obj = $this->aobj_context->mobj_db->GetRow($get_date);
        $this->reportType = $aobj_context->mobj_data["rtype"];

$get_coll_name = "select FUNIVNAME as FUNIVNAME,FUNIVCODE,
		FUNIVADD1 as state, pdf_logo_path,
		ifnull(FEXAMAPPREQ,'F') as FEXAMAPPREQ From control";
        $lobj_get_coll_name = $aobj_context->pobj_db->GetRow($get_coll_name);
// var_dump($lobj_get_coll_name);
// die();
        $aobj_context->FUNIVNAME = $lobj_get_coll_name['FUNIVNAME'];
        $aobj_context->s_state = $lobj_get_coll_name['state'];
        $aobj_context->pdf_logo_path = $lobj_get_coll_name['pdf_logo_path'];
        $aobj_context->FUNIVCODE = $lobj_get_coll_name['FUNIVCODE'];

$this->current_date = $obj['now_date'];
        $deggrp = $this->aobj_context->mobj_data["deggrp"];

$get_coll_name = "select concat(fdeggrp, ' - ', fdescpn) as fdeggrp 
        from deggrp where fdeggrp = '{$deggrp}'";
        $lobj_get_degree = $this->aobj_context->pobj_db->GetRow($get_coll_name);
        
        $aobj_context->deggrp = $lobj_get_degree['fdeggrp'];
        $this->pdf = new MYPDF('P');
        $this->pdf->aobj_context = $aobj_context;
    }

public function Report($res3,$result1,$res2,$admfee,$resbill)
    {
        
        $pdf = $this->pdf;
        $pdf->SetMargins(15, 25);
        $pdf->startPageGroup();
        $pdf->AddPage("P");
        
        
        $pdf->SetFont('Times','B',13);
        $pdf->Cell(0, 5,$resbill['fexamdate'].' EXAMINATION', '0', 1, 'C');
        $pdf->ln(3);
        $pdf->SetFont('Times','',10);

// if($res3 == 'INTERNAL'){

//     $pdf->SetFont('Times','BU',15);
        //     $pdf->Cell(0, 7, 'There is no Bill for Internal Examiners', '0', 1, 'C');
        //     return;

// }

;

if($this->aobj_context->FUNIVCODE == '040')
 {
 $table1 = '<style>
 td {
 border: 0.5px solid black;
 }
 .lable {
 font-weight: bold;
 }
 </style>
 <table cellpadding="3" cellspacing="0">
 <tr nobr="true">
 <td width="135" style="text-align: left;">Bill No</td>

<td width="165" style="text-align: left;">'.$resbill['fbillno'].'</td>

<td width="105" style="text-align: left;">Bill Date</td>
 <td width="135" style="text-align: left;">'.$this->current_date.'</td>

</tr>';
 }else
 {
 $table1 = '<style>
 td {
 border: 0.5px solid black;
 }
 .lable {
 font-weight: bold;
 }
 </style>
 <table cellpadding="3" cellspacing="0">
 <tr nobr="true">
 <td width="135" style="text-align: left;">Bill No</td>

<td width="165" style="text-align: left;">'.$resbill['fbillno'].'</td>

<td width="105" style="text-align: left;">Bill Date</td>
 <td width="135" style="text-align: left;">'.$resbill['fbilldate'].'</td>

</tr>';
 }

// <td width="105" style="text-align: left;">Status</td>
 // <td width="135" style="text-align: left;">'.$res3['fscale'].'</td>

$table1 .='<tr nobr="true">
 <td width="135" style="text-align: left;">Teacher Name</td>
 
 <td width="405" style="text-align: left;">'.$res3['fteachname'].'</td>

</tr>';

$table1 .='<tr nobr="true">
 <td width="135" style="text-align: left;">Examiner Type</td>
 
 <td width="165" style="text-align: left;">'.$res3['FEXAMINER'].'</td>
 
 <td width="105" style="text-align: left;">Board</td>
 <td width="135" style="text-align: left;">'.$res3['fboard'].'</td>

</tr>';

if($this->aobj_context->FUNIVCODE == '040')
{
 $table1 .='<tr nobr="true">
 <td width="135" style="text-align: left;">Department</td>
 
 <td width="405" style="text-align: left;">'.$res3['FDEPTCODE'].'</td>
 
 </tr>';
 $table1 .='<tr nobr="true">
 <td width="135" style="text-align: left;">College</td>
 
 <td width="405" style="text-align: left;">'.$res3['FCOLLEGE'].'</td>
 
 </tr>';
}

$table1 .='<tr nobr="true">
 <td width="135" style="text-align: left;">Address</td>
 
 <td width="405" style="text-align: left;">'.$res3['faddress'].'</td>
 
</tr>';

$table1 .='<tr nobr="true">
<td width="135" style="text-align: left;">Mobile No</td>

<td width="165" style="text-align: left;">'.$res3['fmobile'].'</td>

<td width="105" style="text-align: left;">E Mail</td>
<td width="135" style="text-align: left;">'.$res3['femail'].'</td>

</tr>';

$table1 .='<tr nobr="true">
<td width="135" style="text-align: left;">PAN No</td>

<td width="165" style="text-align: left;">'.$res3['fpanno'].'</td>

<td width="105" style="text-align: left;">Aadhar No</td>
<td width="135" style="text-align: left;">'.$res3['faadharno'].'</td>

</tr>';

$table1 .='<tr nobr="true">
<td width="135" style="text-align: left;">Bank Account No</td>

<td width="165" style="text-align: left;">'.$res3['faccno'].'</td>

<td width="105" style="text-align: left;">IFSC Code</td>
<td width="135" style="text-align: left;">'.$res3['fifsccode'].'</td>

</tr>';

if($this->aobj_context->FUNIVCODE == '040')
{
 $table1 .='<tr nobr="true">
 <td width="135" style="text-align: left;">Date of Valuation</td>
 
 <td width="405" style="text-align: left;">'.$res3['fvaldates'].'</td>
 
</tr>';
}

$table1 .= '</table>';

$pdf->SetX(11);
    
    $pdf->writeHTML($table1, false, true, false, false, 'L');

$pdf->ln(3);
        $pdf->SetFont('Times', 'B', 13);
        if($this->aobj_context->FUNIVCODE == '033')
        {
            $pdf->Cell(0, 5, 'HONORARIUM / DAILY ALLOWANCE', '0', 1, 'C');
        }else if($this->aobj_context->FUNIVCODE == '027')
        {
            $pdf->Cell(0, 5, 'Details of Allowance (HOA : 5204)', '0', 1, 'C');
        }else if($this->aobj_context->FUNIVCODE == '040')
        {
            $pdf->Cell(0, 5, 'Details of Remuneration', '0', 1, 'C');
        }
        else
        {
            $pdf->Cell(0, 5, 'Details of Allowance', '0', 1, 'C');
        }

$pdf->SetFont('Times', '', 14);

$pdf->SetFont('Times','',10);
		$x = $pdf->GetX();
		$y = $pdf->GetY();		
		$pdf->writeHTMLCell(188,0,$x,$y,$html, false,1, false, true, '', false);

$totrem = $res2['fremunration'] + $res2['rfremunration'];

if($this->aobj_context->FUNIVCODE == '040')
{
 if($totrem <$res2['FMINAMOUNT'])
 $totrem = $res2['FMINAMOUNT'];
}

$total = ($totrem) + ($result1['fdaallow']) - ($res2['ftax']);

$i = 1;

$table1 = '<style>
 td {
 border: 0.5px solid black;
 }
 .lable {
 font-weight: bold;
 }
 </style>
 <table cellpadding="3" cellspacing="0">
 <tr nobr="true">
 <td width="35" style="text-align: center;">Sl.No.</td>
 <td width="170" style="text-align: center;">Particulars</td>
 <td width="50" style="text-align: center;">Amount</td>
 <td width="290" style="text-align: center;">Remarks</td>
 </tr>';

$strrem = "Remuneration";
    if($this->aobj_context->FUNIVCODE == '040')
        $strrem = "Paper Valuation";

$revier = ' Scripts Reviewed:&nbsp;'.$res2['rvaluated'].',&nbsp;('.$res2['rvaluated'].'x'.$res2['FREMUNERATION1'].')';
 if($this->aobj_context->FUNIVCODE == '040')
 $revier = "";

$totamtinwords = getNumber($total);
    if($res2['80m'] >0) 
        $res2['FREMUNERATION1'] = $res2['FREMUNERATION1']; 
    else $res2['FREMUNERATION1'] = $res2['FREMUNERATION2'];

$table1 .='<tr nobr="true">
 <td width="35" style="text-align: center;">'.$i.'</td>
 <td width="170">'.$strrem.'</td>
 <td width="50" style="text-align: right;">'.moneyFormatIndia($totrem).'</td>
 <td width="290" >Scripts Valuated:&nbsp;'.$res2['valuated'].',&nbsp;('.$res2['valuated'].'x'.
 $res2['FREMUNERATION1']
 .')'.$revier.'</td>
</tr>';

if($result1['fdaallow'] == '0'){
 
 }else{
 $table1 .='<tr nobr="true">
 <td width="35" style="text-align: center;">'.(++$i).'</td>
 <td width="170">Dearness Allowance</td>
 <td width="50" style="text-align: right;">'.moneyFormatIndia($result1['fdaallow']).'</td>
 <td width="290" >No. of Days : '.$result1['daycnt'].', Add. Days : 0 ('.$result1['FDAAMT'].' X '.$result1['daycnt'].')</td>
 </tr>';

}

if($this->aobj_context->FUNIVCODE != '033' && $this->aobj_context->FUNIVCODE != '040') 
 {
 $table1 .='<tr nobr="true">
 <td width="35" style="text-align: center;">'.(++$i).'</td>
 <td width="170">Tax</td>
 <td width="50" style="text-align: right;">-'.moneyFormatIndia($res2['ftax']).'</td>
 <td width="290" >Tax (on Remuneration) </td>
 </tr>';
 }

$table1 .='<tr nobr="true">
<td width="205" rowspan="2" style="text-align: center;">Total</td>

<td width="50" style="text-align: right;">'.moneyFormatIndia($total).'</td>
<td width="290" >'.$totamtinwords.'</td>
</tr>';

$table1 .= '</table>';

$pdf->SetX(11);
    
    $pdf->writeHTML($table1, false, true, false, false, 'L');

if($this->aobj_context->FUNIVCODE == '033')
    {
        $totamtwrds =  $total;
        $totamtinwords = getNumber($totamtwrds);

// var_dump($totamtinwords);
        $pdf->ln(2);
        $pdf->SetFont('Times','',11);
        $pdf->Cell(30, 5,'Amount in Words: ',0, 0, 'L');
        $pdf->SetFont('Times','BU',11);
        $pdf->Cell(0, 5,trim($totamtinwords),0, 1, 'L');
        $pdf->ln(2);
        $pdf->SetFont('Times','',10);

$str = "Certified that :
        I)   Particulars provided herewith are correct & I have not claimed TA/DA/CA for this journey/purpose from any other source.
        II)  I was not provided lodging and / or Boarding at the cost of Govt. College (Autonomous), Kalaburagi.
        III) I have travelled by shortest route.

The above Meeting / Journey claim is verified to be true & correct                 Signature of the Claimant
                
        Sign & Name of the Chairman / Custodian";
	
		$pdf->SetFont('Times','',12);
		$pdf->MultiCell(186,4,$str,1,'L');

$pdf->ln(6);
        $pdf->SetFont('Times','B',13);

$pdf->Cell(200, 5,'FOR USE BY ACCOUNTS OFFICE ONLY',0, 1, 'C');
        $pdf->ln(2);

$pdf->SetFont('Times','',10);

$str = " 
        Head of Account.....................................Passed for Ra.....................Vide Vr. No...............Dated..............

(In words.....................................................................................................................................................) 
		
		Section Clerk                                                                                                                              Principal";
	
		$pdf->SetFont('Times','',12);
		$pdf->MultiCell(186,4,$str,1,'L');
    }else
    {

$pdf->Ln(3); 
        $pdf->SetFont('Times', '', 9);

$pdf->Cell(0, 5, '1. Certified that this amount is not claimed in any of the previous bills.', '0', 1, 'L');
        $pdf->Cell(0, 5, '2. Certified that the order copy and attendance certificate is enclosed.', '0', 1, 'L');
        $pdf->Cell(0, 5, '3. I do hereby declare that the information mentioned above is correct & true.', '0', 1, 'L');

// $html = "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1. Certified that this amount is not claimed in any of the previous bills. 
 // &nbsp;&nbsp;&nbsp;2. Certified that the order copy and attendance certificate is enclosed. 
 // &nbsp;&nbsp;&nbsp;3. I do hereby declare that the information mentioned above is correct & true.";
 // $x = $pdf->GetX();
 // $y = $pdf->GetY();
 // $pdf->writeHTMLCell(180,0,$x,$y,$html, false,1, false, true, '', false);

$x = $pdf->GetX();
        $y = $pdf->GetY();
        $pdf->Rect($x-5,$y+13,192,40,'D');
            $pdf->Ln(5); 
            $pdf->SetFont('Times','B',11);
            $pdf->Cell(50,7,'Sign. of the Valuator',0,0,'L');

$pdf->Cell(80,7,'Sign. of the Chairman',0,0,'C');
            // $pdf->Ln(12); 
            // $pdf->SetFont('
            $pdf->Cell(60,7,'Sign. of the Chief Custodian',0,1,'R');
            $pdf->ln(5);
            $pdf->SetFont('Times', 'BU', 15);
            $pdf->Cell(0, 5, 'For Examination Section Use Only', 0, 1, 'C');

$pdf->ln(5);
            $pdf->SetFont('Times', '', 11);
            $pdf->Cell(0, 5, 'Payment of Rs.___________ (In Words)___________________________ is approved on ________________.', '0', 1, 'L');

// $html = "Payment of Rs.______________________ (In Words)________________ is approved on ________________.";
 $x = $pdf->GetX();
 $y = $pdf->GetY();
 // $pdf->writeHTMLCell(180,0,$x,$y,$html, false,1, false, true, '', false);

$pdf->Ln(5); 
        $pdf->SetFont('Times','B',11);
        
        $pdf->Cell(180,5,'Asst. Reg. / Dy. Reg. / Registrar (Evaluation)',0,1,'R');

$x = $pdf->GetX();
        $y = $pdf->GetY();

$pdf->Rect( $x-5,$y+10,192,35,'D');
        $pdf->ln(10);
        $pdf->SetFont('Times', 'BU', 15);
        $pdf->Cell(0, 5, 'For Finance Section Use Only', '0', 1, 'C');

$pdf->ln(5);
        $pdf->SetFont('Times', '', 11);
        $pdf->Cell(0, 7, 'Payment of Rs.___________(In Words)______________________________ is passed on ________________.', '0', 1, 'L');

// $html = "Payment of Rs.______________________(In Words)___________________ is passed on ________________.";
 $x = $pdf->GetX();
 $y = $pdf->GetY();
 // $pdf->writeHTMLCell(180,0,$x,$y,$html, false,1, false, true, '', false);

$pdf->Ln(5); 
    $pdf->SetFont('Times','B',11);

$pdf->Cell(180,7,'Asst. Reg. / Dy. Reg. / Finance Officer',0,1,'R');

$x = $pdf->GetX();
    $y = $pdf->GetY();

$pdf->Ln(2); 
    $pdf->SetFont('Times','BU',12);

$pdf->Cell(180,9,'Note:',0,1,'L');

$pdf->SetFont('Times','',9);

if($this->aobj_context->FUNIVCODE == '040')
 {
 $html = " 01.&nbsp;&nbsp;The amount paid as per this bill is subjected to the final decision
 of the finance section. 
 02.&nbsp;&nbsp;PAN number is must for receiving remuneration. The tax amount deducted should be submitted to the Income &nbsp;&nbsp;Tax office before the due date. 
 03.&nbsp;&nbsp;30% remuneration amount may be deducted from the total amount if the Valuator fails to submit the PAN number and only TA and &nbsp;&nbsp;DA may be paid. 
 04.&nbsp;&nbsp;The amount will be recovered, If audit objections are raised.";
 }else
 {
 $html = " 01.&nbsp;&nbsp;The amount paid as per this bill is subjected to the final decision
 of the finance section. 
 02.&nbsp;&nbsp;PAN number is must for receiving remuneration. The tax amount deducted should be submitted to the Income &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Tax office before the due date. 
 03.&nbsp;&nbsp;20% remuneration amount may be deducted from the total amount if the Valuator fails to submit the &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PAN number and only TA and DA may be paid. 
 04.&nbsp;&nbsp;The amount will be recovered, If audit objections are raised.";
 }

$x = $pdf->GetX();
    $y = $pdf->GetY();
    $pdf->writeHTMLCell(180,0,$x,$y,$html, false,1, false, true, '', false);

}

public function SendOutput()
    {
        // ob_end_clean();
        $this->pdf->Output("VALUATION_BILL.pdf", "I");
    }
}

function generatebill_new($aobj_context)
{
    $univcode = $aobj_context->mobj_data["univcode"];
    $fdegreegrp = $aobj_context->mobj_data["fdegreegrp"];
    $fboard = $aobj_context->mobj_data["fboard"];
    $fvalno = $aobj_context->mobj_data["fvalno"];
    $teachrngfrm = $aobj_context->mobj_data["teachrngfrm"];
    $teachrngto = $aobj_context->mobj_data["teachrngto"];
    $type = $aobj_context->mobj_data["type"];
    $fteachcode = $aobj_context->mobj_data["fteachcode"];
    $year = $aobj_context->mobj_data["year"];
    $examtype = $aobj_context->mobj_data["examtype"];

// var_dump($univcode);
    // die();

if($fteachcode == '90001')
        $fteachcode = '16902';

if($type == 'T'){
    $query_teach = "select distinct ifnull(t.fteachcode,'') as fteachcode,
    ts.fyear,ts.fexamtype,
    dg.FEXAMDATE
    from tdvs_masteach t 
    inner join tdvs_tabsum ts on t.fteachcode = ts.fteachcode 
    inner join tdvs_masqp m on m.fqpcode = ts.fqpcode  
    inner join tdvs_deggrp dg on m.fdeggrp = dg.fdeggrp
    where t.fteachcode = '{$fteachcode}'
    and ifnull(t.fbill,'F') = 'T'
    union
    select distinct ifnull(t.fteachcode,'') as fteachcode,
    ts.fyear,ts.fexamtype,
    dg.FEXAMDATE
    from tdvs_masteach t 
    inner join tdvs_tabsum ts on t.fteachcode = ts.frevcode 
    inner join tdvs_masqp m on m.fqpcode = ts.fqpcode
    inner join tdvs_deggrp dg on m.fdeggrp = dg.fdeggrp  
    where ts.frevcode = '{$fteachcode}'
    and ifnull(t.fbill,'F') = 'T'
    and ifnull(ts.fbillno,'') = ''
    ";
    // var_dump($query_teach);
    // die();

}else{
    $query_teach = "select distinct ifnull(t.fteachcode,'') as fteachcode,
    dg.FEXAMDATE
    from tdvs_masteach t 
    inner join tdvs_tabsum ts on t.fteachcode = ts.fteachcode 
    inner join tdvs_masqp m on m.fqpcode = ts.fqpcode  
    inner join tdvs_deggrp dg on m.fdeggrp = dg.fdeggrp
    where t.fteachcode between '{$teachrngfrm}' and '{$teachrngto}'
    and m.fdeggrp = '{$fdegreegrp}'
    and m.fboard = '{$fboard}'
    and ts.fyear='{$year}' and ts.fexamtype='{$examtype}'
    and ifnull(ts.fbillno,'') = ''
    and ifnull(t.fbill,'F') = 'T'";
    // var_dump($query_teach);
    // die();
}

$res_teach = $aobj_context->pobj_db->GetAll($query_teach);

$class_obj = new ReprtObject();
    $class_obj->univcode = $univcode;
    $class_obj->DefaultConstructor($aobj_context);

if($res_teach)
    {

}else
    {
        $class_obj->Report("INTERNAL","INTERNAL","INTERNAL","INTERNAL","INTERNAL");
    }

foreach($res_teach as $key => $value){

$teachrngfrm = $value['fteachcode'];
        $FEXAMDATE = $value['FEXAMDATE'];
        
        if($type == 'T')
        {
            $year = $value['fyear'];
            $examtype = $value['fexamtype'];
        }

$query = "select distinct d.fdeggrp,now() as fbilldate,ts.fteachcode,ts.fyear,ts.fexamtype,
        d.fexamdate
        from tdvs_tabsum ts inner join tdvs_masqp m on ts.fqpcode = m.fqpcode
        inner join tdvs_deggrp d on d.fdeggrp = m.fdeggrp
        where ts.fteachcode = '{$teachrngfrm}' and ts.fyear = '{$year}' 
        and ts.fexamtype = '{$examtype}'";
        $ressumbill = $aobj_context->pobj_db->GetRow($query);

$fdeggrp = $ressumbill['fdeggrp'];
        $fbilldate = $ressumbill['fbilldate'];
        $fteachcode = $ressumbill['fteachcode'];
        $fyear = $ressumbill['fyear'];
        $fexamtype = $ressumbill['fexamtype'];
        $fexamdate = $ressumbill['fexamdate'];

//    $qry = "INSERT IGNORE INTO tdvs_tadabill (fdeggrp,fbilldate,fteachcode,fyear,fexamtype,fexamdate)
//    values('{$fdeggrp}',now(),'{$fteachcode}','{$fyear}','{$fexamtype}','{$fexamdate}')";
//    $result = $aobj_context->pobj_db->Execute($qry);

//    $qrybill = "select ifnull(d.fyear,'') as fyear,ifnull(d.fexamtype,'') as fexamtype,
//    ifnull(d.fexamdate,'') as fexamdate , b.fbillno, date_format(fbilldate,'%d/%m/%Y') as fbilldate
//    from tdvs_tabsum ts inner join tdvs_masqp m on ts.fqpcode = m.fqpcode
//    inner join tdvs_deggrp d on d.fdeggrp = m.fdeggrp
//    inner join tdvs_tadabill b on ts.fteachcode = b.fteachcode and ts.fyear = b.fyear 
//    and ts.fexamtype = b.fexamtype
//    where b.fteachcode = '{$teachrngfrm}' and ts.fyear =  '{$year}' 
//    and ts.fexamtype = '{$examtype}'";

//    $resbill = $aobj_context->pobj_db->GetRow($qrybill);

$boardcnd = "and m.fboard = '{$fboard}'"; 
    $boardcnd1 = "and mq.fboard = '{$fboard}'"; 
    
    if($fboard ==NULL)
    {    
        $boardcnd = "";
        $boardcnd1 = "";
    }

$query1 = "select  d.FDAAMT,
    count(distinct date_format(fdate,'%Y-%m-%d')) as daycnt,(count(distinct date_format(fdate,'%Y-%m-%d'))*d.FDAAMT) as fdaallow
    from tdvs_tabsum s inner join tdvs_masqp m on s.fqpcode = m.fqpcode
    inner join tdvs_deggrp d on m.fdeggrp = d.fdeggrp
    where ifnull(fstatus,'') = 'final' 
    and ifnull(s.fbillno,'') = ''
    {$boardcnd}
    and fteachcode = '{$teachrngfrm}'";

$result1 = $aobj_context->pobj_db->GetRow($query1);
 
 
 $query2 = "select sum(a.valuated) as valuated,ifnull(c.rvaluated,0) as rvaluated,
 ifnull(c.rfremunration,0) as rfremunration, ifnull(c.r40m,0) as r40m,
 ifnull(c.r80m,0) as r80m,
 sum(a.fremunration) as fremunration,sum(a.40) as 40m,
 sum(a.80) as 80m,
 a.FMINAMOUNT,
 round(((sum(a.fremunration)+ifnull(c.rfremunration,0))*a.ftax)) as ftax,a.FREMUNERATION1,a.FREMUNERATION2
 from (select d.fdeggrp,d.FREMUNERATION1,d.FREMUNERATION2,d.FMINAMOUNT,
 d.ftax as ftax,
 count(distinct s.fregcode,s.fvalno) as valuated,
 (count(distinct s.fregcode,s.fvalno)*
 if(ifnull(m.fhours,'3') = '3',d.FREMUNERATION1,d.FREMUNERATION2)) as fremunration,
 sum(if(ifnull(m.fhours,'3') = '3',1,0)) as '80',
 sum(if(ifnull(m.fhours,'3') < '3',1,0)) as '40'
 from tdvs_tabsum s inner join tdvs_masqp m on s.fqpcode = m.fqpcode
 inner join tdvs_deggrp d on m.fdeggrp = d.fdeggrp
 where ifnull(fstatus,'') = 'final' and fteachcode = '{$teachrngfrm}'
 and ifnull(s.fbillno,'') = ''
 and s.fyear = '{$year}' and s.fexamtype = '{$examtype}'
 {$boardcnd}
 group by m.fqpcode
 order by m.fhours) a, 
 (select sum(b.rvaluated) as rvaluated,sum(b.fremunration) as rfremunration,
 sum(b.40) as r40m, sum(b.80) as r80m
 from (select d.fdeggrp,d.FREMUNERATION1,d.FREMUNERATION2,
 d.ftax as ftax,
 count(distinct s.fregcode) as rvaluated,
 (count(distinct s.fregcode)*
 if(ifnull(m.fsmaxmarks,'80') = '40',d.FREMUNERATION2,d.FREMUNERATION1)) as fremunration,
 sum(if(ifnull(m.fsmaxmarks,'') = '40',1,0)) as '40',
 sum(if(ifnull(m.fsmaxmarks,'') = '40',0,1)) as '80'
 from tdvs_tabsum s inner join tdvs_masqp m on s.fqpcode = m.fqpcode
 inner join tdvs_deggrp d on m.fdeggrp = d.fdeggrp
 where ifnull(frevstatus,'') = 'final' and frevcode = '{$teachrngfrm}'
 and s.fyear = '{$year}' and s.fexamtype = '{$examtype}'
 group by m.fqpcode)b) c";
 // var_dump($query2);
 // die();
 $res2 = $aobj_context->pobj_db->GetRow($query2);

$query3 = "select concat(m.fteachcode,' - ',ifnull(fteachname,'')) as fteachname,ifnull(fscale,'') as fscale,
    CONCAT(ifnull(faddress1,''),' ',ifnull(faddress2,''),' ',ifnull(faddress3,''),' ',ifnull(faddress4,'')) as faddress, 
    ifnull(faadharno,'') as faadharno,
    ifnull(fpanno,'') as fpanno,ifnull(faccno,'') as faccno,ifnull(fifsccode,'') as fifsccode,ifnull(femail,'') as femail,
    ifnull(fmobile,'') as fmobile,ifnull(mq.fboard,'') as fboard,
    ifnull(m.FDEPTCODE,'') as FDEPTCODE,  ifnull(m.FCOLLEGE,'') as FCOLLEGE,
    ifnull(fbankname,'') as fbankname,ifnull(FEXAMINER,'') as FEXAMINER,
    group_concat(distinct date_format(s.FENDATE,'%d/%m/%Y') order by s.FENDATE SEPARATOR ', ') as fvaldates 
	from tdvs_masteach m inner join tdvs_tabsum s on m.fteachcode = s.fteachcode
    join tdvs_masqp mq on s.fqpcode = mq.fqpcode
    where  m.fteachcode = '{$teachrngfrm}'
    and ifnull(s.fbillno,'') = ''
    and s.fyear = '{$year}' and s.fexamtype = '{$examtype}'
    {$boardcnd1}
    group by m.fteachcode";
    $res3 = $aobj_context->pobj_db->GetRow($query3);

$fvaldates = $res3['fvaldates'];
    $totrem = $res2['fremunration'] + $res2['rfremunration'];

if($totrem <$res2['FMINAMOUNT'])
 $totrem = $res2['FMINAMOUNT'];

$total = ($totrem) + ($result1['fdaallow']) - ($res2['ftax']);

if($res2['80m'] >0) 
        $res2['FREMUNERATION1'] = $res2['FREMUNERATION1']; 
    else 
        $res2['FREMUNERATION1'] = $res2['FREMUNERATION2'];
    
    $cnd10 = "";
    var_dump($res2['40m']);
    
    if($res2['40m'] > 0)
        $cnd10 = " (".$res2['40m'].'x'.$res2['FREMUNERATION2'].")";
        var_dump($cnd10);
        die();
    $remarks = 'Scripts Valuated:&nbsp;'.$res2['valuated'].',&nbsp;('.$res2['80m'].'x'.$res2['FREMUNERATION1'].')'.$cnd10;

$query = "insert into tdvs_payhead(FYEAR,FEXAMTYPE,FEXAMDATE,FBOARD,FDEGGRP,FBILLDATE,FTEACHCODE,FDAYS,
    FTOTAL,FCREATDATE)
    values('{$year}','{$examtype}','{$FEXAMDATE}','{$fboard}','{$fdegreegrp}',now(),'{$teachrngfrm}','{$fvaldates}','{$total}',now())";
    $result = $aobj_context->pobj_db->Execute($query);
    $billno = $aobj_context->pobj_db->insert_id();

$qry = "INSERT IGNORE INTO tdvs_paydetl (FBILLNO,FTEACHCODE,FHEADCODE,FAMOUNT,FREMARKS,FCREATEDATE)
    values('{$billno}','{$fteachcode}','Paper Valuation','{$total}','{$remarks}',NOW())";
    $result = $aobj_context->pobj_db->Execute($qry);

$update = "update tdvs_tabsum ts, tdvs_masqp m set ts.fbillno = '{$billno}'
    where ts.fqpcode = m.fqpcode and ts.fteachcode = '$fteachcode'
    and ts.fyear = '{$year}' and ts.fexamtype = '{$examtype}'
    and ifnull(ts.fstatus,'') ='FINAL'
    and ifnull(ts.fbillno,'') = ''
    and m.fdeggrp = '{$fdegreegrp}' and m.fboard = '{$fboard}'";
    $result = $aobj_context->pobj_db->Execute($update);

//$class_obj->Report($res3,$result1,$res2,$admfee,$resbill);

}
    
    $class_obj->SendOutput();

}

${this.title}

Code Editor : generatebill_new.php