-- Azan Shinwari Restaurant Menu Items
-- warehouse_id = 1
-- Note: This SQL assumes categories have been inserted first (run 01_menu_categories.sql)
-- For items with variants (Small/Medium/Large, Half/Full), separate entries are created

-- Get category IDs (assuming they were inserted in order)
SET @drink_bar = (SELECT id FROM restaurant_menu_categories WHERE name = 'DRINK Bar' AND warehouse_id = 1 LIMIT 1);
SET @tea_bar = (SELECT id FROM restaurant_menu_categories WHERE name = 'TEA Bar' AND warehouse_id = 1 LIMIT 1);
SET @ice_cream_shakes = (SELECT id FROM restaurant_menu_categories WHERE name = 'ICE CREAM Shakes' AND warehouse_id = 1 LIMIT 1);
SET @ice_cream_scoops = (SELECT id FROM restaurant_menu_categories WHERE name = 'ICE CREAM Scoops' AND warehouse_id = 1 LIMIT 1);
SET @mocktail = (SELECT id FROM restaurant_menu_categories WHERE name = 'MOCKTAIL' AND warehouse_id = 1 LIMIT 1);
SET @frappe = (SELECT id FROM restaurant_menu_categories WHERE name = 'FRAPPE' AND warehouse_id = 1 LIMIT 1);
SET @tandoor = (SELECT id FROM restaurant_menu_categories WHERE name = 'TANDOOR' AND warehouse_id = 1 LIMIT 1);
SET @salad_bar = (SELECT id FROM restaurant_menu_categories WHERE name = 'SALAD Bar' AND warehouse_id = 1 LIMIT 1);
SET @bar_bq = (SELECT id FROM restaurant_menu_categories WHERE name = 'BAR B.Q' AND warehouse_id = 1 LIMIT 1);
SET @starter = (SELECT id FROM restaurant_menu_categories WHERE name = 'STARTER' AND warehouse_id = 1 LIMIT 1);
SET @handi_special = (SELECT id FROM restaurant_menu_categories WHERE name = 'HANDI Special' AND warehouse_id = 1 LIMIT 1);
SET @shinwari = (SELECT id FROM restaurant_menu_categories WHERE name = 'SHINWARI' AND warehouse_id = 1 LIMIT 1);
SET @taka_tak = (SELECT id FROM restaurant_menu_categories WHERE name = 'TAKA TAK' AND warehouse_id = 1 LIMIT 1);
SET @pizza = (SELECT id FROM restaurant_menu_categories WHERE name = 'PIZZA' AND warehouse_id = 1 LIMIT 1);
SET @sandwich = (SELECT id FROM restaurant_menu_categories WHERE name = 'SANDWICH' AND warehouse_id = 1 LIMIT 1);
SET @burger = (SELECT id FROM restaurant_menu_categories WHERE name = 'BURGER' AND warehouse_id = 1 LIMIT 1);

-- DRINK Bar
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Cold Drink Can', 'Cold drink in can', 170.00, NULL, @drink_bar, 'DRINK Bar', 1, 1, 1, NOW(), NOW()),
('Cold Drink Regular', 'Regular cold drink', 130.00, NULL, @drink_bar, 'DRINK Bar', 1, 1, 2, NOW(), NOW()),
('Cold Drink 1.5', '1.5 liter cold drink', 270.00, NULL, @drink_bar, 'DRINK Bar', 1, 1, 3, NOW(), NOW()),
('Mineral Water Small', 'Small mineral water bottle', 90.00, NULL, @drink_bar, 'DRINK Bar', 1, 1, 4, NOW(), NOW()),
('Mineral Water Large', 'Large mineral water bottle', 170.00, NULL, @drink_bar, 'DRINK Bar', 1, 1, 5, NOW(), NOW());

