MyBatis-Plus 关联查询

冰淇淋@

已于 2024-08-06 10:48:39 修改

阅读量467

点赞数 4

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

于 2024-07-12 13:26:54 首次发布

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

版权

mybatis 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

1、mapper

public interface WmsSendOrderLinesMapper extends BaseMapperPlus<WmsSendOrderLinesMapper, WmsSendOrderLines, WmsSendOrderLinesVo> {
List<WmsSendOrderLines> getBindProductLines(@Param(Constants.WRAPPER) Wrapper<WmsSendOrderLinesBo> queryWrapper);
}

2、xml

<select id="getBindProductLines" resultType="com.smart.wms.send.bean.WmsSendOrderLines">
        select wsol.*, wp.bind_id
        from wms_send_order_lines wsol
        left join wms_product wp on wp.id = wsol.product_id
        ${ew.getCustomSqlSegment}
</select>

3、service

List<WmsSendOrderLines> getBindProductLines(WmsSendOrderLinesBo bo);

4、serviceImpl

@Override
    public List<WmsSendOrderLines> getBindProductLines(WmsSendOrderLinesBo bo) {
        return baseMapper.getBindProductLines(buildBindQueryWrapper(bo));
    }

private QueryWrapper<WmsSendOrderLinesBo> buildBindQueryWrapper(WmsSendOrderLinesBo bo) {
        QueryWrapper<WmsSendOrderLinesBo> lqw = Wrappers.query();
Map<String, Object> params = bo.getParams();
        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;
    }

5、 controller


   @RequestMapping("/test")
    public void test() {
        List<WmsSendOrderLines> orderLinesList = iWmsSendOrderLinesService.getBindProductLines(wmsSendOrderLinesBo);
    }