/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

0 vote153 views1 answer
How to pass parameter to middleware from route in laravel
PHP Laravel
6 votes168 views2 answers
How many products can a laravel ecommerce handle
PHP Laravel
0 vote208 views1 answer
Auto reload for laravel
PHP Laravel
7 votes211 views5 answers
Laravel if else condition in blade file
PHP Laravel
11 votes190 views3 answers
How to remove composer package in laravel
PHP Laravel
12 votes217 views4 answers
Laravel get second last record
PHP Laravel
2 votes192 views4 answers
Laravel has many
PHP Laravel
6 votes178 views4 answers
Session has laravel blade
PHP Laravel
0 vote177 views1 answer
How pass optional route parameter in laravel
PHP Laravel
9 votes228 views4 answers
Laravel group route controller
PHP Laravel