Skip to content

Firefly III: a personal finances manager

10.5 KB
Raw Blame
<?php

/**
 * JournalRepository.php
 * Copyright (c) 2019 [email protected]
 *
 * This file is part of Firefly III (https://github.com/firefly-iii).
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 *
 * This program 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 Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <https://www.gnu.org/licenses/>.
 */
declare(strict_types=1);

namespace FireflyIII\Repositories\Journal;

use Carbon\Carbon;
use FireflyIII\Exceptions\FireflyException;
use FireflyIII\Models\Account;
use FireflyIII\Models\Note;
use FireflyIII\Models\Transaction;
use FireflyIII\Models\TransactionGroup;
use FireflyIII\Models\TransactionJournal;
use FireflyIII\Models\TransactionJournalLink;
use FireflyIII\Models\TransactionJournalMeta;
use FireflyIII\Services\Internal\Destroy\JournalDestroyService;
use FireflyIII\Services\Internal\Destroy\TransactionGroupDestroyService;
use FireflyIII\Services\Internal\Update\JournalUpdateService;
use FireflyIII\Support\CacheProperties;
use FireflyIII\Support\Repositories\UserGroup\UserGroupInterface;
use FireflyIII\Support\Repositories\UserGroup\UserGroupTrait;
use Illuminate\Support\Collection;
use Override;

use function Safe\json_encode;

/**
 * Class JournalRepository.
 */
class JournalRepository implements JournalRepositoryInterface, UserGroupInterface
{
    use UserGroupTrait;

    #[Override]
    public function countByDescription(string $value, bool $includeDeleted): int
    {
        $search = $this->user->transactionJournals()->where('description', $value);
        if ($includeDeleted) {
            $search->withTrashed();
        }

        return $search->count();
    }

    #[Override]
    public function countByMeta(string $field, string $value, bool $includeDeleted): int
    {
        $search = TransactionJournalMeta::leftJoin('transaction_journals', 'transaction_journals.id', '=', 'journal_meta.transaction_journal_id')
            ->where('name', $field)
            ->where('data', json_encode($value))
            ->where('transaction_journals.user_id', $this->user->id)
        ;
        if ($includeDeleted) {
            $search->withTrashed();
        }

        return $search->count();
    }

    #[Override]
    public function countByNotes(string $value, bool $includeDeleted): int
    {
        $search = Note::query()
            ->where('noteable_type', TransactionJournal::class)
            ->leftJoin('transaction_journals', 'transaction_journals.id', '=', 'notes.noteable_id')
            ->where('transaction_journals.user_id', $this->user->id)
            ->where('text', 'LIKE', sprintf('%%%s%%', $value))
        ;
        if ($includeDeleted) {
            $search->withTrashed();
        }

        return $search->count();
    }

    public function destroyGroup(TransactionGroup $transactionGroup): void
    {
        /** @var TransactionGroupDestroyService $service */
        $service = app(TransactionGroupDestroyService::class);
        $service->destroy($transactionGroup);
    }

    public function destroyJournal(TransactionJournal $journal): void
    {
        /** @var JournalDestroyService $service */
        $service = app(JournalDestroyService::class);
        $service->destroy($journal);
    }

    /**
     * Find a specific journal.
     */
    public function find(int $journalId): ?TransactionJournal
    {
        /** @var null|TransactionJournal */
        return $this->user->transactionJournals()->find($journalId);
    }

    public function findByType(array $types): Collection
    {
        return $this->user->transactionJournals()
            ->leftJoin('transaction_types', 'transaction_types.id', '=', 'transaction_journals.transaction_type_id')
            ->whereIn('transaction_types.type', $types)
            ->get(['transaction_journals.*'])
        ;
    }

    /**
     * Get users first transaction journal or NULL.
     */
    public function firstNull(): ?TransactionJournal
    {
        /** @var null|TransactionJournal */
        return $this->user->transactionJournals()->orderBy('date', 'ASC')->first(['transaction_journals.*']);
    }

    #[Override]
    public function getAllUncompletedJournals(): Collection
    {
        if (null === $this->userGroup) {
            return TransactionJournal::query()->where('completed', false)->get(['transaction_journals.*']);
        }

        return $this->userGroup->transactionJournals()->where('completed', false)->get(['transaction_journals.*']);
    }

    public function getDestinationAccount(TransactionJournal $journal): Account
    {
        /** @var null|Transaction $transaction */
        $transaction = $journal->transactions()->with('account')->where('amount', '>', 0)->first();
        if (null === $transaction) {
            throw new FireflyException(sprintf('Your administration is broken. Transaction journal #%d has no destination transaction.', $journal->id));
        }

        /** @var null|Account $res */
        $res         = $transaction->account;
        if (null === $res) {
            throw new FireflyException('Account is unexpectedly NULL.');
        }

        return $res;
    }

