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.');