考勤调整记录菜单与后台补卡按钮.sql
2.09 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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
-- 考勤：考勤调整记录菜单
-- 执行环境：lqerp_dev / 生产（按需）
-- 说明：调整记录菜单挂在考勤管理下；手动修改考勤暂不做按钮权限，进入打卡记录页即可操作
-- 幂等：同 URL/EnCode 不重复插入；菜单授权按真实 F_Id 授权
-- 1) 考勤调整记录菜单（Type=2，父级考勤管理 816879900139980037）
-- 仅当 URL 与 EnCode 均不存在时插入，避免与已有 kqtzjl 菜单重复
INSERT 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
)
SELECT
'lvq-attendance-adjust',
'816879900139980037',
2,
'考勤调整记录',
'attendanceAdjust',
'attendance-adjust',
'icon-ym icon-ym-clock',
4,
1,
'Web',
NULL,
'_self',
'{"moduleId":"","iconBackgroundColor":"","isTree":0}',
1, 1, 1, 1,
NOW()
FROM (SELECT 1) AS _seed
WHERE NOT EXISTS (
SELECT 1 FROM BASE_MODULE
WHERE F_UrlAddress = 'attendance-adjust'
AND F_DeleteMark IS NULL
)
AND NOT EXISTS (
SELECT 1 FROM BASE_MODULE
WHERE F_EnCode IN ('kqtzjl', 'attendanceAdjust')
AND F_DeleteMark IS NULL
);
-- 2) 菜单授权：复制打卡记录模块已有角色，授权到真实菜单 F_Id
INSERT INTO BASE_AUTHORIZE (
F_Id, F_ItemType, F_ItemId, F_ObjectType, F_ObjectId, F_SortCode, F_CreatorTime, F_CreatorUserId
)
SELECT LEFT(SHA2(CONCAT(m.F_Id, ':', t.F_ObjectId), 256), 50),
'module', m.F_Id, 'Role', t.F_ObjectId, 1, NOW(), 'admin'
FROM (
SELECT DISTINCT F_ObjectId
FROM BASE_AUTHORIZE
WHERE F_ItemId = 'lvq-attendance-record' AND F_ItemType = 'module' AND F_ObjectType = 'Role'
) t
CROSS JOIN (
SELECT F_Id
FROM BASE_MODULE
WHERE F_UrlAddress = 'attendance-adjust'
AND F_DeleteMark IS NULL
ORDER BY F_CreatorTime
LIMIT 1
) m
WHERE NOT EXISTS (
SELECT 1 FROM BASE_AUTHORIZE a
WHERE a.F_ItemId = m.F_Id
AND a.F_ItemType = 'module'
AND a.F_ObjectType = 'Role'
AND a.F_ObjectId = t.F_ObjectId
);