Changes between Initial Version and Version 1 of UseCase14

Timestamp:

05/08/26 03:22:06 (3 hours ago)

Author:

181201

Comment:

--

UseCase14

@@ +1 @@
+== Use-case 0014 - Cancel a Pending Booking
+
+'''Initiating actor:''' Pet Owner
+
+'''Other actors:''' None
+
+'''Description:'''
+An owner decides they no longer need a sitter and cancels a pending booking request before the sitter accepts it or before payment is made.
+
+'''Scenario:'''
+ 1. Pet Owner navigates to their "My Bookings" page.
+ 2. System fetches the owner's current pending bookings:
+{{{
+#!sql
+SELECT booking_id, date_from, address, status 
+FROM bookings 
+WHERE owner_id = (SELECT user_id FROM users WHERE username = 'owner_bojan')
+  AND status = 'PENDING';
+}}}
+ 3. Owner clicks the "Cancel Request" button.
+ 4. System updates the booking status:
+{{{
+#!sql
+UPDATE bookings
+SET status = 'CANCELLED'
+WHERE booking_id = (
+    SELECT booking_id FROM bookings 
+    WHERE status = 'PENDING' 
+      AND owner_id = (SELECT user_id FROM users WHERE username = 'owner_bojan') 
+    LIMIT 1
+);
+}}}