尚硅谷java项目＜云尚办公系统＞超详细(四)用户管理&菜单管理

约定不等于承诺〃 2024-04-29 19:07 75阅读 0赞

### **一、用户管理** ###

#### **1、用户管理CRUD(service-oa模块)** ####

##### 1.1、Mapper #####

package com.atguigu.auth.mapper;
    /**
     * <p>
     * 用户表 Mapper 接口
     * </p>
     *
     * @author atguigu
     * @since 2023-02-02
     */
    import com.atguigu.model.system.SysUser;
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    
    public interface SysUserMapper extends BaseMapper<SysUser> {
    
    }

##### 1.2、service接口 #####

**SysUserService接口**

package com.atguigu.system.service;
    
    
    import com.atguigu.model.system.SysUser;
    import com.atguigu.vo.system.SysUserQueryVo;
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import com.baomidou.mybatisplus.extension.service.IService;
    
    public interface SysUserService extends IService<SysUser> {
    
    }

##### 1.3、service接口实现 #####

**SysUserServiceImpl实现**

package com.atguigu.system.service.impl;
    
    import com.atguigu.model.system.SysUser;
    import com.atguigu.system.mapper.SysUserMapper;
    import com.atguigu.system.service.SysUserService;
    import com.atguigu.vo.system.SysUserQueryVo;
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    @Service
    public class SysUserServiceImpl extends ServiceImpl<SysUserMapper, SysUser> implements SysUserService {
    
    }

##### 1.4、controller #####

package com.atguigu.auth.controller;
    
    import com.atguigu.auth.service.SysUserService;
    import com.atguigu.common.result.Result;
    import com.atguigu.model.system.SysUser;
    import com.atguigu.vo.system.SysUserQueryVo;
    import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import io.swagger.annotations.ApiOperation;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.util.StringUtils;
    import org.springframework.web.bind.annotation.*;
    
    @RestController
    @RequestMapping("/admin/system/sysUser")
    public class SysUserController {
    
        @Autowired
        private SysUserService service;
    
        //用户条件分页查询
        @ApiOperation("用户条件分页查询")
        @GetMapping("{page}/{limit}")
        public Result index(@PathVariable Long page,
                            @PathVariable Long limit,
                            SysUserQueryVo sysUserQueryVo) {
            //创建page对象
            Page<SysUser> pageParam = new Page<>(page,limit);
    
            //封装条件，判断条件值不为空
            LambdaQueryWrapper<SysUser> wrapper = new LambdaQueryWrapper<>();
            //获取条件值
            String username = sysUserQueryVo.getKeyword();
            String createTimeBegin = sysUserQueryVo.getCreateTimeBegin();
            String createTimeEnd = sysUserQueryVo.getCreateTimeEnd();
            //判断条件值不为空
            //like 模糊查询
            if(!StringUtils.isEmpty(username)) {
                wrapper.like(SysUser::getUsername,username);
            }
            //ge 大于等于
            if(!StringUtils.isEmpty(createTimeBegin)) {
                wrapper.ge(SysUser::getCreateTime,createTimeBegin);
            }
            //le 小于等于
            if(!StringUtils.isEmpty(createTimeEnd)) {
                wrapper.le(SysUser::getCreateTime,createTimeEnd);
            }
    
            //调用mp的方法实现条件分页查询
            IPage<SysUser> pageModel = service.page(pageParam, wrapper);
            return Result.ok(pageModel);
        }
    
        @ApiOperation(value = "获取用户")
        @GetMapping("get/{id}")
        public Result get(@PathVariable Long id) {
            SysUser user = service.getById(id);
            return Result.ok(user);
        }
    
        @ApiOperation(value = "保存用户")
        @PostMapping("save")
        public Result save(@RequestBody SysUser user) {
            service.save(user);
            return Result.ok();
        }
    
        @ApiOperation(value = "更新用户")
        @PutMapping("update")
        public Result updateById(@RequestBody SysUser user) {
            service.updateById(user);
            return Result.ok();
        }
    
        @ApiOperation(value = "删除用户")
        @DeleteMapping("remove/{id}")
        public Result remove(@PathVariable Long id) {
            service.removeById(id);
            return Result.ok();
        }
    }

##### 1.5knife4j测试 #####

