![]()
WARNING You're browsing the documentation for an upcoming version of Laravel DataTables. The documentation and features of this release are subject to change.
Additional Data Response
You can add additional server data on your response by using with
api.
Adding response using key and value
use DataTables; Route::get('user-data', function() { $model = App\User::query(); return DataTables::eloquent($model) ->with('posts', 100) ->with('comments', 20) ->toJson();});
Adding response using array
use DataTables; Route::get('user-data', function() { $model = App\User::query(); return DataTables::eloquent($model) ->with([ 'posts' => 100, 'comments' => 20, ]) ->toJson();});
Adding response with closure.
use DataTables; Route::get('user-data', function() { $model = App\User::query(); return DataTables::eloquent($model) ->with('count', function() use ($model) { return $model->count(); }) ->toJson();});
Adding response with query callback.
This is for Query and Eloquent instance only,
use DataTables; Route::get('user-data', function() { $model = App\User::query(); return DataTables::eloquent($model) ->withQuery('count', function($filteredQuery) { return $filteredQuery->count(); }) ->toJson();});
Example Response
{ "draw": 1, "recordsTotal": 10, "recordsFiltered": 3, "data": [{ "id": 476, "name": "Esmeralda Kulas", "created_at": "2016-07-31 23:26:14", "updated_at": "2016-07-31 23:26:14", "deleted_at": null, "superior_id": 0 }, { "id": 6, "name": "Zachery Muller", "created_at": "2016-07-31 23:25:43", "updated_at": "2016-07-31 23:25:43", "deleted_at": null, "superior_id": 1 }], "posts": 100, "comments": 20}