/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store($property_id)
{
//
foreach (Input::get('name') as $index => $value) {
if (!empty($value)) {
$roomType = new RoomType();
$roomType->rooms_available = 0;
$roomType->property_id = $property_id;
$roomType->name = trim($value);
$roomType->save();
}
}
return Redirect::to('property/room/' . $property_id . "/create");
}
/**
* Check available rooms and show the reservation form
*
* @return Response
*/
public function check(Request $request)
{
$this->validate($request, ['min_capacity' => 'required|numeric|min:1|max:4', 'check_in' => 'required|date|after:' . \Carbon\Carbon::today()->addDays(-1)->format('Y-m-d'), 'check_out' => 'required|date|after:' . $request->input('check_in')]);
$request->session()->put('check_in', $request->input('check_in'));
$request->session()->put('check_out', $request->input('check_out'));
$roomTypes = RoomType::with('rooms')->where('capacity', '>=', $request->input('min_capacity'))->get();
return view('reservation.check', compact('roomTypes'));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker::create();
for ($i = 1; $i <= 3; $i++) {
$roomType = new RoomType();
switch ($i) {
case '1':
$roomType->name = "duzy";
break;
case '2':
$roomType->name = "sredni";
break;
case '3':
$roomType->name = "maly";
break;
}
$roomType->save();
}
}
/**
* Define your route model bindings, pattern filters, etc.
*
* @param \Illuminate\Routing\Router $router
* @return void
*/
public function boot(Router $router)
{
$router->bind('facility', function ($slug) {
return \App\Facility::where('slug', $slug)->first();
});
$router->bind('type', function ($slug) {
return \App\RoomType::where('slug', $slug)->first();
});
$router->bind('room', function ($room_no) {
return \App\Room::where('room_no', $room_no)->first();
});
$router->model('reservation', 'App\\Reservation');
parent::boot($router);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$residences = array(["name" => "Foobar Res", "location" => "Integer Drive", "conferenceID" => self::TARGET_CONF], ["name" => "Barbaz Res", "location" => "XYZ Ave", "conferenceID" => self::TARGET_CONF]);
foreach ($residences as $res) {
Residence::create($res);
}
$types = array(["name" => "TypeA", "capacity" => 4, "accessible" => true], ["name" => "TypeB", "capacity" => 4, "accessible" => false], ["name" => "TypeA-R2", "capacity" => 4, "accessible" => true]);
foreach ($types as $ty) {
RoomType::create($ty);
}
$sets = array(["name" => "104A-104D", "residenceID" => 1, "typeID" => 1], ["name" => "204B-204Y", "residenceID" => 1, "typeID" => 2], ["name" => "21-29", "residenceID" => 2, "typeID" => 3]);
foreach ($sets as $set) {
RoomSet::create($set);
}
}
public function searchAvailability(Request $request)
{
$start_dt = Carbon::createFromFormat('d-m-Y', $request['start_dt'])->toDateTimeString();
$end_dt = Carbon::createFromFormat('d-m-Y', $request['end_dt'])->toDateTimeString();
$min_occupancy = $request['min_occupancy'];
$room_types = RoomType::where('max_occupancy', '>=', $min_occupancy)->get();
$available_room_types = [];
foreach ($room_types as $room_type) {
$count = RoomCalendar::where('day', '>=', $start_dt)->where('day', '<', $end_dt)->where('room_type_id', '=', $room_type->id)->where('availability', '<=', 0)->count();
if ($count == 0) {
$total_price = RoomCalendar::where('day', '>=', $start_dt)->where('day', '<', $end_dt)->where('room_type_id', '=', $room_type->id)->sum('rate');
$room_type->total_price = $total_price;
array_push($available_room_types, $room_type);
}
}
return $available_room_types;
}
public function createRoomSet(Request $req, $confId, $residenceId)
{
if (!Entrust::can(PermissionNames::ConferenceRoomEdit($confId))) {
return response("", 403);
}
return DB::transaction(function () use($req, $confId, $residenceId) {
$res = Residence::find($residenceId);
if (is_null($res) || $res->conferenceID != $confId) {
return response("", 404);
}
$responses = [];
foreach ($req->all() as $request) {
$this->validateRoomSet($request);
if (isset($request['typeID'])) {
$type = $request['typeID'];
} else {
$tyVal = new RoomType();
$tyVal->name = $request['type']['name'];
$tyVal->capacity = $request['type']['capacity'];
$tyVal->accessible = $request['type']['accessible'];
$tyVal->save();
$type = $tyVal->id;
}
$set = new RoomSet();
$set->typeID = $type;
$set->residenceID = $residenceId;
$set->name = $request['name'];
$set->save();
$responses[] = ['name' => $set->name, 'id' => $set->id, 'typeID' => $type];
}
Log::info("Created " . sizeof($responses) . " new room sets in residence {$res->name} for conference {$confId}");
return response()->json($responses);
});
}
public function store(Request $request)
{
$room_type = new RoomType($request->all());
$room_type->save();
return $room_type;
}
/**
* Remove the specified resource from storage.
*
* @param App\RoomType $roomType
* @return Response
*/
public function destroy(RoomType $roomType)
{
$roomType->delete();
Storage::delete($roomType['image_path']);
return redirect('/type');
}
/**
* Show the form for editing the specified resource.
*
* @param App\Room $room
* @return Response
*/
public function edit(Room $room)
{
$roomTypes = RoomType::lists('name', 'id')->all();
return view('room.edit', compact('room', 'roomTypes'));
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$roomType = RoomType::find($id);
$roomType->delete();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('room_types')->truncate();
DB::table('rooms')->truncate();
$room_type = new RoomType();
$room_type->name = "Standard Room A";
$room_type->description = "(2-3 persons) w/o balcony";
$room_type->rate = 2800;
$room_type->save();
$room_type = new RoomType();
$room_type->name = "Standard Room A";
$room_type->description = "(2-3 persons) w/ balcony";
$room_type->rate = 3200;
$room_type->save();
$room_type = new RoomType();
$room_type->name = "Standard Room B";
$room_type->description = "(4-5 persons)";
$room_type->rate = 3200;
$room_type->save();
$room_type = new RoomType();
$room_type->name = "Deluxe Room";
$room_type->description = "(4-5 persons)";
$room_type->rate = 3700;
$room_type->save();
$room_type = new RoomType();
$room_type->name = "Family Room A";
$room_type->description = "(6 persons)";
$room_type->rate = 4200;
$room_type->save();
$room_type = new RoomType();
$room_type->name = "Family Room B";
$room_type->description = "(7 persons)";
$room_type->rate = 4800;
$room_type->save();
$room_type = new RoomType();
$room_type->name = "Suite Room";
$room_type->description = "(1-2 persons)";
$room_type->rate = 4000;
$room_type->save();
$room_type = new RoomType();
$room_type->name = "Maharlika Suite";
$room_type->description = "(4-5 persons)";
$room_type->rate = 4500;
$room_type->save();
$room_type = new RoomType();
$room_type->name = "Dorm Type Room";
$room_type->description = "(10 persons)";
$room_type->rate = 6000;
$room_type->save();
$room = new Room();
$room->no = "101";
$room->view = "Pool";
$room->room_type_id = 6;
$room->description = "5 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "102";
$room->view = "Pool";
$room->room_type_id = 6;
$room->description = "5 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "103";
$room->view = "Pool";
$room->room_type_id = 6;
$room->description = "5 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "104";
$room->view = "Pool";
$room->room_type_id = 6;
$room->description = "5 Single Bed, 1 QS Bed";
$room->save();
$room = new Room();
$room->no = "105";
$room->view = "No View";
$room->room_type_id = 4;
$room->description = "3 Single Bed, 1 QS Bed";
$room->save();
$room = new Room();
$room->no = "106";
$room->view = "No View";
$room->room_type_id = 4;
$room->description = "3 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "107";
$room->view = "No View";
$room->room_type_id = 4;
$room->description = "3 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "108";
$room->view = "No View";
$room->room_type_id = 4;
$room->description = "3 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "109";
$room->view = "No View";
$room->room_type_id = 4;
$room->description = "3 Single Bed, 1 QS Bed";
$room->save();
$room = new Room();
$room->no = "110";
$room->view = "No View";
$room->room_type_id = 3;
$room->description = "2 Queen Size Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "111";
$room->view = "No View";
$room->room_type_id = 3;
$room->description = "2 Queen Size Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "112";
$room->view = "No View";
$room->room_type_id = 3;
$room->description = "2 Queen Size Bed";
$room->save();
$room = new Room();
$room->no = "113";
$room->view = "No View";
$room->room_type_id = 3;
$room->description = "2 Queen Size Bed";
$room->save();
$room = new Room();
$room->no = "114";
$room->view = "No View";
$room->room_type_id = 3;
$room->description = "2 Queen Size Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "201";
$room->view = "Balcony";
$room->room_type_id = 2;
$room->description = "2 Queen Size Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "202";
$room->view = "Balcony";
$room->room_type_id = 2;
$room->description = "2 Queen Size Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "203";
$room->view = "Balcony";
$room->room_type_id = 2;
$room->description = "2 Queen Size Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "204";
$room->view = "Balcony";
$room->room_type_id = 2;
$room->description = "2 Queen Size Bed";
$room->save();
$room = new Room();
$room->no = "205";
$room->view = "Balcony";
$room->room_type_id = 1;
$room->description = "2 Queen Size Bed";
$room->save();
$room = new Room();
$room->no = "206";
$room->view = "No View";
$room->room_type_id = 5;
$room->description = "4 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "207";
$room->view = "No View";
$room->room_type_id = 5;
$room->description = "4 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "208";
$room->view = "No View";
$room->room_type_id = 5;
$room->description = "4 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "209";
$room->view = "No View";
$room->room_type_id = 5;
$room->description = "4 Single Bed, 1 QS Bed";
$room->save();
$room = new Room();
$room->no = "210";
$room->view = "No View";
$room->room_type_id = 5;
$room->description = "4 Single Bed, 1 QS Bed";
$room->save();
$room = new Room();
$room->no = "211";
$room->view = "No View";
$room->room_type_id = 3;
$room->description = "1 Single Bed, 1 QS Bed";
$room->save();
$room = new Room();
$room->no = "212";
$room->view = "No View";
$room->room_type_id = 3;
$room->description = "1 Single Bed, 1 QS Bed";
$room->save();
$room = new Room();
$room->no = "213";
$room->view = "No View";
$room->room_type_id = 3;
$room->description = "1 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "301";
$room->view = "No View";
$room->room_type_id = 1;
$room->description = "1 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "302";
$room->view = "No View";
$room->room_type_id = 1;
$room->description = "1 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "303";
$room->view = "No View";
$room->room_type_id = 1;
$room->description = "1 Single Bed, 1 QS Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "304";
$room->view = "No View";
$room->room_type_id = 1;
$room->description = "1 Single Bed, 1 QS Bed";
$room->save();
$room = new Room();
$room->no = "305";
$room->view = "No View";
$room->room_type_id = 1;
$room->description = "1 Single Bed, 1 QS Bed";
$room->save();
$room = new Room();
$room->no = "306";
$room->view = "No View";
$room->room_type_id = 7;
$room->description = "3 Single Bed";
$room->save();
$room = new Room();
$room->no = "308";
$room->view = "No View";
$room->room_type_id = 7;
$room->description = "1 Queen Size Bed";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "401";
$room->view = "No View";
$room->room_type_id = 8;
$room->description = "2 Queen Size Bed";
$room->save();
$room = new Room();
$room->no = "Dorm A";
$room->view = "Parking";
$room->room_type_id = 9;
$room->description = "5 Double Decks";
$room->type = "available_online";
$room->save();
$room = new Room();
$room->no = "Dorm B";
$room->view = "Parking";
$room->room_type_id = 9;
$room->description = "5 Double Decks";
$room->save();
}
/**
* dashboard view with all the statistics
* @return mixed
*/
public function dash()
{
$roomWeek = DB::select(DB::raw("select * from ROOM_RESERVATION A\nLEFT JOIN CUSTOMER B ON A.cus_id = B.cus_id\nWHERE A.status = 'ACCEPTED'\nAND A.check_in < DATE_ADD(NOW(),INTERVAL 7 DAY)\nAND A.check_in > DATE_SUB(NOW(),INTERVAL 1 DAY)\nOrder by A.check_in ASC"));
$hallWeek = DB::select(DB::raw("Select A.*, B.*, (select C.title from HALLS C where C.hall_id = A.hall_id) as title from HALL_RESERVATION A\nLEFT JOIN CUSTOMER B ON A.cus_id = B.cus_id\nWHERE A.status = 'ACCEPTED'\nAND A.reserve_date < DATE_ADD(NOW(),INTERVAL 7 DAY)\nAND A.reserve_date > DATE_SUB(NOW(),INTERVAL 1 DAY)\nOrder by A.reserve_date ASC;"));
$checkout = DB::select(DB::raw("select * from ROOM_RESERVATION A\nLEFT JOIN CUSTOMER B ON A.cus_id = B.cus_id\nWHERE A.status IN ('ACCEPTED','CHECKED IN')\nAND DATE_FORMAT(A.check_out,'%Y-%m-%d') = DATE_FORMAT(NOW(),'%Y-%m-%d')\nOrder by A.check_out ASC;"));
$reservationCount = DB::select(DB::raw("Select count(*) as pending,\n(select count(*) from ROOM_RESERVATION A where A.status NOT IN('PENDING','REJECTED','CANCELLED') AND A.check_in > NOW()) as accepted,\n(select count(*) from HALL_RESERVATION A where A.status NOT IN('PENDING','REJECTED','CANCELLED') AND A.reserve_date > NOW()) as accepted_hall,\n(select count(*) from HALL_RESERVATION A where A.status = 'PENDING' AND A.reserve_date > NOW()) as pending_hall\n from ROOM_RESERVATION A where A.status = 'PENDING' AND A.check_in > NOW()"));
$roomInfo = DB::select(DB::raw("Select count(room_id) as count,\n(select B.type_name from ROOM_TYPES B where B.room_type_id = A.room_type_id) as type_name\n from ROOMS A Where A.status = 'AVAILABLE'\nGroup by A.room_type_id"));
$ongoing = DB::select(DB::raw("select * from ROOM_RESERVATION A\nLEFT JOIN CUSTOMER B ON A.cus_id = B.cus_id\nWHERE A.status = 'CHECKED IN'"));
$roomTypes = RoomType::all();
return view('nilesh.dash')->with('reservationCount', $reservationCount)->with('roomWeek', $roomWeek)->with('checkout', $checkout)->with('roomInfo', $roomInfo)->with('roomTypes', $roomTypes)->with('ongoing', $ongoing)->with('hallWeek', $hallWeek);
}
/**
* edit room tye info
*
* @param Request $request
* @return \Illuminate\Http\JsonResponse
*
*/
public function admin_edit_roomtype(Request $request)
{
$roomType = RoomType::find($request->input('id'));
$id = $request->input('id');
$rate = DB::select(DB::raw("select a.*,\n (select b.meal_type_name from MEAL_TYPES b where b.meal_type_id = a.meal_type_id) as meal\n from RATES a where a.room_type_id = '{$id}'"));
//RATE::where('room_type_id',$request->input('id'))->get();
$images = ROOM_IMAGE::where('room_type_id', $request->input('id'))->get();
$rf = RoomTypeFurnish::where('room_type_id', $request->input('id'))->get();
$rs = RoomTypeService::where('room_type_id', $request->input('id'))->get();
return response()->json(['info' => $roomType, 'images' => $images, 'rs' => $rs, 'rf' => $rf, 'rate' => $rate]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index($roomTypeId)
{
return response()->json(RoomType::find($roomTypeId)->rooms);
}
public function deleteRoomType($id)
{
RoomType::where('id', $id)->delete();
return redirect()->route('listroomtype_com');
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create($property_id)
{
//
$room_types = RoomType::where('property_id', '=', $property_id)->lists('name', 'id');
return view('room.create')->with('property_id', $property_id)->with('room_types', $room_types);
}
