-- ============================================================
-- Classic Catering Services — Seed Data
-- Run AFTER schema.sql. Inserts admin user, sample student,
-- services, courses, testimonials, gallery, videos, settings.
-- ============================================================

-- Wipe existing data (in case of re-import)
DELETE FROM audit_logs;
DELETE FROM certificates;
DELETE FROM notifications;
DELETE FROM payment_receipts;
DELETE FROM payments;
DELETE FROM training_applications;
DELETE FROM training_courses;
DELETE FROM testimonials;
DELETE FROM videos;
DELETE FROM gallery_images;
DELETE FROM catering_requests;
DELETE FROM catering_services;
DELETE FROM social_links;
DELETE FROM business_settings;
DELETE FROM landing_pages;
DELETE FROM password_resets;
DELETE FROM admin_profiles;
DELETE FROM student_profiles;
DELETE FROM users;

-- ============================================================
-- Admin user (super admin)
-- Password: Admin@2026 (bcrypt hash, cost 10)
-- ============================================================
INSERT INTO users (id, email, phone, password_hash, role, first_name, last_name, status, created_at, updated_at)
VALUES (
  'admin-001',
  'admin@classiccatering.com',
  '+234 800 000 0000',
  '$2b$10$m7KnVinOr1PFnmbrlg0HUOf8VLSw0Ll8VfBCt26CzkOztrhsWeiEy',
  'SUPER_ADMIN',
  'Site',
  'Administrator',
  'ACTIVE',
  NOW(),
  NOW()
);

INSERT INTO admin_profiles (id, user_id, display_name, modules)
VALUES ('admin-profile-001', 'admin-001', 'Site Administrator', '*');

-- ============================================================
-- Sample student
-- Password: Student@2026 (bcrypt hash, cost 10)
-- ============================================================
INSERT INTO users (id, email, phone, password_hash, role, first_name, last_name, status, created_at, updated_at)
VALUES (
  'student-001',
  'student@demo.com',
  '+234 801 234 5678',
  '$2b$10$g.R9eJ5WhTpFha.rIAkQsuCjDjXx1Z1vKa8gT3EheQtFpKuf5hRZ.',
  'STUDENT',
  'Adaeze',
  'Okonkwo',
  'ACTIVE',
  NOW(),
  NOW()
);

INSERT INTO student_profiles (id, user_id, application_number, full_name, date_of_birth, gender, residential_address, state_of_residence, education, previous_experience, emergency_contact)
VALUES (
  'student-profile-001',
  'student-001',
  'APP-2026-DEMO1',
  'Adaeze Okonkwo',
  '1999-04-15',
  'FEMALE',
  '12 Allen Avenue, Ikeja, Lagos',
  'Lagos',
  'BSc Food Science',
  'Worked 1 year as event helper',
  '+234 805 555 1234'
);

