From ef1052e7bf9bf1765d61776bc49ce69a23c6cdee Mon Sep 17 00:00:00 2001
From: yuan <123@>
Date: 星期二, 20 十月 2026 00:25:29 +0800
Subject: [PATCH] feat: 添加加班时长和加班工资字段到员工工资明细

---
 sql/20261019_staff_salary_detail_add_leave_attendance_deduct.sql |    8 ++++----
 1 files changed, 4 insertions(+), 4 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 34bd4d8..70b8ca2 100644
--- a/sql/20261019_staff_salary_detail_add_leave_attendance_deduct.sql
+++ b/sql/20261019_staff_salary_detail_add_leave_attendance_deduct.sql
@@ -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`;
-
-ALTER TABLE staff_salary_detail
-MODIFY COLUMN remark text NULL COMMENT '澶囨敞';
+    ADD COLUMN `manual_deduct` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '搴旀墸宸ヨ祫锛堟墜鍔ㄥ～鍐欙級' AFTER `early_count`,
+    ADD COLUMN `overtime_hours` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '鍔犵彮鏃堕暱锛堝皬鏃讹級' AFTER `hourly_salary`,
+    ADD COLUMN `overtime_pay` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '鍔犵彮宸ヨ祫锛堟墜鍔ㄥ～鍐欙級' AFTER `overtime_hours`,
+    MODIFY COLUMN remark text NULL COMMENT '澶囨敞';

--
Gitblit v1.9.3