/**
* Afficher les événements liés à une personne
*
* @param int $idPerson ID de la personne
* @param string $dateDebut Date de début de la période voulue
* @param string $date2 Date de fin de la période voulue
*
* @return string HTML
* */
public static function displayEvenementsLies($idPerson, $dateDebut, $date2)
{
global $config;
$linkedEvents = archiPersonne::getEvenementsLies($idPerson, $dateDebut, $date2);
if (count($linkedEvents)) {
$linkedEventsHTML = "<h4>" . _("Adresses liées :") . "</h4><ul>";
foreach ($linkedEvents as $linkedEvent) {
$req = "\n SELECT titre, dateDebut, idTypeEvenement\n FROM historiqueEvenement\n WHERE idEvenement = '" . $linkedEvent . "'\n ORDER BY idHistoriqueEvenement DESC\n ";
$res = $config->connexionBdd->requete($req);
$event = mysql_fetch_object($res);
$a = new archiAdresse();
$linkedEventAddress = $a->getIntituleAdresseFrom($linkedEvent, "idEvenement");
$e = new archiEvenement();
if (!empty($linkedEventAddress)) {
$req = "\n SELECT idAdresse\n FROM _adresseEvenement\n WHERE idEvenement = " . $e->getIdEvenementGroupeAdresseFromIdEvenement($linkedEvent);
$res = $config->connexionBdd->requete($req);
$fetch = mysql_fetch_object($res);
if (isset($fetch->idAdresse)) {
$linkedEventIdAddress = $fetch->idAdresse;
}
}
//WIP sélection de l'image des personnes
/*$req = "
SELECT nom
FROM typeEvenement
WHERE idTypeEvenement = ".
mysql_real_escape_string($event->idTypeEvenement);
$res = $config->connexionBdd->requete($req);
$linkedEventType=mysql_fetch_object($res)->nom;
$req = "
SELECT idImage
FROM _personneAdresse
WHERE idPersonne = ".mysql_real_escape_string($idPerson)."
AND idAdresse = ".mysql_real_escape_string($linkedEventIdAddress)."
LIMIT 1";
$res = $config->connexionBdd->requete($req);*/
if ($idImage = mysql_fetch_object($res)->idImage) {
$img = new ArchiImage();
$img = $img->getInfosCompletesFromIdImage($idImage);
$linkedEventImg['url'] = $a->getUrlImage("mini") . $img['dateUpload'] . '/' . $idImage . '.jpg';
} else {
$linkedEventImg = $a->getUrlImageFromEvenement($linkedEvent, "mini");
if ($linkedEventImg["url"] == $config->getUrlImage("", "transparent.gif")) {
$linkedEventImg = $a->getUrlImageFromAdresse($linkedEventIdAddress, "mini");
}
}
$linkedEventUrl = $config->creerUrl("", "adresseDetail", array("archiIdAdresse" => $linkedEventIdAddress, "archiIdEvenementGroupeAdresse" => $linkedEvent));
$linkedEventsHTML .= "<li class='linkedEvents'><img src='" . $linkedEventImg["url"] . "' alt='' /> <div style='display:inline-block;'><a href='{$linkedEventUrl}'>" . $linkedEventAddress;
$res = $e->getInfosEvenementsLiesForAncres($e->getIdEvenementGroupeAdresseFromIdEvenement($linkedEvent));
$i = 0;
while ($rep = mysql_fetch_object($res)) {
if ($rep->idEvenement == $linkedEvent) {
$linkedEventPos = $i;
}
$i++;
}
$linkedEventsHTML .= "</a>";
$linkedEventsHTML .= "<br/><small><a href='" . $linkedEventUrl . "#" . $linkedEventPos . "'>";
if ($event->dateDebut != "0000-00-00") {
$linkedEventsHTML .= $config->date->toFrench($event->dateDebut);
if (!empty($event->titre)) {
$linkedEventsHTML .= ", ";
}
}
if (!empty($event->titre)) {
$linkedEventsHTML .= stripslashes($event->titre);
}
if (!empty($linkedEventType)) {
$linkedEventsHTML .= ", ";
}
$linkedEventsHTML .= $linkedEventType;
$linkedEventsHTML .= "</a></small>";
$linkedEventsHTML .= "</div></li>";
}
$linkedEventsHTML .= "</ul>";
return $linkedEventsHTML;
}
}
