Changes between Initial Version and Version 1 of UseCase0001

Timestamp:

08/29/26 18:48:55 (8 days ago)

Author:

236024

Comment:

--

UseCase0001

@@ +1 @@
+= UC0001 - View Member Profile and Membership History =
+
+'''Initiating actor:''' Board Member
+
+A Board Member views the stored data for a selected BEST Skopje member. The goal is to see the member's profile, current membership stage, mentor, current organisational function, previous membership stages, and applications.
+
+== Scenario ==
+
+1. The Board Member opens the administration page and searches for members named Dario.
+
+2. The application shows a list of members that include the name Dario in their first or last name.
+
+{{{#!sql
+SELECT
+    s.student_index,
+    s.first_name,
+    s.last_name,
+    s.faculty,
+    hs.ms_name AS current_membership_stage
+FROM students s
+JOIN members m
+    ON m.student_index = s.student_index
+LEFT JOIN has_stage hs
+    ON hs.student_index = s.student_index
+   AND hs.valid_to IS NULL
+WHERE lower(s.first_name) LIKE lower('%Dario%')
+   OR lower(s.last_name) LIKE lower('%Dario%')
+ORDER BY s.last_name, s.first_name;
+}}}
+
+3. The Board Member selects Dario Petreski.
+
+4. The application shows the selected member profile.
+
+{{{#!sql
+SELECT
+    s.student_index,
+    s.first_name,
+    s.last_name,
+    s.faculty,
+    s.field_of_studies,
+    s.year_of_studies,
+    s.email,
+    s.phone_number,
+    hs.ms_name AS current_membership_stage,
+    hs.valid_from AS current_stage_valid_from,
+    ym.mentor_index,
+    mentor.first_name AS mentor_first_name,
+    mentor.last_name AS mentor_last_name,
+    iof.of_title AS current_organizational_function,
+    iof.mandate
+FROM students s
+JOIN members m
+    ON m.student_index = s.student_index
+LEFT JOIN has_stage hs
+    ON hs.student_index = s.student_index
+   AND hs.valid_to IS NULL
+LEFT JOIN young_members ym
+    ON ym.student_index = s.student_index
+LEFT JOIN students mentor
+    ON mentor.student_index = ym.mentor_index
+LEFT JOIN is_organizational_function iof
+    ON iof.student_index = s.student_index
+   AND iof.mandate = '2025/2026'
+WHERE s.student_index = 230024;
+}}}
+
+5. The application shows the member's membership stage history.
+
+{{{#!sql
+SELECT
+    hs.ms_name,
+    hs.valid_from,
+    hs.valid_to
+FROM has_stage hs
+WHERE hs.student_index = 230024
+ORDER BY hs.valid_from;
+}}}
+
+6. The application shows the member's applications.
+
+{{{#!sql
+SELECT
+    a.application_id,
+    a.et_name,
+    a.event_title,
+    a.event_start_time,
+    a.function_name,
+    a.application_type,
+    a.application_status
+FROM applications a
+WHERE a.student_index = 230024
+ORDER BY a.event_start_time, a.application_id;
+}}}