| | |
|---|
| | | -- 待用户确认：给已有对应页面授权的角色补授查询权限，包含人资敏感数据。 |
|---|
| | | -- 用户于 2026-10-12 确认允许执行：给已有对应页面授权的角色补授查询权限，包含人资敏感数据。 |
|---|
| | | INSERT INTO `mom-hm`.system_role_menu (role_id,menu_id,creator,create_time,updater,update_time,deleted) |
|---|
| | | SELECT DISTINCT parentGrant.role_id,m.id,'1',NOW(),'1',NOW(),b'0' FROM `mom-hm`.system_menu m JOIN `mom-hm`.system_role_menu parentGrant ON parentGrant.menu_id=m.parent_id AND parentGrant.deleted=b'0' JOIN `mom-hm`.system_role r ON r.id=parentGrant.role_id AND r.deleted=b'0' AND r.status=0 WHERE m.permission IN ('bi:dashboard:query','bpm:oa-notice:query','crm:invoice:query','crm:sale-quotation:query','erp:purchase-request:query','hrm:overtime:query','hrm:resignation:query','hrm:transfer:query','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-payment:query','hrm:social-security-scheme:query','hrm:tax-rate-config:query','mes:pd-document:query','mes:pd-process-param:query','mes:pd-process-param-template:query','mes:pro-mps:query','srm:tender-config:query') AND m.deleted=b'0' AND m.status=0 AND NOT EXISTS (SELECT 1 FROM `mom-hm`.system_role_menu rm WHERE rm.role_id=parentGrant.role_id AND rm.menu_id=m.id); |
|---|
