mescloud/db/mysql/add_mes_erp_prd_instock_bind_menu.sql

-- 生产入库批次绑定明细菜单

-- 父菜单：生产管理 (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(), ''

);