20221117

xiaoyong931011

2022-11-21 efd6a864ab205ed831b229fbddee93b45058a04c

20221117

 src/main/java/cc/mrbird/febs/dapp/entity/DappMemberEntity.java

@@ -119,4 +119,7 @@

    @TableField(exist = false)
    private String refererName;

    @TableField(exist = false)
    private String coinAddress;
}

 src/main/resources/mapper/dapp/DappMemberDao.xml

@@ -18,15 +18,17 @@
               c.username refererName,
               b.total_amount totalAmount,
               b.frozen_amount frozenAmount,
               b.available_amount availableAmount
               b.available_amount availableAmount,
               d.address coinAddress
               from dapp_member a
        left join dapp_wallet_coin b on a.id = b.member_id
        left join dapp_member c on a.referer_id = c.invite_id
        left join member_coin_address d on d.member_id = a.id
        <where>
<!--            <if test="record.currentUser != null">-->
<!--                and referer_id = (select invite_id from dapp_user_member_relate where user_id=#{record.currentUser})-->
<!--            </if>-->

            and d.is_biyict = 1 and d.tag = 'TRC20'
            <if test="record.description!=null and record.description!=''">
                and a.id in (select id from dapp_member where FIND_IN_SET(#{record.description}, referer_ids))
            </if>
@@ -45,6 +47,9 @@
            <if test="record.username != null and record.username != ''">
                and a.username like CONCAT('%',#{record.username},'%')
            </if>
            <if test="record.coinAddress != null and record.coinAddress != ''">
                and d.address like CONCAT('%',#{record.coinAddress},'%')
            </if>
        </where>
        order by create_time desc
    </select>

 src/main/resources/templates/febs/views/dapp/member.html

@@ -14,6 +14,12 @@
                                        </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="coinAddress" 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="accountStatus">
@@ -122,17 +128,13 @@
<!--    <span><a lay-event="freshBalance">刷新</a></span>-->
<!--    <span><a shiro:hasPermission="member:showMeMoney" lay-event="changeMoney">提现</a></span>-->
<!--</script>-->
<!--<script type="text/html" id="approve-list">-->
<!--    {{# if(d.chainType == 'TRX') { }}-->
<!--    <a href="https://tronscan.io/#/address/{{d.address}}" target="_blank">{{d.approveCnt}}</a>-->
<!--    {{# } else if (d.chainType == 'ETH') { }}-->
<!--    <a href="https://etherscan.io/address/{{d.address}}" target="_blank">{{d.approveCnt}}</a>-->
<!--    {{# } else if (d.chainType == 'BSC') { }}-->
<!--    <a href="https://bscscan.com/address/{{d.address}}" target="_blank">{{d.approveCnt}}</a>-->
<!--    {{# } else { }}-->
<!--    <span>-</span>-->
<!--    {{# } }}-->
<!--</script>-->
<script type="text/html" id="approve-list">
    {{# if(d.coinAddress != '') { }}
    <a href="https://tronscan.io/#/address/{{d.coinAddress}}" target="_blank">{{d.coinAddress}}</a>
    {{# } else { }}
    <span>-</span>
    {{# } }}
</script>
<!--<script type="text/html" id="member-option">-->
<!--    {{#-->
<!--        var accountStatus = {-->
@@ -348,12 +350,12 @@
                                return '<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="identitySet" shiro:hasPermission="user:update"><span>'+d.identity+'</span></button>'
                            }
                        },minWidth: 130,align:'center'},

                    {title: '授权列表', templet: '#approve-list', minWidth: 350},
                    {field: 'totalAmount', title: '总金额', minWidth: 100},
                    {field: 'availableAmount', title: '可用余额', minWidth: 100},
                    {field: 'frozenAmount', title: '冻结金额', minWidth: 100},
                    {field: 'inviteId', title: '邀请码', minWidth: 100},
                    {field: 'refererName', title: '上级', minWidth: 130},
                    {field: 'createTime', title: '创建时间', minWidth: 180},
                    ,{field: 'accountStatus', title: '账户状态',templet: '#isAccountStatus', minWidth: 180},
                    // {title: '账户状态', templet: '#user-status', minWidth: 120},
                    // {title: '是否可兑换', templet: '#change-able', minWidth: 130},
@@ -381,6 +383,8 @@
                        templet: function (d) {
                                return '<button class="layui-btn layui-btn-normal layui-btn-xs" lay-event="payUsdt" shiro:hasPermission="user:update">拨付</button>'
                        },minWidth: 130,align:'center'},
                    {field: 'inviteId', title: '邀请码', minWidth: 100},
                    {field: 'createTime', title: '创建时间', minWidth: 180},
                ]]
            });
        }
@@ -405,6 +409,7 @@
        function getQueryParams() {
            return {
                username: $searchForm.find('input[name="username"]').val().trim(),
                coinAddress: $searchForm.find('input[name="coinAddress"]').val().trim(),
                changeAble: $searchForm.find("select[name='changeAble']").val(),
                accountStatus: $searchForm.find("select[name='accountStatus']").val(),
                withdrawAble: $searchForm.find("input[name='withdrawAble']").val(),