| | |
|---|
| | | //转换成字符串用于excel导出 |
|---|
| | | public static CheckIndexVideoVO getExcelVo(@NonNull CheckIndexVideo checkIndexVideo) { |
|---|
| | | CheckIndexVideoVO checkIndexVideoVO = new CheckIndexVideoVO(); |
|---|
| | | checkIndexVideoVO.setScore(checkIndexVideo.getScore()); |
|---|
| | | checkIndexVideoVO.setScore(checkIndexVideo.getScore().setScale(2,RoundingMode.HALF_UP)); |
|---|
| | | checkIndexVideoVO.setDeptName(checkIndexVideo.getDeptName()); |
|---|
| | | //避免合计行报错(合计数据 缺少createTimeStr字段 直接将createTimeStr设置为"合计") |
|---|
| | | if (StringUtils.isEmpty(checkIndexVideo.getCreateTimeStr())) { |
|---|
| | |
|---|
| | | averageVideo.setCreateTimeStr("合计"); |
|---|
| | | averageVideo.setDeptName(videos.get(0).getDeptName()); |
|---|
| | | averageVideo.setExamineTag(videos.get(0).getExamineTag()); |
|---|
| | | averageVideo.setScore(scoreSum); |
|---|
| | | averageVideo.setScore(scoreSum.divide(BigDecimal.valueOf(count), 2, RoundingMode.HALF_UP)); |
|---|
| | | averageVideo.setPlatformOnline(totalPlatformOnline.divide(BigDecimal.valueOf(count), 2, RoundingMode.HALF_UP)); |
|---|
| | | averageVideo.setMonitorQualification(totalMonitorQualification.divide(BigDecimal.valueOf(count), 2, RoundingMode.HALF_UP)); |
|---|
| | | averageVideo.setMonitorRegistration(totalMonitorRegistration.divide(BigDecimal.valueOf(count), 2, RoundingMode.HALF_UP)); |
|---|
