From 8b3c7885598f323b7fd86ba58f31a974a3d7b933 Mon Sep 17 00:00:00 2001
From: huminmin <mac@MacBook-Pro.local>
Date: 星期一, 15 六月 2026 16:22:21 +0800
Subject: [PATCH] 导出工资明细
---
src/main/java/com/ruoyi/staff/controller/StaffSalaryMainController.java | 7 +++
src/main/java/com/ruoyi/staff/service/impl/StaffSalaryMainServiceImpl.java | 44 ++++++++++++++++++++++
src/main/java/com/ruoyi/staff/service/StaffSalaryMainService.java | 3 +
src/main/java/com/ruoyi/staff/excel/StaffSalaryExportData.java | 64 ++++++++++++++++++++++++++++++++
4 files changed, 117 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/ruoyi/staff/controller/StaffSalaryMainController.java b/src/main/java/com/ruoyi/staff/controller/StaffSalaryMainController.java
index e4e8a8f..29fb3bb 100644
--- a/src/main/java/com/ruoyi/staff/controller/StaffSalaryMainController.java
+++ b/src/main/java/com/ruoyi/staff/controller/StaffSalaryMainController.java
@@ -10,6 +10,7 @@
import com.ruoyi.staff.service.StaffSalaryMainService;
import io.swagger.v3.oas.annotations.tags.Tag;
import io.swagger.v3.oas.annotations.Operation;
+import jakarta.servlet.http.HttpServletResponse;
import lombok.AllArgsConstructor;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
@@ -74,6 +75,10 @@
return staffSalaryMainService.delete(ids);
}
-
+ @PostMapping("/export")
+ @Operation(summary = "瀵煎嚭鍛樺伐钖祫鏄庣粏")
+ public void export(HttpServletResponse response, String salaryMonth) {
+ staffSalaryMainService.exportSalaryDetail(response, salaryMonth);
+ }
}
diff --git a/src/main/java/com/ruoyi/staff/excel/StaffSalaryExportData.java b/src/main/java/com/ruoyi/staff/excel/StaffSalaryExportData.java
new file mode 100644
index 0000000..c1f2725
--- /dev/null
+++ b/src/main/java/com/ruoyi/staff/excel/StaffSalaryExportData.java
@@ -0,0 +1,64 @@
+package com.ruoyi.staff.excel;
+
+import com.ruoyi.framework.aspectj.lang.annotation.Excel;
+import lombok.Data;
+
+import java.math.BigDecimal;
+
+/**
+ * 鍛樺伐钖祫瀵煎嚭鏁版嵁
+ */
+@Data
+public class StaffSalaryExportData {
+
+ @Excel(name = "宸ヨ祫鏈堜唤")
+ private String salaryMonth;
+
+ @Excel(name = "宸ヨ祫涓婚")
+ private String salaryTitle;
+
+ @Excel(name = "鍛樺伐濮撳悕")
+ private String staffName;
+
+ @Excel(name = "閮ㄩ棬鍚嶇О")
+ private String deptName;
+
+ @Excel(name = "鍩烘湰宸ヨ祫")
+ private BigDecimal basicSalary;
+
+ @Excel(name = "璁′欢宸ヨ祫")
+ private BigDecimal pieceSalary;
+
+ @Excel(name = "璁℃椂宸ヨ祫")
+ private BigDecimal hourlySalary;
+
+ @Excel(name = "鍏朵粬鏀跺叆")
+ private BigDecimal otherIncome;
+
+ @Excel(name = "绀句繚涓汉")
+ private BigDecimal socialPersonal;
+
+ @Excel(name = "鍏Н閲戜釜浜�")
+ private BigDecimal fundPersonal;
+
+ @Excel(name = "鍏朵粬鏀嚭")
+ private BigDecimal otherDeduct;
+
+ @Excel(name = "绀句繚琛ョ即")
+ private BigDecimal socialSupplementAmount;
+
+ @Excel(name = "宸ヨ祫涓◣")
+ private BigDecimal salaryTax;
+
+ @Excel(name = "搴斿彂宸ヨ祫")
+ private BigDecimal grossSalary;
+
+ @Excel(name = "搴旀墸宸ヨ祫")
+ private BigDecimal deductSalary;
+
+ @Excel(name = "瀹炲彂宸ヨ祫")
+ private BigDecimal netSalary;
+
+ @Excel(name = "澶囨敞")
+ private String remark;
+}
diff --git a/src/main/java/com/ruoyi/staff/service/StaffSalaryMainService.java b/src/main/java/com/ruoyi/staff/service/StaffSalaryMainService.java
index a573b21..4b0838c 100644
--- a/src/main/java/com/ruoyi/staff/service/StaffSalaryMainService.java
+++ b/src/main/java/com/ruoyi/staff/service/StaffSalaryMainService.java
@@ -5,6 +5,7 @@
import com.ruoyi.staff.dto.CalculateSalaryDto;
import com.ruoyi.staff.dto.StaffSalaryCalculateDto;
import com.ruoyi.staff.pojo.StaffSalaryMain;
+import jakarta.servlet.http.HttpServletResponse;
import com.baomidou.mybatisplus.extension.service.IService;
import java.util.List;
@@ -30,4 +31,6 @@
AjaxResult calculateSalary(CalculateSalaryDto calculateSalaryDto);
AjaxResult calculateSalaryByEmployee(StaffSalaryCalculateDto calculateSalaryCalculateDto);
+
+ void exportSalaryDetail(HttpServletResponse response, String salaryMonth);
}
diff --git a/src/main/java/com/ruoyi/staff/service/impl/StaffSalaryMainServiceImpl.java b/src/main/java/com/ruoyi/staff/service/impl/StaffSalaryMainServiceImpl.java
index 00f821c..3c31a21 100644
--- a/src/main/java/com/ruoyi/staff/service/impl/StaffSalaryMainServiceImpl.java
+++ b/src/main/java/com/ruoyi/staff/service/impl/StaffSalaryMainServiceImpl.java
@@ -4,8 +4,11 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.framework.web.domain.AjaxResult;
import com.ruoyi.project.system.mapper.SysUserDeptMapper;
+import com.ruoyi.staff.excel.StaffSalaryExportData;
+import jakarta.servlet.http.HttpServletResponse;
import com.ruoyi.staff.dto.CalculateSalaryDto;
import com.ruoyi.staff.dto.StaffSalaryCalculateDto;
import com.ruoyi.staff.mapper.StaffLeaveMapper;
@@ -170,6 +173,47 @@
return AjaxResult.success(result);
}
+ @Override
+ public void exportSalaryDetail(HttpServletResponse response, String salaryMonth) {
+ LambdaQueryWrapper<StaffSalaryMain> mainWrapper = new LambdaQueryWrapper<>();
+ if (StringUtils.isNotEmpty(salaryMonth)) {
+ mainWrapper.eq(StaffSalaryMain::getSalaryMonth, salaryMonth);
+ }
+ List<StaffSalaryMain> mainList = staffSalaryMainMapper.selectList(mainWrapper);
+
+ List<StaffSalaryExportData> exportDataList = new ArrayList<>();
+ for (StaffSalaryMain main : mainList) {
+ List<StaffSalaryDetail> detailList = staffSalaryDetailMapper.selectList(
+ new LambdaQueryWrapper<StaffSalaryDetail>().eq(StaffSalaryDetail::getMainId, main.getId())
+ );
+
+ for (StaffSalaryDetail detail : detailList) {
+ StaffSalaryExportData exportData = new StaffSalaryExportData();
+ exportData.setSalaryMonth(main.getSalaryMonth());
+ exportData.setSalaryTitle(main.getSalaryTitle());
+ exportData.setStaffName(detail.getStaffName());
+ exportData.setDeptName(detail.getDeptName());
+ exportData.setBasicSalary(detail.getBasicSalary());
+ exportData.setPieceSalary(detail.getPieceSalary());
+ exportData.setHourlySalary(detail.getHourlySalary());
+ exportData.setOtherIncome(detail.getOtherIncome());
+ exportData.setSocialPersonal(detail.getSocialPersonal());
+ exportData.setFundPersonal(detail.getFundPersonal());
+ exportData.setOtherDeduct(detail.getOtherDeduct());
+ exportData.setSocialSupplementAmount(detail.getSocialSupplementAmount());
+ exportData.setSalaryTax(detail.getSalaryTax());
+ exportData.setGrossSalary(detail.getGrossSalary());
+ exportData.setDeductSalary(detail.getDeductSalary());
+ exportData.setNetSalary(detail.getNetSalary());
+ exportData.setRemark(detail.getRemark());
+ exportDataList.add(exportData);
+ }
+ }
+
+ ExcelUtil<StaffSalaryExportData> util = new ExcelUtil<>(StaffSalaryExportData.class);
+ util.exportExcel(response, exportDataList, "鍛樺伐钖祫鏄庣粏");
+ }
+
public List<Map<String, Object>> setSchemeApplicableStaffUserInfo(List<Long> ids) {
if(CollectionUtils.isEmpty(ids)){
return new ArrayList<>();
--
Gitblit v1.9.3