AccountRepository::latestJournal() - Code Metrics - Inspection of "Merge branch 'release/4.7.6.1'" - firefly-iii/firefly-iii - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( bae40e...a4cb2c )

by James

created 2018-09-03 08:26 UTC

AccountRepository::latestJournal() A

↳ Parent: Project

Complexity

Conditions	2
Paths	2

Size

Total Lines	14
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	10
dl	0
loc	14
rs	9.9332
c	0
b	0
f	0
cc	2
nc	2
nop	1

<?php
/**
 * AccountRepository.php
 * Copyright (c) 2017 [email protected]
 *
 * This file is part of Firefly III.
 *
 * Firefly III is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * Firefly III is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with Firefly III. If not, see <http://www.gnu.org/licenses/>.
 */
declare(strict_types=1);

namespace FireflyIII\Repositories\Account;

use Carbon\Carbon;
use FireflyIII\Exceptions\FireflyException;
use FireflyIII\Factory\AccountFactory;
use FireflyIII\Models\Account;
use FireflyIII\Models\AccountType;
use FireflyIII\Models\TransactionJournal;
use FireflyIII\Models\TransactionType;
use FireflyIII\Services\Internal\Destroy\AccountDestroyService;
use FireflyIII\Services\Internal\Update\AccountUpdateService;
use FireflyIII\User;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Support\Collection;
use Log;

/**
 * Class AccountRepository.
 * @SuppressWarnings(PHPMD.CouplingBetweenObjects)
 */
class AccountRepository implements AccountRepositoryInterface
{

    /** @var User */
    private $user;

    /**
     * Constructor.
     */
    public function __construct()
    {
        if ('testing' === env('APP_ENV')) {
            Log::warning(sprintf('%s should not be instantiated in the TEST environment!', \get_class($this)));
        }
    }

    /**
     * @param array $types
     *
     * @return int
     */
    public function count(array $types): int
    {
        return $this->user->accounts()->accountTypeIn($types)->count();
    }

    /**
     * Moved here from account CRUD.
     *
     * @param Account      $account
     * @param Account|null $moveTo
     *
     * @return bool
     *

     */
    public function destroy(Account $account, ?Account $moveTo): bool
    {
        /** @var AccountDestroyService $service */
        $service = app(AccountDestroyService::class);
        $service->destroy($account, $moveTo);

        return true;
    }

    /**
     * @param string $number
     * @param array  $types
     *
     * @return Account|null
     */
    public function findByAccountNumber(string $number, array $types): ?Account
    {
        $query = $this->user->accounts()
                            ->leftJoin('account_meta', 'account_meta.account_id', '=', 'accounts.id')
                            ->where('account_meta.name', 'accountNumber')
                            ->where('account_meta.data', json_encode($number));

        if (\count($types) > 0) {
            $query->leftJoin('account_types', 'accounts.account_type_id', '=', 'account_types.id');
            $query->whereIn('account_types.type', $types);
        }

        /** @var Collection $accounts */
        $accounts = $query->get(['accounts.*']);
        if ($accounts->count() > 0) {
            return $accounts->first();
        }

        return null;
    }

    /**
     * @param string $iban
     * @param array  $types
     *
     * @return Account|null
     */
    public function findByIbanNull(string $iban, array $types): ?Account
    {
        $query = $this->user->accounts()->where('iban', '!=', '')->whereNotNull('iban');

        if (\count($types) > 0) {
            $query->leftJoin('account_types', 'accounts.account_type_id', '=', 'account_types.id');
            $query->whereIn('account_types.type', $types);
        }

        $accounts = $query->get(['accounts.*']);
        /** @var Account $account */
        foreach ($accounts as $account) {
            if ($account->iban === $iban) {
                return $account;
            }
        }

        return null;
    }

