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.221.217.100
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
oasis /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-xr-x
CIEAttendanceNotEligible.php
3.28
KB
-rw-rw-r--
CIEpendingList.php
5.85
KB
-rw-rw-r--
Dispatch_ans_script_setup.php
5.84
KB
-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...
5.18
KB
-rwxr-xr-x
DisplayPrintApplication_ru.php
65.63
KB
-rw-rw-r--
ECHblk.php
14.61
KB
-rwxr-xr-x
ECHblk_15042021.php
11.68
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
30.6
KB
-rw-rw-r--
MarkEntry-Setup_bf_gcg.php
22.89
KB
-rwxr-xr-x
MarkEntry-Setupx.php
30.61
KB
-rwxr-xr-x
SelectSubjType.php
3.05
KB
-rw-rw-r--
SubjectType.php
3.62
KB
-rw-rw-r--
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
UpdateCollDet.php
2.03
KB
-rwxr-xr-x
absentAndMalReportPdf.php
8.25
KB
-rw-rw-r--
absentEntryYearModewise.php
991
B
-rw-rw-r--
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
11.36
KB
-rwxr-xr-x
ack_adm_application.php
103.36
KB
-rwxr-xr-x
ack_adm_application.php.orig
58.73
KB
-rwxr-xr-x
ack_admentry_application.php
59.63
KB
-rwxr-xr-x
ack_exam_app_form.php
20.27
KB
-rwxr-xr-x
ack_exam_app_form_bulk.php
12.71
KB
-rwxr-xr-x
ack_report.php
3.69
KB
-rwxr-xr-x
ack_rv_rt_application.php
9.34
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
adm_delete_data.php
5.58
KB
-rwxr-xr-x
admapprove.php
10.33
KB
-rwxr-xr-x
admapprove_kus.php
9.28
KB
-rwxr-xr-x
admissionHallTicket.php
4.43
KB
-rw-r--r--
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admissionapplist.php
5.06
KB
-rwxr-xr-x
admlist.php
13.87
KB
-rwxr-xr-x
admstuddate.php
6.06
KB
-rwxr-xr-x
admuploadexsheet.php
20.48
KB
-rwxr-xr-x
affliation_fee.php
5.04
KB
-rwxrwxrwx
approve.php
41.53
KB
-rwxr-xr-x
approve_kus.php
24.12
KB
-rwxr-xr-x
assignUserMenu.php
13.66
KB
-rw-rw-r--
attCisshortList_sjbit.php
11.91
KB
-rw-r--r--
attEntTeachWise.php
2.07
KB
-rw-rw-r--
attEntryDaywise.php
26.9
KB
-rw-rw-r--
attTeachSum.php
3.63
KB
-rw-r--r--
attendEntry.php
5.32
KB
-rw-rw-r--
attendance.php
17.09
KB
-rwxr-xr-x
attendanceReportForm.php
6.36
KB
-rw-rw-r--
attendance_freez.php
8.51
KB
-rwxr-xr-x
attendance_freez_mth.php
8.24
KB
-rwxr-xr-x
attendanceentrydaywise.php
11.36
KB
-rw-r--r--
attendenceshort.php
7.58
KB
-rw-rw-r--
attshort.php
6.29
KB
-rwxr-xr-x
atttechblp.php
2.48
KB
-rw-r--r--
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.php
4.12
KB
-rwxr-xr-x
backup_1.php
7.85
KB
-rwxr-xr-x
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
backupold.php
2.73
KB
-rwxr-xr-x
bill_details.php
14.21
KB
-rw-rw-r--
board.php
4
KB
-rwxr-xr-x
bundle_dispatch.php
3.2
KB
-rwxr-xr-x
bundle_rec_ack.php
4.67
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.28
KB
-rwxr-xr-x
candidate-entry.php
50.68
KB
-rwxr-xr-x
cappcontext.php
2.71
KB
-rwxr-xr-x
challan_entries.php
15.05
KB
-rwxr-xr-x
challan_preparation.php
11.29
KB
-rwxr-xr-x
changeDegree.php
1.56
KB
-rwxr-xr-x
changeMobile.php
2.13
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
cntDeclaration.php
4.23
KB
-rwxr-xr-x
coll_exam_app_form.php
3.29
KB
-rwxr-xr-x
collbankdet.php
1.9
KB
-rwxr-xr-x
colldesp_ack.php
4.03
KB
-rw-rw-r--
college.php
5.39
KB
-rwxr-xr-x
college_approve.php
5.59
KB
-rwxr-xr-x
college_degree_status.php
5.65
KB
-rwxr-xr-x
collegewisedownload.php
9.46
KB
-rw-rw-r--
colltransfer.php
6.83
KB
-rw-rw-r--
connect.php
2.58
KB
-rwxr-xr-x
convdet.php
8.02
KB
-rwxr-xr-x
convo.php
8.14
KB
-rw-rw-r--
copoMarksList.php
1.27
KB
-rw-rw-r--
copomarksentry.php
10.46
KB
-rw-r--r--
copomarksexternal.php
23.05
KB
-rw-r--r--
coporeport.php
4.56
KB
-rw-r--r--
courserep.php
1.68
KB
-rw-r--r--
coutput.php
1.84
KB
-rwxr-xr-x
createAdmission.php
14.91
KB
-rwxr-xr-x
create_all_grid_files.php
8.57
KB
-rwxr-xr-x
create_all_grid_group_files.ph...
9.94
KB
-rwxr-xr-x
create_all_popup_files.php
5.93
KB
-rwxr-xr-x
create_all_schema_files.php
4.31
KB
-rwxr-xr-x
create_all_views.php
16.52
KB
-rwxr-xr-x
create_html_files.php
52.03
KB
-rwxr-xr-x
create_html_files_without_tab....
44.49
KB
-rwxr-xr-x
create_module_meta_columns.php
5.16
KB
-rwxr-xr-x
createattclass.php
6.99
KB
-rw-rw-r--
createclassattend.php
22.03
KB
-rw-r--r--
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
548
B
-rwxr-xr-x
cuser.php
3.53
KB
-rwxr-xr-x
custom_mregistry.php
122
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
6.67
KB
-rwxr-xr-x
degree.php
8.28
KB
-rwxr-xr-x
degree_SujectReport.php
893
B
-rw-rw-r--
degstudymat.php
6.51
KB
-rwxr-xr-x
degstudymatdet.php
6.27
KB
-rwxr-xr-x
degwiseIAreport.php
2.95
KB
-rw-rw-r--
display_details_in_grid.php
107.2
KB
-rw-rw-r--
display_details_in_grid_bf_231...
111.76
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.72
KB
-rwxr-xr-x
display_details_in_grid_studta...
96.56
KB
-rwxr-xr-x
display_details_in_grid_withde...
97.45
KB
-rwxr-xr-x
doc_verify.php
7.52
KB
-rwxr-xr-x
download_misc_files.php
5.19
KB
-rwxr-xr-x
download_misc_files_bcu_comm.p...
4.19
KB
-rwxr-xr-x
download_photo.php
35.98
KB
-rwxr-xr-x
download_photo_pgadm_photos.ph...
4.73
KB
-rw-rw-r--
download_upload.php
3.86
KB
-rwxr-xr-x
dynamicmastersdetails.php
117.45
KB
-rwxr-xr-x
dynamicmastersdetails_one.php
119.36
KB
-rwxr-xr-x
editstddet.php
7.01
KB
-rw-rw-r--
enableStudReg.php
7.65
KB
-rwxr-xr-x
entregupd.php
1.91
KB
-rw-rw-r--
entryexitevents.php
3.09
KB
-rwxr-xr-x
error_log.php
749
B
-rwxr-xr-x
examappfeereport.php
2.12
KB
-rw-rw-r--
execute_query.php
2.5
KB
-rwxr-xr-x
export_import_setup.php
7.62
KB
-rwxr-xr-x
export_import_utility.php
2.67
KB
-rwxr-xr-x
feepaidreports.php
2.77
KB
-rwxr-xr-x
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.64
KB
-rwxr-xr-x
freeze_module_at_admin_college...
10.48
KB
-rwxr-xr-x
freeze_module_at_admin_college...
9.35
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
freezeiaprici.php
10.87
KB
-rwxr-xr-x
general_report_format.php
11
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getDegreeAndSem.php
4.32
KB
-rw-rw-r--
getMessages.php
11.39
KB
-rwxr-xr-x
getTestTotalMarksReport.php
11.96
KB
-rw-rw-r--
getdata.php
39.06
KB
-rwxrwxrwx
getdataold.php
29.62
KB
-rwxr-xr-x
getfeeinformation.php
7.26
KB
-rwxr-xr-x
getmoduledetails.php
23.77
KB
-rwxr-xr-x
getnumword.php
7.45
KB
-rwxr-xr-x
getreportdetails.php
3.21
KB
-rwxr-xr-x
getreportfilefordisplay.php
1.37
KB
-rwxr-xr-x
getsearchcondition.php
1.3
KB
-rwxr-xr-x
ggridmodel.php
9.27
KB
-rwxr-xr-x
golden_palm_payslip.php
12.48
KB
-rwxr-xr-x
helptext.php
5.38
KB
-rwxr-xr-x
htblk.php
6.13
KB
-rwxr-xr-x
ia_room_allotment_datewise.php
12.13
KB
-rwxr-xr-x
iaabsententry.php
3.1
KB
-rw-r--r--
iamarks.php
7.68
KB
-rw-r--r--
iaroomdeclaration.php
2.6
KB
-rwxr-xr-x
iasectionwise.php
30.09
KB
-rw-r--r--
iasectionwisenew.php
35.77
KB
-rw-r--r--
iatimetable.php
7.61
KB
-rw-r--r--
identifyCoMarksNew.php
2.6
KB
-rw-rw-r--
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
invigilatorDairyRoomWise.php
6.07
KB
-rw-rw-r--
json.php
34.52
KB
-rwxr-xr-x
lateralentry.php
2.39
KB
-rwxr-xr-x
login.php
8.88
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
marksEntryExt.php
9.11
KB
-rwxr-xr-x
marksentryext.php
13.1
KB
-rw-rw-r--
marksentryquestionwise.php
41.93
KB
-rw-rw-r--
message_board.php
4.67
KB
-rwxr-xr-x
messagetext.php
1.68
KB
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
155.51
KB
-rwxr-xr-x
mregistry18.06.2021.php
99.46
KB
-rwxr-xr-x
mregistry_14092024.php
150.27
KB
-rw-rw-r--
mrn_approval.php
9
KB
-rwxr-xr-x
oldqnpaper.php
4.44
KB
-rw-rw-r--
pendingcie.php
4.21
KB
-rw-rw-r--
picharttesting.php
24.76
KB
-rw-r--r--
pmarks.php
5.97
KB
-rw-rw-r--
post.php
6
KB
-rwxr-xr-x
practicalMarks.php
8.67
KB
-rw-rw-r--
prbillreport.php
5.07
KB
-rw-r--r--
prientCodeStikers.php
6.35
KB
-rw-r--r--
principalFreeze.php
6.92
KB
-rw-rw-r--
principalfreezingsubject.php
1.9
KB
-rw-rw-r--
printAdmRegn.php
13.13
KB
-rwxr-xr-x
printApp_ru.php
1.12
KB
-rw-rw-r--
printMarkListDetailsWisenew_sj...
14.42
KB
-rw-r--r--
qnwiseMarksStats.php
6.14
KB
-rw-rw-r--
qnwisemarksentrynew.php
18.61
KB
-rw-rw-r--
qpSummaryReport.php
1.03
KB
-rw-rw-r--
receive_rv_rt_application.php
8.33
KB
-rwxr-xr-x
receive_teach_trans.php
2.49
KB
-rw-rw-r--
receive_teach_transfer.js
5.06
KB
-rw-rw-r--
remunerationEntry.php
7.14
KB
-rw-rw-r--
repeateriamarksentry.php
4.86
KB
-rw-rw-r--
report_bulk_applications.php
19.42
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_ra_invigilator_dairy.ph...
22.93
KB
-rwxr-xr-x
report_ra_qp_wise_student_coun...
8.54
KB
-rwxr-xr-x
report_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
KB
-rwxr-xr-x
resetPasswordUser.php
2.69
KB
-rw-rw-r--
result.php
5.06
KB
-rwxr-xr-x
revaluation.php
16.66
KB
-rwxr-xr-x
revaluation_oldtype.php
8.45
KB
-rwxr-xr-x
revaluation_withdegree.php
16.77
KB
-rwxr-xr-x
roomAllotment.php
37.45
KB
-rw-rw-r--
room_allotment.php
9.14
KB
-rwxr-xr-x
room_allotment_datewise.php
26.07
KB
-rwxr-xr-x
room_allotment_datewise_bf_rcu...
16.97
KB
-rwxr-xr-x
room_allotment_datewise_stph.p...
21.57
KB
-rwxr-xr-x
room_allotment_datewise_stph_n...
29.01
KB
-rwxr-xr-x
room_allotment_shifiting.php
3.34
KB
-rwxr-xr-x
roomallotmentExcel.php
8.23
KB
-rw-rw-r--
roomallotmentqpwise.php
10.22
KB
-rw-rw-r--
roomallotmentqpwisenew.php
13.92
KB
-rw-rw-r--
roomcreationnew.php
2.81
KB
-rw-rw-r--
roomdeclaration.php
2.2
KB
-rwxr-xr-x
roomdeclaration_stph.php
2.51
KB
-rwxr-xr-x
roomwiseinvigilatorsEntry.php
9.86
KB
-rw-rw-r--
rvdates.php
6.46
KB
-rw-rw-r--
rvrt_ack_exam_app.php
6
KB
-rw-rw-r--
rvrt_report.php
1.92
KB
-rw-rw-r--
savePassword.php
1.14
KB
-rw-rw-r--
saveclsdets.php
1.91
KB
-rw-rw-r--
savesspdetails.php
9.93
KB
-rw-rw-r--
sectionwisepermission.php
5.67
KB
-rwxr-xr-x
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
sendsmsapi.php
814
B
-rwxr-xr-x
sendusrandpws.php
1002
B
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
shortLists.php
1.65
KB
-rw-rw-r--
std_register_det.php
3.56
KB
-rw-rw-r--
stringspliter.php
693
B
-rwxr-xr-x
studSubIdent.php
11.23
KB
-rw-r--r--
stud_name_doc_upload.php
1.24
KB
-rw-rw-r--
stud_wise_report.php
3.02
KB
-rw-rw-r--
student.php
58.23
KB
-rwxr-xr-x
student_entry.php
61.39
KB
-rwxr-xr-x
student_entry_kswu.php
51.23
KB
-rwxr-xr-x
student_entry_nitte.php
88.09
KB
-rw-rw-r--
student_entry_rur.php
74.42
KB
-rw-rw-r--
student_entry_vku.php
66.58
KB
-rwxr-xr-x
student_rur.php
64.37
KB
-rw-rw-r--
student_vku.php
57.95
KB
-rwxr-xr-x
studentfeesandattiashortagedat...
11.38
KB
-rw-rw-r--
studentportal_remove.php
6.18
KB
-rwxr-xr-x
studentreport.php
15.37
KB
-rw-rw-r--
studnamecorr.php
6.69
KB
-rw-rw-r--
subIAMarksEntry.php
11.14
KB
-rw-rw-r--
subblock.php
6.12
KB
-rwxr-xr-x
subdet.php
9.61
KB
-rw-rw-r--
subjReg.php
12.04
KB
-rw-r--r--
subjectList_display.php
11.7
KB
-rwxr-xr-x
subject_freshExam.php
33.18
KB
-rwxr-xr-x
subject_freshExam_rcub.php
28.33
KB
-rwxr-xr-x
subjectfreez.php
13.02
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
12.43
KB
-rwxr-xr-x
subshort.php
8.97
KB
-rw-rw-r--
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
80.41
KB
-rwxr-xr-x
teachFreeze.php
8.17
KB
-rw-r--r--
teachOficerEntry.php
11.46
KB
-rwxr-xr-x
teachers.php
19.76
KB
-rwxr-xr-x
theoryMarksEntry.php
4.89
KB
-rw-rw-r--
thvalmarks.php
2.72
KB
-rw-r--r--
time_table_degreewise.php
5
KB
-rwxrwxrwx
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
4.74
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updatecopo.php
9.34
KB
-rw-r--r--
updatedegreegroup.php
3.21
KB
-rw-rw-r--
updateexamcnt.php
2.92
KB
-rwxr-xr-x
updatefreshexam.php
1.33
KB
-rw-rw-r--
updatestudentsem.php
2.03
KB
-rw-rw-r--
updatetimetable.php
9.14
KB
-rw-r--r--
updateuvcms.php
2.37
KB
-rw-rw-r--
updmarks.php
22.24
KB
-rw-r--r--
updnemp.php
1.78
KB
-rw-r--r--
upload_doc_demo.php
84
B
-rw-rw-r--
upload_studentPhoto.php
10.81
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadcopo.php
7.89
KB
-rw-r--r--
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
uploadteacherattendance.php
5.23
KB
-rw-r--r--
userpasswordreset.php
754
B
-rw-rw-r--
usersetup.php
24.46
KB
-rwxr-xr-x
usersetupNew.php
12.76
KB
-rw-r--r--
usersubj_identification.php
5.15
KB
-rwxr-xr-x
viewNotifications.php
1.21
KB
-rw-rw-r--
view_ledger.php
3.64
KB
-rwxrwxrwx
yearmode.php
1.83
KB
-rw-rw-r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : room_allotment_datewise_bf_rcub.php
<?php /*error_reporting(E_ALL); ini_set('display_errors','on');*/ 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->funivcode = $_SESSION['FUNIVCODE']; $this->collcode = $_SESSION['collcode']; $this->log_name = $_SESSION['usr']; } function DisplayRoomAllotmentDetatilsDatewise() { session_start(); $this->collcode=$_SESSION['collcode']; $frm_date = ($this->aobj_context->mobj_data["frm_date"]); $session = ($this->aobj_context->mobj_data["session"]); $faculty = ($this->aobj_context->mobj_data["faculty"]); $ra_from = ($this->aobj_context->mobj_data["ra_from"]); $ra_to = ($this->aobj_context->mobj_data["ra_to"]); $deggrp = ($this->aobj_context->mobj_data["deggrp"]); if($session== 'both') { $sectionvalue = ""; } else { $sectionvalue = "and s.fsession like '{$session}'"; } //and dd.ffaculty = '{$faculty}' 10521 $hall_no = '0'; //$query = "select distinct fqpcode from subject where fdoe = '2016-11-21' "; $query = "SELECT COUNT(DISTINCT cd.FREGNO) AS reg_cnt,s.FQPCODE,s.FDOE,s.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 cd.FDEGREE=cs.FDEGREE and cd.fcollcode = cs.fcollcode and cs.FREGNO=cd.FREGNO inner join degree dd on cd.fdegree=dd.fdegree and dd.fexamno=cd.fexamno WHERE cs.fcntrcode = '{$this->collcode}' and s.fdoe = date_format(STR_TO_DATE('{$frm_date}', '%d/%m/%Y'),'%Y-%m-%d') AND IFNULL(cd.fpassmth,'') = '' AND cd.FPRESENT='P' {$sectionvalue} AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' and ifnull(s.fqpcode,'') <> '' and dd.fdegree in(select distinct fdegree from degree where fdeggrp = '{$deggrp }') GROUP BY s.FQPCODE ORDER BY reg_cnt DESC,s.fsession,s.FQPCODE"; //var_dump($query); die(); $results = $this->aobj_context->mobj_db->GetAll($query); $query1 = "SELECT COUNT(DISTINCT cd.FREGNO) AS reg_cnt 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 cd.FDEGREE=cs.FDEGREE and cd.fcollcode = cs.fcollcode and cs.FREGNO=cd.FREGNO inner join degree dd on cd.fdegree=dd.fdegree and dd.fexamno=cd.fexamno WHERE cs.fcntrcode = '{$this->collcode}' and s.fdoe = date_format(STR_TO_DATE('{$frm_date}', '%d/%m/%Y'),'%Y-%m-%d') AND IFNULL(cd.fpassmth,'') = '' AND cd.FPRESENT='P' {$sectionvalue} and dd.fdegree in(select distinct fdegree from degree where fdeggrp = '{$deggrp }') AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' GROUP BY s.fdoe"; $results1 = $this->aobj_context->mobj_db->GetRow($query1); $reg_cnt = $results1['reg_cnt']; $query1 = "select sum(fcapacity) as fcapacity from masroom where froomno >= '{$ra_from}' AND froomno <='{$ra_to}' and fcollcode = '{$this->collcode}' and fcapacity > 0"; $results1 = $this->aobj_context->mobj_db->GetRow($query1); $fcapacity = $results1['fcapacity']; if($reg_cnt > $fcapacity) { $arr = "Insufficient Rooms for the allotment. Total Capacity : ".$fcapacity." Total Strength :".$reg_cnt; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); }else { $str_reval.="<br>"; $str_reval.="<table style='padding:' class='tr_ventor_row' id='reval_table_data' width='80%' name = 'HALL' border='0' cellspacing='0' cellpadding='0'>"; $str_reval.="<tr class='tr_bg1'>"; $str_reval.="<td align='center' style='width:8%; 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='width:30%; 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='width:8%;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;'>Room Capacity</td>"; $str_reval.="<td align='center' style='width:10%; 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;'>Qp Code</td>"; $str_reval.="<td align='center' style='width:8%; 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;'>Student Count</td>"; //$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;'>Capacity Remaing</td>"; $str_reval.="<td align='center' style='width:8%; 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;'>Alloted</td>"; $str_reval.="<td align='center' style='width:8%; 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;'>Not-Alloted</td>"; $str_reval.="</tr>"; $cpacity = 0; $studcount = 0; $alloted = 0; $remaing = 0; $query2 ="SELECT GROUP_CONCAT(froomno,'->',froomname,'->',fcapacity) as roomname FROM masroom WHERE froomno >= '{$ra_from}' AND froomno <='{$ra_to}' and fcollcode = '{$this->collcode}' and fcapacity > 0 group by froomno order by froomno"; $rst2 = $this->aobj_context->mobj_db->GetAll($query2); // $i=0; $k=1; //var_dump($rst2); foreach($results as $ak=>$value) { $reg_cnt = $value['reg_cnt']; //echo "student count \n"; //var_dump($reg_cnt); if($reg_cnt > 0) { $studcount = intval($reg_cnt); //echo "student count in if\n"; //var_dump($studcount); while($studcount>0) { $arry = explode("->",$rst2[$i]['roomname']); $hall_no = $arry[0]; $froomname = $arry[1]; $capacity = $arry[2]; $hallcapacity = $arry[2]; //echo "Hall no\n"; //var_dump($arry); if($remaing > 0) { $capacity = $remaing; //echo "student count Remaining\n"; //var_dump($remaing); } if($capacity >= $studcount) { $remaing = $capacity - $studcount; $alloted = $studcount; if($remaing == 0 || $capacity === $studcount) $i++; $studcount = 0; } else { $studcount = $studcount - $capacity; $alloted = $capacity; $remaing = 0; $i++; } if($k%2==0) $class='tbl_row1'; else $class='tbl_row_alter1'; $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;' ><input style='width:100%;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$hall_no}' name = 'HALL' disabled id='{$k}_hallno' /> </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;' ><input style='width:100%;text-align:left;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$froomname}' disabled id='{$k}_roomname' /> </td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' ><input style='width:100%;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$hallcapacity}' disabled id='{$k}_capacity' /> </td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' ><input style='width:100%;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$value['FQPCODE']}' disabled id='{$k}_qpcode' /> </td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' ><input style='width:100%;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$reg_cnt}' disabled id='{$k}_count' /> <input style='width:70px;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='hidden' value='{$remaing}' disabled id='{$k}_remaing' /></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:100%;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$alloted}' disabled id='{$k}_alloted' /></td>"; $str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' ><input style='width:100%;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$studcount}' disabled id='{$k}_notalloted' /> <input style='width:70px;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='hidden' value='{$value['FDOE']}' disabled id='{$k}_fdoe' /> <input style='width:70px;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='hidden' value='{$value['FDESCPN']}' disabled id='{$k}_sestion' /> <input style='width:70px;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='hidden' value='{$value['fsubcode']}' disabled id='{$k}_subcode' /></td>"; $str_reval.="</tr>"; $k++; /*echo "K= ".$k."\n"; echo "student Count\n"; var_dump($studcount);*/ /*if($k == 40) break;*/ } } } $str_reval.="</table>"; $arr['html']=$str_reval; echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } } function SaveRoomAllotmentDatewise() { ini_set('memory_limit','900M'); ini_set('max_execution_time',0); include("error_log.php"); include_once($this->aobj_context->main_src."/src/json.php"); $json = new Services_JSON(); $hall_arr = stripslashes($this->aobj_context->mobj_data["hall_arr"]); $faculty = ($this->aobj_context->mobj_data["faculty"]); $session = ($this->aobj_context->mobj_data["session"]); $rafrom = ($this->aobj_context->mobj_data["rafrom"]); $rato = ($this->aobj_context->mobj_data["rato"]); $college_code = $_SESSION['collcode']; $mobj_jsondata = $json->decode($hall_arr); $hall_arr = get_object_vars($mobj_jsondata); //var_dump($hall_arr); $i = 0; $oldqp = ''; $newqp = ''; $doe = ''; $sestion= ""; $j = 0; $mpcnd = "and ifnull(ab.fabstype,'') <> 'QpM'"; if($this->funivcode == '027') $mpcnd = ""; for($k=1;$k<=count($hall_arr);$k++) { $newqp = $hall_arr[$k]->qpcode; if($newqp != $oldqp) { $i = 0; $doe = $hall_arr[$k]->fdoe; $query1 = "SET SESSION group_concat_max_len=100000"; $results1 = $this->aobj_context->mobj_db->Execute($query1); $query1 = "SET SESSION group_concat_max_len=10000000"; $results = $this->aobj_context->mobj_db->Execute($query1); $query = "SELECT s.fqpcode, group_concat(distinct concat(\"'\",concat(cd.fdegree,cd.fsubcode,cd.FREGNO),\"'\") order by cd.fdegree, cd.fsubcode, cd.fregno) as 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.fdegree = cd.fdegree and cs.FCOLLCODE = cd.FCOLLCODE and cs.FREGNO=cd.FREGNO inner join degree dd on dd.fdegree=cd.fdegree and dd.fexamno=cd.fexamno WHERE cs.FCNTRCODE='{$this->collcode}' AND TRIM(s.FQPCODE)='{$hall_arr[$k]->qpcode}' AND s.fdoe ='{$hall_arr[$k]->fdoe}' AND FPRESENT='P' AND IFNULL(cd.fpassmth,'') = '' AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' group by s.fqpcode"; // var_dump($query); $results = $this->aobj_context->mobj_db->GetRow($query); //var_dump($results); } if($hall_arr[$j]->remaing > 0) { $hall_arr[$k]->capacity = $hall_arr[$j]->remaing; } $insert = " insert into room_allotment(FCOLLCODE,FQPCODE,FHALLNO,FCAPACITY,FLOGNAME,FLOGDATE,FDOE,FSESSION,FORDER) values ('{$this->collcode}','{$hall_arr[$k]->qpcode}' ,'{$hall_arr[$k]->hallno}','{$hall_arr[$k]->alloted}', '{$this->log_name}',now(),'{$hall_arr[$k]->fdoe}','{$hall_arr[$k]->sestion}','{$k}') ON DUPLICATE KEY UPDATE FCOLLCODE = '{$this->collcode}', FQPCODE = '{$hall_arr[$k]->qpcode}', FHALLNO = '{$hall_arr[$k]->hallno}', FCAPACITY = '{$hall_arr[$k]->alloted}', FLOGNAME = '{$this->log_name}', FLOGDATE = now(), FDOE = '{$hall_arr[$k]->fdoe}', FSESSION = '{$hall_arr[$k]->sestion}', FORDER = '{$k}'"; $lobj_insert = $this->aobj_context->mobj_db->Execute($insert); //var_dump($insert); $fregno = explode(',',$results['fregno']); //var_dump($fregno); $FSUBCODE = $results['FSUBCODE']; $regnoin = array_slice($fregno,$i,$hall_arr[$k]->capacity); $regnoin = implode(',',$regnoin); //var_dump($regnoin); $update = "update canddet,candsum set canddet.FHALLNO='{$hall_arr[$k]->hallno}' where canddet.FDEGREE = candsum.FDEGREE and canddet.FCOLLCODE = candsum.FCOLLCODE and canddet.FREGNO = candsum.FREGNO and candsum.FCNTRCODE='{$this->collcode}' and concat(canddet.fdegree,canddet.fsubcode,canddet.FREGNO) in({$regnoin})"; $lobj_update = $this->aobj_context->mobj_db->Execute($update); //var_dump($update); $i = $i+$hall_arr[$k]->capacity; $oldqp = $hall_arr[$k]->qpcode; $j++; } if($lobj_update) { $univcode = $_SESSION['FUNIVCODE']; $mob = $_SESSION['FMOBILE']; $usr = $_SESSION['usr']; $college_code = $_SESSION['collcode']; $enttype = "RAL"; $remark = "RAL - Rooms allotted, $doe, $session, $faculty, $rafrom to $rato"; $res = error_logs($this->aobj_context,$univcode,$remark,$college_code,$enttype,$usr,$mob); // if (!empty($_SERVER['HTTP_CLIENT_IP'])) // { // $ip_address = $_SERVER['HTTP_CLIENT_IP']; // } // else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) // { // $ip_address = $_SERVER['HTTP_X_FORWARDED_FOR']; // } // else // { // $ip_address = $_SERVER['REMOTE_ADDR']; // } // $query = "INSERT INTO logisys3_logs.daylog (funivcode, fdate, fip, fremarks, fcollcode, fenttype, fuser, fmobileno) // VALUES ('{$univcode}', now(),'{$ip_address}', '{$remark}', '{$college_code}', 'RAL', '{$usr}', '{$mob}')"; // $res = $this->aobj_context->mobj_db->Execute($query); $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 DisplayRoomAllotmentDetatilsDatewise($aobj_context) { $class_obj=new room_allotment($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->DisplayRoomAllotmentDetatilsDatewise(); } function SaveRoomAllotmentDatewise($aobj_context) { $class_obj=new room_allotment($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $class_obj->SaveRoomAllotmentDatewise(); } 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}' and fcapacity > 0 order by ifnull(forder,0), froomno "; //var_dump($query);die(); $rst = $aobj_context->mobj_db->getAll($query); //forder, echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); } ?>
Close