Datatables部分返回數據獲取不到
例如以下響應數據因為datatables返回值的設置,紅字部分獲取不到,只能獲取到aaData的內容:
{"iTotalDisplayRecords":161,"sums":2461.04,"iTotalRecords":161,"countstatus":161,"aaData":[{"custId":"42473927","billType":"0","createTime":"2017-01-16 18:37:02","orderDesc":"充值訂單500元","orderType":"2","feeName":"SX09","fees":500,"payReturn":"4238","orderStatus":"0","payToValue":"861001006680375","id":162,"bossRequestId":"SXCHDWY0012017011618370201","payType":"44","payToType":"1","orderId":"201701161837021484563022014","openId":"o0kX6jo4A2V2VW6wUFVFWMdLVMpk"},{"custId":"42473927","billType":"0","createTime":"2017-01-16 18:36:56","orderDesc":"充值訂單300元","orderType":"2","feeName":"SX09","fees":300,"payReturn":"4237","orderStatus":"0","payToValue":"861001006680375","id":161,"bossRequestId":"SXCHDWY0012017011618365676","payType":"44","payToType":"1","orderId":"201701161836561484563016763","openId":"o0kX6jo4A2V2VW6wUFVFWMdLVMpk"},{"custId":"42473927","billType":"0","createTime":"2017-01-16 18:36:52","orderDesc":"充值訂單100元","orderType":"2","feeName":"SX09","fees":100,"payReturn":"4236","orderStatus":"0","payToValue":"861001006680375","id":160,"bossRequestId":"SXCHDWY0012017011618365220","payType":"44","payToType":"1","orderId":"201701161836521484563012204","openId":"o0kX6jo4A2V2VW6wUFVFWMdLVMpk"}],"sEcho":1}
我的修改如下:
Datatables的js里修改了fnServerData,添加了紅色部分把響應回來的數據賦給了oSettings.jqXHR,以及添加了fnDrawCallback,在其中對響應回來的數據進行解析jQuery.parseJSON(oSettings.jqXHR.responseText),然后就可以獲取到相應的值并進行顯示了。
"fnServerData":function (sSource,aoData,fnCallback,oSettings) {
oSettings.jqXHR = $.Ajax({
"dataType":'json',
"type":"GET",
"url":sSource,
"data":aoData,
"success":fnCallback
});
},
"fnDrawCallback": function (oSettings) {
var json=jQuery.parseJSON(oSettings.jqXHR.responseText);//對獲取到的相應數據進行解析處理
$("#sumEarn").html(json.sums);
},
新聞熱點
疑難解答