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
FormulaEvaluate.php	14.15 KB	-rwxr-xr-x
MarkEntry-Setup.php	24.41 KB	-rwxr-xr-x
MarkEntry-Setup22.php	21.76 KB	-rwxr-xr-x
MarkEntry-SetupTEST.php	21.01 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
absent_entry_setup.php	8.13 KB	-rwxr-xr-x
absent_entry_setupQp.php	6.91 KB	-rwxr-xr-x
absent_entry_setupQpold.php	7.03 KB	-rwxr-xr-x
absententrysubjectwiseQP.js	16.34 KB	-rwxr-xr-x
ack_exam_app_form.php	15.86 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_rv_rt_application.php	8.35 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.02 KB	-rwxr-xr-x
actClass.php	6.21 KB	-rwxr-xr-x
admapprove.php	9.24 KB	-rwxr-xr-x
admission_entry_status.php	2.73 KB	-rwxr-xr-x
admissionapplist.php	9.9 KB	-rwxr-xr-x
ansbookcancel.php	9.49 KB	-rwxr-xr-x
answer_book_issued.php	10.34 KB	-rwxr-xr-x
approve.php	23.86 KB	-rwxr-xr-x
attendance.php	9.7 KB	-rwxr-xr-x
attendance_freez.php	8.45 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.php	2.73 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
bundle_dispatch.php	2.93 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	3.19 KB	-rwxr-xr-x
challan_entries.php	15.41 KB	-rwxr-xr-x
challan_preparation.php	11.69 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
college.php	4.61 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
connect.php	2.11 KB	-rwxr-xr-x
coutput.php	1.75 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	4.95 KB	-rwxr-xr-x
degree.php	6.51 KB	-rwxr-xr-x
display_details_in_grid.php	105.12 KB	-rwxr-xr-x
display_details_in_grid22.php	104.95 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.6 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.59 KB	-rwxr-xr-x
download_misc_files_old.php	4.3 KB	-rwxr-xr-x
download_photo.php	3.54 KB	-rwxr-xr-x
download_photo22.php	6.83 KB	-rwxr-xr-x
download_photo_new.php	4.82 KB	-rwxr-xr-x
download_photo_sikkim.php	4.82 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...	9.74 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
general_report_format.php	11 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	2.97 KB	-rwxr-xr-x
getdata.php	33.59 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
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
index.php	5.06 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	10.94 KB	-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php	3.25 KB	-rwxr-xr-x
login_old.php	3.15 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	71.94 KB	-rwxr-xr-x
mregistry_beforedownload.php	53.04 KB	-rwxr-xr-x
mrn_approval.php	9 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
report_admission_ticket.php	46.77 KB	-rwxr-xr-x
report_iamarks_pending.php	12.04 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	11.84 KB	-rwxr-xr-x
report_setup.php	25.12 KB	-rwxr-xr-x
report_tool.php	73.03 KB	-rwxr-xr-x
result.php	5.06 KB	-rwxr-xr-x
revaluation.php	16.66 KB	-rwxr-xr-x
revaluation_oldtype.php	8.45 KB	-rwxr-xr-x
revaluation_withdegree.php	16.77 KB	-rwxr-xr-x
room_allotment.php	16.41 KB	-rwxr-xr-x
room_allotment_datewise.php	16.47 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.88 KB	-rwxr-xr-x
rvdates.php	6.46 KB	-rwxr-xr-x
sendLoginPassword.php	3.09 KB	-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
student.php	43.89 KB	-rwxr-xr-x
student_entry.php	46.56 KB	-rwxr-xr-x
student_entry24.php	56.54 KB	-rwxr-xr-x
student_entry_24112017.php	42.7 KB	-rwxr-xr-x
student_entryold.php	30.33 KB	-rwxr-xr-x
subjectList_display.php	11.05 KB	-rwxr-xr-x
subject_freshExam.php	18.98 KB	-rwxr-xr-x
subjectfreez.php	13.16 KB	-rwxr-xr-x
subjectwise_freezing_sectionwi...	9.95 KB	-rwxr-xr-x
system_utility.php	1.84 KB	-rwxr-xr-x
systemsetup.php	79.94 KB	-rwxr-xr-x
teachers.php	14.51 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	8.61 KB	-rwxr-xr-x
upload_studentPhoto_before_dow...	8.02 KB	-rwxr-xr-x
uploadmoduledetails.php	39.65 KB	-rwxr-xr-x
uploadzip.php	8.46 KB	-rwxr-xr-x
usersetup.php	25.06 KB	-rwxr-xr-x
usersetupold.php	24.36 KB	-rwxr-xr-x
usersubj_identification.php	4.88 KB	-rwxr-xr-x

