Skip to content

Firefly III: a personal finances manager

19.1 KB
Raw Blame
<?php

/**
 * CurrencyRepository.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\Currency;

use Carbon\Carbon;
use FireflyIII\Events\Preferences\UserGroupChangedPrimaryCurrency;
use FireflyIII\Exceptions\FireflyException;
use FireflyIII\Factory\TransactionCurrencyFactory;
use FireflyIII\Models\AccountMeta;
use FireflyIII\Models\AvailableBudget;
use FireflyIII\Models\Bill;
use FireflyIII\Models\BudgetLimit;
use FireflyIII\Models\CurrencyExchangeRate;
use FireflyIII\Models\RecurrenceTransaction;
use FireflyIII\Models\Transaction;
use FireflyIII\Models\TransactionCurrency;
use FireflyIII\Repositories\User\UserRepositoryInterface;
use FireflyIII\Services\Internal\Destroy\CurrencyDestroyService;
use FireflyIII\Services\Internal\Update\CurrencyUpdateService;
use FireflyIII\Support\Facades\Amount;
use FireflyIII\Support\Repositories\UserGroup\UserGroupInterface;
use FireflyIII\Support\Repositories\UserGroup\UserGroupTrait;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\QueryException;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\Log;
use Override;
use Safe\Exceptions\JsonException;

use function Safe\json_encode;

/**
 * Class CurrencyRepository.
 */
class CurrencyRepository implements CurrencyRepositoryInterface, UserGroupInterface
{
    use UserGroupTrait;

    /**
     * @throws FireflyException
     */
    public function currencyInUse(TransactionCurrency $currency): bool
    {
        $result = $this->currencyInUseAt($currency);

        return null !== $result;
    }

    /**
     * @throws JsonException
     */
    public function currencyInUseAt(TransactionCurrency $currency): ?string
    {
        Log::debug(sprintf('Now in currencyInUse() for #%d ("%s")', $currency->id, $currency->code));
        $countJournals    = $this->countJournals($currency);
        if ($countJournals > 0) {
            Log::info(sprintf('Count journals is %d, return true.', $countJournals));

            return 'journals';
        }

        // is the only currency left
        if (1 === $this->getAll()->count()) {
            Log::info('Is the last currency in the system, return true. ');

            return 'last_left';
        }

        // is being used in accounts:
        $meta             = AccountMeta::query()
            ->where('name', 'currency_id')
            ->where('data', json_encode((string) $currency->id))
            ->count()
        ;
        if ($meta > 0) {
            Log::info(sprintf('Used in %d accounts as currency_id, return true. ', $meta));

            return 'account_meta';
        }

        // second search using integer check.
        $meta             = AccountMeta::query()
            ->where('name', 'currency_id')
            ->where('data', json_encode((int) $currency->id))
            ->count()
        ;
        if ($meta > 0) {
            Log::info(sprintf('Used in %d accounts as currency_id, return true. ', $meta));

            return 'account_meta';
        }

        // is being used in bills:
        $bills            = Bill::query()->where('transaction_currency_id', $currency->id)->count();
        if ($bills > 0) {
            Log::info(sprintf('Used in %d bills as currency, return true. ', $bills));

            return 'bills';
        }

        // is being used in recurring transactions
        $recurringAmount  = RecurrenceTransaction::query()->where('transaction_currency_id', $currency->id)->count();
        $recurringForeign = RecurrenceTransaction::query()->where('foreign_currency_id', $currency->id)->count();

        if ($recurringAmount > 0 || $recurringForeign > 0) {
            Log::info(sprintf('Used in %d recurring transactions as (foreign) currency id, return true. ', $recurringAmount + $recurringForeign));

            return 'recurring';
        }

        // is being used in accounts (as integer)
        $meta             = AccountMeta::leftJoin('accounts', 'accounts.id', '=', 'account_meta.account_id')
            ->whereNull('accounts.deleted_at')
            ->where('account_meta.name', 'currency_id')
            ->where('account_meta.data', json_encode($currency->id))
            ->count()
        ;
        if ($meta > 0) {
            Log::info(sprintf('Used in %d accounts as currency_id, return true. ', $meta));

            return 'account_meta';
        }

        // is being used in available budgets
        $availableBudgets = AvailableBudget::query()->where('transaction_currency_id', $currency->id)->count();
        if ($availableBudgets > 0) {
            Log::info(sprintf('Used in %d available budgets as currency, return true. ', $availableBudgets));

            return 'available_budgets';
        }

        // is being used in budget limits
        $budgetLimit      = BudgetLimit::query()->where('transaction_currency_id', $currency->id)->count();
        if ($budgetLimit > 0) {
            Log::info(sprintf('Used in %d budget limits as currency, return true. ', $budgetLimit));

            return 'budget_limits';
        }

        // is the default currency for the user or the system
        $count            = $this->userGroup->currencies()->where('transaction_currencies.id', $currency->id)->wherePivot('group_default', 1)->count();
        if ($count > 0) {
            Log::info('Is the default currency of the user, return true.');

            return 'current_default';
        }

        // is the default currency for the user or the system
        $count            = $this->userGroup->currencies()->where('transaction_currencies.id', $currency->id)->wherePivot('group_default', 1)->count();
        if ($count > 0) {
            Log::info('Is the default currency of the user group, return true.');

            return 'current_default';
        }

        Log::debug('Currency is not used, return false.');

        return null;
    }

