开发者社区> 问答> 正文

jquery 处理 json 数据问题

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

展开
收起
杨冬芳 2016-07-04 16:58:13 1732 0
1 条回答
写回答
取消 提交回答
  • IT从业

    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);
    
    2019-07-17 19:50:54
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
23-Vue.js在前端...1506518547.pdf 立即下载
Javascript中的对象 立即下载
Delivering Javascript to World 立即下载