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 vote177 views1 answer
Encrypt/decrypt data php
PHP
-1 vote167 views1 answer
Laravel seo
PHP
7 votes178 views5 answers
Laravel model update table
PHP
-2 votes148 views1 answer
Laravel trait command
PHP
1 vote203 views1 answer
Laravel export make comman
PHP Laravel
0 vote209 views1 answer
Install pusher package in laravel
PHP Laravel
0 vote181 views1 answer
Php reload after env
PHP
3 votes199 views1 answer
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file laravel
PHP Laravel
11 votes192 views2 answers
Command laravel for php artisan make :auth
PHP
5 votes189 views5 answers
Laravel file permissions
PHP