Example #1
0
function create_date_time_schedule_data($date, $location = DEFAULT_LOCATION_NAME)
{
    //echo "<p>create_date_time_schedule_data function: $date</p>";
    // create the date time schedule data for the specified year and month.
    global $location_db_name;
    list($year, $month, $day) = explode("-", $date);
    // query for the date time data for the 1st of the month, limit only 1
    $result = wrap_db_query("SELECT * FROM " . DATE_TIME_SCHEDULE_TABLE . " WHERE\n\t\t\t\t\t\t" . $location_db_name[$location] . " >= 0 AND\n\t\t\t\t\t\tschedule_date_time = '" . $year . "-" . $month . "-01 " . MIN_BOOKING_HOUR . ":00:00'\n\t\t\t\t\t\tLIMIT 0,1");
    if (!defined(BOOKING_TIME_INTERVAL)) {
        define(BOOKING_TIME_INTERVAL, 30);
    }
    // If there are no result(s) then we need to create the data for this month.
    if (!(wrap_db_num_rows($result) >= 1) || !$result) {
        // Define Valid Times (hh:mm format)
        $valid_times = get_times_in_range(sprintf("%02d", MIN_BOOKING_HOUR) . ':00', sprintf("%02d", MAX_BOOKING_HOUR) . ':00', BOOKING_TIME_INTERVAL, false);
        // Define Starting Weekday Value (0=Sunday, 1=Monday,...,6=Saturday)
        $dayoftheweekid = beginning_weekday_of_the_month($year, $month);
        for ($i = 1; $i <= 31; $i++) {
            // For Each Day in the Month.
            if (check_valid_date($year . '-' . $month . '-' . $i)) {
                //echo "Loop ID: $i<br />";
                if ($dayoftheweekid == 7) {
                    $dayoftheweekid = 0;
                }
                //echo "Day of the Week ID: $dayoftheweekid <br />";
                foreach ($valid_times as $valid_time) {
                    $result = wrap_db_query("INSERT INTO " . DATE_TIME_SCHEDULE_TABLE . " \n\t\t\t\t\t\tSET schedule_date_time = '" . $year . "-" . $month . "-" . sprintf("%02d", $i) . " " . $valid_time . "', day_of_the_week_id = " . $dayoftheweekid);
                }
                $dayoftheweekid++;
            }
            // end of if
        }
        // end of for loop
        // Order the table if modified.
        $result = wrap_db_query("ALTER TABLE " . DATE_TIME_SCHEDULE_TABLE . " ORDER BY schedule_date_time");
        // Optimize all of the main tables.
        $result = wrap_db_query("OPTIMIZE TABLE " . DATE_TIME_SCHEDULE_TABLE);
        $result = wrap_db_query("OPTIMIZE TABLE " . BOOKING_EVENT_TABLE);
        $result = wrap_db_query("OPTIMIZE TABLE " . BOOKING_USER_TABLE);
    }
    // end of if
    return true;
}
Example #2
0
 } elseif ($unix_starting_date < $unix_todays_date) {
     $page_error_message = "Your starting date is in the past! Please enter a start date in the future.";
 } elseif (!check_valid_date($starting_date)) {
     $page_error_message = "Your starting date does not exist. There are only " . number_of_days_in_month($_POST['start_year'], $_POST['start_mon']) . " days in " . month_name($_POST['start_mon']) . " " . $_POST['start_year'] . ". Please check the calendar and try again.";
 } elseif (!$dates_within_limit) {
     if ($bookingTooSoonAhead) {
         $page_error_message = "Your starting time is outside of the minimum booking period of " . $bookeeMinimumAdvanceBookingLimit . " hours.<br><br>";
         $page_error_message .= "Please select a later booking slot and re-submit the form.";
     } else {
         //Basically: $bookingTooFarAhead == true
         $page_error_message = "Your ending date is outside of the booking limit of " . $bookeeAdvanceBookingLimit / 24 . " days.<br><br>";
         $page_error_message .= "The form has been updated to reflect the maximum end and recurrence dates (where applicable).<br>Please check these dates, select an appropriate start date and re-submit the form.";
     }
 } elseif (!check_valid_date($ending_date)) {
     $page_error_message = "Your ending date does not exist. There are only " . number_of_days_in_month($_POST['end_year'], $_POST['end_mon']) . " days in " . month_name($_POST['end_mon']) . " " . $_POST['end_year'] . ". Please check the calendar and try again.";
 } elseif (!check_valid_date($recur_date) && $recur_interval != '') {
     $page_error_message = "Your recurring date does not exist. There are only " . number_of_days_in_month($_POST['recur_year'], $_POST['recur_mon']) . " days in " . month_name($_POST['recur_mon']) . " " . $_POST['recur_year'] . ". Please check the calendar and try again.";
 } elseif (implode("", explode("-", $ending_date)) . implode("", explode(":", $_POST['end_time'])) + 0 <= implode("", explode("-", $starting_date)) . implode("", explode(":", $_POST['start_time'])) + 0) {
     $page_error_message = "Your ending date and time must occur after your starting " . "date and time. Please check your dates and times and try again.";
 } elseif (implode("", explode("-", $recur_date)) + 0 <= implode("", explode("-", $ending_date)) + 0 && !($recur_interval == 'none' || $recur_interval == '')) {
     $page_error_message = "Your recurring until date must occur after your ending " . "date. Please check your dates and try again.";
 }
 // end of if/elseif
 //if recurrence interval is set to none, overwrite the recur_date with
 //the start date to prevent entry of past recur dates into the db
 if ($recur_interval == 'none' || $recur_interval == '') {
     $recur_date = $starting_date;
 }
 // CHECK FOR OVERLAPPING RECURRENCE PROBLEM
 //echo "Recurrence Dates:<br />";
 reset($recurring_dates);
