Javascript 如何按预期聚合SON数据

我有来自API的响应文本如下，我想将它们聚合为新格式的响应.但这很困难，请帮助我(使用JavaScript)

Response from API:

[
  {
    sumTime: "2024-04-25 12:00:00",
    equipParaName: "P1",
    sumValue: 5
  },
  {
    sumTime: "2024-04-25 05:00:00",
    equipParaName: "P2",
    sumValue: 10,
  },
  {
    sumTime: "2024-04-25 09:00:00",
    equipParaName: "P1",
    sumValue: 8
  },
  {
    sumTime: "2024-04-25 08:00:00",
    equipParaName: "P2",
    sumValue: 3,
  },
  {
    sumTime: "2024-04-25 08:00:00",
    equipParaName: "P3",
    sumValue: 12,
  }
]

Conditions:

• 同样的sumTime，equipParaName就无法复制

• 如果有3个唯一的equipParaName，则预期结果在一个对象中最多有3个属于它们的属性

• 结果列表中的相同equipParaName必须由sumTime ASC订购

  equipParaName: P1, sumTime: 2024-04-25 12:00:00, sumValue: 5
  equipParaName: P1, sumTime: 2024-04-25 09:00:00, sumValue: 8
  ==> The sumTime 2024-04-25 09:00:00 should be added to 1st object and sumTime: 2024-04-25 12:00:00 added to 2nd object in result list
  

Expect:

[
  {
    index: 1,
    P1: 8,
    P1_sumTime: "2024-04-25 09:00:00",
    P2: 10,
    P2_sumTime: "2024-04-25 05:00:00",
    P3: 12,
    P3_sumTime: "2024-04-25 07:00:00"
  },
  {
    index: 2,
    P1: 5,
    P1_sumTime: "2024-04-25 12:00:00",
    P2: 3,
    P2_sumTime: "2024-04-25 08:00:00"
  }
]