feat(mallMember): 添加邀请码查询功能

KKSU

2025-03-14 7338052ad16f1f2f5dc338f6c20643ebbc836f00

feat(mallMember): 添加邀请码查询功能

- 在会员列表页面添加邀请码查询输入框
- 在查询参数中增加 inviteId 字段
- 在数据库查询中添加对邀请码的搜索条件
- 同时更新 Mrbird 列表页面，增加邀请码查询功能

 src/main/resources/mapper/modules/MallMemberMapper.xml

@@ -27,6 +27,9 @@
                <if test="record.accountStatus!=null">
                    and m.account_status = #{record.accountStatus}
                </if>
                <if test="record.inviteId!=null">
                    and find_in_set(#{record.inviteId}, m.referrer_ids)
                </if>
                <if test="record.director!=null">
                    and m.director = #{record.director}
                </if>

 src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.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" placeholder="查询全部下级" name="inviteId" 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="levelType" class="vip-level-set-level-member">
@@ -374,6 +380,7 @@
        function getQueryParams() {
            return {
                account: $searchForm.find('input[name="account"]').val(),
                inviteId: $searchForm.find('input[name="inviteId"]').val(),
                level: $searchForm.find("select[name='levelType']").val(),
                director: $searchForm.find("select[name='directorState']").val(),
            };

 src/main/resources/templates/febs/views/modules/mallMember/mallMrbirdList.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" placeholder="查询全部下级" name="inviteId" 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="levelType" class="vip-level-set-level-member">
@@ -373,6 +379,7 @@
        function getQueryParams() {
            return {
                account: $searchForm.find('input[name="account"]').val(),
                inviteId: $searchForm.find('input[name="inviteId"]').val(),
                level: $searchForm.find("select[name='levelType']").val(),
                director: $searchForm.find("select[name='directorState']").val(),
            };