-- Phase 11: recall settings + WhatsApp template records.
-- Import after diabeasy_schema.sql.

INSERT INTO settings (setting_key, setting_value, value_type, group_name, is_secret) VALUES
('recalls_enabled','1','bool','recalls',0),
('recall_daily_cap','200','int','recalls',0),
('recall_template_name','care_gap_due','string','recalls',0)
ON DUPLICATE KEY UPDATE setting_key = setting_key;

-- These must ALSO be created and approved inside Meta Business Manager.
-- This table only records what we believe exists; Meta is the source of truth.
INSERT INTO wa_templates (name, language, category, purpose, body_preview, variables, status) VALUES
('care_gap_due','en','utility','recall_due',
 'Hello 👋 A quick reminder from Diabeasy.\n\n{{1}} {{2}} looks due.\n\nRegular checks catch problems early, while they are still easy to treat.\n\nSend the report here any time and we will explain it in plain language — free.',
 '["who (e.g. your / Ramesh''s)","test name"]','pending'),

('care_gap_due','hi','utility','recall_due',
 'नमस्ते 👋 Diabeasy की ओर से एक याद दिलाना।\n\n{{1}} {{2}} का समय आ गया है।\n\nसमय पर जाँच से दिक्कत जल्दी पकड़ में आती है, जब इलाज आसान होता है।\n\nरिपोर्ट यहीं भेज दीजिए — हम आसान भाषा में समझा देंगे, मुफ़्त।',
 '["किसका","जाँच का नाम"]','pending'),

('report_ready','en','utility','report_ready',
 'Your report summary is ready, {{1}}. Opening this chat will show it.',
 '["first name"]','pending'),

('first_report_nudge','en','marketing','activation',
 'Hello {{1}} 👋 You signed up with Diabeasy but have not sent a report yet.\n\nSend a photo of any lab report — even an old one — and we will explain every number on it, free.',
 '["first name"]','pending')
ON DUPLICATE KEY UPDATE name = name;