Changes between Version 31 and Version 32 of UseCaseModel/AddingShipment

Timestamp:

12/23/24 00:07:52 (3 weeks ago)

Author:

153093

Comment:

--

UseCaseModel/AddingShipment

@@ -84 +84 @@
 
      - Успешно додавање на достава
+     - Додаваме плаќање, достава и товар по редослед.
+{{{
+BEGIN;
+
+INSERT INTO public.Payment (Payment_Id, Payment_Status)
+VALUES
+    (15, 0);
+
+INSERT INTO public.Shipment (Shipment_Id, Employee_Id, Payment_Id, Vehicle_Id, Shipment_Date)
+VALUES
+    (15, 1, 15, 1, now());
+
+INSERT INTO public.shipment_load (Shipment_Id, Customer_Id, Wine_Id, Wine_Agreed_Price, Wine_Base_Price, Wine_Quantity)
+VALUES
+    (15, 1, 1, 150, 50, 20),
+    (15, 1, 2, 90, 80, 50),
+    (15, 2, 2, 100, 80, 50);
+
+COMMIT;
+}}}