CanEditGrid

一款可编辑表格,可以自定义表格内容和格式,表格中有常用的input,select,datePIcker,selectTree等,可以拖拽表格,类似于excel拖拽赋值的功能,并对表格进行实时校验。 An editable table, you can customize the table content and format, the table has commonly used input, select, datePIcker, selectTree, and so on, you can drag and drop the table, similar to excel drag and drop the function of value assignment, and the table for real-time verification

137
16
Vue

启动

1、使用此组件
npm install can-edit-table
2、启动项目
npm install
vue serve

项目概览

图片名称
基于vue和element的可拖拽赋值的可编辑表格,支持表格实时校验,联动校验。
图片名称
支持input、datepicker、select、selctTree等等。可以自定义td的内容,支持slot插槽。

图片名称

图片名称
支持拖拽赋值,类似于excel的拖拽赋值功能

图片名称
支持表格的实时校验

组件的使用

组件下载

npm install can-edit-table

引用组件

import CanEditTable from "can-edit-table"

注册组件

components: {editTable},

组件demo

https://github.com/zhjing1019/canEditDemo.git

组件源码

https://github.com/zhjing1019/CanEditGrid

1、组件

<can-edit-table
      ref="empTable1"
      :headers="empEditData.headers"
      :data.sync="empEditData.data"
      @change="change"
      :isAdd="true"
      :fixCols="empEditData.fixCols"
      :tableHeaderHeight="empEditData.tableHeaderHeight"
      :tableTdHeight="empEditData.tableTdHeight"
      :editTable="empEditData.editTable"
      @data-change="dataChange"
      @editDragEnd="editDragEnd"
      style="height: 400px; width: 100%"
    >
</can-edit-table>

2、表头的数据

[
    {
      name: "zzry",
      title: "测试1",
      width: 350,
      slot: true
    },
    {
      name: "zzsj",
      width: 200,
      title: "测试时间",
      editType: "date"
    },
    {
      name: "sfz",
      width: 200,
      title: "身份证(slot内容、自定义校验规则)",
      slot: true
    },
    {
      name: "zzlb",
      width: 200,
      title: "测试类别",
      editType: "select",
      label: "code",
      value: "id",
      list: [
        {
          code: "测试code1",
          id: "1"
        },
        {
          code: "测试code2",
          id: "2"
        },
        {
          code: "测试code3",
          id: "3"
        },
        {
          code: "测试code4",
          id: "4"
        }
      ]
    },
    {
      name: "khqk",
      width: 200,
      title: "测试(只展示数据)",
      editType: "none"
    },
    {
      name: "zzsm",
      title: "测试三",
      width: 200,
      editType: "input"
    }
  ]

4、data数据

data: [
    {
      zzry: {
        name: "测试",
        sex: "男",
        bus: "测试部门",
        pos: "测试",
        emp: "测试",
        auth: "测试",
        num: "测试"
      },
      zzsj: "",
      zzlb: "",
      khqk: "测试",
      zzsm: "测试",
      sfz: ""
    },
    {
      zzry: {
        name: "测试",
        sex: "测试",
        bus: "测试",
        pos: "测试",
        emp: "测试",
        auth: "测试",
        num: "测试"
      },
      zzsj: "",
      zzlb: "",
      khqk: "测试",
      zzsm: "测试",
      sfz: ""
    }
  ]

5、校验规则

editTable: {
    rules: {
      input: [
        { required: true, message: "请输入活动名称ceshi", trigger: "change" },
        { min: 1, max: 3, message: "长度在 1 到 3 个字符", trigger: "change" }
      ],
      newPost: [
        { required: true, message: "请输入活动名称", trigger: "change" },
        { min: 1, max: 5, message: "长度在 1 到 5 个字符", trigger: "change" }
      ],
      time: {
        type: "date",
        required: true,
        message: "请选择日期",
        trigger: "change"
      },
      newDepartment: [{ required: true, message: "请选择部门", trigger: "change" }],
      treeSelect: [{ required: true, message: "请选择部门", trigger: "change" }],
      timeRange: [{ type: "date", required: true, message: "请选择时间", trigger: "change" }],
      dateMonth: [{ type: "date", required: true, message: "请选择时间", trigger: "change" }],
      dateYear: [{ type: "date", required: true, message: "请选择时间", trigger: "change" }],
      dateMonthRange: [{ type: "date", required: true, message: "请选择时间", trigger: "change" }],
      inputNumber: [{ type: "number", required: true, message: "请输入数字输入框", trigger: "change" }],
      inputNumber1: [{ type: "number", required: true, message: "请输入数字输入框", trigger: "change" }],
      selectPerson1: [{ type: "string", required: true, message: "请选择人", trigger: "change" }],
      select: [{ type: "string", required: true, message: "请选择code", trigger: "change" }]
    }
  }

