ahkmunna/validator

Laravel 5 composite unique validator

Composite Unique Validator

A muti-column unique validation extension with exception for Laravel 5.*, _(*1)

Installation

Install the package through Composer., _(*2)

On you project directory run the composer require command from the Terminal:, _(*3)

composer require ahkmunna/validator

Now add the service provider to your config/app.php file. Add this line to the providers array:, _(*4)

ahkmunna\validator\validatorServiceProvider::class

Translations

Run this command to move the translation file, _(*5)

php artisan vendor:publish

Error messages

Add this method in your validation request class, _(*6)

public function messages()
{
    return [
        'email.composite_unique' => trans('validator::validation.composite_unique'),
    ];
}

Now you're ready to start using the validator in your application., _(*7)

Use case 1

Like any laravel validation rules:, _(*8)

$rules = array(
    'field_name' => 'composite_unique:table, unique_column_1, unique_column_2, unique_column_3',
);

Use case 2

Pass a value or Check uniqueness with a field that not in current form request:, _(*9)

$rules = array(
    'field_name' => 'composite_unique:table, unique_column_1, unique_column_2:4, unique_column_3',
);

unique_column_2 is passed with a value so the validator will ignore the form request value and compare the field with the given value, It is useful sometimes, you can give a field name that not exist in the form request but in the database table., _(*10)

Use case 3

Check uniqueness with exception:, _(*11)

$rules = array(
    'field_name' => 'composite_unique:table, unique_column_1, unique_column_2, unique_column_3, 1',
);

The last parameter is a primary key of the table that row will be ignored. Useful for update operation., _(*12)

+++ Thank You +++