仅当兄弟字段相同时，Laravel唯一值验证

Question

Could someone please help to understand how to create store method validation in Laravel for the table with the current structure.

Schema::create('product_areas', function (Blueprint $table) {
    $table->increments('id');
    $table->integer('area_id')->unsigned();
    $table->integer('product_id')->unsigned();
});

The area_id field must be unique only when it has the same product_id within the same model.

This should be possible:

['id' => 1, 'area_id' => 1, 'product_id' => 1]
['id' => 2, 'area_id'=> 1, 'product_id' => 2]

Where this should throw an error:

['id' => 1, 'area_id' => 1, 'product_id' => 1]
['id' => 2, 'area_id'=> 1, 'product_id' => 1]

I have read the documentation but have not found similar scenario. I have very little idea of how this could be implemented.

Thank you all in advance.

Answer 1

You can conditionally add a validation rule:

$v = Validator::make($data, [
    'area_id' => 'required|integer',
    'product_id' => 'required|integer',
]);

$v->sometimes('area_id', 'unique:product_areas', function ($input) {
    $products = \App\Product::where('id', $input->product_id)->count();
    return $products > 0;
});

The above logic will only apply the rule for area_id when the product_id returns at least one entry from the database. Here's the relevant documentation. You can also add a new validation rule, but I think the above may suffice in your case.