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 | : 18.219.158.84
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 : ack_admentry_application.php
<?php //require_once(_DIR_ . "/../../aws/aws-autoloader.php"); require_once("/var/www/html/aws/aws-autoloader.php"); use Aws\S3\S3Client; use Aws\S3\Exception\S3Exception; class challan_entries { function __construct($aobj_context) { session_start(); $this->aobj_context=$aobj_context; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $this->user_id=$_SESSION['user_id'] ; $this->collcode=$_SESSION['collcode']; $this->college_code=$_SESSION['collcode']; $this->log_name = $_SESSION['usr']; } function DisplayAdmentryApplication() { $adm_degree = trim($this->aobj_context->mobj_data["degree"]); $type = trim($this->aobj_context->mobj_data["type"]); $cnd = ""; if($type == 'wom') { $query = "SELECT c.fdegree, c.fname, IFNULL(c.fid,'') AS fmobileno, IFNULL(c.femail,'') AS femailid FROM collstudnb c LEFT JOIN studadm s ON c.fcollcode = s.fcollcode AND c.fdegree = s.fdegree AND s.fcontact_no = c.fid WHERE c.fcollcode = '{$this->collcode}' AND c.fdegree = '{$adm_degree}' AND IFNULL(s.fcollcode,'') = '' AND IFNULL(s.fdegree,'') = ''"; } else if($type == 'wm') { $query = "SELECT c.fdegree, c.fname, IFNULL(c.fmobileno,'') AS fmobileno,IFNULL(c.femail,'') AS femailid FROM collstud c LEFT JOIN studadm s ON c.fcollcode = s.fcollcode AND c.fdegree = s.fdegree AND c.fmobileno = s.fcontact_no WHERE c.fcollcode = '{$this->collcode}' AND c.fdegree = '{$adm_degree}' AND IFNULL(s.fcontact_no,'') = '' "; } else { $query = "SELECT s.fappno, c.fdegree, c.fname, IFNULL(c.fmobileno,'') AS fmobileno, IFNULL(c.femail,'') AS femailid FROM collstud c inner JOIN studadm s ON c.fcollcode = s.fcollcode AND c.fdegree = s.fdegree AND c.fmobileno = s.fcontact_no WHERE c.fcollcode = '{$this->collcode}' AND c.fdegree = '{$adm_degree}' AND IFNULL(s.ffinsub,'F') = 'F' and ifnull(c.fdeleted,'') <> 'T'"; } //var_dump($query); $lobj_get_data = $this->aobj_context->mobj_db->GetAll($query); //var_dump($query); $lobj_get_data = $this->aobj_context->mobj_db->GetAll($query); $str_reval.="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>"; $str_reval.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $str_reval.="<td align='center' style='padding:4px; 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:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Degree</td>"; $str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Student Name</td>"; $str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Mobile No.</td>"; $str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Email</td>"; $str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Action</td>"; $str_reval.="</tr>"; $k=0; $sl_no=1; if($lobj_get_data) { foreach($lobj_get_data as $ak=>$av) { if($type == 'EA') { $edit="<img onclick='EditStudentDetails(\"{$av['fappno']}\",\"{$av['fdegree']}\", \"{$type}\")' src='img/edit.png' title='Edit' style='width: 80px;height:25px' /> "; } else { $edit="<img onclick='AddEditStudentDetails(\"{$av['fdegree']}\", \"{$av['fmobileno']}\", \"{$av['fname']}\", \"{$type}\")' src='img/edit.png' title='Edit' style='width: 80px;height:25px' /> "; } $challprint = ""; if($k%2==0) $class='tbl_row1'; else $class='tbl_row_alter1'; $str_reval.="<tr>"; $str_reval.="<td class='{$class} tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >{$sl_no}</td>"; $str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;text-align:center; ' >{$av['fdegree']} </td>"; $str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ; ;text-align:left; ' >{$av['fname']}</td>"; $str_reval.="<td class='{$class} tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:11px;text-align:left; ' > {$av['fmobileno']}</td>"; $str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; ;text-align:left; ' > {$av['femailid']}</td>"; $str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;text-align:center; cursor:pointer; ' >{$edit}</td>"; $str_reval.="</tr>"; $sl_no++; $k++; } }else { $str_reval.="<td class='{$class} tbl_row_new' style='text-align:left; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-left:1px solid #C5DBEC;padding:2px;text-align:center; cursor:pointer; ' colspan = '6'><b>No deatils found for the given deatils.</b></td>"; $str_reval.="</tr>"; } $str_reval.="</table>"; $arr['html']=$str_reval; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } } function DisplayAdmentryApplication($aobj_context) { $class_obj=new challan_entries($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->DisplayAdmentryApplication(); } function getAdmentryApplication($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); //and FDELETED = 'F' $mobile = $aobj_context->mobj_data["mobile"]; $degree = $aobj_context->mobj_data["degree"]; $gender = stripslashes($aobj_context->mobj_data["gender"]); $name = $aobj_context->mobj_data["name"]; $type = $aobj_context->mobj_data["type"]; $arr['perdetl'] = array("mobile" => $mobile,"type" => $type, "degree" => $degree, "name" => $name); //var_dump($arr['perdetl']); $combination = $lobj_get_student_details['combination']; $query3 = "SELECT FCATEGORY AS int_code,FDESCPN AS val FROM category where ifnull(FDELETED,'') <> 'T' order by FCATEGORY asc "; $rst3 = $aobj_context->mobj_db->GetAll($query3); $arr['category'] = $rst3; $query3 = "SELECT distinct fdegree AS int_code,FDESCPN AS val FROM degree where ifnull(fadmdeg,'') = 'T' and fdegree = '{$degree}' and ifnull(FDELETED,'') <> 'T' order by fdegree"; $rst3 = $aobj_context->mobj_db->GetAll($query3); $arr['degree'] = $rst3; $query3 = "SELECT distinct fcombcode AS int_code,fcombdesc AS val FROM mascomb WHERE fdegree = '{$degree}' AND IFNULL(FDELETED,'') <> 'T' ORDER BY fcombcode "; $rst3 = $aobj_context->mobj_db->GetAll($query3); $arr['mascomb'] = $rst3; $query4 = "select fboardcode as int_code, fboardname as val from masboard order by forder"; $rst4 = $aobj_context->mobj_db->GetAll($query4); $arr['boards'] = $rst4; $query = "SELECT DISTINCT m.internal_code AS int_code, FCERTDESC AS doc_type , IFNULL(FFILENAME,REPLACE(REPLACE(FCERTDESC,' ','_'),'+','_')) AS FFILENAME FROM masdoc m where m.fdegree = '{$degree}' ORDER BY forder"; $results = $aobj_context->mobj_db->GetAll($query); $arr['masdoc'] = $results; if($type == 'EA') { $get_student_details_slno = "SELECT fappno AS student_entry_admno, fdegree as student_entry_degree_code, DATE_FORMAT(fadmdate,'%d/%m/%Y') AS student_entry_admdate, fdegree AS student_entry_degree_code, fgender = '{$gender}', fcombcode AS combination, fname AS student_entry_name, FFATNAME AS student_entry_fname, FMOTNAME AS student_entry_mname, DATE_FORMAT(fdob,'%d/%m/%Y') AS student_entry_dob, FPHOTOPATH AS student_entry_photo, FSIGNPATH AS student_signature_photo, FRELIGION AS student_entry_religion, FGENDER AS student_entry_gender, FBLOOD_GROUP AS student_entry_blood_grp, FNATIONAL AS student_entry_national, FCASTE AS degree_category, FCATBIRTH AS student_entry_caste, FAADHARNO AS seAadharNumber, FAREA AS farea, FEMAIL AS student_entry_email, FCONTACT_NO AS student_entry_mobile, FMOBILE_NO AS student_entry_phone, FINCOME AS student_entry_fincome, ifnull(FPERMADD1,'') AS student_entry_per_add1, IFNULL(FPERMADD2,'') AS student_entry_per_add2, IFNULL(FPERMADD3,'') AS student_entry_per_add3, IFNULL(FPERDIST,'') AS student_entry_per_dist, IFNULL(FPERSATE,'') AS student_entry_per_state, IFNULL(FPERPINCODE,'') AS student_entry_per_pin, IFNULL(FCURRADD1,'') AS student_entry_comm_addr1, IFNULL(FCURRADD2,'') AS student_entry_comm_addr2, IFNULL(FCURRADD3,'') AS student_entry_comm_addr3, IFNULL(FCOMDIST,'') AS student_entry_comm_dist, IFNULL(FCOMPINCODE,'') AS student_entry_comm_pin, IFNULL(FCOMSTATE,'') AS student_entry_comm_state, FTYPEQUALEXAM AS seTypeOfQualifyingExam, FQUALEXREGNO AS seExamRegNo, FUNIVNAME AS seUniversityName, FQMONTH AS fmonth, FQYEAR AS fyear, FQMAXMARKS AS maxmarks, FQSECMARKS AS secmarks, FQPERCENTAGE AS percentage, ifnull(FCONSTYPE,'') as constype from studadm where FCONTACT_NO ='{$mobile}' and FDEGREE='{$degree}' and ifnull(fdeleted,'') <> 'T' and FCOLLCODE='{$_SESSION['collcode']}'"; $lobj_get_student_details = $aobj_context->mobj_db->getRow($get_student_details_slno); $curl3 = curl_init(); $photo_url = 'https://university-student-photos.s3.ap-south-1.amazonaws.com/'.$_SESSION['FUNIVCODE'].'/'.urlencode($lobj_get_student_details['student_entry_photo']); curl_setopt($curl3, CURLOPT_URL, $photo_url); curl_setopt($curl3, CURLOPT_NOBODY, true); $response_photo = curl_exec($curl3); $httpCode_photo = curl_getinfo($curl3 , CURLINFO_HTTP_CODE); $curl4 = curl_init(); $sign_url = 'https://university-student-photos.s3.ap-south-1.amazonaws.com/'.$_SESSION['FUNIVCODE'].'/'.urlencode($lobj_get_student_details['student_signature_photo']); curl_setopt($curl4, CURLOPT_URL, $sign_url); curl_setopt($curl4, CURLOPT_NOBODY, true); $response_sign_photo = curl_exec($curl4); $httpCode_sign_photo = curl_getinfo($curl4 , CURLINFO_HTTP_CODE); if($lobj_get_student_details['student_entry_photo'] != '' && $httpCode_photo == '200') $lobj_get_student_details['student_entry_photo'] = $photo_url;//.'?'.$currentDate; else $lobj_get_student_details['student_entry_photo'] = "images/default_photo.jpg"; if(!empty($lobj_get_student_details['student_signature_photo']) && $httpCode_sign_photo == '200') $lobj_get_student_details['student_signature_photo'] = $sign_url;//.'?'.$currentDate; else $lobj_get_student_details['student_signature_photo'] = "images/default_photo.jpg"; $arr['perdetl'] = $lobj_get_student_details; $combination = $lobj_get_student_details['combination']; $app_no = $lobj_get_student_details['student_entry_admno']; $get_sub_total = "select FTOTSUB from degree where FDEGREE= '{$degree}' and FEXAMNO='A'"; $lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total); $total_sub = $lobj_sub_total['FTOTSUB']; $get_exsting_data = "select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from (select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options where fappno = '{$app_no}' and FCOLLCODE='{$_SESSION['collcode']}' and FEXAMNO='A' and FDEGREE='{$degree}') 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}' and s.FEXAMNO='A') 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); $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}' 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}' and m.FSUBCODE = s.FSUBCODE group by s.FSUBCODE"; $lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names); $e_data.="<table width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >"; $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); 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 subcode' 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=''; 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 subcode' 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":''; $read_only = "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 subcode' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' onblur='getSubDetails( this.id,{$id});' {$name} 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 subcode' 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; $query = "select * from admfeedetl where fcollcode = '{$_SESSION['collcode']}' and fappno = '{$app_no}'"; $results = $aobj_context->mobj_db->GetAll($query); if($results) { $get_details="SELECT distinct ma.FHEADCODE,IFNULL(ta.FAMOUNT ,ma.FFEE) as FFEE,ma.FMODIFY,ifnull(ta.FAMOUNT ,ma.FFEE) as fee_paid, FCOMBCODE,FCATCODE FROM admfeestr ma left join admfeedetl ta on ma.fdegree = ta.fdegree and ma.fexamno = ta.fexamno and ma.fheadcode = ta.fheadcode WHERE ma.FDEGREE='{$degree}' AND ma.FEXAMNO='A' AND ma.FCOMBCODE='ADM' and ta.fcollcode = '{$_SESSION['collcode']}' and ta.fappno = '{$app_no}' AND ma.FCATCODE='GM' order by ma.fheadcode "; //var_dump($get_details); $lobj_rs = $aobj_context->mobj_db->GetAll($get_details); } else { $get_details="SELECT ma.FHEADCODE,ma.FFEE,ma.FMODIFY,ifnull(ma.FFEE,'') as fee_paid, FCOMBCODE,FCATCODE FROM admfeestr ma WHERE ma.FDEGREE='{$degree}' and FCATCODE = 'GM' AND ma.FEXAMNO='A' AND ma.FCOMBCODE='ADM' order by ma.fheadcode"; $lobj_rs = $aobj_context->mobj_db->GetAll($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']; $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();\" 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['fee_html']= $str_reval; } /*$query = "select fdegree, ifnull(fname,'') as fname, ifnull(fmobileno,'') as fmobileno,ifnull(femail,'') as femail where fdegree = '' and fcollcode = '' and ";*/ echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; if(!empty($lobj_rs)) { echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-2,"Failure"); return; } } function GetCombinationdeg($aobj_context) { $degree = $aobj_context->mobj_data["degree"]; $query3 = "SELECT FCATEGORY AS int_code,FDESCPN AS val FROM category where ifnull(FDELETED,'') <> 'T' order by FCATEGORY asc "; $rst3 = $aobj_context->mobj_db->GetAll($query3); $arr['category'] = $rst3; $query3 = "SELECT distinct fcombcode AS int_code,fcombdesc AS val FROM mascomb WHERE fdegree = '{$degree}' AND IFNULL(FDELETED,'') <> 'T' ORDER BY fcombcode "; $rst3 = $aobj_context->mobj_db->GetAll($query3); $arr['mascomb'] = $rst3; $query4 = "select fboardcode as int_code, fboardname as val from masboard order by forder"; $rst4 = $aobj_context->mobj_db->GetAll($query4); $arr['boards'] = $rst4; $query = "SELECT DISTINCT m.internal_code AS int_code, FCERTDESC AS doc_type , IFNULL(FFILENAME,REPLACE(REPLACE(FCERTDESC,' ','_'),'+','_')) AS FFILENAME FROM masdoc m where m.fdegree = '{$degree}' ORDER BY forder"; $results = $aobj_context->mobj_db->GetAll($query); $arr['masdoc'] = $results; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } function DisplayUserSelectedfile($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $date = date("dmYhis"); $file_name = $aobj_context->mobj_data["file_name"]; $folder_path = $aobj_context->main_src."/upload/"; $db = $aobj_context->mobj_data["db"]; $path_arr = pathinfo($_FILES[$file_name]['name']); $file_ext=$path_arr['extension']; //$temp_path=$aobj_context->main_src."/upload"; $temp_path = $aobj_context->main_src."/".$db."/upload/"; if(!file_exists($temp_path)) { mkdir($temp_path); } $file_path="/{$date}_".$path_arr['basename']; $temp_path.=$file_path; if(isset($_FILES[$file_name]['name']) && $_FILES[$file_name]['name'] != '') { $size=($_FILES[$file_name]['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[$file_name]['tmp_name'],$temp_path)) { $data['path'] ="upload/{$file_path}"; $data['file_name'] =$file_name; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); return; } } echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } function replaceChars($name) { $spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ",""); $link_name = strtolower(str_replace($spl_char,"_",$name)); return str_ireplace("__","_",$link_name); } function savestudententryapplication($aobj_context) { session_start(); $s3 = S3Client::factory( array( 'credentials' => array( 'key' => IAM_KEY, 'secret' => IAM_SECRET ), 'version' => "latest", 'region' => 'ap-south-1' ) ); $db = $aobj_context->mobj_data["db"]; $lstr_param = stripslashes($aobj_context->mobj_data["personal_info"]); $type = stripslashes($aobj_context->mobj_data["type"]); $per_arr_data = json_decode($lstr_param, true); $fappno = stripslashes($aobj_context->mobj_data["fappno"]); $student_photo = stripslashes($aobj_context->mobj_data["student_photo"]); $student_sign = stripslashes($aobj_context->mobj_data["student_sign"]); $gender = stripslashes($aobj_context->mobj_data["gender"]); $rgMultiMarks = stripslashes($aobj_context->mobj_data["rgMultiMarks"]); ////recieve decode json string of subject info $strSubject = stripslashes($aobj_context->mobj_data["pRgSubjects"]); $sub_arr_data = json_decode($strSubject, true); $rgPerArray = array(); for($i=0; $i<count($per_arr_data); $i++) { $rgPerArray[$per_arr_data[$i]['id']] = $per_arr_data[$i]['value']; } $sub_data = array(); for($i=0; $i<count($sub_arr_data); $i++) { $sub_data[$sub_arr_data[$i]['id']] = $sub_arr_data[$i]['value']; } $total = $rgPerArray['fee_paying_2']+$rgPerArray['fee_paying_1']; $get_last_no="select right(concat('0000',ifnull(max(FSLNO),0)+01),4) as app_no from studadm WHERE FDEGREE='{$rgPerArray['student_entry_degree_code']}' and FCOLLCODE = '{$_SESSION['collcode']}'"; $obj = $aobj_context->mobj_db->GetRow($get_last_no); $sl_no = "0000".$obj['app_no']; $sl_no = substr($sl_no, -4); $query = "select FADMPREFIX from control"; $results = $aobj_context->mobj_db->GetRow($query); $FADMPREFIX = $results['FADMPREFIX']; $qry = "select count(*) as cnt from collexam where fdegree = '{$rgPerArray['student_entry_degree_code']}' and fcollcode = '{$_SESSION['collcode']}' and DATE_FORMAT(NOW(),'%Y-%m-%d') BETWEEN DATE_FORMAT(fadmfrom,'%Y-%m-%d') AND DATE_FORMAT(fadmto,'%Y-%m-%d') and fexamno = 'A'"; $student_exam_details = $aobj_context->mobj_db->GetRow($qry); if($student_exam_details['cnt'] == 0) { $arr='Last date for student admission is over'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } /*$query = "select internal_code+1 as FAUTOINCREMENT from studadm order by internal_code desc limit 1"; $results = $aobj_context->mobj_db->GetRow($query); $FAUTOINCREMENT = $results['FAUTOINCREMENT']; $appno = $FADMPREFIX.$FAUTOINCREMENT; $fappno = $appno; $rgPerArray['student_entry_admno'] = $fappno;*/ $college = $_SESSION['collcode']; $total = $rgPerArray['fee_paying_1']+$rgPerArray['fee_paying_2']+$rgPerArray['fee_paying_3']+$rgPerArray['fee_paying_4']+$rgPerArray['fee_paying_5']+$rgPerArray['fee_paying_6']+$rgPerArray['fee_paying_7']; $exam = 'A'; if($rgPerArray['LT'] == 'T') $exam = 'C'; if($rgPerArray['student_entry_admno'] != '') { $insert_qry = "update studadm set FNAME = '{$rgPerArray['student_entry_name']}', fdegree = '{$rgPerArray['student_entry_degree_code']}', FDOB = DATE_FORMAT(STR_TO_DATE('{$rgPerArray['student_entry_dob']}','%d/%m/%Y'),'%Y-%m-%d'), fadmdate = DATE_FORMAT(STR_TO_DATE('{$rgPerArray['student_entry_admdate']}','%d/%m/%Y'),'%Y-%m-%d'), FFATNAME = '{$rgPerArray['student_entry_fname']}', fgender = '{$gender}', FMOTNAME = '{$rgPerArray['student_entry_mname']}', FEMAIL = '{$rgPerArray['student_entry_email']}', FCASTE = '{$rgPerArray['degree_category']}', FCONTACT_NO = '{$rgPerArray['student_entry_mobile']}', FNATIONAL = '{$rgPerArray['student_entry_nationality']}', FCURRADD1 = '{$rgPerArray['student_entry_comm_addr1']}', FCURRADD2 = '{$rgPerArray['student_entry_comm_addr2']}', FCURRADD3 = '{$rgPerArray['student_entry_comm_addr3']}', FCOMDIST = '{$rgPerArray['student_entry_comm_dist']}', FCOMSTATE = '{$rgPerArray['student_entry_comm_state']}', FCOMPINCODE = '{$rgPerArray['student_entry_comm_pin']}', FPERMADD1 = '{$rgPerArray['student_entry_per_add1']}', FPERMADD2 = '{$rgPerArray['student_entry_per_add2']}', FPERMADD3 = '{$rgPerArray['student_entry_per_add3']}', FPERDIST = '{$rgPerArray['student_entry_per_dist']}', FPERSATE = '{$rgPerArray['student_entry_per_state']}', FPERPINCODE = '{$rgPerArray['student_entry_per_pin']}', FRELIGION = '{$rgPerArray['student_entry_religion']}', FMOBILE_NO = '{$rgPerArray['student_entry_phone']}', FCATBIRTH = '{$rgPerArray['student_entry_caste']}', FINCOME = '{$rgPerArray['student_entry_fincome']}', FUNIVNAME = '{$rgPerArray['seUniversityName']}', FQUALEXREGNO = '{$rgPerArray['seExamRegNo']}', FAREA = '{$rgPerArray['farea']}', FQMONTH = '{$rgPerArray['fmonth']}', FQYEAR = '{$rgPerArray['fyear']}', FQMAXMARKS = '{$rgPerArray['maxmarks']}', FQSECMARKS = '{$rgPerArray['secmarks']}', FQPERCENTAGE = '{$rgPerArray['percentage']}', FBLOOD_GROUP = '{$rgPerArray['student_entry_blood_grp']}', FTYPEQUALEXAM = '{$rgPerArray['seTypeOfQualifyingExam']}', fcombcode = '{$rgPerArray['combination']}', FADMFINE = '{$rgPerArray['fee_paying_2']}', FUNIVFEE = '{$rgPerArray['fee_paying_1']}', FTOTFEE = '{$total}', FCONSTYPE = '{$rgPerArray['constype']}', FSTUTYPE = '{$rgPerArray['fstudtype']}', FMEDIUM = '{$rgPerArray['fmedium']}', FQUOTA = '{$rgPerArray['fadmquota']}', flateral_entry = '{$rgPerArray['LT']}', FAPPSTATUS = 'verified', ffinsub = 'T', fexamno = '{$exam}', fcastecert = '{$rgPerArray['fcastecert']}', fincomecert = '{$rgPerArray['fincomecert']}', FACKDATE = now(), FACKUSER = '{$_SESSION['user_type']}' where fappno = '{$rgPerArray['student_entry_admno']}'"; } else { $insert_qry="insert into studadm (FSLNO,FDEGREE,FCOLLCODE,FNAME,FGENDER,FDOB, FEXAMNO,FFATNAME,FMOTNAME,FEMAIL,FCASTE, FCONTACT_NO,FNATIONAL,FCURRADD1,FCURRADD2,FCURRADD3,FCURRADD4, FPERMADD1,FPERMADD2,FPERMADD3,FPERMADD4, FRELIGION,FMOBILE_NO, FCATBIRTH,FADMDATE,FINCOME,FAADHARNO, FUNIVNAME,FQUALEXREGNO, FAPPNO,FAREA,FQMONTH,FQYEAR,FQSECMARKS,FQMAXMARKS,FQPERCENTAGE,FBLOOD_GROUP, FTYPEQUALEXAM,fcombcode,FCREATEDATE, FCREATEUSER,FFINSUB,FACKDATE,FACKUSER,FAPPSTATUS,FCONSTYPE,FADMFINE,FTOTFEE,FUNIVFEE,FSTUTYPE,FMEDIUM,FQUOTA, fincomecert,fcastecert,flateral_entry) values ('{$sl_no}','{$rgPerArray['student_entry_degree_code']}', '{$college}','{$rgPerArray['student_entry_name']}', '{$gender}', date_format(STR_TO_DATE('{$rgPerArray['student_entry_dob']}','%d/%m/%Y'),'%Y-%m-%d'), '{$exam}','{$rgPerArray['student_entry_fname']}', '{$rgPerArray['student_entry_mname']}','{$rgPerArray['student_entry_email']}', '{$rgPerArray['degree_category']}','{$rgPerArray['student_entry_mobile']}', '{$rgPerArray['student_entry_nationality']}', '{$rgPerArray['student_entry_comm_addr1']}', '{$rgPerArray['student_entry_comm_addr2']}', '{$rgPerArray['student_entry_comm_addr3']}', '{$rgPerArray['student_entry_comm_addr4']}', '{$rgPerArray['student_entry_per_add1']}','{$rgPerArray['student_entry_per_add2']}', '{$rgPerArray['student_entry_per_add3']}','{$rgPerArray['student_entry_per_add4']}', '{$rgPerArray['student_entry_religion']}','{$rgPerArray['student_entry_phone']}', '{$rgPerArray['student_entry_caste']}', date_format(now(),'%Y-%m-%d'),'{$rgPerArray['student_entry_fincome']}', '{$rgPerArray['seAadharNumber']}', '{$rgPerArray['seUniversityName']}','{$rgPerArray['seExamRegNo']}', '{$rgPerArray['student_entry_mobile']}', '{$rgPerArray['farea']}', '{$rgPerArray['fmonth']}','{$rgPerArray['fyear']}', '{$rgPerArray['secmarks']}','{$rgPerArray['maxmarks']}', '{$rgPerArray['percentage']}','{$rgPerArray['student_entry_blood_grp']}', '{$rgPerArray['seTypeOfQualifyingExam']}', '{$rgPerArray['combination']}', now(), 'College','T',now(),'{$_SESSION['user_type']}', 'verified','{$rgPerArray['constype']}','{$rgPerArray['fee_paying_2']}','{$total}', '{$total}','{$rgPerArray['fstudtype']}','{$rgPerArray['fmedium']}','{$rgPerArray['fadmquota']}' ,'{$rgPerArray['fincomecert']}','{$rgPerArray['fcastecert']}' ,'{$rgPerArray['LT']}')"; } //$results = $aobj_context->mobj_db->Execute($query); //var_dump($insert_qry); $studresults = $aobj_context->mobj_db->Execute($insert_qry); if($studresults) { if($rgPerArray['student_entry_admno'] == '') { $query = "select internal_code, fdegree, fcollcode, fslno from studadm where fcontact_no = '{$rgPerArray['student_entry_mobile']}' and fappno = '{$rgPerArray['student_entry_mobile']}'"; $results2 = $aobj_context->mobj_db->GetRow($query); //$fappno =""; if(count($results2) > 0) { $internal_code = $results2['internal_code']; $degree = $results2['fdegree']; $college = $results2['fcollcode']; $sl_no = $results2['fslno']; $fappno = '523'.$internal_code; $rgPerArray['student_entry_admno'] = $fappno; $query = "update studadm set fappno = '{$fappno}' where fcontact_no = '{$rgPerArray['student_entry_mobile']}' and fappno = '{$rgPerArray['student_entry_mobile']}'"; $results3 = $aobj_context->mobj_db->Execute($query); } else { $arr['message'] = '2. Error in saving admission details. Send query through I NEED HELP.'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } }else { $query = "select internal_code, fdegree, fcollcode,fappno,fslno from studadm where fappno = '{$rgPerArray['student_entry_admno']}'"; $results2 = $aobj_context->mobj_db->GetRow($query); //$fappno =""; if(count($results2) > 0) { $internal_code = $results2['internal_code']; $degree = $results2['fdegree']; $college = $results2['fcollcode']; $sl_no = $results2['fslno']; $fappno = $results2['fappno']; } } if(count($sub_arr_data) > 0) { $query = "delete from options where fappno = '{$rgPerArray['student_entry_admno']}'"; $deloptresults = $aobj_context->mobj_db->Execute($query); for($k=0;$k<count($sub_data);$k++) { $subcode = "se_sub_code_".$k; if($sub_data[$subcode] != '') { $insSubs .= "('{$degree}','{$sub_data[$subcode][0]}','{$college}','{$sl_no}','{$sub_data[$subcode]}','F','{$fappno}'),"; } } //var_dump($insSubs); $insSubs = rtrim($insSubs,','); $query = "insert into options(FDEGREE, FEXAMNO, FCOLLCODE, FSLNO, FSUBCODE, FDELETED, FAPPNO) values {$insSubs}"; //var_dump($query); $optresults = $aobj_context->mobj_db->Execute($query); } $cert_path = $aobj_context->main_src."/certificates/".$fappno; if(!file_exists($cert_path)) { mkdir($cert_path); } $insert = "INSERT INTO studoc ( app_no, login_cnt, file_path, created_date,fdegree,fcollcode,fdoctype ) select '{$sl_no}', '{$fappno}', null, now(), '{$degree}', '{$college}', ffilename from masdoc where fdegree = '{$degree}'"; $lobj_insert= $aobj_context->mobj_db->Execute($insert); $doc_names = ['ADHAAR', 'CASTE', 'INCOME', 'SSLCMC', 'TCCERT', 'PUMC', 'GCCERT']; // for($i=0;$i<count($doc_names);$i++) // { // $GCCERT = $rgPerArray['h_'.$doc_names[$i]]; // if($GCCERT == '') // continue; // $GCCERT_PATH = $aobj_context->main_src.$GCCERT; // $filename = explode(".", $GCCERT_PATH); // $ext = strtolower($filename[1]); // $GCCERT_FILENAME = $doc_names[$i]; // $GCCERT_FILENAME = $GCCERT_FILENAME.".".$ext; // $GCCERT_FILENAME_FILENAME = $cert_path."/".$GCCERT_FILENAME; // $GCCERT = "certificates/{$fappno}/".$GCCERT_FILENAME; // if(copy($GCCERT_PATH,$GCCERT_FILENAME_FILENAME)) // { // $update = ""; // $update = "update studoc set file_path = '{$GCCERT}' // where login_cnt = '{$fappno}' // and fdoctype = '{$doc_names[$i]}'"; // $lobj_insert= $aobj_context->mobj_db->Execute($update); // unlink($GCCERT_PATH); // } // } for($i=0;$i<count($doc_names);$i++) { $GCCERT = $rgPerArray['h_' . $doc_names[$i]]; if ($GCCERT == '') continue; //$GCCERT_PATH = $aobj_context->main_src . $GCCERT; $GCCERT_PATH = $aobj_context->main_src.'/'.$db.'/'.$GCCERT; $filename = explode(".", $GCCERT_PATH); $ext = strtolower($filename[1]); $GCCERT_FILENAME = $doc_names[$i]; $GCCERT_FILENAME = $GCCERT_FILENAME . "." . $ext; $GCCERT_FILENAME_FILENAME = $cert_path . "/" . $GCCERT_FILENAME; $GCCERT = "certificates/{$rgPerArray['student_entry_admno']}/" . $GCCERT_FILENAME; $GCCERT = $_SESSION['FUNIVCODE'] . "/certificates/{$rgPerArray['student_entry_admno']}/" . $GCCERT_FILENAME; $GCCERT_upd = "certificates/".$rgPerArray['student_entry_admno']."/" . $GCCERT_FILENAME; //var_dump($GCCERT_PATH); if (file_exists($GCCERT_PATH)) { try { $s3->putObject(['Bucket' => ADMISSION_CERTIFICATES, 'Key' => $GCCERT, 'SourceFile' => $GCCERT_PATH]); $update = ''; $insert = "INSERT ignore INTO studoc ( app_no, login_cnt, file_path, created_date,fdegree,fcollcode,fdoctype ) values ( '{$sl_no}', '{$rgPerArray['student_entry_admno']}', '{$GCCERT_upd}',now(),'{$rgPerArray['student_entry_degree_code']}','{$_SESSION['collcode']}', '{$doc_names[$i]}' )"; $lobj_insert = $aobj_context->mobj_db->Execute($insert); $update = "update studoc set file_path = '{$GCCERT_upd}' where login_cnt = '{$rgPerArray['student_entry_admno']}' and fdoctype = '{$doc_names[$i]}'"; //var_dump($update); $lobj_insert = $aobj_context->mobj_db->Execute($update); unlink($GCCERT_PATH); } catch (S3Exception $e) { $arr['message'] = 'Unable to upload documents'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } } $query = "delete from admfeedetl where fappno = '{$fappno}'"; $deladmresults = $aobj_context->mobj_db->Execute($query); $query = "insert into admfeedetl (`FYEAR`,`FDEGREE`,`FEXAMNO`,`FCOLLCODE`,`FSLNO`,`FHEADCODE`,`FAMOUNT`,FAPPNO) values ('2019','{$degree}','A','{$college}', '{$sl_no}','01 REGISTRATION FEE','{$rgPerArray['fee_paying_1']}','{$fappno}'), ('2019','{$degree}','A','{$college}', '{$sl_no}','02 ADMISSION FEE','{$rgPerArray['fee_paying_2']}','{$fappno}'), ('2019','{$degree}','A','{$college}', '{$sl_no}','03 SPORTS FEE','{$rgPerArray['fee_paying_3']}','{$fappno}'), ('2019','{$degree}','A','{$college}', '{$sl_no}','04 PROSESSING FEE','{$rgPerArray['fee_paying_4']}','{$fappno}'), ('2019','{$degree}','A','{$college}', '{$sl_no}','05 CULTURAL ACTIVITIES FEE','{$rgPerArray['fee_paying_5']}','{$fappno}'), ('2019','{$degree}','A','{$college}', '{$sl_no}','06 ELIGIBILITY FEE','{$rgPerArray['fee_paying_6']}','{$fappno}'), ('2019','{$degree}','A','{$college}', '{$sl_no}','07 FINE','{$rgPerArray['fee_paying_7']}','{$fappno}')"; $results = $aobj_context->mobj_db->Execute($query); // $query = "insert into admfeedetl (`FYEAR`,`FDEGREE`,`FEXAMNO`,`FCOLLCODE`,`FSLNO`,`FHEADCODE`,`FAMOUNT`,FAPPNO) values // ('2018','{$degree}','A','{$college}', // '{$sl_no}','01 University Total Fee','{$rgPerArray['fee_paying_1']}','{$fappno}'), // ('2018','{$degree}','A','{$college}', // '{$sl_no}','02 Fine','{$rgPerArray['fee_paying_2']}','{$fappno}')"; //var_dump($query); $photo_filename = $student_photo; $sign_filename = $student_sign; $college_path=$aobj_context->main_src."/student_photos/{$college}"; $degree_path=$aobj_context->main_src."/student_photos/{$college}/".$degree;; $folder_path=$aobj_context->main_src."/student_photos/{$college}/".$degree;; $sign_folder_path = $aobj_context->main_src."/student_photos/{$college}/".$degree."/sign"; $image_path = $aobj_context->main_src.$photo_filename; // if($photo_filename != '') // { // // $filename = explode(".", $photo_filename); // $ext = strtolower($filename[1]); // $photo_filename = $college."_".$degree."_".$fappno; // $photo_filename = $photo_filename.".".$ext; // $full_file_path = $folder_path.'/'.$photo_filename; // if(!file_exists($college_path)) // { // mkdir($college_path); // } // if(!file_exists($degree_path)) // { // mkdir($degree_path); // } // if(!file_exists($sign_folder_path)) // { // mkdir($sign_folder_path); // } // $photo = "student_photos/{$college}/".$degree.'/'.$photo_filename; // //var_dump($image_path); // //var_dump($full_file_path); // // if(copy($image_path,$full_file_path)) // // { // // $update="update studadm set FPHOTOPATH='{$photo}' // // where FAPPNO= '{$fappno}'"; // // $up_obj=$aobj_context->mobj_db->Execute($update); // // unlink($image_path); // // } // } // //update signature path // //$sign_filename = $rgPerArray['sign_path']; // if($sign_filename != '') // { // $sign_path = $aobj_context->main_src.$sign_filename; // $filename = explode(".", $sign_filename); // $ext = strtolower($filename[1]); // $sign_filename = $college."_".$degree."_".$fappno."_sign"; // $sign_filename = $sign_filename.".".$ext; // $full_file_path_sign = $folder_path."/sign/".$sign_filename; // $sign = "student_photos/{$college}/".$degree."/sign/".$sign_filename; // //var_dump($sign_path); // //var_dump($full_file_path_sign); // if(copy($sign_path,$full_file_path_sign)) // { // $update="update studadm set FSIGNPATH='{$sign}' // where FAPPNO= '{$fappno}' "; // $up_obj=$aobj_context->mobj_db->Execute($update); // unlink($sign_path); // } // } //var_dump($photo_filename); if($photo_filename != '') { //$image_path = $aobj_context->main_src.$photo_filename; $image_path = $aobj_context->main_src.'/'.$db.'/'.$photo_filename; $filename = explode(".", $photo_filename); $ext = strtolower($filename[1]); $photo_filename = $college."_".$degree."_".$fappno; $photo_filename = $photo_filename.".".$ext; $full_file_path = $folder_path.'/'.$photo_filename; if(!file_exists($college_path)) { mkdir($college_path); } if(!file_exists($degree_path)) { mkdir($degree_path); } if(!file_exists($sign_folder_path)) { mkdir($sign_folder_path); } $photo_upd = "student_photos/{$college}/" . $degree . '/' . $photo_filename; $photo = $_SESSION['FUNIVCODE'] . "/student_photos/{$college}/" . $degree . '/' . $photo_filename; if (file_exists($image_path)) { try { $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $photo, 'SourceFile' => $image_path]); $update = "update studadm set FPHOTOPATH='{$photo_upd}' where FAPPNO= '{$fappno}'"; $up_obj = $aobj_context->mobj_db->Execute($update); unlink($image_path); } catch (S3Exception $e) { $arr['message'] = 'Unable to upload photo'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } // $photo = "student_photos/{$college}/".$degree.'/'.$photo_filename; // //var_dump($image_path); // //var_dump($full_file_path); // if(copy($image_path,$full_file_path)) // { // $update="update studadm set FPHOTOPATH='{$photo}' // where FAPPNO= '{$fappno}'"; // $up_obj=$aobj_context->mobj_db->Execute($update); // unlink($image_path); // } } //update signature path //$sign_filename = $rgPerArray['sign_path']; if($sign_filename != '') { //$sign_path = $aobj_context->main_src.$sign_filename; $sign_path = $aobj_context->main_src.'/'.$db.'/'.$sign_filename; $filename = explode(".", $sign_filename); $ext = strtolower($filename[1]); $sign_filename = $college."_".$degree."_".$fappno."_sign"; $sign_filename = $sign_filename.".".$ext; $full_file_path_sign = $folder_path."/sign/".$sign_filename; $sign = $_SESSION['FUNIVCODE'] . "/student_photos/{$college}/" . $degree . "/sign/" . $sign_filename; $sign_upd = "student_photos/{$college}/" . $degree . "/sign/" . $sign_filename; if (file_exists($sign_path)) { try { $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $sign, 'SourceFile' => $sign_path]); $update = "update studadm set FSIGNPATH='{$sign_upd}' where FAPPNO='{$fappno}' "; $up_obj = $aobj_context->mobj_db->Execute($update); unlink($sign_path); } catch (S3Exception $e) { $arr['message'] = 'Unable to upload Signature'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); return; } } // $sign = "student_photos/{$college}/".$degree."/sign/".$sign_filename; // //var_dump($sign_path); // //var_dump($full_file_path_sign); // if(copy($sign_path,$full_file_path_sign)) // { // $update="update studadm set FSIGNPATH='{$sign}' // where FAPPNO= '{$fappno}' "; // $up_obj=$aobj_context->mobj_db->Execute($update); // unlink($sign_path); // } } $mobj_jsondata = json_decode($rgMultiMarks,true); //var_dump($this->mobj_jsondata); $sub_marks = array(); for($i=0; $i<count($mobj_jsondata); $i++) { for($j=0;$j<count($mobj_jsondata[$i]);$j++) { $sub_marks[$i][$mobj_jsondata[$i][$j]['name']] = $mobj_jsondata[$i][$j]['value']; } } if(count($mobj_jsondata) > 0) { $query = "delete from qualsubdet where fappno = '{$fappno}'"; //var_dump($query); $resdelt = $aobj_context->mobj_db->Execute($query); } //var_dump(count($sub_marks)); $sql = array(); $j=0; for($i=1; $i<=count($sub_marks);$i++) { $sql[] = "('{$fappno}' ,'{$college}' ,'{$degree}' ,'S0{$i}' ,'{$sub_marks[$j]["subsem1_$i"]}', '{$sub_marks[$j]["subsem1mo_$i"]}' ,'{$sub_marks[$j]["subsem1mm_$i"]}' ,'{$sub_marks[$j]["subsem2mo_$i"]}' ,'{$sub_marks[$j]["subsem2mm_$i"]}' ,'{$sub_marks[$j]["subsem3mo_$i"]}' ,'{$sub_marks[$j]["subsem3mm_$i"]}' ,'{$sub_marks[$j]["subsem4mo_$i"]}' ,'{$sub_marks[$j]["subsem4mm_$i"]}' ,'{$sub_marks[$j]["subsem5mo_$i"]}' ,'{$sub_marks[$j]["subsem5mm_$i"]}' ,'{$sub_marks[$j]["subsem6mo_$i"]}' ,'{$sub_marks[$j]["subsem6mm_$i"]}' ,'{$sub_marks[$j]["subtotalmo_$i"]}' ,'{$sub_marks[$j]["subtotalmm_$i"]}' ,'{$sub_marks[$j]["subpercentagemm_$i"]}')"; $j++; } $query = 'INSERT INTO qualsubdet(fappno, fcollcode, fdegree, fsubcode, fsubname, fsecmarksa , fmaxmarksa, fsecmarksb, fmaxmarksb, fsecmarksc, fmaxmarksc, fsecmarksd, fmaxmarksd, fsecmarkse, fmaxmarkse, fsecmarksf, fmaxmarksf, ftotsecmarks, ftotmaxmarks, fsubpercent ) VALUES '.implode(',', $sql); //var_dump($query); $resultqualdets = $aobj_context->mobj_db->Execute($query); } if($studresults && $optresults) { $data = $fappno; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); return; } else { $data = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } } function DiaplayStudentSignature($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $date = date("dmYhis"); $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."/upload/"; if(!file_exists($temp_path)) { mkdir($temp_path); } $file_path="/{$date}_{$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="upload/{$file_path}"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); return; } } echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } function DiaplayStudentPhoto($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $date = date("dmYhis"); $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."/upload/"; if(!file_exists($temp_path)) { mkdir($temp_path); } $file_path="/{$date}_{$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="upload/{$file_path}"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); return; } } echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); return; } function getcombinationsubjectdet($aobj_context) { $degree = $aobj_context->mobj_data["degree_code"]; $combination = $aobj_context->mobj_data["combination"]; $exam = $aobj_context->mobj_data["exam"]; $get_sub_total = "select FTOTSUB from degree where FDEGREE= '{$degree}' and FEXAMNO='A'"; $lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total); $total_sub = $lobj_sub_total['FTOTSUB']; //$exam = 'A'; $get_exsting_data = "select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from (select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options where fappno = '{$app_no}' and FCOLLCODE='{$_SESSION['collcode']}' and FEXAMNO='{$exam}' and FDEGREE='{$degree}') 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}' 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); $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}' 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}' and m.FSUBCODE = s.FSUBCODE group by s.FSUBCODE"; //var_dump($get_true_sub_names); //var_dump($get_exsting_data); $lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names); $e_data.="<table width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >"; $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); 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 subcode' 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=''; 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 subcode' 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 subcode' 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 subcode' 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; if(!empty($lobj_get_true_sub_names)) { echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-2,"Failure"); return; } } ?>
Close
