-- =====================================================================
-- TechAge MissionSuite - Milestone 6 Sample Seed Data
-- Sample donations and volunteers, so a fresh install shows real content
-- on the admin Donations, Volunteers pages and their KPI tiles.
-- All donations here are logged as 'manual' (gateway=manual) since no
-- live Paystack transaction exists on a fresh install -- online gifts
-- only appear once a real donor completes checkout or an admin adds keys.
-- =====================================================================

SET NAMES utf8mb4;

INSERT INTO `donations` (`donor_name`, `donor_email`, `is_anonymous`, `amount`, `frequency`, `campaign`, `project_id`, `gateway`, `payment_method`, `reference`, `status`, `received_at`, `created_at`) VALUES
('Adaeze Nwosu', 'adaeze.nwosu@example.com', 0, 50000, 'one_time', 'General Fund', NULL, 'manual', 'Bank Transfer', 'MAN-88213001', 'completed', DATE_SUB(CURDATE(), INTERVAL 1 DAY), DATE_SUB(NOW(), INTERVAL 1 DAY)),
('Tolu Bakare', 'tolu.bakare@example.com', 0, 25000, 'monthly', 'Project', (SELECT id FROM projects WHERE slug = 'riverside-fellowship-shelter'), 'manual', 'Bank Transfer', 'MAN-40217002', 'completed', DATE_SUB(CURDATE(), INTERVAL 1 DAY), DATE_SUB(NOW(), INTERVAL 1 DAY)),
('Anonymous Donor', 'anonymous@example.com', 1, 150000, 'one_time', 'Missionary Support', NULL, 'manual', 'Cash', 'MAN-88190003', 'completed', DATE_SUB(CURDATE(), INTERVAL 2 DAY), DATE_SUB(NOW(), INTERVAL 2 DAY)),
('Kunle Ogundele', 'kunle.ogundele@example.com', 0, 10000, 'one_time', 'Project', (SELECT id FROM projects WHERE slug = 'frontier-clinic-supplies'), 'manual', 'Cash', 'MAN-11532004', 'pending', NULL, DATE_SUB(NOW(), INTERVAL 2 DAY)),
('Chiamaka Hassan', 'chiamaka.hassan@example.com', 0, 85000, 'one_time', 'General Fund', NULL, 'manual', 'Bank Transfer', 'MAN-88104005', 'completed', DATE_SUB(CURDATE(), INTERVAL 3 DAY), DATE_SUB(NOW(), INTERVAL 3 DAY)),
('Rebecca Williams', 'rebecca.williams@example.com', 0, 200000, 'one_time', 'Missionary Support', NULL, 'manual', 'Cheque', 'MAN-00931006', 'completed', DATE_SUB(CURDATE(), INTERVAL 5 DAY), DATE_SUB(NOW(), INTERVAL 5 DAY)),
('David Eze', 'david.eze@example.com', 0, 15000, 'one_time', 'General Fund', NULL, 'manual', 'Bank Transfer', 'MAN-87990007', 'refunded', DATE_SUB(CURDATE(), INTERVAL 9 DAY), DATE_SUB(NOW(), INTERVAL 9 DAY));

INSERT INTO `volunteers` (`name`, `email`, `phone`, `home_church`, `department`, `primary_skill`, `additional_skills`, `availability`, `project_id`, `event_id`, `status`) VALUES
('Samuel Mensah', 'samuel.mensah@example.com', '+2348020000001', 'Grace Family Church, Lagos', 'Church Planting', 'Preaching', 'Discipleship', 'both', NULL, NULL, 'pending'),
('Grace Nwankwo', 'grace.nwankwo@example.com', '+2348020000002', 'Redeemed Faith Chapel', 'Medical Outreach', 'Nursing', 'First Aid', 'trips', (SELECT id FROM projects WHERE slug = 'frontier-clinic-supplies'), NULL, 'active'),
('Ifeoma Bassey', 'ifeoma.bassey@example.com', '+2348020000003', 'Living Word Assembly', 'Media & Tech', 'Video Editing', 'Photography', 'both', NULL, (SELECT id FROM events WHERE slug = 'global-missions-conference'), 'active'),
('Tunde Okafor', 'tunde.okafor@example.com', '+2348020000004', 'Christ Covenant Church', 'Logistics', 'Driving', 'Procurement', 'trips', NULL, (SELECT id FROM events WHERE slug = 'short-term-mission-trip'), 'active'),
('Rebecca Ajayi', 'rebecca.ajayi@example.com', '+2348020000005', 'Mount Zion Fellowship', 'Hospitality', 'Event Planning', NULL, 'local', NULL, NULL, 'pending'),
('Paul Kariuki', 'paul.kariuki@example.com', '+2348020000006', 'New Life Chapel', 'Church Planting', 'Worship', 'Youth Ministry', 'both', (SELECT id FROM projects WHERE slug = 'highlands-scripture-drive'), NULL, 'active'),
('Hannah Danladi', 'hannah.danladi@example.com', '+2348020000007', 'Emmanuel Baptist Church', 'Medical Outreach', 'Pharmacy', NULL, 'local', NULL, NULL, 'inactive');