daterangepicker with server side Datatables

[adrienyhuel]

"daterangepicker" was added in #537, and this is wonderful :)

But it doesn't works really well with server side Datatables.
As it is a "date" filter_type, it send the raw value to ajax (ex : "YYYY-MM-DD - YYYY-MM-DD").

For a range of date, server side expect "YYYY-MM-DD-yadcf_delim-YYYY-MM-DD".

I modified your js this way to make it work :

function "exFilterColumn", case "date"

yadcf/src/jquery.dataTables.yadcf.js

Line 5204 in 2c85f07

table_arg.fnSettings().aoPreSearchCols[column_position].sSearch = tmpStr;

if (optionsObj.datepicker_type == 'daterangepicker') {
    var [min, max] = filter_value.split(" - ");
    table_arg.fnSettings().aoPreSearchCols[column_position].sSearch = min + optionsObj.custom_range_delimiter + max;
} else {
    table_arg.fnSettings().aoPreSearchCols[column_position].sSearch = tmpStr;
}

Do you think it's the right way to make it work ?

[vedmack]

@adrienyhuel what about the case 'range_date': inside exFilterColumn function ?

[adrienyhuel]

@adrienyhuel what about the case 'range_date': inside exFilterColumn function ?

@vedmack the case range_date comes with "filter_type" = "range_date", and it makes two calendars.
In order to use the "daterangepicker", we need to use only one field (and that's why in your sample, you put filter_type: "date").