1

13693261870

2023-08-10 bab4adf858317cd6e2763425cb00101ef623d460

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

@@ -167,6 +167,7 @@
                double lj = mapper.selectAccumulate(yearStart, end, 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");
@@ -213,10 +214,12 @@
                double lj = mapper.selectAccumulate(yearStart, intSun, 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.selectSuYuanByStartAndEnd(id, name, yjz, intMon, intSun);
                String ys = getYs(suList);

                list.add(new WeekExcel("" + sz, zhb + "%", "", ztb + "%", "", "" + lj, "" + ljtb, "", ys, "", "", ""));
            }
            saveResult("week", sun, list);
@@ -236,10 +239,12 @@

            List<MonthExcel> list = new ArrayList<>();
            for (int i = 1; i < 47; i++) {
                String name = "AI-" + (i < 10 ? "0" : "") + i;
                //
            }

            String filePath = createExcel("month", end, list);
                list.add(new MonthExcel());
            }
            saveResult("month", end, list);
        } catch (Exception ex) {
            logger.error(ex.getMessage(), ex);
        }