[PHP知识库]PHP自定义函数之计算别名序列数组的差集

示例

$asName = 'ids';
$newData = [
    ['ids'=>'100001','value'=>1],
    ['ids'=>'100003','value'=>2],
    ['ids'=>'100004','value'=>4],
    ['ids'=>'100005','value'=>5],
];

$oldData = [
    ['ids'=>'100001','value'=>1],
    ['ids'=>'100002','value'=>2],
    ['ids'=>'100003','value'=>3],
    ['ids'=>'100004','value'=>4],
];

$c = aliasArrayDiff($newData, $oldData,$asName);
var_dump($c);
/*
^ array:4 [
  "add" => array:1 [
    0 => array:3 [
      "ids" => "100005"
      "value" => 5
      "store_id" => 10001
    ]
  ]
  "delete" => array:1 [
    0 => array:3 [
      "ids" => "100002"
      "value" => 2
      "store_id" => 10001
    ]
  ]
  "update" => array:1 [
    0 => array:3 [
      "ids" => "100003"
      "value" => 2
      "store_id" => 10001
    ]
  ]
  "unchanged" => array:2 [
    0 => array:3 [
      "ids" => "100001"
      "value" => 1
      "store_id" => 10001
    ]
    1 => array:3 [
      "ids" => "100004"
      "value" => 4
      "store_id" => 10001
    ]
  ]
]
*/

代码

/**
 * 计算别名序列数组的差集
 *
 * @param array $newData 待比对数组1
 * @param array $oldData 待比对数组2
 * @param string $asName [可选]默认goods_id，对比数组中同时持有的依据key名称
 * @param array $attach  [可选]公共附带数据
 *
 * @return array
 * array.add[]
 * array.delete[]
 * array.update[]
 * array.unchanged[]
 */
function aliasArrayDiff(array $newData,array $oldData,
                                       string $asName='goods_id', array $attach=[])
{
    // 提取指定下标数据，返回索引数组
    $extractArrayAs = function($data, $asName){
        $_d = [];
        array_map(function($d) use (&$_d, $asName){$_d[]=$d[$asName];}, $data);
        return $_d;
    };
    $_newAsData = $extractArrayAs($newData, $asName);
    $_oldAsData = $extractArrayAs($oldData, $asName);

    // 格式化新数据
    $_asNewData = [];
    array_map(function($item) use (&$_asNewData, $asName){
        $_asNewData[$item[$asName]] = $item;
    }, $newData);

    // 比较差异 - 待删除的
    $_delete = array_diff($_oldAsData, $_newAsData);
    $_delete = array_values($_delete);

    // 比较差异 - 待新增的
    $_newAdd = array_diff($_newAsData, $_oldAsData);
    $_newAdd = array_values($_newAdd);

    // 比较差异 - 待更新的
    $_update = [];
    array_map(function($item)
    use (&$_update, $_asNewData, $asName) {
    	// 更新：2021/11/11 对比存在纰漏问题修复
        if (isset($_asNewData[$item[$asName]]) &&
            array_diff_assoc(array_values($item), array_values($_asNewData[$item[$asName]]))) {
            $_update[] = $item[$asName];
        }
    }, $oldData);

    // 归类数据
    $_data = ['add'=>[],'delete'=>[],'update'=>[],'unchanged'=>[]];
    $_mergeData = array_merge($oldData, $newData);
    foreach ($_mergeData AS $i => $item)
    {
        $item = array_merge($item, $attach);
        $_keyValue = $item[$asName];
        if (in_array($_keyValue, $_delete)) {
            $_data['delete'][] = $item;
        }elseif (in_array($_keyValue, $_newAdd)) {
            $_data['add'][] = $item;
        }elseif (in_array($_keyValue, $_update)) {
            $_data['update'][$_keyValue] = $item;
        }else{
            $_data['unchanged'][$_keyValue] = $item;
        }
    }
    $_data['update'] = array_values($_data['update']);
    $_data['unchanged'] = array_values($_data['unchanged']);

    return $_data;
}