From 725449edce99acdb3111f36d4b722eebbd22d41a Mon Sep 17 00:00:00 2001
From: Helius <wangdoubleone@gmail.com>
Date: Thu, 11 Jun 2020 20:14:50 +0800
Subject: [PATCH] finish add agent view

---
 src/main/resources/templates/febs/views/modules/agent/agent.html                   |  312 ++++++++++++++++++++
 src/main/java/com/xcong/excoin/modules/agent/entity/MemberEntity.java              |    2 
 src/main/java/com/xcong/excoin/system/mapper/UserMapper.java                       |   13 
 src/main/java/com/xcong/excoin/modules/agent/service/IAgentService.java            |   16 +
 src/main/java/com/xcong/excoin/modules/agent/controller/ViewController.java        |   36 ++
 src/main/resources/mapper/modules/AgentFriendRelationMapper.xml                    |    5 
 src/main/java/com/xcong/excoin/modules/agent/mapper/AgentFriendRelationMapper.java |   11 
 src/main/java/com/xcong/excoin/system/entity/User.java                             |   12 
 src/main/resources/static/febs/lay/modules/febs.js                                 |    3 
 src/main/java/com/xcong/excoin/modules/agent/mapper/MemberMapper.java              |    6 
 src/main/java/com/xcong/excoin/modules/agent/service/impl/AgentServiceImpl.java    |   89 +++++
 src/main/resources/mapper/modules/MemberMapper.xml                                 |   10 
 src/main/resources/templates/febs/views/modules/agent/agentAdd.html                |   77 +++++
 src/main/java/com/xcong/excoin/modules/agent/controller/MemberController.java      |    6 
 src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java                   |   92 ++++++
 /dev/null                                                                          |   23 -
 src/main/resources/static/febs/lay/modules/validate.js                             |    8 
 src/main/java/com/xcong/excoin/modules/agent/service/impl/MemberServiceImpl.java   |   10 
 src/main/java/com/xcong/excoin/modules/agent/entity/AgentFriendRelationEntity.java |   64 ++++
 src/main/resources/mapper/system/UserMapper.xml                                    |   34 ++
 src/main/java/com/xcong/excoin/modules/agent/service/IMemberService.java           |    4 
 src/main/resources/templates/febs/views/modules/agent/member.html                  |    0 
 src/main/java/com/xcong/excoin/common/entity/FebsConstant.java                     |    8 
 src/main/java/com/xcong/excoin/modules/agent/controller/AgentController.java       |   48 +++
 24 files changed, 849 insertions(+), 40 deletions(-)

diff --git a/src/main/java/com/xcong/excoin/common/entity/FebsConstant.java b/src/main/java/com/xcong/excoin/common/entity/FebsConstant.java
index bdcdc91..ad0edd1 100644
--- a/src/main/java/com/xcong/excoin/common/entity/FebsConstant.java
+++ b/src/main/java/com/xcong/excoin/common/entity/FebsConstant.java
@@ -51,4 +51,12 @@
      * Windows 操作系统
      */
     String SYSTEM_WINDOWS = "windows";
+
+    String USER_TYPE_ADMIN = "admin";
+
+    String USER_TYPE_AGENT = "agent";
+
+    String SYSTEM_AGENT = "agent";
+
+    String DEFAULT_REFERER_ID = "rxadr3";
 }
diff --git a/src/main/java/com/xcong/excoin/modules/agent/controller/AgentController.java b/src/main/java/com/xcong/excoin/modules/agent/controller/AgentController.java
new file mode 100644
index 0000000..ddeacb2
--- /dev/null
+++ b/src/main/java/com/xcong/excoin/modules/agent/controller/AgentController.java
@@ -0,0 +1,48 @@
+package com.xcong.excoin.modules.agent.controller;
+
+import com.xcong.excoin.common.controller.BaseController;
+import com.xcong.excoin.common.entity.FebsResponse;
+import com.xcong.excoin.common.entity.QueryRequest;
+import com.xcong.excoin.modules.agent.pojo.AgentUser;
+import com.xcong.excoin.modules.agent.service.IAgentService;
+import com.xcong.excoin.system.entity.User;
+import lombok.RequiredArgsConstructor;
+import lombok.extern.slf4j.Slf4j;
+import org.apache.shiro.authz.annotation.RequiresPermissions;
+import org.springframework.validation.annotation.Validated;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+import javax.validation.Valid;
+import java.util.Map;
+
+/**
+ * @author wzy
+ * @date 2020-06-11
+ **/
+@Slf4j
+@Validated
+@RestController
+@RequiredArgsConstructor
+@RequestMapping("/agent")
+public class AgentController extends BaseController {
+
+    private final IAgentService agentService;
+
+    @GetMapping("getList")
+    @RequiresPermissions("agent:view")
+    public FebsResponse getList(AgentUser agentUser, QueryRequest queryRequest) {
+        Map<String, Object> map = getDataTable(agentService.findAgentList(agentUser, queryRequest));
+        return new FebsResponse().success().data(map);
+    }
+
+    @PostMapping("add")
+    @RequiresPermissions("agent:add")
+    public FebsResponse add(@Valid AgentUser agentUser) {
+        User user = getCurrentUser();
+        agentService.addAgent(agentUser, user);
+        return new FebsResponse().success();
+    }
+}
diff --git a/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java b/src/main/java/com/xcong/excoin/modules/agent/controller/MemberController.java
similarity index 85%
rename from src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java
rename to src/main/java/com/xcong/excoin/modules/agent/controller/MemberController.java
index d0002ee..70a3d5f 100644
--- a/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java
+++ b/src/main/java/com/xcong/excoin/modules/agent/controller/MemberController.java
@@ -1,10 +1,10 @@
-package com.xcong.excoin.modules.member.controller;
+package com.xcong.excoin.modules.agent.controller;
 
 import com.xcong.excoin.common.controller.BaseController;
 import com.xcong.excoin.common.entity.FebsResponse;
 import com.xcong.excoin.common.entity.QueryRequest;
