Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
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--

Code Editor : room_allotment_datewise.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->funivcode = $_SESSION['FUNIVCODE'];			
			$this->collcode = $_SESSION['collcode'];	
			$this->log_name = $_SESSION['usr'];	
		}
	 
		function DisplayRoomAllotmentDetatilsDatewise()
		{
			session_start();
			ini_set('memory_limit','900M');
			ini_set('max_execution_time',0);
			$this->collcode=$_SESSION['collcode'];
			$frm_date = ($this->aobj_context->mobj_data["frm_date"]);
			$session = ($this->aobj_context->mobj_data["session"]);
			$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"]);
			$romm = ($this->aobj_context->mobj_data["romm"]);
			
			$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 
			{
				$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 = '{$this->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 = $this->aobj_context->mobj_db->GetRow($query); 
			
			if(count($student_exam_details) > 0)
			{

}else
			{
				$arr = "Room Allotment Not Enabled";
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
				return;
				
			}

$mpcnd = "and ifnull(ab.fabstype,'') <> 'QpM'";
			if($this->funivcode == '027' || $this->funivcode == '003' || $this->funivcode == '023' || $this->funivcode == '041' || $this->funivcode == '035' || $this->funivcode == '050' || $this->funivcode == '051' || $this->funivcode == '052')
				$mpcnd = "";

if($this->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 = '{$this->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 = '{$deggrp}'
					GROUP BY d.fdeggrp,s.FQPCODE 
					{$orderby}";
			
			$results = $this->aobj_context->mobj_db->GetAll($query); 
			// var_dump($query);
			// die();
			// 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 = '{$this->collcode}' 
					and ifnull(a.fregno,'') = ''
					$mpcnd
					and INSTR(cs.fhtenable,cd.fexamno) >0
					and d.fdeggrp = '{$deggrp}'
					GROUP BY s.fdoe
					order by d.fdeggrp";
			
			$results1 = $this->aobj_context->mobj_db->GetRow($query1);
			
			$reg_cnt = $results1['reg_cnt'];

$query1 = "select sum(fcapacity) as fcapacity from masroom where fcollcode = '{$this->collcode}'
			$cond";
			// var_dump($query1);
			// 		  die();
			$results1 = $this->aobj_context->mobj_db->GetRow($query1);
			
			$fcapacity = $results1['fcapacity'];
			
			// if($this->funivcode == '050')
			// {	
			// 	var_dump($fcapacity);
			// 	var_dump($reg_cnt);
			// 	die();
			// }

if($reg_cnt > $fcapacity)
			{
				//$arr = "Insufficient Rooms for the allotment. Total Capacity : ".$fcapacity." Total Strength :".$reg_cnt;
                $arr = "Total Capacity : ".$fcapacity." Total Strength : ".$reg_cnt." Insufficient rooms for the allotment. Please select sufficient rooms";
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
				
			}else
			{
				$str_reval.="<br>";
				$str_reval.="<table class='tr_ventor_row' id='reval_table_data' width='95%' 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;'>Block 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;'>Room / Block 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;'>Block 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:40%; 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;'>Subject 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;'>Total</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;'>Remaining</td>";
				$str_reval.="</tr>";
				
				$cpacity = 0;
				$studcount = 0;
				$alloted = 0;
				$remaing = 0;
				
				$query2 ="SELECT GROUP_CONCAT(froomno,'->',froomname,'->',fcapacity) as roomname FROM masroom
						  WHERE  fcollcode = '{$this->collcode}' $cond
						  group by froomno
						  order by froomno";
						 
				$rst2 = $this->aobj_context->mobj_db->GetAll($query2);
				//
				
				$i=0;
				$k=1;
				foreach($results as $ak=>$value)
				{	
						$reg_cnt = $value['reg_cnt'];
						
						if($reg_cnt > 0)
						{
							$studcount = intval($reg_cnt);
						
							
							while($studcount>0)
							{	
								$arry = explode("->",$rst2[$i]['roomname']);
								
								$hall_no = $arry[0];
								$froomname = $arry[1];
								$capacity = $arry[2];
								$hallcapacity = $arry[2];
								
								if($remaing > 0)
								{
									$capacity = $remaing;
									//var_dump($remaing);
								}
								
								/* $val=$existing_details[$hall_no];
								$hallname = $rmname[$hall_no]; */
								// To display room name 12/11/2016
								
								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';
								
								// To break loop after max count 12/11/2016
								//var_dump($ra_stu_cnt);
								/*  $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;' >{$froomname}</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;' >{$hallcapacity}</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;' >{$value['FQPCODE']}</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;' >{$reg_cnt}</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;' >{$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:50px;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$alloted}' id='ra_input_{$hall_no}' /></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;' >{$studcount}</td>";
								$str_reval.="</tr>"; */ 
								
								$str_reval.="<tr>";		
								$str_reval.="<td class='{$class}' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:0px;' ><input style='border:0px;box-sizing: border-box;text-align:center; width:100%;padding:2px;' 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='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:0px;' ><input style='border:0px;box-sizing: border-box;text-align:left; width:100%;padding:2px;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$froomname}'  disabled id='{$k}_roomname' /> </td>";
								$str_reval.="<td class='{$class}' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:0px;' ><input style='border:0px;box-sizing: border-box;text-align:center; width:100%;padding:2px;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$hallcapacity}'  disabled id='{$k}_capacity' /> </td>";
								$str_reval.="<td class='{$class}' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:0px;' ><input style='border:0px;box-sizing: border-box;text-align:left; width:100%;padding:2px;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$value['FQPCODE']}'   disabled id='{$k}_qpcode' /> </td>";
								$str_reval.="<td class='{$class}' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:0px;' ><input style='border:0px;box-sizing: border-box;text-align:left; width:100%;padding:2px;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$value['FQPCODE1']}'   disabled id='{$k}_subname' /> </td>";
								$str_reval.="<td class='{$class}' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:0px;' ><input style='border:0px;box-sizing: border-box;text-align:center; width:100%;padding:2px;' 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}' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' > </td>";							
								$str_reval.="<td class='{$class}' style='text-align:center; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:0px;'><input style='border:0px;box-sizing: border-box;text-align:center; width:100%;padding:2px;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text'  value='{$alloted}'  disabled id='{$k}_alloted' /></td>"; 
								$str_reval.="<td class='{$class}' style='text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:0px;' ><input style='border:0px;box-sizing: border-box;text-align:center; width:100%;padding:2px;' 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++;
								/* $sl_no++;
								
								$i++;
								$pretotal = $total;  */
							}
						}
						
				}
						
				$str_reval.="</table>";
		 
				$arr['html']=$str_reval;
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
				return;
			}		
		}
		
		function SaveRoomAllotmentDatewise()
		{
			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 = 0;

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);*/

if($this->funivcode == '050')	
				$orderby = "ORDER BY s.fsession,s.FQPCODE,s.fsession";
			else	
				$orderby = "ORDER BY reg_cnt DESC,s.fsession,s.FQPCODE";

for($k=1;$k<=count($hall_arr);$k++)
			{		
		
				$newqp = $hall_arr[$k]->qpcode;
				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($this->funivcode == '046')
					{
						$order = "st.fayear,cd.FREGNO";
					}
					else
					{
						$order = "cd.fregno";
					}

$query1 = "SET SESSION group_concat_max_len=10000000";
					$results = $this->aobj_context->mobj_db->Execute($query1);
					if($deggrp == 'BED' && ($this->funivcode == '027' || $this->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]->qpcode}' 
						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='{$this->collcode}' AND TRIM(s.FQPCODE)='{$hall_arr[$k]->qpcode}' 
						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";
						// var_dump($query);
						// die();
					}
					
					$results = $this->aobj_context->mobj_db->GetRow($query);

}

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}')";
				$lobj_insert = $this->aobj_context->mobj_db->Execute($insert);
				*/
				//var_dump($insert);

