sum unique data from multiple array

Question

I have two arrays from a different database, now I have to print it's in a table as a combined report. those arrays are

array:3 [▼
  0 => array:6 [▼
    "count_id" => 5
    "count_name" => "NE 28/1"
    "order_qty" => 75100
    "balance_qty" => 75100
    "stock_qty" => "0"
    "order_req" => 75100
  ]
  1 => array:6 [▼
    "count_id" => 13
    "count_name" => "NE 20/1 KH"
    "order_qty" => 2200
    "balance_qty" => 2200
    "stock_qty" => "48400"
    "order_req" => 0.0
  ]
]

and the second array

array:2 [▼
  0 => array:6 [▼
    "count_id" => 13
    "count_name" => "NE 20/1 KH"
    "order_qty" => 2200
    "balance_qty" => 2200
    "stock_qty" => "45420.85"
    "order_req" => 0.0
 ]
 1 => array:6 [▼
   "count_id" => 24
   "count_name" => "NE 24/1 KH"
   "order_qty" => 5150
   "balance_qty" => 5150
   "stock_qty" => "45420.85"
   "order_req" => 0.0
 ]
]

Now I need the common "count_name" Like "NE 20/1 KH" value will sum and print only once. Something Like...

array:3 [▼
  0 => array:6 [▼
    "count_id" => 5
    "count_name" => "NE 28/1"
    "order_qty" => 75100
    "balance_qty" => 75100
    "stock_qty" => "0"
    "order_req" => 75100
  ]
  1 => array:6 [▼
    "count_id" => 13
    "count_name" => "NE 20/1 KH"
    "order_qty" => 4400
    "balance_qty" => 4400
    "stock_qty" => "96800"
    "order_req" => 0.0
  ]
  2 => array:6 [▼
    "count_id" => 24
    "count_name" => "NE 24/1 KH"
    "order_qty" => 5150
    "balance_qty" => 5150
    "stock_qty" => "45420.85"
    "order_req" => 0.0
  ]
]

I try to do it by two foreach loop, but it's didn't work. it's print every data multiple time. so is there anyone to help me, please.

Union of the 2 queries should be enough. No need of PHP stuff. — mighty_dev
– mighty_dev, Commented Feb 12, 2020 at 14:07
Please always show what you tried, even if it was not successful. — misorude
– misorude, Commented Feb 12, 2020 at 14:11
Please share what you had tried to achieve it. community is not here to write down code for you. — Yagnik Detroja
– Yagnik Detroja, Commented Feb 12, 2020 at 14:13

BadHorsie · Accepted Answer · 2020-02-12 14:16:37Z

1

It can be done but probably just easier to combine them via the database query in the first place.

// Your arrays of data
$data = [$array1, $array2];

// The fields you want to sum
$sumFields = ['order_qty', 'balance_qty', 'stock_qty', 'order_req'];

// The final array
$combined = [];

foreach ($data as $arr) {
    foreach ($arr as $item) {
        $key = $item['count_id'];
        if (!isset($combined[$key])) {
            $combined[$key] = $item;
        } else {
            foreach ($sumFields as $field) {
                $combined[$key][$field] += $item[$field];
            }
        }
    }
}

// Print result
print_r($combined);

answered Feb 12, 2020 at 14:16

BadHorsie

14.6k31 gold badges127 silver badges196 bronze badges

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

Comments

Gamopo · Accepted Answer · 2020-02-12 14:11:29Z

0

You have to loop through them. This code should work

foreach($array1 as $elem1){
    $found = false;
    foreach($array2 as $elem2){
        if($elem1->count_id = $elem2->count_id){
            $found=true
            //Add elements from elem1 to elem2
            break;
        }
    }
    if(!$found){
        array_push($array2, $elem1)        
    }
}

I hope it helps.

answered Feb 12, 2020 at 14:11

Gamopo

1,5981 gold badge14 silver badges23 bronze badges

4 Comments

Gamopo Over a year ago

@YagnikDetroja can you share the result you get?

Yagnik Detroja Over a year ago

it's just pushing one new element in whole array. he didn't want to combine array. wanted to sum of all the value of array element which match in main array.

Gamopo Over a year ago

the code just pushes one new element if it was not found in the first array as described by op in the example. if the element is found then it should go to the //add elements part. See that 2 first arrays has 2 elements but desired one has 3, one combined and one pushed

Mustafa Nure Alam Over a year ago

@Gamopo thankyou to try to help me :) I try this code, but its returns only common data. it's already solved by another answer. thank you for your time... :)

Collectives™ on Stack Overflow

sum unique data from multiple array

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related