| | 1 | = Use-case 0010 - View RSVP Status = |
| | 2 | |
| | 3 | '''Initiating actor:''' Bride / Groom (Wedding owner) |
| | 4 | |
| | 5 | '''Other actors:''' Wedding Organizer (Assistant) |
| | 6 | |
| | 7 | == Description == |
| | 8 | The wedding owner views RSVP statuses for invited guests per event. This helps planning seating, catering and logistics. |
| | 9 | |
| | 10 | == Scenario == |
| | 11 | 1. The user opens an event. |
| | 12 | 2. The system shows RSVP summary for that event. |
| | 13 | |
| | 14 | {{{ |
| | 15 | SET search_path TO project; |
| | 16 | |
| | 17 | SELECT g.first_name, g.last_name, g.email, r.status, r.response_date |
| | 18 | FROM event_rsvp r |
| | 19 | JOIN guest g ON r.guest_id = g.guest_id |
| | 20 | WHERE r.event_id = :event_id |
| | 21 | ORDER BY g.last_name, g.first_name; |
| | 22 | }}} |
| | 23 | |
| | 24 | 3. The system groups results by RSVP status (accepted/declined/pending). |
| | 25 | 4. The user can export/print the RSVP list (optional). |
