From 0d30e44d3cf4118222f6de88424a39a04d1642e9 Mon Sep 17 00:00:00 2001 From: tuqin <tuqin@tuqin.cn> Date: 星期二, 03 十一月 2026 22:11:08 +0800 Subject: [PATCH] fix(hrm): actual_days 改为可空，区分「未录考勤」与「实出0天」 --- sql/mysql/hrm_salary_calculation_actual_days_nullable.sql | 17 +++++++++++++++++ 1 files changed, 17 insertions(+), 0 deletions(-) diff --git a/sql/mysql/hrm_salary_calculation_actual_days_nullable.sql b/sql/mysql/hrm_salary_calculation_actual_days_nullable.sql new file mode 100644 index 0000000..5fefb14 --- /dev/null +++ b/sql/mysql/hrm_salary_calculation_actual_days_nullable.sql @@ -0,0 +1,17 @@ +-- ============================================================ +-- 钖叕鏍哥畻锛歛ctual_days锛堝疄鍑哄ぉ鏁帮級鍏佽涓虹┖ +-- +-- 鑳屾櫙锛� +-- 鍘熷瓧娈垫槸 INT NOT NULL DEFAULT 0锛屽鑷淬�岃鏈堣繕娌℃湁鑰冨嫟姹囨�汇�嶅拰 +-- 銆屽疄鍑� 0 澶┿�嶅湪鏁版嵁搴撻噷閮藉瓨鎴� 0锛屾棤娉曞尯鍒嗐�� +-- 缂哄嫟鎵ｆ閫昏緫浜庢槸鎶娿�屾湭褰曡�冨嫟銆嶅綋鎴愩�屽疄鍑� 0 澶┿�嶏紝鎶婃暣鏈堝伐璧勬墸鍏夈�� +-- +-- 璇箟绾﹀畾锛堜笌 HrmSalaryCalculationServiceImpl#calculateAttendanceDeduction 瀵瑰簲锛夛細 +-- actual_days IS NULL 鈫� 璇ユ湀鏈敓鎴愯�冨嫟姹囨�伙紝瑙嗕负婊″嫟锛屼笉鍋氭椃宸ユ墸娆� +-- actual_days = 0 鈫� 瀹炲嚭 0 澶╋紙浜哄伐濉啓锛夛紝鎸� 100% 鎵ｆ椃宸� +-- actual_days = N 鈫� 鎸� 搴斿嚭 - N 璁＄畻鏃峰伐澶╂暟锛堣秴鍑鸿鍋囧崟瑕嗙洊鐨勯儴鍒嗭級 +-- ============================================================ + +ALTER TABLE hrm_salary_calculation + MODIFY COLUMN actual_days INT NULL DEFAULT NULL + COMMENT '瀹炲嚭澶╂暟锛坣ull=璇ユ湀鏈敓鎴愯�冨嫟姹囨�伙紝涓嶆墸鏃峰伐锛�'; -- Gitblit v1.9.3