use Illuminate\Database\Query\Builder;

class CustomListFailed extends Command
{
    protected $name = 'queue:custom-list-failed
        {--today}
        {--queue : The queue the job is run on.}
        {--sort-direction=desc : Sort direction.}
        {--job-name : Sort direction.}
        {--limit=10 : Sort direction.}
    ';

    protected $description = 'Filter and list failed jobs.';

    protected Builder $query;

    public function handle(): void
    {
        $this->setQuery(
                app('queue.failer')->getTable()
            )
            ->today()
            ->queue()
            ->jobName()
            ->order()
            ->limit()
            ->query()
            ->get()
            // Format each record before display.
            ->map(fn ($record) => ...);
    }

    public function query(): Builder
    {
        return $this->query;
    }

    protected function setQuery(Builder $query): self
    {
        $this->query = $query;

        return $this;
    }

    protected function today(): self
    {
        if ($this->option('today')) {
            $this->query->whereDate('failed_at', now()->format('Y-m-d'));
        }

        return $this;
    }

    protected function queue(): self
    {
        if ($this->option('queue')) {
            $this->query->where('queue', $this->option('queue'));
        }

        return $this;
    }

    protected function jobName(): self
    {
        if ($this->option('job-name')) {
            $this->query->where('payload->displayName', $this->option('job-name'));
        }

        return $this;
    }

    protected function order(): self
    {
        $this->query->orderBy($this->option('sort-direction'));

        return $this;
    }

    protected function limit(): self
    {
        return $this->query->limit($this->option('limit'));

        return $this;
    }
}