How to return a collection of objects via ajax?

Question

I created this function in my Controller to return a list of employees in my ajax request, but it is not returning anything.

public function getFuncionarios(Request $request){
    if($info = Funcionario::where('id_empresa', $request->get('empresa'))){
         return response()->json($info);
    }else{
         return 'error';
    }
}

When I return the direct variable does not work either.

return $info;

But if I put the where to return only 1 record works.

$info = Funcionario::where('id_empresa', $request->get('empresa'))->first()

What can it be? What would be the right way to get the result I need? This list of employees would be to feed a <select>.

Answer 1

I went soft... just put the get in the end.

if($info = Funcionario::where('id_empresa', $request->get('empresa'))->get()){
    return $info;
}

Answer 2

To return a collection of objects, it can also be done as follows:

public function getFuncionarios(Request $request){

      $funcionarios = Funcionario::whereEmpresa($request->empresa)->get();
      if (!$funcionarios){
           return response()->json(['error' => 'Nenhum funcionário foi encontrado.']);
      }
      return response()->json($funcionarios);
}

to return a specific object:

public function getFuncionaio($id){

          $funcionario = Funcionario::find($id);

          return response()->json($funcionario);
    }