-import com.xcong.excoin.modules.member.entity.MemberEntity;
-import com.xcong.excoin.modules.member.service.IMemberService;
+import com.xcong.excoin.modules.agent.entity.MemberEntity;
+import com.xcong.excoin.modules.agent.service.IMemberService;
 import lombok.RequiredArgsConstructor;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.validation.annotation.Validated;
diff --git a/src/main/java/com/xcong/excoin/modules/agent/controller/ViewController.java b/src/main/java/com/xcong/excoin/modules/agent/controller/ViewController.java
new file mode 100644
index 0000000..57a68ed
--- /dev/null
+++ b/src/main/java/com/xcong/excoin/modules/agent/controller/ViewController.java
@@ -0,0 +1,36 @@
+package com.xcong.excoin.modules.agent.controller;
+
+import com.xcong.excoin.common.entity.FebsConstant;
+import com.xcong.excoin.common.utils.FebsUtil;
+import org.apache.shiro.authz.annotation.RequiresPermissions;
+import org.springframework.stereotype.Controller;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+
+/**
+ * @author wzy
+ * @date 2020-06-10
+ **/
+@Controller("memberView")
+@RequestMapping(FebsConstant.VIEW_PREFIX + "/agent")
+public class ViewController {
+
+    @GetMapping("member")
+    @RequiresPermissions("amember:view")
+    public String member() {
+        return FebsUtil.view("modules/agent/member");
+    }
+
+
+    @GetMapping("agent")
+    @RequiresPermissions("agent:view")
+    public String agent() {
+        return FebsUtil.view("modules/agent/agent");
+    }
+
+    @GetMapping("agentAdd")
+    @RequiresPermissions("agent:add")
+    public String agentAdd() {
+        return FebsUtil.view("modules/agent/agentAdd");
+    }
+}
diff --git a/src/main/java/com/xcong/excoin/modules/agent/entity/AgentFriendRelationEntity.java b/src/main/java/com/xcong/excoin/modules/agent/entity/AgentFriendRelationEntity.java
new file mode 100644
index 0000000..b690032
--- /dev/null
+++ b/src/main/java/com/xcong/excoin/modules/agent/entity/AgentFriendRelationEntity.java
@@ -0,0 +1,64 @@
+package com.xcong.excoin.modules.agent.entity;
+
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.xcong.excoin.common.entity.BaseEntity;
+import lombok.Data;
+import lombok.extern.slf4j.Slf4j;
+
+import java.math.BigDecimal;
+
+/**
+ * @author wzy
+ * @date 2020-06-11
+ **/
+@Slf4j
+@Data
+@TableName("agent_friend_relation")
+public class AgentFriendRelationEntity extends BaseEntity {
+
+    /**
+     * 后台用户ID
+     */
+    private Long userId;
+
+    /**
+     * 会员ID
+     */
+    private Long memberId;
+
+    /**
+     * 邀请码
+     */
+    private String inviteId;
+
+    /**
+     * 上级代理用户ID
+     */
+    private Long refererMemberId;
+
+    /**
+     * 上级代理邀请码
+     */
+    private String refererId;
+
+    /**
+     * 上级邀请码链
+     */
+    private String refererIds;
+
+    /**
+     * 返佣比例
+     */
+    private BigDecimal returnRatio;
+
+    /**
+     * 代理层级
+     */
+    private Integer leverId;
+
+    /**
+     * 手续费是否设置自己
+     */
+    private Integer feeIsSelf;
+
+}
diff --git a/src/main/java/com/xcong/excoin/modules/member/entity/MemberEntity.java b/src/main/java/com/xcong/excoin/modules/agent/entity/MemberEntity.java
similarity index 98%
rename from src/main/java/com/xcong/excoin/modules/member/entity/MemberEntity.java
rename to src/main/java/com/xcong/excoin/modules/agent/entity/MemberEntity.java
index c259a34..0db13c1 100644
--- a/src/main/java/com/xcong/excoin/modules/member/entity/MemberEntity.java
+++ b/src/main/java/com/xcong/excoin/modules/agent/entity/MemberEntity.java
@@ -1,4 +1,4 @@
-package com.xcong.excoin.modules.member.entity;
+package com.xcong.excoin.modules.agent.entity;
 
 import com.baomidou.mybatisplus.annotation.TableField;
 import com.baomidou.mybatisplus.annotation.TableName;
