From 76bf0caef9a6f4b7daae7e7b1d09b0c9044aebef Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期一, 24 八月 2026 10:07:33 +0800
Subject: [PATCH] 新增请假扣款配置设置
---
sql/mysql/hrm_module_init.sql | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/sql/mysql/hrm_module_init.sql b/sql/mysql/hrm_module_init.sql
index 57c4d35..d1d46a3 100644
--- a/sql/mysql/hrm_module_init.sql
+++ b/sql/mysql/hrm_module_init.sql
@@ -274,7 +274,9 @@
`name` varchar(100) NOT NULL COMMENT '缁撴瀯鍚嶇О',
`base_salary` decimal(12,2) NOT NULL COMMENT '鍩烘湰宸ヨ祫',
`performance_ratio` decimal(4,2) DEFAULT 0 COMMENT '缁╂晥宸ヨ祫鍗犳瘮锛�%锛�',
- `overtime_pay_ratio` decimal(4,2) DEFAULT 1.5 COMMENT '鍔犵彮宸ヨ祫鍊嶇巼',
+ `overtime_pay_ratio` decimal(4,2) DEFAULT 1.5 COMMENT '宸ヤ綔鏃ュ姞鐝伐璧勫�嶇巼',
+ `rest_day_overtime_pay_ratio` decimal(4,2) DEFAULT 2.0 COMMENT '浼戞伅鏃ュ姞鐝伐璧勫�嶇巼',
+ `legal_holiday_overtime_pay_ratio` decimal(4,2) DEFAULT 3.0 COMMENT '娉曞畾鑺傚亣鏃ュ姞鐝伐璧勫�嶇巼',
`social_security_base` decimal(12,2) DEFAULT NULL COMMENT '绀句繚鍩烘暟',
`housing_fund_base` decimal(12,2) DEFAULT NULL COMMENT '鍏Н閲戝熀鏁�',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵�侊細0-鍚敤锛�1-绂佺敤',
@@ -586,4 +588,4 @@
-- =============================================
-- 鎵ц瀹屾垚鎻愮ず
-- =============================================
-SELECT 'HRM 浜哄姏璧勬簮妯″潡 SQL 鍒濆鍖栧畬鎴愶紒' AS result;
\ No newline at end of file
+SELECT 'HRM 浜哄姏璧勬簮妯″潡 SQL 鍒濆鍖栧畬鎴愶紒' AS result;
--
Gitblit v1.9.3