404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Remanejamento /
Filename : VieRemanejamentoSaldoExcel.php
back
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL); 
ob_start();
$path = getcwd();
////$Dados = $_GET;
$Lanc = new \App\gre\Models\ModRemanejamentoSaldoLer();
$arr = $Lanc->lerLanc();
//var_dump($arr);
//die;
//var_dump($arr_filial);
$origem = $arr[0]['filial_origem'];
$data_criado = $arr[0]['data'];
$usuario = $arr[0]['usuario'];
$dtxls = date("dmYHi");
$arquivo = "SALDO_REMANEJAMENTO_LOJA_".str_pad($origem,2,0, STR_PAD_LEFT)."_"."$dtxls.xls";
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");
header ("Content-type: application/x-msexcel");
header ("Content-Disposition: attachment; filename=\"{$arquivo}\"" );
header ("Content-Description: PHP Generated Data" );
?>
<html>
<head>
  	<meta http-equiv='Content-Type' content='text/html; charset=utf-8'/>
</head>
<?php 
$html  = "";
$html .= "<table border='1'>";
$html .="<tr>";
$html .="<td colspan='3' align='center'><b>Gerado em: $data_criado</td>";
$html .="<td colspan='3' align='center'><b>Por: $usuario</td>";
$html .="</tr>";
$html .="<tr>";
$html .="<td align='center'><b>Filial Origem</td>";
$html .="<td align='center'><b>Cod. Prod</td>";
$html .="<td align='center'><b>Descrição</td>";
$html .="<td align='center'><b>Curva</td>";
$html .="<td align='center'><b>Qtde Transferir</td>";
$html .="<td align='center'><b>Seção</td>";
$html .="</tr>";

foreach ($arr as $lcto) {
   
    extract($lcto);
	$html .="<tr>";
            $html .="<td align='right'>     $filial_origem</td>";
            $html .="<td align='right'>     $produto_id</td>";
            $html .="<td align='left'>      $prod_nome</td>";		
            $html .="<td align='center'>    $curva</td>";
            $html .="<td align='center'>     $qtde_ped</td>";
            $html .="<td align='left'>     $secao_nome</td>";
	$html .="</tr>";
		}
$html .= "</table>";
$html .= "<br>";
echo $html;
exit;  
?>
</html>