62,067
社区成员
发帖
与我相关
我的任务
分享
<body>
<div style="">
<table id="table_showMembers"></table>
</div>
</body>
<script type="text/javascript" src="js/jquery-3.3.1.js" ></script>
<script type="text/javascript" src="js/bootstrap.js"></script>
<script type="text/javascript" src="js/bootstrap-table.js" ></script>
<script type="text/javascript" src="js/bootstrap-table-zh-CN.js" ></script>
<script type="text/javascript">
$(function () {
initData();
});
function initData() {
$(function () {
var table_showMembers = $('#table_showMembers').bootstrapTable({
url: 'data.ashx',//后台调用时,不行
//data: data.rows, //测试时,在这里写死数据可以
method: 'get',
toolbar: '#toolbar',
striped: true,
cache: false,
pagination: true,
sortable: false,
sortOrder: "asc",
queryParams: function (params) {
return {
startIndex: params.offset,
pageSize: params.limit
};
},
sidePagination: "server",
pageNumber: 1,
pageSize: 10,
pageList: [2, 4, 6, 8],
// search: true,
contentType: "application/x-www-form-urlencoded",
strictSearch: true,
//showColumns: true,
//showRefresh: true,
minimumCountColumns: 2,
clickToSelect: true,
//height: 700,
width: '50%',
uniqueId: "id",
//showToggle: true,
cardView: false,
detailView: false,
checkboxHeader: true,
singleSelect: false,
showFooter: true,
columns: [
{
field: 'openDate',
title: 'openDate',
valign: 'middle',
align: 'center',
visible: true,
width: '100px'
},
{
field: 'balance',
title: 'balance',
align: 'center',
width: '150px',
formatter: function (value, row, index) {
//有值
},
footerFormatter: function (rows) {//是空的
var sum = 0;
for (var i = 0; i < rows.length; i++) {
sum += rows[i].hasWorkedHours
}
return sum + "H";
}
}
]
});
});
}
</script>
{
"total": 2,
"rows": [
{
"ROWNUM": "1",
"cardID": "1010 3576 1212 1134",
"openDate": "2018/10/13 23:17:00",
"balance": "5704.0000"
},
{
"ROWNUM": "2",
"cardID": "1010 3576 1212 8135",
"openDate": "2018/10/13 23:17:00",
"balance": "3633.0000"
}
]
}
footerFormatter: function (rows) {
//alert(rows.length);
if (rows.length > 0) {
debugger
alert(rows[1].balance)
; }
var sum = 0;
for (var i = 0; i < rows.length; i++) {
sum += rows[i].balance
}
return sum + "H";
//return rows.length;
}