PHP 数据聚合：根据一个数组对多个并行数组进行分组和求和

$statuses = ['PROSPECT', 'BACKLOG', 'PROSPECT'];
$of_tranxs = [2, 1, 2]; // 交易数量
$revs = [3, 1, 3];     // 收入
$mgps = [4, 1, 4];     // 毛利

array(
  'status' => ['PROSPECT', 'BACKLOG'],
  'of_tranx' => [4, 1], // PROSPECT: 2+2=4, BACKLOG: 1
  'rev' => [6, 1],      // PROSPECT: 3+3=6, BACKLOG: 1
  'mgp' => [8, 1]       // PROSPECT: 4+4=8, BACKLOG: 1
)

<?php
$statuses = ['PROSPECT', 'BACKLOG', 'PROSPECT'];
$of_tranxs = [2, 1, 2];
$revs = [3, 1, 3];
$mgps = [4, 1, 4];

$found = []; // 用于记录每个状态第一次出现的索引

foreach ($statuses as $index => $status) {
    if (!isset($found[$status])) {
        // 如果是第一次遇到该状态，记录其索引
        $found[$status] = $index;
        continue;
    }
    // 如果该状态已存在，将当前值累加到第一次出现的索引位置
    $of_tranxs[$found[$status]] += $of_tranxs[$index];
    $revs[$found[$status]] += $revs[$index];
    $mgps[$found[$status]] += $mgps[$index];

    // 删除当前重复状态及其对应的数据
    unset($statuses[$index], $of_tranxs[$index], $revs[$index], $mgps[$index]);
}

// 重新索引数组以消除被删除元素留下的空洞
$result = [
    'status' => array_values($statuses),
    'of_tranx' => array_values($of_tranxs),
    'rev' => array_values($revs),
    'mgp' => array_values($mgps)
];

var_export($result);
?>

array (
  'status' => 
  array (
    0 => 'PROSPECT',
    1 => 'BACKLOG',
  ),
  'of_tranx' => 
  array (
    0 => 4,
    1 => 1,
  ),
  'rev' => 
  array (
    0 => 6,
    1 => 1,
  ),
  'mgp' => 
  array (
    0 => 8,
    1 => 1,
  ),
)

<?php
$statuses = ['PROSPECT', 'BACKLOG', 'PROSPECT'];
$of_tranxs = [2, 1, 2];
$revs = [3, 1, 3];
$mgps = [4, 1, 4];

$result = [];
$newIndex = []; // 映射状态到新结果数组中的索引
$i = 0;         // 新结果数组的索引计数器

foreach ($statuses as $oldIndex => $status) {
    if (!isset($newIndex[$status])) {
        // 如果是第一次遇到该状态，在新结果数组中添加新条目
        $newIndex[$status] = $i++; // 记录新索引并递增
        $result['status'][] = $status;
        $result['of_tranx'][] = $of_tranxs[$oldIndex];
        $result['rev'][] = $revs[$oldIndex];
        $result['mgp'][] = $mgps[$oldIndex];
    } else {
        // 如果状态已存在，累加到对应的新索引位置
        $targetNewIndex = $newIndex[$status];
        $result['of_tranx'][$targetNewIndex] += $of_tranxs[$oldIndex];
        $result['rev'][$targetNewIndex] += $revs[$oldIndex];
        $result['mgp'][$targetNewIndex] += $mgps[$oldIndex];
    }
}

var_export($result);
?>

array (
  'status' => 
  array (
    0 => 'PROSPECT',
    1 => 'BACKLOG',
  ),
  'of_tranx' => 
  array (
    0 => 4,
    1 => 1,
  ),
  'rev' => 
  array (
    0 => 6,
    1 => 1,
  ),
  'mgp' => 
  array (
    0 => 8,
    1 => 1,
  ),
)

<?php
$statuses = ['PROSPECT', 'BACKLOG', 'PROSPECT'];
$of_tranxs = [2, 1, 2];
$revs = [3, 1, 3];
$mgps = [4, 1, 4];

$result = [];
$ref = []; // 存储每个状态的聚合数据，并通过引用连接到 $result

foreach ($statuses as $i => $status) {
    if (!isset($ref[$status])) {
        // 如果是第一次遇到该状态，创建新的聚合数据结构
        $ref[$status] = [
            'status' => $status,
            'of_tranx' => $of_tranxs[$i],
            'rev' => $revs[$i],
            'mgp' => $mgps[$i],
        ];
        // 将该聚合数据的引用推入结果数组
        $result[] = &$ref[$status];
    } else {
        // 如果状态已存在，通过引用直接更新聚合数据
        $ref[$status]['of_tranx'] += $of_tranxs[$i];
        $ref[$status]['rev'] += $revs[$i];
        $ref[$status]['mgp'] += $mgps[$i];
    }
}

var_export($result);
?>

array (
  0 => 
  array (
    'status' => 'PROSPECT',
    'of_tranx' => 4,
    'rev' => 6,
    'mgp' => 8,
  ),
  1 => 
  array (
    'status' => 'BACKLOG',
    'of_tranx' => 1,
    'rev' => 1,
    'mgp' => 1,
  ),
)