Fórum Atualizar um Relatório sem perder as variáveis do post #598704

<?php 
include "menu.php";
include "../conexao.php";


?>
			
			<!-- start: Content -->
			<div id="content" class="span10">
			
			<ul class="breadcrumb">
				<li>
					<i class="icon-home"></i>
					<a href="index.html">Home</a> 
					<i class="icon-angle-right"></i>
				</li>
				<li><a href="#">Produtos/Vencimento</a></li>
			</ul>

			<div class="row-fluid sortable">		
				<div class="box span12">
					<div class="box-header" data-original-title>
						<h2><i class="halflings-icon user"></i><span class="break"></span>Produtos</h2>
						<div class="box-icon">
							
							<a href="#" class="btn-minimize"><i class="halflings-icon chevron-up"></i></a>
							<a href="#" class="btn-close"><i class="halflings-icon remove"></i></a>
						</div>
					</div>
		
                	<div class="box-content">
						<table class="table table-striped table-bordered bootstrap-datatable datatable">
						  <thead>
							  <tr>
                              <th>Seq.Produto</th>
                              <th>Descrição</th>
                              
								  <th>Quantidade</th>
                                  <th>Vencimento</th>
                                  <th>Categoria</th>
								  <th>Media de Venda</th>
                                  <th>Dias Restantes</th>
                                  <th>Loja</th>
								  <th>Ação</th>
                                  <th>Inativar</th>
							  </tr>
						  </thead>   
						  <tbody>
       
                    <?php 
					
				    $loja = $_POST[''loja''];
					$categoria = $_POST[''categoria''];
	  // ######################################################################
  function formatarData($data){
      $rData = implode("-", array_reverse(explode("/", trim($data))));
      return $rData;
   }
$data1 = formatarData($_POST[''data1'']);
  function formatarData_a($data_a){
      $rData_a = implode("-", array_reverse(explode("/", trim($data_a))));
      return $rData_a;
   }
   $data2 = formatarData_a($_POST[''data2'']);
// ######################################################################
include ("../conexao.php");
//$usuario = $_SESSION[''usuario''];
$stid = "SELECT b.id, b.codigo, a.codacesso, a.seqproduto, a.desccompleta, b.quantidade, b.data_vencimento, b.data_atual, b.observacao, b.usuario, b.estado, b.loja, a.medvdiageral, a.categoria
FROM master_datas a, master_coletores b
WHERE b.tipo_acao IS NULL and a.categoria = :categoria and a.nroempresa = :loja and b.loja = :loja and estado = ''Ativo'' and b.codigo = a.codacesso AND b.data_vencimento BETWEEN TO_DATE(:data1,''YYYY-MM-DD'') AND TO_DATE(:data2,''YYYY-MM-DD'') ORDER BY b.data_vencimento, b.codigo ASC";
$stmt = oci_parse($conexao, $stid);
    oci_bind_by_name($stmt, '':data1'', $data1);
	oci_bind_by_name($stmt, '':data2'', $data2);
	oci_bind_by_name($stmt, '':loja'', $loja);
	oci_bind_by_name($stmt, '':categoria'', $categoria);
