From 6dafb553cfdff86eb467a68b0d1073e3aa2bdf8b Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Fri, 24 Sep 2021 11:42:45 +0800 Subject: [PATCH] 20210924 --- src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java | 1 src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallOrderService.java | 3 src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java | 17 ++++ src/main/resources/mapper/modules/MallMemberMapper.xml | 2 src/main/resources/templates/febs/views/modules/mallMember/moneyFlow.html | 70 +++++++++++++++++ src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallMemberServiceImpl.java | 12 +++ src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html | 7 + src/main/java/cc/mrbird/febs/mall/controller/ViewMallMemberController.java | 24 ++++++ src/main/java/cc/mrbird/febs/mall/vo/AdminMallMoneyFlowVo.java | 27 ++++++ src/main/resources/mapper/modules/MallMoneyFlowMapper.xml | 5 + src/main/resources/templates/febs/views/modules/mallMember/detail.html | 8 ++ src/main/resources/templates/febs/views/modules/order/orderList.html | 1 src/main/java/cc/mrbird/febs/mall/mapper/MallMoneyFlowMapper.java | 8 ++ src/main/java/cc/mrbird/febs/mall/service/IAdminMallMemberService.java | 4 + 14 files changed, 188 insertions(+), 1 deletions(-) diff --git a/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java b/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java index aee034e..9ef0804 100644 --- a/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java +++ b/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java @@ -5,6 +5,7 @@ import cc.mrbird.febs.common.entity.FebsResponse; import cc.mrbird.febs.common.entity.QueryRequest; import cc.mrbird.febs.mall.entity.MallMember; +import cc.mrbird.febs.mall.entity.MallOrderRefund; import cc.mrbird.febs.mall.service.IAdminMallMemberService; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; @@ -59,4 +60,20 @@ public FebsResponse openAccount(@NotNull(message = "{required}") @PathVariable Long id) { return mallMemberService.openAccount(id); } + + /** + * 会员列表-资金流水 + */ + @GetMapping("/moneyFlow") + public FebsResponse moneyFlow(QueryRequest request, MallMember mallMember, Integer parentId) { + if(parentId==null){ + ViewMallMemberController.idFromMoneyFlow=0; + } + mallMember.setId(ViewMallOrderController.idFromRefund); + Map<String, Object> dataTable = getDataTable(mallMemberService.moneyFlow(request, mallMember)); + return new FebsResponse().success().data(dataTable); + } + + + } diff --git a/src/main/java/cc/mrbird/febs/mall/controller/ViewMallMemberController.java b/src/main/java/cc/mrbird/febs/mall/controller/ViewMallMemberController.java index 4faee7f..9057754 100644 --- a/src/main/java/cc/mrbird/febs/mall/controller/ViewMallMemberController.java +++ b/src/main/java/cc/mrbird/febs/mall/controller/ViewMallMemberController.java @@ -21,6 +21,8 @@ private final IAdminMallMemberService mallMemberService; + public static long idFromMoneyFlow; + /** * 会员列表 * @return @@ -45,4 +47,26 @@ return FebsUtil.view("modules/mallMember/detail"); } + /** + * 会员列表-资金流水 + * @param id + * @param model + * @return + */ + @GetMapping("moneyFlow/{id}") + public String moneyFlow(@PathVariable long id, Model model) { + idFromMoneyFlow = id; + return FebsUtil.view("modules/mallMember/moneyFlow"); + } + + + + + + + + + + + } diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java index 513984a..3708e77 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java +++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java @@ -20,5 +20,6 @@ MallMember selectInfoByInviteId(@Param("inviteId") String inviteId); MallMember selectInfoByAccountAndPwd(@Param("account") String account, @Param("password") String password); + MallMemberVo getMallMemberInfoById(@Param("id")long id); } diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallMoneyFlowMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallMoneyFlowMapper.java index 7e1e324..026adac 100644 --- a/src/main/java/cc/mrbird/febs/mall/mapper/MallMoneyFlowMapper.java +++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallMoneyFlowMapper.java @@ -1,7 +1,15 @@ package cc.mrbird.febs.mall.mapper; +import cc.mrbird.febs.mall.entity.MallMember; import cc.mrbird.febs.mall.entity.MallMoneyFlow; +import cc.mrbird.febs.mall.vo.AdminMallMoneyFlowVo; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import org.apache.ibatis.annotations.Param; public interface MallMoneyFlowMapper extends BaseMapper<MallMoneyFlow> { + + IPage<AdminMallMoneyFlowVo> selectMoneyFlowInPage(Page<AdminMallMoneyFlowVo> page, @Param("record")MallMember mallMember); + } diff --git a/src/main/java/cc/mrbird/febs/mall/service/IAdminMallMemberService.java b/src/main/java/cc/mrbird/febs/mall/service/IAdminMallMemberService.java index 91a6cdc..174be53 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/IAdminMallMemberService.java +++ b/src/main/java/cc/mrbird/febs/mall/service/IAdminMallMemberService.java @@ -4,6 +4,8 @@ import cc.mrbird.febs.common.entity.QueryRequest; import cc.mrbird.febs.mall.dto.RegisterDto; import cc.mrbird.febs.mall.entity.MallMember; +import cc.mrbird.febs.mall.entity.MallMoneyFlow; +import cc.mrbird.febs.mall.vo.AdminMallMoneyFlowVo; import cc.mrbird.febs.mall.vo.MallMemberVo; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.IService; @@ -19,4 +21,6 @@ FebsResponse openAccount(@NotNull(message = "{required}") Long id); MallMemberVo getMallMemberInfoById(@NotNull(message = "{required}") long id); + + IPage<AdminMallMoneyFlowVo> moneyFlow(QueryRequest request, MallMember mallMember); } diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallMemberServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallMemberServiceImpl.java index bc8642c..6a0273e 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallMemberServiceImpl.java +++ b/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallMemberServiceImpl.java @@ -4,7 +4,10 @@ import cc.mrbird.febs.common.entity.QueryRequest; import cc.mrbird.febs.mall.entity.MallMember; import cc.mrbird.febs.mall.mapper.MallMemberMapper; +import cc.mrbird.febs.mall.mapper.MallMoneyFlowMapper; import cc.mrbird.febs.mall.service.IAdminMallMemberService; +import cc.mrbird.febs.mall.vo.AdminMallMoneyFlowVo; +import cc.mrbird.febs.mall.vo.AdminMallOrderRefundOperationVo; import cc.mrbird.febs.mall.vo.MallMemberVo; import cn.hutool.core.util.ObjectUtil; import com.baomidou.mybatisplus.core.metadata.IPage; @@ -24,6 +27,8 @@ public class AdminMallMemberServiceImpl extends ServiceImpl<MallMemberMapper, MallMember> implements IAdminMallMemberService { private final MallMemberMapper mallMemberMapper; + + private final MallMoneyFlowMapper mallMoneyFlowMapper; @Override public IPage<MallMember> getMallMemberList(MallMember mallMember, QueryRequest request) { @@ -60,4 +65,11 @@ return mallMemberVo; } + @Override + public IPage<AdminMallMoneyFlowVo> moneyFlow(QueryRequest request, MallMember mallMember) { + Page<AdminMallMoneyFlowVo> page = new Page<>(request.getPageNum(), request.getPageSize()); + IPage<AdminMallMoneyFlowVo> adminMallMoneyFlowVos = mallMoneyFlowMapper.selectMoneyFlowInPage(page, mallMember); + return adminMallMoneyFlowVos; + } + } diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallOrderService.java b/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallOrderService.java index b862a1a..0b4f0a0 100644 --- a/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallOrderService.java +++ b/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallOrderService.java @@ -67,7 +67,8 @@ return new FebsResponse().fail().message("请输入物流公司"); } MallExpressInfo mallExpressInfo = new MallExpressInfo(); - mallExpressInfo.setMemberId(mallExpressInfo.getMemberId()); + mallExpressInfo.setMemberId(mallOrderInfo.getMemberId()); + mallExpressInfo.setOrderId(mallOrderInfo.getId()); mallExpressInfo.setExpressNo(expressNo); mallExpressInfo.setExpressCom(expressCom); mallExpressInfoMapper.insert(mallExpressInfo); diff --git a/src/main/java/cc/mrbird/febs/mall/vo/AdminMallMoneyFlowVo.java b/src/main/java/cc/mrbird/febs/mall/vo/AdminMallMoneyFlowVo.java new file mode 100644 index 0000000..56dcbb7 --- /dev/null +++ b/src/main/java/cc/mrbird/febs/mall/vo/AdminMallMoneyFlowVo.java @@ -0,0 +1,27 @@ +package cc.mrbird.febs.mall.vo; + +import com.fasterxml.jackson.annotation.JsonFormat; +import io.swagger.annotations.ApiModel; +import lombok.Data; + +import java.math.BigDecimal; +import java.util.Date; + +@Data +@ApiModel(value = "AdminMallMoneyFlowVo", description = "信息返回类") +public class AdminMallMoneyFlowVo { + + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") + private Date createdTime; + + private BigDecimal amount; + + private Integer type; + + private String orderNo; + + private String description; + + private String remark; + +} diff --git a/src/main/resources/mapper/modules/MallMemberMapper.xml b/src/main/resources/mapper/modules/MallMemberMapper.xml index 148abc5..96f8df2 100644 --- a/src/main/resources/mapper/modules/MallMemberMapper.xml +++ b/src/main/resources/mapper/modules/MallMemberMapper.xml @@ -36,9 +36,11 @@ a.level, a.account_status, a.CREATED_TIME, + c.balance, b.name FROM mall_member a LEFT JOIN mall_member b on a.referrer_id = b.invite_id + LEFT JOIN mall_member_wallet c on c.member_id = a.id where a.id = #{id} </select> diff --git a/src/main/resources/mapper/modules/MallMoneyFlowMapper.xml b/src/main/resources/mapper/modules/MallMoneyFlowMapper.xml index 9d3fa8b..9dfef8f 100644 --- a/src/main/resources/mapper/modules/MallMoneyFlowMapper.xml +++ b/src/main/resources/mapper/modules/MallMoneyFlowMapper.xml @@ -2,4 +2,9 @@ <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="cc.mrbird.febs.mall.mapper.MallMoneyFlowMapper"> + <select id="selectMoneyFlowInPage" resultType="cc.mrbird.febs.mall.vo.AdminMallMoneyFlowVo"> + select * from mall_money_flow a where a.member_id = #{record.id} + order by a.CREATED_TIME desc + </select> + </mapper> \ No newline at end of file diff --git a/src/main/resources/templates/febs/views/modules/mallMember/detail.html b/src/main/resources/templates/febs/views/modules/mallMember/detail.html index 77577db..36606ba 100644 --- a/src/main/resources/templates/febs/views/modules/mallMember/detail.html +++ b/src/main/resources/templates/febs/views/modules/mallMember/detail.html @@ -33,6 +33,13 @@ </div> </div> <div class="layui-form-item"> + <label class="layui-form-label febs-form-item-require">余额:</label> + <div class="layui-input-block"> + <input type="text" name="balance" data-th-id="${member.balance}" + autocomplete="off" class="layui-input" readonly> + </div> + </div> + <div class="layui-form-item"> <label class="layui-form-label febs-form-item-require">代理层级:</label> <div class="layui-input-block"> <input type="text" name="level" data-th-id="${member.level}" @@ -116,6 +123,7 @@ "phone": member.phone, "email": member.email, "sex": member.sex, + "balance": member.balance, "inviteId": member.inviteId, "referrerName": member.referrerName, "level": member.level, diff --git a/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html b/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html index dcff9c6..cffe25b 100644 --- a/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html +++ b/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html @@ -92,6 +92,11 @@ maxmin: true, }); } + if (layEvent === 'moneyFlow') { + febs.modal.open( '用户资金流水', 'modules/mallMember/moneyFlow/' + data.id, { + maxmin: true, + }); + } }); function closeAccount(id) { febs.get(ctx + 'admin/mallMember/closeAccount/' + id, null, function () { @@ -157,10 +162,12 @@ if (d.accountStatus === 1) { return '<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="see" shiro:hasPermission="user:update">详情</button>' +'<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="close" shiro:hasPermission="user:update">禁用</button>' + +'<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="moneyFlow" shiro:hasPermission="user:update">资金流水</button>' }else{ return '<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="see" shiro:hasPermission="user:update">详情</button>' +'<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="open" shiro:hasPermission="user:update">启用</button>' + +'<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="moneyFlow" shiro:hasPermission="user:update">资金流水</button>' } },minWidth: 300,align:'center'} diff --git a/src/main/resources/templates/febs/views/modules/mallMember/moneyFlow.html b/src/main/resources/templates/febs/views/modules/mallMember/moneyFlow.html new file mode 100644 index 0000000..880ec15 --- /dev/null +++ b/src/main/resources/templates/febs/views/modules/mallMember/moneyFlow.html @@ -0,0 +1,70 @@ +<div class="layui-fluid layui-anim febs-anim" id="febs-moneyFlow-child" 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"> + <table lay-filter="moneyFlowChild" lay-data="{id: 'moneyFlowChild'}"></table> + </div> + </div> + </div> + </div> +</div> +<script data-th-inline="none" type="text/javascript"> + layui.use(['dropdown', 'jquery', 'laydate', 'form', 'table', 'febs', 'treeSelect' ,'eleTree'], function () { + var $ = layui.jquery, + laydate = layui.laydate, + febs = layui.febs, + form = layui.form, + table = layui.table, + treeSelect = layui.treeSelect, + dropdown = layui.dropdown, + $view = $('#febs-moneyFlow-child'), + $query = $view.find('#queryChild'), + $searchForm = $view.find('formChild'), + sortObject = {field: 'createTime', type: null}, + tableIns, + createTimeFrom, + createTimeTo; + + form.render(); + + initTable(); + + laydate.render({ + elem: '#user-createTime', + range: true, + trigger: 'click' + }); + + + function initTable() { + tableIns = febs.table.init({ + elem: $view.find('table'), + id: 'moneyFlowChild', + url: ctx + 'admin/mallMember/moneyFlow?parentId=1', + cols: [[ + {field: 'orderNo', title: '订单编号', minWidth: 150,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 if (d.type === 4) { + return '<span>退款</span>' + }else{ + return '' + } + }, minWidth: 80,align:'center'}, + {field: 'amount', title: '金额', minWidth: 80,align:'center'}, + {field: 'createdTime', title: '时间', minWidth: 150,align:'left'}, + {field: 'description', title: '描述', minWidth: 150,align:'left'}, + {field: 'remark', title: '备注', minWidth: 150,align:'left'}, + ]] + }); + } + + }) +</script> \ No newline at end of file diff --git a/src/main/resources/templates/febs/views/modules/order/orderList.html b/src/main/resources/templates/febs/views/modules/order/orderList.html index 11bff7c..2a62c2a 100644 --- a/src/main/resources/templates/febs/views/modules/order/orderList.html +++ b/src/main/resources/templates/febs/views/modules/order/orderList.html @@ -169,6 +169,7 @@ templet: function (d) { if (d.status === 2) { return '<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="deliverGoods" shiro:hasPermission="user:update">发货</button>' + +'<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="seeOrder" shiro:hasPermission="user:update">详情</button>' }else{ return '<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="seeOrder" shiro:hasPermission="user:update">详情</button>' } -- Gitblit v1.9.1