javascript - 将 js 对象上的字段求和 2 个字段并创建而不是对象 javascript

Question

我的目标是我每周收到一定数量的对象，这些对象上的每个对象都有日期、全名、总小时数和其他字段。我想按名称和每天的总小时数对这些对象数组进行排序。请仅使用 javascript，不要使用 jquery

对象示例

var anArray = [{
  'End__c':"22:00",
  'Id':"Q45575",
  'Name':"W-299849",
  'Resource_Full_Name__c':"test One",
  'Start__c':"20:00",
  'date__c':"2018-02-04",
  'description__c':"rwqfrwe",
  'total_hours__c':2
},{
  'End__c':"21:00",
  'Id':"Q45551",
  'Name':"W-299809",
  'Resource_Full_Name__c':"test Two",
  'Start__c':"15:00",
  'date__c':"2018-02-01",
  'description__c':"rwqfrwe",
  'total_hours__c':5
},{
  'End__c':"20:00",
  'Id':"Q45515",
  'Name':"W-299849",
  'Resource_Full_Name__c':"test One",
  'Start__c':"10:00",
  'date__c':"2018-02-04",
  'description__c':"rwqfrwe",
  'total_hours__c':2
 }];

输出应该是这样的，假设星期日是 2/4

名称总计周日周一周二周三周五周六

测试一6 2 4 0 0 0 0 0

测试二 3 0 3 0 0 0 0 0

这就是我所拥有的

    var tmp = {}

    results.workBlockList.forEach(function (item) {
      var tempKey = item.Resource_Full_Name__c + item.date__c;
      if (!tmp.hasOwnProperty(tempKey)) {
        tmp[tempKey] = item;
      } else {
        tmp[tempKey].total_hours__c += item.total_hours__c;
      }
    });

不起作用，它只按日期和名称排序，而不给我只按日期排序的 2 个列表

Answer 1

您可以使用reduce功能。

看看这段代码

var items = [{
End__c:"22:00", Id:"Q45575",
 Name:"W-299849", Resource_Full_Name__c:"test One", Start__c:"20:00", 
 date__c:"2018-02-04", description__c:"rwqfrwe", total_hours__c:2
 },
 {End__c:"13:00", Id:"A155645",
 Name:"W-299849", Resource_Full_Name__c:"test One", Start__c:"9:00", 
 date__c:"2018-02-05", description__c:"rwqfrwe", total_hours__c:4
},
{
 End__c:"19:00", Id:"A155645",
 Name:"W-299849", Resource_Full_Name__c:"test Two", Start__c:"16:00", 
 date__c:"2018-02-05", description__c:"rwqfrwe", total_hours__c:3
 }];

var result = items.reduce((a, c) => {
  var targetDay = new Date(c.date__c).getDay() === 6 ? 0 :(new Date(c.date__c).getDay() + 1);

  if (a[c.Resource_Full_Name__c]) {
    a[c.Resource_Full_Name__c]['week'][targetDay] += c.total_hours__c;
    a[c.Resource_Full_Name__c]['total'] += c.total_hours__c;
  } else {
    a[c.Resource_Full_Name__c] = { 'total': c.total_hours__c, 'week': new Array(7).fill(0) };
    a[c.Resource_Full_Name__c]['week'][targetDay] = c.total_hours__c;
  }

  return a;
}, {});

result = Object.keys(result).map((k) => ({'workblock': {...result[k], ...{'resource': k}}}))

console.log(result);

.as-console-wrapper {
  max-height: 100% !important
}