404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Cotacao /
Filename : VieCtPlanilhaPreco.php
back
<?php

$path = getcwd();
//VAR_DUMP(URLFPDF);
$Dados = $_GET;

$Lanc = new \App\gre\Models\Cotacao\ModCtRespondePrecoLer();
$arr = $Lanc->listarResponde($this->Dados);
$repres_nome = $arr[0]['apelido'];
$repres_id = $arr[0]['repres_id'];
$this->DadosUsuario[0]['dest_nome'] = $arr[0]['apelido'];
$this->DadosUsuario[0]['orig_email'] = $arr[0]['usu_email'];
$this->DadosUsuario[0]['dest_email'] = $arr[0]['email'];
$this->DadosUsuario[0]['orig_nome'] = $arr[0]['usu_apelido'];
$this->DadosUsuario[0]['orig_celular'] = $arr[0]['usu_celular'];
$marca_nome = $arr[0]['marca_nome'];
$cabec = "ROSÁRIO - COTACAO ". $arr[0]['data_cotacao_i']. ' '.$repres_nome;
$spreadsheet = '';
?>
<?php
require $_SERVER['DOCUMENT_ROOT']."/rosario/adm/vendor/autoload.php"; 
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xls;
use PHPOffice\phpspreadsheet\Shared\Date;
$spreadsheet = '';

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->getColumnDimension('A')->setWidth(140,'px');
$sheet->getColumnDimension('B')->setWidth(80,'px');
$sheet->getColumnDimension('C')->setWidth(70,'px');
$sheet->getColumnDimension('D')->setWidth(100,'px');
$sheet->getColumnDimension('E')->setWidth(140,'px');
$sheet->getColumnDimension('F')->setWidth(400,'px');
$sheet->getColumnDimension('G')->setWidth(100,'px');
$sheet->getColumnDimension('H')->setWidth(120,'px');
$sheet->getColumnDimension('I')->setWidth(70,'px');
$sheet->setCellValue('A1', 'Data');
$sheet->setCellValue('B1', 'Repres');
$sheet->setCellValue('C1', 'Marca');
$sheet->setCellValue('D1', 'Cod. Interno');
$sheet->setCellValue('E1', 'EAN DO PRODUTO');
$sheet->setCellValue('F1', 'Descrição do Produto');
$sheet->setCellValue('G1', 'Preço Cotado');
$sheet->setCellValue('H1', 'Fator Embalagem');
$sheet->setCellValue('I1', 'Estoque');
$i = 2;
foreach ($arr as $linhas) {
 extract($linhas);
$sheet->setCellValue('A'.$i, $data_cotacao_i);
$sheet->setCellValue('B'.$i, $repres_id);
// $sheet->setCellValue('C'.$i, $id);
$sheet->setCellValue('C'.$i, $marca_nome);
$sheet->setCellValue('D'.$i, $prod_cod);
$sheet->setCellValue('E'.$i, $ean);
$sheet->setCellValue('F'.$i, $prod_nome);
$sheet->setCellValue('G'.$i,'      ');
$sheet->setCellValue('H'.$i, '     ');
$sheet->setCellValue('I'.$i, '      ');
$i = $i + 1;
}

$arquivo = "minhaPlanilha.xls"; 
$local = $_SERVER['DOCUMENT_ROOT']."/rosario/adm/".$arquivo;
try {
    $writer = new Xls($spreadsheet);
    $writer->save($local);
    $content = file_get_contents($local);
} catch(Exception $e) {
    exit($e->getMessage());
}

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="' . urlencode($arquivo) .'"' );

echo $content;  // this actually send the file content to the browser
die;
?>