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.138.105.128
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 : roomAllotment.php
<?php function getExamMonthRoomAllotment($aobj_context){ session_start(); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $collcode = $aobj_context->mobj_data['collcode']; $doe = stripslashes($aobj_context->mobj_data["dates"]); $query = "select funivcode from control"; $results = $aobj_context->mobj_db->GetRow($query); $funivcode = $results['funivcode']; $query = "select froomno as `key`, froomno as `value`, concat(froomname,' - ',fcapacity) as `label` from masroom where ifnull(fdeleted,'') <>'T' and fcapacity > 0 and fcollcode = '{$collcode}' order by froomno "; $rst1 = $aobj_context->mobj_db->getAll($query); $query = "SELECT DISTINCT dg.fdeggrp as id, dg.fdescpn as value FROM deggrp dg INNER JOIN degree d ON d.fdeggrp = dg.fdeggrp INNER JOIN subject s on s.fdegree = d.fdegree and d.fexamno = s.fexamno INNER JOIN timetable t on s.fqpcode = t.fqpcode INNER JOIN colldeg c ON c.fdegree = d.fdegree and ifnull(c.fdeleted,'') <> 'T' WHERE t.fdate ='{$doe}'"; $rst2 = $aobj_context->mobj_db->getAll($query); // $query = "SELECT distinct concat(d.fyear,'*',d.fexamtype)as `value`, concat(t.fdeggrp,' - ',d.fexamdate) as `label`, // concat(t.fdeggrp,' - ',d.fexamdate) as `key` // FROM degexam d INNER JOIN candsum c // ON d.fdegree = c.fdegree and d.fyear = c.fyear // and d.fexamtype = c.fexamtype // INNER JOIN subject s on s.fdegree = c.fdegree // INNER JOIN timetable t on s.fqpcode = t.fqpcode // and t.fyear = c.fyear // and t.fexamtype = c.fexamtype // WHERE c.fcntrcode = '{$collcode}' // and t.fdate ='{$doe}' // GROUP BY d.fyear,d.fexamtype,t.fdeggrp"; // $result1 = $aobj_context->mobj_db->GetAll($query); $query = "SELECT distinct CONCAT(d.fyear,'*',d.fexamtype,'-',d.fexamdate)AS `value`, concat(t.fdeggrp,' - ',d.fexamdate) as `label`, concat(t.fdeggrp,' - ',d.fexamdate) as `key` FROM degexam d INNER JOIN candsum c ON d.fdegree = c.fdegree and d.fyear = c.fyear and d.fexamtype = c.fexamtype INNER JOIN subject s on s.fdegree = c.fdegree INNER JOIN timetable t on s.fqpcode = t.fqpcode and t.fyear = c.fyear and t.fexamtype = c.fexamtype WHERE c.fcntrcode = '{$collcode}' and t.fdate ='{$doe}' GROUP BY d.fyear,d.fexamtype,t.fdeggrp"; $result1 = $aobj_context->mobj_db->GetAll($query); if($funivcode == '012' || $funivcode == '052') { $query3 = "select distinct FREASONCD as id,concat(r.FDESCPN,' (',r.FREASONCD,')') as value from reason r order by r.FREASONCD"; }else { $cnd = "inner join colldeg cd on s.fdegree = cd.fdegree and ifnull(cd.fdeleted,'') <> 'T' where cd.fcollcode = '{$collcode}'"; if($funivcode == '042') { $cnd = ""; } $query3 = "SELECT DISTINCT s.fsession AS `key`,s.fsession AS `value`,CONCAT(s.fsession, ' - ',r.FDESCPN) AS `label` from subject s inner join reason r on s.fsession = r.FREASONCD {$cnd} order by s.fsession"; } $rst3 =$aobj_context->mobj_db->getAll($query3); $rst['room'] = $rst1; $rst['deggrp'] = $rst2; $rst['session'] = $rst3; $rst['exmmonth'] = $result1; echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); } // function getRoomAllotmentdetails($aobj_context){ // session_start(); // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $collcode = $aobj_context->mobj_data['collcode']; // $funivcode = $aobj_context->mobj_data['univcode']; // $query = "select froomno as `key`,froomno as `value`, concat(froomname,' - ',fcapacity) as `label` from masroom // where ifnull(fdeleted,'') <>'T' and fcapacity > 0 // and fcollcode = '{$collcode}' order by froomno "; // $rst1 = $aobj_context->mobj_db->getAll($query); // $query1 = "SELECT DISTINCT dg.fdeggrp as `key`,dg.fdeggrp as `value`, CONCAT(dg.fdeggrp,' - ',dg.fdescpn) as `label` // FROM deggrp dg // INNER JOIN degree d ON d.fdeggrp = dg.fdeggrp and d.fexamno ='A' // INNER JOIN colldeg c ON c.fdegree = d.fdegree and ifnull(c.fdeleted,'') <> 'T' // WHERE c.fcollcode='{$collcode}'"; // $rst2 = $aobj_context->mobj_db->getAll($query1); // if($funivcode == '012' || $funivcode == '052') // { // $query3 = "select distinct FREASONCD as id,concat(r.FDESCPN,' (',r.FREASONCD,')') as value // from reason r // order by r.FREASONCD"; // }else // { // $cnd = "inner join colldeg cd on s.fdegree = cd.fdegree and ifnull(cd.fdeleted,'') <> 'T' // where cd.fcollcode = '{$collcode}'"; // if($funivcode == '042'){ // $cnd = ""; // } // $query3 = "SELECT DISTINCT s.fsession AS `key`,s.fsession AS `value`,CONCAT(s.fsession, ' - ',r.FDESCPN) AS `label` // from subject s inner join reason r on s.fsession = r.FREASONCD // {$cnd} // 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"); // } function getAllotedRoomToView($aobj_context){ session_start(); ini_set('memory_limit','900M'); ini_set('max_execution_time',0); $collcode=$aobj_context->mobj_data['collcode']; $funivcode=$aobj_context->mobj_data['univcode']; $frm = ($aobj_context->mobj_data["dates"]); $session = ($aobj_context->mobj_data["session"]); $ra_from = ($aobj_context->mobj_data["ra_from"]); $ra_to = ($aobj_context->mobj_data["ra_to"]); $deggrp = ($aobj_context->mobj_data["deg"]); $romm = ($aobj_context->mobj_data["room"]); $date=date_create($frm); $frm_date=date_format($date,"d/m/Y"); $roomarray = []; $roomalt = explode(",", $romm); foreach($roomalt as $key => $val){ if($val == 'All'){ $data = "ALL"; }else{ $roomarr .= "'".$val."',"; } } $roomarray = substr_replace($roomarr ,"",-1); if($data == 'ALL'){ $value = 'All'; }else{ $value = $roomarray; } if($value == 'All'){ $cond=""; }else{ $cond="and froomno in ($value)"; } if($session== 'select') { $sectionvalue = ""; } else { $sectionvalue = "and s.fsession like '{$session}%'"; } $hall_no = '0'; //$query = "select distinct fqpcode from subject where fdoe = '2016-11-21' "; //$$canddettmp = "tmp$canddet{$this->degree_code}{$this->college_code}"; if($_SESSION['fexamseparate'] == 'T') { $candsum = "examcandsum"; $canddet = "examcanddet"; }else { $candsum = "candsum"; $canddet = "canddet"; } /*$query = "CREATE TEMPORARY TABLE IF NOT EXISTS {$$canddettmp} AS select * from $canddet where fcollcode = '{$this->college_code}' and fdegree = '{$this->degree_code}'"; $this->aobj_context->mobj_db->execute($query);*/ /*$query = "CREATE TEMPORARY TABLE IF NOT EXISTS {$$candsumttmp} AS select * from $candsum where FCNTRCODE = '{$this->collcode}'"; $this->aobj_context->mobj_db->execute($query); */ $query = "select * from collexam where fcollcode = '{$collcode}' and DATE_FORMAT(NOW(),'%Y-%m-%d') BETWEEN DATE_FORMAT(frafrom,'%Y-%m-%d') AND DATE_FORMAT(frato,'%Y-%m-%d')"; $student_exam_details = $aobj_context->mobj_db->GetRow($query); if(count($student_exam_details) > 0) { }else { $arr = "Room Allotment Not Enabled"; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } $mpcnd = "and ifnull(ab.fabstype,'') <> 'QpM'"; if($funivcode == '027' || $funivcode == '003' || $funivcode == '023' || $funivcode == '041' || $funivcode == '035' || $funivcode == '050' || $funivcode == '051' || $funivcode == '052') $mpcnd = ""; if($funivcode == '050') $orderby = "ORDER BY s.FQPCODE,s.fsession"; else $orderby = "ORDER BY reg_cnt DESC,s.fsession,s.FQPCODE"; $query = "SELECT COUNT(DISTINCT cd.FREGNO) AS reg_cnt, s.FQPCODE,concat(s.fsubname,' - ',s.fssubname) as FQPCODE1,s.FDOE, r.FDESCPN, 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 degree d on cd.fdegree = d.fdegree and cd.fexamno = d.fexamno INNER JOIN $candsum cs ON cs.FREGNO=cd.FREGNO LEFT JOIN reason r ON s.FSESSION = r.FREASONCD left outer join attshort a on a.fdegree = cd.fdegree and cd.fexamno = a.fexamno and a.fregno = cd.fregno and a.fsubcode = s.fcsubcode and a.fyear = cd.fyear and a.fexamtype = cd.fexamtype left join absent ab on ab.fregno = cd.fregno and ab.fqpcode = s.fqpcode WHERE 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 cs.fcntrcode = '{$collcode}' and ifnull(a.fregno,'') = '' and ifnull(s.fqpcode,'') <> '' {$mpcnd} and ifnull(cd.FTHPR,'') <> 'T' and ifnull(s.fparentsub,'') <> 'T' and INSTR(cs.fhtenable,cd.fexamno) >0 and d.fdeggrp = 'UG' GROUP BY d.fdeggrp,s.FQPCODE {$orderby}"; $results = $aobj_context->mobj_db->GetAll($query); // var_dump($results); // if($this->funivcode == '050') // { // var_dump($query); // die(); // } $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 degree d on cd.fdegree = d.fdegree and cd.fexamno = d.fexamno INNER JOIN {$candsum} cs ON cd.fcollcode = cs.fcollcode and cs.FREGNO=cd.FREGNO LEFT JOIN reason r ON s.FSESSION = r.FREASONCD left outer join attshort a on a.fdegree = cd.fdegree and cd.fexamno = a.fexamno and a.fregno = cd.fregno and a.fsubcode = s.fcsubcode and a.fyear = cd.fyear and a.fexamtype = cd.fexamtype left join absent ab on ab.fregno = cd.fregno and ab.fqpcode = s.fqpcode WHERE 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 cs.fcntrcode = '{$collcode}' and ifnull(a.fregno,'') = '' $mpcnd and INSTR(cs.fhtenable,cd.fexamno) >0 and d.fdeggrp = 'UG' GROUP BY s.fdoe order by d.fdeggrp"; // var_dump($query1);die(); $results1 = $aobj_context->mobj_db->GetRow($query1); $reg_cnt = $results1['reg_cnt']; $query1 = "select sum(fcapacity) as fcapacity from masroom where fcollcode = '{$collcode}' $cond"; $results1 = $aobj_context->mobj_db->GetRow($query1); $fcapacity = $results1['fcapacity']; $cpacity = 0; $studcount = 0; $alloted = 0; $remaing = 0; $query2 ="SELECT GROUP_CONCAT(froomno,'->',froomname,'->',fcapacity) as roomname FROM masroom WHERE fcollcode = '{$collcode}' $cond group by froomno order by froomno"; $rst2 = $aobj_context->mobj_db->GetAll($query2); $rst['subject'] = $results; $rst['reg_cnt'] = $reg_cnt; $rst['capacity'] = $fcapacity; $rst['roomdet']=$rst2; echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); } function SaveRoomAllotmentDatewise($aobj_context){ session_start(); $data = $aobj_context->mobj_data["data"]; $hall_arr = json_decode($data,true); $collcode=$aobj_context->mobj_data['collcode']; $funivcode=$aobj_context->mobj_data['univcode']; $frm_date = $aobj_context->mobj_data["dates"]; $session = $aobj_context->mobj_data["session"]; $ra_from = $aobj_context->mobj_data["ra_from"]; $ra_to = $aobj_context->mobj_data["ra_to"]; $alternative = $aobj_context->mobj_data["alternative"]; $deggrp = $aobj_context->mobj_data["deggrp"]; $romm = $aobj_context->mobj_data["romm"]; $exmmonth = $aobj_context->mobj_data["exammonth"]; $fusertype=$aobj_context->mobj_data["fusertype"]; $fuser=$aobj_context->mobj_data["user"]; $exmmonthy = explode('-',$exmmonth); $yearmode=explode('*',$exmmonthy[0]); $year = $yearmode[0]; $examtype = $yearmode[1]; if($_SESSION['fexamseparate'] == 'T') { $candsum = "examcandsum"; $canddet = "examcanddet"; }else { $candsum = "candsum"; $canddet = "canddet"; } $roomarray = []; $roomalt = explode(",", $romm); foreach($roomalt as $key => $val){ if($val == 'All'){ $data = "ALL"; }else{ $roomarr .= "'".$val."',"; } } $roomarray = substr_replace($roomarr ,"",-1); if($data == 'ALL'){ $value = 'All'; }else{ $value = $roomarray; } if($value == 'All'){ $cond=""; }else{ $cond="and froomno in ($value)"; } if($session== 'both') { $sectionvalue = ""; } else { if($funivcode == '049'){ $sectionvalue = "and t.fsessiont like '{$session}'"; }else if($funivcode == '098'){ $sectionvalue = "and t.fsession like '{$session}%'"; }else{ $sectionvalue = "and t.fsessiont like '{$session}%'"; } } $hall_no = '0'; $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.fcollcode = cs.fcollcode and cd.FDEGREE=cs.FDEGREE and cs.FREGNO=cd.FREGNO and cd.fcollcode = cs.fcollcode inner join degree dd on cd.fdegree=dd.fdegree and dd.fexamno=cd.fexamno inner join timetable t on s.fqpcode = t.fqpcode and t.fyear = cd.fyear and t.fexamtype = cd.fexamtype WHERE t.fdate ='{$frm_date}' AND IFNULL(cd.fpassmth,'') = '' AND cd.fyear = '{$year}' and cd.fexamtype = '{$examtype}' AND cd.FPRESENT='P' {$sectionvalue} AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' and cs.fcntrcode = '{$collcode}' and cs.fdegree in(select distinct fdegree from degree where fdeggrp = '{$deggrp}') GROUP BY t.fdate"; $results1 = $aobj_context->mobj_db->GetRow($query1); $reg_cnt = $results1['reg_cnt']; $query1 = "select sum(fcapacity) as fcapacity from masroom where fcollcode = '{$collcode}' $cond"; $results1 = $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 $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); return; } $query = "update $canddet cd, subject s, timetable t set cd.fqpcode1 = t.fqpcode, FHALLNO = NULL,fslno = NULL where cd.fdegree = s.fdegree and cd.fexamno = s.fexamno and ifnull(cd.fpassmth,'') = '' and cd.fpresent = 'P' and s.fqpcode = t.fqpcode and cd.fyear = t.fyear and cd.fexamtype = t.fexamtype and cd.fregno in (select fregno from $candsum where fcntrcode = '{$collcode}') and cd.fsubcode = s.fsubcode {$sectionvalue} and cd.fdegree in(select distinct fdegree from degree where fdeggrp = '{$deggrp}') AND cd.fyear = '{$year}' and cd.fexamtype = '{$examtype}' and t.fdate = '{$frm_date}'"; $rst1 = $aobj_context->mobj_db->Execute($query); $rows_affected = $aobj_context->mobj_db->affected_rows(); $query = "update masroom set fbalroomcnt = fcapacity where fcollcode = '{$collcode}' $cond"; $rst1 = $aobj_context->mobj_db->Execute($query); $cnd = "and ifnull(ab.fabstype,'') <> 'QpM'"; if($funivcode == '049' || $funivcode == '052' || $funivcode == '021' || $funivcode == '055') $cnd = ""; $query = "SELECT COUNT(DISTINCT cd.FREGNO) AS reg_cnt,s.FQPCODE,t.fdate AS 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 and cd.fqpcode1 = s.fqpcode INNER JOIN $candsum cs ON cs.FREGNO = cd.FREGNO AND cd.FDEGREE=cs.FDEGREE inner join timetable t on s.fqpcode = t.fqpcode and t.fyear = cd.fyear and t.fexamtype = cd.fexamtype left join absent ab on ab.fregno = cd.fregno WHERE t.fdate ='{$frm_date}' AND IFNULL(cd.fpassmth,'') = '' AND cd.FPRESENT='P' {$sectionvalue} AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' and cs.fcntrcode = '{$collcode}' AND cd.fyear = '{$year}' and cd.fexamtype = '{$examtype}' {$cnd} and ifnull(s.fqpcode,'') <> '' and cs.fdegree in(select distinct fdegree from degree where fdeggrp = '{$deggrp}') GROUP BY s.FQPCODE ORDER BY reg_cnt DESC,s.fsession,s.FQPCODE"; $results = $aobj_context->mobj_db->GetAll($query); $k = 1; foreach($results as $ak=>$value) { $reg_cnt = $value['reg_cnt']; $qpcode = $value['FQPCODE']; $query2 ="SELECT * FROM masroom WHERE fcollcode = '{$collcode}' $cond and fcapacity > 0 order by froomno"; $restults = $aobj_context->mobj_db->GetAll($query2); foreach($restults as $key => $value) { if($value['fbalroomcnt'] <= 0) continue; if($value['fmaxqpcnt'] == 0) { $value['fmaxqpcnt'] = 1; } $capacity = $value['fcapacity']; $studperqp = round($value['fcapacity'] / $value['fmaxqpcnt']); $balroomcnt = $value['fcapacity'] - $studperqp; if($reg_cnt < $studperqp) $studperqp = $reg_cnt; if($value['fbalroomcnt'] <= $studperqp) $studperqp = $value['fbalroomcnt']; if($funivcode == '055') $regorder = "ifnull(cd.fsorder,'01'),cd.fdegree,cd.fregno"; else $regorder = "cd.fregno"; if($funivcode == '049') { if($session == 'N1' || $session == 'N2') $regorder = "cd.fdegree,cd.fregno"; else $regorder = "cd.fregno"; } $query1 = "SET SESSION group_concat_max_len=10000000"; $res9 = $aobj_context->mobj_db->Execute($query1); $query = "select group_concat(distinct concat(\"'\",cd.FREGNO,\"'\") order by $regorder) as fregno from $canddet cd inner join $candsum cs on cd.fregno = cs.fregno inner join subject s ON s.fdegree = cd.fdegree AND s.fexamno = cd.fexamno AND s.FSUBCODE=cd.FSUBCODE and s.fqpcode = cd.fqpcode1 inner join timetable t on s.fqpcode = t.fqpcode and t.fyear = cd.fyear and t.fexamtype = cd.fexamtype left join absent ab on ab.fregno = cd.fregno where cd.fqpcode1 = '{$qpcode}' and cd.FPRESENT = 'P' and ifnull(cd.fpassmth,'') = '' and ifnull(cd.FHALLNO,'') = '' AND cd.fyear = '{$year}' and cd.fexamtype = '{$examtype}' {$cnd} and cs.fcntrcode = '{$collcode}' order by {$regorder} limit {$studperqp}"; //var_dump($query); $rst3 = $aobj_context->mobj_db->GetRow($query); $regarr = explode(',',$rst3['fregno']); $regnoin = array_slice($regarr,0,$studperqp); $regnoin = implode(',',$regnoin); $query = "update $canddet set FHALLNO = '{$value['froomno']}' where fregno in ({$regnoin}) and fqpcode1 = '{$qpcode}' and FPRESENT = 'P' and ifnull(fpassmth,'') = ''"; $rst1 = $aobj_context->mobj_db->Execute($query); $rows_affected = $aobj_context->mobj_db->affected_rows(); if($rows_affected) { $query = "update masroom set fbalroomcnt = ({$value['fbalroomcnt']} - $rows_affected) where froomno = '{$value['froomno']}' and fcollcode = '{$collcode}'"; $rst1 = $aobj_context->mobj_db->Execute($query); $insert = " insert into room_allotment(FCOLLCODE,FQPCODE,FHALLNO,FCAPACITY,FLOGNAME,FLOGDATE,FDOE,FSESSION,FORDER ) values ('{$collcode}','{$qpcode}' ,'{$value['froomno']}','{$rows_affected}','{$log_name}',now(),{date_format(STR_TO_DATE('{$frm_date}', '%d/%m/%Y'),'%Y-%m-%d')},'{$session}','{$k}')"; //$lobj_insert = $this->aobj_context->mobj_db->Execute($insert); $insert = " insert into room_allotment(FCOLLCODE,FQPCODE,FHALLNO,FCAPACITY,FLOGNAME,FLOGDATE,FDOE,FSESSION,FORDER ) values ('{$collcode}','{$hall_arr[$k]['code']}' ,'{$hall_arr[$k]['blockno']}','{$hall_arr[$k]['alloted']}','{$fuser}',now(),'{$frm_date}','{$session}','{$k}') ON DUPLICATE KEY UPDATE FCOLLCODE = '{$collcode}', FQPCODE = '{$hall_arr[$k]['code']}', FHALLNO = '{$hall_arr[$k]['blockno']}', FCAPACITY = '{$hall_arr[$k]['alloted']}', FLOGNAME = '{$fuser}', FLOGDATE = now(), FDOE = '{$frm_date}', FSESSION = '{$session}', FORDER = '{$k}'"; // var_dump($insert);die(); $lobj_insert = $aobj_context->mobj_db->Execute($insert); } else { break; } } $k++; } if($alternative == 'T') { }else { if($funivcode == '033') { $teacharry = []; $query = "select distinct fteachcode from roominvig where fsession = '{$session}' and fdate = date_format(STR_TO_DATE('{$frm_date}', '%d/%m/%Y'),'%Y-%m-%d')"; $res1 = $aobj_context->mobj_db->GetAll($query); foreach($res1 as $val) { array_push($teacharry,$val['fteachcode']); } } $query = "SELECT distinct cd.fhallno FROM $canddet cd INNER JOIN subject s ON s.fdegree = cd.fdegree AND s.fexamno = cd.fexamno AND s.FSUBCODE = cd.FSUBCODE and cd.fqpcode1 = s.fqpcode INNER JOIN $candsum cs ON cs.FREGNO = cd.FREGNO inner join timetable t on s.fqpcode = t.fqpcode and t.fyear = cd.fyear and t.fexamtype = cd.fexamtype WHERE t.fdate = 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 cd.fyear = '{$year}' and cd.fexamtype = '{$examtype}' and cs.fcntrcode = '{$collcode}' and ifnull(s.fqpcode,'') <> '' and cd.fdegree in(select distinct fdegree from degree where fdeggrp = '{$deggrp}') order by cd.fhallno"; //var_dump($query); $results = $aobj_context->mobj_db->GetAll($query); $roomprifxarry = ["A","B","C","D",'E',"F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB", "AC","AD",'AE',"AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW","AX","AY","AZ"]; $x = 0; foreach($results as $value) { $qrypre = "select fprefix,fcapacity from masroom where fcollcode = '{$collcode}' and froomno = '{$value['fhallno']}'"; $resqrypre = $this->aobj_context->mobj_db->GetRow($qrypre); $teacode = $teacharry[$x]; $roomprifix = $resqrypre['fprefix']; $fcapacity = ($resqrypre['fcapacity']/2); $lprix = 3; if($x >25) $lprix =2; if($funivcode == '033' || $funivcode == '052') { $query1 = "SET SESSION group_concat_max_len=10000000"; $res9 = $aobj_context->mobj_db->Execute($query1); $query = "SELECT distinct s.fqpcode,cd.fdegree,cd.fqpcode1,cd.fcollcode,cd.fexamno, count(distinct cd.fregno) as cnt, group_concat(distinct cd.fregno order by {$regorder}) as reg FROM $canddet cd INNER JOIN subject s ON s.fdegree = cd.fdegree AND s.fexamno = cd.fexamno AND s.FSUBCODE = cd.FSUBCODE and cd.fqpcode1 = s.fqpcode INNER JOIN $candsum cs ON cs.FREGNO = cd.FREGNO inner join timetable t on s.fqpcode = t.fqpcode and t.fyear = cd.fyear and t.fexamtype = cd.fexamtype WHERE t.fdate = '{$frm_date}' AND IFNULL(cd.fpassmth,'') = '' AND cd.FPRESENT='P' {$sectionvalue} AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' and cs.fcntrcode = '{$collcode}' AND cd.fyear = '{$year}' and cd.fexamtype = '{$examtype}' and ifnull(s.fqpcode,'') <> '' and cd.fhallno = '{$value['fhallno']}' and cd.fdegree in(select distinct fdegree from degree where fdeggrp = '{$deggrp}') group by fqpcode order by cnt desc,cd.fhallno"; //var_dump($query); $res = $aobj_context->mobj_db->GetAll($query); $a =1; $b =2; $i =1; $r = 1; $y =1; $x = 1; foreach($res as $val) { $fdegree = $val['fdegree']; $fqpcode1 = $val['fqpcode1']; $fexamno = $val['fexamno']; $reg = $val['reg']; $regdet = explode(",",$reg); foreach($regdet as $ereg) { $regno = $ereg; if($funivcode == '052') { if($x <= $fcapacity) { $slno = 'A'.$x; } else { $slno = 'B'.$y; $y++; } $update = "update $canddet set fslno = '{$slno}' where fqpcode1 = '{$fqpcode1}' and fexamno = '{$fexamno}' and fregno = '{$regno}'"; $res1 = $aobj_context->mobj_db->Execute($update); $x++; } else { if(( $i == 1 && $r <= $fcapacity )) $slno = $roomprifix.str_pad($a, $lprix, "0",STR_PAD_LEFT); else $slno = $roomprifix.str_pad($b, $lprix, "0",STR_PAD_LEFT); $update = "update $canddet set fslno = '{$slno}' where fqpcode1 = '{$fqpcode1}' and fexamno = '{$fexamno}' and fregno = '{$regno}'"; $res1 = $aobj_context->mobj_db->Execute($update); if($i==1 && $r <= $fcapacity) $a = $a+2; else $b = $b+2; $r++; } } $i++; } //die(); } else { if($funivcode == '055') { $query = "update $canddet x, (select right(concat('000',@a:=@a+1),3) as fslno, fregno, fqpcode1, fhallno from (select cd.fdegree, cd.fcollcode, cd.fregno,cd.fqpcode1, cd.fhallno from $canddet cd, subject s, $candsum cs where s.fdegree = cd.fdegree AND s.fexamno = cd.fexamno AND s.FSUBCODE = cd.FSUBCODE and cd.fqpcode1 = s.fqpcode and cs.FREGNO = cd.FREGNO AND cd.FDEGREE=cs.FDEGREE and cd.fcollcode = cs.fcollcode 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 cd.fhallno = '{$value['fhallno']}' and cs.fcntrcode = '{$collcode}' and ifnull(s.fqpcode,'') <> '' order by cd.fqpcode1,RAND(),fregno) b, (SELECT @a:= '000') AS a) y set x.fslno = y.fslno where x.fqpcode1 = y.fqpcode1 and x.fhallno = y.fhallno and x.fregno = y.fregno"; }else { $query = "update $canddet x, (select right(concat('000',@a:=@a+1),3) as fslno, fregno, fqpcode1, fhallno from (select cd.fdegree, cd.fcollcode, cd.fregno,cd.fqpcode1, cd.fhallno from $canddet cd, subject s, $candsum cs where s.fdegree = cd.fdegree AND s.fexamno = cd.fexamno AND s.FSUBCODE = cd.FSUBCODE and cd.fqpcode1 = s.fqpcode and cs.FREGNO = cd.FREGNO and cd.fcollcode = cs.fcollcode 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 cd.fhallno = '{$value['fhallno']}' and cs.fcntrcode = '{$collcode}' and ifnull(s.fqpcode,'') <> '' order by cd.fqpcode1,fregno) b, (SELECT @a:= '000') AS a) y set x.fslno = y.fslno where x.fqpcode1 = y.fqpcode1 and x.fhallno = y.fhallno and x.fregno = y.fregno"; } $lobj_insert = $aobj_context->mobj_db->Execute($query); } //$query = ""; //var_dump($query); and cd.fregno in(select distinct fregno from student where fcollcode = '{$this->collcode}' order by fregno) $x++; } $query = "delete from anscapt where fdoe = date_format(STR_TO_DATE('{$frm_date}', '%d/%m/%Y'),'%Y-%m-%d') and fcntrcode = '{$collcode}' and ifnull(fansbookno,'') = ''"; $lobj_update = $aobj_context->mobj_db->Execute($query); $query = "insert ignore into anscapt(fregno, fdegree, fqpcode, fpresent, fyear, fexamtype, fdoe, fsession, fcntrcode, froomno) select a.fregno, a.fdegree, s.fqpcode, a.fpresent, a.fyear, a.fexamtype, s.fdoe, s.fsession, b.fcntrcode, a.fhallno from $canddet a inner join $candsum b on a.fcollcode = b.fcollcode and a.fregno = b.fregno inner join subject s on a.fdegree = s.fdegree and a.fexamno = s.fexamno and a.fsubcode = s.fsubcode and INSTR(b.fhtenable,a.fexamno) >0 where ifnull(b.frecptdate,'') <> '' and ifnull(a.fpresent,'') = 'P' and ifnull(fpassmth,'') = '' and fdoe = date_format(STR_TO_DATE('{$frm_date}', '%d/%m/%Y'),'%Y-%m-%d') and b.fcntrcode = '{$collcode}'"; $lobj_update = $aobj_context->mobj_db->Execute($query); $insert = " insert ignore into room_allotment(FCOLLCODE,FQPCODE,FHALLNO,FCAPACITY,FLOGNAME,FLOGDATE,FDOE,FSESSION ) select b.fcntrcode, s.fqpcode,a.fhallno, '26','-',now(),s.fdoe, s.fsession from $canddet a inner join $candsum b on a.fcollcode = b.fcollcode and a.fregno = b.fregno inner join subject s on a.fdegree = s.fdegree and a.fexamno = s.fexamno and a.fsubcode = s.fsubcode and INSTR(b.fhtenable,a.fexamno) >0 where ifnull(b.frecptdate,'') <> '' and ifnull(a.fpresent,'') = 'P' and ifnull(fpassmth,'') = '' and fdoe = date_format(STR_TO_DATE('{$frm_date}', '%d/%m/%Y'),'%Y-%m-%d') and b.fcntrcode = '{$collcode}'"; $lobj_insert = $aobj_context->mobj_db->Execute($insert); } echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } // $exammonth = $aobj_context->mobj_data["exammonth"]; // $deggrp=$aobj_context->mobj_data['deggrp']; // $session=$aobj_context->mobj_data['session']; // $funivcode=$aobj_context->mobj_data['univcode']; // $collcode=$aobj_context->mobj_data['collcode']; // $dates=$aobj_context->mobj_data['dates']; // $log_name=$aobj_context->mobj_data['user']; // // ini_set('memory_limit','900M'); // // ini_set('max_execution_time',0); // // include_once($this->aobj_context->main_src."/src/json.php"); // // $json = new Services_JSON(); // // $hall_arr = stripslashes($this->aobj_context->mobj_data["hall_arr"]); // // $deggrp = stripslashes($this->aobj_context->mobj_data["faculty"]); // // $mobj_jsondata = $json->decode($hall_arr); // // $hall_arr = get_object_vars($mobj_jsondata); // $i = 0; // $oldqp = ''; // $newqp = ''; // $j = -1; // if($_SESSION['fexamseparate'] == 'T') // { // $candsum = "examcandsum"; // $canddet = "examcanddet"; // }else // { // $candsum = "candsum"; // $canddet = "canddet"; // } // /* // $query = "CREATE TEMPORARY TABLE IF NOT EXISTS {$$canddettmp} AS // select cd.* from $canddet cd inner join $candsum cs on cd.fcollcode = cs.fcollcode // and cd.fdegree = cs.fdegree and cd.fregno = cs.fregno where // cs.FCNTRCODE = '{$this->collcode}'"; // $this->aobj_context->mobj_db->execute($query); // $query = "CREATE TEMPORARY TABLE IF NOT EXISTS {$$candsumttmp} AS // select * from $candsum where FCNTRCODE = '{$this->collcode}'"; // $this->aobj_context->mobj_db->execute($query);*/ // $mpcnd = "and ifnull(ab.fabstype,'') <> 'QpM'"; // if($funivcode == '027' || $funivcode == '003' || $funivcode == '023' || $funivcode == '041' || $funivcode == '035' || $funivcode == '050' || $funivcode == '008' || $funivcode == '052' || $funivcode == '051') // $mpcnd = ""; // if($funivcode == '050') // $orderby = "ORDER BY s.fsession,s.FQPCODE,s.fsession"; // else // $orderby = "ORDER BY reg_cnt DESC,s.fsession,s.FQPCODE"; // for($k=0;$k<=count($hall_arr);$k++) // { // $newqp = $hall_arr[$k]['code']; // if($newqp != $oldqp) // { // // $query = "select distinct fdeggrp from degree d inner join subject s on // // d.fdegree = s.fdegree // // and d.fexamno = s.fexamno where s.fqpcode = '{$hall_arr[$k]->qpcode}'"; // // $results = $this->aobj_context->mobj_db->GetRow($query); // // $deggrp = $results['fdeggrp']; // $i = 0; // if($funivcode == '046') // { // $order = "st.fayear,cd.FREGNO"; // } // else // { // $order = "cd.fregno"; // } // $query1 = "SET SESSION group_concat_max_len=10000000"; // $results = $aobj_context->mobj_db->Execute($query1); // if($deggrp == 'BED' && ($funivcode == '027' || $funivcode == '026')) // { // $query = "SELECT s.fqpcode, group_concat(distinct concat(\"'\",concat(cd.fdegree,cd.fsubcode,cd.FREGNO),\"'\") order by st.fname) 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.FCOLLCODE = cd.FCOLLCODE and cs.fdegree = cd.fdegree and cs.FREGNO=cd.FREGNO // INNER join degree d on cd.fdegree = d.fdegree and cd.fexamno = d.fexamno // inner join student st on cs.fregno = st.fregno and // cs.fdegree = st.fdegree and cs.fcollcode = st.fcollcode // left join attshort a on a.fdegree = cd.fdegree and cd.fexamno = a.fexamno and a.fregno = cd.fregno // and left(a.fsubcode,4) = cd.fsubcode // and a.fyear = cd.fyear // and a.fexamtype = cd.fexamtype // left join absent ab on ab.fregno = cd.fregno // WHERE cs.FCNTRCODE='{$this->collcode}' AND TRIM(s.FQPCODE)='{$hall_arr[$k]['code']}' // AND FPRESENT='P' AND IFNULL(cd.fpassmth,'') = '' // and ifnull(a.fregno,'') = '' and ifnull(cd.FTHPR,'') <> 'T' // and d.fdeggrp = '{$deggrp}' // {$mpcnd} // AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' // group by s.fqpcode"; // //var_dump($query); // }else // { // $query = "SELECT s.fqpcode, group_concat(distinct concat(\"'\",concat(cd.fdegree,cd.fsubcode,cd.FREGNO),\"'\") order by {$order}) 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.FCOLLCODE = cd.FCOLLCODE and cs.FREGNO=cd.FREGNO // inner join student st on cs.fregno = st.fregno and st.fdegree = cs.fdegree // INNER join degree d on cd.fdegree = d.fdegree and cd.fexamno = d.fexamno // left join attshort a on a.fdegree = cd.fdegree and cd.fexamno = a.fexamno and a.fregno = cd.fregno and left(a.fsubcode,4) = cd.fsubcode // and a.fyear = cd.fyear // and a.fexamtype = cd.fexamtype // left join absent ab on ab.fregno = cd.fregno // WHERE cs.FCNTRCODE='{$collcode}' AND TRIM(s.FQPCODE)='{$hall_arr[$k]['code']}' // AND FPRESENT='P' AND IFNULL(cd.fpassmth,'') = '' // and ifnull(a.fregno,'') = '' and ifnull(cd.FTHPR,'') <> 'T' // and INSTR(cs.fhtenable,cd.fexamno) >0 // and d.fdeggrp = '{$deggrp}' // {$mpcnd} // AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' // group by s.fqpcode"; // } // $results = $aobj_context->mobj_db->GetRow($query); // } // if($hall_arr[$j]['remain'] > 0) // { // $hall_arr[$k]['capacity']= $hall_arr[$j]['remain']; // } // /*$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}')"; // $lobj_insert = $this->aobj_context->mobj_db->Execute($insert); // */ // $insert = " insert into room_allotment(FCOLLCODE,FQPCODE,FHALLNO,FCAPACITY,FLOGNAME,FLOGDATE,FDOE,FSESSION,FORDER ) // values ('{$collcode}','{$hall_arr[$k]['code']}' ,'{$hall_arr[$k][blockno]}','{$hall_arr[$k]['capacity']}','{$log_name}',now(),'{$dates}','{$session}','{$k}') // ON DUPLICATE KEY UPDATE // FCOLLCODE = '{$collcode}', // FQPCODE = '{$hall_arr[$k]['code']}', // FHALLNO = '{$hall_arr[$k]['blockno']}', // FCAPACITY = '{$hall_arr[$k]['capacity']}', // FLOGNAME = '{$log_name}', // FLOGDATE = now(), // FDOE = '{$dates}', // FSESSION = '{$session}', // FORDER = '".($k + 1)."'"; // $lobj_insert = $aobj_context->mobj_db->Execute($insert); // $fregno = explode(',',$results['fregno']); // $FSUBCODE = $results['fqpcode']; // //var_dump("i = ".$i."hall_arr[k]->capacity".$hall_arr[$k]->capacity); // $regnoin = array_slice($fregno,$i,$hall_arr[$k]['capacity']); // $regnoin = implode(',',$regnoin); // //var_dump($hall_arr[$k]); // //var_dump($hall_arr[$k]->hallno.'room'.$regnoin); // if($regnoin !='') // { // $update = "update $canddet,$candsum // set $canddet.FHALLNO='{$hall_arr[$k]['blockno']}' // where // $canddet.FCOLLCODE = $candsum.FCOLLCODE // and $canddet.FREGNO = $candsum.FREGNO // and $candsum.FCNTRCODE='{$collcode}' // and INSTR($candsum.fhtenable,$canddet.fexamno) >0 // and concat($canddet.fdegree,$canddet.fsubcode,$canddet.FREGNO) in({$regnoin})"; // $lobj_update = $aobj_context->mobj_db->Execute($update); // } // $i = $i+$hall_arr[$k]['capacity']; // $oldqp = $hall_arr[$k]['code']; // $j++; // } // if($lobj_update) // { // // var_dump($hall_arr); // $query = "delete from anscapt where fdoe = '{$dates}' and fcntrcode = '{$collcode}' // and ifnull(fansbookno,'') = ''"; // $lobj_update = $aobj_context->mobj_db->Execute($query); // $query = "insert into anscapt(fregno, fdegree, fqpcode, fpresent, fyear, fexamtype, fdoe, fsession, fcntrcode, froomno) // select a.fregno, a.fdegree, s.fqpcode, a.fpresent, a.fyear, a.fexamtype, s.fdoe, s.fsession, b.fcntrcode, // a.fhallno from $canddet a inner join $candsum b on a.fcollcode = b.fcollcode // and a.fregno = b.fregno inner join subject s on a.fdegree = s.fdegree and a.fexamno = s.fexamno // and a.fsubcode = s.fsubcode // and INSTR(b.fhtenable,a.fexamno) >0 // where ifnull(b.frecptdate,'') <> '' and ifnull(a.fpresent,'') = 'P' and ifnull(fpassmth,'') = '' // and fdoe = '{$dates}' and b.fcntrcode = '{$collcode}'"; // $lobj_update = $aobj_context->mobj_db->Execute($query); // $data="Update Successfully."; // echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); // } // else // { // $data="Failed"; // echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); // } ?>
Close
