mybatis-plus框架一对多查询分页total和size错误

先写出错误的代码

Mapper层接口

List selectOrderPage(IPage page, OrderVO order);

mapperXml

 
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    



    
        
    
    
        
        
        
        
        
        
        
        
    


SELECT
      o.*,
      og.id as og_id,
      og.goods_id,
      og.order_id,
      og.goods_price,
      og.goods_count,
      og.goods_money,
      og.goods_category,
      og.goods_img,
      r.id as or_id,
      r.refund_amount
  FROM
      orders o
          LEFT JOIN order_goods og ON o.id = og.order_id
          LEFT JOIN order_refund r ON o.id = r.order_id
  WHERe o.is_deleted = 0
  
     and o.id = #{order.id}
  
  
      and o.status = #{order.status}
  
  
      and o.transport = #{order.transport}
  
  
      and o.pay_way = #{order.payWay}
  
  
      and o.openid = #{order.openid}
  
  
      and o.create_time = #{order.createTime}
  
  
      and o.create_time >= #{order.startTime}
  
  
      and o.create_time <= #{order.endTime}
  
  
      and og.goods_name like concat('%','${order.goodsName}','%')
  -->

修改之后的代码：

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
    

    
        
        
        
        
    


   SELECT
       o.*,
       o.id as orderId
   FROM
       orders o
   WHERe o.is_deleted = 0
       
           and o.id = #{order.id}
       
       
           and o.status = #{order.status}
       
       
           and o.transport = #{order.transport}
       
       
           and o.pay_way = #{order.payWay}
       
       
           and o.openid = #{order.openid}
       
       
           and o.create_time = #{order.createTime}
       
       
           and o.create_time >= #{order.startTime}
       
       
           and o.create_time <= #{order.endTime}
       

com.ht.store.mapper.OrderRefundMapper.selectOrderRefundByOrderId接口

mapper

OrderRefund selectOrderRefundByOrderId(String orderId);

mapperXml

    select * from order_refund where is_deleted = 0 and order_id = #{orderId}

com.ht.store.mapper.OrderGoodsMapper.selectGoodsListByOrderId接口

List selectGoodsListByOrderId(String orderId);

mapperXml

    select * from cart_goods where is_deleted = 0

修改之后total和size均已正常