public function actionMultipleGrid()
{
/**
* Reservations
*/
$reservationsQuery = Reservation::find();
$reservationsSearchModel = new ReservationSearch();
if (isset($_GET['ReservationSearch'])) {
$reservationsSearchModel->load(Yii::$app->request->get());
$reservationsQuery->joinWith(['customer']);
$reservationsQuery->andFilterWhere(['LIKE', 'customer.name', $reservationsSearchModel->getAttribute('customer.name')]);
$reservationsQuery->andFilterWhere(['LIKE', 'customer.surname', $reservationsSearchModel->getAttribute('customer.surname')]);
$reservationsQuery->andFilterWhere(['id' => $reservationsSearchModel->id, 'customer_id' => $reservationsSearchModel->customer_id, 'room_id' => $reservationsSearchModel->room_id, 'price_per_day' => $reservationsSearchModel->price_per_day]);
}
$resultQueryAveragePricePerDay = $reservationsQuery->average('price_per_day');
$dataProvider = new ActiveDataProvider(['query' => $reservationsQuery, 'sort' => ['sortParam' => 'reservations-sort-param'], 'pagination' => ['pageSize' => 10, 'pageParam' => 'reseravations-page-param']]);
$reservationsDataProvider = new ActiveDataProvider(['query' => $reservationsQuery, 'sort' => ['sortParam' => 'reservations-sort-param'], 'pagination' => ['pageSize' => 10, 'pageParam' => 'reservations-page-param']]);
/**
* Rooms
*/
$roomsQuery = Room::find();
$roomsSearchModel = new Room();
if (isset($_GET['Room'])) {
$roomsSearchModel->load(Yii::$app->request->get());
$roomsQuery->andFilterWhere(['id' => $roomsSearchModel->id, 'floor' => $roomsSearchModel->floor, 'room_number' => $roomsSearchModel->room_number, 'has_conditioner' => $roomsSearchModel->has_conditioner, 'has_phone' => $roomsSearchModel->has_phone, 'has_tv' => $roomsSearchModel->has_tv, 'available_from' => $roomsSearchModel->available_from]);
}
$roomsDataProvider = new ActiveDataProvider(['query' => $roomsQuery, 'sort' => ['sortParam' => 'rooms-sort-param'], 'pagination' => ['pageSize' => 10, 'pageParam' => 'rooms-page-param']]);
return $this->render('multipleGrid', ['reservationsDataProvider' => $reservationsDataProvider, 'reservationsSearchModel' => $reservationsSearchModel, 'roomsDataProvider' => $roomsDataProvider, 'roomsSearchModel' => $roomsSearchModel, 'resultQueryAveragePricePerDay' => $resultQueryAveragePricePerDay]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$room = new Room();
$room->event_id = Event::all()->first()->id;
$room->length = 200;
$room->width = 400;
//need 25 tables of 6 people
$room->save();
}
public function deleteRoom(Request $request)
{
$input = $request->all();
$room = Room::find($input['id']);
$room->delete();
return $this->showRoom();
}
public function create(Request $request)
{
$name = $request->room_name;
$created_at = Carbon::now();
$query = ['name' => $name, 'created_at' => $created_at];
Room::insert($query);
return redirect('home');
}
public function index()
{
$rooms = Room::orderBy('created_at', 'desc')->get();
if (Session::has('message')) {
Session::reflash('message');
}
return view('home.home', compact('rooms'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy(Request $request, $eventId)
{
$room = Room::where('event_id', '=', $eventId)->first();
if (!$room) {
return $this->respondNotFound('Room does not exist');
}
$room->delete();
return $this->respondDeleteSuccess('Room deleted');
}
public function search($params)
{
$query = Room::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'active' => $this->active, 'location_id' => $this->location_id]);
$query->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
public function actionBackupRoomTable()
{
$sql = "CREATE TABLE IF NOT EXISTS room (id int not null, floor int not null, room_number int not null, has_conditioner int not null,has_tv int not null, has_phone int not null, available_from date not null, price_per_day float, description text,fileImage text)";
\Yii::$app->dbSqlite->createCommand($sql)->execute();
$sql = 'DELETE FROM room';
\Yii::$app->dbSqlite->createCommand($sql)->execute();
$rooms = Room::find()->all();
foreach ($rooms as $room) {
\Yii::$app->dbSqlite->createCommand()->insert('room', $room->attributes)->execute();
}
}
public function actionGrid()
{
$queryReservation = Reservation::find();
$queryRoom = Room::find();
$searchReservation = new ReservationSearch();
$searchRoom = new Room();
if (isset($_GET['ReservationSearch'])) {
$searchReservation->load(Yii::$app->request->get());
$queryReservation->joinWith(['customer']);
$queryReservation->andFilterWhere(['LIKE', 'customer.surname', $searchReservation->getAttribute('customer.surname')]);
$queryReservation->andFilterWhere(['id' => $searchReservation->id, 'room_id' => $searchReservation->room_id, 'customer_id' => $searchReservation->customer_id, 'price_per_day' => $searchReservation->price_per_day]);
}
$avg = $queryReservation->average('price_per_day');
if (isset($_GET['Room'])) {
$searchRoom->load(Yii::$app->request->get());
$queryRoom->andFilterWhere(['id' => $searchRoom->id, 'floor' => $searchRoom->floor, 'room_number' => $searchRoom->room_number, 'has_conditioner' => $searchRoom->has_conditioner, 'has_tv' => $searchRoom->has_tv, 'has_phone' => $searchRoom->has_phone, 'available_from' => $searchRoom->available_from, 'price_per_day' => $searchRoom->price_per_day, 'description' => $searchRoom->description]);
}
$dataReservation = new ActiveDataProvider(['query' => $queryReservation, 'sort' => ['sortParam' => 'reservations_sort_param'], 'pagination' => ['pageSize' => 3, 'pageParam' => 'reservations_page_param']]);
$dataRoom = new ActiveDataProvider(['query' => $queryRoom, 'sort' => ['sortParam' => 'rooms_sort_param'], 'pagination' => ['pageSize' => 3, 'pageParam' => 'rooms_sort_param']]);
return $this->render('grid', ['dataReservation' => $dataReservation, 'dataRoom' => $dataRoom, 'searchReservation' => $searchReservation, 'searchRoom' => $searchRoom, 'averagePrice' => $avg]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// ---------------------------------------------------------------------
// CONFERENCE 2
// ---------------------------------------------------------------------
$conference = Conference::find(2);
$accommodation = ['name' => 'Shangri-La Hotel Vancouver', 'address' => '1128 West Georgia Street', 'city' => 'Vancouver', 'country' => 'Canada'];
$accommodation = new Accommodation($accommodation);
$accommodation->conference()->associate($conference);
$accommodation->save();
$room = ['room_no' => '100', 'guest_count' => 0, 'capacity' => 2];
$room = new Room($room);
$room->accommodation()->associate($accommodation);
$room->save();
$room = ['room_no' => '101', 'guest_count' => 0, 'capacity' => 3];
$room = new Room($room);
$room->accommodation()->associate($accommodation);
$room->save();
$room = ['room_no' => '102', 'guest_count' => 0, 'capacity' => 4];
$room = new Room($room);
$room->accommodation()->associate($accommodation);
$room->save();
$accommodation = ['name' => 'The Fairmont Hotel Vancouver', 'address' => '900 West Georgia Street', 'city' => 'Vancouver', 'country' => 'Canada'];
$accommodation = new Accommodation($accommodation);
$accommodation->conference()->associate($conference);
$accommodation->save();
$room = ['room_no' => '200', 'guest_count' => 0, 'capacity' => 2];
$room = new Room($room);
$room->accommodation()->associate($accommodation);
$room->save();
$room = ['room_no' => '201', 'guest_count' => 0, 'capacity' => 3];
$room = new Room($room);
$room->accommodation()->associate($accommodation);
$room->save();
$room = ['room_no' => '202', 'guest_count' => 0, 'capacity' => 4];
$room = new Room($room);
$room->accommodation()->associate($accommodation);
$room->save();
}
public function testSetRoomScheduleRoom()
{
$roomsched = new RoomSchedule();
$room = new Room();
$room->setRoomName("SCS Lab A");
$room->setBuilding("SCS");
$roomsched->setRoomName($room->getRoomName());
$roomsched->setBuilding($room->getBuilding());
$this->assertEquals("SCS Lab A", $room->getRoomName());
$this->assertEquals("SCS Lab A", $roomsched->getRoomName());
$this->assertEquals($room->getBuilding(), $roomsched->getBuilding());
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Room::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'house_id' => $this->house_id]);
$query->andFilterWhere(['like', 'description', $this->description]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Room::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'floor' => $this->floor, 'room_number' => $this->room_number, 'has_conditioner' => $this->has_conditioner, 'has_tv' => $this->has_tv, 'has_phone' => $this->has_phone, 'available_from' => $this->available_from, 'price_per_day' => $this->price_per_day]);
$query->andFilterWhere(['like', 'description', $this->description]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Room::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['roomid' => $this->roomid, 'created_dt' => $this->created_dt]);
$query->andFilterWhere(['like', 'roomname', $this->roomname])->andFilterWhere(['like', 'roomnum', $this->roomnum])->andFilterWhere(['like', 'capacity', $this->capacity])->andFilterWhere(['like', 'description', $this->description])->andFilterWhere(['like', 'color', $this->color])->andFilterWhere(['like', 'photo', $this->photo])->andFilterWhere(['like', 'status', $this->status]);
return $dataProvider;
}
public function search($input)
{
$query = Room::query();
$columns = Schema::getColumnListing('rooms');
$attributes = array();
foreach ($columns as $attribute) {
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
} else {
$attributes[$attribute] = null;
}
}
return [$query->get(), $attributes];
}
public function findReserveRoomsByRangeAndRoomType($start, $end, $roomType)
{
$dates = Calendar::getInclusiveDates($start, $end, 'Y-m-d');
$rooms = Room::where('room_type_id', $roomType)->get();
$sql = "select rr_id, reserve_code, room_id, status, if(checkin < '{$start}', '{$start}', checkin) as 'calstart', if(checkin < '{$start}', 'extendleft', '') as 'startmodifier', if(checkout > '{$end}', 'extendright', '') as 'endmodifier',(datediff('{$end}', '{$start}') + if(datediff(checkout, '{$end}') < 0, datediff(checkout, '{$end}'), 0) + if(datediff('{$start}', checkin) < 0, datediff('{$start}', checkin), 0)) as 'computedlength' from reserve_rooms where checkin <= '{$end}' and checkout >= '{$start}' and room_id > 0 and room_type_id = {$roomType} order by room_id, checkin";
$rr = DB::select($sql);
$calendar = [];
foreach ($rooms as $room) {
foreach ($dates as $day) {
$calendar[$room->door_name][$day] = $this->getRoomsForDate($rr, $room->room_id, $day);
}
}
ksort($calendar);
return $calendar;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Room::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'room_num' => $this->room_num, 'status' => $this->status, 'id_card' => $this->id_card, 'price' => $this->price]);
$query->andFilterWhere(['like', 'room_type', $this->room_type])->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Room::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['name' => SORT_ASC]]]);
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
/* if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
} */
$query->andFilterWhere(['id' => $this->id, 'available' => $this->available]);
$query->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
public function actionBackupRoomTable()
{
//$sql = 'CREATE TABLE IF NOT EXISTS room (id int not null, floor int not null, room_number int not null, has_conditioner int not null, has_tv int not null, has_phone int not null, available_from int not null, price_per_day float, description text)';
//Yii::$app->dbSqlite->createCommand($sql)->execute();
$sql = 'delete from room';
Yii::$app->dbSqlite->createCommand($sql)->execute();
$models = Room::find()->all();
foreach ($models as $model) {
//Yii::$app->dbSqlite->createCommand()->insert('room', $model->attributes)->execute();
$modelLite = new RoomLite();
$modelLite->id = $model->id;
$modelLite->attributes = $model->attributes;
$modelLite->save(false);
}
$sqliteModels = RoomLite::find()->all();
return $this->render('backupRoomTable', compact('sqliteModels'));
}
/**
* Delete a Guest of a Room.
*
* @param Request $request
* @param int $rid
* @param int $pid
* @return Response
*/
public function destroy(Request $request, $rid, $pid)
{
try {
$room = Room::find($rid);
if (!$room) {
return response()->error(404, 'Room Not Found');
}
$profile = Profile::find($pid);
if (!$profile) {
return response()->error(404, 'Profile Not Found');
}
$room->guests()->detach($profile);
$room->decrement('guest_count');
return response()->success();
} catch (Exception $e) {
return response()->error($e);
}
}
public function editMatkul($id_course)
{
$course = Course::where('seksi', $id_course)->first();
//get all prodi information
$prodis = Prodi::all();
//transform prodi to associative array
$prodi_arr = array();
foreach ($prodis as $prodi) {
$prodi_arr[$prodi->id] = $prodi->prodi;
}
$kode_dosen = $course->Kode_Dosen;
//need to pass filled data to this view (extra parameter)
$room = Room::room_name();
$room_arr = Helpers::toAssociativeArrays($room);
$waktu_kuliah = WaktuKuliah::waktuMap();
$waktu_opts = Helpers::toAssociativeArrays($waktu_kuliah);
return view('lecturers.editcourse')->with('prodi_options', $prodi_arr)->with('Kode_Dosen', $kode_dosen)->with('room_options', $room_arr)->with('course', $course)->with('waktu_options', $waktu_opts);
}
/**
* Bootstrap the application services.
*
* @return void
*/
public function boot()
{
view()->composer('partials.navigation', function ($view) {
if (Auth::guest()) {
//とりあえず
$rooms = Room::take(10)->get();
$friends = User::all();
$view->with(['rooms' => $rooms, 'friends' => $friends]);
} else {
$user_id = Auth::user()->id;
$rooms = User::find($user_id)->room;
$friends_id_lists = User::find($user_id)->friends->lists('friends_id');
$friends = User::whereIn('id', $friends_id_lists)->get();
$friends_request = Friends::where('friends_id', $user_id)->where('friends_request', 1)->get();
//$friends_request = Friends::whereIn('user_id' , $friends_request_lists)->get();
$view->with(['rooms' => $rooms, 'friends' => $friends, 'friends_request' => $friends_request]);
}
});
}
public function actionMultiGrid()
{
$query = Reservation::find();
$searchModel = new ReservationSearch();
if (isset($_GET['ReservationSearch'])) {
$searchModel->load(\Yii::$app->request->get());
$query->joinWith(['customer']);
$query->andFilterWhere(['LIKE', 'customer.surname', $searchModel->getAttribute('customer.surname')]);
$query->andFilterWhere(['id' => $searchModel->id, 'customer_id' => $searchModel->customer_id, 'room_id' => $searchModel->room_id, 'price_per_day' => $searchModel->price_per_day]);
}
$allAvgPc = $query->average('price_per_day');
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 2]]);
$Roomquery = \app\models\Room::find();
$RoomsearchModel = new \app\models\Room();
if (isset($_GET['Room'])) {
$RoomsearchModel->load(\Yii::$app->request->get());
$Roomquery->andFilterWhere(['id' => $RoomsearchModel->id, 'floor' => $RoomsearchModel->floor, 'room_number' => $RoomsearchModel->room_number, 'has_conditioner' => $RoomsearchModel->has_conditioner, 'has_phone' => $RoomsearchModel->has_conditioner, 'has_tv' => $RoomsearchModel->has_conditioner, 'available_from' => $RoomsearchModel->has_conditioner]);
}
$RoomdataProvider = new ActiveDataProvider(['query' => $Roomquery, 'sort' => ['sortParam' => 'rooms-sort'], 'pagination' => ['pageSize' => 2, 'pageParam' => 'rooms-page']]);
return $this->render("multiGrid", ['reservationsDataProvider' => $dataProvider, 'reservationsSearchModel' => $searchModel, 'roomsDataProvider' => $RoomdataProvider, 'roomsSearchModel' => $RoomsearchModel]);
}
public function actionBackupRoomTable()
{
$sql = "DROP TABLE IF EXISTS room";
\Yii::$app->dbSqlite->createCommand($sql)->execute();
$sql = 'CREATE TABLE IF NOT EXISTS room (
id int not null, floor int not null,
room_number int not null,
has_conditioner int not null,
has_tv int not null,
has_phone int not null,
available_from date not null,
price_per_day float,
description text)';
\Yii::$app->dbSqlite->createCommand($sql)->execute();
$models = Room::find()->all();
foreach ($models as $m) {
\Yii::$app->dbSqlite->createCommand()->insert('room', $m->attributes)->execute();
}
$sql = 'SELECT * FROM room';
$sqliteModels = \Yii::$app->dbSqlite->createCommand($sql)->queryAll();
return $this->render('backupRoomTable', ['sqliteModels' => $sqliteModels]);
}
/**
* Creates a new Assignation model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate($room_id = null, $location_id = null)
{
$model = new Assignation();
$model->room_id = Room::find()->where(['name' => Yii::$app->params['defaultRoom']])->one()->id;
if (!empty($room_id)) {
$model->room_id = $room_id;
}
if (!empty($location_id)) {
$model->location_id = $location_id;
$equipment = Equipment::find()->where(['location_id' => $location_id, 'available' => 1])->one();
$model->equipment_id = empty($equipment) ? null : $equipment->id;
if (empty($room_id)) {
$model->room_id = $equipment->location->room_id;
}
}
$this->layout = '/main2';
if ($model->load(Yii::$app->request->post()) && $model->save()) {
return $this->redirect('index');
} else {
return $this->render('create', ['model' => $model]);
}
}
public function searchRequest(Request $request)
{
if ($request->ajax() && !Auth::guest()) {
$target_id = $request->target_id;
switch ($request->mode) {
case 'friends':
$query = ['user_id' => Auth::user()->id, 'friends_id' => $target_id, 'friends_request' => 1, 'created_at' => Carbon::now()];
Friends::insert($query);
$friend = User::find($target_id);
return ['name' => $friend->name, 'image' => $friend->image, 'email' => $friend->email];
break;
case 'room':
$room = Room::find($target_id);
$query = ['room_id' => $room->id, 'user_id' => Auth::user()->id, 'created_at' => Carbon::now()];
DB::table('room_user')->insert($query);
$room_info = '
<li>
<a href="/room/' . $room->id . '">
<div class="navigation__inner--tab-body--list--box">
' . Html::image($room->image, null, ['width' => '50', 'height' => '50', 'class' => 'navigation__inner--tab-body--list--box-image z-depth-1']) . '
<div class="navigation__inner--tab-body--list--box-description">
<ul>
<li>' . $room->name . '</li>
<li>Belong num</li>
</ul>
</div>
</div>
</a>
</li>
<hr>
';
return ['name' => $room->name, 'image' => $room->image, 'email' => 'Created At:' . $room->created_at, 'room' => $room_info];
break;
}
return $request->mode;
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getRoom()
{
return $this->hasOne(Room::className(), ['id' => 'room_id']);
}
//$this->params['breadcrumbs'][] = ['label' => $model->id, 'url' => ['view', 'id' => $model->id]];
$this->params['breadcrumbs'][] = Yii::t('app', 'Todas las asignaciones');
?>
<h1 align="center"><?php
echo 'Todas las Asignaciones', Html::a('Regresar', ['index'], ['class' => 'btn btn-success btn-md', 'style' => 'float:right; margin-left:4px;']), Html::a('', ['assignations'], ['class' => 'btn btn-primary btn-md glyphicon glyphicon-refresh', 'style' => 'float:right;']);
?>
</h1>
<div class="assignation-index">
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<?php
// echo $this->render('_search', ['model' => $searchModel]);
?>
<?php
$locationQuery = Location::find()->joinWith(['room'])->where(['location.active' => 1, 'room.available' => 1]);
if (!empty(Yii::$app->request->queryParams['AssignationSearch']) && !empty(Yii::$app->request->queryParams['AssignationSearch']['room'])) {
$locationQuery->andWhere(['room.id' => Yii::$app->request->queryParams['AssignationSearch']['room']]);
}
?>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'date', ['attribute' => 'client', 'value' => 'client.client_id', 'label' => Yii::t('app', 'Client ID')], ['attribute' => 'room', 'value' => 'room.name', 'label' => Yii::t('app', 'Room ID'), 'filter' => ArrayHelper::map(Room::find()->where(['available' => 1])->all(), 'id', 'name')], ['attribute' => 'location', 'value' => 'location.location', 'label' => Yii::t('app', 'Location ID'), 'filter' => ArrayHelper::map($locationQuery->all(), 'id', 'fullLocation'), 'filterInputOptions' => ['id' => 'search-assignation-location-id', 'class' => 'form-control']], ['attribute' => 'equipment', 'value' => 'equipment.inventory', 'label' => Yii::t('app', 'Inventory')], 'purpose', 'duration', 'start_time', 'end_time']]);
?>
</div>
/**
* Finds the Room model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Room the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Room::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
?>
</h1>
<div class="assignation-index">
<p></p>
<?php
$locationQuery = Location::find()->joinWith(['room'])->where(['location.active' => 1, 'room.available' => 1]);
if (!empty(Yii::$app->request->queryParams['AssignationSearch']) && !empty(Yii::$app->request->queryParams['AssignationSearch']['room'])) {
$locationQuery->andWhere(['room.id' => Yii::$app->request->queryParams['AssignationSearch']['room']]);
}
?>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], ['attribute' => 'room', 'value' => 'room.name', 'label' => Yii::t('app', 'Room ID'), 'filter' => ArrayHelper::map(Room::find()->orderBy('name ASC')->where(['available' => 1])->all(), 'id', 'name'), 'filterInputOptions' => ['id' => 'search-assignation-room-id', 'class' => 'form-control']], ['attribute' => 'location', 'value' => 'location.location', 'label' => Yii::t('app', 'Location ID'), 'filter' => ArrayHelper::map($locationQuery->orderBy('name ASC')->all(), 'id', 'fullLocation'), 'filterInputOptions' => ['id' => 'search-assignation-location-id', 'class' => 'form-control']], ['attribute' => 'client', 'value' => 'client.client_id', 'label' => Yii::t('app', 'Client ID')], ['attribute' => 'full_name', 'value' => 'client.full_name', 'label' => Yii::t('app', 'Full Name')], 'start_time', 'end_time', ['class' => 'yii\\grid\\ActionColumn', 'template' => ' {view} {update} {delete} {extend_time} {terminate} {report}', 'buttons' => ['view' => function ($url, $model) {
return Html::a('<span class="glyphicon glyphicon-eye-open"></span>', $url, ['title' => Yii::t('app', 'View')]);
}, 'update' => function ($url, $model) {
return Html::a('<span class="glyphicon glyphicon-pencil"></span>', $url, ['title' => Yii::t('app', 'Update')]);
}, 'delete' => function ($url, $model) {
return Html::a('<span class="glyphicon glyphicon-trash"></span>', $url, ['title' => Yii::t('app', 'Delete'), 'data-confirm' => '¿Borrar esta asignación?', 'data-method' => 'POST']);
}, 'extend_time' => function ($url, $model, $key) {
return Html::a('<a data-toggle="modal" href="#extendTime" data-model="' . $model->id . '"><span class="glyphicon glyphicon-time"></span></a>', $url);
}, 'terminate' => function ($url, $model, $key) {
return Html::a('<span class="glyphicon glyphicon-pause"></span>', $url, ['title' => Yii::t('app', 'Terminate assignation')]);
}, 'report' => function ($url, $model) {
return Html::a('<span class="glyphicon glyphicon-alert"></span>', $url, ['title' => Yii::t('app', 'report an incident')]);
}], 'urlCreator' => function ($action, $model, $key, $index) {
if ($action === 'view') {
return Url::to(['assignation/view?id=' . $model->id]);
}