PHP数组去重与结构化：避免循环中重复数据合并的最佳实践

<?php
$dataItems = [
    ['id' => 101, 'name' => 'Apple'],
    ['id' => 102, 'name' => 'Banana'],
    ['id' => 101, 'name' => 'Red Apple'], // Duplicate ID, will overwrite
    ['id' => 103, 'name' => 'Orange'],
];

$uniqueProducts = [];
foreach ($dataItems as $item) {
    // 使用 'id' 作为唯一键
    $uniqueProducts[$item['id']] = $item['name'];
}

print_r($uniqueProducts);
/* 输出:
Array
(
    [101] => Red Apple
    [102] => Banana
    [103] => Orange
)
*/
?>

<?php
// 模拟原始数据结构
class RawDataItem {
    public $name;
    public $value;
    public function __construct($name, $value) {
        $this->name = $name;
        $this->value = $value;
    }
}

$rawD = [
    new RawDataItem('moduleA', 'value1'),
    new RawDataItem('moduleB', 'value2'),
    new RawDataItem('moduleA', 'value3'), // moduleA的另一个相关项
    new RawDataItem('moduleC', 'value4'),
    new RawDataItem('moduleB', 'value5'), // moduleB的另一个相关项
];

$eRD = []; // 最终的结构化数组

foreach ($rawD as $rD) {
    // 模拟从数据库获取模块标题
    // 实际应用中 $findModule 和 $moduleTitleA 会通过查询获得
    $moduleTitleA = "Title for " . $rD->name; 

    // 检查是否已经为当前 $rD->name 创建了条目
    if (!isset($eRD[$rD->name])) {
        // 如果没有，则初始化一个包含 'items' 数组的结构
        $eRD[$rD->name] = [
            'moduleTitle' => $moduleTitleA, // 可以存储模块的通用标题
            'items' => []
        ];
    }

    // 将当前数据项添加到 'items' 数组中
    $eRD[$rD->name]['items'][] = [
        'name' => $rD->name, // 这里的name可能与moduleTitleA不同，取决于业务逻辑
        'value' => $rD->value
    ];
}

echo json_encode($eRD, JSON_PRETTY_PRINT);
/* 输出:
{
    "moduleA": {
        "moduleTitle": "Title for moduleA",
        "items": [
            {
                "name": "moduleA",
                "value": "value1"
            },
            {
                "name": "moduleA",
                "value": "value3"
            }
        ]
    },
    "moduleB": {
        "moduleTitle": "Title for moduleB",
        "items": [
            {
                "name": "moduleB",
                "value": "value2"
            },
            {
                "name": "moduleB",
                "value": "value5"
            }
        ]
    },
    "moduleC": {
        "moduleTitle": "Title for moduleC",
        "items": [
            {
                "name": "moduleC",
                "value": "value4"
            }
        ]
    }
}
*/
?>

<?php
// 假设这是从数据库获取的原始提交数据
$engs = [
    [
        'eSPY' => 'uuid1',
        'rawSubmittedData' => json_encode(['data' => [
            ['name' => 'field1', 'value' => 'valueA'],
            ['name' => 'field2', 'value' => 'valueB'],
            ['name' => 'field1', 'value' => 'valueC'], // field1重复
        ]]),
        'formName' => 'Form Alpha'
    ],
    [
        'eSPY' => 'uuid2',
        'rawSubmittedData' => json_encode(['data' => [
            ['name' => 'field3', 'value' => 'valueD'],
            ['name' => 'field1', 'value' => 'valueE'], // field1再次出现
        ]]),
        'formName' => 'Form Beta'
    ]
];

class QUICKQUES_Init {
    // 模拟数据库查询，根据ID获取模块信息
    public function thisElementByID($id) {
        $elements = [
            'field1' => ['pqfeElement' => json_encode(['qeTitle' => 'Field One Title'])],
            'field2' => ['pqfeElement' => json_encode(['qeTitle' => 'Field Two Title'])],
            'field3' => ['pqfeElement' => json_encode(['qeTitle' => 'Field Three Title'])],
        ];
        return $elements[$id] ?? null;
    }
}

$quickQues = new QUICKQUES_Init();
$ee2 = []; // 最终的输出数组

if (!empty($engs)) {
    foreach ($engs as $e) {
        $eRD = []; // 为每个 $e 重置 $eRD，确保其数据独立
        $rawData = json_decode($e['rawSubmittedData']);
        $rawD = $rawData->data;

        foreach ($rawD as $rD) {
            $findModule = $quickQues->thisElementByID($rD->name);

            if (!empty($findModule)) {
                $moduleTitle = json_decode($findModule['pqfeElement']);
                $moduleTitleA = $moduleTitle->qeTitle;

                // 核心逻辑：使用 $rD->name 作为键来结构化 $eRD
                if (!isset($eRD[$rD->name])) {
                    $eRD[$rD->name] = [
                        'moduleTitle' => $moduleTitleA, // 存储模块的通用标题
                        'items' => []
                    ];
                }
                // 将当前数据项添加到 'items' 数组中
                $eRD[$rD->name]['items'][] = [
                    'name' => $rD->name,
                    'value' => $rD->value
                ];
            }
        }

        // 将处理后的 $eRD 数组作为 'rawSubmittedData' 嵌入到 $ee2 中
        $ee2[] = [
            'eSPY' => $e['eSPY'],
            'submissionElementType' => $e['submissionElementType'] ?? 'default',
            'submittedBy' => $e['submittedBy'] ?? 'anon',
            'rawSubmittedData' => $eRD, // 嵌入结构化后的数据
            'isInternalForm' => $e['isInternalForm'] ?? false,
            'eSpyStatus' => $e['eSpyStatus'] ?? 'active',
            'lastUpdated' => $e['lastUpdated'] ?? date('Y-m-d H:i:s'),
            'formName' => $e['formName']
        ];
    }
}

echo json_encode(['engagements' => ['info' => $ee2]], JSON_PRETTY_PRINT);
?>