需求
要做出如下图所示的 树形表格,也就是数据之间有父子类关系的这种,可以点击展开、收缩
像上图这样的表格树
实现
1.使用树形组件
在学习树形表格之前,肯定得先搞懂普通的树形组件是怎么搞的,然后将其套到表格中就好了,请参考ElementUI官方文档中的使用方法
链接:组件 | Element
基础用法展示
也就是数据中要有 children 作为树形组件中的 子数据
学会使用普通的树形结构之后,我们再来看 怎么使用树形的表格
2.使用树形表格
下面这段话出自博客:Element-ui 表格实现树形结构表格_elementui树形表格_在奋斗的大道的博客-CSDN博客
在el-table中,支持树类型的数据的显示。当 row 中包含 children 字段时,被视为树形数据。
渲染树形数据时,必须要指定 row-key。支持子节点数据异步加载。
通过指定 row 中的 hasChildren 字段来指定哪些行是包含子节点。children 与 hasChildren 都可以通过 tree-props 配置。
row-key="id"和:tree-props="{children: 'children', hasChildren: 'hasChildren'}是必须的。
数据表格区代码
<!-- 表格数据区--> <el-table v-if="refreshTable" v-loading="loading" :data="deptList" row-key="id" :default-expand-all="isExpandAll" :tree-props="{children: 'children', hasChildren: 'hasChildren'}" > <el-table-column prop="deptName" label="部门名称" width="260"></el-table-column> <el-table-column prop="orderNum" label="排序" width="200"></el-table-column> ...... ...... ...... </el-table>
复制
数据的格式
数据必须要有 children,例如下面的代码,就是树形表格数据的地方,我们伪造了一点数据,也是可以展示的。
// 表格树数据
deptList: [
{
id: "1",
deptName: "若依科技",
deptStatus: 1,
superiorId: "0",
orderNum: 1,
ancestors: "0",
createTime: "2023-07-18 08:49:56",
leaderId: "1678651668064612354",
children: [{
id: "1",
deptName: "若依科技",
deptStatus: 1,
superiorId: "0",
orderNum: 1,
ancestors: "0",
createTime: "2023-07-18 08:49:56",
leaderId: "1678651668064612354",
}]
},
],
复制
伪造的代码 的效果如下图
伪造数据效果图
后端返回代码格式
我们项目中返回的数据是下面代码,只需要将后端返回的data 与前端的表格绑定即可
{ "status": 0, "data": [ { "id": "1", "deptName": "若依科技", "deptStatus": 1, "superiorId": "0", "orderNum": 1, "ancestors": "0", "createTime": "2023-07-18 08:49:56", "leaderId": "1678651668064612354", "children": [ { "id": "2", "deptName": "深圳总公司", "deptStatus": 1, "superiorId": "1", "orderNum": 1, "ancestors": "1", "createTime": "2023-07-18 08:50:35", "leaderId": "1678651883026886657", "children": [ { "id": "4", "deptName": "研发部门", "deptStatus": 1, "superiorId": "2", "orderNum": 1, "ancestors": "1,2", "createTime": "2023-07-18 08:53:09", "leaderId": "1679386932135268353" }, { "id": "5", "deptName": "市场部门", "deptStatus": 1, "superiorId": "2", "orderNum": 2, "ancestors": "1,2", "createTime": "2023-07-18 08:53:43", "leaderId": "1681179955059970050" }, { "id": "6", "deptName": "测试部门", "deptStatus": 1, "superiorId": "2", "orderNum": 3, "ancestors": "1,2", "createTime": "2023-07-18 08:54:06", "leaderId": "1681181469627338754" }, { "id": "1683401601626902529", "deptName": "新的部门", "deptStatus": 0, "superiorId": "2", "orderNum": 4, "ancestors": "1,2", "createTime": "2023-07-24 16:59:53", "leaderId": "1679386932135268353" } ] }, { "id": "3", "deptName": "长沙分公司", "deptStatus": 1, "superiorId": "1", "orderNum": 2, "ancestors": "1", "createTime": "2023-07-18 08:51:43", "leaderId": "1679385454339403778", "children": [ { "id": "7", "deptName": "市场部门", "deptStatus": 1, "superiorId": "3", "orderNum": 1, "ancestors": "1,3", "createTime": "2023-07-18 08:54:26", "leaderId": "1681181510534385666" } ] } ] } ], "success": true }
复制
真实数据效果图
前端全部代码
不建议直接看此处代码,写的杂而乱,建议先去看前面的简洁的代码
<template> <!--与若依相比修改的地方: 所有的parentId 修改成 superiorId 所有的 deptId 修改成 id 所有的 status 修改成 deptStatus --> <div class="app-container"> <!-- 头部搜索区--> <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch"> <el-form-item label="部门名称" prop="deptName"> <el-input v-model="queryParams.deptName" placeholder="请输入部门名称" clearable @keyup.enter.native="handleQuery" /> </el-form-item> <el-form-item label="状态" prop="deptStatus"> <el-select v-model="queryParams.deptStatus" placeholder="请选择状态"> <el-option v-for="item in statusOptions" :key="item.value" :label="item.label" :value="item.value"> </el-option> </el-select> </el-form-item> <el-form-item> <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button> <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button> </el-form-item> </el-form> <!-- 展开折叠、搜索区--> <el-row :gutter="10" class="mb8"> <el-col :span="1.5"> <el-button type="primary" plain icon="el-icon-plus" size="mini" @click="handleAdd" v-hasPermi="['system:dept:add']" >新增</el-button> </el-col> <el-col :span="1.5"> <el-button type="info" plain icon="el-icon-sort" size="mini" @click="toggleExpandAll" >展开/折叠</el-button> </el-col> <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar> </el-row> <!-- 表格数据区--> <el-table v-if="refreshTable" v-loading="loading" :data="deptList" row-key="id" :default-expand-all="isExpandAll" :tree-props="{children: 'children', hasChildren: 'hasChildren'}" > <el-table-column prop="deptName" label="部门名称" width="260"></el-table-column> <el-table-column prop="orderNum" label="排序" width="200"></el-table-column> <el-table-column prop="deptStatus" label="状态" width="100"> <!-- <template slot-scope="scope">--> <!-- <dict-tag :options="dict.type.sys_normal_disable" :value="scope.row.status"/>--> <!-- </template>--> <template slot-scope="scope"> <el-tag type="success" effect="dark" v-if="scope.row.deptStatus==1">正常</el-tag> <el-tag type="warning" effect="dark" v-if="scope.row.deptStatus==0">停用</el-tag> </template> </el-table-column> <el-table-column label="创建时间" align="center" prop="createTime" width="200"> <template slot-scope="scope"> <span>{{ parseTime(scope.row.createTime) }}</span> </template> </el-table-column> <el-table-column label="操作" align="center" class-name="small-padding fixed-width"> <template slot-scope="scope"> <el-button size="mini" type="text" icon="el-icon-edit" @click="handleUpdate(scope.row)" v-hasPermi="['system:dept:edit']" >修改</el-button> <el-button size="mini" type="text" icon="el-icon-plus" @click="handleAdd(scope.row)" v-hasPermi="['system:dept:add']" >新增</el-button> <el-button v-if="scope.row.superiorId != 0" size="mini" type="text" icon="el-icon-delete" @click="handleDelete(scope.row)" v-hasPermi="['system:dept:remove']" >删除</el-button> </template> </el-table-column> </el-table> <!-- 添加或修改部门对话框 --> <el-dialog :title="title" :visible.sync="open" width="600px" append-to-body> <el-form ref="form" :model="form" :rules="rules" label-width="80px"> <el-row> <el-col :span="24" v-if="form.superiorId !== 0"> <el-form-item label="上级部门" prop="superiorId"> <!-- <treeselect v-model="form.parentId" :options="deptOptions" :normalizer="normalizer" placeholder="选择上级部门" />--> <el-input v-model="form.superiorId" placeholder="请输入上级部门id" /> </el-form-item> </el-col> </el-row> <el-row> <el-col :span="12"> <el-form-item label="部门名称" prop="deptName"> <el-input v-model="form.deptName" placeholder="请输入部门名称" /> </el-form-item> </el-col> <el-col :span="12"> <el-form-item label="显示排序" prop="orderNum"> <el-input-number v-model="form.orderNum" controls-position="right" :min="0" /> </el-form-item> </el-col> </el-row> <!-- 负责人信息只做显示,不可修改--> <el-row> <!-- <el-col :span="12">--> <!-- <el-form-item label="负责人id" prop="leader">--> <!-- <el-input v-model="form.leaderId" placeholder="请输入负责人id" maxlength="20" :disabled="true" />--> <!-- </el-form-item>--> <!-- </el-col>--> <el-col :span="12"> <el-form-item label="负责人姓名" prop="leader"> <el-input v-model="form.userName" placeholder="请输入负责人姓名" maxlength="20" :disabled="true" /> </el-form-item> </el-col> <el-col :span="12"> <el-form-item label="联系电话" prop="phone"> <el-input v-model="form.phone" placeholder="请输入联系电话" maxlength="11" :disabled="true"/> </el-form-item> </el-col> </el-row> <el-row> <el-col :span="12"> <el-form-item label="邮箱" prop="email"> <el-input v-model="form.email" placeholder="请输入邮箱" maxlength="50" :disabled="true"/> </el-form-item> </el-col> <el-col :span="12"> <el-form-item label="部门状态" prop="email"> <el-input v-model="form.deptStatus" placeholder="请输入部门状态" maxlength="50" :disabled="true"/> </el-form-item> </el-col> <el-form-item label="状态" prop="deptStatus"> <el-select v-model="form.deptStatus" placeholder="请选择状态"> <el-option v-for="item in statusOptions" :key="item.value" :label="item.label" :value="item.value"> </el-option> </el-select> </el-form-item> <!-- <el-col :span="12">--> <!-- <el-form-item label="部门状态">--> <!-- <el-switch--> <!-- v-model="form.deptStatus"--> <!-- active-value="1"--> <!-- inactive-value="0"--> <!-- active-color="#13ce66"--> <!-- inactive-color="#ff4949">--> <!-- </el-switch>--> <!-- <el-radio v-model="form.deptStatus" label="1" >正常</el-radio>--> <!-- <el-radio v-model="form.deptStatus" label="0" >停用</el-radio>--> <!-- </el-form-item>--> <!-- </el-col>--> </el-row> </el-form> <div slot="footer" class="dialog-footer"> <el-button type="primary" @click="submitForm">确 定</el-button> <el-button @click="cancel">取 消</el-button> </div> </el-dialog> </div> </template> <script> // import { listDept, getDept, delDept, addDept, updateDept, listDeptExcludeChild } from "@/api/system/dept"; import Treeselect from "@riophae/vue-treeselect"; import "@riophae/vue-treeselect/dist/vue-treeselect.css"; import axios from 'axios' export default { name: "Dept", dicts: ['sys_normal_disable'], components: { Treeselect }, data() { return { urls:{ listDept2:'/dept/list',// 查询部门列表:普通 listDept:'/dept/getDeptTree',// 查询部门列表:树形 addDept:'/dept/insert', // 新增部门 delDept: '/dept/delete/',// 删除部门 updateDept:'/dept/update',// 修改部门 selectDeptById:'/dept/selectDeptById',// 根据id查询 getDept:'/system/dept/',// 查询部门详细 listDeptExcludeChild:'/user/add', // 查询部门列表(排除节点) }, statusOptions:[ { value: '0', label: '停用' }, { value: '1', label: '正常' }, ], //区分提交按钮:有提交id 就是修改,没有就是添加,因为修改需要id,添加不需要id submitId: undefined, // 遮罩层 loading: false, // 显示搜索条件 showSearch: true, // 表格树数据 deptList: [ { // id: "1", // deptName: "若依科技", // deptStatus: 1, // superiorId: "0", // orderNum: 1, // ancestors: "0", // createTime: "2023-07-18 08:49:56", // leaderId: "1678651668064612354", // // children: [{ // id: "1", // deptName: "若依科技", // deptStatus: 1, // superiorId: "0", // orderNum: 1, // ancestors: "0", // createTime: "2023-07-18 08:49:56", // leaderId: "1678651668064612354", // }] }, ], // 部门树选项 deptOptions: [], // 弹出层标题 title: "", // 是否显示弹出层 open: false, // 是否展开,默认全部展开 isExpandAll: true, // 重新渲染表格状态 refreshTable: true, // 查询参数 queryParams: { deptName: undefined, deptStatus: undefined, }, // 表单参数 form: { }, // 表单校验 rules: { // parentId: [ superiorId: [ { required: true, message: "上级部门不能为空", trigger: "blur" } ], deptName: [ { required: true, message: "部门名称不能为空", trigger: "blur" } ], orderNum: [ { required: true, message: "显示排序不能为空", trigger: "blur" } ], // email: [ // { // type: "email", // message: "请输入正确的邮箱地址", // trigger: ["blur", "change"] // } // ], // phone: [ // { // pattern: /^1[3|4|5|6|7|8|9][0-9]\d{8}$/, // message: "请输入正确的手机号码", // trigger: "blur" // } // ] } }; }, created() { this.getList(); }, methods: { /** 查询部门列表:查出树形结构 */ getList() { axios({ method:"get", url:this.urls.listDept, params: { deptName : this.queryParams.deptName, deptStatus : this.queryParams.deptStatus, } }).then(res => { this.deptList = res.data.data; } ); }, /** 转换部门数据结构 */ normalizer(node) { if (node.children && !node.children.length) { delete node.children; } return { // id: node.deptId, id: node.id, label: node.deptName, children: node.children }; }, // 取消按钮 cancel() { this.open = false; this.reset(); }, // 表单重置 reset() { //添加、修改 框数据清空 this.form = { // deptId: undefined, // parentId: undefined, id: undefined, superiorId: undefined, deptName: undefined, orderNum: undefined, leader: undefined, phone: undefined, email: undefined, deptStatus: undefined, }; // this.resetForm("form"); //搜索框 数据清空 this.queryParams = { deptName: undefined, deptStatus: ' ', }; }, /** 搜索按钮操作 */ handleQuery() { // this.getList(); //搜索功能没有做树形结构,按照普通结构来的 //先清空表格数据 this.deptList = undefined; axios({ method:"get", url:this.urls.listDept2, params: { deptName : this.queryParams.deptName, deptStatus : this.queryParams.deptStatus, } }).then(res => { this.deptList = res.data.data; } ); }, /** 重置按钮操作 */ resetQuery() { this.queryParams = { deptName: undefined, deptStatus: undefined, }; this.getList(); }, /** 新增 添加 按钮操作 */ handleAdd(row) { this.reset();//表单重置 //将 提交按钮 存的id清空了 this.submitId = undefined if (row != undefined) { // this.form.parentId = row.deptId; this.form.superiorId = row.id; } this.open = true; this.title = "添加部门"; }, /** 展开/折叠操作 */ toggleExpandAll() { this.refreshTable = false; this.isExpandAll = !this.isExpandAll; this.$nextTick(() => { this.refreshTable = true; }); }, /** 修改按钮操作 */ handleUpdate(row) { // this.reset(); this.submitId = row.id; //先拿着部门id去查询出来这条数据,并连带这将他的负责人信息查询出来,再把数据赋给form axios({ method:"get", url:this.urls.selectDeptById, params: { id : row.id, } }).then(res => { //查询成功后复制给 修改弹框 this.form = res.data.data; } ); this.open = true; this.title = "修改部门"; }, /** 提交按钮 */ submitForm: function() { this.$refs["form"].validate(valid => { if (valid) { if (this.submitId != undefined) {//是修改,不是添加 axios({ method:"post", url:this.urls.updateDept, data: { id:this.submitId, deptName:this.form.deptName, leaderId:this.form.leaderId, // 修改的状态怎么 单选框? deptStatus:this.form.deptStatus, superiorId:this.form.superiorId, ancestors:this.form.ancestors, orderNum:this.form.orderNum, } }).then(res => { this.$message({ type: 'success', message: '修改成功!' }); this.open = false; this.getList(); } ); } else {//添加 axios({ method:"post", url:this.urls.addDept, data: { deptName:this.form.deptName, //负责人id???直接从查询的数据中取 leaderId:this.form.leaderId, deptStatus:this.form.deptStatus, superiorId:this.form.superiorId, ancestors:this.form.ancestors, orderNum:this.form.orderNum, } }).then(res => { this.$message({ type: 'success', message: '添加成功!' }); this.open = false; this.getList(); } ); } } }); }, /** 删除按钮操作 */ handleDelete(row) { this.$confirm('是否删除选中的所有部门?删除后无法恢复!', '提示', { confirmButtonText: '确定', cancelButtonText: '取消', type: 'warning' }).then(() => { axios({ method:"get", url:this.urls.delDept, params: { id : row.id, } }).then(res => { if(res.data.deptStatus===0){ this.getList(); this.$message({ type: 'success', message: '删除成功!' }); }else{ this.$message({ type: 'error', message: res.data.msg }); } } ); }).catch(() => {}); }, //时间解析 parseTime(time, pattern) { if (arguments.length === 0 || !time) { return null } const format = pattern || '{y}-{m}-{d} {h}:{i}:{s}' let date if (typeof time === 'object') { date = time } else { if ((typeof time === 'string') && (/^[0-9]+$/.test(time))) { time = parseInt(time) } else if (typeof time === 'string') { time = time.replace(new RegExp(/-/gm), '/').replace('T', ' ').replace(new RegExp(/\.[\d]{3}/gm), ''); } if ((typeof time === 'number') && (time.toString().length === 10)) { time = time * 1000 } date = new Date(time) } const formatObj = { y: date.getFullYear(), m: date.getMonth() + 1, d: date.getDate(), h: date.getHours(), i: date.getMinutes(), s: date.getSeconds(), a: date.getDay() } const time_str = format.replace(/{(y|m|d|h|i|s|a)+}/g, (result, key) => { let value = formatObj[key] // Note: getDay() returns 0 on Sunday if (key === 'a') { return ['日', '一', '二', '三', '四', '五', '六'][value] } if (result.length > 0 && value < 10) { value = '0' + value } return value || 0 }) return time_str }, } }; </script>
复制