setAuthConfig('/home/dave/secure/client_credentials.json'); $calendar_events = []; $calendar_error = null; if (isset($_SESSION['access_token']) && $_SESSION['access_token']) { $client->setAccessToken($_SESSION['access_token']); if ($client->isAccessTokenExpired()) { $client->fetchAccessTokenWithRefreshToken($client->getRefreshToken()); $_SESSION['access_token'] = $client->getAccessToken(); } $service = new Google_Service_Calendar($client); // Fetch calendar colors $colors = $service->colors->get(); $eventColors = $colors->getEvent(); // Determine the selected date (default to current date) $selected_date = isset($_GET['date']) ? $_GET['date'] : date('Y-m-d'); // Fetch events from RMGT calendar for the selected date $calendarId = 'd5284d59cf8afa5a911d14a4b670f0f63a0b031de0003b9807aafea0d90bd1bf@group.calendar.google.com'; $timeMin = $selected_date . 'T00:00:00Z'; $timeMax = $selected_date . 'T23:59:59Z'; $optParams = [ 'maxResults' => 100, 'orderBy' => 'startTime', 'singleEvents' => true, 'timeMin' => $timeMin, 'timeMax' => $timeMax, ]; try { $results = $service->events->listEvents($calendarId, $optParams); foreach ($results->getItems() as $event) { $calendar_events[] = [ 'id' => $event->getId(), 'summary' => $event->getSummary(), 'start' => $event->start->dateTime ?: $event->start->date, 'colorId' => $event->getColorId(), 'backgroundColor' => $event->getColorId() && isset($eventColors[$event->getColorId()]) ? $eventColors[$event->getColorId()]->getBackground() : '#787878', ]; } // Sort events by start time usort($calendar_events, function($a, $b) { return strtotime($a['start']) <=> strtotime($b['start']); }); } catch (Exception $e) { $calendar_error = "Calendar Error: " . $e->getMessage(); } } else { $calendar_error = "Not authenticated with Google Calendar. Connect to Google Calendar"; } // Connect to the rmgt database require_once 'config.php'; $rmgt_conn = new mysqli('database-1.cpxjovqfaduk.eu-west-2.rds.amazonaws.com', 'admin', 'efoih24524aedfawtga!SFD', 'rmgt'); $students = []; $students_error = null; if ($rmgt_conn->connect_error) { $students_error = 'Database connection failed: ' . $rmgt_conn->connect_error; } elseif (empty($calendar_events)) { $students_error = 'No events found in RMGT calendar for this day.'; } else { // Fetch students matching calendar event summaries, including rate $event_summaries = array_map(function($event) { // Remove "(paid)" from summary for matching return preg_replace('/\s*\(paid\)$/i', '', trim($event['summary'])); }, $calendar_events); $placeholders = implode(',', array_fill(0, count($event_summaries), '?')); $query = " SELECT s.student_id, s.forename, s.surname, s.calendar_name, s.rate, p.progress, p.datetimestamp FROM students s LEFT JOIN ( SELECT student_id, progress, datetimestamp FROM student_progress WHERE (student_id, datetimestamp) IN ( SELECT student_id, MAX(datetimestamp) FROM student_progress GROUP BY student_id ) ) p ON s.student_id = p.student_id WHERE s.active = 1 AND s.calendar_name IN ($placeholders) "; $stmt = $rmgt_conn->prepare($query); $types = str_repeat('s', count($event_summaries)); $stmt->bind_param($types, ...$event_summaries); $stmt->execute(); $result = $stmt->get_result(); if ($result === false) { $students_error = 'Error fetching students: ' . $rmgt_conn->error; } else { $students = $result->fetch_all(MYSQLI_ASSOC); $students_error = empty($students) ? 'No matching students found for calendar events.' : null; } $stmt->close(); $rmgt_conn->close(); } // Check if a form should be reopened after refresh $reopen_form_id = isset($_GET['reopen_form']) ? (int)$_GET['reopen_form'] : null; ?> Student Schedule

Student Schedule

Student Schedule for

  • -
    Calendar:
    Last worked on:
    Updated:
    No progress recorded.
Accounts Financials RM Guitar Update Schedule