Siak\Tontine\Service\Meeting\Charge\LibreFeeService

Complexity

Total Complexity

9

Size/Duplication

Total Lines	138
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	getRoundSettlements()	0	12	1
A	getSettlements()	0	12	1
A	__construct()	0	3	1
A	getRoundBills()	0	6	1
A	getSessionSettlements()	0	9	1
A	getFeeCount()	0	3	1
A	getBills()	0	8	1
A	getFees()	0	6	1
A	getSessionBills()	0	6	1

<?php

namespace Siak\Tontine\Service\Meeting\Charge;

use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Siak\Tontine\Model\Bill;
use Siak\Tontine\Model\Round;
use Siak\Tontine\Model\Session;
use Siak\Tontine\Service\LocaleService;
use Siak\Tontine\Service\Meeting\Session\SessionService;
use Siak\Tontine\Service\TenantService;

class LibreFeeService
{
    /**
     * @param LocaleService $localeService
     * @param TenantService $tenantService
     * @param SessionService $sessionService
     */
    public function __construct(protected LocaleService $localeService,
        protected TenantService $tenantService, protected SessionService $sessionService)
    {}

    /**
     * Get a paginated list of fees.
     *
     * @param Round $round
     * @param int $page
     *
     * @return Collection
     */
    public function getFees(Round $round, int $page = 0): Collection
    {
        return $round->charges()->variable()
            ->orderBy('id', 'desc')
            ->page($page, $this->tenantService->getLimit())
            ->get();
    }

    /**
     * Get the number of fees.
     *
     * @param Round $round
     *
     * @return int
     */
    public function getFeeCount(Round $round): int
    {
        return $round->charges()->variable()->count();
    }

    /**
     * @param Session $session
     *
     * @return Collection
     */
    private function getSessionBills(Session $session): Collection
    {
        return Bill::ofSession($session)->libre()
            ->select('charge_id', DB::raw('count(*) as total'), DB::raw('sum(amount) as amount'))
            ->groupBy('charge_id')
            ->get();
    }

    /**
     * @param Session $session
     *
     * @return Collection
     */
    private function getSessionSettlements(Session $session): Collection
    {
        return Bill::ofSession($session)->libre()
            ->select('charge_id', DB::raw('count(*) as total'), DB::raw('sum(amount) as amount'))
            ->whereHas('settlement', function($query) use($session) {
                $query->where('session_id', $session->id);
            })
            ->groupBy('charge_id')
            ->get();
    }

    /**
     * @param Session $session
     *
     * @return Collection
     */
    private function getRoundBills(Session $session): Collection
    {
        return Bill::ofRound($session)->libre()
            ->select('charge_id', DB::raw('count(*) as total'), DB::raw('sum(amount) as amount'))
            ->groupBy('charge_id')
            ->get();
    }

    /**
     * @param Session $session
     *
     * @return Collection
     */
    private function getRoundSettlements(Session $session): Collection
    {
        return Bill::ofRound($session)->libre()
            ->select('charge_id', DB::raw('count(*) as total'), DB::raw('sum(amount) as amount'))
            ->whereHas('settlement', function($query) use($session) {
                $query->whereHas('session', function($query) use($session) {
                    $query->where('id', '!=', $session->id)
                        ->where('round_id', $session->round_id);
                });
            })
            ->groupBy('charge_id')
            ->get();
    }

    /**
     * Get the report of bills
     *
     * @param Session $session
     *
     * @return array
     */
    public function getBills(Session $session): array
    {
        $sessionBills = $this->getSessionBills($session);
        $roundBills = $this->getRoundBills($session);
        return [
            'total' => [
                'session' => $sessionBills->pluck('total', 'charge_id'),
                'round' => $roundBills->pluck('total', 'charge_id'),
            ],
        ];
    }

    /**
     * Get the report of settlements
     *
     * @param Session $session
     *
     * @return array
     */
    public function getSettlements(Session $session): array
    {
        $sessionSettlements = $this->getSessionSettlements($session);
        $roundSettlements = $this->getRoundSettlements($session);
        return [
            'total' => [
                'session' => $sessionSettlements->pluck('total', 'charge_id'),
                'round' => $roundSettlements->pluck('total', 'charge_id'),
            ],
            'amount' => [
                'session' => $sessionSettlements->pluck('amount', 'charge_id'),
                'round' => $roundSettlements->pluck('amount', 'charge_id'),
            ],
        ];
    }
}