From eba0a4b0af4301a047ad679fa6e0b09156a90712 Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期日, 26 二月 2023 13:30:51 +0800
Subject: [PATCH] 20230226@xingjs@提交官网一张图相关内容接口(新增服务大类统计、数据服务类型统计、登录用户次数统计)
---
src/main/java/com/lf/server/controller/show/OneMapController.java | 12 ++++++++++++
src/main/java/com/lf/server/mapper/show/OneMapMapper.java | 7 +++++++
src/main/java/com/lf/server/service/show/OneMapService.java | 10 ++++++++++
src/main/resources/mapper/show/OneMapMapper.xml | 5 +++++
4 files changed, 34 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/lf/server/controller/show/OneMapController.java b/src/main/java/com/lf/server/controller/show/OneMapController.java
index 8c23851..09507c2 100644
--- a/src/main/java/com/lf/server/controller/show/OneMapController.java
+++ b/src/main/java/com/lf/server/controller/show/OneMapController.java
@@ -125,6 +125,18 @@
return success(resList);
}
+ /**
+ * 鐧诲綍娆℃暟缁熻
+ * Number of logins
+ * */
+ @SysLog()
+ @ApiOperation(value = "鐧诲綍娆℃暟缁熻")
+ @GetMapping("/countLoginNumber")
+ public ResponseMsg<Object> loginNumberStatistics() {
+ List<String> resList = aMapOfPipelineService.loginNumberStatistics();
+ return success(resList);
+ }
+
/**
* 鏁版嵁缁熻
diff --git a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
index dc8a847..6a212e4 100644
--- a/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
+++ b/src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -65,6 +65,13 @@
public List<String> statisticalDataServiceType();
/**
+ * 鐧诲綍浜烘暟缁熻
+ *
+ * @return {@link List}<{@link String}>
+ */
+ public List<String> loginNumberStatistics();
+
+ /**
* 鏂囦欢鏍煎紡conut
*
* @return {@link List}<{@link String}>
diff --git a/src/main/java/com/lf/server/service/show/OneMapService.java b/src/main/java/com/lf/server/service/show/OneMapService.java
index c099f85..eff91aa 100644
--- a/src/main/java/com/lf/server/service/show/OneMapService.java
+++ b/src/main/java/com/lf/server/service/show/OneMapService.java
@@ -103,6 +103,16 @@
}
/**
+ * 鐧诲綍浜烘暟缁熻
+ *
+ * @return {@link List}<{@link String}>
+ */
+ @Override
+ public List<String> loginNumberStatistics() {
+ return aMapOfPipelineMapper.loginNumberStatistics();
+ }
+
+ /**
* 鏂囦欢鏍煎紡conut
*
* @return {@link List}<{@link String}>
diff --git a/src/main/resources/mapper/show/OneMapMapper.xml b/src/main/resources/mapper/show/OneMapMapper.xml
index 3199f94..2077dc5 100644
--- a/src/main/resources/mapper/show/OneMapMapper.xml
+++ b/src/main/resources/mapper/show/OneMapMapper.xml
@@ -68,6 +68,11 @@
SELECT COUNT(*),TYPE FROM lf.sys_serve_log GROUP BY TYPE;
</select>
+ <!-- 鐧诲綍娆℃暟缁熻 -->
+ <select id="loginNumberStatistics" resultType="java.util.Map">
+ select b.uname, count(*) from lf.sys_login a inner join lf.sys_user b on a.userid = b.id group by uname;
+ </select>
+
<!-- 鏁版嵁缁熻 鏂囦欢鏍煎紡缁村害-鏂囦欢涓暟 select type,count(*),count(sizes) from lf.sys_meta group by type; -->
<select id="fileFormatCount" resultType="java.util.Map">
select type,count(type) AS number,sum(sizes) AS capacity from lf.sys_meta group by type;
--
Gitblit v1.9.3