Server side date filtering is not working

Server side date filtering is not working

ablonashidablonashid Posts: 2Questions: 0Answers: 0
edited August 2012 in Plug-ins
server side date filtering is not working

Here is the code

var minDateFilter;
var maxDateFilter;

$.fn.dataTableExt.afnFiltering.push(
function( oSettings, aData, iDataIndex ) {
if ( typeof aData._date == 'undefined' ) {
aData._date = new Date(aData[1]).getTime();
}

if ( minDateFilter && !isNaN(minDateFilter) ) {
if ( aData._date < minDateFilter ) {
return false;
}
}

if ( maxDateFilter && !isNaN(maxDateFilter) ) {
if ( aData._date > maxDateFilter ) {
return false;
}
}

return true;
}
);

$(document).ready( function() {
$.datepicker.regional[""].dateFormat = 'yy-mm-dd';
$.datepicker.setDefaults($.datepicker.regional['']);
var oTable = $('#example').dataTable( {
"bJQueryUI": true,
"bServerSide": true,
"sAjaxSource": "scripts/server_processing.php",
"bProcessing": true,
"sPaginationType": "full_numbers",
"bFilter": true
} );

$( "#datepicker_min" ).datepicker( {
"onSelect": function(date) {
minDateFilter = new Date(date).getTime();
oTable.fnDraw();
}
} ).keyup( function () {
minDateFilter = new Date(this.value).getTime();
oTable.fnDraw();
} );

$( "#datepicker_max" ).datepicker( {
"onSelect": function(date) {
maxDateFilter = new Date(date).getTime();
oTable.fnDraw();
}
} ).keyup( function () {
maxDateFilter = new Date(this.value).getTime();
oTable.fnDraw();
} );
} );
This discussion has been closed.