php - Laravel avoid insert duplication of consecutive from another table

I have a billing application, where I have a table for billings a table for billing numbering because the user can have more than one billing numbering and each numbering has its own consecutive, so when the user is going to create a billing he chooses the numbering, at the frontend the system shows the possible consecutive with which the billing will be created, is "possible" because if another user creates a billing before him, he will assign the consecutive. So the consecutive is finally assigned in the backend with this code:

...
$numbering = BillingNumbering::find($request->billing_numbering);

$number = $numbering->current_number + 1;

$billing->number = $number;
$numbering->current_number = $number;
$numbering->used = true;

$numbering->save();

$billing->save();
Copy code

Where first I get the billing numbering, get the current number and increase in one and immediately update the table for future requests.

The problem is that some cases when multiples users are working and save a billing almost at the same time the billing take the same billing number generating duplicates in billing consecutives.

How can I achieve this without number duplication?

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.