Laravel 5.4验证独特的问题

Question

I'm trying to update an user and when the email is already taken it will give an error, except when it's your own email. Right now my code is:

$user = User::find($id);

$input['email'] = request('email');

$rules = array('email' => 'unique:users,email,'.$user->id);

$validator = Validator::make($input, $rules);

if ($validator->fails()) {
    return back()->withInput()->withErrors(['email']);
}

This works perfectly fine, but now I want that it only gives an error if the email already exists AND from the found record the column 'function' = 'client', but I have no idea how to code this.

Answer 1

$count = User::where('email','=',request('email'))
        ->where('function','!=','client')
        ->count();

if($count){
    return back()->withInput()->withErrors(['email' => 'Email Already Exist']);
}

What will above code do :

Count users whose email is request_email and function is not client.

if $count is greater than 1 that means duplicate email.

Return with error that Email Already Exist