Changes between Initial Version and Version 1 of ImportatntUseCase004

Timestamp:

02/10/25 11:34:34 (9 months ago)

Author:

221164

Comment:

--

ImportatntUseCase004

@@ +1 @@
+== Employee transfers tab ==
+=== Актери ===
+* Employee
+=== Scenario steps ===
+1. Employee selects a tab order
+2. Employee chooses another front staff to transfer the tab to
+3. Employee transfers tab to selected employee
+
+=== SQL Queries ===
+
+{{{
+SELECT o.id AS order_id, t.table_number 
+FROM tab_orders t
+JOIN orders o ON t.order_id = o.id
+WHERE t.frontstaff_id = 3 -- Current Employee ID
+}}}
+{{{
+SELECT fs.employee_id 
+FROM front_staff fs
+JOIN assignments a ON fs.employee_id = a.employee_id
+JOIN shifts s ON a.shift_id = s.shift_id
+WHERE a.clock_in_time IS NOT NULL  
+AND a.clock_out_time IS NULL       
+AND s.date = CURRENT_DATE       
+AND fs.employee_id != 3          
+LIMIT 1;                           
+}}}
+{{{
+UPDATE tab_orders
+SET frontstaff_id = 5 
+WHERE order_id = 12 
+AND frontstaff_id = 3; 
+}}}