Laravel sum group by

$docs = Document::groupBy('users_editor_id')
   ->selectRaw('sum(no_of_pages) as sum, users_editor_id')
   ->get(); //this return collection 

//In Blade
@foreach($docs as $doc)
	{{$doc->users_editor_id}} >-------< {{$doc->sum}}
@endforeach

Sql select sum group by id laravel

Document::groupBy('users_editor_id')
   ->selectRaw('sum(no_of_pages) as sum, users_editor_id')
   ->pluck('sum','users_editor_id');

   // originally lists(), which was deprecated in favour of pluck in 5.2
   // and dropped completely in 5.3
   // ->lists('sum','users_editor_id');


// returns array like this:
array(
  users_editor_id => sum,
  ...
)

Source: stackoverflow.com

Similar codes

0 vote155 views2 answers
How to replace multiple characters in a string in php
PHP
3 votes153 views4 answers
How to get last 10 digit from number in php
PHP
0 vote196 views1 answer
Which is file attributes in php
PHP
0 vote260 views1 answer
Wc php get order get coupon discount amount
PHP
0 vote192 views3 answers
Laravel has many deep
PHP Laravel
0 vote157 views1 answer
Convert text file to json php
PHP
0 vote205 views1 answer
Comment faire en sorte que le numéro de téléphone ne soit pas un champ obligatoire dans WooCommerce
PHP
18 votes147 views4 answers
Use if in laravel blade
PHP
7 votes194 views1 answer
Eloquent run seeder
PHP
6 votes165 views1 answer
Melhor linguagem de programação
PHP