| | |
| | | //转换成字符串用于excel导出 |
| | | public static CheckIndexFaceVO getExcelVo(@NonNull CheckIndexFace checkIndexFace) { |
| | | CheckIndexFaceVO checkIndexFaceVo = new CheckIndexFaceVO(); |
| | | checkIndexFaceVo.setScore(checkIndexFace.getScore()); |
| | | checkIndexFaceVo.setScore(checkIndexFace.getScore().setScale(2,RoundingMode.HALF_UP)); |
| | | SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); |
| | | //避免合计行报错(合计数据 缺少createTimeStr字段 直接将createTimeStr设置为"合计") |
| | | if (StringUtils.isEmpty(checkIndexFace.getCreateTimeStr())) { |
| | |
| | | result.setCreateTimeStr("合计"); |
| | | result.setDeptName(checkIndexFaces.get(0).getDeptName()); |
| | | result.setExamineTag(checkIndexFaces.get(0).getExamineTag()); |
| | | result.setScore(scoreSum); |
| | | result.setScore(scoreSum.divide(BigDecimal.valueOf(count), 2, RoundingMode.HALF_UP)); |
| | | result.setViewConnectStability(totalViewConnectStability.divide(BigDecimal.valueOf(count), 2, RoundingMode.HALF_UP)); |
| | | result.setSiteOnline(totalSiteOnline.divide(BigDecimal.valueOf(count), 2, RoundingMode.HALF_UP)); |
| | | result.setDeviceDirectoryConsistent(totalDeviceDirectoryConsistent.divide(BigDecimal.valueOf(count), 2, RoundingMode.HALF_UP)); |