Hello I am making booking website and I can't understand how can I check if time is clear, So I will explain what I do:
when I choose service I send Date , Start Time, End Time and Time Between bookings so I need to check if that period for that day is clear.
Need Something Like this
whereRaw("? NOT BETWEEN quit_hour_start AND quit_hour_end", [$start, $end]
Sulution:
if($chkStartTime > $startTime && $chkEndTime < $endTime)
{
$message = "chosen time is between in booked time";
}
elseif(($chkStartTime > $startTime && $chkStartTime < $endTime) || ($chkEndTime > $startTime && $chkEndTime < $endTime))
{
$message = "Start Time or End Time is between Booked Time";
}
elseif($chkStartTime==$startTime || $chkEndTime==$endTime)
{
$message = "Start Time or End Time is on the border of booked time";
}
elseif($startTime > $chkStartTime && $endTime < $chkEndTime)
{
$message = "Time is Already booked";
}