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 vote253 views1 answer
How to write in php
PHP
0 vote301 views1 answer
Back() with errors in laravel
PHP Laravel
3 votes237 views2 answers
Acf options repeater
PHP
0 vote300 views1 answer
Wp functions ajax get
PHP Wordpress
33 votes224 views4 answers
Php switch
PHP
0 vote258 views1 answer
Access to this resource on the server is denied laravel
PHP Laravel
1 vote254 views3 answers
Display pdf file in laravel
PHP
0 vote228 views1 answer
How to increase wp mailster attachment size
PHP
0 vote259 views1 answer
Joomla cache programing clear
PHP
15 votes238 views1 answer
Composer install without dependencies
PHP