Changes between Initial Version and Version 1 of ImportatntUseCase003

Timestamp:

02/10/25 11:45:34 (9 months ago)

Author:

221128

Comment:

--

ImportatntUseCase003

@@ +1 @@
+== EMPLOYEE MANAGES ORDER ==
+=== Actors ===
+* Employee
+=== Steps in the Scenario ===
+**__1. Employee opens tab.__**
+
+SELECT p.name, p.price, oi.quantity
+FROM order_items oi
+JOIN products p ON p.id = oi.product_id
+WHERE oi.order_id = 1;
+
+**__2. Employee adds order items.__**
+
+INSERT INTO order_items(id, order_id, product_id, is_processed, quantity)
+VALUES (7,1,1,false,1);
+INSERT INTO order_items(id ,order_id, product_id, is_processed, quantity)
+VALUES (8,1,2,false,1);
+
+**__3. Employee marks order items as processed.__**
+
+UPDATE order_items SET is_processed=true WHERE id=7;
+UPDATE order_items SET is_processed=true WHERE id=8;
+
+**__4. Employee closes tab.__**
+
+**__5. System prints bil.__**
+
+UPDATE orders SET status='CONFIRMED' WHERE id=1;
+
+**__6. Employee finalizes payment.__**
+
+INSERT INTO payments(id, order_id, amount, payment_type, tip_amount)
+SELECT 3,1, SUM(oi.price), ‘cash’, 0 FROM order_items oi WHERE oi.order_id = 1