firefly-iii / firefly-iii

app/Repositories/Journal/JournalAPIRepository.php

Indentation +3 added lines, -3 removed lines

@@ -56,9 +56,9 @@
     public function findTransaction(int $transactionId): ?Transaction
     {
         $transaction = Transaction::leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
-                                  ->where('transaction_journals.user_id', $this->user->id)
-                                  ->where('transactions.id', $transactionId)
-                                  ->first(['transactions.*']);
+                                    ->where('transaction_journals.user_id', $this->user->id)
+                                    ->where('transactions.id', $transactionId)
+                                    ->first(['transactions.*']);
 
         return $transaction;
     }

app/Repositories/Journal/JournalRepository.php

Indentation +1 added lines, -1 removed lines

@@ -570,7 +570,7 @@
             return new Carbon($cache->get()); // @codeCoverageIgnore
         }
         $entry = TransactionJournalMeta::where('transaction_journal_id', $journalId)
-                                       ->where('name', $field)->first();
+                                        ->where('name', $field)->first();
         if (null === $entry) {
             return null;
         }

app/Support/Steam.php

Indentation +38 added lines, -38 removed lines

@@ -63,18 +63,18 @@ 
 
         // first part: get all balances in own currency:
         $nativeBalance = (string)$account->transactions()
-                                         ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
-                                         ->where('transaction_journals.date', '<=', $date->format('Y-m-d 23:59:59'))
-                                         ->where('transactions.transaction_currency_id', $currency->id)
-                                         ->sum('transactions.amount');
+                                            ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
+                                            ->where('transaction_journals.date', '<=', $date->format('Y-m-d 23:59:59'))
+                                            ->where('transactions.transaction_currency_id', $currency->id)
+                                            ->sum('transactions.amount');
 
         // get all balances in foreign currency:
         $foreignBalance = (string)$account->transactions()
-                                          ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
-                                          ->where('transaction_journals.date', '<=', $date->format('Y-m-d'))
-                                          ->where('transactions.foreign_currency_id', $currency->id)
-                                          ->where('transactions.transaction_currency_id', '!=', $currency->id)
-                                          ->sum('transactions.foreign_amount');
+                                            ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
+                                            ->where('transaction_journals.date', '<=', $date->format('Y-m-d'))
+                                            ->where('transactions.foreign_currency_id', $currency->id)
+                                            ->where('transactions.transaction_currency_id', '!=', $currency->id)
+                                            ->sum('transactions.foreign_amount');
 
         $balance = bcadd($nativeBalance, $foreignBalance);
         $virtual = null === $account->virtual_balance ? '0' : (string)$account->virtual_balance;
@@ -109,18 +109,18 @@ 
 
         $currencyId    = (int)$repository->getMetaValue($account, 'currency_id');
         $nativeBalance = (string)$account->transactions()
-                                         ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
-                                         ->where('transaction_journals.date', '<=', $date->format('Y-m-d'))
-                                         ->where('transactions.transaction_currency_id', $currencyId)
-                                         ->sum('transactions.amount');
+                                            ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
+                                            ->where('transaction_journals.date', '<=', $date->format('Y-m-d'))
+                                            ->where('transactions.transaction_currency_id', $currencyId)
+                                            ->sum('transactions.amount');
 
         // get all balances in foreign currency:
         $foreignBalance = (string)$account->transactions()
-                                          ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
-                                          ->where('transaction_journals.date', '<=', $date->format('Y-m-d'))
-                                          ->where('transactions.foreign_currency_id', $currencyId)
-                                          ->where('transactions.transaction_currency_id', '!=', $currencyId)
-                                          ->sum('transactions.foreign_amount');
+                                            ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
+                                            ->where('transaction_journals.date', '<=', $date->format('Y-m-d'))
+                                            ->where('transactions.foreign_currency_id', $currencyId)
+                                            ->where('transactions.transaction_currency_id', '!=', $currencyId)
+                                            ->sum('transactions.foreign_amount');
         $balance        = bcadd($nativeBalance, $foreignBalance);
 
         $cache->store($balance);
@@ -177,23 +177,23 @@ 
 
         // query!
         $set = $account->transactions()
-                       ->leftJoin('transaction_journals', 'transactions.transaction_journal_id', '=', 'transaction_journals.id')
-                       ->where('transaction_journals.date', '>=', $start->format('Y-m-d 00:00:00'))
-                       ->where('transaction_journals.date', '<=', $end->format('Y-m-d  23:59:59'))
-                       ->groupBy('transaction_journals.date')
-                       ->groupBy('transactions.transaction_currency_id')
-                       ->groupBy('transactions.foreign_currency_id')
-                       ->orderBy('transaction_journals.date', 'ASC')
-                       ->whereNull('transaction_journals.deleted_at')
-                       ->get(
-                           [
-                               'transaction_journals.date',
-                               'transactions.transaction_currency_id',
-                               DB::raw('SUM(transactions.amount) AS modified'),
-                               'transactions.foreign_currency_id',
-                               DB::raw('SUM(transactions.foreign_amount) AS modified_foreign'),
-                           ]
-                       );
+                        ->leftJoin('transaction_journals', 'transactions.transaction_journal_id', '=', 'transaction_journals.id')
+                        ->where('transaction_journals.date', '>=', $start->format('Y-m-d 00:00:00'))
+                        ->where('transaction_journals.date', '<=', $end->format('Y-m-d  23:59:59'))
+                        ->groupBy('transaction_journals.date')
+                        ->groupBy('transactions.transaction_currency_id')
+                        ->groupBy('transactions.foreign_currency_id')
+                        ->orderBy('transaction_journals.date', 'ASC')
+                        ->whereNull('transaction_journals.deleted_at')
+                        ->get(
+                            [
+                                'transaction_journals.date',
+                                'transactions.transaction_currency_id',
+                                DB::raw('SUM(transactions.amount) AS modified'),
+                                'transactions.foreign_currency_id',
+                                DB::raw('SUM(transactions.foreign_amount) AS modified_foreign'),
+                            ]
+                        );
 
         $currentBalance = $startBalance;
         /** @var Transaction $entry */
@@ -402,9 +402,9 @@ 
         $list = [];
 
         $set = auth()->user()->transactions()
-                     ->whereIn('transactions.account_id', $accounts)
-                     ->groupBy(['transactions.account_id', 'transaction_journals.user_id'])
-                     ->get(['transactions.account_id', DB::raw('MAX(transaction_journals.date) AS max_date')]);
+                        ->whereIn('transactions.account_id', $accounts)
+                        ->groupBy(['transactions.account_id', 'transaction_journals.user_id'])
+                        ->get(['transactions.account_id', DB::raw('MAX(transaction_journals.date) AS max_date')]);
 
         foreach ($set as $entry) {
             $list[(int)$entry->account_id] = new Carbon($entry->max_date);