D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
var
/
www
/
html
/
rosario
/
adm
/
app
/
gre
/
Views
/
DiasEstoque
/
Filename :
VieDiasEstoqueExcel.php
back
Copy
<?php ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); ob_start(); $path = getcwd(); $Dados = $_GET; $dias = new \App\gre\Models\ModDiasEstoqueLer(); $arr = $dias->lerDias($Dados); //var_dump($arr); //die; //var_dump($arr_filial); $dtxls = date("dmYHi"); $arquivo = "DIAS MÁXIMO ESTOQUE_"."$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='center'><b>Filial</td>"; $html .="<td align='center'><b>Cod Seção</td>"; $html .="<td align='center'><b>Descrição</td>"; $html .="<td align='center'><b>Cod Grupo</td>"; $html .="<td align='center'><b>Descrição</td>"; $html .="<td align='center'><b>Dias A</td>"; $html .="<td align='center'><b>Dias B</td>"; $html .="<td align='center'><b>Dias C</td>"; $html .="<td align='center'><b>Dias D</td>"; $html .="</tr>"; foreach ($arr as $lcto) { extract($lcto); $html .="<tr>"; $html .="<td align='right'> $fili_nome</td>"; $html .="<td align='center'> $secao_id</td>"; $html .="<td align='left'> $secao_nome</td>"; $html .="<td align='center'> $grupo_id</td>"; $html .="<td align='left'> $grupo_nome</td>"; $html .="<td align='center'> $dias_a</td>"; $html .="<td align='center'> $dias_b</td>"; $html .="<td align='center'> $dias_c</td>"; $html .="<td align='center'> $dias_d</td>"; $html .="</tr>"; } $html .= "</table>"; $html .= "<br>"; echo $html; exit; ?> </html>