/** * 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); }