    public function destroy(TransactionCurrency $currency): bool
    {
        /** @var UserRepositoryInterface $repository */
        $repository = app(UserRepositoryInterface::class);
        if ($repository->hasRole($this->user, 'owner')) {
            /** @var CurrencyDestroyService $service */
            $service = app(CurrencyDestroyService::class);
            $service->destroy($currency);
        }

        return true;
    }

    public function disable(TransactionCurrency $currency): void
    {
        $this->userGroup->currencies()->detach($currency->id);
        $currency->enabled = false;
        $currency->save();
    }

    public function enable(TransactionCurrency $currency): void
    {
        $this->userGroup->currencies()->syncWithoutDetaching([$currency->id]);
        $currency->enabled = false;
        $currency->save();
    }

    #[Override]
    public function find(int $currencyId): ?TransactionCurrency
    {
        try {
            $result = Amount::getTransactionCurrencyById($currencyId);
        } catch (FireflyException) {
            return null;
        }

        return $result;
    }

    /**
     * Find by currency code, return NULL if unfound.
     */
    public function findByCode(string $currencyCode): ?TransactionCurrency
    {
        try {
            $result = Amount::getTransactionCurrencyByCode($currencyCode);
        } catch (FireflyException) {
            return null;
        }

        return $result;
    }

    public function findByName(string $name): ?TransactionCurrency
    {
        return TransactionCurrency::query()->where('name', $name)->first();
    }

    /**
     * Find by object, ID or code. Returns user default or system default.
     */
    public function findCurrency(?int $currencyId, ?string $currencyCode): TransactionCurrency
    {
        $result = $this->findCurrencyNull($currencyId, $currencyCode);

        if (!$result instanceof TransactionCurrency) {
            Log::debug('Grabbing default currency for this user...');

            /** @var null|TransactionCurrency $result */
            $result = Amount::getPrimaryCurrencyByUserGroup($this->user->userGroup);
        }

        Log::debug(sprintf('Final result: %s', $result->code));
        // code below is no longer relevant.
        //        if (false === $result->enabled) {
        //            Log::debug(sprintf('Also enabled currency %s', $result->code));
        //            $this->enable($result);
        //        }

        return $result;
    }

    /**
     * Find by object, ID or code. Returns NULL if nothing found.
     */
    public function findCurrencyNull(?int $currencyId, ?string $currencyCode): ?TransactionCurrency
    {
        Log::debug(sprintf('Now in findCurrencyNull(%s, "%s")', var_export($currencyId, true), $currencyCode));
        if (null !== $currencyId && 0 !== $currencyId) {
            $result = $this->find((int) $currencyId);
            if ($result instanceof TransactionCurrency) {
                Log::debug(sprintf('Found currency by ID: %s', $result->code));

                return $result;
            }
        }
        if (null !== $currencyCode && '' !== $currencyCode) {
            Log::debug(sprintf('Searching for currency with code "%s"...', $currencyCode));

            return $this->findByCode($currencyCode);

            //            if ($result instanceof TransactionCurrency && false === $result->enabled) {
            //                Log::debug(sprintf('Also enabled currency %s', $result->code));
            //                $this->enable($result);
            //            }
        }
        Log::debug('Found no currency, returning NULL.');

        return null;
    }

