USE mobile_repair;

-- Categories
INSERT INTO categories (name, slug, description, display_order) VALUES
('Mobile', 'mobile', 'Smartphone repair and spare parts', 1),
('Tablet', 'tablet', 'Tablet repair and spare parts', 2),
('Laptop', 'laptop', 'Laptop repair and spare parts', 3),
('Printer', 'printer', 'Printer repair and services', 4),
('CCTV', 'cctv', 'CCTV installation and repair', 5),
('Accessories', 'accessories', 'Mobile and laptop accessories', 6),
('Tools', 'tools', 'Repair tools and equipment', 7);

-- Brands
INSERT INTO brands (name, slug, image) VALUES
('Apple', 'apple', 'https://img.icons8.com/color/96/apple--v1.png'),
('Samsung', 'samsung', 'https://img.icons8.com/color/96/samsung.png'),
('OnePlus', 'oneplus', 'https://img.icons8.com/color/96/oneplus.png'),
('Xiaomi', 'xiaomi', 'https://img.icons8.com/color/96/xiaomi.png'),
('Vivo', 'vivo', 'https://img.icons8.com/color/96/vivo.png'),
('Oppo', 'oppo', 'https://img.icons8.com/color/96/oppo.png'),
('Google', 'google', 'https://img.icons8.com/color/96/google-logo.png'),
('Nokia', 'nokia', 'https://img.icons8.com/color/96/nokia.png'),
('Dell', 'dell', 'https://img.icons8.com/color/96/dell.png'),
('HP', 'hp', 'https://img.icons8.com/color/96/hp.png'),
('Lenovo', 'lenovo', 'https://img.icons8.com/color/96/lenovo.png'),
('ASUS', 'asus', 'https://img.icons8.com/color/96/asus.png'),
('Acer', 'acer', 'https://img.icons8.com/color/96/acer.png'),
('Microsoft', 'microsoft', 'https://img.icons8.com/color/96/microsoft.png'),
('Huawei', 'huawei', 'https://img.icons8.com/color/96/huawei.png'),
('Amazon', 'amazon', 'https://img.icons8.com/color/96/amazon.png');

-- Brand Categories
INSERT INTO brand_categories (brand_id, category_name) VALUES
(1, 'Mobile'), (1, 'Tablet'), (1, 'Laptop'),
(2, 'Mobile'), (2, 'Tablet'), (2, 'Laptop'),
(3, 'Mobile'),
(4, 'Mobile'),
(5, 'Mobile'),
(6, 'Mobile'),
(7, 'Mobile'), (7, 'Tablet'),
(8, 'Mobile'),
(9, 'Laptop'),
(10, 'Laptop'),
(11, 'Laptop'), (11, 'Tablet'),
(12, 'Laptop'),
(13, 'Laptop'),
(14, 'Laptop'),
(15, 'Tablet'),
(16, 'Tablet');

