This RSVP link is invalid or has already been used.

', 'error'); exit; } // ── Look up attendee + meeting ──────────────────────────────── $stmt = $db->prepare(" SELECT ma.id AS attendee_id, ma.name, ma.email, ma.rsvp_status, ma.meeting_id, m.title, m.meeting_date, m.start_time, m.end_time, m.location, m.description, m.created_by, u.full_name AS organiser_name, u.email AS organiser_email FROM meeting_attendees ma JOIN meetings m ON m.id = ma.meeting_id LEFT JOIN users u ON u.id = m.created_by WHERE ma.rsvp_token = ? LIMIT 1 "); $stmt->execute([$token]); $row = $stmt->fetch(); if (!$row) { echo _page('Invalid Link', '

This RSVP link is invalid or has expired.

', 'error'); exit; } $name = htmlspecialchars($row['name'] ?: 'Guest'); $title = htmlspecialchars($row['title']); $dateStr = date('l, d F Y', strtotime($row['meeting_date'])); $timeStr = $row['start_time'] ? date('H:i', strtotime($row['start_time'])) . ($row['end_time'] ? ' – '.date('H:i', strtotime($row['end_time'])) : '') : 'All Day'; $loc = htmlspecialchars($row['location'] ?? ''); // ── Process response ────────────────────────────────────────── if ($r && in_array($r, ['accept','decline','reschedule'])) { // Reschedule requires a date if ($r === 'reschedule' && !$date) { // Show the reschedule form echo _rescheduleForm($name, $title, $dateStr, $timeStr, $loc, $token); exit; } $statusMap = ['accept' => 'accepted', 'decline' => 'declined', 'reschedule' => 'reschedule_requested']; $newStatus = $statusMap[$r]; $noteParts = []; if ($r === 'reschedule') { if ($date) $noteParts[] = "date:$date"; if ($time) $noteParts[] = "time:$time"; if ($place) $noteParts[] = "place:" . $place; } $note = implode('|', $noteParts); $db->prepare(" UPDATE meeting_attendees SET rsvp_status=?, rsvp_note=?, rsvp_at=NOW() WHERE rsvp_token=? ")->execute([$newStatus, $note, $token]); // Queue notification to organiser (direct DB insert, no mailer dependency) try { $cfg = $db->query("SELECT setting_key, setting_value FROM settings WHERE setting_group='email'")->fetchAll(\PDO::FETCH_KEY_PAIR); if (!empty($cfg['email_enabled']) && $cfg['email_enabled'] === '1' && !empty($row['organiser_email'])) { $icons = ['accepted'=>'✅','declined'=>'❌','reschedule_requested'=>'🔄']; $labels = ['accepted'=>'Accepted','declined'=>'Declined','reschedule_requested'=>'Reschedule Requested']; $colors = ['accepted'=>'#16a34a','declined'=>'#dc2626','reschedule_requested'=>'#0284c7']; $icon = $icons[$newStatus] ?? '📋'; $label = $labels[$newStatus] ?? $newStatus; $color = $colors[$newStatus] ?? '#6b7280'; // Parse structured note $noteHtml = ''; if ($note && $newStatus === 'reschedule_requested') { $parts = []; foreach (explode('|', $note) as $part) { if (str_starts_with($part, 'date:')) $parts['Date'] = substr($part, 5); if (str_starts_with($part, 'time:')) $parts['Time'] = substr($part, 5); if (str_starts_with($part, 'place:')) $parts['Location'] = substr($part, 6); } if ($parts) { $rows = ''; foreach ($parts as $k => $v) $rows .= "$k" . htmlspecialchars($v) . ""; $appUrl = $cfg['email_app_url'] ?? ''; $meetId = $row['meeting_id']; $attId = $row['attendee_id']; $noteHtml = "
Proposed Changes
$rows
" . ($appUrl ? "
✅ Accept Reschedule Keep Original Date
" : ''); } } elseif ($note) { $noteHtml = "

Note: " . htmlspecialchars($note) . "

"; } $subject = "📅 RSVP {$label}: {$row['title']}"; $html = "
{$icon}

{$label}

" . htmlspecialchars($row['name']) . " has responded to {$title}.

{$noteHtml}

Elegant Work Meeting System

"; $db->prepare(" INSERT INTO email_queue (notification_type, recipient_email, recipient_name, subject, body_html, related_type, related_id) VALUES ('meeting_rsvp', ?, ?, ?, ?, 'meeting', ?) ")->execute([$row['organiser_email'], $row['organiser_name'], $subject, $html, $row['meeting_id']]); } } catch (Exception $e) { /* silent */ } $messages = [ 'accepted' => ['✅ You\'re In!', "Thanks {$name}, your attendance for {$title} on {$dateStr} is confirmed."], 'declined' => ['❌ RSVP Declined', "Thanks {$name}, we've noted you won't be attending {$title}."], 'reschedule_requested' => ['🔄 Reschedule Requested', "Thanks {$name}, the organiser has been notified of your reschedule request for {$title}." . ($date ? " Proposed date: " . htmlspecialchars($date) . "" : '') . ($time ? " at " . htmlspecialchars($time) . "" : '') . ($place ? ". Proposed location: " . htmlspecialchars($place) . "" : '') . "."], ]; [$heading, $body] = $messages[$newStatus]; echo _page($heading, "

{$body}

", $r === 'accept' ? 'success' : 'info'); exit; } // ── Show invite form ────────────────────────────────────────── echo _inviteForm($name, $title, $dateStr, $timeStr, $loc, $token, htmlspecialchars($row['description'] ?? '')); exit; // ── HTML Helpers ────────────────────────────────────────────── function _shell(string $content): string { return << Meeting RSVP
{$content}
Powered by Elegant Work
HTML; } function _inviteForm(string $name, string $title, string $dateStr, string $timeStr, string $loc, string $token, string $desc): string { $locHtml = $loc ? "
📍
Location
{$loc}
" : ''; $descHtml = $desc ? "
📝
Details
{$desc}
" : ''; $t = urlencode($token); return _shell(<<

📅 Meeting Invitation

Please let the organiser know if you can attend

{$title}

📅
Date
{$dateStr}
⏰
Time
{$timeStr}
{$locHtml} {$descHtml}

Hi {$name}, will you be attending?

✅ Yes, I'll be there ❌ No, I can't make it 🔄 Request to reschedule
HTML); } function _rescheduleForm(string $name, string $title, string $dateStr, string $timeStr, string $loc, string $token): string { $t = htmlspecialchars($token); $today = date('Y-m-d'); return _shell(<<

🔄 Request Reschedule

Suggest an alternative date, time and place

Requesting to reschedule {$title} currently scheduled for {$dateStr} at {$timeStr}.

← Back
HTML); } function _page(string $heading, string $body, string $type = 'info'): string { $cls = $type === 'success' ? 'success' : ($type === 'error' ? 'error' : 'info'); return _shell(<<

RSVP Confirmed

Your response has been recorded

{$heading[0]}
{$heading}
{$body}
HTML); }