-- Menu Categories and Items from Menu Image
-- For Restaurant ID 1 and Branch ID 1
-- Note: Delete existing records for this restaurant/branch if you want to re-run this script

-- Delete existing menu items and categories for restaurant_id = 1 and branch_id = 1 (optional - uncomment if needed)
-- DELETE FROM pos_menu_items WHERE restaurant_id = 1 AND branch_id = 1;
-- DELETE FROM restaurant_menu_categories WHERE restaurant_id = 1 AND branch_id = 1;

-- Insert Menu Categories
INSERT INTO `restaurant_menu_categories` (`name`, `description`, `status`, `sort_order`, `restaurant_id`, `branch_id`, `created_at`, `updated_at`) VALUES
('ROCK N ROLL', 'Wraps and Shawarmas', 1, 1, 1, 1, NOW(), NOW()),
('DEALS', 'Special Deal Packages', 1, 2, 1, 1, NOW(), NOW()),
('FAMILY PLATTER', 'Family Platter Packages', 1, 3, 1, 1, NOW(), NOW());

-- Get category IDs
SET @rock_n_roll = (SELECT id FROM restaurant_menu_categories WHERE name = 'ROCK N ROLL' AND restaurant_id = 1 AND branch_id = 1 LIMIT 1);
SET @deals = (SELECT id FROM restaurant_menu_categories WHERE name = 'DEALS' AND restaurant_id = 1 AND branch_id = 1 LIMIT 1);
SET @family_platter = (SELECT id FROM restaurant_menu_categories WHERE name = 'FAMILY PLATTER' AND restaurant_id = 1 AND branch_id = 1 LIMIT 1);

-- Insert ROCK N ROLL Menu Items
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `restaurant_category_id`, `restaurant_category_name`, `restaurant_id`, `branch_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Chicken Shawarma', 'Delicious chicken shawarma wrap', 499.00, @rock_n_roll, 'ROCK N ROLL', 1, 1, 1, 1, NOW(), NOW()),
('Platter Shawarma', 'Platter shawarma wrap', 999.00, @rock_n_roll, 'ROCK N ROLL', 1, 1, 1, 2, NOW(), NOW()),
('Pocket Shawarma', 'Pocket shawarma wrap', 799.00, @rock_n_roll, 'ROCK N ROLL', 1, 1, 1, 3, NOW(), NOW()),
('Arabian Shawarma', 'Arabian style shawarma wrap', 999.00, @rock_n_roll, 'ROCK N ROLL', 1, 1, 1, 4, NOW(), NOW()),
('Zingerilla Wrap', 'Zingerilla wrap', 649.00, @rock_n_roll, 'ROCK N ROLL', 1, 1, 1, 5, NOW(), NOW()),
('Fillet Wrap', 'Fillet wrap', 649.00, @rock_n_roll, 'ROCK N ROLL', 1, 1, 1, 6, NOW(), NOW()),
('Malai Boti Wrap', 'Malai boti wrap', 799.00, @rock_n_roll, 'ROCK N ROLL', 1, 1, 1, 7, NOW(), NOW());

-- Insert DEALS Menu Items
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `restaurant_category_id`, `restaurant_category_name`, `restaurant_id`, `branch_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('DEAL 01', '1 Large Pizza Milano, 1 Small Pizza BBQ, 2 Regular Cold Drink', 2099.00, @deals, 'DEALS', 1, 1, 1, 1, NOW(), NOW()),
('DEAL 02', '2 Large Chicken Tikka Pizza, 1.5 Ltr Cold Drink', 2899.00, @deals, 'DEALS', 1, 1, 1, 2, NOW(), NOW()),
('DEAL 03', '1 Small Pizza, 1 Zinger Burger, 2 Regular Cold Drink', 1399.00, @deals, 'DEALS', 1, 1, 1, 3, NOW(), NOW()),
('DEAL 04', '2 Small Malai Boti Pizza, 1.5 Ltr Cold Drink', 1999.00, @deals, 'DEALS', 1, 1, 1, 4, NOW(), NOW());

-- Insert FAMILY PLATTER Menu Item
INSERT INTO `pos_menu_items` (`name`, `description`, `price`, `restaurant_category_id`, `restaurant_category_name`, `restaurant_id`, `branch_id`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
('Family Platter 8 Person', '1 Chicken Karahi (Full), 1 Chicken Kabab (Plate), 1 Chicken Malai (Plate), 1 Kabali Pulao (Plate), 1 Large Pizza, Roghni Naan (4), Roti (4 Per Head), 1 Salad + 2 Raita', 8999.00, @family_platter, 'FAMILY PLATTER', 1, 1, 1, 1, NOW(), NOW());