-- 出肉率分析菜单（父菜单：生产管理 2176）
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
SELECT '出肉率分析', 2176, 43, 'meatYieldAnalysis', 'production/meatYieldAnalysis/index', NULL, '', 1, 0, 'C', '0', '0', 'production:meatYieldAnalysis:list', 'chart', 'admin', NOW(), '', NULL, ''
FROM DUAL
WHERE NOT EXISTS (
  SELECT 1 FROM `sys_menu` WHERE `path` = 'meatYieldAnalysis' AND `parent_id` = 2176
);
