lavarel5.2中多表联查 搜索后分页

//控制器里方法:

//业务列表
    public function business_list(){
        //分页查询开始
        $search = isset($_GET['search'])?$_GET['search']:"";//判断是否接过搜索值
       if($search)
       {
            //$arr = DB::select("select * from mr_inspect where loan like '%$search%'");//搜索查询
            $arr=DB::table('mr_inspect')//主表
                 ->join('mr_user', 'mr_inspect.user_id', '=', 'mr_user.id')
                 ->join('mr_debtor', 'mr_inspect.debtor_id', '=', 'mr_debtor.id')
                 ->select('mr_inspect.*', 'mr_user.*', 'mr_debtor.*')
                 ->where ('mr_inspect.loan','like','%'.$search.'%')
                 ->get();//搜索多表查询
            }else{
            //$arr = DB::table('mr_inspect')->get();//普通查询
           $arr= DB::table('mr_inspect')//主表
            ->join('mr_user', 'mr_inspect.user_id', '=', 'mr_user.id')
            ->join('mr_debtor', 'mr_inspect.debtor_id', '=', 'mr_debtor.id')
            ->select('mr_inspect.*', 'mr_user.*', 'mr_debtor.*')
            ->get();//多表查询
       }
       //总条数
       $count = count($arr);
       //每页条数
       $mys = 3 ;
       //计算总页数
       $zys = ceil($count/$mys);
       //获取当前页
       $page = isset($_GET['page'])?$_GET['page']:1;
       //偏移量
       $pyl = ($page-1)*$mys;
       if($search)
       {
            //$arr = DB::select("select * from mr_inspect where loan like '%$search%' limit $pyl,$mys");//带搜索分页查询
            $arr=DB::table('mr_inspect')//主表
                 ->join('mr_user', 'mr_inspect.user_id', '=', 'mr_user.id')
                 ->join('mr_debtor', 'mr_inspect.debtor_id', '=', 'mr_debtor.id')
                 ->select('mr_inspect.*', 'mr_user.*', 'mr_debtor.*')
                 ->where ('mr_inspect.loan','like','%'.$search.'%')
                 ->skip($pyl)
                 ->take($mys)
                 ->get();//搜索分页多表查询
             }else{
            //$arr = DB::table('mr_inspect')->skip($pyl)->take($mys)->get();//带分页查询
           $arr= DB::table('mr_inspect')//主表
            ->join('mr_user', 'mr_inspect.user_id', '=', 'mr_user.id')
            ->join('mr_debtor', 'mr_inspect.debtor_id', '=', 'mr_debtor.id')
            ->select('mr_inspect.*', 'mr_user.*', 'mr_debtor.*')
            ->skip($pyl)
            ->take($mys)
            ->get();//分页多表查询
       }
       //上一页
       $last = $page-1<1?1:$page-1;
       //下一页
       $next = $page+1>$zys?$zys:$page+1;
       // print_R($next);die;
       return view('Watch/business_list',['result'=>$arr,'search'=>$search,'last'=>$last,'next'=>$next,'sum_page'=>$zys,'page'=>$page,'count'=>$count]);
        //分页查询结束
       
       
    }
   
 
//视图层

<input type="text" class="input-text" style="width:250px" placeholder="输入贷款金额" id="" value="{{$search}}" name="search">
        <button type="submit" οnclick="page(<?php echo $page?>)"class="btn btn-success" id="" name=""><i class="Hui-iconfont">&#xe665;</i> 搜贷款金额</button>    

<!-- 分页开始 -->
     <div id="div1">