-- TEA Bar
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Karak Tea', 'Traditional karak tea', 199.00, NULL, @tea_bar, 'TEA Bar', 1, 1, 1, NOW(), NOW()),
('Cardamom Tea', 'Cardamom flavored tea', 249.00, NULL, @tea_bar, 'TEA Bar', 1, 1, 2, NOW(), NOW()),
('Ginger Tea', 'Ginger tea', 299.00, NULL, @tea_bar, 'TEA Bar', 1, 1, 3, NOW(), NOW()),
('Peshawari Qehwa', 'Peshawari style qehwa', 229.00, NULL, @tea_bar, 'TEA Bar', 1, 1, 4, NOW(), NOW()),
('Lemon Grass', 'Lemon grass tea', 159.00, NULL, @tea_bar, 'TEA Bar', 1, 1, 5, NOW(), NOW()),
('Sulemani Qehwa', 'Sulemani qehwa', 159.00, NULL, @tea_bar, 'TEA Bar', 1, 1, 6, NOW(), NOW()),
('Green Tea', 'Green tea', 199.00, NULL, @tea_bar, 'TEA Bar', 1, 1, 7, NOW(), NOW()),
('Doodh Patti', 'Milk tea', 249.00, NULL, @tea_bar, 'TEA Bar', 1, 1, 8, NOW(), NOW()),
('Chocolate Tea', 'Chocolate flavored tea', 229.00, NULL, @tea_bar, 'TEA Bar', 1, 1, 9, NOW(), NOW());

-- ICE CREAM Shakes
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Vanilla Shake', 'Vanilla ice cream shake', 499.00, NULL, @ice_cream_shakes, 'ICE CREAM Shakes', 1, 1, 1, NOW(), NOW()),
('Chocolate Shake', 'Chocolate ice cream shake', 499.00, NULL, @ice_cream_shakes, 'ICE CREAM Shakes', 1, 1, 2, NOW(), NOW()),
('Strawberry Shake', 'Strawberry ice cream shake', 499.00, NULL, @ice_cream_shakes, 'ICE CREAM Shakes', 1, 1, 3, NOW(), NOW()),
('Oreo Shake', 'Oreo cookie shake', 499.00, NULL, @ice_cream_shakes, 'ICE CREAM Shakes', 1, 1, 4, NOW(), NOW()),
('KitKat Shake', 'KitKat shake', 549.00, NULL, @ice_cream_shakes, 'ICE CREAM Shakes', 1, 1, 5, NOW(), NOW()),
('Caramel Shake', 'Caramel shake', 499.00, NULL, @ice_cream_shakes, 'ICE CREAM Shakes', 1, 1, 6, NOW(), NOW()),
('Mango Shake', 'Mango shake', 499.00, NULL, @ice_cream_shakes, 'ICE CREAM Shakes', 1, 1, 7, NOW(), NOW()),
('Ice Cream Shake', 'Classic ice cream shake', 499.00, NULL, @ice_cream_shakes, 'ICE CREAM Shakes', 1, 1, 8, NOW(), NOW());

-- ICE CREAM Scoops
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Vanilla', 'Vanilla ice cream scoop', 249.00, NULL, @ice_cream_scoops, 'ICE CREAM Scoops', 1, 1, 1, NOW(), NOW()),
('Mango', 'Mango ice cream scoop', 249.00, NULL, @ice_cream_scoops, 'ICE CREAM Scoops', 1, 1, 2, NOW(), NOW()),
('Pista', 'Pista ice cream scoop', 249.00, NULL, @ice_cream_scoops, 'ICE CREAM Scoops', 1, 1, 3, NOW(), NOW()),
('Chocolate', 'Chocolate ice cream scoop', 249.00, NULL, @ice_cream_scoops, 'ICE CREAM Scoops', 1, 1, 4, NOW(), NOW()),
('Strawberry', 'Strawberry ice cream scoop', 249.00, NULL, @ice_cream_scoops, 'ICE CREAM Scoops', 1, 1, 5, NOW(), NOW());

