feat(mallMember): 会员列表增加节点筛选功能

KKSU

2024-12-31 10ac439f9e0abf732901b5b8e3a3b357588bb13f

feat(mallMember): 会员列表增加节点筛选功能

- 在会员列表页面添加节点筛选下拉框
- 后端增加节点筛选参数处理
- 优化会员列表查询 SQL，添加节点状态筛选条件

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

@@ -26,6 +26,9 @@
                <if test="record.accountStatus!=null">
                    and m.account_status = #{record.accountStatus}
                </if>
                <if test="record.director!=null">
                    and m.director = #{record.director}
                </if>
                <if test="record.level!=null and record.level!=''">
                    and m.level=#{record.level}
                </if>

 src/main/resources/templates/febs/views/modules/mallMember/mallMemberList.html

@@ -21,6 +21,16 @@
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label layui-form-label-sm">节点</label>
                                        <div class="layui-input-inline">
                                            <select name="directorState">
                                                <option value="">请选择</option>
                                                <option value="1">是</option>
                                                <option value="0">否</option>
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area">
@@ -360,6 +370,7 @@
            return {
                account: $searchForm.find('input[name="account"]').val(),
                level: $searchForm.find("select[name='levelType']").val(),
                director: $searchForm.find("select[name='directorState']").val(),
            };
        }