jqgrid-php - 当值已经链接时,如何对 JQgrid 页脚行的值求和
问题描述
我有这段代码需要显示几列的总和,JQgrid 在正常列值中工作正常。但是当该列值被链接时,它显示 Nan
grid.jqGrid({
data: mydata,
datatype: "local",
height: containerHeight,
width: containerWidth,
colNames:[
//'Region/Purchaser Name',
'Order No. / Invoice No.','PO No.','Ship To','Ship To Attention','Address','City','State / Zip','Requested Ship Date','Shipped Date','Total Qty Ordered','Shipped to WF','Open Qty'],
colModel:[
//{name:'REGION',index:'REGION', width:20},
{name:'DUMMYMACNO',index:'MACNO', width:19, align:"center"},
{name:'PONUM',index:'PONUM', width:17},
{name:'SHIPTO',index:'SHIPTO', width:17},
{name:'ATTN',index:'ATTN', width:19,align:"center",formatter:nullFormatter},
{name:'ADDRESS',index:'ADDRESS', width:19},
{name:'CITYJ1',index:'CITYJ1', width:10},
{name:'STZIP',index:'STZIP', width:10},
{name:'SDATE',index:'SDATE', width:10},
{name:'INVDATE',index:'INVDATE', width:10},
{name:'TQO',index:'TQO', width:4, align:"center"},
{name:'DQTY',index:'DQTY', width:5, search:false, align:"center", sorttype:"float", formatter:function(cellvalue, options, rowObject){return '<a href="#qtyShippedModal" id="'+rowObject['MACNO']+'" class="getQtyShippedSummary" data-toggle="modal">'+cellvalue+'</a>';},classes: 'blue-text'},
{name:'OQO',index:'OQO', width:6, search:false, align:"center", sorttype:"float", formatter:function(cellvalue, options, rowObject){return '<a href="#openQtyOrderedModal" id="'+rowObject['MACNO']+'" class="getOpenQtyOrderedSummary" data-toggle="modal">'+cellvalue+'</a>';}},
],
rowNum:100,
rowList : [100,150,200],
loadonce:true,
mtype: "GET",
casesensitive: true,
rownumbers: true,
rownumWidth: 40,
ignoreCase: true,
gridview: true,
pager: '#locationlistpagination',
sortname: 'SONO',
viewrecords: true,
loadComplete: function() {
$("tr.jqgrow:odd").addClass('jqgrow-alt-row');
},
sortorder: "asc",
footerrow: true,
gridComplete: function() {
var colsum = 0;
var colsum1 = 0;
var colSum2 = 'Total';
var colSum4 = 'Total';
var colSum = grid.jqGrid('getCol', 'DQTY', true, 'sum');
var colSum4 = grid.jqGrid('getCol', 'OQO', true, 'sum');
var colSum1 = grid.jqGrid('getCol', 'TQO', false, 'sum');
grid.jqGrid('footerData', 'set', { OQO: colSum });
grid.jqGrid('footerData', 'set', { DQTY: colSum4 });
grid.jqGrid('footerData', 'set', { TQO: colSum1 });
grid.jqGrid('footerData', 'set', { SDATE : colSum2 });;
}
})
该查询在 ColSum1 和 colSum2 中运行良好,但在 ColSum 和 Colsum4 中显示 Nan。谁能有办法解决这个问题
解决方案
getCol 方法在从格式化程序格式化后对网格中的数字值求和。您获得 NaN 的值不是数字,而是格式化后的链接。为了使其正常工作,您应该定义一个 unformat 函数,它将链接转换回一个数字。在此处查看Guriddo 文档
推荐阅读
- javascript - Javascript:限制按键事件侦听器在按住时调用函数的速度
- asp.net - URL 不会重定向到 HTTPS
- r - 如何根据行值中的大于条件选择列值
- swift - 在 swift 中将值从 Firestore 分配给变量
- php - 未找到 Laravel API 路由
- javascript - 如何理解这种语法?[a, b] = [b, a]?
- python-3.x - 在原始数据帧中没有显式“NaN”行的数据帧的插值
- c++ - 如何在不使用信号量的情况下解决寿司吧问题?
- javascript - 吸气剂是个坏主意吗?
- python - 使用 seaborn、swarmplot 显示已经分箱的数据