-- Sample data so the storefront isn't empty on first run.
-- Passwords below are the bcrypt hash of "Password123!" — for demo/testing only, replace before going live.

INSERT INTO users (display_code, full_name, phone, email, password_hash, is_verified, account_status) VALUES
('User-4821', 'Demo Reporter One', '01710000001', 'reporter1@example.com', '$2y$10$abcdefghijklmnopqrstuv', 1, 'approved'),
('User-2210', 'Demo Reporter Two', '01710000002', 'reporter2@example.com', '$2y$10$abcdefghijklmnopqrstuv', 1, 'approved'),
('User-7734', 'Demo Reporter Three', '01710000003', 'reporter3@example.com', '$2y$10$abcdefghijklmnopqrstuv', 0, 'approved');

INSERT INTO report_categories (slug, name, icon, sort_order) VALUES
('online-payment', 'Online Payment', 'credit-card', 1),
('marketplace', 'Marketplace', 'shopping-bag', 2),
('social-media', 'Social Media', 'message-circle', 3),
('job-scam', 'Job Scam', 'briefcase', 4),
('individual', 'Individual', 'user', 5),
('company', 'Company', 'building-2', 6),
('other', 'Other', 'more-horizontal', 7);

INSERT INTO reports
(report_code, user_id, category_id, title, reported_name, reported_phone, reported_company, scam_amount, scam_date, description, status, fee_paid, views, created_at) VALUES
('SCM-2026-000123', 1, 1, 'iPhone 15 Pro Max Deal — Advance Payment Scam', 'Rifat Hasan', '01712345678', NULL, 8500, '2026-05-10',
 'Contact was made through a Facebook Marketplace listing for an iPhone 15 Pro Max. The seller asked to move the conversation to WhatsApp and requested 50% advance via bKash before shipping. After the payment was sent, the seller asked for more time, then blocked all contact. No product was ever received and the seller cannot be reached.',
 'pending_review', 1, 245, '2026-05-10 23:30:00'),

('SCM-2026-000124', 2, 2, 'Daraz Fake Seller — Package Not Delivered', 'Daraz Express Store', '01634556677', 'Daraz Express Store', 12000, '2026-05-09',
 'An order was placed through a third-party seller listed on Daraz for electronics. Payment was completed online but the tracking number provided was invalid and the seller account was later removed from the platform without resolution.',
 'under_investigation', 1, 512, '2026-05-09 18:10:00'),

('SCM-2026-000125', 3, 3, 'Facebook Prize Scam — Fake Lottery Notification', 'SafeGuard Rewards Page', '01890112233', NULL, 5000, '2026-05-08',
 'A Facebook page claiming to run a rewards program contacted the reporter about winning a prize. The page asked for a "processing fee" transfer before the prize could be released. After payment, the page stopped responding and was later found to be a duplicate of an official brand page.',
 'approved', 1, 890, '2026-05-08 14:05:00'),

('SCM-2026-000126', 1, 4, 'Work From Home Scam — Registration Fee Required', 'QuickEarn BD', '01315667788', 'QuickEarn BD', 3000, '2026-05-07',
 'A job listing promised ৳50,000/month for simple data-entry work from home, but required an upfront "registration fee" before training could begin. After payment, no work was ever assigned and further messages went unanswered.',
 'pending_review', 1, 176, '2026-05-07 09:45:00');

-- Cover images (paths are placeholders — replace with real uploaded evidence in /public/assets/uploads)
INSERT INTO report_images (report_id, file_path, is_cover, sort_order) VALUES
(1, '/assets/img/samples/report-1-cover.jpg', 1, 1),
(2, '/assets/img/samples/report-2-cover.jpg', 1, 1),
(3, '/assets/img/samples/report-3-cover.jpg', 1, 1),
(4, '/assets/img/samples/report-4-cover.jpg', 1, 1);