From 89ea0131d4b147a9df696e4408cd0209427ac839 Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Sun, 19 Jul 2020 19:11:13 +0800
Subject: [PATCH] 20200719 代码提交
---
src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java | 6 +
src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java | 2
src/main/resources/templates/febs/views/modules/member/memberAlone.html | 144 ++++++++++++++++++++++++++++++++++++
src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java | 2
src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java | 16 ++++
src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java | 6 +
src/main/resources/mapper/modules/MemberMapper.xml | 32 ++++++++
7 files changed, 208 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java b/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java
index 0183f64..053139d 100644
--- a/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java
+++ b/src/main/java/com/xcong/excoin/modules/member/controller/MemberController.java
@@ -65,6 +65,12 @@
return new FebsResponse().success().data(data);
}
+ @GetMapping("memberAlone")
+ public FebsResponse memberAlone(MemberEntity member, QueryRequest request) {
+ Map<String, Object> data = getDataTable(memberService.findMemberAloneInPage(member, request));
+ return new FebsResponse().success().data(data);
+ }
+
/**
* 实名认证---确认
* @return
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
index 6c47a0a..96a9556 100644
--- a/src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java
+++ b/src/main/java/com/xcong/excoin/modules/member/controller/ViewController.java
@@ -82,6 +82,12 @@
return FebsUtil.view("modules/member/member");
}
+ @GetMapping("memberAlone")
+ @RequiresPermissions("memberAlone:view")
+ public String memberAlone() {
+ return FebsUtil.view("modules/member/memberAlone");
+ }
+
@GetMapping("memberDetail/{id}")
@RequiresPermissions("member:update")
public String memberDetail(@PathVariable long id, Model model) {
diff --git a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java b/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java
index 9f69fe7..828933f 100644
--- a/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java
+++ b/src/main/java/com/xcong/excoin/modules/member/mapper/MemberMapper.java
@@ -88,5 +88,7 @@
String selectHYZCForBasicRealDataBymemberId(Long memberId);
String selectDLZCForBasicRealDataBymemberId(Long memberId);
+
+ IPage<MemberEntity> findMemberAloneInPage(Page<MemberEntity> page, @Param("record") MemberEntity member);
}
diff --git a/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java b/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java
index 862bea0..f783b72 100644
--- a/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java
+++ b/src/main/java/com/xcong/excoin/modules/member/service/IMemberService.java
@@ -72,4 +72,6 @@
IPage<MemberCoinWithdrawVo> findMemberWithdrawCoinAloneInPage(MemberCoinWithdrawEntity memberCoinWithdrawEntity, QueryRequest request);
+ IPage<MemberEntity> findMemberAloneInPage(MemberEntity member, QueryRequest request);
+
}
diff --git a/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java b/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java
index 8601a1f..7890ecc 100644
--- a/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java
+++ b/src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java
@@ -791,4 +791,20 @@
return findmemberQuickBuySaleListInPage;
}
+
+ @Override
+ public IPage<MemberEntity> findMemberAloneInPage(MemberEntity member, QueryRequest request) {
+ Page<MemberEntity> page = new Page<>(request.getPageNum(), request.getPageSize());
+ IPage<MemberEntity> selectMemberListInPage = this.baseMapper.findMemberAloneInPage(page, member);
+ List<MemberEntity> records = selectMemberListInPage.getRecords();
+ if(records != null && records.size() > 0) {
+ for(MemberEntity memberEntitys : records) {
+ String firstName = (memberEntitys.getFirstName() == null ? "" : memberEntitys.getFirstName());
+ String secondName = (memberEntitys.getSecondName() == null ? "" : memberEntitys.getSecondName());
+ memberEntitys.setRealName(firstName+secondName);
+ }
+ }
+ return selectMemberListInPage;
+ }
+
}
diff --git a/src/main/resources/mapper/modules/MemberMapper.xml b/src/main/resources/mapper/modules/MemberMapper.xml
index ae6ae7b..18cf367 100644
--- a/src/main/resources/mapper/modules/MemberMapper.xml
+++ b/src/main/resources/mapper/modules/MemberMapper.xml
@@ -33,6 +33,38 @@
order by m.create_time desc
</select>
+ <select id="findMemberAloneInPage" resultType="com.xcong.excoin.modules.member.entity.MemberEntity">
+ SELECT
+ *
+ FROM
+ member m
+ LEFT JOIN member_authentication a ON m.id = a.member_id
+ <where>
+ FIND_IN_SET('22015141', m.referer_ids)
+ <if test="record != null" >
+ <if test="record.startTime!=null">
+ and m.create_time >=#{record.startTime}
+ </if>
+ <if test="record.endTime!=null">
+ and #{record.endTime} >= m.create_time
+ </if>
+ <if test="record.account!=null and record.account!=''">
+ and (m.phone = #{record.account} or m.email = #{record.account} or m.invite_id=#{record.account})
+ </if>
+ <if test="record.accountStatus!=null">
+ and m.account_status = #{record.accountStatus}
+ </if>
+ <if test="record.accountType != null" >
+ and m.account_type = #{record.accountType}
+ </if>
+ <if test="record.certifyStatus != null and record.certifyStatus!=''">
+ and m.certify_status = #{record.certifyStatus}
+ </if>
+ </if>
+ </where>
+ order by m.create_time desc
+ </select>
+
<select id="findMemberAccountInfoListInPage" resultType="com.xcong.excoin.modules.trademanage.vo.MemberAccountInfoVo">
SELECT
m.id,
diff --git a/src/main/resources/templates/febs/views/modules/member/memberAlone.html b/src/main/resources/templates/febs/views/modules/member/memberAlone.html
new file mode 100644
index 0000000..2c2dee5
--- /dev/null
+++ b/src/main/resources/templates/febs/views/modules/member/memberAlone.html
@@ -0,0 +1,144 @@
+<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">
+ <select name="certifyStatus">
+ <option value="">请选择</option>
+ <option value="1">待审核</option>
+ <option value="2">审核通过</option>
+ <option value="3">未实名</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="userTable" lay-data="{id: 'userTable'}"></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(['dropdown', 'jquery', 'laydate', 'form', 'table', 'febs', 'treeSelect'], function () {
+ var $ = layui.jquery,
+ laydate = layui.laydate,
+ febs = layui.febs,
+ form = layui.form,
+ table = layui.table,
+ dropdown = layui.dropdown,
+ $view = $('#febs-user'),
+ $query = $view.find('#query'),
+ $reset = $view.find('#reset'),
+ $searchForm = $view.find('form'),
+ sortObject = {field: 'phone', type: null},
+ tableIns;
+
+ form.render();
+
+ // 表格初始化
+ initTable();
+
+ // 初始化表格操作栏各个按钮功能
+ table.on('tool(userTable)', function (obj) {
+ var data = obj.data,
+ layEvent = obj.event;
+
+ });
+
+
+ // 查询按钮
+ $query.on('click', function () {
+ var params = $.extend(getQueryParams(), {field: sortObject.field, order: sortObject.type});
+ tableIns.reload({where: params, page: {curr: 1}});
+ });
+
+ // 刷新按钮
+ $reset.on('click', function () {
+ $searchForm[0].reset();
+ sortObject.type = 'null';
+ tableIns.reload({where: getQueryParams(), page: {curr: 1}, initSort: sortObject});
+ });
+
+ function initTable() {
+ tableIns = febs.table.init({
+ elem: $view.find('table'),
+ id: 'userTable',
+ url: ctx + 'member/memberAlone',
+ cols: [[
+ {field: 'phone', title: '手机号', minWidth: 100,align:'left'},
+ {field: 'email', title: '邮箱', minWidth: 200,align:'left'},
+ {field: 'realName', title: '姓名', minWidth: 200,align:'left'},
+ {field: 'inviteId', title: '邀请码UID', minWidth: 80,align:'center'},
+ {field: 'refererId', title: '上级邀请码UID', minWidth: 80,align:'center'},
+ {field: 'refererId', title: '账号状态',
+ templet: function (d) {
+ if (d.accountStatus === 1) {
+ return '<span style="color:green;">正常</span>'
+ } else if (d.accountStatus === 0) {
+ return '<span style="color:red;">禁用</span>'
+ }else{
+ return ''
+ }
+ }, minWidth: 80,align:'center'},
+ {field: 'refererId', title: '审核状态',
+ templet: function (d) {
+ if (d.certifyStatus === 0) {
+ return '<span style="color:red;">未通过</span>'
+ } else if (d.certifyStatus === 1) {
+ return '<span style="color:blue;">待审核</span>'
+ } else if (d.certifyStatus === 2) {
+ return '<span style="color:green;">审核通过</span>'
+ } else if (d.certifyStatus === 3) {
+ return '<span>未实名</span>'
+ }else{
+ return ''
+ }
+ }, minWidth: 80,align:'center'},
+ {field: 'createTime', title: '注册时间', minWidth: 180,align:'center'}
+ ]]
+ });
+ }
+
+ // 获取查询参数
+ function getQueryParams() {
+ return {
+ account: $searchForm.find('input[name="account"]').val().trim(),
+ certifyStatus: $searchForm.find("select[name='certifyStatus']").val(),
+ };
+ }
+
+ })
+</script>
\ No newline at end of file
--
Gitblit v1.9.1