如何把数据放在合计"FooterRow"

How to put data on the total "FooterRow"?

本文关键字：quot FooterRow 数据      更新时间：2023-09-26

我使用jqGrid插件4.6.0与jQuery1.11.0生成一个报告，需要在摘要中的总数。我只能生成按列分组的总数。jqGrid有一个名为footerrow的属性，它应该是网格的摘要。

我需要把整个报告的总数放在FooterRow中，但是我没能做到。

$("#respostaRelatorio").jqGrid({
    url: urlRelatorio + "?" + dadosRelatorio,
    colModel: modeloColunas,
    mtype: "POST",
    altRows: true,
    datatype: "json",
    loadonce: true,
    height: "auto",
    width: 1130,
    rowNum: 10,
    rowList: [ 10, 20, 30, 40, 50 ],
    viewrecords: true,
    pager: "#paginacao",
    sortorder: "asc",
    shrinkToFit: false,
    headertitles: true,
    loadui: "disable",
    rownumbers: true,
    autoencode: true,
    caption: "Resultados encontrados",
    deselectAfterSort: true,
    gridview: true,
    idPrefix: "id",
    rowTotal: 4000,
    sortable: true,
    toppager: true,
    resizable: true,
    grouping: true,
    groupingView: {
        groupField: [ 'loginMedico' ],
        groupCollapse: false,
        groupOrder: [ 'asc' ],
        groupSummary: [ true ],
        groupDataSorted: true
    },
    footerrow: true,
    userDataOnFooter: true
});
var modeloColunas = [
    { name: "loginMedico", index: "loginMedico", jsonmap: "loginMedico", label: "Login Médico", sortable: true, sorttype: "text", summaryType: "count", summaryTpl: "total" },
    { name: "nomeMedico", index: "nomeMedico", jsonmap: "nomeMedico", label: "Nome do Médico", sortable: true, sorttype: "text" },
    { name: "perfilMedico", index: "perfilMedico", jsonmap: "perfilMedico", label: "Perfil Médico", sortable: true, sorttype: "text"},
    { name: "tipoSolicitacao", index: "tipoSolicitacao", jsonmap: "tipoSolicitacao", label: "Tipo da Solicitação", sortable: true, sorttype: "text" },
    { name: "cancelada", index: "cancelada", jsonmap: "cancelada", label: "Cancelada", sortable: true, sorttype: "int" },
    { name: "liberada", index: "liberada", jsonmap: "liberada", label: "Liberada", sortable: true, sorttype: "int", summaryType: "sum" },
    { name: "negada", index: "negada", jsonmap: "negada", label: "Negada", sortable: true, sorttype: "int", summaryType: "sum" },
    { name: "pendente", index: "pendente", jsonmap: "pendente", label: "Pendente", sortable: true, sorttype: "int", summaryType: "sum" },
    { name: "total", index: "total", jsonmap: "total", label: "Total", sortable: true, sorttype: "int", summaryTpl: "total"} ];

将我对SO-PT(葡萄牙语)的回答交叉贴出(并翻译):

看看这个例子。

基本上，您需要在jqGrid中添加loadComplete函数，它将用于构建footerData: 

loadComplete: function () {
    var $self = $(this);
    var sumCanceled = $self.jqGrid("getCol", "cancelada", false, "sum");
    var sumReleased = $self.jqGrid("getCol", "liberada", false, "sum");
    var sumDenied = $self.jqGrid("getCol", "negada", false, "sum");
    var sumPending = $self.jqGrid("getCol", "pendente", false, "sum");
    $self.jqGrid("footerData", "set", {
        loginMedico: "Total:", 
        cancelada: sumCanceled, 
        liberada: sumReleased,  
        negada: sumDenied,
        pendente: sumPending
    });
}

来源:在jqgrid上使用footerdata获取总和

相关文章：