Path: C:\
<?php
if (isset($_GET['arquivo'])) {$arqxlsx=$_GET['arquivo'];
echo "<!DOCTYPE html>
<html lang='pt-br'>
<head>
<meta http-equiv='Refresh' CONTENT='1;URL=http://192.168.0.251:5050/".$arqxlsx."'>
";}else{echo"<!DOCTYPE html>
<html lang='pt-br'>
<head>";}
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("d/m/Y -- G:i");
$hoje = date("d/m/Y");
$dia='';$grupo='';$ds_grupo='';
?>
<meta charset="utf-8"/>
<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/ie-emulation-modes-warning.js"></script>
<script src='js/jquery-1.10.2.min.js'></script>
<script src='js/jquery-ui.js' type='text/javascript'></script>
<script src="js/ie-emulation-modes-warning.js"></script>
<script src="js/ui.datepicker-pt-BR.js"></script>
<script type="text/javascript">
function showCarga()
{
document.getElementById('carga').style.display="block";
}
function hideCarga()
{
document.getElementById('carga').style.display="none";
}
$( function() {
$('#dia1').datepicker( $.datepicker.regional[ "pt-BR" ] );
});
$(document).on('change', '#meuselect', function () {
var value = $(this).val();
var option = $(this).find("option:selected");
var dsgrupo = option.data('dsgrupo');
$('#grupo').val(value);
$('#dsgrupo' ).val(dsgrupo);
});
</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"> CONSOLIDADO </span></h2>
</div></td>
</tr>
<tr>
<td height="30" colspan="2" background="images/top-menubg.gif" > <?php echo $dateadded; ?></td>
</tr>
</table>
<table class="table" align="center" >
<form id="form" name="form" method="post" action="geraconsolidado.php" enctype="multipart/form-data" onsubmit="return showCarga(this)">
<tr>
<td align="center">
<h4>Escolha o Grupo para o Consolidado:</h4>
<select id="meuselect" style="height: 30px; width:300px;" class="form-control" required>
<option value="">Selecione</option>
<?php
require_once("conexao_srvtms.php");
$tsql = "SELECT id_GrupoCliente, ds_GrupoCliente FROM tbdGrupoCliente where id_GrupoCliente>3 ORDER BY id_GrupoCliente ASC";
$row2= sqlsrv_query($conn, $tsql);
while ($row = sqlsrv_fetch_array($row2, SQLSRV_FETCH_ASSOC)) { $ds_grupo=$row [ "ds_GrupoCliente" ];
echo "<option value=".$row [ "id_GrupoCliente" ]." data-dsgrupo=".$ds_grupo." >".$ds_grupo."</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td align="center" >
<h4>Data Inicial:</h4>
<div id="from">
<input type="text" class='date' name="dia" id="dia1" value="<?php echo $hoje;?>"/>
</div>
</td>
</tr>
<tr>
<td 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="submit" name="Data" id="Data" class="button2" value="GERAR EXCEL" />
<div align="center" class="loading" id="carga" >
<img class="imgloading" src="images/tempo.gif" style="height:30; width:240">
</div>
</td>
</tr>
</form>
</table>
</div>
</body>
<p class="copyright" align="center">© Copyright 2018 TransWar - Todos os direitos reservados. Versão 1.0</p>
<br />
<script src="js/docs.min.js"></script>
<script src="js/ie10-viewport-bug-workaround.js"></script>
</html>