    /**
     * Return total amount of journal. Is always positive.
     */
    public function getJournalTotal(TransactionJournal $journal): string
    {
        $cache  = new CacheProperties();
        $cache->addProperty($journal->id);
        $cache->addProperty('amount-positive');
        if ($cache->has()) {
            return $cache->get();
        }

        // saves on queries:
        $amount = $journal->transactions()->where('amount', '>', 0)->get()->sum('amount');
        $amount = (string) $amount;
        $cache->store($amount);

        return $amount;
    }

    public function getLast(): ?TransactionJournal
    {
        /** @var null|TransactionJournal */
        return $this->user->transactionJournals()->orderBy('date', 'DESC')->first(['transaction_journals.*']);
    }

    public function getLinkNoteText(TransactionJournalLink $link): string
    {
        /** @var null|Note $note */
        $note = $link->notes()->first();

        return (string) $note?->text;
    }

    /**
     * Return Carbon value of a meta field (or NULL).
     */
    public function getMetaDateById(int $journalId, string $field): ?Carbon
    {
        $cache = new CacheProperties();
        $cache->addProperty('journal-meta-updated');
        $cache->addProperty($journalId);
        $cache->addProperty($field);

        if ($cache->has()) {
            return new Carbon($cache->get());
        }
        $entry = TransactionJournalMeta::query()->where('transaction_journal_id', $journalId)->where('name', $field)->first();
        if (null === $entry) {
            return null;
        }
        $value = new Carbon($entry->data);
        $cache->store($entry->data);

        return $value;
    }

    public function getSourceAccount(TransactionJournal $journal): Account
    {
        /** @var null|Transaction $transaction */
        $transaction = $journal->transactions()->with('account')->where('amount', '<', 0)->first();
        if (null === $transaction) {
            throw new FireflyException(sprintf('Your administration is broken. Transaction journal #%d has no source transaction.', $journal->id));
        }

        /** @var null|Account $res */
        $res         = $transaction->account;
        if (null === $res) {
            throw new FireflyException('Account is unexpectedly NULL.');
        }

        return $res;
    }

    #[Override]
    public function getUncompletedJournals(): Collection
    {
        return $this->userGroup->transactionJournals()->where('completed', false)->get(['transaction_journals.*']);
    }

    #[Override]
    public function markAsCompleted(Collection $set): void
    {
        TransactionJournal::query()->whereIn('id', $set->pluck('id')->toArray())->update(['completed' => true]);
    }

    public function reconcileById(int $journalId): void
    {
        /** @var null|TransactionJournal $journal */
        $journal = $this->user->transactionJournals()->find($journalId);
        $journal?->transactions()->update(['reconciled' => true]);
    }

    /**
     * Search in journal descriptions.
     */
    public function searchJournalDescriptions(string $search, int $limit): Collection
    {
        $query = $this->user->transactionJournals()->orderBy('date', 'DESC')->orderBy('id', 'DESC')->orderBy('description', 'ASC');
        if ('' !== $search) {
            $query->whereLike('description', sprintf('%%%s%%', $search));
        }

        return $query->take($limit)->get();
    }

    public function unreconcileById(int $journalId): void
    {
        /** @var null|TransactionJournal $journal */
        $journal = $this->user->transactionJournals()->find($journalId);
        $journal?->transactions()->update(['reconciled' => false]);
    }

    /**
     * Update budget for a journal.
     */
    public function updateBudget(TransactionJournal $journal, int $budgetId): TransactionJournal
    {
        /** @var JournalUpdateService $service */
        $service = app(JournalUpdateService::class);

        $service->setTransactionJournal($journal);
        $service->setData(['budget_id' => $budgetId]);
        $service->update();
        $journal->refresh();

        return $journal;
    }

    /**
     * Update category for a journal.
     */
    public function updateCategory(TransactionJournal $journal, string $category): TransactionJournal
    {
        /** @var JournalUpdateService $service */
        $service = app(JournalUpdateService::class);
        $service->setTransactionJournal($journal);
        $service->setData(['category_name' => $category]);
        $service->update();
        $journal->refresh();

        return $journal;
    }

    /**
     * Update tag(s) for a journal.
     */
    public function updateTags(TransactionJournal $journal, array $tags): TransactionJournal
    {
        /** @var JournalUpdateService $service */
        $service = app(JournalUpdateService::class);
        $service->setTransactionJournal($journal);
        $service->setData(['tags' => $tags]);
        $service->update();
        $journal->refresh();

        return $journal;
    }
}