From 3b5c522aad27543ea3cdddf43ff963c14c06adf2 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期一, 12 十月 2026 13:17:19 +0800
Subject: [PATCH] fix(cache): 修复权限缓存清理脚本并更新公司配置

---
 sql/mysql/menu_page_query_role_grants_pending.sql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/sql/mysql/menu_page_query_role_grants_pending.sql b/sql/mysql/menu_page_query_role_grants_pending.sql
index c7f681d..252fd51 100644
--- a/sql/mysql/menu_page_query_role_grants_pending.sql
+++ b/sql/mysql/menu_page_query_role_grants_pending.sql
@@ -1,3 +1,3 @@
--- 寰呯敤鎴风‘璁わ細缁欏凡鏈夊搴旈〉闈㈡巿鏉冪殑瑙掕壊琛ユ巿鏌ヨ鏉冮檺锛屽寘鍚汉璧勬晱鎰熸暟鎹��
+-- 鐢ㄦ埛浜� 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);

--
Gitblit v1.9.3