权限管理接口修改

whyclxw

2025-05-15 a2d386150f391eeccef9da7c6a91cfb2cf9f7a65

权限管理接口修改

 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>

 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">