firefly-iii / firefly-iii

app/Console/Commands/UpgradeDatabase.php

Indentation +11 added lines, -11 removed lines

@@ -269,10 +269,10 @@ 
             return;
         }
         $subQuery = TransactionJournal::leftJoin('transactions', 'transactions.transaction_journal_id', '=', 'transaction_journals.id')
-                                      ->whereNull('transaction_journals.deleted_at')
-                                      ->whereNull('transactions.deleted_at')
-                                      ->groupBy(['transaction_journals.id'])
-                                      ->select(['transaction_journals.id', DB::raw('COUNT(transactions.id) AS t_count')]);
+                                        ->whereNull('transaction_journals.deleted_at')
+                                        ->whereNull('transactions.deleted_at')
+                                        ->groupBy(['transaction_journals.id'])
+                                        ->select(['transaction_journals.id', DB::raw('COUNT(transactions.id) AS t_count')]);
         /** @noinspection PhpStrictTypeCheckingInspection */
         $result     = DB::table(DB::raw('(' . $subQuery->toSql() . ') AS derived'))
                         ->mergeBindings($subQuery->getQuery())
@@ -300,7 +300,7 @@ 
         Log::debug(sprintf('System default currency is "%s"', $defaultConfig));
 
         $accounts = Account::leftJoin('account_types', 'account_types.id', '=', 'accounts.account_type_id')
-                           ->whereIn('account_types.type', [AccountType::DEFAULT, AccountType::ASSET])->get(['accounts.*']);
+                            ->whereIn('account_types.type', [AccountType::DEFAULT, AccountType::ASSET])->get(['accounts.*']);
         /** @var AccountRepositoryInterface $repository */
         $repository = app(AccountRepositoryInterface::class);
         $accounts->each(
@@ -386,9 +386,9 @@ 
                 // get the transaction with the asset account in it:
                 /** @var Transaction $transaction */
                 $transaction = $journal->transactions()
-                                       ->leftJoin('accounts', 'accounts.id', '=', 'transactions.account_id')
-                                       ->leftJoin('account_types', 'account_types.id', '=', 'accounts.account_type_id')
-                                       ->whereIn('account_types.type', [AccountType::DEFAULT, AccountType::ASSET])->first(['transactions.*']);
+                                        ->leftJoin('accounts', 'accounts.id', '=', 'transactions.account_id')
+                                        ->leftJoin('account_types', 'account_types.id', '=', 'accounts.account_type_id')
+                                        ->whereIn('account_types.type', [AccountType::DEFAULT, AccountType::ASSET])->first(['transactions.*']);
                 if (null === $transaction) {
                     return;
                 }
@@ -633,9 +633,9 @@ 
             try {
                 /** @var Transaction $opposing */
                 $opposing = Transaction::where('transaction_journal_id', $journalId)
-                                       ->where('amount', $amount)->where('identifier', '=', 0)
-                                       ->whereNotIn('id', $processed)
-                                       ->first();
+                                        ->where('amount', $amount)->where('identifier', '=', 0)
+                                        ->whereNotIn('id', $processed)
+                                        ->first();
             } catch (QueryException $e) {
                 Log::error($e->getMessage());
                 $this->error('Firefly III could not find the "identifier" field in the "transactions" table.');

Spacing +6 added lines, -6 removed lines

@@ -274,7 +274,7 @@ 
                                       ->groupBy(['transaction_journals.id'])
                                       ->select(['transaction_journals.id', DB::raw('COUNT(transactions.id) AS t_count')]);
         /** @noinspection PhpStrictTypeCheckingInspection */
-        $result     = DB::table(DB::raw('(' . $subQuery->toSql() . ') AS derived'))
+        $result = DB::table(DB::raw('(' . $subQuery->toSql() . ') AS derived'))
                         ->mergeBindings($subQuery->getQuery())
                         ->where('t_count', '>', 2)
                         ->select(['id', 't_count']);
@@ -304,7 +304,7 @@ 
         /** @var AccountRepositoryInterface $repository */
         $repository = app(AccountRepositoryInterface::class);
         $accounts->each(
-            function (Account $account) use ($repository, $defaultConfig) {
+            function(Account $account) use ($repository, $defaultConfig) {
                 $repository->setUser($account->user);
                 // get users preference, fall back to system pref.
 
@@ -382,7 +382,7 @@ 
             ->get(['transaction_journals.*']);
 
         $set->each(
-            function (TransactionJournal $journal) use ($repository, $accountRepos) {
+            function(TransactionJournal $journal) use ($repository, $accountRepos) {
                 // get the transaction with the asset account in it:
                 /** @var Transaction $transaction */
                 $transaction = $journal->transactions()
@@ -401,7 +401,7 @@ 
                 }
                 $transactions = $journal->transactions()->get();
                 $transactions->each(
-                    function (Transaction $transaction) use ($currency) {
+                    function(Transaction $transaction) use ($currency) {
                         if (null === $transaction->transaction_currency_id) {
                             $transaction->transaction_currency_id = $currency->id;
                             $transaction->save();
@@ -442,12 +442,12 @@ 
             ->get(['transaction_journals.*']);
 
         $set->each(
-            function (TransactionJournal $transfer) {
+            function(TransactionJournal $transfer) {
                 // select all "source" transactions:
                 /** @var Collection $transactions */
                 $transactions = $transfer->transactions()->where('amount', '<', 0)->get();
                 $transactions->each(
-                    function (Transaction $transaction) {
+                    function(Transaction $transaction) {
                         $this->updateTransactionCurrency($transaction);
                         $this->updateJournalCurrency($transaction);
                     }