多数据筛选:
json数据:(存放在一个叫111.json的同级目录的 json里面)
{
"success": true,
"code": null,
"msg": null,
"detail": null,
"data": [{
"suppliercompanyid": 1013808,
"supplierCompany": "易派客-得力旗舰店",
"dpList": [{
"purchaselistid": 118,
"suppliercompanyid": 101808,
"suppliercompany": "易派客-得力旗舰店",
"productskuid": 200027,
"productid": 300040,
"skuoptions": "鞋子号码:37号,颜色:白色",
"isinvalid": 1
}]
}, {
"suppliercompanyid": 1393301,
"supplierCompany": "北京慧缘有限责任公司",
"dpList": [{
"purchaselistid": 91,
"suppliercompanyid": 139301,
"suppliercompany": "北京慧缘有限责任公司",
"productskuid": 400010,
"productid": 500007,
"skuoptions": "尺寸:13寸,颜色:黑色,接口:USB2.0",
"isinvalid": 0
}]
}, {
"suppliercompanyid": 143245,
"supplierCompany": "得力集团有限公司",
"dpList": [{
"purchaselistid": 103,
"suppliercompanyid": 1433245,
"suppliercompany": "得力集团有限公司",
"productskuid": 400004,
"productid": 500003,
"skuoptions": "亮度:20,照度:15,大小:100,长度:10,宽度:30,颜色:红色,重量:重量,包装:塑料包装",
"isinvalid": 0
}, {
"purchaselistid": 119,
"suppliercompanyid": 1433245,
"suppliercompany": "得力集团有限公司",
"productskuid": 400002,
"productid": 500001,
"skuoptions": "尺寸:13寸,颜色:黑色,接口:USB2.0",
"isinvalid": 0
}, {
"purchaselistid": 120,
"suppliercompanyid": 1433245,
"suppliercompany": "得力集团有限公司",
"productskuid": 500001,
"productid": 400007,
"skuoptions": "亮度:20,照度:15,大小:100,长度:10,宽度:20,颜色:白色,重量:重量,包装:塑料包装",
"isinvalid": 1
}]
}]
}
$.ajax({
type:"get",
url:"111.json",
success:function(msg){
var data=msg.data;
console.log(typeof data)
var data=$.grep(data,function(n){
return n.supplierCompany=="得力集团有限公司";
})
console.log(data);
$.each(data, function(i) {
data=$.grep(data[i].dpList,function(n){
return n.isinvalid==0;
})
console.log(data) //最终筛选出来的数据为
得力集团有限公司下的
isinvalid值为0的数据
});
}
});