Laravel Validation, accepint 2 unique numbers in same row

[kgcusi]

I have an import of employees with a unique employee number, the problem I'm facing is when 2 rows have the same number, the import still continues.

This is my validation for my employee number.

'*.employee_number' => ['required', 'max:50', 'unique:employee_information,employee_number,NULL,id,company_id,'.Auth::user()->company_id],

Vision of the import file

Employee Number|
---------------------|
EMP1    //Accepts
---------------------|
EMP1    //Accepts too

The validation only runs when EMP1 is already existing before the import.

[patrickbrouwers]

Can only be validated if the entire the 2 rows are in the same batch (using batch inserts). You can always implement it yourself in the model() method.

[kgcusi]

I'm sorry but how do I achieve a query inside the model, and I think they should be inside the same batch since I'm just testing and the same employee number are @ row 1 and 2

[patrickbrouwers]

Then probably your unique validation rule isn't correct. Maybe try stackoverlow/laracasts for help, it goes beyond the scope of this issue tracker, as it's Laravel functionality.

[kgcusi]

This is a weird behaviour because I have also a web page to add an employee but it works fine. Which has the same validation

[kgcusi]

I removed the batchSize and it works, weird because the 2 same row are beside each other and should not be on seperate batches.

[patrickbrouwers]

The difference is that, with a web page, the employee already exists in the db, if they are in the same batch, you can't check for unique, because the batch is not in the database yet.