bootstrap-table:
表头属性增加:
showFooter: true,//合计
列属性增加:
//SettlementAmount_yuan 为需要格式化的字段名称
footerFormatter: function (value) {
var count = 0;
for (var i in value) { count += parseFloat(value[i].SettlementAmount_yuan || 0); }
return ys.formatCNY(count);
}
layui:
table.render({
elem: '#test'
,url:'/test/table/demo1.json'
,toolbar: '#toolbarDemo'
,title: '用户数据表'
,totalRow: true //开启合计行
,cols: [[
{type: 'checkbox', fixed: 'left'}
,{field:'id', title:'ID', width:80, fixed: 'left', unresize: true, sort: true, totalRowText: '合计'/*设置合计行文本*/}
,{field:'username', title:'用户名', width:120, edit: 'text'}
,{field:'email', title:'邮箱', width:150, edit: 'text', templet: function(res){
return '<em>'+ res.email +'</em>'
}}
,{field:'experience', title:'积分', width:80, sort: true, totalRow: true /*列属性中开启合计行*/}
,{field:'sex', title:'性别', width:80, edit: 'text', sort: true}
,{field:'logins', title:'登入次数', width:100, sort: true, totalRow: true}
,{field:'sign', title:'签名'}
,{field:'city', title:'城市', width:100}
,{field:'ip', title:'IP', width:120}
,{field:'joinTime', title:'加入时间', width:120}
,{fixed: 'right', title:'操作', toolbar: '#barDemo', width:150}
]]
,page: true
});