-- =====================================================================
-- TechAge MissionSuite - Milestone 2 Sample Seed Data
-- Gives a fresh install real content on About/Contact/FAQ/Testimonials
-- instead of empty pages, matching the approved HTML prototypes.
-- =====================================================================

SET NAMES utf8mb4;

-- ---------------------------------------------------------------------
-- About page (CMS-managed content)
-- ---------------------------------------------------------------------
INSERT INTO `pages` (`slug`, `title`, `content`, `meta_title`, `is_published`) VALUES
('about', 'About Us',
'<div class="row g-5 align-items-center mb-5">
  <div class="col-lg-6">
    <div class="eyebrow">Our Mission</div>
    <h2 style="font-size:28px;">Equip. Send. Serve alongside the local church.</h2>
    <p style="color:var(--ms-slate);font-size:14.5px;line-height:1.75;">We exist to equip and send workers who make disciples among the unreached, and to serve the local church in every field we enter &mdash; from church planting and Bible translation to medical outreach and community development.</p>
  </div>
  <div class="col-lg-6">
    <div class="eyebrow">Our Vision</div>
    <h2 style="font-size:28px;">A gospel witness in every unreached community.</h2>
    <p style="color:var(--ms-slate);font-size:14.5px;line-height:1.75;">We envision a day when no community is beyond the reach of the gospel &mdash; where local churches are planted, thriving, and reaching their own neighbors long after our missionaries have moved on.</p>
  </div>
</div>
<div class="eyebrow">Our Journey</div>
<h2 style="font-size:28px;" class="mb-4">Two Decades in the Field</h2>
<div class="timeline mb-5">
  <div class="tl-item"><div class="yr">2004</div><h5>Founded</h5><p>Began as a small church-planting effort with three missionary families.</p></div>
  <div class="tl-item"><div class="yr">2011</div><h5>First cross-border field opened</h5><p>Expanded internationally, launching medical outreach programs.</p></div>
  <div class="tl-item"><div class="yr">2017</div><h5>Reached 10 mission fields</h5><p>Grew to 10 active mission fields across three continents.</p></div>
  <div class="tl-item"><div class="yr">2023</div><h5>Digital giving platform launched</h5><p>Introduced online donations and missionary sponsorship.</p></div>
  <div class="tl-item"><div class="yr">2026</div><h5>Growing every year</h5><p>Today we coordinate every missionary, field and gift from MissionSuite.</p></div>
</div>
<div class="eyebrow">What We Believe</div>
<h2 style="font-size:28px;" class="mb-4">Statement of Faith</h2>
<div class="row g-4">
  <div class="col-md-3"><div class="faith-card"><div class="num">01</div><h5>Scripture</h5><p>We believe the Bible is the inspired, authoritative Word of God.</p></div></div>
  <div class="col-md-3"><div class="faith-card"><div class="num">02</div><h5>The Gospel</h5><p>Salvation is by grace through faith in Jesus Christ alone.</p></div></div>
  <div class="col-md-3"><div class="faith-card"><div class="num">03</div><h5>The Church</h5><p>We serve and strengthen the local church in every field we enter.</p></div></div>
  <div class="col-md-3"><div class="faith-card"><div class="num">04</div><h5>The Great Commission</h5><p>We are called to make disciples of all nations, starting with the unreached.</p></div></div>
</div>',
'About Us', 1);

-- ---------------------------------------------------------------------
-- Leadership team
-- ---------------------------------------------------------------------
INSERT INTO `team_members` (`name`, `role_title`, `bio`, `sort_order`, `is_active`) VALUES
('Pastor Emmanuel Ade', 'Executive Director', 'Leading the ministry''s global strategy since 2011.', 1, 1),
('Chinwe Obi', 'Director of Finance', 'Oversees stewardship of every gift and grant.', 2, 1),
('James Tanko', 'Field Operations Director', 'Coordinates missionaries across every mission field.', 3, 1),
('Faith Bello', 'Director of Prayer Ministry', 'Leads the global intercessory prayer network.', 4, 1);

