From 9010b5b3d735abc84c61a88eb2f1483c3acf440f Mon Sep 17 00:00:00 2001 From: yuan <123@> Date: 星期一, 19 十月 2026 17:12:16 +0800 Subject: [PATCH] feat: 添加员工工资明细中的请假、缺勤、迟到、早退次数及手动扣工资字段 --- sql/product-inventory-management-new-pro.sql | 5 +++++ 1 files changed, 5 insertions(+), 0 deletions(-) diff --git a/sql/product-inventory-management-new-pro.sql b/sql/product-inventory-management-new-pro.sql index 71d483b..20746ca 100644 --- a/sql/product-inventory-management-new-pro.sql +++ b/sql/product-inventory-management-new-pro.sql @@ -4673,6 +4673,11 @@ `salary_tax` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '宸ヨ祫涓◣', `gross_salary` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '搴斿彂宸ヨ祫', `deduct_salary` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '搴旀墸宸ヨ祫', + `leave_count` int NULL DEFAULT 0 COMMENT '璇峰亣娆℃暟', + `absence_count` int NULL DEFAULT 0 COMMENT '缂哄嫟娆℃暟', + `late_count` int NULL DEFAULT 0 COMMENT '杩熷埌娆℃暟', + `early_count` int NULL DEFAULT 0 COMMENT '鏃╅��娆℃暟', + `manual_deduct` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '鎵ｅ伐璧勶紙鎵嬪姩濉啓锛�', `net_salary` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '瀹炲彂宸ヨ祫', `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞', `create_time` datetime NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', -- Gitblit v1.9.3