Laravel-datatables: Footer callback and sum of rows value

[ZAZmaster]

Hello! Can i add this to DataTables as a Service http://www.datatables.net/examples/advanced_init/footer_callback.html

When i try to add:

->parameters([
                'FooterCallback' => "function ( row, data, start, end, display ) {
                    var api = this.api(), data;

                    // Remove the formatting to get integer data for summation
                    var intVal = function ( i ) {
                        return typeof i === 'string' ?
                            i.replace(/[\$,]/g, '')*1 :
                            typeof i === 'number' ?
                                i : 0;
                    };

                    // Total over all pages
                    total = api
                        .column( 4 )
                        .data()
                        .reduce( function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0 );

                    // Total over this page
                    pageTotal = api
                        .column( 4, { page: 'current'} )
                        .data()
                        .reduce( function (a, b) {
                            return intVal(a) + intVal(b);
                        }, 0 );

                    // Update footer
                    $( api.column( 4 ).footer() ).html(
                        '$'+pageTotal +' ( $'+ total +' total)'
                    );
                }",

have error: Uncaught TypeError: b.fn.apply is not a function
and table not load.

[yajra]

@ZAZmaster, footer callback is not yet supported on the builder. You may have to manually hook this to dt.draw event of dataTables.

[ZAZmaster]

@yajra ok, i do this in blade template:

@section('js')
    <script type="text/javascript" language="javascript" src="/plugins/datatables/jquery.dataTables.min.js"></script>
    <script type="text/javascript" language="javascript" src="/plugins/datatables/dataTables.bootstrap.min.js"></script>
    <script type="text/javascript" language="javascript" src="/plugins/datatables/dataTables.buttons.min.js"></script>
    <script type="text/javascript" language="javascript" src="/vendor/datatables/buttons.server-side.js"></script>
    <script>
        jQuery.fn.dataTable.Api.register( 'sum()', function ( ) {
            return this.flatten().reduce( function ( a, b ) {
                if ( typeof a === 'string' ) {
                    a = a.replace(/[^\d.-]/g, '') * 1;
                }
                if ( typeof b === 'string' ) {
                    b = b.replace(/[^\d.-]/g, '') * 1;
                }

                return a + b;
            }, 0 );
        } );
    </script>
    {!! $dataTable->scripts() !!}
    <script>
        $(function() {
            var table = $('#dataTableBuilder').DataTable();
            $('#dataTableBuilder').on( 'draw.dt', function () {
                var tablesum = table.column(4).data().sum();
                $(".dataTables_info").append('. Sum of records per page ' + tablesum);
            } );
        });
    </script>
@stop

Thanks for the tip about draw.dt

[yajra]

Glad it worked for you!

[elishaukpong]

i used this, though tweaked it abit.

Thanks @ZAZmaster and @yajra