From 48e1a3658117ebda9270d87092cfb0d31a634b92 Mon Sep 17 00:00:00 2001 From: wl <173@qq.com> Date: 星期四, 21 七月 2022 15:07:00 +0800 Subject: [PATCH] bug修改 --- src/main/java/com/example/jz/service/impl/ReportServiceImpl.java | 42 +++++++++++++++--------------------------- 1 files changed, 15 insertions(+), 27 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 1cac461..d6f26ba 100644 --- a/src/main/java/com/example/jz/service/impl/ReportServiceImpl.java +++ b/src/main/java/com/example/jz/service/impl/ReportServiceImpl.java @@ -3,31 +3,21 @@ import com.alibaba.excel.EasyExcel; import com.alibaba.excel.metadata.data.ImageData; import com.alibaba.excel.metadata.data.WriteCellData; -import com.alibaba.excel.support.ExcelTypeEnum; import com.alibaba.excel.util.IoUtils; import com.alibaba.excel.util.StringUtils; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; -import com.example.jz.dao.GroupDao; -import com.example.jz.dao.GroupUserDao; -import com.example.jz.dao.ReportDao; -import com.example.jz.dao.UserDao; +import com.example.jz.dao.*; import com.example.jz.modle.dto.AddReportDto; import com.example.jz.modle.dto.ReportParamDto; -import com.example.jz.modle.entity.Group; -import com.example.jz.modle.entity.GroupUser; -import com.example.jz.modle.entity.Report; -import com.example.jz.modle.entity.User; -import com.example.jz.modle.vo.ReportListVo; -import com.example.jz.dao.*; import com.example.jz.modle.entity.*; import com.example.jz.modle.vo.ExportExcelReportVo; +import com.example.jz.modle.vo.ReportListVo; import com.example.jz.service.MinIOService; import com.example.jz.service.ReportService; import lombok.SneakyThrows; -import org.springframework.beans.BeanUtils; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @@ -35,13 +25,12 @@ import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; +import java.io.Serializable; import java.net.URL; import java.net.URLEncoder; -import java.nio.charset.StandardCharsets; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; import java.util.ArrayList; -import java.io.Serializable; import java.util.Date; import java.util.List; @@ -113,17 +102,17 @@ ArrayList<ImageData> imageDataList = new ArrayList<>(); if (StringUtils.isNotBlank(a.getReportMaterials())) { String[] urls = a.getReportMaterials().split(","); - if (urls.length==1){ - int width=600; + if (urls.length == 1) { + int width = 600; try { ImageData imageData = new ImageData(); imageData.setImage(IoUtils.toByteArray(new URL(minIOService.getPreviewFileUrl(urls[0])).openConnection().getInputStream())); - imageData.setRight(width/2); + imageData.setRight(width / 2); imageDataList.add(imageData); } catch (Exception e) { throw new RuntimeException(e); } - }else { + } else { for (int i = 0; i < urls.length; i++) { int width = 600; try { @@ -137,16 +126,16 @@ } } } - } - objectWriteCellData.setImageDataList(imageDataList); - exportExcelReportVo.setWriteCellData(objectWriteCellData); - exportExcelReportVos.add(exportExcelReportVo); + } + objectWriteCellData.setImageDataList(imageDataList); + exportExcelReportVo.setWriteCellData(objectWriteCellData); + exportExcelReportVos.add(exportExcelReportVo); } ); String name = causeDao.selectOne(new QueryWrapper<Cause>().eq("id", id)).getName(); - response.setHeader("Content-disposition", "attachment;filename="+ LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))+URLEncoder.encode(name+".xlsx","utf-8")); - response.setCharacterEncoding("utf-8"); response.setContentType("application/vnd.ms-excel"); + response.setCharacterEncoding("utf-8"); + response.setHeader("Content-disposition", "attachment;filename=" + LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")) + URLEncoder.encode(name + ".xlsx", "utf-8")); EasyExcel.write(response.getOutputStream(), ExportExcelReportVo.class).sheet("鏉愭枡瀵煎嚭").doWrite(exportExcelReportVos); } @@ -164,7 +153,7 @@ @Override public Page<ReportListVo> getPageByGroupId(Page<ReportListVo> page, ReportParamDto reportParamDto, Integer groupId) { - Page<ReportListVo> aaa = reportDao.getPageByGroupId(page, reportParamDto,groupId); + Page<ReportListVo> aaa = reportDao.getPageByGroupId(page, reportParamDto, groupId); aaa.getRecords().stream().forEach(x -> x.setIdcard(x.getIdcard().replaceAll("(?<=[\\d]{3})\\d(?=[\\d]{4})", "*"))); return aaa; } @@ -190,5 +179,4 @@ .setIsCommission("0").setReportTime(new Date()); return reportDao.insert(report) > 0; } -} - +} \ No newline at end of file -- Gitblit v1.8.0