diff --git a/casic-service-job-monitor/src/main/java/com/casic/missiles/modular/statistics/StatisticsController.java b/casic-service-job-monitor/src/main/java/com/casic/missiles/modular/statistics/StatisticsController.java index 305aa24..6ea2370 100644 --- a/casic-service-job-monitor/src/main/java/com/casic/missiles/modular/statistics/StatisticsController.java +++ b/casic-service-job-monitor/src/main/java/com/casic/missiles/modular/statistics/StatisticsController.java @@ -70,6 +70,34 @@ return ResponseData.success(count); } + @RequestMapping(value = "/carJobCount") + @ResponseBody + public Object carJobCount() { + Map result = new HashMap<>(); + + // 构建统计查询条件 + JobQueryForm queryForm = new JobQueryForm(); + queryForm.setType("day"); + + Calendar start = Calendar.getInstance(); + start.add(Calendar.DATE, -1); + String yesterday = cn.hutool.core.date.DateUtil.format(start.getTime(), "yyyy-MM-dd"); + queryForm.setStartTime(yesterday); + queryForm.setEndTime(yesterday); + + // 查询转运作业次数 + List> transfer = selectCarJobCount(queryForm, null, "13"); + + // 查询清扫作业次数 + List> clean = selectCarJobCount(queryForm, null, "5"); + + // 获取昨日转运作业次数和清扫作业次数 + result.put("transfer", transfer.get(0).get("count")); + result.put("clean", clean.get(0).get("count")); + + return ResponseData.success(result); + } + private String genCountSql(String dataBase, String endSql) { return JobConstant.SQL_SELECT.concat(dataBase).concat(endSql); }