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;
}
}