Example #3
0
function get_day_view_event_data($date, $location = DEFAULT_LOCATION_NAME)
{
    // Get the event data for the selected day, month, year and location.
    global $location_db_name;
    // Sanitize for MySQL
    $date = wrap_db_escape_string($date);
    // Check Valid Date
    if (!check_valid_date($date)) {
        $date = '1970-01-01';
    }
    list($year, $month, $day) = explode("-", $date);
    $query = "SELECT * \r\n\t\t\t\t\t\tFROM " . DATE_TIME_SCHEDULE_TABLE . ", " . BOOKING_EVENT_TABLE . " WHERE \r\n\t\t\t\t\t\t" . DATE_TIME_SCHEDULE_TABLE . "." . $location_db_name[$location] . " != 0 AND \r\n\t\t\t\t\t\t" . DATE_TIME_SCHEDULE_TABLE . "." . $location_db_name[$location] . " = " . BOOKING_EVENT_TABLE . ".event_id AND \r\n\t\t\t\t\t\t" . DATE_TIME_SCHEDULE_TABLE . ".schedule_date_time >= '" . $date . " 00:00:00' AND \r\n\t\t\t\t\t\t" . DATE_TIME_SCHEDULE_TABLE . ".schedule_date_time <= '" . $date . " 23:59:59' \r\n\t\t\t\t\t\tORDER BY " . DATE_TIME_SCHEDULE_TABLE . ".schedule_date_time";
    //echo $query."<br /><br />";
    $result = wrap_db_query($query);
    $db_num_rows = wrap_db_num_rows($result);
    // Event Row Data Assoc. Array
    //    $event_row_data['display_time'] = 'db_row_id|row_span|start_time|end_time';
    $event_row_data = array();
    global $event_row_data;
    // Get the Display Times and Number of Rows
    $data_display_times = get_times_in_range(MIN_BOOKING_HOUR, MAX_BOOKING_HOUR, BOOKING_TIME_INTERVAL, true);
    $number_of_display_time_rows = count($data_display_times);
    // Create an Assoc. Date array for index lookup.
    $display_time_lookup = array();
    for ($i = 0; $i < $number_of_display_time_rows; $i++) {
        $display_time_lookup[$data_display_times[$i]] = $i;
    }
    // $event_row_data array - build out the schedule time blocks
    foreach ($data_display_times as $display_time) {
        $event_row_data[$display_time] = '';
    }
    reset($data_display_times);
    if (!$result) {
        //echo "No Database Events / Results<br />";
        return false;
    }
    // Go thru the database $result data and fill out the $event_row_data array.
    $previous_event_id = 0;
    $row_span = 0;
    $row = 0;
    $event = array();
    //echo "<h1>TESTING</h1>";
    for ($row = 0; $row <= $db_num_rows; $row++) {
        // define db variables
        $event = wrap_db_fetch_array($result);
        $db_event_id = $event['event_id'];
        //echo "ID: $db_event_id<br />";
        list($db_starting_date, $db_starting_time) = explode(" ", $event['schedule_date_time']);
        list($db_hr, $db_min, $db_sec) = explode(":", $db_starting_time);
        $db_starting_time = sprintf("%02d", $db_hr) . ':' . sprintf("%02d", $db_min);
        if ($previous_event_id != $db_event_id || $previous_event_id == 0) {
            // event_id has changed / or first event_id
            if ($previous_event_id != 0) {
                // if not first id, then define $event_row_data array
                // place the event data into $event_row_data: 'db_row_id|row_span|start_time|end_time'
                $event_row_data[$event_start_time] = $event_start_db_row_id . "|" . $row_span . "|" . $event_start_time . "|" . $data_display_times[$display_time_lookup[$event_start_time] + $row_span];
                // echo values for testing
                //echo "Define Event -> " . $event_row_data[$event_start_time] . "<br />";
                // initialize the row_span for the new event
                $row_span = 1;
            }
            // Mark the event starting time and db row id to be used to data_seeking
            //echo "<strong>Mark Start:</strong> ".$db_starting_time.", ".$row.", ".$db_event_id."<br />";
            $event_start_time = $db_starting_time;
            // mark the starting time
            $event_start_db_row_id = $row;
            // mark the starting db row
            $row_span = 1;
        } else {
            // same event_id
            // Set the 'row_span' for the spanning cells of the event to zero ('row_span' = 0)
            $event_row_data[$db_starting_time] = 0;
            //echo "<strong>Same Event ID:</strong> ".$db_starting_time.", ".$row.", ".$db_event_id."<br />";
            $row_span++;
        }
        $previous_event_id = $db_event_id;
    }
    // end of while
    // Display/Check the $event_row_data for errors
    //echo "<br />";
    //foreach ($data_display_times as $display_time) {
    //		echo $display_time." Event Row Data: ".$event_row_data[$display_time]."<br />";
    //}
    // return the resulting data object
    return $result;
}