Helius
2021-09-07 cbdc5d06838cc89c9b7af35f7d9cf5df64379c2c
fix invite user order list
1 files modified
4 ■■■■ changed files
gc-order/src/main/resources/mapper/order/JhyOrderMapper.xml 4 ●●●● 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>