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')); }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Transportation(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Transportation'])) { $trans = Transportation::model()->findByAttributes(array('student_id' => $_POST['student_id'])); $model->attributes = $_POST['Transportation']; $model->student_id = $_POST['student_id']; if ($trans != NULL and $_POST['student_id']) { $this->redirect(array('error')); } else { if (isset($_POST['student_id']) and $_POST['student_id'] != NULL) { $allot = Allotment::model()->findByAttributes(array('student_id' => $_POST['student_id'])); if ($allot->student_id == $_POST['student_id']) { $this->redirect(array('warning', 'transportation' => $_POST['Transportation'], 'student_id' => $_POST['student_id'])); } } if (isset($_POST['Transportation']['stop_id']) and $_POST['Transportation']['stop_id'] != NULL) { $stop = StopDetails::model()->findByAttributes(array('id' => $_POST['Transportation']['stop_id'])); $route = RouteDetails::model()->findByAttributes(array('id' => $stop->route_id)); $vehicle = VehicleDetails::model()->findByAttributes(array('id' => $route->vehicle_id)); $connection = Yii::app()->db; $sql = "SELECT t2.id FROM transportation AS t2 JOIN stop_details AS t1 WHERE t2.stop_id = t1.id AND t1.route_id= " . $stop->route_id; $command = $connection->createCommand($sql); $stops = $command->queryAll(); } if ($vehicle->maximum_capacity >= count($stops)) { if ($model->save()) { $this->redirect(array('view', 'id' => $model->id)); } } else { Yii::app()->user->setFlash('errorMessage', UserModule::t("No seat available in the vehicle!")); $this->redirect(array('create')); } } } $this->render('create', array('model' => $model)); }
?> </td> <td align="center"><?php echo Yii::t('hostel', 'Bed'); ?> </td> <td align="center"><?php echo Yii::t('hostel', 'Action'); ?> </td> </tr> <?php if ($room != NULL) { foreach ($room as $room_1) { $list = Allotment::model()->findAllByAttributes(array('room_no' => $room_1->id, 'status' => 'C')); foreach ($list as $list_1) { ?> <tr> <td align="center"><?php echo $floordetails->floor_no; ?> </td> <td align="center"><?php echo $list_1->room_no; ?> </td> <td align="center"><?php echo $list_1->bed_no; ?> </td>
?> <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') . ' - '; foreach ($allot as $allot_1) { $data = Allotment::model()->findAllByAttributes(array('room_no' => $allot_1->room_no, 'status' => 'C')); echo $allot_1->bed_no . ' '; } ?> </td> <td align="center"> <?php echo count($data) . '/' . count($allot); ?> </td> <?php /*?><?php if($list_1->status=='C') { echo '<td align="center">Yes</td>'; }
<?php echo $form->errorSummary($model); if (Yii::app()->controller->action->id == 'create') { $bed_no_1 = ''; $floor_no = ''; if (isset($_REQUEST['studentid']) && !isset($_REQUEST['allotid'])) { $bed_no = Allotment::model()->findAll('status=:x ORDER BY id ASC', array(':x' => 'C')); if ($bed_no == NULL) { $bed_no_1 = ''; $floor_no = ''; } else { $bed_no_1 = $bed_no[0]['bed_no']; } } else { if (isset($_REQUEST['studentid']) && isset($_REQUEST['allotid'])) { $room = Allotment::model()->findByAttributes(array('id' => $_REQUEST['allotid'])); $bed_no_1 = $room->bed_no; } } } ?> <div class="formCon" > <div class="formConInner"> <table width="80%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><?php echo $form->labelEx($model, Yii::t('hostel', 'Bed no')); ?> </td> <td> </td> <td><?php
/** * 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 = Allotment::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
/** * Updates a particular model. * If update is successful, the browser will be redirected to the 'view' page. * @param integer $id the ID of the model to be updated */ public function actionUpdate($id) { $model = $this->loadModel($id); $reg = Registration::model()->findByAttributes(array('student_id' => $_REQUEST['studentid'])); $student = Students::model()->findByAttributes(array('id' => $_REQUEST['studentid'])); $model->student_id = $student->first_name . ' ' . $student->last_name; $model->food_preference = $reg->food_preference; // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Registration'])) { $model->attributes = $_POST['Registration']; $model->student_id = $_REQUEST['studentid']; $register = Registration::model()->findByAttributes(array('student_id' => $_REQUEST['studentid'])); if ($register != NULL) { $request = Roomrequest::model()->findByAttributes(array('student_id' => $register->student_id, 'status' => 'C')); if ($request != NULL) { $request->status = 'S'; $request->save(); } $model->status = 'S'; $register->save(); } if ($model->save()) { $bed_info = Allotment::model()->findAll('status=:x AND student_id IS NULL', array(':x' => 'C')); if ($bed_info == NULL) { $this->redirect(array('/hostel/allotment/roominfo/')); } else { $this->redirect(array('/hostel/room/roomlist', 'id' => $model->student_id, 'floor_id' => $_POST['floor'])); } } } $this->render('update', array('model' => $model)); }
$this->breadcrumbs = array('Rooms' => array('/hostel'), 'change'); ?> <div id="parent_Sect"> <?php $this->renderPartial('/settings/studentleft'); ?> <div id="parent_rightSect"> <div class="parentright_innercon"> <h1>Room</h1> <div class="profile_details"> <?php $data = Allotment::model()->findByAttributes(array('student_id' => $_REQUEST['studentid'])); $student = Students::model()->findByAttributes(array('id' => $_REQUEST['studentid'])); echo 'Your request for room change has been submitted'; ?> </div> </div> <div class="clear"></div> </div> <div class="clear"></div> </div>
?> </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 actionRoomvacate() { $model = new Vacate(); if (isset($_POST['search'])) { $criteria = new CDbCriteria(); if (isset($_POST['student_id']) and $_POST['student_id'] != NULL) { $criteria->condition = 'student_id = :match'; $criteria->params = array(':match' => $_POST['student_id']); } $total = Allotment::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(Yii::app()->params['listPerPage']); $pages->applyLimit($criteria); // the trick is here! $posts = Allotment::model()->findAll($criteria); $this->render('roomvacate', array('model' => $model, 'list' => $posts, 'pages' => $pages, 'item_count' => $total, 'page_size' => Yii::app()->params['listPerPage'])); } else { $this->render('roomvacate', array('model' => $model)); } }
<div class="form"> <?php $form = $this->beginWidget('CActiveForm', array('id' => 'vacate-form', 'enableAjaxValidation' => false)); ?> <p class="note">Fields with <span class="required">*</span> are required.</p> <?php echo $form->errorSummary($model); if (Yii::app()->controller->action->id == 'create') { $student_details = Allotment::model()->findByAttributes(array('student_id' => $_REQUEST['id'], 'status' => 'S')); $room = Room::model()->findByAttributes(array('id' => $student_details->room_no)); } ?> <div class="formCon" > <div class="formConInner"> <table width="80%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><?php //echo $form->labelEx($model,'Student'); ?> </td> <td> </td> <td><?php echo $form->hiddenField($model, 'student_id', array('size' => 20, 'value' => $student_details->student_id)); ?> <?php echo $form->error($model, 'student_id'); ?> </td>
public function actionRoomsearch() { $model = new Allotment(); if (isset($_POST['search'])) { $criteria = new CDbCriteria(); $i = 1; if (isset($_POST['student_id']) and $_POST['student_id'] != NULL) { $criteria->condition = 'student_id LIKE :match'; $criteria->params[':match'] = $_POST['student_id']; $i = 0; } //if(isset($_POST['Allotment']['floor']) and $_POST['Allotment']['floor']!=NULL) //{ //$room=Room::model()->findByAttributes(array('floor'=>$_POST['Allotment']['floor'])); //if($i==0) // { // $criteria->condition=$criteria->condition.' and floor LIKE :match1'; // } // else // { /// $criteria->condition='floor LIKE :match1'; // } // $criteria->params[':match1'] = $room->floor.'%'; // $i=0; //} if (isset($_POST['Allotment']['room_no']) and $_POST['Allotment']['room_no'] != NULL) { if ($i == 0) { $criteria->condition = $criteria->condition . ' and room_no LIKE :match2'; } else { $criteria->condition = 'room_no LIKE :match2'; } $criteria->params[':match2'] = $_POST['Allotment']['room_no']; //$criteria->params = array(':match2'=>$_POST['Allotment']['room_no'].'%',':x'=>'S'); } $total = Allotment::model()->count($criteria); $pages = new CPagination($total); $pages->setPageSize(Yii::app()->params['listPerPage']); $pages->applyLimit($criteria); // the trick is here! $posts = Allotment::model()->findAll($criteria); $this->render('roomsearch', array('model' => $model, 'list' => $posts, 'pages' => $pages, 'item_count' => $total, 'page_size' => Yii::app()->params['listPerPage'])); } else { $this->render('roomsearch', array('model' => $model)); } }
?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <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', 'Student Details'); ?> </h1> <?php $allot = Allotment::model()->findByAttributes(array('student_id' => $studentid, 'status' => 'S')); if ($allot != NULL) { $stud = Students::model()->findByAttributes(array('id' => $allot->student_id)); $register = Registration::model()->findByAttributes(array('student_id' => $allot->student_id)); $food = FoodInfo::model()->findByAttributes(array('id' => $register->food_preference)); $mess = MessFee::model()->findByAttributes(array('student_id' => $allot->student_id)); $floor = Floor::model()->findByAttributes(array('id' => $allot->floor)); $hostel = Hosteldetails::model()->findByAttributes(array('id' => $floor->hostel_id)); ?> <div class="pdtab_Con" style="padding:0px;"> <table width="100%" cellpadding="0" cellspacing="0" border="0" > <tr class="pdtab-h"> <td align="center"><?php echo Yii::t('hostel', 'Student Name'); ?> </td>
<div class="y_bx_head" style="width:90%"> <h1><?php echo Yii::t('hostel', 'Notifications'); ?> </h1> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <?php $request = Roomrequest::model()->findAll('status=:x order by created_at DESC limit 1', array(':x' => 'C')); if ($request != NULL) { $i = 1; foreach ($request as $request_1) { echo '<tr>'; $student = Students::model()->findByAttributes(array('id' => $request_1->student_id)); $reg = Registration::model()->findByAttributes(array('student_id' => $request_1->student_id)); if ($request_1->allot_id != NULL) { $allot = Allotment::model()->findByAttributes(array('id' => $request_1->allot_id)); if ($student != NULL) { echo '<td align="center">' . $i . '</td>'; echo '<td align="center"><strong>' . ucfirst($student->last_name . ' ' . $student->first_name) . '</td>'; echo '<td align="center">' . $i . '</td>'; echo '<td align="center">' . $i . '</td>'; echo $i . ' <strong>' . ucfirst($student->first_name . ' ' . $student->last_name) . ' has been requested for changing room to' . ' ' . $allot->room_no . ' ' . $allot->bed_no . ' ' . '</strong>[ ' . CHtml::link(Yii::t('hostel', 'Allot'), array('/hostel/allotment/create', 'studentid' => $request_1->student_id, 'allotid' => $request_1->allot_id)) . ' ]<br>'; $i++; } } else { if ($request_1->allot_id == NULL) { $i = 1; if ($student != NULL) { echo $i . ' <strong>' . ucfirst($student->first_name . ' ' . $student->last_name) . ' has been applied for hostel facility</strong> ' . CHtml::link(Yii::t('hostel', 'Register'), array('/hostel/registration/update', 'studentid' => $request_1->student_id, 'id' => $reg->id)); $i++; }
<tr> <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', 'Student Details'); ?> </h1> <div class="formCon" > <div class="formConInner"> <table width="50%" border="0" cellspacing="0" cellpadding="0"> <tr> <?php echo '<td><strong>' . CHtml::label(Yii::t('hostel', 'Student ID'), '') . '</strong></td><td>'; echo CHtml::dropDownList('studentid', '', CHtml::listData(Allotment::model()->findAll('status=:x', array(':x' => 'S')), 'student_id', 'studentadm'), array('prompt' => 'Select', 'id' => 'student_id', 'submit' => array('MessManage/messdetails'))) . '</td>'; ?> </tr> </table> </div> </div> </div> </td> </tr> </table> <?php $this->endWidget();
public function getCurrentAllottee() { $result = Allotment::model()->findByPk($this->id); if ($this->latest_transfer) { $result->applicant_id = $this->latest_transfer->transfer_to->id; $result->date = $this->latest_transfer->transfer_date; $result->order_no = $this->latest_transfer->deed_no; $result->type = 'transfer'; $result->_transfer_id = $this->latest_transfer->id; } return $result; }