404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Ruptura /
Filename : VieRupMarcaExcel.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;
$Lanc = new \App\gre\Models\ModRupMarcaListar();
$arr = $Lanc->listMarca($Dados);
$num_linhas = 40;
$cont_linha = 99999;
$cont_reg = 0;
$total_dia = 0;
//var_dump($arr);
//die;
$data_sel = $arr[0]['datav'];
$comp_nome = $arr[0]['comp_nome'];
if ($comp_nome == '') {$comp_nome ='TODOS';}
$dtxls = date("dmYHi");
$arquivo = "RUPTURA POR MARCA_"."$comp_nome"."_"."$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 align='left' colspan='8'>Comprador: <font color='blue'><b>$comp_nome</b></font></td>";
	$html .= "</tr>"; 
$html .= "<tr>";  
$html .= "<td align='center' colspan='8'>Data: <b>$data_sel</b></td>";
$html .= "</tr>"; 
$tven_a = 0;
$tven_b = 0;
$tven_c = 0;
$tven_d = 0;
$tven_t = 0;
$trup_a = 0;
$trup_b = 0;
$trup_c = 0;
$trup_d = 0;
$trup_t = 0;
$fdia = 0;
$fmes = 0;
$html .= "<tr>";
$html .= "<td class='table-info' align='center'><b><font color='blue'>Marca</b></td>";
$html .= "<td class='table-info' align='center'><b><font color='blue'>A</td>"; 
$html .= "<td class='table-info' align='center'><b><font color='blue'>B</td>"; 
$html .= "<td class='table-info' align='center'><b><font color='blue'>C</td>"; 
$html .= "<td class='table-info' align='center'><b><font color='blue'>D</td>"; 
$html .= "<td class='table-info' align='center'><b><font color='blue'>TOTAL</td>"; 
$html .= "<td class='table-info' align='center' ><b><font color='blue'>Falta Dia</td>"; 
$html .= "<td class='table-info' align='center'><b><font color='blue'>Falta Mes</td>"; 
$html .= "</tr>";
foreach ($arr as $lactos) {
		extract($lactos);
                $rup_tm = 'R$ '.number_format($rup_t,2,',','.');
                $rup_acumm = 'R$ '.number_format($rup_acum,2,',','.');
		$html .= "<tr>";
		$html .= "<td>$nome</td>"; 
		$html .= "<td  align='center'>$perc_a%</td>"; 
		$html .= "<td  align='center'>$perc_b%</td>"; 
		$html .= "<td  align='center'>$perc_c%</td>"; 
		$html .= "<td  align='center'>$perc_d%</td>"; 
		$html .= "<td  align='center'>$perc_t%</td>"; 
		$html .= "<td align='right'>$rup_tm</td>";
		$html .= "<td align='right'>$rup_acumm</td>";
		$html .= "</tr>";
		$tven_a = $tven_a+ $ven_a;
		$tven_b = $tven_b+ $ven_b;
		$tven_c = $tven_c+ $ven_c;
		$tven_d = $tven_d+ $ven_d;
		$tven_t = $tven_t+ $ven_t;
		$trup_a = $trup_a+ $rup_a;
		$trup_b = $trup_b+ $rup_b;
		$trup_c = $trup_c+ $rup_c;
		$trup_d = $trup_d+ $rup_d;
		$trup_t = $trup_t+ $rup_t; 
		$fmes = $fmes+ $rup_acum; 
}
if ($tven_a > 0){$tind_a = number_format(round((($trup_a*100)/$tven_a),2),2,',','.');}else{$tind_a=0;}
if ($tven_b > 0){$tind_b = number_format(round((($trup_b*100)/$tven_b),2),2,',','.');}else{$tind_b=0;}
if ($tven_c > 0){$tind_c = number_format(round((($trup_c*100)/$tven_c),2),2,',','.');}else{$tind_c=0;}
if ($tven_t > 0){$tind_d = number_format(round((($trup_d*100)/$tven_d),2),2,',','.');}else{$tind_d=0;}
if ($tven_a > 0){$tind_t = number_format(round((($trup_t*100)/$tven_t),2),2,',','.');}else{$tind_t=0;}
$trup_tm = 'R$ '.number_format($trup_t,2,',','.');
$fmesm = 'R$ '.number_format($fmes,2,',','.');
$html .= "<td class='table-info' align='right'><b><font color='blue'>Totais</b></td>";
$html .= "<td class='table-info' align='center'><b><font color='blue'>$tind_a%</b></td>";
$html .= "<td class='table-info' align='center'><b><font color='blue'>$tind_b%</b></td>";
$html .= "<td class='table-info' align='center'><b><font color='blue'>$tind_c%</b></td>";
$html .= "<td class='table-info' align='center'><b><font color='blue'>$tind_d%</b></td>";
$html .= "<td class='table-info' align='center'><b><font color='blue'>$tind_t%</b></td>";
$html .= "<td class='table-info' align='right'><b><font color='blue'>$trup_tm";
$html .= "<td class='table-info' align='right'><b><font color='blue'>$fmesm</b></td>";
$html .= "</table>";
$html .= "<br>";
echo $html;
exit;  
?>
</html>