diff --git a/src/main/java/com/xcong/excoin/modules/agent/mapper/AgentFriendRelationMapper.java b/src/main/java/com/xcong/excoin/modules/agent/mapper/AgentFriendRelationMapper.java
new file mode 100644
index 0000000..38b4369
--- /dev/null
+++ b/src/main/java/com/xcong/excoin/modules/agent/mapper/AgentFriendRelationMapper.java
@@ -0,0 +1,11 @@
+package com.xcong.excoin.modules.agent.mapper;
+
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.xcong.excoin.modules.agent.entity.AgentFriendRelationEntity;
+
+/**
+ * @author helius
+ */
+public interface AgentFriendRelationMapper extends BaseMapper<AgentFriendRelationEntity> {
+}
diff --git a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java b/src/main/java/com/xcong/excoin/modules/agent/mapper/MemberMapper.java
similarity index 65%
rename from src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java
rename to src/main/java/com/xcong/excoin/modules/agent/mapper/MemberMapper.java
index 788d97b..b433991 100644
--- a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java
+++ b/src/main/java/com/xcong/excoin/modules/agent/mapper/MemberMapper.java
@@ -1,9 +1,9 @@
-package com.xcong.excoin.modules.member.mapper;
+package com.xcong.excoin.modules.agent.mapper;
 
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
-import com.xcong.excoin.modules.member.entity.MemberEntity;
+import com.xcong.excoin.modules.agent.entity.MemberEntity;
 import org.apache.ibatis.annotations.Param;
 
 /**
@@ -13,4 +13,6 @@
 public interface MemberMapper extends BaseMapper<MemberEntity> {
 
     IPage<MemberEntity> selectMemberListInPage(Page<MemberEntity> page, @Param("record") MemberEntity memberEntity);
+
+    MemberEntity selectMemberByInviteIdAndRefererId(@Param("inviteId") String inviteId, @Param("refererId") String refererId);
 }
diff --git a/src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java b/src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java
new file mode 100644
index 0000000..cc6d289
--- /dev/null
+++ b/src/main/java/com/xcong/excoin/modules/agent/pojo/AgentUser.java
@@ -0,0 +1,92 @@
+package com.xcong.excoin.modules.agent.pojo;
+
+import lombok.Data;
+
+import javax.validation.constraints.NotBlank;
+import javax.validation.constraints.NotNull;
+import java.math.BigDecimal;
+import java.util.Date;
+
+/**
+ * @author wzy
+ * @date 2020-06-11
+ **/
+@Data
+public class AgentUser {
+
+    /**
+     * 后台用户主键ID
+     */
+    private Long id;
+
+    /**
+     * 代理姓名
+     */
+    @NotBlank(message = "代理姓名不能为空")
+    private String name;
+
+    /**
+     * 代理账号
+     */
+    @NotBlank(message = "代理账号不能为空")
+    private String account;
+
+    /**
+     * 邀请码
+     */
+    @NotBlank(message = "邀请码不能为空")
+    private String inviteId;
+
+    /**
+     * 手机号
+     */
+    @NotBlank(message = "手机号不能为空")
+    private String telphone;
+
+    /**
+     * 邮箱
+     */
+    private String email;
+
+    /**
+     * 上级邀请码
+     */
+    private String referId;
+
+    /**
+     * 发展代理数
+     */
+    private Integer childCnt;
+
+    /**
+     * 充值总数
+     */
+    private BigDecimal chargeTotal;
+
+    /**
+     * 提现总数
+     */
+    private BigDecimal cashOutTotal;
+
+    /**
+     * 佣金返现
+     */
+    private BigDecimal returnTotal;
+
+    /**
+     * 返佣比例
+     */
+    @NotNull(message = "返佣比例不能为空")
+    private BigDecimal returnRatio;
+
+    /**
+     * 状态
+     */
+    private Integer status;
+
+    /**
+     * 创建时间
+     */
+    private Date createTime;
+
+}
diff --git a/src/main/java/com/xcong/excoin/modules/agent/service/IAgentService.java b/src/main/java/com/xcong/excoin/modules/agent/service/IAgentService.java
new file mode 100644
index 0000000..330391d
--- /dev/null
+++ b/src/main/java/com/xcong/excoin/modules/agent/service/IAgentService.java
@@ -0,0 +1,16 @@
+package com.xcong.excoin.modules.agent.service;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.xcong.excoin.common.entity.QueryRequest;
+import com.xcong.excoin.modules.agent.pojo.AgentUser;
+import com.xcong.excoin.system.entity.User;
+
+/**
+ * @author helius
+ */
+public interface IAgentService {
+
+    IPage<AgentUser> findAgentList(AgentUser agentUser, QueryRequest request);
+
+    void addAgent(AgentUser agentUser, User user);
+}
diff --git a/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java b/src/main/java/com/xcong/excoin/modules/agent/service/IMemberService.java
similarity index 76%
rename from src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java
rename to src/main/java/com/xcong/excoin/modules/agent/service/IMemberService.java
index 4b0a602..820e9af 100644
--- a/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java
+++ b/src/main/java/com/xcong/excoin/modules/agent/service/IMemberService.java
@@ -1,9 +1,9 @@
-package com.xcong.excoin.modules.member.service;
+package com.xcong.excoin.modules.agent.service;
 
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.xcong.excoin.common.entity.QueryRequest;
-import com.xcong.excoin.modules.member.entity.MemberEntity;
+import com.xcong.excoin.modules.agent.entity.MemberEntity;
 
 /**
  * @author helius
diff --git a/src/main/java/com/xcong/excoin/modules/agent/service/impl/AgentServiceImpl.java b/src/main/java/com/xcong/excoin/modules/agent/service/impl/AgentServiceImpl.java
new file mode 100644
index 0000000..c54e672
--- /dev/null
+++ b/src/main/java/com/xcong/excoin/modules/agent/service/impl/AgentServiceImpl.java
@@ -0,0 +1,89 @@
+package com.xcong.excoin.modules.agent.service.impl;
+
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.xcong.excoin.common.entity.FebsConstant;
+import com.xcong.excoin.common.entity.QueryRequest;
+import com.xcong.excoin.common.exception.FebsException;
+import com.xcong.excoin.common.utils.Md5Util;
+import com.xcong.excoin.modules.agent.entity.AgentFriendRelationEntity;
+import com.xcong.excoin.modules.agent.entity.MemberEntity;
+import com.xcong.excoin.modules.agent.mapper.AgentFriendRelationMapper;
+import com.xcong.excoin.modules.agent.mapper.MemberMapper;
+import com.xcong.excoin.modules.agent.pojo.AgentUser;
+import com.xcong.excoin.modules.agent.service.IAgentService;
+import com.xcong.excoin.system.entity.User;
+import com.xcong.excoin.system.mapper.UserMapper;
+import lombok.RequiredArgsConstructor;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.stereotype.Service;
+
+import java.util.Date;
+
+/**
+ * @author wzy
+ * @date 2020-06-11
+ **/
+@Slf4j
+@RequiredArgsConstructor
+@Service
+public class AgentServiceImpl implements IAgentService {
+
+    private final UserMapper userMapper;
+
+    private final MemberMapper memberMapper;
+
+    private final AgentFriendRelationMapper agentFriendRelationMapper;
+
+    @Override
+    public IPage<AgentUser> findAgentList(AgentUser agentUser, QueryRequest request) {
+        Page<AgentUser> page = new Page<>(request.getPageNum(), request.getPageSize());
+        return userMapper.selectAgentUserList(page, agentUser);
+    }
+
+    @Override
+    public void addAgent(AgentUser agentUser, User user) {
+        AgentFriendRelationEntity agentFriendRelation = new AgentFriendRelationEntity();
+        String refererId = "";
+        if (FebsConstant.USER_TYPE_ADMIN.equals(user.getType())) {
+            refererId = FebsConstant.DEFAULT_REFERER_ID;
+        } else {
+            refererId = user.getInviteId();
+        }
+        MemberEntity memberEntity = memberMapper.selectMemberByInviteIdAndRefererId(agentUser.getInviteId(), refererId);
+        if (memberEntity == null) {
+            throw new FebsException("UID不存在或不是本用户下级代理");
+        }
+
+        User exsit = userMapper.selectUserByInviteId(agentUser.getInviteId());
+        if (exsit != null) {
+            throw new FebsException("该用户已存在");
+        }
+
+        User addUser = new User();
+        addUser.setUsername(agentUser.getAccount());
+        addUser.setStatus(User.STATUS_VALID);
+        addUser.setAvatar(User.DEFAULT_AVATAR);
+        addUser.setTheme(User.THEME_WHITE);
+        addUser.setIsTab(User.TAB_OPEN);
+        addUser.setType(FebsConstant.USER_TYPE_AGENT);
+        addUser.setSystem(FebsConstant.SYSTEM_AGENT);
+        addUser.setCreateTime(new Date());
+        addUser.setInviteId(agentUser.getInviteId());
+        addUser.setAgentName(agentUser.getName());
+        addUser.setPassword(Md5Util.encrypt(user.getUsername(), User.DEFAULT_PASSWORD));
+        userMapper.insert(user);
+
+        agentFriendRelation.setInviteId(agentUser.getInviteId());
+        agentFriendRelation.setRefererId(refererId);
+        agentFriendRelation.setRefererIds(memberEntity.getRefererIds());
+        agentFriendRelation.setMemberId(memberEntity.getId());
+        agentFriendRelation.setReturnRatio(agentUser.getReturnRatio());
+        agentFriendRelation.setUserId(user.getUserId());
+        agentFriendRelation.setCreateBy(user.getUsername());
+        agentFriendRelation.setCreateTime(new Date());
+        agentFriendRelation.setUpdateBy(user.getUsername());
+        agentFriendRelation.setUpdateTime(new Date());
+        agentFriendRelationMapper.insert(agentFriendRelation);
+    }
+}
diff --git a/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java b/src/main/java/com/xcong/excoin/modules/agent/service/impl/MemberServiceImpl.java
similarity index 74%
rename from src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java
rename to src/main/java/com/xcong/excoin/modules/agent/service/impl/MemberServiceImpl.java
index 332c400..a9de188 100644
--- a/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java
+++ b/src/main/java/com/xcong/excoin/modules/agent/service/impl/MemberServiceImpl.java
@@ -1,15 +1,13 @@
-package com.xcong.excoin.modules.member.service.impl;
+package com.xcong.excoin.modules.agent.service.impl;
 
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.xcong.excoin.common.entity.QueryRequest;
-import com.xcong.excoin.modules.member.entity.MemberEntity;
-import com.xcong.excoin.modules.member.mapper.MemberMapper;
-import com.xcong.excoin.modules.member.service.IMemberService;
+import com.xcong.excoin.modules.agent.entity.MemberEntity;
+import com.xcong.excoin.modules.agent.mapper.MemberMapper;
+import com.xcong.excoin.modules.agent.service.IMemberService;
 import org.springframework.stereotype.Service;
