将数据重新整理到php中的新数组中

debugcn 发表于 Dev

MMMM

第一

Array
(
    [0] => Array
        (
            [member_id] => 1
            [total] => 0
            [sorting] => 0
        )

    [1] => Array
        (
            [member_id] => 2
            [total] => 0
            [sorting] => 1
        )

)

第二

Array
(   
    [0] => Array
        (
            [member_id] => 1
            [total] => 2
        )
    [1] => Array
        (
            [member_id] => 3
            [total] => 4
        )
)

很抱歉提出这个愚蠢的问题，我陷入了这个问题，因为我的逻辑思维能力很弱。

问题：如何将数据重新排列成如下所示的新数组（最终数据）。首先，如果第二个数组缺少成员数据，那么我需要从第一个数组中获取并将其存储到新数组中。除此之外，如果排序丢失，我需要从第一个数组中获取排序值。

最终数据

Array
(   
    [0] => Array
        (
            [member_id] => 1
            [total] => 2
            [sorting] => 0
        )
    [1] => Array
        (
            [member_id] => 2
            [total] => 0
            [sorting] => 1
        )
    [2] => Array
        (
            [member_id] => 3
            [total] => 4
            [sorting] => 2
         )
)

亚尼亚·帕塔克

您可以通过以下代码来实现：

  $a = Array
        (
        0 => Array
            (
            'member_id' => 1,
            'total' => 0,
            'sorting' => 0
        ),
        1 => Array
            (
            'member_id' => 2,
            'total' => 0,
            'sorting' => 1
        )
    ); 

 $b = Array
        (
        0 => Array
            (
            'member_id' => 1,
            'total' => 2
        ),
        1 => Array
            (
            'member_id' => 3,
            'total' => 4
        )
    );


   $new_array = [];
    foreach ($a as $key => $data) {
        $new_array[$key]['member_id'] = $data['member_id'];
        foreach ($b as $key_1 => $data_1) {
            if ($data['member_id'] == $data_1['member_id']) {
                $new_array[$key]['total'] = $data_1['total'];
                if (isset($data_1['sorting'])) {
                    $new_array[$key]['sorting'] = $data_1['sorting'];
                } else {
                    $new_array[$key]['sorting'] = $data['sorting'];
                }
                break;
            } else {
                $new_array[$key]['total'] = $data['total'];
                $new_array[$key]['sorting'] = $data['sorting'];
            }
        }
    }
    
    $new_array1 = [];
    foreach ($b as $key => $data) {
        if ($data['member_id'] != $new_array[$key]['member_id']) {
            $new_array1[$key]['member_id'] = $data['member_id'];
            $new_array1[$key]['total'] = $data['total'];
            if (!isset($data['sorting'])) {
                $new_array1[$key]['sorting'] = $new_array[$key]['sorting'] + 1;
            }
        }
    }

    $array_merge = array_merge($new_array, $new_array1);

最后结果：

  array:3 [▼
        0 => array:3 [▼
          "member_id" => 1
          "total" => 2
          "sorting" => 0
        ]
        1 => array:3 [▼
          "member_id" => 2
          "total" => 0
          "sorting" => 1
        ]
        2 => array:3 [▼
          "member_id" => 3
          "total" => 4
          "sorting" => 2
        ]
      ]

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。