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; } 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); } 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") 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"); } } 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(); } 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); } 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; } } 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> 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> src/main/resources/templates/febs/views/modules/trademanage/agentReturnInfosAlone.html
New file @@ -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>