-- MOCKTAIL
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Lemonade', 'Fresh lemonade', 250.00, NULL, @mocktail, 'MOCKTAIL', 1, 1, 1, NOW(), NOW()),
('Mint Margarita', 'Mint margarita mocktail', 250.00, NULL, @mocktail, 'MOCKTAIL', 1, 1, 2, NOW(), NOW()),
('Apple Lemonade', 'Apple lemonade', 429.00, NULL, @mocktail, 'MOCKTAIL', 1, 1, 3, NOW(), NOW()),
('Blue Colada', 'Blue colada mocktail', 429.00, NULL, @mocktail, 'MOCKTAIL', 1, 1, 4, NOW(), NOW()),
('Blueberry for Blue Colada', 'Blueberry blue colada', 449.00, NULL, @mocktail, 'MOCKTAIL', 1, 1, 5, NOW(), NOW()),
('Lagoon', 'Lagoon mocktail', 399.00, NULL, @mocktail, 'MOCKTAIL', 1, 1, 6, NOW(), NOW()),
('Frappes', 'Frappe mocktail', 399.00, NULL, @mocktail, 'MOCKTAIL', 1, 1, 7, NOW(), NOW()),
('Guava Mint', 'Guava mint mocktail', 349.00, NULL, @mocktail, 'MOCKTAIL', 1, 1, 8, NOW(), NOW()),
('Kiwi Lagoon', 'Kiwi lagoon mocktail', 399.00, NULL, @mocktail, 'MOCKTAIL', 1, 1, 9, NOW(), NOW());

-- FRAPPE
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Mint Frappe', 'Mint frappe', 379.00, NULL, @frappe, 'FRAPPE', 1, 1, 1, NOW(), NOW()),
('Vanilla Frappe', 'Vanilla frappe', 399.00, NULL, @frappe, 'FRAPPE', 1, 1, 2, NOW(), NOW()),
('Caramel Frappe', 'Caramel frappe', 379.00, NULL, @frappe, 'FRAPPE', 1, 1, 3, NOW(), NOW()),
('Cookies & Cream Frappe', 'Cookies and cream frappe', 429.00, NULL, @frappe, 'FRAPPE', 1, 1, 4, NOW(), NOW()),
('Cold Coffee', 'Cold coffee', 599.00, NULL, @frappe, 'FRAPPE', 1, 1, 5, NOW(), NOW()),
('Mint Mojito', 'Mint mojito', 299.00, NULL, @frappe, 'FRAPPE', 1, 1, 6, NOW(), NOW()),
('Strawberry Mojito', 'Strawberry mojito', 379.00, NULL, @frappe, 'FRAPPE', 1, 1, 7, NOW(), NOW()),
('Kiwi Mojito', 'Kiwi mojito', 379.00, NULL, @frappe, 'FRAPPE', 1, 1, 8, NOW(), NOW()),
('Peach', 'Peach frappe', 379.00, NULL, @frappe, 'FRAPPE', 1, 1, 9, NOW(), NOW()),
('Green Apple', 'Green apple frappe', 379.00, NULL, @frappe, 'FRAPPE', 1, 1, 10, NOW(), NOW()),
('Blue Lagoon', 'Blue lagoon frappe', 399.00, NULL, @frappe, 'FRAPPE', 1, 1, 11, NOW(), NOW());

-- TANDOOR
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Qandhari Naan', 'Qandhari style naan', 250.00, NULL, @tandoor, 'TANDOOR', 1, 1, 1, NOW(), NOW()),
('Plain Naan', 'Plain naan bread', 70.00, NULL, @tandoor, 'TANDOOR', 1, 1, 2, NOW(), NOW()),
('Roghni Naan', 'Roghni naan', 129.00, NULL, @tandoor, 'TANDOOR', 1, 1, 3, NOW(), NOW()),
('Peshawari Roti', 'Peshawari roti', 199.00, NULL, @tandoor, 'TANDOOR', 1, 1, 4, NOW(), NOW()),
('Khamiri Roti', 'Khamiri roti', 70.00, NULL, @tandoor, 'TANDOOR', 1, 1, 5, NOW(), NOW()),
('Sada Roti', 'Plain roti', 45.00, NULL, @tandoor, 'TANDOOR', 1, 1, 6, NOW(), NOW()),
('Kalwanji Naan', 'Kalwanji naan', 159.00, NULL, @tandoor, 'TANDOOR', 1, 1, 7, NOW(), NOW()),
('Garlic Naan', 'Garlic naan', 159.00, NULL, @tandoor, 'TANDOOR', 1, 1, 8, NOW(), NOW());

