SettlementTargetService::getMemberCount() - Code Metrics - Inspection of "Merge branch feature/settlement-targets-and-deadli..." - lagdo/tontine - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — main (#51)

by Thierry

created 2023-10-31 10:40 UTC

SettlementTargetService::getMemberCount() A

↳ Parent: SettlementTargetService

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	1
nc	1
nop	1
dl	0
loc	3
rs	10
c	1
b	0
f	0

<?php

namespace Siak\Tontine\Service\Meeting\Charge;

use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;
use Siak\Tontine\Model\Charge;
use Siak\Tontine\Model\Session;
use Siak\Tontine\Model\SettlementTarget;
use Siak\Tontine\Service\TenantService;

class SettlementTargetService
{
    /**
     * @var TenantService
     */
    protected TenantService $tenantService;

    /**
     * @param TenantService $tenantService
     */
    public function __construct(TenantService $tenantService)
    {
        $this->tenantService = $tenantService;
    }

    /**
     * Get the sessions after the current.
     *
     * @param Session $currentSession
     *
     * @return Collection
     */
    public function getDeadlineSessions(Session $currentSession): Collection
    {
        return $this->tenantService->getSessions()
            ->filter(function($session) use($currentSession) {
                return $session->start_at > $currentSession->start_at;
            })
            ->pluck('title', 'id');
    }

    /**
     * @param Charge $charge
     * @param Session $session
     *
     * @return SettlementTarget|null
     */
    public function getTarget(Charge $charge, Session $session): ?SettlementTarget
    {
        return $charge->targets()
            ->with(['session', 'deadline'])
            ->get()
            ->filter(function($target) use($session) {
                return $session->start_at >= $target->session->start_at &&
                    $session->start_at <= $target->deadline->start_at;
            })
            ->first();
    }

    /**
     * @param string $search
     *
     * @return mixed
     */
    private function getMembersQuery(string $search = '')
    {
        return $this->tenantService->tontine()->members()->active()
            ->when($search !== '', function($query) use($search) {
                return $query->where(DB::raw('lower(members.name)'),
                    'like', '%' . strtolower($search) . '%');
            });
    }

    /**
     * @param Charge $charge
     * @param SettlementTarget $target
     * @param Collection $members
     *
     * @return Collection
     */
    public function getMembersSettlements(Charge $charge, SettlementTarget $target,
        Collection $members): Collection
    {
        $sessions = $this->tenantService->round()->sessions
            ->filter(function($session) use($target) {
                return $session->start_at >= $target->session->start_at &&
                    $session->start_at <= $target->deadline->start_at;
            });
        return DB::table('settlements')
            ->join('bills', 'settlements.bill_id', '=', 'bills.id')
            ->join('libre_bills', 'libre_bills.bill_id', '=', 'bills.id')
            ->whereIn('libre_bills.member_id', $members->pluck('id'))
            ->where('libre_bills.charge_id', $charge->id)
            ->whereIn('settlements.session_id', $sessions->pluck('id'))
            ->select('libre_bills.member_id', DB::raw('SUM(bills.amount) as amount'))
            ->groupBy('libre_bills.member_id')
            ->get()
            ->pluck('amount', 'member_id');
    }

    /**
     * @param Charge $charge
     * @param SettlementTarget $target
     * @param string $search
     * @param int $page
     *
     * @return Collection
     */
    public function getMembersWithSettlements(Charge $charge, SettlementTarget $target,
        string $search = '', int $page = 0): Collection
    {
        $sessions = $this->tenantService->round()->sessions
            ->filter(function($session) use($target) {
                return $session->start_at >= $target->session->start_at &&
                    $session->start_at <= $target->deadline->start_at;
            });
        return $this->getMembersQuery($search)
            ->select('members.id', 'members.name')
            ->addSelect([
                'paid' => DB::table('settlements')
                    ->join('bills', 'settlements.bill_id', '=', 'bills.id')
                    ->join('libre_bills', 'libre_bills.bill_id', '=', 'bills.id')
                    ->whereColumn('libre_bills.member_id', 'members.id')
                    ->where('libre_bills.charge_id', $charge->id)
                    ->whereIn('settlements.session_id', $sessions->pluck('id'))
                    ->select(DB::raw('SUM(bills.amount)'))
            ])
            ->page($page, $this->tenantService->getLimit())
            ->orderBy('members.name', 'asc')
            ->get();
    }

    /**
     * @param Charge $charge
     * @param Session $session
     * @param string $search
     * @param bool $filter|null
     *
     * @return int
     */
    public function getMemberCount(string $search = ''): int
    {
        return $this->getMembersQuery($search)->count();
    }

    /**
     * @param Charge $charge
     * @param Session $session
     * @param Session $deadline
     * @param float $amount
     * @param bool $global
     *
     * @return void
     */
    public function createTarget(Charge $charge, Session $session,
        Session $deadline, float $amount, bool $global): void
    {
        $target = new SettlementTarget();
        $target->amount = $amount;
        $target->global = $global;
        $target->charge()->associate($charge);
        $target->session()->associate($session);
        $target->deadline()->associate($deadline);
        $target->save();
    }

    /**
     * @param SettlementTarget $target
     * @param Session $session
     * @param Session $deadline
     * @param float $amount
     * @param bool $global
     *
     * @return void
     */
    public function updateTarget(SettlementTarget $target, Session $session,
        Session $deadline, float $amount, bool $global): void
    {
        $target->amount = $amount;
        $target->global = $global;
        $target->session()->associate($session);
        $target->deadline()->associate($deadline);
        $target->save();
    }

    /**
     * @param SettlementTarget $target
     *
     * @return void
     */
    public function deleteTarget(SettlementTarget $target): void
    {
        $target->delete();
    }
}


1			<?php
2
3			namespace Siak\Tontine\Service\Meeting\Charge;
4
5			use Illuminate\Support\Collection;
6			use Illuminate\Support\Facades\DB;
7			use Illuminate\Support\Facades\Log;
8			use Siak\Tontine\Model\Charge;
9			use Siak\Tontine\Model\Session;
10			use Siak\Tontine\Model\SettlementTarget;
11			use Siak\Tontine\Service\TenantService;
12
13			class SettlementTargetService
14			{
15			/**
16			* @var TenantService
17			*/
18			protected TenantService $tenantService;
19
20			/**
21			* @param TenantService $tenantService
22			*/
23			public function __construct(TenantService $tenantService)
24			{
25			$this->tenantService = $tenantService;
26			}
27
28			/**
29			* Get the sessions after the current.
30			*
31			* @param Session $currentSession
32			*
33			* @return Collection
34			*/
35			public function getDeadlineSessions(Session $currentSession): Collection
36			{
37			return $this->tenantService->getSessions()
38			->filter(function($session) use($currentSession) {
39			return $session->start_at > $currentSession->start_at;
40			})
41			->pluck('title', 'id');
42			}
43
44			/**
45			* @param Charge $charge
46			* @param Session $session
47			*
48			* @return SettlementTarget\|null
49			*/
50			public function getTarget(Charge $charge, Session $session): ?SettlementTarget
51			{
52			return $charge->targets()
53			->with(['session', 'deadline'])
54			->get()
55			->filter(function($target) use($session) {
56			return $session->start_at >= $target->session->start_at &&
57			$session->start_at <= $target->deadline->start_at;
58			})
59			->first();
60			}
61
62			/**
63			* @param string $search
64			*
65			* @return mixed
66			*/
67			private function getMembersQuery(string $search = '')
68			{
69			return $this->tenantService->tontine()->members()->active()
70			->when($search !== '', function($query) use($search) {
71			return $query->where(DB::raw('lower(members.name)'),
72			'like', '%' . strtolower($search) . '%');
73			});
74			}
75
76			/**
77			* @param Charge $charge
78			* @param SettlementTarget $target
79			* @param Collection $members
80			*
81			* @return Collection
82			*/
83			public function getMembersSettlements(Charge $charge, SettlementTarget $target,
84			Collection $members): Collection
85			{
86			$sessions = $this->tenantService->round()->sessions
87			->filter(function($session) use($target) {
88			return $session->start_at >= $target->session->start_at &&
89			$session->start_at <= $target->deadline->start_at;
90			});
91			return DB::table('settlements')
92			->join('bills', 'settlements.bill_id', '=', 'bills.id')
93			->join('libre_bills', 'libre_bills.bill_id', '=', 'bills.id')
94			->whereIn('libre_bills.member_id', $members->pluck('id'))
95			->where('libre_bills.charge_id', $charge->id)
96			->whereIn('settlements.session_id', $sessions->pluck('id'))
97			->select('libre_bills.member_id', DB::raw('SUM(bills.amount) as amount'))
98			->groupBy('libre_bills.member_id')
99			->get()
100			->pluck('amount', 'member_id');
101			}
102
103			/**
104			* @param Charge $charge
105			* @param SettlementTarget $target
106			* @param string $search
107			* @param int $page
108			*
109			* @return Collection
110			*/
111			public function getMembersWithSettlements(Charge $charge, SettlementTarget $target,
112			string $search = '', int $page = 0): Collection
113			{
114			$sessions = $this->tenantService->round()->sessions
115			->filter(function($session) use($target) {
116			return $session->start_at >= $target->session->start_at &&
117			$session->start_at <= $target->deadline->start_at;
118			});
119			return $this->getMembersQuery($search)
120			->select('members.id', 'members.name')
121			->addSelect([
122			'paid' => DB::table('settlements')
123			->join('bills', 'settlements.bill_id', '=', 'bills.id')
124			->join('libre_bills', 'libre_bills.bill_id', '=', 'bills.id')
125			->whereColumn('libre_bills.member_id', 'members.id')
126			->where('libre_bills.charge_id', $charge->id)
127			->whereIn('settlements.session_id', $sessions->pluck('id'))
128			->select(DB::raw('SUM(bills.amount)'))
129			])
130			->page($page, $this->tenantService->getLimit())
131			->orderBy('members.name', 'asc')
132			->get();
133			}
134
135			/**
136			* @param Charge $charge
137			* @param Session $session
138			* @param string $search
139			* @param bool $filter\|null
140			*
141			* @return int
142			*/
143			public function getMemberCount(string $search = ''): int
144			{
145			return $this->getMembersQuery($search)->count();
146			}
147
148			/**
149			* @param Charge $charge
150			* @param Session $session
151			* @param Session $deadline
152			* @param float $amount
153			* @param bool $global
154			*
155			* @return void
156			*/
157			public function createTarget(Charge $charge, Session $session,
158			Session $deadline, float $amount, bool $global): void
159			{
160			$target = new SettlementTarget();
161			$target->amount = $amount;
162			$target->global = $global;
163			$target->charge()->associate($charge);
164			$target->session()->associate($session);
165			$target->deadline()->associate($deadline);
166			$target->save();
167			}
168
169			/**
170			* @param SettlementTarget $target
171			* @param Session $session
172			* @param Session $deadline
173			* @param float $amount
174			* @param bool $global
175			*
176			* @return void
177			*/
178			public function updateTarget(SettlementTarget $target, Session $session,
179			Session $deadline, float $amount, bool $global): void
180			{
181			$target->amount = $amount;
182			$target->global = $global;
183			$target->session()->associate($session);
184			$target->deadline()->associate($deadline);
185			$target->save();
186			}
187
188			/**
189			* @param SettlementTarget $target
190			*
191			* @return void
192			*/
193			public function deleteTarget(SettlementTarget $target): void
194			{
195			$target->delete();
196			}
197			}
198

lagdo / tontine

Pull Request — main (#51)

SettlementTargetService::getMemberCount() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like