akaunting/app/Imports/Banking/Transfers.php

<?php

namespace App\Imports\Banking;

use App\Abstracts\Import;
use App\Jobs\Banking\CreateTransaction;
use App\Models\Banking\Transaction;
use App\Models\Banking\Transfer as Model;
use App\Traits\Categories;
use App\Traits\Currencies;
use App\Traits\Jobs;
use App\Traits\Transactions;
use App\Utilities\Date;

class Transfers extends Import
{
    use Categories, Currencies, Jobs, Transactions;

    public function model(array $row)
    {
        return new Model($row);
    }

    public function map($row): array
    {
        $row = parent::map($row);

        $row['transferred_at'] = Date::parse($row['transferred_at'])->format('Y-m-d');
        $row['from_currency_code'] = $this->getFromCurrencyCode($row);
        $row['to_currency_code'] = $this->getToCurrencyCode($row);
        $row['from_account_id'] = $this->getFromAccountId($row);
        $row['to_account_id'] = $this->getToAccountId($row);
        $row['expense_transaction_id'] = $this->getExpenseTransactionId($row);
        $row['income_transaction_id'] = $this->getIncomeTransactionId($row);

        return $row;
    }

    public function rules(): array
    {
        return [
            'from_account_id' => 'required|integer',
            'from_currency_code' => 'required|string|currency',
            'from_currency_rate' => 'required|gt:0',
            'to_account_id' => 'required|integer',
            'to_currency_code' => 'required|string|currency',
            'to_currency_rate' => 'required|gt:0',
            'amount' => 'required|amount',
            'transferred_at' => 'required|date_format:Y-m-d',
            'payment_method' => 'required|string',
        ];
    }

    private function getExpenseTransactionId($row)
    {
        $expense_transaction = $this->dispatch(new CreateTransaction([
            'company_id' => $row['company_id'],
            'number' => $this->getNextTransactionNumber(),
            'type' => Transaction::EXPENSE_TRANSFER_TYPE,
            'account_id' => $row['from_account_id'],
            'paid_at' => $row['transferred_at'],
            'currency_code' => $row['from_currency_code'],
            'currency_rate' => $row['from_currency_rate'],
            'amount' => $row['amount'],
            'contact_id' => 0,
            'description' => $row['description'],
            'category_id' => $this->getTransferCategoryId(),
            'payment_method' => $row['payment_method'],
            'reference' => $row['reference'],
            'created_by' => $row['created_by'],
        ]));

        return $expense_transaction->id;
    }

    private function getIncomeTransactionId($row)
    {
        $amount = $row['amount'];

        // Convert amount if not same currency
        if ($row['from_currency_code'] !== $row['to_currency_code']) {
            $amount = $this->convertBetween(
                $amount,
                $row['from_currency_code'],
                $row['from_currency_rate'],
                $row['to_currency_code'],
                $row['to_currency_rate']
            );
        }

        $income_transaction = $this->dispatch(new CreateTransaction([
            'company_id' => $row['company_id'],
            'number' => $this->getNextTransactionNumber(),
            'type' => Transaction::INCOME_TRANSFER_TYPE,
            'account_id' => $row['to_account_id'],
            'paid_at' => $row['transferred_at'],
            'currency_code' => $row['to_currency_code'],
            'currency_rate' => $row['to_currency_rate'],
            'amount' => $amount,
            'contact_id' => 0,
            'description' => $row['description'],
            'category_id' => $this->getTransferCategoryId(),
            'payment_method' => $row['payment_method'],
            'reference' => $row['reference'],
            'created_by' => $row['created_by'],
        ]));

        return $income_transaction->id;
    }

    private function getFromAccountId($row)
    {
        $row['account_id'] = $row['from_account_id'] ?? null;
        $row['account_name'] = $row['from_account_name'] ?? null;
        $row['account_number'] = $row['from_account_number'] ?? null;
        $row['currency_code'] = $row['from_currency_code'] ?? null;

        return $this->getAccountId($row);
    }

    private function getToAccountId($row)
    {
        $row['account_id'] = $row['to_account_id'] ?? null;
        $row['account_name'] = $row['to_account_name'] ?? null;
        $row['account_number'] = $row['to_account_number'] ?? null;
        $row['currency_code'] = $row['to_currency_code'] ?? null;

        return $this->getAccountId($row);
    }

    private function getFromCurrencyCode($row)
    {
        $row['currency_code'] = $row['from_currency_code'] ?? null;
        $row['currency_rate'] = $row['from_currency_rate'] ?? null;

        return $this->getCurrencyCode($row);
    }

    private function getToCurrencyCode($row)
    {
        $row['currency_code'] = $row['to_currency_code'] ?? null;
        $row['currency_rate'] = $row['to_currency_rate'] ?? null;

        return $this->getCurrencyCode($row);
    }
}