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

6 votes143 views4 answers
Laravel blade foreach index value
PHP
16 votes144 views6 answers
Session laravel
PHP Laravel
4 votes247 views4 answers
Nginx codeigniter remove index.php
PHP CodeIgniter
0 vote99 views1 answer
Php howto ignore file with BOM
PHP
1 vote130 views1 answer
Wordpress print all categories
PHP Wordpress
11 votes126 views5 answers
Convert String to Date and Date-Time in PHP
PHP
1 vote111 views2 answers
Check installed php modules in linux
PHP
0 vote457 views1 answer
Route login not defined how to laravel problems fixed
PHP
1 vote124 views3 answers
Laravel model to array
PHP
5 votes201 views2 answers
Laravel redirect with message to section
PHP