From a08832337f8de6a53edebbab1fb0b5a3bd1785aa Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期四, 27 八月 2026 17:23:04 +0800
Subject: [PATCH] feat(srm): 供应商准入审核接入协同办公(BPM)
---
sql/mysql/hrm_employee_post_multi.sql | 15 +++++++++++++++
1 files changed, 15 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/hrm_employee_post_multi.sql b/sql/mysql/hrm_employee_post_multi.sql
new file mode 100644
index 0000000..8e24d60
--- /dev/null
+++ b/sql/mysql/hrm_employee_post_multi.sql
@@ -0,0 +1,15 @@
+-- =============================================
+-- HRM 鍛樺伐琛細宀椾綅澶氶�夋敼閫� SQL
+-- 1. 娣诲姞 post_ids 瀛楁锛圝SON 鏍煎紡锛屼笌 role_ids 瀛樺偍鏂瑰紡涓�鑷达級
+-- 2. 杩佺Щ宸叉湁 post_id 鏁版嵁鍒� post_ids
+-- 3. 淇濈暀 post_id 瀛楁锛堝吋瀹规棫鑴氭湰/澶栭儴寮曠敤锛屽凡搴熷純涓嶅啀鍐欏叆锛�
+-- =============================================
+
+-- 1. 娣诲姞宀椾綅ID鍒楄〃瀛楁锛圝SON鏍煎紡瀛樺偍锛�
+ALTER TABLE `hrm_employee` ADD COLUMN `post_ids` varchar(500) DEFAULT NULL COMMENT '宀椾綅ID鍒楄〃锛圝SON鏍煎紡锛�' AFTER `post_id`;
+
+-- 2. 杩佺Щ宸叉湁 post_id 鏁版嵁鍒� post_ids
+UPDATE `hrm_employee` SET `post_ids` = CONCAT('[', `post_id`, ']') WHERE `post_id` IS NOT NULL AND (`post_ids` IS NULL OR `post_ids` = '');
+
+-- 鎵ц瀹屾垚鎻愮ず
+SELECT 'HRM 鍛樺伐琛ㄥ矖浣嶅閫夋敼閫犲畬鎴愶紒' AS result;
--
Gitblit v1.9.3