Changes between Version 9 and Version 10 of UseCaseModel/AddingShipment

Timestamp:

12/22/24 22:54:29 (3 weeks ago)

Author:

153093

Comment:

--

UseCaseModel/AddingShipment

@@ -13 +13 @@
 [[Image(Step_1.png)]]
 
+        
+{{{
+select
+        s.shipment_id,
+    s.shipment_date,
+    (
+        SELECT STRING_AGG(DISTINCT c.customer_name, ', ')
+        FROM shipment_load sl
+        JOIN customer c ON sl.customer_id = c.customer_id
+        WHERE sl.shipment_id = s.shipment_id
+    ) AS customer_names,
+    e.employee_name,
+    e.employee_surname,
+    v.make,
+    v.model,
+    v.registration
+FROM shipment s
+JOIN employee e ON s.employee_id = e.employee_id
+JOIN vehicle v ON s.vehicle_id = v.vehicle_id
+ORDER BY s.shipment_date desc
+}}}
+
+
      ==== Чекор 2.
         * Магационерот го клика копчето **Додади достава** над табелата