Code Editor : room_allotmentold.php

<?php
class room_allotment 
{
    
		function __construct($aobj_context)
		{
			session_start();
			$this->aobj_context=$aobj_context;
			$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
			$this->user_id=$_SESSION['user_id']	;		  
			$this->collcode=$_SESSION['collcode'];	
			$this->log_name = $_SESSION['usr'];			
		}
	 
		function DisplayRoomAllotmentDetatils()
		{
			session_start();
			$this->collcode=$_SESSION['collcode'];
			$qp_code = ($this->aobj_context->mobj_data["qp_code"]);
			$ra_stu_cnt = ($this->aobj_context->mobj_data["ra_stu_cnt"]);
			$ra_from = ($this->aobj_context->mobj_data["ra_from"]);
			$ra_to = ($this->aobj_context->mobj_data["ra_to"]);
			$hall_no = '0';
			$query = "select distinct fqpcode from subject where fdoe = '2016-11-21' ";
			$results = $this->aobj_context->mobj_db->GetAll($query);
			$str_reval.="<br>";
			$str_reval.="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='50%' border='0' cellspacing='0' cellpadding='0'>";
			$str_reval.="<tr class='tr_bg1'>";
			$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Hall No</td>";
			// To display room name 12/11/2016
			$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Hall Name</td>";
			$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left: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=' 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=' 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=' 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.="</tr>";
			$cpacity = 0;
			$studcount = 0;
			$alloted = 0;
			$remaing = 0;
			foreach($results as $ak=>$value)
			{	
				$get_student_cnt ="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 cs.FREGNO=cd.FREGNO AND cd.FDEGREE=cs.FDEGREE
								AND cd.FCOLLCODE=cs.FCOLLCODE
								WHERE cs.FCNTRCODE='{$this->collcode}' and TRIM(FQPCODE)='{$value[fqpcode]}' 
								and ifnull(cd.fpassmth,'') = '' AND cd.FPRESENT='P'  AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00'";
					$lobj_get_student_cnt = $this->aobj_context->mobj_db->GetRow($get_student_cnt);	
					$reg_cnt=$lobj_get_student_cnt['reg_cnt'];
					
					if($reg_cnt > 0)
					{
						$studcount = $reg_cnt;
						//var_dump($value[fqpcode]);
						$query2 ="SELECT froomno,froomname,fcapacity FROM masroom
								  WHERE froomno >= '{$hall_no}'
								  AND froomno <='z' order by froomno asc";	
								// var_dump($query2);
						$rst2 = $this->aobj_context->mobj_db->GetAll($query2);
						
						for($i=0;$i<count($rst2);$i++)
						{
							//$hall_no=str_pad($i, 3, "0", STR_PAD_LEFT);  
							$hall_no = $rst2[$i]['froomno'];
							$froomname = $rst2[$i]['froomname'];
							$capacity = $rst2[$i]['fcapacity'];
							$hallcapacity = $rst2[$i]['fcapacity'];
							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;
								//var_dump($remain);
								$alloted = $studcount;
							}
							if($capacity < $studcount) 
							{	
								$studcount = $studcount - $capacity;
								$alloted = $capacity;
								//$remaing = 0;
							}
							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.="</tr>";
							$sl_no++;
							$k++;
							$pretotal = $total; 
							// To break loop after max count 12/11/2016
							/* if($currcnt <= 0)
							{
								break;
							}	 */
							//var_dump($remaing);
							if($remaing == 0)
								$hall_no++;
							
							if($capacity > $studcount)
								break;
							else
								$remaing =0;
						}
						
					}
					if(($capacity > $studcount) && $remaing == 0)
							break;			
			}
			
			
			/* $query2 ="  SELECT froomno,froomname FROM masroom
			WHERE froomno >= '{$ra_from}'
			AND froomno <='{$ra_to}' order by froomno asc";	
			$rst2 = $this->aobj_context->mobj_db->GetAll($query2);
			
			$get_data="  SELECT FHALLNO,FCAPACITY FROM room_allotment
			WHERE FCOLLCODE='{$this->collcode}'
			AND FQPCODE='{$qp_code}' ";	
			$lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);
			// To display room name 12/11/2016
			$qury="  SELECT froomno, froomname, fcapacity FROM masroom 
			where ifnull(fdeleted,'') <> 'T' order by froomno asc";	
			$rst = $this->aobj_context->mobj_db->GetAll($qury);
			
			foreach($rst as $rmk => $rmv)
			{
				$rmname[$rmv['froomno']] = $rmv['froomname'];
				$rmcapacity[$rmv['froomno']] = $rmv['fcapacity'];
			}	 
			//end 
			$existing_details=array();
			$cnt=1;
			foreach($lobj_get_data as $ak=>$av)
			{					
				$existing_details[$av['FHALLNO']]=$av['FCAPACITY'];
			}
			$str_reval.="<br>";
			$str_reval.="<table style='padding:3px 4px 3px 3px;' class='tr_ventor_row' id='reval_table_data' width='50%' border='0' cellspacing='0' cellpadding='0'>";
			$str_reval.="<tr class='tr_bg1'>";
			$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Hall No</td>";
			// To display room name 12/11/2016
			$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Hall Name</td>";
			$str_reval.="<td align='center' style=' font-size:12px; font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; border-top:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Capacity</td>";
			$str_reval.="</tr>";
	 
			$k=0;
			$sl_no=1;
			$total=0;
			$pretotal = 0;
			for($i=0;$i<count($rst2);$i++)
			{
				//$hall_no=str_pad($i, 3, "0", STR_PAD_LEFT);  
				$hall_no = $rst2[$i]['froomno']; 
				$val=$existing_details[$hall_no];
				$hallname = $rmname[$hall_no];
				// To display room name 12/11/2016
				if(!empty($rmcapacity[$hall_no]) && empty($val))
				{	
					$val = $rmcapacity[$hall_no];				
				}	
				// end
				if(empty($val))
					$val=0;
				$total+= $val;
				
				if($k%2==0)
					$class='tbl_row1';
				else
					$class='tbl_row_alter1';
				
				// To break loop after max count 12/11/2016
				//var_dump($ra_stu_cnt);
				$currcnt = $ra_stu_cnt - $total;
				if($currcnt <= 0)
				{
					$val =  $ra_stu_cnt -($total-$val);
					$total = $pretotal+$val;
				}
				
				$str_reval.="<tr>";		
				$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >{$hall_no}</td>";
				// To display room name 12/11/2016
				$str_reval.="<td class='{$class}' style=' font-size:12px; text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >{$hallname}</td>";
				$str_reval.="<td class='{$class}' align='center' style=' font-size:12px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px; font-weight:bold;text-align:center;' ><input style='width:50px;text-align:right;' onblur='CaclulateRaGrandTotal();' onkeypress='return AcceptNumbersOnly(event);' type='text' value='{$val}' id='ra_input_{$hall_no}' /></td>"; 
				$str_reval.="</tr>";
				$sl_no++;
				$k++;
				$pretotal = $total;*/
				// To break loop after max count 12/11/2016
				/* if($currcnt <= 0)
				{
					break;
				}	 */
			//} 	
			$str_reval.="<tr>";		
				$str_reval.="<td class='{$class}' colspan=2 style=' font-size:12px; font-weight:bold;text-align:center; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' >Total</td>";
			 	$str_reval.="<td class='{$class}' align='center' style=' font-size:12px;font-weight:bold; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;text-align:center;' ><input id='ra_total' style='border:none;width:50px;text-align:right;background:none; font-weight:bold;border:none;' value='{$total}' /> </td>"; 
 
