基于2个值的PHP减法多维数组

Question

我需要根据id和type从两个数组中减去qt，以保持数组的完整性。

我如何在php中能够减去这些数组？

我有两个数组：

=>这是第一个具有多键"down“的数组

Array
(
    [0] => Array
        (
            [id] => 26
            [loc] => 1
            [type] => down
            [qt] => 12
        )

    [1] => Array
        (
            [id] => 32
            [loc] => 1
            [type] => down
            [qt] => 34
        )

    [2] => Array
        (
            [id] => 26
            [loc] => 2
            [type] => down
            [qt] => 5
        )
        
    [3] => Array
        (
            [id] => 86
            [loc] => 3
            [type] => down
            [qt] => 45
        )
        
    [4] => Array
        (
            [id] => 23
            [loc] => 9
            [type] => down
            [qt] => 3
        )
    [5] => Array
        (
            [id] => 23
            [loc] => 3
            [type] => down
            [qt] => 99
        )
)

=> --这是第二个具有多键"up“的数组

Array
(
    [0] => Array
        (
            [id] => 26
            [loc] => 1
            [type] => up
            [qt] => 5
        )
    [1] => Array
        (
            [id] => 86
            [loc] => 3
            [type] => up
            [qt] => 27
        )
    [2] => Array
        (
            [id] => 23
            [loc] => 9
            [type] => up
            [qt] => 3
        )
)

=> i需要立方"qt“(如果"id”和"loc“相同，则减去"qt")

Array
(
    [0] => Array
        (
            [id] => 26
            [loc] => 1
            [type] => total
            [qt] => 7
        )

    [1] => Array
        (
            [id] => 32
            [loc] => 1
            [type] => total
            [qt] => 34
        )

    [2] => Array
        (
            [id] => 26
            [loc] => 2
            [type] => total
            [qt] => 5
        )
        
    [3] => Array
        (
            [id] => 86
            [loc] => 3
            [type] => total
            [qt] => 18
        )
        
    [4] => Array
        (
            [id] => 23
            [loc] => 9
            [type] => total
            [qt] => 0
        )
    [5] => Array
        (
            [id] => 23
            [loc] => 3
            [type] => down
            [qt] => 99
        )
)

Answer 1

试试这个

function findMatch($array, $id, $loc)
{
    foreach ($array as $key => $item) {
        if ($item["id"] == $id and $item["loc"] == $loc) {
            return $key;
        }
    }
    return false;
}

$total = [];
foreach($down as $d) {
    $matched = findMatch($up, $d["id"], $d["loc"]);
    if($matched !== false){
        $total[] = array_replace($d, [
            "type" => "total",
            "qt" => ($d["qt"] - $up[$matched]["qt"])
        ]);
    } else {
        $total[] = array_replace($d, ["type" => "total"]);
    }
}
print_r($total);