Laravel Eloquet AND-OR-AND Undefined variable

Question

I have a function in the Repository to list only the employees not dismissed on a certain date

use Parametergroup, but the condition does not find the $date parameter of the function, giving the error: "Undefined variable: date"

public function listarFuncionariosAtivos($data) 
{
    $funcionarios = Funcionario::where('demitido', '0')
                              ->orWhere(function($query) {
                                  $query->whereNotNull('data_demissao')
                                        ->where('data_demissao', '>=', $data);
                              })
                        ->orderBy('nome')
                        ->get(['id','nome','salario','data_admissao','data_demissao']); 

    return $funcionarios;

}

Answer 1

The scope of variables in PHP are not accessible in sub-functions, you must use the use () to access the variables of a "scope above":

->orWhere(function ($query) use ($data) {
    $query->whereNotNull('data_demissao')
          ->where('data_demissao', '>=', $data);

How did I respond in What is the purpose of the "use" command and what is its relation to Anonimas functions?