Path: C:\
<?php
date_default_timezone_set('America/Sao_Paulo');
$dateadded = date("d/m/Y");
require_once("../conexao_srvtms.php");
?>
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="ie=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1" />
<title>Transwar</title>
<link rel="icon" type="../image/png" href="../img/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" />
<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/jquery.mask.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('.fat').mask('0000000');
});
function Click() {
location.href='index.php';
}
function showCarga() {
document.getElementById('carga').style.display="block";
}
function hideCarga() {
document.getElementById('carga').style.display="none";
}
$(function() {
var dates = $( "#from, #to" ).datepicker({
altField: '#dia_to', defaultDate: null, setDate:null,
altField: '#dia_from', defaultDate: null, setDate:null,
showOtherMonths: true,
maxDate: "0d",
minDate: "-1y",
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 == "from" ? "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 );
}
});
$("input[name=Data]").click(function(e) {
$('#carga').show();
e.preventDefault();
var di = $("#from").val();
var df = $("#to").val();
var grupo = $("#gruforne").val();
var dsgru = $("#dsgru").val();
var fornecedor = $("#listafornecedores").val();
$.post("faturas01.php",
{ di: di, df: df,grupo: grupo,dsgru: dsgru,fornecedor: fornecedor},
function(data)
{
$("#resultados").html(data);
}
);
});
});
$(document).ready(function() {
$('input:radio[name="forne"]').on("change", function() {
if (this.checked && this.value == '1') {
$("#gru").show();
$("#empresa").hide();
} if (this.checked && this.value == '2') {
$("#empresa").show();
$("#gru").hide();
} if (this.checked && this.value == '9') {
$('#grupo').val('nulo');
$('#dsgru').val('TODOS');
$('#fornecedor').val('nulo');
$("#gru, #empresa").hide();
}
});
});
$(document).on('change', '#gruforne', function () {
var value = $(this).val();
var option = $(this).find("option:selected");
var dsgru = option.data('dsgru');
$('#listaforne').val('nulo');
$('#grupo').val(value);
$('#dsgru').val(dsgru);
});
$(document).ready(function() {
$('#termo_busca').keyup(function() {
$.ajax({
type: 'POST',
url: 'busca_ajax.php',
data: {
nome: $("#termo_busca").val()
},
success: function(data) {
$('#listafornecedores').html(data);
}
});
});
});
</script>
<style>
#listafornecedores, #gruforne { width:70%;height:25px; }
</style>
</head>
<body>
<div id="geral">
<div id="cabecalho" align="center" >
<h1><img src="../images/logo.png"></h1>
</div>
<div id="corpo">
<table width="100%" align="center" cellspacing="0" bgcolor="#E9E9E9">
<form id="form" name="form" method="post" action="" enctype="multipart/form-data">
<tr>
<td colspan="4" align="center" >
<h2 align="center">Controle de Faturas</h2>
</td>
</tr>
<tr>
<td> </td>
<td align="center" valign="middle">
<div align="left">
<strong>Escolha:</strong>
<p>
<input type="radio" name="forne" value="1"/>Grupo<br>
<input type="radio" name="forne" value="2"/>Empresa<br>
<input type="radio" name="forne" value="9" checked />Todos
</p>
</div>
</td>
<td colspan="2">
<div id="gru" style="display:none;" align="left">
<select id="gruforne" name="grupo" style="height: 30px;" class="form-control">
<option value="nulo" data-dsgru="TODOS" selected>Todos os Grupos</option>
<?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_gru=$row [ "ds_GrupoCliente" ];
echo "<option value=".$row [ "id_GrupoCliente" ]." data-dsgru=".$ds_gru." >".$ds_gru."</option>";
}
?>
</select>
</div>
<div id="empresa" style="display:none;" align="left">
Empresa: <input type="text" id="termo_busca" name="termo_busca"><br>
<select id="listafornecedores" name="fornecedor" onclick="if( $('#listafornecedores').html() == '' ){ alert('Sem resultados carregados.\n Faça uma busca digitando o nome de uma empresa.');}"></select>
</div>
</td>
</tr>
<tr>
<td align="center" valign="middle" width="40%" >
<div id="from">
<font size="4"><strong>Data inicial.</strong></font><br>
<input type="hidden" name="dia_from" required id="dia_from" value="<?php echo $dateadded;?>" class="form-control">
</div>
</td>
<td colspan="2" align="center" valign="middle" width="20%">
<table width="100%" align="center" >
<tr>
<td align="center" >
<input id='dsgru' name='dsgru' type='hidden' value="TODOS" />
<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>
<tr>
<td align="center" >
<?php
if (isset($_GET['arquivo'])) {$arqxlsx=$_GET['arquivo'];
echo '
<div id="alert" align="center">
<strong>Tabela EXCEL gerada com sucesso!</strong><br>
<a href="Excel/'.$arqxlsx.'" download onclick="Click(this);">Tecle p/ Baixar EXCEL</a>
</div>';}
?>
</td>
</tr>
</table>
</td>
<td align="center" valign="middle" width="40%" >
<div id="to">
<font size="4"><strong>Data final.</strong></font><br>
<input type="hidden" name="dia_to" required id="dia_to" value="<?php echo $dateadded;?>" class="form-control">
</div>
</td>
</tr>
</form>
</table>
</div>
<div id="resultados"></div>
</div>
</body>