<nav class="breadcrumb"><i class="Hui-iconfont">&#xe67f;</i> 首页 <span class="c-gray en">&gt;</span> 业务管理 <span class="c-gray en">&gt;</span> 业务列表 <a class="btn btn-success radius r" style="line-height:1.6em;margin-top:3px" href="javascript:location.replace(location.href);" title="刷新" ><i class="Hui-iconfont">&#xe68f;</i></a></nav>
<div class="page-container">
    <div class="text-c">
        <input type="text" class="input-text" style="width:250px" placeholder="输入贷款金额" id="" value="{{$search}}" name="search">
        <button type="submit" οnclick="page(<?php echo $page?>)"class="btn btn-success" id="" name=""><i class="Hui-iconfont">&#xe665;</i> 搜贷款金额</button>     
   </div>

    <div class="cl pd-5 bg-1 bk-gray mt-20"> <span class="l">
     <a href="business_add"  class="btn btn-primary radius"><i class="Hui-iconfont">&#xe600;</i> 添加业务</a></span> <span class="r">共有数据：<strong><?php echo $count?></strong> 条</span> </div>
    
    <table class="table table-border table-bordered table-bg">
        <thead>
            <tr>
                <th scope="col" colspan="9">业务列表</th>
            </tr>
            <tr class="text-c">
                <th width="25"><input type="checkbox" name="" value=""></th>
                <th width="40">ID</th>
                <th width="150">债权人联系方式</th>
                <th width="130">债务人</th>
                <th width="100">贷款金额</th>
                <th width="100">抵押物</th>
                <th width="100">借款日期</th>
                <th width="100">续息日</th>
                <th width="100">借款周期</th>
                <th width="100">还款日</th>
                <th width="100">展期</th>
                <th width="100">借款合同</th>
                <th width="100">还款状态</th>
                <th width="100">申请贷款状态</th>
                <th width="100">操作</th>
            </tr>
        </thead>
        <tbody>
        @foreach($result as $val)
            <tr class="text-c">
                <td><input type="checkbox" value="{{$val->id}}" name=""></td>
                <td>{{$val->id}}</td>
                <td>{{$val->phone}}</td><!-- 债权人联系方式 -->
                <td>{{$val->username}}</td><!-- 债务人姓名 -->
                <td>{{$val->loan}}</td>
                <td>{{$val->pawn}}</td>
                <td>{{$val->loan_date}}</td>
                <td>{{$val->xuxi_date}}</td>
                <td>{{$val->loan_times}}</td>
                <td>{{$val->repay_date}}</td>
                <td>{{$val->extense_date}}</td>
                <td>{{$val->contract_file}}</td>
                <td>{{$val->status}}</td>
                <td>{{$val->review_status}}</td>
                <td class="td-status"><span class="label label-success radius">已审核</span></td>
                <td class="td-manage">
                <a style="text-decoration:none" onClick="admin_stop(this,'10001')" href="javascript:;" title="审核未通过"><i class="Hui-iconfont">&#xe631;</i></a>
                <a title="编辑" href="{{url('update_business')}}?id={{$val->id}}" class="ml-5" style="text-decoration:none"><i class="Hui-iconfont">&#xe6df;</i></a>
                <a href="{{url('del_business')}}?id={{$val->id}}"><i class="Hui-iconfont">&#xe6e2;</i></a>
        </tr>
         @endforeach   
        </tbody>
    </table>
     当前页<?php echo $page?>共<?php echo $sum_page?>
    <a href="javascript:void (0)" οnclick="page(1)">首页</a>
    <a href="javascript:void (0)" οnclick="page(<?php echo $last?>)">上一页</a>
    <a href="javascript:void (0)" οnclick="page(<?php echo $next?>)">下一页</a>
    <a href="javascript:void (0)" οnclick="page(<?php echo $sum_page?>)">尾页</a>
    </div>
 <!-- 分页结束 -->

<script type="text/javascript">

// 分页
    function page(page){
        var search=document.getElementsByName('search')[0].value;
        var ajax=new XMLHttpRequest();
        ajax.open('get','{{url('business_list')}}?page='+page+'&search='+search);
        ajax.send();
        ajax.onreadystatechange=function(){
            //alert(msg);
            if(ajax.readyState==4&ajax.status==200){
                document.getElementById('div1').innerHTML=ajax.responseText;
            }

        }
    }

</script>