Example #1
0
 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);
         }
     }
 }