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.138.134.247
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 : student_entry.php
<?php /* * * FOR THE STUDENT ENTRY FORM * PROGRAMED BY NAVEEN * DATE: 12/03/09 * TIME: 9:45 AM * */ session_start(); function replaceChars($name) { $spl_char = array("*", "/", "~", "!", "@", "#", "$", "%", "^", "&", ":", ";", "?", "/", "\\", "_", "-", "'", " ", ""); $link_name = strtolower(str_replace($spl_char, "_", $name)); return str_ireplace("__", "_", $link_name); } function saveStudentEntry($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $u_id = $_SESSION['user_id']; $log_name = $_SESSION['usr']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); if (trim($college_code) == true) { $add_edit = trim($aobj_context->mobj_data["add_edit"]); $degree_slno = trim($aobj_context->mobj_data["degree_slno"]); $degree_code = trim($aobj_context->mobj_data["degree_code"]); $degree_exam = trim($aobj_context->mobj_data["degree_exam"]); $student_entry_name = trim($aobj_context->mobj_data["student_entry_name"]); $degree_fname = trim($aobj_context->mobj_data["degree_fname"]); $degree_mname = trim($aobj_context->mobj_data["degree_mname"]); $degree_dob = trim($aobj_context->mobj_data["degree_dob"]); $degree_gender = trim($aobj_context->mobj_data["degree_gender"]); $degree_category = trim($aobj_context->mobj_data["degree_category"]); $degree_nationality = trim($aobj_context->mobj_data["degree_nationality"]); $degree_english = trim($aobj_context->mobj_data["degree_english"]); $degree_address_comm1 = trim($aobj_context->mobj_data["student_entry_comm_addr1"]); $degree_address_comm2 = trim($aobj_context->mobj_data["student_entry_comm_addr2"]); $degree_address_comm3 = trim($aobj_context->mobj_data["student_entry_comm_addr3"]); $degree_address_comm4 = trim($aobj_context->mobj_data["student_entry_comm_addr4"]); $degree_address_perm1 = trim($aobj_context->mobj_data["student_entry_per_add1"]); $degree_address_perm2 = trim($aobj_context->mobj_data["student_entry_per_add2"]); $degree_address_perm3 = trim($aobj_context->mobj_data["student_entry_per_add3"]); $degree_address_perm4 = trim($aobj_context->mobj_data["student_entry_per_add4"]); $sub_degree = trim($aobj_context->mobj_data["sub_degree"]); //$lateral_entry=trim($aobj_context->mobj_data["lateral_entry"]); $lateral_entry = 0; $rec_order_no = trim($aobj_context->mobj_data["rec_order_no"]); $rec_order_date = trim($aobj_context->mobj_data["rec_order_date"]); $aff_order_no = trim($aobj_context->mobj_data["aff_order_no"]); $aff_order_date = trim($aobj_context->mobj_data["aff_order_date"]); $religion = trim($aobj_context->mobj_data["religion"]); $father_occ = trim($aobj_context->mobj_data["father_occ"]); $mother_occ = trim($aobj_context->mobj_data["mother_occ"]); $email = trim($aobj_context->mobj_data["email"]); $contact = trim($aobj_context->mobj_data["contact"]); $blood_group = trim($aobj_context->mobj_data["blood_group"]); $mobile = trim($aobj_context->mobj_data["mobile"]); $collrsch = trim($aobj_context->mobj_data["collrsch"]); $passyear = trim($aobj_context->mobj_data["passyear"]); $totalper = trim($aobj_context->mobj_data["totalper"]); $boardRuniv = trim($aobj_context->mobj_data["boardRuniv"]); $othboardRuniv = trim($aobj_context->mobj_data["othboardRuniv"]); $mgdocno = trim($aobj_context->mobj_data["mgdocno"]); $combination = trim($aobj_context->mobj_data["honours_combination"]); $honours = trim($aobj_context->mobj_data["degree_honours"]); $student_entry_reg_fee = trim($aobj_context->mobj_data["student_entry_reg_fee"]); $student_entry_exam_fee = trim($aobj_context->mobj_data["student_entry_exam_fee"]); $student_entry_grade_card_fee = trim($aobj_context->mobj_data["student_entry_grade_card_fee"]); $student_entry_total_fee = trim($aobj_context->mobj_data["student_entry_total_fee"]); $student_entry_reg_fee = empty($student_entry_reg_fee) ? 0 : $student_entry_reg_fee; $student_entry_exam_fee = empty($student_entry_reg_fee) ? 0 : $student_entry_exam_fee; $student_entry_grade_card_fee = empty($student_entry_reg_fee) ? 0 : $student_entry_grade_card_fee; $student_entry_total_fee = empty($student_entry_reg_fee) ? 0 : $student_entry_total_fee; $rec_no = trim($aobj_context->mobj_data["rec_no"]); $rec_date = trim($aobj_context->mobj_data["rec_date"]); $fee_remarks = trim($aobj_context->mobj_data["fee_remarks"]); $fcombcode = trim($aobj_context->mobj_data["fcombcode"]); $fee_paid = trim($aobj_context->mobj_data["fee_paid"]); $total_comb_fee = trim($aobj_context->mobj_data["total_comb_fee"]); $total_comb_fee = (empty($total_comb_fee) || $total_comb_fee = 'null') ? 0 : $total_comb_fee; $get_year = "SELECT FADYEAR FROM degree WHERE FDEGREE='{$degree_code}' AND FEXAMNO='{$degree_exam}'"; $lobj_get_year = $aobj_context->mobj_db->getRow($get_year); $f_year = $lobj_get_year['FADYEAR']; if ($add_edit == 'Add') { $get_generateAutoIncrementSlNo = "select right(concat('0000',ifnull(max(FSLNO),0)+01),4) as FSLNO from studadm where FDEGREE='{$degree_code}' and FCOLLCODE='{$college_code}'"; $lobj_get_generateAutoIncrementSlNo = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo); $degree_slno = $lobj_get_generateAutoIncrementSlNo[FSLNO]; } $unlink_file = trim($aobj_context->mobj_data["unlink_file"]); include_once("/JSON.php"); $json = new Services_JSON(); $lstr_param = stripslashes($aobj_context->mobj_data["sub_arr"]); $mobj_jsondata = $json->decode($lstr_param); $sub_arr_data = get_object_vars($mobj_jsondata); $fee_com_param = stripslashes($aobj_context->mobj_data["fee_com"]); $mobj_fee_com_param = $json->decode($fee_com_param); $fee_arr_data = get_object_vars($mobj_fee_com_param); $check_adminsion_freeze = " select FCADSTATUS, ifnull(fadmstop,'') as FADMSTOP from colldeg where FCOLLCODE='{$college_code}' and FDEGREE='{$degree_code}'"; $lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); if ($lobj_check_adminsion_freeze['FADMSTOP'] == 'T') { $arr = 'Last date for student admission is over'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure"); return; } else { $college_path = $aobj_context->main_src . "/student_photos/{$college_code}"; $folder_path = $aobj_context->main_src . "/student_photos/{$college_code}/" . replaceChars($degree_code); $file_name = basename($_FILES['student_entry_upload']['name']); $path_arr = pathinfo($_FILES['student_entry_upload']['name']); $file_ext = $path_arr['extension']; $full_file_path = $folder_path . '/' . $degree_slno . "_" . $file_name;; $image_path = "student_photos/{$college_code}/" . replaceChars($degree_code) . '/' . $degree_slno . "_2017_" . $file_name; //student_entry_upload if (!file_exists($college_path)) { mkdir($college_path); } if (!file_exists($folder_path)) { mkdir($folder_path); } if (is_null($lobj_check_adminsion_freeze['FCADSTATUS'])) { if ($add_edit == 'Add') { $photo_path = ""; if (isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '') { if (move_uploaded_file($_FILES['student_entry_upload']['tmp_name'], $full_file_path)) { $photo_path = $image_path; } } $lstr_qry = "insert into studadm( FSLNO,FDEGREE,FEXAMNO,FCOLLCODE,FNAME,FAYEAR,FFATNAME, FMOTNAME,FDOB,Fgender,FCASTE,FNATIONAL,FENGLISH, FCURRADD1,FCURRADD2,FCURRADD3,FCURRADD4, FPERMADD1,FPERMADD2,FPERMADD3,FPERMADD4, FSUBDEGREE,FPHOTOPATH,FLATERAL_ENTRY,FREC_ORDER_NO, FREC_ORDER_DATE,FAFF_ORDER_NO,FAFF_ORDER_DATE, FRELIGION, REG_FEE,EXAM_FEE,GRADE_CARD_FEE,TOTAL_FEE, FFAT_OCC,FMOT_OCC,FEMAIL,FCONTACT_NO,FBLOOD_GROUP, FUSERID, FLOGNAME, FLOGDATE, FDELETED, FFEEPAID,FRECNO,FRECDATE,FREMARKS, FMOBILE_NO, FCOLLRSCH, FPASSYEAR, FTOTALPERCENT, FBOARD_UNIV,FOTHBOARD,FMIGCERTNO, FCOMBCODE,FHONOURS) values ('{$degree_slno}','{$degree_code}', '{$degree_exam}', '{$college_code}', '{$student_entry_name}','{$f_year}','{$degree_fname}', '{$degree_mname}','{$degree_dob}', '{$degree_gender}', '{$degree_category}', '{$degree_nationality}', '{$degree_english}', '{$degree_address_comm1}','{$degree_address_comm2}', '{$degree_address_comm3}','{$degree_address_comm4}', '{$degree_address_perm1}', '{$degree_address_perm2}', '{$degree_address_perm3}','{$degree_address_perm4}', '{$sub_degree}','{$photo_path}','{$lateral_entry}', '{$rec_order_no}','{$rec_order_date}','{$aff_order_no}', '{$aff_order_date}','{$religion}', '{$student_entry_reg_fee}', '{$student_entry_exam_fee}', '{$student_entry_grade_card_fee}', '{$student_entry_total_fee}', '{$father_occ}','{$mother_occ}','{$email}', '{$contact}','{$blood_group}', '{$u_id}','{$log_name} ', NOW(),'F' , '{$fee_paid}', '{$rec_no}',date_format('{$rec_date}','%Y-%m-%d'),'{$fee_remarks}', '{$mobile}','{$collrsch}','{$passyear}','{$totalper}','{$boardRuniv}', '{$othboardRuniv}','{$mgdocno}','{$combination}','{$honours}' ) "; $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); for ($k = 0; $k < count($fee_arr_data); $k++) { $insert_options = "insert into admfeedetl (FYEAR,FDEGREE, FEXAMNO,FCOLLCODE, FSLNO,FHEADCODE, FAMOUNT) values ( {$f_year}, '{$degree_code}', '{$degree_exam}', '{$college_code}', '{$degree_slno}', '{$fee_arr_data[$k]->head_id}', '{$fee_arr_data[$k]->fee_paid}' ) "; $lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options); } for ($k = 0; $k < count($sub_arr_data); $k++) { $insert_options = "insert into options(FDEGREE, FEXAMNO, FCOLLCODE, FSLNO, FSUBCODE, FDELETED) values ( '{$degree_code}', '{$degree_exam}', '{$college_code}', '{$degree_slno}', '{$sub_arr_data[$k]->sub_code}', 'F' ) "; $lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options); } if ($lobj_rs) { $arr = 'Student Record inserted Successfully. Sl.No is ' . $degree_slno; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; } else { //var_dump($lstr_qry); $arr = 'Insertion Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure"); return; } } else if ($add_edit == 'Edit') // { $get_existing_data = "select FPHOTOPATH from studadm where FSLNO='{$degree_slno}' and FDEGREE='{$degree_code}' and FCOLLCODE='{$college_code}' and FEXAMNO='{$degree_exam}'"; $lobj_get_existing_data = $aobj_context->mobj_db->GetRow($get_existing_data); $existing_photo_path = $lobj_get_existing_data[FPHOTOPATH]; if (isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '') { if (move_uploaded_file($_FILES['student_entry_upload']['tmp_name'], $full_file_path)) { $unlink_file = $aobj_context->main_src . "/" . $existing_photo_path; unlink($unlink_file); //rename($unlink_file,$unlink_file."_tmp"); $existing_photo_path = $image_path; } } $update_qry = "update studadm set FNAME='{$student_entry_name}', FFATNAME='{$degree_fname}', FMOTNAME='{$degree_mname}', FDOB='{$degree_dob}', Fgender='{$degree_gender}', FCASTE='{$degree_category}', FNATIONAL='{$degree_nationality}', FENGLISH='{$degree_english}', FCURRADD1='{$degree_address_comm1}', FCURRADD2='{$degree_address_comm2}', FCURRADD3='{$degree_address_comm3}', FCURRADD4='{$degree_address_comm4}', FPERMADD1='{$degree_address_perm1}', FPERMADD2='{$degree_address_perm2}', FPERMADD3='{$degree_address_perm3}', FPERMADD4='{$degree_address_perm4}', FPHOTOPATH='{$existing_photo_path}', FSUBDEGREE='{$sub_degree}', REG_FEE='{$student_entry_reg_fee}', EXAM_FEE='{$student_entry_exam_fee}', GRADE_CARD_FEE='{$student_entry_grade_card_fee}', TOTAL_FEE='{$student_entry_total_fee}', FLATERAL_ENTRY='{$lateral_entry}', FREC_ORDER_NO='{$rec_order_no}', FREC_ORDER_DATE='{$rec_order_date}', FAFF_ORDER_NO='{$aff_order_no}', FAFF_ORDER_DATE='{$aff_order_date}', FRELIGION='{$religion}', FFAT_OCC='{$father_occ}', FMOT_OCC='{$mother_occ}', FEMAIL='{$email}', FCONTACT_NO='{$contact}', FBLOOD_GROUP='{$blood_group}', FUSERID='{$u_id} ', FLOGNAME='{$log_name}', FLOGDATE=NOW(), FFEEPAID='{$fee_paid}', FRECNO='{$rec_no}', FRECDATE='{$rec_date}', FREMARKS='{$fee_remarks}', FMOBILE_NO = '{$mobile}', FCOLLRSCH = '{$collrsch}', FPASSYEAR = '{$passyear}', FTOTALPERCENT = '{$totalper}', FBOARD_UNIV = '{$boardRuniv}',FOTHBOARD='{$othboardRuniv}', FMIGCERTNO= '{$mgdocno}',FCOMBCODE = '{$combination}', FHONOURS = '{$honours}' where FSLNO='{$degree_slno}' and FDEGREE='{$degree_code}' and FCOLLCODE='{$college_code}' and FEXAMNO='{$degree_exam}'"; $lobj_rs = $aobj_context->mobj_db->Execute($update_qry); $delete = "delete from admfeedetl where FYEAR='{$f_year}' and FDEGREE='{$degree_code}' and FEXAMNO='{$degree_exam}' and FCOLLCODE='{$college_code}' and FSLNO='{$degree_slno}'"; $lobj_rsa = $aobj_context->mobj_db->Execute($delete); for ($k = 0; $k < count($fee_arr_data); $k++) { $insert_options = "insert into admfeedetl (FYEAR,FDEGREE, FEXAMNO,FCOLLCODE, FSLNO,FHEADCODE, FAMOUNT) values ( '{$f_year}', '{$degree_code}', '{$degree_exam}', '{$college_code}', '{$degree_slno}', '{$fee_arr_data[$k]->head_id}', '{$fee_arr_data[$k]->fee_paid}' ) "; $lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options); } //Secho $update_qry; die(); $delete_from_options = "delete from options where FDEGREE='{$degree_code}' and FEXAMNO='{$degree_exam}' and FCOLLCODE='{$_SESSION['collcode']}' and FSLNO='{$degree_slno}'"; $lobj_delete_from_options = $aobj_context->mobj_db->Execute($delete_from_options); for ($k = 0; $k < count($sub_arr_data); $k++) { $insert_options = "insert into options(FDEGREE, FEXAMNO, FCOLLCODE, FSLNO, FSUBCODE, FDELETED) values ( '{$degree_code}', '{$degree_exam}', '{$college_code}', '{$degree_slno}', '{$sub_arr_data[$k]->sub_code}', 'F' )"; $lobj_insert_options = $aobj_context->mobj_db->Execute($insert_options); } if ($lobj_rs) { $arr = 'Student Record Updated Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; } else { $arr = 'Updation Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure"); return; } } } else { $arr = 'Student Admission Freezed By Admin'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "Failure"); return; } } } else { $arr = 'Session Expired,please login'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -9, "Failure"); return; } } // delete Record function disableRecord($aobj_context) { $sl_no = $aobj_context->mobj_data["sl_no"]; $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $db = $aobj_context->mobj_data["db"]; include_once("/JSON.php"); $json = new Services_JSON(); $lstr_param = stripslashes($aobj_context->mobj_data["delete_arr"]); $mobj_jsondata = $json->decode($lstr_param); $delete_arr_data = get_object_vars($mobj_jsondata); for ($k = 0; $k < count($delete_arr_data); $k++) { /* $lstr_qry = "delete from student where FDEGREE='{$delete_arr_data[$k]->degree_code}' AND FEXAMNO='{$delete_arr_data[$k]->exam}' AND FSLNO ='{$delete_arr_data[$k]->sl_no}' "; */ //echo $lstr_qry ; if($db == 'ru') { $disable_student_record = " UPDATE studadm SET FDELETED='T' WHERE FDEGREE='{$delete_arr_data[$k]->degree_code}' and FEXAMNO='{$delete_arr_data[$k]->exam}' and fslno='{$delete_arr_data[$k]->sl_no}' and FCOLLCODE ='{$_SESSION['collcode']}' "; $lobj_rs = $aobj_context->mobj_db->Execute($disable_student_record); }else { $disable_student_record = " UPDATE studadm SET FDELETED='T' WHERE FDEGREE='{$delete_arr_data[$k]->degree_code}' and FEXAMNO='{$delete_arr_data[$k]->exam}' and fappno='{$delete_arr_data[$k]->sl_no}' and FCOLLCODE ='{$_SESSION['collcode']}' "; $lobj_rs = $aobj_context->mobj_db->Execute($disable_student_record); } } /* //FDELETED $disable_student_record = " UPDATE student SET FDELETED='T' WHERE FDEGREE='{$degree_code}' and FEXAMNO='{$exam}' and FSLNO='{$sl_no}' and FCOLLCODE ='{$_SESSION['collcode']}' "; $disable_options_record = " UPDATE options SET FDELETED='T' WHERE FDEGREE='{$degree_code}' and FEXAMNO='{$exam}' and FSLNO='{$sl_no}' and FCOLLCODE='{$_SESSION['collcode']}' "; //echo $disable_student_record; die(); $lobj_disable_student_record = $aobj_context->mobj_db->Execute($disable_student_record); $lobj_disable_options_record = $aobj_context->mobj_db->Execute($disable_options_record); */ if ($lobj_rs) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs, 0, "success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs, -1, "Failure"); return; } } function getSubjectNames($aobj_context) // purpose to put subject name to dynamic text boxes -- naveen { $subject_code = $aobj_context->mobj_data["subject_code"]; $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $get_sub_names = "select FSUBCODE as id,FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY 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 FSUBCODE='{$subject_code}' group by FSUBCODE"; $lobj_get_sub_names = $aobj_context->mobj_db->getRow($get_sub_names); //var_dump($arr); die(); echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_sub_names, 0, "success"); return; } // $g_student_retain_per_mode=1; function getsubjectAppearingTotal($aobj_context) { session_start(); $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $sl_no = $aobj_context->mobj_data["sl_no"]; $pmode = $aobj_context->mobj_data["pmode"]; $sub_degree = trim($aobj_context->mobj_data["sub_degree"]); $college_code = $_SESSION['collcode']; $combination = trim($aobj_context->mobj_data["combination"]); $degree_code = (!empty($sub_degree)) ? $sub_degree : $degree_code; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $get_sub_total = " select FTOTSUB from degree where FDEGREE= '{$degree_code}' and FEXAMNO='{$exam}'"; $lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total); $total_sub = $lobj_sub_total['FTOTSUB']; //echo $total_sub; die(); $get_exsting_data = " select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from (select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options where fappno = '{$sl_no}' and FCOLLCODE='{$_SESSION['collcode']}' and FEXAMNO='{$exam}' and FDEGREE='{$degree_code}') a left join (select s.FDEGREE, FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY 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}') b on a.FSUBCODE=b.FSUBCODE and a.FDEGREE=b.FDEGREE group by FSUBCODE limit {$total_sub} "; // var_dump($get_exsting_data); $lobj_get_exsting_data = $aobj_context->mobj_db->getAll($get_exsting_data); // get true sub Names $get_true_sub_names = "select FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY 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 FMANDATORY='T' group by s.FSUBCODE union select s.FSUBCODE,s.FSUBNAME,s.FSUBSHORT ,'T' as FMANDATORY from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO left join mascomb m on m.FDEGREE=d.FDEGREE and m.fcombcode = '{$combination}' where d.FDEGREE='{$degree_code}' and INSTR(m.FSUBCODE, s.FSUBCODE) group by s.FSUBCODE"; $lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names); $e_data = ''; $e_data .= "<table width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >"; //$e_data.="<th align='left' colspan='3' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Subjects Appearing</th>"; $e_data .= "<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>"; $e_data .= "<td style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>"; $e_data .= "<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>"; $e_data .= "<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>"; $e_data .= "</tr>"; $k = 0; $id = 0; if (empty($lobj_get_exsting_data)) { $remaining_count = $total_sub - count($lobj_get_true_sub_names); //echo 'aa'; foreach ($lobj_get_true_sub_names as $key => $value) { $e_data .= "<tr style='font-size:12px;' class='ui-widget-content jqgrow'>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;'><input tabindex=-1 {$inp_class} type=text style='width:60px;border:none;' readonly id='se_sub_code_{$id}' value='{$value[FSUBCODE]}' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'></td>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:60px;' {$inp_class} tabindex=-1 readonly id='se_short_name_{$id}' value='{$value[FSUBSHORT]}'></td>"; $e_data .= "<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:290px;' {$inp_class} id='se_sub_name_{$id}' tabindex=-1 readonly value='{$value[FSUBNAME]}'> </td>"; $e_data .= "</tr>"; $k++; $id++; } $name = ''; if ($pmode == 0) { $last_slno_execution = " select s.FSUBCODE, s.FSUBSHORT, s.FSUBNAME from subject s inner join options d on s.FDEGREE=d.FDEGREE and s.FEXAMNO=d.FEXAMNO and d.fsubcode = s.fsubcode and d.FCOLLCODE='{$college_code}' and s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and d.fslno = ( select MAX(s.fslno) from studadm s where s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' AND FCOLLCODE='{$college_code}' ) group by s.FSUBCODE "; $lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution); } // var_dump($lobj_last_slno_execution); die(); for ($j = 0; $j < $remaining_count; $j++) { if ($k % 2 == 0) { $class = 'tbl_row'; $inp_class = 'tbl_row_input'; } else { $input_class = 'tbl_row1'; $inp_class = 'tbl_row1_input'; } if ($j == 0) $name = "name='focus'"; else $name = ''; $e_data .= "<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data .= "<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name} onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}' ></td>"; $e_data .= "<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}' ></td>"; $e_data .= "</tr>"; $k++; $id++; } } else { $flag = 0; $remaining_count = $total_sub - count($lobj_get_exsting_data); for ($h = 0; $h < count($lobj_get_exsting_data); $h++) { $read_only = ($lobj_get_exsting_data[$h]['FMANDATORY'] == 'T') ? "readOnly" : ''; $border = ($lobj_get_exsting_data[$h]['FMANDATORY'] == 'T') ? " border:none;" : ''; $on_blur = ($lobj_get_exsting_data[$h]['FMANDATORY'] == 'F') ? " onblur='getSubDetails( this.id,{$id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' " : ''; $focus_id = ($lobj_get_exsting_data[$h]['FMANDATORY'] == 'F') ? " onfocus=\$g_focus_element='se_sub_code_{$id}' " : ''; if ($k % 2 == 0) { $class = 'tbl_row'; $inp_class = 'tbl_row_input'; } else { $input_class = 'tbl_row1'; $inp_class = 'tbl_row1_input'; } if (($lobj_get_exsting_data[$h]['FMANDATORY'] == 'F') && $flag == 0) { $name = "name='focus'"; $flag = 1; } else $name = ''; $e_data .= "<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data .= "<td class='tbl_row_new' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} {$on_blur} {$name} {$read_only} align='center' {$focus_id} value='{$lobj_get_exsting_data[$h]['FSUBCODE']}' style = 'width:60px;{$border}'id='se_sub_code_{$id}'> </td>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} style = 'width:60px;border:none;' {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBSHORT']}' id='se_short_name_{$id}'></td>"; $e_data .= "<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} style = 'width:290px;border:none;' {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBNAME']}' id='se_sub_name_{$id}'></td>"; $e_data .= "</tr>"; $k++; $id++; } $k = 0; for ($j = 0; $j < $remaining_count; $j++) { if ($k % 2 == 0) { $class = 'tbl_row'; $inp_class = 'tbl_row_input'; } else { $input_class = 'tbl_row1'; $inp_class = 'tbl_row1_input'; } if ($j == 0) $name = "name='focus'"; else $name = ''; $e_data .= "<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data .= "<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name} onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}' ></td>"; $e_data .= "<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}' ></td>"; $e_data .= "</tr>"; $k++; $id++; } } $e_data .= "</table>"; $arr['html'] = $e_data; $arr['table_data'] = $lobj_get_true_sub_names; $arr['remaining_count'] = $remaining_count; $arr['total_count'] = $id; // var_dump($arr['total_count']); die(); echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; } function getHonoursCombinationSubject($aobj_context) { session_start(); $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $honours = $aobj_context->mobj_data["honours"]; $combcode = $aobj_context->mobj_data["combcode"]; $sl_no = $aobj_context->mobj_data["sl_no"]; $pmode = $aobj_context->mobj_data["pmode"]; $college_code = $_SESSION['collcode']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $get_sub_total = " select FTOTSUB from degree where FDEGREE= '{$degree_code}' and FEXAMNO='{$exam}'"; $lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total); $total_sub = $lobj_sub_total['FTOTSUB']; //echo $total_sub; die(); $get_exsting_data = " select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from (select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options where FSLNO='{$sl_no}' and FCOLLCODE='{$_SESSION['collcode']}' and FEXAMNO='{$exam}' and FDEGREE='{$degree_code}') a left join (select s.FDEGREE, FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY 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}') b on a.FSUBCODE=b.FSUBCODE and a.FDEGREE=b.FDEGREE group by FSUBCODE limit {$total_sub} "; $lobj_get_exsting_data = $aobj_context->mobj_db->getAll($get_exsting_data); //var_dump($get_exsting_data );die(); // get true sub Names $get_true_sub_names = "select FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from mascomb d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO inner join mascomb m on INSTR(m.fsubcode,s.FSUBCODE) group by s.FSUBCODE"; $lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names); $e_data = ''; $e_data .= "<table width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >"; //$e_data.="<th align='left' colspan='3' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Subjects Appearing</th>"; $e_data .= "<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>"; $e_data .= "<td style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>"; $e_data .= "<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>"; $e_data .= "<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>"; $e_data .= "</tr>"; $k = 0; $id = 0; if (empty($lobj_get_exsting_data)) { $remaining_count = $total_sub - count($lobj_get_true_sub_names); //echo 'aa'; foreach ($lobj_get_true_sub_names as $key => $value) { /* if($k%2==0) { $class='tbl_row'; $inp_class='tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } */ $e_data .= "<tr style='font-size:12px;' class='ui-widget-content jqgrow'>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;'><input tabindex=-1 {$inp_class} type=text style='width:60px;border:none;' readonly id='se_sub_code_{$id}' value='{$value[FSUBCODE]}' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'></td>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:60px;' {$inp_class} tabindex=-1 readonly id='se_short_name_{$id}' value='{$value[FSUBSHORT]}'></td>"; $e_data .= "<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:290px;' {$inp_class} id='se_sub_name_{$id}' tabindex=-1 readonly value='{$value[FSUBNAME]}'> </td>"; $e_data .= "</tr>"; $k++; $id++; } $name = ''; if ($pmode == 0) { $last_slno_execution = " select s.FSUBCODE, s.FSUBSHORT, s.FSUBNAME from subject s inner join options d on s.FDEGREE=d.FDEGREE and s.FEXAMNO=d.FEXAMNO and d.fsubcode = s.fsubcode and d.FCOLLCODE='{$college_code}' and s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and d.fslno = ( select MAX(s.fslno) from studadm s where s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' AND FCOLLCODE='{$college_code}' ) group by s.FSUBCODE "; $lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution); } // var_dump($lobj_last_slno_execution); die(); for ($j = 0; $j < $remaining_count; $j++) { if ($k % 2 == 0) { $class = 'tbl_row'; $inp_class = 'tbl_row_input'; } else { $input_class = 'tbl_row1'; $inp_class = 'tbl_row1_input'; } if ($j == 0) $name = "name='focus'"; else $name = ''; $e_data .= "<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data .= "<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name} onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}' ></td>"; $e_data .= "<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}' ></td>"; $e_data .= "</tr>"; $k++; $id++; } } else { $flag = 0; $remaining_count = $total_sub - count($lobj_get_exsting_data); for ($h = 0; $h < count($lobj_get_exsting_data); $h++) { $read_only = ($lobj_get_exsting_data[$h]['FMANDATORY'] == 'T') ? "readOnly" : ''; $border = ($lobj_get_exsting_data[$h]['FMANDATORY'] == 'T') ? " border:none;" : ''; $on_blur = ($lobj_get_exsting_data[$h]['FMANDATORY'] == 'F') ? " onblur='getSubDetails( this.id,{$id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' " : ''; $focus_id = ($lobj_get_exsting_data[$h]['FMANDATORY'] == 'F') ? " onfocus=\$g_focus_element='se_sub_code_{$id}' " : ''; if ($k % 2 == 0) { $class = 'tbl_row'; $inp_class = 'tbl_row_input'; } else { $input_class = 'tbl_row1'; $inp_class = 'tbl_row1_input'; } if (($lobj_get_exsting_data[$h]['FMANDATORY'] == 'F') && $flag == 0) { $name = "name='focus'"; $flag = 1; } else $name = ''; $e_data .= "<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data .= "<td class='tbl_row_new' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} {$on_blur} {$name} {$read_only} align='center' {$focus_id} value='{$lobj_get_exsting_data[$h]['FSUBCODE']}' style = 'width:60px;{$border}'id='se_sub_code_{$id}'> </td>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} style = 'width:60px;border:none;' {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBSHORT']}' id='se_short_name_{$id}'></td>"; $e_data .= "<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} style = 'width:290px;border:none;' {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBNAME']}' id='se_sub_name_{$id}'></td>"; $e_data .= "</tr>"; $k++; $id++; } $k = 0; for ($j = 0; $j < $remaining_count; $j++) { if ($k % 2 == 0) { $class = 'tbl_row'; $inp_class = 'tbl_row_input'; } else { $input_class = 'tbl_row1'; $inp_class = 'tbl_row1_input'; } if ($j == 0) $name = "name='focus'"; else $name = ''; $e_data .= "<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data .= "<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name} onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>"; $e_data .= "<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}' ></td>"; $e_data .= "<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}' ></td>"; $e_data .= "</tr>"; $k++; $id++; } } $e_data .= "</table>"; $arr['html'] = $e_data; $arr['table_data'] = $lobj_get_true_sub_names; $arr['remaining_count'] = $remaining_count; $arr['total_count'] = $id; // var_dump($arr['total_count']); die(); echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; } function getSubDetails($aobj_context) { $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $field_id = $aobj_context->mobj_data["field_id"]; $icode = $aobj_context->mobj_data["icode"]; $value = $aobj_context->mobj_data["value"]; $get_true_sub_names = "select'{$field_id}' as 'field_id',{$icode} as 'icode', FSUBCODE,FSUBNAME,fQPcode as FSUBSHORT ,FMANDATORY 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 ( FSUBCODE='{$value}' or FSUBSHORT='{$value}') "; $lobj_get_true_sub_names = $aobj_context->mobj_db->getRow($get_true_sub_names); if ($lobj_get_true_sub_names) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_true_sub_names, 0, "success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($icode, -1, "Failure"); return; } } function getSlNoStudentDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); //and FDELETED = 'F' $sl_no = $aobj_context->mobj_data["sl_no"]; // $sl_no=substr($sl_no, -4); $degree = $aobj_context->mobj_data["degree"]; $_SESSION['sl_no'] = $sl_no; $select_logintCnt = "select ifnull(login_cnt,'') as login_cnt from studoc where FCOLLCODE='{$_SESSION['collcode']}' and app_no='{$sl_no}' and FDEGREE = '{$degree}'"; $lobj_select_logintCnt = $aobj_context->mobj_db->getRow($select_logintCnt); if ($lobj_select_logintCnt[login_cnt] != '') { $_SESSION['login_cnt'] = $lobj_select_logintCnt[login_cnt]; } else { session_start(); $login_counter = "select (ifnull(login_cnt,0) +1)as login_cnt from login_counter"; $lobj_rs_counter = $aobj_context->mobj_db->GetRow($login_counter); $count_val = $lobj_rs_counter['login_cnt']; $update_log_cnt = "update login_counter set login_cnt={$count_val}"; $lobj_update_log_cnt = $aobj_context->mobj_db->Execute($update_log_cnt); setcookie("login_cnt", $count_val, time() + 36000333, '/'); $_SESSION['login_cnt'] = $count_val; } $get_student_details_slno = "select s.*, s.FSLNO,s.FDEGREE,d.FDESCPN,s.FEXAMNO,s.FCOLLCODE,s.FNAME, s.FFATNAME,s.FMOTNAME,ifnull(FPASSMNTH,'') as FPASSMNTH,ifnull(FPASSYER,'') as FPASSYER,ifnull(FMARKSECURED,'') as FMARKSECURED, ifnull(FMARKTOTAL,'') as FMARKTOTAL, ifnull(FPERMARK,'') as FPERMARK, DATE_FORMAT(s.FDOB,'%d/%m/%Y') as FDOBirth ,FCATBIRTH, s.Fgender,s.FCASTE,s.FNATIONAL,s.FENGLISH,s.FCURRADD1, REG_FEE,EXAM_FEE,GRADE_CARD_FEE,TOTAL_FEE, s.FCURRADD2,s.FCURRADD3,s.FCURRADD4,s.FPERMADD1,s.FPERMADD2,s.FPERMADD3,s.FPERMADD4, DATE_FORMAT(s.FADMDATE,'%d/%m/%Y') as FADMISDATE, s.FSUBDEGREE,s.FPHOTOPATH,s.FLATERAL_ENTRY,s.FBLOOD_GROUP,s.FCONTACT_NO,s.FEMAIL,s.FMOT_OCC,s.FFAT_OCC, s.FREC_ORDER_NO, DATE_FORMAT(s.FREC_ORDER_DATE,'%d/%m/%Y') as FREC_ORDER_DATE, s.FAFF_ORDER_NO, DATE_FORMAT(s.FAFF_ORDER_DATE,'%d/%m/%Y') as FAFF_ORDER_DATE, s.FRELIGION, ifnull(s.FDELETED,'F') as FDELETED,FFEEPAID,FRECNO,date_format(FRECDATE,'%d/%m/%Y') as FRECDATE, FREMARKS,FCOMBCODE,FMOBILE_NO from studadm s inner join degree d on d.FDEGREE=s.FDEGREE where s.fappno='{$sl_no}' and s.FDEGREE='{$degree}' and s.FCOLLCODE='{$_SESSION['collcode']}' and d.FEXAMNO='A'"; $lobj_get_student_details = $aobj_context->mobj_db->getRow($get_student_details_slno); //var_dump($lobj_get_student_details); die(); //echo $get_student_details_slno; die(); $query = "select * from qualdet where fslno = '{$sl_no}' and fdegree = '{$degree}' and fcollcode ='{$_SESSION['collcode']}'"; $results = $aobj_context->mobj_db->getAll($query); $arr['studdet'] = $lobj_get_student_details; $arr['qualdet'] = $results; $arr['qualcount'] = count($results);; if (!empty($lobj_get_student_details) && $lobj_get_student_details[FDELETED] == 'F') { echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; } else if (!empty($lobj_get_student_details) && $lobj_get_student_details[FDELETED] == 'T') { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details, -1, "Disabled"); return; } else if (empty($lobj_get_student_details)) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details, -2, "Failure"); return; } } function generateAutoIncrementSlNo($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $degree = $aobj_context->mobj_data["degree"]; $get_generateAutoIncrementSlNo = "select right(concat('0000',ifnull(max(FSLNO),0)+01),4) as FSLNO from studadm where FDEGREE='{$degree}' and FCOLLCODE='{$_SESSION['collcode']}'"; //echo $get_generateAutoIncrementSlNo; $lobj_get_generateAutoIncrementSlNo = $aobj_context->mobj_db->getRow($get_generateAutoIncrementSlNo); if ($lobj_get_generateAutoIncrementSlNo) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_generateAutoIncrementSlNo['FSLNO'], 0, "success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details, -1, "success"); return; } } function DiaplayUserSelectedPhoto($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode = $_SESSION['collcode']; $user_id = $_SESSION['user_id']; $college_path = $aobj_context->main_src .'/'.$aobj_context->mobj_data["db"]."/student_photos/{$college_code}"; $folder_path = $aobj_context->main_src .'/'.$aobj_context->mobj_data["db"]."/student_photos/{$college_code}/" . replaceChars($degree_code); $file_name = replaceChars(basename($_FILES['student_entry_upload']['name'])); $path_arr = pathinfo($_FILES['student_entry_upload']['name']); $file_ext = $path_arr['extension']; $temp_path = $aobj_context->main_src.$aobj_context->mobj_data["db"]."/student_photos/temp"; //var_dump($temp_path); if (!file_exists($temp_path)) { mkdir($temp_path); } $file_path = "/{$collcode}_{$user_id}_{$file_name}"; $temp_path .= $file_path; if (isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '') { $size = ($_FILES['student_entry_upload']['size'] / 1024); if ($size > 1024) { $data = "Please Upload the Photo of size less than 1 MB"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -2, "success"); return; } if (move_uploaded_file($_FILES['student_entry_upload']['tmp_name'], $temp_path)) { $data = "student_photos/temp/{$file_path}"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, 0, "success"); return; } } echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } /* function ViewStudentDetails($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; 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('grid_sl_no','grid_degree','grid_sub_degree','grid_exam','grid_count'); $display_obj->display_qry="select concat(FDEGREE,FSLNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree,FSUBDEGREE as grid_sub_degree, FEXAMNO as grid_exam, FNAME as grid_name, concat(real_name,date_format(FLOGDATE,' %d-%b-%Y')) as created_by from studadm st left join s_sysdb s on s.internal_code=FUSERID where 1=1 and ifnull(st.FDELETED,'F')='F' and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}'"; $display_obj->DisplayDetailsInGrid(); } */ function ViewStudentDetails($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; 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('grid_sl_no', 'grid_degree', 'grid_exam', 'grid_count'); $display_obj->display_qry = "select concat(FDEGREE,FEXAMNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree, FEXAMNO as grid_exam, count(*) as grid_count from studadm st left join s_sysdb s on s.internal_code=FUSERID where 1=1 and ifnull(st.FDELETED,'F')='F' and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}' group by FDEGREE,FEXAMNO"; $display_obj->DisplayDetailsInGrid(); } function ViewDegreeWiseStudentDetails($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $degid = $aobj_context->mobj_data["degid"]; $cnd = "concat(FDEGREE,FSLNO) as id, FSLNO as grid_sl_no,"; if($_SESSION['FUNIVCODE'] == '023' || $_SESSION['FUNIVCODE'] == '035' || $_SESSION['FUNIVCODE'] == '048') { $cnd = "concat(FDEGREE,fappno) as id, fappno as grid_sl_no,"; } //var_dump($cnd); 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('grid_sl_no', 'grid_degree', 'grid_sub_degree', 'grid_exam', 'grid_name', 'created_by'); $display_obj->display_qry = "select {$cnd} FDEGREE as grid_degree,FSUBDEGREE as grid_sub_degree, FEXAMNO as grid_exam, FNAME as grid_name, concat(real_name,date_format(FLOGDATE,' %d-%b-%Y')) as created_by from studadm st left join s_sysdb s on s.internal_code=FUSERID where 1=1 and ifnull(st.FDELETED,'F')='F' and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}' and concat(FDEGREE,FEXAMNO) ='{$degid}'"; $display_obj->DisplayDetailsInGrid(); } function ViewCourseWiseStudentDetails($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; 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('grid_sl_no', 'grid_degree', 'grid_sub_degree', 'grid_exam', 'grid_name', 'created_by'); $display_obj->display_qry = "select concat(FDEGREE,FSLNO) as id, FSLNO as grid_sl_no, FDEGREE as grid_degree,FSUBDEGREE as grid_sub_degree, FEXAMNO as grid_exam, FNAME as grid_name, concat(real_name,date_format(FLOGDATE,' %d-%b-%Y')) as created_by from studadm st left join s_sysdb s on s.internal_code=FUSERID where 1=1 and ifnull(st.FDELETED,'F')='F' and (FREGNO='' or FREGNO is null) and FCOLLCODE='{$college_code}'"; $display_obj->DisplayDetailsInGrid(); } function deleteStudentDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $lstr_ids = $aobj_context->mobj_data["id"]; $lstr_qry = "delete from studadm where internal_code in (" . $lstr_ids . ")"; // echo $lstr_qry $lobj_rs = $aobj_context->mobj_db->Execute($lstr_qry); } function GetCombinationFeeList($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $fdegree = $aobj_context->mobj_data["fdegree"]; $fexamno = $aobj_context->mobj_data["fexamno"]; //$fexamno = 'A'; $fcombcode = 'GEN'; $fcatcode = $aobj_context->mobj_data["fcatcode"]; $fstudtype = $aobj_context->mobj_data["fstudtype"]; $fsl_no = $aobj_context->mobj_data["fsl_no"]; session_start(); $collcode = $_SESSION['collcode']; $get_year = "SELECT FADYEAR FROM degree WHERE FDEGREE='{$fdegree}' AND FEXAMNO='{$fexamno}'"; $lobj_get_year = $aobj_context->mobj_db->getRow($get_year); $year = $lobj_get_year['FADYEAR']; $get_details = "SELECT FHEADCODE,FFEE, ifnull(FMODIFY,'F') as FMODIFY, ifnull(FAMOUNT ,FFEE) as fee_paid, FCOMBCODE,FCATCODE FROM admfeestr WHERE FDEGREE='{$fdegree}' AND FEXAMNO='{$fexamno}' AND FCOMBCODE='ADM' and fconstype = '{$fstudtype}' AND FCATCODE='GM' order by fheadcode "; $lobj_rs = $aobj_context->mobj_db->GetAll($get_details); //var_dump($get_details); $str_reval = ""; $str_reval .= "<table width='60%' style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>"; $str_reval .= "<th align='left' colspan='4' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Fee Details</th>"; $str_reval .= "<tr class='ui-state-default ui-jqgrid-hdiv'>"; $str_reval .= "<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl.No</td>"; $str_reval .= "<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Description</td>"; /*$str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee</td>";*/ $str_reval .= "<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Fee Paid</td>"; $str_reval .= "</tr>"; $sl_no = 1; $total = 0; $total_fee_paid = 0; foreach ($lobj_rs as $ak => $av) { $FHEADCODE = $av['FHEADCODE']; $FFEE = $av['FFEE']; $fee_paid = $av['fee_paid']; $FMODIFY = $av['FMODIFY']; $cnd = "disabled = true"; if($FMODIFY == 'T') { $cnd = ""; } $total += $FFEE; $total_fee_paid += $fee_paid; $str_reval .= "<tr class='ui-widget-content jqgrow'>"; $str_reval .= "<td class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' >{$sl_no}</td>"; $str_reval .= "<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='left' id='head_{$sl_no}'>{$FHEADCODE}</td>"; /*$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;width:50px;'align='right' >{$FFEE}</td>";*/ $str_reval .= "<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right'><input onblur=\"CalculateTotalFeePaid();\" {$cnd} onkeypress='return acceptNumbersOnlyForModule(event);' type='text' style='text-align:right;width:50px;'id='fee_paying_{$sl_no}' value='{$fee_paid}'/></td>"; $str_reval .= "</tr>"; $sl_no++; } $str_reval .= "<tr class='ui-widget-content jqgrow' style='font-weight:bold;'>"; $str_reval .= "<td colspan=2 class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right'>Total </td>"; /*$str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='total_comb_fee'>{$total}</td>";*/ $str_reval .= "<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' align='right' id='total_fee_paid'>{$total_fee_paid}</td>"; $str_reval .= "</tr>"; $str_reval .= "</table>"; $arr['html'] = $str_reval; print_r($aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success")); return $html; } function getHonoursNames($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode = $_SESSION['collcode']; $degreecode = $aobj_context->mobj_data["degree"]; $get_honours = "SELECT distinct fhonours as internal_code, fhonours as value from mascomb where ifnull(fhonours,'') <>'' and fdegree = '{$degreecode}'"; $lobj_get_honours = $aobj_context->mobj_db->getAll($get_honours); if ($lobj_get_honours) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_honours, 0, "success"); } else { $data = 'Error in data retrieval'; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); } } function getCombinationNames($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode = $_SESSION['collcode']; $degreecode = $aobj_context->mobj_data["degree"]; $get_honours = "SELECT FCOMBCODE as internal_code, FCOMBDESC as value from mascomb where fdegree = '{$degreecode}' group by FCOMBCODE"; $lobj_get_honours = $aobj_context->mobj_db->getAll($get_honours); $arr['mascomb'] = $lobj_get_honours; if ($lobj_get_honours) { echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); } else { $data = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); } } function UploadEmployeeDocuments($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $login_cnt = $_SESSION['login_cnt']; $collcode = $_SESSION['collcode']; $dir_path = $aobj_context->main_src . "/certificates/{$login_cnt}"; mkdir($dir_path); //chmod($dir_path,7777); $cert_file_name = trim($aobj_context->mobj_data["file_name"]); $doc_type_int_code = trim($aobj_context->mobj_data["doc_type_int_code"]); $file_id = "ed_{$doc_type_int_code}"; $file_name = replaceChars(basename($_FILES[$file_id]['name'])); //$file_ext=$path_arr['extension']; $arr['file_name'] = $file_name; if (isset($file_name) && $file_name != '') { $path_arr = pathinfo($_FILES[$file_id]['name']); $file_ext = $path_arr['extension']; $root_file_name = $dir_path . "/{$cert_file_name}." . $file_ext; $attachement_path = "certificates/{$login_cnt}/{$cert_file_name}." . $file_ext; if (move_uploaded_file($_FILES[$file_id]['tmp_name'], $root_file_name)) { $arr['path'] = $attachement_path; $arr['id'] = $doc_type_int_code; $arr['file_name'] = $file_name; $delete = "delete from studoc where ref_mas_doc_code='{$doc_type_int_code}' and login_cnt='{$login_cnt}' "; $lobj_delete = $aobj_context->mobj_db->Execute($delete); $insert = "INSERT INTO studoc ( ref_mas_doc_code, login_cnt, file_path, created_date, fcollcode ) values ( '{$doc_type_int_code}', '{$login_cnt}', '{$attachement_path}',now(), '{$collcode}' )"; $lobj_insert = $aobj_context->mobj_db->Execute($insert); // echo $insert; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; } else { $data = "Moving {$file_name} failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } else { $data = "File is empty, not moved"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function UploadEditEmployeeDocuments($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $login_cnt = $_SESSION['login_cnt']; $degree = $aobj_context->mobj_data["degree"]; $collcode = $aobj_context->mobj_data["collcode"]; $slno = $aobj_context->mobj_data["slno"]; $dir_path = $aobj_context->main_src .'/'.$aobj_context->mobj_data["db"]. "/certificates/{$login_cnt}"; mkdir($dir_path); //chmod($dir_path,7777); $cert_file_name = trim($aobj_context->mobj_data["file_name"]); $doc_type_int_code = trim($aobj_context->mobj_data["doc_type_int_code"]); $file_id = "ed_{$doc_type_int_code}"; $file_name = replaceChars(basename($_FILES[$file_id]['name'])); //$file_ext=$path_arr['extension']; $arr['file_name'] = $file_name; if (trim($college_code) != '') { if (isset($file_name) && $file_name != '') { $path_arr = pathinfo($_FILES[$file_id]['name']); $file_ext = $path_arr['extension']; $root_file_name = $dir_path . "/{$cert_file_name}." . $file_ext; $attachement_path = "certificates/{$login_cnt}/{$cert_file_name}." . $file_ext; if (move_uploaded_file($_FILES[$file_id]['tmp_name'], $root_file_name)) { $arr['path'] = $attachement_path; $arr['id'] = $doc_type_int_code; $arr['file_name'] = $file_name; $delete = "delete from studoc where ref_mas_doc_code='{$doc_type_int_code}' and login_cnt='{$login_cnt}' "; $lobj_delete = $aobj_context->mobj_db->Execute($delete); $insert = "INSERT INTO studoc(ref_mas_doc_code, login_cnt, file_path, created_date, fcollcode,fdegree,app_no) values('{$doc_type_int_code}','{$login_cnt}','{$attachement_path}',now(),'{$college_code}','{$degree}','{$slno}')"; $lobj_insert = $aobj_context->mobj_db->Execute($insert); // echo $insert; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); return; } else { $data = "Moving {$file_name} failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } else { $data = "File is empty, not moved"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } else { $data = "Moving {$file_name} failed"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } function setAdmLoginCntr($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $login_counter = "select (ifnull(login_cnt,0) +1)as login_cnt from login_counter"; $lobj_rs_counter = $aobj_context->mobj_db->GetRow($login_counter); $count_val = $lobj_rs_counter['login_cnt']; $update_log_cnt = "update login_counter set login_cnt={$count_val}"; $lobj_update_log_cnt = $aobj_context->mobj_db->Execute($update_log_cnt); setcookie("login_cnt", $count_val, time() + 36000333, '/'); $_SESSION['login_cnt'] = $count_val; echo $aobj_context->mobj_output->ToJSONEnvelope($count_val, 0, "success"); return; } function DiaplayUserSelectedSignature($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode = $_SESSION['collcode']; $user_id = $_SESSION['user_id']; $college_path = $aobj_context->main_src .'/'.$aobj_context->mobj_data["db"]. "/student_photos/{$college_code}"; $folder_path = $aobj_context->main_src .'/'.$aobj_context->mobj_data["db"]. "/student_photos/{$college_code}/" . replaceChars($degree_code); $file_name = replaceChars(basename($_FILES['student_entry_signupload']['name'])); $path_arr = pathinfo($_FILES['student_entry_signupload']['name']); $file_ext = $path_arr['extension']; $temp_path = $aobj_context->main_src .'/'.$aobj_context->mobj_data["db"]. "/student_photos/temp"; if (!file_exists($temp_path)) { mkdir($temp_path); } $file_path = "/{$collcode}_{$user_id}_s_{$file_name}"; $temp_path .= $file_path; if (isset($_FILES['student_entry_signupload']['name']) && $_FILES['student_entry_signupload']['name'] != '') { $size = ($_FILES['student_entry_signupload']['size'] / 1024); if ($size > 1024) { $data = "Please Upload the Photo of size less than 1 MB"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -2, "success"); return; } if (move_uploaded_file($_FILES['student_entry_signupload']['tmp_name'], $temp_path)) { $data = "student_photos/temp/{$file_path}"; echo $aobj_context->mobj_output->ToJSONEnvelope($data, 0, "success"); return; } } echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } function GetDodumentsUpload() { $degree = trim($this->aobj_context->mobj_data["degree"]); $nationality = trim($this->aobj_context->mobj_data["nationality"]); $amt = empty($amt) ? 0 : $amt; $arr['amount'] = $amt; $query = "SELECT DISTINCT m.internal_code AS int_code, FCERTDESC AS doc_type, IFNULL(FFILENAME,REPLACE(REPLACE(FCERTDESC,' ','_'),'+','_')) AS FFILENAME, ifnull(s.file_path,'') as file_path FROM masdoc m LEFT JOIN studoc s ON s.fdegree = m.fdegree AND login_cnt = '0' AND s.fdoctype = m.FFILENAME AND fcollcode = '{$_SESSION['collcode']}' ORDER BY forder"; $results = $aobj_context->mobj_db->GetAll($query); $arr['masdoc'] = $results; //$sub_arr=$this->GetSubjectDetails($degree); $doc_arr = $this->GetStudentDocumentsTable($degree, $nationality); $arr['subjects'] = $sub_arr; $arr['doc_arr'] = $doc_arr; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); }
Close
