You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
540 B
19 lines
540 B
<?php
|
|
|
|
namespace App\Domains\Academic\Queries\Lookup;
|
|
|
|
use App\Domains\Academic\Models\Term;
|
|
use Illuminate\Support\Collection;
|
|
|
|
class TermLookup
|
|
{
|
|
public static function fetch(bool $odd = false, $search = null): Collection
|
|
{
|
|
return once(fn () => Term::query()
|
|
->select(['name'])
|
|
->when($search, fn ($query) => $query->where('name', 'like', "%{$search}%"))
|
|
->when($odd, fn ($query) => $query->where('semester', 1))
|
|
->latest('date_start')
|
|
->pluck('name'));
|
|
}
|
|
}
|
|
|