javascript - React JS连接数组并转换为新的二维数组并按二维数组数据和排序
问题描述
我正在开发一个反应原生应用程序说我有这些数组列表:
let soldList1 = [
{"itemCode":"X001" , "soldRate":0.0789},
{"itemCode":"5555" , "soldRate":0.0543},
{"itemCode":"3141" , "soldRate":0.0112},
{"itemCode":"Mix-001" , "soldRate":0.01},
{"itemCode":"7689-L" , "soldRate":0.005},
{"itemCode":"1111" , "soldRate":0.003}
]
let soldList2 = [
{"itemCode":"3141" , "soldRate":0.0712},
{"itemCode":"7689-L" , "soldRate":0.03},
{"itemCode":"5555" , "soldRate":0.0234},
{"itemCode":"1111" , "soldRate":0.011},
{"itemCode":"X001" , "soldRate":0.008},
{"itemCode":"Mix-001" , "soldRate":0.004}
]
let soldList3 = [
{"itemCode":"5555" , "soldRate":0.0339},
{"itemCode":"X001" , "soldRate":0.0221},
{"itemCode":"3141" , "soldRate":0.0111},
{"itemCode":"1111" , "soldRate":0.0089},
{"itemCode":"Mix-001" , "soldRate":0.0077},
{"itemCode":"7689-L" , "soldRate":0.0032}
]
let soldList4 =[
{"itemCode":"8888" , "soldRate":0.13},
{"itemCode":"9999" , "soldRate":0.11},
{"itemCode":"3141" , "soldRate":0.08},
{"itemCode":"1111" , "soldRate":0.07}
]
let soldList5 =[
{"itemCode":"3141" , "soldRate":0.044},
{"itemCode":"1111" , "soldRate":0.011},
{"itemCode":"8888" , "soldRate":0.0011},
{"itemCode":"9999" , "soldRate":0.0001}
]
let soldList6 =[
{"itemCode":"Mix-001" , "soldRate":0.5678},
{"itemCode":"7689-L" , "soldRate":0.546}
{"itemCode":"8888" , "soldRate":0.323},
{"itemCode":"9999" , "soldRate":0.0032},
{"itemCode":"Mix-001" , "soldRate":0.0022},
{"itemCode":"UV-007" , "soldRate":0.0012}
{"itemCode":"TT-08" , "soldRate":0.0011},
{"itemCode":"PP-03" , "soldRate":0.0009}
]
如您所见,一些列表获得了其他列表没有的元素,并且每个列表项的顺序为desc order by 'soldRate'
,并且每个 list.length 也可能不同。
所以目标是连接这些数组列表和处理以构建一个新的数组列表,如下所示:
let finalAllConcateAndSortedByDataSumList = [
{"itemCode":"Mix-001" , "data": [0.01, 0.004, 0.0077, 0, 0, 0.5678], "dataSum":0.5895},
{"itemCode":"7689-L" , "data": [0.005, 0.03, 0.0032, 0, 0, 0.546], "dataSum":0.5842},
{"itemCode":"8888" , "data": [0, 0, 0, 0.13, 0.0011, 0.323], "dataSum":0.4541},
{"itemCode":"3141" , "data": [0.0112, 0.0712, 0.0111, 0.08, 0.044, 0], "dataSum":0.2175},
{"itemCode":"X001" , "data": [0.0789, 0.008, 0.0221, 0, 0, 0.0221], "dataSum":0.1311},
{"itemCode":"9999" , "data": [0, 0, 0, 0.11, 0.0001, 0.0032], "dataSum":0.1133},
{"itemCode":"5555" , "data": [0.0543, 0.0234, 0.0339, 0, 0, 0], "dataSum":0.1116},
{"itemCode":"1111" , "data": [0.003, 0.011, 0.0089, 0.07, 0.011, 0], "dataSum":0.1039},
{"itemCode":"UV-007" , "data": [0, 0, 0, 0, 0, 0.0012], "dataSum":0.0012},
{"itemCode":"TT-08" , "data": [0, 0, 0, 0, 0, 0.0011], "dataSum":0.0011},
{"itemCode":"PP-03" , "data": [0, 0, 0, 0, 0, 0.0009], "dataSum":0.0009},
]
如您所见,'soldRate'
上面列表 1 2 3 4 5 6 中的所有元素都已连接并生成新的数组列表'data'
属性,每个数据顺序的位置与上面的原始列表 1 2 3 4 5 6 完全相同。 ...如果位置中的元素值不存在于任何原始列表中,则它是“0”值
最终将 finalAllConcateAndSortedByDataSumList 中的每个对象,数据数组汇总为属性'dataSum'
那么新列表 finalAllConcateAndSortedByDataSumList 是desc order by dataSum
这是我个人尝试让它工作,但它不起作用......
let finalAllConcateAndSortedByDataSumList = soldList1.concat(soldList2)
.concat(soldList3)
.concat(soldList4)
.concat(soldList5)
.concat(soldList16).map((item) => {
let newItem = { itemCode: item.itemCode, data: [item.soldRate], dataSum: Math.sum([item.soldRate])}
return newItem
}).sort((item) => { return item.dataSum})
所以在这里寻求帮助,代码示例真的很有帮助谢谢
解决方案
您可以首先提取数组中的所有唯一itemCode
值,然后循环遍历它们,如果每个数组中都存在soldRate
或,则将其添加0
到结果中。itemCode
let soldList1 = [
{ itemCode: "X001", soldRate: 0.0789 },
{ itemCode: "5555", soldRate: 0.0543 },
{ itemCode: "3141", soldRate: 0.0112 },
{ itemCode: "Mix-001", soldRate: 0.01 },
{ itemCode: "7689-L", soldRate: 0.005 },
{ itemCode: "1111", soldRate: 0.003 }
];
let soldList2 = [
{ itemCode: "3141", soldRate: 0.0712 },
{ itemCode: "7689-L", soldRate: 0.03 },
{ itemCode: "5555", soldRate: 0.0234 },
{ itemCode: "1111", soldRate: 0.011 },
{ itemCode: "X001", soldRate: 0.008 },
{ itemCode: "Mix-001", soldRate: 0.004 }
];
let soldList3 = [
{ itemCode: "5555", soldRate: 0.0339 },
{ itemCode: "X001", soldRate: 0.0221 },
{ itemCode: "3141", soldRate: 0.0111 },
{ itemCode: "1111", soldRate: 0.0089 },
{ itemCode: "Mix-001", soldRate: 0.0077 },
{ itemCode: "7689-L", soldRate: 0.0032 }
];
let soldList4 = [
{ itemCode: "8888", soldRate: 0.13 },
{ itemCode: "9999", soldRate: 0.11 },
{ itemCode: "3141", soldRate: 0.08 },
{ itemCode: "1111", soldRate: 0.07 }
];
let soldList5 = [
{ itemCode: "3141", soldRate: 0.044 },
{ itemCode: "1111", soldRate: 0.011 },
{ itemCode: "8888", soldRate: 0.0011 },
{ itemCode: "9999", soldRate: 0.0001 }
];
let soldList6 = [
{ itemCode: "Mix-001", soldRate: 0.5678 },
{ itemCode: "7689-L", soldRate: 0.546 },
{ itemCode: "8888", soldRate: 0.323 },
{ itemCode: "9999", soldRate: 0.0032 },
{ itemCode: "Mix-001", soldRate: 0.0022 },
{ itemCode: "UV-007", soldRate: 0.0012 },
{ itemCode: "TT-08", soldRate: 0.0011 },
{ itemCode: "PP-03", soldRate: 0.0009 }
];
function sumSoldRates(...arrs) {
let itemCodes = [].concat(...arrs).reduce((acc, obj) => {
if (!acc.includes(obj.itemCode)) {
acc.push(obj.itemCode);
}
return acc;
}, []);
let result = itemCodes.map(code => {
let obj = { itemCode: code, data: [], dataSum: 0 };
arrs.forEach(arr => {
let item = arr.find(el => el.itemCode === code);
if (item) {
obj.data.push(item.soldRate);
obj.dataSum += item.soldRate;
} else {
obj.data.push(0);
}
});
return obj;
});
result.sort((a, b) => b.dataSum - a.dataSum);
return result;
}
let result = sumSoldRates(
soldList1,
soldList2,
soldList3,
soldList4,
soldList5,
soldList6
);
console.log(result);
推荐阅读
- php - 带有翻译和碳的 Laravel 数据表 - 第一行默认语言问题
- git - 当我的本地不是最新的时,如何从远程拉取?
- vue.js - 如何卸载 vue-cli 2.xx
- internationalization - 免费在线服务从不同国家发送短信
- xaml - 如何在 xaml 中居中网格列标题?
- csv - 如何从 JMeter 中的 CSV 文件替换 GET 路径变量?
- reactjs - 如何将图像从 JSON 文件放到 React Native Js 页面
- gcc - 错误:'::acos' 尚未使用 ::acos 声明;
- sql-server - VM 上的 Azure SQL Server 可以作为生产数据库吗?
- r - 两列数据的部分匹配