From a719b1c8617fa37b22c55307d20796cda14e3c7d Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Thu, 16 Jul 2020 16:53:36 +0800
Subject: [PATCH] 20200716 代码提交
---
src/main/resources/templates/febs/views/modules/member/member.html | 389 ++++++++++----------
src/main/resources/mapper/modules/MemberMapper.xml | 672 ++++++++++++++++++------------------
src/main/resources/mapper/modules/ContractHoldOrderEntityMapper.xml | 3
3 files changed, 531 insertions(+), 533 deletions(-)
diff --git a/src/main/resources/mapper/modules/ContractHoldOrderEntityMapper.xml b/src/main/resources/mapper/modules/ContractHoldOrderEntityMapper.xml
index 2de6da9..c3cdf16 100644
--- a/src/main/resources/mapper/modules/ContractHoldOrderEntityMapper.xml
+++ b/src/main/resources/mapper/modules/ContractHoldOrderEntityMapper.xml
@@ -8,7 +8,7 @@
FROM
contract_hold_order s
LEFT JOIN member m ON m.id = s.member_id
- WHERE
+ <where>
s.member_id IN (
SELECT
id
@@ -17,7 +17,6 @@
WHERE
account_type = '1'
)
- <where>
<if test="record != null" >
<if test="record.account!=null and record.account!=''">
and (m.phone = #{record.account} or m.email = #{record.account} or m.invite_id=#{record.account})
diff --git a/src/main/resources/mapper/modules/MemberMapper.xml b/src/main/resources/mapper/modules/MemberMapper.xml
index c4ef057..d371d4e 100644
--- a/src/main/resources/mapper/modules/MemberMapper.xml
+++ b/src/main/resources/mapper/modules/MemberMapper.xml
@@ -1,337 +1,337 @@
-<?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">
-
- <select id="selectMemberListInPage" resultType="com.xcong.excoin.modules.member.entity.MemberEntity">
- SELECT
- *
- FROM
- member m
- LEFT JOIN member_authentication a ON m.id = a.member_id
- <where>
- <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 (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 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,
- m.phone,
- m.email,
- m.invite_id inviteId,
- a.available_balance walletCoinAvailableBalance,
- a.total_balance walletCoinTotalBalance,
- a.frozen_balance walletCoinFrozenBalance,
- b.available_balance walletAvailableBalance,
- b.total_balance walletTotalBalance,
- b.frozen_balance walletFrozenBalance
- FROM
- member m
- LEFT JOIN member_wallet_coin b ON m.id = b.member_id
- LEFT JOIN member_wallet_contract a ON a.member_id = m.id
- <where>
- b.wallet_code = 'USDT'
- <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>
- </where>
- order by m.create_time desc
- </select>
-
- <select id="selectAgentForAccount" resultType="java.lang.String">
- select invite_id from agent_friend_relation where member_id = #{memberId}
- </select>
-
- <select id="selectTradeSetting" resultType="java.lang.String">
- select profit_param from platform_trade_setting
- </select>
-
- <select id="selectMemberDataInfoDtoListInPage" resultType="com.xcong.excoin.modules.member.vo.MemberDataInfoVo">
- select COUNT(m.id) as memberCount from member m
- </select>
-
- <select id="selectTotalAmountUsdtBForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(a.amount),'0') as amount
- FROM
- member_coin_charge a
- WHERE
- a.symbol = 'USDT'
- AND a.member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectTotalAmountUsdtSForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(a.amount),'0') as amount
- FROM
- member_coin_withdraw a
- WHERE
- a. STATUS = 2
- AND a.is_inside = 'N'
- AND a.member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
-
- <select id="selectTotalAmountUsdtCZForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(amount_usdt),'0')
- FROM
- member_quick_buy_sale
- WHERE
- order_type = 'B'
- AND order_status = 3
- AND member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectTotalAmountUsdtTXForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(amount_usdt),'0')
- FROM
- member_quick_buy_sale
- WHERE
- order_type = 'S'
- AND order_status = 2
- AND member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectReturnMoneyForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(s.amount), '0')
- FROM
- member_account_money_change s
- WHERE
- s.type = 3
- AND s.content LIKE '%佣金到账%'
- AND s. STATUS = '1'
- </select>
- <select id="selectClosingpriceForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(a.opening_fee_amount),'0')
- FROM
- contract_order a
- WHERE
- a.closing_type = '0'
- and a.order_status = '1'
- AND a.member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectSellClosingpriceForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(a.closing_fee_amount),'0')
- FROM
- contract_order a
- WHERE
- a.closing_type IN (2,3,4, 5, 6, 7, 8, 9)
- and a.order_status = '1'
- AND a.member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectRewardratioForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(a.reward_amount), '0')
- FROM
- contract_order a
- WHERE
- a.closing_type IN (2,3,4, 5, 6, 7, 8, 9)
- AND a.order_status = '1'
- AND a.member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectSFCCForBasicRealData" resultType="java.lang.String">
- SELECT
- COUNT(b.id)
- FROM
- (
- SELECT
- s.id
- FROM
- contract_hold_order s
- WHERE
- s.member_id IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '1'
- )
- GROUP BY
- s.member_id
- ) b
- </select>
- <select id="selectBBZHForBasicRealData" resultType="java.lang.String">
- SELECT
- COUNT(a.id)
- FROM
- member_wallet_coin a
- WHERE
- a.wallet_code = 'USDT'
- AND a.available_balance > 1
- AND a.member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectHYZHForBasicRealData" resultType="java.lang.String">
- SELECT
- COUNT(a.id)
- FROM
- member_wallet_contract a
- WHERE
- a.wallet_code = 'USDT'
- AND a.total_balance > 1
- AND a.member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectprepriceForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(a.hold_amount),'0')
- FROM
- contract_order a
- WHERE
- a.member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectBBZCForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(available_balance),'0')
- FROM
- member_wallet_coin
- WHERE
- wallet_code = 'USDT'
- AND member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectHYZCForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(total_balance),'0')
- FROM
- member_wallet_contract
- WHERE
- member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
- <select id="selectDLZCForBasicRealData" resultType="java.lang.String">
- SELECT
- IFNULL(SUM(total_balance),'0')
- FROM
- member_wallet_agent
- WHERE
- member_id NOT IN (
- SELECT
- id
- FROM
- member
- WHERE
- account_type = '2'
- AND account_status = '1'
- )
- </select>
-
- <select id="selectMemberBylowLevelInviteId" resultType="java.lang.String">
- select id from member where FIND_IN_SET(#{inviteId},referer_ids)
- </select>
-
+<?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">
+
+ <select id="selectMemberListInPage" resultType="com.xcong.excoin.modules.member.entity.MemberEntity">
+ SELECT
+ *
+ FROM
+ member m
+ LEFT JOIN member_authentication a ON m.id = a.member_id
+ <where>
+ <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,
+ m.phone,
+ m.email,
+ m.invite_id inviteId,
+ a.available_balance walletCoinAvailableBalance,
+ a.total_balance walletCoinTotalBalance,
+ a.frozen_balance walletCoinFrozenBalance,
+ b.available_balance walletAvailableBalance,
+ b.total_balance walletTotalBalance,
+ b.frozen_balance walletFrozenBalance
+ FROM
+ member m
+ LEFT JOIN member_wallet_coin b ON m.id = b.member_id
+ LEFT JOIN member_wallet_contract a ON a.member_id = m.id
+ <where>
+ b.wallet_code = 'USDT'
+ <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>
+ </where>
+ order by m.create_time desc
+ </select>
+
+ <select id="selectAgentForAccount" resultType="java.lang.String">
+ select invite_id from agent_friend_relation where member_id = #{memberId}
+ </select>
+
+ <select id="selectTradeSetting" resultType="java.lang.String">
+ select profit_param from platform_trade_setting
+ </select>
+
+ <select id="selectMemberDataInfoDtoListInPage" resultType="com.xcong.excoin.modules.member.vo.MemberDataInfoVo">
+ select COUNT(m.id) as memberCount from member m
+ </select>
+
+ <select id="selectTotalAmountUsdtBForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.amount),'0') as amount
+ FROM
+ member_coin_charge a
+ WHERE
+ a.symbol = 'USDT'
+ AND a.member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectTotalAmountUsdtSForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.amount),'0') as amount
+ FROM
+ member_coin_withdraw a
+ WHERE
+ a. STATUS = 2
+ AND a.is_inside = 'N'
+ AND a.member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+
+ <select id="selectTotalAmountUsdtCZForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(amount_usdt),'0')
+ FROM
+ member_quick_buy_sale
+ WHERE
+ order_type = 'B'
+ AND order_status = 3
+ AND member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectTotalAmountUsdtTXForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(amount_usdt),'0')
+ FROM
+ member_quick_buy_sale
+ WHERE
+ order_type = 'S'
+ AND order_status = 2
+ AND member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectReturnMoneyForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(s.amount), '0')
+ FROM
+ member_account_money_change s
+ WHERE
+ s.type = 3
+ AND s.content LIKE '%佣金到账%'
+ AND s. STATUS = '1'
+ </select>
+ <select id="selectClosingpriceForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.opening_fee_amount),'0')
+ FROM
+ contract_order a
+ WHERE
+ a.closing_type = '0'
+ and a.order_status = '1'
+ AND a.member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectSellClosingpriceForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.closing_fee_amount),'0')
+ FROM
+ contract_order a
+ WHERE
+ a.closing_type IN (2,3,4, 5, 6, 7, 8, 9)
+ and a.order_status = '1'
+ AND a.member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectRewardratioForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.reward_amount), '0')
+ FROM
+ contract_order a
+ WHERE
+ a.closing_type IN (2,3,4, 5, 6, 7, 8, 9)
+ AND a.order_status = '1'
+ AND a.member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectSFCCForBasicRealData" resultType="java.lang.String">
+ SELECT
+ COUNT(b.id)
+ FROM
+ (
+ SELECT
+ s.id
+ FROM
+ contract_hold_order s
+ WHERE
+ s.member_id IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '1'
+ )
+ GROUP BY
+ s.member_id
+ ) b
+ </select>
+ <select id="selectBBZHForBasicRealData" resultType="java.lang.String">
+ SELECT
+ COUNT(a.id)
+ FROM
+ member_wallet_coin a
+ WHERE
+ a.wallet_code = 'USDT'
+ AND a.available_balance > 1
+ AND a.member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectHYZHForBasicRealData" resultType="java.lang.String">
+ SELECT
+ COUNT(a.id)
+ FROM
+ member_wallet_contract a
+ WHERE
+ a.wallet_code = 'USDT'
+ AND a.total_balance > 1
+ AND a.member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectprepriceForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(a.hold_amount),'0')
+ FROM
+ contract_order a
+ WHERE
+ a.member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectBBZCForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(available_balance),'0')
+ FROM
+ member_wallet_coin
+ WHERE
+ wallet_code = 'USDT'
+ AND member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectHYZCForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(total_balance),'0')
+ FROM
+ member_wallet_contract
+ WHERE
+ member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+ <select id="selectDLZCForBasicRealData" resultType="java.lang.String">
+ SELECT
+ IFNULL(SUM(total_balance),'0')
+ FROM
+ member_wallet_agent
+ WHERE
+ member_id NOT IN (
+ SELECT
+ id
+ FROM
+ member
+ WHERE
+ account_type = '2'
+ AND account_status = '1'
+ )
+ </select>
+
+ <select id="selectMemberBylowLevelInviteId" resultType="java.lang.String">
+ select id from member where FIND_IN_SET(#{inviteId},referer_ids)
+ </select>
+
</mapper>
\ 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/member/member.html
index 4d807d3..eed7d4d 100644
--- a/src/main/resources/templates/febs/views/modules/member/member.html
+++ b/src/main/resources/templates/febs/views/modules/member/member.html
@@ -1,196 +1,195 @@
-<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="0">未通过</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;
-
- if (layEvent === 'edit') {
- febs.modal.open('身份认证', 'modules/member/memberDetail/' + data.id, {
- btn: ['提交', '取消'],
- yes: function (index, layero) {
- $('#user-update').find('#submit').trigger('click');
- },
- btn2: function () {
- layer.closeAll();
- }
- });
- }
- if (layEvent === 'see') {
- febs.modal.open( '身份认证', 'modules/member/memberDetail/' + data.id, {
- maxmin: true,
- });
- }
- if (layEvent === 'addCoin') {
- febs.modal.open( '拨币', 'modules/member/addCoin/' + data.id, {
- 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();
- 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/getList',
- 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: 'accountType', title: '账号类型',
- templet: function (d) {
- if (d.accountType === 2) {
- return '<span style="color:green;">测试账号</span>'
- } else if (d.accountType === 1) {
- return '<span style="color:red;">正常账号</span>'
- }else{
- return ''
- }
- }, 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'},
- {title: '操作',
- templet: function (d) {
- if (d.certifyStatus === 1) {
- return '<a lay-event="edit" shiro:hasPermission="user:update">审核认证</a>'
- +'<i class="layui-icon febs-edit-area febs-blue"></i>'
- +'<a lay-event="addCoin" shiro:hasPermission="user:update">拨币</a>'
- }else if(d.certifyStatus === 2){
- return '<a lay-event="see" shiro:hasPermission="user:update">'
- +'<i class="layui-icon febs-edit-area febs-blue"></i></a>'
- +'<a lay-event="addCoin" shiro:hasPermission="user:update">拨币</a>'
- }else {
- return '<a lay-event="addCoin" shiro:hasPermission="user:update">拨币</a>'
- }
- },minWidth: 200,align:'center'}
- ]]
- });
- }
-
- // 获取查询参数
- function getQueryParams() {
- return {
- account: $searchForm.find('input[name="account"]').val().trim(),
- certifyStatus: $searchForm.find("select[name='certifyStatus']").val(),
- };
- }
-
- })
+<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;
+
+ if (layEvent === 'edit') {
+ febs.modal.open('身份认证', 'modules/member/memberDetail/' + data.id, {
+ btn: ['提交', '取消'],
+ yes: function (index, layero) {
+ $('#user-update').find('#submit').trigger('click');
+ },
+ btn2: function () {
+ layer.closeAll();
+ }
+ });
+ }
+ if (layEvent === 'see') {
+ febs.modal.open( '身份认证', 'modules/member/memberDetail/' + data.id, {
+ maxmin: true,
+ });
+ }
+ if (layEvent === 'addCoin') {
+ febs.modal.open( '拨币', 'modules/member/addCoin/' + data.id, {
+ 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();
+ 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/getList',
+ 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: 'accountType', title: '账号类型',
+ templet: function (d) {
+ if (d.accountType === 2) {
+ return '<span style="color:green;">测试账号</span>'
+ } else if (d.accountType === 1) {
+ return '<span style="color:red;">正常账号</span>'
+ }else{
+ return ''
+ }
+ }, 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'},
+ {title: '操作',
+ templet: function (d) {
+ if (d.certifyStatus === 1) {
+ return '<a lay-event="edit" shiro:hasPermission="user:update">审核认证</a>'
+ +'<i class="layui-icon febs-edit-area febs-blue"></i>'
+ +'<a lay-event="addCoin" shiro:hasPermission="user:update">拨币</a>'
+ }else if(d.certifyStatus === 2){
+ return '<a lay-event="see" shiro:hasPermission="user:update">'
+ +'<i class="layui-icon febs-edit-area febs-blue"></i></a>'
+ +'<a lay-event="addCoin" shiro:hasPermission="user:update">拨币</a>'
+ }else {
+ return '<a lay-event="addCoin" shiro:hasPermission="user:update">拨币</a>'
+ }
+ },minWidth: 200,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