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 | : 52.14.255.122
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 /
suk_discontinued /
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
6.91
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.35
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
9.7
KB
-rwxr-xr-x
attendance_freez.php
8.45
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.php
2.73
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
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
3.19
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
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
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
4.95
KB
-rwxr-xr-x
degree.php
6.51
KB
-rwxr-xr-x
display_details_in_grid.php
105.12
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
4.82
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
33.59
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
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
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
71.94
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
16.41
KB
-rwxr-xr-x
room_allotment_datewise.php
16.47
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.88
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
46.56
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
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
79.94
KB
-rwxr-xr-x
teachers.php
14.51
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
8.61
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 : revaluation.php
<?php function GetNextNumber($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $get_prefix_running_number = "select last_number from reval_code_generator where college_code = '{$college_code}' "; $lobj_get_prefix_running_number = $aobj_context->mobj_db->GetRow($get_prefix_running_number); if(!empty($lobj_get_prefix_running_number[last_number])) { $next_number = $lobj_get_prefix_running_number[last_number]+1; $last_number = str_pad($next_number,5, "0", STR_PAD_LEFT); } else { $next_number=0001; $insert_into="insert into reval_code_generator(college_code,last_number) values ( '{$college_code}', {$next_number} )"; $lobj_insert_into = $aobj_context->mobj_db->Execute($insert_into); $last_number = str_pad($next_number,4, "0", STR_PAD_LEFT); } return $college_code.$last_number; } function UpdateNextNumber($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $update_code_generator = "update reval_code_generator set last_number = last_number+1 where college_code = '{$college_code}' "; $lobj_update_code_generator = $aobj_context->mobj_db->Execute($update_code_generator); } function DisplayRevalutionDetails($aobj_context) { session_start(); $college_code = $_SESSION['collcode']; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $revalution_degree_code=($aobj_context->mobj_data["revalution_degree_code"]); $revalution_regno=($aobj_context->mobj_data["revalution_regno"]); $get_reg_no_exists="select count(*) as reg_cnt from mresult where FREGNO='{$revalution_regno}'"; $lobj_get_reg_no_exists = $aobj_context->mobj_db->GetRow($get_reg_no_exists); //echo $get_reg_no_exists; if($lobj_get_reg_no_exists[reg_cnt]>0) { $get_already_applied="SELECT APPNO,DATE_FORMAT(FAPPDATE,'%d/%m/%Y') AS app_date, FTOTAL,mr.FSUBCODE,FCORRTYPE,FAMOUNT,mr.internal_code FROM mresult_detail mr LEFT JOIN subject s ON mr.FSUBCODE=s.FCSUBCODE inner JOIN student st ON st.FREGNO=mr.FREGNO WHERE mr.FREGNO='{$revalution_regno}' AND mr.FCOLLCODE='{$college_code}' AND s.FDEGREE=mr.FDEGREE AND s.FEXAMNO=mr.FEXAMNO "; $lobj_get_already_applied= $aobj_context->mobj_db->GetAll($get_already_applied); //echo $get_already_applied; $allready_applied_arr=array(); $allready_applied_html_arr=array(); foreach($lobj_get_already_applied as $ak=>$av) { $allready_applied_arr[$av['FSUBCODE']][$av['FCORRTYPE']]=$av['FAMOUNT']; $allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['type']=$av['FCORRTYPE']; $allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['amt']=$av['FAMOUNT']; $allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['app_date']=$av['app_date']; $allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['FTOTAL']=$av['FTOTAL']; $allready_applied_html_arr[$av['APPNO']][$av['FSUBCODE']][$av['FCORRTYPE']]['internal_code']=$av['internal_code']; } $get_data="select mr.internal_code,date_format(current_date(),'%d/%m/%Y') as curr_date, s.FDEGREE,FCSUBCODE ,concat(s.FSUBNAME ,' ',s.FSSUBNAME) as FSUBNAME, mr.FPASS,st.FNAME , IFNULL(FRVFEE,0) as FRVFEE, IFNULL(FRTFEE,0) as FRTFEE, IFNULL(FXRFEE,0) as FXRFEE, IFNULL(FCVFEE,0) as FCVFEE, IF(CURRENT_DATE()<=IFNULL(FRVLASTDATE,'0000-00-00'),'1',0) AS is_rv, IF(IFNULL(CURRENT_DATE()<=FRTLASTDATE,'0000-00-00'),'1',0) AS is_rt, IF(IFNULL(CURRENT_DATE()<=FXEROXLASTDATE,'0000-00-00'),'1',0) AS is_xr, IF(IFNULL(CURRENT_DATE()<=FCVLASTDATE,'0000-00-00'),'1',0) AS is_cv from mresult mr left join subject s on mr.FSUBCODE=s.FCSUBCODE left join student st on st.FREGNO=mr.FREGNO where mr.FREGNO='{$revalution_regno}' and mr.FCOLLCODE='{$college_code}' and s.FDEGREE=mr.FDEGREE and s.FEXAMNO=mr.FEXAMNO group by FCSUBCODE"; $lobj_get_data = $aobj_context->mobj_db->GetAll($get_data); $str_reval=""; $str_reval.="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='100%' border='0' cellspacing='0' cellpadding='0'>"; $str_reval.="<th align='left' colspan='8' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Revaluation</th>"; $str_reval.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $str_reval.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Code</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Result?</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>RV</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>RT</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Xerox</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Challenge Val.</td>"; $str_reval.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'> Total</td>"; $str_reval.="</tr>"; $sl_no=0; $total_val=0; //echo $get_data; $name=$lobj_get_data[0][FNAME]; $curr_date=$lobj_get_data[0][curr_date]; foreach($lobj_get_data as $k=>$val) { //print_r($lobj_get_data); die(); $is_selected_checked=''; $FCSUBCODE =$val[FCSUBCODE]; $is_rv =$val['is_rv']; $is_rt =$val['is_rt']; $is_xr =$val['is_xr']; $is_cv =$val['is_cv']; $applied_arr=$allready_applied_arr[$FCSUBCODE]; $FPASS =$val[FPASS]; $FFEE =$val[FFEE]; $internal_code =$val[internal_code]; $FSUBNAME =$val[FSUBNAME]; $FRVFEE =$val[FRVFEE]; $FRTFEE =$val[FRTFEE]; $FXRFEE =$val[FXRFEE]; $FCVFEE =$val[FCVFEE]; $rv_disabled=""; $rt_disabled=""; $xr_disabled=""; if($applied_arr["RV"]>0) $rv_disabled=" disabled=true; "; if($applied_arr["RT"]>0) $rt_disabled=" disabled=true; "; if($applied_arr["XR"]>0) $xr_disabled=" disabled=true; "; if($applied_arr["CV"]>0) $cv_disabled=" disabled=true; "; $str_reval.="<tr class='ui-widget-content jqgrow'>"; $str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=fccode_{$internal_code}>{$FCSUBCODE}</td>"; $str_reval.="<td class='tbl_row_new' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=fsname_{$internal_code}>{$FSUBNAME}</td>"; $str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=fsname_{$internal_code}>{$FPASS}</td>"; $str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=is_sele_{$internal_code}>"; if($is_rv=="1") $str_reval.="<input id='rv_{$internal_code}' {$rv_disabled} onclick='CalculateRevaluationTotFee();' type='checkbox' style='width: 20px;'><span style='font-weight:bold;' id='fee_rv_{$internal_code}'>({$FRVFEE})</span></td>"; else $str_reval.="NA / Last date over</td>"; $str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=is_sele_{$internal_code}>"; if($is_rt=="1") $str_reval.="<input id='rt_{$internal_code}' {$rt_disabled} onclick='CalculateRevaluationTotFee();' type='checkbox' style='width: 20px;'> <span style='font-weight:bold;' id='fee_rt_{$internal_code}'>({$FRTFEE})</span></</td>"; else $str_reval.="NA / Last date over</td>"; $str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=is_sele_{$internal_code}>"; if($is_xr=="1") $str_reval.="<input id='xr_{$internal_code}' {$xr_disabled} onclick='CalculateRevaluationTotFee();' type='checkbox' style='width: 20px;'><span style='font-weight:bold;' id='fee_xr_{$internal_code}'>({$FXRFEE})</span></</td>"; else $str_reval.="NA / Last date over</td>"; $str_reval.="<td class='tbl_row_new' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px; ' id=is_sele_{$internal_code}>"; if($is_cv=="1") $str_reval.="<input id='cv_{$internal_code}' {$cv_disabled} onclick='CalculateRevaluationTotFee();' type='checkbox' style='width: 20px;'><span style='font-weight:bold;' id='fee_cv_{$internal_code}'>({$FCVFEE})</span></</td>"; else $str_reval.="NA / Last date over</td>"; $str_reval.="<td class='tbl_row_new' align='right' style='border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;font-weight:bold; ' id=total_{$internal_code}></td>"; $str_reval.="</tr>"; $sl_no++; } $str_reval.="</table>"; $arr['reval_html']=$str_reval; $arr['total_val']=$total_val; $arr['name']=$name; $arr['curr_date']=$curr_date; $str_reval1=""; if(count($allready_applied_html_arr)>0) { $str_reval1.="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='80%' border='0' align='center' cellspacing='0' cellpadding='0'>"; $str_reval1.="<th align='left' colspan='7' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Entered Revaluation Data</th>"; $str_reval1.="<tr class='ui-state-default ui-jqgrid-hdiv' >"; $str_reval1.="<td align='center' style=' font-size:12px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>App No</td>"; $str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject</td>"; $str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Type</td>"; $str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Amount</td>"; $str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Delete</td>"; $str_reval1.="<td align='center' style=' font-size:12px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Grand Total</td>"; $str_reval1.="</tr>"; foreach($allready_applied_html_arr as $app=>$app_val) { //echo "<pre>";print_r($app_val);die(); $cnt=0; foreach($app_val as $aks=>$avv) { $cnt+=count($avv); } $i=0; foreach($app_val as $aks=>$avv) { foreach($avv as $ak=>$av) { $internal_code=$av['internal_code']; $str_reval1.="<tr class='ui-widget-content jqgrow' >"; if($i==0) $str_reval1.="<td class='tbl_row_new' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' rowspan={$cnt}>{$app}</td>"; $str_reval1.="<td class='tbl_row_new' style='text-align:center; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' id='delete_td_1_{$internal_code}' >{$aks}</td>"; $str_reval1.="<td class='tbl_row_new' style='text-align:center; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' id='delete_td_2_{$internal_code}' >{$av['type']}</td>"; $str_reval1.="<td class='tbl_row_new' style='text-align:center; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' id='delete_td_3_{$internal_code}' >{$av['amt']}</td>"; $str_reval1.="<td class='tbl_row_new' style='text-align:center; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;' id='delete_td_4_{$internal_code}' ><img src='img/Remove-icon.png' alt='Delete' onclick='DeleteMresultDetail({$internal_code},\"{$app}\");'></img></td>"; if($i==0) $str_reval1.="<td class='tbl_row_new' style='text-align:center; border-right:1px solid #C5DBEC; padding:2px; font-size:12px;font-weight:bold;' rowspan={$cnt} >{$av['FTOTAL']}</td>"; $str_reval1.="</tr>"; $i++; } } } $str_reval1.="</table>"; } if(!empty($lobj_get_data)) { $arr['reval_html']=$str_reval; $arr['total_val']=$total_val; $arr['allready_html']=$str_reval1; $arr['name']=$name; $arr['curr_date']=$curr_date; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } else { $data="You Cannot Enter the Revaluation Details"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); } } else { $data="Invalid Reg No"; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"success"); } } function SaveRevalution($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include_once("/JSON.php"); $json = new Services_JSON(); session_start(); $usr=$_SESSION['usr']; $reg_no=($aobj_context->mobj_data["reg_no"]); $revalution_corr_type=($aobj_context->mobj_data["revalution_corr_type"]); $revalution_fee_total=($aobj_context->mobj_data["revalution_fee_total"]); $revalution_date=($aobj_context->mobj_data["revalution_date"]); $revalution_dd_no=($aobj_context->mobj_data["revalution_dd_no"]); $revalution_receipt_no=($aobj_context->mobj_data["revalution_receipt_no"]); $lstr_param_reval = stripslashes($aobj_context->mobj_data["myJSONText"]); $mobj_json_reval_data = $json->decode($lstr_param_reval); $reval_arr_data = get_object_vars($mobj_json_reval_data); $int_codes_arr=array(); $app_number=GetNextNumber($aobj_context); foreach($reval_arr_data as $ak=>$av) { $get_data="select FDEGREE,FEXAMNO,FCOLLCODE,FREGNO,FSUBCODE,FYEAR,FEXAMTYPE from mresult where internal_code={$ak}"; $lobj_get_data = $aobj_context->mobj_db->GetRow($get_data); //echo "<pre>".$get_data."<br>"; $FDEGREE=$lobj_get_data['FDEGREE']; $FEXAMNO=$lobj_get_data['FEXAMNO']; $FCOLLCODE=$lobj_get_data['FCOLLCODE']; $FREGNO=$lobj_get_data['FREGNO']; $FSUBCODE=$lobj_get_data['FSUBCODE']; $FYEAR=$lobj_get_data['FYEAR']; $FEXAMTYPE=$lobj_get_data['FEXAMTYPE']; foreach($av as $akk=>$avv) { $delete_from="delete from mresult_detail where FDEGREE='{$FDEGREE}' and FEXAMNO='{$FEXAMNO}' and FCOLLCODE='{$FCOLLCODE}' and FREGNO='{$FREGNO}' and FSUBCODE='{$FSUBCODE}' and FCORRTYPE='{$akk}' "; $lobj_delete_from = $aobj_context->mobj_db->Execute($delete_from); //echo $delete_from."<br>"; $insert="INSERT INTO mresult_detail ( APPNO, FAPPDATE, FDEGREE, FEXAMNO, FCOLLCODE, FREGNO, FSUBCODE, FCORRTYPE, FAMOUNT, FTOTAL, FRECNO, CHALLANNO, FCHALLANDATE, FDATE,FYEAR,FEXAMTYPE, FUSER, FLOGDATE )values ('{$app_number}',current_date(),'{$FDEGREE}','{$FEXAMNO}', '{$FCOLLCODE}','{$FREGNO}','{$FSUBCODE}','{$akk}', '{$avv}',{$revalution_fee_total},'{$revalution_receipt_no}', '{$revalution_dd_no}','{$revalution_date}','{$revalution_date}', '{$FYEAR}','{$FEXAMTYPE}', '{$usr}',current_date() )"; $lobj_insert = $aobj_context->mobj_db->Execute($insert); } } if($lobj_insert) { UpdateNextNumber($aobj_context); $arr="Done! Application No: {$app_number}"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } else { $arr='Updation Failed'; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); return; } } function DeleteMresultDetail($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $int_code=($aobj_context->mobj_data["int_code"]); $app_no=($aobj_context->mobj_data["app_no"]); $delete_from="delete from mresult_detail where internal_code={$int_code}"; $lobj_delete_from = $aobj_context->mobj_db->Execute($delete_from); $get_app_no="SELECT SUM(FAMOUNT) as tot_amt FROM mresult_detail WHERE APPNO='{$app_no}' "; $lobj_get_app_no = $aobj_context->mobj_db->GetRow($get_app_no); $tot_amt=$lobj_get_app_no['tot_amt']; $update="update mresult_detail set FTOTAL={$tot_amt} WHERE APPNO='{$app_no}' "; $lobj_get_app_no = $aobj_context->mobj_db->Execute($update); echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_app_no,0,"success"); } ?>
Close