<?php

namespace App\Nova\Filters;

use Illuminate\Http\Request;
use Laravel\Nova\Filters\Filter;

class UserAttemptStatus extends Filter
{
    /**
     * 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)
    {
        if ($value == 'complete') {
            return $query->whereHas('attempt', function ($q) {
                $q->whereNotNull('end_time');
            });
        } else if ($value == 'incomplete') {
            //intentionally wrapped inside a callback function in where
            //so that the orWhereDoesntHave doesn't interfere with other filters.
            //Otherwise the precedence of the queries of all filters is strange
            return $query->where(function ($q) {
                $q->whereHas('attempt', function ($q1) {
                    $q1->whereNull('end_time');
                })->orWhereDoesntHave('attempt');
            });
        } else {
            return $query;
        }
    }

    /**
     * Get the filter's available options.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return array
     */
    public function options(Request $request)
    {
        return [
            'Complete only' => 'complete',
            'Incomplete only' => 'incomplete'
        ];
    }
}