/**
* Process datatables ajax request.
*
* @return \Illuminate\Http\JsonResponse
*/
public function eventsIndexData(Request $request)
{
$tests = Sitemap::join('sitemaptranslations', 'sitemaps.id', '=', 'sitemaptranslations.sitemap_id')->join('tmp_page_event', 'sitemaptranslations.id', '=', 'tmp_page_event.sitemaptranslation_id')->join('users', 'sitemaps.created_by_user_id', '=', 'users.id')->join('templates', 'sitemaps.template_id', '=', 'templates.id')->where('sitemaptranslations.locale_id', 1)->where('templates.name', 'Evenement')->select(['sitemaps.id', 'sitemaps.status', 'sitemaps.created_at', 'sitemaps.updated_at', 'users.name AS usersname', 'sitemaptranslations.name as testname', 'sitemaptranslations.published_at as published_at', 'tmp_page_event.name as eventname', 'tmp_page_event.when as wanneer'])->groupBy('sitemaps.id');
//dd($tests->get());
$datatable = Datatables::of($tests);
$datatable->addColumn('check', '<input type="checkbox" name="selected_dt_row[]" value="{{ $id }}">{{ $id }}');
//app('debugbar')->warning($datatable);
$datatable->addColumn('action', function ($test) {
return '<a href="' . route('admin::sitemap.edit', ['id' => $test->id]) . '" class="btn btn-xs-uit btn-primary"><i class="glxyphicon glyphicon-xedit"></i> Edit</a>';
});
//->editColumn('created_at', function ($test) {
// return $test->created_at ? with(new Carbon($test->created_at))->format('m/d/Y') : '';
//})
$datatable->editColumn('published_at', function ($test) {
return $test->published_at ? with(new Carbon($test->published_at))->diffForHumans() : '';
});
$datatable->editColumn('wanneer', function ($test) {
return $test->wanneer ? with(new Carbon($test->wanneer))->formatLocalized('%A %d %B %Y') : '';
return $test->wanneer ? with(new Carbon($test->wanneer))->diffForHumans() : '';
});
$datatable->editColumn('status', function ($test) {
$statusValue = $test->status;
if ($test->status == 'pending_review') {
$statusValue = 'pending';
}
return "<span class=\"labelx badge label-table label-" . $test->status . "\">" . $statusValue . "</span>";
});
//app('debugbar')->warning($tRequest['columns'][3]['data']);
//app('debugbar')->warning($tRequest['columns'][3]['search']['value']);
//$request['columns'][3]['search']['value'] = "RET";
$tRequest = $request->all();
//app('debugbar')->warning($tRequest['columns'][3]['search']['isNull']);
//if (($tRequest['columns'][3]['data'] == 'locaties') && (isset($tRequest['columns'][3]['search']['isNull']))) {
// app('debugbar')->warning($tRequest['columns'][3]);
// $datatable->whereNull('sctest_st.name');
//$datatable->whereNull('sctest_st.name');
//}
return $datatable->make(true);
}
