From 5fd46ebbfe3c3bdc2aea660cd19d4f52de59f2da Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Fri, 19 Jun 2020 18:02:53 +0800 Subject: [PATCH] modify --- src/main/java/com/xcong/excoin/modules/agent/entity/MemberEntity.java | 10 src/main/java/com/xcong/excoin/modules/contract/controller/ContractOrderController.java | 16 + src/main/java/com/xcong/excoin/modules/contract/mapper/ContractOrderMapper.java | 15 src/main/java/com/xcong/excoin/modules/agent/mapper/MemberMapper.java | 2 src/main/resources/mapper/modules/MemberMapper.xml | 19 + src/main/java/com/xcong/excoin/modules/agent/controller/MemberController.java | 8 src/main/resources/templates/febs/views/modules/contract/history-list.html | 208 +++++++++++++ /dev/null | 8 src/main/resources/templates/febs/views/modules/contract/return-list.html | 175 ++++++++++ src/main/java/com/xcong/excoin/modules/contract/entity/ContractOrderEntity.java | 207 ++++++++++++ src/main/java/com/xcong/excoin/modules/agent/service/impl/MemberServiceImpl.java | 6 src/main/java/com/xcong/excoin/modules/contract/controller/ViewController.java | 6 src/main/java/com/xcong/excoin/modules/agent/service/IMemberService.java | 2 src/main/resources/mapper/modules/ContractOrderMapper.xml | 26 + src/main/resources/templates/febs/views/modules/contract/totalFee-list.html | 169 ++++++++++ src/main/java/com/xcong/excoin/modules/contract/service/impl/ContractOrderServiceImpl.java | 24 + src/main/java/com/xcong/excoin/modules/contract/service/IContractOrderService.java | 14 17 files changed, 907 insertions(+), 8 deletions(-) diff --git a/src/main/java/com/xcong/excoin/modules/agent/controller/MemberController.java b/src/main/java/com/xcong/excoin/modules/agent/controller/MemberController.java index 978b2d1..08cb052 100644 --- a/src/main/java/com/xcong/excoin/modules/agent/controller/MemberController.java +++ b/src/main/java/com/xcong/excoin/modules/agent/controller/MemberController.java @@ -36,4 +36,12 @@ Map<String, Object> data = getDataTable(memberService.findMemberListInPage(member, request)); return new FebsResponse().success().data(data); } + + @GetMapping("getFeeAmountList") + public FebsResponse getFeeAmountList(MemberEntity memberEntity, QueryRequest request) { + User user = getCurrentUser(); + memberEntity.setRefererId(FebsConstant.USER_TYPE_ADMIN.equals(user.getType()) ? FebsConstant.DEFAULT_REFERER_ID : user.getInviteId()); + Map<String, Object> data = getDataTable(memberService.findFeeAmountList(memberEntity, request)); + return new FebsResponse().success().data(data); + } } diff --git a/src/main/java/com/xcong/excoin/modules/agent/entity/MemberEntity.java b/src/main/java/com/xcong/excoin/modules/agent/entity/MemberEntity.java index 0db13c1..c10b0cd 100644 --- a/src/main/java/com/xcong/excoin/modules/agent/entity/MemberEntity.java +++ b/src/main/java/com/xcong/excoin/modules/agent/entity/MemberEntity.java @@ -6,6 +6,7 @@ import com.xcong.excoin.common.entity.BaseEntity; import lombok.Data; +import java.math.BigDecimal; import java.util.Date; /** @@ -149,4 +150,13 @@ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") @TableField(exist = false) private Date endTime; + + @TableField(exist = false) + private BigDecimal openFeeAmount; + @TableField(exist = false) + private BigDecimal closeFeeAmount; + @TableField(exist = false) + private BigDecimal holdFeeAmount; + @TableField(exist = false) + private BigDecimal loseOrProfit; } diff --git a/src/main/java/com/xcong/excoin/modules/agent/mapper/MemberMapper.java b/src/main/java/com/xcong/excoin/modules/agent/mapper/MemberMapper.java index b433991..721c6e8 100644 --- a/src/main/java/com/xcong/excoin/modules/agent/mapper/MemberMapper.java +++ b/src/main/java/com/xcong/excoin/modules/agent/mapper/MemberMapper.java @@ -15,4 +15,6 @@ IPage<MemberEntity> selectMemberListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity); MemberEntity selectMemberByInviteIdAndRefererId(@Param("inviteId") String inviteId, @Param("refererId") String refererId); + + IPage<MemberEntity> selectMemberFeeAmountTotal(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity); } diff --git a/src/main/java/com/xcong/excoin/modules/agent/service/IMemberService.java b/src/main/java/com/xcong/excoin/modules/agent/service/IMemberService.java index 820e9af..516eda8 100644 --- a/src/main/java/com/xcong/excoin/modules/agent/service/IMemberService.java +++ b/src/main/java/com/xcong/excoin/modules/agent/service/IMemberService.java @@ -11,4 +11,6 @@ public interface IMemberService extends IService<MemberEntity> { IPage<MemberEntity> findMemberListInPage(MemberEntity memberEntity, QueryRequest request); + + IPage<MemberEntity> findFeeAmountList(MemberEntity memberEntity, QueryRequest request); } diff --git a/src/main/java/com/xcong/excoin/modules/agent/service/impl/MemberServiceImpl.java b/src/main/java/com/xcong/excoin/modules/agent/service/impl/MemberServiceImpl.java index a9de188..ef197d1 100644 --- a/src/main/java/com/xcong/excoin/modules/agent/service/impl/MemberServiceImpl.java +++ b/src/main/java/com/xcong/excoin/modules/agent/service/impl/MemberServiceImpl.java @@ -22,4 +22,10 @@ Page<MemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize()); return this.baseMapper.selectMemberListInPage(page, memberEntity); } + + @Override + public IPage<MemberEntity> findFeeAmountList(MemberEntity memberEntity, QueryRequest request) { + Page<MemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize()); + return this.baseMapper.selectMemberListInPage(page, memberEntity); + } } diff --git a/src/main/java/com/xcong/excoin/modules/contract/controller/ContractOrderController.java b/src/main/java/com/xcong/excoin/modules/contract/controller/ContractOrderController.java index 408f862..1026d32 100644 --- a/src/main/java/com/xcong/excoin/modules/contract/controller/ContractOrderController.java +++ b/src/main/java/com/xcong/excoin/modules/contract/controller/ContractOrderController.java @@ -5,7 +5,9 @@ import com.xcong.excoin.common.entity.FebsResponse; import com.xcong.excoin.common.entity.QueryRequest; import com.xcong.excoin.modules.contract.entity.ContractHoldOrderEntity; +import com.xcong.excoin.modules.contract.entity.ContractOrderEntity; import com.xcong.excoin.modules.contract.service.IContractHoldOrderService; +import com.xcong.excoin.modules.contract.service.IContractOrderService; import com.xcong.excoin.system.entity.User; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; @@ -30,6 +32,8 @@ private final IContractHoldOrderService contractHoldOrderService; + private final IContractOrderService contractOrderService; + @GetMapping("getHoldList") public FebsResponse getHoldList(ContractHoldOrderEntity contractHoldOrderEntity, QueryRequest request) { User user = getCurrentUser(); @@ -41,4 +45,16 @@ Map<String, Object> data = getDataTable(contractHoldOrderService.findHoldList(contractHoldOrderEntity, request)); return new FebsResponse().success().data(data); } + + @GetMapping("getHistoryList") + public FebsResponse getHistoryList(ContractOrderEntity contractOrderEntity, QueryRequest request) { + User user = getCurrentUser(); + if (user.getType().equals(FebsConstant.USER_TYPE_ADMIN)) { + contractOrderEntity.setRefererId(FebsConstant.DEFAULT_REFERER_ID); + } else { + contractOrderEntity.setRefererId(user.getInviteId()); + } + Map<String, Object> data = getDataTable(contractOrderService.findHistoryOrderListInPage(contractOrderEntity, request)); + return new FebsResponse().success().data(data); + } } diff --git a/src/main/java/com/xcong/excoin/modules/contract/controller/MemberAssetsController.java b/src/main/java/com/xcong/excoin/modules/contract/controller/MemberAssetsController.java deleted file mode 100644 index c4fb9c1..0000000 --- a/src/main/java/com/xcong/excoin/modules/contract/controller/MemberAssetsController.java +++ /dev/null @@ -1,8 +0,0 @@ -package com.xcong.excoin.modules.contract.controller; - -/** - * @author wzy - * @date 2020-06-16 - **/ -public class MemberAssetsController { -} diff --git a/src/main/java/com/xcong/excoin/modules/contract/controller/ViewController.java b/src/main/java/com/xcong/excoin/modules/contract/controller/ViewController.java index 08688c9..827ccc2 100644 --- a/src/main/java/com/xcong/excoin/modules/contract/controller/ViewController.java +++ b/src/main/java/com/xcong/excoin/modules/contract/controller/ViewController.java @@ -32,4 +32,10 @@ public String saleList() { return FebsUtil.view("modules/contract/sale-list"); } + + @GetMapping("historyList") + @RequiresPermissions("history:view") + public String historyList() { + return FebsUtil.view("modules/contract/history-list"); + } } diff --git a/src/main/java/com/xcong/excoin/modules/contract/entity/ContractOrderEntity.java b/src/main/java/com/xcong/excoin/modules/contract/entity/ContractOrderEntity.java new file mode 100644 index 0000000..7c92c9c --- /dev/null +++ b/src/main/java/com/xcong/excoin/modules/contract/entity/ContractOrderEntity.java @@ -0,0 +1,207 @@ +package com.xcong.excoin.modules.contract.entity; + +import com.baomidou.mybatisplus.annotation.TableName; +import com.xcong.excoin.common.entity.BaseEntity; +import lombok.Data; + +import java.math.BigDecimal; +import java.util.Date; + +/** + * 合约订单历史表 + * + * @author wzy + * @date 2020-05-27 + **/ +@Data +@TableName("contract_order") +public class ContractOrderEntity extends BaseEntity { + + /** + * 交易类型 市价 + */ + public static final int TRADE_TYPE_MARK_PRICE = 1; + + /** + * 交易类型 限价 + */ + public static final int TRADE_TYPE_LIMIT_PRICE = 2; + + /** + * 订单状态 撤单 + */ + public static final int ORDER_STATUS_CANCEL = 2; + + /** + * 订单状态 成交 + */ + public static final int ORDER_STATUS_SUCCESS = 1; + + /** + * 订单类型 开多 + */ + public static final int ORDER_TYPE_OPEN_MORE = 1; + + /** + * 订单类型 开空 + */ + public static final int ORDER_TYPE_OPEN_LESS = 2; + + /** + * 订单类型 平多 + */ + public static final int ORDER_TYPE_CLOSE_MORE = 3; + + /** + * 订单类型 平空 + */ + public static final int ORDER_TYPE_CLOSE_LESS = 4; + + + /** + * 会员Id + */ + private Long memberId; + + /** + * 订单编号 + */ + private String orderNo; + + /** + * 仓位类型 1-逐仓 2-全仓 + */ + private int positionType; + + /** + * 交易类型 1-市价 2-限价 + */ + private int tradeType; + + /** + * 订单类型 - 1开多,2开空,3平多,4平空 + */ + private int orderType; + + /** + * 订单状态 - 1成交 2撤单 + */ + private int orderStatus = 1; + + /** + * 委托开仓价 + */ + private BigDecimal entrustOpeningPrice; + + /** + * 委托时间 + */ + private Date entrustTime; + + /** + * 币种 + */ + private String symbol; + + /** + * 手数 + */ + private int symbolCnt; + + /** + * 币种规格 + */ + private BigDecimal symbolSku; + + /** + * 平仓价 + */ + private BigDecimal closingPrice; + + /** + * 平仓手续费 + */ + private BigDecimal closingFeeAmount; + + /** + * 平仓时间 + */ + private Date closingTime; + + /** + * 平仓类型 2平多3平空4爆仓平多5爆仓平空6止盈平多7止盈平空8止损平多9止损平空 + */ + private int closingType; + + /** + * 杠杆倍率 + */ + private int leverRatio; + + /** + * 止损价 + */ + private BigDecimal stopLossPrice; + + /** + * 止盈价 + */ + private BigDecimal stopProfitPrice; + + /** + * 盈亏金额 + */ + private BigDecimal rewardAmount; + + /** + * 盈亏比例 + */ + private BigDecimal rewardRatio; + + /** + * 开仓价 + */ + private BigDecimal openingPrice; + + /** + * 开仓手续费 + */ + private BigDecimal openingFeeAmount; + + private Date openingTime; + + /** + * 预付款金额 + */ + private BigDecimal prePaymentAmount; + + /** + * 保证金 + */ + private BigDecimal bondAmount; + + /** + * 市场价 + */ + private BigDecimal markPrice; + + /** + * 预估强平价 + */ + private BigDecimal forceClosingPrice; + + /** + * 持仓费 + */ + private BigDecimal holdAmount; + + private int operateNo; + + private String refererId; + private String phone; + private String email; + private String name; + + + +} diff --git a/src/main/java/com/xcong/excoin/modules/contract/mapper/ContractOrderMapper.java b/src/main/java/com/xcong/excoin/modules/contract/mapper/ContractOrderMapper.java new file mode 100644 index 0000000..7a74b40 --- /dev/null +++ b/src/main/java/com/xcong/excoin/modules/contract/mapper/ContractOrderMapper.java @@ -0,0 +1,15 @@ +package com.xcong.excoin.modules.contract.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.xcong.excoin.modules.contract.entity.ContractOrderEntity; +import org.apache.ibatis.annotations.Param; + +/** + * @author helius + */ +public interface ContractOrderMapper extends BaseMapper<ContractOrderEntity> { + + IPage<ContractOrderEntity> selectHistoryOrderListInPage(Page<ContractOrderEntity> page, @Param("record") ContractOrderEntity contractOrderEntity); +} diff --git a/src/main/java/com/xcong/excoin/modules/contract/service/IContractOrderService.java b/src/main/java/com/xcong/excoin/modules/contract/service/IContractOrderService.java new file mode 100644 index 0000000..63d2c3f --- /dev/null +++ b/src/main/java/com/xcong/excoin/modules/contract/service/IContractOrderService.java @@ -0,0 +1,14 @@ +package com.xcong.excoin.modules.contract.service; + +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.service.IService; +import com.xcong.excoin.common.entity.QueryRequest; +import com.xcong.excoin.modules.contract.entity.ContractOrderEntity; + +/** + * @author helius + */ +public interface IContractOrderService extends IService<ContractOrderEntity> { + + IPage<ContractOrderEntity> findHistoryOrderListInPage(ContractOrderEntity contractOrderEntity, QueryRequest request); +} diff --git a/src/main/java/com/xcong/excoin/modules/contract/service/impl/ContractOrderServiceImpl.java b/src/main/java/com/xcong/excoin/modules/contract/service/impl/ContractOrderServiceImpl.java new file mode 100644 index 0000000..7abd971 --- /dev/null +++ b/src/main/java/com/xcong/excoin/modules/contract/service/impl/ContractOrderServiceImpl.java @@ -0,0 +1,24 @@ +package com.xcong.excoin.modules.contract.service.impl; + +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.xcong.excoin.common.entity.QueryRequest; +import com.xcong.excoin.modules.contract.entity.ContractOrderEntity; +import com.xcong.excoin.modules.contract.mapper.ContractOrderMapper; +import com.xcong.excoin.modules.contract.service.IContractOrderService; +import org.springframework.stereotype.Service; + +/** + * @author wzy + * @date 2020-06-19 + **/ +@Service +public class ContractOrderServiceImpl extends ServiceImpl<ContractOrderMapper, ContractOrderEntity> implements IContractOrderService { + + @Override + public IPage<ContractOrderEntity> findHistoryOrderListInPage(ContractOrderEntity contractOrderEntity, QueryRequest request) { + Page<ContractOrderEntity> page = new Page<>(request.getPageNum(), request.getPageSize()); + return this.baseMapper.selectHistoryOrderListInPage(page, contractOrderEntity); + } +} diff --git a/src/main/resources/mapper/modules/ContractOrderMapper.xml b/src/main/resources/mapper/modules/ContractOrderMapper.xml new file mode 100644 index 0000000..ff105da --- /dev/null +++ b/src/main/resources/mapper/modules/ContractOrderMapper.xml @@ -0,0 +1,26 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.xcong.excoin.modules.contract.mapper.ContractOrderMapper"> + + <select id="selectHistoryOrderListInPage" resultType="com.xcong.excoin.modules.contract.entity.ContractOrderEntity"> + select + a.phone, + a.email, + a.referer_id, + concat(b.first_name, b.second_name) name, + c.* + from member a + inner join member_authentication b on a.id=b.member_id + inner join contract_order c on a.id=c.member_id + <where> + <if test="record!=null"> + <if test="record.refererId!=null and record.refererId!=''"> + find_in_set(#{record.refererId}, a.referer_ids) + </if> + and order_status = 1 + </if> + </where> + order by c.create_time desc + </select> + +</mapper> \ No newline at end of file diff --git a/src/main/resources/mapper/modules/MemberMapper.xml b/src/main/resources/mapper/modules/MemberMapper.xml index 0c74203..172a8f7 100644 --- a/src/main/resources/mapper/modules/MemberMapper.xml +++ b/src/main/resources/mapper/modules/MemberMapper.xml @@ -39,4 +39,23 @@ where invite_id=#{inviteId} and referer_id=#{refererId} </select> + <select id="selectMemberFeeAmountTotal" resultType="com.xcong.excoin.modules.agent.entity.MemberEntity"> + select + a.create_time, + a.phone, + a.email, + a.referer_id, + a.invite_id, + concat(c.first_name, c.second_name) account, + sum(b.opening_fee_amount) openFeeAmount, + sum(b.closing_fee_amount) closeFeeAmount, + sum(b.hold_amount) holdFeeAmount, + sum(reward_amount) loseOrProfit + from member a + inner join member_authentication c on a.id=c.member_id + inner join contract_order b on a.id=b.member_id and b.order_status=1 + where find_in_set(#{record.refererId}, a.referer_ids) + group by a.create_time,a.phone, a.email + order by a.create_time desc + </select> </mapper> \ No newline at end of file diff --git a/src/main/resources/templates/febs/views/modules/contract/history-list.html b/src/main/resources/templates/febs/views/modules/contract/history-list.html new file mode 100644 index 0000000..293b237 --- /dev/null +++ b/src/main/resources/templates/febs/views/modules/contract/history-list.html @@ -0,0 +1,208 @@ +<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"> + <div class="layui-card-body febs-table-full"> + <form class="layui-form layui-table-form" lay-filter="user-table-form"> + <div class="layui-row"> + <div class="layui-col-md10"> + <div class="layui-form-item"> + <div class="layui-inline"> + <div class="layui-input-inline"> + <input type="text" placeholder="手机号/邮箱/邀请码" name="account" + autocomplete="off" class="layui-input"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">创建时间</label> + <div class="layui-input-inline"> + <input type="text" name="createTime" id="user-createTime" + class="layui-input"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">账号类型</label> + <div class="layui-input-inline"> + <select name="accountType"> + <option value=""></option> + <option value="1">测试账号</option> + <option value="2">正常账号</option> + </select> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">账号状态</label> + <div class="layui-input-inline"> + <select name="accountStatus"> + <option value=""></option> + <option value="0">禁用</option> + <option value="1">正常</option> + </select> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">实名状态</label> + <div class="layui-input-inline"> + <select name="certifyStatus"> + <option value=""></option> + <option value="0">未通过</option> + <option value="1">审核中</option> + <option value="2">审核通过</option> + <option value="2">未实名</option> + </select> + </div> + </div> + </div> + </div> + <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area"> + <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-blue-plain table-action" + id="query"> + <i class="layui-icon"></i> + </div> + <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain table-action" + id="reset"> + <i class="layui-icon"></i> + </div> + </div> + </div> + </form> + <table lay-filter="userTable" lay-data="{id: 'userTable'}"></table> + </div> + </div> + </div> + </div> +</div> +<!-- 表格字段状态格式化 start --> +<script type="text/html" id="open-type"> + {{# + var openType = { + 1: {title: '开多', color : 'blue'}, + 2: {title: '开空', color : 'red'}, + 3: {title: '平多', color : 'blue'}, + 4: {title: '平空', color : 'red'} + }[d.orderType]; + }} + <span class="layui-badge febs-bg-{{openType.color}}">{{ openType.title }}</span> +</script> +<script type="text/html" id="closing-type"> + {{# + var closingType = { + 0: {title: '-'}, + 2: {title: '平多'}, + 3: {title: '平空'}, + 4: {title: '爆仓平多'}, + 5: {title: '爆仓平空'}, + 6: {title: '止盈平多'}, + 7: {title: '止盈平空'}, + 8: {title: '止损平多'}, + 9: {title: '止损平空'}, + }[d.closingType]; + }} + <span>{{ closingType.title }}</span> +</script> +<script type="text/html" id="loseOrProfit"> + {{# if(d.orderType == 3 || d.orderType == 4){ }} + {{# if(d.rewardAmount >= 0){ }} + <span style="color: green">{{ d.rewardAmount }}</span> + {{# } else { }} + <span style="color: red">{{ d.rewardAmount }}</span> + {{# } }} + {{# } }} +</script> +<!-- 表格字段状态格式化 start --> + +<script data-th-inline="none" type="text/javascript"> + // 引入组件并初始化 + layui.use(['dropdown', 'jquery', 'laydate', 'form', 'table', 'febs', 'treeSelect'], function () { + var $ = layui.jquery, + laydate = layui.laydate, + febs = layui.febs, + form = layui.form, + table = layui.table, + $view = $('#febs-user'), + $query = $view.find('#query'), + $reset = $view.find('#reset'), + $searchForm = $view.find('form'), + sortObject = {field: 'createTime', type: null}, + tableIns, + createTimeFrom, + createTimeTo; + + form.render(); + + // 表格初始化 + initTable(); + + // 时间组件 + laydate.render({ + elem: '#user-createTime', + range: true, + trigger: 'click' + }); + + // 查询按钮 + $query.on('click', function () { + var params = $.extend(getQueryParams(), {field: sortObject.field, order: sortObject.type}); + tableIns.reload({where: params, page: {curr: 1}}); + }); + + // 刷新按钮 + $reset.on('click', function () { + $searchForm[0].reset(); + sortObject.type = 'null'; + createTimeTo = null; + createTimeFrom = null; + tableIns.reload({where: getQueryParams(), page: {curr: 1}, initSort: sortObject}); + }); + + function initTable() { + tableIns = febs.table.init({ + elem: $view.find('table'), + id: 'userTable', + url: ctx + 'order/getHistoryList', + cols: [[ + {type: 'checkbox'}, + {field: 'orderNo', title: '订单编号', minWidth: 150, align: 'center'}, + {field: 'symbol', title: '合约名称', minWidth: 100, align: 'center'}, + {field: 'refererId', title: '上级UID', minWidth: 100, align: 'center'}, + {field: 'name', title: '姓名', minWidth: 130, align: 'center'}, + {field: 'phone', title: '联系方式', minWidth: 130, align: 'center'}, + {field: 'email', title: '邮箱', minWidth: 140, align: 'center'}, + {title: '开仓类型', templet: '#open-type', minWidth: 100, align: 'center'}, + {field: 'entrustPrice', title: '委托价', minWidth: 100, align: 'center'}, + {field: 'openingPrice', title: '开仓价', minWidth: 130, align: 'center'}, + {field: 'openingFeeAmount', title: '开仓手续费', minWidth: 130, align: 'center'}, + {field: 'openingTime', title: '开仓时间', minWidth: 180, align: 'center'}, + {field: 'bondAmount', title: '保证金', minWidth: 120, align: 'center'}, + {field: 'symbolCnt', title: '成交量', minWidth: 100, align: 'center'}, + {field: 'stopProfitPrice', title: '止盈', minWidth: 100, align: 'center'}, + {field: 'stopLossPrice', title: '止损', minWidth: 120, align: 'center'}, + {field: 'holdAmount', title: '持仓费', minWidth: 140, align: 'center'}, + {templet: '#loseOrProfit', title: '平仓盈亏', minWidth: 140, align: 'center'}, + {field: 'closingPrice', title: '平仓价', minWidth: 140, align: 'center'}, + {field: 'closingFeeAmount', title: '平仓手续费', minWidth: 140, align: 'center'}, + { title: '平仓类型', templet: '#closing-type', minWidth: 100, align: 'center'}, + {field: 'closingTime', title: '平仓时间', minWidth: 180, align: 'center'}, + ]] + }); + } + + // 获取查询参数 + function getQueryParams() { + var createTime = $searchForm.find('input[name="createTime"]').val(); + if (createTime) { + createTimeFrom = createTime.split(' - ')[0]; + createTimeTo = createTime.split(' - ')[1]; + } + return { + startTime: createTimeFrom, + endTime: createTimeTo, + account: $searchForm.find('input[name="account"]').val().trim(), + accountStatus: $searchForm.find("select[name='accountStatus']").val(), + accountType: $searchForm.find("select[name='accountType']").val(), + certifyStatus: $searchForm.find("select[name='certifyStatus']").val(), + invalidate_ie_cache: new Date() + }; + } + }) +</script> \ No newline at end of file diff --git a/src/main/resources/templates/febs/views/modules/contract/return-list.html b/src/main/resources/templates/febs/views/modules/contract/return-list.html new file mode 100644 index 0000000..cb0a150 --- /dev/null +++ b/src/main/resources/templates/febs/views/modules/contract/return-list.html @@ -0,0 +1,175 @@ +<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"> + <div class="layui-card-body febs-table-full"> + <form class="layui-form layui-table-form" lay-filter="user-table-form"> + <div class="layui-row"> + <div class="layui-col-md10"> + <div class="layui-form-item"> + <div class="layui-inline"> + <div class="layui-input-inline"> + <input type="text" placeholder="手机号/邮箱/邀请码" name="account" + autocomplete="off" class="layui-input"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">创建时间</label> + <div class="layui-input-inline"> + <input type="text" name="createTime" id="user-createTime" + class="layui-input"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">账号类型</label> + <div class="layui-input-inline"> + <select name="accountType"> + <option value=""></option> + <option value="1">测试账号</option> + <option value="2">正常账号</option> + </select> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">账号状态</label> + <div class="layui-input-inline"> + <select name="accountStatus"> + <option value=""></option> + <option value="0">禁用</option> + <option value="1">正常</option> + </select> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">实名状态</label> + <div class="layui-input-inline"> + <select name="certifyStatus"> + <option value=""></option> + <option value="0">未通过</option> + <option value="1">审核中</option> + <option value="2">审核通过</option> + <option value="2">未实名</option> + </select> + </div> + </div> + </div> + </div> + <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area"> + <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-blue-plain table-action" + id="query"> + <i class="layui-icon"></i> + </div> + <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain table-action" + id="reset"> + <i class="layui-icon"></i> + </div> + </div> + </div> + </form> + <table lay-filter="userTable" lay-data="{id: 'userTable'}"></table> + </div> + </div> + </div> + </div> +</div> +<!-- 表格字段状态格式化 start --> +<script type="text/html" id="open-type"> + {{# + var openType = { + 1: {title: '开多', color : 'blue'}, + 2: {title: '开空', color : 'red'} + }[d.openingType]; + }} + <span class="layui-badge febs-bg-{{openType.color}}">{{ openType.title }}</span> +</script> +<!-- 表格字段状态格式化 start --> + +<script data-th-inline="none" type="text/javascript"> + // 引入组件并初始化 + layui.use(['dropdown', 'jquery', 'laydate', 'form', 'table', 'febs', 'treeSelect'], function () { + var $ = layui.jquery, + laydate = layui.laydate, + febs = layui.febs, + form = layui.form, + table = layui.table, + $view = $('#febs-user'), + $query = $view.find('#query'), + $reset = $view.find('#reset'), + $searchForm = $view.find('form'), + sortObject = {field: 'createTime', type: null}, + tableIns, + createTimeFrom, + createTimeTo; + + form.render(); + + // 表格初始化 + initTable(); + + // 时间组件 + laydate.render({ + elem: '#user-createTime', + range: true, + trigger: 'click' + }); + + // 查询按钮 + $query.on('click', function () { + var params = $.extend(getQueryParams(), {field: sortObject.field, order: sortObject.type}); + tableIns.reload({where: params, page: {curr: 1}}); + }); + + // 刷新按钮 + $reset.on('click', function () { + $searchForm[0].reset(); + sortObject.type = 'null'; + createTimeTo = null; + createTimeFrom = null; + tableIns.reload({where: getQueryParams(), page: {curr: 1}, initSort: sortObject}); + }); + + function initTable() { + tableIns = febs.table.init({ + elem: $view.find('table'), + id: 'userTable', + url: ctx + 'order/getHoldList', + cols: [[ + {type: 'checkbox'}, + {field: 'orderNo', title: '订单编号', minWidth: 150, align: 'center'}, + {field: 'symbol', title: '币种', minWidth: 100, align: 'center'}, + {field: 'refererId', title: '上级UID', minWidth: 100, align: 'center'}, + {field: 'telphone', title: '联系方式', minWidth: 130, align: 'center'}, + {field: 'email', title: '邮箱', minWidth: 100, align: 'center'}, + {title: '开仓类型', templet: '#open-type', minWidth: 100, align: 'center'}, + {field: 'leverRatio', title: '杠杆倍率', minWidth: 100, align: 'center'}, + {field: 'openingPrice', title: '开仓均价', minWidth: 120, align: 'center'}, + {field: 'symbolCnt', title: '持仓数', minWidth: 100, align: 'center'}, + {field: 'symbolCntSale', title: '可平数', minWidth: 100, align: 'center'}, + {field: 'forceClosingPrice', title: '预估强平价', minWidth: 130, align: 'center'}, + {field: 'bondAmount', title: '保证金', minWidth: 130, align: 'center'}, + {field: 'createTime', title: '开仓时间', minWidth: 160, align: 'center'}, + {field: 'loseOrProfit', title: '盈亏', minWidth: 140, align: 'center', fixed : "right"}, + {field: 'returnRatio', title: '回报率', minWidth: 140, align: 'center', fixed : "right"}, + ]] + }); + } + + // 获取查询参数 + function getQueryParams() { + var createTime = $searchForm.find('input[name="createTime"]').val(); + if (createTime) { + createTimeFrom = createTime.split(' - ')[0]; + createTimeTo = createTime.split(' - ')[1]; + } + return { + startTime: createTimeFrom, + endTime: createTimeTo, + account: $searchForm.find('input[name="account"]').val().trim(), + accountStatus: $searchForm.find("select[name='accountStatus']").val(), + accountType: $searchForm.find("select[name='accountType']").val(), + certifyStatus: $searchForm.find("select[name='certifyStatus']").val(), + invalidate_ie_cache: new Date() + }; + } + }) +</script> \ No newline at end of file diff --git a/src/main/resources/templates/febs/views/modules/contract/totalFee-list.html b/src/main/resources/templates/febs/views/modules/contract/totalFee-list.html new file mode 100644 index 0000000..fd1f173 --- /dev/null +++ b/src/main/resources/templates/febs/views/modules/contract/totalFee-list.html @@ -0,0 +1,169 @@ +<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"> + <div class="layui-card-body febs-table-full"> + <form class="layui-form layui-table-form" lay-filter="user-table-form"> + <div class="layui-row"> + <div class="layui-col-md10"> + <div class="layui-form-item"> + <div class="layui-inline"> + <div class="layui-input-inline"> + <input type="text" placeholder="手机号/邮箱/邀请码" name="account" + autocomplete="off" class="layui-input"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">创建时间</label> + <div class="layui-input-inline"> + <input type="text" name="createTime" id="user-createTime" + class="layui-input"> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">账号类型</label> + <div class="layui-input-inline"> + <select name="accountType"> + <option value=""></option> + <option value="1">测试账号</option> + <option value="2">正常账号</option> + </select> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">账号状态</label> + <div class="layui-input-inline"> + <select name="accountStatus"> + <option value=""></option> + <option value="0">禁用</option> + <option value="1">正常</option> + </select> + </div> + </div> + <div class="layui-inline"> + <label class="layui-form-label layui-form-label-sm">实名状态</label> + <div class="layui-input-inline"> + <select name="certifyStatus"> + <option value=""></option> + <option value="0">未通过</option> + <option value="1">审核中</option> + <option value="2">审核通过</option> + <option value="2">未实名</option> + </select> + </div> + </div> + </div> + </div> + <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area"> + <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-blue-plain table-action" + id="query"> + <i class="layui-icon"></i> + </div> + <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain table-action" + id="reset"> + <i class="layui-icon"></i> + </div> + </div> + </div> + </form> + <table lay-filter="userTable" lay-data="{id: 'userTable'}"></table> + </div> + </div> + </div> + </div> +</div> +<!-- 表格字段状态格式化 start --> +<script type="text/html" id="open-type"> + {{# + var openType = { + 1: {title: '开多', color : 'blue'}, + 2: {title: '开空', color : 'red'} + }[d.openingType]; + }} + <span class="layui-badge febs-bg-{{openType.color}}">{{ openType.title }}</span> +</script> +<!-- 表格字段状态格式化 start --> + +<script data-th-inline="none" type="text/javascript"> + // 引入组件并初始化 + layui.use(['dropdown', 'jquery', 'laydate', 'form', 'table', 'febs', 'treeSelect'], function () { + var $ = layui.jquery, + laydate = layui.laydate, + febs = layui.febs, + form = layui.form, + table = layui.table, + $view = $('#febs-user'), + $query = $view.find('#query'), + $reset = $view.find('#reset'), + $searchForm = $view.find('form'), + sortObject = {field: 'createTime', type: null}, + tableIns, + createTimeFrom, + createTimeTo; + + form.render(); + + // 表格初始化 + initTable(); + + // 时间组件 + laydate.render({ + elem: '#user-createTime', + range: true, + trigger: 'click' + }); + + // 查询按钮 + $query.on('click', function () { + var params = $.extend(getQueryParams(), {field: sortObject.field, order: sortObject.type}); + tableIns.reload({where: params, page: {curr: 1}}); + }); + + // 刷新按钮 + $reset.on('click', function () { + $searchForm[0].reset(); + sortObject.type = 'null'; + createTimeTo = null; + createTimeFrom = null; + tableIns.reload({where: getQueryParams(), page: {curr: 1}, initSort: sortObject}); + }); + + function initTable() { + tableIns = febs.table.init({ + elem: $view.find('table'), + id: 'userTable', + url: ctx + 'member/getFeeAmountList', + cols: [[ + {type: 'checkbox'}, + {field: 'inviteId', title: '代理UID', minWidth: 150, align: 'center'}, + {field: 'refererId', title: '上级UID', minWidth: 100, align: 'center'}, + {field: 'telphone', title: '联系方式', minWidth: 130, align: 'center'}, + {field: 'email', title: '邮箱', minWidth: 100, align: 'center'}, + {field: 'account', title: '姓名', minWidth: 100, align: 'center'}, + {field: 'openFeeAmount', title: '开仓手续费', minWidth: 140, align: 'center'}, + {field: 'closeFeeAmount', title: '平仓手续费', minWidth: 140, align: 'center'}, + {field: 'holdFeeAmount', title: '持仓手续费', minWidth: 140, align: 'center'}, + {field: 'loseOrProfit', title: '净盈利', minWidth: 140, align: 'center'} + ]] + }); + } + + // 获取查询参数 + function getQueryParams() { + var createTime = $searchForm.find('input[name="createTime"]').val(); + if (createTime) { + createTimeFrom = createTime.split(' - ')[0]; + createTimeTo = createTime.split(' - ')[1]; + } + return { + startTime: createTimeFrom, + endTime: createTimeTo, + account: $searchForm.find('input[name="account"]').val().trim(), + accountStatus: $searchForm.find("select[name='accountStatus']").val(), + accountType: $searchForm.find("select[name='accountType']").val(), + certifyStatus: $searchForm.find("select[name='certifyStatus']").val(), + invalidate_ie_cache: new Date() + }; + } + }) +</script> \ No newline at end of file -- Gitblit v1.9.1