-- VELORA Sample Data
-- Sample products, subcategories, and more

USE `websparkit_velora`;

-- Sample Subcategories
INSERT INTO subcategories (category_id, name, slug) VALUES
(1, 'Living Room', 'living-room'),
(1, 'Bedroom', 'bedroom'),
(1, 'Kitchen', 'kitchen'),
(1, 'Garden', 'garden'),
(2, 'Skincare', 'skincare'),
(2, 'Makeup', 'makeup'),
(2, 'Hair Care', 'hair-care'),
(2, 'Fragrance', 'fragrance'),
(3, 'Tools', 'tools'),
(3, 'Safety Equipment', 'safety-equipment'),
(3, 'Machinery', 'machinery'),
(4, 'Smartphones', 'smartphones'),
(4, 'Laptops', 'laptops'),
(4, 'Audio', 'audio'),
(4, 'Wearable', 'wearable'),
(5, 'Car Care', 'car-care'),
(5, 'Interior Accessories', 'interior-accessories'),
(5, 'Exterior Accessories', 'exterior-accessories'),
(6, 'Paintings', 'paintings'),
(6, 'Sculptures', 'sculptures'),
(6, 'Photography', 'photography'),
(6, 'Handicrafts', 'handicrafts');

-- Sample Products (Home & Garden)
INSERT INTO products (category_id, subcategory_id, brand_id, name, slug, short_description, description, regular_price, sale_price, discount_percent, sku, stock_quantity, stock_status, featured, best_seller, new_arrival, thumbnail, tags) VALUES
(1, 1, 1, 'Premium Velvet Sofa Set', 'premium-velvet-sofa-set', 'Luxurious 3-seater velvet sofa with elegant gold legs', 'Transform your living room with our Premium Velvet Sofa Set. Handcrafted with the finest materials, this 3-seater sofa features plush velvet upholstery, gold-finished legs, and exceptional comfort. Perfect for modern luxury homes.', 89999.00, 74999.00, 17, 'VLR-HG-001', 15, 'in_stock', 1, 1, 1, '', 'luxury,sofa,velvet,home,premium'),
(1, 2, 1, 'Egyptian Cotton Bedsheet Set', 'egyptian-cotton-bedsheet-set', '1000 thread count Egyptian cotton bedsheet', 'Indulge in the luxury of our 1000 thread count Egyptian cotton bedsheet set. Includes 1 bedsheet, 2 pillowcases, and 1 duvet cover. Available in multiple elegant colors.', 12999.00, 8999.00, 31, 'VLR-HG-002', 30, 'in_stock', 1, 0, 1, '', 'bedding,cotton,luxury,bedroom'),
(1, 3, 4, 'Handcrafted Ceramic Dinner Set', 'handcrafted-ceramic-dinner-set', '16-piece handcrafted ceramic dinnerware', 'Exquisite 16-piece ceramic dinner set featuring hand-painted designs. Microwave and dishwasher safe. Each piece is a work of art.', 15999.00, 11999.00, 25, 'VLR-HG-003', 25, 'in_stock', 0, 1, 0, '', 'kitchen,ceramic,dinner,handcrafted'),
(1, 4, 1, 'Modern Garden Lounge Set', 'modern-garden-lounge-set', 'Weather-resistant rattan outdoor furniture', 'Create your perfect outdoor sanctuary with our Modern Garden Lounge Set. Made from weather-resistant rattan with plush cushions. Includes 4-seater sofa, 2 chairs, and coffee table.', 65999.00, 54999.00, 17, 'VLR-HG-004', 8, 'in_stock', 1, 0, 1, '', 'garden,outdoor,rattan,lounge'),

-- Health & Beauty
(2, 5, 6, '24K Gold Anti-Aging Serum', '24k-gold-anti-aging-serum', 'Luxury anti-aging serum with 24K gold particles', 'Reveal radiant, youthful skin with our 24K Gold Anti-Aging Serum. Infused with pure gold particles, hyaluronic acid, and vitamin C. Suitable for all skin types.', 4999.00, 3499.00, 30, 'VLR-HB-001', 50, 'in_stock', 1, 1, 1, '', 'skincare,serum,gold,anti-aging,luxury'),
(2, 6, 6, 'Velvet Matte Lipstick Collection', 'velvet-matte-lipstick-collection', 'Set of 6 long-lasting velvet matte lipsticks', 'Express yourself with our Velvet Matte Lipstick Collection. Six stunning shades from nude to bold red. Long-lasting formula with vitamin E for soft, hydrated lips.', 2999.00, 1999.00, 33, 'VLR-HB-002', 40, 'in_stock', 1, 1, 0, '', 'makeup,lipstick,matte,beauty'),
(2, 7, 6, 'Argan Oil Hair Repair Mask', 'argan-oil-hair-repair-mask', 'Deep conditioning hair mask with pure argan oil', 'Restore damaged hair with our Argan Oil Hair Repair Mask. Enriched with pure Moroccan argan oil, keratin, and essential vitamins. Salon-quality results at home.', 1999.00, 1299.00, 35, 'VLR-HB-003', 60, 'in_stock', 0, 1, 1, '', 'hair,argan,repair,mask'),
(2, 8, 1, 'Luxury Oud Perfume 100ml', 'luxury-oud-perfume-100ml', 'Premium Arabian oud fragrance for men and women', 'Experience the allure of the Orient with our Luxury Oud Perfume. A rich, woody fragrance with notes of saffron, rose, and amber. Long-lasting 100ml bottle.', 8999.00, 6999.00, 22, 'VLR-HB-004', 20, 'in_stock', 1, 0, 1, '', 'perfume,oud,fragrance,luxury'),