-- SALAD Bar
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Fresh Salad', 'Fresh vegetable salad', 199.00, NULL, @salad_bar, 'SALAD Bar', 1, 1, 1, NOW(), NOW()),
('Cachumber Salad', 'Cachumber salad', 299.00, NULL, @salad_bar, 'SALAD Bar', 1, 1, 2, NOW(), NOW()),
('Russian Salad', 'Russian salad', 595.00, NULL, @salad_bar, 'SALAD Bar', 1, 1, 3, NOW(), NOW()),
('Caesar Salad', 'Caesar salad', 695.00, NULL, @salad_bar, 'SALAD Bar', 1, 1, 4, NOW(), NOW()),
('Raita', 'Yogurt raita', 199.00, NULL, @salad_bar, 'SALAD Bar', 1, 1, 5, NOW(), NOW()),
('Mint Raita', 'Mint raita', 199.00, NULL, @salad_bar, 'SALAD Bar', 1, 1, 6, NOW(), NOW());

-- BAR B.Q
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Chicken Malai Boti (10 pcs)', 'Chicken malai boti - 10 pieces', 1499.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 1, NOW(), NOW()),
('Chicken Tikka Boti (10 pcs)', 'Chicken tikka boti - 10 pieces', 1099.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 2, NOW(), NOW()),
('Chicken Seekh Kabab (4 pcs)', 'Chicken seekh kabab - 4 pieces', 999.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 3, NOW(), NOW()),
('Chicken Reshmi Kabab (4 pcs)', 'Chicken reshmi kabab - 4 pieces', 1299.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 4, NOW(), NOW()),
('Chicken Cheese Kabab (4 pcs)', 'Chicken cheese kabab - 4 pieces', 1399.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 5, NOW(), NOW()),
('Chicken Tikka Pieces (Leg & Chest) (1 Pc)', 'Chicken tikka piece - leg or chest', 599.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 6, NOW(), NOW()),
('Pasha Boti', 'Pasha boti', 1799.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 7, NOW(), NOW()),
('Green boti', 'Green boti', 1699.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 8, NOW(), NOW()),
('Kastoori Boti (8 pcs)', 'Kastoori boti - 8 pieces', 1599.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 9, NOW(), NOW()),
('Special Afghani Boti (10 pcs)', 'Special Afghani boti - 10 pieces', 1199.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 10, NOW(), NOW()),
('Mutton Namkeen Tikka (1 KG)', 'Mutton namkeen tikka - 1 kilogram', 4199.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 11, NOW(), NOW()),
('Mutton Tikka (1 KG)', 'Mutton tikka - 1 kilogram', 4199.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 12, NOW(), NOW()),
('Mutton Chops (1 KG)', 'Mutton chops - 1 kilogram', 4199.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 13, NOW(), NOW()),
('Shish Touk', 'Shish touk', 1299.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 14, NOW(), NOW()),
('Mutton Seekh Kabab (4 pcs)', 'Mutton seekh kabab - 4 pieces', 1595.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 15, NOW(), NOW()),
('Bar B.Q Mix Platter Full', 'Full mix platter - 4 Pieces Chicken Kabab, 4 Pieces Mutton Kabab, 8 Pieces Malai Boti, 8 Pieces Kastoori boti, 8 Pieces Chicken Boti, 1 Chest Piece, 4 Naan, 1 Raita With Kabli Pulao & French Fries', 8799.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 16, NOW(), NOW()),
('Bar B.Q Mix Platter Half', 'Half mix platter - 2 Pieces Chicken Kabab, 2 Pieces Mutton Kabab, 4 Pieces Malai Boti, 4 Pieces Kastoori boti, 4 Pieces Chicken Boti, 2 Chest Piece, 2 Naan, 2 Roti With Kabli Pulao & French Fries', 4399.00, NULL, @bar_bq, 'BAR B.Q', 1, 1, 17, NOW(), NOW());