$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);
				
				
				$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]->hallno}'
					where
					$canddet.FCOLLCODE = $candsum.FCOLLCODE
					and $canddet.FREGNO = $candsum.FREGNO
					and $candsum.FCNTRCODE='{$this->collcode}'
					and INSTR($candsum.fhtenable,$canddet.fexamno) >0
					and concat($canddet.fdegree,$canddet.fsubcode,$canddet.FREGNO) in({$regnoin})";
					
					$lobj_update = $this->aobj_context->mobj_db->Execute($update);	
				}
				
				$i = $i+$hall_arr[$k]->capacity; 
				$oldqp = $hall_arr[$k]->qpcode;
				$j++;
			}

if($lobj_update)
			{
				// var_dump($hall_arr);
				$query = "delete from anscapt where fdoe = '{$hall_arr[1]->fdoe}' and fcntrcode = '{$this->collcode}'
				and ifnull(fansbookno,'') = ''";
				
				$lobj_update = $this->aobj_context->mobj_db->Execute($query);	
				// var_dump($lobj_update);
				$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 = '{$hall_arr[1]->fdoe}' and b.fcntrcode = '{$this->collcode}'";
				
				$lobj_update = $this->aobj_context->mobj_db->Execute($query);	
				// var_dump($lobj_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 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}' order by froomno ";
	//var_dump($query);die();	
	$rst = 	$aobj_context->mobj_db->getAll($query);	//forder,
	
	echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); 
}	
?>

${this.title}

Code Editor : room_allotment_datewise.php