From 38225792c525a5657a376678a9c4ef58375f213e Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期五, 15 八月 2025 10:23:18 +0800
Subject: [PATCH] yys 修改导入导出
---
src/main/java/com/ruoyi/lavorissue/service/impl/LavorIssueServiceImpl.java | 62 +++++++++++++++++++++++++++++++
1 files changed, 62 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ruoyi/lavorissue/service/impl/LavorIssueServiceImpl.java b/src/main/java/com/ruoyi/lavorissue/service/impl/LavorIssueServiceImpl.java
index b6a5e27..77fe335 100644
--- a/src/main/java/com/ruoyi/lavorissue/service/impl/LavorIssueServiceImpl.java
+++ b/src/main/java/com/ruoyi/lavorissue/service/impl/LavorIssueServiceImpl.java
@@ -5,16 +5,22 @@
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.approve.utils.StartAndEndDateDto;
+import com.ruoyi.common.utils.excel.ExcelUtils;
import com.ruoyi.lavorissue.dto.StatisticsLaborIssue;
import com.ruoyi.lavorissue.mapper.LavorIssueMapper;
import com.ruoyi.lavorissue.pojo.LaborIssue;
import com.ruoyi.lavorissue.service.LavorIssueService;
+import com.ruoyi.project.system.domain.SysDictData;
+import com.ruoyi.project.system.domain.SysDictType;
+import com.ruoyi.project.system.mapper.SysDictDataMapper;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
+import javax.servlet.http.HttpServletResponse;
import java.text.SimpleDateFormat;
+import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
@@ -112,6 +118,62 @@
return statisticsLaborIssue;
}
+ @Autowired
+ private SysDictDataMapper sysDictDataMapper;
+
+ @Override
+ public void exportCopy(HttpServletResponse response) {
+ List<SysDictData> sys_lavor_issue = sysDictDataMapper.selectDictDataByType("sys_lavor_issue");
+ if(CollectionUtils.isEmpty(sys_lavor_issue)){
+ throw new RuntimeException("瀛楀吀鏁版嵁涓虹┖");
+ }
+ List<Object> head = new ArrayList<>();
+ head.add("閮ㄩ棬");
+ head.add(ExcelUtils.COLUMN_MERGE);
+ head.add("浼佷笟绠＄悊绉�");
+ head.add(ExcelUtils.COLUMN_MERGE);
+ head.add("浼佷笟绠＄悊绉�2025骞�1鏈�-2025骞�3鏈堝姵淇濆彂鏀捐鍒掕〃");
+ for (int i = 0; i < sys_lavor_issue.size(); i++) {
+ if (i == 0) {
+ head.add(ExcelUtils.COLUMN_MERGE);
+ } else {
+ head.add(ExcelUtils.COLUMN_MERGE);
+ }
+ }
+ List<Object> head1 = new ArrayList<>();
+ head1.add("寮�濮嬪勾/鏈�");
+ head1.add(ExcelUtils.COLUMN_MERGE);
+ head1.add("缁撴潫骞�/鏈�");
+ head1.add(ExcelUtils.COLUMN_MERGE);
+ for (int i = 0; i < sys_lavor_issue.size(); i++) {
+ head1.add("");
+ }
+
+ List<Object> head2 = new ArrayList<>();
+ head2.add("2025");
+ head2.add("1");
+ head2.add("2025");
+ head2.add("3");
+ for (int i = 0; i < sys_lavor_issue.size(); i++) {
+ head2.add("");
+ }
+ List<Object> head3 = new ArrayList<>();
+ head3.add("閮ㄩ棬鍚嶇О");
+ head3.add(ExcelUtils.COLUMN_MERGE);
+ head3.add("濮撳悕");
+ head3.add("宸ュ彿");
+ for (SysDictData sysDictData : sys_lavor_issue) {
+ head3.add(sysDictData.getDictLabel());
+ }
+
+ List<List<Object>> sheetDataList = new ArrayList<>();
+ sheetDataList.add(head);
+ sheetDataList.add(head1);
+ sheetDataList.add(head2);
+ sheetDataList.add(head3);
+ ExcelUtils.export(response, "鍔充繚鍙戞斁璁″垝琛�", sheetDataList);
+ }
+
public Date getLastDayOfMonth(Date date) {
Calendar calendar = Calendar.getInstance();
calendar.setTime(date); // 璁剧疆浼犲叆鐨凞ate
--
Gitblit v1.9.3