From 365b87f3e8fe3773955e84dcd9ea4224e8f92c06 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 27 十二月 2022 10:35:52 +0800
Subject: [PATCH] 12.27
---
src/main/java/com/lf/server/service/sys/UserService.java | 5 +++++
data/ts.sql | 8 +++++---
src/main/java/com/lf/server/controller/sys/UserController.java | 20 ++++++++++++++++++++
src/main/java/com/lf/server/mapper/sys/UserMapper.java | 8 ++++++++
src/main/resources/mapper/sys/UserMapper.xml | 6 ++++++
data/集成用户所需接口.docx | 0
6 files changed, 44 insertions(+), 3 deletions(-)
diff --git a/data/ts.sql b/data/ts.sql
index 722179e..f06fef8 100644
--- a/data/ts.sql
+++ b/data/ts.sql
@@ -88,12 +88,14 @@
select * from lf.sys_user
select * from lf.sys_role_user
select * from lf.sys_role
+
select c.*, fn_rec_query(c.depid, 'dep') depName,fn_uname(c.create_user) createName,fn_uname(c.update_user) updateName
-from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid
-inner join lf.sys_role c on b.roleid = c.id
+from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid inner join lf.sys_role c on b.roleid = c.id
where a.id = 1;
-
+select a.*, fn_rec_query(a.depid, 'dep') depName,fn_uname(a.create_user) createName,fn_uname(a.update_user) updateName
+from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid inner join lf.sys_role c on b.roleid = c.id
+where c.id = 15
diff --git "a/data/\351\233\206\346\210\220\347\224\250\346\210\267\346\211\200\351\234\200\346\216\245\345\217\243.docx" "b/data/\351\233\206\346\210\220\347\224\250\346\210\267\346\211\200\351\234\200\346\216\245\345\217\243.docx"
index 81b9728..764de3d 100644
--- "a/data/\351\233\206\346\210\220\347\224\250\346\210\267\346\211\200\351\234\200\346\216\245\345\217\243.docx"
+++ "b/data/\351\233\206\346\210\220\347\224\250\346\210\267\346\211\200\351\234\200\346\216\245\345\217\243.docx"
Binary files differ
diff --git a/src/main/java/com/lf/server/controller/sys/UserController.java b/src/main/java/com/lf/server/controller/sys/UserController.java
index 4d29710..fadba3a 100644
--- a/src/main/java/com/lf/server/controller/sys/UserController.java
+++ b/src/main/java/com/lf/server/controller/sys/UserController.java
@@ -254,6 +254,26 @@
}
@SysLog()
+ @ApiOperation(value = "鏍规嵁瑙掕壊鏌ヨ鐢ㄦ埛")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "id", value = "瑙掕壊ID", dataType = "Integer", paramType = "query", example = "1")
+ })
+ @GetMapping(value = "/selectUserByRoleId")
+ public ResponseMsg<Object> selectUserByRoleId(Integer id) {
+ try {
+ if (null == id || id < 1) {
+ return fail("鐢ㄦ埛ID涓嶈兘涓虹┖鎴栧皬浜�1", false);
+ }
+
+ List<UserEntity> rs = userService.selectUserByRoleId(id);
+
+ return success(rs);
+ } catch (Exception ex) {
+ return fail(ex.getMessage(), false);
+ }
+ }
+
+ @SysLog()
@ApiOperation(value = "鎻掑叆涓�鏉�")
@ApiImplicitParams({
@ApiImplicitParam(name = "entity", value = "瀹炰綋绫�", dataType = "com.lf.server.entity.data.UserEntity", paramType = "body", example = "")
diff --git a/src/main/java/com/lf/server/mapper/sys/UserMapper.java b/src/main/java/com/lf/server/mapper/sys/UserMapper.java
index 997794e..649cdba 100644
--- a/src/main/java/com/lf/server/mapper/sys/UserMapper.java
+++ b/src/main/java/com/lf/server/mapper/sys/UserMapper.java
@@ -66,6 +66,14 @@
public List<RoleEntity> selectRoleByUserId(Integer id);
/**
+ * 鏍规嵁瑙掕壊鏌ヨ鐢ㄦ埛
+ *
+ * @param roleId 瑙掕壊ID
+ * @return 鐢ㄦ埛闆嗗悎
+ */
+ public List<UserEntity> selectUserByRoleId(Integer roleId);
+
+ /**
* 鎻掑叆涓�鏉�
*
* @param userEntity
diff --git a/src/main/java/com/lf/server/service/sys/UserService.java b/src/main/java/com/lf/server/service/sys/UserService.java
index 769a205..7603f23 100644
--- a/src/main/java/com/lf/server/service/sys/UserService.java
+++ b/src/main/java/com/lf/server/service/sys/UserService.java
@@ -87,6 +87,11 @@
}
@Override
+ public List<UserEntity> selectUserByRoleId(Integer roleId) {
+ return userMapper.selectUserByRoleId(roleId);
+ }
+
+ @Override
public Integer insertUser(UserEntity userEntity) {
return userMapper.insertUser(userEntity);
}
diff --git a/src/main/resources/mapper/sys/UserMapper.xml b/src/main/resources/mapper/sys/UserMapper.xml
index d29a50d..30c48d6 100644
--- a/src/main/resources/mapper/sys/UserMapper.xml
+++ b/src/main/resources/mapper/sys/UserMapper.xml
@@ -104,6 +104,12 @@
where a.id = #{id}
</select>
+ <select id="selectUserByRoleId" resultType="com.lf.server.entity.sys.RoleEntity">
+ select a.*, fn_rec_query(a.depid, 'dep') depName
+ from lf.sys_user a inner join lf.sys_role_user b on a.id = b.userid inner join lf.sys_role c on b.roleid = c.id
+ where c.id = #{roleId}
+ </select>
+
<insert id="insertUser" parameterType="com.lf.server.entity.sys.UserEntity">
insert into lf.sys_user
(depid,uid,uname,salt,sex,native,contact,job,email,addr,edu,idcard,status,create_user,create_time,bak)
--
Gitblit v1.9.3