springboot mybatis-plus LambdaQueryWrapper IPage 查询分页
public IPage<EquipmentOnsiteInfo> listPaging(EquipmentInfoQO qo) {
LambdaQueryWrapper<EquipmentOnsiteInfo> lambdaQuery = Wrappers.lambdaQuery();
if(!StringUtils.isEmpty(qo.getEquipmentName())) {
lambdaQuery.and(
wapper -> wapper.like(EquipmentOnsiteInfo::getName, qo.getEquipmentName())
.or().like(EquipmentOnsiteInfo::getEquipmentCode, qo.getEquipmentName())
);
}
if(!StringUtils.isEmpty(qo.getTypeId())){
lambdaQuery.eq(EquipmentOnsiteInfo::getTypeId, qo.getTypeId());
}
if(!StringUtils.isEmpty(qo.getEquipmentStatusId())){
lambdaQuery.eq(EquipmentOnsiteInfo::getEquipmentStatusId, qo.getEquipmentStatusId());
}
if(!StringUtils.isEmpty(qo.getUsedStatus())){
lambdaQuery.eq(EquipmentOnsiteInfo::getUsedStatus, qo.getUsedStatus());
}
if(Optional.ofNullable(qo.getStartTime()).isPresent() &&
Optional.ofNullable(qo.getEndTime()).isPresent()) {
lambdaQuery.ge(EquipmentOnsiteInfo::getCreateTime, qo.getStartTime());
lambdaQuery.le(EquipmentOnsiteInfo::getCreateTime, qo.getEndTime());
}
lambdaQuery.eq(EquipmentOnsiteInfo::getDelFlag, false);
lambdaQuery.eq(EquipmentOnsiteInfo::getType, qo.getType());
Page<EquipmentOnsiteInfo> page = new Page<>(qo.getCurrent(), qo.getSize(), true);
IPage<EquipmentOnsiteInfo> equipmentInfoIPage = equipmentOnsiteInfoMapper.selectPage(page, lambdaQuery);
return equipmentInfoIPage;
}