Avançar para outra página após a execução

gibagehrke · Janeiro 31, 2017

Boa tarde pessoal, estou iniciando no PHP (na programação de modo geral na pratica e fora da teoria da faculdade) e tenho que aprimorar um sistema já existente feito por outra pessoa, na qual ele coleta as informações e gera um relatório em Excel. Agora tenho que fazer com que ele além de gerar o Excel, também pegue parte desse relatório, criando uma versão resumida que será colocada no corpo de um e-mail que será disparado por ele junto do arquivo Excel anexado.

Porém estou tentando encontrar uma forma, que após ele gerar o relatório (código abaixo) ele vá para outra página e continue a rotina, o sistema apenas gera o relatório e o navegador baixa o arquivo, parando por aí.

<?php

error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Europe/London');

if (PHP_SAPI == 'cli')
	die('This example should only be run from a Web Browser');

/** Include PHPExcel */
require_once '../Classes/PHPExcel.php';
require_once 'sqlexpo.php';

  $connection = pg_connect("host=localhost port=5432 dbname=base user=usuario password=senha") 
      or die ("Nao consegui conectar ao PostGres --> " . pg_last_error($conn)); 	

	$qu = pg_query($connection, $sql);  
	$arr = pg_fetch_array($qu, NULL, PGSQL_ASSOC);
	  
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Set document properties
$cordaborda = array(
	'borders' => array(
		'outline' => array(
			'style' => PHPExcel_Style_Border::BORDER_THIN,
			'color' => array('argb' => 'ffffffff'),
		),
	),
);