    public function get(): Collection
    {
        $all = $this->userGroup->currencies()->orderBy('code', 'ASC')->withPivot(['group_default'])->get();
        $all->map(static function (TransactionCurrency $current): TransactionCurrency {
            $current->userGroupEnabled = true;
            $current->userGroupNative  = 1 === (int) $current->pivot->group_default;

            return $current;
        });

        /** @var Collection */
        return $all;
    }

    /**
     * Returns ALL currencies, regardless of whether they are enabled or not.
     */
    public function getAll(): Collection
    {
        $all   = TransactionCurrency::query()->orderBy('code', 'ASC')->get();
        $local = $this->get();

        return $all->map(static function (TransactionCurrency $current) use ($local): TransactionCurrency {
            $hasId                     = $local->contains(static fn (TransactionCurrency $entry): bool => $entry->id === $current->id);
            $isPrimary                 = $local->contains(
                static fn (TransactionCurrency $entry): bool => 1 === (int) $entry->pivot->group_default && $entry->id === $current->id
            );
            $current->userGroupEnabled = $hasId;
            $current->userGroupNative  = $isPrimary;

            return $current;
        });
    }

    /**
     * Returns the complete set of transactions but needs
     * no user object.
     */
    public function getCompleteSet(): Collection
    {
        return TransactionCurrency::query()->where('enabled', true)->orderBy('code', 'ASC')->get();
    }

    /**
     * Get currency exchange rate.
     */
    public function getExchangeRate(TransactionCurrency $fromCurrency, TransactionCurrency $toCurrency, Carbon $date): ?CurrencyExchangeRate
    {
        if ($fromCurrency->id === $toCurrency->id) {
            $rate       = new CurrencyExchangeRate();
            $rate->rate = '1';
            $rate->id   = 0;

            return $rate;
        }

        /** @var null|CurrencyExchangeRate $rate */
        $rate = $this->user->currencyExchangeRates()
            ->where('from_currency_id', $fromCurrency->id)
            ->where('to_currency_id', $toCurrency->id)
            ->where('date', $date->format('Y-m-d'))
            ->first()
        ;
        if (null !== $rate) {
            Log::debug(sprintf('Found cached exchange rate in database for %s to %s on %s', $fromCurrency->code, $toCurrency->code, $date->format('Y-m-d')));

            return $rate;
        }

        return null;
    }

    #[Override]
    public function isEnabled(TransactionCurrency $currency): bool
    {
        if (null === $this->user && null === $this->userGroup) {
            throw new FireflyException(sprintf('Cannot check enabled status for currency "%s" in stateless currency repository', $currency->code));
        }
        $userGroup = $this->userGroup;
        if (null === $this->userGroup) {
            $userGroup = $this->user->userGroup;
        }
        $currency  = $userGroup->currencies()->find($currency->id);

        return null !== $currency;
    }

    public function isFallbackCurrency(TransactionCurrency $currency): bool
    {
        return $currency->code === config('firefly.default_currency', 'EUR');
    }

    public function makePrimary(TransactionCurrency $currency): void
    {
        $current = Amount::getPrimaryCurrencyByUserGroup($this->userGroup);
        Log::debug(sprintf('Enabled + made default currency %s for user #%d', $currency->code, $this->userGroup->id));
        $this->userGroup->currencies()->detach($currency->id);
        foreach ($this->userGroup->currencies()->get() as $item) {
            $this->userGroup->currencies()->updateExistingPivot($item->id, ['group_default' => false]);
        }
        $this->userGroup->currencies()->syncWithoutDetaching([$currency->id => ['group_default' => true]]);
        if ($current->id !== $currency->id) {
            Log::debug('Trigger on a different default currency.');
            // clear all primary currency amounts through an event.
            event(new UserGroupChangedPrimaryCurrency($this->userGroup));
        }
    }

