404

D7net
:/ var / www / html / rosario / adm / app / gre / Models / Cotacao /
Filename : VieCtRespondePrecoExcel.php
back
<?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\ModCtRespondePrecoLer();
$arr = $Lanc->listarResponde($Dados);
echo '<pre>';
var_dump($arr);
echo '</pre>';
die;
$repres_nome = $arr[0]['repres_nome'];
$repres_id = $arr[0]['repres_id'];
$cabec = "ROSÁRIO - COTACAO ". $arr[0]['data_cotacao_i']. ' '.$repres_nome;
$nomePlanilha = "COTACAO_".$repres_id.'_'. $arr[0]['data_cotacao_m'];
require $_SERVER['DOCUMENT_ROOT']."/rosario/adm/vendor/autoload.php";
use PhpOffice\PhpSpreadsheet\Spreadsheet;

use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use PHPOffice\phpspreadsheet\Shared\Date;
//include_once("conecta.php");
$styleArray = [
    'borders' => [
        'allBorders' => [
            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
            'color' => ['argb' => '00000000'],
            
        ],
    ],
     
];

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
//$spreadsheet->getActiveSheet()->setPrintGridlines(true);
$spreadsheet->getActiveSheet()->getStyle('A1:I2')
    ->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
$sheet->getColumnDimension('A')->setWidth(70,'px');
$sheet->getColumnDimension('B')->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:G1');
$sheet->getStyle('A1')->getFont()->setBold(true);
$sheet->getStyle('A2:I2')->getFont()->setBold(true);
$sheet->setCellValue('A1', $cabec);
$sheet->setCellValue('A2', 'Data');
$sheet->setCellValue('B2', 'Repres');
$sheet->setCellValue('C2', '#ID');
$sheet->setCellValue('D2', 'Cod. Interno');
$sheet->setCellValue('E2', 'EAN DO PRODUTO');
$sheet->setCellValue('F2', 'Descrição do Produto');
$sheet->setCellValue('G2', 'Preço Cotado');
$sheet->setCellValue('H2', 'Fator Embalagem');
$sheet->setCellValue('I2', 'Estoque');
$i = 3;
foreach ($arr as $lactos) {
	extract($lactos);
$sheet->setCellValue('A'.$i, $data_cotacao_i);
$sheet->setCellValue('B'.$i, $repres_id);
$sheet->setCellValue('C'.$i, $id);
$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;
}
$sheet->getStyle('A1:I'.$i)->applyFromArray($styleArray);
//$sheet->setCellValue('A1', 'Hello World !');
//var_dump($sheet);

$writer = new Xlsx($spreadsheet);
$writer->save($nomePlanilha.'.xlsx');
$fileName = $nomePlanilha.'.zip';
$path      = '/var/www/html/rosario/adm/'; //__DIR__ ;
$fullPath  = $path.$fileName;
$diretorio = dir($path);
$nomeArquivo = $nomePlanilha.'.xlsx';
//var_dump('fullpath:'. $fullPath);
$zip = new \ZipArchive();
if( $zip->open($fullPath, \ZipArchive::CREATE) ){

	while($arquivo = $diretorio->read()){
                 var_dump('$arquivo=> '.$arquivo.'<br>');
                 var_dump('$nomearquivo=> '.$nomeArquivo.'<br>');
		$extensao = substr($arquivo,strlen($arquivo)-4,4);
               
		if($arquivo == $nomeArquivo ){
                    
                 //   var_dump('arquivo - planilha=> '.$arquivo.' - '. $nomeplanilha.'<br>');
                      //var_dump('path e arquivo=>'. $arquivo);
                      
                   
			  $zip->addFile($path.'/'.$arquivo, $arquivo); 
                           var_dump('zipou');
		}
	}
        
	 $zip->close();
}

if(file_exists($fullPath)){
 //  var_dump('achou para subir');
    // Forçamos o donwload do arquivo.
    header('Content-Type: application/zip');
    header('Content-Disposition: attachment; filename="'.$fileName.'"');
    readfile($fullPath);
     $path      = '/var/www/html/rosario/adm/'; //__DIR__ ;
    $fileDelz  =$nomePlanilha.'.zip';
    $fullPathDelz  = $path.'/'.$fileDelz;
    $fileDelx = $nomePlanilha.'.xlsx';
    $fullPathDelx  = $path.'/'.$fileDelx;
    $diretorio = dir($path);

    unlink($fileName);
    unlink($fullPathDelx);
}
die;