DataTables
HTML
<link rel="stylesheet" href="//cdn.datatables.net/1.10.7/css/jquery.dataTables.css">
<script src="//cdn.datatables.net/1.10.7/js/jquery.dataTables.js"></script>
<div class="container">
<h3>jQuery DataTables: Sum in footer</h3>
<a href="https://www.gyrocode.com/articles/tag/jquery-datatables/">See more articles about jQuery DataTables</a> on <a href="https://www.gyrocode.com/articles/">Gyrocode.com</a><hr>
<table id="ticketTable" class="display">
<thead>
<tr>
<th></th>
<th>Diarienummer</th>
<th>Organisation</th>
<th>Status</th>
<th class="sum">Sökt antal</th>
<th>Godkänt antal</th>
<th>Sökt bidrag</th>
<th>Godkänt bidrag</th>
<th></th>
</tr>
</thead>
<tfoot>
<tr>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
<th></th>
</tr>
</tfoot>
<tbody>
<tr>
<td class="text-center sorting_1">
<input data-val="true" data-val-required="Fältet Checked krävs." id="Tickets_0__Checked" name="Tickets[0].Checked" type="checkbox" value="true">
<input name="Tickets[0].Checked" type="hidden" value="false">
<input data-val="true" data-val-number="The field Id must be a number." data-val-required="Fältet Id krävs." id="Tickets_0__Id" name="Tickets[0].Id" type="hidden" value="8">
</td>
<td> <a href="/AtlasPartnerskap/Ticket/Overview/8">3.3.1.34.8</a>
</td>
<td>AP Skola 1</td>
<td>Beviljad</td>
<td>1</td>
<td>1</td>
<td>20000,00</td>
<td>0,00</td>
...
JavaScript
var table = $('#ticketTable').DataTable({
"initComplete": function (settings, json) {
this.api().columns('.sum').every(function () {
var column = this;
var sum = column
.data()
.reduce(function (a, b) {
a = parseInt(a, 10);
if(isNaN(a)){ a = 0; }
b = parseInt(b, 10);
if(isNaN(b)){ b = 0; }
return a + b;
});
$(column.footer()).html('Sum: ' + sum);
});
}
});