

-- =====================================================
-- DEMO CONTENT SEED DATA — products, blogs, works, properties
-- Run this after schema.sql so shop/blog/work/property detail pages show real database content.
-- Safe to re-run because INSERT IGNORE is used with unique slugs.
-- =====================================================

INSERT IGNORE INTO `product_categories` (`name`,`slug`,`description`,`sort_order`) VALUES
('Digital Solutions','digital-solutions','Premium websites, apps and automation solutions.',1),
('Branding & Design','branding-design','Corporate branding and graphic design packages.',2),
('Travel Services','travel-services','Travel planning, tours and ticketing services.',3),
('Real Estate Services','real-estate-services','Property advisory and investment products.',4);

INSERT IGNORE INTO `products` (`category_id`,`name`,`slug`,`description`,`short_description`,`price`,`sale_price`,`stock`,`sku`,`featured_image`,`is_featured`,`is_active`,`meta_title`,`meta_description`) VALUES
((SELECT id FROM product_categories WHERE slug='digital-solutions' LIMIT 1),'Premium Corporate Website Package','premium-corporate-website','A complete ultra-premium corporate website package with responsive pages, SEO foundation, contact forms, blog, portfolio, and admin-ready structure.','Ultra-premium responsive website package for companies.',4500.00,NULL,20,'TG-WEB-001',NULL,1,1,'Premium Corporate Website Package','Ultra-premium website design package by Tettevi Group'),
((SELECT id FROM product_categories WHERE slug='branding-design' LIMIT 1),'Complete Brand Identity Kit','complete-brand-identity-kit','Professional logo system, brand colors, typography guide, social media templates, business card design, and launch-ready brand assets.','Professional branding package for growing businesses.',2500.00,2200.00,25,'TG-BRAND-001',NULL,1,1,'Complete Brand Identity Kit','Logo and brand identity design package'),
((SELECT id FROM product_categories WHERE slug='travel-services' LIMIT 1),'Corporate Travel Management Setup','corporate-travel-management-setup','End-to-end business travel planning setup for companies, including booking workflow, travel policy guidance, and reporting templates.','Corporate travel setup and advisory package.',1800.00,NULL,30,'TG-TRAVEL-001',NULL,0,1,'Corporate Travel Management Setup','Corporate travel management service package'),
((SELECT id FROM product_categories WHERE slug='real-estate-services' LIMIT 1),'Real Estate Investment Advisory','real-estate-investment-advisory','Premium consultation for property buyers and investors seeking secure opportunities in Ghana real estate markets.','Property investment advisory package.',1200.00,NULL,40,'TG-REAL-001',NULL,1,1,'Real Estate Investment Advisory','Real estate advisory package in Ghana');

INSERT IGNORE INTO `blogs` (`category_id`,`author_id`,`title`,`slug`,`excerpt`,`content`,`featured_image`,`status`,`allow_comments`,`meta_title`,`meta_description`,`published_at`) VALUES
((SELECT id FROM blog_categories WHERE slug='technology' LIMIT 1),(SELECT id FROM users WHERE email='admin@tettevigroup.com' LIMIT 1),'Why Every Business Needs a Premium Website in 2026','professional-website-business-2026','A practical guide to why modern businesses need fast, secure and conversion-focused websites.','<p>A premium website is more than an online brochure. It is your digital office, sales representative, customer support desk, brand proof and search engine asset working every day.</p><p>For businesses in Ghana and beyond, customers compare brands online before calling. A strong website improves trust, captures leads, supports payments, and gives your brand a professional foundation.</p><p>Tettevi Group builds websites with responsive layouts, SEO-ready structure, fast loading pages, and clean user journeys that help visitors take action.</p>',NULL,'published',1,'Why Every Business Needs a Premium Website in 2026','Premium website benefits for modern businesses',NOW()),
((SELECT id FROM blog_categories WHERE slug='real-estate' LIMIT 1),(SELECT id FROM users WHERE email='admin@tettevigroup.com' LIMIT 1),'Property Investment Guide for Accra Buyers','property-investment-accra-guide','Key things buyers should know before investing in Accra real estate.','<p>Accra remains one of Ghana’s strongest real estate markets, but smart investors need clear goals, proper documentation checks, and professional guidance.</p><p>Before buying, confirm land title, location growth potential, road access, rental demand, and total ownership cost. A good investment is not only about price; it is about security, long-term demand, and exit options.</p><p>Tettevi Group supports buyers with property sourcing, due diligence guidance, negotiation support, and investment advisory.</p>',NULL,'published',1,'Property Investment Guide for Accra Buyers','Real estate investment guide for Accra buyers',NOW()),
((SELECT id FROM blog_categories WHERE slug='travel' LIMIT 1),(SELECT id FROM users WHERE email='admin@tettevigroup.com' LIMIT 1),'Stress-Free Travel Planning for Families and Businesses','stress-free-travel-planning','How professional travel planning saves time, cost and stress.','<p>Travel becomes easier when flights, accommodation, documents, transport, and itinerary details are coordinated early.</p><p>Families need convenience and safety. Businesses need reliability, cost control and proper records. With professional planning, travellers avoid last-minute pressure and enjoy smoother trips.</p><p>Tettevi Group helps clients plan tours, flights, logistics and travel experiences with care and attention to detail.</p>',NULL,'published',1,'Stress-Free Travel Planning','Professional travel planning tips',NOW());

