权限管理下增删改

lxw

2022-09-01 03ff8a0aef0fa4f44edbe61cfe4cf86c3cecb61b

权限管理下增删改

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

@@ -1,17 +1,19 @@
package com.whyc.controller;

import com.whyc.dto.Response;
import com.whyc.pojo.DocUser;
import com.whyc.pojo.PermitGroup;
import com.whyc.pojo.UserGroup;
import com.whyc.service.CategoryService;
import com.whyc.service.GroupService;
import com.whyc.service.PermitGroupService;
import com.whyc.service.PermitService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.bouncycastle.asn1.ocsp.ResponderID;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@Api(tags = "权限管理")
@RequestMapping("permitGroup")
@@ -40,4 +42,44 @@
    public Response getAllGroup(){
        return  groupService.getAllGroup();
    }

    @ApiOperation(value = "添加权限组")
    @GetMapping("addGroup")
    public Response addGroup(@RequestParam String groupName){
        return  groupService.addGroup(groupName);
    }

    @ApiOperation(value = "删除权限组")
    @GetMapping("delGroup")
    public Response delGroup(@RequestParam String groupId){
        return  groupService.delGroup(groupId);
    }

    @ApiOperation(value = "编辑权限组名")
    @GetMapping("updateGroup")
    public Response updateGroup(@RequestParam String groupId,@RequestParam String groupName){
        return  groupService.updateGroup(groupId,groupName);
    }

    @ApiOperation(value = "权限组下加用户")
    @PostMapping("addUserToGroup")
    public Response addUserToGroup(@RequestBody List<UserGroup> users){
        return  groupService.addUserToGroup(users);
    }
    @ApiOperation(value = "权限组下移除用户")
    @PostMapping("delUserToGroup")
    public Response delUserToGroup(@RequestBody List<UserGroup> users){
        return  groupService.delUserToGroup(users);
    }

    @ApiOperation(value = "权限组下加权限")
    @PostMapping("addPermitToGroup")
    public Response addPermitToGroup(@RequestBody List<PermitGroup> permits){
        return  groupService.addPermitToGroup(permits);
    }
    @ApiOperation(value = "权限组下移除权限")
    @PostMapping("delPermitToGroup")
    public Response delPermitToGroup(@RequestBody List<PermitGroup> permits){
        return  groupService.delPermitToGroup(permits);
    }
}

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

@@ -7,4 +7,6 @@
public interface GroupMapper extends CustomMapper<Group>{
    //查询所有的权限组
    List getAllGroup();
    //查询最大的权限组id
    int selectGroupIdMax();
}

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

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

import com.whyc.pojo.UserGroup;

public interface UserGroupMapper extends CustomMapper<UserGroup>{
}

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

@@ -1,10 +1,18 @@
package com.whyc.service;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.whyc.dto.Response;
import com.whyc.mapper.GroupMapper;
import com.whyc.mapper.PermitGroupMapper;
import com.whyc.mapper.UserGroupMapper;
import com.whyc.pojo.Group;
import com.whyc.pojo.PermitGroup;
import com.whyc.pojo.UserGroup;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@@ -13,9 +21,84 @@
    @Autowired(required = false)
    private GroupMapper mapper;

    @Autowired(required = false)
    private PermitGroupMapper permitGroupMapper;

    @Autowired(required = false)
    private UserGroupMapper userGroupMapper;

    //查询所有的权限组
    public Response getAllGroup() {
        List list=mapper.getAllGroup();
        return  new Response().setII(1,list.size()>0?true:false,list,"权限组信息");
    }
    //添加权限组
    public Response addGroup(String groupName) {
        //查询最大的权限组id
        int groupIdMax=mapper.selectGroupIdMax();
        Group group=new Group();
        group.setGroupId(String.valueOf(groupIdMax+1));
        group.setGroupName(groupName);
        int flag=mapper.insert(group);
        return new Response().set(1,flag>0?true:false,"返回");
    }
    //删除权限组
    @Transactional
    public Response delGroup(String groupId) {
        UpdateWrapper wrapper=new UpdateWrapper();
        wrapper.eq("group_id",groupId);
        //删除权限组要先删除权限组管理的权限
        int flagP=permitGroupMapper.delete(wrapper);
        //删除权限组要先删除权限组管理的ren
        int flagU=userGroupMapper.delete(wrapper);
        //删除权限组
        int flag=mapper.delete(wrapper);
        return new Response().set(1,flag>0?true:false,"返回");
    }
    //编辑权限组名
    public Response updateGroup(String groupId,String groupName) {
        UpdateWrapper wrapper=new UpdateWrapper();
        wrapper.eq("group_id",groupId);
        wrapper.set("group_name",groupName);
        int flag=mapper.update(null,wrapper);
        return new Response().set(1,flag>0?true:false,"返回");
    }
    //权限组下加用户
    @Transactional
    public Response addUserToGroup(List<UserGroup> users) {
        int flag=userGroupMapper.insertBatchSomeColumn(users);
        return new Response().set(1,flag>0?true:false,"返回");
    }
    //权限组下移除用户
    @Transactional
    public Response delUserToGroup(List<UserGroup> users) {
        UpdateWrapper wrapper=new UpdateWrapper();
        int flag=0;
        for (UserGroup userGroup: users) {
            wrapper.eq("uid",userGroup.getUid());
            wrapper.eq("uname",userGroup.getUname());
            wrapper.eq("group_id",userGroup.getGroupId());
            flag=userGroupMapper.delete(wrapper);
        }
        return new Response().set(1,flag>0?true:false,"返回");
    }
    //权限组下加权限
    @Transactional
    public Response addPermitToGroup(List<PermitGroup> permits) {
        int flag=permitGroupMapper.insertBatchSomeColumn(permits);
        return new Response().set(1,flag>0?true:false,"返回");
    }
    //权限组下移除用户
    @Transactional
    public Response delPermitToGroup(List<PermitGroup> permits) {
        UpdateWrapper wrapper=new UpdateWrapper();
        int flag=0;
        for (PermitGroup permitGroup: permits) {
            wrapper.eq("permit_id",permitGroup.getPermitId());
            wrapper.eq("categoty_id",permitGroup.getCategoryId());
            wrapper.eq("group_id",permitGroup.getGroupId());
            flag=userGroupMapper.delete(wrapper);
        }
        return new Response().set(1,flag>0?true:false,"返回");
    }
}

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

New file
@@ -0,0 +1,7 @@
package com.whyc.service;

import org.springframework.stereotype.Service;

@Service
public class UserGroupService {
}

 src/main/resources/mapper/GroupMapper.xml

@@ -30,4 +30,9 @@
          and tb_user_group.uname=tb_doc_user.name
          and group_id=#{groupId}
    </select>


    <select id="selectGroupIdMax" resultType="java.lang.Integer">
        select max(group_id) as groupIdMax from db_doc.tb_group
    </select>
</mapper>