vue+Element-ui实现树形组件、表格树
需求
要做出如下图所示的 树形表格,也就是数据之间有父子类关系的这种,可以点击展开、收缩
像上图这样的表格树
实现
1.使用树形组件
在学习树形表格之前,肯定得先搞懂普通的树形组件是怎么搞的,然后将其套到表格中就好了,请参考ElementUI官方文档中的使用方法
链接:组件 | Element
基础用法展示
也就是数据中要有 children 作为树形组件中的 子数据
学会使用普通的树形结构之后,我们再来看 怎么使用树形的表格
2.使用树形表格
在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>
这篇好文章是转载于:学新通技术网
- 版权申明: 本站部分内容来自互联网,仅供学习及演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,请提供相关证据及您的身份证明,我们将在收到邮件后48小时内删除。
- 本站站名: 学新通技术网
- 本文地址: /boutique/detail/tanhggaiff
系列文章
更多
同类精品
更多
-
photoshop保存的图片太大微信发不了怎么办
PHP中文网 06-15 -
《学习通》视频自动暂停处理方法
HelloWorld317 07-05 -
word里面弄一个表格后上面的标题会跑到下面怎么办
PHP中文网 06-20 -
Android 11 保存文件到外部存储,并分享文件
Luke 10-12 -
photoshop扩展功能面板显示灰色怎么办
PHP中文网 06-14 -
微信公众号没有声音提示怎么办
PHP中文网 03-31 -
excel下划线不显示怎么办
PHP中文网 06-23 -
excel打印预览压线压字怎么办
PHP中文网 06-22 -
TikTok加速器哪个好免费的TK加速器推荐
TK小达人 10-01 -
怎样阻止微信小程序自动打开
PHP中文网 06-13