INSERT IGNORE INTO `portfolio_projects` (`category_id`,`title`,`slug`,`client`,`description`,`featured_image`,`gallery`,`technologies`,`results`,`project_url`,`is_featured`,`completed_at`,`meta_title`,`meta_description`) VALUES
((SELECT id FROM portfolio_categories WHERE slug='it-solutions' LIMIT 1),'Premium E-Commerce Platform','ecommerce-platform','Retail Ghana Ltd','A complete e-commerce platform with product catalogue, cart, checkout, payment integration and admin order management.',NULL,JSON_ARRAY(),JSON_ARRAY('PHP 8','MySQL','Paystack','Responsive UI','Admin Dashboard'),JSON_ARRAY('Improved digital sales workflow','Reduced manual order handling','Created mobile-first shopping experience'),NULL,1,CURDATE(),'Premium E-Commerce Platform','Portfolio detail for e-commerce platform'),
((SELECT id FROM portfolio_categories WHERE slug='branding' LIMIT 1),'Corporate Brand Identity System','corporate-brand-identity-system','Tettevi Group Client','A full visual identity project including logo direction, color system, typography, marketing templates and brand launch assets.',NULL,JSON_ARRAY(),JSON_ARRAY('Brand Strategy','Graphic Design','Social Media Kits','Print Assets'),JSON_ARRAY('Consistent brand presence','Professional launch materials','Improved customer trust'),NULL,1,CURDATE(),'Corporate Brand Identity System','Branding portfolio project'),
((SELECT id FROM portfolio_categories WHERE slug='real-estate' LIMIT 1),'Real Estate Listing Portal','property-portal','Zuri Estate','A property listing and lead capture portal for real estate buyers, sellers and investors.',NULL,JSON_ARRAY(),JSON_ARRAY('PHP','MySQL','Property Search','Lead Forms'),JSON_ARRAY('Better property discovery','More qualified enquiries','Responsive buyer experience'),NULL,1,CURDATE(),'Real Estate Listing Portal','Real estate portal portfolio project');

INSERT IGNORE INTO `properties` (`title`,`slug`,`type`,`property_type`,`price`,`currency`,`bedrooms`,`bathrooms`,`area_sqft`,`location`,`city`,`region`,`description`,`features`,`featured_image`,`gallery`,`is_featured`,`status`) VALUES
('4-Bedroom Executive Villa','east-legon-villa','sale','villa',850000.00,'GHS',4,3,3444.00,'East Legon, Accra','Accra','Greater Accra','A stunning executive villa in one of Accra’s most desirable residential areas with spacious interiors and premium finishing.',JSON_ARRAY('Fitted Kitchen','CCTV Security','Double Garage','Backup Generator','Air Conditioning','Garden'),NULL,JSON_ARRAY(),1,'available'),
('Trasacco Estate Luxury Home','trasacco-luxury','sale','villa',1200000.00,'GHS',5,4,5597.00,'Trasacco, Accra','Accra','Greater Accra','An exceptional luxury residence within a secure gated estate, designed for comfort, privacy and high-end living.',JSON_ARRAY('Swimming Pool','Smart Home System','Home Theater','Solar Power','Staff Quarters','Landscaped Garden'),NULL,JSON_ARRAY(),1,'available'),
('Airport Residential Apartment','airport-residential-apartment','rent','apartment',15000.00,'GHS',3,3,1800.00,'Airport Residential Area, Accra','Accra','Greater Accra','A premium apartment in a prime business-friendly location with easy access to major offices, restaurants and airport routes.',JSON_ARRAY('Elevator','Gym Access','Security','Backup Power','Fitted Kitchen'),NULL,JSON_ARRAY(),0,'available');

INSERT IGNORE INTO `tours` (`title`,`slug`,`destination`,`duration_days`,`price`,`currency`,`max_persons`,`description`,`itinerary`,`includes`,`excludes`,`featured_image`,`gallery`,`is_featured`,`is_active`) VALUES
('Accra City Premium Experience','accra-city-premium-experience','Accra, Ghana',1,850.00,'GHS',20,'A curated city tour covering culture, food, landmarks and premium travel support.',JSON_ARRAY('Pickup','City landmarks','Cultural experience','Drop-off'),JSON_ARRAY('Transport','Guide','Selected entry fees'),JSON_ARRAY('Personal shopping'),NULL,JSON_ARRAY(),1,1);
