Path: C:\
<?php
ini_set('max_execution_time',259200);
ini_set ('memory_limit','-1');
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("d/m/Y -- G:i");
if (isset($_POST['grupo'])) {$grupo=$_POST['grupo'];$ds_grupo=$_POST['dsgru'];} else {$grupo="nulo";$ds_grupo="TODOS";}
if (isset($_POST['fornecedor'])) {$faturado=$_POST['fornecedor'];} else {$faturado="nulo";}
if ($grupo!='nulo'){$where=" AND d.id_GrupoCliente='$grupo' ";$cabec="GRUPO ".$ds_grupo;}else{if ($faturado!='nulo'){$where=" AND a.id_ClienteFaturamento='$faturado' ";}else{$where="";}}
if (isset($_POST['dia'])){$dia=$_POST['dia'];}
$ano=substr($dia, 6);
$mes=substr($dia, 3,-5);
$dia=$ano.$mes.substr($dia, 0,-8);
require_once("../conexao_srvtms.php");
$tsql="SELECT convert(varchar(10),a.dt_Atualizacao,103) as coleta
,convert(varchar(5),a.dt_Atualizacao,108) as hora
,Convert(varchar(44), b.ds_ChaveNFe) as chave
,b.nr_NotaFiscalInteiro as nrNF
,a.ds_Remetente as fornecedor
,c.ds_Pessoa as empresa
,a.vl_NotaFiscal as valor
,a.qt_Volume as volume
,b.cd_ServicoNotaFiscal as pedido
,h.ds_Cliente as origem
,a.ds_Cliente as destino
,g.ds_Embalagem as embalagem
FROM dtbtransporte.dbo.tbdMovimento AS a
left JOIN dtbtransporte.dbo.tbdMovimentoNotaFiscal AS b ON a.id_Movimento = b.id_Movimento
left JOIN dtbtransporte.dbo.tbdPessoa AS c on a.cd_CGCCPF = c.cd_CGCCPF
left JOIN dtbtransporte.dbo.tbdConfiguracaoCliente AS d on d.id_Pessoa = c.id_Pessoa
left join dtbtransporte.dbo.tbdEmbalagem as g on a.id_Embalagem = g.id_Embalagem
left join dtbtransporte.dbo.tbdClienteSistema as h on a.id_Cliente = h.id_Cliente
WHERE Convert(varchar(10), a.dt_Coleta,112)>=$dia and a.id_TipoMovimento<>'5' and a.id_TipoMovimento<>'109'";
$tsql=$tsql.$where." order by Coleta ASC";
$query=sqlsrv_query($conn, $tsql, array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
$quant = 0;
while ($res = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)) {
$empresa=$res['empresa'];
$coleta[$quant]=$res['coleta'];
$hora[$quant]=trim($res['hora']);
$nrNF[$quant]=$res['nrNF'];
$valor[$quant]=$res['valor'];
$volume[$quant]=$res['volume'];
$embalagem[$quant]=str_replace(',', ' ', trim($res['embalagem']));
$fornecedor[$quant]=str_replace(',', ' ', trim($res['fornecedor']));
$destino[$quant]=str_replace(',', ' ', trim($res['destino']));
$origem[$quant]=str_replace(',', ' ', trim($res['origem']));
$pedido[$quant]=trim($res['pedido']);
$chave[$quant]=trim($res['chave']);
$quant++;}
if($faturado!='nulo'){if ($quant<>0){$cabec=$empresa;}else{$cabec='';}}
?>
<!DOCTYPE html>
<html lang='pt-br'>
<head>
<meta charset='utf-8'/>
<meta http-equiv="Cache-Control" content="no-cache, no-store, must-revalidate" />
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="Expires" content="0" />
<meta content='width=device-width, initial-scale=1, maximum-scale=1' name='viewport'>
<title>TransWar</title>
<link href='../images/favicon.ico' rel='icon' type='image/png'>
<link href="../css/estilo.css" rel="stylesheet" type="text/css"/>
<link href="../css/redmond/jquery-ui-1.10.1.custom.css" rel="stylesheet"/>
<link href="../css/bootstrap.min.css" rel="stylesheet">
<link href="../css/bootstrap-theme.min.css" rel="stylesheet">
<link href="../css/theme.css" rel="stylesheet">
<link href="../css/signin.css" rel="stylesheet">
<script src='../js/jquery.min.js'></script>
<script src='../js/checkbox.js'></script>
<script src="../js/ie-emulation-modes-warning.js"></script>
<script type='text/javascript' >
function eMail(){
window.open('about:blank','email','toolbar=no, status=no, menubar=no, scrollbars=no, resizable=no, width=800, height=500, top=50, left=280');
document.formEmail.submit();
}
</script>
</head>
<body role='document'>
<div class="container">
<table width="100%">
<tr>
<td><img src="../images/logo03.png" width="408" height="88" /></td>
<td><div class="page-header">
<h2><span class="label label-primary"> Controle de Entregas : <span style='color: Yellow;'><?php echo $cabec; ?></span></span></h2>
</div></td>
</tr>
<tr>
<td height="30" colspan="2" background="../images/top-menubg.gif" > <?php echo $dateadded; ?></td>
</tr>
</table>
<div class='panel panel-primary'>
<table class="table table-bordered">
<tbody>
<form method="POST" action="entregas02.php" name='formEmail' target='email'>
<input id='cabec' name='cabec' type='hidden' value="<?php echo $cabec; ?>"/>
<tr align="center" STYLE='color: red;font-weight: bold;'>
<td>Data Coleta</td>
<td>Hora</td>
<td>N.Fiscal</td>
<td>Fornecedor</td>
<td>Pedido</td>
<td>Chave Nfe</td>
</tr>
<?php
echo '<input type="hidden" name="tudo" onclick="verificaStatus(this)" />';
for ($singleRow = 0; $singleRow < $quant; $singleRow++)
{
echo '<tr>
<input type="hidden" name="pedido[]" value="'.$pedido[$singleRow].'">
<input type="hidden" name="fornecedor[]" value="'.$fornecedor[$singleRow].'">
<input type="hidden" name="nrNF[]" value="'.$nrNF[$singleRow].'">
<input type="hidden" name="hora[]" value="'.$hora[$singleRow].'">
<input type="hidden" name="coleta[]" value="'.$coleta[$singleRow].'">
<input type="hidden" name="valor[]" value="'.$valor[$singleRow].'">
<input type="hidden" name="volume[]" value="'.$volume[$singleRow].'">
<input type="hidden" name="embalagem[]" value="'.$embalagem[$singleRow].'">
<input type="hidden" name="destino[]" value="'.$destino[$singleRow].'">
<input type="hidden" name="origem[]" value="'.$origem[$singleRow].'">
<input type="hidden" name="chave[]" value="'.$chave[$singleRow].'">
<td align="center">'.$coleta[$singleRow].'</td>
<td align="center">'.$hora[$singleRow].'</td>
<td align="center" >'.$nrNF[$singleRow].'</td>
<td align="left">'.$fornecedor[$singleRow].'</td>
<td align="center">'.$pedido[$singleRow].'</td>
<td align="center">'.$chave[$singleRow].'
<input type="checkbox" name="del[]" value="'.$singleRow.'" ></td>
</tr>';
}
echo '<tr>
<td align="center" colspan="5"><button type="submit" class="btn btn-danger" onclick="javascript:eMail();">Montar Arquivo ZIP</button>
</td>
<td align="center"><input type="checkbox" name="tudo" onclick="verificaStatus(this)" /><span style="color: red;font-weight:bold"> Marcar/Desmarcar (Tudo)</span>
</td>
</tr>';
?>
</form>
<form method="GET" action="index.php">
<tr>
<td colspan="6" align="center">
<button type="submit" class="btn btn-success">Voltar</button>
</td>
</tr>
</form>';
</tbody>
</table>
</div>
</div>
<p class="copyright" align="center">© Copyright 2018 TransWar - Todos os direitos reservados. Versão 1.0</p>
<br />
<script src="../js/bootstrap.min.js"></script>
<script src="../js/jquery-1.9.1.js" type="text/javascript"></script>
<script src="../js/jquery-ui.js" type="text/javascript"></script>
<script src="../js/docs.min.js"></script>
<script src="../js/ie10-viewport-bug-workaround.js"></script>
</body>
</html>