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 e.CODIGO as 'CODIGO', e.DESCRICAO as 'DESCRICAO'
FROM ESTR_EMPR as e, PESSOAL as p
WHERE e.CODIGO in (select AREA from PESSOAL group by AREA)
GROUP BY e.CODIGO, e.DESCRICAO
ORDER BY e.DESCRICAO"; //Digite SQL aqui
$process = odbc_exec($sqlconnect, $query);
$client = new SoapClient("http://10.134.25.22:8081/ws/FIEWS014.apw?WSDL", array('trace' => 1));
$cont = 0;
$aux = 1;
$depto = '';
while ($row = odbc_fetch_array($process)){
try{
if(strlen("".$aux) == 1) $depto = '0000'.$aux;
elseif(strlen("".$aux) == 2) $depto = '000'.$aux;
elseif(strlen("".$aux) == 3) $depto = '00'.$aux;
elseif(strlen("".$aux) == 4) $depto = '0'.$aux;
elseif(strlen("".$aux) == 5) $depto = $aux;
//Para "Cadastro de Centro de Custo - SQB
$dados->QB_CODAREA = $row["CODIGO"];
$dados->QB_DEPTO = $depto;
$dados->QB_DESCRIC = utf8_encode($row["DESCRICAO"]);
$dados->QB_FILIAL = '';
$resultado = $client->INC_ALT(array('DADOS' => $dados));
echo "SQB - Sucesso!
";
} catch(SoapFault $e){
echo utf8_decode($e->getMessage())."
";
$cont++;
}
$aux++;
}
echo "
Total: ". $cont;
?>