database - Laravel DB 查询生成器 "whereNotIn"到另一个表

Question

我如何在不使用 DB::raw(); 的情况下使用查询构建器将 whereNotIn 设置为另一个表的条件？

$query ="select * from project 
            where prj_usr_id= $user->id 
            and now()<prj_expiry 
            and prj_id not in(select bd_prj_id from bid where bd_status=1) 
            and prj_status='open' 
            order by prj_updated_date desc;

Answer 1

我用这个解决了。

$results = DB::table('project')
                        ->where('prj_usr_id',  '=' , 1 ) 
                        ->where('prj_status',  '=' , 'open' ) 
                        ->where('prj_expiry',  '<' , Carbon::Now() ) 
                        ->whereNotIn ('prj_id',function ($query)
                        {
                            $query->select(DB::raw(1))
                                    ->from('bid')
                                    ->where('bd_status',  '=' , '1' ) 
                                    ->get(['bd_prj_id']); 
                        })
                        ->orderBy('prj_updated_date', 'desc') 
                        ->paginate(5);
return  $results;