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

0 vote213 views1 answer
Wordpress function _() not working
PHP Wordpress
1 vote175 views2 answers
Php superglobal
PHP
8 votes182 views1 answer
Laravel command to create symlink storage
PHP
1 vote191 views1 answer
Php artisan serve a folder
PHP
13 votes182 views5 answers
Laravel validation custom message example
PHP
48 votes267 views6 answers
Create migration with model laravel
PHP Laravel
19 votes275 views5 answers
Get url php
PHP
0 vote175 views1 answer
Laravel send ajax
PHP
1 vote217 views2 answers
Index the string php
PHP
0 vote218 views1 answer
Add Empty Cart Button WooCommerce
PHP