package com.ruoyi.inspect.service.impl; import cn.hutool.core.bean.BeanUtil; import cn.hutool.core.util.StrUtil; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; import com.baomidou.mybatisplus.core.toolkit.StringUtils; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.deepoove.poi.XWPFTemplate; import com.deepoove.poi.config.Configure; import com.deepoove.poi.config.ConfigureBuilder; import com.deepoove.poi.data.Pictures; import com.ruoyi.common.core.domain.Result; import com.ruoyi.common.utils.DateImageUtil; import com.ruoyi.common.utils.api.IfsApiUtils; import com.ruoyi.common.utils.QueryWrappers; import com.ruoyi.framework.exception.ErrorException; import com.ruoyi.inspect.dto.IfsStockQueryDTO; import com.ruoyi.inspect.dto.SpotCheckQuarterDto; import com.ruoyi.inspect.dto.SpotCheckYearDto; import com.ruoyi.inspect.mapper.SpotCheckQuarterMapper; import com.ruoyi.inspect.mapper.SpotCheckYearMapper; import com.ruoyi.inspect.pojo.SpotCheckQuarter; import com.ruoyi.inspect.pojo.SpotCheckQuarterItem; import com.ruoyi.inspect.pojo.SpotCheckYear; import com.ruoyi.inspect.pojo.SpotCheckYearItem; import com.ruoyi.inspect.service.FinishProductSpotCheckService; import com.ruoyi.inspect.service.SpotCheckQuarterItemService; import com.ruoyi.inspect.service.SpotCheckYearItemService; import com.ruoyi.system.mapper.UserMapper; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.net.URLEncoder; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.stream.Collectors; /** * 成品抽样 * * @Author zhuo * @Date 2024/9/29 */ @Service @Transactional(rollbackFor = Exception.class) public class FinishProductSpotCheckServiceImpl implements FinishProductSpotCheckService { @Resource private IfsApiUtils ifsApiUtils; @Resource private SpotCheckQuarterMapper spotCheckQuarterMapper; @Resource private SpotCheckQuarterItemService spotCheckQuarterItemService; @Resource private SpotCheckYearMapper spotCheckYearMapper; @Resource private SpotCheckYearItemService spotCheckYearItemService; @Value("${wordUrl}") private String wordUrl; @Value("${file.path}") private String imgUrl; @Resource private UserMapper userMapper; public Result getIfsStockReport(IfsStockQueryDTO ifsStockQueryDTO) { JSONObject jresult = new JSONObject(); jresult.put("total", 0); jresult.put("count", 0); jresult.put("data", new JSONArray()); JSONObject jsonObject = new JSONObject(); generateIfsStockQueryParams(jsonObject, ifsStockQueryDTO, ifsStockQueryDTO.getPage(), ifsStockQueryDTO.getLimit()); Result result = ifsApiUtils.getIfsStock(jsonObject.toJSONString()); if (result.getCode() == 200) { JSONObject data = (JSONObject) JSON.toJSON(result.getData()); JSONArray array = new JSONArray(); for (int i = 0; i < data.getJSONArray("LIST_INFO").size(); i++) { JSONObject listInfo = data.getJSONArray("LIST_INFO").getJSONObject(i); array.add(listInfo); } //获取总数量 int count = data.getIntValue("TOTAL_RECORD"); //获取页数 int total = (int) Math.ceil((double) count / (double) ifsStockQueryDTO.getLimit()); jresult.put("total", total); jresult.put("count", count); jresult.put("data", array); } return Result.success(jresult); } public void generateIfsStockQueryParams(JSONObject result, IfsStockQueryDTO ifsStockQueryDTO, Long pageNo, Long pageSize) { result.put("PAGE", pageNo); result.put("LIMIT", pageSize); result.put("WAREHOUSE", "成品仓库"); result.put("QUANTITY_FLAG", ">0"); //表里面的OTC行号 if (StrUtil.isNotBlank(ifsStockQueryDTO.getCotcOrderNo())) { result.put("C_OTC_ORDER_NO", ifsStockQueryDTO.getCotcOrderNo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getCotcLineNo())) { result.put("C_OTC_LINE_NO", ifsStockQueryDTO.getCotcLineNo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getPartNo())) { result.put("PART_NO", ifsStockQueryDTO.getPartNo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getPartDescription())) { result.put("PART_DESC", "%" + ifsStockQueryDTO.getPartDescription() + "%"); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getLocNo())) { result.put("LOCATION_NO", ifsStockQueryDTO.getLocNo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getLocDesc())) { result.put("LOCATION_DESC", ifsStockQueryDTO.getLocDesc()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getLotBatchNo())) { result.put("LOT_BATCH_NO", ifsStockQueryDTO.getLotBatchNo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getWdrNo())) { result.put("WDR_NO", ifsStockQueryDTO.getWdrNo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getWarehouse())) { result.put("WAREHOUSE", ifsStockQueryDTO.getWarehouse()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getLocationGroup())) { result.put("LOCATION_GROUP", ifsStockQueryDTO.getLocationGroup()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getLocationGroupDesc())) { result.put("LOCATION_GROUP_DESC", ifsStockQueryDTO.getLocationGroupDesc()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getReelNumber())) { result.put("ATTR1", ifsStockQueryDTO.getReelNumber()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getStartMeter())) { result.put("ATTR2", ifsStockQueryDTO.getStartMeter()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getEndMeter())) { result.put("ATTR3", ifsStockQueryDTO.getEndMeter()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getOuterColor())) { result.put("ATTR4", ifsStockQueryDTO.getOuterColor()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getInsulationColor())) { result.put("ATTR5", ifsStockQueryDTO.getInsulationColor()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getOtcOrderNo())) { result.put("ATTR6", ifsStockQueryDTO.getOtcOrderNo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getMpsNo())) { result.put("ATTR7", ifsStockQueryDTO.getMpsNo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getLetteringInfo())) { result.put("ATTR8", ifsStockQueryDTO.getLetteringInfo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getSStockQuantity())) { result.put("ATTR9", ifsStockQueryDTO.getSStockQuantity()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getSAvailableStockQuantity())) { result.put("ATTR10", ifsStockQueryDTO.getSAvailableStockQuantity()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getSunit())) { result.put("ATTR11", ifsStockQueryDTO.getSunit()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getStockSource())) { result.put("ATTR12", ifsStockQueryDTO.getStockSource()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getInspInstorageTime())) { result.put("ATTR13", ifsStockQueryDTO.getInspInstorageTime()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getTestRemark())) { result.put("ATTR14", ifsStockQueryDTO.getTestRemark()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getGrossWeight())) { result.put("ATTR15", ifsStockQueryDTO.getGrossWeight()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getNetWeight())) { result.put("ATTR16", ifsStockQueryDTO.getNetWeight()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getPackingManner())) { result.put("ATTR17", ifsStockQueryDTO.getPackingManner()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getCylinderNumber())) { result.put("ATTR18", ifsStockQueryDTO.getCylinderNumber()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getRemark())) { result.put("ATTR19", ifsStockQueryDTO.getRemark()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getLengthRequirement())) { result.put("ATTR20", ifsStockQueryDTO.getLengthRequirement()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getCustomerName())) { result.put("ATTR21", ifsStockQueryDTO.getCustomerName()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getSystemNo())) { result.put("ATTR22", ifsStockQueryDTO.getSystemNo()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getInSource())) { result.put("ATTR23", ifsStockQueryDTO.getInSource()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getSplitQuality())) { result.put("ATTR24", ifsStockQueryDTO.getSplitQuality()); } if (StrUtil.isNotBlank(ifsStockQueryDTO.getReserveQuantity())) { result.put("QTY_RESERVED", ifsStockQueryDTO.getReserveQuantity()); } } /************************************************* 季度抽样 ***********************************************************/ /** * 新增季度抽检 * @param spotCheckQuarterDto * @return */ @Override public boolean addQuarter(SpotCheckQuarterDto spotCheckQuarterDto) { // 根据编号查询之前的 SpotCheckQuarter spotCheckQuarter = spotCheckQuarterMapper.selectOne(Wrappers.lambdaQuery() .eq(SpotCheckQuarter::getQuarterNo, spotCheckQuarterDto.getQuarterNo()) .orderByDesc(SpotCheckQuarter::getCreateTime) .last("limit 1")); if (spotCheckQuarter == null) { spotCheckQuarterMapper.insert(spotCheckQuarterDto); // 添加详情 for (SpotCheckQuarterItem quarterItem : spotCheckQuarterDto.getQuarterItems()) { quarterItem.setQuarterId(spotCheckQuarterDto.getQuarterId()); } spotCheckQuarterItemService.saveBatch(spotCheckQuarterDto.getQuarterItems()); } else { // 累加详情 for (SpotCheckQuarterItem quarterItem : spotCheckQuarterDto.getQuarterItems()) { quarterItem.setQuarterId(spotCheckQuarter.getQuarterId()); } spotCheckQuarterItemService.saveBatch(spotCheckQuarterDto.getQuarterItems()); } return true; } /** * 查询季度抽样详情 * @param quarterId * @return */ @Override public SpotCheckQuarterDto getQuarter(Integer quarterId) { SpotCheckQuarter spotCheckQuarter = spotCheckQuarterMapper.selectById(quarterId); // 查询详情 List list = spotCheckQuarterItemService.list(Wrappers.lambdaQuery() .eq(SpotCheckQuarterItem::getQuarterId, spotCheckQuarter.getQuarterId())); SpotCheckQuarterDto spotCheckQuarterDto = new SpotCheckQuarterDto(); BeanUtil.copyProperties(spotCheckQuarter, spotCheckQuarterDto); spotCheckQuarterDto.setQuarterItems(list); return spotCheckQuarterDto; } /** * 季度抽样分页查询 * @param page * @param spotCheckQuarter * @return */ @Override public IPage getQuarterPage(Page page, SpotCheckQuarterDto spotCheckQuarter) { return spotCheckQuarterMapper.getQuarterPage(page, QueryWrappers.queryWrappers(spotCheckQuarter)); } /** * 删除季度抽样 * @param quarterId * @return */ @Override public boolean deleteQuarter(Integer quarterId) { spotCheckQuarterMapper.deleteById(quarterId); spotCheckQuarterItemService.remove(Wrappers.lambdaQuery() .eq(SpotCheckQuarterItem::getQuarterId, quarterId)); return true; } /** * 成品下单界面查询季度信息 * @return */ @Override public List> getQuarterOnOrder() { List> quarterOnOrder = spotCheckQuarterMapper.getQuarterOnOrder(); for (Map stringMap : quarterOnOrder) { List list = spotCheckQuarterItemService.list(Wrappers.lambdaQuery() .eq(SpotCheckQuarterItem::getQuarterId, (Integer) stringMap.get("value"))); List> itemMaps = list.stream().map(spotCheckQuarterItem -> { Map map = new HashMap<>(); map.put("value", spotCheckQuarterItem.getQuarterItemId()); map.put("label", spotCheckQuarterItem.getProductModel() + " " + spotCheckQuarterItem.getProductType() + " " + spotCheckQuarterItem.getSpotCheckNumber()); return map; }).collect(Collectors.toList()); stringMap.put("children", itemMaps); } return quarterOnOrder; } /** * 修改季度检验 * @param spotCheckQuarterDto * @return */ @Override public boolean updateQuarterOnOrder(SpotCheckQuarterDto spotCheckQuarterDto) { if (CollectionUtils.isNotEmpty(spotCheckQuarterDto.getQuarterItems())) { // 清除之前详情 spotCheckQuarterItemService.remove(Wrappers.lambdaQuery() .eq(SpotCheckQuarterItem::getQuarterId, spotCheckQuarterDto.getQuarterId())); // 添加详情 for (SpotCheckQuarterItem quarterItem : spotCheckQuarterDto.getQuarterItems()) { quarterItem.setQuarterId(spotCheckQuarterDto.getQuarterId()); } spotCheckQuarterItemService.saveBatch(spotCheckQuarterDto.getQuarterItems()); } spotCheckQuarterMapper.updateById(spotCheckQuarterDto); return true; } /** * 生成最终报告 * @param quarterId * @return */ @Override public boolean finalReportQuarter(Integer quarterId, HttpServletResponse response) { // 添加报告信息 SpotCheckQuarter spotCheckQuarter = spotCheckQuarterMapper.selectById(quarterId); // 查询详情 List itemList = spotCheckQuarterItemService.list(Wrappers.lambdaQuery() .eq(SpotCheckQuarterItem::getQuarterId, spotCheckQuarter.getQuarterId())); for (SpotCheckQuarterItem spotCheckQuarterItem : itemList) { // 拼接型号和数量 spotCheckQuarterItem.setSpotCheckNumber((StringUtils.isBlank(spotCheckQuarterItem.getProductModel()) ? "" : spotCheckQuarterItem.getProductModel()) + (StringUtils.isBlank(spotCheckQuarterItem.getSpotCheckNumber()) ? "" : spotCheckQuarterItem.getSpotCheckNumber())); } //编制人 String writeUrl = null; if (spotCheckQuarter.getWriteUser() != null) { try { writeUrl = userMapper.selectById(spotCheckQuarter.getWriteUser()).getSignatureUrl(); } catch (Exception e) { throw new ErrorException("找不到编制人的签名"); } if (StrUtil.isBlank(writeUrl)) { throw new ErrorException("找不到编制人的签名"); } } // 初始化所有的 countersignUrl 变量 String[] countersignUrls = new String[7]; // 如果 spotCheckQuarter.getCountersignUser() 不是空或空白字符串 if (StrUtil.isNotBlank(spotCheckQuarter.getCountersignUser())) { String[] split = spotCheckQuarter.getCountersignUser().split(","); // 遍历 split 数组，并将元素依次赋值给 countersignUrls 数组 for (int i = 0; i < Math.min(split.length, countersignUrls.length); i++) { String countersignUrl = null; try { countersignUrl = userMapper.selectById(Integer.parseInt(split[i])).getSignatureUrl(); } catch (Exception e) { throw new ErrorException("找不到编制人的签名"); } if (StrUtil.isBlank(countersignUrl)) { throw new ErrorException("找不到编制人的签名"); } countersignUrls[i] = countersignUrl; } } // 将 countersignUrls 数组中的值依次赋值给 countersignUrl1 到 countersignUrl7 String countersignUrl1 = countersignUrls[0]; String countersignUrl2 = countersignUrls[1]; String countersignUrl3 = countersignUrls[2]; String countersignUrl4 = countersignUrls[3]; String countersignUrl5 = countersignUrls[4]; String countersignUrl6 = countersignUrls[5]; String countersignUrl7 = countersignUrls[6]; //审核人 String examineUrl = null; if (spotCheckQuarter.getExamineUser() != null) { try { examineUrl = userMapper.selectById(spotCheckQuarter.getExamineUser()).getSignatureUrl(); } catch (Exception e) { throw new ErrorException("找不到审核人的签名"); } if (StrUtil.isBlank(examineUrl)) { throw new ErrorException("找不到审核人的签名"); } } //批准人 String ratifyUrl = null; if (spotCheckQuarter.getRatifyUser() != null) { try { ratifyUrl = userMapper.selectById(spotCheckQuarter.getRatifyUser()).getSignatureUrl(); } catch (Exception e) { throw new ErrorException("找不到批准人的签名"); } if (StrUtil.isBlank(ratifyUrl)) { throw new ErrorException("找不到批准人的签名"); } } String finalWriteUrl = writeUrl; String finalExamineUrl = examineUrl; String finalRatifyUrl = ratifyUrl; // 获取路径 InputStream inputStream = this.getClass().getResourceAsStream("/static/spot_check_quarter.docx"); ConfigureBuilder builder = Configure.builder(); builder.useSpringEL(true); XWPFTemplate template = XWPFTemplate.compile(inputStream, builder.build()).render( new HashMap() {{ put("quarter", spotCheckQuarter); put("quarterItems", itemList); put("writeUrl", StrUtil.isBlank(finalWriteUrl) ? null : Pictures.ofLocal(imgUrl + "/" + finalWriteUrl).create()); put("countersignUrl1", StrUtil.isBlank(countersignUrl1) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl1).create()); put("countersignUrl2", StrUtil.isBlank(countersignUrl2) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl2).create()); put("countersignUrl3", StrUtil.isBlank(countersignUrl3) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl3).create()); put("countersignUrl4", StrUtil.isBlank(countersignUrl4) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl4).create()); put("countersignUrl5", StrUtil.isBlank(countersignUrl5) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl5).create()); put("countersignUrl6", StrUtil.isBlank(countersignUrl6) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl6).create()); put("countersignUrl7", StrUtil.isBlank(countersignUrl7) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl7).create()); put("examineUrl", StrUtil.isBlank(finalExamineUrl) ? null : Pictures.ofLocal(imgUrl + "/" + finalExamineUrl).create()); put("ratifyUrl", StrUtil.isBlank(finalRatifyUrl) ? null : Pictures.ofLocal(imgUrl + "/" + finalRatifyUrl).create()); put("createDateUrl", Pictures.ofStream(DateImageUtil.createDateImage(spotCheckQuarter.getCreateTime())).create()); }}); try { response.setContentType("application/msword"); String fileName = URLEncoder.encode( spotCheckQuarter.getQuarterNo() + "抽样计划", "UTF-8"); response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".docx"); OutputStream os = response.getOutputStream(); template.write(os); os.flush(); os.close(); inputStream.close(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException("导出失败"); } return true; } /******************************************************* 年度抽样 *************************************************************/ @Override public boolean addSpotCheckYear(SpotCheckYearDto spotCheckYearDto) { spotCheckYearMapper.insert(spotCheckYearDto); // 详情 for (SpotCheckYearItem yearItem : spotCheckYearDto.getYearItems()) { yearItem.setYearId(spotCheckYearDto.getYearId()); } spotCheckYearItemService.saveBatch(spotCheckYearDto.getYearItems()); return true; } @Override public SpotCheckYearDto getSpotCheckYear(Integer yearId) { SpotCheckYear spotCheckYear = spotCheckYearMapper.selectById(yearId); // 查询详情 List list = spotCheckYearItemService.list(Wrappers.lambdaQuery() .eq(SpotCheckYearItem::getYearId, spotCheckYear.getYearId())); SpotCheckYearDto spotCheckYearDto = new SpotCheckYearDto(); BeanUtil.copyProperties(spotCheckYear, spotCheckYearDto); spotCheckYearDto.setYearItems(list); return spotCheckYearDto; } @Override public IPage getSpotCheckYearPage(Page page, SpotCheckYearDto spotCheckYear) { return spotCheckYearMapper.getSpotCheckYearPage(page, QueryWrappers.queryWrappers(spotCheckYear)); } @Override public boolean deleteSpotCheckYear(Integer yearId) { spotCheckYearMapper.deleteById(yearId); spotCheckYearItemService.remove(Wrappers.lambdaQuery() .eq(SpotCheckYearItem::getYearId, yearId)); return true; } /** * 修改年度检验 * @param spotCheckYearDto * @return */ @Override public boolean updateSpotCheckYear(SpotCheckYearDto spotCheckYearDto) { spotCheckYearMapper.updateById(spotCheckYearDto); // 删除详情 spotCheckYearItemService.remove(Wrappers.lambdaQuery() .eq(SpotCheckYearItem::getYearId, spotCheckYearDto.getYearId())); // 重新新增 for (SpotCheckYearItem yearItem : spotCheckYearDto.getYearItems()) { yearItem.setYearId(spotCheckYearDto.getYearId()); } spotCheckYearItemService.saveBatch(spotCheckYearDto.getYearItems()); return false; } @Override public boolean finalReportSpotCheckYear(Integer yearId, HttpServletResponse response) { SpotCheckYear spotCheckYear = spotCheckYearMapper.selectById(yearId); // 查询详情 List itemList = spotCheckYearItemService.list(Wrappers.lambdaQuery() .eq(SpotCheckYearItem::getYearId, spotCheckYear.getYearId())); //编制人 String writeUrl = null; if (spotCheckYear.getWriteUser() != null) { try { writeUrl = userMapper.selectById(spotCheckYear.getWriteUser()).getSignatureUrl(); } catch (Exception e) { throw new ErrorException("找不到编制人的签名"); } if (StrUtil.isBlank(writeUrl)) { throw new ErrorException("找不到编制人的签名"); } } // 初始化所有的 countersignUrl 变量 String[] countersignUrls = new String[7]; // 如果不是空或空白字符串 if (StrUtil.isNotBlank(spotCheckYear.getCountersignUser())) { String[] split = spotCheckYear.getCountersignUser().split(","); // 遍历 split 数组，并将元素依次赋值给 countersignUrls 数组 for (int i = 0; i < Math.min(split.length, countersignUrls.length); i++) { String countersignUrl = null; try { countersignUrl = userMapper.selectById(Integer.parseInt(split[i])).getSignatureUrl(); } catch (Exception e) { throw new ErrorException("找不到编制人的签名"); } if (StrUtil.isBlank(countersignUrl)) { throw new ErrorException("找不到编制人的签名"); } countersignUrls[i] = countersignUrl; } } // 将 countersignUrls 数组中的值依次赋值给 countersignUrl1 到 countersignUrl7 String countersignUrl1 = countersignUrls[0]; String countersignUrl2 = countersignUrls[1]; String countersignUrl3 = countersignUrls[2]; String countersignUrl4 = countersignUrls[3]; String countersignUrl5 = countersignUrls[4]; String countersignUrl6 = countersignUrls[5]; String countersignUrl7 = countersignUrls[6]; //审核人 String examineUrl = null; if (spotCheckYear.getExamineUser() != null) { try { examineUrl = userMapper.selectById(spotCheckYear.getExamineUser()).getSignatureUrl(); } catch (Exception e) { throw new ErrorException("找不到审核人的签名"); } if (StrUtil.isBlank(examineUrl)) { throw new ErrorException("找不到审核人的签名"); } } //批准人 String ratifyUrl = null; if (spotCheckYear.getRatifyUser() != null) { try { ratifyUrl = userMapper.selectById(spotCheckYear.getRatifyUser()).getSignatureUrl(); } catch (Exception e) { throw new ErrorException("找不到批准人的签名"); } if (StrUtil.isBlank(ratifyUrl)) { throw new ErrorException("找不到批准人的签名"); } } String finalWriteUrl = writeUrl; String finalExamineUrl = examineUrl; String finalRatifyUrl = ratifyUrl; // 获取路径 InputStream inputStream = this.getClass().getResourceAsStream("/static/spot_check_year.docx"); ConfigureBuilder builder = Configure.builder(); builder.useSpringEL(true); XWPFTemplate template = XWPFTemplate.compile(inputStream, builder.build()).render( new HashMap() {{ put("year", spotCheckYear); put("yearItems", itemList); put("writeUrl", StrUtil.isBlank(finalWriteUrl) ? null : Pictures.ofLocal(imgUrl + "/" + finalWriteUrl).create()); put("countersignUrl1", StrUtil.isBlank(countersignUrl1) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl1).create()); put("countersignUrl2", StrUtil.isBlank(countersignUrl2) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl2).create()); put("countersignUrl3", StrUtil.isBlank(countersignUrl3) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl3).create()); put("countersignUrl4", StrUtil.isBlank(countersignUrl4) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl4).create()); put("countersignUrl5", StrUtil.isBlank(countersignUrl5) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl5).create()); put("countersignUrl6", StrUtil.isBlank(countersignUrl6) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl6).create()); put("countersignUrl7", StrUtil.isBlank(countersignUrl7) ? null : Pictures.ofLocal(imgUrl + "/" + countersignUrl7).create()); put("examineUrl", StrUtil.isBlank(finalExamineUrl) ? null : Pictures.ofLocal(imgUrl + "/" + finalExamineUrl).create()); put("ratifyUrl", StrUtil.isBlank(finalRatifyUrl) ? null : Pictures.ofLocal(imgUrl + "/" + finalRatifyUrl).create()); put("createDateUrl", Pictures.ofStream(DateImageUtil.createDateImage(spotCheckYear.getCreateTime())).create()); }}); try { response.setContentType("application/msword"); String fileName = URLEncoder.encode( spotCheckYear.getYearHead(), "UTF-8"); response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".docx"); OutputStream os = response.getOutputStream(); template.write(os); os.flush(); os.close(); inputStream.close(); } catch (IOException e) { throw new RuntimeException(e); } return true; } }