<?php

namespace App\Rules\Sigtap;

use Illuminate\Contracts\Validation\Rule;
use Illuminate\Support\Facades\DB;

class CompetenciaIsValid implements Rule
{
    public function passes($attribute, $value)
    {
        return self::isValid($value);
    }

    public static function isValid($value, $competenciaExportacaoId = null)
    {
        $competencias = DB::table('sigtap.competencia')
            ->select('id')
            ->when(is_numeric($competenciaExportacaoId), function ($query) use ($competenciaExportacaoId) {
                $query->where('sigtap.competencia.id', '<=', $competenciaExportacaoId);
            })
            ->orderByDesc('valor')
            ->limit(4)
            ->pluck('id');

        return $competencias->contains($value);
    }

    public function message()
    {
        return 'Competência inválida.';
    }
}