/*JQUERY DATATABLES */
/* Add class to the columns you do not wish to sort */
$("#tablepress-12 thead tr th.column-1").addClass("no-sort");
$("#tablepress-12 thead tr th.column-2").addClass("no-sort");
$("#tablepress-12 thead tr th.column-8").addClass("no-sort");
/* EXTENSIONS */
/* formatted numbers extension */
jQuery.extend( jQuery.fn.dataTableExt.oSort, {
"formatted-num-pre": function ( a ) {
a = (a === "-" || a === "") ? 0 : a.replace( /[^\d\-\.]/g, "" );
return parseFloat( a );
},
"formatted-num-asc": function ( a, b ) {
return a - b;
},
"formatted-num-desc": function ( a, b ) {
return b - a;
}
} );
/* currency extension */
jQuery.extend( jQuery.fn.dataTableExt.oSort, {
"currency-pre": function ( a ) {
a = (a==="-") ? 0 : a.replace( /[^\d\-\.]/g, "" );
return parseFloat( a );
},
"currency-asc": function ( a, b ) {
return a - b;
},
"currency-desc": function ( a, b ) {
return b - a;
}
} );
/* Plugin call */
/* Each one in aoColumns represents a column */
$('.data-table-sort').dataTable({
"aoColumns": [
null,
null,
null,
{ "sType": "formatted-num" },
null,
null,
null,
null
],"aoColumnDefs": [
{ 'bSortable': false, 'aTargets': ["no-sort" ] }
]
});