var json={"Table1":[{"XMID":"B0","ysdate":"2015-01-01T00:00:00","SZH":7373.0},{"XMID":"B0","ysdate":"2015-01-02T00:00:00","SZH":7845.0},{"XMID":"C0","ysdate":"2015-01-01T00:00:00","SZH":327.0},{"XMID":"C0","ysdate":"2015-01-02T00:00:00","SZH":295.0},{"XMID":"D","ysdate":"2015-01-01T00:00:00","SZH":211.0},{"XMID":"D","ysdate":"2015-01-02T00:00:00","SZH":254.0},{"XMID":"K","ysdate":"2015-01-01T00:00:00","SZH":7911.0},{"XMID":"K","ysdate":"2015-01-02T00:00:00","SZH":8394.0}]}
最终想要js输出表格:
ysdate B0 C0 D K
2015-01-01 7373.0 327.0 211.0 7911.0
2015-01-02 7845.0 295.0 254.0 9394.0
js处理就好了吧。。jquery还不一样是js写的,归类下数据
var json = { "Table1": [
{ "XMID": "B0", "ysdate": "2015-01-01T00:00:00", "SZH": 7373.0 },
{ "XMID": "B0", "ysdate": "2015-01-02T00:00:00", "SZH": 7845.0 },
{ "XMID": "C0", "ysdate": "2015-01-01T00:00:00", "SZH": 327.0 },
{ "XMID": "C0", "ysdate": "2015-01-02T00:00:00", "SZH": 295.0 },
{ "XMID": "D", "ysdate": "2015-01-01T00:00:00", "SZH": 211.0 },
{ "XMID": "D", "ysdate": "2015-01-02T00:00:00", "SZH": 254.0 },
{ "XMID": "K", "ysdate": "2015-01-01T00:00:00", "SZH": 7911.0 },
{ "XMID": "K", "ysdate": "2015-01-02T00:00:00", "SZH": 8394.0}]
};
var rows = json.Table1,item;
var result = {},ritem;
for (var i = 0, j = rows.length; i < j; i++) {
item = rows[i];
ritem = result[item.ysdate] || {};
if (ritem[item.XMID]) ritem[item.XMID] += ',' + item.SZH;
else ritem[item.XMID] = item.SZH;
result[item.ysdate] = ritem;
}
var s = '<table border="1"><tr><th>ysdate</th><th>B0</th><th>C0</th><th>D</th><th>K</th></tr>';
for (k in result) {
s += '<tr><td>' + (k.split('T')[0]) + '</td><td>' + result[k].B0 + '</td><td>' + result[k].C0 + '</td><td>' + result[k].D + '</td><td>' + result[k].K + '</td></tr>';
}
s += '</table>';
document.write(s);
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。