= UC0007 - Review Applications =

'''Initiating actor:''' Main Organiser

A Main Organiser reviews applications for their event edition and updates application statuses.

== Scenario ==

1. The Main Organiser opens the application review page.

2. The application lists event editions where the current member is an accepted Main Organiser.

{{{#!sql
SELECT
    ee.ee_id,
    et.et_name,
    ee.ee_title,
    ee.ee_start_time,
    ee.ee_end_time
FROM applications a
JOIN event_functions ef
    ON ef.ee_id = a.ee_id
   AND ef.ef_no = a.ef_no
JOIN event_editions ee
    ON ee.ee_id = a.ee_id
JOIN event_types et
    ON et.et_id = ee.et_id
WHERE a.student_index = 230014
  AND a.application_type = 'event_function'
  AND a.application_status = 'accepted'
  AND ef.ef_name LIKE 'Main Organiser%'
ORDER BY ee.ee_start_time DESC;
}}}

3. The Main Organiser chooses Impact Hackathon 2026.

4. The application lists submitted applications for the event edition.

{{{#!sql
SELECT
    a.application_id,
    s.student_index,
    s.first_name,
    s.last_name,
    ef.ef_name,
    a.application_type,
    a.application_status,
    a.motivational_letter
FROM applications a
JOIN students s
    ON s.student_index = a.student_index
LEFT JOIN event_functions ef
    ON ef.ee_id = a.ee_id
   AND ef.ef_no = a.ef_no
WHERE a.ee_id = 8
ORDER BY a.application_type, ef.ef_name, a.application_status, s.last_name, s.first_name;
}}}

5. The Main Organiser accepts the participation application from student 230031.

6. The application updates the application status.

{{{#!sql
UPDATE applications
SET application_status = 'accepted'
WHERE student_index = 230031
  AND ee_id = 8
  AND application_type = 'event_participation';
}}}

7. The application shows the updated application list.

{{{#!sql
SELECT
    a.application_id,
    s.student_index,
    s.first_name,
    s.last_name,
    ef.ef_name,
    a.application_type,
    a.application_status
FROM applications a
JOIN students s
    ON s.student_index = a.student_index
LEFT JOIN event_functions ef
    ON ef.ee_id = a.ee_id
   AND ef.ef_no = a.ef_no
WHERE a.ee_id = 8
ORDER BY a.application_type, ef.ef_name, a.application_status, s.last_name, s.first_name;
}}}

8. The application shows accepted event function applications for the same event edition.

{{{#!sql
SELECT
    ef.ef_no,
    ef.ef_name,
    s.student_index,
    s.first_name,
    s.last_name
FROM event_functions ef
LEFT JOIN applications a
    ON a.ee_id = ef.ee_id
   AND a.ef_no = ef.ef_no
   AND a.application_type = 'event_function'
   AND a.application_status = 'accepted'
LEFT JOIN students s
    ON s.student_index = a.student_index
WHERE ef.ee_id = 8
ORDER BY ef.ef_no;
}}}