				$str_reval.="</tr>";			
			$str_reval.="</table>";
	 
			$arr['html']=$str_reval;
			echo $this->aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 	
		}
		function SaveRoomAllotment()
		{
			$qp_code = ($this->aobj_context->mobj_data["qp_code"]);
			$ra_stu_cnt = ($this->aobj_context->mobj_data["ra_stu_cnt"]);
			$total_rooms = ($this->aobj_context->mobj_data["total_rooms"]);
			$FSESSION = ($this->aobj_context->mobj_data["FSESSION"]);
			 $FDOE = ($this->aobj_context->mobj_data["FDOE"]);
			include_once($this->aobj_context->main_src."/src/json.php"); 
			$json = new Services_JSON();
			$lstr_param = stripslashes($this->aobj_context->mobj_data["hall_obj"]);
			$mobj_jsondata = $json->decode($lstr_param);
			$obj_arr_data = get_object_vars($mobj_jsondata);
			$del="delete from room_allotment   
						WHERE FCOLLCODE='{$this->collcode}'
						AND FQPCODE='{$qp_code}' ";
			$lobj_del = $this->aobj_context->mobj_db->Execute($del);
			$hall_arr=array();
			$cnt=1;
			foreach($obj_arr_data as $hall=>$capc)
			{
				$insert=" insert into room_allotment( FCOLLCODE,FQPCODE,FHALLNO,FCAPACITY,FLOGNAME,FLOGDATE,FDOE,FSESSION  )
							values (
							'{$this->collcode}','{$qp_code}' ,'{$hall}','{$capc}','{$this->log_name}',now(),'{$FDOE}','{$FSESSION}'
							)";
				$lobj_insert = $this->aobj_context->mobj_db->Execute($insert);	
				$hall_arr[$cnt][$hall]=$capc;
				$cnt++;
			 
			}
			 
		if($lobj_insert)
		{		
		$get_student_cnt ="SELECT cd.FREGNO,cd.FEXAMNO,cd.FDEGREE,cd.FSUBCODE
								FROM canddet cd INNER JOIN subject s ON s.fdegree = cd.fdegree 
								and s.fexamno = cd.fexamno and s.FSUBCODE=cd.FSUBCODE
								inner join candsum cs on cs.FREGNO=cd.FREGNO 
								WHERE cs.FCNTRCODE='{$this->collcode}' and TRIM(FQPCODE)='{$qp_code}' 
								AND FPRESENT='P' and ifnull(cd.fpassmth,'') = '' 
								AND IFNULL(cs.FRECPTDATE,'0000-00-00')<>'0000-00-00' order by cd.FREGNO";//and FPRESENT='P'  and ifnull(FRECPTDATE,'0000-00-00')<>='0000-00-00'
		 $lobj_get_student_cnt = $this->aobj_context->mobj_db->GetAll($get_student_cnt);
		
		 $cand_det_arr=array();
		 $c=1;
		 foreach($lobj_get_student_cnt as $ak=>$av)
		 {
			 $cand_det_arr[$c]['FREGNO']=$av['FREGNO'];
			 $cand_det_arr[$c]['FEXAMNO']=$av['FEXAMNO'];
			 $cand_det_arr[$c]['FDEGREE']=$av['FDEGREE'];
			 $cand_det_arr[$c]['FSUBCODE']=$av['FSUBCODE'];
			 $c++;
		 }
		  
		 $reg_no_arr=array();
		 $tot_nos=0;
		 for($i=1;$i<=count($hall_arr);$i++)
		 {
			$h_arr=$hall_arr[$i];
			foreach($h_arr as $hk=>$hv)
			{
			$hall=$hk;
			$capc=$hv;
			}
			if($i==1)
			{
			$reg_no_arr[$hall]['start']=1;
			$reg_no_arr[$hall]['end']=$capc;
			 $tot_nos+=$capc;
			}
			else
			{
			$reg_no_arr[$hall]['start']=$tot_nos+1;
			$reg_no_arr[$hall]['end']=$tot_nos+$capc;
			 $tot_nos+=$capc;
			}
		 }
		 foreach($reg_no_arr as $hallk =>$hallv)
		 {
			for($z=$hallv[start];$z<=$hallv['end'];$z++)
			{
				$FREGNO=$cand_det_arr[$z]['FREGNO']; 
				$FEXAMNO=$cand_det_arr[$z]['FEXAMNO']; 
				$FDEGREE=$cand_det_arr[$z]['FDEGREE']; 
				$FSUBCODE=$cand_det_arr[$z]['FSUBCODE']; 
				$update =" update canddet,candsum
							set canddet.FHALLNO='{$hallk}'
							where  
							canddet.FCOLLCODE = candsum.FCOLLCODE
							and canddet.FDEGREE = canddet.FDEGREE
							and canddet.FREGNO = candsum.FREGNO
							and candsum.FCNTRCODE='{$this->collcode}'
							and  canddet.FREGNO='{$FREGNO}'
							and  canddet.FEXAMNO='{$FEXAMNO}'
							and  canddet.FDEGREE='{$FDEGREE}'
							and  canddet.FSUBCODE='{$FSUBCODE}'
							";
			 	
				$lobj_update = $this->aobj_context->mobj_db->Execute($update);	
 		
			}
		 }
		  
		 
		$data="Update Successfully.";
		echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 				
		}
		else
		{
			$data="Failed";
				echo $this->aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 		
		}
	}	 
 }
	
function DisplayRoomAllotmentDetatils($aobj_context)
{
    $class_obj=new room_allotment($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->DisplayRoomAllotmentDetatils();
}function SaveRoomAllotment($aobj_context)
{
    $class_obj=new room_allotment($aobj_context);
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	$class_obj->SaveRoomAllotment();
}

function getRoomdetails($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
	
	$query = "select froomno as id, froomname as value from masroom 
			where ifnull(fdeleted,'') <>'T' order by froomno";
	$rst = 	$aobj_context->mobj_db->getAll($query);	//forder,
	
	echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); 
}	
?>

${this.title}

Code Editor : room_allotmentold.php