如何展平 JSON 结果中的关联对？

Question

我从服务器收到一个包含对象和关联表的数组。例如，我从服务器获得了以下 JSON 结果：

var myEvent = {
   "Event":{
      "SessionTags":[
         {
            "SessionID":1,
            "TagID":x
         },
         {
            "SessionID":2,
            "TagID":x
         },
         {
            "SessionID":2,
            "TagID":y
         },
         {
            "SessionID":3,
            "TagID":z
         }
      ],
      "Sessions":[
         {
            "ID":1,
            "Name":"Advanced Tips",
         },
         {
            "ID":2,
            "Name":"Best Practices"
         },
         {
            "ID":3,
            "Name":"Code Fun"
         },
      "Tags":[
         {
            "ID":x,
            "Name":"AJAX"
         },
         {
            "ID":y,
            "Name":"Android"
         },
         {
            "ID":z,
            "Name":"ASP.NET"
         },
      ]
   }
}

注意用作关联表的“SessionTags”对象。如何在会话标记中添加正确的标记对象，以便我最终得到以下结果：

var myNewEvent = {
   "Event":{
      "Sessions":[
         {
            "ID":1,
            "Name":"Advanced Tips",
            "Tags":[
              {
               "ID":x,
               "Name":"AJAX"
              }
            ]
         },
         {
            "ID":2,
            "Name":"Best Practices",
            "Tags":[
              {
               "ID":x,
               "Name":"AJAX"
              },
              {
               "ID":y,
               "Name":"Android"
              }
            ]
         },
         {
            "ID":3,
            "Name":"Code Fun",
            "Tags":[
              {
               "ID":z,
               "Name":"ASP.NET"
              }
            ]
         }
   }
}

Answer 1

试试这个：

var getTagName = function(tagId){
    var t = myEvent["Event"]["Tags"];
    for (var i in t); {
        if (t[i].ID == tagId) {
            return t[i].Name;
        }
    }
};

var getTags = function(sessionId){
    var s = myEvent["Event"]["SessionTags"];
    var tags = [];
    for (var i in s) {
        if (s[i]["SessionID"] == sessionId) {
            var tagName = getTagName(s[i]["TagID"]);
            tags.push({"ID": sessionId, "Name": tagName});
        }
    }
    return tags;
};

var addSessionTags = function(){
    var s = myEvent["Event"]["Sessions"];
    for (var i in s) {
        var currentSession = s[i];
        currentSession.Tags = getTags(currentSession.ID);
    }
};

addSessionTags();

delete myEvent.Event.Tags;
delete myEvent.Event.SessionTags;

我必须稍微清理你的数据（x、y、z的ID没有引用任何变量，而且你还有一些额外的逗号和缺少的右括号）才能得到它对于这个例子是可行的：

var myEvent = {
   "Event":{
      "SessionTags":[
         {
            "SessionID":1,
            "TagID":"x"
         },
         {
            "SessionID":2,
            "TagID":"x"
         },
         {
            "SessionID":2,
            "TagID":"y"
         },
         {
            "SessionID":3,
            "TagID":"z"
         }
      ],
      "Sessions":[
         {
            "ID":1,
            "Name":"Advanced Tips",
         },
         {
            "ID":2,
            "Name":"Best Practices"
         },
         {
            "ID":3,
            "Name":"Code Fun"
         }
     ],
      "Tags":[
         {
            "ID":"x",
            "Name":"AJAX"
         },
         {
            "ID":"y",
            "Name":"Android"
         },
         {
            "ID":"z",
            "Name":"ASP.NET"
         }
      ]
   }
}