<?php

namespace App\Nova\Filters;

use App\Models\Academy;
use Illuminate\Http\Request;
use Laravel\Nova\Filters\Filter;

class UserAcademy extends Filter
{
    /**
     * The filter's component.
     *
     * @var string
     */
    public $component = 'select-filter';

    public $name = 'Academy';

    /**
     * Apply the filter to the given query.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Illuminate\Database\Eloquent\Builder  $query
     * @param  mixed  $value
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function apply(Request $request, $query, $value)
    {
        return $query->whereHas('attempt', function($q) use($value) {
            $q->where('academy_id', $value);
        })->get();
    }

    /**
     * Get the filter's available options.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return array
     */
    public function options(Request $request)
    {
        $options = Academy::pluck('id', 'name')->toArray();
        
        return $options;
    }
}