| | |
|---|
| | | <select id="selectAgentReturnList" resultType="com.xcong.excoin.modules.contract.entity.AgentReturnEntity"> |
|---|
| | | select |
|---|
| | | CONCAT(b.first_name, b.second_name) account, |
|---|
| | | -- a.closing_fee_amount*(select fee_spread_ratio from platform_trade_setting) closing_fee_amount, |
|---|
| | | -- a.opening_fee_amount*(select fee_spread_ratio from platform_trade_setting) opening_fee_amount, |
|---|
| | | a.closing_fee_amount*(select fee_spread_ratio from platform_trade_setting) closing_fee_amount, |
|---|
| | | a.opening_fee_amount*(select fee_spread_ratio from platform_trade_setting) opening_fee_amount, |
|---|
| | | a.*, |
|---|
| | | c.phone, |
|---|
| | | c.email |
|---|
