34 lines
858 B
PHP
34 lines
858 B
PHP
<?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.';
|
|
}
|
|
}
|