列表渲染分页批量删除接口调用

<!--搜索-->
<div class="demoTable">
    关键字：
    <div class="layui-inline">
        <input class="layui-input" name="id" id="demoReload" autocomplete="off">
    </div>
    <button class="layui-btn" data-type="reload">搜索</button>
</div>

<!--table表格渲染-->
<table class="layui-hide" id="test" lay-filter="test"></table>

<!--    模板：批量删除-->
<script type="text/html" id="delAll">
    <div class="layui-btn-container">
        <button class="layui-btn layui-btn-sm layui-btn-danger" lay-event="del">批量删除</button>
    </div>
</script>

<!--    模板：基本操作-->
<script type="text/html" id="actionBar">
    <a class="layui-btn layui-btn-xs" lay-event="edit">查看</a>
    <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>

<!--    模板：图片-->
<script type="text/html" id="img">
    <div><img src="http://www.thinkphp5.com/{{d.logo}}" alt="加载失败.."></div>
</script>

<script>
    layui.use(['table','jquery'], function(){
        var table = layui.table;
        var $ = layui.jquery;

        table.render({
            elem: '#test'
            ,url:"{:url('brand/brandtable')}"
            ,cols: [[
                {type:'checkbox'}
                ,{field:'id', title: 'ID', sort: true}
                ,{field:'name', title: '品牌名称', sort: true}
                ,{field:'logo', title: '品牌logo',templet:'#img'}
                ,{field:'sort', title: '排序', sort: true}
                ,{field:'cate_name', title: '品牌分类', sort: true}
                ,{title: '操作',fixed: 'right',toolbar: '#actionBar', width:150}
            ]]
            ,page: true
            ,limit:5
            ,limits:[5,10,15,20,30,40,50]
            ,toolbar:"#delAll"
            ,id:'testReload'
        });
        //头工具栏事件
        table.on('toolbar(test)', function(obj){
            layer.confirm('真的要删除吗', function(index){
                layer.close(index);
                var checkStatus = table.checkStatus(obj.config.id);
                var arr = checkStatus.data;
                var ids = [];
                $(arr).each(function (k,v) {
                    ids.push(v.id)
                })
                $.ajax({
                    url:'http://www.thinkphp5.com/admin/brand/brandDel?ids='+ids.toString(),
                    success:function (e) {
                        if(e.code==0){
                            layer.msg(e.msg)
                            table.reload('testReload')
                        }
                    }
                })
            });
        });

        //监听行工具事件
        table.on('tool(test)', function(obj){
            var data = obj.data;
            //console.log(obj)
            if(obj.event === 'del'){
                layer.confirm('真的要删除吗？', function(index){
                    $.ajax({
                        url:'http://www.thinkphp5.com/admin/brand/brandDel?ids='+index,
                        success:function (e) {
                            if(e.code==0){
                                layer.msg(e.msg)
                                table.reload('testReload')
                            }
                        }
                    })
                });
            } else if(obj.event === 'edit'){
                layer.prompt({
                    formType: 2
                    ,value: data.email
                }, function(value, index){
                    obj.update({
                        email: value
                    });
                    layer.close(index);
                });
            }
        });
        var $ = layui.$, active = {
            reload: function(){
                var demoReload = $('#demoReload');

                //执行重载
                table.reload('testReload', {
                    page: {
                        curr: 1 //重新从第 1 页开始
                    }
                    ,where: {
                        words:demoReload.val()
                    }
                });
            }
        };

        $('.demoTable .layui-btn').on('click', function(){
            var type = $(this).data('type');
            active[type] ? active[type].call(this) : '';
        });
    });
</script>

public function brandTable()
{
    $limit = input('limit');
    $word = input('words');
    if (empty($limit)){
        $limit = 5;
    }
    $brand = \app\admin\model\Brand::with('category')
        ->whereOr('name','like',"%$word%")
        ->whereOr('id','like',"%$word%")
        ->paginate($limit);
    $data = $brand->items();
    $count = $brand->total();
    return json(['code'=>0,'msg'=>'success','data'=>$data,'count'=>$count]);
}

public function brandDel()
{
    $ids = input('ids');
    $res = \app\admin\model\Brand::destroy($ids);
    return json(['code'=>0,'msg'=>'删除成功','data'=>'']);
}