From 93977b43fc8256761b7035b9d3d3e39c24451477 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Sun, 26 Sep 2021 18:19:53 +0800
Subject: [PATCH] 20210926
---
src/main/java/cc/mrbird/febs/mall/controller/ViewMallMemberController.java | 10 +
src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java | 8 +
src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java | 13 ++
src/main/resources/mapper/modules/MallMemberMapper.xml | 26 ++++
src/main/java/cc/mrbird/febs/mall/dto/AgentDto.java | 15 ++
src/main/java/cc/mrbird/febs/mall/vo/AdminAgentVo.java | 38 ++++++
src/main/resources/templates/febs/views/modules/mallMember/agentList.html | 168 ++++++++++++++++++++++++++++
src/main/java/cc/mrbird/febs/mall/service/IAdminMallMemberService.java | 3
src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallMemberServiceImpl.java | 24 ++++
9 files changed, 305 insertions(+), 0 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 79a08ee..e907f35 100644
--- a/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java
+++ b/src/main/java/cc/mrbird/febs/mall/controller/AdminMallMemberController.java
@@ -4,6 +4,7 @@
import cc.mrbird.febs.common.controller.BaseController;
import cc.mrbird.febs.common.entity.FebsResponse;
import cc.mrbird.febs.common.entity.QueryRequest;
+import cc.mrbird.febs.mall.dto.AgentDto;
import cc.mrbird.febs.mall.dto.MoneyChargeListDto;
import cc.mrbird.febs.mall.dto.MoneyFlowListDto;
import cc.mrbird.febs.mall.entity.MallMember;
@@ -122,6 +123,18 @@
return mallMemberService.chargeDisagree(id);
}
+ /**
+ * 代理列表
+ * @param agentDto
+ * @param request
+ * @return
+ */
+ @GetMapping("getAgentList")
+ public FebsResponse getAgentList(AgentDto agentDto, QueryRequest request) {
+ Map<String, Object> data = getDataTable(mallMemberService.getAgentList(agentDto, request));
+ return new FebsResponse().success().data(data);
+ }
+
}
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 a3a48a7..cab9dc3 100644
--- a/src/main/java/cc/mrbird/febs/mall/controller/ViewMallMemberController.java
+++ b/src/main/java/cc/mrbird/febs/mall/controller/ViewMallMemberController.java
@@ -94,6 +94,16 @@
return FebsUtil.view("modules/mallMember/paymentInfo");
}
+ /**
+ * 代理列表
+ * @return
+ */
+ @GetMapping("agentList")
+ @RequiresPermissions("agentList:view")
+ public String agentList() {
+ return FebsUtil.view("modules/mallMember/agentList");
+ }
+
diff --git a/src/main/java/cc/mrbird/febs/mall/dto/AgentDto.java b/src/main/java/cc/mrbird/febs/mall/dto/AgentDto.java
new file mode 100644
index 0000000..32124df
--- /dev/null
+++ b/src/main/java/cc/mrbird/febs/mall/dto/AgentDto.java
@@ -0,0 +1,15 @@
+package cc.mrbird.febs.mall.dto;
+
+import io.swagger.annotations.ApiModel;
+import lombok.Data;
+
+@Data
+@ApiModel(value = "AgentDto", description = "地址接收参数类")
+public class AgentDto {
+
+ private String name;
+
+ private String account;
+
+ private String level;
+}
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 4650b3b..5c82afd 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java
@@ -1,6 +1,8 @@
package cc.mrbird.febs.mall.mapper;
+import cc.mrbird.febs.mall.dto.AgentDto;
import cc.mrbird.febs.mall.entity.MallMember;
+import cc.mrbird.febs.mall.vo.AdminAgentVo;
import cc.mrbird.febs.mall.vo.MallMemberVo;
import cc.mrbird.febs.mall.vo.TeamListVo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@@ -40,4 +42,10 @@
List<MallMember> selectChildAgentList(@Param("inviteId") String inviteId, @Param("agentLevel") String agentLevel);
List<MallMember> selectByInviteIds(@Param("list") List<String> inviteIds);
+
+ IPage<AdminAgentVo> getAgentListInPage(Page<AdminAgentVo> page, @Param("record")AgentDto agentDto);
+
+ List<MallMember> selectChildAgentListByInviteId(@Param("inviteId")String inviteId);
+
+ List<MallMember> selectAllChildAgentListByInviteId(@Param("inviteId")String inviteId);
}
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 9be5be2..79cfe9f 100644
--- a/src/main/java/cc/mrbird/febs/mall/service/IAdminMallMemberService.java
+++ b/src/main/java/cc/mrbird/febs/mall/service/IAdminMallMemberService.java
@@ -2,6 +2,7 @@
import cc.mrbird.febs.common.entity.FebsResponse;
import cc.mrbird.febs.common.entity.QueryRequest;
+import cc.mrbird.febs.mall.dto.AgentDto;
import cc.mrbird.febs.mall.dto.MoneyChargeListDto;
import cc.mrbird.febs.mall.dto.MoneyFlowListDto;
import cc.mrbird.febs.mall.entity.MallMember;
@@ -32,4 +33,6 @@
FebsResponse chargeDisagree(Long id);
AdminMallMemberPaymentVo getMallMemberPaymentInfoByFlowId(long id);
+
+ IPage<AdminAgentVo> getAgentList(AgentDto agentDto, QueryRequest request);
}
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 ba0fb10..c3cc822 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
@@ -2,6 +2,7 @@
import cc.mrbird.febs.common.entity.FebsResponse;
import cc.mrbird.febs.common.entity.QueryRequest;
+import cc.mrbird.febs.mall.dto.AgentDto;
import cc.mrbird.febs.mall.dto.MoneyChargeListDto;
import cc.mrbird.febs.mall.dto.MoneyFlowListDto;
import cc.mrbird.febs.mall.entity.MallMember;
@@ -12,6 +13,7 @@
import cc.mrbird.febs.mall.service.IAdminMallMemberService;
import cc.mrbird.febs.mall.service.IApiMallMemberWalletService;
import cc.mrbird.febs.mall.vo.*;
+import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.util.ObjectUtil;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
@@ -20,6 +22,8 @@
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+
+import java.util.List;
/**
* @author wzy
@@ -140,4 +144,24 @@
return adminMallMemberPaymentVo;
}
+ @Override
+ public IPage<AdminAgentVo> getAgentList(AgentDto agentDto, QueryRequest request) {
+ Page<AdminAgentVo> page = new Page<>(request.getPageNum(), request.getPageSize());
+ IPage<AdminAgentVo> adminAgentVos = this.baseMapper.getAgentListInPage(page, agentDto);
+ List<AdminAgentVo> records = adminAgentVos.getRecords();
+ if(CollUtil.isNotEmpty(records)){
+ for(AdminAgentVo adminAgentVo : records){
+ String inviteId = adminAgentVo.getInviteId();
+ //直接下级
+ List<MallMember> mallMembers = mallMemberMapper.selectChildAgentListByInviteId(inviteId);
+ adminAgentVo.setMemberNum(CollUtil.isEmpty(mallMembers) ? 0 : mallMembers.size());
+
+ //获取总数
+ List<MallMember> allMallMembers =mallMemberMapper.selectAllChildAgentListByInviteId(inviteId);
+ adminAgentVo.setAllMemberNum(CollUtil.isEmpty(allMallMembers) ? 0 : allMallMembers.size());
+ }
+ }
+ return adminAgentVos;
+ }
+
}
diff --git a/src/main/java/cc/mrbird/febs/mall/vo/AdminAgentVo.java b/src/main/java/cc/mrbird/febs/mall/vo/AdminAgentVo.java
new file mode 100644
index 0000000..d6b3b6d
--- /dev/null
+++ b/src/main/java/cc/mrbird/febs/mall/vo/AdminAgentVo.java
@@ -0,0 +1,38 @@
+package cc.mrbird.febs.mall.vo;
+
+import io.swagger.annotations.ApiModel;
+import lombok.Data;
+
+@Data
+@ApiModel(value = "AdminAgentVo", description = "信息返回类")
+public class AdminAgentVo {
+
+ private Long id;
+
+ private String name;
+
+ private String phone;
+
+ private String level;
+
+ /**
+ * 邀请码
+ */
+ private String inviteId;
+
+ /**
+ * 父级邀请码
+ */
+ private String referrerId;
+
+ /**
+ * 邀请码链
+ */
+ private String referrerIds;
+
+ //下级总代理人数
+ private Integer allMemberNum;
+ //发展下级代理人数
+ private Integer memberNum;
+
+}
diff --git a/src/main/resources/mapper/modules/MallMemberMapper.xml b/src/main/resources/mapper/modules/MallMemberMapper.xml
index 8a6fe9f..56d3ef5 100644
--- a/src/main/resources/mapper/modules/MallMemberMapper.xml
+++ b/src/main/resources/mapper/modules/MallMemberMapper.xml
@@ -113,4 +113,30 @@
</foreach >
order by id desc
</select>
+
+ <select id="getAgentListInPage" resultType="cc.mrbird.febs.mall.vo.AdminAgentVo">
+ SELECT * FROM mall_member m
+ <where>
+ <if test="record != null" >
+ <if test="record.name!=null and record.name!=''">
+ and m.name like concat('%', #{record.name},'%')
+ </if>
+ <if test="record.level!=null and record.level!=''">
+ and m.level = #{record.level}
+ </if>
+ <if test="record.account!=null and record.account!=''">
+ and m.phone like concat('%', #{record.account},'%')
+ </if>
+ </if>
+ </where>
+ order by m.CREATED_TIME desc
+ </select>
+
+ <select id="selectChildAgentListByInviteId" resultType="cc.mrbird.febs.mall.entity.MallMember">
+ select * from mall_member where referrer_id = #{inviteId}
+ </select>
+
+ <select id="selectAllChildAgentListByInviteId" resultType="cc.mrbird.febs.mall.entity.MallMember">
+ select * from mall_member where find_in_set(#{inviteId}, referrer_ids)
+ </select>
</mapper>
\ No newline at end of file
diff --git a/src/main/resources/templates/febs/views/modules/mallMember/agentList.html b/src/main/resources/templates/febs/views/modules/mallMember/agentList.html
new file mode 100644
index 0000000..ae29c2c
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/mallMember/agentList.html
@@ -0,0 +1,168 @@
+<div class="layui-fluid layui-anim febs-anim" id="febs-user-agent" 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="name" autocomplete="off" class="layui-input">
+ </div>
+ </div>
+ <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">
+ <select name="level">
+ <option value="">请选择</option>
+ <option value="FIRST_LEVEL">FIRST_LEVEL</option>
+ <option value="SECOND_LEVEL">SECOND_LEVEL</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="userAgentTable" lay-data="{id: 'userAgentTable'}"></table>
+ </div>
+ </div>
+ </div>
+ </div>
+</div>
+<!-- 表格操作栏 start -->
+<script type="text/html" id="user-option">
+ <span shiro:lacksPermission="user:view,user:update,user:delete">
+ <span class="layui-badge-dot febs-bg-orange"></span> 无权限
+ </span>
+ <a lay-event="edit" shiro:hasPermission="user:update"><i
+ class="layui-icon febs-edit-area febs-blue"></i></a>
+</script>
+<!-- 表格操作栏 end -->
+<script data-th-inline="none" type="text/javascript">
+ // 引入组件并初始化
+ layui.use([ 'jquery', 'form', 'table', 'febs'], function () {
+ var $ = layui.jquery,
+ febs = layui.febs,
+ form = layui.form,
+ table = layui.table,
+ $view = $('#febs-user-agent'),
+ $query = $view.find('#query'),
+ $reset = $view.find('#reset'),
+ $searchForm = $view.find('form'),
+ sortObject = {field: 'phone', type: null},
+ tableIns;
+
+ form.render();
+
+ // 表格初始化
+ initTable();
+
+ // 初始化表格操作栏各个按钮功能
+ table.on('tool(userAgentTable)', function (obj) {
+ var data = obj.data,
+ layEvent = obj.event;
+ // if (layEvent === 'close') {
+ // febs.modal.confirm('禁用', '确认禁用该账号？', function () {
+ // closeAccount(data.id);
+ // });
+ // }
+ // if (layEvent === 'open') {
+ // febs.modal.confirm('开启', '确认开启该账号？', function () {
+ // openAccount(data.id);
+ // });
+ // }
+ // if (layEvent === 'see') {
+ // febs.modal.open( '个人信息', 'modules/mallMember/detail/' + data.id, {
+ // 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 () {
+ // febs.alert.success('禁用成功');
+ // $query.click();
+ // });
+ // }
+ // function openAccount(id) {
+ // febs.get(ctx + 'admin/mallMember/openAccount/' + id, null, function () {
+ // febs.alert.success('开启成功');
+ // $query.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';
+ tableIns.reload({where: getQueryParams(), page: {curr: 1}, initSort: sortObject});
+ });
+
+ function initTable() {
+ tableIns = febs.table.init({
+ elem: $view.find('table'),
+ id: 'userAgentTable',
+ url: ctx + 'admin/mallMember/getAgentList',
+ cols: [[
+ {field: 'phone', title: '手机号', minWidth: 150,align:'left'},
+ {field: 'name', title: '名称', minWidth: 100,align:'left'},
+ {field: 'inviteId', title: '邀请码', minWidth: 100,align:'left'},
+ {field: 'level', title: '代理层级', minWidth: 100,align:'left'},
+ {field: 'memberNum', title: '下级', minWidth: 100,align:'left'},
+ {field: 'allMemberNum', title: '我的团队总数', minWidth: 100,align:'left'},
+ // {title: '操作',
+ // templet: function (d) {
+ // 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'}
+ ]]
+ });
+ }
+
+ // 获取查询参数
+ function getQueryParams() {
+ return {
+ name: $searchForm.find('input[name="name"]').val().trim(),
+ account: $searchForm.find('input[name="account"]').val().trim(),
+ level: $searchForm.find("select[name='level']").val(),
+ };
+ }
+
+ })
+</script>
\ No newline at end of file
--
Gitblit v1.9.1