Validation Rule

[chojisan]

How to validate unique email if encrypted?

[grafxflow]

A bit late in the day... but I found this works using a custom rule. The rule could actually work for any model.

use App\Rules\UniqueEncryptedEmail;
use App\Models\User;

protected function rules()
{
    return [
        'email' => ['required', 'email', new UniqueEncryptedEmail(User::class, 'email', 'email_index')],
    ];
}

<?php

namespace App\Rules;

use Illuminate\Contracts\Validation\Rule;

class UniqueEncryptedEmail implements Rule
{
    protected $model;

    protected $column;

    protected $indexName;

    public function __construct(string $model, string $column, string $indexName)
    {
        $this->model = $model;
        $this->column = $column;
        $this->indexName = $indexName;
    }

    public function passes($attribute, $value)
    {
        // Get the model instance
        $model = new $this->model;

        // Check if the encrypted email already exists
        return $model::whereBlind($this->column, $this->indexName, $value)->doesntExist();
    }

    public function message()
    {
        return 'The :attribute already exists.';
    }
}