本文整理匯總了PHP中Appointment::timeBetween方法的典型用法代碼示例。如果您正苦於以下問題:PHP Appointment::timeBetween方法的具體用法?PHP Appointment::timeBetween怎麽用?PHP Appointment::timeBetween使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Appointment
的用法示例。
在下文中一共展示了Appointment::timeBetween方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: getTimes
/**
* Function to retrieve times available for a given date
*
* View is returned in JSON format
*
**/
public function getTimes()
{
// We get the data from AJAX for the day selected, then we get all available times for that day
$selectedDay = Input::get('selectedDay');
$availableTimes = DB::select('SELECT id, booking_datetime AS bdate, strftime("%H:%M", booking_datetime) AS bdatetime FROM booking_datetimes WHERE strftime("%Y-%m-%d", booking_datetime)="' . $selectedDay . '"');
// PSEUDO CODE
// Get package duration of the chosen package
$package = Package::find(Session::get('packageID'));
$packageTime = $package->package_time;
// For each available time...
foreach ($availableTimes as $t => $value) {
//get the start and end times of that time
$startTime = new DateTime($value->bdate);
$endTime = new DateTime($value->bdate);
date_add($endTime, date_interval_create_from_date_string($packageTime . ' hours'));
// Try to grab any appointments between the start time and end time
$result = Appointment::timeBetween($startTime->format("Y-m-d H:i"), $endTime->format("Y-m-d H:i"));
// If no records are returned, the time is okay, if not, we must remove it from the array
if ($result->first()) {
unset($availableTimes[$t]);
}
}
return Response::make(View::make('getTimes')->with('selectedDay', $selectedDay)->with('availableTimes', $availableTimes), 200, array('Content-Type' => 'application/json'));
}