-- STARTER
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Mozzarella Cheese Sticks (4 Pieces)', 'Mozzarella cheese sticks - 4 pieces', 1095.00, NULL, @starter, 'STARTER', 1, 1, 1, NOW(), NOW()),
('Finger Fish', 'Finger fish', 1499.00, NULL, @starter, 'STARTER', 1, 1, 2, NOW(), NOW()),
('Fish n Chips (3 Fillet)', 'Fish and chips - 3 fillets', 1599.00, NULL, @starter, 'STARTER', 1, 1, 3, NOW(), NOW()),
('Honey Wings (8 Pieces)', 'Honey wings - 8 pieces', 999.00, NULL, @starter, 'STARTER', 1, 1, 4, NOW(), NOW()),
('Chicken Nuggets', 'Chicken nuggets', 649.00, NULL, @starter, 'STARTER', 1, 1, 5, NOW(), NOW()),
('Crispy Fried Wings', 'Crispy fried wings', 1195.00, NULL, @starter, 'STARTER', 1, 1, 6, NOW(), NOW()),
('Loaded Fries', 'Loaded fries', 699.00, NULL, @starter, 'STARTER', 1, 1, 7, NOW(), NOW()),
('Fish Crackers', 'Fish crackers', 349.00, NULL, @starter, 'STARTER', 1, 1, 8, NOW(), NOW());

-- HANDI Special (with Half/Full variants)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Chicken Handi', 'Chicken handi', 1999.00, NULL, @handi_special, 'HANDI Special', 1, 1, 1, NOW(), NOW()),
('Madrasi Handi', 'Madrasi handi', 1999.00, NULL, @handi_special, 'HANDI Special', 1, 1, 2, NOW(), NOW()),
('Rajhistani Handi', 'Rajasthani handi', 1999.00, NULL, @handi_special, 'HANDI Special', 1, 1, 3, NOW(), NOW()),
('Chicken Sajji', 'Chicken sajji', 2599.00, NULL, @handi_special, 'HANDI Special', 1, 1, 4, NOW(), NOW()),
('Khadda Sajji', 'Khadda sajji', 5500.00, NULL, @handi_special, 'HANDI Special', 1, 1, 5, NOW(), NOW()),
('Plain Steam Rice', 'Plain steamed rice', 350.00, NULL, @handi_special, 'HANDI Special', 1, 1, 6, NOW(), NOW()),
('Chicken Ginger', 'Chicken ginger handi', 1999.00, NULL, @handi_special, 'HANDI Special', 1, 1, 7, NOW(), NOW()),
('Chicken Jalfrezi', 'Chicken jalfrezi', 1999.00, NULL, @handi_special, 'HANDI Special', 1, 1, 8, NOW(), NOW()),
('Chicken Makhni Handi', 'Chicken makhni handi', 1999.00, NULL, @handi_special, 'HANDI Special', 1, 1, 9, NOW(), NOW()),
('Chicken Karahi - Half', 'Chicken karahi - half portion', 1199.00, NULL, @handi_special, 'HANDI Special', 1, 1, 10, NOW(), NOW()),
('Chicken Karahi - Full', 'Chicken karahi - full portion', 2299.00, NULL, @handi_special, 'HANDI Special', 1, 1, 11, NOW(), NOW()),
('Chicken White - Half', 'Chicken white - half portion', 1199.00, NULL, @handi_special, 'HANDI Special', 1, 1, 12, NOW(), NOW()),
('Chicken White - Full', 'Chicken white - full portion', 2299.00, NULL, @handi_special, 'HANDI Special', 1, 1, 13, NOW(), NOW()),
('Chicken Peshawari Karahi - Half', 'Chicken Peshawari karahi - half portion', 1299.00, NULL, @handi_special, 'HANDI Special', 1, 1, 14, NOW(), NOW()),
('Chicken Peshawari Karahi - Full', 'Chicken Peshawari karahi - full portion', 2399.00, NULL, @handi_special, 'HANDI Special', 1, 1, 15, NOW(), NOW()),
('Chicken Afghani Karahi - Half', 'Chicken Afghani karahi - half portion', 1399.00, NULL, @handi_special, 'HANDI Special', 1, 1, 16, NOW(), NOW()),
('Chicken Afghani Karahi - Full', 'Chicken Afghani karahi - full portion', 2599.00, NULL, @handi_special, 'HANDI Special', 1, 1, 17, NOW(), NOW());

