Mybatis-plus 根据条件多个动态or进行嵌套查询

如题，最近有个需求，or语句是动态的，并且需要嵌套与and一起， 需要查询数据sql结构如下

select XXX from tb_xx 
where  
((column1 =xxx and column2 ) or (column3 =xxx and ...)...)
and id = xx and name = xxx ...

括号里or语句是根据条件来显示不同的，
我们这里可以使用 Mybatis-plus 的nested(Consumer<Param> consumer)做嵌套(相关使用)。

Consumer的andThen做动态拼接。代码如下:

拼接 (column1 =xxx and column2 ) or (column3 =xxx and …)…

拼接 (column1 =xxx and column2 ) or (column3 =xxx and ...)...
public static Consumer<QueryWrapper<SettleOrderDO>> getOrConsumers(List<SettleOrderStatusMappingEnumV2.WrapperStatusFactor> factors) {
        Consumer orConsumers = null;
        for (int i = 0; i < factors.size(); i++) {
            SettleOrderStatusMappingEnumV2.WrapperStatusFactor factor = factors.get(i);
            Consumer<QueryWrapper<SettleOrderDO>> consumer = null;
            if (i != 0) {
                consumer = settleOrderDOQueryWrapper -> settleOrderDOQueryWrapper
                        .or(settleOrderDOQueryWrapper1 -> settleOrderDOQueryWrapper1.eq(EmptyUtil.isNotNull(factor.getIsAudit()), "audit_flag", factor.getIsAudit())
                                .in(EmptyUtil.isNotEmpty(factor.getInvoiceStatuses()), "settle_invoice_status", factor.getInvoiceStatuses())
                                .in(EmptyUtil.isNotEmpty(factor.getStatuses()), "status", factor.getStatuses())
                                .eq(EmptyUtil.isNotNull(factor.getIsInvoiced()), "is_invoiced", factor.getIsInvoiced()));
                orConsumers = orConsumers.andThen(consumer);
            }
            if (i == 0) {
                consumer = settleOrderDOQueryWrapper -> settleOrderDOQueryWrapper
                        .or(settleOrderDOQueryWrapper1 -> settleOrderDOQueryWrapper1.eq(EmptyUtil.isNotNull(factor.getIsAudit()), "audit_flag", factor.getIsAudit())
                                .in(EmptyUtil.isNotEmpty(factor.getInvoiceStatuses()), "settle_invoice_status", factor.getInvoiceStatuses())
                                .in(EmptyUtil.isNotEmpty(factor.getStatuses()), "status", factor.getStatuses())
                                .eq(EmptyUtil.isNotNull(factor.getIsInvoiced()), "is_invoiced", factor.getIsInvoiced()));
                orConsumers = consumer;
            }
        }
        return orConsumers;
    }

嵌套

public IPage<SettleOrderDO> getPageByVO2(SettleOrderQueryVO query, Integer pageNum, Integer pageSize, Consumer<QueryWrapper<SettleOrderDO>> paramConsumers) {
  QueryWrapper<SettleOrderDO> queryWrapper = new QueryWrapper<>();
        if (paramConsumers != null) {
            queryWrapper.nested(paramConsumers);  嵌套
        }

        queryWrapper.eq(EmptyUtil.isNotNull(query.getOptionType()), "option_type", query.getOptionType())
                .eq(EmptyUtil.isNotEmpty(query.getPayeeMerchant()), "payee_merchant", query.getPayeeMerchant())
                .eq(EmptyUtil.isNotEmpty(query.getPayeeMerchantName()), "payee_merchant_name", query.getPayeeMerchantName());
                return this.page(new MyPage<SettleOrderDO>(pageNum, pageSize), queryWrapper);
}

知识点：Consumer
or(Consumer<Param> consumer) 、Children or()、nested(Consumer<Param> consumer)
Consumer接口不清楚的可以看一下我之前的文章
多总结，多学习 这样就不用加晚班。