Changes between Version 32 and Version 33 of UseCaseModel/AddingShipment
- Timestamp:
- 12/27/24 22:10:08 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCaseModel/AddingShipment
v32 v33 16 16 {{{ 17 17 select 18 s.shipment_id,19 s.shipment_date,18 s.shipment_id as ShipmentId, 19 TO_CHAR(s.shipment_date, 'DD-MM-YYYY') as ShipmentDate, 20 20 ( 21 21 SELECT STRING_AGG(DISTINCT c.customer_name, ', ') … … 23 23 JOIN customer c ON sl.customer_id = c.customer_id 24 24 WHERE sl.shipment_id = s.shipment_id 25 ) AS customer_names,26 CONCAT(e.employee_name, ' ', e.employee_surname) AS employee_full_name,27 CONCAT(v.make, ' ', v.model, ' (', v.registration, ')') AS vehicle_info25 ) as Customers, 26 CONCAT(e.employee_name, ' ', e.employee_surname) AS EmployeeFullName, 27 CONCAT(v.make, ' ', v.model, ' (', v.registration, ')') AS VehicleInfo 28 28 FROM shipment s 29 29 JOIN employee e ON s.employee_id = e.employee_id 30 30 JOIN vehicle v ON s.vehicle_id = v.vehicle_id 31 ORDER BY s.shipment_date desc 31 ORDER BY s.shipment_date desc"; 32 32 }}} 33 33