Answers

• arcanisgk Posts: 69Questions: 16Answers: 0

  July 2017

  Code:

  $('.DataTableHelper1').DataTable( {
          "dom": '<"html5buttons"B>rt<"bottom"><"clear">',
          "language": {
              "decimal":      ".",
              "emptyTable":       "No hay datos disponibles en la tabla",
              "info":         "Mostrando _START_ a _END_ de _TOTAL_ Registros",
              "infoEmpty":        "Mostrando 0 a 0 de 0 Registros",
              "infoFiltered":     "(Filtrado a Partir de _MAX_ Registros)",
              "infoPostFix":      "",
              "thousands":        ",",
              "lengthMenu":       "_MENU_",
              "loadingRecords":   "Cargando...",
              "processing":       "Procesando...",
              "search":       "Buscar:",
              "zeroRecords":      "No Encontrado - lo siento",
              "paginate": {
                  "first":        "Inicio",
                  "last":         "Ultimo",
                  "next":         "Siguiente",
                  "previous":     "Anterior"
              },
              "aria": {
                  "sortAscending":  ": activar para ordenar la columna ascendente",
                  "sortDescending": ": activar para ordenar la columna descendente"
              }
          },
          "iDisplayLength": -1,
          "lengthMenu": [[-1], ["All"]],
          "ordering": false,
          "scrollY": "300px",
          "scrollCollapse": true,
          buttons: [{
              extend: 'collection',
              text: 'Herramientas',
              buttons: [
                  {extend: 'copy', text: 'Copiar',exportOptions: {columns: ':visible'},},
                  {extend: 'excel', title: 'ArchivoExcel', text: 'Excel',exportOptions: {columns: ':visible'},},
                  {extend: 'pdfHtml5', title: 'ArchivoPDF', text: 'PDF',
                      orientation: 'landscape',
                      pageSize: 'LEGAL',
                      exportOptions: {
                          columns: ':visible',
                          stripHtml: true,
                      },
                  },
                  {extend: 'print', text: 'Imprimir',
                      customize: function (win){
                          $(win.document.body).addClass('white-bg');
                          $(win.document.body).css('font-size', '10px');
                          $(win.document.body).find('table')
                          .addClass('compact')
                          .css('font-size', 'inherit');
                      },
                      exportOptions: {columns: ':visible'},
                  },
              ]},
              {extend: 'colvis', text: 'Adm',},
              {
                  text: 'Ayuda',
                  action: function ( e, dt, node, config ) {
                      $.jAlert({
                          'title': 'Ayuda de Herramientas',
                          'content': msgtext,
                          'theme': 'blue',
                          'size': 'lg',
                          'showAnimation': 'fadeInUp',
                          'hideAnimation': 'fadeOutDown'
                      });
                  }
              },
          ]
      });