2021-10-28

var d = [ {date:“20210101”,type:“A”,total:1}, {date:“20210101”,type:“B”,total:2}, {date:“20210102”,type:“A”,total:3}, {date:“20210102”,type:“B”,total:5}, {date:“20210102”,type:“D”,total:4}, {date:“20210103”,type:“B”,total:3}, {date:“20210104”,type:“B”,total:2}, {date:“20210104”,type:“C”,total:2}, {date:“20210104”,type:“D”,total:1}, {date:“20210105”,type:“A”,total:3}]var dates = []var types = []var total = []var datesSet = new Set()var typesSet = new Set()d.forEach(o => { datesSet.add(o.date) typesSet.add(o.type)})dates = […datesSet]types = […typesSet]types = types.sort()var tempDate = []var fz = []d.forEach(o=>{ //如果是新日期,构造新子数组 var index = tempDate.indexOf(o.date) if(index == -1){ tempDate.push(o.date) var s = [] s.push(o) fz.push(s) }else{ fz[index].push(o) }})fz.forEach(o=>{ var single = [] o.forEach(i=>{ console.log(i) types.forEach(t=>{ var k = types.indexOf(t) if(i.type == t){ //若相等则赋值total single[k] = i.total }else{ //若不等，赋值0 if(!single[k]) single[k] = 0 } }) }) total.push(single)})