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.135.247.24
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_adm_application.php
<?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 DisplayAdmApplication() { $adm_degree = trim($this->aobj_context->mobj_data["degree"]); $appfrom = trim($this->aobj_context->mobj_data["app_from"]); $appto = trim($this->aobj_context->mobj_data["app_to"]); $status = trim($this->aobj_context->mobj_data["status"]); $cnd = ''; if($status == 'Verified') $cnd = "and ifnull(FAPPSTATUS,'Pending') = 'verified'"; else if($status == 'Pending') $cnd = "and ifnull(FAPPSTATUS,'Pending') <> 'verified'"; else $cnd = ''; if($_SESSION['FUNIVCODE'] == '027') $paysts = "and ifnull(FPAYSTATUS,'') = 'success'"; else $paysts = ''; $query = "select fname, fappno, fdegree, fcombcode, fcaste, DATE_FORMAT(fadmdate, '%d/%m/%Y') as fadmdate, ifnull(FAPPSTATUS,'Pending') as appstatus, ifnull(FAPPRSTATUS,'Pending') as apprstatus, ifnull(FTOTFEE,0) as FTOTFEE from studadm where fcollcode = '{$this->collcode}' and ifnull(fdeleted,'') <> 'T' and fdegree = '{$adm_degree}' AND CAST(fappno AS CHAR) BETWEEN '{$appfrom}' AND '{$appto}' {$paysts} {$cnd}"; // var_dump($query);die(); $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;border-top: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;border-top:1px solid #C5DBEC;'>App. No.</td>"; // $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top: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;border-top:1px solid #C5DBEC;'>Degree</td>"; // $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Combination</td>"; // $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Cat.</td>"; // $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Amount</td>"; // $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Status</td>"; // $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Adm. Date</td>"; // $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Print</td>"; // $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Action</td>"; // $str_reval .= "<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'>Remove</td>"; // /*$str_reval.="<td align='center' style=' font-size:11px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;border-top:1px solid #C5DBEC;'> </td>"; */ // $str_reval .= "</tr>"; $str_reval.="<table style='padding: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:5px; border-top:1px solid #C5DBEC; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl No</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Degree</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>App. No.</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Student Name</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Adm. Date</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Combination</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Category</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Amount</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Status</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Edit</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Print</td>"; $str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Remove</td>"; /*$str_reval.="<td align='center' style='padding:5px; border-top:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> </td>"; */ $str_reval.="</tr>"; $k=0; $sl_no=1; if($lobj_get_data) { foreach($lobj_get_data as $ak=>$av) { if($av['appstatus'] == 'verified') { $edit="<center><span style='background-color: #008cba;border: none; color: white; padding: 5px 10px; text-align: center; text-decoration: none; display: inline-block; cursor: pointer; border-radius: 3px;'>Verified</span></center>"; $remove ="<center><span style='background-color: #008cba;border: none; color: white; padding: 5px 10px; text-align: center; text-decoration: none; display: inline-block; cursor: pointer; border-radius: 3px;' onclick='RemoveApplication(\"{$av['fappno']}\", \"{$av['fdegree']}\")'>Remove</span></center>"; if($av['apprstatus'] == 'APPROVED') { $remove ="<center><span style='background-color: #008cba;border: none; color: white; padding: 5px 10px; text-align: center; text-decoration: none; display: inline-block; cursor: pointer; border-radius: 3px;'>{$av['apprstatus']}</span></center>"; }else { $remove ="<center><span style='background-color: #008cba;border: none; color: white; padding: 5px 10px; text-align: center; text-decoration: none; display: inline-block; cursor: pointer; border-radius: 3px;' onclick='RemoveApplication(\"{$av['fappno']}\", \"{$av['fdegree']}\")'>Remove</span></center>"; } }else { $edit="<center><span style='background-color: #008cba;border: none; color: white; padding: 5px 10px; text-align: center; text-decoration: none; display: inline-block; cursor: pointer; border-radius: 3px;' onclick='EditStudentDetails(\"{$av['fappno']}\", \"{$av['fdegree']}\", \"ACK\")'>Edit</span></center>"; $remove ="<center><span style='background-color: #008cba;border: none; color: white; padding: 5px 10px; text-align: center; text-decoration: none; display: inline-block; cursor: pointer; border-radius: 3px;'>Remove</span></center>"; } //Verified $print ="<center><span style='background-color: #008cba;border: none; color: white; padding: 5px 10px; text-align: center; text-decoration: none; display: inline-block; cursor: pointer; border-radius: 3px;' onclick='printapplication(\"{$av['fappno']}\", \"{$av['fdegree']}\")'>Print</span></center>"; /*$edit="<img onclick='EditStudentDetails(\"{$av['fappno']}\", \"{$av['fdegree']}\")' src='img/edit.png' title='Edit' style='width: 80px;height:25px' /> ";*/ //var_dump($remove); $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['fappno']} </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['fname']}</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:center; ' >{$av['fcombcode']}</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['fcaste']}</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['FTOTFEE']}</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['appstatus']}</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['fadmdate']}</td>"; // $str_reval .= "<td class='{$class} tbl_row_new' align='center' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;text-align:center; cursor:pointer; ' >{$print}</td>"; // $str_reval .= "<td class='{$class} tbl_row_new' align='center' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;text-align:center; ' >{$edit}</td>"; // $str_reval .= "<td class='{$class} tbl_row_new' align='center' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;text-align:center; ' >{$remove}</td>"; // $str_reval .= "</tr>"; $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:center; ' >{$av['fappno']} </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; font-size:11px;text-align:left; ' > {$av['fname']}</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['fadmdate']}</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['fcombcode']}</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['fcaste']}</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['FTOTFEE']}</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['appstatus']}</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; ' >{$edit}</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; ' >{$print}</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; ' >{$remove}</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 = '10'><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 DisplayAdmApplication($aobj_context) { $class_obj=new challan_entries($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->DisplayAdmApplication(); } function getappnostudentdetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); //and FDELETED = 'F' $app_no = $aobj_context->mobj_data["app_no"]; $degree = $aobj_context->mobj_data["degree"]; // $arr['msg'] = 'Last date over'; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"Failure"); // return; $get_student_details_slno = "SELECT fappno AS student_entry_admno, fexamno as student_entry_exam, fdegree as student_entry_degree_code, DATE_FORMAT(fadmdate,'%d/%m/%Y') AS student_entry_admdate, fdegree AS student_entry_degree_code, 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, concat('********',right(FAADHARNO,4)) 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, fincomecert AS fincomecert, fcastecert AS fcastecert, 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, flateral_entry as LT, FQMAXMARKS AS maxmarks, FQSECMARKS AS secmarks, FQPERCENTAGE AS percentage, ifnull(FCONSTYPE,'') as constype, FQUOTA as fadmquota, FMEDIUM as fmedium, FSTUTYPE as fstudtype, IFNULL(ffeenumber,'') AS ffeenumber, DATE_FORMAT(ffeedate,'%d/%m/%Y') AS ffeedate from studadm where fappno='{$app_no}' and FDEGREE='{$degree}' and ifnull(fdeleted,'') <> 'T' and FCOLLCODE='{$_SESSION['collcode']}'"; // var_dump($get_student_details_slno); $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']; $fstudtype = $lobj_get_student_details['fstudtype']; $student_entry_exam = $lobj_get_student_details['student_entry_exam']; $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; // $deg = substr_replace($degree ,"", -1); // $degree1 = $deg.'1'; // $degree2 = $deg.'2'; $query3 = "SELECT distinct fdegree AS int_code,concat(fdegree,' - ',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; $url = 'https://admission-certificates.s3.ap-south-1.amazonaws.com/'.$_SESSION['FUNIVCODE'].'/'; $query = "SELECT DISTINCT m.internal_code AS int_code, FCERTDESC AS doc_type , IFNULL(FFILENAME,REPLACE(REPLACE(FCERTDESC,' ','_'),'+','_')) AS FFILENAME, if(ifnull(s.file_path,'')='','',concat('{$url}',ifnull(s.file_path,''))) as file_path FROM masdoc m left JOIN studoc s ON s.fdegree = m.fdegree AND login_cnt = '{$app_no}' AND s.fdoctype = m.FFILENAME AND fcollcode = '{$_SESSION['collcode']}' where m.fdegree = '{$degree}' and ifnull(s.fdeleted,'') <> 'T' ORDER BY forder"; // var_dump($query); $results = $aobj_context->mobj_db->GetAll($query); $arr['masdoc'] = $results; $get_sub_total = "select FTOTSUB,fdeggrp from degree where FDEGREE= '{$degree}' and FEXAMNO= '{$student_entry_exam}'"; $lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total); $total_sub = $lobj_sub_total['FTOTSUB']; $fdeggrp = $lobj_sub_total['fdeggrp']; $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 FDEGREE='{$degree}') a left join (select s.FDEGREE, s.FSUBCODE,FSUBNAME,FSUBSHORT, if(ifnull(m.fsubcode,'') = '',s.FMANDATORY,'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}' and m.FSUBCODE = s.FSUBCODE where d.FDEGREE='{$degree}') 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="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); // var_dump($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;' disabled 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 disabled 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 disabled value='{$value['FSUBNAME']}'> </td>"; $e_data.="</tr>"; $k++; $id++; } $name=''; $pmode = 1; 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='{$_SESSION['collcode']}' and s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and s.FDEGREE='{$degree}' and d.fslno = ( select MAX(s.fslno) from studadm s where s.FDEGREE='{$degree}' AND FCOLLCODE='{$_SESSION['collcode']}' ) group by s.FSUBCODE "; $lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution); } 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); // var_dump($remaining_count,$total_sub,$lobj_get_exsting_data); for($h=0;$h<count($lobj_get_exsting_data);$h++) { $read_only=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?"disabled":''; //$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);' {$read_only} 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['deggrp']=$fdeggrp; $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 ta.FHEADCODE,IFNULL(ta.FAMOUNT,'') as FFEE, 'T' as FMODIFY, ifnull(ta.FAMOUNT,'') as fee_paid FROM admfeedetl ta WHERE ta.fappno = '{$app_no}'"; //var_dump($get_details); $lobj_rs = $aobj_context->mobj_db->GetAll($get_details); } else { $get_details="SELECT ma.FHEADCODE,ma.FFEE, ifnull(ma.FMODIFY,'F') as 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' and ma.fconstype = '{$fstudtype}' order by ma.fheadcode"; // var_dump($get_details); $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']; $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();\" onkeypress='return acceptNumbersOnlyForModule(event);' {$cnd} 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 * from qualsubdet where fappno = '{$app_no}' and fdegree = '{$degree}' and fcollcode ='{$_SESSION['collcode']}'"; $results = $aobj_context->mobj_db->getAll($query); $arr['qualdet'] = $results; $arr['qualcount'] = count($results); // var_dump($arr); if(!empty($lobj_get_student_details)) { 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 getappnostudentdetailsjssun($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); //and FDELETED = 'F' $app_no = $aobj_context->mobj_data["app_no"]; $degree = $aobj_context->mobj_data["degree"]; // $arr['msg'] = 'Last date over'; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-2,"Failure"); // return; $get_student_details_slno = "SELECT fappno AS student_entry_admno, fexamno as student_entry_exam, fdegree as student_entry_degree_code, ifnull(ffatmob,'') as student_entry_ffmob, ifnull(idFatOccup,'')as student_entry_ffoccp, ifnull(fFatAnInc,'')as student_entry_ffincom, ifnull(fmotmob,'') as student_entry_fmmob, ifnull(idMotOccup,'')as student_entry_fmoccp, ifnull(fMotAnInc,'')as student_entry_fmincom, ifnull(fparexser,'') as student_entry_fparexser, ifnull(fpergovt,'')as student_entry_fpergovt, ifnull(fstdncc,'')as student_entry_fstdncc, ifnull(ftenregno,'')as student_entry_ftenregno, ifnull(ftenminmrk,'') as student_entry_ftenminmrk, ifnull(ftenmaxmrk,'')as student_entry_ftenmaxmrk, ifnull(ftenper,'')as student_entry_ftenper, ifnull(ftenbrd,'') as student_entry_ftenbrd, ifnull(ftenschname,'')as student_entry_ftenschname, ifnull(ftenlocsch,'')as student_entry_ftenlocsch, ifnull(FQUOTA,'')as FQUOTA, ifnull(ftwtregno,'')as student_entry_ftwtregno, ifnull(ftwtminmrk,'') as student_entry_ftwtminmrk, ifnull(ftwtmaxmrk,'')as student_entry_ftwtmaxmrk, ifnull(ftwtper,'')as student_entry_ftwtper, ifnull(ftwtbrd,'') as student_entry_ftwtbrd, ifnull(ftwtcollname,'')as student_entry_ftwtcollname, ifnull(ftwtloccoll,'')as student_entry_ftwtloccoll, ifnull(fdipregno,'')as student_entry_fdipregno, ifnull(fthredipmin,'') as student_entry_fthredipmin, ifnull(fthredipmax,'')as student_entry_fthredipmax, ifnull(fdipper,'')as student_entry_fdipper, ifnull(fdipbrd,'') as student_entry_fdipbrd, ifnull(fdipcollname,'')as student_entry_fdipcollname, ifnull(fdiploccoll,'')as student_entry_fdiploccoll, ifnull(fenttstnm,'')as student_entry_fenttstnm, ifnull(fentmax,'')as student_entry_fentmax, ifnull(fentper,'') as student_entry_fentper, ifnull(frankobt,'')as student_entry_frankobt, ifnull(fentmin,'')as student_entry_fentmin, ifnull(fphymax,'') as student_entry_fphymax, ifnull(fphysec,'')as student_entry_fphysec, ifnull(fphyper,'')as student_entry_fphyper, ifnull(fmatmax,'') as student_entry_fmatmax, ifnull(fmatsec,'')as student_entry_fmatsec, ifnull(fmatper,'')as student_entry_fmatper, ifnull(fchemax,'') as student_entry_fchemax, ifnull(fchesec,'')as student_entry_fchesec, ifnull(fcheper,'')as student_entry_fcheper, ifnull(fbiomax,'') as student_entry_fbiomax, ifnull(fbiosec,'')as student_entry_fbiosec, ifnull(fbioper,'')as student_entry_fbioper, ifnull(fpcmtotmax,'')as student_entry_fpcmtotmax, ifnull(fpcbtotmax,'')as student_entry_fpcbtotmax, ifnull(fpcmscraggr,'')as student_entry_fpcmscraggr, ifnull(fpcbscraggr,'')as student_entry_fpcbscraggr, DATE_FORMAT(fadmdate,'%d/%m/%Y') AS student_entry_admdate, fdegree AS student_entry_degree_code, 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, CASE WHEN FAADHARNO IS NULL OR FAADHARNO = '' THEN '' ELSE CONCAT('********', RIGHT(FAADHARNO, 4)) END 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, fincomecert AS fincomecert, fcastecert AS fcastecert, 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, flateral_entry as LT, FQMAXMARKS AS maxmarks, FQSECMARKS AS secmarks, FQPERCENTAGE AS percentage, ifnull(FCONSTYPE,'') as constype, FQUOTA as fadmquota, FMEDIUM as fmedium, FSTUTYPE as fstudtype, IFNULL(ffeenumber,'') AS ffeenumber, DATE_FORMAT(ffeedate,'%d/%m/%Y') AS ffeedate from studadm where fappno='{$app_no}' and FDEGREE='{$degree}' and ifnull(fdeleted,'') <> 'T' and FCOLLCODE='{$_SESSION['collcode']}'"; // var_dump($get_student_details_slno);die(); $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']; $fstudtype = $lobj_get_student_details['fstudtype']; $student_entry_exam = $lobj_get_student_details['student_entry_exam']; $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; // $deg = substr_replace($degree ,"", -1); // $degree1 = $deg.'1'; // $degree2 = $deg.'2'; $query3 = "SELECT distinct fdegree AS int_code,concat(fdegree,' - ',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; $url = 'https://admission-certificates.s3.ap-south-1.amazonaws.com/'.$_SESSION['FUNIVCODE'].'/'; $query = "SELECT DISTINCT m.internal_code AS int_code, FCERTDESC AS doc_type , IFNULL(FFILENAME,REPLACE(REPLACE(FCERTDESC,' ','_'),'+','_')) AS FFILENAME, if(ifnull(s.file_path,'')='','',concat('{$url}',ifnull(s.file_path,''))) as file_path FROM masdoc m left JOIN studoc s ON s.fdegree = m.fdegree AND login_cnt = '{$app_no}' AND s.fdoctype = m.FFILENAME AND fcollcode = '{$_SESSION['collcode']}' where m.fdegree = '{$degree}' and ifnull(s.fdeleted,'') <> 'T' ORDER BY forder"; //var_dump($query); $results = $aobj_context->mobj_db->GetAll($query); $arr['masdoc'] = $results; $get_sub_total = "select FTOTSUB,fdeggrp from degree where FDEGREE= '{$degree}' and FEXAMNO= '{$student_entry_exam}'"; $lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total); $total_sub = $lobj_sub_total['FTOTSUB']; $fdeggrp = $lobj_sub_total['fdeggrp']; $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 FDEGREE='{$degree}') a left join (select s.FDEGREE, s.FSUBCODE,FSUBNAME,FSUBSHORT, if(ifnull(m.fsubcode,'') = '',s.FMANDATORY,'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}' and m.FSUBCODE = s.FSUBCODE where d.FDEGREE='{$degree}') 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;' disabled 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 disabled 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 disabled value='{$value['FSUBNAME']}'> </td>"; $e_data.="</tr>"; $k++; $id++; } $name=''; $pmode = 1; 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='{$_SESSION['collcode']}' and s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and s.FDEGREE='{$degree}' and d.fslno = ( select MAX(s.fslno) from studadm s where s.FDEGREE='{$degree}' AND FCOLLCODE='{$_SESSION['collcode']}' ) group by s.FSUBCODE "; $lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution); } 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); // var_dump($remaining_count,$total_sub,$lobj_get_exsting_data); for($h=0;$h<count($lobj_get_exsting_data);$h++) { $read_only=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?"disabled":''; //$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);' {$read_only} 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['deggrp']=$fdeggrp; $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 ta.FHEADCODE,IFNULL(ta.FAMOUNT,'') as FFEE, 'T' as FMODIFY, ifnull(ta.FAMOUNT,'') as fee_paid FROM admfeedetl ta WHERE ta.fappno = '{$app_no}'"; //var_dump($get_details); $lobj_rs = $aobj_context->mobj_db->GetAll($get_details); } else { $get_details="SELECT ma.FHEADCODE,ma.FFEE, ifnull(ma.FMODIFY,'F') as 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' and ma.fconstype = '{$fstudtype}' order by ma.fheadcode"; // var_dump($get_details); $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']; $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();\" onkeypress='return acceptNumbersOnlyForModule(event);' {$cnd} 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 * from qualsubdet where fappno = '{$app_no}' and fdegree = '{$degree}' and fcollcode ='{$_SESSION['collcode']}'"; // var_dump($query); $results = $aobj_context->mobj_db->getAll($query); $arr['qualdet'] = $results; $arr['qualcount'] = count($results); if(!empty($lobj_get_student_details)) { 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 DisplayUserSelectedfile($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $date = date("dmYhis"); $file_name = $aobj_context->mobj_data["file_name"]; $db = $aobj_context->mobj_data["db"]; $folder_path = $aobj_context->main_src."/upload/"; $path_arr = pathinfo($_FILES[$file_name]['name']); $file_ext=$path_arr['extension']; $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>2048) { $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 savestudentapplication($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"]); $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); $feedet = stripslashes($aobj_context->mobj_data["feedet"]); $fee_arr_data = json_decode($feedet, true); $ffeedate = $aobj_context->mobj_data["ffeedate"]; $ffeeno = $aobj_context->mobj_data["ffeeno"]; // var_dump($ffeedate);var_dump($ffeeno); // die(); $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']; } //if($rgPerArray['combination'] ) //if($rgPerArray['student_entry_degree_code']) // $query = "select a.fcollcode, a.fdegree, a.fcombcode, // sum(if(ifnull(a.FAPPSTATUS,'') = '',0,1)) as fcount, // ifnull(b.fintake,0) as fintake // from studadm a // left join collcomb b on a.fcollcode = b.fcollcode and a.fdegree = b.fdegree // and a.fcombcode = b.fcombcode // where a.fcollcode = '{$_SESSION['collcode']}' // and a.fcombcode = '{$rgPerArray['combination']}' // and a.fdegree = '{$rgPerArray['student_entry_degree_code']}' // and ifnull(a.fdeleted,'') <> 'T' // group by a.fcollcode,a.fdegree,a.fcombcode"; // //var_dump($query); // $sresult = $aobj_context->mobj_db->GetRow($query); // if($sresult['fcount']>=$sresult['fintake']) // { // $data = "Intake Exceeded for degree: ".$rgPerArray['student_entry_degree_code']." Combination: ".$rgPerArray['combination']; // echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); // return; // } $query = "select b.fcollcode, b.fdegree, b.fcombcode, sum(if(ifnull(a.FAPPSTATUS,'') = '',0,1)) as fcount, ifnull(b.fintake,0) as fintake from collcomb b left join studadm a on a.fcollcode = b.fcollcode and a.fdegree = b.fdegree and a.fcombcode = b.fcombcode where b.fcollcode = '{$_SESSION['collcode']}' and b.fcombcode = '{$rgPerArray['combination']}' and b.fdegree = '{$rgPerArray['student_entry_degree_code']}' and a.fexamno = 'A' and ifnull(a.fdeleted,'') <> 'T' group by a.fcollcode,a.fdegree,a.fcombcode"; $sresult = $aobj_context->mobj_db->GetRow($query); if($_SESSION['FUNIVCODE'] != '097'){ if ($sresult['fcount'] >= $sresult['fintake']) { $data = "Intake Exceeded for degree: " . $rgPerArray['student_entry_degree_code'] . " Combination: " . $rgPerArray['combination']; echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); return; } } $query = "select fslno from studadm where fappno = '{$rgPerArray['student_entry_admno']}'"; $res = $aobj_context->mobj_db->GetRow($query); $sl_no = $res['fslno']; $exam = 'A'; if($rgPerArray['LT'] == 'T') $exam = 'C'; $sql = array(); foreach($fee_arr_data as $value) { $year = date("Y"); $sql[] = "('{$year}','{$rgPerArray["student_entry_degree_code"]}','{$exam}','{$_SESSION['FCOLLCODE']}', '{$sl_no}','{$value['id']}','{$value['value']}','{$rgPerArray['student_entry_admno']}')"; } $total = $rgPerArray['fee_paying_2']+$rgPerArray['fee_paying_1']+$rgPerArray['fee_paying_3']+$rgPerArray['fee_paying_4']+$rgPerArray['fee_paying_5']+$rgPerArray['fee_paying_6']+$rgPerArray['fee_paying_7']+$rgPerArray['fee_paying_8']; $query = "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']}', FTOTFEE = '{$total}', 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']}', 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']}', ffeenumber = '{$ffeeno}', ffeedate = DATE_FORMAT(STR_TO_DATE('{$ffeedate}','%d/%m/%Y'),'%Y-%m-%d'), fpcmtotmax = '{$rgPerArray['student_entry_fpcmtotmax']}', fpcbtotmax = '{$rgPerArray['student_entry_fpcbtotmax']}', fpcmscraggr = '{$rgPerArray['student_entry_fpcmscraggr']}', fpcbscraggr = '{$rgPerArray['student_entry_fpcbscraggr']}', fphymax = '{$rgPerArray['student_entry_fphymax']}', fphysec = '{$rgPerArray['student_entry_fphysec']}', fmatmax = '{$rgPerArray['student_entry_fmatmax']}', fmatsec = '{$rgPerArray['student_entry_fmatsec']}', fchemax = '{$rgPerArray['student_entry_fchemax']}', fchesec = '{$rgPerArray['student_entry_fchesec']}', fbiomax = '{$rgPerArray['student_entry_fbiomax']}', fbiosec = '{$rgPerArray['student_entry_fbiosec']}' where fappno = '{$rgPerArray['student_entry_admno']}'"; $results = $aobj_context->mobj_db->Execute($query); if(count($sub_arr_data) >0) { $query = "delete from options where fappno = '{$rgPerArray['student_entry_admno']}'"; $deloptresults = $aobj_context->mobj_db->Execute($query); //var_dump($query); } if(count($fee_arr_data) > 0) { $query = "delete from admfeedetl where fappno = '{$rgPerArray['student_entry_admno']}'"; $deladmresults = $aobj_context->mobj_db->Execute($query); $query = "insert into admfeedetl (`FYEAR`,`FDEGREE`,`FEXAMNO`,`FCOLLCODE`,`FSLNO`,`FHEADCODE`,`FAMOUNT`,FAPPNO) VALUES ".implode(',', $sql); //var_dump($query); $results = $aobj_context->mobj_db->Execute($query); } for($k=0;$k<count($sub_data);$k++) { $subcode = "se_sub_code_".$k; $exam = substr($sub_data[$subcode], 0, 1); $query = "insert into options(FDEGREE, FEXAMNO, FCOLLCODE, FSLNO, FSUBCODE, FDELETED,fappno) values ( '{$rgPerArray["student_entry_degree_code"]}', '{$exam}', '{$_SESSION['collcode']}', '{$sl_no}', '{$sub_data[$subcode]}', 'F','{$rgPerArray['student_entry_admno']}')"; //var_dump($query); $optresults = $aobj_context->mobj_db->Execute($query); //var_dump($optresults); } $cert_path = $aobj_context->main_src."/certificates/".$rgPerArray['student_entry_admno']; //is successfully inserted $fappno = $rgPerArray['student_entry_admno']; if(!file_exists($cert_path)) { mkdir($cert_path); } $doc_names = ['ADHAAR', 'CASTE', 'INCOME', 'SSLCMC', 'TCCERT', 'PUMC', 'GCCERT', 'DEGMC']; // ------------- Document Strart -------------------////// for($i=0;$i<count($doc_names);$i++) { $GCCERT = $rgPerArray['h_'.$doc_names[$i]]; if($GCCERT == '') continue; $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; $degree = $rgPerArray["student_entry_degree_code"]; $college = $_SESSION['collcode']; $insert = "INSERT ignore 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); $GCCERT_FILENAME_FILENAME = $cert_path."/".$GCCERT_FILENAME; $GCCERT = "certificates/{$rgPerArray['student_entry_admno']}/".$GCCERT_FILENAME; $GCCERT = $_SESSION['FUNIVCODE']."/certificates/{$fappno}/".$GCCERT_FILENAME; $GCCERT_upd = "certificates/{$fappno}/".$GCCERT_FILENAME; //var_dump($GCCERT_PATH); if(file_exists($GCCERT_PATH)) { try{ $s3->putObject(['Bucket' => ADMISSION_CERTIFICATES, 'Key' => $GCCERT, 'SourceFile' => $GCCERT_PATH]); $update = ''; $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; } } // if(copy($GCCERT_PATH,$GCCERT_FILENAME_FILENAME)) // { // $query = "delete from studoc where login_cnt = '{$rgPerArray['student_entry_admno']}' // and app_no = '{$sl_no}' // and fdoctype = '{$doc_names[$i]}'"; // $studocresults = $aobj_context->mobj_db->Execute($query); // //var_dump($query); // $insert = "INSERT INTO studoc // ( // app_no, // login_cnt, // file_path, // created_date,fdegree,fcollcode,fdoctype // ) // values // ( // '{$sl_no}', // '{$rgPerArray['student_entry_admno']}', // '{$GCCERT}',now(),'{$rgPerArray['student_entry_degree_code']}','{$_SESSION['collcode']}', // '{$doc_names[$i]}' // )"; // //var_dump($insert); // $lobj_insert= $aobj_context->mobj_db->Execute($insert); // unlink($GCCERT_PATH); // } } $query = "update studoc set fdegree = '{$rgPerArray['student_entry_degree_code']}' where login_cnt = '{$rgPerArray['student_entry_admno']}'"; $res = $aobj_context->mobj_db->Execute($query); $college = $_SESSION['collcode']; $degree = $rgPerArray['student_entry_degree_code']; $fappno = $rgPerArray['student_entry_admno']; $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"; if($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; } } // 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.'/'.$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 = "student_photos/{$college}/".$degree."/sign/".$sign_filename; //var_dump($sign_path); //var_dump($full_file_path_sign); $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; } } // 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); //var_dump($resultqualdets); if($results && $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 savestudentapplicationJssun($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"]); $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); $feedet = stripslashes($aobj_context->mobj_data["feedet"]); $fee_arr_data = json_decode($feedet, true); $ffeedate = $aobj_context->mobj_data["ffeedate"]; $ffeeno = $aobj_context->mobj_data["ffeeno"]; $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']; } $query = "select b.fcollcode, b.fdegree, b.fcombcode, sum(if(ifnull(a.FAPPSTATUS,'') = '',0,1)) as fcount, ifnull(b.fintake,0) as fintake from collcomb b left join studadm a on a.fcollcode = b.fcollcode and a.fdegree = b.fdegree and a.fcombcode = b.fcombcode where b.fcollcode = '{$_SESSION['collcode']}' and b.fdegree = '{$rgPerArray['student_entry_degree_code']}' and a.fexamno = 'A' and ifnull(a.fdeleted,'') <> 'T' group by a.fcollcode,a.fdegree,a.fcombcode"; $sresult = $aobj_context->mobj_db->GetRow($query); // if ($sresult['fcount'] >= $sresult['fintake']) { // $data = "Intake Exceeded for degree: " . $rgPerArray['student_entry_degree_code'] . " Combination: " . $rgPerArray['combination']; // echo $aobj_context->mobj_output->ToJSONEnvelope($data, -1, "failure"); // return; // } $query = "select fslno from studadm where fappno = '{$rgPerArray['student_entry_admno']}'"; $res = $aobj_context->mobj_db->GetRow($query); $sl_no = $res['fslno']; $exam = 'A'; if($rgPerArray['LT'] == 'T') $exam = 'C'; $sql = array(); foreach($fee_arr_data as $value) { $year = date("Y"); $sql[] = "('{$year}','{$rgPerArray["student_entry_degree_code"]}','{$exam}','{$_SESSION['FCOLLCODE']}', '{$sl_no}','{$value['id']}','{$value['value']}','{$rgPerArray['student_entry_admno']}')"; } $total = $rgPerArray['fee_paying_2']+$rgPerArray['fee_paying_1']+$rgPerArray['fee_paying_3']+$rgPerArray['fee_paying_4']+$rgPerArray['fee_paying_5']+$rgPerArray['fee_paying_6']+$rgPerArray['fee_paying_7']+$rgPerArray['fee_paying_8']; if(strpos($rgPerArray['seAadharNumber'],'********') === 0){ $faadhaar = ""; }else{ $faadhaar = ",FAADHARNO = '{$rgPerArray['seAadharNumber']}'"; } $query = "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']}', FTOTFEE = '{$total}', 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']}', 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']}', ffatmob = '{$rgPerArray['student_entry_ffmob']}', idFatOccup = '{$rgPerArray['student_entry_ffoccp']}', fFatAnInc = '{$rgPerArray['student_entry_ffincom']}', fmotmob = '{$rgPerArray['student_entry_fmmob']}', idMotOccup = '{$rgPerArray['student_entry_fmoccp']}', fMotAnInc = '{$rgPerArray['student_entry_fmincom']}', fparexser = '{$rgPerArray['student_entry_fparexser']}', fpergovt = '{$rgPerArray['student_entry_fpergovt']}', fstdncc = '{$rgPerArray['student_entry_fstdncc']}', ftenregno = '{$rgPerArray['student_entry_ftenregno']}', ftenminmrk = '{$rgPerArray['student_entry_ftenminmrk']}', ftenmaxmrk = '{$rgPerArray['student_entry_ftenmaxmrk']}', ftenper = '{$rgPerArray['student_entry_ftenper']}', ftenbrd = '{$rgPerArray['student_entry_ftenbrd']}', ftenschname = '{$rgPerArray['student_entry_ftenschname']}', ftenlocsch = '{$rgPerArray['student_entry_ftenlocsch']}', ftwtregno = '{$rgPerArray['student_entry_ftwtregno']}', ftwtminmrk = '{$rgPerArray['student_entry_ftwtminmrk']}', ftwtmaxmrk = '{$rgPerArray['student_entry_ftwtmaxmrk']}', ftwtper = '{$rgPerArray['student_entry_ftwtper']}', ftwtbrd = '{$rgPerArray['student_entry_ftwtbrd']}', ftwtcollname = '{$rgPerArray['student_entry_ftwtcollname']}', ftwtloccoll = '{$rgPerArray['student_entry_ftwtloccoll']}', fdipregno = '{$rgPerArray['student_entry_fdipregno']}', fthredipmin = '{$rgPerArray['student_entry_fthredipmin']}', fthredipmax = '{$rgPerArray['student_entry_fthredipmax']}', fdipper = '{$rgPerArray['student_entry_fdipper']}', fdipbrd = '{$rgPerArray['student_entry_fdipbrd']}', fdipcollname = '{$rgPerArray['student_entry_fdipcollname']}', fdiploccoll = '{$rgPerArray['student_entry_fdiploccoll']}', fenttstnm = '{$rgPerArray['student_entry_fenttstnm']}', fentmax = '{$rgPerArray['student_entry_fentmax']}', fentper = '{$rgPerArray['student_entry_fentper']}', frankobt = '{$rgPerArray['student_entry_frankobt']}', fentmin = '{$rgPerArray['student_entry_fentmin']}', fphymax = '{$rgPerArray['student_entry_fphymax']}', fphysec = '{$rgPerArray['student_entry_fphysec']}', fmatmax = '{$rgPerArray['student_entry_fmatmax']}', fmatsec = '{$rgPerArray['student_entry_fmatsec']}', fchemax = '{$rgPerArray['student_entry_fchemax']}', fchesec = '{$rgPerArray['student_entry_fchesec']}', fbiomax = '{$rgPerArray['student_entry_fbiomax']}', fbiosec = '{$rgPerArray['student_entry_fbiosec']}', fpcmtotmax = '{$rgPerArray['student_entry_fpcmtotmax']}', fpcmscraggr = '{$rgPerArray['student_entry_fpcmscraggr']}', fpcbtotmax = '{$rgPerArray['student_entry_fpcbtotmax']}', fpcbscraggr = '{$rgPerArray['student_entry_fpcbscraggr']}', FACKDATE = now(), FACKUSER = '{$_SESSION['user_type']}' $faadhaar where fappno = '{$rgPerArray['student_entry_admno']}'"; // var_dump($query);die(); $results = $aobj_context->mobj_db->Execute($query); $cert_path = $aobj_context->main_src."/certificates/".$rgPerArray['student_entry_admno']; //is successfully inserted $fappno = $rgPerArray['student_entry_admno']; if(!file_exists($cert_path)) { mkdir($cert_path); } $doc_names = ['ADHAAR', 'CASTE', 'INCOME', 'SSLCMC', 'TCCERT', 'PUMC', 'GCCERT', 'DEGMC']; // ------------- Document Strart -------------------////// for($i=0;$i<count($doc_names);$i++) { $GCCERT = $rgPerArray['h_'.$doc_names[$i]]; if($GCCERT == '') continue; $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; $degree = $rgPerArray["student_entry_degree_code"]; $college = $_SESSION['collcode']; $insert = "INSERT ignore 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); $GCCERT_FILENAME_FILENAME = $cert_path."/".$GCCERT_FILENAME; $GCCERT = "certificates/{$rgPerArray['student_entry_admno']}/".$GCCERT_FILENAME; $GCCERT = $_SESSION['FUNIVCODE']."/certificates/{$fappno}/".$GCCERT_FILENAME; $GCCERT_upd = "certificates/{$fappno}/".$GCCERT_FILENAME; //var_dump($GCCERT_PATH); if(file_exists($GCCERT_PATH)) { try{ $s3->putObject(['Bucket' => ADMISSION_CERTIFICATES, 'Key' => $GCCERT, 'SourceFile' => $GCCERT_PATH]); $update = ''; $update = "update studoc set file_path = '{$GCCERT_upd}' where login_cnt = '{$rgPerArray['student_entry_admno']}' and fdoctype = '{$doc_names[$i]}'"; $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 = "update studoc set fdegree = '{$rgPerArray['student_entry_degree_code']}' where login_cnt = '{$rgPerArray['student_entry_admno']}'"; $res = $aobj_context->mobj_db->Execute($query); $college = $_SESSION['collcode']; $degree = $rgPerArray['student_entry_degree_code']; $fappno = $rgPerArray['student_entry_admno']; $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"; if($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; } } } $mobj_jsondata = json_decode($rgMultiMarks,true); $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($results) { $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']; $db = $aobj_context->mobj_data["db"]; $temp_path = $aobj_context->main_src."/".$db."/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']; $db = $aobj_context->mobj_data["db"]; $temp_path = $aobj_context->main_src."/".$db."/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"]; $fexamno = $aobj_context->mobj_data["fexamno"]; $fappno = $aobj_context->mobj_data["fappno"]; $get_sub_total = "select FTOTSUB from degree where FDEGREE= '{$degree}' and FEXAMNO='{$fexamno}'"; $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='{$fexamno}' 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='{$fexamno}') 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='{$fexamno}' 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); // var_dump($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=''; $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='{$_SESSION['collcode']}' and s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and s.FDEGREE='{$degree}' and d.fappno = '{$fappno}' group by s.FSUBCODE "; $lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution); 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; } } function removedocument($aobj_context) { session_start(); $degree = $aobj_context->mobj_data["degree_code"]; $fappno = $aobj_context->mobj_data["fappno"]; $filename = $aobj_context->mobj_data["filename"]; $collcode = $_SESSION['collcode']; $query = "update studoc set file_path = null where fcollcode = '{$collcode}' and fdoctype = '{$filename}' and login_cnt = '{$fappno}' and fdegree = '{$degree}'"; // var_dump($query); $results = $aobj_context->mobj_db->Execute($query); if($results) { $arr['filename'] = $filename; $arr['fappno'] = $fappno; $arr['degree'] = $degree; $arr['msg'] = "Document Removed."; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; }else { $arr = "Document Removal Failure. Please Try Gain"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } function RemoveApplication($aobj_context) { session_start(); $appno = $aobj_context->mobj_data["appno"]; $degree = $aobj_context->mobj_data["degree"]; $collcode = $_SESSION['collcode']; $query = "update studadm set FAPPSTATUS = NULL,FACKDATE=NULL,FACKUSER = NULL where fcollcode = '{$collcode}' and fappno = '{$appno}' and fdegree = '{$degree}'"; $results = $aobj_context->mobj_db->Execute($query); if($results) { // $query = "delete from admfeedetl where fcollcode = '{$collcode}' and fappno = '{$appno}' // and fdegree = '{$degree}'"; // $results = $aobj_context->mobj_db->Execute($query); } if($results) { $arr['msg'] = "Acknowledgement Removed."; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; }else { $arr = "Acknowledgement Removal Failure. Please Try Gain"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } function DeleteApplication($aobj_context) { session_start(); $appno = $aobj_context->mobj_data["appno"]; $degree = $aobj_context->mobj_data["degree"]; $collcode = $_SESSION['collcode']; $query = "select FCONTACT_NO from studadm where fappno = '{$appno}'"; $results1 = $aobj_context->mobj_db->GetRow($query); $query = "update studadm set fdeleted = 'T' where fcollcode = '{$collcode}' and fappno = '{$appno}' and fdegree = '{$degree}'"; $results = $aobj_context->mobj_db->Execute($query); if($results) { $mob = $results1['FCONTACT_NO']; $query = "update options set fdeleted = 'T' where fcollcode = '{$collcode}' and fappno = '{$appno}' and fdegree = '{$degree}'"; $results = $aobj_context->mobj_db->Execute($query); $query = "update studoc set fdeleted = 'T' where fcollcode = '{$collcode}' and login_cnt = '{$appno}' and fdegree = '{$degree}'"; $results = $aobj_context->mobj_db->Execute($query); // $query = "delete from admfeedetl where fcollcode = '{$collcode}' and fappno = '{$appno}' // and fdegree = '{$degree}'"; // $results = $aobj_context->mobj_db->Execute($query); $query = "update collstud set fdeleted = 'T' where fmobileno = '{$mob}'"; $results = $aobj_context->mobj_db->Execute($query); } if($results) { $arr['msg'] = "Deleted successfully."; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; }else { $arr = "Acknowledgement Removal Failure. Please Try Gain"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } ?>
Close