oci_execute($stmt);
while (($array = oci_fetch_array($stmt, OCI_BOTH)) != false) {

					$id = $array["ID"];
					?>                        
							<tr>
								<td> <?php echo $array[''SEQPRODUTO'']; ?></td>
								<td><?php echo $array[''DESCCOMPLETA'']; ?></td>
                                
                                <td><?php echo $array[''QUANTIDADE'']; ?></td>
                                <td><?php echo $array[''DATA_VENCIMENTO'']; ?></td>
                                <td><?php echo $array[''CATEGORIA'']; ?></td>
                                <td><span class="label label-important"><?php  $media = $array[''MEDVDIAGERAL'']; echo round($media, 2) ?></span></td>
								<td>
                                 <?php
  if(strtotime($array[''DATA_VENCIMENTO'']) == 0) echo ''<b></b>'';
   else {
date_default_timezone_set(''America/Sao_Paulo'');
$dat1 = date(''Y-m-d'');
$dat2 = date(''d-m-Y'', strtotime($array[''DATA_VENCIMENTO'']));
$date1=date_create("$dat1");
$date2=date_create("$dat2");
$diff=date_diff($date1,$date2);
//echo $diff->format("%R%a dias");
if ($diff->format("%R%a dias") < 0) { 
echo ''<font style="color:#FF0206"> <b>'';
echo $diff->format("%R%a"); 
echo ''</b></font>'';
} else { 
echo ''<font style="color:#0E008A"> <b>'';
echo $diff->format("%R%a"); 
echo ''</b></font>'';
} }
?>
                                </td>
                                <td><span class="label label-success"><?php echo $array[''LOJA'']; ?></span></td>
                                <td class="center">
									<!--<a class="btn btn-success" href="#">
										<i class="halflings-icon white zoom-in"></i>  
									</a>-->
		<?php						echo"<a class=''btn btn-info'' href=''acao_comercial.php?ID=$id''>
										<i class=''halflings-icon white edit''></i>  
									</a>";  ?>
								<!--	<a class="btn btn-danger" href="#">
										<i class="halflings-icon white trash"></i> 
									</a>-->
								</td>
                               <td class="center">
									<!--<a class="btn btn-success" href="#">
										<i class="halflings-icon white zoom-in"></i>  
									</a> -->
		<?php						echo"<a class=''btn btn-danger'' href=''update_produto.php?ID=$id''>
										Inativar  
									</a>";  ?>
								<!--	<a class="btn btn-danger" href="#">
										<i class="halflings-icon white trash"></i> 
									</a -->
								</td> 
                                
							</tr>
						<?php  } ?>
						
						  </tbody>
					  </table>            
					</div> </div></div></div>

		

	
		
	<footer>

		<p>
			<span style="text-align:left;float:left">© 2015 Master Sonda - Erechim</span>
			
		</p>

	</footer>
	
	<!-- start: JavaScript-->

		<script src="js/jquery-1.9.1.min.js"></script>
	<script src="js/jquery-migrate-1.0.0.min.js"></script>
	
		<script src="js/jquery-ui-1.10.0.custom.min.js"></script>
	
		<script src="js/jquery.ui.touch-punch.js"></script>
	
		<script src="js/modernizr.js"></script>
	
		<script src="js/bootstrap.min.js"></script>
	
		<script src="js/jquery.cookie.js"></script>
	
		<script src=''js/fullcalendar.min.js''></script>
	
		<script src=''js/jquery.dataTables.min.js''></script>

		<script src="js/excanvas.js"></script>
	<script src="js/jquery.flot.js"></script>
	<script src="js/jquery.flot.pie.js"></script>
	<script src="js/jquery.flot.stack.js"></script>
	<script src="js/jquery.flot.resize.min.js"></script>
	
		<script src="js/jquery.chosen.min.js"></script>
	
		<script src="js/jquery.uniform.min.js"></script>
		
		<script src="js/jquery.cleditor.min.js"></script>
	
		<script src="js/jquery.noty.js"></script>
	
		<script src="js/jquery.elfinder.min.js"></script>
	
		<script src="js/jquery.raty.min.js"></script>
	
		<script src="js/jquery.iphone.toggle.js"></script>
	
		<script src="js/jquery.uploadify-3.1.min.js"></script>
	
		<script src="js/jquery.gritter.min.js"></script>
	
		<script src="js/jquery.imagesloaded.js"></script>
	
		<script src="js/jquery.masonry.min.js"></script>
	
		<script src="js/jquery.knob.modified.js"></script>
	
		<script src="js/jquery.sparkline.min.js"></script>
	
		<script src="js/counter.js"></script>
	
		<script src="js/retina.js"></script>

		<script src="js/custom.js"></script>
	<!-- end: JavaScript-->
	
</body>
</html>

<?php

include "../conexao.php";
	

$id = $_GET[''ID''];
$estado = ''Inativo'';
$sql = "UPDATE MASTER_COLETORES SET ESTADO = ''$estado'' WHERE ID = $id";
$stmt = oci_parse($conexao, $sql);
$result = oci_execute($stmt);
if ($id == TRUE) {
	
	echo ''<script> alert ("Cadastro alterado com sucesso!"); location.href=("filtro_vencimento.php")</script>'';

} else {
	 echo ''<script> alert ("Por favor, pree