DataTables
DataTables Examples
HTML
<link rel="stylesheet" href="http://cdn.datatables.net/1.9.4/css/jquery.dataTables.css">
<script src="http://cdn.datatables.net/1.9.4/js/jquery.dataTables.min.js"></script>
<table id="example" class="sortable">
<thead>
<tr>
<th>Nome</th>
<th>Descontos</th>
<th>LĂquido</th>
</tr>
</thead>
<tbody>
<tr>
<td>Estatutário - Financeiro</td>
<td style="text-align: right">379,18</td>
<td style="text-align: right">2.460,59</td>
</tr>
<tr>
<td>Agente Atendimento Saúde I</td>
<td style="text-align: right">1.053,87</td>
<td style="text-align: right">77,45</td>
</tr>
<tr>
<td>Agente Atendimento Saúde I</td>
<td style="text-align: right">122,44</td>
<td style="text-align: right">1.007,85</td>
</tr>
<tr>
<td>Agente Atendimento Saúde I</td>
<td style="text-align: right">415,72</td>
<td style="text-align: right">1.071,61</td>
</tr>
<tr>
<td>Agente Atendimento Saúde I</td>
<td style="text-align: right">411,04</td>
<td style="text-align: right">761,96</td>
</tr>
<tr>
<td>Agente Atendimento Saúde I</td>
<td style="text-align: right">422,73</td>
<td style="text-align: right">2.015,35</td>
</tr>
<tr>
<td>Operador Equipamento Especial</td>
<td style="text-align: right">1.278,45</td>
<td style="text-align: right">2.714,25</td>
...
JavaScript
jQuery.extend( jQuery.fn.dataTableExt.oSort, {
"my-currency-pre": function(a) {
console.log(a);
return parseFloat(a.replace('.', ''));
},
"my-currency-asc": function(a,b) {
return ((a < b) ? -1 : ((a > b) ? 1 : 0));
},
"my-currency-desc": function(a,b) {
return ((a < b) ? 1 : ((a > b) ? -1 : 0));
}
});
var table = $('#example').dataTable({
"aoColumnDefs": [
{"sType": "my-currency", "aTargets": [1]}
]
});