f075068f
 “wangming”
对考勤这块功能进行开发
|
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
|
-- 考勤设置菜单配置脚本
-- 说明：在“考勤汇总表”同级新增“考勤设置”菜单，并复制原考勤菜单的角色授权
SET @ModuleId = 'attendance-setting';
SET @SourceModuleId = '729599328976372997'; -- 考勤汇总表
SET @ParentId = '729569163395204357';
DELETE FROM BASE_MODULE WHERE F_Id = @ModuleId;
DELETE FROM BASE_AUTHORIZE WHERE F_ItemId = @ModuleId;
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
)
VALUES (
@ModuleId, @ParentId, 2, '考勤设置', 'attendanceSetting', 'attendance-setting', 'icon-ym icon-ym-clock',
1, 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 REPLACE(UUID(), '-', ''), '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;
|
