/PHP/Laravel/Laravel join query sum example

Laravel join query sum example

Sql select sum group by id laravel join

$users = User::select('users*', 'analytics.*', DB::raw('SUM(analytics.revenue) As revenue'))
         ->leftJoin('analytics', 'analytics.user_id', '=', 'users.id')
         ->where('analytics.date', Carbon::today()->toDateString())
         ->get();

Source: stackoverflow.com

Laravel join query sum example

$users = User::select('users*', 'analytics.*', DB::raw('SUM(analytics.revenue) As revenue'))
         ->leftJoin('analytics', 'analytics.user_id', '=', 'users.id')
         ->where('analytics.date', Carbon::today()->toDateString())
         ->get();

Source: stackoverflow.com

Similar codes

1 vote320 views1 answer
Get specific columns using with() function in laravel eloquent
PHP Laravel
2 votes344 views2 answers
Laravel validate form data unique
PHP Laravel
10 votes346 views4 answers
Laravel create
PHP Laravel
0 vote329 views2 answers
Add blade in blade laravel
PHP Laravel
0 vote331 views2 answers
Laravel FileManager Display Blank pop up page
PHP Laravel
1 vote355 views1 answer
Inrandomorder laravel
PHP Laravel
0 vote321 views1 answer
Laravel validation if another record is not deleted / not null
PHP Laravel
0 vote388 views1 answer
Laravel migration add contraint to other database
PHP Laravel
0 vote323 views1 answer
Handling deadlocks laravel
PHP Laravel
0 vote330 views1 answer
Laravel compare request domain and app domain and request original domain
PHP Laravel