1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
|
<?php
//Déclarer des variables
$tab = "\t";
$cr = "\n";
$fp = fopen($filename,"a"); // $fp pointeur du fichier $filename
if($fp){
fwrite($fp,$data); // Write information to the file
fclose($fp); // Close the file
echo "File saved successfully";
} else {
// echo "Error saving file!";
}
header("Content-type: application/ms-excel");
header("Content-Disposition: attachment; filename=newsletter.xls");// Donner un nom au fichier excel
header("Pragma: no-cache");
header("Expires: 0");
// Fetch d'extration du contenu depuit la base de données EZ
$v=eZContentObjectTreeNode::subTreeByNodeID(
array( 'ClassFilterType' => 'include',
'ClassFilterArray' => array('compte_newsletter'),// identifiant de la classe
'Depth' => 1,
'DepthOperator' => 'eq'),
12448// ID du noeud parent
);
// Affichage du titre et des libellés
echo 'Inscription à la newsletter'. $cr;
echo $cr. $cr. $cr;
$libelle = "Adresse E-mail ( E-mail Adress )" . $tab . " Nom ( Last name ) " . $tab . "Prénom ( First name)" . $tab . " Enseigne ( Chain )" . $tab . " Fonction ( Function )" . $tab . " Téléphone ( Phone )" . $tab . " Fax " . $tab . "Langue ( Language ) " . $cr .$cr;
echo $libelle;
foreach ( $v as $o )
{
$dataMap =& $o->dataMap();
$email =& $dataMap['email']->content();
$em = mb_convert_encoding($email,"UTF-8",mb_detect_encoding($email, "UTF-8, ISO-8859-1, ISO-8859-15", true));
echo $em. $tab;
$dataMap =& $o->dataMap();
$nom =& $dataMap['nom']->content();
$nm = mb_convert_encoding($nom,"UTF-8",mb_detect_encoding($nom, "UTF-8, ISO-8859-1, ISO-8859-15", true));
echo $nm. $tab;
$dataMap =& $o->dataMap();
$prenom =& $dataMap['prenom']->content();
$prnm = mb_convert_encoding($prenom,"UTF-8",mb_detect_encoding($prenom, "UTF-8, ISO-8859-1, ISO-8859-15", true));
echo $prnm. $tab;
$dataMap =& $o->dataMap();
$enseigne =& $dataMap['enseigne']->content();
$ensig = mb_convert_encoding($enseigne,"UTF-8",mb_detect_encoding($enseigne, "UTF-8, ISO-8859-1, ISO-8859-15", true));
echo $ensig. $tab;
$dataMap =& $o->dataMap();
$fonction =& $dataMap['fonction']->content();
$font = mb_convert_encoding($fonction,"UTF-8",mb_detect_encoding($fonction, "UTF-8, ISO-8859-1, ISO-8859-15", true));
echo $font. $tab;
$dataMap =& $o->dataMap();
$telephone =& $dataMap['telephone']->content();
$phone = mb_convert_encoding($telephone,"UTF-8",mb_detect_encoding($telephone, "UTF-8, ISO-8859-1, ISO-8859-15", true));
echo $phone. $tab;
$dataMap =& $o->dataMap();
$fax =& $dataMap['fax']->content();
$fx = mb_convert_encoding($fax,"UTF-8",mb_detect_encoding($fax, "UTF-8, ISO-8859-1, ISO-8859-15", true));
echo $fx. $tab;
$objetlangue = & $o->object();
$langue =& $objetlangue->attribute('current_language');
$fr = " Français";
$en = " English ";
if($langue == 'fre-FR'){
echo $fr. $cr ;
}else{
echo $en. $cr ;
}
}
?> |
Partager