javascript - Ajax JSON SUMIF 数组包含特定单词

Question

在 jQuery 中有没有一种方法可以添加包含 BC 的所有 JSON 对象的 SUM 作为客户端属性的值？我无法找到解决方案，我已经尝试过:

[
  {
    client: "BC",
    users: "PHIL",
    levels: "EAST",
    SUM: "32,600.00"
  },
  {
    client: "BC",
    users: "PHIL",
    levels: "EAST",
    SUM: "12,600.00"
  },
  {
    client: "AQ",
    users: "PHIL",
    levels: "WEST",
    SUM: "20,600.00"
  },
  {
    client: "AQ",
    users: "PHIL",
    levels: "WEST",
    SUM: "16,600.00"
  }
]

Answer 1

您可以按如下方式使用过滤器、映射和减少:

var items = [{"client": "BC", "users": "PHIL", "levels": "EAST", "SUM":"32,600.00"},
      {"client": "BC", "users": "PHIL", "levels": "EAST", "SUM": "12,600.00"},
      {"client": "AQ", "users": "PHIL", "levels": "WEST", "SUM": "20,600.00"},          
      {"client": "AQ", "users": "PHIL", "levels": "WEST", "SUM": "16,600.00"}];

var sum = items.filter(item => {
    // get only ones with client property equals to 'BC'
    return item.client === "BC";
  }).map(item => {
    // parse SUM property values removing the commas and convert them to int
    return parseInt(item.SUM.replace(/,/g, ""));
  }).reduce((a, b) => {
    // sum 
    return a + b;
  }, 0);
    
console.log(sum);