我循环遍历两个存储过程的结果集,根据另一个存储过程中的字段获取结果.
包含结果集的两个数组是$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
)
...
)
上述结果需要按名称,标签,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
)
...
)
最后
以上就是刻苦棉花糖最近收集整理的关于php对数组某一字段求和_php – 在foreach中对数组中的项目进行分组和求和的全部内容，更多相关php对数组某一字段求和_php内容请搜索靠谱客的其他文章。
![tp5.1 php 记录集foreach for循环array_merge函数合拼、array_column函数组装成一维数组array[1,2,45]结果1：array[1,2,45]一、循环记录方法$useridarr[]=$v['user_id'];结果2：array[{id:1,titl:标题1},{id:2,titl:标题2}]二、php内置函数实现其它例子：php数组合并 要保持两个数组的键名都不变](https://file2.kaopuke.com:8081/files_image/reation/bcimg6.png)
发表评论 取消回复