Path: C:\
<?php
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date('d/m/Y -- G:i');
$grupo=$_GET['grupo'];$ds_grupo=$_GET['dsgrupo'];
$nf=$_GET['id'];
?>
<!DOCTYPE html>
<html lang='pt-br'>
<head>
<meta charset='utf-8'/>
<meta http-equiv="pragma" content="no-cache">
<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/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/ie-emulation-modes-warning.js'></script>
</head>
<style >
table:nth-child(even) {
border: 1px solid #d4d4d4}
td:nth-child(even) {
border: 1px solid #d4d4d4}
tr:nth-child(even) {
border: 1px solid #d4d4d4}
td {
padding: 1px 30px;
}
</style>
<body role='document'>
<div class='container'>
<td>
<?php
echo "<table width='100%'><tr><td><h2>Notas Fiscais para Validação Grupo: <span style='color: RED;'>".$ds_grupo."</h2></td></tr> <tr><td height='30' background='images/top-menubg.gif' > ";
echo $dateadded;
echo "</td> </tr> </table>";
?>
</td>
<div id="corpo" class="panel panel-primary">
<?php
require_once("conexao_srvtms.php");
$pergunta="SELECT nr_NotaFiscal as nrNF
,Convert(varchar(10), dt_Coleta,103) as dtColeta
,Convert(varchar(10), dt_Emissao,103) as dtEmissao
,Convert(varchar(44), ds_ChaveNFe) as chave
,nr_Conhecimento as CTe
,ds_Modelo as CFOP
,ds_Remetente as fornec
,cd_ServicoNotaFiscal as pedido
,qt_Volume as volume
,qt_Paletes as palete
,cm_Coleta as col
,nr_AR as nrAR
,ds_Status as obs
,ds_Situacao as bip
FROM dbo.tbdValidacao
WHERE id_GrupoCliente = '$grupo' and nr_NotaFiscal = '$nf'";
$result = sqlsrv_query( $conn, $pergunta , array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
while ($resultado = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC))
{
$dtColeta=$resultado['dtColeta'];
$CTe=trim($resultado['CTe']);
$coleta=trim($resultado['col']);
$dtEmissao=$resultado['dtEmissao'];
$CFOP=trim($resultado['CFOP']);
$pedido=trim($resultado['pedido']);
$fornec=trim($resultado['fornec']);
$nrNF=$resultado['nrNF'];
$palete=$resultado['palete'];
$volume=$resultado['volume'];
$chave=$resultado['chave'];
$nrAR=$resultado['nrAR'];
$obs=$resultado['obs'];
$bip=$resultado['bip'];
}
echo'<div class="panel-heading"><h3 class="panel-title" align="center">Nota Fiscal Salva : '.$nrNF.'</h3></div><div class="section"><form method="post" action="processa/proc_edit_validacao.php"><input id="grupo" name="grupo" type="hidden" value="'.$grupo.'"><input id="dsgrupo" name="dsgrupo" type="hidden" value="'.$ds_grupo.'"><input type="hidden" class="form-control" name="nrNF" value="'.$nrNF.'" ><div class="row"><div class="col-md-3"><label>Data Rec./Coleta:</label><input type="text" class="form-control" name="dtColeta" value="'.$dtColeta;
echo'" ></div><div class="col-md-3"><label>CTe:</label><input type="text" class="form-control" name="CTe" value="'.$CTe.'" ></div><div class="col-md-3"><label>Coleta NR:</label><input type="text" class="form-control" name="coleta" value="'.$coleta.'" ></div><div class="col-md-3"><label>Emissão:</label><input type="text" class="form-control" name="dtEmissao" value="'.$dtEmissao.'" ></div><div class="col-md-3"><label>Pedido:</label><input type="text" class="form-control" name="pedido" value="'.$pedido;
echo '" ></div><div class="col-md-2"><label>CFOP:</label><input type="text" class="form-control" name="CFOP" value="'.$CFOP.'"></div><div class="col-md-7"><label>Fornecedor:</label><input type="text" class="form-control" name="fornec" value="'.$fornec.'" ></div><div class="col-md-2"><label>Paletes:</label><input type="text" class="form-control" name="palete" value="'.$palete;
echo '"></div><div class="col-md-2"><label>Volumes:</label><input type="text" class="form-control" name="volume" value="'.$volume.'"></div><div class="col-md-8"><label>Chave NFe:</label><input type="text" class="form-control" name="chave" value="'.$chave.'"></div><div class="col-md-3"><label>AR</label><input type="text" class="form-control" name="nrAR" value="'.$nrAR.'"></div><div class="col-md-7"><label>OBS.:</label><input type="text" class="form-control" name="obs" value="'.$obs;
if ($bip=="S") {$sim="selected";}else{$sim="";}
if ($bip=="N") {$nao="selected";}else{$nao="";}
echo '"></div><div class="col-md-2"><label>Lançada? (S/N):</label><select class="form-control" name="bip"><option value="S" '.$sim.'>Sim</option><option value="N" '.$nao.'>Não</option></select></div><div class="col-sm-12" align="center"><button type="submit" class="btn btn-success">Salvar</button></div></div></form></div>';
?>
</div>
</div>
</body>
<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/docs.min.js'></script>
</html>