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