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 vote171 views2 answers
Laravel schedule run
PHP
0 vote171 views1 answer
Php webpage to string
PHP
0 vote142 views1 answer
Woocommerce change place order button text
PHP
1 vote173 views1 answer
Wordpress get perma link
PHP Wordpress
5 votes182 views4 answers
Wordpress get plugin root directory
PHP Wordpress
1 vote180 views1 answer
Php transform associative array to array
PHP
0 vote178 views1 answer
Wordpress show notice only on plugin page
PHP
0 vote185 views1 answer
Laravel reset autoload
PHP Laravel
0 vote160 views2 answers
Carbon Format date with timezone in views Laravel
PHP
0 vote161 views2 answers
Yii2 activerecord bulk insert
PHP