public function getHtmlArborescence()
{
$liens = array();
$adresse = new archiAdresse();
$s = new objetSession();
if (isset($this->variablesGet['archiAffichage']) && $this->variablesGet['archiAffichage'] == 'evenement' && isset($this->variablesGet['idEvenement']) && $this->variablesGet['idEvenement'] != '') {
$fetchVille = $adresse->getInfosVille($adresse->getIdVilleFrom($this->variablesGet['idEvenement'], 'idEvenementGroupeAdresse'), array('fieldList' => 'v.idVille as idVille,v.nom as nomVille,v.idPays as idPays, p.nom as nomPays'));
$liens[] = array('libelle' => $fetchVille['nomPays'], 'url' => $this->creerUrl('', 'afficheCarte'));
$liens[] = array('libelle' => $fetchVille['nomVille'], 'url' => $this->creerUrl('', 'afficheAccueil', array('archiIdVilleGeneral' => $fetchVille['idVille'], 'archiIdPaysGeneral' => $fetchVille['idPays'])));
//$s->addToSession('archiIdVilleGeneral', $fetchVille['idVille']);
} elseif ((isset($this->variablesGet['archiAffichage']) && $this->variablesGet['archiAffichage'] != 'afficheCarte' || !isset($this->variablesGet['archiAffichage'])) && (isset($this->variablesGet['archiIdAdresse']) || isset($this->variablesGet['archiIdImage']))) {
if (isset($this->variablesGet['archiIdAdresse']) && $this->variablesGet['archiIdAdresse'] != '') {
$fetchVille = $adresse->getInfosVille($adresse->getIdVilleFrom($this->variablesGet['archiIdAdresse'], 'idAdresse'), array('fieldList' => 'v.idVille as idVille,v.nom as nomVille,v.idPays as idPays, p.nom as nomPays'));
$liens[] = array('libelle' => $fetchVille['nomPays'], 'url' => $this->creerUrl('', 'afficheCarte'));
$liens[] = array('libelle' => $fetchVille['nomVille'], 'url' => $this->creerUrl('', 'afficheAccueil', array('archiIdVilleGeneral' => $fetchVille['idVille'], 'archiIdPaysGeneral' => $fetchVille['idPays'])));
//$s->addToSession('archiIdVilleGeneral', $fetchVille['idVille']);
$arrayAdresse = $adresse->getArrayAdresseFromIdAdresse($this->variablesGet['archiIdAdresse']);
if ($arrayAdresse['nomQuartier'] != '' && strtolower($arrayAdresse['nomQuartier']) != 'autre') {
$liens[] = array('libelle' => ucfirst($arrayAdresse['nomQuartier']), 'url' => $this->creerUrl('', 'adresseListe', array('recherche_quartier' => $arrayAdresse['idQuartier'])));
if ($arrayAdresse['nomSousQuartier'] != '' && strtolower($arrayAdresse['nomSousQuartier']) != 'autre') {
$liens[] = array('libelle' => ucfirst($arrayAdresse['nomSousQuartier']), 'url' => $this->creerUrl('', 'adresseListe', array('recherche_sousQuartier' => $arrayAdresse['idSousQuartier'])));
}
}
} elseif (isset($this->variablesGet['archiIdImage']) && $this->variablesGet['archiIdImage'] != '') {
$i = new archiImage();
$fetchVille = $adresse->getInfosVille($adresse->getIdVilleFrom($i->getIdAdresseFromIdImage($this->variablesGet['archiIdImage']), 'idAdresse'), array('fieldList' => 'v.idVille as idVille,v.nom as nomVille,v.idPays as idPays, p.nom as nomPays'));
$liens[] = array('libelle' => $fetchVille['nomPays'], 'url' => $this->creerUrl('', 'afficheCarte'));
$liens[] = array('libelle' => $fetchVille['nomVille'], 'url' => $this->creerUrl('', 'afficheAccueil', array('archiIdVilleGeneral' => $fetchVille['idVille'], 'archiIdPaysGeneral' => $fetchVille['idPays'])));
//$s->addToSession('archiIdVilleGeneral',$fetchVille['idVille']);
}
} elseif (isset($this->variablesGet['archiAffichage']) && $this->variablesGet['archiAffichage'] == 'adresseListe' && isset($this->variablesGet['recherche_quartier']) && $this->variablesGet['recherche_quartier']) {
$fetchVille = $adresse->getInfosVille($adresse->getIdVilleFrom($this->variablesGet['recherche_quartier'], 'idQuartier'), array('fieldList' => 'v.idVille as idVille,v.nom as nomVille,v.idPays as idPays, p.nom as nomPays'));
$liens[] = array('libelle' => $fetchVille['nomPays'], 'url' => $this->creerUrl('', 'afficheCarte'));
$liens[] = array('libelle' => $fetchVille['nomVille'], 'url' => $this->creerUrl('', 'afficheAccueil', array('archiIdVilleGeneral' => $fetchVille['idVille'], 'archiIdPaysGeneral' => $fetchVille['idPays'])));
//$s->addToSession('archiIdVilleGeneral',$fetchVille['idVille']);
$reqQuartier = "SELECT idQuartier,nom as nomQuartier FROM quartier WHERE idQuartier='" . $this->variablesGet['recherche_quartier'] . "'";
$resQuartier = $this->connexionBdd->requete($reqQuartier);
if (mysql_num_rows($resQuartier) > 0) {
$fetchQuartier = mysql_fetch_assoc($resQuartier);
if ($fetchQuartier['nomQuartier'] != '' && strtolower($fetchQuartier['nomQuartier']) != 'autre') {
$liens[] = array('libelle' => ucfirst($fetchQuartier['nomQuartier']), 'url' => $this->creerUrl('', 'adresseListe', array('recherche_quartier' => $fetchQuartier['idQuartier'])));
}
}
} elseif (isset($this->variablesGet['archiAffichage']) && $this->variablesGet['archiAffichage'] == 'adresseListe' && isset($this->variablesGet['recherche_sousQuartier']) && $this->variablesGet['recherche_sousQuartier'] != '') {
$fetchVille = $adresse->getInfosVille($adresse->getIdVilleFrom($this->variablesGet['recherche_sousQuartier'], 'idSousQuartier'), array('fieldList' => 'v.idVille as idVille,v.nom as nomVille,v.idPays as idPays, p.nom as nomPays'));
$liens[] = array('libelle' => $fetchVille['nomPays'], 'url' => $this->creerUrl('', 'afficheCarte'));
$liens[] = array('libelle' => $fetchVille['nomVille'], 'url' => $this->creerUrl('', 'afficheAccueil', array('archiIdVilleGeneral' => $fetchVille['idVille'], 'archiIdPaysGeneral' => $fetchVille['idPays'])));
//$s->addToSession('archiIdVilleGeneral',$fetchVille['idVille']);
$reqSousQuartier = "\n\t\t\t\t\tSELECT sq.idSousQuartier as idSousQuartier,sq.nom as nomSousQuartier, q.nom as nomQuartier , q.idQuartier as idQuartier\n\t\t\t\t\tFROM sousQuartier sq\n\t\t\t\t\tLEFT JOIN quartier q ON q.idQuartier = sq.idQuartier\n\t\t\t\t\tWHERE sq.idSousQuartier='" . $this->variablesGet['recherche_sousQuartier'] . "'";
$resSousQuartier = $this->connexionBdd->requete($reqSousQuartier);
if (mysql_num_rows($resSousQuartier) > 0) {
$fetchSousQuartier = mysql_fetch_assoc($resSousQuartier);
if ($fetchSousQuartier['nomQuartier'] != '' && strtolower($fetchSousQuartier['nomQuartier']) != 'autre') {
$liens[] = array('libelle' => ucfirst($fetchSousQuartier['nomQuartier']), 'url' => $this->creerUrl('', 'adresseListe', array('recherche_quartier' => $fetchSousQuartier['idQuartier'])));
}
if ($fetchSousQuartier['nomSousQuartier'] != '' && strtolower($fetchSousQuartier['nomSousQuartier']) != 'autre') {
$liens[] = array('libelle' => ucfirst($fetchSousQuartier['nomSousQuartier']), 'url' => $this->creerUrl('', 'adresseListe', array('recherche_sousQuartier' => $fetchSousQuartier['idSousQuartier'])));
}
}
} elseif (isset($this->variablesGet['archiAffichage']) && $this->variablesGet['archiAffichage'] == 'listeDossiers' && isset($this->variablesGet['archiIdQuartier']) && $this->variablesGet['archiIdQuartier'] != '' && isset($this->variablesGet['modeAffichageListe']) && $this->variablesGet['modeAffichageListe'] == 'parRuesDeQuartier') {
$fetchVille = $adresse->getInfosVille($adresse->getIdVilleFrom($this->variablesGet['archiIdQuartier'], 'idQuartier'), array('fieldList' => 'v.idVille as idVille,v.nom as nomVille,v.idPays as idPays, p.nom as nomPays'));
$liens[] = array('libelle' => $fetchVille['nomPays'], 'url' => $this->creerUrl('', 'afficheCarte'));
$liens[] = array('libelle' => $fetchVille['nomVille'], 'url' => $this->creerUrl('', 'afficheAccueil', array('archiIdVilleGeneral' => $fetchVille['idVille'], 'archiIdPaysGeneral' => $fetchVille['idPays'])));
//$s->addToSession('archiIdVilleGeneral',$fetchVille['idVille']);
$reqQuartier = "SELECT idQuartier, nom FROM quartier WHERE idQuartier = '" . $this->variablesGet['archiIdQuartier'] . "'";
$resQuartier = $this->connexionBdd->requete($reqQuartier);
if (mysql_num_rows($resQuartier) > 0) {
$fetchQuartier = mysql_fetch_assoc($resQuartier);
if ($fetchQuartier['nom'] != '' && strtolower($fetchQuartier['nom']) != 'autre') {
$liens[] = array('libelle' => ucfirst($fetchQuartier['nom']), 'url' => $this->creerUrl('', 'adresseListe', array('recherche_quartier' => $fetchQuartier['idQuartier'])));
}
}
} elseif ($s->isInSession('archiIdVilleGeneral') && $s->getFromSession('archiIdVilleGeneral') != '') {
$arrayInfosVille = $adresse->getInfosVille($s->getFromSession('archiIdVilleGeneral'), array("fieldList" => " v.nom as nomVille,v.idVille as idVille, v.idPays as idPays, p.nom as nomPays"));
$liens[] = array('libelle' => $arrayInfosVille['nomPays'], 'url' => $this->creerUrl('', 'afficheCarte'));
$liens[] = array('libelle' => $arrayInfosVille['nomVille'], 'url' => $this->creerUrl('', 'afficheAccueil', array('archiIdVilleGeneral' => $arrayInfosVille['idVille'], 'archiIdPaysGeneral' => $arrayInfosVille['idPays'])));
} else {
$liens[] = array('libelle' => 'France', 'url' => $this->creerUrl('', 'afficheCarte'));
}
$retour = "";
foreach ($liens as $indice => $value) {
$retour .= " <a href='" . $value['url'] . "'>" . $value['libelle'] . "</a> >";
}
$retour = pia_substr($retour, 0, -1);
return $retour;
}
