


-- Insert dummy projects
INSERT INTO `projects` (`project_name`, `description`, `status`, `created_by`) VALUES
('Tax Preparation 2024', 'Prepare and file 2024 taxes for Smith Corp.', 'in_progress', 1),
('Audit Service - Jones Co.', 'Conduct annual audit for Jones Company.', 'planning', 1),
('Monthly Bookkeeping - ABC Corp', 'Provide monthly bookkeeping services for ABC Corp.', 'in_progress', 2),
('Year-End Financials - XYZ Ltd', 'Prepare year-end financial statements for XYZ Ltd.', 'planning', 2);

-- Insert dummy jobs for Tax Preparation 2024
INSERT INTO `jobs` (`job_unique_id`, `title`, `project_id`, `client_company_name`, `price`, `due_date`, `status`, `agent_id`, `account_manager_id`) VALUES
('TP24-JOB-001', 'Individual Tax Return', 1, 'Smith Corp', 500.00, '2025-04-15', 'draft', 5, 3),
('TP24-JOB-002', 'Corporate Tax Return', 1, 'Smith Corp', 1500.00, '2025-03-15', 'draft', 6, 3);

-- Insert dummy jobs for Audit Service - Jones Co.
INSERT INTO `jobs` (`job_unique_id`, `title`, `project_id`, `client_company_name`, `price`, `due_date`, `status`, `agent_id`, `account_manager_id`) VALUES
('ASJC-JOB-001', 'Financial Audit', 2, 'Jones Co.', 10000.00, '2025-06-30', 'planning', 5, 3);

-- Insert dummy jobs for Monthly Bookkeeping - ABC Corp
INSERT INTO `jobs` (`job_unique_id`, `title`, `project_id`, `client_company_name`, `price`, `due_date`, `status`, `agent_id`, `account_manager_id`) VALUES
('MB-JOB-001', 'Monthly Reconciliation', 3, 'ABC Corp', 1200.00, '2024-12-31', 'approved', 6, 4),
('MB-JOB-002', 'Accounts Payable', 3, 'ABC Corp', 800.00, '2025-01-15', 'assigned', 6, 4),
('MB-JOB-003', 'Accounts Receivable', 3, 'ABC Corp', 900.00, '2025-01-31', 'draft', 7, 4);

-- Insert dummy jobs for Year-End Financials - XYZ Ltd
INSERT INTO `jobs` (`job_unique_id`, `title`, `project_id`, `client_company_name`, `price`, `due_date`, `status`, `agent_id`, `account_manager_id`) VALUES
('YE-JOB-001', 'Balance Sheet Prep', 4, 'XYZ Ltd', 3000.00, '2025-02-28', 'draft', 6, 4),
('YE-JOB-002', 'Income Statement Prep', 4, 'XYZ Ltd', 2500.00, '2025-03-15', 'draft', 7, 4),
('YE-JOB-003', 'Cash Flow Statement Prep', 4, 'XYZ Ltd', 2000.00, '2025-03-31', 'draft', 7, 4);

INSERT INTO `project_assignments` (`project_id`, `user_id`, `role`) VALUES
(1, 3, 'manager'),
(2, 3, 'manager'),
(3, 4, 'manager'),
(4, 4, 'manager'),
(1, 5, 'agent'),
(1, 6, 'agent'),
(2, 5, 'agent'),
(2, 6, 'agent'),
(3, 6, 'agent'),
(3, 7, 'agent'),
(4, 6, 'agent'),
(4, 7, 'agent'),
(1, 8, 'vendor'),
(1, 9, 'vendor'),
(1, 10, 'vendor'),
(2, 8, 'vendor'),
(2, 9, 'vendor'),
(2, 10, 'vendor'),
(3, 8, 'vendor'),
(3, 9, 'vendor'),
(3, 10, 'vendor'),
(4, 8, 'vendor'),
(4, 9, 'vendor'),
(4, 10, 'vendor');
