1
2
3
4
5
6
7
8
9
10
11
12
| -- mom-hm 库存现有量导入权限补丁，可重复执行。
| -- 根据组件名定位父菜单，以 MAX(id)+1 分配按钮编号，恢复软删除/禁用的权限。
| -- 仅默认授权超级管理员；业务角色请在角色管理中勾选“库存现有量导入”。
| -- 执行后重新登录；若后端曾缓存缺失权限，在菜单管理中保存该按钮以刷新权限缓存。
|
| INSERT INTO `mom-hm`.system_menu (id,name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,creator,create_time,updater,update_time,deleted) SELECT next_id.id,'库存现有量导入','mes:wm-material-stock:import',3,8,parent.id,'','#','',NULL,0,b'1',b'0',b'1','1',NOW(),'1',NOW(),b'0' FROM `mom-hm`.system_menu parent CROSS JOIN (SELECT COALESCE(MAX(id),0)+1 AS id FROM `mom-hm`.system_menu) next_id WHERE parent.component_name='MesWmMaterialStock' AND parent.type=2 AND parent.deleted=b'0' AND NOT EXISTS (SELECT 1 FROM `mom-hm`.system_menu WHERE permission='mes:wm-material-stock:import');
|
| UPDATE `mom-hm`.system_menu child JOIN `mom-hm`.system_menu parent ON parent.component_name='MesWmMaterialStock' AND parent.type=2 AND parent.deleted=b'0' SET child.parent_id=parent.id,child.type=3,child.status=0,child.deleted=b'0',child.updater='1',child.update_time=NOW() WHERE child.permission='mes:wm-material-stock:import' AND (child.parent_id<>parent.id OR child.type<>3 OR child.status<>0 OR child.deleted<>b'0');
|
| INSERT INTO `mom-hm`.system_role_menu (role_id,menu_id,creator,create_time,updater,update_time,deleted) SELECT r.id,m.id,'1',NOW(),'1',NOW(),b'0' FROM `mom-hm`.system_role r JOIN `mom-hm`.system_menu m ON m.permission='mes:wm-material-stock:import' AND m.deleted=b'0' WHERE r.code='super_admin' AND r.deleted=b'0' AND NOT EXISTS (SELECT 1 FROM `mom-hm`.system_role_menu rm WHERE rm.role_id=r.id AND rm.menu_id=m.id);
|
| UPDATE `mom-hm`.system_role_menu rm JOIN `mom-hm`.system_role r ON r.id=rm.role_id AND r.code='super_admin' AND r.deleted=b'0' JOIN `mom-hm`.system_menu m ON m.id=rm.menu_id AND m.permission='mes:wm-material-stock:import' AND m.deleted=b'0' SET rm.deleted=b'0',rm.updater='1',rm.update_time=NOW() WHERE rm.deleted<>b'0';
|
|
