Account::creditTransactionLineAdded()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 2
CRAP Score 1

Importance

Changes 0
Metric Value
cc 1
eloc 1
nc 1
nop 1
dl 0
loc 3
ccs 2
cts 2
cp 1
crap 1
rs 10
c 0
b 0
f 0
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Application\Model;
6
7
use Application\Enum\AccountType;
8
use Application\Repository\AccountRepository;
9
use Application\Repository\TransactionLineRepository;
10
use Application\Traits\HasIban;
11
use Cake\Chronos\ChronosDate;
12
use Doctrine\Common\Collections\ArrayCollection;
13
use Doctrine\Common\Collections\Collection;
14
use Doctrine\ORM\Mapping as ORM;
15
use Ecodev\Felix\Api\Exception;
16
use Ecodev\Felix\Model\Traits\HasName;
17
use GraphQL\Doctrine\Attribute as API;
18
use Money\Money;
19
20
/**
21
 * Financial account.
22
 */
23
#[ORM\Entity(AccountRepository::class)]
24
#[ORM\AssociationOverrides([new ORM\AssociationOverride(name: 'owner', inversedBy: 'accounts', joinColumns: new ORM\JoinColumn(unique: true, onDelete: 'SET NULL'))])]
25
class Account extends AbstractModel
26
{
27
    use HasIban;
28
    use HasName;
29
30
    #[ORM\Column(type: 'Money', options: ['default' => 0])]
31
    private Money $balance;
32
33
    #[ORM\JoinColumn(onDelete: 'CASCADE')]
34
    #[ORM\ManyToOne(targetEntity: self::class, inversedBy: 'children')]
35
    private ?Account $parent = null;
36
37
    /**
38
     * @var Collection<int, Account>
39
     */
40
    #[ORM\OneToMany(targetEntity: self::class, mappedBy: 'parent')]
41
    #[ORM\OrderBy(['code' => 'ASC'])]
42
    private Collection $children;
43
44
    #[ORM\Column(type: 'enum', length: 10)]
45
    private AccountType $type;
46
47
    #[ORM\Column(type: 'integer', unique: true, options: ['unsigned' => true])]
48
    private int $code;
49
50
    /**
51
     * @var Collection<int, TransactionLine>
52
     */
53
    #[ORM\OneToMany(targetEntity: TransactionLine::class, mappedBy: 'debit')]
54
    private Collection $debitTransactionLines;
55
56
    /**
57
     * @var Collection<int, TransactionLine>
58
     */
59
    #[ORM\OneToMany(targetEntity: TransactionLine::class, mappedBy: 'credit')]
60
    private Collection $creditTransactionLines;
61
62
    #[ORM\Column(type: 'Money', options: ['default' => 0])]
63
    private Money $totalBalance;
64
65
    #[ORM\Column(type: 'Money', nullable: true)]
66
    private ?Money $budgetAllowed = null;
67
68
    #[ORM\Column(type: 'Money', nullable: true, columnDefinition: 'INT AS (IF(type = \'asset\', budget_allowed - (total_balance - total_balance_former), budget_allowed - total_balance)) PERSISTENT')]
69
    private ?Money $budgetBalance = null;
70
71
    #[ORM\Column(type: 'Money', options: ['default' => 0])]
72
    private Money $totalBalanceFormer;
73
74 37
    public function __construct()
75
    {
76 37
        $this->balance = Money::CHF(0);
77 37
        $this->totalBalance = Money::CHF(0);
78 37
        $this->totalBalanceFormer = Money::CHF(0);
79 37
        $this->children = new ArrayCollection();
80 37
        $this->debitTransactionLines = new ArrayCollection();
81 37
        $this->creditTransactionLines = new ArrayCollection();
82
    }
83
84
    /**
85
     * Get full name including code and name.
86
     */
87
    public function getFullName(): string
88
    {
89
        return implode(' - ', array_filter([$this->getCode(), $this->getName()]));
90
    }
91
92
    /**
93
     * Assign the account to an user.
94
     */
95 21
    public function setOwner(?User $owner): void
96
    {
97 21
        if ($this->getOwner()) {
98 1
            $this->getOwner()->accountRemoved();
99
        }
100
101 21
        parent::setOwner($owner);
102
103 21
        if ($this->getOwner()) {
104 21
            $owner->accountAdded($this);
0 ignored issues
show
Bug introduced by
The method accountAdded() does not exist on null. ( Ignorable by Annotation )

If this is a false-positive, you can also ignore this issue in your code via the ignore-call  annotation

104
            $owner->/** @scrutinizer ignore-call */ 
105
                    accountAdded($this);

This check looks for calls to methods that do not seem to exist on a given type. It looks for the method on the type itself as well as in inherited classes or implemented interfaces.

This is most likely a typographical error or the method has been renamed.

Loading history...
105
        }
106
    }
107
108 2
    public function getBudgetAllowed(): ?Money
109
    {
110 2
        return $this->budgetAllowed;
111
    }
112
113 1
    public function setBudgetAllowed(?Money $budgetAllowed): void
114
    {
115 1
        $this->budgetAllowed = $budgetAllowed;
116
    }
117
118 2
    public function getBudgetBalance(): ?Money
119
    {
120 2
        return $this->budgetBalance;
121
    }
122
123
    public function getTotalBalanceFormer(): Money
124
    {
125
        return $this->totalBalanceFormer;
126
    }
127
128
    public function setTotalBalanceFormer(Money $totalBalanceFormer): void
129
    {
130
        $this->totalBalanceFormer = $totalBalanceFormer;
131
    }
132
133
    /**
134
     * Only members' liability accounts must have an owner
135
     * and there must be only an account per member.
136
     */
137 16
    protected function getOwnerForCreation(): ?User
138
    {
139 16
        return null;
140
    }
141
142
    /**
143
     * Set balance.
144
     */
145 2
    #[API\Exclude]
146
    public function setBalance(Money $balance): void
147
    {
148 2
        $this->balance = $balance;
149
    }
150
151 9
    public function getBalance(): Money
152
    {
153 9
        return $this->balance;
154
    }
155
156
    /**
157
     * Total balance, recursively including all child account if this account is a group.
158
     */
159 2
    public function getTotalBalance(): Money
160
    {
161 2
        return $this->totalBalance;
162
    }
163
164
    /**
165
     * Historical account's balance at a date in the past.
166
     */
167 3
    public function getBalanceAtDate(ChronosDate $date): Money
168
    {
169 3
        $today = ChronosDate::today();
170
171 3
        if ($date->greaterThan($today)) {
172
            throw new Exception('Cannot compute balance of account #' . $this->getId() . ' in the future on ' . $date->format('d.m.Y'));
173
        }
174
175 3
        if ($date->equals($today)) {
176
            if ($this->getType() === AccountType::Group) {
177
                return $this->getTotalBalance();
178
            }
179
180
            return $this->getBalance();
181
        }
182
183 3
        $connection = _em()->getConnection();
184
185 3
        if ($this->getType() === AccountType::Group) {
186
            // Get all child accounts that are not group account (= they have their own balance)
187 2
            $sql = 'WITH RECURSIVE child AS
188
              (SELECT id, parent_id, `type`, balance
189
               FROM account WHERE id = ?
190
               UNION
191
               SELECT account.id, account.parent_id, account.type, account.balance
192
               FROM account
193
               JOIN child ON account.parent_id = child.id)
194 2
            SELECT child.id FROM child WHERE `type` <> ?';
195
196 2
            $result = $connection->executeQuery($sql, [$this->getId(), AccountType::Group->value]);
197
198 2
            $ids = $result->fetchFirstColumn();
199
200 2
            $totals = [];
201 2
            $totalForChildren = Money::CHF(0);
202
203
            /** @var AccountRepository $accountRepository */
204 2
            $accountRepository = _em()->getRepository(self::class);
205 2
            foreach ($ids as $idAccount) {
206 2
                $child = $accountRepository->getOneById((int) $idAccount);
207 2
                $childBalance = $child->getBalanceAtDate($date);
208 2
                $totalForChildren = $totalForChildren->add($childBalance);
209 2
                $totals[(int) $idAccount] = $totalForChildren;
210
            }
211
212 2
            return $totalForChildren;
213
        }
214
215
        /** @var TransactionLineRepository $transactionLineRepository */
216 3
        $transactionLineRepository = _em()->getRepository(TransactionLine::class);
217
218 3
        $totalDebit = $transactionLineRepository->totalBalance($this, null, null, $date);
219 3
        $totalCredit = $transactionLineRepository->totalBalance(null, $this, null, $date);
220 3
        if (in_array($this->getType(), [
221 3
            AccountType::Liability,
222 3
            AccountType::Equity,
223 3
            AccountType::Revenue,
224 3
        ], true)) {
225 2
            $balance = $totalCredit->subtract($totalDebit);
226 3
        } elseif (in_array($this->getType(), [AccountType::Asset, AccountType::Expense], true)) {
227 3
            $balance = $totalDebit->subtract($totalCredit);
228
        } else {
229
            throw new Exception('Do not know how to compute past balance of account #' . $this->getId() . ' of type ' . $this->getType()->value);
230
        }
231
232 3
        return $balance;
233
    }
234
235
    /**
236
     * Set parent.
237
     */
238 17
    public function setParent(?self $parent): void
239
    {
240 17
        if ($this->getParent()) {
241 1
            $this->getParent()->getChildren()->removeElement($this);
242
        }
243
244 17
        $this->parent = $parent;
245
246 17
        if ($this->getParent()) {
247 17
            $this->getParent()->getChildren()->add($this);
248
        }
249
    }
250
251 17
    public function getParent(): ?self
252
    {
253 17
        return $this->parent;
254
    }
255
256 18
    public function getChildren(): Collection
257
    {
258 18
        return $this->children;
259
    }
260
261
    /**
262
     * Set type.
263
     */
264 16
    public function setType(AccountType $type): void
265
    {
266 16
        $this->type = $type;
267
    }
268
269
    /**
270
     * Get type.
271
     */
272 5
    public function getType(): AccountType
273
    {
274 5
        return $this->type;
275
    }
276
277
    /**
278
     * Set code.
279
     */
280 16
    public function setCode(int $code): void
281
    {
282 16
        $this->code = $code;
283
    }
284
285
    /**
286
     * Get code.
287
     */
288 18
    public function getCode(): int
289
    {
290 18
        return $this->code;
291
    }
292
293
    /**
294
     * Notify when a transaction line is added
295
     * This should only be called by TransactionLine::setDebit().
296
     */
297 32
    public function debitTransactionLineAdded(TransactionLine $transactionLine): void
298
    {
299 32
        $this->debitTransactionLines->add($transactionLine);
300
    }
301
302
    /**
303
     * Notify when a transaction line is removed
304
     * This should only be called by TransactionLine::setDebit().
305
     */
306 1
    public function debitTransactionLineRemoved(TransactionLine $transactionLine): void
307
    {
308 1
        $this->debitTransactionLines->removeElement($transactionLine);
309
    }
310
311 5
    public function getDebitTransactionLines(): Collection
312
    {
313 5
        return $this->debitTransactionLines;
314
    }
315
316
    /**
317
     * Notify when a transaction line is added
318
     * This should only be called by TransactionLine::setCredit().
319
     */
320 32
    public function creditTransactionLineAdded(TransactionLine $transactionLine): void
321
    {
322 32
        $this->creditTransactionLines->add($transactionLine);
323
    }
324
325
    /**
326
     * Notify when a transaction line is removed
327
     * This should only be called by TransactionLine::setCredit().
328
     */
329 1
    public function creditTransactionLineRemoved(TransactionLine $transactionLine): void
330
    {
331 1
        $this->creditTransactionLines->removeElement($transactionLine);
332
    }
333
334 5
    public function getCreditTransactionLines(): Collection
335
    {
336 5
        return $this->creditTransactionLines;
337
    }
338
}
339