tags:

views:

8

answers:

0

Hi, I using DataTables to sort my table files.i have a column of displaying month description.i need to sort the data according to months description.but dataTables sorting data using the alphabetical order. i created my own function, as shown below. [code] var monthsArray=new Array("Gennaio","febbraio","Marzo","Aprile","Maggio","Giugno","Luglio","Agosto","Settembre","Ottobre","novembre","dicembre");

       jQuery.fn.dataTableExt.oSort['Month-asc']  = function(x,y) {
            alert( "asc");
            var indexOfx = monthsArray.indexOf(x);
            var indexOfy = monthsArray.indexOf(y);
            alert("indexOfx>>"+indexOfx);
            alert("indexOfy>>"+indexOfy);
            return ((indexOfx < indexOfy) ? -1 : ((indexOfx > indexOfy) ?  1 : 0));
        };

        jQuery.fn.dataTableExt.oSort['Month-desc'] = function(x,y) {
            alert( "desc");
            var indexOfx = monthsArray.indexOf(x);
            var indexOfy = monthsArray.indexOf(y);
            alert("indexOfx>>"+indexOfx);
            alert("indexOfy>>"+indexOfy);
            return ((indexOfx < indexOfy) ?  1 : ((indexOfx > indexOfy) ? -1 : 0));
        };

        $(document).ready(function() {
            $('#example').dataTable({
             "bPaginate": false,
            "bLengthChange": false,
            "bFilter": false,
            "bSort": true,
            "bInfo": false,
            "aoColumnDefs": [
                    { "sType": 'Month'}
                  ], 
            "bAutoWidth": false 
            });
        } );

[code]

but it is not working properly , any body have idea please...

Thanking usman