if (trim($titre) != '') {
$titre .= ' - ';
}
}
$messageAutresModif .= "<a href='" . $valueAdresse['url'] . "'>" . $titre . $valueAdresse['libelle'] . "</a><br>" . PHP_EOL;
$adressesModifieesAffichees[] = $valueAdresse['idEvenementGroupeAdresse'];
$adressesModifieesAffichees = array_unique($adressesModifieesAffichees);
$iv3++;
}
}
$iv3 = 0;
}
}
}
$messageFin = "<br>L'équipe archi-wiki.org<br>";
$messageFin .= $config->getMessageDesabonnerAlerteMail();
$reqNewPeople = "\n SELECT pers.idPersonne, pers.nom, pers.prenom\n FROM personne pers\n\n LEFT JOIN _personneEvenement ae ON ae.idPersonne = pers.idPersonne\n LEFT JOIN _evenementEvenement ee ON ee.idEvenement = ae.idEvenement\n LEFT JOIN historiqueEvenement he ON he.idEvenement = ae.idEvenement\n\n\n\n WHERE he.dateCreationEvenement < {$borneMin}\n AND he.dateCreationEvenement >= {$borneMax}\n GROUP BY pers.idPersonne,ee.idEvenement\n HAVING count(ee.idEvenementAssocie)>0\n ORDER BY he.dateCreationEvenement\n ";
$resNewPeople = $config->connexionBdd->requete($reqNewPeople);
$newPeople = array();
if (mysql_num_rows($resNewPeople) > 0) {
$messagePeople = "<h4>Nouvelles personnes :</h4>\n <ul>";
while ($newPerson = mysql_fetch_object($resNewPeople)) {
$newPeople[] = $newPerson->idPersonne;
$messagePeople .= "<li><a href='" . $config->creerUrl("", "evenementListe", array("selection" => "personne", "id" => $newPerson->idPersonne)) . "'>" . $newPerson->prenom . " " . $newPerson->nom . "</a></li>" . PHP_EOL;
}
$messagePeople .= "</ul>";
}
$reqModPeople = "\n SELECT * FROM (\n SELECT pers.idPersonne, pers.nom, pers.prenom, he.dateCreationEvenement, ee.idEvenement, ee.idEvenementAssocie, he.idHistoriqueEvenement\n FROM personne pers\n\n LEFT JOIN _personneEvenement ae ON ae.idPersonne = pers.idPersonne\n LEFT JOIN _evenementEvenement ee ON ee.idEvenement = ae.idEvenement\n LEFT JOIN historiqueEvenement he ON he.idEvenement = ee.idEvenementAssocie\n\n ORDER BY he.idHistoriqueEvenement\n ) as people\n\n WHERE people.dateCreationEvenement < {$borneMin}\n AND people.dateCreationEvenement >= {$borneMax}\n GROUP BY people.idPersonne, people.idEvenement\n HAVING count(people.idEvenementAssocie)>0\n ORDER BY people.dateCreationEvenement\n ";
$resModPeople = $config->connexionBdd->requete($reqModPeople);
$i = 0;
while ($modPerson = mysql_fetch_object($resModPeople)) {
}
foreach ($arrayRegroupementTypeMail as $idUtilisateur => $valueTypeMailRegroupement) {
$arrayMailsASupprimer = array();
$message = "<b>Modifications apportées sur le site archi-wiki.org" . "</b><br><br>";
foreach ($valueTypeMailRegroupement as $idTypeMailRegroupement => $valueMail) {
// recup de l'intitule de la rubrique de mail regroupee
$reqIntituleRegroupement = "SELECT intitule FROM typesMailsEnvoiMailsRegroupes" . " WHERE idTypeMail = '" . $idTypeMailRegroupement . "'";
$resIntituleRegroupement = $config->connexionBdd->requete($reqIntituleRegroupement);
$fetchIntituleRegroupement = mysql_fetch_assoc($resIntituleRegroupement);
$message .= "<b>" . $fetchIntituleRegroupement['intitule'] . "</b> : <br>";
foreach ($valueMail as $indice => $value) {
$message .= " - <i>" . $d->toFrenchAffichage($value['dateHeure']) . " :</i> " . $value['contenu'] . "<br>";
$arrayMailsASupprimer[] = $value['idMail'];
}
}
$message .= "<br>" . $config->getMessageDesabonnerAlerteMail();
// recup du mail de la personne
$reqMail = "SELECT mail FROM utilisateur WHERE idUtilisateur='" . $idUtilisateur . "'";
$resMail = $config->connexionBdd->requete($reqMail);
$fetchMail = mysql_fetch_assoc($resMail);
$sujet = "archi-wiki.org : Modifications sur le site";
$mail->sendMail($mail->getSiteMail(), trim($fetchMail['mail']), $sujet, $message, true, null, 'daily.log');
// Stockage du mail dans les logs
/*
$reqStock = "INSERT INTO logMails".
"(destinataire, sujet, message, date) VALUES ('"
.trim($fetchMail['mail'])."', \"".mysql_real_escape_string($sujet)."\", \""
.mysql_real_escape_string($message)."\", now())";
$resStock = $config->connexionBdd->requete($reqStock);*/
// On supprime les mail regroupés
if (count($arrayMailsASupprimer) > 0) {