Changes between Version 33 and Version 34 of UseCaseModel/AddingShipment

Timestamp:

12/27/24 22:56:41 (3 weeks ago)

Author:

153093

Comment:

--

UseCaseModel/AddingShipment

@@ -44 +44 @@
 {{{
 select
-        e.employee_id,
-        CONCAT(e.employee_name, ' ', e.employee_surname) AS employee_full_name
-from employee e 
+    e.employee_id as Id,
+    CONCAT(e.employee_name, ' ', e.employee_surname) AS Name
+from employee e
 }}}
 
@@ -52 +52 @@
 {{{
 select
-        v.vehicle_id,
-        CONCAT(v.make, ' ', v.model, ' (', v.registration, ')') AS vehicle_info
+    v.vehicle_id as Id,
+    CONCAT(v.make, ' ', v.model, ' (', v.registration, ')') AS Name,
+    edv.employee_id as EmployeeId,
+    v.capacity as Capacity
 from employee_drives_vehicle edv
-join vehicle v on edv.vehicle_id = v.vehicle_id 
-where edv.employee_id = 1
+join vehicle v on edv.vehicle_id = v.vehicle_id
 }}}
         * Приказ на Клиенти
 {{{
 select
-        c.customer_id,
-        CONCAT(c.customer_name , ' (', a.city , ' ', a.street ,' ',a.building_number, ' ', a.postcode, ')') AS customer_info
+    c.customer_id as Id,
+    CONCAT(c.customer_name , ' (', a.city , ' ', a.street ,' ',a.building_number, ' ', a.postcode, ')') AS Name,
+    CONCAT(a.city ,' ', a.street ,' ',a.building_number,' ', a.postcode) AS Address
 from customer c
 join address a on c.address_id = a.address_id 
@@ -69 +71 @@
 {{{
 select
-         w.wine_id,
-        CONCAT(w.wine_name , ' (', wt.wine_type_name,', ', wt.wine_type_region,')') AS wine_info
-from wine w 
+    w.wine_id as Id,
+    CONCAT(w.wine_name , ' (', wt.wine_type_name,', ', wt.wine_type_region,')') AS Name,
+    w.base_price as BasePrice
+from wine w
 join wine_type wt on w.wine_type_id = wt.wine_type_id 
 }}}