Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 3.145.88.241
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 : candidate-entry.php
<?php require_once("/var/www/html/aws/aws-autoloader.php"); use Aws\S3\S3Client; function replaceChars($name) { $spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ",""); $link_name = strtolower(str_replace($spl_char,"_",$name)); return str_ireplace("__","_",$link_name); } function ckeakexamdate($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); @session_start(); $degree = $aobj_context->mobj_data["degree"]; $collegeCode =$_SESSION['collcode']; $query = "select * from collexam where fcollcode = '{$collegeCode}' and fdegree = '{$degree}' and DATE_FORMAT(NOW(),'%Y-%m-%d') BETWEEN DATE_FORMAT(FAPPFROM,'%Y-%m-%d') AND DATE_FORMAT(FAPPTO,'%Y-%m-%d') "; $result = $aobj_context->mobj_db->GetAll($query); if(strtoupper($_SESSION['usr'])=='SUPER') { $arr = ""; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1,"success"); return; }else if ($result == false) { $arr = "Last Date is Over"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1,"success"); return; }else { $arr = ""; echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 1,"success"); return; // $arr = "Exam application form is available in Student Portal."; // echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1,"success"); // return; } } function displayCandidateEntryRegNoDetails($aobj_context) { //session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $Regno = $aobj_context->mobj_data["Regno"]; $degree = $aobj_context->mobj_data["degree"]; $li = $aobj_context->mobj_data["li"]; $category = $aobj_context->mobj_data["category"]; $exam_appear=array(); /*$qry=" select * from colldeg where fdegree = '{$degree}' and fcollcode = '{$college_code}' and ifnull(fexregstop,'') <> 'T'"; $student_exam_details = $aobj_context->mobj_db->GetRow($qry); if(empty($student_exam_details)) { $e_data="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' width='100%' border='0' cellspacing='0' cellpadding='0'>"; $e_data.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Last date is over for exam registration</th>"; $e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $e_data.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>A</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>B </td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>C </td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>D </td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>E </td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>F</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>G</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>H</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>I</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>J</td>"; $e_data.="</tr>"; $e_data.="<tr style=' border-bottom:1px solid #C5DBEC;'>"; $qry=" "; $student_exam_details = $aobj_context->mobj_db->GetRow($qry); } else { $qry=" select c.FDEGREE,c.FEXAMNO,c.FCOLLCODE,c.FREGNO,s.FCASTE AS FCATEGORY, s.Fgender as Fgender,c.FAPPEARA,c.FEXAMFEEA, c.FAPPEARB,c.FEXAMFEEB,c.FAPPEARC,c.FEXAMFEEC,c.FAPPEARD,c.FEXAMFEED,c.FAPPEARE, c.FEXAMFEEE,c.FAPPEARF,c.FEXAMFEEF,c.FAPPEARG,c.FEXAMFEEG,c.FAPPEARH,c.FEXAMFEEH, c.FAPPEARI,c.FEXAMFEEI,c.FAPPEARJ,c.FEXAMFEEJ,round(c.FTOTALFEE,2) as FTOTALFEE, c.FYEAR,c.FEXAMTYPE,c.FDELETED,FRECPTNO,DATE_FORMAT(FRECPTDATE,'%d/%m/%Y') as FRECPTDATE ,FREMARKS, FRECPTNOA,DATE_FORMAT(FRECPTDATEA,'%d/%m/%Y') AS FRECPTDATEA, FRECPTNOB,DATE_FORMAT(FRECPTDATEB,'%d/%m/%Y') AS FRECPTDATEB, FRECPTNOC,DATE_FORMAT(FRECPTDATEC,'%d/%m/%Y') AS FRECPTDATEC , FRECPTNOD,DATE_FORMAT(FRECPTDATED,'%d/%m/%Y') AS FRECPTDATED , FRECPTNOE,DATE_FORMAT(FRECPTDATEE,'%d/%m/%Y') AS FRECPTDATEE , FRECPTNOF,DATE_FORMAT(FRECPTDATEF,'%d/%m/%Y') AS FRECPTDATEF , FRECPTNOG,DATE_FORMAT(FRECPTDATEG,'%d/%m/%Y') AS FRECPTDATEG , FRECPTNOH,DATE_FORMAT(FRECPTDATEH,'%d/%m/%Y') AS FRECPTDATEH , FRECPTNOI,DATE_FORMAT(FRECPTDATEI,'%d/%m/%Y') AS FRECPTDATEI , FRECPTNOJ,DATE_FORMAT(FRECPTDATEJ,'%d/%m/%Y') AS FRECPTDATEJ ,FFRESHEXAM from candsum c left join student s on s.FDEGREE=c.FDEGREE and s.FREGNO=c.FREGNO where c.FDEGREE='{$degree}' and c.FCOLLCODE='{$college_code}' and c.FREGNO='{$Regno}' ";*/ $qry=" select c.FDEGREE,c.FEXAMNO,c.FCOLLCODE,c.FREGNO, c.FAPPEARA,c.FEXAMFEEA, c.FAPPEARB,c.FEXAMFEEB,c.FAPPEARC,c.FEXAMFEEC,c.FAPPEARD,c.FEXAMFEED,c.FAPPEARE, c.FEXAMFEEE,c.FAPPEARF,c.FEXAMFEEF,c.FAPPEARG,c.FEXAMFEEG,c.FAPPEARH,c.FEXAMFEEH, c.FAPPEARI,c.FEXAMFEEI,c.FAPPEARJ,c.FEXAMFEEJ,round(c.FTOTALFEE,2) as FTOTALFEE, c.FYEAR,c.FEXAMTYPE,c.FDELETED,FRECPTNO,DATE_FORMAT(FRECPTDATE,'%d/%m/%Y') as FRECPTDATE ,FREMARKS, c.FTOTSUBA,c.FTOTSUBB,c.FTOTSUBC,c.FTOTSUBD,c.FTOTSUBE,c.FTOTSUBF,c.FTOTSUBG,c.FTOTSUBH, c.FTOTSUBI,c.FTOTSUBJ, FRECPTNOA,DATE_FORMAT(FRECPTDATEA,'%d/%m/%Y') AS FRECPTDATEA, FRECPTNOB,DATE_FORMAT(FRECPTDATEB,'%d/%m/%Y') AS FRECPTDATEB, FRECPTNOC,DATE_FORMAT(FRECPTDATEC,'%d/%m/%Y') AS FRECPTDATEC , FRECPTNOD,DATE_FORMAT(FRECPTDATED,'%d/%m/%Y') AS FRECPTDATED , FRECPTNOE,DATE_FORMAT(FRECPTDATEE,'%d/%m/%Y') AS FRECPTDATEE , FRECPTNOF,DATE_FORMAT(FRECPTDATEF,'%d/%m/%Y') AS FRECPTDATEF , FRECPTNOG,DATE_FORMAT(FRECPTDATEG,'%d/%m/%Y') AS FRECPTDATEG , FRECPTNOH,DATE_FORMAT(FRECPTDATEH,'%d/%m/%Y') AS FRECPTDATEH , FRECPTNOI,DATE_FORMAT(FRECPTDATEI,'%d/%m/%Y') AS FRECPTDATEI , FRECPTNOJ,DATE_FORMAT(FRECPTDATEJ,'%d/%m/%Y') AS FRECPTDATEJ ,FFRESHEXAM,FFEETYPE from candsum c where c.FDEGREE='{$degree}' and c.FCOLLCODE='{$college_code}' and c.FREGNO='{$Regno}' "; $student_exam_details = $aobj_context->mobj_db->GetRow($qry); $e_data="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' width='100%' border='0' cellspacing='0' cellpadding='0' align='center' >"; $e_data.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Exam Details</th>"; $e_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $e_data.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>A</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>B </td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>C </td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>D </td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>E </td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>F</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>G</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>H</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>I</td>"; $e_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>J</td>"; $e_data.="</tr>"; $e_data.="<tr style=' border-bottom:1px solid #C5DBEC;'>"; //} //echo $qry; $get_existing_fee_details="SELECT FEXAMNO,FFEECODE,FAMOUNT FROM studfee WHERE FCOLLCODE='{$college_code}' AND FDEGREE='{$degree}' AND FREGNO='{$Regno}' "; $obj_get_existing_fee_details = $aobj_context->mobj_db->GetAll($get_existing_fee_details); $existing_fee_arr=array(); foreach($obj_get_existing_fee_details as $ak=>$av) { $existing_fee_arr[$av['FEXAMNO']][$av['FFEECODE']]=$av['FAMOUNT']; } $totsub = ''; $totsub.=$student_exam_details['FTOTSUBA'].","; $totsub.=$student_exam_details['FTOTSUBB'].","; $totsub.=$student_exam_details['FTOTSUBC'].","; $totsub.=$student_exam_details['FTOTSUBD'].","; $totsub.=$student_exam_details['FTOTSUBE'].","; $totsub.=$student_exam_details['FTOTSUBF'].","; $totsub.=$student_exam_details['FTOTSUBG'].","; $totsub.=$student_exam_details['FTOTSUBH'].","; $totsub.=$student_exam_details['FTOTSUBI'].","; $totsub.=$student_exam_details['FTOTSUBJ'].","; $FFRESHEXAM=$student_exam_details['FFRESHEXAM']; /*if($category=="Select" || $category=="0") $FCATEGORY=$student_exam_details[FCATEGORY]; else*/ $FCATEGORY=$category; $fee_td=""; for($i=65;$i<75;$i++) { $html_id="candidate_list_exam_".chr($i)."_details"; $exam_fee["{$html_id}"]=$student_exam_details['FEXAMFEE'.chr($i)]; $exam_receipt_no["{$html_id}"]=$student_exam_details['FRECPTNO'.chr($i)]; //is_null($student_exam_details['FRECPTDATE'])?date('d/m/Y'):$student_exam_details['FRECPTDATE']; $exam_receipt_no_date["{$html_id}"]=is_null($student_exam_details['FRECPTDATE'.chr($i)])?date('d/m/Y'):($student_exam_details['FRECPTDATE'.chr($i)]); $border_left=($i==65)?" border-left:1px solid #ccc;":" border-left:0px solid #ccc;"; if($student_exam_details['FAPPEAR'.chr($i)]=='N') { $td_data="NE"; $id=" id ='cand_entry_".chr($i)."'"; } else if($student_exam_details['FAPPEAR'.chr($i)]=='P') { $td_data="Pass"; $id=" id ='cand_entry_".chr($i)."'"; } else if($student_exam_details['FAPPEAR'.chr($i)]=='A' || $student_exam_details['FAPPEAR'.chr($i)]=='E') { array_push($exam_appear,chr($i)); $id=" id='cand_entry_".chr($i)."'"; $td_data="<Input onclick=showExamNosDiv('{$html_id}'); {$id} name='radio_common' type='radio'>"; $id=''; } else { $td_data="<font color=red> </font>"; $id=" id ='cand_entry_".chr($i)."'"; } $e_data.="<td align=center style='padding:2px; border-bottom:1px solid #ccc; {$border_left}border-right:1px solid #ccc;' {$id} >{$td_data}</td>"; $fee_td.="<td align=center style='padding:2px; border-bottom:1px solid #ccc; {$border_left}border-right:1px solid #ccc; color: #B52DA0; font-weight: bold; ' id='ssub_fee_".chr($i)."' > </td>"; } $e_data.="</tr>"; $e_data.="</tr>{$fee_td}</tr>"; $e_data.="</table>"; // get total Subs $get_total_sub_for_degree="select * from degree where FDEGREE='{$degree}'"; $lobj_get_total_sub_for_degree = $aobj_context->mobj_db->GetAll($get_total_sub_for_degree); $totsub = explode(',',$totsub); for($j=0;$j<count($lobj_get_total_sub_for_degree);$j++) { if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='A') { if($totsub[$j] > 0) $exam_A_limit = $totsub[$j]; else $exam_A_limit = $lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['A']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='B') { if($totsub[$j] > 0) $exam_B_limit = $totsub[$j]; else $exam_B_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['B']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='C') { if($totsub[$j] > 0) $exam_C_limit = $totsub[$j]; else $exam_C_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['C']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='D') { if($totsub[$j] > 0) $exam_D_limit = $totsub[$j]; else $exam_D_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['D']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='E') { if($totsub[$j] > 0) $exam_E_limit = $totsub[$j]; else $exam_E_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['E']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='F') { if($totsub[$j] > 0) $exam_F_limit = $totsub[$j]; else $exam_F_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['F']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='G') { if($totsub[$j] > 0) $exam_G_limit = $totsub[$j]; else $exam_G_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['G']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='H') { if($totsub[$j] > 0) $exam_H_limit = $totsub[$j]; else $exam_H_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['H']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='I') { if($totsub[$j] > 0) $exam_I_limit = $totsub[$j]; else $exam_I_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['I']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } else if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='J') { if($totsub[$j] > 0) $exam_J_limit = $totsub[$j]; else $exam_J_limit=$lobj_get_total_sub_for_degree[$j]['FTOTSUB']; $semister_names['J']=$lobj_get_total_sub_for_degree[$j]['FEXAMNAME']; } } // Exam A Div for($i=65;$i<75;$i++) { if(in_array(chr($i),$exam_appear)) { $id=''; $remaining_count=0; $id="\$exam_".chr($i); $html_id="candidate_list_exam_".chr($i)."_details"; $char_name=chr($i); $max_limit="\$exam_".$char_name."_limit"; eval("\$max_limit = \"$max_limit\";"); $FEXAMNO=chr($i); $id="<table class='tr_ventor_row' align='center' width=100% border='0' cellspacing='0' cellpadding='2'>"; $id.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:11px; padding-left:6px; height:20px;'>{$semister_names[$FEXAMNO]}</th>"; // $id="<table width='95%' align='center' cellspacing='0' cellpadding='0' border='0' >"; //$id.=" <tr><td class='act_txtclr' colspan='5' style='background-color:#3D83CC; color:#fff; font-weight:700; width:222px; padding-left:5px; letter-spacing:0.5pt;'>{$semister_names[$FEXAMNO]} </td> </tr>"; $id.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $id.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>"; $id.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>QP Code</td>"; $id.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Description</td>"; $id.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Pass Month<input type=checkbox id='{$html_id}^{$char_name}' onclick='checkAllCandidateSemisterSub(this.id);' ></td>"; /* $id.="<tr style='background-image:url(../jqGrid3/themes/tarka/images/grid-blue-hd.gif);border-bottom:1px solid #CBC7B8; color:#000; font-weight:700; padding:3px 6px; letter-spacing:0.5pt;'>"; $id.="<td align=center style='padding:2px; border-bottom:1px solid #ccc; border-left:1px solid #ccc; border-right:1px solid #ccc;width:23px;'>Code</td>"; $id.="<td align=center style='padding:2px; border-bottom:1px solid #ccc;border-left:0px solid #ccc; border-right:1px solid #ccc;width:90px'>Short Name</td>"; $id.="<td align=center style='padding:2px; width:160px; border-bottom:1px solid #ccc;border-left:0px solid #ccc; border-right:1px solid #ccc;'>Description</td>"; $id.="<td align=center style='padding:2px; border-bottom:1px solid #ccc; border-left:0px solid #ccc; border-right:1px solid #ccc;width:80px'>Pass M/Y<input type=checkbox id='{$html_id}^{$char_name}' onclick='checkAllCandidateSemisterSub(this.id);' ></td>"; */ $id.="</tr>"; $get_header_exam_details="select c.FSUBCODE,s.FSUBNAME,ifnull(c.FPASSMTH,'') as FPASSMTH, s.FQPCODE AS FSUBSHORT,c.FEXAMTYPE, ifnull(c.FPRESENT,'N') as FPRESENT, ifnull(c.fthpr,'') as fthpr, if(c.FINSERTED='','F',c.FINSERTED) as FINSERTED from canddet c inner join subject s on s.FDEGREE=c.FDEGREE and s.fexamno = c.fexamno and s.FSUBCODE=c.FSUBCODE where c.FCOLLCODE='{$college_code}' and c.FDEGREE='{$degree}' and c.FEXAMNO='{$FEXAMNO}' and c.FREGNO='{$Regno}' group by c.FSUBCODE limit $max_limit "; $lobj_rs = $aobj_context->mobj_db->GetAll($get_header_exam_details); //echo $get_header_exam_details; $remaining_count=$max_limit-count($lobj_rs); $k=0; $txt_id=0; for($m=0;$m<count($lobj_rs);$m++) { $code_pop_up_field=""; $FSUBCODE=$lobj_rs[$m]['FSUBCODE']; $FTHPR=$lobj_rs[$m]['fthpr']; $get_theroy_cnt="SELECT COUNT(1) AS t_cnt FROM subject WHERE FDEGREE='{$degree}' AND fexamno='{$FEXAMNO}' AND FSUBCODE='{$FSUBCODE}' AND IFNULL(ftheory,'') = 'T' AND IFNULL(fintass,'') <> 'T' AND IFNULL(fretain,'') <> 'T' "; $lobj_get_theroy_cnt = $aobj_context->mobj_db->GetRow($get_theroy_cnt); $th_cnt=$lobj_get_theroy_cnt['t_cnt']; $get_prc_cnt="SELECT COUNT(1) AS p_cnt FROM subject WHERE FDEGREE='{$degree}' AND fexamno='{$FEXAMNO}' AND FSUBCODE='{$FSUBCODE}' AND IFNULL(ftheory,'') <> 'T' AND IFNULL(fintass,'') <> 'T' AND IFNULL(fretain,'') <> 'T' "; $lobj_get_prc_cnt = $aobj_context->mobj_db->GetRow($get_prc_cnt); $pr_cnt=$lobj_get_prc_cnt['p_cnt']; if($th_cnt>1) $th_cnt=max(2,$th_cnt); if($pr_cnt>1) $pr_cnt=max(2,$pr_cnt); if($FTHPR=='T') $th_cnt=0; if($FTHPR=='F') $pr_cnt=0; $FSUBSHORT=$lobj_rs[$m]['FSUBSHORT']; $FSUBNAME=$lobj_rs[$m]['FSUBNAME']; if($FTHPR == 'T') $fsubchekbox = "(PR)"; else if($FTHPR == 'F') $fsubchekbox = "(TH)"; else $fsubchekbox = ""; if($lobj_rs[$m]['FPASSMTH']=='' or is_null($lobj_rs[$m]['FPASSMTH']))// to display pass M/Y based on the value { $checked=($lobj_rs[$m]['FPRESENT']=='P')?" checked ":""; // Default Making as checked as Pondi Uni preffers all Subjects to Take //$checked= " checked " ; //for default check status $FPASSMTH="{$fsubchekbox} <input type='checkbox' {$checked} onclick='UpdateExamFeeForEachSelectedSubject();' id='exam_{$char_name}_ce_pass_{$txt_id}'>"; $FPASSMTH.="<input type='hidden' id='exam_{$char_name}_th_cnt_{$txt_id}' value='{$th_cnt}' /> "; $FPASSMTH.="<input type='hidden' id='exam_{$char_name}_pr_cnt_{$txt_id}' value='{$pr_cnt}' /> "; //var_dump($FPASSMTH); $FPASSMTH_TD=""; $code_pop_up_field=""; } else { $FPASSMTH=$lobj_rs[$m]['FPASSMTH']; $FPASSMTH_TD=" id='exam_{$char_name}_ce_pass_{$txt_id}' "; $code_pop_up_field='readonly=true;'; } if($lobj_rs[$m]['FINSERTED']=='T')// to display text box for the value if FINSERTED=''T { $sub_code_input_border= ""; $sub_code_input_popup=" onblur='getSubDetails(this.id,{$txt_id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'"; $sub_code_input_name="di"; $input_tab_indx=" tabindex={$txt_id}"; $read_only=" "; } else { $sub_code_input_border= " border:none;"; $sub_code_input_popup= ""; $sub_code_input_name="update"; $input_tab_indx=" tabindex=-1"; $read_only=" readonly"; } if($k%2==0) { $class='tbl_row'; $inp_class='tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } $id.="<tr>"; $id.="<td align='center' style='font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input {$code_pop_up_field} {$inp_class} type=text style='width:55px;text-align:center;{$sub_code_input_border}' {$read_only} {$sub_code_input_popup} name='{$sub_code_input_name}' id='exam_{$char_name}_ce_sub_code_{$txt_id}' {$input_tab_indx} value='{$FSUBCODE}'></td>"; $id.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}' > {$FSUBSHORT}</td>"; $id.="<td align='left' id='exam_{$char_name}_ce_desc_{$txt_id}' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> {$FSUBNAME}</td>"; $id.="<td style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;' align='center' {$FPASSMTH_TD} >{$FPASSMTH} </td>"; $id.="</tr>"; $k++; $txt_id++; } // for non entered Subjects if($remaining_count>0) { $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'; } $id.="<tr>"; $id.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input type='text' {$inp_class} name='new_insert' onblur='getSubDetails(this.id,{$txt_id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' style='width:60px;' tabindex={$txt_id} id='exam_{$char_name}_ce_sub_code_{$txt_id}'> </td>"; $id.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'id='exam_{$char_name}_ce_short_name_{$txt_id}'> </td>"; $id.="<td align='left' id='exam_{$char_name}_ce_desc_{$txt_id}' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> </td>"; $pr_th_cnt="<input type='hidden' id='exam_{$char_name}_th_cnt_{$txt_id}' value='0' /> "; $pr_th_cnt.="<input type='hidden' id='exam_{$char_name}_pr_cnt_{$txt_id}' value='0' /> "; $id.="<td style='padding:2px; font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;' align='center' >{$fsubchekbox} <input type='checkbox' onclick='UpdateExamFeeForEachSelectedSubject();' id='exam_{$char_name}_ce_pass_{$txt_id}' > {$pr_th_cnt} </td>"; $id.="</tr>"; $k++; $txt_id++; } } // var_dump($id); $total_count_of_each_div[$html_id]=$txt_id; $exam_fee_val=$exam_fee[$html_id]; // echo $exam_fee[$html_id]; $exam_receipt_no_val=$exam_receipt_no[$html_id]; $exam_receipt_no_date_val=$exam_receipt_no_date[$html_id]; //for Total Input Box /* $id.="</tr><tr>"; $id.="<td align='right' style='padding:2px; font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><div style='border:1px solid #C5DBEC;'>Receipt No:</div></td>"; $id.="<td align='left' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><input type='text' style='width:85px;' id='exam_{$char_name}_receipt_no' value='{$exam_receipt_no_val}'> Date:</font></td>"; $id.="<td style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'align=left><input style='width:75px;' value='{$exam_receipt_no_date_val}' id='exam_{$char_name}_date' type='text' /> <script>$('#exam_{$char_name}_date').datepicker({showOn: 'button',showButtonPanel: true, changeMonth: true, changeYear: true,dateFormat:'dd/mm/yy', buttonImage: 'images/cal.jpg', buttonImageOnly: true});</script> </td>"; $id.="<td style=' background-color:Coral;font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;' align='center'><input readonly type=text onblur=showExamNosDiv('{$html_id}');CheckCheckBoxIsChecked('{$html_id}') id='{$html_id}_total' style='width:76px;background-color:Coral;border:none;' value='{$exam_fee_val}' align='right' onkeypress='return acceptNumbersOnlyForModule(event);'> </td>"; $id.="</tr>"; $id.="</table>" */; $get_fee_data = "SELECT FHEADCODE, FFEE, IF('{$FFRESHEXAM}'='{$char_name}',FFEE,FREPFEE) AS O_FFEE, IF('{$FFRESHEXAM}'='{$char_name}',FPRFEE,FREPPRFEE) AS FPRFEE ,FMAXFEE, ifnull(FMODIFY,'') as FMODIFY FROM admfeestr a WHERE FDEGREE='{$degree}' AND FEXAMNO='{$char_name}' AND FCOMBCODE='EXAM' AND FCATCODE='{$category}' and FCONSTYPE='{$li}' order by FHEADCODE"; // var_dump($get_fee_data);die(); session_start(); $FUNIVCODE=$_SESSION['FUNIVCODE']; if($FUNIVCODE == "013" && $FFRESHEXAM != $char_name)//checking specific to univeristy { $get_cnt="select count(fsubcode) as rep_cnt from canddet WHERE FDEGREE='{$degree}' AND FEXAMNO='{$char_name}' AND FCOLLCODE='{$college_code}' AND FREGNO='{$Regno}' AND ifnull(FPASSMTH,'')=''"; $lobj_get_cnt = $aobj_context->mobj_db->GetRow($get_cnt); $rep_cnt = $lobj_get_cnt['rep_cnt']; if($rep_cnt>3)// changing only qry { $get_fee_data ="SELECT FHEADCODE,FFEE, IF('{$FFRESHEXAM}'='{$char_name}',FFEE,FREPFEE) AS O_FFEE, IF('{$FFRESHEXAM}'='{$char_name}',FPRFEE,FREPPRFEE) AS FPRFEE ,FMAXFEE,ifnull(FMODIFY,'') as FMODIFY FROM admfeestr a WHERE FDEGREE='{$degree}' AND FEXAMNO='{$char_name}' AND FCOMBCODE='EXAM' AND FCATCODE='GM' and FCONSTYPE='{$li}' order by FHEADCODE"; } } $lobj_get_fee_data = $aobj_context->mobj_db->GetAll($get_fee_data); $fee_cnt=count($lobj_get_fee_data)+1; $id.="<tr>"; $id.="<td colspan='4' style=' border-bottom:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-left:1px solid #C5DBEC; padding:5px;'>"; $id.=""; $tr="<table id='fee_table_{$char_name}' style='width:100%;' class='tr_ventor_row;' border='0' cellspacing='0' cellpadding='2'>"; $tr.="<th align='left' colspan='2' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:11px; padding-left:6px; height:20px;'>Fee Details</th>"; $tr.="<tr class='ui-state-default ui-jqgrid-hdiv' style='height:22px;font-weight:bold; font-size:12px; '>"; $tr.="<td align='center' style='border:0px solid #C5DBEC;border-top:1px solid #C5DBEC ;border-left:1px solid #C5DBEC;'> Fee Description</td>"; $tr.="<td align='center' style='border:0px solid #C5DBEC;border-top:1px solid #C5DBEC ;border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC;'>Amount</td>"; $tr.="</tr>"; $tot=0; foreach($lobj_get_fee_data as $ak=>$av) { $disabled = "disabled = true"; $FMODIFY = $av['FMODIFY']; //var_dump($FMODIFY); if($FMODIFY == 'T') $disabled = ""; $tr.=" <tr class='' style='height:22px;font-size:11px;'>"; $h_code=substr($av['FHEADCODE'],0,2); $tr.="<td align='left' style='width: 70%;border-top:1px solid #C5DBEC ;border-left:1px solid #C5DBEC;' id='tfh_{$char_name}_{$h_code}'>{$av['FHEADCODE']}</td>"; $input_val=0; $exist_value=""; $exist_value = $existing_fee_arr[$char_name][$av['FHEADCODE']]; if(!empty($exist_value)) { $input_val = $exist_value; } $O_FFEE = $av['O_FFEE']; $tot+=$input_val; $tr.="<td align='center' style='border-top:1px solid #C5DBEC ;border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC;' > <input type=hidden value='{$av['O_FFEE']}' id='o_fee_{$char_name}_{$h_code}' /> <input type=hidden value='{$av['FPRFEE']}' id='prfee_{$char_name}_{$h_code}' /> <input type=hidden value='{$av['FMAXFEE']}' id='minnfee_{$char_name}_{$h_code}' /> <input onblur='CalculateNewwFeeTotals();' style='width:56px;border:none;text-align:center; ' $disabled}type=text value='{$input_val}' id='nfee_{$char_name}_{$h_code}'></td>"; $tr.=" </tr>"; } $tr.=" <tr class='ui-state-default ui-jqgrid-hdiv' style='font-weight:bold;background:#27E87A; height:20px;font-size:12px;'>"; $tr.="<td align='center' style='border-left:1px solid #C5DBEC;border-top:1px solid #C5DBEC;border-bottom:1px solid #C5DBEC;'> Total </td>"; $tr.="<td align='center' style='border-left:1px solid #C5DBEC;border-top:1px solid #C5DBEC;border-right:1px solid #C5DBEC;border-bottom:1px solid #C5DBEC;'><input style='text-align:center;border:none;font-weight:bold;background:#27E87A;' id='nfee_{$char_name}_total' value={$tot} $disabled /></td>"; $tr.="</tr></table>"; $id.=$tr ; //var_dump($id); $id.="</td></tr>";//close fee row $id.="<tr>"; $id.="<td colspan='4' style='border-left:1px solid #C5DBEC;border-right:1px solid #C5DBEC;border-bottom:1px solid #C5DBEC; padding:4px;font-size:12px;'>"; $id.="<span style='float:left;'>Receipt No:<input type='text' style='width:100px;' maxlength='15' id='exam_{$char_name}_receipt_no' value='{$exam_receipt_no_val}'></span>"; $id.="<span style='float:right;'>Receipt Date:<input style='width:100px;text-align:center;' id='exam_{$char_name}_date' value='{$exam_receipt_no_date_val}' type='text' value='00/00/0000' />"; $id.="<script> $('#exam_{$char_name}_date').datepicker({ changeMonth: true, changeYear: true,dateFormat:'dd/mm/yy'});</script></span>"; $id.="</td>"; $id.="</tr>"; $id.="</table>"; $arr[$html_id]=$id; } } $arr['table_data']=$student_exam_details; $arr['html_data']=$e_data; $arr['date']=is_null($student_exam_details['FRECPTDATE'])?date('d/m/Y'):$student_exam_details['FRECPTDATE']; $arr['total_count_of_each_div']=$total_count_of_each_div; if($lobj_get_total_sub_for_degree) echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); else echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } function saveCandidateEntryDetails($aobj_context) { //session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $FLOGNAME = $_SESSION['usr']; $reg_no = $aobj_context->mobj_data["reg_no"]; $degree = $aobj_context->mobj_data["degree"]; $total_fee = $aobj_context->mobj_data["total_fee"]; $candidate_list_receipt_no = $aobj_context->mobj_data["candidate_list_receipt_no"]; $candidate_list_remarks = trim($aobj_context->mobj_data["candidate_list_remarks"]); $candidate_list_date = trim($aobj_context->mobj_data["candidate_list_date"]); $full_file_path = ""; $parentMobile = $aobj_context->mobj_data["parent_mobile"]; $stu_email = $aobj_context->mobj_data["stu_email"]; $candidate_mobile = $aobj_context->mobj_data["candidate_mobile"]; $category = trim($aobj_context->mobj_data["category"]); $li = trim($aobj_context->mobj_data["li"]); include_once("json.php"); $json = new Services_JSON(); if($college_code == '') { $arr='Login and try Again'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success"); return; die(); } $s3 = S3Client::factory( array( 'credentials' => array( 'key' => IAM_KEY, 'secret' => IAM_SECRET ), 'version' => "latest", 'region' => 'ap-south-1' ) ); $FUNIVCODE=$_SESSION['FUNIVCODE']; $student_entry_photo_path=$aobj_context->mobj_data["unlink_file"]; $college_path=$aobj_context->main_src.'/'.$aobj_context->mobj_data["db"]."/student_photos/{$college_code}"; $folder_path=$aobj_context->main_src.'/'.$aobj_context->mobj_data["db"]."/student_photos/{$college_code}/".replaceChars($degree); $file_name=basename($_FILES['student_entry_upload']['name']); $path_arr=pathinfo($_FILES['student_entry_upload']['name']); $file_ext=$path_arr['extension']; $full_file_path= $folder_path.'/'.$reg_no."_".$file_name;; $image_path="student_photos/{$college_code}/".replaceChars($degree).'/'.$reg_no."_".$file_name;; $photo_path=""; if(!file_exists($college_path)) { mkdir($college_path); }if(!file_exists($folder_path)) { mkdir($folder_path); } if(isset($_FILES['student_entry_upload']['name']) && $_FILES['student_entry_upload']['name'] != '') { if(move_uploaded_file($_FILES['student_entry_upload']['tmp_name'],$full_file_path)) { $photo_path=$image_path; $path_s3 = $FUNIVCODE.'/'.$image_path; $test = $s3->putObject(['Bucket' => STUDENT_PHOTOS_BUCKET, 'Key' => $path_s3, 'SourceFile' => $full_file_path]); $update_student_table="update student set FPHOTOPATH='{$photo_path}' where FREGNO='{$reg_no}' and FDEGREE='{$degree}' and FCOLLCODE='{$college_code}'"; $lobj_update_student_table = $aobj_context->mobj_db->Execute($update_student_table); echo mysql_error(); } } $unlink_file=trim($aobj_context->mobj_data["unlink_file"]); if($unlink_file!="images/default_photo.jpg") unlink($aobj_context->main_src.'/'.$aobj_context->mobj_data["db"].'/'.$unlink_file); $ext_arr=explode(".",$student_entry_photo_path); $app_img=strtoupper($reg_no).".".array_pop($ext_arr); $src_path=$aobj_context->main_src."/".$aobj_context->mobj_data["db"]."/".$student_entry_photo_path; $college_path=$aobj_context->main_src."/".$aobj_context->mobj_data["db"]."/student_photos/{$college_code}"; $folder_path=$aobj_context->main_src."/".$aobj_context->mobj_data["db"]."/student_photos/{$college_code}/".replaceChars(strtoupper($degree)); // if(file_exists($src_path)) // { // if(!file_exists($college_path)) // { // mkdir($college_path); // } // if(!file_exists($folder_path)) // { // mkdir($folder_path); // } // var_dump($path_s3); // var_dump($src_path); // $path ="student_photos/{$college_code}/".replaceChars(strtoupper($degree))."/".$app_img; // $dest_path=$folder_path.'/'.$app_img; // // copy($src_path,$dest_path); // $query = "update student set FPHOTOPATH = '{$path}' where fregno = '{$reg_no}'"; // $results = $aobj_context->mobj_db->Execute($query); // } $update_student_details ="update student set fstumobile ='{$candidate_mobile}', fstuemail = '{$stu_email}', ffatmobile = '{$parentMobile}' where fregno = '{$reg_no}'"; $lobj_update_student_details = $aobj_context->mobj_db->Execute($update_student_details); $lstr_param = stripslashes($aobj_context->mobj_data["details"]); $mobj_jsondata = $json->decode($lstr_param); $sub_arr_data = get_object_vars($mobj_jsondata); $check_adminsion_freeze =" select distinct c.FCCLSTATUS, d.fmeyear, d.fmeexamtyp from colldeg c, degree d where c.fdegree = d.fdegree and c.FCOLLCODE='{$college_code}' and c.FDEGREE='{$degree}'"; $lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); $query ="select distinct FFRESHEXAM from candsum where fregno = '{$reg_no}'"; $res = $aobj_context->mobj_db->getRow($query); $CFRESHEXAM = $res['FFRESHEXAM']; //insertStudFeeDetails($aobj_context,$degree,$college_code,$reg_no,$FLOGNAME); //echo $check_adminsion_freeze; die(); if(is_null($lobj_check_adminsion_freeze['FCCLSTATUS'])) { $lstr_sub_fee = stripslashes($aobj_context->mobj_data["sub_fee"]); $mobj_lstr_sub_fee = $json->decode($lstr_sub_fee); $sub_fee_data = get_object_vars($mobj_lstr_sub_fee); //delete Newly inserted records for($i=65;$i<75;$i++) { $exam_data=''; $char_id=chr($i); $exam_data=get_object_vars($sub_arr_data[$char_id]); if(!empty($exam_data)) { for($k=0;$k<count($exam_data);$k++) { //if($exam_data[$k]->sub_code!='' && $exam_data[$k]->opr=='di' && $exam_data[$k]->smy!=-1) //{ $FRESENT=($exam_data[$k]->smy=='1')?"P":"N"; $delete_from_canddet_records="delete from canddet where FINSERTED='T' and FEXAMNO='{$exam_data[$k]->ex}' and FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FREGNO='{$reg_no}'"; $lobj_delete_from_canddet_records = $aobj_context->mobj_db->Execute($delete_from_canddet_records); //} } } } // do insert/update for($i=65;$i<75;$i++) { $exam_data=''; $char_id=chr($i); $x=0; $y=0; $psubcode = array(); $nsubcode = array(); $exam_data=get_object_vars($sub_arr_data[$char_id]); if(!empty($exam_data)) { for($k=0;$k<count($exam_data);$k++) { $FRESENT=($exam_data[$k]->smy=='1')?"P":"N"; if($FRESENT == 'P') { $psubcode[$x] = $exam_data[$k]->sub; $x++; } if($FRESENT == 'N') { $nsubcode[$y] = $exam_data[$k]->sub; $y++; } } $psubcode = implode("','",$psubcode); $nsubcode = implode("','",$nsubcode); if($psubcode != NULL) { $query = "update canddet set FPRESENT='P' where FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FREGNO='{$reg_no}' and FSUBCODE in('{$psubcode}')"; $lobj_update_canddet_records = $aobj_context->mobj_db->Execute($query); } if($nsubcode != NULL) { $query = "update canddet set FPRESENT='N' where FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FREGNO='{$reg_no}' and FSUBCODE in('{$nsubcode}') and ifnull(fpassmth,'') = ''"; $lobj_update_canddet_records = $aobj_context->mobj_db->Execute($query); } for($k=0;$k<count($exam_data);$k++) { // updates only the records /*if($exam_data[$k]->sub !='' && $exam_data[$k]->opr=='update' && $exam_data[$k]->smy!=-1) { $FRESENT=($exam_data[$k]->smy=='1')?"P":"N"; $update_canddet_records="update canddet set FPRESENT='{$FRESENT}' where FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FREGNO='{$reg_no}' and FSUBCODE='{$exam_data[$k]->sub}' "; $lobj_update_canddet_records = $aobj_context->mobj_db->Execute($update_canddet_records); } // Inserts New Records else*/ if($exam_data[$k]->sub!='' && $exam_data[$k]->opr=='new_insert' && $exam_data[$k]->smy!=-1) { $FRESENT=($exam_data[$k]->smy=='1')?"P":"N"; $insert_canddet_records="insert into canddet (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FINSERTED, FPRESENT, fyear, fexamtype) values ( '{$degree}', '{$exam_data[$k]->ex}', '{$college_code}', '{$reg_no}', '{$exam_data[$k]->sub}', 'T', '{$FRESENT}', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}' )"; $lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($insert_canddet_records); } else if($exam_data[$k]->sub!='' && $exam_data[$k]->opr=='di' && $exam_data[$k]->smy!=-1) { $FRESENT=($exam_data[$k]->smy=='1')?"P":"N"; $insert_canddet_records="insert into canddet (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FINSERTED, FPRESENT, fyear, fexamtype) values ( '{$degree}', '{$exam_data[$k]->ex}', '{$college_code}', '{$reg_no}', '{$exam_data[$k]->sub}', 'T', '{$FRESENT}', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}' )"; $lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($insert_canddet_records); } $insert_canddet_records="insert into marks (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks, fyear, fexamtype) select '{$degree}', '{$exam_data[$k]->ex}', '{$college_code}', '{$reg_no}', concat(s.fsubcode,s.fssubcode), -1, '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}' from subject s where s.fdegree = '{$degree}' and s.fexamno = '{$CFRESHEXAM}' and s.fsubcode = '{$exam_data[$k]->sub}' and s.fintass = 'T' and s.fretain = 'T'"; $lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($insert_canddet_records); //var_dump($insert_canddet_records); $insert_canddet_records="insert into marks_pr (FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, fmarks11, fyear, fexamtype) select '{$degree}', '{$exam_data[$k]->ex}', '{$college_code}', '{$reg_no}', concat(s.fsubcode,s.fssubcode), '-1', '{$lobj_check_adminsion_freeze['fmeyear']}', '{$lobj_check_adminsion_freeze['fmeexamtyp']}' from subject s inner join canddet cd on s.fdegree = cd.fdegree and s.fsubcode = cd.FSUBCODE and cd.fregno = '{$reg_no}' and ifnull(cd.fpassmth,'') = '' and cd.fsubcode = '{$exam_data[$k]->sub}' and ifnull(cd.fthpr,'') <> 'F' where s.fdegree = '{$degree}' and s.fexamno = '{$exam_data[$k]->ex}' and s.ftheory = 'F' and ifnull(s.fintass,'F') <> 'T' and s.fsubcode = '{$exam_data[$k]->sub}' "; $lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($insert_canddet_records); //var_dump($insert_canddet_records); } } } //var_dump($sub_fee_data['F']); // to update the exam a/b details for($i=65;$i<75;$i++) { $char_id=chr($i); $sub_fee_datas=get_object_vars($sub_fee_data[$char_id]); if(!empty($sub_fee_datas)) { $update_records="update candsum set FEXAMFEE{$char_id}='{$sub_fee_datas[0]->total_fee}', FRECPTNO{$char_id}='{$sub_fee_datas[0]->receipt_no}', FRECPTDATE{$char_id}='{$sub_fee_datas[0]->date}' where FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FREGNO='{$reg_no}' "; $lobj_update_records = $aobj_context->mobj_db->Execute($update_records); } } $update_total_fee="update candsum set FTOTALFEE={$total_fee}, FLOGNAME='{$FLOGNAME}', FCATEGORY='{$category}', FFEETYPE='{$li}', FRECPTDATE='{$candidate_list_date}', FREMARKS='{$candidate_list_remarks}', FRECPTNO='{$candidate_list_receipt_no}', FLOGDATE=now() where FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FREGNO='{$reg_no}' "; $lobj_update_total_fee = $aobj_context->mobj_db->Execute($update_total_fee); $update_student_category="update student set FCASTE='{$category}' where FREGNO='{$reg_no}'"; $lobj_update_student_category = $aobj_context->mobj_db->Execute($update_student_category); // to insert STUDFEE insertStudFeeDetails($aobj_context,$degree,$college_code,$reg_no,$FLOGNAME); if($lobj_update_total_fee) { $arr='Details Updated Successfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $arr='Updation failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success"); return; } } else { $arr='Candidate List Freezed By Admin'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } function insertStudFeeDetails($aobj_context,$degree,$college_code,$reg_no,$FLOGNAME) { include_once("json.php"); $json = new Services_JSON(); $lstr_fee_details = stripslashes($aobj_context->mobj_data["new_fee_details"]); $mobj_lstr_fee_details = $json->decode($lstr_fee_details); $fee_details_data = get_object_vars($mobj_lstr_fee_details); if($college_code == '') { $arr='Updation failed. Login and try Again'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"success"); return; die(); } for($i=65;$i<75;$i++) { $char_id=chr($i); if(($fee_details_data[$char_id])!=0) { $delete_from_stud_fee="delete from studfee where FDEGREE='{$degree}' and FEXAMNO='{$char_id}' and FCOLLCODE='{$college_code}' and FREGNO='{$reg_no}'"; $lobj_delete_from_stud_fee = $aobj_context->mobj_db->Execute($delete_from_stud_fee); $insert_arr=get_object_vars($fee_details_data[$char_id]); if(count($insert_arr)>0) { foreach( $insert_arr as $ak=>$av) { $FFEECODE=$ak; $FAMOUNT=$av; $insert_into_student_fee="insert into studfee ( FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FFEECODE,FAMOUNT,FLOGNAME,FLOGDATE ) VALUES ( '{$degree}', '{$char_id}', '{$college_code}', '{$reg_no}', '{$FFEECODE}', '{$FAMOUNT}', '{$FLOGNAME}', NOW() )"; $lobj_insert_into_student_fee = $aobj_context->mobj_db->Execute($insert_into_student_fee); } } // $lobj_update_records = $aobj_context->mobj_db->Execute($update_records); } } } function getExamfeeNames($aobj_context) { //session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $FLOGNAME = $_SESSION['usr']; $reg_no = $aobj_context->mobj_data["reg_no"]; $degree = $aobj_context->mobj_data["degree"]; $exam_no = $aobj_context->mobj_data["exam_no"]; $get_existing_data="select ifnull(GROUP_CONCAT(FFEECODE,'_',FLOOR(FAMOUNT) separator '~'),0) as stu_data from studfee where FREGNO='{$reg_no}' and FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FEXAMNO='{$exam_no}'"; $aobj_context->mobj_db->execute("SET @@session.group_concat_max_len=100000"); $lobj_get_existing_data = $aobj_context->mobj_db->getRow($get_existing_data); $exsting_data=$lobj_get_existing_data['stu_data']; $select_data="select '{$exam_no}' as exam_no,'{$exsting_data}' as stu_data,FFEECODE,FSHORTNAME,FDESCPN from masfee order by FSEQUENCE"; $lobj_select_data = $aobj_context->mobj_db->getAll($select_data); $fee_data.="<table align='center' cellspacing='0' cellpadding='0' border='0' width='98%'>"; //$fee_data.="<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;'>User Rights</th>"; $fee_data.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $fee_data.="<td align='center' style='font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Particulars</td>"; $fee_data.="<td align='center' style='font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Amount</td>"; $fee_data.="</tr>"; $k=0; foreach($lobj_select_data as $key=>$val) { if($k%2==0) $fee_data.="<tr class='ui-widget-content jqgrow' >"; $fee_data.="<td align='left' style='font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC; padding:2px;'>{$val['FDESCPN']}</td>"; $fee_data.="<td style='padding:2px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC; font-size:12px; '><input style='width:90px; text-align:right; border:1px solid #C5DBEC;' type='text' value=0 id='fee_{$exam_no}_{$val['FFEECODE']}_amount'></td>"; $fee_data.="</tr>"; $k++; } $fee_data.="</table>"; //$fee_data.=" <br><input type='button' value='OK' onclick=AssignMarkstoGlobalVariable('{$exam_no}');> <input type='button' value='Cancel' onlcick=removeFeePopUp('');>"; $fee_data.=" <br><input type='button' class='ui-corner-all ui-widget-header' style='font-size:12px;' value='OK' onclick=AssignMarkstoGlobalVariable('{$exam_no}');> "; $fee_data.=" <input type='button' class='ui-corner-all ui-widget-header' style='font-size:12px;' value='Cancel' onclick=removeFeePopUp();>"; $arr['fee_data']=$fee_data; $arr['table_data']=$lobj_select_data; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Success"); } function GetCandidateListPhoto($aobj_context) { // session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $college_code = $_SESSION['collcode']; $reg_no = $aobj_context->mobj_data["reg_no"]; $degree = $aobj_context->mobj_data["degree"]; // $get_student_path="select ifnull(FPHOTOPATH,'') as FPHOTOPATH from student // where FREGNO='{$reg_no}' and FDEGREE='{$degree}' // and FCOLLCODE='{$college_code}'"; // $lobj_get_student_path = $aobj_context->mobj_db->getRow($get_student_path); $get_student_path="select concat('https://university-student-photos.s3.ap-south-1.amazonaws.com/',control.funivcode,'/',ifnull(FPHOTOPATH,'')) as FPHOTOPATH from student, control where FREGNO='{$reg_no}' and FDEGREE='{$degree}' and FCOLLCODE='{$college_code}'"; $lobj_get_student_path = $aobj_context->mobj_db->getRow($get_student_path); if(!empty($lobj_get_student_path['FPHOTOPATH'])) { $data=$lobj_get_student_path['FPHOTOPATH']; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"Success"); } else { $data=$lobj_get_student_path['FPHOTOPATH']; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Failure"); } } function PopulateExamTypeListCategory($aobj_context) { //session_start(); $FUNIVCODE=$_SESSION['FUNIVCODE']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $degree = $aobj_context->mobj_data["degree"]; $reg_no = $aobj_context->mobj_data["reg_no"]; $get_category_names="select FCATEGORY as internal_code,FCATEGORY as value from category "; $get_student_cat="SELECT IFNULL(FCASTE,0) as FCATEGORY FROM student WHERE FREGNO='{$reg_no}' "; $lobj_get_student_cat1 = $aobj_context->mobj_db->GetRow($get_student_cat); $query = "select ifnull(FCATEGORY,'') as FCATEGORY,ifnull(FFEETYPE,'') as FFEETYPE from candsum WHERE FREGNO='{$reg_no}'"; $lobj_get_student_cat = $aobj_context->mobj_db->GetRow($query); $arr['FCATEGORY'] = $lobj_get_student_cat['FCATEGORY'] == '' ? $lobj_get_student_cat1['FCATEGORY'] : $lobj_get_student_cat['FCATEGORY']; $arr['FFEETYPE'] = $lobj_get_student_cat['FFEETYPE'] == '' ? 'Normal Fee' : $lobj_get_student_cat['FFEETYPE']; if($FUNIVCODE == '30') { $get_fconst = "SELECT DISTINCT FCONSTYPE as internal_code,FCONSTYPE as value FROM admfeestr ORDER BY 1 DESC "; }else { $get_fconst = "SELECT DISTINCT FCONSTYPE as internal_code,FCONSTYPE as value FROM admfeestr where FDEGREE='{$degree}' and fcombcode = 'EXAM' ORDER BY 1 DESC "; } $lobj_get_category_names = $aobj_context->mobj_db->GetAll($get_category_names); $lobj_get_fconst = $aobj_context->mobj_db->GetAll($get_fconst); // $lobj_get_student_cat = $aobj_context->mobj_db->GetRow($get_student_cat); //var_dump($get_fconst); $arr['category']=$lobj_get_category_names; $arr['FCONSTYPE']=$lobj_get_fconst; //$arr['FCATEGORY']=$lobj_get_student_cat['FCATEGORY']; if($lobj_get_category_names!= 0) echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } ?>
Close
