2014年4月27日 星期日

DataTable number-comma sorting

<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==="&nbsp;") ? 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;
    }
} );

沒有留言:

張貼留言