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.45.223
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 /
html /
sdu /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-xr-x
Dispatch_ans_script_setup.php
5.84
KB
-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...
5.18
KB
-rwxr-xr-x
DownloadExamAppFormApplication...
5.12
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
24.41
KB
-rwxr-xr-x
MarkEntry-Setup22.php
21.76
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
TAGMAY2013.pdf
331.03
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
TarkaFormatStyles_old.php
3.71
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
7.25
KB
-rwxr-xr-x
absent_entry_setupQpold.php
7.03
KB
-rwxr-xr-x
absententrysubjectwiseQP.js
16.34
KB
-rwxr-xr-x
ack_exam_app_form.php
15.86
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.58
KB
-rwxr-xr-x
ack_exam_app_form_oldformat.ph...
12.53
KB
-rwxr-xr-x
ack_rv_rt_application.php
8.52
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
admapprove.php
9.24
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admissionapplist.php
9.9
KB
-rwxr-xr-x
ansbookcancel.php
9.49
KB
-rwxr-xr-x
answer_book_issued.php
10.34
KB
-rwxr-xr-x
approve.php
23.86
KB
-rwxr-xr-x
attendance.php
10.23
KB
-rwxr-xr-x
attendance_freez.php
8.45
KB
-rwxr-xr-x
attendance_freez_mth.php
8.24
KB
-rwxr-xr-x
attendance_freez_old.php
8.55
KB
-rwxr-xr-x
attshort.php
6.29
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.js
2.73
KB
-rwxr-xr-x
backup.php
2.74
KB
-rwxr-xr-x
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
basic_old.css
13.33
KB
-rwxr-xr-x
batch_close.php
4.31
KB
-rwxr-xr-x
boeselection.php
1.64
KB
-rwxr-xr-x
bundle_dispatch.php
2.93
KB
-rwxr-xr-x
bundlereceive.php
1.08
KB
-rwxr-xr-x
bundlestatus.php
5.3
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.24
KB
-rwxr-xr-x
candidate-entry.php
45.51
KB
-rwxr-xr-x
candidate-entry_new.php
42.85
KB
-rwxr-xr-x
candidate-entry_without_iapr_i...
34.88
KB
-rwxr-xr-x
candidate-entrybefore yearexam...
34.55
KB
-rwxr-xr-x
candidate-entrykus.php
33.23
KB
-rwxr-xr-x
candidate-entrynewformat.php
44.16
KB
-rwxr-xr-x
candidate-entryold.php
34.55
KB
-rwxr-xr-x
candidate_list.js
39.62
KB
-rwxr-xr-x
cappcontext.php
2.64
KB
-rwxr-xr-x
cconfig_wait.php
1.12
KB
-rwxr-xr-x
challan_entries.php
15.41
KB
-rwxr-xr-x
challan_preparation.php
11.69
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
colldesp_ack.php
4
KB
-rwxr-xr-x
college.php
4.61
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.5
KB
-rwxr-xr-x
college_approve.php
5.61
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
connect.php
2.11
KB
-rwxr-xr-x
convdet.php
8.02
KB
-rwxr-xr-x
coutput.php
1.75
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_grid_group_files_ol...
9.61
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
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
514
B
-rwxr-xr-x
cuser.php
3.41
KB
-rwxr-xr-x
custom_mregistry.php
122
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
7.36
KB
-rwxr-xr-x
degree.php
6.49
KB
-rwxr-xr-x
display_details_in_grid.php
105.86
KB
-rwxr-xr-x
display_details_in_grid22.php
104.95
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.6
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
display_details_in_gridold.php
102.19
KB
-rwxr-xr-x
doc_verify.php
6.99
KB
-rwxr-xr-x
downloadFeeStatement.php
5.32
KB
-rwxr-xr-x
download_misc_files.php
4.59
KB
-rwxr-xr-x
download_misc_files_old.php
4.3
KB
-rwxr-xr-x
download_photo.php
3.54
KB
-rwxr-xr-x
download_photo22.php
6.83
KB
-rwxr-xr-x
download_photo_new.php
4.82
KB
-rwxr-xr-x
download_photo_sikkim.php
5.07
KB
-rwxr-xr-x
download_photoold.php
3.58
KB
-rwxr-xr-x
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
entryexitevents.php
3.09
KB
-rwxr-xr-x
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
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.63
KB
-rwxr-xr-x
freeze_module_at_admin_college...
9.74
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.76
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.81
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
general_report_format.php
11
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getdata.php
35.88
KB
-rwxr-xr-x
getdata22.php
32.91
KB
-rwxr-xr-x
getdataold.php
28.7
KB
-rwxr-xr-x
getfeeinformation.php
7.03
KB
-rwxr-xr-x
getmoduledetails.php
23.59
KB
-rwxr-xr-x
getnumword.php
7.43
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
hidden.php
239.01
KB
-rwxr-xr-x
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
index.php
5.06
KB
-rwxr-xr-x
json.php
33.22
KB
-rwxr-xr-x
krvw.html
1.5
KB
-rwxr-xr-x
login.php
10.94
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
mascomb.php
10.02
KB
-rwxr-xr-x
mcverifydet.php
14.26
KB
-rwxr-xr-x
message_board.php
4.7
KB
-rwxr-xr-x
messagetext.php
980
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
90.13
KB
-rwxr-xr-x
mregistry_09012020.php
73.81
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
payment_gateway.php
7.78
KB
-rwxr-xr-x
pclzip.lib.php
192.53
KB
-rwxr-xr-x
photoupload.php
9.28
KB
-rwxr-xr-x
printexamform.php
11.54
KB
-rwxr-xr-x
receive_rv_rt_application.php
8.57
KB
-rwxr-xr-x
report_admission_ticket.php
46.77
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_marks_entry_subwise_lis...
11.84
KB
-rwxr-xr-x
report_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
KB
-rwxr-xr-x
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
room_allotment.php
15.43
KB
-rwxr-xr-x
room_allotment_datewise.php
15.59
KB
-rwxr-xr-x
room_allotment_datewise_090120...
15.37
KB
-rwxr-xr-x
room_allotmentnew.php
9.24
KB
-rwxr-xr-x
room_allotmentold.php
15.27
KB
-rwxr-xr-x
roomdeclaration.php
1.77
KB
-rwxr-xr-x
rvdates.php
6.46
KB
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
servfeehead.php
3.84
KB
-rwxr-xr-x
services.php
3.47
KB
-rwxr-xr-x
sfeehead.php
5.45
KB
-rwxr-xr-x
stringspliter.php
693
B
-rwxr-xr-x
student.php
43.89
KB
-rwxr-xr-x
student_entry.php
45.88
KB
-rwxr-xr-x
student_entry24.php
56.54
KB
-rwxr-xr-x
student_entry_24112017.php
42.7
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
subjectList_display.php
11.05
KB
-rwxr-xr-x
subject_freshExam.php
18.98
KB
-rwxr-xr-x
subjectfreez.php
13.16
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
9.95
KB
-rwxr-xr-x
subshort.php
5.83
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
79.94
KB
-rwxr-xr-x
teachers.php
16.85
KB
-rwxr-xr-x
teachersOLD.php
10.33
KB
-rwxr-xr-x
teachersnew.php
16.83
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
4.79
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updateexamcnt.php
2.92
KB
-rwxr-xr-x
upload_studentPhoto.php
10.06
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadzip.php
8.46
KB
-rwxr-xr-x
usersetup.php
25.06
KB
-rwxr-xr-x
usersetupold.php
24.36
KB
-rwxr-xr-x
usersubj_identification.php
4.88
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : candidate-entryold.php
<?php function replaceChars($name) { $spl_char = array("*","/","~","!","@","#","$","%","^","&",":",";","?","/","\\","_","-","'"," ",""); $link_name = strtolower(str_replace($spl_char,"_",$name)); return str_ireplace("__","_",$link_name); } 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"]; $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=" select c.FDEGREE,c.FEXAMNO,c.FCOLLCODE,c.FREGNO,if(c.FCATEGORY='',s.FCASTE,c.FCATEGORY) as FCATEGORY, if(c.FSEX='',s.FSEX,c.FSEX) as FSEX,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 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}' and 1=2"; $student_exam_details = $aobj_context->mobj_db->GetRow($qry); } else { $qry=" select c.FDEGREE,c.FEXAMNO,c.FCOLLCODE,c.FREGNO,if(c.FCATEGORY='',s.FCASTE,c.FCATEGORY) as FCATEGORY, if(c.FSEX='',s.FSEX,c.FSEX) as FSEX,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 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}' "; $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'>"; $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; 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>"; } $e_data.="</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); for($j=0;$j<count($lobj_get_total_sub_for_degree);$j++) { if($lobj_get_total_sub_for_degree[$j]['FEXAMNO']=='A') { $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') { $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') {$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') {$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') {$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') {$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') {$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') {$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') {$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') {$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' border='0' cellspacing='0' cellpadding='0'>"; $id.="<th align='left' colspan='10' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:10px; 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 M/Y<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, if(c.FINSERTED='','F',c.FINSERTED) as FINSERTED from canddet c inner join subject s on s.FDEGREE=c.FDEGREE and s.FSUBCODE=c.FSUBCODE where c.FDEGREE='{$degree}' and c.FCOLLCODE='{$college_code}' 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']; $FSUBSHORT=$lobj_rs[$m]['FSUBSHORT']; $FSUBNAME=$lobj_rs[$m]['FSUBNAME']; 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="<input type='checkbox' {$checked} id='exam_{$char_name}_ce_pass_{$txt_id}'>"; $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;{$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>"; $id.="<td style='padding:2px; font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;' align='center' ><input type='checkbox' id='exam_{$char_name}_ce_pass_{$txt_id}' checked> </td>"; $id.="</tr>"; $k++; $txt_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>" */; $id.="<tr>"; $id.="<td colspan='4'>"; $id.="<div style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC; padding:4px; height:17px;'>"; $id.="<div style='width:74px; float:left'>Receipt No:</div>"; $id.="<div style='width:99px; float:left'><input type='text' style='width:85px;' id='exam_{$char_name}_receipt_no' value='{$exam_receipt_no_val}'></div>"; $id.="<div style='float:left;'>Date:</div>"; $id.="<div style='width:95px; border:1px solid #ccc; float:left;'> <input style='width:75px; border:0px;' id='exam_{$char_name}_date' value='{$exam_receipt_no_date_val}' type='text' value='00/00/0000' /> <script>$('#exam_{$char_name}_date').datepicker({showOn: 'button',showButtonPanel: true, changeMonth: true, changeYear: true,dateFormat:'dd/mm/yy',buttonImage: 'images/date.gif', buttonImageOnly: true});</script></div>"; $id.="<div style='width:40px; float:left;'> </div>"; $id.="<div style='width:121px; float:left;'><input class='ui-state-default ui-corner-all' align=right type='button' onclick=GetFeePopUp('{$char_name}'); value='Exam Fee:'/></div>"; $id.="<div style='width:100px; float:left'><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);'></div>"; $id.="</div>"; $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"]); include_once("/JSON.php"); $json = new Services_JSON(); $college_path=$aobj_context->main_src."/student_photos/{$college_code}"; $folder_path=$aobj_context->main_src."/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; $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.'/'.$unlink_file); $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 FCCLSTATUS from colldeg where FCOLLCODE='{$college_code}' and FDEGREE='{$degree}'"; $lobj_check_adminsion_freeze = $aobj_context->mobj_db->getRow($check_adminsion_freeze); //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); $exam_data=get_object_vars($sub_arr_data[$char_id]); if(!empty($exam_data)) { 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 FSUBCODE='{$exam_data[$k]->sub}' and FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FREGNO='{$reg_no}' "; $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) values ( '{$degree}', '{$exam_data[$k]->ex}', '{$college_code}', '{$reg_no}', '{$exam_data[$k]->sub}', 'T', '{$FRESENT}' )"; $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) values ( '{$degree}', '{$exam_data[$k]->ex}', '{$college_code}', '{$reg_no}', '{$exam_data[$k]->sub}', 'T', '{$FRESENT}' )"; $lobj_insert_canddet_records = $aobj_context->mobj_db->Execute($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}', 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); // 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["fee_details"]); $mobj_lstr_fee_details = $json->decode($lstr_fee_details); $fee_details_data = get_object_vars($mobj_lstr_fee_details); 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); $tilde_split=explode("~",$fee_details_data[$char_id]); for($h=0;$h<count($tilde_split);$h++) { if(!empty($tilde_split[$h])) { $value_split=explode("_",$tilde_split[$h]); $FFEECODE=$value_split[0]; $FAMOUNT=$value_split[1]; $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 FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FEXAMNO='{$exam_no}' and FREGNO='{$reg_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 FDEGREE='{$degree}' and FCOLLCODE='{$college_code}' and FREGNO='{$reg_no}'"; $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"); } } ?>
Close