Optimistic Locking Laravel

<?php

function transfer($fromAccountId, $toAccountId, $balance)
{
  $fromQuery = Account::whereId($fromAccountId);
  if (! $fromQuery->exists()) {
    throw new InvalidAccountException();
  }

  $toQuery = Account::whereId($toAccountId);
  if (! $toQuery->exists()) {
    throw new InvalidAccountException();
  }

  do {
    $fromAccount = $fromQuery->first();
    if ($fromAccount->balance < $amount) {
      throw new InsufficientBalanceException();
    }
    $updated = Account::whereId($fromAccountId)
      ->where('updated_at', '=', $fromAccount->updated_at)
      ->update(['balance' => $fromAccount->balance - $amount]);
  } while (! $updated);

  do {
    $toAccount = $toQuery->first();    
    $updated = Account::whereId($toAccountId)
      ->where('updated_at', '=', $toAccount->updated_at)
      ->update(['balance' => $toAccount->balance + $amount]);
  } while (! $updated);

  $transaction = new Transaction();
  $transaction->from_account_id = $fromAccountId;
  $transaction->to_account_id   = $toAccountId;
  $transaction->amount          = $amount;
  $transaction->save();
}

Source: gist.githubusercontent.com

Similar codes

3 votes309 views3 answers
Woocommerce order item get product id
PHP
15 votes302 views6 answers
Laravel create request
PHP Laravel
29 votes348 views6 answers
Laravel timestamp
PHP Laravel
0 vote284 views3 answers
Upload multiple files in codeigniter
PHP
7 votes315 views4 answers
Php info
PHP
26 votes359 views6 answers
Carbon in laravel
PHP Laravel
5 votes302 views3 answers
Check all php version installed ubuntu
PHP
0 vote295 views1 answer
Php date in italiano
PHP
10 votes347 views2 answers
Convert collection to array laravel
PHP Laravel
57 votes432 views6 answers
How to create migration in laravel
PHP Laravel