1

13693261870

2023-08-10 52d0a60fb770d11010d61d2cbef4ed8dbfa281aa

 src/main/java/com/yssh/service/XlsReportService.java

@@ -117,6 +117,7 @@
        List<String> list = new ArrayList<>();
        for (SuYuan700 su : suList) {
            List<String> sub = new ArrayList<>();
            sub.add(DateUtils.getYyyyMmDdHh(su.getCreateTime()));
            if (null != su.getAddr1())
                sub.add(su.getAddr1() + "，概率：" + (su.getOdds1() * 100) + "%，X：" + su.getX1() + "，Y：" + su.getY1());
            if (null != su.getAddr2())
@@ -148,14 +149,14 @@
                String name = "AI-" + (i < 10 ? "0" : "") + i;
                double rjz = mapper.selectDayAvg(yyyymmdd + "%", name);
                double lj = mapper.selectAccumulate(start, end, name);
                double lastLj = mapper.selectYearAccumulate(lastYear, name);
                double lastLj = mapper.selectYearAccumulate(lastYear + "%", name);
                double ljtb = CalculateUtils.round2((lj - lastLj) / lastLj * 100);
                MonitorPointPosition point = commonService.select3dCheckPointByName(name);
                String id = point.getId().substring(0, point.getId().lastIndexOf("_") + 1) + "0";
                List<SuYuan700> suList = mapper.selectSuYuanByTime(id, yyyy_mm_dd + " 00:00:00", yyyy_mm_dd + " 23:00:00");
                String ys = getYs(suList);

                list.add(new DayExcel("" + rjz, "" + lj, "" + ljtb, ys, "", "", ""));
                list.add(new DayExcel("" + rjz, "" + lj, ljtb + "%", ys, "", "", ""));
            }

            String filePath = createExcel("day", yesterday, list);