$("#lxchtj-totalSum1").datagrid({
url: 'chtj/getxhchtjList',
loadMsg: '数据加载中,请稍后...',
showFooter: true,
fit: true,
toolbar:'#lxchtj-totalSum-toolbar',
columns: [[
{ field: 'recordid', align: 'center', title: '票号', width: 160, },
{ field: 'chrq', align: 'center', title: '出货日期', width: 160, },
{ field: 'zhxh', align: 'center', title: '货号', width: 160, },
{ field: 'gg', align: 'center', title: '规格', width: 160, },
{ field: 'sl', align: 'center', title: '数量', width: 160, sum: 'true',},
/* { field: 'price', align: 'center', title: '单价', width: 160, sum: 'true',},
{ field: 'fdl', align: 'center', title: '浮动率', width: 160, }, */
{ field: 'je', align: 'center', title: '金额', width: 160, sum: 'true', },
]],
onLoadSuccess: function (data) {
$('#lxchtj-totalSum').datagrid('statistics');
//合计
},
{
statistics: function (jq) {
var opt = $(jq).datagrid('options').columns;
var rows = $(jq).datagrid("getRows");
var footer = new Array();
footer['sum'] = "";
for (var i = 0; i < opt[0].length; i++) {
if (opt[0][i].sum) {
footer['sum'] = footer['sum'] + sum(opt[0][i].field, 1) + ',';
}
}
var footerObj = new Array();
if (footer['sum'] != "") {
var tmp = '{' + footer['sum'].substring(0, footer['sum'].length - 1) + "}";
var obj = eval('(' + tmp + ')');
if (obj[opt[0][0].field] == undefined) {
footer['sum'] += '"' + opt[0][0].field + '":"<b>合计:</b>"';
//第0列显示为合计
obj = eval('({' + footer['sum'] + '})');
}
else {
obj[opt[0][0].field] = "<b>合计:</b>" + obj[opt[0][0].field];
}
footerObj.push(obj);
}
if (footerObj.length > 0) { $(jq).datagrid('reloadFooter', footerObj); }
function sum(filed) {
var sumNum = 0;
var str = "";
for (var i = 0; i < rows.length; i++) {
var num = rows[i][filed];
sumNum += Number(num);
}
return '"' + filed + '":"' + sumNum.toFixed(2) + '"';
}
}
});
url: 'chtj/getxhchtjList',
loadMsg: '数据加载中,请稍后...',
showFooter: true,
fit: true,
toolbar:'#lxchtj-totalSum-toolbar',
columns: [[
{ field: 'recordid', align: 'center', title: '票号', width: 160, },
{ field: 'chrq', align: 'center', title: '出货日期', width: 160, },
{ field: 'zhxh', align: 'center', title: '货号', width: 160, },
{ field: 'gg', align: 'center', title: '规格', width: 160, },
{ field: 'sl', align: 'center', title: '数量', width: 160, sum: 'true',},
/* { field: 'price', align: 'center', title: '单价', width: 160, sum: 'true',},
{ field: 'fdl', align: 'center', title: '浮动率', width: 160, }, */
{ field: 'je', align: 'center', title: '金额', width: 160, sum: 'true', },
]],
onLoadSuccess: function (data) {
$('#lxchtj-totalSum').datagrid('statistics');
//合计
},
});
/*扩展方法*/
$.extend($.fn.datagrid.methods,{
statistics: function (jq) {
var opt = $(jq).datagrid('options').columns;
var rows = $(jq).datagrid("getRows");
var footer = new Array();
footer['sum'] = "";
for (var i = 0; i < opt[0].length; i++) {
if (opt[0][i].sum) {
footer['sum'] = footer['sum'] + sum(opt[0][i].field, 1) + ',';
}
}
var footerObj = new Array();
if (footer['sum'] != "") {
var tmp = '{' + footer['sum'].substring(0, footer['sum'].length - 1) + "}";
var obj = eval('(' + tmp + ')');
if (obj[opt[0][0].field] == undefined) {
footer['sum'] += '"' + opt[0][0].field + '":"<b>合计:</b>"';
//第0列显示为合计
obj = eval('({' + footer['sum'] + '})');
}
else {
obj[opt[0][0].field] = "<b>合计:</b>" + obj[opt[0][0].field];
}
footerObj.push(obj);
}
if (footerObj.length > 0) { $(jq).datagrid('reloadFooter', footerObj); }
function sum(filed) {
var sumNum = 0;
var str = "";
for (var i = 0; i < rows.length; i++) {
var num = rows[i][filed];
sumNum += Number(num);
}
return '"' + filed + '":"' + sumNum.toFixed(2) + '"';
}
}
});