From 556de16f65ae7b776fbf77e48bfcfa8523c1aff3 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 27 十一月 2024 17:20:31 +0800
Subject: [PATCH] 1
---
se-modules/se-system/src/main/java/com/se/system/controller/IndexController.java | 11 +++++++----
se-modules/se-system/src/main/java/com/se/system/mapper/IndexMapper.java | 10 ++++++----
se-modules/se-system/src/main/resources/mapper/system/IndexMapper.xml | 9 +++++++++
se-modules/se-system/src/main/java/com/se/system/service/IndexService.java | 6 ++++++
4 files changed, 28 insertions(+), 8 deletions(-)
diff --git a/se-modules/se-system/src/main/java/com/se/system/controller/IndexController.java b/se-modules/se-system/src/main/java/com/se/system/controller/IndexController.java
index 2e7c02f..723e298 100644
--- a/se-modules/se-system/src/main/java/com/se/system/controller/IndexController.java
+++ b/se-modules/se-system/src/main/java/com/se/system/controller/IndexController.java
@@ -103,12 +103,15 @@
// 鈶ュ父鐢ㄧ郴缁熷睍绀�/鍚勭郴缁熻闂俊鎭細鍩轰簬鐢ㄦ埛璁块棶娆℃暟鎺掑悕锛屽睍绀哄墠浜斾釜绯荤粺鐨勬帓鍚�
// 骞跺睍绀哄悇涓郴缁熶竴澶╁唴銆佷笁澶╁唴銆佷竴鍛ㄥ唴鐨勮闂鏁般�傘�愬彲鑰冭檻鎸夊叾浠栨寚鏍囪繘琛屾帓鍚嶅睍绀恒��
- @Log(title = "鐢ㄦ埛缁熻鎺掕", businessType = BusinessType.OTHER)
+ @Log(title = "甯哥敤绯荤粺灞曠ず", businessType = BusinessType.OTHER)
@GetMapping("/sysVisitList")
- public Map<String, Object> sysVisitList() {
- Map<String, Object> map = new HashMap<>();
+ public List<Map<String, Object>> sysVisitList(Integer day, Integer amount) {
+ if (null == day || day < 1) day = 15;
+ if (day > 365) day = 365;
+ if (null == amount) amount = 5;
+ if (amount > 100) amount = 100;
- return map;
+ return indexService.sysVisitList(day, amount);
}
@Log(title = "杩愮淮鐩戞帶", businessType = BusinessType.OTHER)
diff --git a/se-modules/se-system/src/main/java/com/se/system/mapper/IndexMapper.java b/se-modules/se-system/src/main/java/com/se/system/mapper/IndexMapper.java
index 71af4b3..31913e0 100644
--- a/se-modules/se-system/src/main/java/com/se/system/mapper/IndexMapper.java
+++ b/se-modules/se-system/src/main/java/com/se/system/mapper/IndexMapper.java
@@ -12,12 +12,14 @@
@Repository
@SuppressWarnings("ALL")
public interface IndexMapper {
- public int newUserCount(@Param("createTime") String createTime);
+ int newUserCount(@Param("createTime") String createTime);
//@MapKey("username")
- public List<Map<String, Object>> userCountList(@Param("createTime") String createTime, @Param("amount") Integer amount);
+ List<Map<String, Object>> userCountList(@Param("createTime") String createTime, @Param("amount") Integer amount);
- public int uvCount(@Param("createTime") String createTime);
+ int uvCount(@Param("createTime") String createTime);
- public int pvCount(String createTime);
+ int pvCount(@Param("createTime") String createTime);
+
+ List<Map<String, Object>> sysVisitList(@Param("createTime") String createTime, @Param("amount") Integer amount);
}
diff --git a/se-modules/se-system/src/main/java/com/se/system/service/IndexService.java b/se-modules/se-system/src/main/java/com/se/system/service/IndexService.java
index 6582b8f..a303562 100644
--- a/se-modules/se-system/src/main/java/com/se/system/service/IndexService.java
+++ b/se-modules/se-system/src/main/java/com/se/system/service/IndexService.java
@@ -47,4 +47,10 @@
return indexMapper.pvCount(createTime);
}
+
+ public List<Map<String, Object>> sysVisitList(Integer day, Integer amount) {
+ String createTime = getCreateTime(day);
+
+ return indexMapper.sysVisitList(createTime, amount);
+ }
}
diff --git a/se-modules/se-system/src/main/resources/mapper/system/IndexMapper.xml b/se-modules/se-system/src/main/resources/mapper/system/IndexMapper.xml
index afaa134..acecf2a 100644
--- a/se-modules/se-system/src/main/resources/mapper/system/IndexMapper.xml
+++ b/se-modules/se-system/src/main/resources/mapper/system/IndexMapper.xml
@@ -27,4 +27,13 @@
from sys_oper_log
where oper_url = '/index/addAccessLog' and oper_time >= #{createTime};
</select>
+
+ <select id="sysVisitList" resultType="java.util.Map">
+ select title, count(*) count
+ from sys_oper_log
+ where oper_time >= #{createTime} and (title like '%骞冲彴' or title like '%鍒嗙郴缁�' or title like '%鐮旇鍘�' or title = '瑁呭搴�')
+ group by title
+ order by count desc
+ limit ${amount};
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3