Session::loans() - Code Metrics - Inspection of "Fix the session selection in the round report page..." - lagdo/tontine - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( 0f5fd7...06315f )

by Thierry

created 2025-10-17 22:10 UTC

Session::loans() A

↳ Parent: Session

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php

namespace Siak\Tontine\Model;

use Illuminate\Database\Eloquent\Casts\Attribute;
use Illuminate\Database\Eloquent\Builder;

class Session extends Base
{
    use Traits\DateFormatter;

    /**
     * @const
     */
    const STATUS_PENDING = 0;

    /**
     * @const
     */
    const STATUS_OPENED = 1;

    /**
     * @const
     */
    const STATUS_CLOSED = 2;

    /**
     * Indicates if the model should be timestamped.
     *
     * @var bool
     */
    public $timestamps = false;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'title',
        'abbrev',
        'agenda',
        'report',
        'status',
        'notes',
        'venue',
        'day_date',
        'start_time',
        'end_time',
        'host_id',
    ];

    /**
     * Get the attributes that should be cast.
     *
     * @return array<string, string>
     */
    protected function casts(): array
    {
        return [
            'day_date' => 'datetime:Y-m-d',
            'start_time' => 'datetime:H:i',
            'end_time' => 'datetime:H:i',
        ];
    }

    public function notFirst(): Attribute
    {
        return Attribute::make(
            get: fn() => $this->round->sessions()->where('day_date', '<', $this->day_date)->exists(),
        );
    }

    public function notLast(): Attribute
    {
        return Attribute::make(
            get: fn() => $this->round->sessions()->where('day_date', '>', $this->day_date)->exists(),
        );
    }

    public function abbrev(): Attribute
    {
        return Attribute::make(
            get: fn($value) => $value ?? $this->day_date->format('M y'),
        );
    }

    public function times(): Attribute
    {
        return Attribute::make(
            get: fn() => $this->start_time->format('H:i') . ' - ' . $this->end_time->format('H:i'),
        );
    }

    public function pending(): Attribute
    {
        return Attribute::make(
            get: fn() => $this->status === self::STATUS_PENDING,
        );
    }

    public function opened(): Attribute
    {
        return Attribute::make(
            get: fn() => $this->status === self::STATUS_OPENED,
        );
    }

    public function closed(): Attribute
    {
        return Attribute::make(
            get: fn() => $this->status === self::STATUS_CLOSED,
        );
    }

    public function active(): Attribute
    {
        return Attribute::make(
            get: fn() => $this->status !== self::STATUS_PENDING,
        );
    }

    public function round()
    {
        return $this->belongsTo(Round::class);
    }

    public function host()
    {
        return $this->belongsTo(Member::class);
    }

    public function payables()
    {
        return $this->hasMany(Payable::class)->orderBy('payables.id', 'asc');
    }

    public function receivables()
    {
        return $this->hasMany(Receivable::class);
    }

    public function deposits()
    {
        return $this->hasMany(Deposit::class);
    }

    public function session_bills()
    {
        return $this->hasMany(SessionBill::class);
    }

    public function libre_bills()
    {
        return $this->hasMany(LibreBill::class);
    }

    public function loans()
    {
        return $this->hasMany(Loan::class);
    }

    public function auctions()
    {
        return $this->hasMany(Auction::class);
    }

    public function refunds()
    {
        return $this->hasMany(Refund::class);
    }

    public function partial_refunds()
    {
        return $this->hasMany(PartialRefund::class);
    }

    public function savings()
    {
        return $this->hasMany(Saving::class);
    }

    public function outflows()
    {
        return $this->hasMany(Outflow::class);
    }

    public function funds()
    {
        return $this->belongsToMany(Fund::class, 'v_fund_session');
    }

    public function pools()
    {
        return $this->belongsToMany(Pool::class, 'v_pool_session');
    }

    public function disabled_pools()
    {
        return $this->belongsToMany(Pool::class, 'pool_session_disabled');
    }

    public function absences()
    {
        return $this->belongsToMany(Member::class, 'absences');
    }

    /**
     * @param  Builder  $query
     *
     * @return Builder
     */
    public function scopeActive(Builder $query): Builder
    {
        return $query->where('sessions.status', '!=', self::STATUS_PENDING);
    }

    /**
     * @param  Builder  $query
     *
     * @return Builder
     */
    public function scopeOpened(Builder $query): Builder
    {
        return $query->where('status', '=', self::STATUS_OPENED);
    }

    /**
     * @param  Builder  $query
     * @param  Session  $session
     * @param  bool $strictly
     *
     * @return Builder
     */
    public function scopePrecedes(Builder $query, Session $session, bool $strictly = false): Builder
    {
        return $query
            ->where('round_id', $session->round_id)
            ->where('day_date', $strictly ? '<' : '<=', $session->day_date);
    }

    /**
     * @param  Builder  $query
     * @param  Session  $session
     * @param  bool $strictly
     *
     * @return Builder
     */
    public function scopeSucceedes(Builder $query, Session $session, bool $strictly = false): Builder
    {
        return $query
            ->where('round_id', $session->round_id)
            ->where('day_date', $strictly ? '>' : '>=', $session->day_date);
    }
}


