function check_schedule_availability($scheduled_date_time_data, $location_field_name)
{
// Check to see if schedule dates and times are available.
$query = "SELECT COUNT(*) FROM " . DATE_TIME_SCHEDULE_TABLE . " WHERE (";
foreach ($scheduled_date_time_data as $sql_data) {
// First check to see if the data for the month(s) have been created yet.
// Do this only for each unique "YYYYMM" in the date time data array.
list($date, $time) = explode(" ", $sql_data);
list($year, $month, $day) = explode("-", $date);
$yearmonth = $year . $month;
if ($yearmonth != $previous_yearmonth) {
$result = create_date_time_schedule_data($date);
}
$previous_yearmonth = $yearmonth;
// then...resume building the query
$query .= "schedule_date_time = '" . $sql_data . "' OR ";
}
$query = substr($query, 0, strlen($query) - 4);
$query .= ") AND " . $location_field_name . " = 0";
//echo $query."<br /><br />";
$result = wrap_db_query($query);
$db_row_values = wrap_db_fetch_array($result);
// Return the number of available date time schedule blocks
$availability = $db_row_values[0];
//echo 'Schedule Availability Count: '.$availability.'<br /><br />';
return $availability;
}
// Selected Date Data
@(list($sel_year, $sel_month, $sel_day) = explode("-", $_REQUEST['date']));
if (!checkdate($sel_month + 0, $sel_day + 0, $sel_year + 0)) {
$_REQUEST['date'] = TODAYS_DATE;
list($sel_year, $sel_month, $sel_day) = explode("-", $_REQUEST['date']);
}
if (strlen($sel_year) == 2 && $sel_year <= 69) {
$sel_year += 2000;
}
define('SELECTED_DATE_YEAR', sprintf("%04d", $sel_year));
define('SELECTED_DATE_MONTH', sprintf("%02d", $sel_month));
define('SELECTED_DATE_DAY', sprintf("%02d", $sel_day));
define('SELECTED_DATE', SELECTED_DATE_YEAR . '-' . SELECTED_DATE_MONTH . '-' . SELECTED_DATE_DAY);
$_REQUEST['date'] = SELECTED_DATE;
$tmp_todays_dates = date("j M Y|l F j, Y", mktime(1, 0, 0, SELECTED_DATE_MONTH, SELECTED_DATE_DAY, SELECTED_DATE_YEAR));
list($tmp_shortstr, $tmp_longstr) = explode("|", $tmp_todays_dates);
define('SELECTED_DATE_SHORTSTR', $tmp_shortstr);
// 21 Mar 2003
define('SELECTED_DATE_LONGSTR', $tmp_longstr);
// Saturday, January 25, 2003
// Selected Date Data - Previous/Next Day, Month, & Year Data
define('PREVIOUS_DAY_DATE', add_delta_ymd(SELECTED_DATE, 0, 0, -1));
define('NEXT_DAY_DATE', add_delta_ymd(SELECTED_DATE, 0, 0, 1));
define('PREVIOUS_MONTH_DATE', add_delta_ymd(SELECTED_DATE, 0, -1, 0));
define('NEXT_MONTH_DATE', add_delta_ymd(SELECTED_DATE, 0, 1, 0));
define('PREVIOUS_YEAR_DATE', add_delta_ymd(SELECTED_DATE, -1, 0, 0));
define('NEXT_YEAR_DATE', add_delta_ymd(SELECTED_DATE, 1, 0, 0));
// Create the schedule table data for the selected month date (year and month).
include_once "booking_db_fns.php";
$res = create_date_time_schedule_data(SELECTED_DATE, $_REQUEST['loc']);
