== 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
}}}