package com.platform.service.impl; import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.platform.mapper.ExcelTemplateMapper; import com.platform.model.dto.ExcelTemplateDTO; import com.platform.model.entity.ExcelTemplateEntity; import com.platform.model.vo.ExcelTemplateVO; import com.platform.model.vo.TableHeaderVO; import com.platform.service.ExcelTemplateService; import com.platform.utils.DozerUtils; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.stereotype.Service; import org.springframework.util.ObjectUtils; import javax.servlet.http.HttpServletResponse; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.io.UnsupportedEncodingException; import java.net.URLEncoder; import java.util.List; /** * @author : wujipeng * @date : 2025/7/30 15:05 * @Version: 1.0 * @Desc : 描述信息 */ @Service public class ExcelTemplateServiceImpl extends ServiceImpl implements ExcelTemplateService { @Override public List pageExcelTemplate(ExcelTemplateDTO excelTemplateDTO) { List excelTemplateList = baseMapper.pageExcelTemplate(excelTemplateDTO); for (ExcelTemplateVO excelTemplateVO : excelTemplateList) { if (!ObjectUtils.isEmpty(excelTemplateVO) && !ObjectUtils.isEmpty(excelTemplateVO.getJson())) { String json = excelTemplateVO.getJson(); List tableHeaderList = JSON.parseArray(json, TableHeaderVO.class); excelTemplateVO.setTableHeaderList(tableHeaderList); } if (!ObjectUtils.isEmpty(excelTemplateVO) && !ObjectUtils.isEmpty(excelTemplateVO.getAllHeader())) { String json = excelTemplateVO.getAllHeader(); List tableHeaderList = JSON.parseArray(json, TableHeaderVO.class); excelTemplateVO.setAllList(tableHeaderList); } } return excelTemplateList; } @Override public ExcelTemplateVO detail(Integer id) { ExcelTemplateVO excelTemplate = DozerUtils.convertBean(getById(id), ExcelTemplateVO.class); if (!ObjectUtils.isEmpty(excelTemplate) && !ObjectUtils.isEmpty(excelTemplate.getJson())) { String json = excelTemplate.getJson(); List tableHeaderList = JSON.parseArray(json, TableHeaderVO.class); excelTemplate.setTableHeaderList(tableHeaderList); } if (!ObjectUtils.isEmpty(excelTemplate) && !ObjectUtils.isEmpty(excelTemplate.getAllHeader())) { String json = excelTemplate.getAllHeader(); List tableHeaderList = JSON.parseArray(json, TableHeaderVO.class); excelTemplate.setAllList(tableHeaderList); } return excelTemplate; } @Override public void export(List ids, HttpServletResponse response) { // 设置响应头 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); response.setCharacterEncoding("utf-8"); String fileName = "模板.xlsx"; try { // 设置响应头,告诉浏览器这是文件下载 response.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8")); } catch (UnsupportedEncodingException e) { throw new RuntimeException("文件名编码异常", e); } // 创建一个excel文件对象 try (XSSFWorkbook workbook = new XSSFWorkbook(); OutputStream outputStream = response.getOutputStream()) { for (int i = 0; i < ids.size(); i++) { ExcelTemplateEntity excelTemplate = this.getById(ids.get(i)); XSSFSheet sheet = workbook.createSheet("sheet" + i); sheet.createRow(0); sheet.createRow(1); sheet.createRow(2); sheet.createRow(3); String json = excelTemplate.getJson(); List tableHeaderList = JSON.parseArray(json, TableHeaderVO.class); for (int j = 0; j < tableHeaderList.size(); j++) { TableHeaderVO tableHeaderVO = tableHeaderList.get(j); if (ObjectUtils.isEmpty(tableHeaderVO)) { sheet.getRow(0).createCell(j).setCellValue("-"); sheet.getRow(1).createCell(j).setCellValue("-"); } else { sheet.getRow(0).createCell(j).setCellValue(tableHeaderVO.getName()); sheet.getRow(1).createCell(j).setCellValue(tableHeaderVO.getIndex()); } } // 自动调整列宽 for (int j = 0; j < tableHeaderList.size(); j++) { sheet.autoSizeColumn(j); } String allHeader = excelTemplate.getAllHeader(); List tableHeaderList1 = JSON.parseArray(allHeader, TableHeaderVO.class); for (int j = 0; j < tableHeaderList1.size(); j++) { TableHeaderVO tableHeaderVO = tableHeaderList1.get(j); if (ObjectUtils.isEmpty(tableHeaderVO)) { sheet.getRow(2).createCell(j).setCellValue("-"); sheet.getRow(3).createCell(j).setCellValue("-"); } else { sheet.getRow(2).createCell(j).setCellValue(tableHeaderVO.getName()); sheet.getRow(3).createCell(j).setCellValue(tableHeaderVO.getIndex()); } } // 自动调整列宽 for (int j = 0; j < tableHeaderList1.size(); j++) { sheet.autoSizeColumn(j); } } // 写入输出流 workbook.write(outputStream); outputStream.flush(); } catch (IOException e) { throw new RuntimeException("导出Excel失败", e); } } }