USE fortunes_quotation;

INSERT INTO users (name, email, password_hash, role, status, must_change_password, created_at, updated_at) VALUES
('Admin User', 'admin@fortunes.local', '$2y$12$2lLz..PwjiJVHGvN/ABDQO.lHo2trX/3YLuNZ6qB2XoSZ.IV2NhnG', 'admin', 'active', 1, NOW(), NOW());

INSERT INTO products (product_category, product_name, description, brand, model, unit, unit_price, status, created_at, updated_at) VALUES
('Solar Panel', '550W Mono Panel', 'High efficiency mono crystalline solar panel', 'Jinko', 'JKM550', 'pcs', 14500, 'active', NOW(), NOW()),
('Solar Panel', '580W Mono Panel', 'High output mono crystalline solar panel', 'JA Solar', 'JAM72S30', 'pcs', 15500, 'active', NOW(), NOW()),
('Inverter', '5kW On Grid Inverter', 'On-grid solar inverter', 'Growatt', 'MIN5000TL-X', 'pcs', 68000, 'active', NOW(), NOW()),
('Inverter', '5kW Hybrid Inverter', 'Hybrid solar inverter', 'Deye', 'SUN-5K-SG04LP1', 'pcs', 125000, 'active', NOW(), NOW()),
('Battery', '100Ah 12V Battery', 'Deep cycle solar battery', 'Livguard', 'LG100', 'pcs', 14500, 'active', NOW(), NOW()),
('Structure', 'Rooftop Mounting Structure', 'Standard rooftop mounting structure', 'Local', 'STD', 'set', 25000, 'active', NOW(), NOW()),
('Accessories', 'DC Cable 6mm', 'Solar grade DC cable', 'Local', 'DC6', 'meter', 180, 'active', NOW(), NOW()),
('Accessories', 'AC/DC Protection Box', 'Protection distribution box', 'Local', 'DB-BOX', 'set', 8500, 'active', NOW(), NOW());

INSERT INTO settings (setting_key, setting_value) VALUES
('company_name', 'Fortunes'),
('company_phone', '+880 0000-000000'),
('company_email', 'info@fortunes.local'),
('company_address', 'Dhaka, Bangladesh'),
('quotation_logo_path', ''),
('default_vat_percent', '5'),
('default_terms', 'Payment terms, delivery schedule, and warranty will be confirmed with the final work order. Prices are valid for 15 days unless otherwise stated.');
