datatable.js 1.06 KB
$('#table').dataTable({
	"aaSorting": [[ 1, "desc" ]],
	"pading":false
});

$.fn.dataTableExt.afnFiltering.push(
    function( oSettings, aData, iDataIndex ) {
        var min = document.getElementById('min').value;
        var max = document.getElementById('max').value;
        var iDateCol = 12;

        var dateMin = new Date(aData[iDateCol]);
        var dateMax = new Date(aData[iDateCol]);

        if (min === '' && max === '')
            return true;
        else if (new Date(min).getTime() <= dateMin.getTime() && max === '')
            return true;
        else if (new Date(min).getTime() <= dateMin.getTime() && new Date(max).getTime() >= dateMax.getTime())
            return true;
        return false;
    }
);

$('.table_search').on('change', function () {
    search = $(this).val();
    column = $(this).attr('column');

    $('#table').DataTable().column(column).search(search).draw();
});

$('#min, #max').on('keyup', function () {
    $('#table').DataTable().draw();
});

function resetHandler ()
{
    $('#table').DataTable().columns().search("").draw();
}