权限管理:通过权限组id查询权限组关联的权限明细,已添加的用户,未添加的用户

whycxzp

2021-11-19 127846f1551c76791cc9510f4336f2115d0ea102

权限管理:通过权限组id查询权限组关联的权限明细,已添加的用户,未添加的用户

 src/main/java/com/whyc/controller/PermitGroupController.java

@@ -10,6 +10,7 @@

import javax.annotation.Resource;
import java.util.List;
import java.util.Map;

@RestController
@RequestMapping("permitGroup")
@@ -50,7 +51,8 @@
    @GetMapping("info")
    @ApiOperation(value = "权限组-用户-权限信息查询")
    public Response getPermitGroupInfo(@RequestParam Integer permitGroupId){
        return null;
        Map resultMap = service.getPermitGroupInfo(permitGroupId);
        return new Response().set(1,resultMap);
    }

}

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

@@ -2,9 +2,13 @@

import com.whyc.pojo.PermitGroup;
import com.whyc.pojo.PermitGroupUser;
import com.whyc.pojo.UserInf;

import java.util.List;

public interface PermitGroupUserMapper extends CustomMapper<PermitGroupUser> {
    List<PermitGroup> getPermitByUser(Long userId);

    List<UserInf> getUserInf(Integer permitGroupId);

}

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

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

import com.whyc.pojo.UserInf;

public interface UserInfMapper extends CustomMapper<UserInf>{
}

 src/main/java/com/whyc/service/PermitGroupService.java

@@ -6,14 +6,20 @@
import com.whyc.mapper.CommonMapper;
import com.whyc.mapper.PermitGroupMapper;
import com.whyc.mapper.PermitGroupUserMapper;
import com.whyc.mapper.UserInfMapper;
import com.whyc.pojo.PermitGroup;
import com.whyc.pojo.PermitGroupUser;
import com.whyc.pojo.UserInf;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.RequestParam;

import javax.annotation.Resource;
import java.sql.Wrapper;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;

@Service
@Transactional
@@ -27,6 +33,9 @@

    @Resource
    private CommonMapper commonMapper;

    @Resource
    private UserInfMapper userInfMapper;

    public void add(List<PermitGroup> permitGroupList) {
        //权限组id生成
@@ -64,4 +73,22 @@
        wrapper.select("distinct permit_group_id,permit_group_name");
        return mapper.selectList(wrapper);
    }

    public Map getPermitGroupInfo(Integer permitGroupId) {
        Map<String,List> resultMap = new HashMap<>();
        //查询权限组已添加的用户
        List<UserInf> relatedUserInfList = permitGroupUserMapper.getUserInf(permitGroupId);
        //查询权限组未添加的用户
        List<UserInf> allUserInfList = userInfMapper.selectList(null);
        List<UserInf> notRelatedUserInfList = allUserInfList.stream().filter(userInf -> !relatedUserInfList.contains(userInf)).collect(Collectors.toList());
        //查询权限组的明细权限
        QueryWrapper<PermitGroup> wrapper = Wrappers.query();
        wrapper.eq("permit_group_id",permitGroupId);
        List<PermitGroup> permitGroupList = mapper.selectList(wrapper);

        resultMap.put("usersAdded",relatedUserInfList);
        resultMap.put("usersNotAdded",notRelatedUserInfList);
        resultMap.put("permits",permitGroupList);
        return resultMap;
    }
}

 src/main/resources/mapper/PermitGroupUserMapper.xml

@@ -10,4 +10,9 @@
        and tb_user_permitgroup_data.uId=#{userId}
        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
        where u.uId = d.uId
        and d.permit_group_id = #{permitGroupId}
    </select>
</mapper>