Path: C:\
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="ie=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1" />
<title>Transwar</title>
<link rel="icon" type="image/png" href="img/favicon.ico">
<link href="css/estilo.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" media="all" href="css/contato.css"/>
</head>
<?php
require_once("conexao_srvtms.php");
$tsql= "SELECT a.id_Movimento
,a.nr_NotaFiscal
,a.cd_CGCCPF
,b.id_Movimento
,b.cd_NotaFiscal
,Convert(varchar(10), b.dt_Emissao,103) as dia
,Convert(varchar(44), b.ds_ChaveNFe) as chav
FROM dbo.tbdMovimento AS a RIGHT JOIN dbo.tbdMovimentoNotaFiscal AS b ON b.id_Movimento = a.id_Movimento
inner join dbo.tbdPessoa AS c on a.cd_CGCCPF = c.cd_CGCCPF
inner join dbo.tbdConfiguracaoCliente AS d on d.id_Pessoa = c.id_Pessoa
WHERE d.id_GrupoCliente =4 and a.id_Movimento > '577767'
order by a.id_Movimento asc ";
$consulta = sqlsrv_query($conn, $tsql, array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
if (!$consulta){echo "ATENÇÃOs!! FALHA NA CONSULTA!";}
$numReg1 = sqlsrv_num_rows($consulta);
$file_csv = fopen('brainfarma.csv', 'w');
$nf1='NF'; $chave1='999999';$dia1='9999/99/99'; $mov1="Movimento"; $l=1;$emissao="\Emissão NF"";$chave="\"Cheve NFe";
while ($row = sqlsrv_fetch_array($consulta, SQLSRV_FETCH_ASSOC))
{
$chave2="'".$row['chav'];
$dia2=$row['dia'];
$nf2=$row['nr_NotaFiscal'];
$mov2=$row['id_Movimento'];
if ($nf1!=$nf2) {$emissao=$emissao."\"";$chave=$chave."\""; $linha[$l] = array($nf1,$mov1,$emissao,$chave); ++$l;
$nf1=$nf2; $chave1=$chave2; $dia1=$dia2; $mov1=$mov2; $emissao="\"".$dia2; $chave="\"".$chave2;}
else
{ if ($dia1!=$dia2){$emissao=$emissao.";".$dia2; $dia1=$dia2;}
if ($chave1!=$chave2) { $chave=$chave.";".$chave2; $chave1=$chave2;}
}
}
$emissao=$emissao."\"";$chave=$chave."\"";$linha[$l] = array($nf1,$mov1,$emissao,$chave);
for ( $i = 1; $i < $l; ++$i )
{$linha2 = $linha[$i][0]. ";" .$linha[$i][1] . ";" . $linha[$i][2].";".$linha[$i][3] . PHP_EOL;
fwrite($file_csv, $linha2);
}
fwrite($file_csv, $linha2);
fclose($file_csv);
echo "ENCERRADO";
?>
</html>