从对象数组创建uniques对象

Question

下面显示了我当前的数据结构，它是基于一个名为“submitId”的属性分组的

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

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

// 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，则指示符设置为“两者”。uniques对象需要如下所示：

   {
      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

可以使用“还原”和“筛选”来解决此任务：

​

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

虽然只有一组“真实”数据可供使用，但我希望以下内容可以说明如何处理此任务：

​

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)

​