如何从JSON中获得计数的数量，包括javascript中的重复项

How to get the number of count including the duplicates in javascript from JSON?

本文关键字：包括 javascript JSON      更新时间：2023-09-26

JSON如下，

var json =
         [
            {"cardAid":"ALPHG","displayName":"ALPHG","SequenceNumber":"0","port":"A"},
            {"cardAid":"ALPHG","displayName":"ALPHG","SequenceNumber":"1","port":"B"},
            {"cardAid":"SFD","displayName":"SFD","SequenceNumber":"2","port":"C"},
            {"cardAid":"SFD","displayName":"SFD","SequenceNumber":"3","port":"D"},
            {"cardAid":"ALPHG","displayName":"ALPHG","SequenceNumber":"4","port":"E"},
            {"cardAid":"ALPHG","displayName":"ALPHG","SequenceNumber":"5","port":"F"},
            {"cardAid":"BETA","displayName":"BETA","SequenceNumber":"6","port":"G"}
        ];

我使用代码从这个链接解析这个JSON，在javascript中从JSON中获得计数的数量?

function count(arr) {
    var map = {};
    for (var i = 0; i < arr.length; i++) {
        var name = arr[i].cardAid;
        var port = arr[i].port;
        if (name in map){
            map[name].Count++;
            map[name].Port += ',' + port;
        } else {
            map[name] = { Count: 1, Port: port };
        }
    }
    return map;
}

这个函数使用cardAid作为键来解析JSON，并给出如下输出:

{
  ALPHG: { Count: 4, Port: "A,B,E,F" },
  SFD: { Count: 2, Port: "C,D" },
  BETA: { Count: 1, Port: "G" }
}

但是我需要基于JSON中的SequenceNumber的输出，

{
  ALPHG: { Count: 2, Port: "A,B" },
  SFD: { Count: 2, Port: "C,D" },
  ALPHG: { Count: 2, Port: "E,F" },
  BETA: { Count: 1, Port: "G" }
}

我怎么能把这个重复的名字在地图上基于JSON的SequenceNumber

这可能接近您的想法(jsfiddle)，我选择将Port作为数组而不是字符串。但我有点困惑，因为SequenceNumber在这个逻辑中没有影响，也许元素应该先由SequenceNumber排序?

function count(data) {
    var result = {};
    for (var i = 0; i < data.length; ++i) {
        var cardAid = data[i].cardAid;
        if (!(cardAid in result)) {
            result[cardAid] = [];
        }
        // Check if a new "sequence" needs to be created
        if (i == 0 || data[i-1].cardAid != cardAid) {
            result[cardAid].push({ Count: 0, Port: [] });
        }
        // Append item to the latest sequence
        var lastIndex = result[cardAid].length - 1;
        ++result[cardAid][lastIndex].Count;
        result[cardAid][lastIndex].Port.push(data[i].port);
    }
    return result;
}
结果:

{
  "ALPHG": [
    {
      "Count": 2,
      "Port": [ "A", "B" ]
    },
    {
      "Count": 2,
      "Port": [ "E", "F" ]
    }
  ],
  "SFD": [
    {
      "Count": 2,
      "Port": [ "C", "D" ]
    }
  ],
  "BETA": [
    {
      "Count": 1,
      "Port": [ "G" ]
    }
  ]
}
相关文章：