dqxm14187
2016-07-14 02:10
浏览 53
已采纳

从数组中获得总和

I have 2 arrays that are shown below.

I need to get the sum of the progress (in the tasks array) for each milestone that it relates to.

So in the tasks array, I can see that the sum of the progress for 1578453e53090b (Wireframe milestone) is 15.

The ideal result would be to append the sum total of progress onto each milestone. Hope that makes sense.

$milestones = 
Array
(
[0] => Array
    (
        [id] => 1578453e53090b
        [milestone] => Wireframe
        [assigned_to] => 9
    )

[1] => Array
    (
        [id] => 1578453e530975
        [milestone] => Development
    )

[2] => Array
    (
        [id] => 1578453e530943
        [milestone] => Design
        [assigned_to] => 2
    )

)


$tasks =
Array
(
[0] => Array
    (
        [id] => 15786dc59333f2
        [status] => Open
        [progress] => 5
        [milestone] => 1578453e53090b
    )

[1] => Array
    (
        [id] => 15786dc669d451
        [status] => Open
        [progress] => 10
        [milestone] => 1578453e53090b
    )

[2] => Array
    (
        [id] => 15786dc7ccbea3
        [status] => Open
        [progress] => 20
        [milestone] => 1578453e530943
    )
)

图片转代码服务由CSDN问答提供 功能建议

我有2个数组如下所示。

我需要得到 与它相关的每个里程碑的进度总和(在任务数组中)。

因此在tasks数组中,我可以看到1578453e53090b(Wireframe里程碑)的进度总和 )是15。

理想的结果是将进度总和附加到每个里程碑。 希望这是有道理的。

  $ milestones = 
Array 
(
 [0] =>数组
(
 [id] => 1578453e53090b 
  [里程碑] =>线框
 [assigned_to] => 9 
)
 
 [1] =>数组
(
 [id] => 1578453e530975 
 [里程碑] => 开发
 
 
 
 [2] =>数组
(
 [id] => 1578453e530943 
 [里程碑] =>设计
 [assigned_to] => 2 
)
  
)
 
 
 $ tasks = 
Array 
(
 [0] =>数组
(
 [id] => 15786dc59333f2 
 [status] =>打开
 [ 进度] => 5 
 [里程碑] => 1578453e53090b 
)
 
 [1] =>数组
(
 [id] => 15786dc669d451 
 [状态] =>打开 
 [进度] => 10 
 [里程碑] => 1578453e53090b 
)
 
 [2] =>数组
(
 [id] => 15786dc7ccbea3 
 [status] =  >打开
 [进度] => 20 
 [里程碑] => 1578453e530943 
)
)
   
 
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dongshun5963 2016-07-14 02:22
    已采纳

    One of the ways to do this is to just use foreach. Use the first foreach for the milestones getting the ID that will match the second foreach for tasks in milestone.

    After that, use a simple $total container to be used continually andatch them using a simple if.

    foreach($milestones as &$m) {
                    //     ^ add reference to make changes
        $total = 0; // initialize total holder
        foreach($tasks as $task) {
            if($task['milestone'] === $m['id']) { // if it matches
                $total += $task['progress']; // add
            }
        }
    
        $m['total'] = $total; // after its done, add another key pair being total and its value
    }
    
    点赞 评论
  • duanmajing9332 2016-07-14 02:21

    Array mapping should do the trick:

    //will add 'progress' key to each milestone
    $tabulate_progress = function($milestone) use ($tasks) {
        $milestone['progress'] = 0; //start with 0 progress
    
        foreach($tasks as $task):
            //add to progress if we find a matching task
            if($task['milestone']===$milestone['id'])
                $milestone['progress']+=$task['progress'];
        endforeach;
    
        return $milestone;
    };
    $milestones = array_map($tabulate_progress,$milestones);
    

    Here's a demo.

    点赞 评论

相关推荐 更多相似问题