20210926

xiaoyong931011

2021-09-26 93977b43fc8256761b7035b9d3d3e39c24451477

20210926

 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);
    }



}

 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");
    }





 src/main/java/cc/mrbird/febs/mall/dto/AgentDto.java

New file
@@ -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;
}

 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);
}

 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);
}

 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;
    }

}

 src/main/java/cc/mrbird/febs/mall/vo/AdminAgentVo.java

New file
@@ -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;

}

 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>

 src/main/resources/templates/febs/views/modules/mallMember/agentList.html

New file
@@ -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">&#xe848;</i>
                                </div>
                                <div class="layui-btn layui-btn-sm layui-btn-primary febs-button-green-plain table-action" id="reset">
                                    <i class="layui-icon">&#xe79b;</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">&#xe7a5;</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>