From 580211c8f889692521592aff164b47ab28da841b Mon Sep 17 00:00:00 2001 From: zainali5120 <512061637@qq.com> Date: Wed, 21 Oct 2020 23:39:07 +0800 Subject: [PATCH] 初始化bug修复 --- src/main/resources/mapper/walletCoinOrder/OrderCoinsDao.xml | 26 ++++++++++++++++++++++---- 1 files changed, 22 insertions(+), 4 deletions(-) diff --git a/src/main/resources/mapper/walletCoinOrder/OrderCoinsDao.xml b/src/main/resources/mapper/walletCoinOrder/OrderCoinsDao.xml index b443d3d..5ca6292 100644 --- a/src/main/resources/mapper/walletCoinOrder/OrderCoinsDao.xml +++ b/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> -- Gitblit v1.9.1