-- Approximate McDonald's Egypt prices (EGP) pending official verification.
UPDATE menu_items mi
JOIN restaurants r ON r.id = mi.restaurant_id AND r.slug = 'mcdonalds'
SET
  mi.price = CASE mi.name
    -- Bundles
    WHEN 'Mix 2 Meal' THEN 180
    WHEN 'Share Box' THEN 320
    WHEN 'Grand Share Box' THEN 450
    -- Beef
    WHEN 'Big Mac®' THEN 150
    WHEN 'Big Tasty®' THEN 235
    WHEN 'Double Big Tasty®' THEN 310
    WHEN 'McRoyale®' THEN 170
    WHEN 'Double McRoyale®' THEN 240
    WHEN 'McDouble®' THEN 120
    WHEN 'Little Tasty' THEN 115
    WHEN 'Cheeseburger' THEN 75
    WHEN 'Double Cheeseburger' THEN 110
    WHEN 'Cheeseburger Deluxe' THEN 90
    WHEN 'Beefburger' THEN 65
    WHEN 'Double Beefburger' THEN 95
    -- Chicken & Fish
    WHEN 'McChicken®' THEN 130
    WHEN 'Double McChicken®' THEN 190
    WHEN 'Chicken Mac®' THEN 150
    WHEN 'Big Tasty® Chicken' THEN 235
    WHEN 'Grand Chicken Premier' THEN 205
    WHEN 'Grand Chicken Spicy' THEN 205
    WHEN 'Chicken Fillet' THEN 145
    WHEN 'Spicy Chicken Fillet' THEN 145
    WHEN 'Chicken MACDO®' THEN 70
    WHEN 'Spicy Chicken MACDO®' THEN 70
    WHEN 'Chicken MACDO® Deluxe' THEN 85
    WHEN 'Spicy Chicken MACDO® Deluxe' THEN 85
    WHEN 'McNuggets® 4 Pieces' THEN 85
    WHEN 'McNuggets® 6 Pieces' THEN 120
    WHEN 'McNuggets® 9 Pieces' THEN 165
    WHEN 'Filet-O-Fish®' THEN 140
    WHEN 'Double Filet-O-Fish®' THEN 195
    -- Sides & Salads
    WHEN 'McFries®' THEN 50
    WHEN 'Green Salad' THEN 70
    WHEN 'Chicken Caesar Salad' THEN 115
    -- Beverages
    WHEN 'Coca-Cola' THEN 35
    WHEN 'Coca-Cola Zero' THEN 35
    WHEN 'Sprite' THEN 35
    WHEN 'Fanta' THEN 35
    WHEN 'Mixology Blue Curaçao' THEN 60
    WHEN 'Mixology Strawberry' THEN 60
    WHEN 'Mixology Passion Fruit' THEN 60
    WHEN 'Orange Juice' THEN 50
    WHEN 'Water' THEN 20
    WHEN 'Chocolate Milkshake' THEN 80
    WHEN 'Vanilla Milkshake' THEN 80
    WHEN 'Strawberry Milkshake' THEN 80
    -- Happy Meal
    WHEN 'Happy Meal® Cheeseburger' THEN 130
    WHEN 'Happy Meal® Beefburger' THEN 120
    WHEN 'Happy Meal® McNuggets® 4 Pieces' THEN 140
    WHEN 'Happy Meal® Chicken MACDO®' THEN 130
    WHEN 'Happy Meal® Double Beefburger' THEN 145
    WHEN 'Happy Meal® Double Cheeseburger' THEN 155
    WHEN 'Happy Meal® McNuggets® 6 Pieces' THEN 165
    -- Desserts
    WHEN 'Ice Cream Cone' THEN 20
    WHEN 'Chocolate Fudge Sundae' THEN 50
    WHEN 'Caramel Sundae' THEN 50
    WHEN 'Strawberry Sundae' THEN 50
    WHEN 'Oreo McFlurry®' THEN 65
    WHEN 'Apple Pie' THEN 40
    -- Breakfast
    WHEN 'Egg McMuffin®' THEN 80
    WHEN 'McFalafel' THEN 45
    WHEN 'Hash Browns' THEN 30
    WHEN 'Chicken McMuffin®' THEN 80
    WHEN 'Spicy Chicken McMuffin®' THEN 80
    WHEN 'Chicken McMuffin® with Egg' THEN 90
    WHEN 'Spicy Chicken McMuffin® with Egg' THEN 90
    WHEN 'Egg & Cheese Wrap' THEN 85
    WHEN 'Big Breakfast' THEN 115
    -- McCafé
    WHEN 'Espresso' THEN 45
    WHEN 'Double Espresso' THEN 55
    WHEN 'Americano' THEN 55
    WHEN 'Flat White' THEN 70
    WHEN 'Latte' THEN 70
    WHEN 'Cappuccino' THEN 70
    WHEN 'Mochaccino' THEN 80
    WHEN 'Hot Chocolate' THEN 70
    WHEN 'Iced Latte' THEN 80
    WHEN 'Iced Mocha' THEN 90
    WHEN 'Latte Frappe' THEN 95
    WHEN 'Mocha Frappe' THEN 95
    WHEN 'Chocolate Frappe' THEN 95
    WHEN 'Caramel Frappe' THEN 95
    WHEN 'Mango Smoothie' THEN 95
    WHEN 'Passion Smoothie' THEN 95
    WHEN 'Blueberry Smoothie' THEN 95
    WHEN 'Strawberry Smoothie' THEN 95
    WHEN 'Hot Tea' THEN 35
    WHEN 'Green Sencha Tea' THEN 40
    WHEN 'Green Mint Tea' THEN 40
    WHEN 'Earl Grey Tea' THEN 40
    WHEN 'Chamomile Tea' THEN 40
    WHEN 'Juicy Forest Tea' THEN 40
    WHEN 'Plain Croissant' THEN 45
    WHEN 'Chocolate Muffin' THEN 55
    WHEN 'Skinny Blueberry Muffin' THEN 55
    WHEN 'Chocolate Fudge' THEN 75
    WHEN 'Red Velvet Cake' THEN 80
    WHEN 'Blueberry Cheese Cake' THEN 85
    WHEN 'Chocolate Walnut' THEN 80
    WHEN 'Chocolate Chip Cookie' THEN 35
    WHEN 'Double Chocolate Chip Cookie' THEN 40
    ELSE mi.price
  END,
  mi.is_available = 1,
  mi.description = 'Approximate price in EGP, subject to review.',
  mi.description_ar = 'سعر تقريبي بالجنيه المصري قابل للمراجعة.';
