-- Roster Demo Data
-- Insert shift templates with org_id and branch_id
INSERT INTO shifts (shift_id, name, start_time, end_time, overtime_cap, branch_id, org_id) VALUES 
('0194a8b2-5000-7123-8123-123456789ac1', 'Morning Shift', '08:00:00', '16:00:00', 2.00, '019a9524-320c-7b14-9a28-9ae6298e756d', '0194a8b2-1234-7123-8123-123456789abc'),
('0194a8b2-5001-7123-8123-123456789ac1', 'Afternoon Shift', '16:00:00', '00:00:00', 2.00, '019a9524-320c-7b14-9a28-9ae6298e756d', '0194a8b2-1234-7123-8123-123456789abc'),
('0194a8b2-5002-7123-8123-123456789ac1', 'Night Shift', '00:00:00', '08:00:00', 2.00, '019a9524-320d-72d9-afa7-167b5626d10f', '0194a8b2-1234-7123-8123-123456789abc'),
('0194a8b2-5003-7123-8123-123456789ac1', 'Remote Morning', '09:00:00', '17:00:00', 1.00, '019a9524-320c-7b14-9a28-9ae6298e756d', '0194a8b2-1234-7123-8123-123456789abc'),
('0194a8b2-5004-7123-8123-123456789ac1', 'Field Work', '07:00:00', '15:00:00', 3.00, '019a9524-320d-79f4-999c-2738fc4c1010', '0194a8b2-1234-7123-8123-123456789abc'),
('0194a8b2-5005-7123-8123-123456789ac1', 'Weekend Shift', '10:00:00', '18:00:00', 4.00, '019a9524-320d-72d9-afa7-167b5626d10f', '0194a8b2-1234-7123-8123-123456789abc')
ON CONFLICT (shift_id) DO NOTHING;

-- Insert employee shift assignments for this week
-- Monday - Admin (Main Branch Morning)
INSERT INTO employee_shifts (employee_shift_id, employee_id, shift_id, org_id, shift_date, start_time, end_time) VALUES 
('0194a8b2-6000-7123-8123-123456789ac1', '0194a8b2-1111-7123-8123-123456789ac0', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE, '08:00:00', '16:00:00'),

-- Tuesday - Admin (Main Branch Morning)
('0194a8b2-6001-7123-8123-123456789ac1', '0194a8b2-1111-7123-8123-123456789ac0', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 1, '08:00:00', '16:00:00'),

