从php数组中删除重复值并合并数量

Question

我有一个名为$PRODUCTS_LIST的数组，它填充了数据，结构如下：

$products_list[] = [
                'manufacturer' => $manufacturer_name,
                'mpn' => $mpn,
                'description' => $description,
                'quantity' => $quantity,
                'condition' => $condition,
                'price' => $price
];

如果数组中的值具有相同的描述和条件，我正在尝试从数组中删除任何重复值，并合并重复值中的数量。
我尝试将数据设置为临时数组，以便能够将两个数组比较为foreach语句。类似这样的事情：

foreach($products_list as $key => $row) {

            if($test_data['description'] == $row['description'] && $test_data['isbn'] == $isbn)
            {
                echo $row['description'];
                echo $row['quantity']+$temp_quantity;
            }
                $test_data = [
                'description' => $row['description'],
                'isbn' => $row['isbn'],
                'quantity' => 
            ];      
}

Answer 1

不是从原始数组中删除，而是创建一个新的数组，用唯一的值填充该数组。

<?php
$products_list = [
    [
        'description' => 'foo',
        'condition' => 'foobar',
    ],
    [
        'description' => 'foo',
        'condition' => 'foobar',
    ],
    [
        'description' => 'hello',
        'condition' => 'hi',
    ]
];

$uniques = [];
foreach ($products_list as $productItem) {
    // loop through the uniques
    // if the `description` and `condition` match an existing one, don't add it
    foreach ($uniques as $uniqueItem) {
        if ($productItem['description'] == $uniqueItem['description']
            && $productItem['condition'] == $uniqueItem['condition']
        ) {
            // continue on both of the loops: 
            // 1) no need to loop over more unique items if you already found a match
            // 2) continuing of the `$products_list` loop will result in not adding the `productItem` to `$uniques`
            continue 2;
        }
    }
    
    $uniques[] = $productItem;
}

var_dump($uniques);

/*
array(2) {
  [0]=>
  array(2) {
    ["description"]=>
    string(3) "foo"
    ["condition"]=>
    string(6) "foobar"
  }
  [1]=>
  array(2) {
    ["description"]=>
    string(5) "hello"
    ["condition"]=>
    string(2) "hi"
  }
}

*/

Answer 2

这里有一个解决方案：

$products_list[] = [
    'manufacturer' => 'manufacturer1',
    'mpn' => 'mpn1',
    'description' => 'desc',
    'quantity' => 2,
    'condition' => 'condition',
    'price' => 10
];

$products_list[] = [
    'manufacturer' => 'manufacturer1',
    'mpn' => 'mpn1',
    'description' => 'desc',
    'quantity' => 3,
    'condition' => 'condition',
    'price' => 10
];

$products_list[] = [
    'manufacturer' => 'manufacturer2',
    'mpn' => 'mpn2',
    'description' => 'desc2',
    'quantity' => 4,
    'condition' => 'condition2',
    'price' => 15
];

$quantities   = [];

foreach ( $products_list as $product ) {
    $key = $product['description'].'|'.$product['condition']; // fields you want to compare
    if ( !isset($quantities[$key]) ) {
        $quantities[$key] = $product;
    } else {
        $quantities[$key]['quantity'] += $product['quantity'];
    }
}

$products   = array_values($quantities);

print_r($products);

结果是

Array ( [0] => Array ( [manufacturer] => manufacturer1 [mpn] => mpn1 [description] => desc [quantity] => 5 [condition] => condition [price] => 10 ) [1] => Array ( [manufacturer] => manufacturer2 [mpn] => mpn2 [description] => desc2 [quantity] => 4 [condition] => condition2 [price] => 15 ) )