/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

3 votes189 views1 answer
Run laravel cron job on cpanel
PHP Laravel
9 votes183 views4 answers
Composer require laravel/ui for laravel 6
PHP Laravel
19 votes191 views6 answers
Laravel logger
PHP Laravel
2 votes171 views2 answers
Validator number laravel
PHP Laravel
0 vote189 views1 answer
Prevent xss attack in laravel
PHP Laravel
0 vote240 views1 answer
Cannot be cast automatically to type integer laravel
PHP Laravel
43 votes209 views6 answers
Laravel cache
PHP Laravel
0 vote174 views1 answer
Url() inside laravel config files
PHP Laravel
2 votes168 views1 answer
Redirect on validation error laravel to specific section laravel
PHP Laravel
2 votes177 views2 answers
Laravel validation unique email except self
PHP Laravel