Adding query results to view

I have an EntityController and the index method gets all the Entities and sends them to the view where I display them in a table.

I have then created a basic SQL query to get a sum of all the Bills (one to many relationship) for each Entity. How do I then add this or pass this across to the Index view in order to show the total amount of Bills for each Entity in my table?

This is what I have so far:

    public function index()
    {
		// new bit that gets my SUM of bills
        $result = DB::select('SELECT entity_id, SUM(amount) FROM bills GROUP BY entity_id;');

        return view('app.entities.index')
            ->with('entities', Entity::all());
    }

I don't know if this is the best way of getting the SUM value but I looked around the docs etc. and couldn't see any alternatives.

So, is there a better way of getting the SUM and how do I pass that in with my Entity?

MichalOravec

5 years ago

Best Answer

Level 75

public function index()
{
    $entities = Entity::withSum('bills ', 'amount')->get();

    return view('app.entities.index', compact('entities'));
}

In view

@foreach ($entities as $entity) 
    {{ $entity->bills_sum_amount }}
@endforeach

Docs: https://laravel.com/docs/8.x/eloquent-relationships#other-aggregate-functions

1 like

SarahS

5 years ago

Level 12

Thank you, that's perfect and thanks for adding the link.

Please or to participate in this conversation.