jaulz / laravel-model-exists-rule

Laravel validation rule to check if a model exists

Laravel Model Exists Rule

Laravel validation rule to check if a model exists.

You want to use this rule if the standard laravel Rule::exists('table', 'column') is not powerful enough. When you want to add joins to your exist rule, or the advanced Eloquent\Builder features like whereHas this might be for you.

Installation

You can install the package via composer:

composer require mvanduijker/laravel-model-exists-rule

Usage

Simple

<?php

use Duijker\LaravelModelExistsRule\ModelExists;
use Illuminate\Foundation\Http\FormRequest;

class ExampleUserRequest extends FormRequest
{
    public function rules()
    {
        return [
            'user_id' => [
                'required',
                new ModelExists(\App\Models\User::class, 'id'),        
            ],
        ];
    }
}

Advanced

<?php

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Foundation\Http\FormRequest;
use Illuminate\Validation\Rule;

class ExampleUserRequest extends FormRequest
{
    public function rules()
    {
        return [
            'user_id' => [
                'required',
                Rule::modelExists(\App\Models\User::class, 'id', function (Builder $query) {
                    $query->whereHas('role', function (Builder $query) {
                        $query->whereIn('name', ['super-admin', 'admin']);
                    });                    
                }),        
            ],
        ];
    }
}

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Credits

• Mark van Duijker
• All Contributors

License

The MIT License (MIT). Please see License File for more information.