/** * 系统函数 * @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(); }