laravel框架中orwhere 多条件查询 如下:
$data = DB::table('group')
->join('group_users as gu','group.group_id','=','gu.group_id')
->where(['gu.user_id'=>$uid])
->where(function($query){
$query->where('is_super',1)
->orwhere(function($query){
$query->where('is_super',2);
});
})
->orderBy('group.group_id', 'desc')
->select('group.group_id','group.group_name','group.type_id','group.logo')
->get();
$customer_info=DB::table('customer as c')
->leftJoin('customer_details as cd','c.customer_id','=','cd.customer_id')
->leftJoin('costomer_linkman as cl','c.customer_id','=','cl.customer_id')
->whereIn('c.user_id',$userIdarr)
->where($where_two)
->where(function($query){
$query->where('cd.deal_status',0)
->orwhere('cd.deal_status',null);
})
->where('c.customer_name','like','%'.$customer_name.'%')
->select('c.customer_id','c.user_id','c.customer_name','cl.linkman_phone','cd.intention_level_id','c.add_time')
->paginate($limit);