Changes between Version 6 and Version 7 of UseCaseModel/ShipmentDetails

Timestamp:

12/25/24 22:57:38 (3 weeks ago)

Author:

153093

Comment:

--

UseCaseModel/ShipmentDetails

@@ -51 +51 @@
      ==== Чекор 3.
         * Актерот може да кликне и на копчето **Прикажи повеќе детали** при што добиваме специфично кое вино било доставено на кој клиент и нивните цени по единица.
+[[Image(step3.png)]]
+
+{{{
+select 
+        c.customer_name,
+        CONCAT(a.city , ', ', a.street, ', ',a.building_number, ', ', a.postcode) AS customer_address,
+        w.wine_name, 
+        sl.wine_base_price, 
+        sl.wine_agreed_price, 
+        sl.wine_quantity
+from shipment_load sl
+join customer c on sl.customer_id = c.customer_id
+join address a on c.address_id = a.address_id
+join wine w on sl.wine_id = w.wine_id 
+where sl.shipment_id = 5
+{{{