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 P.EMPRESA as 'FIL1', P.LOCAL as 'FIL2', P.CHAPA as 'MAT', P.AREA as 'AREA', P.PAG_BANCO as 'COD_BANCO', B.DESCRICAO as 'DESCRICAO', P.PAG_AGENCIA as 'AGENCIA', P.PAG_CONTA as 'CONTA' FROM PESSOAL as P, BANCOS as B where P.DEMISSAO is null and P.PAG_BANCO = B.CODIGO"; //Digite SQL aqui
$process = odbc_exec($sqlconnect, $query);
while ($row = odbc_fetch_array($process)){
if(strlen($row['FIL1']) == 4) $fil1 = substr($row['FIL1'], 1, 3);
else $fil1 = $row['FIL1'];
if(strlen($row['FIL2']) == 4) $fil2 = substr($row['FIL2'], 1, 3);
else $fil2 = $row['FIL2'];
$filial = $fil1.'0'.$fil2;
echo $filial.";".$row['MAT'].";".$row['AREA'].";".$row['COD_BANCO'].";".$row['DESCRICAO'].";".$row['AGENCIA'].";".$row['CONTA']."
";
}
?>