Manager

File "script_extract.php"
Full Path: /home/asmplong/www/asm/scripts/script_extract.php
File size: 3.59 KB
MIME-type: text/x-php
Charset: utf-8
Open Edit Advanced Editor Back
<?php
include ('../inc.conec.php');
include ('../inc.fonctions.php');
include ('../inc.config.php');
include('../class/class.phpmailer.php');

// Le but : faire une exec tous les mois qui reprendrait pour récupérer les statistiques des plongées du mois précédent
// mois dernier
$mois = date('m')-1;
$annee = date('Y');


$req_membres = mysql_query("SELECT * FROM ".$db_prefixe."membres ORDER BY membre_id");

		
		
		/** PHPExcel */
		require_once '../class/PHPExcel.php';
		
		/** PHPExcel_IOFactory */
		require_once '../class/PHPExcel/IOFactory.php';
		
		// Create new PHPExcel object
		$objPHPExcel = new PHPExcel();
		
		// Set properties
		$objPHPExcel->getProperties()->setCreator("BLUEFROG")
									 ->setLastModifiedBy("BLUEFROG")
									 ->setTitle("EXCTRACTION")
									 ->setSubject("EXCTRACTION")
									 ->setDescription("EXCTRACTION")
									 ->setKeywords("")
									 ->setCategory("");
		
		$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);
		$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15);
		$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(5);
		$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
		$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);

		
		// Add some data
		$objPHPExcel->setActiveSheetIndex(0)
					->setCellValue('A1', 'MEMBRES')
					->setCellValue('B1', 'NIVEAU')
					->setCellValue('C1', 'PLONGÉES')
					->setCellValue('D1', 'DP')
					->setCellValue('E1', 'ANNULÉES');
		

		$i = 1;	
		While($data_membres = mysql_fetch_array($req_membres))
		{
			$i++;
			$membre_nom = $data_membres['membre_nom'];
			$membre_prenom = $data_membres['membre_prenom'];
			$membre_niveau = $data_membres['membre_niveau'];


			$objPHPExcel->setActiveSheetIndex(0)
					->setCellValue('A'.$i, $membre_nom.' '.$membre_prenom )
					->setCellValue('B'.$i, $membre_niveau)
					->setCellValue('C'.$i, '')
					->setCellValue('D'.$i, '')
					->setCellValue('E'.$i, '');					
		}

		$objPHPExcel->setActiveSheetIndex(0);		
		
		// Redirect output to a client’s web browser (Excel5)
		//header('Content-Type: application/vnd.ms-excel');
		//header('Content-Disposition: attachment;filename="extract_'.$operation_id.'_'.$date.'.xls"');
		//header('Cache-Control: max-age=0');
		
		$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
		//$objWriter->save('php://output'); 
		$objWriter->save("../extract/statistiques_plongees_".$mois."-".$annee.".xls");
		
		
		// Préparation du mail	
		$nom        = 'ASM';
		$expediteur = $config_email_noreply;
		
		$mail = new PHPmailer();
		$mail->IsHTML(true);	
		$mail->From=$expediteur;
		$mail->FromName=$nom;
		$mail->AddAddress($config_email);
		$mail->AddReplyTo($expediteur);	
		$mail->Subject='ASM : statistiques des plongées ('.$mois.'/'.$annee.')';
		
		$message = utf8_decode('<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
</head>

<body>
<p style="font-family:arial; font-size:12px; color:#000000;"><strong>STATISTIQUES PLONGÉES DU '.$mois.'/'.$annee.'</strong><br><br>Lien de téléchargement de l\'extraction :<br><br><a href="http://asm-plongee.fr/asm/extract/statistiques_plongees_'.$mois.'-'.$annee.'.xls">http://asm-plongee.fr/asm/extract/statistiques_plongees_'.$mois.'-'.$annee.'.xls</a></p>
</body>
</html>');
			
		$mail->Body=$message;
		
		// Envoi du message	
		if($mail->Send())
		{
			$mail->SmtpClose();
			unset($mail);
		
		}



?>