-- Wednesday - Admin (Remote Morning)
('0194a8b2-6002-7123-8123-123456789ac1', '0194a8b2-1111-7123-8123-123456789ac0', '0194a8b2-5003-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 2, '09:00:00', '17:00:00'),

-- Thursday - Admin (Main Branch Morning)
('0194a8b2-6003-7123-8123-123456789ac1', '0194a8b2-1111-7123-8123-123456789ac0', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 3, '08:00:00', '16:00:00'),

-- Friday - Admin (Field Work at Warehouse)
('0194a8b2-6004-7123-8123-123456789ac1', '0194a8b2-1111-7123-8123-123456789ac0', '0194a8b2-5004-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 4, '07:00:00', '15:00:00'),

-- Saturday - Admin (Weekend Shift at Retail Store)
('0194a8b2-6005-7123-8123-123456789ac1', '0194a8b2-1111-7123-8123-123456789ac0', '0194a8b2-5005-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 5, '10:00:00', '18:00:00')

ON CONFLICT (employee_shift_id) DO NOTHING;

-- Add shifts for all other employees across the week (2-3 people per shift)
INSERT INTO employee_shifts (employee_shift_id, employee_id, shift_id, org_id, shift_date, start_time, end_time) VALUES 
-- MONDAY shifts (multiple people per shift)
-- Morning Shift (Admin + Kevin + Bhaskaran)
('0194a8b2-6010-7123-8123-123456789ac1', '0194a8b2-5003-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE, '08:00:00', '16:00:00'), -- Kevin - Morning
('0194a8b2-6011-7123-8123-123456789ac1', '0194a8b2-4451-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE, '08:00:00', '16:00:00'), -- Bhaskaran - Morning
-- Afternoon Shift (Michael + Lisa)
('0194a8b2-6012-7123-8123-123456789ac1', '0194a8b2-5002-7123-8123-123456789ac3', '0194a8b2-5001-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE, '16:00:00', '00:00:00'), -- Michael - Afternoon
('0194a8b2-6013-7123-8123-123456789ac1', '0194a8b2-5005-7123-8123-123456789ac3', '0194a8b2-5001-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE, '16:00:00', '00:00:00'), -- Lisa - Afternoon
-- Night Shift (David + Kevin doing double shift)
('0194a8b2-6014-7123-8123-123456789ac1', '0194a8b2-5004-7123-8123-123456789ac3', '0194a8b2-5002-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE, '00:00:00', '08:00:00'), -- David - Night
('0194a8b2-6015-7123-8123-123456789ac1', '0194a8b2-5003-7123-8123-123456789ac3', '0194a8b2-5002-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE, '00:00:00', '08:00:00'), -- Kevin - Night (double shift)

-- TUESDAY shifts (multiple people per shift)
-- Morning Shift (Admin + Bhaskaran + Lisa)
('0194a8b2-6020-7123-8123-123456789ac1', '0194a8b2-4451-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 1, '08:00:00', '16:00:00'), -- Bhaskaran - Morning
('0194a8b2-6021-7123-8123-123456789ac1', '0194a8b2-5005-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 1, '08:00:00', '16:00:00'), -- Lisa - Morning
-- Remote Morning (David + Kevin)
('0194a8b2-6022-7123-8123-123456789ac1', '0194a8b2-5004-7123-8123-123456789ac3', '0194a8b2-5003-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 1, '09:00:00', '17:00:00'), -- David - Remote
('0194a8b2-6023-7123-8123-123456789ac1', '0194a8b2-5003-7123-8123-123456789ac3', '0194a8b2-5003-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 1, '09:00:00', '17:00:00'), -- Kevin - Remote
-- Afternoon Shift (Michael + Bhaskaran double shift)
('0194a8b2-6024-7123-8123-123456789ac1', '0194a8b2-5002-7123-8123-123456789ac3', '0194a8b2-5001-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 1, '16:00:00', '00:00:00'), -- Michael - Afternoon
('0194a8b2-6025-7123-8123-123456789ac1', '0194a8b2-4451-7123-8123-123456789ac3', '0194a8b2-5001-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 1, '16:00:00', '00:00:00'), -- Bhaskaran - Afternoon (double shift)

-- WEDNESDAY shifts (multiple people per shift)
-- Morning Shift (Admin + Michael + David)
('0194a8b2-6030-7123-8123-123456789ac1', '0194a8b2-5002-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 2, '08:00:00', '16:00:00'), -- Michael - Morning
('0194a8b2-6031-7123-8123-123456789ac1', '0194a8b2-5004-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 2, '08:00:00', '16:00:00'), -- David - Morning
-- Field Work (Kevin + Bhaskaran + Lisa)
('0194a8b2-6032-7123-8123-123456789ac1', '0194a8b2-5003-7123-8123-123456789ac3', '0194a8b2-5004-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 2, '07:00:00', '15:00:00'), -- Kevin - Field Work
('0194a8b2-6033-7123-8123-123456789ac1', '0194a8b2-4451-7123-8123-123456789ac3', '0194a8b2-5004-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 2, '07:00:00', '15:00:00'), -- Bhaskaran - Field Work
('0194a8b2-6034-7123-8123-123456789ac1', '0194a8b2-5005-7123-8123-123456789ac3', '0194a8b2-5004-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 2, '07:00:00', '15:00:00'), -- Lisa - Field Work
-- Afternoon Shift (Michael + David double shifts)
('0194a8b2-6035-7123-8123-123456789ac1', '0194a8b2-5002-7123-8123-123456789ac3', '0194a8b2-5001-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 2, '16:00:00', '00:00:00'), -- Michael - Afternoon (double shift)
('0194a8b2-6036-7123-8123-123456789ac1', '0194a8b2-5004-7123-8123-123456789ac3', '0194a8b2-5001-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 2, '16:00:00', '00:00:00'), -- David - Afternoon (double shift)

-- THURSDAY shifts (multiple people per shift)
-- Morning Shift (Admin + Lisa + Kevin)
('0194a8b2-6040-7123-8123-123456789ac1', '0194a8b2-5005-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 3, '08:00:00', '16:00:00'), -- Lisa - Morning
('0194a8b2-6041-7123-8123-123456789ac1', '0194a8b2-5003-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 3, '08:00:00', '16:00:00'), -- Kevin - Morning
-- Remote Morning (Bhaskaran + Michael + David)
('0194a8b2-6042-7123-8123-123456789ac1', '0194a8b2-4451-7123-8123-123456789ac3', '0194a8b2-5003-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 3, '09:00:00', '17:00:00'), -- Bhaskaran - Remote
('0194a8b2-6043-7123-8123-123456789ac1', '0194a8b2-5002-7123-8123-123456789ac3', '0194a8b2-5003-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 3, '09:00:00', '17:00:00'), -- Michael - Remote
('0194a8b2-6044-7123-8123-123456789ac1', '0194a8b2-5004-7123-8123-123456789ac3', '0194a8b2-5003-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 3, '09:00:00', '17:00:00'), -- David - Remote
-- Night Shift (Lisa + Kevin double shifts)
('0194a8b2-6045-7123-8123-123456789ac1', '0194a8b2-5005-7123-8123-123456789ac3', '0194a8b2-5002-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 3, '00:00:00', '08:00:00'), -- Lisa - Night (double shift)
('0194a8b2-6046-7123-8123-123456789ac1', '0194a8b2-5003-7123-8123-123456789ac3', '0194a8b2-5002-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 3, '00:00:00', '08:00:00'), -- Kevin - Night (double shift)

-- FRIDAY shifts (multiple people per shift)
-- Morning Shift (Admin + Bhaskaran + Michael)
('0194a8b2-6050-7123-8123-123456789ac1', '0194a8b2-4451-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 4, '08:00:00', '16:00:00'), -- Bhaskaran - Morning
('0194a8b2-6051-7123-8123-123456789ac1', '0194a8b2-5002-7123-8123-123456789ac3', '0194a8b2-5000-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 4, '08:00:00', '16:00:00'), -- Michael - Morning
-- Field Work (Kevin + David + Lisa)
('0194a8b2-6052-7123-8123-123456789ac1', '0194a8b2-5003-7123-8123-123456789ac3', '0194a8b2-5004-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 4, '07:00:00', '15:00:00'), -- Kevin - Field Work
('0194a8b2-6053-7123-8123-123456789ac1', '0194a8b2-5004-7123-8123-123456789ac3', '0194a8b2-5004-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 4, '07:00:00', '15:00:00'), -- David - Field Work
('0194a8b2-6054-7123-8123-123456789ac1', '0194a8b2-5005-7123-8123-123456789ac3', '0194a8b2-5004-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 4, '07:00:00', '15:00:00'), -- Lisa - Field Work
-- Afternoon Shift (Bhaskaran + Michael double shifts)
('0194a8b2-6055-7123-8123-123456789ac1', '0194a8b2-4451-7123-8123-123456789ac3', '0194a8b2-5001-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 4, '16:00:00', '00:00:00'), -- Bhaskaran - Afternoon (double shift)
('0194a8b2-6056-7123-8123-123456789ac1', '0194a8b2-5002-7123-8123-123456789ac3', '0194a8b2-5001-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 4, '16:00:00', '00:00:00'), -- Michael - Afternoon (double shift)

-- SATURDAY shifts (multiple people per shift)
-- Weekend Shift (Admin + David + Lisa + Kevin + Bhaskaran)
('0194a8b2-6060-7123-8123-123456789ac1', '0194a8b2-5004-7123-8123-123456789ac3', '0194a8b2-5005-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 5, '10:00:00', '18:00:00'), -- David - Weekend
('0194a8b2-6061-7123-8123-123456789ac1', '0194a8b2-5005-7123-8123-123456789ac3', '0194a8b2-5005-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 5, '10:00:00', '18:00:00'), -- Lisa - Weekend
('0194a8b2-6062-7123-8123-123456789ac1', '0194a8b2-5003-7123-8123-123456789ac3', '0194a8b2-5005-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 5, '10:00:00', '18:00:00'), -- Kevin - Weekend
('0194a8b2-6063-7123-8123-123456789ac1', '0194a8b2-4451-7123-8123-123456789ac3', '0194a8b2-5005-7123-8123-123456789ac1', '0194a8b2-1234-7123-8123-123456789abc', CURRENT_DATE + 5, '10:00:00', '18:00:00') -- Bhaskaran - Weekend

ON CONFLICT (employee_shift_id) DO NOTHING;