From 824b3bee4d838cf26060b59e2e226c83da5cf8fc Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期四, 15 十月 2026 17:16:56 +0800
Subject: [PATCH] fix(hrm): 员工导入日期列容错解析（支持 2015年 / 2015-01-01 / Excel序列号），修复含非标准日期时整表报系统异常

---
 sql/mysql/hrm_overtime_wage_config_init.sql |    6 ++++++
 1 files changed, 6 insertions(+), 0 deletions(-)

diff --git a/sql/mysql/hrm_overtime_wage_config_init.sql b/sql/mysql/hrm_overtime_wage_config_init.sql
index b3589a9..986010e 100644
--- a/sql/mysql/hrm_overtime_wage_config_init.sql
+++ b/sql/mysql/hrm_overtime_wage_config_init.sql
@@ -6,6 +6,9 @@
 --   - 鎸夊伐绉嶈缃渶澶у姞鐝椂闀夸笂闄�
 -- =============================================
 
+-- 寮哄埗杩炴帴瀛楃闆嗭紝閬垮厤涓枃鑿滃崟鍚嶈鍙岄噸缂栫爜锛堜贡鐮侊級
+SET NAMES utf8mb4;
+
 -- =============================================
 -- 1. 宀椾綅鍔犵彮宸ヨ祫閰嶇疆琛�
 -- =============================================
@@ -73,6 +76,9 @@
 `path` = VALUES(`path`), `icon` = VALUES(`icon`), `component` = VALUES(`component`),
 `component_name` = VALUES(`component_name`), `status` = VALUES(`status`), `deleted` = b'0';
 
+-- 纭繚涓婄骇銆岃柂閰鐞嗐�嶇洰褰曞彲瑙侊紙閮ㄥ垎瀹㈡埛搴撲腑璇ョ洰褰曡璁句负闅愯棌 visible=0锛屼細瀵艰嚧銆屽姞鐝伐璧勭鐞嗐�嶄笉鏄剧ず锛�
+UPDATE `system_menu` SET `visible` = b'1' WHERE `id` = 6020 AND `deleted` = b'0';
+
 -- 鎺堜簣瓒呯骇绠＄悊鍛橈紙role_id = 1锛�
 INSERT INTO `system_role_menu`
 (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)

--
Gitblit v1.9.3