Datatable export generic data outside table












-1















I'm trying to add aditional rows during exportation(plz, see attached image), i don't find the right way to do it, please someone tell me whether or not its possible, since many reports carry parent data that not necesarily appears inside the table. I need the Pdf output with the same format. I'm using yajra datatables for laravel.



buttons :[  
{
extend: 'pdfHtml5',
pageSize: 'letter',
title: "Informe Asistencia",
exportOptions: {
columns: [0,1,2,3,4,5,6,7,8,9,10 ]
}
},
['excel','csv','colvis']
],


calling the function and drawing table



   $.get('{{ url("informes/get_informe_asistencia") }}', 
{
'fecha_inicio': fecha_inicio,
'fecha_fin' : fecha_fin,
'numero' : numero

},function(resp){
console.log(resp);
$('.desde').append(fecha_inicio);
$('.hasta').append(fecha_fin);
$('.nombre').append(resp.informe[1].nombre);
$('.ficha').append(resp.informe[1].numero);

dtinforme.clear().draw();
dtinforme.rows.add(resp.informe).draw();
}


missing data










share|improve this question





























    -1















    I'm trying to add aditional rows during exportation(plz, see attached image), i don't find the right way to do it, please someone tell me whether or not its possible, since many reports carry parent data that not necesarily appears inside the table. I need the Pdf output with the same format. I'm using yajra datatables for laravel.



    buttons :[  
    {
    extend: 'pdfHtml5',
    pageSize: 'letter',
    title: "Informe Asistencia",
    exportOptions: {
    columns: [0,1,2,3,4,5,6,7,8,9,10 ]
    }
    },
    ['excel','csv','colvis']
    ],


    calling the function and drawing table



       $.get('{{ url("informes/get_informe_asistencia") }}', 
    {
    'fecha_inicio': fecha_inicio,
    'fecha_fin' : fecha_fin,
    'numero' : numero

    },function(resp){
    console.log(resp);
    $('.desde').append(fecha_inicio);
    $('.hasta').append(fecha_fin);
    $('.nombre').append(resp.informe[1].nombre);
    $('.ficha').append(resp.informe[1].numero);

    dtinforme.clear().draw();
    dtinforme.rows.add(resp.informe).draw();
    }


    missing data










    share|improve this question



























      -1












      -1








      -1








      I'm trying to add aditional rows during exportation(plz, see attached image), i don't find the right way to do it, please someone tell me whether or not its possible, since many reports carry parent data that not necesarily appears inside the table. I need the Pdf output with the same format. I'm using yajra datatables for laravel.



      buttons :[  
      {
      extend: 'pdfHtml5',
      pageSize: 'letter',
      title: "Informe Asistencia",
      exportOptions: {
      columns: [0,1,2,3,4,5,6,7,8,9,10 ]
      }
      },
      ['excel','csv','colvis']
      ],


      calling the function and drawing table



         $.get('{{ url("informes/get_informe_asistencia") }}', 
      {
      'fecha_inicio': fecha_inicio,
      'fecha_fin' : fecha_fin,
      'numero' : numero

      },function(resp){
      console.log(resp);
      $('.desde').append(fecha_inicio);
      $('.hasta').append(fecha_fin);
      $('.nombre').append(resp.informe[1].nombre);
      $('.ficha').append(resp.informe[1].numero);

      dtinforme.clear().draw();
      dtinforme.rows.add(resp.informe).draw();
      }


      missing data










      share|improve this question
















      I'm trying to add aditional rows during exportation(plz, see attached image), i don't find the right way to do it, please someone tell me whether or not its possible, since many reports carry parent data that not necesarily appears inside the table. I need the Pdf output with the same format. I'm using yajra datatables for laravel.



      buttons :[  
      {
      extend: 'pdfHtml5',
      pageSize: 'letter',
      title: "Informe Asistencia",
      exportOptions: {
      columns: [0,1,2,3,4,5,6,7,8,9,10 ]
      }
      },
      ['excel','csv','colvis']
      ],


      calling the function and drawing table



         $.get('{{ url("informes/get_informe_asistencia") }}', 
      {
      'fecha_inicio': fecha_inicio,
      'fecha_fin' : fecha_fin,
      'numero' : numero

      },function(resp){
      console.log(resp);
      $('.desde').append(fecha_inicio);
      $('.hasta').append(fecha_fin);
      $('.nombre').append(resp.informe[1].nombre);
      $('.ficha').append(resp.informe[1].numero);

      dtinforme.clear().draw();
      dtinforme.rows.add(resp.informe).draw();
      }


      missing data







      pdf datatables






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 20 '18 at 14:14







      Rodrigo Cabrera

















      asked Nov 19 '18 at 19:40









      Rodrigo CabreraRodrigo Cabrera

      186




      186
























          1 Answer
          1






          active

          oldest

          votes


















          0














          you can export manually.



                              text: 'PDF',//title
          titleAttr: 'Exportar PDF',
          exportOptions: {
          ...
          },
          action: function (e, dt, node, config) {
          var table = this;
          dt.clear().draw();
          dt.rows.add("YOUR DATA").draw();
          $.fn.dataTable.ext.buttons.pdfHtml5.action.call(table, e, dt, node, config);
          }


          So you need modify your data from with dt.rows().data().toArray(),dt.settings().init().columns.






          share|improve this answer
























          • hello Wilmer, i'm can't make up my mind on how to implement this solution, i get resp from the controller with data requested on json format as edited above, the classes are the ones that i need to fill up outside the datatable and appear on export

            – Rodrigo Cabrera
            Nov 20 '18 at 14:34













          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381543%2fdatatable-export-generic-data-outside-table%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          you can export manually.



                              text: 'PDF',//title
          titleAttr: 'Exportar PDF',
          exportOptions: {
          ...
          },
          action: function (e, dt, node, config) {
          var table = this;
          dt.clear().draw();
          dt.rows.add("YOUR DATA").draw();
          $.fn.dataTable.ext.buttons.pdfHtml5.action.call(table, e, dt, node, config);
          }


          So you need modify your data from with dt.rows().data().toArray(),dt.settings().init().columns.






          share|improve this answer
























          • hello Wilmer, i'm can't make up my mind on how to implement this solution, i get resp from the controller with data requested on json format as edited above, the classes are the ones that i need to fill up outside the datatable and appear on export

            – Rodrigo Cabrera
            Nov 20 '18 at 14:34


















          0














          you can export manually.



                              text: 'PDF',//title
          titleAttr: 'Exportar PDF',
          exportOptions: {
          ...
          },
          action: function (e, dt, node, config) {
          var table = this;
          dt.clear().draw();
          dt.rows.add("YOUR DATA").draw();
          $.fn.dataTable.ext.buttons.pdfHtml5.action.call(table, e, dt, node, config);
          }


          So you need modify your data from with dt.rows().data().toArray(),dt.settings().init().columns.






          share|improve this answer
























          • hello Wilmer, i'm can't make up my mind on how to implement this solution, i get resp from the controller with data requested on json format as edited above, the classes are the ones that i need to fill up outside the datatable and appear on export

            – Rodrigo Cabrera
            Nov 20 '18 at 14:34
















          0












          0








          0







          you can export manually.



                              text: 'PDF',//title
          titleAttr: 'Exportar PDF',
          exportOptions: {
          ...
          },
          action: function (e, dt, node, config) {
          var table = this;
          dt.clear().draw();
          dt.rows.add("YOUR DATA").draw();
          $.fn.dataTable.ext.buttons.pdfHtml5.action.call(table, e, dt, node, config);
          }


          So you need modify your data from with dt.rows().data().toArray(),dt.settings().init().columns.






          share|improve this answer













          you can export manually.



                              text: 'PDF',//title
          titleAttr: 'Exportar PDF',
          exportOptions: {
          ...
          },
          action: function (e, dt, node, config) {
          var table = this;
          dt.clear().draw();
          dt.rows.add("YOUR DATA").draw();
          $.fn.dataTable.ext.buttons.pdfHtml5.action.call(table, e, dt, node, config);
          }


          So you need modify your data from with dt.rows().data().toArray(),dt.settings().init().columns.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 19 '18 at 21:28









          Wilmer Ofelio Alama SeminarioWilmer Ofelio Alama Seminario

          7316




          7316













          • hello Wilmer, i'm can't make up my mind on how to implement this solution, i get resp from the controller with data requested on json format as edited above, the classes are the ones that i need to fill up outside the datatable and appear on export

            – Rodrigo Cabrera
            Nov 20 '18 at 14:34





















          • hello Wilmer, i'm can't make up my mind on how to implement this solution, i get resp from the controller with data requested on json format as edited above, the classes are the ones that i need to fill up outside the datatable and appear on export

            – Rodrigo Cabrera
            Nov 20 '18 at 14:34



















          hello Wilmer, i'm can't make up my mind on how to implement this solution, i get resp from the controller with data requested on json format as edited above, the classes are the ones that i need to fill up outside the datatable and appear on export

          – Rodrigo Cabrera
          Nov 20 '18 at 14:34







          hello Wilmer, i'm can't make up my mind on how to implement this solution, i get resp from the controller with data requested on json format as edited above, the classes are the ones that i need to fill up outside the datatable and appear on export

          – Rodrigo Cabrera
          Nov 20 '18 at 14:34




















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381543%2fdatatable-export-generic-data-outside-table%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          How to change which sound is reproduced for terminal bell?

          Can I use Tabulator js library in my java Spring + Thymeleaf project?

          Title Spacing in Bjornstrup Chapter, Removing Chapter Number From Contents