6、表头配置

1、width, 表示此列的宽度
2、name,表示此列的id
3、title, 表示此列的字段名
4、slot, 表示此列是否自定义
5、editType, 表示此列的编辑类型(
1、editType = “treeSelect” 选择机构树

    {
      name: "treeSelect",
      title: "选择树机构",
      width: 200,
      // slot: true,
      editType: "treeSelect",
      disabled: false,
      treeParams: {
        clickParent: true,
        filterable: false,
        "check-strictly": true,
        "default-expand-all": false,
        "expand-on-click-node": false,
        data: [
          {
            id: "1",
            name: "哎哎哎",
            children: [{ id: "3", name: "啊啊啊啊" }]
          },
          {
            id: "2",
            name: "发生的"
          }
        ],
        props: {
          children: "children",
          label: "name",
          value: "id"
        }
      },
      selectParams: {
        multiple: false,
        clearable: true,
        placeholder: "请输入内容"
      },
      list: []
    },
2、editType: "input", input输入框 
3、editType: "select", select选择框 
{
      name: "select",
      title: "select选择框",
      width: 100,
      multiple: true,
      editType: "select",
      label: "code",
      value: "id",
      list: [
        {
          code: "测试code1",
          id: "1"
        },
        {
          code: "测试code2",
          id: "2"
        },
        {
          code: "测试code3",
          id: "3"
        },
        {
          code: "测试code4",
          id: "4"
        }
      ]
    },
4、editType: "date",年月日时间选择框 
5、editType: "dateRange",年月日时间范围 
6、editType: "none",显示文本值 

7、自定义表格

<template slot="zzry" slot-scope="field" class="fl-td">
        <div class="zzry-detail">
          <div class="zzry-p">
            <p class="zzry-first-p">
              {{ `${field.field.rowData.zzry.name || 
              ''} (${field.field.rowData.zzry.num || 
              ''}) ${field.field.rowData.zzry.sex || 
              ''}` }}
            </p>
            <p>
              {{
                `${field.field.rowData.zzry.bus || 
              ''}_${field.field.rowData.zzry.emp || 
              ''}_${field.field.rowData.zzry.pos}_${
                  field.field.rowData.zzry.auth || 
              ''
                }`
              }}
            </p>
          </div>
        </div>
</template>
<template slot="fixedCol" slot-scope="field" class="fl-td">
        <div>
          <span>自定义插槽</span>
          <div>{{ field.field.rowData[field.field.field.name] }}</div>
          <div>可自定义td</div>
        </div>
</template>
<template slot="selectPerson" slot-scope="field" class="fl-td">
        <div>
          {{ field.field.rowData[field.field.field.name] }}
        </div>
</template>

1、slot与表头的name字段对应
2、slot-scope=“field”
field.field.rowData 从底层传出的rowData,当前行的数据
field.field.field 从底层传出的field,当前行的数据的表头字段
field.field.colIndex 从底层传出的colIndex,当前行的数据的列数
field.field.rowIndex 从底层传出的rowIndex,当前行的数据的行数

8、表格触发的事件

change:数据发生改变时触发
data-change:可编辑表格中td发生变化时触发的事件(slot的td除外)
editDragEnd:拖拽赋值结束后触发的事件(currentColIndex, selectArr, name, value,返回四个数据,)

this.$refs[ref].submitForm():提交表单

this.$refs[ref].clearAll():清空表格

this.$refs[ref].resetAll():重置表格

如果有任何问题可以关注我的个人技术公众号javascript艺术,或者添加我微信反馈
image
image