Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // == suma los valores de la columna del DataTable ===
- <script type="text/javascript">
- var table;
- $(document).ready(function() {
- table = $('#myTable').DataTable( {
- buttons: [
- 'print', 'excel', 'pdf', 'copy'
- ],
- "footerCallback": function ( row, data, start, end, display ) {
- var api = this.api(), data;
- var intVal = function ( i ) {
- return typeof i === 'string' ?
- i.replace(/[$,]/g, '')*1 :
- typeof i === 'number' ?
- i : 0;
- };
- total = api
- .column( 4 )
- .data()
- .reduce( function (a, b) {
- return intVal(a) + intVal(b);
- }, 0 );
- pageTotal = api
- .column( 4, { page: 'current'} )
- .data()
- .reduce( function (a, b) {
- return intVal(a) + intVal(b);
- }, 0 );
- $( api.column( 4 ).footer() ).html(
- '$'+pageTotal +' ( $'+ total +' total)'
- );
- }
- } );
- } );
- //=== Exportar los datos del dataTable ===
- table.buttons().container()
- .appendTo( $('.col-sm-6:eq(0)', table.table().container() ) );
- </script>
Add Comment
Please, Sign In to add comment