在线监测-实时监控-A059文件导出

whyclxw

2022-01-21 f30ecd34b7629aa97fd1060aba476f09b5676599

在线监测-实时监控-A059文件导出

 src/main/java/com/whyc/service/EchartPictureDowloadService.java

@@ -172,7 +172,7 @@
                sheet.createRow(rowNum);  //创建行
                for(int j=0;j<monCount;j++){
                    FBOTestData fbo=list.get(i+j);
                    sheet.getRow(rowNum).createCell(0).setCellValue(fbo.getRecordTime());
                    sheet.getRow(rowNum).createCell(0).setCellValue(ActionUtil.secToTime(fbo.getTestTimeLong()));
                    sheet.getRow(rowNum).createCell(1).setCellValue(fbo.getSumVol());
                    sheet.getRow(rowNum).createCell(2).setCellValue(fbo.getTestCurr());
                    sheet.getRow(rowNum).createCell(3).setCellValue(fbo.getTestCap());

 src/main/java/com/whyc/util/ActionUtil.java

@@ -492,5 +492,30 @@
            }
        } 
    }
    /**
     * 秒转换小时-分-秒analytics/util/DateUtil.java
     *
     * @param seconds 秒为单位 比如..600秒
     * @return 比如...2小时3分钟52秒
     */
    public static String secToTime(int seconds) {
        int hour = seconds / 3600;
        int minute = (seconds - hour * 3600) / 60;
        int second = (seconds - hour * 3600 - minute * 60);

        StringBuffer sb = new StringBuffer();
        if (hour > 0) {
            sb.append(hour + ":");
        }
        if (minute > 0) {
            sb.append(minute + ":");
        }
        if (second > 0) {
            sb.append(second );
        }
        if (second == 0) {
            sb.append("");
        }
        return sb.toString();
    }
}