/PHP/Laravel/Laravel join query sum example

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 vote358 views1 answer
Laravel recursive relationships
PHP Laravel
0 vote327 views1 answer
How to pass token with post request laravel
PHP Laravel
0 vote317 views1 answer
Only get selected value from has many ralation laravel
PHP Laravel
0 vote350 views1 answer
Php/Laravel check if date is passed
PHP Laravel
0 vote357 views1 answer
Array helper array_push laravel
PHP Laravel
0 vote317 views1 answer
Counting time execution duration in time laravel
PHP Laravel
4 votes299 views2 answers
Laravel form method delete
PHP Laravel
0 vote320 views1 answer
Laravel query builder select first
PHP Laravel
0 vote347 views2 answers
Laravel get url without domain in blade
PHP Laravel
0 vote337 views1 answer
Configuration laravel dompdf
PHP Laravel