Changes between Version 26 and Version 27 of UseCaseModel/AddingShipment

Timestamp:

12/22/24 23:27:36 (3 weeks ago)

Author:

153093

Comment:

--

UseCaseModel/AddingShipment

@@ -44 +44 @@
 
 {{{
-select 
+select
+        e.employee_id,
         CONCAT(e.employee_name, ' ', e.employee_surname) AS employee_full_name
 from employee e 
@@ -51 +52 @@
         * Приказ на Возила (повик што се извршува во база само откако ке избереме вработен на формата)
 {{{
-select 
+select
+        v.vehicle_id,
         CONCAT(v.make, ' ', v.model, ' (', v.registration, ')') AS vehicle_info
 from employee_drives_vehicle edv
@@ -59 +61 @@
         * Приказ на Клиенти
 {{{
-select 
+select
+        c.customer_id,
         CONCAT(c.customer_name , ' (', a.city , ' ', a.street ,' ',a.building_number, ' ', a.postcode, ')') AS customer_info
 from customer c
@@ -66 +69 @@
         * Приказ на Вина
 {{{
-select CONCAT(w.wine_name , ' (', wt.wine_type_name,', ', wt.wine_type_region,')') AS wine_info
+select
+         w.wine_id,
+        CONCAT(w.wine_name , ' (', wt.wine_type_name,', ', wt.wine_type_region,')') AS wine_info
 from wine w 
 join wine_type wt on w.wine_type_id = wt.wine_type_id