PHP找出专题下重复的商品数据

一、前言

1、问题描述

• 已知：二维数组的数据：id 主键ID；special_id 专题ID；goods_id 专题关联的商品ID
• 求：每个专题里重复商品的主键ID

2、基本思路

• 1、把数据处理成专题ID为键，里面包含单个专题的所有商品。
• 2、循环处理后的数据，循环商品数据，找出重复商品数据的主键ID

二、代码

//PHP找出专题下重复的商品数据
public function test() {
    //待处理的数据：id 主键ID；special_id 专题ID；goods_id 专题关联的商品ID
    $data = [
        ['id' => 1, 'special_id' => 1, 'goods_id' => 1],
        ['id' => 2, 'special_id' => 1, 'goods_id' => 2],
        ['id' => 3, 'special_id' => 1, 'goods_id' => 3],
        ['id' => 4, 'special_id' => 1, 'goods_id' => 1],

        ['id' => 5, 'special_id' => 2, 'goods_id' => 2],
        ['id' => 6, 'special_id' => 2, 'goods_id' => 3],
        ['id' => 7, 'special_id' => 2, 'goods_id' => 4],
        ['id' => 8, 'special_id' => 2, 'goods_id' => 3],

        ['id' => 9, 'special_id' => 3, 'goods_id' => 5],
        ['id' => 10, 'special_id' => 3, 'goods_id' => 5],
        ['id' => 11, 'special_id' => 3, 'goods_id' => 5],
        ['id' => 12, 'special_id' => 3, 'goods_id' => 5],

        ['id' => 13, 'special_id' => 4, 'goods_id' => 1],
        ['id' => 14, 'special_id' => 4, 'goods_id' => 2],
        ['id' => 15, 'special_id' => 4, 'goods_id' => 3]
    ];


    //把数据按special_id分组，处理成以special_id为键，里面是关联的商品数据（二维数组）
    $deleteId = $specialList = [];
    foreach ($data as $value) {
        $specialList[$value['special_id']][] = $value;
    }

    //循环每一个专题下的商品数据，查找出有重复商品的主键ID
    foreach ($specialList as $specialId => $value) {
        $goodsIds = []; //单个专题下的商品ID（一维数组）
        foreach ($value as $goodsInfo) {    //循环单个专题下的所有商品
            $goodsId = $goodsInfo['goods_id'];

            if (in_array($goodsId, $goodsIds)) {    //如果商品ID已存在，则说明重复了
                $deleteId[] = $goodsInfo['id'];  //删除的主键ID追加
                continue;   //跳出本次循环，直接执行下一次循环
            }

            $goodsIds[] = $goodsId; //单个专题下的商品ID追加
        }
    }

    if ($deleteId) {
        exit("重复数据的ID为 [" . implode(',', $deleteId) . "]");
    }else{
        exit("专题下无重复的商品数据");
    }
}

三、打印

重复数据的ID为 [4,8,10,11,12]