    public function searchCurrency(string $search, int $limit): Collection
    {
        $query = TransactionCurrency::query()->orderBy('code', 'ASC');
        if ('' !== $search) {
            $query->where(function (Builder $q1) use ($search): void {
                $q1
                    ->whereLike('code', sprintf('%%%s%%', $search))
                    ->orWhereLike('name', sprintf('%%%s%%', $search))
                    ->orWhereLike('symbol', sprintf('%%%s%%', $search))
                ;
            });
        }

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

    /**
     * TODO must be a factory
     */
    public function setExchangeRate(TransactionCurrency $fromCurrency, TransactionCurrency $toCurrency, Carbon $date, float $rate): CurrencyExchangeRate
    {
        $res = new CurrencyExchangeRate();

        try {
            $res = CurrencyExchangeRate::create([
                'user_id'          => $this->user->id,
                'user_group_id'    => $this->userGroup->id,
                'from_currency_id' => $fromCurrency->id,
                'to_currency_id'   => $toCurrency->id,
                'date'             => $date,
                'date_tz'          => $date->format('e'),
                'rate'             => $rate,
            ]);
        } catch (QueryException $e) {
            $message = $e->getMessage();
            Log::error(sprintf('Could not save exchange rate: %s', $message));
            if (str_contains($message, 'Integrity constraint violation')) {
                Log::warning(sprintf('Currency exchange rate already exists, so return existing one: %s', $message));
                $res = CurrencyExchangeRate::query()
                    ->where('user_id', $this->user->id)
                    ->where('user_group_id', $this->userGroup->id)
                    ->where('from_currency_id', $fromCurrency->id)
                    ->where('to_currency_id', $toCurrency->id)
                    ->where('date', $date)
                    ->first()
                ;
                if (null === $res) {
                    Log::warning('Could not find currency exchange rate, throw exception.');

                    throw new FireflyException('Could not save new currency exchange rate, and returned null when trying to find existing one.');
                }

                return $res;
            }
        }

        return $res;
    }

    /**
     * @throws FireflyException
     */
    public function store(array $data): TransactionCurrency
    {
        /** @var TransactionCurrencyFactory $factory */
        $factory = app(TransactionCurrencyFactory::class);
        $result  = $factory->create($data);

        if (true === $data['enabled']) {
            $this->userGroup->currencies()->attach($result->id);
        }

        return $result;
    }

    public function update(TransactionCurrency $currency, array $data): TransactionCurrency
    {
        Log::debug('Now in update()');
        // can be true, false, null
        $enabled                = $data['enabled'] ?? null;
        // can be true, false, but method only responds to "true".
        $default                = array_key_exists('default', $data) ? $data['default'] : false;

        // remove illegal combo's:
        if (false === $enabled && true === $default) {
            $enabled = true;
            Log::debug('Enabled is now forced to be TRUE.');
        }

        // update currency with current user specific settings
        $currency->refreshForUser($this->user);

        // get current default for this group.
        $currentDefaultCurrency = Amount::getPrimaryCurrencyByUserGroup($this->userGroup);

        // currency is enabled, must be disabled.
        if (false === $enabled) {
            Log::debug(sprintf('Disabled currency %s for user #%d', $currency->code, $this->userGroup->id));
            $this->userGroup->currencies()->detach($currency->id);
        }
        // currency must be enabled
        if (true === $enabled) {
            Log::debug(sprintf('Enabled currency %s for user #%d', $currency->code, $this->userGroup->id));
            $this->userGroup->currencies()->detach($currency->id);
            $this->userGroup->currencies()->syncWithoutDetaching([$currency->id => ['group_default' => $currentDefaultCurrency->id === $currency->id]]);
        }

        // currency must be made default.
        if (true === $default) {
            Log::debug('Will now be default.');
            $this->makePrimary($currency);
        }

        /** @var CurrencyUpdateService $service */
        $service                = app(CurrencyUpdateService::class);

        return $service->update($currency, $data);
    }

    private function countJournals(TransactionCurrency $currency): int
    {
        $count = $currency->transactions()->whereNull('deleted_at')->count() + $currency->transactionJournals()->whereNull('deleted_at')->count();

        // also count foreign:
        return $count + Transaction::query()->where('foreign_currency_id', $currency->id)->count();
    }
}