404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / PontaGondola / Ruptura /
Filename : VieRupFilialProdExcelFilial.php
back
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL); 
ob_start();
$path = getcwd();
//VAR_DUMP(URLFPDF);
$Dados = $_GET;
//echo '<pre>';
//var_dump($Dados);
//echo '</pre>';
$Lanc = new \App\gre\Models\ModRupFilialProdFilialLer();
$arr = $Lanc->lerLanc($Dados);
//echo '<pre>';
//var_dump($arr);
//echo '</pre>';
//die;
$num_linhas = 40;
$cont_linha = 99999;
$cont_reg = 0;
$total_dia = 0;
$filial_nome = $arr[0]['filial_nome'];
$prod_cod = $arr[0]['prod_cod'];
$data_sel = $arr[0]['data']; 
$estoque_cd = $arr[0]['est_cd']; 
$dtxls = date("dmYHi");
$arquivo = "FALTAS PRODUTO_"."$prod_cod"."_"."$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='9' align='center'><b><font color='red'>Falta de Produtos em $data_sel</td>";
$html .="</tr>";
$html .= "<tr>";
$html .="<td  colspan='9' align='center'><b><font color='red'>Filial: $filial_nome </td>";
$html .="</tr>";
$html .="<tr>";
$html .="<td align='center'><b>Cod Prod</td>";
$html .="<td align='center'><b>Descrição</td>";

$html .="<td align='center'><b>Curva Filial</td>"; 
$html .="<td align='center'><b>Dias em Falta</td>";
$html .="<td align='center'><b>Venda/dia</td>"; 
$html .="<td align='center'><b>Estoque Loja</td>"; 
$html .="<td align='center'><b>Dias Estoque</td>";
$html .="<td align='center'><b>Custo Médio</td>";
$html .="<td align='center'><b>Falta/dia</td>"; 
$html .="</tr>";   
foreach ($arr as $lcto) {
   
    extract($lcto);
        $cmed =  number_format($cmed,2,',','.');
        $qtde_dia =  number_format($qtde_dia,4,',','.');
        $ven_dia =  number_format($ven_dia,2,',','.');
  	$html .="<tr>";
	$html .="<td align='right'>   $prod_cod</td>";
	$html .="<td align='left'>    $prod_nome</td>";		
	$html .="<td align='center'>  $curva</td>";
        $html .="<td align='center'>  $dias_recorr</td>"; 	
	$html .="<td align='right'>   $qtde_dia</td>"; 			
        $html .="<td align='right'>   $est_qtde</td>";
        $html .="<td align='right'>   $dias_est</td>";
        $html .="<td align='right'>  $cmed</td>";
	$html .="<td align='right'>   $ven_dia</td>"; 			
	$html .="</tr>";
}
			
$html .= "</table>";
$html .= "<br>";
echo $html;
exit;  
?>
</html>