如何在laravel 8中添加带有where条件的验证规则

Question

$validatedData = $this->validate($request, [
'ldate' => 'required',
'type' => 'required',
'daytype' => 'required',
'employee' => 'required', 'exists:leaves,bemployee'  //where condition i need here
'bemployee' => 'required',
'subject' => 'required',
'content' => 'required',
]);

这是我的验证。表名为Leaves。employee、bemployee和ldate是表中的字段。

如何在ldate=$ldate中检查员工是否存在为bemploye？

提前感谢

Answer 1

$valid= Validator::make($request, [
'contact'=> ['required',Rule::exists('tableName')->where(function ($query) use ($request) {
$query->where('column',$request->yourField);}),
],
],
);
if($valid->fails()){
// code
}else{
// code
}