Path: C:\
<?php
ini_set('max_execution_time', 300); //300 seconds = 5 minutes
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("d-m-Y");
$dia = date("d/m/Y");
$grupo=$_GET['grupo'];$ds_grupo=$_GET['dsgrupo'];
$arqxlsx="validacao_".$ds_grupo.".xlsx";
require_once("conexao_srvtms.php");
$result = sqlsrv_query( $conn, "SELECT nr_NotaFiscal as nrNF, ds_Situacao as sit FROM dbo.tbdValidacao
WHERE id_GrupoCliente=".$grupo." order by nrNF ASC", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
$res = 1;
while ($resultado = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
$nrNF[$res]=$resultado['nrNF'];
$sit[$res]=$resultado['sit'];
$res++; }
?>
<!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/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 class='panel panel-primary'>
<div class='panel-heading'>
<h3 class='panel-title' align='center'>Notas Fiscais Salvas</h3>
</div>
<div id="lista">
<script type="text/javascript">
$(document).ready(function(e)
{
$("#datepicker").datepicker(
{
showOn: "button",
buttonImage: "images/calendario.png",
buttonImageOnly: true,
maxDate: "0d",
minDate: "-2m",
dayNamesMin: ['D','S','T','Q','Q','S','S','D'],
dayNamesShort: ['Dom','Seg','Ter','Qua','Qui','Sex','Sáb','Dom'],
dayNames: ['Domingo','Segunda','Terça','Quarta','Quinta','Sexta','Sábado'],
monthNamesShort: ['Jan','Fev','Mar','Abr','Mai','Jun','Jul','Ago','Set','Out','Nov','Dez'],
monthNames: ['Janeiro','Fevereiro','Março','Abril','Maio','Junho','Julho','Agosto','Setembro','Outubro','Novembro','Dezembro'],
dateFormat: 'dd/mm/yy',
nextText: 'Próximo',
prevText: 'Anterior',
onSelect: function( selectedDate )
{ var option = this.id == "dia" ? "minDate" : "maxDate",
instance = $( this ).data( "datepicker" ),
date = $.datepicker.parseDate(
instance.settings.dateFormat ||
$.datepicker._defaults.dateFormat,
selectedDate, instance.settings );
dates.not( this ).datepicker( "option", option, date );
}
});
});
</script>
<?php
$allRows = $res;
echo '<form method="POST" action="apaganota.php"><input id="grupo" name="grupo" type="hidden" value='.$grupo.
'><input id="dsgrupo" name="dsgrupo" type="hidden" value="'.$ds_grupo.'"><table class="table table-bordered">';
for ($singleRow = 1; $singleRow < $allRows; $singleRow++) {
if ($singleRow === 1) {
echo '<tbody><tr>';
$item = 0;
}
if ($item === 7) {echo '</tr><tr>';
$item = 0;
}
if ($sit[$singleRow]=="N"){$sim='#F3F781';} else {$sim='#ffffff';}
echo '<td align="right" bgcolor="'.$sim.'">'.$nrNF[$singleRow].'<a href="alteranota.php?id='.$nrNF[$singleRow].'&grupo='.$grupo.'&dsgrupo='.$ds_grupo.'"><img src="images/editar.png"/></a><input type="checkbox" name="del[]" value="'.$nrNF[$singleRow].'"></td>';
$item++;
}
echo'</tr></tbody></table><div class="col-sm-2" align="center"><button type="submit" class="btn btn-danger" onclick="return confirm(\'Certeza que quer apagar as notas selecionadas?\')">Apagar Seleção</button></div></form>';
?>
</div>
<!-- voltar (início) -->
<form method='POST' action='validacao.php'>
<div class='col-sm-1' align='center'>
<input id='grupo' name='grupo' type='hidden' value="<?php echo $grupo;?>"/>
<input id='dsgrupo' name='dsgrupo' type='hidden' value="<?php echo $ds_grupo;?>"/>
<button type='submit' class='btn btn-success'>Voltar</button>
</div>
</form>
<!-- voltar (fim) -->
<!-- Confere (início) -->
<form id="form" name="form" method="post" action="compara.php" enctype="multipart/form-data">
<div id="from" class='col-sm-3' align='center'>
<input id='grupo' name='grupo' type='hidden' value="<?php echo $grupo;?>"/>
<input id='dsgrupo' name='dsgrupo' type='hidden' value="<?php echo $ds_grupo;?>"/>
<input type="text" name="dia" id="datepicker" value="<?php echo $dia;?>"/>
</div>
<div class='col-sm-1' align='center'>
<button type='submit' class='btn btn-success'>Confere</button>
</div>
</form>
<!-- Confere (fim) -->
<!-- apagar NF (início) -->
<form method='POST' action='apagalista.php'>
<div class='col-sm-2' align='center'>
<input id='grupo' name='grupo' type='hidden' value="<?php echo $grupo;?>"/>
<input id='dsgrupo' name='dsgrupo' type='hidden' value="<?php echo $ds_grupo;?>"/>
<button type='submit' class='btn btn-danger' onclick="return confirm('Certeza que quer apagar TODAS as notas?')">Apagar Todas</button>
</div>
</form>
<!-- apagar NF (fim) -->
<ol>
</ol>
</div>
</div>
<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>
<p class="copyright" align="center">© Copyright 2018 TransWar - Todos os direitos reservados. Versão 1.0</p>
<br />
</html>