From a2d386150f391eeccef9da7c6a91cfb2cf9f7a65 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期四, 15 五月 2025 13:58:05 +0800
Subject: [PATCH] 权限管理接口修改
---
src/main/resources/mapper/PermitGroupUserMapper.xml | 2 +-
src/main/resources/mapper/UserMapper.xml | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/resources/mapper/PermitGroupUserMapper.xml b/src/main/resources/mapper/PermitGroupUserMapper.xml
index c08f1ea..210cb94 100644
--- a/src/main/resources/mapper/PermitGroupUserMapper.xml
+++ b/src/main/resources/mapper/PermitGroupUserMapper.xml
@@ -11,7 +11,7 @@
and tb_user_permitgroup.permit_item_value=1
</select>
<select id="getUserInf" resultType="com.whyc.pojo.UserInf">
- select u.* from db_user.tb_user_permitgroup_data d,db_user.tb_user_inf u
+ select DISTINCT u.uid,u.uname from db_user.tb_user_permitgroup_data d,db_user.tb_user_inf u
where u.uId = d.uId
and d.permit_group_id = #{permitGroupId}
</select>
diff --git a/src/main/resources/mapper/UserMapper.xml b/src/main/resources/mapper/UserMapper.xml
index c4dd597..0918be1 100644
--- a/src/main/resources/mapper/UserMapper.xml
+++ b/src/main/resources/mapper/UserMapper.xml
@@ -17,7 +17,7 @@
select * from db_user.tb_user_inf where uMobilephone =#{phoneNumber} limit 1
</select>
<select id="searchCS_All2" resultType="com.whyc.pojo.UserInf">
- SELECT uId,uName FROM db_user.tb_user_inf where uId not in (select distinct uId from db_user.tb_user_permitgroup_data) and uId!=0
+ SELECT distinct uId,uName FROM db_user.tb_user_inf where uId not in (select distinct uId from db_user.tb_user_permitgroup_data) and uId!=0
order by uId
</select>
<select id="getUserInfoByStationId" resultType="com.whyc.pojo.UserInf">
--
Gitblit v1.9.1