From 8030905be406c979c3bea37cc79f282af4c6ba17 Mon Sep 17 00:00:00 2001
From: baizonghao <1719256278@qq.com>
Date: 星期五, 17 三月 2023 18:29:44 +0800
Subject: [PATCH] 驾驶舱指数体征排行榜
---
ycl-platform/src/main/java/com/ycl/service/apidata/impl/IApiDataServiceImpl.java | 22 +++++++++++
ycl-platform/src/main/java/com/ycl/service/apidata/IApiDataService.java | 10 +++++
ycl-platform/src/main/java/com/ycl/controller/cockpit/statisticsEvents/StatisticsEventsController.java | 27 ++++++++++---
ycl-platform/src/main/java/com/ycl/mapper/apidata/ApiDataMapper.java | 9 ++++
ycl-platform/src/main/resources/mapper/apidata/ApiDataMapper.xml | 21 ++++++++++
5 files changed, 82 insertions(+), 7 deletions(-)
diff --git a/ycl-platform/src/main/java/com/ycl/controller/cockpit/statisticsEvents/StatisticsEventsController.java b/ycl-platform/src/main/java/com/ycl/controller/cockpit/statisticsEvents/StatisticsEventsController.java
index e8bf477..4f247dc 100644
--- a/ycl-platform/src/main/java/com/ycl/controller/cockpit/statisticsEvents/StatisticsEventsController.java
+++ b/ycl-platform/src/main/java/com/ycl/controller/cockpit/statisticsEvents/StatisticsEventsController.java
@@ -6,6 +6,7 @@
import com.ycl.api.CommonResult;
import com.ycl.entity.cockpitManage.TeamConstruction;
import com.ycl.entity.cockpitManage.TeamIndex;
+import com.ycl.service.apidata.IApiDataService;
import com.ycl.service.cockpitManage.ITeamConstructionService;
import com.ycl.service.equipment.IOrgGridService;
import com.ycl.service.video.impl.IVideoPointService;
@@ -45,6 +46,14 @@
private ITeamConstructionService teamConstructionService;
private IOrgGridService orgGridService;
+
+
+ private IApiDataService iApiDataService;
+
+ @Autowired
+ public void setIApiDataService(IApiDataService apiDataService){
+ this.iApiDataService = apiDataService;
+ }
@Autowired
public void setTeamConstructionService(ITeamConstructionService teamConstructionService) {
@@ -147,13 +156,17 @@
@ApiOperation(value = "top10")
@GetMapping("/top10")
public CommonResult<List<StatisticsEventsVO.Top10VO>> top10(@Validated CockpitVO params) {
- checkApiUtil.cockpit(params);
- List<StatisticsEventsVO.Top10VO> ls = new ArrayList<>();
- ls.add(new StatisticsEventsVO.Top10VO("xx涓槦", 100.0));
- ls.add(new StatisticsEventsVO.Top10VO("xx涓槦", 90.0));
- ls.add(new StatisticsEventsVO.Top10VO("xx涓槦", 80.0));
- ls.add(new StatisticsEventsVO.Top10VO("xx涓槦", 70.0));
- return CommonResult.success(ls);
+// checkApiUtil.cockpit(params);
+// List<StatisticsEventsVO.Top10VO> ls = new ArrayList<>();
+// ls.add(new StatisticsEventsVO.Top10VO("xx涓槦", 100.0));
+// ls.add(new StatisticsEventsVO.Top10VO("xx涓槦", 90.0));
+// ls.add(new StatisticsEventsVO.Top10VO("xx涓槦", 80.0));
+// ls.add(new StatisticsEventsVO.Top10VO("xx涓槦", 70.0));
+// return CommonResult.success(ls);
+ String beginTime = params.getBeginTime();
+ String endTime = params.getEndTime();
+ List<StatisticsEventsVO.Top10VO> res = iApiDataService.listTop10(beginTime, endTime);
+ return CommonResult.success(res);
}
diff --git a/ycl-platform/src/main/java/com/ycl/mapper/apidata/ApiDataMapper.java b/ycl-platform/src/main/java/com/ycl/mapper/apidata/ApiDataMapper.java
new file mode 100644
index 0000000..3a87ab5
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/mapper/apidata/ApiDataMapper.java
@@ -0,0 +1,9 @@
+package com.ycl.mapper.apidata;
+
+import com.ycl.vo.cockpit.statisticsEvents.StatisticsEventsVO;
+
+import java.util.List;
+
+public interface ApiDataMapper {
+ List<StatisticsEventsVO.Top10VO> listTop10(String beginTime, String endTime);
+}
diff --git a/ycl-platform/src/main/java/com/ycl/service/apidata/IApiDataService.java b/ycl-platform/src/main/java/com/ycl/service/apidata/IApiDataService.java
new file mode 100644
index 0000000..702653c
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/service/apidata/IApiDataService.java
@@ -0,0 +1,10 @@
+package com.ycl.service.apidata;
+
+import com.ycl.vo.cockpit.statisticsEvents.StatisticsEventsVO;
+
+import java.util.List;
+
+public interface IApiDataService {
+
+ List<StatisticsEventsVO.Top10VO> listTop10(String beginTime, String endTime);
+}
diff --git a/ycl-platform/src/main/java/com/ycl/service/apidata/impl/IApiDataServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/apidata/impl/IApiDataServiceImpl.java
new file mode 100644
index 0000000..3c8352b
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/service/apidata/impl/IApiDataServiceImpl.java
@@ -0,0 +1,22 @@
+package com.ycl.service.apidata.impl;
+
+import com.ycl.mapper.apidata.ApiDataMapper;
+import com.ycl.service.apidata.IApiDataService;
+import com.ycl.vo.cockpit.statisticsEvents.StatisticsEventsVO;
+import org.springframework.stereotype.Service;
+
+import javax.annotation.Resource;
+import java.util.List;
+
+@Service
+public class IApiDataServiceImpl implements IApiDataService {
+
+ @Resource
+ private ApiDataMapper apiDataMapper;
+
+ @Override
+ public List<StatisticsEventsVO.Top10VO> listTop10(String beginTime, String endTime) {
+
+ return apiDataMapper.listTop10(beginTime, endTime);
+ }
+}
diff --git a/ycl-platform/src/main/resources/mapper/apidata/ApiDataMapper.xml b/ycl-platform/src/main/resources/mapper/apidata/ApiDataMapper.xml
new file mode 100644
index 0000000..4a0853f
--- /dev/null
+++ b/ycl-platform/src/main/resources/mapper/apidata/ApiDataMapper.xml
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ycl.mapper.apidata.ApiDataMapper">
+
+
+ <select id="listTop10" resultType="com.ycl.vo.cockpit.statisticsEvents.StatisticsEventsVO$Top10VO">
+ SELECT NAME
+ ,
+ IFNULL(month_index_number,0) month_index_number
+ FROM
+ ums_team_construction
+ <where>
+ <if test="beginTime !='' and endTime !='' and beginTime!=null and endTime !=null">
+ and create_time between #{beginTime} and #{endTime}
+ </if>
+ </where>
+ ORDER BY
+ month_index_number DESC
+ LIMIT 10
+ </select>
+</mapper>
--
Gitblit v1.8.0