Laravel withCount elements in related and subrealted table

Question

I'm building application with Laravel, Inertiajs and Vue3. There are three key tables in application: Operators, Locations and Terminals. Terminals belongs to Locations and Locations belongs to Operators. There is no direct relations between Operators and Terminals. I would like to display list of Operators with counting locations and counting their terminals.

For example. Operator John Doe have 3 locations. Every his location have 3 terminals. Result should be:

John Doe | 3 | 9

something like this:

$operators = Operator::countWith('locations')->countWith('locations.terminals')->get()

Of course, this doesn't work, but is there some similar options to get this counts?

Mirsad Batilovic · Accepted Answer · 2025-02-07 22:49:49Z

0

I find solution in Laravel documentation eloquent relationships hasManyThrough

In Operator Model I create terminals method

public function terminals(): HasManyThrough {
        return $this->hasManyThrough(Terminal::class, Location::class);
    }

and in OperatorController index method

public function index() {
    $operators = Operator::withCount('locations')->withCount('terminals')->get();
    return Inertia::render('Operator/Index', [
        'operators' => OperatorResource::collection($operators)
    ]);
}

In OperatorResource toArray method

public function toArray(Request $request): array {
    return [
        'id' => $this->id,
        'name' => $this->name,
        'locations_count' => $this->locations->count(),
        'terminals_count' => $this->terminals->count(),
    ];
}

answered Feb 7 at 22:49

Mirsad Batilovic

4411 gold badge5 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Laravel withCount elements in related and subrealted table

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