[http://localhost:8800/doc.html][http_localhost_8800_doc.html]

![2ea077c63754da4bc8d5e4bd9153efe4.png][]

#### **2.用户管理前端实现** ####

![de7c18b101339fb51078fe074a1d1f58.png][]

##### 2.1、添加路由 #####

**修改 src/router/index.js 文件**

##### 2.2、定义基础api #####

**创建文件 src/api/system/sysUser.js**

import request from '@/utils/request'
    
    const api_name = '/admin/system/sysUser'
    
    export default {
    
      getPageList(page, limit, searchObj) {
        return request({
          url: `${api_name}/${page}/${limit}`,
          method: 'get',
          params: searchObj // url查询字符串或表单键值对
        })
      },
      getById(id) {
        return request({
          url: `${api_name}/get/${id}`,
          method: 'get'
        })
      },
    
      save(role) {
        return request({
          url: `${api_name}/save`,
          method: 'post',
          data: role
        })
      },
    
      updateById(role) {
        return request({
          url: `${api_name}/update`,
          method: 'put',
          data: role
        })
      },
      removeById(id) {
        return request({
          url: `${api_name}/remove/${id}`,
          method: 'delete'
        })
      }
    }

##### 2.3、实现页面功能 #####

**创建src/views/system/sysUser/list.vue**

<template>
      <div class="app-container">
    
        <div class="search-div">
          <el-form label-width="70px" size="small">
            <el-row>
              <el-col :span="8">
                <el-form-item label="关 键 字">
                  <el-input style="width: 95%" v-model="searchObj.keyword" placeholder="用户名/姓名/手机号码"></el-input>
                </el-form-item>
              </el-col>
              <el-col :span="8">
                <el-form-item label="操作时间">
                  <el-date-picker
                    v-model="createTimes"
                    type="datetimerange"
                    range-separator="至"
                    start-placeholder="开始时间"
                    end-placeholder="结束时间"
                    value-format="yyyy-MM-dd HH:mm:ss"
                    style="margin-right: 10px;width: 100%;"
                  />
                </el-form-item>
              </el-col>
            </el-row>
            <el-row style="display:flex">
              <el-button type="primary" icon="el-icon-search" size="mini" :loading="loading" @click="fetchData()">搜索</el-button>
              <el-button icon="el-icon-refresh" size="mini" @click="resetData">重置</el-button>
            </el-row>
          </el-form>
        </div>
    
        
        <div class="tools-div">
          <el-button type="success" icon="el-icon-plus" size="mini" @click="add">添 加</el-button>
        </div>
    
        
        <el-table
          v-loading="listLoading"
          :data="list"
          stripe
          border
          style="width: 100%;margin-top: 10px;">
    
          <el-table-column
            label="序号"
            width="70"
            align="center">
            <template slot-scope="scope">
              {
        { (page - 1) * limit + scope.$index + 1 }}
            </template>
          </el-table-column>
    
          <el-table-column prop="username" label="用户名" width="100"/>
          <el-table-column prop="name" label="姓名" width="70"/>
          <el-table-column prop="phone" label="手机" width="120"/>
          <el-table-column prop="postName" label="岗位" width="100"/>
          <el-table-column prop="deptName" label="部门" width="100"/>
          <el-table-column label="所属角色" width="130">
            <template slot-scope="scope">
              <span v-for="item in scope.row.roleList" :key="item.id" style="margin-right: 10px;">{
        { item.roleName }}</span>
            </template>
          </el-table-column>
          <el-table-column label="状态" width="80">
            <template slot-scope="scope">
              <el-switch
                v-model="scope.row.status === 1"
                @change="switchStatus(scope.row)">
              </el-switch>
            </template>
          </el-table-column>
          <el-table-column prop="createTime" label="创建时间" width="160"/>
    
          <el-table-column label="操作" width="180" align="center" fixed="right">
            <template slot-scope="scope">
              <el-button type="primary" icon="el-icon-edit" size="mini" @click="edit(scope.row.id)" title="修改"/>
              <el-button type="danger" icon="el-icon-delete" size="mini" @click="removeDataById(scope.row.id)" title="删除" />
            </template>
          </el-table-column>
        </el-table>
    
        
        <el-pagination
          :current-page="page"
          :total="total"
          :page-size="limit"
          :page-sizes="[5, 10, 20, 30, 40, 50, 100]"
          style="padding: 30px 0; text-align: center;"
          layout="sizes, prev, pager, next, jumper, ->, total, slot"
          @current-change="fetchData"
          @size-change="changeSize"
        />
    
        <el-dialog title="添加/修改" :visible.sync="dialogVisible" width="40%" >
          <el-form ref="dataForm" :model="sysUser"  label-width="100px" size="small" style="padding-right: 40px;">
            <el-form-item label="用户名" prop="username">
              <el-input v-model="sysUser.username"/>
            </el-form-item>
            <el-form-item v-if="!sysUser.id" label="密码" prop="password">
              <el-input v-model="sysUser.password" type="password"/>
            </el-form-item>
            <el-form-item label="姓名" prop="name">
              <el-input v-model="sysUser.name"/>
            </el-form-item>
            <el-form-item label="手机" prop="phone">
              <el-input v-model="sysUser.phone"/>
            </el-form-item>
          </el-form>
          <span slot="footer" class="dialog-footer">
            <el-button @click="dialogVisible = false" size="small" icon="el-icon-refresh-right">取 消</el-button>
            <el-button type="primary" icon="el-icon-check" @click="saveOrUpdate()" size="small">确 定</el-button>
          </span>
        </el-dialog>
      </div>
    </template>
    
    <script>
    import api from '@/api/system/sysUser'
    const defaultForm = {
      id: '',
      username: '',
      password: '',
      name: '',
      phone: '',
      status: 1
    }
    export default {
      data() {
        return {
          listLoading: true, // 数据是否正在加载
          list: null, // banner列表
          total: 0, // 数据库中的总记录数
          page: 1, // 默认页码
          limit: 10, // 每页记录数
          searchObj: {}, // 查询表单对象
    
          createTimes: [],
    
          dialogVisible: false,
          sysUser: defaultForm,
          saveBtnDisabled: false,
        }
      },
    
      // 生命周期函数：内存准备完毕，页面尚未渲染
      created() {
        console.log('list created......')
        this.fetchData()
      },
    
      // 生命周期函数：内存准备完毕，页面渲染成功
      mounted() {
        console.log('list mounted......')
      },
    
      methods: {
        // 当页码发生改变的时候
        changeSize(size) {
          console.log(size)
          this.limit = size
          this.fetchData(1)
        },
    
        // 加载banner列表数据
        fetchData(page = 1) {
          debugger
          this.page = page
          console.log('翻页。。。' + this.page)
    
          if(this.createTimes && this.createTimes.length ==2) {
            this.searchObj.createTimeBegin = this.createTimes[0]
            this.searchObj.createTimeEnd = this.createTimes[1]
          }
    
          api.getPageList(this.page, this.limit, this.searchObj).then(
            response => {
              //this.list = response.data.list
              this.list = response.data.records
              this.total = response.data.total
    
              // 数据加载并绑定成功
              this.listLoading = false
            }
          )
        },
    
        // 重置查询表单
        resetData() {
          console.log('重置查询表单')
          this.searchObj = {}
          this.createTimes = []
          this.fetchData()
        },
    
        // 根据id删除数据
        removeDataById(id) {
          // debugger
          this.$confirm('此操作将永久删除该记录, 是否继续?', '提示', {
            confirmButtonText: '确定',
            cancelButtonText: '取消',
            type: 'warning'
          }).then(() => { // promise
            // 点击确定，远程调用ajax
            return api.removeById(id)
          }).then((response) => {
            this.fetchData(this.page)
            this.$message.success(response.message || '删除成功')
          }).catch(() => {
             this.$message.info('取消删除')
          })
        },
    
        // -------------
        add(){
          this.dialogVisible = true
          this.sysUser = Object.assign({}, defaultForm)
        },
    
        edit(id) {
          this.dialogVisible = true
          this.fetchDataById(id)
        },
    
        fetchDataById(id) {
          api.getById(id).then(response => {
            this.sysUser = response.data
          })
        },
    
        saveOrUpdate() {
          this.$refs.dataForm.validate(valid => {
            if (valid) {
              this.saveBtnDisabled = true // 防止表单重复提交
              if (!this.sysUser.id) {
                this.saveData()
              } else {
                this.updateData()
              }
            }
          })
        },
    
        // 新增
        saveData() {
          api.save(this.sysUser).then(response => {
            this.$message.success('操作成功')
            this.dialogVisible = false
            this.fetchData(this.page)
          })
        },
    
        // 根据id更新记录
        updateData() {
          api.updateById(this.sysUser).then(response => {
            this.$message.success(response.message || '操作成功')
            this.dialogVisible = false
            this.fetchData(this.page)
          })
        }
      }
    }
    </script>

### **二、给用户分配角色及更改用户状态** ###

#### **1、给用户分配角色** ####

##### 1.1、接口分析 #####

1、进入分配页面：获取已分配角色与全部角色，进行页面展示

2、保存分配角色：删除之前分配的角色和保存现在分配的角色

##### 1.2、controller方法 #####

操作类：SysRoleController 添加以下代码

@ApiOperation(value = "根据用户获取角色数据")
    @GetMapping("/toAssign/{userId}")
    public Result toAssign(@PathVariable Long userId) {
        Map<String, Object> roleMap = sysRoleService.findRoleByAdminId(userId);
        return Result.ok(roleMap);
    }
    
    @ApiOperation(value = "根据用户分配角色")
    @PostMapping("/doAssign")
    public Result doAssign(@RequestBody AssginRoleVo assginRoleVo) {
        sysRoleService.doAssign(assginRoleVo);
        return Result.ok();
    }

##### 1.3、service接口 #####

操作类：SysRoleService

/**
     * 根据用户获取角色数据
     * @param userId
     * @return
     */
    Map<String, Object> findRoleByAdminId(Long userId);
    
    /**
     * 分配角色
     * @param assginRoleVo
     */
    void doAssign(AssginRoleVo assginRoleVo);

##### 1.4、service接口实现 #####

操作类：SysRoleServiceImpl

@Autowired
    private SysUserRoleMapper sysUserRoleMapper;
    
    @Override
    public Map<String, Object> findRoleByUserId(Long userId) {
        //查询所有的角色
        List<SysRole> allRolesList = this.list();
    
        //拥有的角色id
        List<SysUserRole> existUserRoleList = sysUserRoleMapper.selectList(new LambdaQueryWrapper<SysUserRole>().eq(SysUserRole::getUserId, userId).select(SysUserRole::getRoleId));
        List<Long> existRoleIdList = existUserRoleList.stream().map(c->c.getRoleId()).collect(Collectors.toList());
    
        //对角色进行分类
        List<SysRole> assginRoleList = new ArrayList<>();
        for (SysRole role : allRolesList) {
            //已分配
            if(existRoleIdList.contains(role.getId())) {
                assginRoleList.add(role);
            }
        }
    
        Map<String, Object> roleMap = new HashMap<>();
        roleMap.put("assginRoleList", assginRoleList);
        roleMap.put("allRolesList", allRolesList);
        return roleMap;
    }
    
    @Transactional
    @Override
    public void doAssign(AssginRoleVo assginRoleVo) {
        sysUserRoleMapper.delete(new LambdaQueryWrapper<SysUserRole>().eq(SysUserRole::getUserId, assginRoleVo.getUserId()));
    
        for(Long roleId : assginRoleVo.getRoleIdList()) {
            if(StringUtils.isEmpty(roleId)) continue;
            SysUserRole userRole = new SysUserRole();
            userRole.setUserId(assginRoleVo.getUserId());
            userRole.setRoleId(roleId);
            sysUserRoleMapper.insert(userRole);
        }
    }

##### 1.5、添加SysUserRoleMapper类 #####

package com.atguigu.system.mapper;
    
    import com.atguigu.model.system.SysUserRole;
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import org.apache.ibatis.annotations.Mapper;
    import org.springframework.stereotype.Repository;
    
    @Repository
    @Mapper
    public interface SysUserRoleMapper extends BaseMapper<SysUserRole> {
    
    }

#### **2更改用户状态** ####

![8bc346814819fbe2e3c0e65803454bbe.png][]

##### 2.1、需求分析 #####

用户状态：状态（1：正常 0：停用），当用户状态为正常时，可以访问后台系统，当用户状态停用后，不可以登录后台系统

##### 2.2、controller方法 #####

操作类：SysUserController

@ApiOperation(value = "更新状态")
    @GetMapping("updateStatus/{id}/{status}")
    public Result updateStatus(@PathVariable Long id, @PathVariable Integer status) {
        sysUserService.updateStatus(id, status);
        return Result.ok();
    }

##### 2.3、service接口 #####

操作类：SysUserService 添加以下代码

void updateStatus(Long id, Integer status);

##### 2.4、service接口实现 #####

操作类：SysUserServiceImpl

@Transactional
    @Override
    public void updateStatus(Long id, Integer status) {
       SysUser sysUser = this.getById(id);
       if(status.intValue() == 1) {
          sysUser.setStatus(status);
       } else {
          sysUser.setStatus(0);
       }
       this.updateById(sysUser);
    }

#### **3、前端实现更改用户状态** ####

##### 3.1、添加api #####

**src/api/system/sysUser.js**

updateStatus(id, status) {
      return request({
        url: `${api_name}/updateStatus/${id}/${status}`,
        method: 'get'
      })
    }

**src/api/system/sysRole.js**

getRoles(adminId) {
      return request({
        url: `${api_name}/toAssign/${adminId}`,
        method: 'get'
      })
    },
    
    assignRoles(assginRoleVo) {
      return request({
        url: `${api_name}/doAssign`,
        method: 'post',
        data: assginRoleVo
      })
    }

##### 3.2、修改页面 #####

**更改src/views/system/sysUser/list.vue**

<template>
      <div class="app-container">
    
        <div class="search-div">
          <el-form label-width="70px" size="small">
            <el-row>
              <el-col :span="8">
                <el-form-item label="关 键 字">
                  <el-input style="width: 95%" v-model="searchObj.keyword" placeholder="用户名/姓名/手机号码"></el-input>
                </el-form-item>
              </el-col>
              <el-col :span="8">
                <el-form-item label="操作时间">
                  <el-date-picker
                    v-model="createTimes"
                    type="datetimerange"
                    range-separator="至"
                    start-placeholder="开始时间"
                    end-placeholder="结束时间"
                    value-format="yyyy-MM-dd HH:mm:ss"
                    style="margin-right: 10px;width: 100%;"
                  />
                </el-form-item>
              </el-col>
            </el-row>
            <el-row style="display:flex">
              <el-button type="primary" icon="el-icon-search" size="mini" :loading="loading" @click="fetchData()">搜索</el-button>
              <el-button icon="el-icon-refresh" size="mini" @click="resetData">重置</el-button>
            </el-row>
          </el-form>
        </div>
    
        
        <div class="tools-div">
          <el-button type="success" icon="el-icon-plus" size="mini" @click="add">添 加</el-button>
        </div>
    
        
        <el-table
          v-loading="listLoading"
          :data="list"
          stripe
          border
          style="width: 100%;margin-top: 10px;">
    
          <el-table-column
            label="序号"
            width="70"
            align="center">
            <template slot-scope="scope">
              {
        { (page - 1) * limit + scope.$index + 1 }}
            </template>
          </el-table-column>
    
          <el-table-column prop="username" label="用户名" width="100"/>
          <el-table-column prop="name" label="姓名" width="70"/>
          <el-table-column prop="phone" label="手机" width="120"/>
          <el-table-column prop="postName" label="岗位" width="100"/>
          <el-table-column prop="deptName" label="部门" width="100"/>
          <el-table-column label="所属角色" width="130">
            <template slot-scope="scope">
              <span v-for="item in scope.row.roleList" :key="item.id" style="margin-right: 10px;">{
        { item.roleName }}</span>
            </template>
          </el-table-column>
          <el-table-column label="状态" width="80">
            <template slot-scope="scope">
              <el-switch
                v-model="scope.row.status === 1"
                @change="switchStatus(scope.row)">
              </el-switch>
            </template>
          </el-table-column>
          <el-table-column prop="createTime" label="创建时间" width="160"/>
    
          <el-table-column label="操作" width="180" align="center" fixed="right">
            <template slot-scope="scope">
              <el-button type="primary" icon="el-icon-edit" size="mini" @click="edit(scope.row.id)" title="修改"/>
              <el-button type="danger" icon="el-icon-delete" size="mini" @click="removeDataById(scope.row.id)" title="删除" />
              <el-button type="warning" icon="el-icon-baseball" size="mini" @click="showAssignRole(scope.row)" title="分配角色"/>
            </template>
          </el-table-column>
        </el-table>
    
        
        <el-pagination
          :current-page="page"
          :total="total"
          :page-size="limit"
          :page-sizes="[5, 10, 20, 30, 40, 50, 100]"
          style="padding: 30px 0; text-align: center;"
          layout="sizes, prev, pager, next, jumper, ->, total, slot"
          @current-change="fetchData"
          @size-change="changeSize"
        />
    
        <el-dialog title="添加/修改" :visible.sync="dialogVisible" width="40%" >
          <el-form ref="dataForm" :model="sysUser"  label-width="100px" size="small" style="padding-right: 40px;">
            <el-form-item label="用户名" prop="username">
              <el-input v-model="sysUser.username"/>
            </el-form-item>
            <el-form-item v-if="!sysUser.id" label="密码" prop="password">
              <el-input v-model="sysUser.password" type="password"/>
            </el-form-item>
            <el-form-item label="姓名" prop="name">
              <el-input v-model="sysUser.name"/>
            </el-form-item>
            <el-form-item label="手机" prop="phone">
              <el-input v-model="sysUser.phone"/>
            </el-form-item>
          </el-form>
          <span slot="footer" class="dialog-footer">
            <el-button @click="dialogVisible = false" size="small" icon="el-icon-refresh-right">取 消</el-button>
            <el-button type="primary" icon="el-icon-check" @click="saveOrUpdate()" size="small">确 定</el-button>
          </span>
        </el-dialog>
    
        <el-dialog title="分配角色" :visible.sync="dialogRoleVisible">
          <el-form label-width="80px">
            <el-form-item label="用户名">
              <el-input disabled :value="sysUser.username"></el-input>
            </el-form-item>
    
            <el-form-item label="角色列表">
              <el-checkbox :indeterminate="isIndeterminate" v-model="checkAll" @change="handleCheckAllChange">全选</el-checkbox>
              <div style="margin: 15px 0;"></div>
              <el-checkbox-group v-model="userRoleIds" @change="handleCheckedChange">
                <el-checkbox v-for="role in allRoles" :key="role.id" :label="role.id">{
        {role.roleName}}</el-checkbox>
              </el-checkbox-group>
            </el-form-item>
          </el-form>
          <div slot="footer">
            <el-button type="primary" @click="assignRole" size="small">保存</el-button>
            <el-button @click="dialogRoleVisible = false" size="small">取消</el-button>
          </div>
        </el-dialog>
      </div>
    </template>
    
    <script>
    import api from '@/api/system/sysUser'
    import roleApi from '@/api/system/sysRole'
    const defaultForm = {
      id: '',
      username: '',
      password: '',
      name: '',
      phone: '',
      status: 1
    }
    export default {
      data() {
        return {
          listLoading: true, // 数据是否正在加载
          list: null, // banner列表
          total: 0, // 数据库中的总记录数
          page: 1, // 默认页码
          limit: 10, // 每页记录数
          searchObj: {}, // 查询表单对象
    
          createTimes: [],
    
          dialogVisible: false,
          sysUser: defaultForm,
          saveBtnDisabled: false,
    
          dialogRoleVisible: false,
          allRoles: [], // 所有角色列表
          userRoleIds: [], // 用户的角色ID的列表
          isIndeterminate: false, // 是否是不确定的
          checkAll: false // 是否全选
        }
      },
    
      // 生命周期函数：内存准备完毕，页面尚未渲染
      created() {
        console.log('list created......')
        this.fetchData()
    
        roleApi.findAll().then(response => {
          this.roleList = response.data;
        })
      },
    
      // 生命周期函数：内存准备完毕，页面渲染成功
      mounted() {
        console.log('list mounted......')
      },
    
      methods: {
        // 当页码发生改变的时候
        changeSize(size) {
          console.log(size)
          this.limit = size
          this.fetchData(1)
        },
    
        // 加载banner列表数据
        fetchData(page = 1) {
          debugger
          this.page = page
          console.log('翻页。。。' + this.page)
    
          if(this.createTimes && this.createTimes.length ==2) {
            this.searchObj.createTimeBegin = this.createTimes[0]
            this.searchObj.createTimeEnd = this.createTimes[1]
          }
    
          api.getPageList(this.page, this.limit, this.searchObj).then(
            response => {
              //this.list = response.data.list
              this.list = response.data.records
              this.total = response.data.total
    
              // 数据加载并绑定成功
              this.listLoading = false
            }
          )
        },
    
        // 重置查询表单
        resetData() {
          console.log('重置查询表单')
          this.searchObj = {}
          this.createTimes = []
          this.fetchData()
        },
    
        // 根据id删除数据
        removeDataById(id) {
          // debugger
          this.$confirm('此操作将永久删除该记录, 是否继续?', '提示', {
            confirmButtonText: '确定',
            cancelButtonText: '取消',
            type: 'warning'
          }).then(() => { // promise
            // 点击确定，远程调用ajax
            return api.removeById(id)
          }).then((response) => {
            this.fetchData(this.page)
            this.$message.success(response.message || '删除成功')
          }).catch(() => {
             this.$message.info('取消删除')
          })
        },
    
        // -------------
        add(){
          this.dialogVisible = true
          this.sysUser = Object.assign({}, defaultForm)
        },
    
        edit(id) {
          this.dialogVisible = true
          this.fetchDataById(id)
        },
    
        fetchDataById(id) {
          api.getById(id).then(response => {
            this.sysUser = response.data
          })
        },
    
        saveOrUpdate() {
          this.$refs.dataForm.validate(valid => {
            if (valid) {
              this.saveBtnDisabled = true // 防止表单重复提交
              if (!this.sysUser.id) {
                this.saveData()
              } else {
                this.updateData()
              }
            }
          })
        },
    
        // 新增
        saveData() {
          api.save(this.sysUser).then(response => {
            this.$message.success('操作成功')
            this.dialogVisible = false
            this.fetchData(this.page)
          })
        },
    
        // 根据id更新记录
        updateData() {
          api.updateById(this.sysUser).then(response => {
            this.$message.success(response.message || '操作成功')
            this.dialogVisible = false
            this.fetchData(this.page)
          })
        },
    
        showAssignRole (row) {
          this.sysUser = row
          this.dialogRoleVisible = true
          this.getRoles()
        },
    
        getRoles () {
          roleApi.getRoles(this.sysUser.id).then(response => {
            const {allRolesList, assginRoleList} = response.data
            this.allRoles = allRolesList
            this.userRoleIds = assginRoleList.map(item => item.id)
            this.checkAll = allRolesList.length===assginRoleList.length
            this.isIndeterminate = assginRoleList.length>0 && assginRoleList.length<allRolesList.length
          })
        },
    
        /*
        全选勾选状态发生改变的监听
        */
        handleCheckAllChange (value) {// value 当前勾选状态true/false
          // 如果当前全选, userRoleIds就是所有角色id的数组, 否则是空数组
          this.userRoleIds = value ? this.allRoles.map(item => item.id) : []
          // 如果当前不是全选也不全不选时, 指定为false
          this.isIndeterminate = false
        },
    
        /*
        角色列表选中项发生改变的监听
        */
        handleCheckedChange (value) {
          const {userRoleIds, allRoles} = this
          this.checkAll = userRoleIds.length === allRoles.length && allRoles.length>0
          this.isIndeterminate = userRoleIds.length>0 && userRoleIds.length<allRoles.length
        },
    
        assignRole () {
          let assginRoleVo = {
            userId: this.sysUser.id,
            roleIdList: this.userRoleIds
          }
          roleApi.assignRoles(assginRoleVo).then(response => {
            this.$message.success(response.message || '分配角色成功')
            this.dialogRoleVisible = false
            this.fetchData(this.page)
          })
        },
    
        switchStatus(row) {
          row.status = row.status === 1 ? 0 : 1
          api.updateStatus(row.id, row.status).then(response => {
            if (response.code) {
              this.$message.success(response.message || '操作成功')
              this.dialogVisible = false
              this.fetchData()
            }
          })
        }
      }
    }
    </script>

![c7fe71cb0430f1803cdf6600652d29bf.png][]

### **三、菜单管理** ###

#### **1.菜单管理需求** ####

##### **1.1需求描述** #####

不同角色的用户登录后台管理系统拥有不同的菜单权限与功能权限，我们前端是基于：vue-admin-template这个模块开发的，因此我们菜单表设计也必须基于前端模板进行设计。

前端框架vue-admin-template菜单其实就是我们配置的路由：

{
      path: '/system',
      component: Layout,
      meta: {
        title: '系统管理',
        icon: 'el-icon-s-tools'
      },
      alwaysShow: true,
      children: [
        {
          name: 'sysUser',
          path: 'sysUser',
          component: () => import('@/views/system/sysUser/list'),
          meta: {
            title: '用户管理',
            icon: 'el-icon-s-custom'
          },
        },
        {
          path: 'sysRole',
          component: () => import('@/views/system/sysRole/list'),
          meta: {
            title: '角色管理',
            icon: 'el-icon-s-help'
          },
        },
        {
          name: 'sysMenu',
          path: 'sysMenu',
          component: () => import('@/views/system/sysMenu/list'),
          meta: {
            title: '菜单管理',
            icon: 'el-icon-s-unfold'
          },
        },
        {
          path: 'assignAuth',
          component: () => import('@/views/system/sysRole/assignAuth'),
          meta: {
            activeMenu: '/system/sysRole',
            title: '角色授权'
          },
          hidden: true,
        }
      ]
    }

因此，菜单表的设计必须满足路由配置的必要信息

##### **1.2菜单表设计** #####

###### 2.1、表结构 ######

![bedd1ca314af8fd75611fd5c30fa51d2.png][]

重点字段说明：

type：菜单类型，分为：目录、菜单与按钮

目录：一个分类（可理解为一级菜单）、目录下级节点可以为目录与菜单

菜单：一个具体页面，菜单的下级节点只能是按钮

按钮：页面上的功能

path：对应路由里面的路由地址path

component：对应路由里面的组件component

perms：对应菜单的功能权限标识

icom：对应路由的菜单图标

![2216bf54b1ebe66ca957541c7546896c.png][]

###### 2.2、页面效果 ######

![7905ceeeef9a6a0bd83e3b8b8fe441a7.png][]

#### **2、菜单管理CRUD** ####

##### 2.1、Mapper #####

package com.atguigu.system.mapper;
    
    
    import com.atguigu.model.system.SysMenu;
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    @Repository
    @Mapper
    public interface SysMenuMapper extends BaseMapper<SysMenu> {
    
    }

##### 2.2、service接口及实现 #####

**SysUserService接口**

package com.atguigu.system.service;
    
    
    import com.atguigu.model.system.SysMenu;
    import com.baomidou.mybatisplus.extension.service.IService;
    
    import java.util.List;
    
    public interface SysMenuService extends IService<SysMenu> {
    
        /**
         * 菜单树形数据
         * @return
         */
        List<SysMenu> findNodes();
    
    }

**SysUserServiceImpl实现**

package com.atguigu.system.service.impl;
    
    import com.atguigu.common.execption.GuiguException;
    import com.atguigu.common.result.ResultCodeEnum;
    import com.atguigu.model.system.SysMenu;
    import com.atguigu.system.helper.MenuHelper;
    import com.atguigu.system.mapper.SysMenuMapper;
    import com.atguigu.system.service.SysMenuService;
    import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.util.CollectionUtils;
    
    import java.io.Serializable;
    import java.util.List;
    
    @Service
    public class SysMenuServiceImpl extends ServiceImpl<SysMenuMapper, SysMenu> implements SysMenuService {
    
        @Autowired
        private SysMenuMapper sysMenuMapper;
    
        @Override
        public List<SysMenu> findNodes() {
            //全部权限列表
            List<SysMenu> sysMenuList = this.list();
            if (CollectionUtils.isEmpty(sysMenuList)) return null;
    
            //构建树形数据
            List<SysMenu> result = MenuHelper.buildTree(sysMenuList);
            return result;
        }
    
        @Override
        public boolean removeById(Serializable id) {
            int count = this.count(new LambdaQueryWrapper<SysMenu>().eq(SysMenu::getParentId, id));
            if (count > 0) {
                throw new GuiguException(201,"菜单不能删除");
            }
            sysMenuMapper.deleteById(id);
            return false;
        }
    
    }

**添加帮助类(service-oa模块)**

新建：com.atguigu.auth.utils.MenuHelper

package com.atguigu.auth.utils;
    
    
    import com.atguigu.model.system.SysMenu;
    
    import java.util.ArrayList;
    import java.util.List;
    
    /**
     * <p>
     * 根据菜单数据构建菜单数据
     * </p>
     *
     */
    public class MenuHelper {
    
        /**
         * 使用递归方法建菜单
         * @param sysMenuList
         * @return
         */
        public static List<SysMenu> buildTree(List<SysMenu> sysMenuList) {
            List<SysMenu> trees = new ArrayList<>();
            for (SysMenu sysMenu : sysMenuList) {
                if (sysMenu.getParentId().longValue() == 0) {
                    trees.add(findChildren(sysMenu,sysMenuList));
                }
            }
            return trees;
        }
    
        /**
         * 递归查找子节点
         * @param treeNodes
         * @return
         */
        public static SysMenu findChildren(SysMenu sysMenu, List<SysMenu> treeNodes) {
            sysMenu.setChildren(new ArrayList<SysMenu>());
    
            for (SysMenu it : treeNodes) {
                if(sysMenu.getId().longValue() == it.getParentId().longValue()) {
                    if (sysMenu.getChildren() == null) {
                        sysMenu.setChildren(new ArrayList<>());
                    }
                    sysMenu.getChildren().add(findChildren(it,treeNodes));
                }
            }
            return sysMenu;
        }
    }

##### 2.4、SysMenuController层 #####

package com.atguigu.system.controller;
    
    import com.atguigu.common.result.Result;
    import com.atguigu.model.system.SysMenu;
    import com.atguigu.system.service.SysMenuService;
    import io.swagger.annotations.Api;
    import io.swagger.annotations.ApiOperation;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.*;
    import java.util.List;
    
    @Api(tags = "菜单管理")
    @RestController
    @RequestMapping("/admin/system/sysMenu")
    public class SysMenuController {
    
        @Autowired
        private SysMenuService sysMenuService;
    
        @ApiOperation(value = "获取菜单")
        @GetMapping("findNodes")
        public Result findNodes() {
            List<SysMenu> list = sysMenuService.findNodes();
            return Result.ok(list);
        }
    
        @ApiOperation(value = "新增菜单")
        @PostMapping("save")
        public Result save(@RequestBody SysMenu permission) {
            sysMenuService.save(permission);
            return Result.ok();
        }
    
        @ApiOperation(value = "修改菜单")
        @PutMapping("update")
        public Result updateById(@RequestBody SysMenu permission) {
            sysMenuService.updateById(permission);
            return Result.ok();
        }
    
        @ApiOperation(value = "删除菜单")
        @DeleteMapping("remove/{id}")
        public Result remove(@PathVariable Long id) {
            sysMenuService.removeById(id);
            return Result.ok();
        }
    
    }

##### 2.5、knife4j测试 #####

[http://localhost:8800/doc.html][http_localhost_8800_doc.html]

#### **3、用户管理前端实现** ####

##### 3.1、添加路由 #####

**修改 src/router/index.js 文件**

{
      name: 'sysMenu',
      path: 'sysMenu',
      component: () => import('@/views/system/sysMenu/list'),
      meta: {
        title: '菜单管理',
        icon: 'el-icon-s-unfold'
      },
    }

##### 3.2、定义基础api #####

**创建文件 src/api/system/sysMenu.js**

import request from '@/utils/request'
    
    /*
    菜单管理相关的API请求函数
    */
    const api_name = '/admin/system/sysMenu'
    
    export default {
    
      /*
      获取权限(菜单/功能)列表
      */
      findNodes() {
        return request({
          url: `${api_name}/findNodes`,
          method: 'get'
        })
      },
    
      /*
      删除一个权限项
      */
      removeById(id) {
        return request({
          url: `${api_name}/remove/${id}`,
          method: "delete"
        })
      },
    
      /*
      保存一个权限项
      */
      save(sysMenu) {
        return request({
          url: `${api_name}/save`,
          method: "post",
          data: sysMenu
        })
      },
    
      /*
      更新一个权限项
      */
      updateById(sysMenu) {
        return request({
          url: `${api_name}/update`,
          method: "put",
          data: sysMenu
        })
      }
    }

##### 3.3、实现页面功能 #####

**创建src/views/system/sysMenu/list.vue**

<template>
      <div class="app-container">
    
        
        <div class="tools-div">
          <el-button type="success" icon="el-icon-plus" size="mini" @click="add()">添 加</el-button>
        </div>
        <el-table
          :data="sysMenuList"
          style="width: 100%;margin-bottom: 20px;margin-top: 10px;"
          row-key="id"
          border
          :default-expand-all="false"
          :tree-props="{children: 'children'}">
    
          <el-table-column prop="name" label="菜单名称" width="160"/>
          <el-table-column label="图标">
            <template slot-scope="scope">
              <i :class="scope.row.icon"></i>
            </template>
          </el-table-column>
          <el-table-column prop="perms" label="权限标识" width="160"/>
          <el-table-column prop="path" label="路由地址" width="120"/>
          <el-table-column prop="component" label="组件路径" width="160"/>
          <el-table-column prop="sortValue" label="排序" width="60"/>
          <el-table-column label="状态" width="80">
            <template slot-scope="scope">
              <el-switch
                v-model="scope.row.status === 1" disabled="true">
              </el-switch>
            </template>
          </el-table-column>
          <el-table-column prop="createTime" label="创建时间" width="160"/>
          <el-table-column label="操作" width="180" align="center" fixed="right">
            <template slot-scope="scope">
              <el-button type="success" v-if="scope.row.type !== 2" icon="el-icon-plus" size="mini" @click="add(scope.row)" title="添加下级节点"/>
              <el-button type="primary" icon="el-icon-edit" size="mini" @click="edit(scope.row)" title="修改"/>
              <el-button type="danger" icon="el-icon-delete" size="mini" @click="removeDataById(scope.row.id)" title="删除" :disabled="scope.row.children.length > 0"/>
            </template>
          </el-table-column>
        </el-table>
    
        <el-dialog :title="dialogTitle" :visible.sync="dialogVisible" width="40%" >
          <el-form ref="dataForm" :model="sysMenu" label-width="150px" size="small" style="padding-right: 40px;">
            <el-form-item label="上级部门" v-if="sysMenu.id === ''">
              <el-input v-model="sysMenu.parentName" disabled="true"/>
            </el-form-item>
            <el-form-item label="菜单类型" prop="type">
              <el-radio-group v-model="sysMenu.type" :disabled="typeDisabled">
                <el-radio :label="0" :disabled="type0Disabled">目录</el-radio>
                <el-radio :label="1" :disabled="type1Disabled">菜单</el-radio>
                <el-radio :label="2" :disabled="type2Disabled">按钮</el-radio>
              </el-radio-group>
            </el-form-item>
            <el-form-item label="菜单名称" prop="name">
              <el-input v-model="sysMenu.name"/>
            </el-form-item>
            <el-form-item label="图标" prop="icon" v-if="sysMenu.type !== 2">
              <el-select v-model="sysMenu.icon" clearable>
                <el-option v-for="item in iconList" :key="item.class" :label="item.class" :value="item.class">
                <span style="float: left;">
                 <i :class="item.class"></i>  
                </span>
                  <span style="padding-left: 6px;">{
        { item.class }}</span>
                </el-option>
              </el-select>
            </el-form-item>
            <el-form-item label="排序">
              <el-input-number v-model="sysMenu.sortValue" controls-position="right" :min="0" />
            </el-form-item>
            <el-form-item prop="path">
                  <span slot="label">
                    <el-tooltip content="访问的路由地址，如：`sysUser`" placement="top">
                    <i class="el-icon-question"></i>
                    </el-tooltip>
                    路由地址
                  </span>
              <el-input v-model="sysMenu.path" placeholder="请输入路由地址" />
            </el-form-item>
            <el-form-item prop="component" v-if="sysMenu.type !== 0">
                  <span slot="label">
                    <el-tooltip content="访问的组件路径，如：`system/user/index`，默认在`views`目录下" placement="top">
                    <i class="el-icon-question"></i>
                    </el-tooltip>
                    组件路径
                  </span>
              <el-input v-model="sysMenu.component" placeholder="请输入组件路径" />
            </el-form-item>
            <el-form-item v-if="sysMenu.type === 2">
              <el-input v-model="sysMenu.perms" placeholder="请输入权限标识" maxlength="100" />
              <span slot="label">
                    <el-tooltip content="控制器中定义的权限字符，如：@PreAuthorize(hasAuthority('bnt.sysRole.list'))" placement="top">
                    <i class="el-icon-question"></i>
                    </el-tooltip>
                    权限字符
                  </span>
            </el-form-item>
            <el-form-item label="状态" prop="type">
              <el-radio-group v-model="sysMenu.status">
                <el-radio :label="1">正常</el-radio>
                <el-radio :label="0">停用</el-radio>
              </el-radio-group>
            </el-form-item>
          </el-form>
          <span slot="footer" class="dialog-footer">
            <el-button @click="dialogVisible = false" size="small" icon="el-icon-refresh-right">取 消</el-button>
            <el-button type="primary" icon="el-icon-check" @click="saveOrUpdate()" size="small">确 定</el-button>
          </span>
        </el-dialog>
      </div>
    </template>
    
    
    <script>
    import api from '@/api/system/sysMenu'
    const defaultForm = {
      id: '',
      parentId: '',
      name: '',
      type: 0,
      path: '',
      component: '',
      perms: '',
      icon: '',
      sortValue: 1,
      status: 1
    }
    export default {
      // 定义数据
      data() {
        return {
          sysMenuList: [],
          expandKeys: [], // 需要自动展开的项
    
          typeDisabled: false,
          type0Disabled: false,
          type1Disabled: false,
          type2Disabled: false,
          dialogTitle: '',
    
          dialogVisible: false,
          sysMenu: defaultForm,
          saveBtnDisabled: false,
    
          iconList: [
            {
              class: "el-icon-s-tools",
            },
            {
              class: "el-icon-s-custom",
            },
            {
              class: "el-icon-setting",
            },
            {
              class: "el-icon-user-solid",
            },
            {
              class: "el-icon-s-help",
            },
            {
              class: "el-icon-phone",
            },
            {
              class: "el-icon-s-unfold",
            },
            {
              class: "el-icon-s-operation",
            },
            {
              class: "el-icon-more-outline",
            },
            {
              class: "el-icon-s-check",
            },
            {
              class: "el-icon-tickets",
            },
            {
              class: "el-icon-s-goods",
            },
            {
              class: "el-icon-document-remove",
            },
            {
              class: "el-icon-warning",
            },
            {
              class: "el-icon-warning-outline",
            },
            {
              class: "el-icon-question",
            },
            {
              class: "el-icon-info",
            }
          ]
        }
      },
    
      // 当页面加载时获取数据
      created() {
        this.fetchData()
      },
    
      methods: {
        // 调用api层获取数据库中的数据
        fetchData() {
          console.log('加载列表')
          api.findNodes().then(response => {
            this.sysMenuList = response.data
            console.log(this.sysMenuList)
          })
        },
    
        // 根据id删除数据
        removeDataById(id) {
          // debugger
          this.$confirm('此操作将永久删除该记录, 是否继续?', '提示', {
            confirmButtonText: '确定',
            cancelButtonText: '取消',
            type: 'warning'
          }).then(() => { // promise
            // 点击确定，远程调用ajax
            return api.removeById(id)
          }).then((response) => {
            this.fetchData()
            this.$message({
              type: 'success',
              message: '删除成功!'
            })
          }).catch(() => {
             this.$message.info('取消删除')
          })
        },
    
        // -------------
        add(row){
          debugger
          this.typeDisabled = false
          this.dialogTitle = '添加下级节点'
          this.dialogVisible = true
    
          this.sysMenu = Object.assign({}, defaultForm)
          this.sysMenu.id = ''
          if(row) {
            this.sysMenu.parentId = row.id
            this.sysMenu.parentName = row.name
            //this.sysMenu.component = 'ParentView'
            if(row.type === 0) {
              this.sysMenu.type = 1
              this.typeDisabled = false
              this.type0Disabled = false
              this.type1Disabled = false
              this.type2Disabled = true
            } else if(row.type === 1) {
              this.sysMenu.type = 2
              this.typeDisabled = true
            }
          } else {
            this.dialogTitle = '添加目录节点'
            this.sysMenu.type = 0
            this.sysMenu.component = 'Layout'
            this.sysMenu.parentId = 0
            this.typeDisabled = true
          }
        },
    
        edit(row) {
          debugger
          this.dialogTitle = '修改节点'
          this.dialogVisible = true
    
          this.sysMenu = Object.assign({}, row)
          this.typeDisabled = true
        },
    
        saveOrUpdate() {
          if(this.sysMenu.type === 0 && this.sysMenu.parentId !== 0) {
            this.sysMenu.component = 'ParentView'
          }
          this.$refs.dataForm.validate(valid => {
            if (valid) {
              this.saveBtnDisabled = true // 防止表单重复提交
              if (!this.sysMenu.id) {
                this.saveData()
              } else {
                this.updateData()
              }
            }
          })
        },
    
        // 新增
        saveData() {
          api.save(this.sysMenu).then(response => {
            this.$message.success(response.message || '操作成功')
            this.dialogVisible = false
            this.fetchData(this.page)
          })
        },
    
        // 根据id更新记录
        updateData() {
          api.updateById(this.sysMenu).then(response => {
            this.$message.success(response.message || '操作成功')
            this.dialogVisible = false
            this.fetchData()
          })
        }
      }
    }
    </script>

### **四、给角色分配权限** ###

#### **1、给角色分配权限** ####

##### 1.1、接口分析 #####

1、进入分配页面：获取全部菜单及按钮，选中已选复选框，进行页面展示

2、保存分配权限：删除之前分配的权限和保存现在分配的权限

##### 1.2、controller方法 #####

操作类：SysMenuController 添加以下代码

@ApiOperation(value = "根据角色获取菜单")
    @GetMapping("toAssign/{roleId}")
    public Result toAssign(@PathVariable Long roleId) {
        List<SysMenu> list = sysMenuService.findSysMenuByRoleId(roleId);
        return Result.ok(list);
    }
    
    @ApiOperation(value = "给角色分配权限")
    @PostMapping("/doAssign")
    public Result doAssign(@RequestBody AssignMenuVo assignMenuVo) {
        sysMenuService.doAssign(assignMenuVo);
        return Result.ok();
    }

##### 1.3、service接口 #####

操作类：SysMenuService

/**
     * 根据角色获取授权权限数据
     * @return
     */
    List<SysMenu> findSysMenuByRoleId(Long roleId);
    
    /**
     * 保存角色权限
     * @param  assginMenuVo
     */
    void doAssign(AssginMenuVo assginMenuVo);

##### 1.4、service接口实现 #####

1、操作类：SysMenuServiceImpl

@Override
    public List<SysMenu> findSysMenuByRoleId(Long roleId) {
        //全部权限列表
        List<SysMenu> allSysMenuList = this.list(new LambdaQueryWrapper<SysMenu>().eq(SysMenu::getStatus, 1));
    
        //根据角色id获取角色权限
        List<SysRoleMenu> sysRoleMenuList = sysRoleMenuMapper.selectList(new LambdaQueryWrapper<SysRoleMenu>().eq(SysRoleMenu::getRoleId, roleId));
        //转换给角色id与角色权限对应Map对象
        List<Long> menuIdList = sysRoleMenuList.stream().map(e -> e.getMenuId()).collect(Collectors.toList());
    
        allSysMenuList.forEach(permission -> {
            if (menuIdList.contains(permission.getId())) {
                permission.setSelect(true);
            } else {
                permission.setSelect(false);
            }
        });
    
        List<SysMenu> sysMenuList = MenuHelper.buildTree(allSysMenuList);
        return sysMenuList;
    }
    
    @Transactional
    @Override
    public void doAssign(AssginMenuVo assginMenuVo) {
        sysRoleMenuMapper.delete(new LambdaQueryWrapper<SysRoleMenu>().eq(SysRoleMenu::getRoleId, assginMenuVo.getRoleId()));
    
        for (Long menuId : assginMenuVo.getMenuIdList()) {
            if (StringUtils.isEmpty(menuId)) continue;
            SysRoleMenu rolePermission = new SysRoleMenu();
            rolePermission.setRoleId(assginMenuVo.getRoleId());
            rolePermission.setMenuId(menuId);
            sysRoleMenuMapper.insert(rolePermission);
        }
    }

##### 1.5、添加SysRoleMenuMapper类 #####

package com.atguigu.system.mapper;
    
    import com.atguigu.model.system.SysRoleMenu;
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import org.apache.ibatis.annotations.Mapper;
    import org.springframework.stereotype.Repository;
    
    @Repository
    @Mapper
    public interface SysRoleMenuMapper extends BaseMapper<SysRoleMenu> {
    
    }

#### **2、前端实现** ####

##### 2.1、添加路由 #####

修改 src/router/index.js 文件

{
      path: 'assignAuth',
      component: () => import('@/views/system/sysRole/assignAuth'),
      meta: {
        activeMenu: '/system/sysRole',
        title: '角色授权'
      },
      hidden: true,
    }

##### 2.2、角色列表添加按钮及方法 #####

<el-button type="warning" icon="el-icon-baseball" size="mini" @click="showAssignAuth(scope.row)" title="分配权限"/>

showAssignAuth(row) {
      this.$router.push('/system/assignAuth?id='+row.id+'&roleName='+row.roleName);
    }

##### 2.3、添加api #####

**创建文件 src/api/system/sysMenu.js**

/*
    查看某个角色的权限列表
    */
    toAssign(roleId) {
      return request({
        url: `${api_name}/toAssign/${roleId}`,
        method: 'get'
      })
    },
    
    /*
    给某个角色授权
    */
    doAssign(assginMenuVo) {
      return request({
        url: `${api_name}/doAssign`,
        method: "post",
        data: assginMenuVo
      })
    }

![32a5206880bde9f4ffff759a12ea6673.png][]

##### 2.4、实现页面功能 #####

**创建src/views/system/sysMenu/assignAuth.vue**

<template>
      <div class="app-container">
        <div style="padding: 20px 20px 0 20px;">
          授权角色：{
        { $route.query.roleName }}
        </div>
        <el-tree
          style="margin: 20px 0"
          ref="tree"
          :data="sysMenuList"
          node-key="id"
          show-checkbox
          default-expand-all
          :props="defaultProps"
        />
        <div style="padding: 20px 20px;">
          <el-button :loading="loading" type="primary" icon="el-icon-check" size="mini" @click="save">保存</el-button>
          <el-button @click="$router.push('/system/sysRole')" size="mini" icon="el-icon-refresh-right">返回</el-button>
        </div>
      </div>
    </template>
    <script>
      import api from '@/api/system/sysMenu'
      export default {
        name: 'roleAuth',
    
        data() {
          return {
            loading: false, // 用来标识是否正在保存请求中的标识, 防止重复提交
            sysMenuList: [], // 所有
            defaultProps: {
              children: 'children',
              label: 'name'
            },
          };
        },
    
        created() {
          this.fetchData()
        },
    
        methods: {
          /*
          初始化
          */
          fetchData() {
            const roleId = this.$route.query.id
            api.toAssign(roleId).then(result => {
              const sysMenuList = result.data
              this.sysMenuList = sysMenuList
              const checkedIds = this.getCheckedIds(sysMenuList)
              console.log('getPermissions() checkedIds', checkedIds)
              this.$refs.tree.setCheckedKeys(checkedIds)
            })
          },
    
          /*
          得到所有选中的id列表
          */
          getCheckedIds (auths, initArr = []) {
            return auths.reduce((pre, item) => {
              if (item.select && item.children.length === 0) {
                pre.push(item.id)
              } else if (item.children) {
                this.getCheckedIds(item.children, initArr)
              }
              return pre
            }, initArr)
          },
    
          /*
          保存权限列表
          */
          save() {
            debugger
            //获取到当前子节点
            //const checkedNodes = this.$refs.tree.getCheckedNodes()
            //获取到当前子节点及父节点
            const allCheckedNodes = this.$refs.tree.getCheckedNodes(false, true);
            let idList = allCheckedNodes.map(node => node.id);
            console.log(idList)
            let assginMenuVo = {
              roleId: this.$route.query.id,
              menuIdList: idList
            }
            this.loading = true
            api.doAssign(assginMenuVo).then(result => {
              this.loading = false
              this.$message.success(result.$message || '分配权限成功')
              this.$router.push('/system/sysRole');
            })
          }
        }
      };
    </script>

[http_localhost_8800_doc.html]: http://localhost:8800/doc.html
[2ea077c63754da4bc8d5e4bd9153efe4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/29/70058858fde741048596048c66ae7a35.png
[de7c18b101339fb51078fe074a1d1f58.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/29/91958ed700d84fd58127046ed186df05.png
[8bc346814819fbe2e3c0e65803454bbe.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/29/c1813be2cf5442ec85922b66f8e846a5.png
[c7fe71cb0430f1803cdf6600652d29bf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/29/cee11e3ec6944ae5aa1a8a50ae6c13e3.png
[bedd1ca314af8fd75611fd5c30fa51d2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/29/c50ee8e186e0461a90482c47f204d244.png
[2216bf54b1ebe66ca957541c7546896c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/29/c7cd5c3ec0f74df188999a0334d12b46.png
[7905ceeeef9a6a0bd83e3b8b8fe441a7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/29/6007d71d2f094d7c8e012ab2dd1129c7.png
[32a5206880bde9f4ffff759a12ea6673.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/29/86918bd5eaef45e4891c1f756f686130.png