Changes between Initial Version and Version 1 of PlaceOrder

Timestamp:

12/30/25 16:14:38 (14 hours ago)

Author:

235018

Comment:

--

PlaceOrder

@@ +1 @@
+== Placing an Order
+
+==== Actors: **Registered Shopper**
+
+**1.** The user selects products and proceeds to checkout.
+
+**2.** The system checks if the user has a delivery address.
+
+{{{#!sql
+SELECT CASE 
+         WHEN EXISTS (
+             SELECT 1
+             FROM delivery_address
+             WHERE client_ID = '1001'
+         ) THEN 'Yes'
+         ELSE 'No'
+       END AS has_address;
+
+}}}
+
+**3.** If not, the user will need to provide a delivery address.
+
+{{sql#!
+INSERT INTO delivery_address(client_ID, address, city, postcode, country, is_default) VALUES
+('1001', bul.Partizanski Odredi num.52/4' , 'Skopje', '1000', 'Macedonia', TRUE);
+
+}}}
+
+**4.** The application creates a new order in {{{order}}}.
+
+{{{#!sql
+INSERT INTO "order" (order_num, client_ID, last_date_mod, payment_method) VALUES
+('00125100001', 1001, CURRENT_TIMESTAMP,'credit card, **** **** **** 6750');
+
+}}}
+
+**5.** Products are added to the order using {{{includes}}}.
+
+{{{#!sql
+INSERT INTO includes (order_num, product_code)
+VALUES ('00125100001', '00100001');
+
+}}}
+
+**6.** Store employees are nottifed that a new order has been placed and are given the information about the order.