![](https://i-blog.csdnimg.cn/blog_migrate/f6d569ab2a0ba7afdd4617e9f9d4e58e.png)
@Override
public PageUtils queryPage(Map<String, Object> params) {
/**
* skuId: 1
* wareId: 2
*/
QueryWrapper<WareSkuEntity> queryWrapper = new QueryWrapper<>();
String skuId = (String) params.get("skuId");
if(!StringUtils.isEmpty(skuId)){
queryWrapper.eq("sku_id",skuId);
}
String wareId = (String) params.get("wareId");
if(!StringUtils.isEmpty(wareId)){
queryWrapper.eq("ware_id",wareId);
}
IPage<WareSkuEntity> page = this.page(
new Query<WareSkuEntity>().getPage(params),
queryWrapper
);
return new PageUtils(page);
}
![](https://i-blog.csdnimg.cn/blog_migrate/58a1f66c0f255d16ab6c1f114cf24b3f.png)
![](https://i-blog.csdnimg.cn/blog_migrate/4b76da6db302cdaf33373d25ab3059a8.png)
![](https://i-blog.csdnimg.cn/blog_migrate/da716c10f75fc98ba17e39f2fe9d5469.png)
![](https://i-blog.csdnimg.cn/blog_migrate/c03d1ee3e0340e7146c6c651d9b7d40e.png)
@Override
public PageUtils queryPage(Map<String, Object> params) {
/**
* status: 0,//状态
* wareId: 1,//仓库id
*/
QueryWrapper<PurchaseDetailEntity> queryWrapper = new QueryWrapper<PurchaseDetailEntity>();
String key = (String) params.get("key");
if(!StringUtils.isEmpty(key)){
//purchase_id sku_id
queryWrapper.and(w->{
w.eq("purchase_id",key).or().eq("sku_id",key);
});
}
String status = (String) params.get("status");
if(!StringUtils.isEmpty(status)){
//purchase_id sku_id
queryWrapper.eq("status",status);
}
String wareId = (String) params.get("wareId");
if(!StringUtils.isEmpty(wareId)){
//purchase_id sku_id
queryWrapper.eq("ware_id",wareId);
}
IPage<PurchaseDetailEntity> page = this.page(
new Query<PurchaseDetailEntity>().getPage(params),
queryWrapper
);
return new PageUtils(page);
}
![](https://i-blog.csdnimg.cn/blog_migrate/eded21956b01775616b6b5745d382472.png)