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