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.148.105.152
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 : getdata.php
<?php function getCollegeNames($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $coll_code = $aobj_context->mobj_data["coll_code"]; $qry="select FCOLLCODE,concat(FCOLLNAME,', ',FTOWN) as FCOLLNAME from college where FCOLLCODE='{$coll_code}'"; $lobj_rs = $aobj_context->mobj_db->GetRow($qry); if($lobj_rs) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure"); return; } function GetQpCode($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $coll_code = $aobj_context->mobj_data["coll_code"]; $qp_code = $aobj_context->mobj_data["qp_code"]; $collcode=$_SESSION['collcode'] ; $qry = "SELECT distinct ms.FQPCODE,FSUBNAME,FMAXMARKS FROM masqp ms inner join valqp v on v.FQPCODE=ms.FQPCODE where ms.FQPCODE='{$qp_code}' and v.FCOLLCODE='{$collcode}'"; $lobj_qp_code = $aobj_context->mobj_db->GetRow($qry); if($lobj_qp_code) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_qp_code,0,"success"); } else { $err_data="Invalid Qp Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return ; } function SelectSubjectQpCode($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $qp_code = $aobj_context->mobj_data["qp_code"]; $module_name_for_save = $aobj_context->mobj_data["module_name_for_save"]; session_start(); $college_code = $_SESSION['collcode']; $FUNIVCODE = $_SESSION['FUNIVCODE']; /* if($FUNIVCODE == '026') { $field = " cs.FCNTRCODE='{$college_code}'"; }else { $field = "cd.FCOLLCODE='{$college_code}'"; } */ if($module_name_for_save!="Room Allotment") { $qry="select DISTINCT su.FQPCODE as id,FQPCODE,su.FSUBCODE,concat(su.FSUBNAME,' ',su.FSSUBNAME) as FSSUBNAME, date_format(su.FDOE,'%d/%m/%Y') as FDOE,CASE WHEN LEFT(FSESSION,1)='M' THEN 'AM' ELSE 'PM' END AS FSESSION from subject su inner join canddet cd on su.fdegree = cd.fdegree and su.fexamno = cd.fexamno and su.fsubcode = cd.fsubcode where TRIM(su.FQPCODE)<>'' and FTHEORY='T' and FINTASS<>'T' and FQPCODE='{$qp_code}' group by su.FQPCODE"; $lobj_qp_code = $aobj_context->mobj_db->GetRow($qry); } else { $get_student_cnt ="SELECT COUNT(DISTINCT cd.FREGNO) AS reg_cnt FROM canddet cd INNER JOIN subject s ON s.fdegree = cd.fdegree and s.fexamno = cd.fexamno and s.FSUBCODE=cd.FSUBCODE inner join candsum cs on cs.FREGNO=cd.FREGNO AND cd.FDEGREE=cs.FDEGREE AND cd.FCOLLCODE=cs.FCOLLCODE WHERE cs.FCNTRCODE='{$college_code}' and TRIM(s.FQPCODE)='{$qp_code}' and ifnull(cd.fpassmth,'') = '' AND cd.FPRESENT='P' AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00'"; //var_dump($get_student_cnt); $lobj_get_student_cnt = $aobj_context->mobj_db->GetRow($get_student_cnt); $reg_cnt=$lobj_get_student_cnt['reg_cnt']; $qry="select '{$reg_cnt}' as reg_cnt, FQPCODE as id,FQPCODE,su.FSUBCODE, concat(su.FSUBNAME,' ',su.FSSUBNAME) as FSSUBNAME, date_format(su.FDOE,'%d/%m/%Y') as FDOE, if(ifnull(FSESSION,'')<>'',if(FSESSION = FREASONCD,FDESCPN,FSESSION),FSESSION) as FSESSION from subject su inner join canddet cd on su.fdegree = cd.fdegree and su.fexamno = cd.fexamno and su.fsubcode = cd.fsubcode left join reason on su.FSESSION = reason.FREASONCD where TRIM(FQPCODE)<>'' and su.FQPCODE='{$qp_code}' group by su.FQPCODE"; //var_dump($qry); $lobj_qp_code = $aobj_context->mobj_db->GetRow($qry); } if($lobj_qp_code) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_qp_code,0,"success"); } else { $err_data="Invalid Qp Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return ; } function SelectDeptCode($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $FDEPTCODE = $aobj_context->mobj_data["FDEPTCODE"]; $collcode=$_SESSION['collcode'] ; $qry="SELECT FDEPTCODE,FDEPTNAME FROM masdept where FDEPTCODE='{$FDEPTCODE}'"; // echo $qry; die(); $lobj_qp_code = $aobj_context->mobj_db->GetRow($qry); if($lobj_qp_code) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_qp_code,0,"success"); } else { $err_data="Invalid DEPT Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return ; }function SelectDesCode($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $FDEGNCODE = $aobj_context->mobj_data["FDEGNCODE"]; $collcode=$_SESSION['collcode'] ; $qry="SELECT FDEGNCODE,FDEGNDESC FROM masdegn where FDEGNCODE='{$FDEGNCODE}'"; // echo $qry; die(); $lobj_qp_code = $aobj_context->mobj_db->GetRow($qry); if($lobj_qp_code) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_qp_code,0,"success"); } else { $err_data="Invalid Qp Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return ; } function GetVivaSubjectDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $degcode = $aobj_context->mobj_data["degcode"]; $subcode = $aobj_context->mobj_data["subcode"]; $exam_no = $aobj_context->mobj_data["exam_no"]; $qry="select pm.FVVCODE,s.FSUBNAME,fvalmax as fsmaxmarks from practical_master pm inner join subject s on s.FEXAMNO=pm.FEXAMNO and s.FDEGREE=pm.FDEGREE and s.FCSUBCODE=pm.FVVCODE where pm.FDEGREE='{$degcode}' and pm.FEXAMNO='{$exam_no}' and pm.FPRCODE='{$subcode}' and pm.FVVCODE!=''"; // echo $qry;die(); $lobj_rs = $aobj_context->mobj_db->GetRow($qry); if($lobj_rs) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); return; } else { $err_data="No Viva Subject"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); return; } } function getSubjectNameForDispatchScript($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $subject_code = $aobj_context->mobj_data["subject_code"]; $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $get_sub_names="select FCSUBCODE,FSUBNAME from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and FCSUBCODE='{$subject_code}' group by FCSUBCODE"; $lobj_get_sub_names = $aobj_context->mobj_db->getRow($get_sub_names); //echo $get_sub_names; if($lobj_get_sub_names) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_sub_names,0,"success"); return; } else { $err_data="Invalid Subject Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); return; } } function getdegreeNames($aobj_context) { /* session_start(); $college_code = $_SESSION['collcode']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $degree_code=trim($aobj_context->mobj_data["degree_code"]); $mod_type=trim($aobj_context->mobj_data["type"]); $userid = $_SESSION['user_id']; if($mod_type == 'FCADSTATUS') { //$fadmdeg = "and fadmdeg = 'T'"; $fadmdeg = "inner join mascomb mc on c.fdegree = mc.fdegree "; }else { //$fadmdeg = " and 1=1"; $fadmdeg = " "; } //echo $mod_type; die(); if(strtoupper($_SESSION['usr']) =='ADMIN' || strtoupper($_SESSION['usr']) =='SUPER') { $ltable = "inner join degree d on d.FDEGREE=c.FDEGREE and FCOLLCODE='{$college_code}'"; } else { $ltable = "inner join degree d on d.FDEGREE=c.FDEGREE and c.FCOLLCODE='{$college_code}' inner join usersub us on d.fdegree = us.fdegree and c.fcollcode = us.fcollegecode and us.fuser = '{$userid}'"; } if(strtolower($college_code) === 'lsys') { $get_name_by_degree_code =" select c.FDEGREE,d.FDESCPN from colldeg c {$ltable} and c.FDELETED <> 'T' {$fadmdeg} group by FDEGREE"; $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if($lobj_get_name) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); } else { $err_data="Invalid Degree Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return; } else { if($mod_type== '') { $get_name_by_degree_code=" select c.FDEGREE,d.FDESCPN from colldeg c {$ltable} and c.FDELETED <> 'T' {$fadmdeg} group by FDEGREE"; $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); //var_dump($get_name_by_degree_code); if($lobj_get_name) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); } else { $err_data="Invalid Degree Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return; } else { $field_name = "c.{$mod_type}"; //$cond= "and c.{$mod_type} is NULL"; $get_name_by_degree_code=" select c.FDEGREE,d.FDESCPN, ifNULL({$field_name},'NOTFREEZED') as type from colldeg c {$ltable} and c.FDELETED <> 'T' and FCOLLCODE = '{$college_code}' {$fadmdeg} group by FDEGREE "; //echo $get_name_by_degree_code; $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if(($lobj_get_name['type'] == 'NOTFREEZED')&& $lobj_get_name) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); } else if(($lobj_get_name['type'] != 'NOTFREEZED')&& $lobj_get_name) { $err_data="Already Freezed By Admin"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } else { $err_data="Invalid Degree Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return; } } */ session_start(); $college_code = $_SESSION['collcode']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $degree_code=trim($aobj_context->mobj_data["degree_code"]); $mod_type=trim($aobj_context->mobj_data["type"]); // if($mod_type == 'FCADSTATUS') // { // //$fadmdeg = "and fadmdeg = 'T'"; // $fadmdeg = "inner join mascomb mc on c.fdegree = mc.fdegree "; // }else // { //$fadmdeg = " and 1=1"; $fadmdeg = " "; // } //echo $mod_type; die(); if(strtolower($college_code) === 'lsys') { $get_name_by_degree_code =" select c.FDEGREE,d.FDESCPN from colldeg c inner join degree d on d.FDEGREE=c.FDEGREE and c.FDEGREE='{$degree_code}' and c.FDELETED <> 'T' {$fadmdeg} group by FDEGREE"; $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if($lobj_get_name) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); } else { $err_data="Invalid Degree Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return; } else { if($mod_type== '') { $get_name_by_degree_code=" select c.FDEGREE,d.FDESCPN, d.fdeggrp from colldeg c inner join degree d on d.FDEGREE=c.FDEGREE and c.FDEGREE='{$degree_code}' and c.FCOLLCODE='{$college_code}' and c.FDELETED <> 'T' {$fadmdeg} group by FDEGREE"; $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if($lobj_get_name) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); } else { $err_data="Invalid Degree Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return; } else { $field_name = "c.{$mod_type}"; //$cond= "and c.{$mod_type} is NULL"; $get_name_by_degree_code=" select c.FDEGREE,d.FDESCPN, ifNULL({$field_name},'NOTFREEZED') as type from colldeg c inner join degree d on d.FDEGREE=c.FDEGREE and c.FDEGREE='{$degree_code}' and c.FDELETED <> 'T' and FCOLLCODE = '{$college_code}' {$fadmdeg} group by FDEGREE "; // var_dump($get_name_by_degree_code); // die(); //echo $get_name_by_degree_code; $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if(($lobj_get_name['type'] == 'NOTFREEZED')&& $lobj_get_name) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); } else if(($lobj_get_name['type'] != 'NOTFREEZED')&& $lobj_get_name) { $err_data="Already Freezed By Admin"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } else { $err_data="Invalid Degree Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return; } } } function getSubjectCode($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $subject_code=trim($aobj_context->mobj_data["subject_code"]); $get_subject_by_subject_code="select fsubcode,Fsubshort,fsubname from subject where fsubcode='{$subject_code}' and fexamno='A' group by fsubcode "; // echo $get_subject_by_subject_code; $lobj_sub_name = $aobj_context->mobj_db->GetRow($get_subject_by_subject_code); if($lobj_sub_name!= 0) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_sub_name,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_sub_name,-1,"Failure"); return; } function getExamNo($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $exam_no=trim($aobj_context->mobj_data["ExamNo"]); $degree=trim($aobj_context->mobj_data["degree"]); $get_name_by_degree_code="select distinct fexamno,fexamname from degree where fexamno='{$exam_no}' and FDEGREE='{$degree}'"; $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if($lobj_get_name) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure"); return; } function getSubMarkDetails($aobj_context) { session_start(); $univcode = $_SESSION['FUNIVCODE']; $college_code = $_SESSION['collcode']; $userId = $_SESSION['user_id']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Subcode=trim($aobj_context->mobj_data["subcode"]); $Degcode=trim($aobj_context->mobj_data["degcode"]); $examno=trim($aobj_context->mobj_data["exam_no"]); $category=trim($aobj_context->mobj_data["category"]); $module=trim($aobj_context->mobj_data["module"]); $cat_cond=''; if(!empty($module)) { $select_category_cond = "select Value from markentrycodition where FMODULE='{$module}' and Code='{$category}' and FDELETED='F'"; $lobj_select_category_cond = $aobj_context->mobj_db->GetRow($select_category_cond); if(!empty($lobj_select_category_cond) && ($lobj_select_category_cond['Value']!='0' || $lobj_select_category_cond['Value']!=0 )) $cat_cond=" and ".$lobj_select_category_cond['Value']; } if(strtoupper($_SESSION['user_type'])=='ADMIN' || strtoupper($_SESSION['user_type'])=='SUPERUSER' || strtoupper($_SESSION['user_type'])=='BASKARAN') { $get_name_by_degree_code=" select FCSUBCODE, FSUBNAME,FSSUBNAME,FSHORTNAME,fvalmax as FSMAXMARKS,ifnull(FEXAMCNT,'1') as FEXAMCNT from subject s inner join colldeg c on s.FDEGREE = c.FDEGREE and c.fdegree = '{$Degcode}' and s.fexamno='{$examno}' where s.FCSUBCODE='{$Subcode}' and c.FCOLLCODE='{$college_code}' {$cat_cond} "; } else { if($module == 'ME') { $get_name_by_degree_code=" select FCSUBCODE, FSUBNAME,FSSUBNAME,FSHORTNAME,fvalmax as FSMAXMARKS,ifnull(FEXAMCNT,'1') as FEXAMCNT from subject s inner join colldeg c on s.FDEGREE = c.FDEGREE and s.fdegree = '{$Degcode}' and s.fexamno='{$examno}' left join usersub us on (INSTR(us.fsubcode,s.fsubcode) or INSTR(us.FPRSUBCODE,s.fsubcode)) where s.FCSUBCODE='{$Subcode}' and fuser='{$userId}' and us.fdegree = '{$Degcode}' and c.FCOLLCODE='{$college_code}' {$cat_cond} "; //var_dump($get_name_by_degree_code); } else { $get_name_by_degree_code =" select FCSUBCODE, FSUBNAME,FSSUBNAME,FSHORTNAME,fvalmax as FSMAXMARKS,ifnull(FEXAMCNT,'1') as FEXAMCNT from subject s inner join colldeg c on s.FDEGREE = c.FDEGREE and c.fdegree = '{$Degcode}' and s.fexamno='{$examno}' where s.FCSUBCODE='{$Subcode}' and c.FCOLLCODE='{$college_code}' {$cat_cond} "; } } $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); //var_dump($_SESSION['user_type']); //var_dump($get_name_by_degree_code); die(); if($lobj_get_name) { if($module == 'ME') { if($univcode == '052') { $chk_fcsubcode = "select count(*) as count from colldeg where FMESTATUS{$examno} like '%{$Subcode}%' and fdegree='{$Degcode}' and fcollcode='{$college_code}'"; }else { $chk_fcsubcode = "select count(*) as count from collia where fcollcode='{$college_code}' and fdegree='{$Degcode}' and fexamno ='{$examno}' and fsubcode = '{$Subcode}' and (ifnull(ffreezed,'') = 'T' || ifnull(ffreezed,'') = 'L')"; } } else { $chk_fcsubcode = "select count(*) as count from colldeg where FMESTATUS{$examno} like '%{$Subcode}%' and fdegree='{$Degcode}' and fcollcode='{$college_code}'"; } $lobj_chk_fcsubcode = $aobj_context->mobj_db->GetRow($chk_fcsubcode); // echo $chk_fcsubcode; die(); if($lobj_chk_fcsubcode['count']==0 || $module=="PR") { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); } else { $rs_data = "Subject Freezed By Admin"; echo $aobj_context->mobj_output->ToJSONEnvelope($rs_data,-1,"Failure"); } } else { $rs_data = "Invalid Subject Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($rs_data,-1,"Failure"); } return; } function getSubMarkDetailsForPopUp($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Subcode=trim($aobj_context->mobj_data["subcode"]); $get_name_by_dcode_for_popup=" select FCSUBCODE,FSUBNAME,FSSUBNAME,FSHORTNAME,fvalmax as fsmaxmarks from subject s where s.FCSUBCODE='{$Subcode}' "; $lobj_get_name_by_dcode_for_popup = $aobj_context->mobj_db->GetRow($get_name_by_dcode_for_popup); if(!empty($lobj_get_name_by_dcode_for_popup)) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name_by_dcode_for_popup,0,"success"); } else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name_by_dcode_for_popup,-1,"failure"); } return; } function getSubjectCodePopupForAnswerScript($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $degree_code = trim($aobj_context->mobj_data["degree_code"]); $Subcode = trim($aobj_context->mobj_data["subcode"]); $get_name_by_scode_for_popup=" select S.FCSUBCODE,S.FSUBNAME from SUBJECT S WHERE S.FDEGREE='{$degree_code}' and S.FCSUBCODE = '{$Subcode}' "; //echo $get_name_by_scode_for_popup; die(); $lobj_get_name_by_scode_for_popup = $aobj_context->mobj_db->GetRow($get_name_by_scode_for_popup); if($lobj_get_name_by_scode_for_popup) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name_by_scode_for_popup,0,"success"); return; } else { $arr_data="Invalid Subject Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr_data,-1,"Failure"); return; } } function getFullSubjectDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Shortcode=trim($aobj_context->mobj_data["shortcode"]); $Degcode=trim($aobj_context->mobj_data["degcode"]); $examno=trim($aobj_context->mobj_data["examno"]); $get_name_by_degree_code="select fcsubcode,fsubname,fssubname,fshortname,fvalmax as fsmaxmarks from subject where fdegree ='{$Degcode}' and fexamno='{$examno}' and fshortname='{$Shortcode}'"; //echo $get_name_by_degree_code; die(); $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if($lobj_get_name!= 0) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure"); return; } function getStudentRegisterNoName($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Regno=trim($aobj_context->mobj_data["Regno"]); $CollegeCode = $_SESSION['collcode']; $module_name_for_save = $aobj_context->mobj_data["module_name_for_save"]; $collcnd = "and fcollcode = '{$CollegeCode}'"; if(strtolower($CollegeCode) == 'lsys') { $collcnd = ""; } if($module_name_for_save=="SaveAbsentEntrySubjectwiseQP") { $get_name_by_degree_code="select fregno,fname,fdegree from student where fregno='{$Regno}'"; } else { $get_name_by_degree_code="select s.fregno,s.fname,s.fdegree,d.FDESCPN from student s inner join degree d on d.FDEGREE=s.FDEGREE where fregno='{$Regno}' {$collcnd}"; } // echo $get_name_by_degree_code; die(); $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if($lobj_get_name!= 0) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure"); return; } function CheckEnteredRegisterNo($aobj_context) { session_start(); $College_Code = $_SESSION['collcode']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Regno=trim($aobj_context->mobj_data["Regno"]); $module_name_for_save=trim($aobj_context->mobj_data["module_name_for_save"]); if($module_name_for_save == 'Cancel_ANS_Books') { $qpcode=trim($aobj_context->mobj_data["qpcode"]); $condition =" and al.fqpcode = '{$qpcode}' and ifnull(fcancel,'') <> 'T'"; }else { $condition = ""; $fnewansbookno = ""; } $CollegeCode = $_SESSION['collcode']; $id =trim($aobj_context->mobj_data["id"]); $id_split=explode("_",$id); $id=$id_split[3]; $get_name_by_degree_code="select '{$id}' as id,fregno,fname from student where fregno='{$Regno}'"; //var_dump($get_name_by_degree_code); $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if($lobj_get_name) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); else { $lobj_get_name=$id; echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure"); } return; } function getNextRegisterNoName($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Regno=trim($aobj_context->mobj_data["Regno"]); //echo $Regno; die(); $CollegeCode = $_SESSION['collcode']; $get_name_by_degree_code="select fregno,fname from student where fcollcode= '{$CollegeCode}'and fregno>'{$Regno}' order by 1 limit 1"; //echo $get_name_by_degree_code; die(); $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if($lobj_get_name!= 0) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure"); return; } function getCategoryNames($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $id=trim($aobj_context->mobj_data["id"]); $get_category_names="select '{$id}' as id,FCATEGORY as internal_code,FCATEGORY as value from category "; //echo $get_category_names; die(); $lobj_get_category_names = $aobj_context->mobj_db->GetAll($get_category_names); if($lobj_get_category_names!= 0) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_category_names,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_category_names,-1,"Failure"); return; } function getCombinations($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $id=trim($aobj_context->mobj_data["id"]); $db=trim($aobj_context->mobj_data["db"]); $CollegeCode = $_SESSION['collcode']; if($db == 'acu'){ $get_category_names= "select d.fdegree as internal_code,concat(d.fdegree,' - ',d.fdescpn) as value from degree d inner join colldeg c on d.fdegree = c.fdegree and d.fexamno = 'A' where d.fadmdeg = 'T' and ifnull(c.fdeleted,'') <> 'T' and fcollcode = '{$CollegeCode}'"; }else{ $get_category_names="select distinct '{$id}' as id,FCOMBCODE as internal_code,FCOMBDESC as value from mascomb where fdeleted <> 'T' "; } // echo $get_category_names; die(); $lobj_get_category_names = $aobj_context->mobj_db->GetAll($get_category_names); if($lobj_get_category_names!= 0) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_category_names,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_category_names,-1,"Failure"); return; } function isRegNoValid($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $Regno=trim($aobj_context->mobj_data["Regno"]); $CollegeCode = $_SESSION['collcode']; $degree =trim($aobj_context->mobj_data["degree"]); $CollCnd = "and fcollcode= '{$CollegeCode}'"; if( strtolower($CollegeCode) == 'lsys') { $CollCnd = ""; } $get_no = "select s.fregno,s.fname,d.FDEGREE,FDESCPN from student s inner join degree d on d.FDEGREE=s.FDEGREE where fregno='{$Regno}' and ifnull(s.fdeleted,'F') <> 'T' {$CollCnd}"; $lobj_get_name = $aobj_context->mobj_db->GetRow($get_no); if($lobj_get_name) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); else { $lobj_get_name=$id; echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure"); } return; } function GetSubSubjectCategory($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $type = trim($aobj_context->mobj_data["type"]); if($type!='') $where_cond=" where FMODULE='{$type}'"; else $where_cond=' '; $get_Subsubject="SELECT Code,Name from markentrycodition {$where_cond} order by Code"; $lobj_get_subject = $aobj_context->mobj_db->GetAll($get_Subsubject); if($lobj_get_subject) print_r ($aobj_context->mobj_output->ToJSONEnvelope($lobj_get_subject,0,"success")); else print_r ($aobj_context->mobj_output->ToJSONEnvelope($lobj_get_subject,-1,"Failure")); return; } function CheckEnteredstudentSubjectCode($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $Degcode=trim($aobj_context->mobj_data["degcode"]); $examno=trim($aobj_context->mobj_data["exam_no"]); $category=trim($aobj_context->mobj_data["category"]); $Subcode=trim($aobj_context->mobj_data["subcode"]); $module=trim($aobj_context->mobj_data["module"]); $id=trim($aobj_context->mobj_data["id"]); $id_split=explode("_",$id); $id=$id_split[3]; $cat_cond=''; $select_category_cond = "select Value from markentrycodition where FMODULE='{$module}' and Code='{$category}' and FDELETED='F'"; $lobj_select_category_cond = $aobj_context->mobj_db->GetRow($select_category_cond); if($lobj_select_category_cond['Value']!='0' || $lobj_select_category_cond['Value']!=0) $cat_cond=" and ".$lobj_select_category_cond['Value']; $get_name_by_degree_code=" select '{$id}' as id, FCSUBCODE,FSUBNAME,FSSUBNAME,FSHORTNAME,fvalmax as fsmaxmarks from subject s inner join colldeg c on s.FDEGREE = c.FDEGREE and s.fdegree = '{$Degcode}' and s.fexamno='{$examno}' where s.FCSUBCODE='{$Subcode}' and c.FCOLLCODE='{$college_code}' {$cat_cond} "; $lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code); if($lobj_get_name) { $chk_fcsubcode = "select count(*) as count from colldeg where FMESTATUS{$examno} like '%{$Subcode}%' "; $lobj_chk_fcsubcode = $aobj_context->mobj_db->GetRow($chk_fcsubcode); if($lobj_chk_fcsubcode['count']==0) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); } else { $rs_data = "Subject Freezed By Admin"; echo $aobj_context->mobj_output->ToJSONEnvelope($rs_data,-1,"Failure"); } } else { $rs_data =$id; echo $aobj_context->mobj_output->ToJSONEnvelope($rs_data,-1,"Failure"); } return; } function getSectionName($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode=$_SESSION['collcode'] ; $DegCode=trim($aobj_context->mobj_data["degCode"]); $examNo=trim($aobj_context->mobj_data["examNo"]); $section=trim($aobj_context->mobj_data["section"]); $qry="select distinct FSECTION from student where FCOLLCODE='{$collcode}' and FDEGREE='{$DegCode}' and FEXAMNO='{$examNo}' and FSECTION='{$section}' UNION ALL Select 'All' as FSECTION"; $lobj_qp_code = $aobj_context->mobj_db->GetRow($qry); if($lobj_qp_code) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_qp_code,0,"success"); } else { $err_data="Invalid Section Code"; echo $aobj_context->mobj_output->ToJSONEnvelope($err_data,-1,"Failure"); } return ; } function markslistsubjpopup($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $degree=trim($aobj_context->mobj_data["degree"]); $exam=trim($aobj_context->mobj_data["exam"]); /* $sql="select distinct FSUBCODE, FSUBNAME from subject where FDEGREE='{$degree}' and FEXAMNO ='{$exam}'"; //echo $get_no; $lobj_get_name = $aobj_context->mobj_db->GetAll($sql); if($lobj_get_name) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure"); } */ include_once($aobj_context->main_src.'/src/display_details_in_grid_custom.php'); $display_obj = new display_details_in_grid($aobj_context); $display_obj->table_cols = array('FSUBCODE','FSSUBNAME'); $display_obj->display_qry = "select distinct FSUBCODE as id,FSUBCODE,FSUBNAME from subject where FDEGREE='{$degree}' and FEXAMNO ='{$exam}'"; //echo $display_obj->display_qry; die(); $display_obj->DisplayDetailsInGrid(); } function getmarkslistsubjNames($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $subject_code=trim($aobj_context->mobj_data["subject_code"]); $sql="select distinct FSUBCODE, FSUBNAME from subject where FSUBCODE ='{$subject_code}' "; //echo $get_no; $lobj_get_name = $aobj_context->mobj_db->GetRow($sql); if($lobj_get_name) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure"); } } function lastdate_validate($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $FUNIVCODE = $_SESSION['FUNIVCODE']; $screen_type = trim($aobj_context->mobj_data["screen_type"]); $examno = trim($aobj_context->mobj_data["examno"]); $degree = trim($aobj_context->mobj_data["degree"]); if($screen_type == 'IAM') $lstr = "ifnull(FIAFROM,'1990-01-01') AND ifnull(FIATO,'1990-01-01')"; else if($screen_type == 'PR') $lstr = "ifnull(FPRFROM,'1990-01-01') AND ifnull(FPRTO,'1990-01-01')"; else if($screen_type == 'ADM') $lstr = "ifnull(FADMFROM,'1990-01-01') AND ifnull(FADMTO,'1990-01-01')"; else if($screen_type == 'EAF') $lstr = "ifnull(FAPPFROM,'1990-01-01') AND ifnull(FAPPTO,'1990-01-01')"; else if($screen_type == 'HT') $lstr = "ifnull(FHTFROM,'1990-01-01') AND ifnull(FHTTO,'1990-01-01')"; else if($screen_type == 'att') $lstr = "ifnull(fattfrom,'1990-01-01') AND ifnull(fattto,'1990-01-01')"; $query = "select sum(case when DATE_FORMAT(NOW(),'%Y-%m-%d') not between {$lstr} then 1 else 0 end) as flastdate, fsuspend from collexam where fcollcode = '{$college_code}' and fdegree = '{$degree}' and fexamno = '{$examno}' group by fsuspend"; // var_dump($query); $result = $aobj_context->mobj_db->GetRow($query); /* */ if($result['fsuspend'] == 'T') { $arr = "This degree is suspended temporarily"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); } else if(strtoupper($_SESSION['user_type'])=='SUPERUSER') { $arr = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else if($result['flastdate'] > 0) { $arr = "Last date is over for the given details"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"Failure"); } else { $arr = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } } function validatelastdate($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $degree = trim($aobj_context->mobj_data["Degcode"]); $subcode = trim($aobj_context->mobj_data["Subcode"]); $examno = trim($aobj_context->mobj_data["Examno"]); $batch_no = trim($aobj_context->mobj_data["batch_no"]); $batch_no = str_pad($batch_no,2, "0", STR_PAD_LEFT); $query = "select fexamdate,ffreezed,printfreezed,fbatch,fdegree from practical_entry_freeze where fcollcode = '{$college_code}' and fdegree = '{$degree}' and fexam = '{$examno}' and fbatch = '{$batch_no}' and fcsubcode = '{$subcode}'"; $result = $aobj_context->mobj_db->GetRow($query); $last_date = $result['fexamdate']; $query = "select sum(case when DATE_FORMAT(NOW(),'%Y-%m-%d') <> '{$last_date}' then 1 else 0 end) as flastdate from practical_entry_freeze where fcollcode = '{$college_code}' and fdegree = '{$degree}' and fexam = '{$examno}' and fbatch = '{$batch_no}' and fcsubcode = '{$subcode}'"; //var_dump($query); $result = $aobj_context->mobj_db->GetRow($query); if(strtoupper($_SESSION['user_type'])=='ADMIN' || strtoupper($_SESSION['user_type'])=='SUPERUSER') { $arr = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else if($result['flastdate'] > 0) { $arr = "Practical dates are not matching."; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"Failure"); } else { $arr = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } } function checkdateforhalticket($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); @session_start(); $degree = $aobj_context->mobj_data["degree"]; $examfrom = $aobj_context->mobj_data["examfrom"]; $examto = $aobj_context->mobj_data["examto"]; $collegeCode = $_SESSION['collcode']; $FUNIVCODE = $_SESSION['FUNIVCODE']; $userID = $_SESSION['user_id']; $query = "select * from s_sysdb where internal_code = '{$userID}'"; $res = $aobj_context->mobj_db->GetRow($query); $user_type = $res['user_type']; if($FUNIVCODE == '051') { $query = "select sum( if(ifnull(fshortiaper,'*') = '*',1,0)) as ia , sum( if(ifnull(fshortattper,'*') = '*',1,0)) as att from degree where fdegree = '{$degree}'"; $res1 = $aobj_context->mobj_db->GetRow($query); $ia = $res1['ia']; $att = $res1['att']; $str = ""; if($ia >0) $str .= " IA Eligibility not set."; if($att >0) $str .= " Attendance Eligibility not set."; if($str != '') { $arr = "Eligibility not updated. ".$str; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } $query = "select * from collexam where fcollcode = '{$collegeCode}' and fdegree = '{$degree}' and DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_FORMAT(collexam.fhtfrom,'%Y-%m-%d') AND DATE_FORMAT(collexam.fhtto,'%Y-%m-%d')"; $result = $aobj_context->mobj_db->GetAll($query); if($user_type =='40') { $arr = ""; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1,"success"); } else if ($result == false) { $arr = "Hall Ticket is Not Available."; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1,"success"); } else { $arr = ""; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1,"success"); } } function checkgeneratehtstaus($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $regnofrom = str_pad(strtoupper(trim($aobj_context->mobj_data["regnofrom"])),8, "00000000", STR_PAD_LEFT); $regnoto = str_pad(strtoupper(trim($aobj_context->mobj_data["regnoto"])),8,"ZZZZZZZZ",STR_PAD_LEFT); $rtype = trim($aobj_context->mobj_data["rtype"]); $degcode = trim($aobj_context->mobj_data["degcode"]); $query = "select * From candsum where fdegree = '{$degcode}' and fregno between '{$regnofrom}' and '{$regnoto}' and ifnull(fhtupload,'') = 'T'"; //var_dump($query); $result = $aobj_context->mobj_db->GetRow($query); if(count($result) >0) { $arr = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); }else { $arr = 'Hall Ticket Not Uploaded. Please upload Hall Ticket'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); } } function checkdateforra($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); @session_start(); $qp_date_frm = $aobj_context->mobj_data["qp_date_frm"]; $qp_date_to = $aobj_context->mobj_data["qp_date_to"]; $fqpcodefrm = $aobj_context->mobj_data["fqpcodefrm"]; $fqpcodeto = $aobj_context->mobj_data["qpcodeto"]; $collegeCode = $_SESSION['collcode']; $query1 = "select distinct fdegree from subject where fqpcode between '{$fqpcodefrm}' and '{$fqpcodeto}'"; $res = $aobj_context->mobj_db->GetRow($query1); $degree = $res['fdegree']; $query = "select * from collexam where fcollcode = '{$collegeCode}' and DATE_FORMAT(NOW(),'%Y-%m-%d') between DATE_FORMAT(collexam.frafrom,'{$qp_date_frm}') AND DATE_FORMAT(collexam.frato,'{$qp_date_to}')"; $result = $aobj_context->mobj_db->GetAll($query); // if(strtoupper($_SESSION['usr']) == 'SUPER' || strtoupper($_SESSION['usr']) == 'YADU') // { // $arr = ""; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1,"success"); // } // else if ($result == false) // { // $arr = "Exam Preparation is Not Available."; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1,"success"); // } // if() { $arr = ""; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1,"success"); } } function getBoardNames($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $board_id = $aobj_context->mobj_data["board_id"]; $qry="select fboardcode, fboardsate, fboardname, faddress, fphoneno from masboard where fboardcode='{$board_id}'"; $lobj_rs = $aobj_context->mobj_db->GetRow($qry); if($lobj_rs) echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure"); return; } function getBatchdet($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $query = "select distinct cd.fbatch, r.fdescpn from canddet cd inner join reason r on cd.fbatch = r.FREASONCD where ifnull(fbatch,'') <> '' order by fbatch"; $result = $aobj_context->mobj_db->GetAll($query); if ($result) { $arr['batchdet'] = $result; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1,"success"); } else { $arr = "Batch Deatils Not Found"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1,"success"); } } ?>
Close
