public function deletBooking($id)
{
$booking = App\Booking::findOrNew($id);
$userID = $booking::userID;
\App\Booking::destroy($id);
returnToUserBooking($userID);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$num_bookings = 50;
$all_properties = \App\Property::all();
$users = \App\User::all();
$statuses = array('requested', 'confirmed', 'rejected');
for ($i = 0; $i < $num_bookings; $i++) {
$one_property = $all_properties[mt_rand(0, count($all_properties) - 1)];
$one_customer = null;
$customer_id_ok = false;
while (!$customer_id_ok) {
$one_customer = $users[mt_rand(0, count($users) - 1)];
if ($one_customer->id != $one_property->owner_id) {
$customer_id_ok = true;
}
}
$one_status = $statuses[mt_rand(0, count($statuses) - 1)];
$booking_ok = false;
$start = null;
$end = null;
while (!$booking_ok) {
$start = $this->randomDate(date('2016-01-01'), "2016-04-30");
$start_time_plus_one_day = strtotime($start);
$start_time_plus_one_day = strtotime("+1 day", $start_time_plus_one_day);
$start_time_plus_seven_days = strtotime($start);
$start_time_plus_seven_days = strtotime("+7 day", $start_time_plus_seven_days);
$end = $this->randomDate(date('Y-m-d', $start_time_plus_one_day), date('Y-m-d', $start_time_plus_seven_days));
$select_statement = 'select * from bookings WHERE ' . "'" . $start . "'" . ' <= bookings.end AND ' . "'" . $end . "'" . ' >= start AND bookings.status = ' . "'" . 'confirmed' . "'" . 'AND bookings.property_id = ' . $one_property->id;
$overlapping_bookings = DB::select($select_statement);
if (count($overlapping_bookings) == 0) {
$booking_ok = true;
}
}
$booking = new \App\Booking();
$booking->customer_id = $one_customer->id;
$booking->property_id = $one_property->id;
$booking->start = $start;
$booking->end = $end;
$booking->status = $one_status;
$booking->save();
}
}
/**
* Responds to requests to POST /bookings/create
*/
public function postCreate(Request $request)
{
// check if the hall is booked for the given time
$startTime = $request->date . 'T08:00:00.000';
$endTime = $request->date . 'T19:00:00.000';
$bookings = \App\Booking::where('booking_status_id', '=', '3')->where('booking_time', '>=', $startTime)->where('booking_time', '<=', $endTime)->where('sport_hall_id', '=', $request->hall)->get();
// selected time for booking
$currentBookingTime = Carbon::createFromFormat('Y-m-d H:00', $request->date . ' ' . $request->time);
// hall should be booked atleast 5 hours in advance
if (Carbon::now()->diffInHours($currentBookingTime, false) <= 5) {
\Session::flash('flash_message', 'You have to book a hall atleast 5 hours in advance. Please select an other time slot.');
return redirect('/bookings/create');
}
// loop through all the booking on this date and check if the hall is reserved
foreach ($bookings as $bookingInRange) {
$startTime = Carbon::createFromFormat('Y-m-d H:00:00', $bookingInRange->booking_time);
$endTime = $startTime->copy();
$endTime->addHours($bookingInRange->hours);
if ($currentBookingTime->between($startTime, $endTime) && !($endTime->diffInHours($currentBookingTime) == 0)) {
\Session::flash('flash_message', 'Sorry the hall is already reserved for this time slot!');
return redirect('/bookings/create');
}
}
// make a booking
$booking = new \App\Booking();
$booking->sport_hall_id = $request->hall;
$booking->user_id = \Auth::id();
$booking->booking_time = Carbon::createFromFormat('Y-m-d H:00', $request->date . ' ' . $request->time)->toDateTimeString();
$bookingStatusId = \App\BookingStatus::where('status', '=', 'Reserved')->pluck('id');
$booking->booking_status_id = $bookingStatusId;
$booking->hours = $request->hours;
$booking->save();
// Done
\Session::flash('flash_message', 'Your booking was created!');
return redirect('/bookings');
}