-- SHINWARI (with Half/Full variants)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Azan Special Ribs With Rice', 'Azan special ribs with rice', 4999.00, NULL, @shinwari, 'SHINWARI', 1, 1, 1, NOW(), NOW()),
('Mutton Shinwari - Half', 'Mutton shinwari - half portion', 2199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 2, NOW(), NOW()),
('Mutton Shinwari - Full', 'Mutton shinwari - full portion', 4199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 3, NOW(), NOW()),
('Mutton Sulemani - Half', 'Mutton sulemani - half portion', 2199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 4, NOW(), NOW()),
('Mutton Sulemani - Full', 'Mutton sulemani - full portion', 4199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 5, NOW(), NOW()),
('Mutton Masala Rosh', 'Mutton masala rosh', 4199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 6, NOW(), NOW()),
('Namkeen Rosh', 'Namkeen rosh', 4199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 7, NOW(), NOW()),
('Yakhni Rosh', 'Yakhni rosh', 4199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 8, NOW(), NOW()),
('Kabli Pulao', 'Kabli pulao', 1699.00, NULL, @shinwari, 'SHINWARI', 1, 1, 9, NOW(), NOW()),
('Chicken Shinwari - Half', 'Chicken shinwari - half portion', 1199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 10, NOW(), NOW()),
('Chicken Shinwari - Full', 'Chicken shinwari - full portion', 2299.00, NULL, @shinwari, 'SHINWARI', 1, 1, 11, NOW(), NOW()),
('Shinwari Qeema', 'Shinwari qeema', 4199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 12, NOW(), NOW()),
('Sulemani Qeema', 'Sulemani qeema', 4199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 13, NOW(), NOW()),
('Salam Dumba', 'Salam dumba', 54990.00, NULL, @shinwari, 'SHINWARI', 1, 1, 14, NOW(), NOW()),
('Raan Roast', 'Raan roast', 4499.00, NULL, @shinwari, 'SHINWARI', 1, 1, 15, NOW(), NOW()),
('Mutton Joint', 'Mutton joint', 1799.00, NULL, @shinwari, 'SHINWARI', 1, 1, 16, NOW(), NOW()),
('Dampukht', 'Dampukht', 4333.00, NULL, @shinwari, 'SHINWARI', 1, 1, 17, NOW(), NOW()),
('Mutton Yakhni Pulao', 'Mutton yakhni pulao', 2499.00, NULL, @shinwari, 'SHINWARI', 1, 1, 18, NOW(), NOW()),
('Azan Special Desi Murgh', 'Azan special desi murgh', 4199.00, NULL, @shinwari, 'SHINWARI', 1, 1, 19, NOW(), NOW());

-- TAKA TAK (with Half/Full variants)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Mix Taka tak', 'Mix taka tak', 2499.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 1, NOW(), NOW()),
('Brain Masala', 'Brain masala', 1599.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 2, NOW(), NOW()),
('Special Taka tak', 'Special taka tak', 2699.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 3, NOW(), NOW()),
('Tawa Pc', 'Tawa piece', 799.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 4, NOW(), NOW()),
('Mutton Tawa Chops', 'Mutton tawa chops', 2499.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 5, NOW(), NOW()),
('Chicken Tawa Karahi - Half', 'Chicken tawa karahi - half portion', 1299.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 6, NOW(), NOW()),
('Chicken Tawa Karahi - Full', 'Chicken tawa karahi - full portion', 2499.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 7, NOW(), NOW()),
('Chicken Tawa Kabab Masala', 'Chicken tawa kabab masala', 1399.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 8, NOW(), NOW()),
('Mutton Kabab Masala', 'Mutton kabab masala', 1799.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 9, NOW(), NOW()),
('Mutton Tawa Qeema', 'Mutton tawa qeema', 3199.00, NULL, @taka_tak, 'TAKA TAK', 1, 1, 10, NOW(), NOW());

