权限管理

whyclxw

2025-05-12 582ec8acdafaacb5bb9ef3e32aa71d15b51c99ae

权限管理

 src/main/java/com/whyc/mapper/PermitGroupUserMapper.java

New file
@@ -0,0 +1,19 @@
package com.whyc.mapper;



import com.whyc.pojo.db_user.Permitgroup;
import com.whyc.pojo.db_user.PermitgroupUsr;
import com.whyc.pojo.db_user.User;

import java.util.List;

public interface PermitGroupUserMapper extends CustomMapper<PermitgroupUsr> {
    List<Permitgroup> getPermitByUser(Integer userId);

    List<User> getUserInf(Integer permitGroupId);

    List<String> getItemList(Integer uid);
    //内置用户包含所有得权限
    List<Permitgroup> getAllPermitList();
}

 src/main/java/com/whyc/pojo/db_user/PermitgroupUsr.java

File was renamed from src/main/java/com/whyc/pojo/db_user/PermitgroupData.java
@@ -21,9 +21,9 @@
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(schema = "db_user",value = "tb_permitgroup_data")
@TableName(schema = "db_user",value = "tb_permitgroup_usr")
@ApiModel(value="PermitgroupData对象", description="")
public class PermitgroupData implements Serializable {
public class PermitgroupUsr implements Serializable {

    private static final long serialVersionUID = 1L;


 src/main/resources/mapper/BaojigroupUsrMapper.xml

@@ -4,17 +4,17 @@

    <delete id="deleteUserList">
        <foreach collection="list" item="item" separator=";" >
            delete from plus_user.tb_baojigroup_usr where baoji_id = #{item.baojiId} and uid = #{item.uid}
            delete from db_user.tb_baojigroup_usr where baoji_id = #{item.baojiId} and uid = #{item.uid}
        </foreach>
    </delete>
    <select id="getALlUsrByBjId" resultType="com.whyc.pojo.plus_user.BaojigroupUsr">
    <select id="getALlUsrByBjId" resultType="com.whyc.pojo.db_user.BaojigroupUsr">
        select tb_baojigroup_usr.*,tb_user_inf.uname
        from plus_user.tb_baojigroup_usr,plus_user.tb_user_inf
        from db_user.tb_baojigroup_usr,db_user.tb_user_inf
        where tb_baojigroup_usr.uid=tb_user_inf.uid
        and   baoji_id = #{id}
    </select>
    <select id="getUserList" resultType="com.whyc.pojo.plus_user.UserInf">
        select u.uid,u.uname from plus_user.tb_baojigroup_usr bu,plus_user.tb_user_inf u
    <select id="getUserList" resultType="com.whyc.pojo.db_user.User">
        select u.uid,u.uname from db_user.tb_baojigroup_usr bu,db_user.tb_user_inf u
        where bu.uid = u.uid
          and bu.baoji_id = #{id}
          and u.uid>100

 src/main/resources/mapper/PermitGroupUserMapper.xml

@@ -3,32 +3,32 @@
<mapper namespace="com.whyc.mapper.PermitGroupUserMapper" >


    <select id="getPermitByUser" resultType="com.whyc.pojo.plus_user.PermitGroup">
        select distinct tb_user_permitgroup.num,permit_group_name,tb_user_permitgroup.permit_group_id,permit_item_name,permit_item_value
        from plus_user.tb_user_permitgroup,plus_user.tb_user_permitgroup_data
        where tb_user_permitgroup.permit_group_id=tb_user_permitgroup_data.permit_group_id
        and tb_user_permitgroup_data.uid=#{userId}
        and tb_user_permitgroup.permit_item_value=1
    <select id="getPermitByUser" resultType="com.whyc.pojo.db_user.Permitgroup">
        select distinct tb_permitgroup.num,permit_group_name,tb_permitgroup.permit_group_id,permit_item_name,permit_item_value
        from db_user.tb_permitgroup,db_user.tb_permitgroup_usr
        where tb_permitgroup.permit_group_id=tb_permitgroup_usr.permit_group_id
        and tb_permitgroup_usr.uid=#{userId}
        and tb_permitgroup.permit_item_value=1
    </select>
    <select id="getUserInf" resultType="com.whyc.pojo.plus_user.UserInf">
        select u.* from plus_user.tb_user_permitgroup_data d,plus_user.tb_user_inf u
    <select id="getUserInf" resultType="com.whyc.pojo.db_user.User">
        select u.* from db_user.tb_permitgroup_usr d,db_user.tb_user u
        where u.uid = d.uid
        and d.permit_group_id = #{permitGroupId}
    </select>
    <select id="getItemList" resultType="java.lang.String">
        select  tb_user_permitgroup.permit_item_name
        from plus_user.tb_user_permitgroup,plus_user.tb_user_permitgroup_data
        select  tb_permitgroup.permit_item_name
        from db_user.tb_permitgroup,db_user.tb_permitgroup_usr
        <where>
         tb_user_permitgroup.permit_group_id=tb_user_permitgroup_data.permit_group_id
         tb_permitgroup.permit_group_id=tb_permitgroup_usr.permit_group_id
        <if test="uid>100">
            and tb_user_permitgroup_data.uid=#{uid}
            and tb_permitgroup_usr.uid=#{uid}
        </if>
        and tb_user_permitgroup.permit_item_value=1
        and tb_permitgroup.permit_item_value=1
        </where>
    </select>
    <select id="getAllPermitList" resultType="com.whyc.pojo.plus_user.PermitGroup">
        select  distinct  tb_user_permitgroup.num,permit_group_name,tb_user_permitgroup.permit_group_id,permit_item_name,permit_item_value
        from plus_user.tb_user_permitgroup,plus_user.tb_user_permitgroup_data
        where tb_user_permitgroup.permit_group_id=tb_user_permitgroup_data.permit_group_id
    <select id="getAllPermitList" resultType="com.whyc.pojo.db_user.Permitgroup">
        select  distinct  tb_permitgroup.num,permit_group_name,tb_permitgroup.permit_group_id,permit_item_name,permit_item_value
        from db_user.tb_permitgroup,db_user.tb_permitgroup_usr
        where tb_permitgroup.permit_group_id=tb_permitgroup_usr.permit_group_id
    </select>
</mapper>