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.

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.

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.

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.