从对象数组中创建唯一的对象

Question

我当前的数据结构如下所示，它是根据一个名为" submitId "的属性分组的

{
bc3827d9c21548f8b1ae072ceab4ce6d: [
{...}
],
5ee08c723e1d40b0af716ea3e18c6114: [
{...}
],
886b149dfe1241efac863d0532b7d847: [
{...}
]
}

基于单个submitd的实际数据如下所示

// ACTUAL DATA
{
bc3827d9c21548f8b1ae072ceab4ce6d: [
{
status: 'FINISHED',
start: '2022-05-26 05:01:00.0',
end: '2022-05-28 05:01:00.0',
submissionRank: 112,
submitId: 'bc3827d9c21548f8b1ae072ceab4ce6d',
code: 'ATL',
indicator: 0,
addBy: 30,
delayBy: 0,
pstat: 'DATA GATHERED',
fstat: 'FINISHED',
},
{
status: 'FINISHED',
start: '2022-05-26 05:01:00.0',
end: '2022-05-28 05:01:00.0',
submissionRank: 112,
submitId: 'bc3827d9c21548f8b1ae072ceab4ce6d',
code: 'AAA',
indicator: 0,
addBy: 30,
delayBy: 0,
pstat: 'DATA GATHERED',
fstat: 'FINISHED',
},
{
status: 'FINISHED',
start: '2022-05-26 05:01:00.0',
end: '2022-05-28 05:01:00.0',
submissionRank: 112,
submitId: 'bc3827d9c21548f8b1ae072ceab4ce6d',
code: 'AAA',
indicator: 1,
addBy: 30,
delayBy: 0,
pstat: 'DATA GATHERED',
fstat: 'FINISHED',
},
{
status: 'FINISHED',
start: '2022-05-26 05:01:00.0',
end: '2022-05-28 05:01:00.0',
submissionRank: 112,
submitId: 'bc3827d9c21548f8b1ae072ceab4ce6d',
code: 'ATL',
indicator: 1,
addBy: 30,
delayBy: 0,
pstat: 'DATA GATHERED',
fstat: 'FINISHED',
},
]
}

对于给定的'submitId，唯一对象由唯一的"代码"组合组成，如果所有对象出于相同的原因都有1和0，则指示符设置为1，但如果0和1混合，则设置为"both"。唯一对象需要如下所示:

{
status: 'FINISHED',
start: '2022-05-26 05:01:00.0',
end: '2022-05-28 05:01:00.0',
submissionRank: 112,
submitId: 'bc3827d9c21548f8b1ae072ceab4ce6d',
code: 'ATL, AAA', <--- unique codes
indicator: 'both', <--- if indicator is even mix of 0 and 1 then 'both'
addBy: 30,
delayBy: 0,
pstat: 'DATA GATHERED',
fstat: 'FINISHED',
},

请帮忙!

Answer 1

您可以使用reduce和filter来解析这个任务:

let obj = {
uuid: [
{
status: "FINISHED",
start: "2022-05-26 05:01:00.0",
end: "2022-05-28 05:01:00.0",
submissionRank: 112,
submitId: "bc3827d9c21548f8b1ae072ceab4ce6d",
code: "ATL",
indicator: 1,
addBy: 30,
delayBy: 0,
pstat: "DATA GATHERED",
fstat: "FINISHED",
},
{
status: "FINISHED",
start: "2022-05-26 05:01:00.0",
end: "2022-05-28 05:01:00.0",
submissionRank: 112,
submitId: "bc3827d9c21548f8b1ae072ceab4ce6d",
code: "AAA",
indicator: 1,
addBy: 30,
delayBy: 0,
pstat: "DATA GATHERED",
fstat: "FINISHED",
},
{
status: "FINISHED",
start: "2022-05-26 05:01:00.0",
end: "2022-05-28 05:01:00.0",
submissionRank: 112,
submitId: "bc3827d9c21548f8b1ae072ceab4ce6d",
code: "AAA",
indicator: 1,
addBy: 30,
delayBy: 1,
pstat: "DATA GATHERED",
fstat: "FINISHED",
},
{
status: "FINISHED",
start: "2022-05-26 05:01:00.0",
end: "2022-05-28 05:01:00.0",
submissionRank: 112,
submitId: "bc3827d9c21548f8b1ae072ceab4ce6d",
code: "ATL",
indicator: 0,
addBy: 30,
delayBy: 1,
pstat: "DATA GATHERED",
fstat: "FINISHED",
},
],
};
let one = false;
let zero = false;
let codes = [];

let res = obj.uuid.reduce((t, v, i) => {
let = indicator = v.indicator;
let = code = v.code;
if (indicator === 0) zero = true;
else if (indicator === 1) one = true;
if (zero && one) indicator = `both`;
else indicator = indicator;
v.indicator = indicator;
codes.push(v.code);
unq = codes.filter((v, i, a) => a.indexOf(v) === i);
v.code = unq.toString();
return v;
});
console.log(res);

Answer 2

这被称为reduce操作:您想要将条目数组转换为单个条目。Array.prototype.reduce正是你想要使用的。

Answer 3

虽然只有一组"real"我希望下面的内容能告诉你如何处理这个任务:

const data={
bc3827d9c21548f8b1ae072ceab4ce6d: [
{
status: 'FINISHED',
start: '2022-05-26 05:01:00.0',
end: '2022-05-28 05:01:00.0',
submissionRank: 112,
submitId: 'bc3827d9c21548f8b1ae072ceab4ce6d',
code: 'ATL',
indicator: 0,
addBy: 30,
delayBy: 0,
pstat: 'DATA GATHERED',
fstat: 'FINISHED',
},
{
status: 'FINISHED',
start: '2022-05-26 05:01:00.0',
end: '2022-05-28 05:01:00.0',
submissionRank: 112,
submitId: 'bc3827d9c21548f8b1ae072ceab4ce6d',
code: 'AAA',
indicator: 0,
addBy: 30,
delayBy: 0,
pstat: 'DATA GATHERED',
fstat: 'FINISHED',
},
{
status: 'FINISHED',
start: '2022-05-26 05:01:00.0',
end: '2022-05-28 05:01:00.0',
submissionRank: 112,
submitId: 'bc3827d9c21548f8b1ae072ceab4ce6d',
code: 'AAA',
indicator: 1,
addBy: 30,
delayBy: 0,
pstat: 'DATA GATHERED',
fstat: 'FINISHED',
},
{
status: 'FINISHED',
start: '2022-05-26 05:01:00.0',
end: '2022-05-28 05:01:00.0',
submissionRank: 112,
submitId: 'bc3827d9c21548f8b1ae072ceab4ce6d',
code: 'ATL',
indicator: 1,
addBy: 30,
delayBy: 0,
pstat: 'DATA GATHERED',
fstat: 'FINISHED',
},
]
};
const res=Object.fromEntries(Object.entries(data).map(([id,o])=>
[id,o.reduce((a,c,i)=>{
if(a.indicator!=c.indicator) a.indicator="both";
if(i==1)a.code=[a.code];
else a.code.push(c.code);
return a;
})]
));
console.log(res)