1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
| -- 模块数据补录菜单补丁，可重复执行。
| -- 顶级目录“数据补录” + 子菜单“模块数据补录”，前端组件 agent/dataEntry/index。
| -- 仅超级管理员自动可见；其他角色请在角色管理中勾选这两个菜单。
|
| INSERT INTO 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,'数据补录','',1,2,0,'/agent','ep:magic-stick','',NULL,0,b'1',b'0',b'1','1',NOW(),'1',NOW(),b'0'
| FROM (SELECT COALESCE(MAX(id),0)+1 AS id FROM system_menu) next_id
| WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE parent_id=0 AND path='/agent' AND deleted=b'0');
|
| INSERT INTO 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,'模块数据补录','',2,1,parent.id,'data-entry','ep:chat-dot-round','agent/dataEntry/index','AgentDataEntry',0,b'1',b'0',b'1','1',NOW(),'1',NOW(),b'0'
| FROM system_menu parent CROSS JOIN (SELECT COALESCE(MAX(id),0)+1 AS id FROM system_menu) next_id
| WHERE parent.parent_id=0 AND parent.path='/agent' AND parent.deleted=b'0'
| AND NOT EXISTS (SELECT 1 FROM system_menu WHERE component='agent/dataEntry/index' AND deleted=b'0');
|
| UPDATE system_menu SET status=0,visible=b'1',deleted=b'0',updater='1',update_time=NOW()
| WHERE (component='agent/dataEntry/index' OR (parent_id=0 AND path='/agent')) AND deleted<>b'0';
|
| INSERT INTO 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 system_role r JOIN system_menu m ON m.deleted=b'0' AND (m.component='agent/dataEntry/index' OR (m.parent_id=0 AND m.path='/agent'))
| 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);
|
|
