首頁猿問有一個時間數組對象，時次不連續(xù)，怎...

有一個時間數組對象，時次不連續(xù)，怎樣補全比較好？

JavaScript

紅糖糍粑 2019-05-12 15:34:55

需要展示出一天中所有小時的數據，后端返回的數據是這樣beforData:[{"time_hours":"09",//時間"approved_amount":28068.0,"pass_rate":1.0},{"time_hours":"10","approved_amount":0.0,"pass_rate":0.0},{"time_hours":"11","approved_amount":42706.0,"pass_rate":0.5},{"time_hours":"13","approved_amount":0.0,"pass_rate":0.0},{"time_hours":"15","approved_amount":37700.0,"pass_rate":0.5714285714},{"time_hours":"16","approved_amount":0.0,"pass_rate":0.0},{"time_hours":"17","approved_amount":29520.0,"pass_rate":0.6},{"time_hours":"18","approved_amount":0.0,"pass_rate":0.0},{"time_hours":"19","approved_amount":56216.0,"pass_rate":1.0},{"time_hours":"22","approved_amount":5800.0,"pass_rate":1.0},{"time_hours":"23","approved_amount":0.0,"pass_rate":0.0}]需要將缺少的小時補全，轉化成[{"time_hours":"01:00","approved_amount":null,"pass_rate":null,},{"time_hours":"02:00","approved_amount":null,"pass_rate":null,},{"time_hours":"03:00","approved_amount":null,"pass_rate":null,},{"time_hours":"04:00","approved_amount":null,"pass_rate":null,},{"time_hours":"05:00","approved_amount":null,"pass_rate":null,},{"time_hours":"06:00","approved_amount":null,"pass_rate":null,},{"time_hours":"07:00","approved_amount":null,"pass_rate":null,},{"time_hours":"08:00","approved_amount":null,"pass_rate":null,},{"time_hours":"09:00","approved_amount":28068.0,"pass_rate":1.0},{"time_hours":"10:00","approved_amount":0.0,"pass_rate":0.0},{"time_hours":"11:00","approved_amount":42706.0,"pass_rate":0.5},{"time_hours":"12:00","approved_amount":null,"pass_rate":null,},{"time_hours":"13:00","approved_amount":0.0,"pass_rate":0.0},{"time_hours":"14:00","approved_amount":null,"pass_rate":null,},{"time_hours":"15:00","approved_amount":37700.0,"pass_rate":0.5714285714},{"time_hours":"16:00","approved_amount":0.0,"pass_rate":0.0},{"time_hours":"17:00","approved_amount":29520.0,"pass_rate":0.6},{"time_hours":"18:00","approved_amount":0.0,"pass_rate":0.0},{"time_hours":"19:00","approved_amount":56216.0,"pass_rate":1.0},{"time_hours":"20:00","approved_amount":null,"pass_rate":null,},{"time_hours":"21:00","approved_amount":null,"pass_rate":null,},{"time_hours":"22:00","approved_amount":5800.0,"pass_rate":1.0},{"time_hours":"23:00","approved_amount":0.0,"pass_rate":0.0},{"time_hours":"00:00","approved_amount":null,"pass_rate":null,},]這樣的，請教一下大家這個要怎么做?。?

查看完整描述

2 回答

阿晨1998

TA貢獻2037條經驗獲得超6個贊

不謝，拿走：constbeforeData=[{"time_hours":"09",//時間"approved_amount":28068.0,"pass_rate":1.0}];constresult=Array.from({length:24},(v,i)=>i).map(hour=>{letobj=beforeData.filter(has=>Number(has.time_hours)===hour)[0]||{};return{time_hours:`${`00${hour}`.slice(-2)}:00`,approved_amount:obj.approved_amount||null,pass_rate:obj.pass_rate||null};});console.log(result);就這么簡單~~~

反對回復 2019-05-12

呼啦一陣風

TA貢獻1802條經驗獲得超6個贊

補充一個線性時間復雜度的functiongetFullRange(beforeData){returnbeforeData.reduce((arr,item)=>{arr[+item.time_hours]=itemreturnarr},[...newArray(24)]).map((item,i)=>{if(!item){item={time_hours:String(i),approved_amount:null,pass_rate:null,}}item.time_hours=item.time_hours.padStart(2,'0')+':00'returnitem})}