/** * Display a listing of the resource. * GET /booking * * @return Response */ public function index() { if (Session::has('checkin') && Session::has('checkout') && Session::has('reserved_room_id')) { $checkin = Session::get('checkin'); $checkout = Session::get('checkout'); $room_id = Session::get('reserved_room_id'); $room_details = Room::where('id', $room_id)->select('id', 'name', 'price')->first(); $available_rooms = 0; $room1 = []; //$roomDetails = Room::where('id')->first(); $room = RoomQty::where('room_id', Session::get('reserved_room_id'))->with(array('roomReserved' => function ($query) { $query->whereBetween('check_in', array(Session::has('checkin'), Session::has('checkout')))->orWhereBetween('check_out', array(Session::has('checkin'), Session::has('checkout')))->orWhereRaw('"' . Session::has('checkin') . '" between check_in and check_out')->orWhereRaw('"' . Session::has('checkout') . '" between check_in and check_out')->where('status', '!=', 5); }))->get(); foreach ($room as $r) { if ($r->roomReserved->count() == 0 && $r->status == 1) { $available_rooms++; } } $room = $room->toArray(); $room1['quantity'] = $room; $room1['available_rooms'] = $available_rooms; $cpage = 'booking'; return View::make('clientview.booking.index', compact('cpage', 'available_rooms', 'room_details')); } else { return Redirect::to('/'); } }
Route::get('dashboard/departure/aPassword::sendReminder(user, token, callback)jax', 'DashboardController@ajax_todayDeparture'); Route::get('dashboard/occupied_booking/ajax', 'DashboardController@ajax_todayBookingOccupied'); Route::get('dashboard/preparing_booking/ajax', 'DashboardController@ajax_todayBookingPreparing'); Route::get('dashboard/success_booking', 'DashboardController@todayBookingSuccess'); Route::get('dashboard/cancelled_booking', 'DashboardController@todayBookingCancelled'); Route::get('dashboard/pending_booking', 'DashboardController@todayBookingPending'); Route::get('dashboard/arrival', 'DashboardController@todayArrival'); Route::get('dashboard/departure', 'DashboardController@todayDeparture'); Route::get('dashboard/occupied', 'DashboardController@todayBookingOccupied'); Route::get('dashboard/preparing', 'DashboardController@todayBookingPreparing'); Route::get('reservation/list/ajax', 'BookingController@thisYearList'); Route::get('activity', 'ActivitiesController@index'); Route::get('room', 'RoomController@index'); Route::get('room/all', 'RoomController@allrooms'); Route::get('room/search/{query}', function ($query) { $r = RoomQty::where('room_no', $query)->first(); if (!empty($r)) { $room_id = $r->room_id; $rooms = Room::with('roomQty', 'roomImages.photo')->where('id', $room_id)->get(); //return 'heyt'; return $rooms; } else { return '0'; } return 'hey'; }); Route::get('user', 'UsersController@index'); Route::post('user/create', 'UsersController@store'); Route::post('user/{id}/delete', 'UsersController@destroy'); Route::post('user/{id}/update', 'UsersController@update'); Route::get('settings', function () {
public function updateSpecific($id) { $i = Input::all(); $today = Date('Y-m-d H:i:s'); $tomorrow = new DateTime('tomorrow'); $tomorrow = $tomorrow->format('Y-m-d') . ' 11:59:00'; $r = RoomQty::where('id', $id)->with(array('roomReserved' => function ($query) use($today, $tomorrow) { $query->where(function ($query2) use($today, $tomorrow) { $query2->whereBetween('check_in', array($today, $tomorrow))->orWhereBetween('check_out', array($today, $tomorrow))->orWhereRaw('"' . $today . '" between check_in and check_out')->orWhereRaw('"' . $tomorrow . '" between check_in and check_out'); })->where(function ($query3) { $query3->where('status', '!=', 5)->where('status', '!=', 3); }); }))->first(); if (!empty($r)) { $r->room_no = $i['room_no']; $r->status = $i['status']; if ($r->save()) { return $r; } else { return '0'; //means failed } } }