Every week, a number of objects are delivered to me. Each object contains information such as date, hours, and other fields. I need to arrange these objects in an array based on the total hours for each day.
Here is an example of the objects:
var anArray = [{
'End':"22:00",
'Id':"Q45575",
'Name':"W-299849",
'Start':"20:00",
'date':"2018-02-04",
'hours':2
},{
'End':"21:00",
'Id':"Q45551",
'Name':"W-299809",
'Start':"15:00",
'date':"2018-02-07",
'hours':5
},{
'End':"20:00",
'Id':"Q45515",
'Name':"W-299849",
'Start':"10:00",
'date':"2018-02-04 ",
'hours':2
}];
The desired output should be something like this (assuming Sunday is 2/4):
Sun Mon Tue Wed Thu Fri Sat
4 0 0 5 0 0
This is what I have currently:
var resourceData = data.reduce((a, c) => {
var targetDay = new Date(c.date).getDay() === 6 ? 0 : (new Date(c.date).getDay() + 1);
if (a) {
a['week'][targetDay] += c.hours;
} else {
a = { 'week': new Array(7).fill(0) };
a['week'][targetDay] = c.hours;
}
return a;
}, {});
Unfortunately, it's not working as expected and I'm encountering errors with the variable targetDay.