/** * Process datatables ajax request. * Used by 'admin.sitemap.menuIndex' via 'this.getMenuIndex()' * @return \Illuminate\Http\JsonResponse */ public function allIndexData(Request $request, $sitemap_parent_id = 0) { $permissions = Permission::select(['id', 'name', 'label', 'description', 'updated_at']); $datatable = Datatables::of($permissions); //dd($datatable); $datatable->addColumn('action', function ($permission) { //<input class="btn btn-cons btn-awesome btn btn-cons btn-awesome btn btn-danger" value="Delete" type="submit"> $r = "<table><tr><td style='border:none'>"; $r .= '<a href="' . route('admin::permission.edit', ['id' => $permission->id]) . '" class="btn btn-success btn-labeled fa fa-pencil mar-rgt">Wijzigen</a>'; $r .= '</td><td>'; $r .= "<a class=\"btn btn-danger btn-labeled fa fa-trash-o\" onclick=\"wiDeletePermission(" . $permission->id . ")\">Verwijderen</a>"; $r .= '</td></td></table>'; return $r; }); $var = ''; $datatable->editColumn('label', function ($role) use($var) { $retval = "<div style='white-space: nowrap'>"; $retval .= $role->label; $retval .= "</div>"; return $retval; }); $datatable->editColumn('updated_at', function ($role) use($var) { //$retval = $role->updated_at ? with(new Carbon($role->updated_at))->diffForHumans() : ''; $retval = "<div class=\"extraDataxx\" style='xdisplay:none;white-space: nowrap'>"; $retval .= "<date>"; $retval .= $role->updated_at->formatLocalized('%A %d %B'); $retval .= " <i class=\"fa fa-clock-o\" aria-hidden=\"true\"></i>"; $retval .= $role->updated_at->format(' h:i'); $retval .= "</date>"; $retval .= "</div>"; return $retval; }); return $datatable->make(true); }