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 vote203 views2 answers
Laravel log to console
PHP Laravel
5 votes163 views1 answer
Php 8.1 release date
PHP
0 vote175 views1 answer
Laravel face-auth
PHP
0 vote201 views1 answer
Disable laravel cors
PHP Laravel
0 vote220 views1 answer
Access-control-allow-origin php laravel
PHP Laravel
0 vote256 views2 answers
Send html from datatable in laravel
PHP Laravel
2 votes188 views1 answer
Drupal 8 get nodes types
PHP Drupal
8 votes216 views4 answers
Laravel set date format
PHP Laravel
4 votes210 views2 answers
Add class to body class wordpress
PHP Wordpress
4 votes176 views6 answers
Class 'App\Http\Controllers\Artisan' not found
PHP