-
-import java.util.Map;
 
 /**
  * @author wzy
diff --git a/src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java b/src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java
deleted file mode 100644
index c7e9b55..0000000
--- a/src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java
+++ /dev/null
@@ -1,23 +0,0 @@
-package com.xcong.excoin.modules.member.controller;
-
-import com.xcong.excoin.common.entity.FebsConstant;
-import com.xcong.excoin.common.utils.FebsUtil;
-import org.apache.shiro.authz.annotation.RequiresPermissions;
-import org.springframework.stereotype.Controller;
-import org.springframework.web.bind.annotation.GetMapping;
-import org.springframework.web.bind.annotation.RequestMapping;
-
-/**
- * @author wzy
- * @date 2020-06-10
- **/
-@Controller("memberView")
-@RequestMapping(FebsConstant.VIEW_PREFIX + "modules/member")
-public class ViewController {
-
-    @GetMapping("member")
-    @RequiresPermissions("member:view")
-    public String member() {
-        return FebsUtil.view("modules/member/member");
-    }
-}
diff --git a/src/main/java/com/xcong/excoin/system/entity/User.java b/src/main/java/com/xcong/excoin/system/entity/User.java
index e612617..c68b9ec 100644
--- a/src/main/java/com/xcong/excoin/system/entity/User.java
+++ b/src/main/java/com/xcong/excoin/system/entity/User.java
@@ -183,6 +183,18 @@
     @ExcelField(value = "个人描述")
     private String description;
 
