From 8674fd3d10dba263a6606758ceddf20a9d694098 Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期一, 08 六月 2026 17:47:16 +0800
Subject: [PATCH] 增加社保补缴金额字段
---
src/main/java/com/ruoyi/staff/pojo/StaffSalaryDetail.java | 3 +++
src/main/resources/mapper/staff/StaffSalaryDetailMapper.xml | 1 +
doc/20260608_add_social_supplement_amount_to_staff_salary_detail.sql | 2 ++
3 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/doc/20260608_add_social_supplement_amount_to_staff_salary_detail.sql b/doc/20260608_add_social_supplement_amount_to_staff_salary_detail.sql
new file mode 100644
index 0000000..28258ff
--- /dev/null
+++ b/doc/20260608_add_social_supplement_amount_to_staff_salary_detail.sql
@@ -0,0 +1,2 @@
+alter table staff_salary_detail
+ add social_supplement_amount decimal(16, 2) null comment '绀句繚琛ョ即閲戦' after social_personal;
diff --git a/src/main/java/com/ruoyi/staff/pojo/StaffSalaryDetail.java b/src/main/java/com/ruoyi/staff/pojo/StaffSalaryDetail.java
index 3db7baa..4600486 100644
--- a/src/main/java/com/ruoyi/staff/pojo/StaffSalaryDetail.java
+++ b/src/main/java/com/ruoyi/staff/pojo/StaffSalaryDetail.java
@@ -74,6 +74,9 @@
@Schema(description = "绀句繚涓汉")
private BigDecimal socialPersonal;
+ @Schema(description = "绀句繚琛ョ即閲戦")
+ private BigDecimal socialSupplementAmount;
+
@Schema(description = "鍏Н閲戜釜浜�")
private BigDecimal fundPersonal;
diff --git a/src/main/resources/mapper/staff/StaffSalaryDetailMapper.xml b/src/main/resources/mapper/staff/StaffSalaryDetailMapper.xml
index 7c8004a..e2f9514 100644
--- a/src/main/resources/mapper/staff/StaffSalaryDetailMapper.xml
+++ b/src/main/resources/mapper/staff/StaffSalaryDetailMapper.xml
@@ -15,6 +15,7 @@
<result column="hourly_salary" property="hourlySalary" />
<result column="other_income" property="otherIncome" />
<result column="social_personal" property="socialPersonal" />
+ <result column="social_supplement_amount" property="socialSupplementAmount" />
<result column="fund_personal" property="fundPersonal" />
<result column="other_deduct" property="otherDeduct" />
<result column="salary_tax" property="salaryTax" />
--
Gitblit v1.9.3