初始化bug修复

zainali5120

2020-10-21 580211c8f889692521592aff164b47ab28da841b

初始化bug修复

 src/main/resources/mapper/walletCoinOrder/OrderCoinsDao.xml

@@ -35,11 +35,29 @@
    </select>



    <select id="selectCoinOrderOnTrade" resultType="com.xcong.excoin.modules.coin.entity.OrderCoinsEntity">

        select *

        from coins_order

        where order_status=1

        select a.id,

        a.deal_price,

        a.entrust_amount,

        a.fee_amount,

        a.entrust_cnt,

        a.mark_price,

        a.member_id,

        a.order_no,

        a.order_status,

        a.order_type,

        a.symbol,

        a.trade_type,

        a.version,

        a.create_by,

        a.create_time,

        a.update_by,

        a.update_time,

        (select sum(symbol_cnt) from coins_order_deal where order_id = a.id) as deal_cnt,

        (select sum(deal_amount) from coins_order_deal where order_id = a.id) as deal_amount

        from coins_order a

        where a.order_status=1

        <if test="list != null">

            and symbol in

            and a.symbol in

            <foreach collection="list" separator="," item="item" open="(" close=")">

                #{item}

            </foreach>