<script type="text/javascript" charset="utf-8" src="js/jquery-min.js?version=1"></script>
<script type="text/javascript" charset="utf-8" src="js/jquery.dataTables-min.js?version=1"></script>
<script type="text/javascript" charset="utf-8" src="js/dataTables.numericComma-min.js?version=1"></script>
<script type="text/javascript" charset="utf-8" src="js/FixedColumns-min.js?version=1"></script>
<script type="text/javascript" charset="utf-8">
$(document).ready( function () {
var oTable = $('#example').dataTable( {
"sScrollX": "100%",
//"sScrollXInner": "110%",
//"sScrollXInner": "400px",
//"bScrollCollapse": true,
"sPaginationType": "full_numbers",
"aoColumns": [
null,null,null,null,null,
{ "sType": "numeric-comma" },
{ "sType": "numeric-comma" },
{ "sType": "numeric-comma" },
{ "sType": "numeric-comma" },
{ "sType": "numeric-comma" },
{ "sType": "numeric-comma" },
{ "sType": "numeric-comma" },
null
]
} );
new FixedColumns( oTable, {
"iLeftColumns": 1,
"iLeftWidth": 160
} );
} );
</script>
dataTables.numericComma.js
jQuery.extend( jQuery.fn.dataTableExt.oSort, {
"numeric-comma-pre": function ( a ) {
a = (a===" ") ? 0 : a.replace( /[^\d\-\.]/g, "" );
//a = a.replace( /[^\d\-\.]/g, "" );
return parseFloat( a );
},
"numeric-comma-asc": function(a,b) {
return a - b;
},
"numeric-comma-desc": function(a,b) {
return b - a;
}
} );
沒有留言:
張貼留言