add_erp_prd_in_stock_menu.sql 931 B

1234567891011121314151617
  1. -- ERP 生产入库单查询菜单
  2. -- 父菜单:生产管理 (menu_code: 1672118505143263232)
  3. DELETE FROM `js_sys_menu` WHERE `menu_code` = 'erpPrdInStock';
  4. INSERT INTO `js_sys_menu` (
  5. `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  6. `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  7. `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  8. `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
  9. ) VALUES (
  10. 'erpPrdInStock', '1672118505143263232', '0,1672118505143263232,',
  11. 151, '0000009290,0000000151,', '1', 1,
  12. '生产管理/ERP生产入库单查询', 'ERP生产入库单查询', '1', '/mes/erpPrdInStock/list', '',
  13. 'fa-download', '', '', 'mes:erpPrdInStock:view', 82, '1', 'default', 'core', NULL, NULL,
  14. '0', 'system', NOW(), 'system', NOW(), ''
  15. );