+    @TableField("SYSTEM")
+    private String system;
+
+    @TableField("TYPE")
+    private String type;
+
+    @TableField("INVITE_ID")
+    private String inviteId;
+
+    @TableField("AGENT_NAME")
+    private String agentName;
+
     /**
      * 部门名称
      */
diff --git a/src/main/java/com/xcong/excoin/system/mapper/UserMapper.java b/src/main/java/com/xcong/excoin/system/mapper/UserMapper.java
index 71c75b4..0fb90e2 100644
--- a/src/main/java/com/xcong/excoin/system/mapper/UserMapper.java
+++ b/src/main/java/com/xcong/excoin/system/mapper/UserMapper.java
@@ -1,5 +1,6 @@
 package com.xcong.excoin.system.mapper;
 
+import com.xcong.excoin.modules.agent.pojo.AgentUser;
 import com.xcong.excoin.system.entity.User;
 import com.baomidou.mybatisplus.core.mapper.BaseMapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
@@ -40,4 +41,16 @@
      */
     List<User> findUserDetail(@Param("user") User user);
 
+    /**
+     * 获取代理商列表
+     *
+     * @param page
+     * @param agentUser
+     * @param <T>
+     * @return
+     */
+    IPage<AgentUser> selectAgentUserList(Page<AgentUser> page,@Param("record") AgentUser agentUser);
+
+    User selectUserByInviteId(@Param("inviteId") String inviteId);
+
 }
diff --git a/src/main/resources/mapper/modules/AgentFriendRelationMapper.xml b/src/main/resources/mapper/modules/AgentFriendRelationMapper.xml
new file mode 100644
index 0000000..a86b18c
--- /dev/null
+++ b/src/main/resources/mapper/modules/AgentFriendRelationMapper.xml
@@ -0,0 +1,5 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.xcong.excoin.modules.agent.mapper.AgentFriendRelationMapper">
+
+</mapper>
\ No newline at end of file
diff --git a/src/main/resources/mapper/modules/MemberMapper.xml b/src/main/resources/mapper/modules/MemberMapper.xml
index 380a747..99a3e52 100644
--- a/src/main/resources/mapper/modules/MemberMapper.xml
+++ b/src/main/resources/mapper/modules/MemberMapper.xml
@@ -1,9 +1,9 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.xcong.excoin.modules.member.mapper.MemberMapper">
+<mapper namespace="com.xcong.excoin.modules.agent.mapper.MemberMapper">
 
 
-    <select id="selectMemberListInPage" resultType="com.xcong.excoin.modules.member.entity.MemberEntity">
+    <select id="selectMemberListInPage" resultType="com.xcong.excoin.modules.agent.entity.MemberEntity">
         select * from member
         <where>
             <if test="record != null" >
@@ -30,4 +30,10 @@
         order by create_time desc
     </select>
 
+
+    <select id="selectMemberByInviteIdAndRefererId" resultType="com.xcong.excoin.modules.agent.entity.MemberEntity">
+        select * from member
+        where invite_id=#{inviteId} and referer_id=#{refererId}
+    </select>
+
 </mapper>
\ No newline at end of file
diff --git a/src/main/resources/mapper/system/UserMapper.xml b/src/main/resources/mapper/system/UserMapper.xml
index b7838c0..363a17d 100644
--- a/src/main/resources/mapper/system/UserMapper.xml
+++ b/src/main/resources/mapper/system/UserMapper.xml
@@ -44,6 +44,10 @@
         u.modify_time modifyTime,
         u.description,
         u.avatar,
+        u.invite_id,
+        u.system,
+        u.type,
+        u.agent_name,
         d.dept_name deptName,
         GROUP_CONCAT(r.role_id) roleId,
         GROUP_CONCAT(r.ROLE_NAME) roleName
@@ -86,7 +90,11 @@
             u.last_login_time,
             u.modify_time,
             u.description,
-            u.avatar
+            u.avatar,
+            u.invite_id,
+            u.system,
+            u.type,
+            u.agent_name,
     </sql>
 
     <select id="countUserDetail" parameterType="user" resultType="long">
@@ -116,6 +124,10 @@
         u.modify_time modifyTime,
         u.description,
         u.avatar,
+        u.invite_id,
+        u.system,
+        u.type,
+        u.agent_name,
         u.theme,
         u.is_tab isTab,
         d.dept_name deptName,
