-- Insert main workflow
INSERT INTO Workflows (Name, Phase)
VALUES ('RecruitmentWorkflow', 'HireToRetire');

DECLARE @WorkflowID INT = SCOPE_IDENTITY();

-- Step 1: Define Job Role
INSERT INTO Steps (WorkflowID, StepName, Sequence, OutputKey)
VALUES (@WorkflowID, 'Define Job Role', 1, 'JobID_1234');

DECLARE @Step1ID INT = SCOPE_IDENTITY();

INSERT INTO InputParameters (StepID, ParamName, ParamValue, IsList)
VALUES 
(@Step1ID, 'title', 'Software Developer', 0),
(@Step1ID, 'experience', '3-5 years', 0),
(@Step1ID, 'skills', 'JavaScript,SQL Server,Node-RED', 1),
(@Step1ID, 'location', 'Vadodara, Gujarat', 0),
(@Step1ID, 'budget', '8-10 LPA', 0);

-- Step 2: AI Screening
INSERT INTO Steps (WorkflowID, StepName, Sequence, Agent)
VALUES (@WorkflowID, 'AI Screening', 2, 'ResumeAnalyzerBot');

DECLARE @Step2ID INT = SCOPE_IDENTITY();

INSERT INTO InputParameters (StepID, ParamName, ParamValue, IsList)
VALUES (@Step2ID, 'input', 'JobID_1234', 0);

INSERT INTO Actions (StepID, ActionName, ActionValue, ActionType)
VALUES 
(@Step2ID, 'parse_resumes', 'true', 'BOOLEAN'),
(@Step2ID, 'match_score_threshold', '75', 'NUMBER'),
(@Step2ID, 'shortlist_candidates', 'true', 'BOOLEAN');

-- Step 3: Candidate Engagement
INSERT INTO Steps (WorkflowID, StepName, Sequence, Agent)
VALUES (@WorkflowID, 'Candidate Engagement', 3, 'EngagementBot');

DECLARE @Step3ID INT = SCOPE_IDENTITY();

INSERT INTO StepChannels (StepID, ChannelName)
VALUES 
(@Step3ID, 'Email'),
(@Step3ID, 'WhatsApp');

INSERT INTO Actions (StepID, ActionName, ActionValue, ActionType)
VALUES 
(@Step3ID, 'send_assessment_links', 'true', 'BOOLEAN'),
(@Step3ID, 'capture_responses', 'true', 'BOOLEAN'),
(@Step3ID, 'update_dashboard', 'RealTime', 'STRING');

-- Step 4: Interview Coordination
INSERT INTO Steps (WorkflowID, StepName, Sequence, Agent)
VALUES (@WorkflowID, 'Interview Coordination', 4, 'InterviewBot');

DECLARE @Step4ID INT = SCOPE_IDENTITY();

INSERT INTO Scheduling (StepID, Mode, Notifications)
VALUES (@Step4ID, 'Auto', 1);

INSERT INTO StepTools (StepID, ToolName)
VALUES 
(@Step4ID, 'Google Meet'),
(@Step4ID, 'Calendly');

-- Step 5: Final Selection
INSERT INTO Steps (WorkflowID, StepName, Sequence)
VALUES (@WorkflowID, 'Final Selection', 5);

DECLARE @Step5ID INT = SCOPE_IDENTITY();

INSERT INTO Actions (StepID, ActionName, ActionValue, ActionType)
VALUES 
(@Step5ID, 'shortlist_final', 'true', 'BOOLEAN'),
(@Step5ID, 'approval_workflow', 'AutoNotifyHR', 'STRING'),
(@Step5ID, 'background_check', 'Initiate', 'STRING');

-- Step 6: Onboarding
INSERT INTO Steps (WorkflowID, StepName, Sequence)
VALUES (@WorkflowID, 'Onboarding', 6);

DECLARE @Step6ID INT = SCOPE_IDENTITY();

INSERT INTO StepTools (StepID, ToolName)
VALUES 
(@Step6ID, 'DocuSign'),
(@Step6ID, 'Internal Portal');

INSERT INTO Actions (StepID, ActionName, ActionValue, ActionType)
VALUES 
(@Step6ID, 'generate_offer_letter', 'true', 'BOOLEAN'),
(@Step6ID, 'assign_training_modules', 'true', 'BOOLEAN'),
(@Step6ID, 'add_to_employee_registry', 'true', 'BOOLEAN');