基于springboot+vue的电厂定期试验管理信息系统.zip

package pro.epms.services.poi.poiService; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.context.AnalysisContext; import com.alibaba.excel.exception.ExcelAnalysisException; import com.alibaba.excel.metadata.CellExtra; import com.alibaba.excel.metadata.data.ReadCellData; import com.alibaba.excel.read.listener.ReadListener; import com.alibaba.excel.read.metadata.property.ExcelReadHeadProperty; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.toolkit.CollectionUtils; import com.mysql.cj.util.StringUtils; import org.apache.poi.ooxml.POIXMLProperties; import org.apache.poi.ss.usermodel.CellType; import org.apache.poi.ss.usermodel.DataValidation; import org.apache.poi.ss.usermodel.DataValidationHelper; import org.apache.poi.ss.util.CellRangeAddressList; import org.apache.poi.xssf.usermodel.*; import org.openxmlformats.schemas.officeDocument.x2006.customProperties.CTProperty; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.dao.DuplicateKeyException; import org.springframework.format.datetime.DateFormatter; import org.springframework.scheduling.annotation.Async; import org.springframework.stereotype.Service; import org.springframework.web.multipart.MultipartFile; import pro.epms.entity.entity.*; import pro.epms.entity.entity.extend.experiment.FailedRecordVO; import pro.epms.entity.entity.extend.experiment.PlanTestListVO; import pro.epms.entity.entity.extend.experiment.TestRecordVO; import pro.epms.entity.entity.pageFilter.experiment.PlanTestListPageFilter; import pro.epms.entity.entity.pageFilter.experiment.TestRecordPageFilter; import pro.epms.entity.service.*; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.io.InputStream; import java.io.PrintWriter; import java.net.URL; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.chrono.ChronoLocalDateTime; import java.time.format.DateTimeFormatter; import java.time.temporal.TemporalAccessor; import java.time.temporal.TemporalAdjusters; import java.util.*; @Service public class ExcelDataUploadService { @Value("${template-resolve.max-row}") Integer TEMPLATE_RESOLVE_MAX_ROW; @Value("${template-resolve.max-col}") Integer TEMPLATE_RESOLVE_MAX_COL; @Autowired HttpServletRequest httpServletRequest; @Autowired HttpServletResponse httpServletResponse; @Autowired IPoiTemplateService poiTemplateService; @Autowired IPlanService planService; @Autowired ITestListService testListService; @Autowired IGeneratorSetService generatorSetService; @Autowired IDepartmentService departmentService; @Autowired IFailedTypeService failedTypeService; @Autowired IPlanTestListService planTestListService; @Autowired ITestRecordService testRecordService; @Autowired IFailedRecordService failedRecordService; @Async public void uploadPlanTestList(MultipartFile file, Long templateId, Boolean createTestWhileNotFound) throws IOException { XSSFWorkbook[] templateWorkbookContainer = {null}; // resolve template Integer[] rowOffset = new Integer[]{0}; Integer[] maxCol = new Integer[]{0}; Integer[] planNameCoordinate = new Integer[2]; Map<Integer, String> headerMap = new LinkedHashMap<>(); Map<Integer, XSSFCellStyle> styleMap = new LinkedHashMap<>(); Map<Integer, CellType> cellTypeMap = new LinkedHashMap<>(); // 数据验证 Map<Integer, XSSFDataValidation> dataValidationMap = new HashMap<>(); resolveTemplate( templateId, templateWorkbookContainer, file, rowOffset, maxCol, planNameCoordinate, headerMap, styleMap, cellTypeMap, dataValidationMap ); XSSFWorkbook templateWorkbook = templateWorkbookContainer[0]; // uploadFile int finalRowOffset = rowOffset[0]; int finalMaxCol = maxCol[0]; EasyExcel.read(file.getInputStream(), new ReadListener<Map<Integer, Object>>() { private String planName = null; // 错误统计 List<Map<Integer, String>> excelWithErrorHead = new ArrayList<>(); List<Map<Integer, Object>> excelWithErrorRows = new ArrayList<>(); @Override public void invokeHead(Map<Integer, ReadCellData<?>> headMap, AnalysisContext context) { if (planNameCoordinate[0] == 0) { planName = headMap.get(planNameCoordinate[1]).getStringValue(); } Map<Integer, String> head = new HashMap<>(); for (Integer key : headerMap.keySet()) { ReadCellData<?> cellData = headMap.get(key); if (cellData == null) { continue; } head.put(key, cellData.getStringValue()); } excelWithErrorHead.add(head); } @Override public void invoke(Map<Integer, Object> data, AnalysisContext analysisContext) { Integer rowIndex = analysisContext.readRowHolder().getRowIndex(); if (rowIndex == planNameCoordinate[0]) { planName = (String) data.get(planNameCoordinate[1]); } // 跳过所在行及之前的行 if (rowIndex <= finalRowOffset) { Map<Integer, String> rowMap = new HashMap<>(); for (Integer key : data.keySet()) { if (data.get(key) == null) { continue; } rowMap.put(key, data.get(key).toString()); } excelWithErrorHead.add(rowMap); return; } Map<String, Object> convertedData = new LinkedHashMap<>(); boolean invalid = true; for (Integer key : data.keySet()) { if (!headerMap.containsKey(key)) { continue; } Object value = data.get(key); if (value == null) { continue; } invalid = false; String propertyName = headerMap.get(key); convertedData.put(propertyName, value); } if (invalid) { return; } PlanTestListVO planTestListVO = PlanTestListVO.fromMap(convertedData); PlanTestList planTestList = PlanTestListVO.toPlanTestList(planTestListVO); if (StringUtils.isNullOrEmpty(planName)) { throw new ExcelAnalysisException("没有指定试验计划"); } // 查询试验计划 QueryWrapper<Plan> planQueryWrapper = new QueryWrapper<>(); planQueryWrapper.eq("name", planName); Plan plan = planService.getOne(planQueryWrapper); if (plan == null) { throw new ExcelAnalysisException("试验计划信息无效"); } planTestList.setPlanId(plan.getId()); // 查询发电机组 QueryWrapper<GeneratorSet> generatorSetWrapper = new QueryWrapper<>(); generatorSetWrapper.eq("code", planTestListVO.getGeneratorCode()); GeneratorSet generatorSet = generatorSetService.getOne(generatorSetWrapper); if (generatorSet == null) { data.