public function afficherAdressesLiees($idImage = 0)
{
$html = "";
$t = new Template('modules/archi/templates/');
$t->set_filenames(array('listeAdresses' => 'listeAdressesLiesAImage.tpl'));
$authentification = new archiAuthentification();
if ($authentification->estConnecte()) {
$t->assign_block_vars('isConnected', array());
}
$reqAdressesLiees = "\n SELECT ha.numero as numero, ai.etage as etage,\n ha.idRue as idRue, ha.idSousQuartier as idSousQuartier, ha.idQuartier as idQuartier, ha.idVille as idVille, ha.idPays as idPays,\n ai.prisDepuis as prisDepuis, ai.seSitue as seSitue, ai.hauteur as hauteur, ai.idAdresse as idAdresse\n\n FROM historiqueAdresse hab, historiqueAdresse ha\n\n RIGHT JOIN _adresseImage ai ON ai.idAdresse = ha.idAdresse\n\n LEFT JOIN rue r ON r.idRue = ha.idRue\n LEFT JOIN sousQuartier sq ON sq.idSousQuartier = ha.idSousQuartier\n LEFT JOIN quartier q ON q.idQuartier = ha.idQuartier\n LEFT JOIN ville v ON v.idVille = ha.idVille\n LEFT JOIN pays p ON p.idPays = ha.idPays\n\n WHERE ai.idImage = '" . $idImage . "'\n AND hab.idAdresse = ha.idAdresse\n\n GROUP BY ha.idAdresse, ha.idHistoriqueAdresse\n\n HAVING ha.idHistoriqueAdresse = max(hab.idHistoriqueAdresse)\n ";
$resAdressesLiees = $this->connexionBdd->requete($reqAdressesLiees);
$adresses = new archiAdresse();
$recherche = new archiRecherche();
$arrayListeIdAdresses = array();
while ($fetch = mysql_fetch_assoc($resAdressesLiees)) {
$nomAdressePrisDepuis = $adresses->getNomAdresse($adresses->getArrayAdresseFromIdAdresse($fetch['prisDepuis']));
$nomAdresseSeSitue = $adresses->getNomAdresse($adresses->getArrayAdresseFromIdAdresse($fetch['seSitue']));
$t->assign_block_vars('adressesLiees', array('intitule' => $adresses->getAdresseToDisplay($fetch), 'hauteur' => $fetch['hauteur'], 'etage' => $fetch['etage'], 'prisDepuis' => $fetch['prisDepuis'], 'idAdresse' => $fetch['idAdresse'], 'urlPopupSeSitue' => "#", 'onClickPopupSeSitue' => "document.getElementById('paramChampsAppelantAdresse').value='seSitue_" . $fetch['idAdresse'] . "';document.getElementById('calqueAdresse').style.display='block';", 'urlPopupPrisDepuis' => "#", 'onClickPopupPrisDepuis' => "document.getElementById('paramChampsAppelantAdresse').value='prisDepuis_" . $fetch['idAdresse'] . "';document.getElementById('calqueAdresse').style.display='block';", 'prisDepuisTxt' => $nomAdressePrisDepuis, 'seSitueTxt' => $nomAdresseSeSitue));
$arrayListeIdAdresses[] = $fetch['idAdresse'];
}
$t->assign_vars(array('formAction' => $this->creerUrl('modifImageAdressesLiees', '', array('archiIdImage' => $idImage)), 'listeIdAdresses' => implode(', ', $arrayListeIdAdresses), 'popupAdresses' => $recherche->getPopupChoixAdresse('resultatRechercheAdresseCalqueImageChampMultipleRetourSimple')));
ob_start();
$t->pparse('listeAdresses');
$html = ob_get_contents();
ob_end_clean();
return $html;
}
