From 3c79d1b62d794cda8b9976610956057f212a4706 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 27 十一月 2024 17:00:19 +0800
Subject: [PATCH] 1
---
se-modules/se-system/src/main/java/com/se/system/controller/IndexController.java | 12 ++++++++++--
se-modules/se-system/src/main/java/com/se/system/mapper/IndexMapper.java | 4 ++++
se-modules/se-system/src/main/resources/mapper/system/IndexMapper.xml | 12 ++++++++++++
se-modules/se-system/src/main/java/com/se/system/service/IndexService.java | 12 ++++++++++++
4 files changed, 38 insertions(+), 2 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 10ffcf1..2e7c02f 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
@@ -41,8 +41,12 @@
// PV鍙嶆槧浜嗙綉绔欑敤鎴疯闂殑缃戦〉鏁伴噺锛屾槸琛￠噺缃戠珯娴侀噺鐨勯噸瑕佹寚鏍囦箣涓�
@Log(title = "PV缁熻", businessType = BusinessType.OTHER)
@GetMapping("/pvCount")
- public Map<String, Object> pvCount() {
+ public Map<String, Object> pvCount(Integer day) {
+ if (null == day || day < 1) day = 15;
+ if (day > 365) day = 365;
+
Map<String, Object> map = new HashMap<>();
+ map.put("pvCount", indexService.pvCount(day));
return map;
}
@@ -52,8 +56,12 @@
// 濡傛灉鏇存崲浜咺P鍚庝絾涓嶆竻闄ookies锛屽啀璁块棶鐩稿悓缃戠珯锛岃缃戠珯鐨勭粺璁′腑UV鏁版槸涓嶅彉鐨勩��
@Log(title = "UV缁熻", businessType = BusinessType.OTHER)
@GetMapping("/uvCount")
- public Map<String, Object> uvCount() {
+ public Map<String, Object> uvCount(Integer day) {
+ if (null == day || day < 1) day = 15;
+ if (day > 365) day = 365;
+
Map<String, Object> map = new HashMap<>();
+ map.put("uvCount", indexService.uvCount(day));
return map;
}
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 e34f5fb..71af4b3 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
@@ -16,4 +16,8 @@
//@MapKey("username")
public List<Map<String, Object>> userCountList(@Param("createTime") String createTime, @Param("amount") Integer amount);
+
+ public int uvCount(@Param("createTime") String createTime);
+
+ public int pvCount(String createTime);
}
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 6a94801..6582b8f 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
@@ -35,4 +35,16 @@
return indexMapper.userCountList(createTime, amount);
}
+
+ public int uvCount(int day) {
+ String createTime = getCreateTime(day);
+
+ return indexMapper.uvCount(createTime);
+ }
+
+ public Object pvCount(Integer day) {
+ String createTime = getCreateTime(day);
+
+ return indexMapper.pvCount(createTime);
+ }
}
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 6ca5ab5..afaa134 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
@@ -15,4 +15,16 @@
order by count desc
limit ${amount};
</select>
+
+ <select id="uvCount" resultType="java.lang.Integer">
+ select count(distinct user_name, ipaddr, date_format(access_time, '%Y%m%d')) count
+ from sys_logininfor
+ where access_time >= #{createTime};
+ </select>
+
+ <select id="pvCount" resultType="java.lang.Integer">
+ select count(*)
+ from sys_oper_log
+ where oper_url = '/index/addAccessLog' and oper_time >= #{createTime};
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3