-- Insert sample companies
INSERT INTO company (company_code, company_cin, company_headoffice, company_gstin, company_name, company_desc) VALUES
('ZEN', 'CIN001', 'Jamshedpur', 'GSTIN001', 'Zenuino', 'Company');

-- Insert sample master employees
INSERT INTO master (company_code, first_name, middle_name, last_name, preferred_name, email, contact_number, date_of_birth, hire_date, salary, is_admin, is_active) VALUES
('ZEN', 'Palak', null, 'Parhawk', null, 'parhawkp@gmail.com', '8789300129', '2000-01-01', '2020-01-01', 24000.00, 0, 1),
('ZEN', 'Jayesh', NULL, 'Taunk', NULL, 'jayesh.taunk@zenuino.in', '9334808093', '1992-02-02', '2019-02-02', 60000.00, 1, 1),
('ZEN', 'Alok', NULL, 'Kumar', NULL, 'alokkumar@zenuino.in', '9204058219', '1991-02-02', '2019-02-02', 60000.00, 1, 1),
('ZEN', 'Bhupesh', NULL, 'Kumar', NULL, 'bhupesh@zenuino.in', '7763807675', '1992-02-02', '2019-02-02', 60000.00, 1, 1),
('ZEN', 'Amit', 'Roy', 'Chowdhury', NULL, 'amitrc@zenuino.in', '9204058075', '1991-02-02', '2019-02-02', 60000.00, 1, 1),
('ZEN', 'Niranjan', NULL, 'Pandey', NULL, 'niranjan@zenuino.in', '9835121088', '1991-02-02', '2019-02-02', 60000.00, 1, 1);

-- Insert sample PO
INSERT INTO PO (date, expiry_date, value, active) VALUES
('2023-01-01', '2023-12-31', 100000.00, 1),
('2023-06-01', '2024-05-31', 200000.00, 1);

-- Insert sample PO_Task
INSERT INTO PO_Task (task_name, task_desc, task_hrs, active) VALUES
('Site Survey', 'Survey the site', 8.00, 1),
('Installation', 'Install equipment', 16.00, 1),
('Meeting', 'Conduct meetings', 1.00, 1),
('Maintenance', 'Ensure product is working', 2.00, 1);

-- Insert sample Location
INSERT INTO Location (loc_name) VALUES
('Jamshedpur Branch'),
('Ranchi Branch');

-- Insert sample PO_loc
INSERT INTO PO_loc (PO_id, loc_id) VALUES
(1, 1),
(2, 2);

-- Insert sample Emp_PO
INSERT INTO Emp_PO (employee_id, PO_id, date) VALUES
(1, 1, '2023-01-01'),
(2, 2, '2023-06-01'),
(3, 2, '2023-06-01'),
(4, 1, '2023-06-01'),
(5, 1, '2023-06-01'),
(6, 2, '2023-06-01');

-- Insert sample Emp_PO_Task_Loc
INSERT INTO Emp_PO_Task_Loc (employee_id, PO_id, task_id, PO_loc_id, assigned_at) VALUES
(1, 1, 1, 1, '2023-01-02 09:00:00'),
(2, 2, 2, 2, '2023-06-02 10:00:00'),
(3, 2, 3, 2, '2023-06-02 10:00:00'),
(4, 1, 3, 1, '2023-06-02 10:00:00'),
(5, 1, 2, 1, '2023-06-02 10:00:00'),
(6, 2, 3, 2, '2023-06-02 10:00:00');