-- ============================================================================
-- MergenFlow Initial Seed Data
-- ============================================================================

-- 1. Subscription Plans
INSERT INTO `subscription_plans` (`id`, `name`, `slug`, `monthly_email_quota`, `monthly_whatsapp_quota`, `max_stores`, `max_team_members`, `max_automations`, `price_monthly`, `price_yearly`, `is_active`)
VALUES 
(1, 'Başlangıç', 'starter', 1000, 100, 1, 2, 3, 299.00, 2990.00, 1),
(2, 'Büyüme', 'growth', 10000, 1000, 3, 5, 15, 899.00, 8990.00, 1),
(3, 'Kurumsal', 'enterprise', 50000, 5000, 10, 20, 50, 2499.00, 24990.00, 1)
ON DUPLICATE KEY UPDATE `name`=VALUES(`name`);

-- 2. Super Administrator (admin@mergensoft.net / MergenFlow2026!)
INSERT INTO `users` (`id`, `email`, `password_hash`, `first_name`, `last_name`, `phone`, `is_super_admin`, `status`)
VALUES 
(1, 'admin@mergensoft.net', '$2y$10$tw.ukTWSF2gVCmBnDAAQa.cO2AwNb6H1E1VJBC8etN1nJrzWNZjnq', 'Mergen', 'Yönetici', '+905550000000', 1, 'active')
ON DUPLICATE KEY UPDATE `first_name`=VALUES(`first_name`);

-- 3. Demo Tenant
INSERT INTO `tenants` (`id`, `name`, `subdomain`, `company_title`, `tax_number`, `phone`, `status`)
VALUES 
('tn_demo_mergen01', 'Mergen Mağaza', 'demo', 'Mergen Teknoloji A.Ş.', '1234567890', '+908501234567', 'active')
ON DUPLICATE KEY UPDATE `name`=VALUES(`name`);

-- 4. Tenant Owner User (demo@mergenflow.com / MergenFlow2026!)
INSERT INTO `users` (`id`, `email`, `password_hash`, `first_name`, `last_name`, `phone`, `is_super_admin`, `status`)
VALUES 
(2, 'demo@mergenflow.com', '$2y$10$tw.ukTWSF2gVCmBnDAAQa.cO2AwNb6H1E1VJBC8etN1nJrzWNZjnq', 'Alperen', 'Müşteri', '+905321112233', 0, 'active')
ON DUPLICATE KEY UPDATE `first_name`=VALUES(`first_name`);

-- 5. Tenant User Relation
INSERT INTO `tenant_users` (`tenant_id`, `user_id`, `role`, `status`)
VALUES 
('tn_demo_mergen01', 2, 'owner', 'active')
ON DUPLICATE KEY UPDATE `role`=VALUES(`role`);

-- 6. Demo Subscription
INSERT INTO `subscriptions` (`tenant_id`, `plan_id`, `status`, `current_period_start`, `current_period_end`)
VALUES 
('tn_demo_mergen01', 2, 'active', CURDATE(), DATE_ADD(CURDATE(), INTERVAL 1 YEAR))
ON DUPLICATE KEY UPDATE `status`=VALUES(`status`);

-- 7. Demo Usage Record
INSERT INTO `usage_records` (`tenant_id`, `billing_period`, `emails_sent`, `whatsapp_sent`)
VALUES 
('tn_demo_mergen01', DATE_FORMAT(NOW(), '%Y-%m'), 142, 38)
ON DUPLICATE KEY UPDATE `emails_sent`=VALUES(`emails_sent`);

-- 8. Demo Store
INSERT INTO `stores` (`id`, `tenant_id`, `platform`, `name`, `domain`, `status`, `last_sync_at`)
VALUES 
(1, 'tn_demo_mergen01', 'shopify', 'Mergen Butik', 'mergenbutik.myshopify.com', 'connected', NOW())
ON DUPLICATE KEY UPDATE `name`=VALUES(`name`);

-- 9. Demo Sender Domain
INSERT INTO `sender_domains` (`id`, `tenant_id`, `domain`, `verification_status`, `dkim_status`, `dmarc_status`, `verified_at`)
VALUES 
(1, 'tn_demo_mergen01', 'mergensoft.net', 'verified', 'success', 'success', NOW())
ON DUPLICATE KEY UPDATE `verification_status`=VALUES(`verification_status`);

-- 10. Demo Sender Identity
INSERT INTO `sender_identities` (`id`, `tenant_id`, `domain_id`, `email`, `display_name`, `is_default`, `status`)
VALUES 
(1, 'tn_demo_mergen01', 1, 'info@mergensoft.net', 'Mergen Butik', 1, 'active')
ON DUPLICATE KEY UPDATE `display_name`=VALUES(`display_name`);