//linha da cor das responsabilidades
$objPHPExcel->getActiveSheet()->getStyle('A4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('B4:H4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('B4:H4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('I4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('I4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('J4:X4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('J4:X4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('Y4:Z4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('Y4:Z4')->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('AA4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('AA4')->getFill()->getStartColor()->setARGB('FF0000A0');
//mesclando as linhas e colunas
$objPHPExcel->getActiveSheet()->mergeCells('A1:AA3');
$objPHPExcel->getActiveSheet()->mergeCells('B4:H4');
$objPHPExcel->getActiveSheet()->mergeCells('J4:X4');
$objPHPExcel->getActiveSheet()->mergeCells('Y4:Z4');
//TITULO DAS RESPONSABILIDADES - MESCLADO
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A4', 'FRONTEIRA');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B4', 'EXPORTADOR');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('I4', 'TRANSPORTADOR');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('J4', 'Empresa');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('Y4', 'TRANSPORTADOR');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('AA4', 'STATUS');
// TITULOS DA LINHA 1 - e configurações
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'FOLLOWUP');
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(28);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
//colocando bordas nas células mescladas
$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//cor de fundo azul
$objPHPExcel->getActiveSheet()->getStyle('A1:AA1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A1:AA1')->getFill()->getStartColor()->setARGB('FF0000A0');
//cor da borda branca
$objPHPExcel->getActiveSheet()->getStyle('A1:AA3')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('A4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('B4:H4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('I4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('J4:X4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('Y4:Z4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('AA4')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//linha da cor dos títulos dos eventos
$objPHPExcel->getActiveSheet()->getStyle('A5:AA5')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->getStyle('A5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('B5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('C5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('D5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('E5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('F5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('G5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('H5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('I5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('J5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('K5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('L5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('M5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('N5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('O5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('P5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('Q5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('R5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('S5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('T5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('U5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('V5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('W5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('X5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('Y5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('Z5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('AA5')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//
$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('B4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('I4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('J4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('Y4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

$objPHPExcel->getActiveSheet()->getStyle('A5:AA5')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getStyle('A5:AA5')->getFill()->getStartColor()->setARGB('FF0000A0');
//cor da borda branca
$objPHPExcel->getActiveSheet()->getStyle('A5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('B5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('C5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('D5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('E5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('F5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('G5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('H5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('I5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('J5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('K5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('L5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('M5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('N5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('O5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('P5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('Q5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('R5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('S5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('T5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('U5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('V5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('W5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('X5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('Y5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('Z5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('AA5')->applyFromArray($cordaborda);
$objPHPExcel->getActiveSheet()->getStyle('A5:P5')->applyFromArray($cordaborda);
//FAZENDO AS COLUNAS TEREM TAMANHO AUTOMATICO
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('O')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('P')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('R')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('S')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('T')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('U')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('V')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('W')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('X')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setAutoSize(true);
//ALINHANDO A ESQUERDA
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('J')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('M')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('N')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('O')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('P')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('Q')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('R')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('S')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('T')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('U')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('V')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('W')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('X')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('Y')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('Z')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('AA')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
//ALINHANDO AO CENTRO AS COLUNAS MESCLADAS DAS RESPONSABILIDADES
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
//formatando a fonte com cor branca
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle('A4:AA4')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle('A5:AA5')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
// TITULOS DA LINHA 1
$objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A5', 'Local de Desembaraco')
            ->setCellValue('B5', 'Fatura')
            ->setCellValue('C5', 'Cliente')
            ->setCellValue('D5', 'Ref.Cliente')
            ->setCellValue('E5', 'Cnpj')
            ->setCellValue('F5', 'RE')
            ->setCellValue('G5', 'Data RE')
            ->setCellValue('H5', 'Processo')
            ->setCellValue('I5', 'Conhecimento')
            ->setCellValue('J5', 'DDE')
            ->setCellValue('K5', 'Data DDE')
            ->setCellValue('L5', 'Chegada em Fronteira')
            ->setCellValue('M5', 'Recepcao dos Documentos')
            ->setCellValue('N5', 'Tempo Entrega')
            ->setCellValue('O5', 'Ingresso Autorizado ')
            ->setCellValue('P5', 'Ingresso Recinto Alfand.')
            ->setCellValue('Q5', 'Tempo Ok e Ingr.')
            ->setCellValue('R5', 'Apresentacao RF')
            ->setCellValue('S5', 'Canal')
            ->setCellValue('T5', 'Courier')
            ->setCellValue('U5', 'Envio Originais')
            ->setCellValue('V5', 'Liberacao RF')
            ->setCellValue('W5', 'Tempo Liberacao')
            ->setCellValue('X5', 'RE Averbado')
            ->setCellValue('Y5', 'Seguiu Viagem')
            ->setCellValue('Z5', 'Cruze')
            ->setCellValue('AA5', 'Status');
							
  $row = 0; // postgresql precisa de um contador de linha, outros dbs talvez n?o precisem
  $li = 6;

//linhas dos dados
while ($data = @pg_fetch_object($qu, $row)) {		

if(isset($data->ingressorecinto)){$data_recinto = $data->ingressorecinto;}
else{$data_recinto = $data->ingressorecintof;}

if (isset($data->data_re1)) {$datare = $data->data_re1;}
else{$datare = $data->data_re2;}

if(isset($data->ingressorecinto)){$ingressorecinto = $data->ingressorecinto;}
else{$ingressorecinto = $data->ingressorecintof;} 

                        
            $objPHPExcel->setActiveSheetIndex(0)
                        ->setCellValue('A'.$li, $data->localdesembaraco)
			->setCellValue('B'.$li, $data->referencia)
                        ->setCellValue('C'.$li, $data->cliente)
                        ->setCellValue('D'.$li, $data->refcliente)
                        ->setCellValue('E'.$li, $data->cnpj)
                        ->setCellValue('F'.$li, $data->re)
                        ->setCellValue('G'.$li, $datare)
                        ->setCellValue('H'.$li, $data->processo)
                        ->setCellValue('I'.$li, $data->crt)
                        ->setCellValue('J'.$li, $data->dde)
                        ->setCellValue('K'.$li, $data->datadde)
                        ->setCellValue('L'.$li, $data->chegadaemfronteira)
                        ->setCellValue('M'.$li, $data->recepdocs)
                        ->setCellValue('N'.$li, $data->tempo1)
                        ->setCellValue('O'.$li, $data->ingressoaut)
                        ->setCellValue('P'.$li, $ingressorecinto)
                        ->setCellValue('Q'.$li, $data->tempooking)
                        ->setCellValue('R'.$li, $data->apresentacaorf)
                        ->setCellValue('S'.$li, $data->canal)
                        ->setCellValue('T'.$li, $data->observacaogeral)
                        ->setCellValue('U'.$li, $data->envio_docs_originais)
                        ->setCellValue('V'.$li, $data->liberacaorf)
                        ->setCellValue('W'.$li, $data->tempoliberacao)
                        ->setCellValue('X'.$li, $data->averbacao)
                        ->setCellValue('Y'.$li, $data->seguiuviagem)
                        ->setCellValue('Z'.$li, $data->cruze)
                        ->setCellValue('AA'.$li, trim($data->obsfollow));

                if (($row % 2) == 0) {
                    $objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
                    $objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->getStartColor()->setARGB('E6E6E6FF');                    
		}  
                else{
                    $objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
                    $objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->getStartColor()->setARGB('FFFFFFFF');                    
                }
                
		$teste = $li++;
		$row++;                
	}
	
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Follow Rodoviário de Exportação');

//
$objPHPExcel->getActiveSheet()->getStyle('A'.$li.':AA'.$li)->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet()->mergeCells('A'.$li. ':AA'.$li);
$objPHPExcel->getActiveSheet()->getStyle('A'.$li)->getFill()->getStartColor()->setARGB('FF0000A0');
$objPHPExcel->getActiveSheet()->getStyle('A'.$li)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle('A'.$li)->getFont()->setSize(8);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$li, '* Informações Extraídas do sistema. Follow up desenvolvido internamente pela TI.');

// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);

// Set password for readonly activesheet
$objPHPExcel->getSecurity()->setLockWindows(true);
$objPHPExcel->getSecurity()->setLockStructure(true);
$objPHPExcel->getSecurity()->setWorkbookPassword("senha da planilha");
// Set password for readonly data
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
$objPHPExcel->getActiveSheet()->getProtection()->setPassword("senha da planilha");

// Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="FollowRodoviarioExpo.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
	
?>

Entrar

Arquivado

Avançar para outra página após a execução

Recommended Posts

gibagehrke 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

problema em usar json para realizar engenharia de dados

Soma dos dias utilizados

Saber se todos os produtos de uma consulta estão cadastrados no banco de dados

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante