<?php
namespace App\Services;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\Log;
class PricingFilterService
{
public static function getOptions(): array
{
return [
'under_40' => 'Under 40',
'40_60' => '40 - 60',
'60_80' => '60 - 80',
];
}
public static function applyQuery(Builder $query, $value, $column): Builder
{
$query->whereNotNull($column);
return match ($value) {
'under_40' => $query->where($column, '<', 40),
'40_60' => $query->whereBetween($column, [40, 60]),
'60_80' => $query->whereBetween($column, [60, 80]),
default => $query,
};
}
}
<?php
namespace App\Services;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Support\Facades\Log;
class PricingFilterService
{
public static function getOptions(): array
{
return [
'under_40' => 'Under 40',
'40_60' => '40 - 60',
'60_80' => '60 - 80',
];
}
public static function applyQuery(Builder $query, $value, $column): Builder
{
$query->whereNotNull($column);
return match ($value) {
'under_40' => $query->where($column, '<', 40),
'40_60' => $query->whereBetween($column, [40, 60]),
'60_80' => $query->whereBetween($column, [60, 80]),
default => $query,
};
}
}