File "correos_excel.php"

Full path: /home/wwwitravel/public_html/00sistema.cymchiletours.cl/vistas/correos_excel.php
File size: 0 KB (2.25 KB bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php
require_once "../clases/config.php";
require_once '../clases/PHPExcel.php';
 
$conexion= mysqli_connect(HOST,USER,PASS, DBNAME) or die ("could not connect to mysql"); 
$conexion->set_charset("utf8");


$sql="SELECT distinct(autoint) FROM log_mail order by id desc limit 10;";
$resultado=mysqli_query($conexion, $sql) or die(mysql_error());   
$registros = mysqli_num_rows ($resultado);
$autoint='';
while ($registro = mysqli_fetch_object ($resultado)) {
	$autoint=$autoint.' autoint='.$registro->autoint.' OR '; 
}

$where=substr($autoint, 0, -3);

$sql="SELECT fecha,nombre,email,autoint FROM log_mail WHERE ".$where." ORDER BY id DESC;";
$resultado=mysqli_query($conexion, $sql) or die(mysql_error());   
$registros = mysqli_num_rows ($resultado);
$fecha=date('d-m-Y'); 
 
 
 if ($registros > 0) {
   $objPHPExcel = new PHPExcel();
   
   //Informacion del excel
   $objPHPExcel->
    getProperties()
        ->setCreator("I-travel Administrador")
        ->setLastModifiedBy("I-travel Administrador")
        ->setTitle("LOG")
        ->setSubject("Hoja 1")
        ->setDescription("Documento generado con PHPExcel")
        ->setKeywords("phpexcel")
        ->setCategory("Log_Correos");    

   $i = 1;    
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$i, 'FECHA');
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$i, 'NOMBRE');
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C'.$i, 'CORREO');
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D'.$i, 'Nº MENSAJE');
   
   $i++;
   
   
   
   while ($registro = mysqli_fetch_object ($resultado)) {
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$i, strtoupper($registro->fecha));
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$i, strtoupper($registro->nombre));
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C'.$i, strtoupper($registro->email));
		$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D'.$i, strtoupper($registro->autoint));
      $i++;
      
   }
}
//die('trtrt');

header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Log_correos'.$fecha.'.xlsx"');
header('Cache-Control: max-age=0');
$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');
$objWriter->save('php://output');
exit;
mysqli_close ();
?>