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; }