D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
var
/
www
/
html
/
rosario
/
adm
/
app
/
gre
/
Views
/
Faceamento
/
Filename :
VieFacFilialExcel.php
back
Copy
<?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\ModFacFilialListar(); $arr = $Lanc->listFilial($Dados); //echo '<pre>'; //var_dump($arr[0]); //echo '</pre>'; $num_linhas = 40; $cont_linha = 99999; $cont_reg = 0; $total_dia = 0; $data_sel = $arr[0]['data_v']; $dtxls = date("dmYHi"); $arquivo = "FACEAMENTO_"."$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 .="<td align='center'><b>EMPRESA</td>"; $html .="<td align='center'><b>CENTRO ESTOQUE</td>"; $html .="<td align='center'><b>CODIGO DO PRODUTO</td>"; $html .="<td align='center'><b>DESCRIÇÃO</td>"; $html .="<td align='center'><b>FACEAMENTO</td>"; $html .="<td align='center'><b>VALIDADE</td>"; $html .="</tr>"; foreach ($arr as $lcto) { extract($lcto); $html .="<tr>"; $html .="<td align='right'> $filial_id</td>"; $html .="<td align='right'> $filial_id</td>"; $html .="<td align='right'> $produto_id</td>"; $html .="<td align='left'> $produto_nome</td>"; $html .="<td align='right'> $qtde_faceamento</td>"; $html .="<td align='right'> $data_v</td>"; $html .="</tr>"; } $html .= "</table>"; $html .= "<br>"; echo $html; exit; ?> </html>