| | |
|---|
| | | //转换成字符串用于excel导出 |
|---|
| | | public static CheckIndexFaceVO getExcelVo(@NonNull CheckIndexFace checkIndexFace) { |
|---|
| | | CheckIndexFaceVO checkIndexFaceVo = new CheckIndexFaceVO(); |
|---|
| | | checkIndexFaceVo.setNum(checkIndexFace.getNum()); |
|---|
| | | checkIndexFaceVo.setScore(checkIndexFace.getScore().setScale(2,RoundingMode.HALF_UP)); |
|---|
| | | SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); |
|---|
| | | //避免合计行报错(合计数据 缺少createTimeStr字段 直接将createTimeStr设置为"合计") |
|---|
| | |
|---|
| | | } |
|---|
| | | /** 用于导出计算平均值 */ |
|---|
| | | public static CheckIndexFace calculateAverage(List<CheckIndexFace> checkIndexFaces) { |
|---|
| | | Integer numSum = 0; |
|---|
| | | BigDecimal scoreSum = BigDecimal.ZERO; |
|---|
| | | BigDecimal totalViewConnectStability = BigDecimal.ZERO; |
|---|
| | | BigDecimal totalSiteOnline = BigDecimal.ZERO; |
|---|
| | |
|---|
| | | int count = checkIndexFaces.size(); |
|---|
| | | |
|---|
| | | for (CheckIndexFace indexFace : checkIndexFaces) { |
|---|
| | | numSum = numSum + (indexFace.getNum() == null? 0:indexFace.getNum()); |
|---|
| | | scoreSum = scoreSum.add(indexFace.getScore() == null ? BigDecimal.ZERO : indexFace.getScore()); |
|---|
| | | totalViewConnectStability = totalViewConnectStability.add(indexFace.getViewConnectStability()); |
|---|
| | | totalSiteOnline = totalSiteOnline.add(indexFace.getSiteOnline()); |
|---|
| | |
|---|
| | | result.setCreateTimeStr("合计"); |
|---|
| | | result.setDeptName(checkIndexFaces.get(0).getDeptName()); |
|---|
| | | result.setExamineTag(checkIndexFaces.get(0).getExamineTag()); |
|---|
| | | result.setNum(numSum/count); |
|---|
| | | 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)); |
|---|
