20200716 代码提交

xiaoyong931011

2020-07-16 a719b1c8617fa37b22c55307d20796cda14e3c7d

20200716  代码提交

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


 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>

 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">&#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="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">&#xe7a5;</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">&#xe7a4;</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">&#xe7a5;</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">&#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="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">&#xe7a5;</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">&#xe7a4;</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">&#xe7a5;</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>