From d476e7d1595e131f2bb7bb1a62c00fa3e82fb0a7 Mon Sep 17 00:00:00 2001
From: yuan <123@>
Date: 星期一, 19 十月 2026 17:23:30 +0800
Subject: [PATCH] feat: 添加员工工资明细中的请假、缺勤、迟到、早退次数及手动扣工资字段

---
 sql/20261019_staff_salary_detail_add_leave_attendance_deduct.sql |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/sql/20261019_staff_salary_detail_add_leave_attendance_deduct.sql b/sql/20261019_staff_salary_detail_add_leave_attendance_deduct.sql
index f9a8b06..34bd4d8 100644
--- a/sql/20261019_staff_salary_detail_add_leave_attendance_deduct.sql
+++ b/sql/20261019_staff_salary_detail_add_leave_attendance_deduct.sql
@@ -1,6 +1,6 @@
 -- ----------------------------
--- 鍛樺伐宸ヨ祫鏄庣粏鏂板锛氳鍋囨鏁般�佺己鍕ゆ鏁般�佽繜鍒版鏁般�佹棭閫�娆℃暟銆佹墸宸ヨ祫锛堟墜濉級
--- 鍒椾綅缃細搴旀墸宸ヨ祫(deduct_salary) 涔嬪悗銆佸疄鍙戝伐璧�(net_salary) 涔嬪墠
+-- 鍛樺伐宸ヨ祫鏄庣粏鏂板锛氳鍋囨鏁般�佺己鍕ゆ鏁般�佽繜鍒版鏁般�佹棭閫�娆℃暟銆佸簲鎵ｅ伐璧勶紙鎵嬪～锛�
+-- 鍒椾綅缃細搴旀墸绀句繚(deduct_salary) 涔嬪悗銆佸疄鍙戝伐璧�(net_salary) 涔嬪墠
 -- 鎵ц鐜锛氬凡鏈夊簱鍗囩骇锛堝叏閲忚剼鏈� product-inventory-management-new-pro.sql 宸插悓姝ワ級
 -- ----------------------------
 ALTER TABLE `staff_salary_detail`
@@ -8,7 +8,7 @@
     ADD COLUMN `absence_count` int NULL DEFAULT 0 COMMENT '缂哄嫟娆℃暟' AFTER `leave_count`,
     ADD COLUMN `late_count` int NULL DEFAULT 0 COMMENT '杩熷埌娆℃暟' AFTER `absence_count`,
     ADD COLUMN `early_count` int NULL DEFAULT 0 COMMENT '鏃╅��娆℃暟' AFTER `late_count`,
-    ADD COLUMN `manual_deduct` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '鎵ｅ伐璧勶紙鎵嬪姩濉啓锛�' AFTER `early_count`;
+    ADD COLUMN `manual_deduct` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '搴旀墸宸ヨ祫锛堟墜鍔ㄥ～鍐欙級' AFTER `early_count`;
 
 ALTER TABLE staff_salary_detail
 MODIFY COLUMN remark text NULL COMMENT '澶囨敞';

--
Gitblit v1.9.3