404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Analise_Mix /
Filename : VieMixGenericoExcel.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;
$DadosLer['dcb_id'] = $Dados['dcb_id'];
$DadosLer['apres_nome'] = $Dados['apres_nome'];

//$filial_nome = $Dados['filial_nome'];

//$gre_filial_id = $Dados['gre_filial_id'];
// $Lanc = new \App\gre\Models\ModRupCompProdLer();
$Lanc = new \App\gre\Models\ModMixGenericoLer();
$arr = $Lanc->lerLanc($DadosLer);
$num_linhas = 40;
$cont_linha = 99999;
$cont_reg = 0;
$total_dia = 0;
$dcb_nome = $arr[0]['dcb_nome'];
$mb_media_m = $arr[0]['mb_media'];
$mb_media_m = number_format($mb_media_m,2,',','.');
$apres = $arr[0]['apres']; 
$dias = $arr[0]['dias']; 
$dtxls = date("dmYHi");
$arquivo = "ANALISE MIX GENÉRICO_"."$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='16' align='center'><b><font color='blue'>ANÁLISE DO MIX - GENÉRICO</td>";
$html .="</tr>";
$html .= "<tr>";
$html .="<td  colspan='10' align='center'><b><font color='blue'>DCB: $dcb_nome $apres </td>";
$html .="<td  colspan='2' align='center'><b><font color='blue'>Margem Média: $mb_media_m</td>";
$html .="<td  colspan='4' align='center'><b><font color='blue'>Dias de Vendas: $dias </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>Marca</td>";
$html .="<td align='center'><b>inclusão</td>";
$html .="<td align='center'><b>Qtde Filiais</td>"; 
$html .="<td align='center'><b>Estoque</td>";
$html .="<td align='center'><b>Venda Total</td>"; 
$html .="<td align='center'><b>Venda/dia</td>"; 
$html .="<td align='center'><b>Part s/Venda</td>"; 
$html .="<td align='center'><b>Custo Total</td>"; 
$html .="<td align='center'><b>Venda Total</td>"; 
$html .="<td align='center'><b>Margem Bruta</td>"; 
$html .="<td align='center'><b>Preço Fábrica</td>"; 
$html .="<td align='center'><b>Preço Máximo</td>";
$html .="<td align='center'><b>Desconto Médio</td>";
$html .="<td align='center'><b>Preço de Venda Médio</td>";
$html .="</tr>";

foreach ($arr as $lcto) {
    extract($lcto);
	$html .="<tr>";
	$html .="<td align='right'>    $produto_id</td>";		
	$html .="<td align='left'>     $produto_nome</td>";
        $html .="<td align='left'>     $marca_nome</td>";
	$html .="<td align='center'>   $data_inclusao</td>"; 
	$html .="<td align='center'>   $qtde_filiais</td>";
	$html .="<td align='right'>    $estoque</td>"; 			
	$html .="<td align='right'>    $qtde_venda</td>";
        $html .="<td align='right'>    $qtde_dia</td>";        
	$html .="<td align='right'>    $part_venda_unid%</td>";
        $html .="<td align='right'>    $custo_total</td>";
        $html .="<td align='right'>    $venda_total</td>";
        if ($lb_i < $mb_media) {
            $html .="<td align='right'><font color='red'>$lb%</font></td>";
        }else{
            $html .="<td align='right'><font color='black'>$lb%</font></td>";
        }
            
        $html .="<td align='right'>    $preco_max</td>";             
        $html .="<td align='right'>    $preco_fabr</td>";
        $html .="<td align='right'>    $desconto%</td>";   
        $html .="<td align='right'>    $preco_de_venda_medio</td>";   
	$html .="</tr>";
		
		}
			
$html .= "</table>";
$html .= "<br>";
echo $html;
exit;  
?>
</html>