-- 废料管理菜单和权限;业务表需先执行 20261103_wm_scrap.sql。 -- 初始授权超级管理员,其他角色请在角色管理中按职责配置。 INSERT INTO system_menu(name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,creator,updater,deleted) SELECT '废料管理','',2,80,5780,'scrap','ep:box','wls/scrap/index','WlsScrap',0,b'1',b'0',b'1','1','1',b'0' WHERE EXISTS (SELECT 1 FROM system_menu WHERE id=5780 AND deleted=b'0') AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component='wls/scrap/index' AND deleted=b'0'); SET @scrap_menu_id = (SELECT id FROM system_menu WHERE component='wls/scrap/index' AND deleted=b'0' ORDER BY id LIMIT 1); INSERT INTO system_menu(name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,creator,updater,deleted) SELECT p.name,p.permission,3,p.sort,@scrap_menu_id,'','','','',0,b'1',b'0',b'1','1','1',b'0' FROM ( SELECT '废料入库查询' name,'mes:wm-scrap-receipt:query' permission,1 sort UNION ALL SELECT '废料入库登记','mes:wm-scrap-receipt:create',2 UNION ALL SELECT '废料出售查询','mes:wm-scrap-sale:query',3 UNION ALL SELECT '废料出售创建','mes:wm-scrap-sale:create',4 UNION ALL SELECT '废料出售提交审批','mes:wm-scrap-sale:submit',5 ) p WHERE @scrap_menu_id IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.permission=p.permission AND m.deleted=b'0'); INSERT INTO system_role_menu(role_id,menu_id,creator,updater,deleted) SELECT r.id,m.id,'1','1',b'0' FROM system_role r JOIN system_menu m ON m.deleted=b'0' AND (m.id=@scrap_menu_id OR m.parent_id=@scrap_menu_id) WHERE r.code='super_admin' AND r.deleted=b'0' AND NOT EXISTS (SELECT 1 FROM system_role_menu rm WHERE rm.role_id=r.id AND rm.menu_id=m.id AND rm.deleted=b'0');