热门标签
热门文章
- 1L2-022 重排链表 (25分)_给定一个单链表 l 1 →l 2 → →l n 1 →l n ,请编写程序将链表重新排列为
- 2深度学习如何入门？
- 30基础跨考408｜一战上岸复盘及经验分享
- 4unable to access android sdk add-on list_unableto accessandroid sdk
- 5Android Studio启动虚拟机时一直提示安装Haxm_install haxm
- 6使用MySQL now函数的坑
- 7MCU_STM32的位带操作 -- bit banding_mcu中bit-band
- 8Mac 上搭建aarch64交叉编译环境_mac graal error: native toolchain (x86_64) amd64.a
- 9 angular 全局监听键盘事件
- 10IOS人脸识别开发入门教程--人脸检测篇_didoutputsamplebuffer
当前位置: article > 正文
【表格单元格可编辑】vue-elementul简单实现table表格点击单元格可编辑，点击单元格变成输入框修改数据_cell-click
作者：繁依Fanyi0 | 2024-03-06 20:01:15
赞
踩
cell-click
前言
这是最近遇到的功能，经常会需要一个表格可以编辑数据
类似于excel那种点击一下单元格就可以编辑数据，修改后鼠标移动出去
光标消失就会保存数据给后台
这里记录一下实现方法，其实也比较简单
就是通过角标来判断显示隐藏的
点击单元格出现弹框修改数据版本
这里考虑到有些时候可能想要点击单元格不只修改一个数据，可能是一个多个数据都需要修改。
这时候只能用表单了，所以这里输入框就有限制不好用了。我就又写了个模板，是点击单元格后出现弹框的，内部可以表单修改
点击这里跳转
效果图
代码
我这里是用的html的形式，引入了vue的语法使用的
各位自行在自己的代码中套用。和vue写法一样
然后核心就是注意那个@cell-click=‘getCell’ :cell-class-name=‘getRowColumn’
这两个方法解释：
cell-class-name：其实就是通过创建table时触发的把角标赋值给行和列方便后面使用
cell-click：就是点击单元格时触发的事件，可以通过这个拿到角标
然后我们通过点击v-if判断当前单元格位置的角标和我们点击的角标一致就显示不然就隐藏
这就实现了切换输入框的功能，然后给文字div加个点击事件，方便我们获取到数据，用于判断需要调用新增还是修改方法
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<!-- 公共css文件 -->
<link rel="stylesheet" href="/statics/css/common/common.css">
<!-- 公共js文件 -->
<script type="text/javascript" src="/statics/vue_element/common.js"></script>
<!-- vue方面文件 -->
<link rel="stylesheet" href="/statics/vue_element/element.css">
<script src="/statics/vue_element/vue.js"></script>
<script src="/statics/vue_element/element.js"></script>
<script src="/statics/vue_element/axios.js"></script>
<title>表格单元格输入框修改</title>
</head>
<body>
<div id="app" v-cloak>
<!-- 搜索栏 -->
<div class="search_main">
<div class="ibox-search" ref="menus">
<el-form :inline="true" class="form-inline">
<el-form-item label="排班日期">
<el-date-picker v-model="time" size="small" type="month" placeholder="选择日期"
value-format="yyyy-MM" clearable id="month1" class="ywidth">
</el-date-picker>
</el-form-item>
<el-form-item>
<el-button size="small" @click="search" type="primary">查询</el-button>
</el-form-item>
</el-form>
</div>
</div>
<!-- 内容栏 -->
<div class="layout-main">
<div class="ibox-search">
<!-- 循环表头 -->
<el-table :data="tableData" border style="width: 100%" v-loading="loadings" :height="height" ref="table"
@cell-click='getCell' :cell-class-name='getRowColumn'>
<el-table-column v-for="(arrd,index) in headered" :fixed="arrd.fixed" :key="index"
:label="arrd.name" align="center" show-overflow-tooltip :prop="arrd.key"
:width="arrd.key=='ks'||arrd.key=='doctor'?'100px':''">
<template slot-scope='scope'>
<!-- 列不等于科室和医生的才有输入框 -->
<div v-if="arrd.key!=='ks'&&arrd.key!=='doctor'">
<el-input v-model='scope.row[arrd.key]'
v-if='scope.row.index == tabRowIndex && scope.column.index == tabColumnIndex'
@blur='inputBlur' size="mini" v-focus></el-input>
<div v-else style="cursor: pointer;" @click="inputType(scope.row[arrd.key])">
{{scope.row[arrd.key]}}</div>
</div>
<div v-else>
{{scope.row[arrd.key]}}
</div>
</template>
</el-table-column>
</el-table>
<!-- 分页 -->
<div class="list-footer" ref="footer">
<div class="foot-bg">
</div>
<div class="block page_r">
<el-pagination @size-change="handleSizeChange" @current-change="handleCurrentChange"
:current-page="currentPage" :page-sizes="[10, 30, 50, 100]" :page-size="pagesize"
layout="total, sizes, prev, pager, next, jumper" :total="count">
</el-pagination>
</div>
</div>
</div>
</div>
</div>
</body>
<script>
new Vue({
el: '#app',
directives: {
//注册一个局部的自定义指令 v-focus，输入框自动聚焦
focus: {
inserted: function (el) {
el.querySelector('input').focus()
}
}
},
data() {
return {
time: '', //日期
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
}], //表格数据
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"
}
],
loadings: false, //表格加载
height: null, //表格高度
// 分页部分
currentPage: 1,
pagesize: 10,
count: 0,
//表单验证
value: '', //区分新增和修改
tabRowIndex: null, //行角标
tabColumnIndex: '', //列角标
}
},
mounted() {
let that = this
that.initTableHeight() //初始化 表格高度
window.addEventListener('resize', this.initTableHeight) //动态表格高度监听
that.time = timer.benyuefen() //初始化默认获取本月日期，不含日
//that.searchList() //初始化表格数据获取
},
methods: {
// 保存数据区分新增和修改
inputType(num) {
this.value = num
},
// 获取点击的单元格角标位置
getCell(row, column, cell, event) {
this.tabRowIndex = row.index
this.tabColumnIndex = column.index
},
// 把角标赋值给行和列，上面才可以直接拿到点击位置的坐标
getRowColumn({
row,
column,
rowIndex,
columnIndex
}) {
row.index = rowIndex
column.index = columnIndex
},
// 失去光标
inputBlur() {
// 把输入框隐藏
this.tabRowIndex = null
this.tabColumnIndex = ''
// 发请求把修改的数据发送给后台
// this.subForm()
},
// 表格高度
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
axios.get(apiadmin_url + `zkjk_doctor_limit?month=${that.time}`, {
headers: {
token: session_token,
hosId: userinfo.hospital_id,
}
}).then(res => {
console.log(res, 'res');
this.headered = res.data.data.header
this.tableData = res.data.data.data
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
console.log(this.time, '时间');
that.searchList()
},
// 分页
handleSizeChange(val) {
let that = this
that.pagesize = val;
that.searchList()
},
// 分页
handleCurrentChange(val) {
let that = this
that.currentPage = val;
that.searchList()
},
// 弹框内提交
subForm() {
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 => {})
}
},
}
})
</script>
</html>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
- 203
- 204
- 205
- 206
- 207
- 208
- 209
- 210
- 211
- 212
- 213
- 214
- 215
- 216
- 217
- 218
- 219
- 220
- 221
- 222
- 223
- 224
- 225
- 226
- 227
- 228
- 229
- 230
- 231
- 232
- 233
- 234
- 235
- 236
- 237
- 238
- 239
- 240
- 241
- 242
- 243
- 244
- 245
- 246
- 247
- 248
- 249
- 250
- 251
- 252
- 253
- 254
- 255
- 256
- 257
- 258
- 259
- 260
- 261
- 262
- 263
- 264
- 265
- 266
- 267
- 268
- 269
- 270
- 271
- 272
- 273
- 274
- 275
- 276
- 277
- 278
- 279
- 280
- 281
- 282
- 283
- 284
- 285
- 286
- 287
- 288
- 289
- 290
- 291
- 292
- 293
- 294
- 295
- 296
- 297
- 298
- 299
- 300
- 301
- 302
- 303
- 304
- 305
- 306
- 307
- 308
- 309
- 310
- 311
- 312
- 313
- 314
- 315
- 316
- 317
- 318
- 319
- 320
- 321
- 322
- 323
- 324
- 325
- 326
- 327
- 328
- 329
- 330
- 331
- 332
- 333
- 334
- 335
- 336
- 337
- 338
- 339
- 340
- 341
- 342
- 343
- 344
- 345
- 346
- 347
- 348
- 349
- 350
- 351
- 352
- 353
- 354
- 355
- 356
- 357
- 358
- 359
- 360
- 361
- 362
- 363
- 364
- 365
- 366
- 367
- 368
- 369
- 370
- 371
- 372
- 373
- 374
- 375
- 376
- 377
- 378
- 379
- 380
- 381
- 382
- 383
- 384
- 385
- 386
- 387
- 388
- 389
- 390
- 391
- 392
- 393
- 394
- 395
- 396
- 397
- 398
- 399
- 400
- 401
- 402
- 403
- 404
- 405
- 406
- 407
- 408
- 409
- 410
- 411
- 412
- 413
- 414
- 415
- 416
- 417
- 418
- 419
- 420
- 421
- 422
- 423
- 424
- 425
- 426
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/繁依Fanyi0/article/detail/201216
推荐阅读
相关标签
