輸入陣列:
$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 求和。
<?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 )
)
*/
<?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);
}
groupSumByKey 即可,單次請求 < 50ms。GROUP BY。