Filter Between

[hussenk]

How to filter between two values.

$data = Car::where('year', '>=', $input['year_from'])->where('year', '<=', $input['year_to'] )->get();

[dogeow]

# controller
 $userQuery = QueryBuilder::for(User::query())
            ->allowedFilters([AllowedFilter::scope('year')]);
            
# model
public function scopeYear(Builder $query, $year): Builder
    {
        return $query
            ->where('year', '>=', $year)
            ->where('year', '<=', $year);
    }

[diegomartins404]

This wont work.

This code only accepts one "year" parameter.

The result will be:
SELECT * FROM USER WHERE YEAR >= X_VALUE AND YEAR <= X_VALUE

The need here is:
SELECT * FROM USER WHERE YEAR >= X_VALUE AND YEAR <= Y_VALUE

[syedabuthahirm]

You can use different separator /user?filter[year]=2024:2026

then in model

public function scopeYear($query, $year)
{
  $dates = explode(":", $year);
  return $query->whereBetween('year', $dates);
}
    

[syedabuthahirm]

There is a alternative without using custom separator

 /**
  * $value is already array
  * $property is equal to year_between
  */
  $callback = function ($query, $value, $property) {
      return $query->whereBetween('year', $value);
  };

  $users = QueryBuilder::for(User::class)
      ->allowedFilters([AllowedFilter::callback('year_between', $callback)])
      ->get();