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 vote290 views1 answer
Laravel datepicker date format
PHP
0 vote299 views1 answer
Php add 1 day hours to unix timestamp
PHP
1 vote368 views2 answers
Laravel gmail
PHP Laravel
0 vote303 views1 answer
Php artisan make migrate different folder
PHP
2 votes336 views2 answers
Laravel valet 504 gateway time-out
PHP Laravel
0 vote273 views1 answer
Php is_assoc
PHP
1 vote343 views1 answer
Get advanced custom field value in wordpress
PHP Wordpress
0 vote278 views1 answer
Php show number 4 digit
PHP
1 vote315 views1 answer
Strupper
PHP
0 vote343 views1 answer
Check for headers laravel
PHP