public function servicosEspecialidades($empresa_id = null) { try { $newList = array(); $ServicoModel = new Servico(); $sql = "SELECT DISTINCT\n\t\t\t\t\t\tServico.*\n\t\t\t\t\tFROM\n\t\t\t\t\t\tagentus_database.servicos AS Servico\n\t\t\t\t\t\t\tINNER JOIN\n\t\t\t\t\t\tagentus_database.tipos_servicos AS TipoServico ON TipoServico.servicos_id = Servico.id\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tServico.empresas_id = {$empresa_id};"; $servicos = $ServicoModel->query($sql); foreach ($servicos as $servico) { $object = new Servicos($servico['id'], $servico['nome']); $object->setEspecialidades($this->lista((int) $servico['id'])); $newList[] = $object; } return $newList; } catch (Exception $ex) { throw $ex; } }