From f3764df3401423004c2877e0f37169890ed67e9d Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Tue, 20 Jul 2021 10:32:04 +0800
Subject: [PATCH] 用户注册数量统计
---
src/main/java/org/springblade/modules/system/mapper/UserMapper.xml | 16 ++++++++
src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java | 10 ++++
src/main/java/org/springblade/modules/system/controller/UserController.java | 9 ++++
src/main/java/org/springblade/modules/system/mapper/UserMapper.java | 7 +++
src/main/java/org/springblade/modules/system/service/IUserService.java | 6 +++
src/main/java/org/springblade/modules/system/vo/UserRegisterStatisVO.java | 14 +++++++
6 files changed, 61 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/system/controller/UserController.java b/src/main/java/org/springblade/modules/system/controller/UserController.java
index 9dbe2b7..a6faf6f 100644
--- a/src/main/java/org/springblade/modules/system/controller/UserController.java
+++ b/src/main/java/org/springblade/modules/system/controller/UserController.java
@@ -443,6 +443,15 @@
return R.data(userService.selectUser());
}
+ /**
+ * 统计用户注册数据
+ * @return
+ */
+ @GetMapping("/getUserRegisterStatisticsData")
+ public R getUserRegisterStatisticsData(){
+ return R.data(userService.getUserRegisterStatisticsData());
+ }
+
}
diff --git a/src/main/java/org/springblade/modules/system/mapper/UserMapper.java b/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
index 59af447..a551b51 100644
--- a/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
+++ b/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
@@ -22,6 +22,7 @@
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.system.excel.UserExcel;
import org.springblade.modules.system.entity.User;
+import org.springblade.modules.system.vo.UserRegisterStatisVO;
import org.springblade.modules.system.vo.UsersVo;
import java.util.List;
@@ -96,4 +97,10 @@
*/
List<UsersVo> selectSecurityUserPageList(IPage<UsersVo> page, User user);
List<Map<String, Object>> selectUser();
+
+ /**
+ * 统计用户注册数据
+ * @return
+ */
+ List<UserRegisterStatisVO> getUserRegisterStatisticsData();
}
diff --git a/src/main/java/org/springblade/modules/system/mapper/UserMapper.xml b/src/main/java/org/springblade/modules/system/mapper/UserMapper.xml
index 3e2e833..9f4dbea 100644
--- a/src/main/java/org/springblade/modules/system/mapper/UserMapper.xml
+++ b/src/main/java/org/springblade/modules/system/mapper/UserMapper.xml
@@ -94,6 +94,8 @@
</if>
ORDER BY id
</select>
+
+
<select id="selectUserPages" resultMap="userResultMaps">
select s.*,p.jd,p.wd,ST_ASTEXT ( e.coordinate ) from blade_user s
LEFT JOIN sys_position p ON p.snumber = s.CODE
@@ -231,4 +233,18 @@
<select id="selectUser" resultType="java.util.HashMap">
select CAST(id AS CHAR) as groupmember,real_name as rname from blade_user
</select>
+
+ <!--统计用户注册数据-->
+ <select id="getUserRegisterStatisticsData" resultType="org.springblade.modules.system.vo.UserRegisterStatisVO">
+ SELECT
+ br.name as region,
+ count(*) num
+ FROM blade_user bu
+ left join
+ blade_region br
+ on
+ bu.region_id = br.code
+ where bu.region_id is not null
+ group by bu.region_id
+ </select>
</mapper>
diff --git a/src/main/java/org/springblade/modules/system/service/IUserService.java b/src/main/java/org/springblade/modules/system/service/IUserService.java
index 01d8292..aa7458e 100644
--- a/src/main/java/org/springblade/modules/system/service/IUserService.java
+++ b/src/main/java/org/springblade/modules/system/service/IUserService.java
@@ -28,6 +28,7 @@
import org.springblade.modules.system.entity.UserInfo;
import org.springblade.modules.system.entity.UserOauth;
import org.springblade.modules.system.excel.UserExcel;
+import org.springblade.modules.system.vo.UserRegisterStatisVO;
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.system.vo.UsersVo;
@@ -256,4 +257,9 @@
R<Boolean> saveUser(User user);
List<Map<String, Object>> selectUser();
+ /**
+ * 统计用户注册数据
+ * @return
+ */
+ List<UserRegisterStatisVO> getUserRegisterStatisticsData();
}
diff --git a/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java b/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java
index d653e66..8932a45 100644
--- a/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java
+++ b/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java
@@ -49,6 +49,7 @@
import org.springblade.modules.system.service.IUserDeptService;
import org.springblade.modules.system.service.IUserOauthService;
import org.springblade.modules.system.service.IUserService;
+import org.springblade.modules.system.vo.UserRegisterStatisVO;
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.system.vo.UsersVo;
import org.springblade.modules.system.wrapper.UserWrapper;
@@ -486,5 +487,12 @@
return baseMapper.selectUser();
}
-
+ /**
+ * 统计用户注册数据
+ * @return
+ */
+ @Override
+ public List<UserRegisterStatisVO> getUserRegisterStatisticsData() {
+ return baseMapper.getUserRegisterStatisticsData();
+ }
}
diff --git a/src/main/java/org/springblade/modules/system/vo/UserRegisterStatisVO.java b/src/main/java/org/springblade/modules/system/vo/UserRegisterStatisVO.java
new file mode 100644
index 0000000..d2667c0
--- /dev/null
+++ b/src/main/java/org/springblade/modules/system/vo/UserRegisterStatisVO.java
@@ -0,0 +1,14 @@
+package org.springblade.modules.system.vo;
+
+import lombok.Data;
+
+import java.io.Serializable;
+
+@Data
+public class UserRegisterStatisVO implements Serializable {
+
+ private String region;
+
+
+ private Integer num;
+}
--
Gitblit v1.9.3