如何在函数中使用带3 where子句的Laravel？

Question

我有一个函数用3 where子句条件显示数据。但是这个输出是无效的。我有4个数据，只显示了1个。此函数如下所示：

public function alkes_user()
{
    $user_id = Auth::user()->id;

    $unit        = User::where('roles_id' , 1)->pluck('nama_unit', 'id'); 


    $alat    = Alat::with('users')
    ->where('jenis' ,'Alkes')
    ->where('user_id',  $user_id)
    ->where('is_active',  'true')
    ->orderBy('created_at', 'desc')->paginate(10);
    return view('users.alkes_user',['alat' => $alat , 'unit' => $unit ,'count' => $count ]);
}

这个数据只显示1，但在数据库中我有这么多的数据。有什么不对，如何解决？谢谢

Answer 1

$user_id = Auth::user()->id;
$unit = User::where('roles_id' , 1)->pluck('nama_unit', 'id');
$alat = Alat::with('users')->where([
        ['jenis' ,'=','Alkes'],
        ['user_id','=',$user_id],
        ['is_active','=','true']       
])->orderBy('created_at', 'desc')->paginate(10);
return view('users.alkes_user',['alat' => $alat , 'unit' => $unit ,'count' => $count ]);

Answer 2

简单解

$alat= Alat::with(array('users' => function($query) {
    $query->where([['jenis' ,'Alkes'],['user_id',  $user_id],[is_active',  'true']]);
}))->orderBy('created_at', 'desc')->paginate(10);

Answer 3

如果您想要多个where条件，请像这样重写您的查询：

public function alkes_user(){
    $user_id = Auth::user()->id;
    $unit = User::where('roles_id' , 1)->pluck('nama_unit', 'id');
    $alat    = Alat::with('users')
                ->where([['jenis' ,'Alkes'],['user_id',  $user_id],['is_active',  'true']])
                ->orderBy('created_at', 'desc')->paginate(10);
    return view('users.alkes_user',['alat' => $alat , 'unit' => $unit ,'count' => $count ]);
}