我有一個這樣的 postgresql 代碼，它運行正確，但我很困惑進入 laravel 模型
PostgreSQL :
select * from anggota a where id_parpol = 4 and a.nik in ('2816742691102816','8939799808489659','4757527446829790') or a.no_kta in ('2816742691102816','8939799808489659','4757527446829790')
anggota控制器：
$aa = "2816742691102816,8939799808489659,4757527446829790";
$bb = explode(",", $aa);
$model = Anggota::where('id_parpol', Auth::user()->id_org)->whereIn('nik', $bb)->whereIn('no_kta', $bb)->get();
dd($model);
uj5u.com熱心網友回復：
您可以使用基于閉包的查詢分組
$model = Anggota::where('id_parpol', Auth::user()->id_org)
->where(function($query) use($bb){
$query->whereIn('nik', $bb)
->orWhereIn('no_kta', $bb);
})->get();
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/461961.html
標籤：拉拉维尔 PostgreSQL