Changes between Version 10 and Version 11 of UseCaseModel/ShipmentDetails

Timestamp:

12/28/24 21:29:51 (3 weeks ago)

Author:

153093

Comment:

--

UseCaseModel/ShipmentDetails

@@ -29 +29 @@
     SUM(sl.wine_agreed_price * sl.wine_quantity) AS ShipmentAgreedPrice,
     COALESCE(ex.shipment_expenses, 0) AS ShipmentExpenses,
-    (SUM(sl.wine_agreed_price * sl.wine_quantity) - SUM(sl.wine_base_price * sl.wine_quantity) - COALESCE(ex.shipment_expenses, 0)) AS ShipmentProfit
+    ROUND(
+        (SUM(sl.wine_agreed_price * sl.wine_quantity) - 
+        SUM(sl.wine_base_price * sl.wine_quantity) - 
+        COALESCE(ex.shipment_expenses, 0))::NUMERIC
+    , 2) AS ShipmentProfit
 FROM shipment s
 JOIN payment p ON s.payment_id = p.payment_id
@@ -36 +40 @@
 JOIN shipment_load sl ON s.shipment_id = sl.shipment_id
 LEFT JOIN (SELECT shipment_id, SUM(amount) AS shipment_expenses FROM shipment_has_expense_of_expense_type GROUP BY shipment_id) ex ON s.shipment_id = ex.shipment_id
-WHERE s.shipment_id = 8
+WHERE s.shipment_id = {int.Parse(shipmentId)}
 GROUP BY 
     s.shipment_id,