-- PIZZA (with Small/Medium/Large variants)
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('BBQ Pizza - Small', 'BBQ pizza - small size', 799.00, NULL, @pizza, 'PIZZA', 1, 1, 1, NOW(), NOW()),
('BBQ Pizza - Medium', 'BBQ pizza - medium size', 1199.00, NULL, @pizza, 'PIZZA', 1, 1, 2, NOW(), NOW()),
('BBQ Pizza - Large', 'BBQ pizza - large size', 1999.00, NULL, @pizza, 'PIZZA', 1, 1, 3, NOW(), NOW()),
('Azan Special Muglai Pizza - Small', 'Azan special muglai pizza - small size', 899.00, NULL, @pizza, 'PIZZA', 1, 1, 4, NOW(), NOW()),
('Azan Special Muglai Pizza - Medium', 'Azan special muglai pizza - medium size', 1299.00, NULL, @pizza, 'PIZZA', 1, 1, 5, NOW(), NOW()),
('Azan Special Muglai Pizza - Large', 'Azan special muglai pizza - large size', 2199.00, NULL, @pizza, 'PIZZA', 1, 1, 6, NOW(), NOW()),
('Chicken Tikka Pizza - Small', 'Chicken tikka pizza - small size', 799.00, NULL, @pizza, 'PIZZA', 1, 1, 7, NOW(), NOW()),
('Chicken Tikka Pizza - Medium', 'Chicken tikka pizza - medium size', 1099.00, NULL, @pizza, 'PIZZA', 1, 1, 8, NOW(), NOW()),
('Chicken Tikka Pizza - Large', 'Chicken tikka pizza - large size', 1999.00, NULL, @pizza, 'PIZZA', 1, 1, 9, NOW(), NOW()),
('Chicken Fajita Pizza - Small', 'Chicken fajita pizza - small size', 799.00, NULL, @pizza, 'PIZZA', 1, 1, 10, NOW(), NOW()),
('Chicken Fajita Pizza - Medium', 'Chicken fajita pizza - medium size', 1099.00, NULL, @pizza, 'PIZZA', 1, 1, 11, NOW(), NOW()),
('Chicken Fajita Pizza - Large', 'Chicken fajita pizza - large size', 1999.00, NULL, @pizza, 'PIZZA', 1, 1, 12, NOW(), NOW()),
('Chicken Supreeme Pizza - Small', 'Chicken supreme pizza - small size', 799.00, NULL, @pizza, 'PIZZA', 1, 1, 13, NOW(), NOW()),
('Chicken Supreeme Pizza - Medium', 'Chicken supreme pizza - medium size', 1299.00, NULL, @pizza, 'PIZZA', 1, 1, 14, NOW(), NOW()),
('Chicken Supreeme Pizza - Large', 'Chicken supreme pizza - large size', 2099.00, NULL, @pizza, 'PIZZA', 1, 1, 15, NOW(), NOW()),
('Milano Pizza - Small', 'Milano pizza - small size', 849.00, NULL, @pizza, 'PIZZA', 1, 1, 16, NOW(), NOW()),
('Milano Pizza - Medium', 'Milano pizza - medium size', 1399.00, NULL, @pizza, 'PIZZA', 1, 1, 17, NOW(), NOW()),
('Milano Pizza - Large', 'Milano pizza - large size', 2199.00, NULL, @pizza, 'PIZZA', 1, 1, 18, NOW(), NOW()),
('Chilli Hot Pizza - Small', 'Chilli hot pizza - small size', 799.00, NULL, @pizza, 'PIZZA', 1, 1, 19, NOW(), NOW()),
('Chilli Hot Pizza - Medium', 'Chilli hot pizza - medium size', 1099.00, NULL, @pizza, 'PIZZA', 1, 1, 20, NOW(), NOW()),
('Chilli Hot Pizza - Large', 'Chilli hot pizza - large size', 2099.00, NULL, @pizza, 'PIZZA', 1, 1, 21, NOW(), NOW()),
('Peproni Pizza - Small', 'Pepperoni pizza - small size', 899.00, NULL, @pizza, 'PIZZA', 1, 1, 22, NOW(), NOW()),
('Peproni Pizza - Medium', 'Pepperoni pizza - medium size', 1299.00, NULL, @pizza, 'PIZZA', 1, 1, 23, NOW(), NOW()),
('Peproni Pizza - Large', 'Pepperoni pizza - large size', 1999.00, NULL, @pizza, 'PIZZA', 1, 1, 24, NOW(), NOW()),
('Crown Crust Pizza - Small', 'Crown crust pizza - small size', 999.00, NULL, @pizza, 'PIZZA', 1, 1, 25, NOW(), NOW()),
('Crown Crust Pizza - Medium', 'Crown crust pizza - medium size', 1299.00, NULL, @pizza, 'PIZZA', 1, 1, 26, NOW(), NOW()),
('Crown Crust Pizza - Large', 'Crown crust pizza - large size', 2199.00, NULL, @pizza, 'PIZZA', 1, 1, 27, NOW(), NOW()),
('Kabab Crust Pizza - Small', 'Kabab crust pizza - small size', 999.00, NULL, @pizza, 'PIZZA', 1, 1, 28, NOW(), NOW()),
('Kabab Crust Pizza - Medium', 'Kabab crust pizza - medium size', 1399.00, NULL, @pizza, 'PIZZA', 1, 1, 29, NOW(), NOW()),
('Kabab Crust Pizza - Large', 'Kabab crust pizza - large size', 2199.00, NULL, @pizza, 'PIZZA', 1, 1, 30, NOW(), NOW());