    /**
     * @param string $name
     * @param array  $types
     *
     * @return Account|null
     */
    public function findByName(string $name, array $types): ?Account
    {
        $query = $this->user->accounts();

        if (\count($types) > 0) {
            $query->leftJoin('account_types', 'accounts.account_type_id', '=', 'account_types.id');
            $query->whereIn('account_types.type', $types);
        }
        Log::debug(sprintf('Searching for account named "%s" (of user #%d) of the following type(s)', $name, $this->user->id), ['types' => $types]);

        $accounts = $query->get(['accounts.*']);
        /** @var Account $account */
        foreach ($accounts as $account) {
            if ($account->name === $name) {
                Log::debug(sprintf('Found #%d (%s) with type id %d', $account->id, $account->name, $account->account_type_id));

                return $account;
            }
        }
        Log::debug(sprintf('There is no account with name "%s" of types', $name), $types);

        return null;
    }

    /**
     * @param int $accountId
     *
     * @return Account|null
     */
    public function findNull(int $accountId): ?Account
    {
        return $this->user->accounts()->find($accountId);
    }

    /**
     * Return account type or null if not found.
     *
     * @param string $type
     *
     * @return AccountType|null
     */
    public function getAccountTypeByType(string $type): ?AccountType
    {
        return AccountType::whereType($type)->first();
    }

    /**
     * @param array $accountIds
     *
     * @return Collection
     */
    public function getAccountsById(array $accountIds): Collection
    {
        /** @var Collection $result */
        $query = $this->user->accounts();

        if (\count($accountIds) > 0) {
            $query->whereIn('accounts.id', $accountIds);
        }

        $result = $query->get(['accounts.*']);
        $result = $result->sortBy(
            function (Account $account) {
                return strtolower($account->name);
            }
        );

        return $result;
    }

    /**
     * @param array $types
     *
     * @return Collection
     */
    public function getAccountsByType(array $types): Collection
    {
        /** @var Collection $result */
        $query = $this->user->accounts();
        if (\count($types) > 0) {
            $query->accountTypeIn($types);
        }

        $result = $query->get(['accounts.*']);
        $result = $result->sortBy(
            function (Account $account) {
                return strtolower($account->name);
            }
        );

        return $result;
    }

    /**
     * @param array $types
     *
     * @return Collection
     */
    public function getActiveAccountsByType(array $types): Collection
    {
        /** @var Collection $result */
        $query = $this->user->accounts()->with(
            ['accountmeta' => function (HasMany $query) {
                $query->where('name', 'accountRole');
            }]
        );
        if (\count($types) > 0) {
            $query->accountTypeIn($types);
        }
        $query->where('active', 1);
        $result = $query->get(['accounts.*']);
        $result = $result->sortBy(
            function (Account $account) {
                return sprintf('%02d', $account->account_type_id) . strtolower($account->name);
            }
        );

        return $result;
    }

    /**
     * @return Account
     *
     * @throws FireflyException
     */
    public function getCashAccount(): Account
    {
        /** @var AccountType $type */
        $type = AccountType::where('type', AccountType::CASH)->first();
        /** @var AccountFactory $factory */
        $factory = app(AccountFactory::class);
        $factory->setUser($this->user);

        return $factory->findOrCreate('Cash account', $type->type);
    }

    /**
     * @param $account
     *
     * @return string
     */
    public function getInterestPerDay(Account $account): string
    {
        $interest       = $this->getMetaValue($account, 'interest');
        $interestPeriod = $this->getMetaValue($account, 'interest_period');
        Log::debug(sprintf('Start with interest of %s percent', $interest));

        // calculate
        if ('monthly' === $interestPeriod) {
            $interest = bcdiv(bcmul($interest, '12'), '365'); // per year
            Log::debug(sprintf('Interest is now (monthly to daily) %s percent', $interest));
        }
        if ('yearly' === $interestPeriod) {
            $interest = bcdiv($interest, '365'); // per year
            Log::debug(sprintf('Interest is now (yearly to daily) %s percent', $interest));
        }

        return $interest;
    }

    /**
     * Return meta value for account. Null if not found.
     *
     * @param Account $account
     * @param string  $field
     *
     * @return null|string
     */
    public function getMetaValue(Account $account, string $field): ?string
    {
        foreach ($account->accountMeta as $meta) {
            if ($meta->name === $field) {
                return (string)$meta->data;
            }
        }

        return null;
    }

    /**
     * Get note text or null.
     *
     * @param Account $account
     *
     * @return null|string
     */
    public function getNoteText(Account $account): ?string
    {
        $note = $account->notes()->first();

        if (null === $note) {
            return null;
        }

        return $note->text;
    }