-- Industrial
(3, 9, 2, 'Professional Power Drill Set', 'professional-power-drill-set', 'Heavy-duty 18V cordless power drill kit', 'Tackle any job with our Professional Power Drill Set. 18V cordless drill with 2 batteries, 50+ accessories, and carrying case. Perfect for professionals and DIY enthusiasts.', 12999.00, 9999.00, 23, 'VLR-IN-001', 25, 'in_stock', 0, 1, 1, '', 'drill,power,tools,professional'),
(3, 10, 2, 'Industrial Safety Helmet', 'industrial-safety-helmet', 'Heavy-duty industrial safety helmet with visor', 'Ensure workplace safety with our Industrial Safety Helmet. ANSI certified with adjustable headband, chin strap, and integrated visor. Available in multiple colors.', 1999.00, 1499.00, 25, 'VLR-IN-002', 100, 'in_stock', 0, 0, 1, '', 'safety,helmet,industrial,protection'),
(3, 11, 2, 'Digital Industrial Scale 500kg', 'digital-industrial-scale-500kg', 'Heavy-duty digital weighing scale', 'Accurate 500kg capacity digital industrial scale with LCD display, tare function, and rechargeable battery. Perfect for warehouses and industrial use.', 24999.00, 19999.00, 20, 'VLR-IN-003', 10, 'in_stock', 1, 0, 0, '', 'scale,industrial,weighing,digital'),

-- Electronics
(4, 12, 2, 'Latest Smartphone Pro Max', 'latest-smartphone-pro-max', 'Flagship smartphone with 6.7" OLED display', 'Experience the future with our Latest Smartphone Pro Max. 6.7-inch OLED display, 108MP camera, 5G connectivity, and all-day battery life. Premium design meets cutting-edge technology.', 89999.00, 79999.00, 11, 'VLR-EL-001', 30, 'in_stock', 1, 1, 1, '', 'smartphone,mobile,5g,flagship'),
(4, 13, 2, 'Ultra-Slim Gaming Laptop', 'ultra-slim-gaming-laptop', 'RTX 4070 gaming laptop with 32GB RAM', 'Dominate every game with our Ultra-Slim Gaming Laptop. RTX 4070 graphics, 32GB DDR5 RAM, 1TB SSD, 240Hz QHD display. Power and portability combined.', 159999.00, 139999.00, 13, 'VLR-EL-002', 12, 'in_stock', 1, 1, 1, '', 'laptop,gaming,rtx,computer'),
(4, 14, 2, 'Noise-Cancelling Wireless Headphones', 'noise-cancelling-wireless-headphones', 'Premium ANC headphones with 40h battery', 'Immerse yourself in pure sound with our Noise-Cancelling Wireless Headphones. Industry-leading ANC, 40-hour battery, premium leather cushions, and crystal-clear calls.', 29999.00, 22999.00, 23, 'VLR-EL-003', 45, 'in_stock', 1, 1, 0, '', 'headphones,wireless,anc,audio'),
(4, 15, 2, 'Smart Fitness Watch Pro', 'smart-fitness-watch-pro', 'Advanced health monitoring smartwatch', 'Track your fitness journey with our Smart Fitness Watch Pro. Heart rate, SpO2, sleep tracking, 100+ workout modes, and 14-day battery. Water resistant to 5ATM.', 19999.00, 14999.00, 25, 'VLR-EL-004', 35, 'in_stock', 0, 1, 1, '', 'smartwatch,fitness,wearable,health'),

-- Vehicle Accessories
(5, 16, 2, 'Premium Leather Car Seat Covers', 'premium-leather-car-seat-covers', 'Universal fit luxury leather seat covers', 'Upgrade your car interior with our Premium Leather Car Seat Covers. Universal fit, made from high-quality synthetic leather with foam padding for extra comfort.', 12999.00, 9999.00, 23, 'VLR-VA-001', 20, 'in_stock', 1, 0, 1, '', 'car,seat,leather,accessory'),
(5, 17, 2, 'Car Interior LED Light Kit', 'car-interior-led-light-kit', 'RGB LED ambient lighting with app control', 'Transform your car interior with our RGB LED Light Kit. 16 million colors, music sync, app control, and easy installation. Universal compatibility.', 4999.00, 2999.00, 40, 'VLR-VA-002', 50, 'in_stock', 0, 1, 1, '', 'led,car,interior,rgb'),
(5, 18, 2, 'All-Weather Floor Mats', 'all-weather-floor-mats', 'Custom-fit waterproof floor mats set', 'Protect your car interior with our All-Weather Floor Mats. Custom-fit design, waterproof, easy to clean, and durable rubber construction. Set of 4 mats.', 5999.00, 3999.00, 33, 'VLR-VA-003', 30, 'in_stock', 1, 1, 0, '', 'car,mats,floor,protection'),

