Changes between Version 32 and Version 33 of UseCaseModel/AddingShipment


Ignore:
Timestamp:
12/27/24 22:10:08 (3 weeks ago)
Author:
153093
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCaseModel/AddingShipment

    v32 v33  
    1616{{{
    1717select
    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,
    2020    (
    2121        SELECT STRING_AGG(DISTINCT c.customer_name, ', ')
     
    2323        JOIN customer c ON sl.customer_id = c.customer_id
    2424        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_info
     25    ) as Customers,
     26    CONCAT(e.employee_name, ' ', e.employee_surname) AS EmployeeFullName,
     27    CONCAT(v.make, ' ', v.model, ' (', v.registration, ')') AS VehicleInfo
    2828FROM shipment s
    2929JOIN employee e ON s.employee_id = e.employee_id
    3030JOIN vehicle v ON s.vehicle_id = v.vehicle_id
    31 ORDER BY s.shipment_date desc
     31ORDER BY s.shipment_date desc";
    3232}}}
    3333