Hey everyone,
I'm trying to create filter by date for leads table.
I have date picker from which I get date range
and an ajax call :
$('#filters-form-submit').on('click', function () {
const created_at = {};
let range = $('#date-range').val();
if (range) {
range = range.split('-');
created_at.min = range[0].replace(/\//g, '-').trim() + ' 00:00:00';
created_at.max = range[1].replace(/\//g, '-').trim() + ' 23:59:59';
}
$.ajax({
method: "POST",
url: "{{route('filterLeads')}}",
dataType: "json",
data: {
Filters: created_at
}
})
which addresses to LeadsController:
public function filterLeads(Request $request) {
$leads = Lead::select('id',
DB::raw('DATE_FORMAT(created_at, "%Y-%m-%d %H:%i:%s") as created_at'),
'phone_number')
->whereBetween('created_at', [$request->Filters['min'], $request->Filters['max']])
->get();
return response()->json($leads);
}
The problem is that this json response returns something like this :
2022-02-01T15:45:33.000000Z
I've read that it's some kind of serialization but couldn't find the solution.
Any kind of advice will be appreciated.