【表格单元格可编辑】vue-elementul简单实现table表格点击单元格可编辑，点击单元格变成弹框修改数据

前言

这是继我另一个帖子就是单元格点击变成输入框后添加的功能

因为考虑到有些时候修改单元格的信息可能点击后要修改很多，那一个输入框不好用

所以这时候就需要一个弹框可以把所有表单都显示出来修改

所以这里就专门又写了一个demo，用于处理这种情况

如果需要看表格单元格点击后变成输入框，然后焦点消失后直接更改的模板，可以点击这个帖子

链接在这：点击单元格变输入框

效果图

列表展示，点击单元格可以弹出弹框，内部是当前单元格的行和列的数据

代码

功能实现的几个点解释一下。

1，获取到行和列的数据主要是cellClick和tableCellClassName方法

这里我是用的人名和日期来返回给后端修改数据的。

如果你们需要拿到当前行的id之类的。

就自行更改一下就可以了。行的数据和列的数据都有的

2，注意一下，这里表格上面是需要放prop的。

我这里:prop=”arrd.key”就是把每个列的字段名存起来。

如果不写这个，那么你就拿不到当前列的字段名了。当然如果你不需要返回这个字段名那就无所谓

    
    
    
    
    
    
    
    
    
    
    



    
        
        
            
                
                    
                        
                        
                    
                    
                        查询
                    
                
            
        
        
        
            
                
                
                    
                        
                            
                                {{row[arrd.key]}}
                            
                            
                                {{row[arrd.key]}}
                            
                        
                    
                
                
                
                    
                    
                    
                        
                        
                    
                
            
        
        
        
            
                
                    {{nickName}}
                
                
                    {{tableTimer}}
                
                
                    
                
            
            
                保存
            
        
    


    new Vue({
        el: '#app',
        data() {
            return {
                time: '', //日期
                tableData: [], //表格数据
                headered: [],
                loadings: false,
                height: null,
                // 分页部分
                currentPage: 1,
                pagesize: 10,
                count: 0,
                // 弹框title
                name: '',
                // 弹框显示隐藏
                dialogVisible: false,
                // 弹框内数据
                ruleForm: {
                    show_num: '', //输入框
                },
                qd_options: [], //弹框内下拉框
                //表单验证
                value: '', //
                nickName: '', //医生名
                tableTimer: '' //当前列名称
            }
        },
        mounted() {
            let that = this
            that.initTableHeight() //初始化 表格高度
            window.addEventListener('resize', this.initTableHeight) //动态表格高度监听
            that.time = timer.benyuefen() //初始化默认获取本月日期，不含日
            that.searchList() //初始化表格数据获取
        },
        methods: {
            // 给行和列赋值
            tableCellClassName({
                row,
                column,
                rowIndex,
                columnIndex
            }) {
                //注意这里是解构
                //利用单元格的 className 的回调方法，给行列索引赋值
                row.index = rowIndex;
                column.index = columnIndex;
            },
            // 拿到行和列对应的值
            cellClick(row, index) {
                if (index.property == 'ks' || index.property == 'doctor') {
                    return
                }
                this.dialogVisible = true
                this.tableTimer = index.label //当前单元格的列名称
                this.ruleForm.show_num = row[index.property] //当前单元格的值
                this.nickName = row.doctor //当前行的医生
                this.value = row[index.property]
                console.log('点击后获取的数据:','行：',row, '列：',index);
            },
            // 表格高度
            initTableHeight() {
                let that = this
                var menus = that.$refs.menus.offsetHeight //搜索栏高度
                var footer = that.$refs.footer.offsetHeight //分页高度
                that.height = window.innerHeight - menus - footer - 25 + 'px'
            },
            // 获取表格数据
            searchList() {
                let that = this
                // that.loadings = true
                // 模拟数据
                this.headered = [{
                            "key": "ks",
                            "name": "科室"
                        },
                        {
                            "key": "doctor",
                            "name": "专家"
                        },
                        {
                            "key": "num1",
                            "name": "2023-02-01"
                        },
                        {
                            "key": "num2",
                            "name": "2023-02-02"
                        },
                        {
                            "key": "num3",
                            "name": "2023-02-03"
                        },
                        {
                            "key": "num4",
                            "name": "2023-02-04"
                        },
                        {
                            "key": "num5",
                            "name": "2023-02-05"
                        },
                        {
                            "key": "num6",
                            "name": "2023-02-06"
                        },
                        {
                            "key": "num7",
                            "name": "2023-02-07"
                        },
                        {
                            "key": "num8",
                            "name": "2023-02-08"
                        },
                        {
                            "key": "num9",
                            "name": "2023-02-09"
                        },
                        {
                            "key": "num10",
                            "name": "2023-02-10"
                        },
                        {
                            "key": "num11",
                            "name": "2023-02-11"
                        },
                        {
                            "key": "num12",
                            "name": "2023-02-12"
                        },
                        {
                            "key": "num13",
                            "name": "2023-02-13"
                        },
                        {
                            "key": "num14",
                            "name": "2023-02-14"
                        },
                        {
                            "key": "num15",
                            "name": "2023-02-15"
                        },
                        {
                            "key": "num16",
                            "name": "2023-02-16"
                        },
                        {
                            "key": "num17",
                            "name": "2023-02-17"
                        },
                        {
                            "key": "num18",
                            "name": "2023-02-18"
                        },
                        {
                            "key": "num19",
                            "name": "2023-02-19"
                        },
                        {
                            "key": "num20",
                            "name": "2023-02-20"
                        },
                        {
                            "key": "num21",
                            "name": "2023-02-21"
                        },
                        {
                            "key": "num22",
                            "name": "2023-02-22"
                        },
                        {
                            "key": "num23",
                            "name": "2023-02-23"
                        },
                        {
                            "key": "num24",
                            "name": "2023-02-24"
                        },
                        {
                            "key": "num25",
                            "name": "2023-02-25"
                        },
                        {
                            "key": "num26",
                            "name": "2023-02-26"
                        },
                        {
                            "key": "num27",
                            "name": "2023-02-27"
                        },
                        {
                            "key": "num28",
                            "name": "2023-02-28"
                        }
                    ]
                    this.tableData = [{
                            ks: "中医科",
                            doctor: "段占天",
                            num1: 0,
                            num2: 0,
                            num3: 0,
                            num4: 0,
                            num5: 0,
                            num6: 0,
                            num7: 0,
                            num8: 0,
                            num9: 0,
                            num10: 0,
                            num11: 0,
                            num12: 0,
                            num13: 0,
                            num14: 0,
                            num15: 0,
                            num16: 0,
                            num17: 0,
                            num18: 0,
                            num19: 0,
                            num20: 0,
                            num21: 0,
                            num22: 0,
                            num23: 0,
                            num24: 0,
                            num25: 0,
                            num26: 0,
                            num27: 0,
                            num28: 0,
                            index: 0
                        },
                        {
                            ks: "中医科",
                            doctor: "陈国",
                            num1: 0,
                            num2: 0,
                            num3: 0,
                            num4: 0,
                            num5: 0,
                            num6: 0,
                            num7: 0,
                            num8: 0,
                            num9: 0,
                            num10: 0,
                            num11: 0,
                            num12: 0,
                            num13: 0,
                            num14: 0,
                            num15: 0,
                            num16: 0,
                            num17: 0,
                            num18: 0,
                            num19: 0,
                            num20: 0,
                            num21: 0,
                            num22: 0,
                            num23: 0,
                            num24: 0,
                            num25: 0,
                            num26: 0,
                            num27: 0,
                            num28: 0,
                            index: 1
                        }
                    ]
                    return
                axios.get(apiadmin_url + `zkjk_doctor_limit?month=${that.time}`, {
                    headers: {
                        token: session_token,
                        hosId: userinfo.hospital_id,
                    }
                }).then(res => {
                    this.headered = res.data.data.header
                    this.tableData = res.data.data.data
                    // 根据ks字段排序
                    this.tableData.sort(function (a, b) {
                        return a.ks > b.ks ? 1 : -1
                    })
                    that.loadings = false
                }).catch(error => {})
            },
            // 搜索按钮
            search() {
                let that = this
                that.currentPage = 1
                that.searchList()
            },
            // 分页
            handleSizeChange(val) {
                let that = this
                that.pagesize = val;
                that.searchList()
            },
            // 分页
            handleCurrentChange(val) {
                let that = this
                that.currentPage = val;
                that.searchList()
            },
            // 弹框内提交
            subForm(formName) {
                let that = this
                if (this.value == 0) {
                    axios.post(apiadmin_url + "zkjk_doctor_limit", {
                        date: this.tableTimer,
                        doctor: this.nickName,
                        limit_num: this.ruleForm.show_num
                    }, {
                        headers: {
                            token: session_token,
                            hosId: userinfo.hospital_id,
                        }
                    }).then(response => {
                        if (response.data.code == 200) {
                            that.dialogVisible = false
                            this.$message({
                                showClose: true,
                                type: 'success',
                                message: response.data.message
                            });
                            that.search()
                        } else {
                            this.$message({
                                showClose: true,
                                message: response.data.message,
                                type: 'error'
                            });
                        }
                    }).catch(error => {})
                } else {
                    axios.put(apiadmin_url +
                        `zkjk_doctor_limit/1?date=${this.tableTimer}&doctor=${this.nickName}&limit_num=${this.ruleForm.show_num}`, {}, {
                            headers: {
                                token: session_token,
                                hosId: userinfo.hospital_id,
                            }
                        }).then(response => {
                        if (response.data.code == 200) {
                            that.dialogVisible = false
                            this.$message({
                                showClose: true,
                                type: 'success',
                                message: response.data.message
                            });
                            that.search()
                        } else {
                            this.$message({
                                showClose: true,
                                message: response.data.message,
                                type: 'error'
                            });
                        }
                    }).catch(error => {})
                }
            },
        }
    })