快捷搜索: 王者荣耀 脱发

Laravel框架中 orwhere 多条件查询的使用

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);
经验分享 程序员 微信小程序 职场和发展