Path: C:\
<?php
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("d/m/Y -- G:i");
$hoje=date('d-m-Y');
if (isset($_POST['grupo'])){$grupo=$_POST['grupo'];$ds_grupo=$_POST['dsgrupo'];$dia=$_POST['dia'];}
$arqxlsx="LIBERAÇÃO DE NOTAS ".$ds_grupo.".xlsx";
$ano=substr($dia, 6);
$mes=substr($dia, 3,-5);
$dia=$ano.$mes.substr($dia, 0,-8);
require_once("conexao_srvtms.php");
$query=sqlsrv_query($conn, "SELECT Convert(varchar(10), a.dt_Coleta,103) as coleta
,b.nr_NotaFiscalInteiro as nrNF
,Convert(varchar(40), a.ds_Remetente) as fornecedor
,b.cd_ServicoNotaFiscal as pedido
,b.ds_ChaveNFe as chave
,c.ds_Pessoa as destinatario
,Convert(varchar(10), e.dt_Liberar,105) as liberar
FROM dbo.tbdMovimento AS a
left JOIN dbo.tbdMovimentoNotaFiscal AS b ON a.id_Movimento = b.id_Movimento
left JOIN dbo.tbdRigesa AS e ON b.ds_ChaveNFe = e.ds_ChaveNFe
left JOIN dbo.tbdPessoa AS c on a.cd_CGCCPF = c.cd_CGCCPF
left JOIN dbo.tbdConfiguracaoCliente AS d on d.id_Pessoa = c.id_Pessoa
WHERE a.nr_Conhecimento='' and d.id_GrupoCliente=$grupo and Convert(varchar(10), a.dt_Coleta,112)>=$dia and a.id_TipoMovimento<>'5' and a.id_TipoMovimento<>'109' order by Convert(varchar(8), a.dt_Coleta,112) ASC", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
$quant = 0;
while ($res = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)) {
$liberar[$quant]=$res['liberar'];
$coleta[$quant]=$res['coleta'];
$nrNF[$quant]=$res['nrNF'];
$fornecedor[$quant]=str_replace(',', ' ', trim($res['fornecedor']));
$destinatario[$quant]=str_replace(',', ' ', trim($res['destinatario']));
$pedido[$quant]=trim($res['pedido']);
$chave[$quant]=trim($res['chave']);
if ($liberar[$quant]===NULL){$liberar[$quant]=$hoje;$grava[$quant]='1';}else{$grava[$quant]='0';}
$quant++;
}
?>
<!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 rel='icon' type='image/png' href='images/favicon.ico'>
<link href="css/estilo.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="css/redmond/jquery-ui-1.10.1.custom.css" />
<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/checkbox.js'></script>
<script src='js/jquery.min.js'></script>
<script src="js/ie-emulation-modes-warning.js"></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"> Notas Fiscais Aguardando Liberação : <span style='color: Yellow;'>Grupo <?php echo $ds_grupo;?></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="geraLiberacao.php" >
<tr align="center" STYLE='color: red;font-weight: bold;'>
<td>Data Coleta</td>
<td>N.Fiscal</td>
<td>Fornecedor</td>
<td>Pedido</td>
<td>Destinatário</td>
<td>Chave Nfe</td>
<td>1ª Liberação</td>
<td></td>
</tr>
<?php
echo '<input type="hidden" name="tudo" onclick="verificaStatus(this)" />';
for ($singleRow = 0; $singleRow < $quant; $singleRow++)
{
echo '<tr style="font-size:11px;">
<input type="hidden" name="grava[]" value="'.$grava[$singleRow].'">
<input type="hidden" name="liberar[]" value="'.$liberar[$singleRow].'">
<input type="hidden" name="coleta[]" value="'.$coleta[$singleRow].'">
<input type="hidden" name="nrNF[]" value="'.$nrNF[$singleRow].'">
<input type="hidden" name="fornecedor[]" value="'.$fornecedor[$singleRow].'">
<input type="hidden" name="pedido[]" value="'.$pedido[$singleRow].'">
<input type="hidden" name="destinatario[]" value="'.$destinatario[$singleRow].'">
<input type="hidden" name="chave[]" value="'.$chave[$singleRow].'">
<td align="center">'.$coleta[$singleRow].'</td>
<td align="center" >'.$nrNF[$singleRow].'</td>
<td align="left">'.$fornecedor[$singleRow].'</td>
<td align="center">'.$pedido[$singleRow].'</td>
<td align="center">'.$destinatario[$singleRow].'</td>
<td align="center">'.$chave[$singleRow].'</td>
<td align="center">'.$liberar[$singleRow].'</td>
<td align="center"><input type="checkbox" name="del[]" value="'.$singleRow.'" ></td>
</tr>';
}
echo '<tr>
<input id="dsgrupo" name="dsgrupo" type="hidden" value="'.$ds_grupo.'"/>
<input id="arqxlsx" name="arqxlsx" type="hidden" value="'.$arqxlsx.'"/>
<td align="center" colspan="4"><button type="submit" class="btn btn-danger" >Montar Arquivo ZIP</button></td>
<td align="right" colspan="4"><input type="checkbox" name="tudo" onclick="verificaStatus(this)" /><span style="color: red;font-weight:bold"> Marcar/Desmarcar (Tudo)</span></td>
</tr>';
?>
</form>
<tr>
<form method="GET" action="grupo6.php">
<td colspan="5" align="center">
<button type="submit" class="btn btn-success">Voltar</button>
</td>
</form>
</tr>
</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>