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

2 votes262 views3 answers
Laravel get auth user in constructor
PHP
0 vote254 views3 answers
Caculator
PHP
1 vote241 views1 answer
Laravel validation types for float
PHP
4 votes280 views2 answers
Delete all rows in table laravel
PHP Laravel
31 votes292 views1 answer
How to count the characters in laravel
PHP
85 votes301 views6 answers
Php replace string
PHP
0 vote267 views1 answer
Laravel collection diff
PHP Laravel
1 vote238 views1 answer
Change minutes in to hours carbon
PHP
0 vote267 views1 answer
Php mess detector laravel
PHP
0 vote317 views1 answer
How to run database Query in WordPress?
PHP Wordpress