gc-order/src/main/resources/mapper/order/JhyOrderMapper.xml | ●●●●● patch | view | raw | blame | history |
gc-order/src/main/resources/mapper/order/JhyOrderMapper.xml
@@ -98,10 +98,10 @@ c.status status, sum(d.score) score from xzx_user_share_info a inner join xzx_user_info b on a.mobile_phone=b.mobile_phone inner join xzx_user_info b on a.register_mobile_phone=b.mobile_phone inner join xzx_jhy_order c on b.user_id=c.user_id inner join xzx_jhy_order_items d on c.id=d.order_id where register_mobile_phone=#{record.phone} where a.mobile_phone=#{record.phone} group by c.order_no </select> </mapper>