= UC0003 - RSVP or Announce Absence for Activity Session =

'''Initiating actor:''' Member

A Member views upcoming activity sessions, submits an RSVP, or announces an absence. The scenario uses Nikola Spasovski as the logged-in member.

== Scenario ==

1. The Member opens the list of upcoming activity sessions.

2. The application lists upcoming sessions with the member's current RSVP, attendance status, and whether attendance is expected.

{{{#!sql
SELECT
    a.as_id,
    at.at_name,
    a.as_start_time,
    l.l_name,
    p.rsvp_status,
    p.rsvp_at,
    p.attendance_status,
    CASE
        WHEN ra.student_index IS NOT NULL THEN 'yes'
        ELSE 'no'
    END AS attendance_expected
FROM activity_sessions a
JOIN activity_types at
    ON at.at_id = a.at_id
JOIN locations l
    ON l.l_id = a.l_id
LEFT JOIN participation p
    ON p.as_id = a.as_id
   AND p.student_index = 230014
LEFT JOIN required_attendance ra
    ON ra.as_id = a.as_id
   AND ra.student_index = 230014
WHERE a.as_start_time >= CURRENT_TIMESTAMP
ORDER BY a.as_start_time, at.at_name;
}}}

3. The Member chooses the IT workshop and marks that they are going.

4. The application stores the RSVP.

{{{#!sql
INSERT INTO participation (
    student_index,
    as_id,
    rsvp_status,
    rsvp_at
)
VALUES (
    230014,
    22,
    'going',
    CURRENT_TIMESTAMP
);
}}}

5. The Member enters an absence reason for the Full Member Meeting on 16 April 2026.

6. The application checks that the member's attendance is expected for the selected activity session.

{{{#!sql
SELECT
    student_index,
    as_id
FROM required_attendance
WHERE student_index = 230014
  AND as_id = 9;
}}}

7. The application stores the absence announcement.

{{{#!sql
INSERT INTO announces_absence (
    student_index,
    as_id,
    reason,
    announced_at
)
VALUES (
    230014,
    9,
    'Faculty obligations at the same time.',
    CURRENT_TIMESTAMP
);
}}}

8. The application stores that the member is not going to the same activity session.

{{{#!sql
INSERT INTO participation (
    student_index,
    as_id,
    rsvp_status,
    rsvp_at
)
VALUES (
    230014,
    9,
    'not_going',
    CURRENT_TIMESTAMP
);
}}}

9. The application shows the saved absence and participation status.

{{{#!sql
SELECT
    p.student_index,
    at.at_name,
    a.as_start_time,
    l.l_name,
    p.rsvp_status,
    p.rsvp_at,
    p.attendance_status,
    aa.reason,
    aa.announced_at
FROM participation p
JOIN activity_sessions a
    ON a.as_id = p.as_id
JOIN activity_types at
    ON at.at_id = a.at_id
JOIN locations l
    ON l.l_id = a.l_id
LEFT JOIN announces_absence aa
    ON aa.student_index = p.student_index
   AND aa.as_id = p.as_id
WHERE p.student_index = 230014
  AND p.as_id = 9;
}}}