Guest User

Untitled

a guest
Feb 25th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. // == suma los valores de la columna del DataTable ===
  2.  
  3. <script type="text/javascript">
  4. var table;
  5. $(document).ready(function() {
  6. table = $('#myTable').DataTable( {
  7. buttons: [
  8. 'print', 'excel', 'pdf', 'copy'
  9. ],
  10. "footerCallback": function ( row, data, start, end, display ) {
  11. var api = this.api(), data;
  12.  
  13. var intVal = function ( i ) {
  14. return typeof i === 'string' ?
  15. i.replace(/[$,]/g, '')*1 :
  16. typeof i === 'number' ?
  17. i : 0;
  18. };
  19.  
  20. total = api
  21. .column( 4 )
  22. .data()
  23. .reduce( function (a, b) {
  24. return intVal(a) + intVal(b);
  25. }, 0 );
  26.  
  27. pageTotal = api
  28. .column( 4, { page: 'current'} )
  29. .data()
  30. .reduce( function (a, b) {
  31. return intVal(a) + intVal(b);
  32. }, 0 );
  33.  
  34. $( api.column( 4 ).footer() ).html(
  35. '$'+pageTotal +' ( $'+ total +' total)'
  36. );
  37. }
  38. } );
  39. } );
  40.  
  41. //=== Exportar los datos del dataTable ===
  42.  
  43. table.buttons().container()
  44. .appendTo( $('.col-sm-6:eq(0)', table.table().container() ) );
  45. </script>
Add Comment
Please, Sign In to add comment