-- Art
(6, 19, 5, 'Original Abstract Oil Painting', 'original-abstract-oil-painting', 'Hand-painted 36x48 inch abstract artwork', 'Add sophistication to your space with this Original Abstract Oil Painting. Hand-painted by renowned artists on premium canvas. Includes certificate of authenticity and ready-to-hang hardware.', 49999.00, 39999.00, 20, 'VLR-AR-001', 5, 'in_stock', 1, 0, 1, '', 'art,painting,abstract,canvas'),
(6, 20, 5, 'Bronze Sculpture - Modern Art', 'bronze-sculpture-modern-art', 'Handcrafted bronze sculpture 18 inches', 'This exquisite bronze sculpture represents the perfect blend of traditional craftsmanship and modern aesthetics. Hand-finished with a unique patina, this 18-inch sculpture makes a stunning centerpiece.', 79999.00, 64999.00, 19, 'VLR-AR-002', 3, 'in_stock', 1, 1, 0, '', 'sculpture,bronze,art,decor'),
(6, 22, 4, 'Handcrafted Wooden Wall Art', 'handcrafted-wooden-wall-art', 'Hand-carved wooden wall art piece', 'Beautiful hand-carved wooden wall art featuring intricate designs. Made from premium sustainable wood. 24x24 inches. Perfect for modern and traditional interiors.', 8999.00, 6499.00, 28, 'VLR-AR-003', 15, 'in_stock', 0, 1, 1, '', 'wood,art,handcrafted,wall');

-- Sample Banners
INSERT INTO banners (title, subtitle, link, image, status, sort_order) VALUES
('Discover Luxury', 'New collection of premium home decor', 'pages/shop.php?category=home-garden', 'banner-1.jpg', 1, 1),
('Flash Sale Live', 'Up to 50% off on selected items', 'pages/shop.php?sale=1', 'banner-2.jpg', 1, 2),
('New Arrivals', 'Explore our latest electronics', 'pages/shop.php?category=electronics', 'banner-3.jpg', 1, 3);

-- Sample Coupons
INSERT INTO coupons (code, type, value, min_cart_amount, usage_limit, start_date, end_date, status) VALUES
('WELCOME10', 'percentage', 10, 1000, 100, CURDATE(), DATE_ADD(CURDATE(), INTERVAL 30 DAY), 1),
('LUXURY20', 'percentage', 20, 5000, 50, CURDATE(), DATE_ADD(CURDATE(), INTERVAL 60 DAY), 1),
('FLAT500', 'fixed', 500, 2000, 200, CURDATE(), DATE_ADD(CURDATE(), INTERVAL 90 DAY), 1),
('FIRSTBUY', 'percentage', 15, 0, 0, CURDATE(), DATE_ADD(CURDATE(), INTERVAL 180 DAY), 1);

-- Sample Reviews
INSERT INTO reviews (product_id, user_id, name, email, rating, title, review, status, created_at) VALUES
(1, NULL, 'Priya Sharma', 'priya@example.com', 5, 'Absolutely Stunning!', 'This sofa set transformed my living room. The velvet quality is exceptional and the gold legs add the perfect touch of luxury. Highly recommended!', 1, NOW()),
(1, NULL, 'Rajesh Kumar', 'rajesh@example.com', 5, 'Worth every penny', 'Bought this 3 months ago and it still looks brand new. Very comfortable and well-made.', 1, NOW()),
(5, NULL, 'Anjali Patel', 'anjali@example.com', 5, 'Miracle in a bottle!', 'My skin has never looked better. The 24K gold serum is a game-changer. Worth every rupee!', 1, NOW()),
(5, NULL, 'Sneha Reddy', 'sneha@example.com', 4, 'Great product', 'Really good serum, only reason I gave 4 stars is the price. But quality is amazing!', 1, NOW()),
(12, NULL, 'Vikram Singh', 'vikram@example.com', 5, 'Best gaming laptop', 'Handles all my games at max settings. The 240Hz display is buttery smooth. Couldn''t be happier!', 1, NOW()),
(12, NULL, 'Arjun Mehta', 'arjun@example.com', 5, 'Beast of a machine', 'Powers through everything. The build quality is premium and the keyboard feels amazing for typing.', 1, NOW());

-- Sample Testimonial
-- Testimonials are hardcoded in the homepage; the database reviews are for products

-- Update product view counts
UPDATE products SET views = FLOOR(RAND() * 500) + 50;