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

5 votes139 views3 answers
Get users of specific role laravel role spatie
PHP
0 vote161 views1 answer
Mongodb/mongodb[dev-master, 1.10.0, ..., v1.10.x-dev] require ext-mongodb ^1.11.0 -> it is missing from your system. Install or enable PHP's mongodb extension
PHP
37 votes156 views6 answers
Php remove last character in string
PHP
0 vote155 views1 answer
Symfony how to respond in-memory file
PHP Symfony
0 vote124 views1 answer
Php page sends cookie to visitor
PHP
0 vote138 views1 answer
WithErrors laravel
PHP
4 votes156 views1 answer
How to check query execution time in laravel
PHP Laravel
1 vote125 views1 answer
Ubuntu fopen failed to open stream: Permission denied
PHP
8 votes133 views6 answers
Session in laravel
PHP
4 votes139 views1 answer
Wp enqueue
PHP