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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
| -- mom-hm 全业务菜单权限一致性补丁（2026-10-12）。
| -- 以实际 Controller 权限为准；旧权限改名保留菜单 ID 与既有角色授权。
| -- 补齐已有页面缺失的按钮权限；新操作权限默认只授予超级管理员。
| -- 新增权限仅自动授予超级管理员；普通角色查询授权见单独待确认脚本。
| -- 可重复执行。执行后清理受影响的 permission_menu_ids 缓存，并重新登录。
|
| UPDATE `mom-hm`.system_menu SET permission='crm:sale-quotation:convert-contract',updater='1',update_time=NOW() WHERE id=602515 AND parent_id=602512 AND name='转合同' AND permission='crm:sale-quotation:update' AND deleted=b'0';
|
| UPDATE `mom-hm`.system_menu SET permission = CASE permission WHEN 'mdm:unit-measure:import' THEN 'mdm:unit:import' WHEN 'mdm:unit-measure:export' THEN 'mdm:unit:export' WHEN 'mes:pd:parameter:create' THEN 'mes:pd-process-param:create' WHEN 'mes:pd:template:create' THEN 'mes:pd-process-param-template:create' WHEN 'mes:pd:parameter:update' THEN 'mes:pd-process-param:update' WHEN 'mes:pd:template:update' THEN 'mes:pd-process-param-template:update' WHEN 'mes:pd:parameter:delete' THEN 'mes:pd-process-param:delete' WHEN 'mes:pd:template:delete' THEN 'mes:pd-process-param-template:delete' WHEN 'mes:pd:parameter:export' THEN 'mes:pd-process-param:export' WHEN 'mes:pd:template:export' THEN 'mes:pd-process-param-template:export' WHEN 'mes:wm-outsource-issue:execute' THEN 'mes:wm-outsource-issue:finish' WHEN 'mes:wm-return-vendor:update-status' THEN 'mes:wm-return-vendor:finish' WHEN 'mes:wm-material-stock:move' THEN 'mes:wm-material-stock:update' WHEN 'mes:pd-project:archive' THEN 'mes:pd-project:update' ELSE permission END, updater='1',update_time=NOW() WHERE permission IN ('mdm:unit-measure:import','mdm:unit-measure:export','mes:pd:parameter:create','mes:pd:template:create','mes:pd:parameter:update','mes:pd:template:update','mes:pd:parameter:delete','mes:pd:template:delete','mes:pd:parameter:export','mes:pd:template:export','mes:wm-outsource-issue:execute','mes:wm-return-vendor:update-status','mes:wm-material-stock:move','mes:pd-project:archive');
|
| 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 + desired.offset_id,desired.name,desired.permission,3,90,parent.id,'','#','',NULL,0,b'1',b'0',b'1','1',NOW(),'1',NOW(),b'0'
| FROM (SELECT 1 AS offset_id,'bi:dashboard:query' AS permission,1063007 AS parent_id,'图表配置-查询' AS name
| UNION ALL
| SELECT 2 AS offset_id,'bpm:oa-notice:query' AS permission,602608 AS parent_id,'通知公告-查询' AS name
| UNION ALL
| SELECT 3 AS offset_id,'crm:invoice:query' AS permission,1063093 AS parent_id,'开票管理-查询' AS name
| UNION ALL
| SELECT 4 AS offset_id,'crm:sale-quotation:query' AS permission,602512 AS parent_id,'销售报价-查询' AS name
| UNION ALL
| SELECT 5 AS offset_id,'crm:sale-quotation:export' AS permission,602512 AS parent_id,'销售报价-导出' AS name
| UNION ALL
| SELECT 6 AS offset_id,'crm:sale-quotation:convert-contract' AS permission,602512 AS parent_id,'销售报价-转合同' AS name
| UNION ALL
| SELECT 7 AS offset_id,'erp:purchase-order:import' AS permission,2666 AS parent_id,'采购订单-导入' AS name
| UNION ALL
| SELECT 8 AS offset_id,'erp:purchase-request:query' AS permission,602498 AS parent_id,'采购申请-查询' AS name
| UNION ALL
| SELECT 9 AS offset_id,'erp:purchase-request:submit' AS permission,602498 AS parent_id,'采购申请-提交' AS name
| UNION ALL
| SELECT 10 AS offset_id,'erp:purchase-request:generate-order' AS permission,602498 AS parent_id,'采购申请-生成订单' AS name
| UNION ALL
| SELECT 11 AS offset_id,'erp:sale-order:cancel' AS permission,2638 AS parent_id,'销售订单-撤销' AS name
| UNION ALL
| SELECT 12 AS offset_id,'erp:sale-order:enable' AS permission,2638 AS parent_id,'销售订单-启用' AS name
| UNION ALL
| SELECT 13 AS offset_id,'erp:sale-order:import' AS permission,2638 AS parent_id,'销售订单-导入' AS name
| UNION ALL
| SELECT 14 AS offset_id,'hrm:leave:export' AS permission,6003 AS parent_id,'请假申请-导出' AS name
| UNION ALL
| SELECT 15 AS offset_id,'hrm:overtime:query' AS permission,1065211 AS parent_id,'加班申请-查询' AS name
| UNION ALL
| SELECT 16 AS offset_id,'hrm:resignation:query' AS permission,6005 AS parent_id,'离职申请-查询' AS name
| UNION ALL
| SELECT 17 AS offset_id,'hrm:resignation:export' AS permission,6005 AS parent_id,'离职申请-导出' AS name
| UNION ALL
| SELECT 18 AS offset_id,'hrm:transfer:query' AS permission,6004 AS parent_id,'调岗申请-查询' AS name
| UNION ALL
| SELECT 19 AS offset_id,'hrm:transfer:export' AS permission,6004 AS parent_id,'调岗申请-导出' AS name
| UNION ALL
| SELECT 20 AS offset_id,'hrm:attendance-exception:update' AS permission,6012 AS parent_id,'考勤异常-编辑' AS name
| UNION ALL
| SELECT 21 AS offset_id,'hrm:attendance-exception:delete' AS permission,6012 AS parent_id,'考勤异常-删除' AS name
| UNION ALL
| SELECT 22 AS offset_id,'hrm:attendance-exception:query' AS permission,6012 AS parent_id,'考勤异常-查询' AS name
| UNION ALL
| SELECT 23 AS offset_id,'hrm:attendance-holiday:query' AS permission,6014 AS parent_id,'节假日配置-查询' AS name
| UNION ALL
| SELECT 24 AS offset_id,'hrm:attendance-record:query' AS permission,6011 AS parent_id,'考勤记录-查询' AS name
| UNION ALL
| SELECT 25 AS offset_id,'hrm:attendance-rule:query' AS permission,6013 AS parent_id,'考勤规则-查询' AS name
| UNION ALL
| SELECT 26 AS offset_id,'hrm:attendance-summary:query' AS permission,6015 AS parent_id,'考勤统计-查询' AS name
| UNION ALL
| SELECT 27 AS offset_id,'hrm:employee-social-security:query' AS permission,6023 AS parent_id,'员工社保公积金档案-查询' AS name
| UNION ALL
| SELECT 28 AS offset_id,'hrm:salary-calculation:query' AS permission,6021 AS parent_id,'薪酬核算-查询' AS name
| UNION ALL
| SELECT 29 AS offset_id,'hrm:salary-calculation:delete' AS permission,6021 AS parent_id,'薪酬核算-删除' AS name
| UNION ALL
| SELECT 30 AS offset_id,'hrm:salary-calculation:save' AS permission,6021 AS parent_id,'薪酬核算-保存' AS name
| UNION ALL
| SELECT 31 AS offset_id,'hrm:salary-payment:query' AS permission,6022 AS parent_id,'薪资发放-查询' AS name
| UNION ALL
| SELECT 32 AS offset_id,'hrm:salary-payment:generate' AS permission,6022 AS parent_id,'薪资发放-生成' AS name
| UNION ALL
| SELECT 33 AS offset_id,'hrm:salary-payment:delete' AS permission,6022 AS parent_id,'薪资发放-删除' AS name
| UNION ALL
| SELECT 34 AS offset_id,'hrm:social-security-scheme:query' AS permission,602445 AS parent_id,'社保公积金方案-查询' AS name
| UNION ALL
| SELECT 35 AS offset_id,'hrm:tax-rate-config:query' AS permission,6024 AS parent_id,'个税税率配置-查询' AS name
| UNION ALL
| SELECT 36 AS offset_id,'mes:dv-metering:import' AS permission,5380 AS parent_id,'计量器具-导入' AS name
| UNION ALL
| SELECT 37 AS offset_id,'mes:md-workshop:export' AS permission,5160 AS parent_id,'车间设置-导出' AS name
| UNION ALL
| SELECT 38 AS offset_id,'mes:pd-archive:create' AS permission,602578 AS parent_id,'设计归档-新增' AS name
| UNION ALL
| SELECT 39 AS offset_id,'mes:pd-document:create' AS permission,602572 AS parent_id,'设计项目-新增' AS name
| UNION ALL
| SELECT 40 AS offset_id,'mes:pd-document:update' AS permission,602572 AS parent_id,'设计项目-编辑' AS name
| UNION ALL
| SELECT 41 AS offset_id,'mes:pd-document:delete' AS permission,602572 AS parent_id,'设计项目-删除' AS name
| UNION ALL
| SELECT 42 AS offset_id,'mes:pd-document:query' AS permission,602572 AS parent_id,'设计项目-查询' AS name
| UNION ALL
| SELECT 43 AS offset_id,'mes:pd-document:export' AS permission,602572 AS parent_id,'设计项目-导出' AS name
| UNION ALL
| SELECT 44 AS offset_id,'mes:pd-process-param:query' AS permission,602474 AS parent_id,'基础参数-查询' AS name
| UNION ALL
| SELECT 45 AS offset_id,'mes:pd-process-param-template:query' AS permission,602475 AS parent_id,'参数模板-查询' AS name
| UNION ALL
| SELECT 46 AS offset_id,'mes:pro-mps:query' AS permission,602504 AS parent_id,'生产计划-查询' AS name
| UNION ALL
| SELECT 47 AS offset_id,'mes:qc-ipqc:finish' AS permission,5650 AS parent_id,'过程检验-完成' AS name
| UNION ALL
| SELECT 48 AS offset_id,'mes:qc-iqc:finish' AS permission,5640 AS parent_id,'来料检验-完成' AS name
| UNION ALL
| SELECT 49 AS offset_id,'mes:qc-oqc:finish' AS permission,5660 AS parent_id,'出货检验-完成' AS name
| UNION ALL
| SELECT 50 AS offset_id,'mes:qc-rqc:finish' AS permission,5670 AS parent_id,'退货检验-完成' AS name
| UNION ALL
| SELECT 51 AS offset_id,'mes:wm-stock-taking-task:finish' AS permission,5957 AS parent_id,'盘点任务-完成' AS name
| UNION ALL
| SELECT 52 AS offset_id,'srm:tender-config:query' AS permission,602545 AS parent_id,'招投标管理-查询' AS name
| UNION ALL
| SELECT 54 AS offset_id,'hrm:employee-contract:import' AS permission,6006 AS parent_id,'员工合同-导入' AS name
| UNION ALL
| SELECT 53 AS offset_id,'srm:tender-config:update' AS permission,602545 AS parent_id,'招投标管理-编辑' AS name) desired
| JOIN `mom-hm`.system_menu parent ON parent.id=desired.parent_id AND parent.type=2 AND parent.status=0 AND parent.deleted=b'0'
| CROSS JOIN (SELECT COALESCE(MAX(id),0) AS id FROM `mom-hm`.system_menu) next_id
| WHERE NOT EXISTS (SELECT 1 FROM `mom-hm`.system_menu existing WHERE existing.permission=desired.permission AND existing.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 IN ('mdm:unit:import','mdm:unit:export','mes:pd-process-param:create','mes:pd-process-param-template:create','mes:pd-process-param:update','mes:pd-process-param-template:update','mes:pd-process-param:delete','mes:pd-process-param-template:delete','mes:pd-process-param:export','mes:pd-process-param-template:export','mes:wm-outsource-issue:finish','mes:wm-return-vendor:finish','mes:wm-material-stock:update','mes:pd-project:update','bi:dashboard:query','bpm:oa-notice:query','crm:invoice:query','crm:sale-quotation:query','crm:sale-quotation:export','crm:sale-quotation:convert-contract','erp:purchase-order:import','erp:purchase-request:query','erp:purchase-request:submit','erp:purchase-request:generate-order','erp:sale-order:cancel','erp:sale-order:enable','erp:sale-order:import','hrm:leave:export','hrm:overtime:query','hrm:resignation:query','hrm:resignation:export','hrm:transfer:query','hrm:transfer:export','hrm:attendance-exception:update','hrm:attendance-exception:delete','hrm:attendance-exception:query','hrm:attendance-holiday:query','hrm:attendance-record:query','hrm:attendance-rule:query','hrm:attendance-summary:query','hrm:employee-social-security:query','hrm:salary-calculation:query','hrm:salary-calculation:delete','hrm:salary-calculation:save','hrm:salary-payment:query','hrm:salary-payment:generate','hrm:salary-payment:delete','hrm:social-security-scheme:query','hrm:tax-rate-config:query','mes:dv-metering:import','mes:md-workshop:export','mes:pd-archive:create','mes:pd-document:create','mes:pd-document:update','mes:pd-document:delete','mes:pd-document:query','mes:pd-document:export','mes:pd-process-param:query','mes:pd-process-param-template:query','mes:pro-mps:query','mes:qc-ipqc:finish','mes:qc-iqc:finish','mes:qc-oqc:finish','mes:qc-rqc:finish','mes:wm-stock-taking-task:finish','srm:tender-config:query','srm:tender-config:update','hrm:employee-contract:import') AND m.deleted=b'0' AND m.status=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);
|
|