@@ -141,6 +153,10 @@
             u.modify_time,
             u.description,
             u.avatar,
+            u.invite_id,
+            u.system,
+            u.type,
+            u.agent_name,
             u.theme,
             u.is_tab
     </select>
@@ -149,4 +165,20 @@
         select user_id userId, dept_id deptId from t_user_data_permission
         where user_id = #{userId}
     </select>
+
+    <select id="selectAgentUserList" resultType="com.xcong.excoin.modules.agent.pojo.AgentUser">
+        select *
+        from t_user a
+        inner join agent_friend_relation b on a.user_id = b.user_id
+        inner join member c on b.member_id = c.id
+        <if test="record != null">
+            <where>
+
+            </where>
+        </if>
+    </select>
+
+    <select id="selectUserByInviteId" resultType="user">
+        select * from t_user where invite_id=#{inviteId}
+    </select>
 </mapper>
diff --git a/src/main/resources/static/febs/lay/modules/febs.js b/src/main/resources/static/febs/lay/modules/febs.js
index bbac870..9aaee98 100644
--- a/src/main/resources/static/febs/lay/modules/febs.js
+++ b/src/main/resources/static/febs/lay/modules/febs.js
@@ -540,6 +540,9 @@
                     "count": res.data.total,
                     "data": res.data.rows
                 }
+            },
+            done: function(res, curr, count) {
+                count || this.elem.next('.layui-table-view').find('.layui-table-header').css('overflow', 'auto');
             }
         };
         return layuiTable.render(
diff --git a/src/main/resources/static/febs/lay/modules/validate.js b/src/main/resources/static/febs/lay/modules/validate.js
index 452e8a5..c86ad1e 100644
--- a/src/main/resources/static/febs/lay/modules/validate.js
+++ b/src/main/resources/static/febs/lay/modules/validate.js
@@ -78,6 +78,14 @@
                     return '长度范围 ' + minlength + ' ~ ' + maxlength + ' 个字符';
                 }
             }
+        },
+        slot: function (value) {
+            if (!isEmpty(value)) {
+                console.log(new RegExp("^0\\.\\d{2}$").test(value))
+                if (!new RegExp("^0\\.\\d{2}$").test(value)) {
+                    return '保留两位小数';
+                }
+            }
         }
     });
 
