<?php

define("TABLE_NAME", "site_newsletter");
define("FILE_NAME", router(1));
nivel(FILE_NAME);

if(router(2) == 'export'){
	ini_set('display_errors', TRUE);
		
	$nomearquivo = 'newsletter_'.date('Y-m-d_h-i-s');
	
	require_once '../system/PHPExcel.php';
	// Create new PHPExcel object
	$objPHPExcel = new PHPExcel();

$objPHPExcel->getProperties()
	//->setCreator("")
	//->setLastModifiedBy("LTXDESIGN")
	->setTitle("NEWSLETTER")
	->setSubject(date('d/m/Y H:i:s'))
	->setDescription("Gerado pelo painel")
	->setKeywords("")
	->setCategory("");
	
	$SQL = "SELECT * FROM ".TABLE_NAME." ORDER BY data DESC";
	$busca = mysql_query($SQL);

$atualLinha = 0;

while($ln = mysql_fetch_object($busca)){ $atualLinha++;

$objPHPExcel->setActiveSheetIndex(0)
	            ->setCellValue('A'.$atualLinha, $ln->email) // email
	            ->setCellValue('B'.$atualLinha, date("Y-m-d", strtotime($ln->data))) //DATA
		;
	}

// Rename worksheet
	$objPHPExcel->getActiveSheet()->setTitle('EXPORTADO '.date('d-m-Y'));
	// Set active sheet index to the first sheet, so Excel opens this as the first sheet
	$objPHPExcel->setActiveSheetIndex(0);

// Redirect output to a client’s web browser (Excel5)
	header('Content-Type: application/vnd.ms-excel');
	header('Content-Disposition: attachment;filename="'.$nomearquivo.'.xls"');
	header('Cache-Control: max-age=0');
	// If you're serving to IE 9, then the following may be needed
	header('Cache-Control: max-age=1');
	// If you're serving to IE over SSL, then the following may be needed
	header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
	header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
	header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
	header ('Pragma: public'); // HTTP/1.0
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
	$objWriter->save('php://output');
	die();

exit;

}