laravel 条件查询限制和分页 查询

 

//查询10条数据

\DB::table('users')
    -> where('id', '>=', $id)
    -> orderBy('id','desc')
    -> take(10)
    -> get();

 

//分页和连表查询

 

$member=\App\MemberModel::leftjoin('ys_employee','ys_employee.user_id','=','ys_member.invite_id')
   ->leftjoin('ys_invite_member','ys_invite_member.user_id','=','ys_member.user_id')
   ->select('ys_member.*','ys_employee.agency_id')
   ->orderBy('ys_member.created_at','desc');

$search=[];
if ($request->start != ''){
   $member->where('ys_member.created_at','>=',$request->start.' 00:00:00');
   $search['start']=$request->start;
}
if ($request->end != ''){
   $member->where('ys_member.created_at','<',$request->end.' 59:59:59');
   $search['end']=$request->end;
}
if ($request->mobile != ""){
   $member->where('ys_member.mobile','like','%'.$request->mobile.'%');
   $search['mobile']=$request->mobile;
}
if ($request->name != ""){
   $member->where('ys_member.name','like','%'.$request->name.'%');
   $search['name']=$request->name;
}
if ($request->agency != ''){
   $member->where('ys_employee.agency_id','=',$request->agency);
   $search['agency']=$request->agency;
}
$data = $member ->paginate(10);

 

页面里面 

<div class="box-footer clearfix">会员：{{$data->total()}}人<br>
   {!! $data->appends($search)->render() !!}

 

接口数据分页 每页显示几条

 

       $start = $request->page <= 1 ? 0 : ($request->page - 1) * 10;//分页
        //获取首页  新品上线（10个最新产品即可）
        $new_goods = \DB::table('ys_goods as a')
                        ->leftjoin('ys_goods_extend as b','a.id','=','b.goods_id')
                        ->leftjoin('ys_goods_image as c','a.id','=','c.goods_id')
                        ->select('a.id as goods_id','a.name as goods_name','b.name as spec_name',
                            'b.market_price','b.price','b.id as ext_id','c.image')
                        ->where('a.state',1) //0下架1上架
                        ->groupBy('a.id')
       
                        ->orderBy('a.id','desc') //也就是时间顺序，倒序

                        ->skip($start)
                        ->take(10)
                        ->get();