Changes between Version 12 and Version 13 of UseCaseModel/ShipmentDetails
- Timestamp:
- 01/16/25 11:19:47 (6 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCaseModel/ShipmentDetails
v12 v13 22 22 p.payment_status AS PaymentStatus, 23 23 CONCAT(e.employee_name, ' ', e.employee_surname) AS EmployeeFullName, 24 CONCAT(v .make, ' ', v.model, ' (', v.registration, ')') AS VehicleInfo,24 CONCAT(vd.make, ' ', vd.model, ' (', v.registration, ')') AS VehicleInfo, 25 25 TO_CHAR(s.shipment_date, 'DD-MM-YYYY') AS ShipmentDate, 26 26 COUNT(DISTINCT sl.customer_id) AS NumberOfCustomers, … … 38 38 JOIN employee e ON s.employee_id = e.employee_id 39 39 JOIN vehicle v ON s.vehicle_id = v.vehicle_id 40 join vehicle_details vd on vd.vehicle_details_id = v.vehicle_details_id 40 41 JOIN shipment_load sl ON s.shipment_id = sl.shipment_id 41 42 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 42 WHERE s.shipment_id = {int.Parse(shipmentId)}43 WHERE s.shipment_id = 1 43 44 GROUP BY 44 45 s.shipment_id, … … 46 47 e.employee_name, 47 48 e.employee_surname, 48 v .make,49 v .model,49 vd.make, 50 vd.model, 50 51 v.registration, 51 52 s.shipment_date,