-- ============================================================
-- Business settings
-- ============================================================
INSERT INTO business_settings (`key`, value, category) VALUES
('businessName', 'Classic Catering Services', 'general'),
('tagline', 'Exceptional Catering, Beautifully Served.', 'general'),
('email', 'info@classiccatering.com', 'contact'),
('phone', '+234 800 000 0000', 'contact'),
('whatsapp', '+234 800 000 0000', 'contact'),
('address', '123 Catering Avenue, Lagos, Nigeria', 'contact'),
('openingHours', 'Mon - Sat: 8:00 AM - 8:00 PM', 'contact'),
('mapEmbedUrl', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d31688.6!2d3.3792!3d6.5244', 'contact'),
('heroTitle', 'Exceptional Catering, Beautifully Served.', 'hero'),
('heroSubtitle', 'Premium catering, event food preparation, and certificate training in catering, baking, cooking, and hospitality.', 'hero'),
('seoTitle', 'Classic Catering Services | Premium Catering & Training', 'seo'),
('seoDescription', 'Premier catering services for weddings, corporate events, and private parties. Certificate training courses in catering, baking, and hospitality.', 'seo'),
('bankName', 'First Bank Nigeria', 'payment'),
('accountName', 'Classic Catering Services', 'payment'),
('accountNumber', '0000000000', 'payment'),
('paymentInstructions', 'Deposit the course fee into the bank account above. Use your Application Number as the deposit reference. Then upload your payment receipt below.', 'payment'),
('logoUrl', '', 'branding'),
('faviconUrl', '', 'branding');

-- ============================================================
-- Social links
-- ============================================================
INSERT INTO social_links (id, platform, url, icon, `order`, active) VALUES
('social-001', 'facebook', 'https://facebook.com/classiccatering', 'facebook', 1, 1),
('social-002', 'instagram', 'https://instagram.com/classiccatering', 'instagram', 2, 1),
('social-003', 'youtube', 'https://youtube.com/@classiccatering', 'youtube', 3, 1),
('social-004', 'whatsapp', 'https://wa.me/2348000000000', 'whatsapp', 4, 1);

-- ============================================================
-- Catering services
-- ============================================================
INSERT INTO catering_services (id, title, slug, description, category, starting_price, featured, published) VALUES
('svc-001', 'Wedding & Traditional Event Catering', 'wedding-traditional-event-catering', 'Make your big day unforgettable with our elegant wedding catering. We offer customized menus covering traditional Nigerian dishes, continental cuisine, desserts, and signature drinks. Our team handles setup, presentation, and service so you can focus on your celebration.', 'Wedding & Traditional Event Catering', 2500, 1, 1),
('svc-002', 'Birthday & Private Party Catering', 'birthday-private-party-catering', 'Delight your guests with carefully curated menus for birthdays, anniversies, family reunions, and intimate gatherings. From small home parties to large celebrations, we craft menus that match your taste and budget.', 'Birthday & Private Party Catering', 800, 1, 1),
('svc-003', 'Corporate Catering', 'corporate-catering', 'Professional catering for meetings, conferences, retreats, product launches, and end-of-year parties. We deliver on time, on budget, with the corporate presentation your brand expects.', 'Corporate Catering', 1500, 1, 1),
('svc-004', 'Outdoor & Buffet Catering', 'outdoor-buffet-catering', 'Perfect for garden parties, picnics, beach events, and outdoor celebrations. Our buffet setups are designed for visual appeal, easy flow, and effortless guest service.', 'Outdoor & Buffet Catering', 1200, 0, 1),
('svc-005', 'Food Preparation & Delivery', 'food-preparation-delivery', 'Need bulk meals delivered to your location? We prepare fresh, hygienically-packed meals and deliver them to your office, event venue, or home in food-grade containers.', 'Food Preparation & Delivery', 300, 0, 1),
('svc-006', 'Event Decoration & Hospitality Support', 'event-decoration-hospitality', 'Complete the look of your event with our decoration service. We provide table setting, floral arrangement, chair covers, draping, and trained hospitality ushers.', 'Event Decoration & Hospitality Support', 600, 0, 1),
('svc-007', 'Custom & Themed Catering', 'custom-themed-catering', 'Have a unique vision? We design custom and themed catering experiences for cultural festivals, themed parties, religious events, and private brand experiences.', 'Other Catering Services', 1000, 0, 1);

-- ============================================================
-- Training courses
-- ============================================================
INSERT INTO training_courses (id, title, slug, description, outline, category, duration, training_mode, venue, start_date, end_date, application_deadline, certificate_type, fee, status, accept_applications) VALUES
('crs-001',
 'Professional Catering & Event Management Certificate',
 'professional-catering-event-management',
 'A 6-week intensive certificate program covering menu planning, event catering operations, food presentation, customer service, and small business management for caterers.',
 'Week 1: Introduction to Catering Business\nWeek 2: Menu Planning & Costing\nWeek 3: Food Production & Hygiene\nWeek 4: Presentation & Service Standards\nWeek 5: Event Management & Logistics\nWeek 6: Customer Service & Business Management',
 'catering', '6 weeks', 'PHYSICAL', 'Lagos Training Center',
 '2026-10-05', '2026-11-16', '2026-09-28',
 'Professional Certificate', 75000, 'OPEN', 1),
('crs-002',
 'Baking & Pastry Arts Certificate',
 'baking-pastry-arts',
 'A 4-week hands-on program covering bread making, cakes, pastries, cookies, and desserts. Suitable for aspiring bakers and small bakery owners.',
 'Week 1: Bread Production\nWeek 2: Cakes & Icing\nWeek 3: Pastries & Cookies\nWeek 4: Desserts & Plating',
 'baking', '4 weeks', 'HYBRID', 'Lagos Training Center + Online',
 '2026-10-12', '2026-11-09', '2026-10-05',
 'Certificate of Completion', 55000, 'OPEN', 1),
('crs-003',
 'African & Continental Cuisine Masterclass',
 'african-continental-cuisine',
 'A 3-week specialized program for cooks and food enthusiasts. Master signature African dishes and continental favorites with professional plating.',
 'Week 1: African Cuisine Fundamentals\nWeek 2: Continental Cuisine Techniques\nWeek 3: Plating & Service',
 'cooking', '3 weeks', 'PHYSICAL', 'Lagos Training Center',
 '2026-11-02', '2026-11-23', '2026-10-26',
 'Certificate of Participation', 45000, 'OPEN', 1);

-- ============================================================
-- Testimonials
-- ============================================================
INSERT INTO testimonials (id, client_name, client_role, content, rating, published, `order`) VALUES
('tst-001', 'Mr. & Mrs. Adeyemi', 'Wedding Clients, Lagos', 'Classic Catering Services handled our wedding for 400 guests flawlessly. The food was delicious, the presentation was elegant, and the service team was professional. Highly recommended!', 5, 1, 1),
('tst-002', 'TechFlow Limited', 'Corporate Client', 'We use Classic Catering for our quarterly team events and annual retreat. They are punctual, reliable, and the food quality has never disappointed. A trusted partner.', 5, 1, 2),
('tst-003', 'Chidinma Eze', 'Baking Certificate Graduate', 'I completed the Baking & Pastry Arts Certificate and started my own small bakery three months later. The training was practical, the instructors were patient, and the value is unmatched.', 5, 1, 3);

-- ============================================================
-- Gallery images (using stable OSS-hosted URLs)
-- ============================================================
INSERT INTO gallery_images (id, title, category, image_url, caption, published) VALUES
('gal-001', 'Wedding Reception Spread', 'wedding', 'https://z-cdn.chatglm.cn/image-search-mcp/images-ppt/87b8194ce1a7.jpg', 'Elegant wedding catering setup', 1),
('gal-002', 'Corporate Lunch Service', 'corporate', 'https://z-cdn.chatglm.cn/image-search-mcp/images-ppt/850ca79423df.jpg', 'Corporate buffet service', 1),
('gal-003', 'Birthday Cake Table', 'birthday', 'https://z-cdn.chatglm.cn/image-search-mcp/images-ppt/99e63f8e981f.jpeg', 'Birthday party cake table', 1),
('gal-004', 'Buffet Spread', 'buffet', 'https://z-cdn.chatglm.cn/image-search-mcp/images-ppt/41b4220c18cf.jpg', 'Outdoor buffet spread', 1),
('gal-005', 'Continental Plating', 'food', 'https://z-cdn.chatglm.cn/image-search-mcp/images-ppt/cc9b3a336749.jpg', 'Continental cuisine plating', 1),
('gal-006', 'Training Session', 'training', 'https://z-cdn.chatglm.cn/image-search-mcp/images-ppt/0f2d84b19ef0.jpg', 'Catering training session in progress', 1);

-- ============================================================
-- Videos (YouTube IDs)
-- ============================================================
INSERT INTO videos (id, title, description, youtube_id, category, featured, published) VALUES
('vid-001', 'Behind the Scenes: Wedding Catering', 'A look at how our team prepares for a 400-guest wedding.', 'ScMzIhfOSbs', 'behind-the-scenes', 1, 1),
('vid-002', 'Catering Training Open Day', 'Highlights from our last training open day.', 'aqiZmPrOjOQ', 'training', 0, 1),
('vid-003', 'Signature Dish Showcase', 'Our chef preparing a signature jollof rice with grilled chicken.', 'Zabc9J4uWpI', 'food', 0, 1);

-- ============================================================
-- Default landing page (active)
-- ============================================================
INSERT INTO landing_pages (id, name, slug, is_active, is_default, hero_title, hero_subtitle, hero_image, hero_badge, cta1_text, cta1_link, cta2_text, cta2_link, show_stats, show_services, show_why_choose_us, show_video, show_gallery, show_training, show_testimonials, show_final_cta, final_cta_headline, final_cta_button_text, final_cta_button_link)
VALUES (
  'landing-001',
  'Default',
  'default',
  1,
  1,
  'Exceptional Catering, Beautifully Served.',
  'Premium catering, event food preparation, and certificate training in catering, baking, cooking, and hospitality.',
  'https://z-cdn.chatglm.cn/image-search-mcp/images-ppt/dfdef171cf82.jpg',
  'PREMIUM CATERING & TRAINING',
  'Request Catering Services', '/catering/request',
  'Explore Training Courses', '/courses',
  1, 1, 1, 1, 1, 1, 1, 1,
  'Ready to Plan Your Next Event?', 'Request Catering', '/catering/request'
);