How to export within the subGrid?

5

Information: I am using jqGrid(4.54) , and also implemented SubGrid , after opening SubGrid , it is necessary to export the contents of the open table.

Question: Is there a way to implement a button or a link within SubGrid ?

See below the code for my SubGrid :

 var subgrid_table_id;
       subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table><div id='paginacaoSub'></div>");
       jQuery("#"+subgrid_table_id).jqGrid({
          url: urlRelatorioInterno,
          datatype: 'json',
          mtype: 'POST',
          colModel: [
            {name:"dataHora", index:"dataHora", jsonmap:"dataHora", label:"Data e Hora", sortable: true, sorttype: "date"},
            {name:"tipoSolicitacao",index:"tipoSolicitacao",jsonmap:"tipoSolicitacao",label:"Tipo Solicitacao", sortable: true, sorttype: "int"},
            {name:"statusSolicitacao",index:"statusSolicitacao",jsonmap:"statusSolicitacao",label:"Status Solicitacao",  sortable: true, sorttype: "text"},
            {name:"numeroSolicitacao",index:"numeroSolicitacao",jsonmap:"numeroSolicitacao",label:"Numero Solicitacao",  sortable: true, sorttype: "int"},           
            {name:"numeroCartao",index:"numeroCartao",jsonmap:"numeroCartao",label:"Numero Cartao",  sortable: true, sorttype: "int"},
            {name:"nomeSegurado",index:"nomeSegurado",jsonmap:"nomeSegurado",label:"Nome Segurado",  sortable: true, sorttype: "text"},
            {name:"codigoReferenciado",index:"codigoReferenciado",jsonmap:"codigoReferenciado",label:"Codigo Referenciado",  sortable: true, sorttype: "int"},
            {name:"nomeReferenciado",index:"nomeReferenciado",jsonmap:"nomeReferenciado",label:"Nome Referenciado",  sortable: true, sorttype: "text"},
            {name:"senha",index:"senha",jsonmap:"senha",label:"Senha",  sortable: true, sorttype: "text"},           
            {name:"canalSolicitacao",index:"canalSolicitacao",jsonmap:"canalSolicitacao",label:"Canal Solicitacao",  sortable: true, sorttype: "int"}],

          pager: "#paginacaoSub",
          scroll: 1,
          width: 1100,
          height: 240,
          rowNum:10,
          rowList: true,
          loadonce:true
       });
    
asked by anonymous 31.01.2014 / 16:31

1 answer

2

People found an easy way to insert the buttons into the subgrid. JqGrid already provides a way to insert through a jqGrid function "navButtonAdd". Below is the subGrid code next to the button code.

var urlTipoSolicitacao = "?filtro.tipoSolicitacao="+$('#respostaRelatorio').jqGrid('getRowData', row_id).tipoSolicitacao;
       var subgrid_table_id;
       subgrid_table_id = subgrid_id+"_t";
       jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table><div id='paginacaoSub'></div>");
       jQuery("#"+subgrid_table_id).jqGrid({
          url: urlRelatorioInterno + urlTipoSolicitacao,
          datatype: 'json',
          mtype: 'POST',
          colModel: [
            {name:"dataHora", index:"dataHora", jsonmap:"dataHora", label:"Data e Hora", sortable: true, sorttype: "date"},
            {name:"tipoSolicitacao",index:"tipoSolicitacao",jsonmap:"tipoSolicitacao",label:"Tipo Solicitacao", sortable: true, sorttype: "int"},
            {name:"statusSolicitacao",index:"statusSolicitacao",jsonmap:"statusSolicitacao",label:"Status Solicitacao",  sortable: true, sorttype: "text"},
            {name:"numeroSolicitacao",index:"numeroSolicitacao",jsonmap:"numeroSolicitacao",label:"Numero Solicitacao",  sortable: true, sorttype: "int"},           
            {name:"numeroCartao",index:"numeroCartao",jsonmap:"numeroCartao",label:"Numero Cartao",  sortable: true, sorttype: "int"},
            {name:"nomeSegurado",index:"nomeSegurado",jsonmap:"nomeSegurado",label:"Nome Segurado",  sortable: true, sorttype: "text"},
            {name:"codigoReferenciado",index:"codigoReferenciado",jsonmap:"codigoReferenciado",label:"Codigo Referenciado",  sortable: true, sorttype: "int"},
            {name:"nomeReferenciado",index:"nomeReferenciado",jsonmap:"nomeReferenciado",label:"Nome Referenciado",  sortable: true, sorttype: "text"},
            {name:"senha",index:"senha",jsonmap:"senha",label:"Senha",  sortable: true, sorttype: "text"},           
            {name:"canalSolicitacao",index:"canalSolicitacao",jsonmap:"canalSolicitacao",label:"Canal Solicitacao",  sortable: true, sorttype: "int"}],
          pager: "#paginacaoSub",
          scroll: 1,
          width: 1100,
          height: 135,
          rowNum:5,
          rowList: true,
          loadonce:true
         }).jqGrid('navGrid', '#paginacaoSub', {
                           add: false,
                           edit: false,
                           del : false,
                           search: false,
                           refresh: false
                             }).jqGrid('navButtonAdd', '#paginacaoSub',{ 
                           caption: "Exportar Excel",
                           onClickButton: function(){ 
                                window.location.href = urlExportarExcelInterno + urlTipoSolicitacao;
                               }, 
                           position: "first"
                             }).jqGrid('navButtonAdd', '#paginacaoSub',{
                           caption: "Exportar PDF",
                           onClickButton: function(){ 
                               window.location.href = urlExportarPdfInterno + urlTipoSolicitacao;
                                   }, 
                           position: "first"

                             });
                      };
    
07.02.2014 / 14:52