-- Brand Models
INSERT INTO brand_models (brand_id, category_name, model_name) VALUES
(1, 'Mobile', 'iPhone 16 Pro Max'), (1, 'Mobile', 'iPhone 16 Pro'), (1, 'Mobile', 'iPhone 16'),
(1, 'Mobile', 'iPhone 15 Pro Max'), (1, 'Mobile', 'iPhone 15 Pro'), (1, 'Mobile', 'iPhone 15'),
(1, 'Mobile', 'iPhone 14'), (1, 'Mobile', 'iPhone SE 3rd Gen'), (1, 'Mobile', 'iPhone 13'), (1, 'Mobile', 'iPhone 12'),
(1, 'Tablet', 'iPad Pro 12.9"'), (1, 'Tablet', 'iPad Pro 11"'), (1, 'Tablet', 'iPad Air'),
(1, 'Tablet', 'iPad 10th Gen'), (1, 'Tablet', 'iPad 9th Gen'), (1, 'Tablet', 'iPad Mini'),
(1, 'Laptop', 'MacBook Pro 16"'), (1, 'Laptop', 'MacBook Pro 14"'), (1, 'Laptop', 'MacBook Air 15"'), (1, 'Laptop', 'MacBook Air 13"'),
(2, 'Mobile', 'Galaxy S24 Ultra'), (2, 'Mobile', 'Galaxy S24+'), (2, 'Mobile', 'Galaxy S24'),
(2, 'Mobile', 'Galaxy S23'), (2, 'Mobile', 'Galaxy S22'), (2, 'Mobile', 'Galaxy A55'),
(2, 'Mobile', 'Galaxy A35'), (2, 'Mobile', 'Galaxy M34'), (2, 'Mobile', 'Galaxy F34'),
(2, 'Tablet', 'Galaxy Tab S9 Ultra'), (2, 'Tablet', 'Galaxy Tab S9+'), (2, 'Tablet', 'Galaxy Tab S9'),
(2, 'Tablet', 'Galaxy Tab A9+'), (2, 'Tablet', 'Galaxy Tab A8'), (2, 'Tablet', 'Galaxy Tab A7 Lite'),
(2, 'Laptop', 'Galaxy Book4 Ultra'), (2, 'Laptop', 'Galaxy Book4 Pro'), (2, 'Laptop', 'Galaxy Book3 360'), (2, 'Laptop', 'Galaxy Book2'),
(3, 'Mobile', 'OnePlus 12'), (3, 'Mobile', 'OnePlus 12R'), (3, 'Mobile', 'OnePlus 11'),
(3, 'Mobile', 'OnePlus 10T'), (3, 'Mobile', 'OnePlus Nord CE4'), (3, 'Mobile', 'OnePlus Nord 3'), (3, 'Mobile', 'OnePlus Nord CE3'),
(4, 'Mobile', 'Xiaomi 14 Pro'), (4, 'Mobile', 'Xiaomi 14'), (4, 'Mobile', 'Redmi Note 13 Pro'),
(4, 'Mobile', 'Redmi Note 13'), (4, 'Mobile', 'Redmi Note 12 Pro'), (4, 'Mobile', 'Poco X6 Pro'),
(4, 'Mobile', 'Poco M6'), (4, 'Mobile', 'Xiaomi 13T'),
(5, 'Mobile', 'Vivo X100 Pro'), (5, 'Mobile', 'Vivo V30 Pro'), (5, 'Mobile', 'Vivo V29'),
(5, 'Mobile', 'Vivo Y100'), (5, 'Mobile', 'Vivo Y28'), (5, 'Mobile', 'Vivo T3'), (5, 'Mobile', 'Vivo T2'),
(6, 'Mobile', 'Oppo Find X7 Ultra'), (6, 'Mobile', 'Oppo Reno 11 Pro'), (6, 'Mobile', 'Oppo Reno 11'),
(6, 'Mobile', 'Oppo F25 Pro'), (6, 'Mobile', 'Oppo A78'), (6, 'Mobile', 'Oppo A58'),
(7, 'Mobile', 'Pixel 9 Pro'), (7, 'Mobile', 'Pixel 9'), (7, 'Mobile', 'Pixel 8 Pro'),
(7, 'Mobile', 'Pixel 8'), (7, 'Mobile', 'Pixel 7a'), (7, 'Mobile', 'Pixel 7'),
(7, 'Tablet', 'Pixel Tablet'),
(8, 'Mobile', 'Nokia G42'), (8, 'Mobile', 'Nokia G22'), (8, 'Mobile', 'Nokia C32'),
(8, 'Mobile', 'Nokia X30'), (8, 'Mobile', 'Nokia G60'),
(9, 'Laptop', 'XPS 16'), (9, 'Laptop', 'XPS 15'), (9, 'Laptop', 'XPS 13'),
(9, 'Laptop', 'Inspiron 16'), (9, 'Laptop', 'Inspiron 14'), (9, 'Laptop', 'Latitude 15'),
(9, 'Laptop', 'Latitude 14'), (9, 'Laptop', 'Alienware m16'),
(10, 'Laptop', 'Spectre x360 16'), (10, 'Laptop', 'Pavilion 15'), (10, 'Laptop', 'Pavilion 14'),
(10, 'Laptop', 'Envy 16'), (10, 'Laptop', 'Victus 16'), (10, 'Laptop', 'EliteBook 840'), (10, 'Laptop', 'ProBook 450'),
(11, 'Laptop', 'ThinkPad X1 Carbon'), (11, 'Laptop', 'ThinkPad T14s'), (11, 'Laptop', 'IdeaPad 5'),
(11, 'Laptop', 'IdeaPad Slim 3'), (11, 'Laptop', 'Legion 5 Pro'), (11, 'Laptop', 'Yoga 7i'), (11, 'Laptop', 'ThinkBook 16'),
(11, 'Tablet', 'Tab P12'), (11, 'Tablet', 'Tab P11 Gen 2'), (11, 'Tablet', 'Tab M10 5G'), (11, 'Tablet', 'Tab M8 4th Gen'),
(12, 'Laptop', 'ROG Zephyrus G16'), (12, 'Laptop', 'ROG Strix G17'), (12, 'Laptop', 'TUF Gaming A15'),
(12, 'Laptop', 'Vivobook S 15'), (12, 'Laptop', 'Vivobook 16X'), (12, 'Laptop', 'ZenBook 14 OLED'),
(13, 'Laptop', 'Predator Helios 16'), (13, 'Laptop', 'Swift Go 14'), (13, 'Laptop', 'Aspire 5'),
(13, 'Laptop', 'Aspire 3'), (13, 'Laptop', 'Chromebook Spin 514'),
(14, 'Laptop', 'Surface Laptop 6'), (14, 'Laptop', 'Surface Laptop Go 3'), (14, 'Laptop', 'Surface Pro 10'), (14, 'Laptop', 'Surface Book 4'),
(15, 'Tablet', 'MatePad Pro 13.2"'), (15, 'Tablet', 'MatePad 11.5"'), (15, 'Tablet', 'MatePad SE 11"'),
(16, 'Tablet', 'Fire Max 11'), (16, 'Tablet', 'Fire HD 10'), (16, 'Tablet', 'Fire HD 8 Plus'), (16, 'Tablet', 'Fire HD 8'), (16, 'Tablet', 'Fire 7');

