MyBatis-Plus-QueryWrapper用法

冰淇淋@

已于 2024-07-23 17:44:17 修改

阅读量160

点赞数 2

分类专栏： mybatis 文章标签： mybatis

于 2024-07-23 17:43:57 首次发布

本文链接：https://blog.csdn.net/qq_38410795/article/details/140642274

版权

mybatis 专栏收录该内容

14 篇文章 0 订阅

订阅专栏


 private QueryWrapper<WmsSendOrderLinesBo> buildBindQueryWrapper(WmsSendOrderLinesBo bo) {
        QueryWrapper<WmsSendOrderLinesBo> lqw = Wrappers.query();
        lqw.eq(bo.getSendOrderId() != null, "wsol.send_order_id", bo.getSendOrderId());
        lqw.ge("wsol.product_stock",0);
        lqw.nested(wrapper ->
            wrapper.eq("wsol.quality_type", "ZP").or().eq("wsol.quality_type", "XTZP")
        );        
        lqw.between(params.get("beginFinishTime") != null &&     params.get("endFinishTime") != null,
            "wsol.finish_time", params.get("beginFinishTime"), params.get("endFinishTime"));        
        lqw.in(CollUtil.isNotEmpty(bo.getReturnOrderIds()),"wsol.returnOrderIds", bo.getReturnOrderIds());
        lqw.groupBy("wsol.return_order_id,wsol.item_bar_code");
        return lqw;
    }