layui table表格搜索不生效

layui表格 搜索可以重载,但重载完仍然返回所有数据,没有进行过滤
用代码块功能插入代码,请勿粘贴截图



<div class="layui-fluid qs_v_cardlist" id="VIEW-list-table" lay-title="会员卡管理">
    <div class="layui-row layui-col-space10">
        <div class="layui-col-md12">
            <div class="layui-card">
                <div class="layui-card-header layui-bg-cyan">会员卡管理div>
                    <form class="layui-form layui-form-pane search_box" action="" >
                        <input class="layui-input" name="keyword" id="demoReload" autocomplete="off">
                        <button type="button" class="layui-btn layui-btn-primary"  lay-submit data-type="reload" lay-filter="data-search-btn"><i class="layui-icon">i> 搜 索button>
                    form>
                <table id="service" lay-filter="test">table>
            div>
        div>
    div>
div>

<table class="layui-hide" id="tablea" lay-filter="menu-filter">table>
<script type="text/html" id="barDemo">
    
    <a class="layui-btn layui-btn-sm" lay-event="present">退款a>
    <a class="layui-btn layui-btn-sm" lay-event="prize">赠券a>
script>

<script>
    layui.use(['admin', 'echarts','table','form','upload', 'laydate'], function (admin, code) {
        
        var th_store = admin.post({
            api:'storeList',
            success:function(e){
                if(e.code==200){
                    console.log(e.result.list)
                    $.each(e.result.list, function(i,item){
                        var store_opn = '+'" >'+item.title+'';
                        $("#prize_store_id").append(store_opn);
                    });
                }
            }
         });
         
        var $ = layui.jquery;
        var form = layui.form
        var imgUrl = layui.conf.imgUrl
        var uploadUrl = layui.conf.uploadUrl
        var upload = layui.upload;
          var view = $('#VIEW-list-table');
        var table = layui.table;

        var laydate = layui.laydate;
        laydate.render({
          elem: '#service_opentime'
          ,type: 'time'
          ,format: 'HH:mm:ss' //可任意组合
        });
        laydate.render({
          elem: '#service_closetime'
          ,type: 'time'
          ,format: 'HH:mm:ss' //可任意组合
        });

        // var page = 1
          admin.post({
            api:'cardsList',
            // data:{page:4},
            success:function(e){
                var list = e.result.list
                console.log(list)
            }
        })
        var tableFilter = 'test';
        var tableIns = admin.renderTable({
            elem: '#service'
                  ,height: 1000
                  ,api: 'cardsList'
                  ,cellMinWidth: 80
                  ,cols: [[
                    {field: 'card_id', width:100,title: '会员卡', sort:'true'}
                    ,{field: 'user_id', width:80,title: '用户', sort:'true'}
                    //,{field: 'store_id', width:80, title: '门店', }
                    ,{field: 'real_pay',width:80, title: '实付', }
                    ,{field: 'prize_pay', width:120,title: '累计退款', }
                    ,{field: 'total',width:80, title: '总额', }
                    ,{field: 'balance',width:120, title: '通用余额',} 
                    ,{field: 'prizeInfo', title: '消费券余额',templet:function(e){
                            var prize_storeid_balance = [];
                            $.each(e.prizeInfo, function(i,item){
                                prize_storeid_balance.push(item.store_id+'-'+item.p_balance);
                            });
                            return prize_storeid_balance
                    }} 
                    ,{field: 'create_time', width:180,title: '创建时间', templet:function(e){
                        return '
' + layui.util.toDateString((e.create_time*1000), 'yyyy-MM-dd HH:mm:ss') + '
'
}} ,{field: 'status', width:120,title: '是否禁用', templet: function(d){ if(d.status==1){ return '
card_id+'" lay-filter="ifban" checked />
'; }else{ return '
card_id+'" lay-filter="ifban"/>
'; } }} ,{fixed: 'right', width:200,align:'center', toolbar: '#barDemo'} //这里的toolbar值是模板元素的选择器 ]] , //laypage分页设置 page: { //支持传入 laypage 组件的所有参数(某些参数除外,如:jump/elem) - 详见文档 layout: ['count', 'prev', 'page', 'next', 'limit', 'refresh', 'skip']//自定义分页布局 ,limit:20//默认20条数据一页 ,groups: 5 //默认显示分页选项个数 ,limits:[20,30,50,100,200] ,first: '1' //将首页显示为数字1,。若不显示,设置false即可 ,last: '' //将尾页显示为总页数。若不显示,设置false即可 }, skin: 'line', //laypage分页设置END done: function(res, curr, count){ //console.log(res); //console.log(curr); //console.log(count); if(my_phone==1){ console.log("table手机端重写渲染"); var vrs = res.result; console.log(vrs); v_data = vrs; var v_htm = ''; v_htm +='
'; $.each(vrs, function(i, item){ v_htm +='
'; v_htm +='
'; v_htm +=' avatar+'" style="width:30px;height:30px;">'; v_htm +=' 【'+item.nick_name+'】'; v_htm +=' '+item.user_id+''; v_htm +='
'
; v_htm +='
'; v_htm +=' 会员卡id'; v_htm +=' '+item.card_id+''; v_htm +='
'
; v_htm +='
'; v_htm +=' 门店名'; v_htm +=' '+item.store_name+''; v_htm +='
'
; v_htm +='
'; v_htm +=' 注册时间'; v_htm +=' '+layui.util.toDateString((item.create_time*1000), 'yyyy-MM-dd HH:mm:ss')+''; v_htm +='
'
; v_htm +='
'; v_htm +=' 当前余额'; v_htm +=' ¥'+item.balance+''; v_htm +='
'
; // v_htm +='
'; // v_htm +=' 工位控电状态'; // v_htm +=' '; // v_htm +=' 开启'; // v_htm +='
';
v_htm +='
'; v_htm +=' 累计充值'; v_htm +=' ¥'+item.real_pay+''; v_htm +='
'
; v_htm +='
'; v_htm +=' 累计退款'; v_htm +=' ¥'+item.prize_pay+''; v_htm +='
'
; v_htm +='
'; v_htm +=' 修改'; v_htm +=' 退款'; v_htm +='
'
; v_htm +='
'
; }) v_htm +='
'
; $(".qs_v_cardlist .layui-card .layui-table-view").css({"height":"auto","border":"none"}); $(".layui-body").scrollTop(0); $(".qs_v_cardlist .layui-card .layui-table-view .layui-table-box").children().addClass("qs_yin"); $(".qs_v_cardlist .layui-card .layui-table-view .layui-table-box").append(v_htm); } } }) function stampToTime (stamp) { var d = new Date(stamp * 1000) var date = (d.getFullYear()) + "-" + (d.getMonth() + 1) + "-" + (d.getDate()) + " " + (d.getHours()) + ":" + (d.getMinutes()) + ":" + (d.getSeconds()); return date } // 搜索功能 var active = { reload: function(){ var demoReload = $('#demoReload'); //得到搜索框里已输入的数据 //执行重载 table.reload('service', { page: { curr: 1 //重新从第 1 页开始 } ,where: { name: demoReload.val() //在表格中进行搜索 } }); } }; $('#btn .layui-btn').on('click', function(){ var type = $(this).data('type'); active[type] ? active[type].call(this) : ''; }); function present(data){ var mainIndex = layer.open({ type:1 ,area:['60%','70%'] ,title: '退款金额' ,content: $("#presentDiv") ,offset: 'auto' ,btnAlign: 'c' ,success:function(layero,index){ var mask = $(".layui-layer-shade"); mask.appendTo(layero.parent()); admin.post({ api:'cardsItem', data:{card_id:data.card_id}, //data:{card_id:826}, success:function(e){ console.log(e) if(e.code==200){ var oneData = e.result console.log(oneData) form.val("presentInfo",{ "card_id":oneData.card_id, "user_id":oneData.user_id, "old_balance":oneData.balance, "present":0, }) form.render(); } } }) } }); form.on('submit(presentSubmit)',function (obj) { console.log(obj) var json = obj.field; admin.post({ api: 'cardsPresent', async:false, data:{ "card_id":json.card_id, "present":json.present, }, success:function(data){ console.log(data) result = data.result layer.msg('退款成功',{icon:1,time:1000},function(){ $(".layui-laypage-btn").click(); }) form.render(); layer.close(mainIndex); } }); }) } function prize(data){ var all_prize = ''; var mainIndex = layer.open({ type:1 ,area:['60%','70%'] ,title: '消费券金额' ,content: $("#prizeDiv") ,offset: 'auto' ,btnAlign: 'c' ,success:function(layero,index){ var mask = $(".layui-layer-shade"); mask.appendTo(layero.parent()); admin.post({ api:'cardsItem', data:{card_id:data.card_id}, //data:{card_id:826}, success:function(e){ console.log(e) if(e.code==200){ var oneData = e.result console.log(oneData); all_prize = oneData.prizeInfo; var prize_storeid_balance = []; $.each(all_prize, function(i,item){ prize_storeid_balance.push(item.store_id+'-'+item.p_balance); }); form.val("prizeInfo",{ "card_id":oneData.card_id, "user_id":oneData.user_id, "prize_balance":prize_storeid_balance, "prize":0, }) form.render(); } } }) } }); layui.form.on('select(select_store_id)', function (data) { //console.log(data.value); $("#prize_balance").val(0); $.each(all_prize, function(i,item){ if( data.value == item.store_id ){ $("#prize_balance").val(item.p_balance); } }); }) form.on('submit(prizeSubmit)',function (obj) { console.log(obj) var json = obj.field; admin.post({ api: 'cardsPrize', async:false, data:{ "card_id":json.card_id, "store_id":json.store_id, "user_id":json.user_id, "prize":json.prize, }, success:function(data){ console.log(data) result = data.result layer.msg('赠送消费券金额成功',{icon:1,time:1000},function(){ $(".layui-laypage-btn").click(); }) form.render(); layer.close(mainIndex); } }); }) } script>
运行结果及报错内容

返回所有 数据,筛选目标未达到