natural-time-delta

Created by Shodhan Save on Jan 23, 2018. Updated @ Jan 25, 2018

Plug-in code

/**
* This plug-in allows sorting of human readable time delta, viz.,
* "1 week", "2 weeks 3 days", "4 weeks 5 days 6hours", etc.
*
* Curently this plugin supports time range from microseconds to decades.
*
* The plugin also takes care of singular and plural values lik week(s)
*
*  @name Natural Time Delta
*  @summary Sort human readable time delta
*
*  @example
*    $("#example").DataTable({
*       columnDefs: [
*         { "type": "natural-time-delta", "targets": 2 }
*       ]
*    });
*/

jQuery.extend(jQuery.fn.dataTableExt.oSort,{
    "natural-time-delta-pre" : function(data){
        var result = 0;
        var pattern = /(\d+\s*decades?\s*)?(\d+\s*years?\s*)?(\d+\s*months?\s*)?(\d+\s*weeks?\s*)?(\d+\s*days?\s*)?(\d+\s*hours?\s*)?(\d+\s*minutes?\s*)?(\d+\s*seconds?\s*)?(\d+\s*milliseconds?\s*)?(\d+\s*microseconds?\s*)?/i
        var format_time_element = function(el, splitter, mul){
            if (el === undefined){
                return 0;
            }
            return parseFloat(el.split(splitter)[0].trim()) * mul;
        };

        var matches = data.match(pattern);
        matches.reverse();

        var time_elements = [
            {"splitter" : "us",  "name" : "microsecond",  "mul" : 1 / 1000 / 1000},
            {"splitter" : "ms",  "name" : "millisecond",  "mul" : 1 / 1000},
            {"splitter" : "s",  "name" : "second",  "mul" : 1},
            {"splitter" : "m",  "name" : "minute",  "mul" : 1 * 60},
            {"splitter" : "h",  "name" : "hour",    "mul" : 1 * 60 * 60},
            {"splitter" : "d",  "name" : "day",     "mul" : 1 * 60 * 60 * 24},
            {"splitter" : "w",  "name" : "week",    "mul" : 1 * 60 * 60 * 24 * 7},
            {"splitter" : "w",  "name" : "month",    "mul" : 1 * 60 * 60 * 24 * 7 * 30},
            {"splitter" : "w",  "name" : "year",    "mul" : 1 * 60 * 60 * 24 * 7 * 30 * 12},
            {"splitter" : "w",  "name" : "decade",    "mul" : 1 * 60 * 60 * 24 * 7 * 30 * 12 * 10},
        ];

        time_elements.forEach(function(el, i){
            var val = format_time_element(matches[i], el["splitter"], el["mul"]);
            result += val;
        });

        return result || -1;
    },

    "natural-time-delta-asc" : function (a, b) {
        return ((a < b) ? -1 : ((a > b) ? 1 : 0));
    },

    "natural-time-delta-desc" : function (a, b) {
        return ((a < b) ? 1 : ((a > b) ? -1 : 0));
    }
});

CDN

This plug-in is available on the DataTables CDN:

JS

Note that if you are using multiple plug-ins, it is beneficial in terms of performance to combine the plug-ins into a single file and host it on your own server, rather than making multiple requests to the DataTables CDN.

Version control

If you have any ideas for how this plug-in can be improved, or spot anything that is in error, it is available on GitHub and pull requests are very welcome!