| | |
| | | contract_order s
|
| | | LEFT JOIN member m ON m.id = s.member_id
|
| | | <where>
|
| | | s.order_type IN (3, 4)
|
| | | s.closing_type in (2,3,4,5,6,7,8,9)
|
| | | AND s.member_id IN (
|
| | | SELECT
|
| | | id
|
| | |
| | | </if>
|
| | | </if>
|
| | | </where>
|
| | | order by s.order_no DESC,s.create_time asc
|
| | | order by s.opening_time desc
|
| | | </select>
|
| | |
|
| | | </mapper> |
| | |
| | | LEFT JOIN member m ON m.id = s.member_id
|
| | | <where>
|
| | | s.type = 3
|
| | | and s.content like '%佣金入账%' |
| | | and s.content like '%佣金到账%' |
| | | <if test="record != null" >
|
| | | <if test="record.account!=null and record.account!=''">
|
| | | and (m.phone = #{record.account} or m.email = #{record.account} or m.invite_id=#{record.account})
|
| | | </if>
|
| | | </if>
|
| | | </where>
|
| | | ORDER BY s.create_time DESC
|
| | | </select>
|
| | |
|
| | | </mapper> |
| | |
| | | <div class="layui-fluid layui-anim febs-anim" id="febs-user" lay-title="充币审核管理">
|
| | | <div class="layui-fluid layui-anim febs-anim" id="febs-user" lay-title="代理信息">
|
| | | <div class="layui-row febs-container">
|
| | | <div class="layui-col-md12">
|
| | | <div class="layui-card">
|
| | |
| | | }else {
|
| | | return '<span style="color:red;">限价</span>'
|
| | | }
|
| | | }, minWidth: 120,align:'center'},
|
| | | }, minWidth: 100,align:'center'},
|
| | |
|
| | |
|
| | | {field: 'symbol', title: '币种', minWidth: 120,align:'center'},
|
| | |
| | | }else{
|
| | | return ''
|
| | | }
|
| | | }, minWidth: 120,align:'center'},
|
| | | {field: 'openingPrice', title: '开仓价', minWidth: 150,align:'center'},
|
| | | }, minWidth: 100,align:'center'},
|
| | | {field: 'openingPrice', title: '开仓价', minWidth: 100,align:'center'},
|
| | | {field: 'openingTime', title: '开仓时间', minWidth: 200,align:'center'},
|
| | | {field: 'closingType', title: '平仓类型',
|
| | | templet: function (d) {
|
| | | if (d.closingType === 0) {
|
| | |
| | | return ''
|
| | | }
|
| | | }, minWidth: 120,align:'center'},
|
| | | {field: 'closingPrice', title: '平仓价', minWidth: 150,align:'center'},
|
| | | {field: 'closingPrice', title: '平仓价', minWidth: 100,align:'center'},
|
| | | {field: 'closingTime', title: '平仓时间', minWidth: 200,align:'center'},
|
| | | {field: 'rewardAmount', title: '盈亏金额',
|
| | | templet: function (d) {
|
| | | if (d.rewardAmount > 0) {
|
| | |
| | | {field: 'closingFeeAmount', title: '平仓手续费', minWidth: 100,align:'center',totalRow: true},
|
| | | {field: 'holdAmount', title: '持仓费', minWidth: 120,align:'center',totalRow: true},
|
| | | {field: 'rewardRatio', title: '盈亏比例', minWidth: 120,align:'center'},
|
| | | {field: 'openingTime', title: '开仓时间', minWidth: 200,align:'center'},
|
| | | {field: 'closingTime', title: '平仓时间', minWidth: 200,align:'center'},
|
| | | {field: 'entrustOpeningPrice', title: '委托开仓价', minWidth: 150,align:'center'},
|
| | | {field: 'entrustTime', title: '委托时间', minWidth: 200,align:'center'},
|
| | | {field: 'orderStatus', title: '订单状态',
|