function con_personne(){
$odbc_dsn = 'DRIVER={SQL Server};SERVER=10.134.25.15;DATABASE=personne';
$odbc_user = "cetinu";
$odbc_pass = "!gcti@$";
$odbc_conn_personne = odbc_connect($odbc_dsn, $odbc_user, $odbc_pass) or die(odbc_error());
return $odbc_conn_personne;
}
$sqlconnect = con_personne();
$query = "SELECT B.CODIGO AS 'CODIGO', B.DESCRICAO AS 'DESCRICAO', A.AGE_BANCO AS 'AGE_BANCO'
FROM BANCOS AS B, AGENCIAS AS A
WHERE B.CODIGO = A.BANCO"; //Digite SQL aqui
$process = odbc_exec($sqlconnect, $query);
$client = new SoapClient("http://10.134.25.22:8081/ws/FIEWS010.apw?WSDL", array('trace' => 1));
$cont = 0;
while ($row = odbc_fetch_array($process)){
try{
if((strlen($row["AGE_BANCO"]) == 5) || (strlen($row["AGE_BANCO"]) == 7)){ $agebanco = substr($row["AGE_BANCO"], 0, -1); $dvage = substr($row["AGE_BANCO"], -1); }
elseif((strlen($row["AGE_BANCO"]) == 4) || (strlen($row["AGE_BANCO"]) == 4)){ $agebanco = $row["AGE_BANCO"]; $dvage = '0'; }
//Para "Cadastro de Centro de Custo - SA6
$dados->A6_AGENCIA = $agebanco;
$dados->A6_COD = $row["CODIGO"];
$dados->A6_DVAGE = $dvage;
$dados->A6_DVCTA = '0';
$dados->A6_FILIAL = ' ';
$dados->A6_NOME = utf8_encode($row["DESCRICAO"]);
$dados->A6_NREDUZ = '0';
$dados->A6_NUMCON = '0';
$resultado = $client->INC_ALT(array('DADOS' => $dados));
echo "SA6 - Sucesso!
";
} catch(SoapFault $e){
echo utf8_decode($e->getMessage())."
";
$cont++;
}
}
echo "
Total: ". $cont;
?>