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 vote63 views1 answer
Get wordpress id
PHP
0 vote189 views1 answer
How to Limit Excerpt Length in WordPress
PHP Wordpress
7 votes124 views6 answers
Remove foreign key constraint laravel
PHP Laravel
0 vote103 views1 answer
Htaccess set php memory limit
PHP
0 vote93 views1 answer
WordPress Convert Object To Array
PHP
0 vote98 views1 answer
WPML - Add a floating language switcher to the footer
PHP
3 votes116 views2 answers
Clear cache via route laravel
PHP Laravel
0 vote130 views1 answer
Laravel collection except
PHP Laravel
0 vote112 views2 answers
?? ' ' in php
PHP
0 vote117 views1 answer
Time zone set in codeigniter
PHP