<?php

namespace App\Classes\General\Eloquent\Filters;

use Illuminate\Database\Eloquent\Builder;

class HasActiveRewardForAdmin implements Filter
{

    /**
     * @param Builder $builder
     * @param $value
     * @return Builder|mixed
     */
    public static function apply(Builder $builder, $value)
    {
        return $builder->where('user_id', $value)
        ->where(function ($query) {
            $query->whereHas('reward', function ($subquery) {
                $subquery->where('is_active', true);
            });
            // ->orWhereDoesntHave('reward');
        });
    }

}
