Laravel query failed using function query

Question

I am trying to get sum of amount of all users group by month.But if I add sum then query not work.It return amount log as blank array But without sum query return all logs data as monthly.

My query

$reports = $user->whereHas('groups', function ($query) use($acceptedGroup) {
    $query->whereIn('groups.name',$acceptedGroup);
})->with(
    array(
        'amountLogs' => function($query) use($year){
            $query
            ->select(
                DB::raw('sum(amount) as total')
            )
                ->whereYear('created_at','=',  $year)
                ->groupBy(DB::raw("MONTH(created_at)",'user_id'))->get();
        })
);

If I remove

            ->select(
                DB::raw('sum(amount) as total')
            )

Then query works

What version of laravel are you on? Try selectRaw instead of select — SrThompson
– SrThompson, Commented Sep 30, 2018 at 22:21

Jason · Accepted Answer · 2018-09-30 22:26:45Z

2

If you creating a specific select on a relationship in your query, you also need to include the foreign key to the related table (in your case, probably the users table)

->select(
   'user_id',
    DB::raw('sum(amount) as total')
)

This allows Eloquent to relate the records after loading from the database.

answered Sep 30, 2018 at 22:26

Jason

3,0402 gold badges24 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Laravel query failed using function query

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