1			<?php
2
3			namespace Siak\Tontine\Model;
4
5			use Illuminate\Database\Eloquent\Casts\Attribute;
6			use Illuminate\Database\Eloquent\Builder;
7
8			class Session extends Base
9			{
10			use Traits\DateFormatter;
11
12			/**
13			* @const
14			*/
15			const STATUS_PENDING = 0;
16
17			/**
18			* @const
19			*/
20			const STATUS_OPENED = 1;
21
22			/**
23			* @const
24			*/
25			const STATUS_CLOSED = 2;
26
27			/**
28			* Indicates if the model should be timestamped.
29			*
30			* @var bool
31			*/
32			public $timestamps = false;
33
34			/**
35			* The attributes that are mass assignable.
36			*
37			* @var array
38			*/
39			protected $fillable = [
40			'title',
41			'abbrev',
42			'agenda',
43			'report',
44			'status',
45			'notes',
46			'venue',
47			'day_date',
48			'start_time',
49			'end_time',
50			'host_id',
51			];
52
53			/**
54			* Get the attributes that should be cast.
55			*
56			* @return array<string, string>
57			*/
58			protected function casts(): array
59			{
60			return [
61			'day_date' => 'datetime:Y-m-d',
62			'start_time' => 'datetime:H:i',
63			'end_time' => 'datetime:H:i',
64			];
65			}
66
67			public function notFirst(): Attribute
68			{
69			return Attribute::make(
70			get: fn() => $this->round->sessions()->where('day_date', '<', $this->day_date)->exists(),
71			);
72			}
73
74			public function notLast(): Attribute
75			{
76			return Attribute::make(
77			get: fn() => $this->round->sessions()->where('day_date', '>', $this->day_date)->exists(),
78			);
79			}
80
81			public function abbrev(): Attribute
82			{
83			return Attribute::make(
84			get: fn($value) => $value ?? $this->day_date->format('M y'),
85			);
86			}
87
88			public function times(): Attribute
89			{
90			return Attribute::make(
91			get: fn() => $this->start_time->format('H:i') . ' - ' . $this->end_time->format('H:i'),
92			);
93			}
94
95			public function pending(): Attribute
96			{
97			return Attribute::make(
98			get: fn() => $this->status === self::STATUS_PENDING,
99			);
100			}
101
102			public function opened(): Attribute
103			{
104			return Attribute::make(
105			get: fn() => $this->status === self::STATUS_OPENED,
106			);
107			}
108
109			public function closed(): Attribute
110			{
111			return Attribute::make(
112			get: fn() => $this->status === self::STATUS_CLOSED,
113			);
114			}
115
116			public function active(): Attribute
117			{
118			return Attribute::make(
119			get: fn() => $this->status !== self::STATUS_PENDING,
120			);
121			}
122
123			public function round()
124			{
125			return $this->belongsTo(Round::class);
126			}
127
128			public function host()
129			{
130			return $this->belongsTo(Member::class);
131			}
132
133			public function payables()
134			{
135			return $this->hasMany(Payable::class)->orderBy('payables.id', 'asc');
136			}
137
138			public function receivables()
139			{
140			return $this->hasMany(Receivable::class);
141			}
142
143			public function deposits()
144			{
145			return $this->hasMany(Deposit::class);
146			}
147
148			public function session_bills()
149			{
150			return $this->hasMany(SessionBill::class);
151			}
152
153			public function libre_bills()
154			{
155			return $this->hasMany(LibreBill::class);
156			}
157
158			public function loans()
159			{
160			return $this->hasMany(Loan::class);
161			}
162
163			public function auctions()
164			{
165			return $this->hasMany(Auction::class);
166			}
167
168			public function refunds()
169			{
170			return $this->hasMany(Refund::class);
171			}
172
173			public function partial_refunds()
174			{
175			return $this->hasMany(PartialRefund::class);
176			}
177
178			public function savings()
179			{
180			return $this->hasMany(Saving::class);
181			}
182
183			public function outflows()
184			{
185			return $this->hasMany(Outflow::class);
186			}
187
188			public function funds()
189			{
190			return $this->belongsToMany(Fund::class, 'v_fund_session');
191			}
192
193			public function pools()
194			{
195			return $this->belongsToMany(Pool::class, 'v_pool_session');
196			}
197
198			public function disabled_pools()
199			{
200			return $this->belongsToMany(Pool::class, 'pool_session_disabled');
201			}
202
203			public function absences()
204			{
205			return $this->belongsToMany(Member::class, 'absences');
206			}
207
208			/**
209			* @param Builder $query
210			*
211			* @return Builder
212			*/
213			public function scopeActive(Builder $query): Builder
214			{
215			return $query->where('sessions.status', '!=', self::STATUS_PENDING);
216			}
217
218			/**
219			* @param Builder $query
220			*
221			* @return Builder
222			*/
223			public function scopeOpened(Builder $query): Builder
224			{
225			return $query->where('status', '=', self::STATUS_OPENED);
226			}
227
228			/**
229			* @param Builder $query
230			* @param Session $session
231			* @param bool $strictly
232			*
233			* @return Builder
234			*/
235			public function scopePrecedes(Builder $query, Session $session, bool $strictly = false): Builder
236			{
237			return $query
238			->where('round_id', $session->round_id)
239			->where('day_date', $strictly ? '<' : '<=', $session->day_date);
240			}
241
242			/**
243			* @param Builder $query
244			* @param Session $session
245			* @param bool $strictly
246			*
247			* @return Builder
248			*/
249			public function scopeSucceedes(Builder $query, Session $session, bool $strictly = false): Builder
250			{
251			return $query
252			->where('round_id', $session->round_id)
253			->where('day_date', $strictly ? '>' : '>=', $session->day_date);
254			}
255			}
256

lagdo / tontine

Push — main ( 0f5fd7...06315f )

Session::loans() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like