| | |
| | | import java.io.InputStream; |
| | | import java.io.OutputStream; |
| | | import java.net.URLEncoder; |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.stream.Collectors; |
| | |
| | | String endDate = processMethodSearchNew.getEndDate(); |
| | | String writeUserId = processMethodSearchNew.getWriteUserId().toString(); |
| | | String ratifyUserId = processMethodSearchNew.getRatifyUserId().toString(); |
| | | String writeDate = processMethodSearchNew.getWriteDate(); |
| | | String ratifyDate = processMethodSearchNew.getRatifyDate(); |
| | | processMethodSearchNew.setBeginDate(null); |
| | | processMethodSearchNew.setEndDate(null); |
| | | processMethodSearchNew.setWriteUserId(null); |
| | | processMethodSearchNew.setRatifyUserId(null); |
| | | processMethodSearchNew.setWriteDate(null); |
| | | processMethodSearchNew.setRatifyDate(null); |
| | | List<ProcessMethodSearchNewDto> methodSearchNews = baseMapper.selectMethodSearchNew(QueryWrappers.queryWrappers(processMethodSearchNew), beginDate, endDate); |
| | | |
| | | int index = 1; |
| | |
| | | // 备注 |
| | | if (methodSearchNew.getRemark() != null) { |
| | | if (methodSearchNew.getRemark().equals(1)) { |
| | | methodSearchNew.setIsNewStandardString("替换"); |
| | | methodSearchNew.setRemarkString("替换"); |
| | | } else { |
| | | methodSearchNew.setIsNewStandardString("作废"); |
| | | methodSearchNew.setRemarkString("作废"); |
| | | } |
| | | } |
| | | |
| | |
| | | List<List<Object>> totalListList = ListUtils.newArrayList(); |
| | | List<Object> totalList = ListUtils.newArrayList(); |
| | | totalListList.add(totalList); |
| | | DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd"); |
| | | // 第一列 |
| | | totalList.add("查新人:"); |
| | | totalList.add("编制人:"); |
| | | // 第二列 设置签名 |
| | | totalList.add(FileUtils.readFileToByteArray(new File(writeUserUrl))); |
| | | // 第三列 |
| | | totalList.add("日期:"); |
| | | // 第五列 |
| | | totalList.add("2024-12-23"); // 日期写死 |
| | | totalList.add(writeDate); |
| | | // 第六列 |
| | | totalList.add("审核:"); |
| | | // 第七列 |
| | |
| | | // 第八列 |
| | | totalList.add("日期:"); |
| | | // 第九列 |
| | | totalList.add("2024-12-23"); // 日期写死 |
| | | totalList.add(ratifyDate); |
| | | // 这里是write 别和fill 搞错了 |
| | | excelWriter.write(totalListList, writeSheet); |
| | | |