layui数据表格编辑后更新合计的值
layui数据表格开启编辑后，修改表格的值往往合计不能自动更新，这里通过循环数据表格进行更新合计的值//监听单元格编辑
table.on('edit(test)', function(obj){
let data = obj.data;//得到所在行所有键值
let field = obj.field; //得到字段
//计算合计公时与总工资
let table_data =table.cache["test"];//得到数据表格
let totalWorkingHours = 0;//合计总工时
let totalwages = 0;//合计工资
for (let i = 0; i < table_data.length; i++) {
if(isNumber(table_data['workingHours'])){
totalWorkingHours += parseFloat(table_data['workingHours']);
}
if(table_data['wages'] != '0.00'){
totalwages += parseFloat(table_data['wages']);
}
}
$('.layui-table-total td .layui-table-cell').text(totalwages);
$('.layui-table-total td .layui-table-cell').text(totalWorkingHours);
}
});
页:
[1]