D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
var
/
www
/
html
/
rosario
/
adm
/
app
/
gre
/
Views
/
Cotacao
/
Filename :
VieCtCotadoVerPreco.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\Cotacao\ModCtCotadoVerPreco(); $arr = $Lanc->verPrecoCotado($Dados); $data_pre =$arr[0]['data']; $data_imp = date("d/m/Y H:i:s"); date_default_timezone_set ("America/Sao_Paulo"); $dtxls = date("dmYHi"); $dtxls = date("Y_m_d H:i"); $arquivo = "PRECOS COTADOS_"."$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='10' align='center'><b><font color='blue'>PREÇOS COTADOS: $data_pre</td>"; $html .="</tr>"; $html .="<tr>"; $html .="<td align='center'>ID FORN</td>"; $html .="<td align='center'>NOME</td>"; $html .="<td align='center'>ID REPRES</td>"; $html .="<td align='center'>NOME</td>"; $html .="<td align='center'>ID MARCA</td>"; $html .="<td align='center'>NOME</td>"; $html .="<td align='center'>COD INTERNO</td>"; $html .="<td align='center'>EAN</td>"; $html .="<td align='center'>PRODUTO</td>"; $html .="<td align='center'>PREÇO COTADO</td>"; foreach ($arr as $lactos) { extract($lactos); $html .="<tr>"; $html .="<td align='right'>$forn_id</td>"; $html .="<td align='left'>$forn_nome</td>"; $html .="<td align='right'>$repres_id</td>"; $html .="<td align='left'>$repres_nome</td>"; $html .="<td align='right'>$marca_id</td>"; $html .="<td align='left'>$marca_nome</td>"; $html .="<td align='right'>$prod_cod</td>"; $html .="<td align='center'>$ean</td>"; $html .="<td align='left'>$prod_nome</td>"; $html .="<td align='right'>$preco_cotado</td>"; $html .="</tr>"; } $html .= "</table>"; $html .= "<br>"; echo $html; exit; ?> </html>