public function createReservation(Request $request)
{
$room_info = $request['room_info'];
$start_dt = Carbon::createFromFormat('d-m-Y', $request['start_dt'])->toDateString();
$end_dt = Carbon::createFromFormat('d-m-Y', $request['end_dt'])->toDateString();
$customer = Customer::firstOrCreate($request['customer']);
$reservation = Reservation::create();
$reservation->total_price = $room_info['total_price'];
$reservation->occupancy = $request['occupancy'];
$reservation->customer_id = $customer->id;
$reservation->checkin = $start_dt;
$reservation->checkout = $end_dt;
$reservation->save();
$date = $start_dt;
while (strtotime($date) < strtotime($end_dt)) {
$room_calendar = RoomCalendar::where('day', '=', $date)->where('room_type_id', '=', $room_info['id'])->first();
$night = ReservationNight::create();
$night->day = $date;
$night->rate = $room_calendar->rate;
$night->room_type_id = $room_info['id'];
$night->reservation_id = $reservation->id;
$room_calendar->availability--;
$room_calendar->reservations++;
$room_calendar->save();
$night->save();
$date = date("Y-m-d", strtotime("+1 day", strtotime($date)));
}
$nights = $reservation->nights;
$customer = $reservation->customer;
return $reservation;
}
public function createReservation(Request $request)
{
// $request = array (
// 'customer' =>
// array (
// 'first_name' => 'Marie-Laure',
// 'last_name' => 'Lamarque-Choy',
// 'email' => '*****@*****.**',
// ),
// 'room_info' =>
// array (
// 'id' => 4,
// 'name' => 'Large Studio',
// 'short_name' => 'LXS1',
// 'base_price' => '200.00',
// 'base_availability' => '3',
// 'max_occupancy' => '4',
// 'created_at' => '2016-01-11 00:00:00',
// 'updated_at' => '2016-01-11 00:00:00',
// 'total_price' => 0,
// ),
// 'start_dt' => '15-1-2016',
// 'end_dt' => '16-1-2016',
// 'occupancy' => '2',
// );
$room_info = $request['room_info'];
$start_dt = Carbon::createFromFormat('d-m-Y', $request['start_dt'])->toDateString();
$end_dt = Carbon::createFromFormat('d-m-Y', $request['end_dt'])->toDateString();
$customer = Customer::firstOrCreate($request['customer']);
$reservation = Reservation::create();
$reservation->total_price = $room_info['total_price'];
$reservation->occupancy = $request['occupancy'];
$reservation->customer_id = $customer->id;
$reservation->checkin = $start_dt;
$reservation->checkout = $end_dt;
//$var = "'".var_export($request->all())."''";
//return $var;
$reservation->save();
$date = $start_dt;
while (strtotime($date) < strtotime($end_dt)) {
$room_calendar = RoomCalendar::where('day', '=', $date)->where('room_type_id', '=', $room_info['id'])->first();
$night = ReservationNight::create();
$night->day = $date;
//dd($room_calendar);
$night->rate = $room_calendar->rate;
$night->room_type_id = $room_info['id'];
$night->reservation_id = $reservation->id;
$room_calendar->availability--;
$room_calendar->reservations++;
$room_calendar->save();
$night->save();
$date = date("Y-m-d", strtotime("+1 day", strtotime($date)));
}
$nights = $reservation->nights;
$customer = $reservation->customer;
return $reservation;
}