萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> PHP 程式設計

PHP 二維陣列按鍵值分組求和完整解法

問題描述

輸入陣列:

$a = [
    ['a' => 'aa', 'a1' => 1, 'a2' => 1],
    ['a' => 'bb', 'a1' => 2, 'a2' => 2],
    ['a' => 'cc', 'a1' => 3, 'a2' => 3],
    ['a' => 'aa', 'a1' => 1, 'a2' => 1],  // 重複鍵 aa
    ['a' => 'bb', 'a1' => 5, 'a2' => 5],  // 重複鍵 bb
];

期望輸出:相同 a 值的記錄合併,數值欄位 a1、a2 求和。

方案一:鍵值索引法 (O(n)、最推薦)

<?php
function groupSumByKey(array $data, string $groupKey, array $sumKeys): array
{
    $result = [];
    foreach ($data as $row) {
        $key = $row[$groupKey] ?? null;
        if ($key === null) continue; // 或拋出異常

        if (!isset($result[$key])) {
            $result[$key] = $row; // 首次出現,直接複製
        } else {
            // 後續出現,累加指定欄位
            foreach ($sumKeys as $sumKey) {
                if (isset($row[$sumKey], $result[$key][$sumKey])) {
                    $result[$key][$sumKey] += $row[$sumKey];
                }
            }
        }
    }
    return array_values($result); // 重置索引
}

// 使用
$data = [
    ['a' => 'aa', 'a1' => 1, 'a2' => 1],
    ['a' => 'bb', 'a1' => 2, 'a2' => 2],
    ['a' => 'cc', 'a1' => 3, 'a2' => 3],
    ['a' => 'aa', 'a1' => 1, 'a2' => 1],
    ['a' => 'bb', 'a1' => 5, 'a2' => 5],
];

$merged = groupSumByKey($data, 'a', ['a1', 'a2']);
print_r($merged);
/*
Array
(
    [0] => Array ( [a] => aa [a1] => 2 [a2] => 2 )
    [1] => Array ( [a] => bb [a1] => 7 [a2] => 7 )
    [2] => Array ( [a] => cc [a1] => 3 [a2] => 3 )
)
*/

方案二:array_reduce 函數式寫法 (PHP 7.4+ 箭頭函數)

<?php
$merged = array_reduce($data, function ($carry, $row) {
    $key = $row['a'];
    if (!isset($carry[$key])) {
        $carry[$key] = $row;
    } else {
        $carry[$key]['a1'] += $row['a1'];
        $carry[$key]['a2'] += $row['a2'];
    }
    return $carry;
}, []);

$merged = array_values($merged);

方案三:資料庫層面聚合 (大數據量首選)

若數據源自資料庫,**直接用 SQL 聚合** 避免 PHP 端載入大量數據:

SELECT `a`, SUM(`a1`) AS a1_sum, SUM(`a2`) AS a2_sum
FROM your_table
GROUP BY `a`
ORDER BY `a`;

PHP 僅負責執行查詢並輸出結果,記憶體佔用 O(1)。

擴展:多欄位分組 + 多聚合函數

<?php
function advancedGroupBy(array $data, array $groupKeys, array $aggregations): array
{
    // $aggregations = ['sum' => ['a1','a2'], 'avg' => ['score'], 'count' => '*'];
    $groups = [];
    
    foreach ($data as $row) {
        $keyParts = [];
        foreach ($groupKeys as $k) {
            $keyParts[] = $row[$k] ?? 'NULL';
        }
        $key = implode('|', $keyParts);
        
        if (!isset($groups[$key])) {
            $groups[$key] = [
                'group' => array_intersect_key($row, array_flip($groupKeys)),
                'sum'   => [],
                'avg'   => ['_count' => 0],
                'min'   => [],
                'max'   => [],
            ];
        }
        $g = &$groups[$key];
        
        // SUM
        foreach ($aggregations['sum'] ?? [] as $field) {
            $g['sum'][$field] = ($g['sum'][$field] ?? 0) + ($row[$field] ?? 0);
        }
        // AVG (累加 + 計數)
        foreach ($aggregations['avg'] ?? [] as $field) {
            $g['avg'][$field] = ($g['avg'][$field] ?? 0) + ($row[$field] ?? 0);
            $g['avg']['_count']++;
        }
        // MIN/MAX
        foreach (['min','max'] as $type) {
            foreach ($aggregations[$type] ?? [] as $field) {
                $val = $row[$field] ?? null;
                if ($val !== null) {
                    if (!isset($g[$type][$field]) || ($type === 'min' ? $val < $g[$type][$field] : $val > $g[$type][$field])) {
                        $g[$type][$field] = $val;
                    }
                }
            }
        }
    }
    
    // 計算平均值
    foreach ($groups as &$g) {
        if ($g['avg']['_count'] > 0) {
            foreach ($g['avg'] as $field => $sum) {
                if ($field !== '_count') $g['avg'][$field] = $sum / $g['avg']['_count'];
            }
        }
        unset($g['avg']['_count']);
    }
    
    return array_values($groups);
}

效能建議

  • 資料量 < 10 萬:PHP 端 groupSumByKey 即可,單次請求 < 50ms。
  • 資料量 10 萬~100 萬:考慮分塊處理或資料庫 GROUP BY。
  • 資料量 > 100 萬:**必須在資料庫層面聚合**,PHP 僅做展示。
  • 頻繁查詢:Redis 緩存聚合結果,資料變更時失效/更新。
copyright © 萬盛學電腦網 all rights reserved