diff --git a/src/main/resources/templates/febs/views/modules/agent/agent.html b/src/main/resources/templates/febs/views/modules/agent/agent.html
new file mode 100644
index 0000000..db21149
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/agent/agent.html
@@ -0,0 +1,312 @@
+<div class="layui-fluid layui-anim febs-anim" id="febs-user" 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="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">
+                                            <input type="text" name="createTime" id="user-createTime" 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="accountType">
+                                                <option value=""></option>
+                                                <option value="1">测试账号</option>
+                                                <option value="2">正常账号</option>
+                                            </select>
+                                        </div>
+                                    </div>
+                                    <div class="layui-inline">
+                                        <label class="layui-form-label layui-form-label-sm">账号状态</label>
+                                        <div class="layui-input-inline">
+                                            <select name="accountStatus">
+                                                <option value=""></option>
+                                                <option value="0">禁用</option>
+                                                <option value="1">正常</option>
+                                            </select>
+                                        </div>
+                                    </div>
+                                    <div class="layui-inline">
+                                        <label class="layui-form-label layui-form-label-sm">实名状态</label>
+                                        <div class="layui-input-inline">
+                                            <select name="certifyStatus">
+                                                <option value=""></option>
+                                                <option value="0">未通过</option>
+                                                <option value="1">审核中</option>
+                                                <option value="2">审核通过</option>
+                                                <option value="2">未实名</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 class="layui-btn layui-btn-sm layui-btn-primary table-action action-more"
+                                     shiro:hasAnyPermissions="user:add,user:update,user:password:reset,user:export">
+                                    <i class="layui-icon">&#xe875;</i>
+                                </div>
+                            </div>
+                        </div>
+                    </form>
+                    <table lay-filter="userTable" lay-data="{id: 'userTable'}"></table>
+                </div>
+            </div>
+        </div>
+    </div>
+</div>
+<!-- 表格字段状态格式化 start -->
+<script type="text/html" id="certify-status">
+    {{#
+    var certifyStatus = {
+    0: {title: '未通过', color: 'red'},
+    1: {title: '审核中', color: 'blue'},
+    2: {title: '审核通过', color: 'green'},
+    3: {title: '未实名', color: 'cyan'}
+    }[d.certifyStatus];
+    }}
+    <span class="layui-badge febs-tag-{{certifyStatus.color}}">{{ certifyStatus.title }}</span>
+</script>
+<script type="text/html" id="account-status">
+    {{#
+    var accountStatus = {
+    1: {title: '正常', color : 'blue'},
+    0: {title: '禁用', color : 'red'}
+    }[d.status];
+    }}
+    <span class="layui-badge febs-bg-{{accountStatus.color}}">{{ accountStatus.title }}</span>
+</script>
+<!-- 表格字段状态格式化 start -->
+
+<!-- 表格操作栏 start -->
+<script type="text/html" id="user-option">
+    <span shiro:lacksPermission="agent:view,agent:edit,agent:del">
+        <span class="layui-badge-dot febs-bg-orange"></span> 无权限
+    </span>
+    <a lay-event="detail" shiro:hasPermission="agent:view"><i
+            class="layui-icon febs-edit-area febs-green">&#xe7a5;</i></a>
+    <a lay-event="edit" shiro:hasPermission="agent:edit"><i
+            class="layui-icon febs-edit-area febs-blue">&#xe7a4;</i></a>
+    <a lay-event="del" shiro:hasPermission="agent:del"><i class="layui-icon febs-edit-area febs-red">&#xe7f9;</i></a>
+</script>
+<!-- 表格操作栏 end -->
+<script data-th-inline="none" type="text/javascript">
+    // 引入组件并初始化
+    layui.use(['dropdown', 'jquery', 'laydate', 'form', 'table', 'febs', 'treeSelect'], function () {
+        var $ = layui.jquery,
+            laydate = layui.laydate,
+            febs = layui.febs,
+            form = layui.form,
+            table = layui.table,
+            treeSelect = layui.treeSelect,
+            dropdown = layui.dropdown,
+            $view = $('#febs-user'),
+            $query = $view.find('#query'),
+            $reset = $view.find('#reset'),
+            $searchForm = $view.find('form'),
+            sortObject = {field: 'createTime', type: null},
+            tableIns,
+            createTimeFrom,
+            createTimeTo;
+
+        form.render();
+
+        // 表格初始化
+        initTable();
+
+        // 时间组件
+        laydate.render({
+            elem: '#user-createTime',
+            range: true,
+            trigger: 'click'
+        });
+
+        // 新增下拉组件
+        dropdown.render({
+            elem: $view.find('.action-more'),
+            click: function (name, elem, event) {
+                var checkStatus = table.checkStatus('userTable');
+                if (name === 'add') {
+                    febs.modal.open('新增用户', 'agent/agentAdd', {
+                        btn: ['提交', '重置'],
+                        area: $(window).width() <= 750 ? '95%' : '50%',
+                        offset: '30px',
+                        yes: function (index, layero) {
+                            $('#user-add').find('#submit').trigger('click');
+                        },
+                        btn2: function () {
+                            $('#user-add').find('#reset').trigger('click');
+                            return false;
+                        }
+                    });
+                }
+                if (name === 'delete') {
+                    if (!checkStatus.data.length) {
+                        febs.alert.warn('请选择需要删除的用户');
+                    } else {
+                        febs.modal.confirm('删除用户', '确定删除该用户?', function () {
+                            var userIds = [];
+                            layui.each(checkStatus.data, function (key, item) {
+                                userIds.push(item.userId)
+                            });
+                            deleteUsers(userIds.join(','));
+                        });
+                    }
+                }
+                if (name === 'reset') {
+                    if (!checkStatus.data.length) {
+                        febs.alert.warn('请选择需要重置密码的用户');
+                    } else {
+                        var usernames = [];
+                        layui.each(checkStatus.data, function (key, item) {
+                            usernames.push(item.username)
+                        });
+                        febs.post(ctx + 'user/password/reset/' + usernames.join(','), null, function () {
+                            febs.alert.success('所选用户密码已重置为1234qwer');
+                        });
+                    }
+                }
+            },
+            options: [{
+                name: 'add',
+                title: '新增代理商',
+                perms: 'agent:add'
+            }, {
+                name: 'delete',
+                title: '删除代理商',
+                perms: 'agent:del'
+            }, {
+                name: 'reset',
+                title: '密码重置',
+                perms: 'agent:password:reset'
+            }]
+        });
+
+        // 下拉框选择器
+        treeSelect.render({
+            elem: $view.find('#dept'),
+            type: 'get',
+            data: ctx + 'dept/select/tree',
+            placeholder: '请选择',
+            search: false
+        });
+
+        // 初始化表格操作栏各个按钮功能
+        table.on('tool(userTable)', function (obj) {
+            var data = obj.data,
+                layEvent = obj.event;
+            if (layEvent === 'detail') {
+                febs.modal.view('用户信息', 'system/user/detail/' + data.username, {
+                    area: $(window).width() <= 750 ? '95%' : '660px'
+                });
+            }
+            if (layEvent === 'del') {
+                febs.modal.confirm('删除用户', '确定删除该用户?', function () {
+                    deleteUsers(data.userId);
+                });
+            }
+            if (layEvent === 'edit') {
+                febs.modal.open('修改用户', 'system/user/update/' + data.username, {
+                    area: $(window).width() <= 750 ? '90%' : '50%',
+                    offset: '30px',
+                    btn: ['提交', '取消'],
+                    yes: function (index, layero) {
+                        $('#user-update').find('#submit').trigger('click');
+                    },
+                    btn2: function () {
+                        layer.closeAll();
+                    }
+                });
+            }
+        });
+
+        // 查询按钮
+        $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();
+            treeSelect.revokeNode('dept');
+            sortObject.type = 'null';
+            createTimeTo = null;
+            createTimeFrom = null;
+            tableIns.reload({where: getQueryParams(), page: {curr: 1}, initSort: sortObject});
+        });
+
+        function initTable() {
+            tableIns = febs.table.init({
+                elem: $view.find('table'),
+                id: 'userTable',
+                url: ctx + 'agent/getList',
+                cols: [[
+                    {type: 'checkbox'},
+                    {field: 'name', title: '代理姓名', minWidth: 100, align: 'center'},
+                    {field: 'account', title: '代理账号', minWidth: 100, align: 'center'},
+                    {field: 'inviteId', title: '代理UID', minWidth: 100, align: 'center'},
+                    {field: 'phone', title: '手机号', minWidth: 100, align: 'center'},
+                    {field: 'email', title: '邮箱', minWidth: 100, align: 'center'},
+                    {field: 'referId', title: '上级UID', minWidth: 100, align: 'center'},
+                    {title: '是否实名', templet: '#certify-status', minWidth: 100, align: 'center'},
+                    {field: 'childCnt', title: '发展代理数', minWidth: 100, align: 'center'},
+                    {field: 'chargeTotal', title: '充值总额', minWidth: 100, align: 'center'},
+                    {field: 'cashOutTotal', title: '提现总额', minWidth: 100, align: 'center'},
+                    {field: 'returnTotal', title: '佣金返现', minWidth: 100, align: 'center'},
+                    {field: 'returnRatio', title: '返佣比例', minWidth: 100, align: 'center'},
+                    {title: '状态', templet: '#account-status', align: 'center'},
+                    {field: 'createTime', title: '创建时间', minWidth: 140, align: 'center'},
+                    {title: '操作', toolbar: '#user-option', minWidth: 140, fixed : 'right', align: 'center'}
+                ]]
+            });
+        }
+
+        // 获取查询参数
+        function getQueryParams() {
+            var createTime = $searchForm.find('input[name="createTime"]').val();
+            if (createTime) {
+                createTimeFrom = createTime.split(' - ')[0];
+                createTimeTo = createTime.split(' - ')[1];
+            }
+            return {
+                startTime: createTimeFrom,
+                endTime: createTimeTo,
+                account: $searchForm.find('input[name="account"]').val().trim(),
+                accountStatus: $searchForm.find("select[name='accountStatus']").val(),
+                accountType: $searchForm.find("select[name='accountType']").val(),
+                certifyStatus: $searchForm.find("select[name='certifyStatus']").val(),
+                invalidate_ie_cache: new Date()
+            };
+        }
+
+        function deleteUsers(userIds) {
+            var currentUserId = currentUser.userId + '';
+            if (('' + userIds).split(',').indexOf(currentUserId) !== -1) {
+                febs.alert.warn('所选用户包含当前登录用户,无法删除');
+                return;
+            }
+            febs.get(ctx + 'user/delete/' + userIds, null, function () {
+                febs.alert.success('删除用户成功');
+                $query.click();
+            });
+        }
+    })
+</script>
\ No newline at end of file
diff --git a/src/main/resources/templates/febs/views/modules/agent/agentAdd.html b/src/main/resources/templates/febs/views/modules/agent/agentAdd.html
new file mode 100644
index 0000000..5b4f8ce
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/agent/agentAdd.html
@@ -0,0 +1,77 @@
+<style>
+    #user-add {
+        padding: 20px 25px 25px 0;
+    }
+    #user-add .layui-treeSelect .ztree li a, .ztree li span {
+        margin: 0 0 2px 3px !important;
+    }
+    #user-add #data-permission-tree-block {
+        border: 1px solid #eee;
+        border-radius: 2px;
+        padding: 3px 0;
+    }
+    #user-add .layui-treeSelect .ztree li span.button.switch {
+        top: 1px;
+        left: 3px;
+    }
+</style>
+<div class="layui-fluid" id="user-add">
+    <form class="layui-form" action="" lay-filter="user-add-form">
+        <div class="layui-form-item">
+            <label class="layui-form-label febs-form-item-require">用户名:</label>
+            <div class="layui-input-block">
+                <input type="text" name="account" lay-verify="required" autocomplete="off" class="layui-input">
+            </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="name" minlength="2" maxlength="25" lay-verify="range" autocomplete="off" class="layui-input">
+            </div>
+        </div>
+        <div class="layui-form-item">
+            <label class="layui-form-label febs-form-item-require">联系电话:</label>
+            <div class="layui-input-block">
+                <input type="tel" name="telphone" lay-verify="phone" autocomplete="off" class="layui-input">
+            </div>
+        </div>
+        <div class="layui-form-item">
+            <label class="layui-form-label febs-form-item-require">代理UID:</label>
+            <div class="layui-input-block">
+                <input type="text" name="inviteId" lay-verify="required" autocomplete="off" class="layui-input">
+            </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="returnRatio" lay-verify="slot" autocomplete="off" class="layui-input">
+            </div>
+        </div>
+        <div class="layui-form-item febs-hide">
+            <button class="layui-btn" lay-submit="" lay-filter="user-add-form-submit" id="submit"></button>
+            <button type="reset" class="layui-btn" id="reset"></button>
+        </div>
+    </form>
+</div>
+
+<script>
+    layui.use(['febs', 'form', 'validate'], function () {
+        var $ = layui.$,
+            febs = layui.febs,
+            layer = layui.layer,
+            form = layui.form,
+            validate = layui.validate;
+
+        form.verify(validate);
+        form.render();
+
+        form.on('submit(user-add-form-submit)', function (data) {
+            febs.post(ctx + 'agent/add', data.field, function () {
+                layer.closeAll();
+                febs.alert.success('新增用户成功,初始密码为 1234qwer');
+                $('#febs-user').find('#query').click();
+            });
+            return false;
+        });
+    });
+</script>
\ No newline at end of file
diff --git a/src/main/resources/templates/febs/views/modules/member/member.html b/src/main/resources/templates/febs/views/modules/agent/member.html
similarity index 100%
rename from src/main/resources/templates/febs/views/modules/member/member.html
rename to src/main/resources/templates/febs/views/modules/agent/member.html

--
Gitblit v1.9.1