public function import($url) { $xmlObj = simplexml_load_file($url); $gabineteAoDb = new app_importer_ao_db_Gabinetes(); $gabineteBeanDb = new app_importer_bean_db_Gabinetes(); $gabineteAoDb->truncate(); $vereadorAoDb = new app_importer_ao_db_Vereadores(); $vereadorBeanDb = new app_importer_bean_db_Vereadores(); $arrayErroVereador = array(); foreach ($xmlObj as $vereador) { $vereadorBeanDb = $vereadorAoDb->getByNomeFix($vereador->NOME_PARLAMENTAR); $vereadorBeanDb->id; if ($vereadorBeanDb->id != 0) { $gabineteBeanDb->id = 0; $gabineteBeanDb->id_vereador = $vereadorBeanDb->id; $gabineteBeanDb->num_gabinete = (int) $vereador->GV; $gabineteBeanDb->ramal = (string) $vereador->RAMAL; $gabineteBeanDb->fax = (string) $vereador->FAX; $gabineteBeanDb->sala = (string) $vereador->SALA; $gabineteAoDb->upsert($gabineteBeanDb); } else { $nome = (string) $vereador->NOME_PARLAMENTAR; $arrayErroVereador[$nome] = "ERRO"; } } if (count($arrayErroVereador) > 0) { ksort($arrayErroVereador); echo "Vereadores não encontrados: \n"; foreach ($arrayErroVereador as $k => $v) { echo " - " . $k . "\n"; } } }
public function import($url) { $xmlObj = simplexml_load_file($url); $gabineteFuncionarioAoDb = new app_importer_ao_db_GabinetesFuncionarios(); $gabineteFuncionarioBeanDb = new app_importer_bean_db_GabinetesFuncionarios(); $gabineteFuncionarioAoDb->truncate(); $gabineteAoDb = new app_importer_ao_db_Gabinetes(); $gabineteBeanDb = new app_importer_bean_db_Gabinetes(); foreach ($xmlObj->Funcionario as $funcionario) { $strCentoCusto = (string) $funcionario->Centro_de_Custos; $strCentoCusto = strtoupper($strCentoCusto); if (substr_count($strCentoCusto, "VEREADOR") > 0) { $num_gab = preg_replace('/[^0-9]/', '', $strCentoCusto); $gabineteBeanDb = $gabineteAoDb->getByNumGab($num_gab); $gabineteFuncionarioBeanDb->id = 0; $gabineteFuncionarioBeanDb->id_gabinete = $gabineteBeanDb->id; $gabineteFuncionarioBeanDb->nome = (string) $funcionario->Nome_Servidor; $gabineteFuncionarioBeanDb->cargo = (string) $funcionario->Descricao_Cargo; $gabineteFuncionarioAoDb->upsert($gabineteFuncionarioBeanDb); } } }