404

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

namespace App\gre\Models\Cotacao;

if (!defined('URL')) {
    header("Location: /");
    exit();
}
require $_SERVER['DOCUMENT_ROOT']."/rosario/adm/vendor/autoload.php"; 
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xls;
use PHPOffice\phpspreadsheet\Shared\Date;
/**
 * Description of GrsListarPsaudemedico
 *
 * @copyright (c) year, Carlos Marques - CM
 */
class ModCtRespondePrecoGerar
{

    private $Dados;
    private $DadosEmail;
    private $DadosUsuario;
    private $Resultado;
    private $PageId;
    private $DadosExcel;
  

 function getResultado()
    {
        return $this->Resultado;
    }
    
    public function gerarCotacao( $Dados = null)
    {
$this->Dados = $Dados;

 
$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 = '';
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
//$spreadsheet->getActiveSheet()->getStyle('A1:I2')
//    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$sheet->getColumnDimension('A')->setWidth(140,'px');
$sheet->getColumnDimension('B')->setWidth(80,'px');
//$sheet->getColumnDimension('C')->setWidth(70,'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');
//$spreadsheet->getActiveSheet()->mergeCells('A1:J1');

//$sheet->getStyle('A1:J2')->getFont()->setBold(true);

$sheet->setCellValue('A1', 'Data');
$sheet->setCellValue('B1', 'Repres');
//$sheet->setCellValue('C2', '#ID');
$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);
   // var_dump($row);
$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"; 
$writer = new Xls($spreadsheet);

$local = $_SERVER['DOCUMENT_ROOT']."/rosario/adm/".$arquivo;
$writer->save($local);
header('Content-Type: application/excel');
//header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="'.$arquivo.'"'); 
//header('Cache-Control: max-age=0');

ob_end_clean();
ob_start();
flush();
$writer->save('php://output');
//readfile($arquivo);
 
die;
    }
}