20211216

xiaoyong931011

2021-12-22 90bd2c3aedab5bb2e115a3fbc31c5877d41134ce

20211216

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

@@ -69,6 +69,12 @@
                    and (b.account like concat('%',  #{record.account},'%')
                    or b.name like concat('%', #{record.account}, '%'))
                </if>
                <if test="record.payType!=null">
                    and a.pay_type = #{record.payType}
                </if>
                <if test="record.status!=null">
                    and a.status = #{record.status}
                </if>
            </if>
        </where>
        order by a.CREATED_TIME desc

 src/main/resources/templates/febs/views/videoMember/orderList.html

@@ -12,6 +12,27 @@
                                            <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="status">
                                                <option value="">请选择</option>
                                                <option value="1">待支付</option>
                                                <option value="2">已支付</option>
                                                <option value="3">已取消</option>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label layui-form-label-sm">支付类型</label>
                                        <div class="layui-input-inline">
                                            <select name="payType">
                                                <option value="">请选择</option>
                                                <option value="1">支付宝</option>
                                                <option value="2">USDT</option>
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area">
@@ -134,6 +155,8 @@
        function getQueryParams() {
            return {
                account: $searchForm.find('input[name="account"]').val().trim(),
                status: $searchForm.find("select[name='status']").val(),
                payType: $searchForm.find("select[name='payType']").val(),
            };
        }