Changes between Initial Version and Version 1 of UseCase0001PrototypeImplementation

Timestamp:

03/16/26 21:53:16 (5 days ago)

Author:

221511

Comment:

--

UseCase0001PrototypeImplementation

@@ +1 @@
+= UC0001 Prototype Implementation - Browse Available Resources =
+
+'''Initiating actor:''' Student (also available to Teaching Staff and Administrator)
+
+'''Other actors:''' None
+
+The user browses all resources in the system with options to filter by type or building, view detailed information about a specific resource including its upcoming reservations, and check whether a resource is available at a specific date and time.
+
+== Scenario ==
+
+ 1. The user selects ''Browse Available Resources'' from the main menu. The system runs the following query:
+{{{
+SELECT r.resource_id, r.name, r.description,
+       r.available_from, r.available_to, r.available_weekends,
+       rt.type_name, rt.is_physical,
+       l.building, l.room
+FROM resources r
+JOIN resource_types rt ON r.type_id = rt.type_id
+LEFT JOIN locations l ON r.location_id = l.location_id
+ORDER BY rt.type_name, r.name;
+}}}
+
+The system displays all resources as a numbered list with a sub-menu:
+{{{
+=== Browse Resources (27 found) ===
+
+    1. Prusa i3 MK3S+ [3D Printer] - FINKI-B / Lab 1
+    2. Ultimaker S3 [3D Printer] - FINKI-B / Lab 1
+    3. Classroom 101 [Classroom] - FINKI-A / 101
+    ...
+   27. Google Cloud Credits [Online Service] - Digital
+
+  1. Filter by Resource Type
+  2. Filter by Building
+  3. View Resource Details
+  4. Check Availability for a Time Slot
+  5. Clear Filters
+  0. Cancel / Go back
+}}}
+
+ 2. The user selects ''Filter by Resource Type'' and picks ''Computer Laboratory''. The system queries the available types:
+{{{
+SELECT DISTINCT rt.type_name FROM resource_types rt ORDER BY rt.type_name;
+}}}
+
+The filtered results are displayed:
+{{{
+=== Browse Resources (4 found) ===
+  Active filters: Type: Computer Laboratory
+
+    1. Database Lab [Computer Laboratory] - FINKI-B / Lab 4
+    2. Networking Lab [Computer Laboratory] - FINKI-B / Lab 3
+    3. Programming Lab 1 [Computer Laboratory] - FINKI-B / Lab 1
+    4. Programming Lab 2 [Computer Laboratory] - FINKI-B / Lab 2
+}}}
+
+ 3. The user selects ''View Resource Details'' and picks ''Programming Lab 1''. The system queries upcoming reservations for that resource:
+{{{
+SELECT res.start_time, res.end_time, res.status, res.purpose
+FROM reservations res
+WHERE res.resource_id = 5
+  AND res.status IN ('approved', 'pending')
+  AND res.end_time > CURRENT_TIMESTAMP
+ORDER BY res.start_time;
+}}}
+
+The system displays the resource details and upcoming reservations:
+{{{
+  === Programming Lab 1 ===
+  Type:        Computer Laboratory
+  Description: Computer lab with 25 workstations, Linux/Windows dual boot
+  Location:    FINKI-B / Lab 1
+  Available:   08:00 - 22:00
+  Weekends:    Yes
+
+  Upcoming reservations:
+  Start            | End              | Status   | Purpose
+  -----------------+-----------------+----------+--------
+  2026-02-11 14:00 | 2026-02-11 16:00 | approved | Web Development Lab - Week 2
+  2026-02-18 14:00 | 2026-02-18 16:00 | approved | Web Development Lab - Week 3
+}}}
+
+ 4. The user selects ''Check Availability'' for 2026-02-20 from 14:00 to 16:00. The system checks for conflicts:
+{{{
+SELECT COUNT(*) FROM reservations
+WHERE resource_id = 5
+  AND status IN ('approved', 'pending')
+  AND start_time < '2026-02-20 16:00:00'
+  AND end_time > '2026-02-20 14:00:00';
+}}}
+
+No conflicts found. The system displays the result:
+{{{
+  AVAILABLE: Programming Lab 1 is free on 2026-02-20 from 14:00 to 16:00.
+}}}