public List<WmsProductVo> buildQueryWrapper(Long warehouseId, List<Long> customerIds, String keyword) {
LambdaQueryWrapper<WmsProduct> lqw = Wrappers.lambdaQuery();
lqw.select(WmsProduct::getId, WmsProduct::getProductNo, WmsProduct::getProductName, WmsProduct::getBarCode);
lqw.eq(ObjectUtil.isNotNull(warehouseId), WmsProduct::getWarehouseId, warehouseId);
lqw.in(CollUtil.isNotEmpty(customerIds), WmsProduct::getCustomerId, customerIds);
if (StringUtils.isNotBlank(keyword)) {
lqw.nested(i -> i.eq(WmsProduct::getProductNo, keyword)
.or().eq(WmsProduct::getBarCode, keyword)
.or().like(WmsProduct::getProductName, keyword));
}
lqw.orderByDesc(WmsProduct::getCreateTime);
lqw.last("limit 10");
return baseMapper.selectVoList(lqw);
}
MyBatis-Plus-LambdaQueryWrapper用法
于 2024-07-23 17:42:01 首次发布