PHP array combine values - laravel

Question

I have an data model for sales that looks like:

| id | dist_abbv | invoice | account | brand | quantity

Now when I dump out an account sales I will get an array (actually a laravel collection) like:

[0]=>Sale

     "id" => 2113
     "dist_abbv" => "CARDMT"
     "date" => "2016-06-23"
     "invoice" => 597935
     "brand" => "ID46C"
     "quantity" => 1
     "account_vip_id" => 10010

How can I loop through this and combine all the same brands and total up the quantity? So opposed to 10 entries with only 2 different brands I get 2 entries with each brands total sales?

Zakaria Acharki · Accepted Answer · 2016-10-27 22:52:40Z

3

Try to use :

DB::table('sales')
   ->select('brand', 'sum(quantity) as total')
   ->groupBy('brand')
   ->get();

Hope this helps.

answered Oct 27, 2016 at 22:52

Zakaria Acharki

67.5k15 gold badges79 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP array combine values - laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related