/**
* 系统函数
* @access public
*/
function beforeAction()
{
$c = new Category();
$category_1 = $c->getCategory_1_id();
$this->assign('category_1', $category_1);
$f = new Floor();
$floor_1 = $f->getFloor_1_id();
$this->assign('floor_1', $floor_1);
}
private static function buildDBFloor($dbFloor, $pdo)
{
$floor = Floor::__build($dbFloor['ID'], $dbFloor['NAME']);
$stmt = $pdo->prepare("SELECT * FROM PLACES WHERE FLOOR = :id");
$stmt->bindParam(":id", $dbFloor['ID']);
$stmt->execute();
while ($dbPlace = $stmt->fetch()) {
$place = PlacesService::buildDBPlace($dbPlace);
$floor->addPlace($place);
}
return $floor;
}
public function actionUpdate()
{
$lid = Yii::app()->request->getParam('lid');
$dpid = Yii::app()->request->getParam('companyId');
$model = Floor::model()->find('t.lid=:lid and t.dpid=:dpid', array(':lid' => $lid, ':dpid' => $dpid));
Until::isUpdateValid(array($lid), $this->companyId, $this);
//0,表示企业任何时候都在云端更新。
if (Yii::app()->request->isPostRequest) {
$model->attributes = Yii::app()->request->getPost('Floor');
$model->update_at = date('Y-m-d H:i:s', time());
if ($model->save()) {
Yii::app()->user->setFlash('success', yii::t('app', '修改成功'));
$this->redirect(array('floor/index', 'companyId' => $this->companyId));
}
}
$this->render('update', array('model' => $model));
}
public function actionDeleteall($id)
{
$hostel = Hosteldetails::model()->findByAttributes(array('id' => $id));
$hostel->is_deleted = '1';
$hostel->save();
$floor = Floor::model()->findAllByAttributes(array('hostel_id' => $id));
foreach ($floor as $floor1) {
$room = Room::model()->findAllByAttributes(array('floor' => $floor1->id));
foreach ($room as $room1) {
$allot = Allotment::model()->findAllByAttributes(array('room_no' => $room1->id));
foreach ($allot as $allot1) {
$allot1->delete();
$floor1->delete();
$room1->delete();
}
}
}
$this->redirect(array('manage'));
}
<td width="247" valign="top">
<?php
$this->renderPartial('/settings/hostel_left');
?>
</td>
<td valign="top">
<div class="cont_right">
<h1><?php
echo Yii::t('hostel', 'Allot Room');
?>
</h1>
<div class="formCon" >
<div class="formConInner">
<?php
if (isset($_REQUEST['id']) && isset($_REQUEST['floor_id'])) {
$floordetails = Floor::model()->findByAttributes(array('id' => $_REQUEST['floor_id']));
$room = Room::model()->findAllByAttributes(array('floor' => $_REQUEST['floor_id']));
//$hostel=Hosteldetails::model()->findByAttributes(array('id'=>$floordetails->hostel_id));
?>
<div class="pdtab_Con" style="padding-top:0px;">
<table width="100%" cellpadding="0" cellspacing="0" border="0" >
<tr class="pdtab-h">
<td align="center"><?php
echo Yii::t('hostel', 'Floor');
?>
</td>
<td align="center"><?php
echo Yii::t('hostel', 'Room No');
?>
</td>
echo Yii::t('hostel', 'Room No');
?>
</td>
<td align="center"><?php
echo Yii::t('hostel', 'Availability');
?>
</td>
</tr>
<?php
if ($list == NULL) {
echo '<tr><td align="center" colspan="6"><strong>' . Yii::t('hostel', 'No data available') . '</strong></td></tr>';
} else {
foreach ($list as $list_1) {
$allot = Allotment::model()->findAllByAttributes(array('room_no' => $list_1->room_no));
$room = Room::model()->findByAttributes(array('id' => $list_1->room_no));
$floor = Floor::model()->findByAttributes(array('id' => $room->floor));
$hostel = Hosteldetails::model()->findByAttributes(array('id' => $floor->hostel_id));
?>
<tr>
<td align="center">
<?php
echo $hostel->hostel_name;
?>
<td align="center">
<?php
echo $floor->floor_no;
?>
</td>
<td align="center">
<?php
echo $list_1->room_no . '<br>' . Yii::t('hostel', 'Beds') . ' - ';
function get_floor_3()
{
$floor_2 = get_post_value('floor_2');
$m = new Floor();
$data = $m->getFloor_3($floor_2);
$this->assign('json', $data);
$this->setReturnType('json');
}
private function getFloors()
{
$floors = Floor::model()->findAll('dpid=:companyId and delete_flag=0', array(':companyId' => $this->companyId));
$floors = $floors ? $floors : array();
return CHtml::listData($floors, 'lid', 'name');
}
/**
* Moving to next Floor
* @param $nextFloor
*/
private function _setNextFloor($nextFloor)
{
Log::elevatorMoving($this->_currentDirection, $this->_currentFloor, $nextFloor);
if (Floor::checkFloorStatus($nextFloor) == 'operatinal') {
Log::doorMessage();
}
$this->_currentFloor = $nextFloor;
}
/**
* 返回国家最大序号
* @access public
*/
function get_orders()
{
//查询最大序号
$floor_1 = get_post_value('floor_1');
$m = new Floor();
$m->clear();
$m->setTable('vcb_product_floor_2');
$m->setWhere('status', '!=', '60000');
$m->setWhere('floor_1_id', '=', $floor_1);
$data = $m->getFieldValue('MAX(orders) ');
// 设置新的序号
if (is_null($data)) {
$data = 1;
} else {
$data += 1;
}
$this->assign('message', $data);
$this->setReturnType('message');
//只返回单值
}
echo Yii::t('hostel', 'Room No');
?>
</td>
<td align="center"><?php
echo Yii::t('hostel', 'Bed');
?>
</td>
<td align="center"><?php
echo Yii::t('hostel', 'Action');
?>
</td>
</tr>
<?php
foreach ($list as $list_1) {
$floordetails = Floor::model()->findByAttributes(array('id' => $list_1->floor));
$allot = Allotment::model()->findAll('room_no=:x and status=:y', array(':x' => $list_1->id, ':y' => 'C'));
if ($allot != NULL) {
foreach ($allot as $allot_1) {
?>
<tr>
<td align="center"><?php
echo $floordetails->floor_no;
?>
</td>
<td align="center"><?php
echo $allot_1->room_no;
?>
</td>
<td align="center"><?php
echo $allot_1->bed_no;
public function actionAllot()
{
if (isset($_POST['hostel'])) {
$data = Floor::model()->findAll('hostel_id=:x', array(':x' => $_POST['hostel']));
}
echo CHtml::tag('option', array('value' => 0), CHtml::encode('Select'), true);
$data = CHtml::listData($data, 'id', 'floor_no');
foreach ($data as $value => $title) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($title), true);
}
}
function get_floor_3($id)
{
$m = new Floor();
$data = $m->getFloor_3_byid($id);
return $data;
}
<div class="form">
<?php
$form = $this->beginWidget('CActiveForm', array('id' => 'room-form', 'enableAjaxValidation' => false));
?>
<p class="note">Fields with <span class="required">*</span> are required.</p>
<?php
echo $form->errorSummary($model);
?>
<?php
$floor = Floor::model()->findByAttributes(array('id' => $_REQUEST['id']));
if ($floor != NULL) {
$cnt = $floor->no_of_rooms;
for ($i = 1; $i <= $cnt; $i++) {
?>
<div class="formCon" style="margin-bottom:8px; border:1px #e6e8e9 solid;">
<div class="formConInner">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><?php
echo $form->labelEx($model, Yii::t('hostel', 'Room No'));
?>
</td>
<th> </th>
<td><?php
echo $form->textField($model, 'room_no[]', array('size' => 20));
?>
<?php
} else {
if (isset($_REQUEST['id']) && isset($_REQUEST['bed_no'])) {
$room = RoomDetails::model()->findByAttributes(array('bed_no' => $_REQUEST['bed_no']));
$floor_no = $room->no_of_floors;
$bed_no_1 = $_REQUEST['bed_no'];
}
}
}
?>
<div class="row">
<?php
echo $form->labelEx($model, 'Floor');
?>
<?php
echo CHtml::dropDownList('floor', '', CHtml::listData(Floor::model()->findAll(), 'id', 'floor_no'), array('prompt' => 'Select', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('/room/allot'), 'update' => '#bed', 'data' => 'js:$(this).serialize()')));
?>
</div>
<div class="row">
<?php
echo CHtml::dropDownList('bed_no', '', array(), array('prompt' => 'Select', 'id' => 'bed'));
?>
</div>
<?php
/*?><div class="row">
<?php echo $form->labelEx($model,'Bed no'); ?>
<?php echo $form->textField($model,'bed_no',array('size'=>20,'value'=>$bed_no_1)); ?>
<?php echo $form->error($model,'bed_no'); ?>
</div>
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Floor::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<tr class="pdtab-h">
<td align="center">Room No</td>
<td align="center">Floor</td>
<td align="center">Bed No</td>
<td align="center">Available</td>
</tr>
<?php
foreach ($bedinfo as $bed_info) {
?>
<tr>
<td align="center"><?php
echo $bed_info->room_no;
?>
</td>
<td align="center"><?php
$floor = Floor::model()->findByAttributes(array('id' => $bed_info->no_of_floors));
echo $floor->floor_no;
?>
</td>
<td align="center"><?php
echo $bed_info->bed_no;
?>
</td>
<?php
if ($bed_info->status == 'C') {
echo '<td align="center">Yes</td>';
} else {
echo '<td align="center" >No</td>';
}
?>
</tr>
public function isEqual(Floor $floor)
{
return $this->floorNumber == $floor->getFloorNumber();
}
