App\Module\Client\Read\Repository\ClientReadNoteAmountFinderRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	31
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	findClientNotesAmount()	0	17	1

<?php

namespace App\Module\Client\Read\Repository;

use App\Infrastructure\Database\QueryFactory;

The type App\Infrastructure\Database\QueryFactory was not found. Maybe you did not declare it correctly or list all dependencies?

readonly class ClientReadNoteAmountFinderRepository
{
    public function __construct(
        private QueryFactory $queryFactory,
    ) {
    }

    /**
     * Find the amount of notes without counting the main note.
     *
     * @param int $clientId
     *
     * @return int
     */
    public function findClientNotesAmount(int $clientId): int
    {
        $query = $this->queryFactory->selectQuery()->from('client');

        $query->select(['amount' => $query->func()->count('n.id')])
            ->join(['n' => ['table' => 'note', 'type' => 'LEFT', 'conditions' => 'n.client_id = client.id']])
            ->where(
                [
                    'client.id' => $clientId,
                    // The main note should not be counted in
                    'n.is_main' => 0,
                    'n.deleted_at IS' => null,
                ]
            );

        // Return amount of notes
        return (int)$query->execute()->fetch('assoc')['amount'];
    }
}