From 94944842a1de7445245caaa5de84ef9c1d57a1aa Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Tue, 07 Jul 2020 18:02:34 +0800 Subject: [PATCH] modify --- src/main/resources/mapper/contract/ContractOrderDao.xml | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/src/main/resources/mapper/contract/ContractOrderDao.xml b/src/main/resources/mapper/contract/ContractOrderDao.xml index fc31d0e..37d1e5c 100644 --- a/src/main/resources/mapper/contract/ContractOrderDao.xml +++ b/src/main/resources/mapper/contract/ContractOrderDao.xml @@ -4,7 +4,11 @@ <select id="selectContractOrderInPage" resultType="com.xcong.excoin.modules.contract.entity.ContractOrderEntity"> - select * from contract_order + select + *, + IFNULL(closing_fee_amount, closing_fee_amount*(select fee_spread_ratio from platform_trade_setting)) closing_fee_amount, + IFNULL(opening_fee_amount, opening_fee_amount*(select fee_spread_ratio from platform_trade_setting)) opening_fee_amount + from contract_order <if test="record != null"> <where> <if test="record.memberId != null" > -- Gitblit v1.9.1