Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.84 KB	-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...	5.18 KB	-rwxr-xr-x
DownloadExamAppFormApplication...	5.12 KB	-rwxr-xr-x
ECHblk.php	12.63 KB	-rwxr-xr-x
ECHblk_12112019.php	11 KB	-rwxr-xr-x
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MC_033_S1720418_A_2017_2.pdf	0 B	-rwxr-xr-x
MarkEntry-Setup.php	26.29 KB	-rwxr-xr-x
MarkEntry-Setup22.php	21.76 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 KB	-rwxr-xr-x
PrintApplicationFormPOSTOFFICE...	26.92 KB	-rwxr-xr-x
TAGMAY2013.pdf	331.03 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.37 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.71 KB	-rwxr-xr-x
UpdateCollDet.php	1.67 KB	-rwxr-xr-x
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	7.25 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
absententrysubjectwiseQP.js	16.34 KB	-rwxr-xr-x
ack_adm_application.php	56.15 KB	-rwxr-xr-x
ack_adm_application_05102018.p...	48.96 KB	-rwxr-xr-x
ack_adm_application_15092018.p...	42.38 KB	-rwxr-xr-x
ack_adm_application_22102018.p...	49.24 KB	-rwxr-xr-x
ack_adm_application_BEFOR_PG.p...	50.21 KB	-rwxr-xr-x
ack_admentry_application.php	48.13 KB	-rwxr-xr-x
ack_admentry_application_05102...	31.48 KB	-rwxr-xr-x
ack_admentry_application_10102...	47.65 KB	-rwxr-xr-x
ack_exam_app_form.php	16.6 KB	-rwxr-xr-x
ack_exam_app_form_19112018.php	16.1 KB	-rwxr-xr-x
ack_exam_app_form_bulk.php	12.58 KB	-rwxr-xr-x
ack_exam_app_form_oldformat.ph...	12.53 KB	-rwxr-xr-x
ack_registration.php	7.77 KB	-rwxr-xr-x
ack_report.php	2.27 KB	-rwxr-xr-x
ack_rv_rt_application.php	8.52 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
adm_challan_entries.php	13.83 KB	-rwxr-xr-x
adm_delete_data.php	5.58 KB	-rwxr-xr-x
admapprove.php	10.33 KB	-rwxr-xr-x
admchallanpreparation.php	8.81 KB	-rwxr-xr-x
admission_entry_reg.php	39.89 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	5.06 KB	-rwxr-xr-x
admstuddate.php	6.06 KB	-rwxr-xr-x
admuploadexsheet.php	13.63 KB	-rwxr-xr-x
admuploadexsheet_07082019.php	8.78 KB	-rwxr-xr-x
admuploadexsheet_bkp_bf_rcub.p...	12.1 KB	-rwxr-xr-x
admuploadexsheet_wait.php	8.78 KB	-rwxr-xr-x
ansbookcancel.php	9.49 KB	-rwxr-xr-x
answer_book_issued.php	10.34 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	25.94 KB	-rwxr-xr-x
approve.php	37.59 KB	-rwxr-xr-x
attendance.php	10.23 KB	-rwxr-xr-x
attendance_freez.php	8.45 KB	-rwxr-xr-x
attendance_freez_mth.php	8.24 KB	-rwxr-xr-x
attendance_freez_old.php	8.55 KB	-rwxr-xr-x
attshort.php	6.29 KB	-rwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup.js	2.73 KB	-rwxr-xr-x
backup.php	2.74 KB	-rwxr-xr-x
backup_restore.php	8.14 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
basic_old.css	13.33 KB	-rwxr-xr-x
batch_close.php	4.31 KB	-rwxr-xr-x
board.php	2.71 KB	-rwxr-xr-x
boeselection.php	1.64 KB	-rwxr-xr-x
bundle_dispatch.php	3.09 KB	-rwxr-xr-x
bundlereceive.php	1.08 KB	-rwxr-xr-x
bundlestatus.php	5.3 KB	-rwxr-xr-x
cManualMailer.php	2.54 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate-entry.php	45.51 KB	-rwxr-xr-x
candidate-entry_new.php	42.85 KB	-rwxr-xr-x
candidate-entry_without_iapr_i...	34.88 KB	-rwxr-xr-x
candidate-entrybefore yearexam...	34.55 KB	-rwxr-xr-x
candidate-entrykus.php	33.23 KB	-rwxr-xr-x
candidate-entrynewformat.php	44.16 KB	-rwxr-xr-x
candidate-entryold.php	34.55 KB	-rwxr-xr-x
candidate_list.js	39.62 KB	-rwxr-xr-x
cappcontext.php	2.64 KB	-rwxr-xr-x
cconfig_wait.php	1.12 KB	-rwxr-xr-x
challan_entries.php	15.38 KB	-rwxr-xr-x
challan_preparation.php	11.69 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.15 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
coll_exam_app_form.php	981 B	-rwxr-xr-x
collbankdet.php	1.82 KB	-rwxr-xr-x
colldesp_ack.php	4 KB	-rwxr-xr-x
college.php	5.06 KB	-rwxr-xr-x
college_16012019.php	5.05 KB	-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php	3.5 KB	-rwxr-xr-x
college_approve.php	5.61 KB	-rwxr-xr-x
college_degree_status.php	5.65 KB	-rwxr-xr-x
collfundtransfer.php	2.23 KB	-rwxr-xr-x
connect.php	2.11 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
createAdmission.php	8.63 KB	-rwxr-xr-x
createAdmission_22.php	3.71 KB	-rwxr-xr-x
createAdmission_bkp_bf_rcub.ph...	3.94 KB	-rwxr-xr-x
create_all_grid_files.php	8.57 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	9.94 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.61 KB	-rwxr-xr-x
create_all_popup_files.php	5.93 KB	-rwxr-xr-x
create_all_schema_files.php	4.31 KB	-rwxr-xr-x
create_all_views.php	16.52 KB	-rwxr-xr-x
create_html_files.php	52.03 KB	-rwxr-xr-x
create_html_files_without_tab....	44.49 KB	-rwxr-xr-x
create_module_meta_columns.php	5.16 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
custom_mregistry.php	122 B	-rwxr-xr-x
datadictionary.php	3.96 KB	-rwxr-xr-x
daterange.php	7.36 KB	-rwxr-xr-x
degree.php	6.49 KB	-rwxr-xr-x
degreeGroup.php	2 B	-rwxr-xr-x
degstudymat.php	6.45 KB	-rwxr-xr-x
degstudymatdet.php	6.3 KB	-rwxr-xr-x
display_details_in_grid.php	105.17 KB	-rwxr-xr-x
display_details_in_grid22.php	104.95 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.61 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
display_details_in_gridold.php	102.19 KB	-rwxr-xr-x
doc_verify.php	6.99 KB	-rwxr-xr-x
downloadFeeStatement.php	5.32 KB	-rwxr-xr-x
download_misc_files.php	4.17 KB	-rwxr-xr-x
download_misc_files_old.php	4.3 KB	-rwxr-xr-x
download_photo.php	4.45 KB	-rwxr-xr-x
download_photo22.php	6.83 KB	-rwxr-xr-x
download_photo_bcu_old.php	4.24 KB	-rwxr-xr-x
download_photo_new.php	4.82 KB	-rwxr-xr-x
download_photo_sikkim.php	5.07 KB	-rwxr-xr-x
download_photoold.php	3.58 KB	-rwxr-xr-x
download_upload.php	3.86 KB	-rwxr-xr-x
dynamicmastersdetails.php	117.45 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	119.36 KB	-rwxr-xr-x
entryexitevents.php	3.09 KB	-rwxr-xr-x
execute_query.php	2.5 KB	-rwxr-xr-x
export_import_setup.php	7.62 KB	-rwxr-xr-x
export_import_utility.php	2.67 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.63 KB	-rwxr-xr-x
freeze_module_at_admin_college...	10.07 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.76 KB	-rwxr-xr-x
freeze_module_at_admin_college...	7.81 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.45 KB	-rwxr-xr-x
freezeiaprici.php	9.9 KB	-rwxr-xr-x
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getMessages.php	11.16 KB	-rwxr-xr-x
getMessages_29012019.php	8.18 KB	-rwxr-xr-x
getdata.php	34.54 KB	-rwxr-xr-x
getdata22.php	32.91 KB	-rwxr-xr-x
getdataold.php	28.7 KB	-rwxr-xr-x
getfeeinformation.php	7.03 KB	-rwxr-xr-x
getfeeinformation_bulk.php	7.52 KB	-rwxr-xr-x
getmoduledetails.php	23.59 KB	-rwxr-xr-x
getnumword.php	7.43 KB	-rwxr-xr-x
getreportdetails.php	3.21 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.37 KB	-rwxr-xr-x
getsearchcondition.php	1.3 KB	-rwxr-xr-x
ggridmodel.php	9.27 KB	-rwxr-xr-x
golden_palm_payslip.php	12.48 KB	-rwxr-xr-x
helptext.php	5.38 KB	-rwxr-xr-x
identify_transactions.php	6.4 KB	-rwxr-xr-x
import_marks.php	4.11 KB	-rwxr-xr-x
json.php	33.72 KB	-rwxr-xr-x
krvw.html	1.5 KB	-rwxr-xr-x
lateralentry.php	2.39 KB	-rwxr-xr-x
login.php	16.44 KB	-rwxr-xr-x
login_05112018.php	12.34 KB	-rwxr-xr-x
login_11102018.php	12.31 KB	-rwxr-xr-x
login_19112018.php	12.29 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 KB	-rwxr-xr-x
login_wait.php	16.1 KB	-rwxr-xr-x
mascomb.php	10.02 KB	-rwxr-xr-x
mcverifydet.php	14.26 KB	-rwxr-xr-x
message_board.php	4.7 KB	-rwxr-xr-x
messagetext.php	980 B	-rwxr-xr-x
module_setup.php	2.48 KB	-rwxr-xr-x
mregistry.php	91.17 KB	-rwxr-xr-x
mregistry_18012019.php	83.61 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 KB	-rwxr-xr-x
nobleRegn.php	3.96 KB	-rwxr-xr-x
payment_gateway.php	7.78 KB	-rwxr-xr-x
pclzip.lib.php	192.53 KB	-rwxr-xr-x
photoupload.php	9.28 KB	-rwxr-xr-x
printexamform.php	11.54 KB	-rwxr-xr-x
receive_rv_rt_application.php	8.57 KB	-rwxr-xr-x
remove_exam_ack.php	2.01 KB	-rwxr-xr-x
report_admission_ticket.php	46.77 KB	-rwxr-xr-x
report_bulk_applications.php	19.42 KB	-rwxr-xr-x
report_hall_ticket.php	11.18 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	8.24 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
result.php	5.06 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	7.91 KB	-rwxr-xr-x
room_allotment_datewise.php	15.71 KB	-rwxr-xr-x
room_allotment_datewise_130720...	15.3 KB	-rwxr-xr-x
room_allotment_old.php	16.44 KB	-rwxr-xr-x
room_allotmentnew.php	9.24 KB	-rwxr-xr-x
room_allotmentold.php	15.27 KB	-rwxr-xr-x
roomdeclaration.php	1.81 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sectionwisepermission.php	5.53 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-rwxr-xr-x
sendsmsapi.php	814 B	-rwxr-xr-x
sendusrandpws.php	1002 B	-rwxr-xr-x
serchbygrid.php	822 B	-rwxr-xr-x
servfeehead.php	3.84 KB	-rwxr-xr-x
services.php	3.47 KB	-rwxr-xr-x
sfeehead.php	5.45 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
stuIAMarksPending.php	5.92 KB	-rwxr-xr-x
student.php	56.01 KB	-rwxr-xr-x
student_14062018.php	43.9 KB	-rwxr-xr-x
student_entry.php	60.55 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entry_03092018.php	60.08 KB	-rwxr-xr-x
student_entry_14062018.php	48.28 KB	-rwxr-xr-x
student_entry_24112017.php	42.7 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
studentportal_remove.php	6.18 KB	-rwxr-xr-x
subjectList_display.php	11.05 KB	-rwxr-xr-x
subject_freshExam.php	28.33 KB	-rwxr-xr-x
subjectfreez.php	13.2 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	9.95 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	80.01 KB	-rwxr-xr-x
teachers.php	15.1 KB	-rwxr-xr-x
teachersOLD.php	10.33 KB	-rwxr-xr-x
teachersnew.php	16.83 KB	-rwxr-xr-x
transaction-series.php	4.86 KB	-rwxr-xr-x
updateSection.php	4.79 KB	-rwxr-xr-x
update_defined_flag.php	3.41 KB	-rwxr-xr-x
updateexamcnt.php	2.92 KB	-rwxr-xr-x
upload_studentPhoto.php	10.03 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadzip.php	9.18 KB	-rwxr-xr-x
usersetup.php	25.11 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	4.88 KB	-rwxr-xr-x

