예제 #1
0
 public function actiongetBlock()
 {
     $div = array();
     $result = HostelBlocks::model()->findAll('block_hostel_id = ' . (int) $_REQUEST['HostelRoomMaster']['hostel_hostelinfo_id']);
     $data = CHtml::listData($result, 'block_id', 'block_name');
     $div .= "<option value=''>Select Block</option>";
     foreach ($data as $value => $name) {
         $div .= CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
     }
     echo CJSON::encode(array('div' => $div));
 }
	else{
		$roomAllocation = Yii::app()->db->createCommand()
			->select('*')
			->from('hostel_room_master')
			->where('hostel_hostelinfo_id = '.$hostelid. ' and hostel_block_id = '.$blockid)
			->queryAll();
	}
		
	foreach($roomAllocation as $key=>$data){

		$reg_data = HostelStudentRegistration::model()->findAll(array('condition'=>'hostel_room_id='.$data['hostel_room_master_id']));
		$rowspan=count($reg_data);
		if($blockid)
			echo "<td rowspan=".$rowspan. ">". HostelBlocks::model()->findByPk($blockid)->block_name ."</	td>";			
		else
			echo "<td rowspan=".$rowspan.">".HostelBlocks::model()->findByPk($data['hostel_block_id'])->block_name."</td>";
		echo "<td rowspan=".$rowspan.">". $data['hostel_room_no_or_name'] ."</td>";
		echo "<td rowspan=".$rowspan.">". $data['hostel_room_capacity'] ."</td>";		

		if($reg_data){

		foreach($reg_data as $key=>$val){
			$stud_trans = StudentTransaction::model()->findByPk($val['hostel_student_transaction_id']);	
			echo "<td >". StudentInfo::model()->findByPk($stud_trans->student_transaction_student_id)->student_first_name ."</td>";
			echo "<td >". Branch::model()->findByPk($stud_trans->student_transaction_branch_id)->branch_name ."</td>";
			echo "<td>". AcademicTermPeriod::model()->findByPk($stud_trans->student_academic_term_period_tran_id)->academic_term_period ."</td>";
			echo "<td >". AcademicTerm::model()->findByPk($stud_trans->student_academic_term_name_id)->academic_term_name ."</td>";	
			echo "</tr>";
			}
		}
		else{