-- ==========================================================
-- Initial admin account
-- IMPORTANT: change this password immediately after first login.
-- Default password below is: ChangeMe123!  (bcrypt hash)
-- Generate your own with: password_hash('YourPassword', PASSWORD_BCRYPT)
-- ==========================================================
INSERT INTO users (name, email, password_hash, role_id, status, email_verified_at, created_at)
VALUES (
    'Administrator',
    'admin@rgnet.local',
    '$2y$12$vI9v9tD1v6E3s5C0Q0Iixe1AjV8pQ7wFhZ1yFQvZ2yqjKz1e0k3Zi',
    6,
    'active',
    NOW(),
    NOW()
)
ON DUPLICATE KEY UPDATE name = VALUES(name);

-- ==========================================================
-- Packages — matches the reference design (Basic/Family/Gaming/Ultimate)
-- Admin can add/edit/delete/reorder from the dashboard; this is seed data only.
-- ==========================================================
INSERT INTO packages (name, slug, description, speed_mbps, price, billing_cycle, is_popular, is_featured, is_active, sort_order) VALUES
('Basic', 'basic', 'Cocok untuk browsing & sosmed', 10, 150000.00, 'monthly', 0, 0, 1, 1),
('Family', 'family', 'Ideal untuk keluarga', 30, 250000.00, 'monthly', 1, 1, 1, 2),
('Gaming', 'gaming', 'Ping rendah, pengalaman maksimal', 50, 350000.00, 'monthly', 0, 0, 1, 3),
('Ultimate', 'ultimate', 'Untuk kebutuhan digital penuh', 100, 550000.00, 'monthly', 0, 0, 1, 4)
ON DUPLICATE KEY UPDATE price = VALUES(price);

-- ==========================================================
-- Theme defaults — Orange Glass preset (matches reference image)
-- ==========================================================
INSERT INTO theme_settings (`key`, `value`) VALUES
('preset', 'orange-glass'),
('color-primary', '#FF7A1A'),
('color-primary-dark', '#E8590C'),
('color-bg', '#0B0D10'),
('color-surface', '#12151A'),
('color-text', '#F5F6F7'),
('color-success', '#22C55E'),
('color-error', '#EF4444'),
('color-warning', '#F5A524'),
('color-info', '#38BDF8'),
('glass-opacity', '0.55'),
('glass-blur', '18px'),
('glass-border', 'rgba(255,255,255,0.08)'),
('glow-primary', 'rgba(255,122,26,0.35)'),
('border-radius', '16px')
ON DUPLICATE KEY UPDATE `value` = VALUES(`value`);

-- ==========================================================
-- General branding settings
-- ==========================================================
INSERT INTO settings (`group`, `key`, `value`) VALUES
('branding', 'site_name', 'RGNet'),
('branding', 'tagline', 'Internet Cepat, Hidup Lebih Baik'),
('branding', 'logo_path', '/assets/img/logo.svg'),
('branding', 'favicon_path', '/assets/img/favicon.png'),
('general', 'support_phone', ''),
('general', 'support_whatsapp', ''),
('billing', 'grace_period_days', '3'),
('authentication', 'google_login_enabled', '0'),
('maintenance', 'enabled', '0')
ON DUPLICATE KEY UPDATE `value` = VALUES(`value`);

-- ==========================================================
-- WhatsApp templates (spec section 19)
-- ==========================================================
INSERT INTO whatsapp_templates (event_key, template_text) VALUES
('invoice_created', 'Halo {name}, tagihan baru telah dibuat.\n\nInvoice: {invoice}\nPaket: {package}\nTotal: {amount}\nJatuh Tempo: {due_date}\n\nSilakan lakukan pembayaran melalui: {payment_url}'),
('payment_reminder', 'Halo {name}, ini pengingat pembayaran.\n\nInvoice: {invoice}\nTotal: {amount}\nJatuh Tempo: {due_date}\n\nSegera lakukan pembayaran untuk menghindari isolir.'),
('isolation', 'Internet Anda saat ini telah diisolir karena tagihan belum dibayar.\n\nInvoice: {invoice}\nTotal: {amount}\nJatuh Tempo: {due_date}\n\nSilakan melakukan pembayaran untuk mengaktifkan kembali layanan.'),
('payment_success', 'Pembayaran Anda telah berhasil.\n\nInvoice: {invoice}\nStatus: LUNAS\n\nLayanan internet Anda telah diaktifkan kembali.'),
('restore', 'Layanan internet Anda ({username}) telah dipulihkan dan aktif kembali. Terima kasih telah melakukan pembayaran.')
ON DUPLICATE KEY UPDATE template_text = VALUES(template_text);

-- ==========================================================
-- Default community room
-- ==========================================================
INSERT INTO community_rooms (name, is_public) VALUES ('Komunitas RGNet', 1)
ON DUPLICATE KEY UPDATE name = VALUES(name);