-- 生产入库批次绑定明细菜单 -- 父菜单:生产管理 (menu_code: 1672118505143263232) DELETE FROM `js_sys_menu` WHERE `menu_code` = 'mesErpPrdInstockLog'; INSERT INTO `js_sys_menu` ( `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`, `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`, `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks` ) VALUES ( 'mesErpPrdInstockLog', '1672118505143263232', '0,1672118505143263232,', 153, '0000009290,0000000153,', '1', 1, '生产管理/生产入库批次绑定', '生产入库批次绑定', '1', '/mes/mesErpPrdInstockLog/list', '', 'fa-link', '', '', 'mes:mesErpPrdInstockLog:view', 84, '1', 'default', 'core', NULL, NULL, '0', 'system', NOW(), 'system', NOW(), '独立菜单权限;从 ERP 入库单列表点「绑定」时 mes:erpPrdInStock:view 亦可访问' ); -- 可选:作为 ERP 生产入库子权限(便于角色授权,与 erpPrdInStock 菜单同组) DELETE FROM `js_sys_menu` WHERE `menu_code` = 'erpPrdInStockBind'; INSERT INTO `js_sys_menu` ( `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`, `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`, `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`, `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks` ) VALUES ( 'erpPrdInStockBind', 'erpPrdInStock', '0,1672118505143263232,erpPrdInStock,', 30, '0000009290,0000000151,0000000030,', '1', 2, '生产管理/ERP生产入库单查询/批次绑定明细', '批次绑定明细', '2', '', '', '', '', '', 'mes:mesErpPrdInstockLog:view', 82, '0', 'default', 'core', NULL, NULL, '0', 'system', NOW(), 'system', NOW(), '' );