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.143.241.205
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 /
rcub /
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
ECHblk.php
11.1
KB
-rwxr-xr-x
ECHblk26112019.php
11.06
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MainPage.html
11.66
KB
-rwxr-xr-x
MarkEntry-Setup.php
22.92
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
TarkaFormatStyles_old.php
3.71
KB
-rwxr-xr-x
UpdateCollDet.php
3.61
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
8.7
KB
-rwxr-xr-x
absent_entry_setupQp09.09.2020...
6.95
KB
-rwxr-xr-x
absent_entry_setupQp27.11.2019...
6.93
KB
-rwxr-xr-x
absent_entry_setupQpold.php
7.03
KB
-rwxr-xr-x
ack_adm_application.php
66.54
KB
-rwxr-xr-x
ack_adm_application09092020.ph...
58.44
KB
-rwxr-xr-x
ack_adm_application_bf_bcu_130...
55.28
KB
-rwxr-xr-x
ack_admentry_application.php
48.13
KB
-rwxr-xr-x
ack_exam_app_form.php
12.08
KB
-rwxr-xr-x
ack_report.php
2.63
KB
-rw-rw-r--
ack_report_07072022.php
2.23
KB
-rwxr-xr-x
ack_rv_rt_application.php
8.27
KB
-rwxr-xr-x
ack_rv_rt_application12.03.201...
8.19
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
ack_rv_rt_application_old.php
8.1
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
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admissionapplist.php
5.06
KB
-rwxr-xr-x
admissionapplist_bf_login_0610...
9.9
KB
-rwxr-xr-x
admstuddate.php
6.06
KB
-rwxr-xr-x
admuploadexsheet.php
13.63
KB
-rwxr-xr-x
approve.php
38.89
KB
-rwxr-xr-x
approve_bf_login_06102020.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
3.42
KB
-rwxr-xr-x
backup02122016.php
2.6
KB
-rwxr-xr-x
backup_1.php
1.86
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
board.php
2.97
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
47.06
KB
-rwxr-xr-x
candidate-entry11112016.php
43.36
KB
-rwxr-xr-x
candidate-entry25.03.2019.php
45.81
KB
-rwxr-xr-x
candidate-entry_23092018.php
45.38
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
2.66
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
college.php
4.69
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.5
KB
-rwxr-xr-x
college_approve.php
5.59
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
connect.php
2.57
KB
-rwxr-xr-x
coutput.php
1.75
KB
-rwxr-xr-x
createAdmission.php
16.66
KB
-rwxr-xr-x
createAdmission21.12.2020.php
14.53
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
6.06
KB
-rwxr-xr-x
daterange11.03.2019.php
4.06
KB
-rwxr-xr-x
degree.php
6.54
KB
-rwxr-xr-x
degstudymat.php
6.45
KB
-rwxr-xr-x
degstudymatdet.php
6.3
KB
-rwxr-xr-x
display_details_in_grid.php
102.76
KB
-rwxr-xr-x
display_details_in_grid1109201...
102.06
KB
-rwxr-xr-x
display_details_in_grid1209201...
102.27
KB
-rwxr-xr-x
display_details_in_grid2609201...
102.25
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.69
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.64
KB
-rwxr-xr-x
download_photo.php
3.51
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
error_log.php
749
B
-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.31
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.46
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
getMessages.php
11.32
KB
-rwxr-xr-x
getMessages25.11.2020.php
11.39
KB
-rwxr-xr-x
getMessages_02092020.php
11.16
KB
-rwxr-xr-x
getdata.php
36.98
KB
-rw-rw-r--
getdata12092016.php
28.9
KB
-rwxr-xr-x
getdata26092016.php
28.88
KB
-rwxr-xr-x
getdata_11092021.php
35.53
KB
-rwxr-xr-x
getdata_23042018.php
32.87
KB
-rwxr-xr-x
getdataold.php
29.62
KB
-rwxr-xr-x
getfeeinformation.php
6.14
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
lateralentry.php
2.39
KB
-rwxr-xr-x
login.php
8.87
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
mp_batch_upd.php
2.1
KB
-rwxr-xr-x
mregistry.php
95.35
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mregistry_bf_bcu_13082020.php
91.38
KB
-rwxr-xr-x
mregistry_bf_studymat.php
89.91
KB
-rwxr-xr-x
mregistry_old_12102019.php
74.88
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
receive_rv_rt_application.php
8.33
KB
-rwxr-xr-x
receive_rv_rt_application19.03...
8.57
KB
-rwxr-xr-x
receive_rv_rt_application_old....
8.08
KB
-rwxr-xr-x
regSubCorr.php
27.72
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_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
10.36
KB
-rwxr-xr-x
room_allotment24112016.php
9.29
KB
-rwxr-xr-x
room_allotment_datewise.php
22.77
KB
-rwxr-xr-x
room_allotment_datewise0312201...
19.06
KB
-rwxr-xr-x
room_allotment_datewise_1605.p...
17.07
KB
-rwxr-xr-x
room_allotment_datewise_251220...
16.48
KB
-rwxr-xr-x
roomdeclaration.php
1.88
KB
-rwxr-xr-x
savesspdetails.php
9.89
KB
-rw-rw-r--
sectionwisepermission.php
5.53
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
stringspliter.php
693
B
-rwxr-xr-x
student.php
56.7
KB
-rwxr-xr-x
student_entry.php
60.55
KB
-rwxr-xr-x
student_entry03102016.php
40.73
KB
-rwxr-xr-x
student_entry04.10.2018.php
53.57
KB
-rwxr-xr-x
student_entry1.php
48.78
KB
-rwxr-xr-x
student_entry27.08.2018.php
53.1
KB
-rwxr-xr-x
student_entry_04042018.php
48.79
KB
-rwxr-xr-x
student_entry_06032018.php
46.48
KB
-rwxr-xr-x
student_entry_bf_login_0610202...
57.16
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
studentportal_remove.php
6.18
KB
-rwxr-xr-x
subjectList_display.php
11.01
KB
-rwxr-xr-x
subject_freshExam.php
32.27
KB
-rw-rw-r--
subject_freshExam_11092021.php
28.44
KB
-rwxr-xr-x
subjectfreez.php
13.02
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
82.65
KB
-rwxr-xr-x
teacher_summary.php
1.62
KB
-rw-rw-r--
teachers.php
16.64
KB
-rwxr-xr-x
teachers04.10.2018.php
15.02
KB
-rwxr-xr-x
teachers1.php
14.46
KB
-rwxr-xr-x
teachersOLD.php
10.33
KB
-rwxr-xr-x
teachers_03.02.2019.php
16.13
KB
-rwxr-xr-x
teachers_03.09.2018.php
14.23
KB
-rwxr-xr-x
teachers_06.06.2020.php
16.12
KB
-rwxr-xr-x
time_table_degreewise.php
4.82
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
updateexamcnt.php
2.92
KB
-rwxr-xr-x
upload_studentPhoto.php
10.16
KB
-rwxr-xr-x
upload_studentPhoto30112019.ph...
8.03
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadteacherattendance.php
5.23
KB
-rw-r--r--
usersetup.php
24.14
KB
-rwxr-xr-x
usersubj_identification.php
6.26
KB
-rwxr-xr-x
view_ledger.php
1.23
KB
-rwxrwxrwx
Delete
Unzip
Zip
${this.title}
Close
Code Editor : room_allotment.php
<?php class room_allotment { function __construct($aobj_context) { session_start(); $this->aobj_context=$aobj_context; $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $this->user_id=$_SESSION['user_id'] ; $this->collcode=$_SESSION['collcode']; $this->log_name = $_SESSION['usr']; } function DisplayRoomAllotmentDetatils() { $qp_code = ($this->aobj_context->mobj_data["qp_code"]); $ra_stu_cnt = ($this->aobj_context->mobj_data["ra_stu_cnt"]); $ra_from = ($this->aobj_context->mobj_data["ra_from"]); $ra_to = ($this->aobj_context->mobj_data["ra_to"]); $query2 =" SELECT froomno,froomname FROM masroom WHERE froomno >= '{$ra_from}' AND froomno <='{$ra_to}' and fcollcode = '{$this->collcode}' order by froomno asc"; $rst2 = $this->aobj_context->mobj_db->GetAll($query2); $get_data=" SELECT FHALLNO,FCAPACITY FROM room_allotment WHERE FCOLLCODE='{$this->collcode}' AND FQPCODE='{$qp_code}' "; $lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data); // To display room name 12/11/2016 $qury=" SELECT froomno, froomname, fcapacity FROM masroom where ifnull(fdeleted,'') <> 'T' and fcollcode = '{$this->collcode}' order by froomno asc"; $rst = $this->aobj_context->mobj_db->GetAll($qury); foreach($rst as $rmk => $rmv) { $rmname[$rmv['froomno']] = $rmv['froomname']; $rmcapacity[$rmv['froomno']] = $rmv['fcapacity']; } //end $existing_details=array(); $cnt=1; foreach($lobj_get_data as $ak=>$av) { $existing_details[$av['FHALLNO']]=$av['FCAPACITY']; } $str_reval.="<br>"; $str_reval.="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='50%' border='0' cellspacing='0' cellpadding='0'>"; $str_reval.="<tr class='tr_bg1'>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Hall No</td>"; // To display room name 12/11/2016 $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Hall Name</td>"; $str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Capacity</td>"; $str_reval.="</tr>"; $k=0; $sl_no=1; $total=0; $pretotal = 0; for($i=0;$i<count($rst2);$i++) { //$hall_no=str_pad($i, 3, "0", STR_PAD_LEFT); $hall_no = $rst2[$i]['froomno']; $val=$existing_details[$hall_no]; $hallname = $rmname[$hall_no]; // To display room name 12/11/2016 if(!empty($rmcapacity[$hall_no]) && empty($val)) { $val = $rmcapacity[$hall_no]; } // end if(empty($val)) $val=0; $total+= $val; if($k%2==0) $class='tbl_row1'; else $class='tbl_row_alter1'; // To break loop after max count 12/11/2016 $currcnt = $ra_stu_cnt - $total; if($currcnt <= 0) { $val = $ra_stu_cnt -($total-$val); $total = $pretotal+$val; } $str_reval.="<tr>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >{$hall_no}</td>"; // To display room name 12/11/2016 $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >{$hallname}</td>"; $str_reval.="<td class='{$class}' align='center' style=' font-size:12px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-weight:bold;text-align:center;' ><input style='width:50px;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$val}' id='ra_input_{$hall_no}' /></td>"; $str_reval.="</tr>"; $sl_no++; $k++; $pretotal = $total; // To break loop after max count 12/11/2016 /* if($currcnt <= 0) { break; } */ } $str_reval.="<tr>"; $str_reval.="<td class='{$class}' colspan=2 style=' font-size:12px; font-weight:bold;text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >Total</td>"; $str_reval.="<td class='{$class}' align='center' style=' font-size:12px;font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;text-align:center;' ><input id='ra_total' style='border:none;width:50px;text-align:right;background:none; font-weight:bold;border:none;' value='{$total}' /> </td>"; $str_reval.="</tr>"; $str_reval.="</table>"; $arr['html']=$str_reval; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function SaveRoomAllotment() { $qp_code = ($this->aobj_context->mobj_data["qp_code"]); $ra_stu_cnt = ($this->aobj_context->mobj_data["ra_stu_cnt"]); $total_rooms = ($this->aobj_context->mobj_data["total_rooms"]); $FSESSION = ($this->aobj_context->mobj_data["FSESSION"]); $FDOE = ($this->aobj_context->mobj_data["FDOE"]); include_once($this->aobj_context->main_src."/src/json.php"); $json = new Services_JSON(); $lstr_param = stripslashes($this->aobj_context->mobj_data["hall_obj"]); $mobj_jsondata = $json->decode($lstr_param); $obj_arr_data = get_object_vars($mobj_jsondata); $del="delete from room_allotment WHERE FCOLLCODE='{$this->collcode}' AND FQPCODE='{$qp_code}' "; $lobj_del = $this->aobj_context->mobj_db->Execute($del); $hall_arr=array(); $cnt=1; foreach($obj_arr_data as $hall=>$capc) { $insert="insert into room_allotment( FCOLLCODE,FQPCODE,FHALLNO,FCAPACITY,FLOGNAME,FLOGDATE,FDOE,FSESSION ) values ( '{$this->collcode}','{$qp_code}' ,'{$hall}','{$capc}','{$this->log_name}',now(),'{$FDOE}','{$FSESSION}' )"; $lobj_insert = $this->aobj_context->mobj_db->Execute($insert); //var_dump($insert); $hall_arr[$cnt][$hall]=$capc; $cnt++; } if($lobj_insert) { $get_student_cnt ="SELECT cd.FREGNO,cd.FEXAMNO,cd.FDEGREE,cd.FSUBCODE FROM canddet cd INNER JOIN subject s ON s.fdegree = cd.fdegree and s.fexamno = cd.fexamno and s.FSUBCODE=cd.FSUBCODE inner join candsum cs on cs.FREGNO=cd.FREGNO WHERE cs.FCNTRCODE='{$this->collcode}' and TRIM(FQPCODE)='{$qp_code}' AND FPRESENT='P' and ifnull(cd.fpassmth,'') = '' and ifnull(cd.fthpr,'F') <> 'T' AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' order by cd.FREGNO";//and FPRESENT='P' and ifnull(FRECPTDATE,'0000-00-00')<>='0000-00-00' $lobj_get_student_cnt = $this->aobj_context->mobj_db->GetAll($get_student_cnt); $cand_det_arr=array(); $c=1; foreach($lobj_get_student_cnt as $ak=>$av) { $cand_det_arr[$c]['FREGNO']=$av['FREGNO']; $cand_det_arr[$c]['FEXAMNO']=$av['FEXAMNO']; $cand_det_arr[$c]['FDEGREE']=$av['FDEGREE']; $cand_det_arr[$c]['FSUBCODE']=$av['FSUBCODE']; $c++; } $reg_no_arr=array(); $tot_nos=0; for($i=1;$i<=count($hall_arr);$i++) { $h_arr=$hall_arr[$i]; foreach($h_arr as $hk=>$hv) { $hall=$hk; $capc=$hv; } if($i==1) { $reg_no_arr[$hall]['start']=1; $reg_no_arr[$hall]['end']=$capc; $tot_nos+=$capc; } else { $reg_no_arr[$hall]['start']=$tot_nos+1; $reg_no_arr[$hall]['end']=$tot_nos+$capc; $tot_nos+=$capc; } } foreach($reg_no_arr as $hallk =>$hallv) { for($z=$hallv[start];$z<=$hallv['end'];$z++) { $FREGNO=$cand_det_arr[$z]['FREGNO']; $FEXAMNO=$cand_det_arr[$z]['FEXAMNO']; $FDEGREE=$cand_det_arr[$z]['FDEGREE']; $FSUBCODE=$cand_det_arr[$z]['FSUBCODE']; $update =" update canddet,candsum set canddet.FHALLNO='{$hallk}' where canddet.FCOLLCODE = candsum.FCOLLCODE and canddet.FDEGREE = canddet.FDEGREE and canddet.FREGNO = candsum.FREGNO and candsum.FCNTRCODE='{$this->collcode}' and canddet.FREGNO='{$FREGNO}' and canddet.FEXAMNO='{$FEXAMNO}' and canddet.FDEGREE='{$FDEGREE}' and canddet.FSUBCODE='{$FSUBCODE}' "; $lobj_update = $this->aobj_context->mobj_db->Execute($update); } } $data="Update Successfully."; echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); } else { $data="Failed"; echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); } } } function DisplayRoomAllotmentDetatils($aobj_context) { $class_obj=new room_allotment($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->DisplayRoomAllotmentDetatils(); }function SaveRoomAllotment($aobj_context) { $class_obj=new room_allotment($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->SaveRoomAllotment(); } // function getRoomdetails($aobj_context) // { // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // session_start(); // $collcode = $_SESSION['collcode']; // $query = "select froomno as id, froomname as value from masroom // where fcollcode = '{$collcode}' and ifnull(fdeleted,'') <>'T' order by froomno"; // $rst = $aobj_context->mobj_db->getAll($query); // echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); // } function getRoomdetails($aobj_context) { session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $collcode = $_SESSION['collcode']; $query = "select froomno as id, froomname as value from masroom where ifnull(fdeleted,'') <>'T' and fcollcode = '{$collcode}' order by froomno "; //var_dump($query);die(); $rst1 = $aobj_context->mobj_db->getAll($query); //forder, $query = "select fdeggrp as id, fdescpn as value from deggrp where ifnull(fdeleted,'') <>'T'"; //var_dump($query);die(); $rst2 = $aobj_context->mobj_db->getAll($query); $query3 = "select distinct s.fsession as id,concat(r.FDESCPN,' (',s.fsession,')') as value from subject s inner join reason r on s.fsession = r.FREASONCD order by s.fsession"; $rst3 = $aobj_context->mobj_db->getAll($query3); $rst['room'] = $rst1; $rst['deggrp'] = $rst2; $rst['session'] = $rst3; echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); } ?>
Close