-- Banners
INSERT INTO banners (title, image, type, display_order) VALUES
('Banner 1', 'https://picsum.photos/seed/banner1/800/300', 'main', 1),
('Banner 2', 'https://picsum.photos/seed/banner2/800/300', 'main', 2),
('Banner 3', 'https://picsum.photos/seed/banner3/800/300', 'main', 3),
('Small Banner 1', 'https://picsum.photos/seed/small1/400/200', 'small', 1),
('Small Banner 2', 'https://picsum.photos/seed/small2/400/200', 'small', 2);

-- Testimonials
INSERT INTO testimonials (name, comment, rating, avatar, display_order) VALUES
('Rajesh Kumar', 'Excellent service! They fixed my phone screen in just 30 minutes. Highly recommended.', 5, 'RK', 1),
('Priya Sharma', 'Very professional team. They diagnosed my laptop issue accurately and fixed it at a reasonable price.', 4, 'PS', 2),
('Amit Singh', 'Great experience with their repair service. Technician arrived on time and did a thorough job.', 5, 'AS', 3),
('Sneha Patel', 'Trustworthy service for electronic repairs. They even provided a warranty for their work.', 4, 'SP', 4),
('Vikram Joshi', 'Best place for tablet repairs. Quick turnaround and friendly staff.', 5, 'VJ', 5);

-- Sample Products (insert via category IDs)
INSERT INTO products (name, slug, description, price, original_price, image, category_id, brand_name, stock)
SELECT CONCAT('Battery for ', b.name), LOWER(CONCAT('battery-', b.name, '-', c.id)), 'Original quality battery replacement', 499, 699, 'https://picsum.photos/seed/prod1/400/400', c.id, b.name, 20
FROM brands b, categories c WHERE c.name IN ('Mobile', 'Tablet', 'Laptop') LIMIT 30;