Code Editor : room_allotment_datewise_13072019.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"]);
			
			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 cs.FREGNO=cd.FREGNO AND cd.FDEGREE=cs.FDEGREE
					and cd.fcollcode = cs.fcollcode
					inner join degree dd on cd.fdegree=dd.fdegree and dd.fexamno=cd.fexamno 
					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(s.fqpcode,'') <> ''
					GROUP BY s.FQPCODE ORDER BY reg_cnt DESC,s.fsession,s.FQPCODE";
			//var_dump($query);
			$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.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 
					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}' 
					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 >= '0'
					  AND froomno <='z' and fcollcode = '{$this->collcode}'";
			$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 >= '0'
						  AND froomno <='z' AND fcollcode = '{$this->collcode}'
						  group by froomno
						  order by forder,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_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"]);
			
			$mobj_jsondata = $json->decode($hall_arr);
			$hall_arr = get_object_vars($mobj_jsondata);
			//var_dump($hall_arr);
			$i = 0;
			$oldqp = '';
			$newqp = '';
			$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;
					
					$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.FCOLLCODE = cd.FCOLLCODE and cs.fdegree = cd.fdegree 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 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);

}

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.FCOLLCODE = candsum.FCOLLCODE
				and canddet.FDEGREE = candsum.FDEGREE
				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)
		{
			$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 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"); 
}	
?>

${this.title}

Code Editor : room_allotment_datewise_13072019.php