如何把data数据形式转为newData数据形式的数据？
const data = {
1: [{
category: '水果',
time: 12,
}, {
category: '护肤品',
time: 1,
}, {
category: '水果',
time: 0.2,
}, {
category: '零食',
time: 2,
}, {
category: '水果',
time: 3,
}, {
category: '护肤品',
time: 1,
}, ],
2: [{
category: '水果',
time: 2,
}, {
category: '零食',
time: 2,
}, {
category: '水果',
time: 2.3,
}, ],
3: [{
category: '水果',
time: 2.1,
}, ],
4: [],
5: [],
6: [],
}
const newData = {
1: [{
category: '水果',
time: 12,
x:0,
}, {
category: '水果',
time: 0.2,
x:12,
}, {
category: '水果',
time: 3,
x:12.2,
}, {
category: '护肤品',
time: 1,
x:12.5,
}, {
category: '护肤品',
time: 1,
x:12.6,
}, {
category: '零食',
time: 2,
x:12.7,
}, ],
2: [{
category: '水果',
time: 2,
x:0,
}, {
category: '水果',
time: 2.3,
x:2,
}, {
category: '零食',
time: 2,
x:4.3,
}, ],
3: [{
category: '水果',
time: 2.1,
x:0,
}, ],
}
示例代码如下
const data = {
1: [{
category: '水果',
time: 12,
}, {
category: '护肤品',
time: 1,
}, {
category: '水果',
time: 0.2,
}, {
category: '零食',
time: 2,
}, {
category: '水果',
time: 3,
}, {
category: '护肤品',
time: 1,
},],
2: [{
category: '水果',
time: 2,
}, {
category: '零食',
time: 2,
}, {
category: '水果',
time: 2.3,
},],
3: [{
category: '水果',
time: 2.1,
},],
4: [],
5: [],
6: [],
}
const newData = {};
for (let key in data) {
if (data[key].length == 0) continue;
newData[key] = [];
let kv = { };
for (let item of data[key]) {
let x = kv[item.category] || 0;
newData[key].push({ category: item.category, time: item.time, x: x });
x += item.time;
kv[item.category] = x;
}
//排序，将同类型放到一起
let keys = Object.keys(kv); console.log(keys)
newData[key].sort((a, b) => {
let aIndex = keys.findIndex(x => x == a.category), bIndex = keys.findIndex(x => x == b.category);
return aIndex - bIndex;
})
}
console.log(newData)