From d759812b05ceffc6021dee9ebf61bc0c22472df3 Mon Sep 17 00:00:00 2001 From: wl <173@qq.com> Date: 星期三, 28 十二月 2022 17:41:37 +0800 Subject: [PATCH] fix: 导入和报案方式 --- src/main/java/com/example/jz/service/impl/ReportServiceImpl.java | 33 +++++++++++++++++++++++++++++++-- 1 files changed, 31 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/example/jz/service/impl/ReportServiceImpl.java b/src/main/java/com/example/jz/service/impl/ReportServiceImpl.java index 37e6ee6..5ae21e5 100644 --- a/src/main/java/com/example/jz/service/impl/ReportServiceImpl.java +++ b/src/main/java/com/example/jz/service/impl/ReportServiceImpl.java @@ -1,6 +1,8 @@ package com.example.jz.service.impl; import com.alibaba.excel.EasyExcel; +import com.alibaba.excel.context.AnalysisContext; +import com.alibaba.excel.event.AnalysisEventListener; import com.alibaba.excel.metadata.data.ImageData; import com.alibaba.excel.metadata.data.WriteCellData; import com.alibaba.excel.util.IoUtils; @@ -12,6 +14,7 @@ import com.example.jz.dao.*; import com.example.jz.modle.PageParam; import com.example.jz.modle.dto.AddReportDto; +import com.example.jz.modle.dto.AddReportLoadDto; import com.example.jz.modle.dto.ReportParamDto; import com.example.jz.modle.entity.*; import com.example.jz.modle.vo.ExportExcelReportVo; @@ -25,6 +28,7 @@ import org.springframework.security.core.context.SecurityContextHolder; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; +import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; @@ -206,8 +210,9 @@ .setCtime(new Date()) .setStatus(0) .setIsInGroup(0) - .setReportMethod("鍚庡彴褰曞叆") - .setIsCommission("0").setReportTime(new Date()) + .setReportMethod("鐜板満鎶ユ") + .setIsCommission("0") + .setReportTime(new Date()) .setCauseId(addReportDto.getCauseId()); return reportService.save(report); } @@ -216,4 +221,28 @@ public List<Report> listGroup(Integer id) { return reportDao.selectListGroup(id); } + + @Override + @SneakyThrows + public void loadFileReport(MultipartFile multipartFile, Integer causeId) { + EasyExcel.read(multipartFile.getInputStream(), AddReportLoadDto.class, new AnalysisEventListener<AddReportLoadDto>() { + @Override + public void invoke(AddReportLoadDto data, AnalysisContext context) { + if (com.baomidou.mybatisplus.core.toolkit.StringUtils.isNotBlank(data.getReporterName()) && com.baomidou.mybatisplus.core.toolkit.StringUtils.isNotBlank(data.getIdcard())) { + AddReportDto addReportDto = new AddReportDto(); + BeanUtils.copyProperties(data, addReportDto); + addReportDto.setCauseId(causeId); + addReport(addReportDto); + } + + } + + @Override + public void doAfterAllAnalysed(AnalysisContext context) { + + } + }) + .autoCloseStream(true) + .doReadAll(); + } } \ No newline at end of file -- Gitblit v1.8.0