    /**
     * Returns the amount of the opening balance for this account.
     *
     * @param Account $account
     *
     * @return string
     */
    public function getOpeningBalanceAmount(Account $account): ?string
    {

        $journal = TransactionJournal::leftJoin('transactions', 'transactions.transaction_journal_id', '=', 'transaction_journals.id')
                                     ->where('transactions.account_id', $account->id)
                                     ->transactionTypes([TransactionType::OPENING_BALANCE])
                                     ->first(['transaction_journals.*']);
        if (null === $journal) {
            return null;
        }
        $transaction = $journal->transactions()->where('account_id', $account->id)->first();
        if (null === $transaction) {
            return null;
        }

        return (string)$transaction->amount;
    }

    /**
     * Return date of opening balance as string or null.
     *
     * @param Account $account
     *
     * @return null|string
     */
    public function getOpeningBalanceDate(Account $account): ?string
    {
        $journal = TransactionJournal::leftJoin('transactions', 'transactions.transaction_journal_id', '=', 'transaction_journals.id')
                                     ->where('transactions.account_id', $account->id)
                                     ->transactionTypes([TransactionType::OPENING_BALANCE])
                                     ->first(['transaction_journals.*']);
        if (null === $journal) {
            return null;
        }

        return $journal->date->format('Y-m-d');
    }

    /**
     * @param Account $account
     *
     * @return Account|null
     *
     * @throws FireflyException
     */
    public function getReconciliation(Account $account): ?Account
    {
        if (AccountType::ASSET !== $account->accountType->type) {
            throw new FireflyException(sprintf('%s is not an asset account.', $account->name));
        }
        $name = $account->name . ' reconciliation';
        /** @var AccountType $type */
        $type     = AccountType::where('type', AccountType::RECONCILIATION)->first();
        $accounts = $this->user->accounts()->where('account_type_id', $type->id)->get();
        /** @var Account $current */
        foreach ($accounts as $current) {
            if ($current->name === $name) {
                return $current;
            }
        }
        /** @var AccountFactory $factory */
        $factory = app(AccountFactory::class);
        $factory->setUser($account->user);
        $account = $factory->findOrCreate($name, $type->type);

        return $account;
    }

    /**
     * @param Account $account
     *
     * @return bool
     */
    public function isLiability(Account $account): bool
    {
        return \in_array($account->accountType->type, [AccountType::CREDITCARD, AccountType::LOAN, AccountType::DEBT, AccountType::MORTGAGE], true);
    }

    /**
     * Returns the date of the very last transaction in this account.
     *
     * @param Account $account
     *
     * @return TransactionJournal|null
     */
    public function latestJournal(Account $account): ?TransactionJournal
    {
        $first = $account->transactions()
                         ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
                         ->orderBy('transaction_journals.date', 'DESC')
                         ->orderBy('transaction_journals.order', 'ASC')
                         ->where('transaction_journals.user_id', $this->user->id)
                         ->orderBy('transaction_journals.id', 'DESC')
                         ->first(['transaction_journals.id']);
        if (null !== $first) {
            return TransactionJournal::find((int)$first->id);
        }

        return null;
    }

    /**
     * Returns the date of the very last transaction in this account.
     *
     * @param Account $account
     *
     * @return Carbon|null
     */
    public function latestJournalDate(Account $account): ?Carbon
    {
        $result  = null;
        $journal = $this->latestJournal($account);
        if (null !== $journal) {
            $result = $journal->date;
        }

        return $result;
    }

    /**
     * Returns the date of the very first transaction in this account.
     *
     * @param Account $account
     *
     * @return TransactionJournal|null
     */
    public function oldestJournal(Account $account): ?TransactionJournal
    {
        $first = $account->transactions()
                         ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
                         ->orderBy('transaction_journals.date', 'ASC')
                         ->orderBy('transaction_journals.order', 'DESC')
                         ->where('transaction_journals.user_id', $this->user->id)
                         ->orderBy('transaction_journals.id', 'ASC')
                         ->first(['transaction_journals.id']);
        if (null !== $first) {
            return TransactionJournal::find((int)$first->id);
        }

        return null;
    }

