Is there a way to make row customizing methods work with this package? about laravel-datatables-fractal HOT 1 CLOSED

yajra commented on June 14, 2024

Is there a way to make row customizing methods work with this package?

from laravel-datatables-fractal.

Comments (1)

benyaminl commented on June 14, 2024

https://yajrabox.com/docs/laravel-datatables/master/response-fractal

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

https://yajrabox.com/docs/laravel-datatables/master/row-options

The methods above are extremely useful, why is fractal preventing their use?

Because with fractal it self you can return data on each row, than what's the point of adding columns with add Column or remove Column if you can change using fractal manually on the laravel transformer (TL:DR, it's redundant)?

Last time I also think I want to add Column but after learn about it's change the return as free as I want, I left addColumn if not needed.

eg :
user

id
username
branch
city
name
in transformer fractal you only need to

use DataTables;
use App\User;

Route::get('user-data', function() {
    $model = User::query();

    return DataTables::eloquent($model)
                ->setTransformer(function($item){
                    return [
                        'id'                      => (int) $item->id,
                        'name'                => $item->name,
                        'branch_city'       => $item->branch . $item->city,
                    ];
                })
                ->toJson();
});

Other than like this

use DataTables;
use App\User;

Route::get('user-data', function() {
    $model = User::query();

    return DataTables::eloquent($model)
                ->setTransformer(function($item){
                    return [
                        'id'                      => (int) $item->id,
                        'name'                => $item->name,
                    ];
                })
->addColumn('branch_city', function(User $user) {
                    return $item->branch . $item->city;
                })
                ->toJson();
});