对于如此多的代码行，我提前表示歉意！请帮我重组阵列。现在我以这样的对象数组的形式接收数据（有条件地，可能会有更多情况）：
let dataToExpandToCheck= [
{
codePlatform: 'Platform 1',
codeInstance: 'Instance 1',
codeScheme: 'Scheme 1',
codeTable: 'Table 1",
columns: []
},
{
codePlatform: 'Platform 1',
codeInstance: 'Instance 1',
codeScheme: 'Scheme 1',
codeTable: 'Table 2",
columns: []
},
{
codePlatform: 'Platform 1',
codeInstance: 'Instance 1',
codeScheme: 'Scheme 2',
codeTable: 'Table 1",
columns: []
},
{
codePlatform: 'Platform 1',
codeInstance: 'Instance 2',
codeScheme: 'Scheme 1',
codeTable: 'Table 1",
columns: []
},
{
codePlatform: 'Platform 2',
codeInstance: 'Instance 1',
codeScheme: 'Scheme 1',
codeTable: 'Table 1",
columns: []
},
]
问题的本质是，一个平台（codePlatform）内可以有多个实例（codeInstance），一个实例内可以有多个不同的方案（codeScheme），方案内可以有多个不同的表（codeTable）。在我提供的数据中：有2个平台（1和2）。平台 1 内部有 2 个实例（1 和 2），实例 1 内部有模式 1 和模式 2，模式 1 中有 2 个表。在平台 2 上有一个实例、一个模式和一个表。
为了发送数据，我需要重写这个数组，以便 Platform 对象包含其名称和带有其实例的数组，每个实例的对象必须包含实例的名称和包含所有模式的数组，并且每个模式的对象包含其名称和包含表的数组（因此，表对象包括表的名称和其列的数组）。因此，最终数组应该是这样的（我再说一遍，在工作项目中有更多数据和更多选项）：
let restrArray = [
{
codePlatform: 'Platform 1',
instances: [
{
codeInstance: 'Instance 1',
schemes: [
{
codeScheme: 'Scheme1',
tables: [
{
codeTable: 'Table 1',
columns: []
},
{
codeTable: 'Table 2',
columns: []
}
]
},
{
codeScheme: 'Scheme 2',
tables: [
{
codeTable: 'Table 1',
columns: []
}
]
}
]
},
{
codeInstance: 'Instance 2',
schemes: [
{
codeScheme: 'Scheme1',
tables: [
{
codeTable: 'Table 1',
columns: []
}
]
}
]
}
]
},
{
codePlatform: 'Platform 2',
instances: [
{
codeInstance: 'Instance 1',
schemes: [
{
codeScheme: 'Scheme 1',
tables: [
{
codeTable: 'Table 1',
columns: []
}
]
}
]
}
]
}
]
我写下了算法，但它不能正常工作：在某些情况下它不会向平台对象添加实例，有时它会复制数组中的表。请帮助我理解如何重写算法：
const restructureFinalDataToSend = (
dataToExpandToCheck,
setRestructuredDataToSend
) => {
let newDataArray = [];
let instanceArray = [];
let instanceObject = {};
let schemesArray = [];
let schemeObject = {};
let tablesArray = [];
let tableObject = {};
let platformObject = {};
for (let i = 0; i < dataToExpandToCheck.length; i++) {
for (let j = 0; j < i; j++) {
if (
dataToExpandToCheck[j].codePlatform ===
dataToExpandToCheck[i].codePlatform
) {
if (
dataToExpandToCheck[j].codeInstance ===
dataToExpandToCheck[i].codeInstance
) {
if (
dataToExpandToCheck[j].codeScheme ===
dataToExpandToCheck[i].codeScheme
) {
tableObject = {
codeTable: dataToExpandToCheck[i].codeTable,
columns: dataToExpandToCheck[i].columns
};
tablesArray.push(tableObject);
schemeObject = {
codeScheme: dataToExpandToCheck[i].codeScheme,
tables: tablesArray
};
schemesArray.push(schemeObject);
instanceObject = {
codeInstance: dataToExpandToCheck[i].codeInstance,
schemes: schemesArray.reduce((o, i) => {
if (
!o.find((v) => v.codeScheme == i.codeScheme)
) {
o.push(i);
}
return o;
}, [])
};
instanceArray.push(instanceObject);
platformObject = {
codePlatform: dataToExpandToCheck[i].codePlatform,
instances: instanceArray.reduce((o, i) => {
if (
!o.find(
(v) => v.codeInstance == i.codeInstance
)
) {
o.push(i);
}
return o;
}, [])
};
newDataArray.push(platformObject);
} else {
schemeObject = {
codeScheme: dataToExpandToCheck[i].codeScheme,
tables: [
{
codeTable: dataToExpandToCheck[i].codeTable,
columns: dataToExpandToCheck[i].columns
}
]
};
schemesArray.push(schemeObject);
instanceObject = {
codeInstance: dataToExpandToCheck[i].codeInstance,
schemes: schemesArray
};
instanceArray.push(instanceObject);
platformObject = {
codePlatform: dataToExpandToCheck[i].codePlatform,
instances: instanceArray
};
newDataArray.push(platformObject);
}
} else {
instanceObject = {
codeInstance: dataToExpandToCheck[i].codeInstance,
schemes: [
{
codeScheme: dataToExpandToCheck[i].codeScheme,
tables: [
{
codeTable:
dataToExpandToCheck[i].codeTable,
columns: dataToExpandToCheck[i].columns
}
]
}
]
};
instanceArray.push(instanceObject);
platformObject = {
codePlatform: dataToExpandToCheck[i].codePlatform,
instances: instanceArray
};
newDataArray.push(platformObject);
}
} else {
platformObject = {
codePlatform: dataToExpandToCheck[i].codePlatform,
instances: [
{
codeInstance: dataToExpandToCheck[i].codeInstance,
schemes: [
{
codeScheme:
dataToExpandToCheck[i].codeScheme,
tables: [
{
codeTable:
dataToExpandToCheck[i]
.codeTable,
columns:
dataToExpandToCheck[i].columns
}
]
}
]
}
]
};
newDataArray.push(platformObject);
}
}
}
let resultArray = newDataArray.reduce((o, i) => {
if (!o.find((v) => v.codePlatform == i.codePlatform)) {
o.push(i);
}
return o;
}, []);
setRestructuredDataToSend(resultArray);
};
一个示例，其中使用临时文件
json来组织数据，然后使用Object.entries()我会建议另一种解决方案...一切都一次性完成。