wzy
2021-01-28 9e042bdf884adf87b79fed346b35a274bee98c17
modify
1 files modified
1 ■■■■ changed files
zq-erp/src/main/resources/mybatis/mapper/hive/SysOrderDao.xml 1 ●●●● patch | view | raw | blame | history
zq-erp/src/main/resources/mybatis/mapper/hive/SysOrderDao.xml
@@ -475,6 +475,7 @@
            MAX(pay_time) payTime,
            GROUP_CONCAT(DISTINCT t2.shop_short_name) shopName
        from sys_order t1
        left join sys_order_item b on t1.id=b.ORDER_ID and goods_id!=5583
        left join sys_shop_info t2 on t1.SHOP_ID=t2.ID
        where VIP_ID=#{vipId} and STATU='已付款';
    </select>