Check if name is unique among non-deleted items with laravel validation

Question

I have a simple form which posts to a controller which checks if a name for an item is already taken for a particular project. If it is, then it returns an error. This is the code I'm using for that:

'name'    => 'required|min:1|unique:versions,name,NULL,id,project_id,'.$project->id, 

The problem I've run into is that instead of a hard delete, I'm using a soft delete to remove them from the database, meaning that, for example, 'Test' can only be used as the name once, even after it's been deleted.

How can I make it check that it is unique for that project among the items that are not soft deleted?

Answer 1

You may try this:

'name' => 'required|min:1|unique:versions,name,NULL,id,deleted_at,NULL' 

This will make sure that the name in the versions table will be unique, if a record is soft deleted and has same name name then it won't be counted, means, name will be accepted even if there is a soft deleted record with the same name exists.

To ignore a model when updating, you should pass the id after name in the place of first NULL.

Update: Also you may use something like this to add your own custom rule:

// You can declare it inside your controller method before you run validation Validator::extend('unique_project', function($attribute, $value, $parameters) {    // $attribute will contain field name, i.e. name    // $value will contain the value in the $attribute/name    // $parameters will be an array of arguments passed    // i.e. [0] => arg1, [1] => arg2, [2] => arg3 and so on     return true for valid and false for invalid  }); 

You may use it like this:

'name' => 'required|min:1|unique_project:arg1,arg2,arg3' // add more args if needed