From 7338052ad16f1f2f5dc338f6c20643ebbc836f00 Mon Sep 17 00:00:00 2001 From: KKSU <15274802129@163.com> Date: Fri, 14 Mar 2025 11:42:16 +0800 Subject: [PATCH] feat(mallMember): 添加邀请码查询功能 --- src/main/resources/templates/febs/views/modules/mallMember/mallMrbirdList.html | 7 +++++++ src/main/resources/mapper/modules/MallMemberMapper.xml | 3 +++ src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html | 7 +++++++ 3 files changed, 17 insertions(+), 0 deletions(-) diff --git a/src/main/resources/mapper/modules/MallMemberMapper.xml b/src/main/resources/mapper/modules/MallMemberMapper.xml index 554fad1..99ad530 100644 --- a/src/main/resources/mapper/modules/MallMemberMapper.xml +++ b/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> diff --git a/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html b/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html index b768852..a3b1aed 100644 --- a/src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html +++ b/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(), }; diff --git a/src/main/resources/templates/febs/views/modules/mallMember/mallMrbirdList.html b/src/main/resources/templates/febs/views/modules/mallMember/mallMrbirdList.html index 4659eb4..d3ca1d5 100644 --- a/src/main/resources/templates/febs/views/modules/mallMember/mallMrbirdList.html +++ b/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(), }; -- Gitblit v1.9.1