Changes between Initial Version and Version 1 of ImportatntUseCase005

Timestamp:

02/10/25 11:43:08 (9 months ago)

Author:

221164

Comment:

--

ImportatntUseCase005

@@ +1 @@
+== Customer makes order ==
+=== Актери ===
+* Customer
+=== Scenario steps ===
+1. Customer logs in
+2. Customer browses menu
+3. Customer adds items to order
+4. Customer enters delivery details
+5. Customer pays and submits order
+6. Employee accepts orders
+7. Employee prepares and ships order
+
+=== SQL Queries ===
+
+{{{
+SELECT user FROM users where email ='test2@hotmail.com' -- and password application check
+}}}
+{{{
+SELECT name, price, id FROM products;                 
+}}}
+{{{
+INSERT INTO orders(id)
+VALUES (4);
+INSERT INTO online_orders(order_id,delivery_address,customer_id)
+VALUES (4,'Mladinska 2', 2);
+INSERT INTO order_items( order_id, product_id, is_processed, price, quantity)
+SELECT 4,1,true, price, 3 FROM products WHERE id=1;
+}}}
+{{{
+INSERT INTO order_items( order_id, product_id, is_processed, quantity)
+VALUES (4,2,true,1);
+}}}
+{{{
+INSERT INTO payments(id, order_id, amount, payment_type, tip_amount)
+VALUES (2,4,550, ‘card’, 0);
+UPDATE orders SET status=’PLACED’ WHERE id=4;
+}}}
+{{{
+SELECT 
+    o.id AS order_id,
+    o.status,
+    oo.delivery_address,
+    u.name AS customer_name,
+    oi.product_id,
+    p.name AS product_name,
+    oi.is_processed,
+    oi.price,
+    oi.quantity,
+    pm.amount AS payment_amount,
+    pm.payment_type,
+    pm.tip_amount
+FROM orders o
+JOIN online_orders oo ON o.id = oo.order_id
+JOIN users u ON oo.customer_id = u.id
+JOIN order_items oi ON o.id = oi.order_id
+JOIN products p ON oi.product_id = p.id
+LEFT JOIN payments pm ON o.id = pm.order_id
+WHERE o.id = 4;
+
+UPDATE orders SET status='CONFIRMED' WHERE id=4;
+}}}