首页 前端知识 vue Element-ui实现树形组件、表格树

vue Element-ui实现树形组件、表格树

2024-06-24 23:06:31 前端知识 前端哥 305 895 我要收藏

需求

要做出如下图所示的 树形表格,也就是数据之间有父子类关系的这种,可以点击展开、收缩

像上图这样的表格树

 

实现

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>

转载请注明出处或者链接地址:https://www.qianduange.cn//article/13480.html
标签
评论
发布的文章
大家推荐的文章
会员中心 联系我 留言建议 回顶部
复制成功!