Subversion Repositories SmartDukaan

        // Totals row appended at the bottom of thead — sits directly above the tbody data

        // and stays visible thanks to fixedHeader. Refilled on every draw via drawCallback,

        // so it reflects the current search/filter state.

        var whbTotalsRow = '<tr class="whbTotalsRow" style="background:#eef;font-weight:700;">';

        for (var c = 0; c < 11; c++) {

            whbTotalsRow += '<th class="whbTotalCell" data-col-idx="' + c + '"></th>';

        }

        whbTotalsRow += '</tr>';

        $('#warehouseBrandItemStock thead').append(whbTotalsRow);

        // Numeric columns to sum across all filtered rows.

        var whbSumCols = [2, 3, 4, 5, 6, 7, 8, 9, 10];

            drawCallback: function () {

                var api = this.api();

                var whbTotalCells = jQuery('#warehouseBrandItemStock .whbTotalCell');

                whbTotalCells.text('');

                whbTotalCells.filter('[data-col-idx="0"]').text('Totals');

                whbSumCols.forEach(function (idx) {

                    var sum = api.column(idx, {search: 'applied'}).data()

                            .reduce(function (a, b) {

                                var s = (b == null ? '' : String(b)).replace(/[,\s]/g, '');

                                var n = parseFloat(s);

                                return a + (isNaN(n) ? 0 : n);

                            }, 0);

                    whbTotalCells.filter('[data-col-idx="' + idx + '"]').text(

                            sum.toLocaleString('en-IN', {maximumFractionDigits: 0})

                    );

                });

            }