mybatis-plus -- 条件构造器之拼接 and(a =? or b=?) 条件

野性酷女 2023-03-13 13:48 23阅读 0赞

### 1、参考图片 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNDYzNjU1_size_16_color_FFFFFF_t_70]

### 2、参考示例 ###

/**
         * TODO    分页查询
         */
        @Override
        public Result<IPage<OrderInfoVO>> findPage(@RequestParam(required = false) String shopId,
                                                   @RequestParam(required = false) String houseId,
                                                   @RequestParam(required = false) String orderNo,
                                                   @RequestParam(required = false) String formFullName,
                                                   @RequestParam(required = false) String formPhone,
                                                   @RequestParam(required = false) String commodityName,
                                                   @RequestParam(required = false) LocalDateTime startTime,
                                                   @RequestParam(required = false) LocalDateTime entTime,
                                                   @RequestParam(required = false) OrderPayTypeEnum payType,
                                                   @RequestParam(required = false) OrderStatusEnum orderStatus) {
            Page<OrderInfo> page = this.page(this.getPage(), new LambdaQueryWrapper<OrderInfo>()
                    .orderByAsc(OrderInfo::getCreateTime)
                    .eq(StringUtils.isNotBlank(shopId), OrderInfo::getShopId, shopId)
                    .eq(StringUtils.isNotBlank(houseId), OrderInfo::getHouseId, houseId)
                    .eq(StringUtils.isNotBlank(orderNo), OrderInfo::getOrderNo, orderNo)
                    .like(StringUtils.isNotBlank(formFullName), OrderInfo::getFormFullName, formFullName)
                    .like(StringUtils.isNotBlank(formPhone), OrderInfo::getFormPhone, formPhone)
                    .and(StringUtils.isNotBlank(commodityName),
                            i -> i.like(OrderInfo::getHouseName, commodityName)
                                    .or()
                                    .like(OrderInfo::getHouseRoomName, commodityName)
                    )
                    .between(startTime != null && entTime != null, OrderInfo::getPayTime, startTime, entTime)
                    .eq(payType != null, OrderInfo::getPayType, payType)
                    .eq(orderStatus != null, OrderInfo::getOrderStatus, orderStatus)
            );
            IPage<OrderInfoVO> orderInfoVOIPage = BeanDtoVoUtil.pageVo(page, OrderInfoVO.class);
            return Result.successFind(orderInfoVOIPage);
        }

**本文到此结束，如果觉得有用，劳烦各位点赞关注一下呗，将不定时持续更新更多的内容…，感谢大家的观看！**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNDYzNjU1_size_16_color_FFFFFF_t_70]: /images/20230312/c701d6f15468455e9e6ce21d995ce8f0.png