Skip to content
Icon

WARNING You're browsing the documentation for an old version of LARAVEL-DATATABLES. Consider upgrading your project to laravel-datatables 11.0.

Response using Transformer

When using tranformer, all response manipulations must be done via transformer. Thus addColumn, editColumn, removeColumn, setRowAttr, setClassAttr, etc... should be avoided when using fractal.

use Datatables;
use App\Transformers\UserTransformer;
 
Route::get('user-data', function() {
$model = App\User::query();
 
return Datatables::eloquent($model)
->setTransformer(new UserTransformer)
->make(true);
});

Create your transformer. app\Transformers\UserTransformer.php

namespace App\Transformers;
 
use App\User;
use League\Fractal\TransformerAbstract;
 
class UserTransformer extends TransformerAbstract
{
protected $availableIncludes = ['posts'];
 
/**
* @param \App\User $user
* @return array
*/
public function transform(User $user)
{
return [
'id' => (int) $user->id,
'name' => $user->name,
'email' => $user->email,
'created_at' => (string) $user->created_at,
'updated_at' => (string) $user->updated_at,
];
}
 
/**
* @param \App\User $user
* @return \League\Fractal\Resource\Collection
*/
public function includePosts(User $user)
{
$posts = $user->posts;
 
return $this->collection($posts, new PostTransformer);
}
}