/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

2 votes126 views1 answer
Laravel model wherein update
PHP Laravel
1 vote138 views3 answers
Laravel model to array
PHP Laravel
0 vote143 views1 answer
Laravel collection reject
PHP Laravel
0 vote131 views1 answer
Laravel make view command
PHP Laravel
4 votes134 views2 answers
Laravel migration update table column type
PHP Laravel
1 vote132 views2 answers
Laravel required_with
PHP Laravel
0 vote128 views1 answer
Set config key dynamic laravel
PHP Laravel
19 votes127 views6 answers
Laravel updateOrCreate
PHP Laravel
4 votes133 views1 answer
Laravel validation numeric vs integer
PHP Laravel
0 vote130 views1 answer
Laravel Code To Rename file on server in the storage folder
PHP Laravel