From 02c660bd6f359e670d533d2101470b5b6944cc99 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Mon, 20 Jul 2020 22:42:33 +0800
Subject: [PATCH] 20200720 代码提交
---
src/main/java/com/xcong/excoin/modules/member/entity/MemberAccountMoneyChangeEntity.java | 6 +
src/main/java/com/xcong/excoin/modules/trademanage/service/impl/TradeManageServiceImpl.java | 42 ++++++++++
src/main/resources/mapper/modules/AgentReturnMapper.xml | 11 ++
src/main/java/com/xcong/excoin/modules/trademanage/controller/TradeManageController.java | 9 ++
src/main/java/com/xcong/excoin/modules/trademanage/service/TradeManageService.java | 3
src/main/java/com/xcong/excoin/modules/trademanage/mapper/AgentReturnMapper.java | 2
src/main/java/com/xcong/excoin/modules/member/mapper/MemberAccountMoneyChangeMapper.java | 5 +
src/main/resources/mapper/modules/MemberAccountMoneyChangeMapper.xml | 32 ++++++++
src/main/resources/templates/febs/views/modules/trademanage/agentReturnInfosAlone.html | 118 +++++++++++++++++++++++++++++
src/main/java/com/xcong/excoin/modules/trademanage/controller/ViewController.java | 10 ++
10 files changed, 238 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/xcong/excoin/modules/member/entity/MemberAccountMoneyChangeEntity.java b/src/main/java/com/xcong/excoin/modules/member/entity/MemberAccountMoneyChangeEntity.java
index c0ceb88..2db22e1 100644
--- a/src/main/java/com/xcong/excoin/modules/member/entity/MemberAccountMoneyChangeEntity.java
+++ b/src/main/java/com/xcong/excoin/modules/member/entity/MemberAccountMoneyChangeEntity.java
@@ -75,4 +75,10 @@
*/
@TableField(exist = false)
private String inviteId;
+
+ /**
+ * 总返佣
+ */
+ @TableField(exist = false)
+ private String allAmount;
}
diff --git a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberAccountMoneyChangeMapper.java b/src/main/java/com/xcong/excoin/modules/member/mapper/MemberAccountMoneyChangeMapper.java
index b56a692..6b86880 100644
--- a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberAccountMoneyChangeMapper.java
+++ b/src/main/java/com/xcong/excoin/modules/member/mapper/MemberAccountMoneyChangeMapper.java
@@ -12,4 +12,9 @@
IPage<MemberAccountMoneyChangeEntity> findMemberAccountInfoListInPage(Page<MemberAccountMoneyChangeEntity> page,
@Param("record") MemberAccountMoneyChangeEntity memberAccountMoneyChangeEntity);
+ IPage<MemberAccountMoneyChangeEntity> findMemberAgentReturnInfoAloneInPage(
+ Page<MemberAccountMoneyChangeEntity> page, @Param("record")MemberAccountMoneyChangeEntity memberAccountMoneyChangeEntity);
+
+ String selectAccountMoneyChangeByMemberId(Long memberId);
+
}
diff --git a/src/main/java/com/xcong/excoin/modules/trademanage/controller/TradeManageController.java b/src/main/java/com/xcong/excoin/modules/trademanage/controller/TradeManageController.java
index 8ab6521..d714900 100644
--- a/src/main/java/com/xcong/excoin/modules/trademanage/controller/TradeManageController.java
+++ b/src/main/java/com/xcong/excoin/modules/trademanage/controller/TradeManageController.java
@@ -63,6 +63,15 @@
}
/**
+ * 返佣明细---alone
+ */
+ @GetMapping("memberAgentReturnInfoAlone")
+ public FebsResponse memberAgentReturnInfoAlone(MemberAccountMoneyChangeEntity memberAccountMoneyChangeEntity, QueryRequest request) {
+ Map<String, Object> data = getDataTable(tradeManageService.findMemberAgentReturnInfoAloneInPage(memberAccountMoneyChangeEntity, request));
+ return new FebsResponse().success().data(data);
+ }
+
+ /**
* 返佣总明细---列表
*/
@GetMapping("memberAgentReturnInfos")
diff --git a/src/main/java/com/xcong/excoin/modules/trademanage/controller/ViewController.java b/src/main/java/com/xcong/excoin/modules/trademanage/controller/ViewController.java
index e08dee9..c4dc36e 100644
--- a/src/main/java/com/xcong/excoin/modules/trademanage/controller/ViewController.java
+++ b/src/main/java/com/xcong/excoin/modules/trademanage/controller/ViewController.java
@@ -93,4 +93,14 @@
return FebsUtil.view("modules/trademanage/historyOrderAll");
}
+ /**
+ * 返佣总明细
+ * @return
+ */
+ @GetMapping("agentReturnInfosAlone")
+ @RequiresPermissions("agentReturnInfosAlone:view")
+ public String agentReturnInfosAlone() {
+ return FebsUtil.view("modules/trademanage/agentReturnInfosAlone");
+ }
+
}
diff --git a/src/main/java/com/xcong/excoin/modules/trademanage/mapper/AgentReturnMapper.java b/src/main/java/com/xcong/excoin/modules/trademanage/mapper/AgentReturnMapper.java
index fe9bc90..4eb1cc7 100644
--- a/src/main/java/com/xcong/excoin/modules/trademanage/mapper/AgentReturnMapper.java
+++ b/src/main/java/com/xcong/excoin/modules/trademanage/mapper/AgentReturnMapper.java
@@ -12,4 +12,6 @@
IPage<AgentReturnEntity> findMemberAgentReturnInfosInPage(Page<AgentReturnEntity> page,
@Param("record") AgentReturnEntity agentReturnEntity);
+ String selectYJByMemberId();
+
}
diff --git a/src/main/java/com/xcong/excoin/modules/trademanage/service/TradeManageService.java b/src/main/java/com/xcong/excoin/modules/trademanage/service/TradeManageService.java
index a9bfd32..9c4848a 100644
--- a/src/main/java/com/xcong/excoin/modules/trademanage/service/TradeManageService.java
+++ b/src/main/java/com/xcong/excoin/modules/trademanage/service/TradeManageService.java
@@ -32,4 +32,7 @@
IPage<ContractOrderEntity> findHistoryOrderInfoAloneInfoInPage(ContractOrderEntity contractOrderEntity, QueryRequest request);
+ IPage<MemberAccountMoneyChangeEntity> findMemberAgentReturnInfoAloneInPage(MemberAccountMoneyChangeEntity memberAccountMoneyChangeEntity,
+ QueryRequest request);
+
}
diff --git a/src/main/java/com/xcong/excoin/modules/trademanage/service/impl/TradeManageServiceImpl.java b/src/main/java/com/xcong/excoin/modules/trademanage/service/impl/TradeManageServiceImpl.java
index 00ed1a6..5d38486 100644
--- a/src/main/java/com/xcong/excoin/modules/trademanage/service/impl/TradeManageServiceImpl.java
+++ b/src/main/java/com/xcong/excoin/modules/trademanage/service/impl/TradeManageServiceImpl.java
@@ -201,4 +201,46 @@
return findMemberAccountInfoListInPage;
}
+ @Override
+ public IPage<MemberAccountMoneyChangeEntity> findMemberAgentReturnInfoAloneInPage(
+ MemberAccountMoneyChangeEntity memberAccountMoneyChangeEntity, QueryRequest request) {
+ Page<MemberAccountMoneyChangeEntity> page = new Page<>(request.getPageNum(), request.getPageSize());
+ IPage<MemberAccountMoneyChangeEntity> findMemberAccountInfoListInPage =
+ memberAccountMoneyChangeMapper.findMemberAgentReturnInfoAloneInPage(page, memberAccountMoneyChangeEntity);
+ List<MemberAccountMoneyChangeEntity> records = findMemberAccountInfoListInPage.getRecords();
+ if(records != null && records.size() > 0) {
+ for(MemberAccountMoneyChangeEntity accountMoneyChangeEntity : records) {
+ Long memberId = accountMoneyChangeEntity.getMemberId();
+ String allAmount = memberAccountMoneyChangeMapper.selectAccountMoneyChangeByMemberId(memberId);
+ accountMoneyChangeEntity.setAllAmount(allAmount);
+ }
+ }
+
+ return findMemberAccountInfoListInPage;
+ }
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
}
diff --git a/src/main/resources/mapper/modules/AgentReturnMapper.xml b/src/main/resources/mapper/modules/AgentReturnMapper.xml
index 99884d7..ef3bc1e 100644
--- a/src/main/resources/mapper/modules/AgentReturnMapper.xml
+++ b/src/main/resources/mapper/modules/AgentReturnMapper.xml
@@ -25,5 +25,16 @@
</where>
order by s.create_time desc
</select>
+
+ <select id="selectYJByMemberId" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(return_amount), '0') AS amount
+ FROM
+ agent_return a
+ LEFT JOIN member m on m.id = a.member_id
+ WHERE
+ a.referer_id = 8
+ and FIND_IN_SET('22015141', m.referer_ids)
+ </select>
</mapper>
\ No newline at end of file
diff --git a/src/main/resources/mapper/modules/MemberAccountMoneyChangeMapper.xml b/src/main/resources/mapper/modules/MemberAccountMoneyChangeMapper.xml
index 9936aba..549ade7 100644
--- a/src/main/resources/mapper/modules/MemberAccountMoneyChangeMapper.xml
+++ b/src/main/resources/mapper/modules/MemberAccountMoneyChangeMapper.xml
@@ -27,5 +27,37 @@
</where>
ORDER BY s.create_time DESC
</select>
+
+ <select id="findMemberAgentReturnInfoAloneInPage" resultType="com.xcong.excoin.modules.member.entity.MemberAccountMoneyChangeEntity">
+ SELECT
+ m.phone,
+ m.email,
+ m.invite_id inviteId,
+ s.member_id,
+ s.symbol,
+ s.amount,
+ s.content,
+ s.create_time createTime,
+ s. STATUS,
+ s.type
+ FROM
+ member_account_money_change s
+ LEFT JOIN member m ON m.id = s.member_id
+ <where>
+ s.type = 3
+ and (FIND_IN_SET('22015141', m.referer_ids) or m.id in (10))
+ 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>
+
+ <select id="selectAccountMoneyChangeByMemberId" resultType="java.lang.String">
+ select IFNULL(SUM(s.amount), '0') AS allAmount from member_account_money_change s where s.content like '%佣金到账%' and s.member_id = #{memberId}
+ </select>
</mapper>
\ No newline at end of file
diff --git a/src/main/resources/templates/febs/views/modules/trademanage/agentReturnInfosAlone.html b/src/main/resources/templates/febs/views/modules/trademanage/agentReturnInfosAlone.html
new file mode 100644
index 0000000..e50eadd
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/trademanage/agentReturnInfosAlone.html
@@ -0,0 +1,118 @@
+<div class="layui-fluid layui-anim febs-anim" id="febs-user" lay-title="返佣明细03">
+ <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>
+ </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>
+<!-- 表格操作栏 end -->
+<script data-th-inline="none" type="text/javascript">
+ // 引入组件并初始化
+ layui.use([ 'jquery', 'laydate', 'form', 'table', 'febs'], 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;
+
+ form.render();
+
+ // 表格初始化
+ initTable();
+
+ // 查询按钮
+ $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';
+ tableIns.reload({where: getQueryParams(), page: {curr: 1}, initSort: sortObject});
+ });
+
+ function initTable() {
+ tableIns = febs.table.init({
+ elem: $view.find('table'),
+ id: 'userTable',
+ url: ctx + 'tradeManage/memberAgentReturnInfoAlone',
+ totalRow: true,
+ cols: [[
+ {field: 'phone', title: '手机号', minWidth: 100,align:'left',totalRowText: '合计'},
+ {field: 'email', title: '邮箱', minWidth: 200,align:'left'},
+ {field: 'inviteId', title: '邀请码UID', minWidth: 80,align:'center'},
+ {field: 'symbol', title: '币种', minWidth: 80,align:'center'},
+ {field: 'allAmount', title: '总佣金', minWidth: 80,align:'center',totalRow: true},
+ {field: 'amount', title: '本次金额', minWidth: 80,align:'center',totalRow: true},
+ {field: 'content', title: '记录内容', minWidth: 80,align:'center'},
+ {field: 'createTime', title: '时间', minWidth: 80,align:'center'},
+ {field: 'status', title: '状态',
+ templet: function (d) {
+ if (d.status === 0) {
+ return '<span style="color:blue;">待审核</span>'
+ } else if (d.status === 1) {
+ return '<span style="color:green;">成功</span>'
+ }else if (d.status === 2) {
+ return '<span style="color:red;">失败</span>'
+ }else{
+ return ''
+ }
+ }, minWidth: 80,align:'center'},
+ {field: 'type', title: '类型',
+ templet: function (d) {
+ if (d.type === 1) {
+ return '<span>币币资产</span>'
+ } else if (d.type === 2) {
+ return '<span>合约资产</span>'
+ }else if (d.type === 3) {
+ return '<span>代理资产</span>'
+ }else{
+ return ''
+ }
+ }, minWidth: 80,align:'center'}
+ ]]
+ });
+ }
+
+ // 获取查询参数
+ function getQueryParams() {
+ return {
+ account: $searchForm.find('input[name="account"]').val().trim(),
+ };
+ }
+
+ })
+</script>
\ No newline at end of file
--
Gitblit v1.9.1