我正在遍历两个存储过程的结果集，根据另一个存储过程中的字段在一个存储过程中获取结果。

包含结果集的两个数组是 $customers 和 $subcustomers。

foreach($customers as $customer)
{
      foreach($subcustomers as $subcustomer)
      {
            if($subcustomer['parent'] == $customer['id'])
            {                        
                  if($customer['innumber'] == null && $subcustomer['innumber'] != null)
                  {                       
                      $chartInboundSub['name'] = $customer['name'];
                      $chartInboundSub['label'] = $subcustomer['innumber'];
                      $chartInboundSub['countInbound'] = $customer['count'];
                      $chartInboundSub['minsInbound'] = ceil($customer['duration'] / 60);
                      $chartInboundSub['customerid'] = $customer['id'];

                      array_push($out['chartInbound'], $chartInboundSub);
                  }
            }
       }
}

print_r($out['chartInbound']) 的当前输出如下:

Array
(
    [0] => Array
        (
            [countInbound] => 426
            [minsInbound] => 340
            [name] => Telekomm
            [label] => 01-02
            [customerid] => 6
        )

    [1] => Array
        (
            [countInbound] => 1
            [minsInbound] => 2
            [name] => Telekomm
            [label] => 01-02
            [customerid] => 6
        )

    [2] => Array
        (
            [countInbound] => 3
            [minsInbound] => 21
            [name] => Telekomm
            [label] => 080
            [customerid] => 6
        )

    [3] => Array
        (
            [countInbound] => 1920
            [minsInbound] => 15766
            [name] => Telekomm
            [label] => 084
            [customerid] => 6
        )

    [4] => Array
        (
            [countInbound] => 2332
            [minsInbound] => 17521
            [name] => Telekomm
            [label] => 084
            [customerid] => 6
        )
    ...
)

以上结果需要按name、label、customerid和countInbound和进行分组minsInbound 求和，所以:

期望的输出应该是:

Array
    (
        [0] => Array
            (
                [countInbound] => 427
                [minsInbound] => 342
                [name] => Telekomm
                [label] => 01-02
                [customerid] => 6
            )

        [1] => Array
            (
                [countInbound] => 3
                [minsInbound] => 21
                [name] => Telekomm
                [label] => 080
                [customerid] => 6
            )

        [2] => Array
            (
                [countInbound] => 4252
                [minsInbound] => 33287
                [name] => Telekomm
                [label] => 084
                [customerid] => 6
            )
        ...
    )

最佳答案

我认为这应该可行。我没有测试代码，所以我不做任何 promise 。

$map = array();
$i = 0;

foreach($customers as $customer)
{
      foreach($subcustomers as $subcustomer)
      {
            if($subcustomer['parent'] == $customer['id'])
            {                        
                  if($customer['innumber'] == null && $subcustomer['innumber'] != null)
                  {                       

                      $key = $customer['name'] . '/' . $subcustomer['innumber'] . '/' . $customer['id'];

                      if(isset($map[$key])) {
                            $out['chartInbound'][$map[$key]]['countInbound'] += $customer['count'];
                            $out['chartInbound'][$map[$key]]['minsInbound'] += ceil($customer['duration'] / 60);
                      }
                      else {
                          $out['chartInbound'][$i] = array(
                                  'name' => $customer['name'],
                                  'label' => $subcustomer['innumber'],
                                  'countInbound' => $customer['count'],
                                  'minsInbound' => ceil($customer['duration'] / 60),
                                  'customerid' => $customer['id'],
                          );
                          $map[$key] = $i++;
                    }
                  }
            }
       }
}

对于 name、label 和 customerid 的每个组合，它都会创建一个对于该组合​​必须唯一的字符串键。然后它检查是否已经有该键的任何数据(通过在 $out['chartInbound'] 中保留一个单独的键列表及其索引)。如果是这样，它只是添加 countInbound 和 minsInbound。如果不是，它会将整个 $chartInboundSub 放入 $out['chartInbound']。

请注意，这依赖于唯一的 key 。例如，如果您允许在名称中使用 /，则情况可能并非如此。

关于php - 在 foreach 中对数组中的项目进行分组和求和，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/31051451/