404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Analise_Mix /
Filename : VieMixExcel.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\ModListarAnaliseMix();
$arr = $Lanc->listAnalMix($Dados);
//var_dump ($arr[0]);
//die;
 setlocale(LC_TIME, 'pt_BR', 'pt_BR.utf-8', 'pt_BR.utf-8', 'portuguese');
            date_default_timezone_set('America/Sao_Paulo');
$perc_corte = $arr[0]['perc_corte'];
$perc_margem = $arr[0]['perc_mb'];
$linha = 0;
$data_imp = date("d/m/Y H:i:s");
$dtxls = date("dmYHi"); 
$dtxls = date("Y_m_d H:i:s"); 
$arquivo = "Analise_Mix"."$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 

foreach ($arr as $lcto) {
    
extract($lcto);
if ($linha== 0) {    
$html  = "";
$html .= "<table border='1'>";
$html .= "<tr>";
if ($filial_id > 0) {
    $html .="<td  colspan='21' align='center'><b><font color='blue'>Filial/Cluster: $filial_nome</td>";
}else{
    $html .="<td  colspan='21' align='center'><b><font color='blue'>Filial: TODAS</td>";
}    
$html .="</tr>";
$html .= "<tr>";
$html .="<td colspan='21' align='center'><b><font color='blue'>Seção: $secao_nome</td>";
$html .="</tr>";
$html .= "<tr>";
$html .="<td colspan='21' align='center'><b><font color='blue'>Grupo: $grupo_nome</td>";
$html .="</tr>";
$html .="<td colspan='21' align='center'><b><font color='blue'>SubGrupo: $subgrupo_nome</td>";
$html .="</tr>";
$html .="</tr>";
$html .="<td colspan='21' align='center'><b><font color='blue'>Classe: $classe_nome</td>";
$html .="</tr>";
$html .="</tr>";
$margem_toleravel = $perc_margem * 0.9;
$perc_margem_m = number_format($perc_margem,2,',','.').'%';
$margem_toleravel_m = number_format($margem_toleravel,2,',','.').'%';
$html .="<td   align='left'><b><font color='blue'>Perc Corte: $perc_corte</td>";
$html .="<td   align='left'><b><font color='blue'>Margem Média: $perc_margem_m</td>";
$html .="<td   align='left'><b><font color='red'>Margem Tolerável: $margem_toleravel_m</td>";
$html .="<td   colspan='18'align='left'></td>";
$html .="</tr>";
    $html .="<tr>";
    $html .="<td align='center'><b>Prod</td>";
    $html .="<td align='center'><b>Descrição do Produto</td>"; 
    $html .="<td align='center'><b>Marca</td>"; 
    $html .="<td align='center'><b>Curva</td>"; 
    $html .="<td align='center'><b>Qtde Estoque</td>"; 
    $html .="<td align='center'><b>Valor Estoque</td>"; 
    $html .="<td align='center'><b>Dias Estoque</td>";
    $html .="<td align='center'><b>Venda $data1</td>";
    $html .="<td align='center'><b>Venda $data2</td>";
    $html .="<td align='center'><b>Venda $data3</td>";
    $html .="<td align='center'><b>Venda $data4</td>";
    $html .="<td align='center'><b>Venda $data5</td>";
    $html .="<td align='center'><b>Venda $data6</td>";
    $html .="<td align='center'><b>Venda $datacurso</td>";
    $html .="<td align='center'><b>Venda Total</td>";
    $html .="<td align='center'><b>% Part</td>";
    $html .="<td align='center'><b>% Part Acum</td>";
    $html .="<td align='center'><b>Venda (R$) Total</td>";
    $html .="<td align='center'><b>Custo (R$) Total</td>";
    $html .="<td align='center'><b>MB (R$) Total</td>";
    $html .="<td align='center'><b>Perc MB</td>";
    
$linha = 1;
}
$qtde_estoque = number_format($qtde_estoque,0,',','.');
$valor_estoque = number_format($valor_estoque,2,',','.');
$qtde_mes1 = number_format($qtde_mes1,0,',','.');
$qtde_mes2 = number_format($qtde_mes2,0,',','.');
$qtde_mes3 = number_format($qtde_mes3,0,',','.');
$qtde_mes4 = number_format($qtde_mes4,0,',','.');
$qtde_mes5 = number_format($qtde_mes5,0,',','.');
$qtde_mes6 = number_format($qtde_mes6,0,',','.');
$qtde_mescurso = number_format($qtde_mescurso,0,',','.');
$qtde_total = number_format($qtde_total,0,',','.');
$ven_total = number_format($ven_total,2,',','.');
$cus_total = number_format($cus_total,2,',','.');
$valor_mb  = number_format($valor_mb,2,',','.');
$perc_mb_m = number_format($perc_mb,2,',','.').'%';
$part = number_format($part,2,',','.').'%';
if ($part_acum > 100.00) {$part_acum = 100.00;}
$part_acum_m = number_format($part_acum,2,',','.').'%';
$html .="</tr>";		
$html .="<tr>";
if ($part_acum >= $perc_corte) {
    $html .="<td align='right'><font color='red'><b>$prod_cod</b></font></td>"; 
    $html .="<td align='left'><font color='red'><b>$prod_nome</b></font></td>"; 
}else{
    $html .="<td align='right'><font color='black'>$prod_cod</font></td>"; 
    $html .="<td align='left'><font color='black'>$prod_nome</font></td>"; 

}
$html .="<td align='left'>    $marca_nome</td>"; 
$html .="<td align='left'>    $curva</td>"; 
$html .="<td align='right'>   $qtde_estoque</td>"; 	
$html .="<td align='right'>   $valor_estoque</td>"; 	
$html .="<td align='right'>   $dias_estoque</td>"; 
$html .="<td align='right'>   $qtde_mes1</td>"; 
$html .="<td align='right'>   $qtde_mes2</td>"; 
$html .="<td align='right'>   $qtde_mes3</td>"; 
$html .="<td align='right'>   $qtde_mes4</td>"; 
$html .="<td align='right'>   $qtde_mes5</td>"; 
$html .="<td align='right'>   $qtde_mes6</td>"; 
$html .="<td align='right'>   $qtde_mescurso</td>"; 
$html .="<td align='right'>   $qtde_total</td>"; 
$html .="<td align='right'>   $part</td>"; 
if ($part_acum >= $perc_corte) {
    $html .="<td align='right'><font color='red'><b>   $part_acum_m</b></font></td>"; 
}else{
    $html .="<td align='right'><font color='black'>   $part_acum_m</td>"; 
}
$html .="<td align='right'>   $ven_total</td>"; 
$html .="<td align='right'>   $cus_total</td>"; 
$html .="<td align='right'>   $valor_mb</td>"; 
if ($perc_mb < $margem_toleravel) {
    $html .="<td align='right'><font color='red'><b>   $perc_mb_m</b></font></td>"; 
}else{
    $html .="<td align='right'><font color='black'>   $perc_mb_m</td>"; 
}
$html .="</tr>";
}		
$html .= "</table>";
$html .= "<br>";
echo $html;
exit;  
?>
</html>