    /**
     * Returns the date of the very first transaction in this account.
     *
     * @param Account $account
     *
     * @return Carbon|null
     */
    public function oldestJournalDate(Account $account): ?Carbon
    {
        $result  = null;
        $journal = $this->oldestJournal($account);
        if (null !== $journal) {
            $result = $journal->date;
        }

        return $result;
    }

    /**
     * @param User $user
     */
    public function setUser(User $user): void
    {
        $this->user = $user;
    }

    /**
     * @param array $data
     *
     * @return Account
     * @throws \FireflyIII\Exceptions\FireflyException
     */
    public function store(array $data): Account
    {
        /** @var AccountFactory $factory */
        $factory = app(AccountFactory::class);
        $factory->setUser($this->user);

        return $factory->create($data);
    }

    /**
     * @param Account $account
     * @param array   $data
     *
     * @return Account
     * @throws \FireflyIII\Exceptions\FireflyException
     * @throws FireflyException
     * @throws FireflyException
     */
    public function update(Account $account, array $data): Account
    {
        /** @var AccountUpdateService $service */
        $service = app(AccountUpdateService::class);
        $account = $service->update($account, $data);

        return $account;
    }
}


1			<?php
2			/**
3			* AccountRepository.php
4			* Copyright (c) 2017 [email protected]
5			*
6			* This file is part of Firefly III.
7			*
8			* Firefly III is free software: you can redistribute it and/or modify
9			* it under the terms of the GNU General Public License as published by
10			* the Free Software Foundation, either version 3 of the License, or
11			* (at your option) any later version.
12			*
13			* Firefly III is distributed in the hope that it will be useful,
14			* but WITHOUT ANY WARRANTY; without even the implied warranty of
15			* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16			* GNU General Public License for more details.
17			*
18			* You should have received a copy of the GNU General Public License
19			* along with Firefly III. If not, see <http://www.gnu.org/licenses/>.
20			*/
21			declare(strict_types=1);
22
23			namespace FireflyIII\Repositories\Account;
24
25			use Carbon\Carbon;
26			use FireflyIII\Exceptions\FireflyException;
27			use FireflyIII\Factory\AccountFactory;
28			use FireflyIII\Models\Account;
29			use FireflyIII\Models\AccountType;
30			use FireflyIII\Models\TransactionJournal;
31			use FireflyIII\Models\TransactionType;
32			use FireflyIII\Services\Internal\Destroy\AccountDestroyService;
33			use FireflyIII\Services\Internal\Update\AccountUpdateService;
34			use FireflyIII\User;
35			use Illuminate\Database\Eloquent\Relations\HasMany;
36			use Illuminate\Support\Collection;
37			use Log;
38
39			/**
40			* Class AccountRepository.
41			* @SuppressWarnings(PHPMD.CouplingBetweenObjects)
42			*/
43			class AccountRepository implements AccountRepositoryInterface
44			{
45
46			/** @var User */
47			private $user;
48
49			/**
50			* Constructor.
51			*/
52			public function __construct()
53			{
54			if ('testing' === env('APP_ENV')) {
55			Log::warning(sprintf('%s should not be instantiated in the TEST environment!', \get_class($this)));
56			}
57			}
58
59			/**
60			* @param array $types
61			*
62			* @return int
63			*/
64			public function count(array $types): int
65			{
66			return $this->user->accounts()->accountTypeIn($types)->count();
67			}
68
69			/**
70			* Moved here from account CRUD.
71			*
72			* @param Account $account
73			* @param Account\|null $moveTo
74			*
75			* @return bool
76			*
77
78			*/
79			public function destroy(Account $account, ?Account $moveTo): bool
80			{
81			/** @var AccountDestroyService $service */
82			$service = app(AccountDestroyService::class);
83			$service->destroy($account, $moveTo);
84
85			return true;
86			}
87
88			/**
89			* @param string $number
90			* @param array $types
91			*
92			* @return Account\|null
93			*/
94			public function findByAccountNumber(string $number, array $types): ?Account
95			{
96			$query = $this->user->accounts()
97			->leftJoin('account_meta', 'account_meta.account_id', '=', 'accounts.id')
98			->where('account_meta.name', 'accountNumber')
99			->where('account_meta.data', json_encode($number));
100
101			if (\count($types) > 0) {
102			$query->leftJoin('account_types', 'accounts.account_type_id', '=', 'account_types.id');
103			$query->whereIn('account_types.type', $types);
104			}
105
106			/** @var Collection $accounts */
107			$accounts = $query->get(['accounts.*']);
108			if ($accounts->count() > 0) {
109			return $accounts->first();
110			}
111
112			return null;
113			}
114
115			/**
116			* @param string $iban
117			* @param array $types
118			*
119			* @return Account\|null
120			*/
121			public function findByIbanNull(string $iban, array $types): ?Account
122			{
123			$query = $this->user->accounts()->where('iban', '!=', '')->whereNotNull('iban');
124
125			if (\count($types) > 0) {
126			$query->leftJoin('account_types', 'accounts.account_type_id', '=', 'account_types.id');
127			$query->whereIn('account_types.type', $types);
128			}
129
130			$accounts = $query->get(['accounts.*']);
131			/** @var Account $account */
132			foreach ($accounts as $account) {
133			if ($account->iban === $iban) {
134			return $account;
135			}
136			}
137
138			return null;
139			}
140
141			/**
142			* @param string $name
143			* @param array $types
144			*
145			* @return Account\|null
146			*/
147			public function findByName(string $name, array $types): ?Account
148			{
149			$query = $this->user->accounts();
150
151			if (\count($types) > 0) {
152			$query->leftJoin('account_types', 'accounts.account_type_id', '=', 'account_types.id');
153			$query->whereIn('account_types.type', $types);
154			}
155			Log::debug(sprintf('Searching for account named "%s" (of user #%d) of the following type(s)', $name, $this->user->id), ['types' => $types]);
156
157			$accounts = $query->get(['accounts.*']);
158			/** @var Account $account */
159			foreach ($accounts as $account) {
160			if ($account->name === $name) {
161			Log::debug(sprintf('Found #%d (%s) with type id %d', $account->id, $account->name, $account->account_type_id));
162
163			return $account;
164			}
165			}
166			Log::debug(sprintf('There is no account with name "%s" of types', $name), $types);
167
168			return null;
169			}
170
171			/**
172			* @param int $accountId
173			*
174			* @return Account\|null
175			*/
176			public function findNull(int $accountId): ?Account
177			{
178			return $this->user->accounts()->find($accountId);
179			}
180
181			/**
182			* Return account type or null if not found.
183			*
184			* @param string $type
185			*
186			* @return AccountType\|null
187			*/
188			public function getAccountTypeByType(string $type): ?AccountType
189			{
190			return AccountType::whereType($type)->first();
191			}
192
193			/**
194			* @param array $accountIds
195			*
196			* @return Collection
197			*/
198			public function getAccountsById(array $accountIds): Collection
199			{
200			/** @var Collection $result */
201			$query = $this->user->accounts();
202
203			if (\count($accountIds) > 0) {
204			$query->whereIn('accounts.id', $accountIds);
205			}
206
207			$result = $query->get(['accounts.*']);
208			$result = $result->sortBy(
209			function (Account $account) {
210			return strtolower($account->name);
211			}
212			);
213
214			return $result;
215			}
216
217			/**
218			* @param array $types
219			*
220			* @return Collection
221			*/
222			public function getAccountsByType(array $types): Collection
223			{
224			/** @var Collection $result */
225			$query = $this->user->accounts();
226			if (\count($types) > 0) {
227			$query->accountTypeIn($types);
228			}
229
230			$result = $query->get(['accounts.*']);
231			$result = $result->sortBy(
232			function (Account $account) {
233			return strtolower($account->name);
234			}
235			);
236
237			return $result;
238			}
239
240			/**
241			* @param array $types
242			*
243			* @return Collection
244			*/
245			public function getActiveAccountsByType(array $types): Collection
246			{
247			/** @var Collection $result */
248			$query = $this->user->accounts()->with(
249			['accountmeta' => function (HasMany $query) {
250			$query->where('name', 'accountRole');
251			}]
252			);
253			if (\count($types) > 0) {
254			$query->accountTypeIn($types);
255			}
256			$query->where('active', 1);
257			$result = $query->get(['accounts.*']);
258			$result = $result->sortBy(
259			function (Account $account) {
260			return sprintf('%02d', $account->account_type_id) . strtolower($account->name);
261			}
262			);
263
264			return $result;
265			}
266
267			/**
268			* @return Account
269			*
270			* @throws FireflyException
271			*/
272			public function getCashAccount(): Account
273			{
274			/** @var AccountType $type */
275			$type = AccountType::where('type', AccountType::CASH)->first();
276			/** @var AccountFactory $factory */
277			$factory = app(AccountFactory::class);
278			$factory->setUser($this->user);
279
280			return $factory->findOrCreate('Cash account', $type->type);
281			}
282
283			/**
284			* @param $account
285			*
286			* @return string
287			*/
288			public function getInterestPerDay(Account $account): string
289			{
290			$interest = $this->getMetaValue($account, 'interest');
291			$interestPeriod = $this->getMetaValue($account, 'interest_period');
292			Log::debug(sprintf('Start with interest of %s percent', $interest));
293
294			// calculate
295			if ('monthly' === $interestPeriod) {
296			$interest = bcdiv(bcmul($interest, '12'), '365'); // per year
297			Log::debug(sprintf('Interest is now (monthly to daily) %s percent', $interest));
298			}
299			if ('yearly' === $interestPeriod) {
300			$interest = bcdiv($interest, '365'); // per year
301			Log::debug(sprintf('Interest is now (yearly to daily) %s percent', $interest));
302			}
303
304			return $interest;
305			}
306
307			/**
308			* Return meta value for account. Null if not found.
309			*
310			* @param Account $account
311			* @param string $field
312			*
313			* @return null\|string
314			*/
315			public function getMetaValue(Account $account, string $field): ?string
316			{
317			foreach ($account->accountMeta as $meta) {
318			if ($meta->name === $field) {
319			return (string)$meta->data;
320			}
321			}
322
323			return null;
324			}
325
326			/**
327			* Get note text or null.
328			*
329			* @param Account $account
330			*
331			* @return null\|string
332			*/
333			public function getNoteText(Account $account): ?string
334			{
335			$note = $account->notes()->first();
336
337			if (null === $note) {
338			return null;
339			}
340
341			return $note->text;
342			}
343
344			/**
345			* Returns the amount of the opening balance for this account.
346			*
347			* @param Account $account
348			*
349			* @return string
350			*/
351			public function getOpeningBalanceAmount(Account $account): ?string
352			{
353
354			$journal = TransactionJournal::leftJoin('transactions', 'transactions.transaction_journal_id', '=', 'transaction_journals.id')
355			->where('transactions.account_id', $account->id)
356			->transactionTypes([TransactionType::OPENING_BALANCE])
357			->first(['transaction_journals.*']);
358			if (null === $journal) {
359			return null;
360			}
361			$transaction = $journal->transactions()->where('account_id', $account->id)->first();
362			if (null === $transaction) {
363			return null;
364			}
365
366			return (string)$transaction->amount;
367			}
368
369			/**
370			* Return date of opening balance as string or null.
371			*
372			* @param Account $account
373			*
374			* @return null\|string
375			*/
376			public function getOpeningBalanceDate(Account $account): ?string
377			{
378			$journal = TransactionJournal::leftJoin('transactions', 'transactions.transaction_journal_id', '=', 'transaction_journals.id')
379			->where('transactions.account_id', $account->id)
380			->transactionTypes([TransactionType::OPENING_BALANCE])
381			->first(['transaction_journals.*']);
382			if (null === $journal) {
383			return null;
384			}
385
386			return $journal->date->format('Y-m-d');
387			}
388
389			/**
390			* @param Account $account
391			*
392			* @return Account\|null
393			*
394			* @throws FireflyException
395			*/
396			public function getReconciliation(Account $account): ?Account
397			{
398			if (AccountType::ASSET !== $account->accountType->type) {
399			throw new FireflyException(sprintf('%s is not an asset account.', $account->name));
400			}
401			$name = $account->name . ' reconciliation';
402			/** @var AccountType $type */
403			$type = AccountType::where('type', AccountType::RECONCILIATION)->first();
404			$accounts = $this->user->accounts()->where('account_type_id', $type->id)->get();
405			/** @var Account $current */
406			foreach ($accounts as $current) {
407			if ($current->name === $name) {
408			return $current;
409			}
410			}
411			/** @var AccountFactory $factory */
412			$factory = app(AccountFactory::class);
413			$factory->setUser($account->user);
414			$account = $factory->findOrCreate($name, $type->type);
415
416			return $account;
417			}
418
419			/**
420			* @param Account $account
421			*
422			* @return bool
423			*/
424			public function isLiability(Account $account): bool
425			{
426			return \in_array($account->accountType->type, [AccountType::CREDITCARD, AccountType::LOAN, AccountType::DEBT, AccountType::MORTGAGE], true);
427			}
428
429			/**
430			* Returns the date of the very last transaction in this account.
431			*
432			* @param Account $account
433			*
434			* @return TransactionJournal\|null
435			*/
436			public function latestJournal(Account $account): ?TransactionJournal
437			{
438			$first = $account->transactions()
439			->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
440			->orderBy('transaction_journals.date', 'DESC')
441			->orderBy('transaction_journals.order', 'ASC')
442			->where('transaction_journals.user_id', $this->user->id)
443			->orderBy('transaction_journals.id', 'DESC')
444			->first(['transaction_journals.id']);
445			if (null !== $first) {
446			return TransactionJournal::find((int)$first->id);
447			}
448
449			return null;
450			}
451
452			/**
453			* Returns the date of the very last transaction in this account.
454			*
455			* @param Account $account
456			*
457			* @return Carbon\|null
458			*/
459			public function latestJournalDate(Account $account): ?Carbon
460			{
461			$result = null;
462			$journal = $this->latestJournal($account);
463			if (null !== $journal) {
464			$result = $journal->date;
465			}
466
467			return $result;
468			}
469
470			/**
471			* Returns the date of the very first transaction in this account.
472			*
473			* @param Account $account
474			*
475			* @return TransactionJournal\|null
476			*/
477			public function oldestJournal(Account $account): ?TransactionJournal
478			{
479			$first = $account->transactions()
480			->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'transactions.transaction_journal_id')
481			->orderBy('transaction_journals.date', 'ASC')
482			->orderBy('transaction_journals.order', 'DESC')
483			->where('transaction_journals.user_id', $this->user->id)
484			->orderBy('transaction_journals.id', 'ASC')
485			->first(['transaction_journals.id']);
486			if (null !== $first) {
487			return TransactionJournal::find((int)$first->id);
488			}
489
490			return null;
491			}
492
493			/**
494			* Returns the date of the very first transaction in this account.
495			*
496			* @param Account $account
497			*
498			* @return Carbon\|null
499			*/
500			public function oldestJournalDate(Account $account): ?Carbon
501			{
502			$result = null;
503			$journal = $this->oldestJournal($account);
504			if (null !== $journal) {
505			$result = $journal->date;
506			}
507
508			return $result;
509			}
510
511			/**
512			* @param User $user
513			*/
514			public function setUser(User $user): void
515			{
516			$this->user = $user;
517			}
518
519			/**
520			* @param array $data
521			*
522			* @return Account
523			* @throws \FireflyIII\Exceptions\FireflyException
524			*/
525			public function store(array $data): Account
526			{
527			/** @var AccountFactory $factory */
528			$factory = app(AccountFactory::class);
529			$factory->setUser($this->user);
530
531			return $factory->create($data);
532			}
533
534			/**
535			* @param Account $account
536			* @param array $data
537			*
538			* @return Account
539			* @throws \FireflyIII\Exceptions\FireflyException
540			* @throws FireflyException
541			* @throws FireflyException
542			*/
543			public function update(Account $account, array $data): Account
544			{
545			/** @var AccountUpdateService $service */
546			$service = app(AccountUpdateService::class);
547			$account = $service->update($account, $data);
548
549			return $account;
550			}
551			}
552

firefly-iii / firefly-iii

GitHub Access Token became invalid

Push — master ( bae40e...a4cb2c )

AccountRepository::latestJournal() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like