Laravel Datatables Sorting Appended Fields

Question

My Model Items is related to Rooms, which is related to Buildings, which is related to Locations.

Short: Items belongsTo Rooms belongsTo Buildings belongsTo Locations

At the index function of the ItemController I want to show a table of Items. I use Laravel Datatables. It works for 'simple' tables, but I ran into the problem of sorting/searching custom/appended fields, because they are not in the table of course.

Basically I want to join the Room, Building and Location Name for each Item in the displaying table.

This is my Items Model:

protected $appends = [
    'building_title',
    'location_title',
    'room_title',
];

public function getLocationTitleAttribute() {
    return $this->room->building->location->title;
}

public function getBuildingTitleAttribute() {
    return $this->room->building->title;
}

public function getRoomTitleAttribute() {
    return $this->room->title;
}

This is my Controller:

public function anyData()
{
    return Datatables::of(Item::query())->make(true);
}

What is the best approach to enable sorting/filtering for appended fields? Thank you for reading.

pr4xx · Accepted Answer · 2016-08-25 14:22:42Z

1

This is my solution (no appended fields were used):

public function anyData()
{
    $items = Item::join('rooms', 'items.room_id', '=', 'rooms.id')
        ->join('buildings', 'rooms.building_id', '=', 'buildings.id')
        ->join('locations', 'buildings.location_id', '=', 'locations.id')
        ->select([
            'items.id',
            'items.title',
            'items.label_number',
            'items.fibu_number',
            'rooms.title as room_title',
            'buildings.title as building_title',
            'locations.title as location_title'
        ]);
    return Datatables::of($items)->make(true);
}

answered Aug 25, 2016 at 14:22

pr4xx

5184 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel Datatables Sorting Appended Fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related