-- SANDWICH
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Azan Special Sandwich', 'Azan special sandwich', 1050.00, NULL, @sandwich, 'SANDWICH', 1, 1, 1, NOW(), NOW()),
('Cold Chicken Sandwich', 'Cold chicken sandwich', 649.00, NULL, @sandwich, 'SANDWICH', 1, 1, 2, NOW(), NOW()),
('Grilled Chicken Sandwich', 'Grilled chicken sandwich', 999.00, NULL, @sandwich, 'SANDWICH', 1, 1, 3, NOW(), NOW()),
('Panini Sandwich', 'Panini sandwich', 1050.00, NULL, @sandwich, 'SANDWICH', 1, 1, 4, NOW(), NOW()),
('Egg & Cheese Sandwich', 'Egg and cheese sandwich', 650.00, NULL, @sandwich, 'SANDWICH', 1, 1, 5, NOW(), NOW());

-- BURGER
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `image`, `restaurant_category_id`, `restaurant_category_name`, `warehouse_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Azan Special King Burger', 'Azan special king burger - served with fries and coleslaw', 1199.00, NULL, @burger, 'BURGER', 1, 1, 1, NOW(), NOW()),
('Azan Special Chicken Burger', 'Azan special chicken burger - served with fries and coleslaw', 799.00, NULL, @burger, 'BURGER', 1, 1, 2, NOW(), NOW()),
('Azan Special Beef Burger', 'Azan special beef burger - served with fries and coleslaw', 1199.00, NULL, @burger, 'BURGER', 1, 1, 3, NOW(), NOW()),
('Azan Special Crunch Burger', 'Azan special crunch burger - served with fries and coleslaw', 799.00, NULL, @burger, 'BURGER', 1, 1, 4, NOW(), NOW()),
('Zinger Burger', 'Zinger burger - served with fries and coleslaw', 999.00, NULL, @burger, 'BURGER', 1, 1, 5, NOW(), NOW()),
('Grilled Cheese Burger', 'Grilled cheese burger - served with fries and coleslaw', 649.00, NULL, @burger, 'BURGER', 1, 1, 6, NOW(), NOW()),
('Jalapeno Chicken Burger', 'Jalapeno chicken burger - served with fries and coleslaw', 1099.00, NULL, @burger, 'BURGER', 1, 1, 7, NOW(), NOW());

