人事填报管理菜单.sql
1.73 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
-- 人事填报管理：管理端动态菜单
-- 与「用户管理」同级，挂在「组织机构」下；授权复制自用户管理角色。
-- 前端页面：permission/personnel-report -> src/views/permission/personnel-report/index.vue
-- 静态路由兜底：/permission/personnel-report（见 router/modules/base.js）
SET @ModuleId = 'personnel-report-lq';
SELECT F_ParentId INTO @ParentId
FROM BASE_MODULE
WHERE F_FullName = '用户管理' AND F_Type = 2 AND F_DeleteMark IS NULL
LIMIT 1;
SELECT F_Id INTO @SourceModuleId
FROM BASE_MODULE
WHERE F_FullName = '用户管理' AND F_Type = 2 AND F_DeleteMark IS NULL
LIMIT 1;
INSERT IGNORE INTO BASE_MODULE (
F_Id, F_ParentId, F_Type, F_FullName, F_EnCode, F_UrlAddress, F_Icon,
F_SortCode, F_EnabledMark, F_Category, F_DeleteMark, F_LinkTarget,
F_PropertyJson, F_IsButtonAuthorize, F_IsColumnAuthorize, F_IsDataAuthorize,
F_IsFormAuthorize, F_CreatorTime
)
VALUES (
@ModuleId, @ParentId, 2, '人事填报管理', 'personnelReport', 'permission/personnel-report', 'icon-ym icon-ym-user',
56, 1, 'Web', NULL, '_self', '{"moduleId":"","iconBackgroundColor":"","isTree":0}',
1, 1, 1, 1, NOW()
);
INSERT INTO BASE_AUTHORIZE (
F_Id, F_ItemType, F_ItemId, F_ObjectType, F_ObjectId, F_SortCode, F_CreatorTime, F_CreatorUserId
)
SELECT LEFT(SHA2(CONCAT(@ModuleId, ':', t.F_ObjectId), 256), 50),
'module', @ModuleId, 'Role', t.F_ObjectId, 1, NOW(), 'admin'
FROM (
SELECT DISTINCT F_ObjectId
FROM BASE_AUTHORIZE
WHERE F_ItemId = @SourceModuleId AND F_ItemType = 'module' AND F_ObjectType = 'Role'
) t
WHERE NOT EXISTS (
SELECT 1
FROM BASE_AUTHORIZE a
WHERE a.F_ItemId = @ModuleId
AND a.F_ItemType = 'module'
AND a.F_ObjectType = 'Role'
AND a.F_ObjectId = t.F_ObjectId
);