-- ---------------------------------------------------------------------
-- FAQ categories + questions
-- ---------------------------------------------------------------------
INSERT INTO `faq_categories` (`name`, `icon`, `sort_order`) VALUES
('General', 'fa-circle-info', 1),
('Donations & Giving', 'fa-hand-holding-dollar', 2),
('Missionary Support', 'fa-user-group', 3),
('Volunteering', 'fa-people-group', 4);

INSERT INTO `faqs` (`category_id`, `question`, `answer`, `is_published`, `sort_order`) VALUES
((SELECT id FROM faq_categories WHERE name = 'General'), 'What is MissionSuite?', 'MissionSuite is a ministry management platform that helps mission organizations coordinate missionaries, mission fields, outreach projects, events, prayer requests and donations from one console.', 1, 1),
((SELECT id FROM faq_categories WHERE name = 'General'), 'Is this ministry affiliated with a specific denomination?', 'We are an interdenominational evangelical mission organization, partnering with local churches of many traditions in every field we serve.', 1, 2),
((SELECT id FROM faq_categories WHERE name = 'Donations & Giving'), 'How much of my donation goes directly to the field?', '98.2% of donations go directly to field programs. The remainder covers essential administrative and compliance costs.', 1, 1),
((SELECT id FROM faq_categories WHERE name = 'Donations & Giving'), 'What payment methods do you accept?', 'We accept card payments, bank transfer and USSD via Paystack and Flutterwave, as well as manual bank transfer for larger or international gifts.', 1, 2),
((SELECT id FROM faq_categories WHERE name = 'Donations & Giving'), 'Can I set up a recurring monthly gift?', 'Yes — choose "Monthly" on the Donate page before selecting your amount.', 1, 3),
((SELECT id FROM faq_categories WHERE name = 'Missionary Support'), 'How do I sponsor a specific missionary?', 'Visit a missionary''s profile page and click "Sponsor This Missionary."', 1, 1),
((SELECT id FROM faq_categories WHERE name = 'Volunteering'), 'How do I apply to volunteer?', 'Visit the Volunteer page, choose a department, and submit your application. Our Volunteer Coordinator will follow up within a week.', 1, 1);

-- ---------------------------------------------------------------------
-- Testimonials
-- ---------------------------------------------------------------------
INSERT INTO `testimonials` (`name`, `type`, `role_title`, `quote`, `status`, `sort_order`) VALUES
('Faith Bello', 'missionary', 'Field Coordinator', 'Through MissionSuite''s coordination, our clinic was able to treat hundreds of families this quarter alone — and every donor could see exactly where their gift went.', 'featured', 1),
('Adaeze Nwosu', 'donor', 'Monthly Partner since 2022', 'Seeing exactly where my monthly gift goes — down to the project — is what keeps me giving consistently.', 'published', 2),
('Grace Family Church', 'partner_church', 'Partner Church', 'Our congregation can track the missionaries we sponsor in real time. It has transformed our missions giving culture.', 'published', 3),
('Samuel Mensah', 'volunteer', 'Short-Term Trip Volunteer', 'Registering for a mission trip and tracking my support raising was seamless from start to finish.', 'published', 4);

-- ---------------------------------------------------------------------
-- Contact offices
-- ---------------------------------------------------------------------
INSERT INTO `contact_offices` (`name`, `description`, `icon`, `sort_order`) VALUES
('Regional Office', 'Serving nearby mission fields.', 'fa-mountain-sun', 1),
('Field Office', 'Coordinating regional operations.', 'fa-seedling', 2);

-- ---------------------------------------------------------------------
-- Contact + map settings
-- ---------------------------------------------------------------------
INSERT INTO `settings` (`key`, `value`) VALUES
('contact_email', 'hello@missionsuite.org'),
('contact_phone', '+234 (0) 000 0000'),
('contact_whatsapp', '+234 (0) 000 0001'),
('contact_hours', 'Mon–Fri, 9am–5pm'),
('contact_address', '12 Dispatch Way, Victoria Island, Lagos, Nigeria'),
('contact_departments', 'General Inquiry, Donations & Giving, Missionary Support, Volunteering, Mission Trips, Media & Press'),
('map_address', '12 Dispatch Way, Victoria Island, Lagos, Nigeria'),
('map_lat', '6.4281'),
('map_lng', '3.4219'),
('map_zoom', '14')
ON DUPLICATE KEY UPDATE `value` = VALUES(`value`);