/trunk/controleurs/AnnuaireControleur.php |
---|
166,6 → 166,7 |
if ($this->annuaireAvoirFormulaireInscription($annuaire['informations']['aa_code'])) { |
$formulaire_inscription = $this->GetVue(Config::get('dossier_squelettes_formulaires').$annuaire['informations']['aa_code'].'_inscription',$donnees); |
} else { |
$tableau_nom_mappage = $this->obtenirNomsChampsMappageAnnuaire($id_annuaire); |
$donnees['mappage_nom_champs'] = $tableau_nom_mappage; |
1200,8 → 1201,9 |
$valeur = $valeurs_recherchees['departement']; |
$champ_critere = $tableau_mappage[0]['champ_code_postal']; |
$criteres = array($tableau_mappage[0]['champ_pays'] => $valeurs_recherchees['pays'], |
$tableau_mappage[0]['champ_code_postal'] => $valeurs_recherchees['departement'] |
$criteres = array( |
$tableau_mappage[0]['champ_pays'] => $valeurs_recherchees['pays'], |
$tableau_mappage[0]['champ_code_postal'] => $valeurs_recherchees['departement'] |
); |
} |
1432,4 → 1434,3 |
return $this->AnnuaireModele->chargerNombreAnnuaireListeInscritsParDepartement($id_annuaire); |
} |
} |
?> |
Property changes: |
Added: svnkit:entry:sha1-checksum |
+944bd9cfcd47b6193f55d5774b921b5d4a220ca4 |
\ No newline at end of property |
/trunk/controleurs/CartoControleur.php |
---|
3,106 → 3,104 |
/** |
* classe Controleur du module Carte. |
* |
* @package Collection |
* @category Php5 |
* @author Jean-Pascal MILCENT <jpm@tela-botanica.org> |
* @author Aurélien Peronnet <aurelien@tela-botanica.org> |
* @package Collection |
* @category Php5 |
* @author Jean-Pascal MILCENT <jpm@tela-botanica.org> |
* @author Aurélien Peronnet <aurelien@tela-botanica.org> |
* @copyright 2010 Tela-Botanica |
* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL |
* @license http://www.gnu.org/licenses/gpl.html Licence GNU-GPL |
* @version SVN: $Id$ |
* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL |
* @license http://www.gnu.org/licenses/gpl.html Licence GNU-GPL |
*/ |
class CartoControleur extends AppControleur { |
// identifiant de la france pour l'accès direct |
private $id_france = 'fr'; |
private $id_france = 'fr'; |
// nom du fond de carte en cours |
private $nom_fond = ''; |
private $niveau = 0; |
// contient le tableau de données sur les continents une fois chargé |
private $donnees_continents = array(); |
// contient le tableau de données sur les pays une fois chargé |
private $donnees_pays = array(); |
// contient le tableau de données sur les departements une fois chargé |
private $donnees_departements = array(); |
// contient le nombre total d'inscrits dans la zone en cours de consultation |
private $total_inscrits_zone = 0; |
private $nom_fond = ''; |
//+----------------------------------------------------------------------------------------------------------------+ |
// Méthodes |
private $niveau = 0; |
/** |
* Fonction d'affichage par défaut, elle appelle la cartographie |
*/ |
public function executerActionParDefaut() { |
return $this->cartographier(1); |
} |
// contient le tableau de données sur les continents une fois chargé |
private $donnees_continents = array(); |
/** |
* Cartographier un annuaire. |
* @param int $id_annuaire l'identitifiant de l'annuaire à cartographier |
* @param int $continent l'identitifiant du continent sur lequel on se trouve |
* @param string $pays l'identitifiant du pays sur lequel on se trouve (normalement seulement la france si présent) |
* @return string la vue correspondante |
*/ |
public function cartographier($id_annuaire, $continent= null , $pays = null) { |
// Initialisation de variable |
$donnees = array(); |
// contient le tableau de données sur les pays une fois chargé |
private $donnees_pays = array(); |
// contient le tableau de données sur les departements une fois chargé |
private $donnees_departements = array(); |
// contient le nombre total d'inscrits dans la zone en cours de consultation |
private $total_inscrits_zone = 0; |
//+----------------------------------------------------------------------------------------------------------------+ |
// Méthodes |
/** |
* Fonction d'affichage par défaut, elle appelle la cartographie |
*/ |
public function executerActionParDefaut() { |
return $this->cartographier(1); |
} |
/** |
* Cartographier un annuaire. |
* @param int $id_annuaire l'identitifiant de l'annuaire à cartographier |
* @param int $continent l'identitifiant du continent sur lequel on se trouve |
* @param string $pays l'identitifiant du pays sur lequel on se trouve (normalement seulement la france si présent) |
* @return string la vue correspondante |
*/ |
public function cartographier($id_annuaire, $continent= null , $pays = null) { |
// Initialisation de variable |
$donnees = array(); |
// la présence d'un pays (non) et d'un continent (ou non) détermine le niveau de carte à afficher |
$this->niveau = $this->calculerNiveau($continent, $pays); |
$this->niveau = $this->calculerNiveau($continent, $pays); |
// suivant le niveau, continent et pays, on renvoie un template html différent |
$fond = $this->renvoyerPrefixePourNiveau($this->niveau, $continent, $pays); |
// suivant le niveau, continent et pays, on renvoie un template html différent |
$fond = $this->renvoyerPrefixePourNiveau($this->niveau, $continent, $pays); |
$carte = ''; |
// chaque continent possède un fond de carte différent |
if($this->niveau == 1) { |
$carte = $this->renvoyerSuffixePourContinent($this->niveau, $continent, $pays); |
if ($this->niveau == 1) { |
$carte = $this->renvoyerSuffixePourContinent($this->niveau, $continent, $pays); |
} |
// Création de la carte |
$options = array( |
'carte_nom' => $fond.$carte, |
'formule' => Cartographie::FORMULE_PROPORTIONNEL, |
'couleur_claire' => Config::get('carte_couleur_claire'), |
'couleur_foncee' => Config::get('carte_couleur_foncee'), |
'fond_fichier' => Config::get('carte_base_nom_'.$fond).$carte, |
'fond_dossier' => Application::getChemin().Config::get('carte_fonds_chemin'), |
'stock_dossier' => Config::get('carte_stockage_chemin'), |
'stock_url' => Config::get('carte_stockage_url'), |
'debug' => Config::get('carte_mode_debug')); |
$cartographie = Composant::fabrique('cartographie', $options); |
// Création de la carte |
$options = array( |
'carte_nom' => $fond.$carte, |
'formule' => Cartographie::FORMULE_PROPORTIONNEL, |
'couleur_claire' => Config::get('carte_couleur_claire'), |
'couleur_foncee' => Config::get('carte_couleur_foncee'), |
'fond_fichier' => Config::get('carte_base_nom_'.$fond).$carte, |
'fond_dossier' => Application::getChemin().Config::get('carte_fonds_chemin'), |
'stock_dossier' => Config::get('carte_stockage_chemin'), |
'stock_url' => Config::get('carte_stockage_url'), |
'debug' => Config::get('carte_mode_debug')); |
$cartographie = Composant::fabrique('cartographie', $options); |
$this->nom_fond = Config::get('carte_base_nom_'.$fond).$carte; |
$this->nom_fond = Config::get('carte_base_nom_'.$fond).$carte; |
// Construction des données nécessaires à la cartographie |
$zones = $cartographie->getCarteZones(); |
$this->chargerZonesNbre($id_annuaire,$zones, $this->niveau); |
$this->chargerZonesUrls($id_annuaire, $zones, $continent, $pays, $this->niveau); |
// Construction des données nécessaires à la cartographie |
$zones = $cartographie->getCarteZones(); |
$this->chargerZonesNbre($id_annuaire,$zones, $this->niveau); |
$this->chargerZonesUrls($id_annuaire, $zones, $continent, $pays, $this->niveau); |
$navigation = new NavigationControleur(); |
$navigation = new NavigationControleur(); |
$donnees_navigation = $this->obtenirUrlsNavigation($id_annuaire, $continent, $pays, null); |
$donnees['infos_pays'] = $donnees_navigation; |
$donnees['navigation'] = $navigation->afficherBandeauNavigationCartographie($donnees_navigation); |
$donnees['nb_resultats'] = $this->total_inscrits_zone; |
$cartographie->setCarteZones($zones); |
$cartographie->setCarteZones($zones); |
$cartographie->creerCarte(); |
$donnees['map'] = $cartographie->getImageMap(); |
$cartographie->creerCarte(); |
$donnees['map'] = $cartographie->getImageMap(); |
$resultat = $this->getVue('cartes/'.$fond, $donnees); |
return $resultat; |
} |
$resultat = $this->getVue('cartes/'.$fond, $donnees); |
return $resultat; |
} |
/** |
* Charge le nombre d'inscrit par zone pour un annuaire donné |
110,46 → 108,41 |
* @param array $zones les zones à cartographier (attention, passage par référence, donc les zones sont modifiées) |
* @param int $niveau le niveau de la carto (monde, continent, ou pays) |
*/ |
private function chargerZonesNbre($id_annuaire, &$zones, $niveau = 0) { |
private function chargerZonesNbre($id_annuaire, &$zones, $niveau = 0) { |
$metaModele = $this->getModele('AnnuaireModele'); |
// on charge les inscrits pour le niveau donné |
$zones_infos = $this->chargerNombreInscritsParNiveauGeographique($id_annuaire, $niveau); |
$metaModele = $this->getModele('AnnuaireModele'); |
// on charge les inscrits pour le niveau donné |
$zones_infos = $this->chargerNombreInscritsParNiveauGeographique($id_annuaire, $niveau); |
foreach ($zones as $id => &$infos) { |
foreach ($zones as $id => &$infos) { |
// si l'on a des données pour la zone, on renseigne le nombre d'inscrits |
if (isset($zones_infos[$id])) { |
if (isset($zones_infos[$id])) { |
$nbre = $zones_infos[$id]; |
$infos['info_nombre'] = $nbre; |
$this->total_inscrits_zone += $nbre; |
} else { |
// sinon on le met à 0 |
$infos['info_nombre'] = 0; |
} |
} |
} |
$nbre = $zones_infos[$id]; |
$infos['info_nombre'] = $nbre; |
$this->total_inscrits_zone += $nbre; |
} else { |
// sinon on le met à 0 |
$infos['info_nombre'] = 0; |
} |
} |
} |
/** |
* Charge les des zones pour un annuaire donné |
* @param int $id_annuaire l'identifiant de l'annuaire |
* @param array $zones les zones à cartographier (attention, passage par référence, donc les zones sont modifiées) |
* @param int $continent l'identitifiant du continent sur lequel on se trouve |
* @param string $pays l'identitifiant du pays sur lequel on se trouve (normalement seulement la france si présent) |
* @param string $pays l'identitifiant du pays sur lequel on se trouve (normalement seulement la france si présent) |
* @param int $niveau le niveau de la carto (monde, continent, ou pays) |
*/ |
private function chargerZonesUrls($id_annuaire, &$zones, $continent = null, $pays = null, $niveau = 0) { |
private function chargerZonesUrls($id_annuaire, &$zones, $continent = null, $pays = null, $niveau = 0) { |
$url = new URL(Config::get('url_base')); |
$url = new URL(Config::get('url_base')); |
$url->setVariableRequete('id_annuaire', $id_annuaire); |
$url->setVariableRequete('id_annuaire', $id_annuaire); |
foreach ($zones as $id => &$infos) { |
foreach ($zones as $id => &$infos) { |
switch ($niveau) { |
switch ($niveau) { |
// niveau 0 de la carte : on affiche tous les continents |
// l'url va pointer vers un continent en particulier |
case 0: |
181,32 → 174,32 |
$url->setVariableRequete('departement', $id); |
break; |
} |
$infos['url'] = sprintf($url, $id); |
} |
} |
$infos['url'] = sprintf($url, $id); |
} |
} |
/** |
* Renvoie le niveau auquel on se trouve suivant la présence ou non de certains paramètres |
* @param int $continent l'identitifiant du continent sur lequel on se trouve |
* @param string $pays l'identitifiant du pays sur lequel on se trouve (normalement seulement la france si présent) |
* @param string $pays l'identitifiant du pays sur lequel on se trouve (normalement seulement la france si présent) |
*/ |
private function calculerNiveau($continent, $pays) { |
private function calculerNiveau($continent, $pays) { |
// le niveau 0 c'est la carte de base |
$niveau = 0; |
$niveau = 0; |
// le niveau 1 on consulte un continent en particulier (ex. Amérique du Sud) |
if($continent != null) { |
$niveau = 1; |
} |
$niveau = 1; |
} |
// le niveau 2 c'est un pays en particulier (ce cas là n'arrive que pour la france) |
if($pays != null) { |
$niveau = 2; |
} |
if($pays != null) { |
$niveau = 2; |
} |
return $niveau; |
} |
return $niveau; |
} |
/** |
* Renvoie le type de template à utiliser suivant le niveau de certains paramètres |
213,17 → 206,17 |
* @param int $niveau le niveau de la carto |
* @return string le type de template |
*/ |
private function renvoyerPrefixePourNiveau($niveau) { |
switch ($niveau) { |
case 0: |
$fond = 'continents'; |
break; |
private function renvoyerPrefixePourNiveau($niveau) { |
switch ($niveau) { |
case 0: |
$fond = 'continents'; |
break; |
case 1: |
case 1: |
$fond = 'pays'; |
break; |
break; |
case 2 : |
case 2 : |
$fond = 'france'; |
break; |
230,10 → 223,10 |
default: |
$fond = ''; |
break; |
} |
} |
return $fond; |
} |
return $fond; |
} |
/** |
* Renvoie le suffixe de fond de carte à utiliser pour un continent donné |
241,52 → 234,52 |
* @param int $niveau l'identifiant de continent |
* @return string le suffixe |
*/ |
private function renvoyerSuffixePourContinent($niveau, $continent) { |
private function renvoyerSuffixePourContinent($niveau, $continent) { |
switch ($continent) { |
case 1: |
switch ($continent) { |
case 1: |
$carte = '_afrique'; |
break; |
case 2: |
case 2: |
$carte = '_nord_amerique'; |
break; |
case 3: |
case 3: |
$carte = '_asie'; |
break; |
case 4: |
case 4: |
$carte = '_europe'; |
break; |
case 5: |
case 5: |
$carte = '_oceanie'; |
break; |
break; |
case 6: |
case 6: |
$carte = '_sud_amerique'; |
break; |
break; |
case 7: |
case 7: |
$carte = '_moyen_orient'; |
break; |
break; |
default: |
$carte = ''; |
break; |
} |
default: |
$carte = ''; |
break; |
} |
return $carte; |
} |
return $carte; |
} |
/** |
* renvoie tous les noms templates pour chaque zone du monde |
* @return array un tableau associatif indexé par les identifiants de zone et contenant les noms de templates |
*/ |
private function renvoyerTousTemplates() { |
return array(1 => 'pays_afrique', 2 => 'pays_nord_amerique', 3 => 'pays_asie', 4 => 'pays_europe', 5 => 'pays_oceanie', 6 => 'pays_sud_amerique', 7 => 'pays_moyen_orient'); |
} |
private function renvoyerTousTemplates() { |
return array(1 => 'pays_afrique', 2 => 'pays_nord_amerique', 3 => 'pays_asie', 4 => 'pays_europe', 5 => 'pays_oceanie', 6 => 'pays_sud_amerique', 7 => 'pays_moyen_orient'); |
} |
/** |
* Charge la liste des inscrits par zone pour un niveau géographique donné |
294,11 → 287,8 |
* @param int $niveau le niveau où l'on se situe |
* @return array un tableau associatif indexé par les identifiants de zone et contenant le nombre d'inscrits pour chaque zone |
*/ |
private function chargerNombreInscritsParNiveauGeographique($id_annuaire, $niveau) { |
$nb_inscrits = array(); |
if($niveau == 0) { |
private function chargerNombreInscritsParNiveauGeographique($id_annuaire, $niveau) { |
if ($niveau == 0) { |
// si on est au niveau des continents |
$zones_ids = array(); |
// il faut faire la somme des inscrits par zones géographique |
309,65 → 299,50 |
} |
$annuaire_controleur = new AnnuaireControleur(); |
$nb_inscrits = array(); |
switch ($niveau) { |
// niveau de la carte du monde |
case 0: |
// pour chacun des continents, on fait la somme des membres de sa zone |
foreach($templates as $id_continent => $template) { |
$zones_continent_ids = $this->chargerZonesParCsv(Application::getChemin().Config::get('carte_fonds_chemin').$template); |
$nb_inscrits[$id_continent] = array_sum($annuaire_controleur->chargerNombreAnnuaireListeInscritsParPays($id_annuaire, $zones_continent_ids)); |
} |
break; |
// niveau de la carte des pays d'un continent |
case 1: |
case 0 : // niveau de la carte du monde |
// pour chacun des continents, on fait la somme des membres de sa zone |
foreach ($templates as $id_continent => $template) { |
$zones_continent_ids = $this->chargerZonesParCsv(Application::getChemin().Config::get('carte_fonds_chemin').$template); |
$nb_inscrits[$id_continent] = array_sum($annuaire_controleur->chargerNombreAnnuaireListeInscritsParPays($id_annuaire, $zones_continent_ids)); |
} |
break; |
case 1 : // niveau de la carte des pays d'un continent |
$nb_inscrits = $annuaire_controleur->chargerNombreAnnuaireListeInscritsParPays($id_annuaire, $zones_ids); |
break; |
// détail d'un pays |
case 2 : |
break; |
case 2 : // détail d'un pays |
$nb_inscrits = $annuaire_controleur->chargerNombreAnnuaireListeInscritsParDepartement($id_annuaire); |
break; |
// action par défaut |
default: |
// on renvoie un tableau vide |
$nb_inscrits = array(); |
break; |
break; |
} |
return $nb_inscrits; |
} |
return $nb_inscrits; |
} |
public function obtenirUrlsNavigation($id_annuaire ,$continent = null, $pays = null, $departement = null) { |
$donnees = array(); |
$url_carte_monde = new URL(Config::get('url_base')); |
$url_carte_monde->setVariableRequete('id_annuaire', $id_annuaire); |
public function obtenirUrlsNavigation($id_annuaire ,$continent = null, $pays = null, $departement = null) { |
$url_carte_monde = new URL(Config::get('url_base')); |
$url_carte_monde->setVariableRequete('id_annuaire', $id_annuaire); |
$url_carte_monde->setVariableRequete('m', 'annuaire_afficher_carte'); |
$donnees['url_carte_monde'] = $url_carte_monde; |
$donnees['nom_carte_monde'] = 'Carte du monde'; |
if($continent != null && trim($continent) != '') { |
$infos_continents = $this->chargerInformationsContinentCsv(); |
$url_continent = new URL(Config::get('url_base')); |
$url_continent->setVariableRequete('id_annuaire', $id_annuaire); |
$donnees = array(); |
$donnees['url_carte_monde'] = $url_carte_monde; |
$donnees['nom_carte_monde'] = 'Carte du monde'; |
if ($continent != null && trim($continent) != '') { |
$infos_continents = $this->chargerInformationsContinentCsv(); |
$url_continent = new URL(Config::get('url_base')); |
$url_continent->setVariableRequete('id_annuaire', $id_annuaire); |
$url_continent->setVariableRequete('m', 'annuaire_afficher_carte'); |
$url_continent->setVariableRequete('continent', $continent); |
$donnees['url_continent'] = $url_continent; |
$donnees['nom_continent'] = $infos_continents[$continent][2]; |
} |
if($pays != null && trim($pays) != '') { |
$templates_continents = $this->renvoyerTousTemplates(); |
$infos_continents = $this->chargerInformationsPaysDuContinentsCsv($templates_continents[$continent]); |
$infos_pays = $infos_continents[$pays]; |
$url_pays = new URL(Config::get('url_base')); |
$url_pays->setVariableRequete('id_annuaire', $id_annuaire); |
if($pays == $this->id_france) { |
$donnees['url_continent'] = $url_continent; |
$donnees['nom_continent'] = $infos_continents[$continent][2]; |
} |
if ($pays != null && trim($pays) != '') { |
$templates_continents = $this->renvoyerTousTemplates(); |
$infos_continents = $this->chargerInformationsPaysDuContinentsCsv($templates_continents[$continent]); |
$infos_pays = $infos_continents[$pays]; |
$url_pays = new URL(Config::get('url_base')); |
$url_pays->setVariableRequete('id_annuaire', $id_annuaire); |
if ($pays == $this->id_france) { |
$url_pays->setVariableRequete('m', 'annuaire_afficher_carte'); |
} else { |
// sinon l'url pointe vers la liste des inscrits de ce pays |
375,59 → 350,49 |
} |
$url_pays->setVariableRequete('continent', $continent); |
$url_pays->setVariableRequete('pays', $pays); |
$donnees['url_pays'] = $url_pays; |
$donnees['nom_pays'] = $infos_pays[2]; |
} |
if($departement != null && trim($departement) != '') { |
$infos_departement = $this->chargerInformationsDepartementsFranceCsv(); |
$url_departement = new URL(Config::get('url_base')); |
$url_departement->setVariableRequete('id_annuaire', $id_annuaire); |
$donnees['url_pays'] = $url_pays; |
$donnees['nom_pays'] = $infos_pays[2]; |
} |
if ($departement != null && trim($departement) != '') { |
$infos_departement = $this->chargerInformationsDepartementsFranceCsv(); |
$url_departement = new URL(Config::get('url_base')); |
$url_departement->setVariableRequete('id_annuaire', $id_annuaire); |
$url_departement->setVariableRequete('m', 'annuaire_afficher_carte'); |
$url_departement->setVariableRequete('continent', $continent); |
$url_departement->setVariableRequete('departement', $departement); |
$url_departement->setVariableRequete('pays', $pays); |
$donnees['url_departement'] = $url_departement; |
$donnees['nom_departement'] = $infos_departement[$departement][2]; |
} |
$donnees['url_departement'] = $url_departement; |
$donnees['nom_departement'] = $infos_departement[$departement][2]; |
} |
$donnees['nb_resultats'] = $this->total_inscrits_zone; |
$donnees['nb_resultats'] = $this->total_inscrits_zone; |
return $donnees; |
} |
return $donnees; |
} |
public function chargerInformationsContinentCsv() { |
$nom_csv = Application::getChemin().Config::get('carte_fonds_chemin').'continents'; |
return $this->chargerInformationsCompletesParCsv($nom_csv); |
} |
public function chargerInformationsPaysDuContinentsCsv($continent) { |
$nom_csv = Application::getChemin().Config::get('carte_fonds_chemin').$continent; |
public function chargerInformationsContinentCsv() { |
$nom_csv = Application::getChemin().Config::get('carte_fonds_chemin').'continents'; |
return $this->chargerInformationsCompletesParCsv($nom_csv); |
} |
return $this->chargerInformationsCompletesParCsv($nom_csv); |
} |
public function chargerInformationsDepartementsFranceCsv() { |
$nom_csv = Application::getChemin().Config::get('carte_fonds_chemin').'france'; |
return $this->chargerInformationsCompletesParCsv($nom_csv); |
} |
public function chargerInformationsCompletesParCsv($nom_csv) { |
$fichier_csv = $nom_csv.'.csv'; |
$infos = array(); |
public function chargerInformationsPaysDuContinentsCsv($continent) { |
$nom_csv = Application::getChemin().Config::get('carte_fonds_chemin').$continent; |
return $this->chargerInformationsCompletesParCsv($nom_csv); |
} |
public function chargerInformationsDepartementsFranceCsv() { |
$nom_csv = Application::getChemin().Config::get('carte_fonds_chemin').'france'; |
return $this->chargerInformationsCompletesParCsv($nom_csv); |
} |
public function chargerInformationsCompletesParCsv($nom_csv) { |
$fichier_csv = $nom_csv.'.csv'; |
$infos = array(); |
if (($handle = fopen($fichier_csv, 'r')) !== false) { |
$ligne = 0; |
while (($donnees = fgetcsv($handle, 1000, ',')) !== false) { |
if($ligne != 0 && trim($donnees[0]) != '') { |
$infos[$donnees[0]] = $donnees; |
} |
$ligne++; |
434,10 → 399,8 |
} |
fclose($handle); |
} |
return $infos; |
} |
} |
/** |
* Récupère les identifiants de zone dans un fichier csv donné |
444,16 → 407,12 |
* @param string $nom_csv chemin vers le fichier csv (sans extension) qui contient les données |
* @return array un tableau contenant les identifiants des zones |
*/ |
private function chargerZonesParCsv($nom_csv) { |
private function chargerZonesParCsv($nom_csv) { |
$fichier_csv = $nom_csv.'.csv'; |
$zones_id = array(); |
if (($handle = fopen($fichier_csv, 'r')) !== false) { |
$ligne = 0; |
while (($donnees = fgetcsv($handle, 1000, ',')) !== false) { |
if($ligne != 0 && trim($donnees[0]) != '') { |
$zones_id[] = "'".$donnees[0]."'"; |
} |
461,8 → 420,6 |
} |
fclose($handle); |
} |
return $zones_id; |
} |
} |
?> |
} |
} |
Property changes: |
Added: svnkit:entry:sha1-checksum |
+be06e5e37b1d0280628ea8db298296154bfefe64 |
\ No newline at end of property |
/trunk/cartes/pays_nord_amerique.html |
---|
File deleted |
/trunk/cartes/pays_europe.html |
---|
File deleted |
/trunk/cartes/pays_asie.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = image/png |
/trunk/cartes/france.html |
---|
File deleted |
\ No newline at end of file |
/trunk/cartes/pays_sud_amerique.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = image/png |
/trunk/cartes/pays_oceanie.html |
---|
File deleted |
/trunk/cartes/pays_moyen_orient.html |
---|
File deleted |
/trunk/cartes/continents.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = image/png |
/trunk/cartes/pays_nord_amerique.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = image/png |
/trunk/cartes/pays_europe.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = image/png |
/trunk/cartes/pays_asie.html |
---|
File deleted |
/trunk/cartes/france.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = image/png |
/trunk/cartes/pays_oceanie.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = image/png |
/trunk/cartes/pays_sud_amerique.html |
---|
File deleted |
/trunk/cartes/pays_moyen_orient.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = image/png |
/trunk/cartes/continents.html |
---|
File deleted |
/trunk/cartes/pays_afrique.html |
---|
1,58 → 1,58 |
<div id="cartographie"> |
<img id="carte-img" src="http://162.38.234.9/annuaire/cartes/pays_afrique.png" alt="info" usemap="#carte-map" /> |
<img id="carte-img" src="http://localhost/applications/annuaire/cartes/pays_afrique.png" alt="info" usemap="#carte-map" /> |
<map name="carte-map"> |
<area shape="poly" title="Comores (3 inscrits)" class="zone-km" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=km" coords="471,401,469,401,470,403 480,401,480,399,477,400 463,392,460,389,463,385,463,383,461,383,459,386,459,389,464,395" /> |
<area shape="poly" title="Côte d'Ivoire (41 inscrits)" class="zone-ci" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ci" coords="99,263,110,263,113,264,113,261,111,259,110,249,112,247,112,244,115,240,114,232,110,229,104,229,98,230,94,226,91,225,88,226,87,223,85,223,85,225,75,226,74,230,76,232,77,239,75,240,75,245,73,247,73,253,76,255,77,257,80,259,80,263,79,269,88,265,90,265" /> |
<area shape="poly" title="Comores (4 inscrits)" class="zone-km" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=km" coords="471,401,469,401,470,403 480,401,480,399,477,400 463,392,460,389,463,385,463,383,461,383,459,386,459,389,464,395" /> |
<area shape="poly" title="Côte d'Ivoire (82 inscrits)" class="zone-ci" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ci" coords="99,263,110,263,113,264,113,261,111,259,110,249,112,247,112,244,115,240,114,232,110,229,104,229,98,230,94,226,91,225,88,226,87,223,85,223,85,225,75,226,74,230,76,232,77,239,75,240,75,245,73,247,73,253,76,255,77,257,80,259,80,263,79,269,88,265,90,265" /> |
<area shape="poly" title="Rwanda (6 inscrits)" class="zone-rw" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=rw" coords="359,319,364,319,364,315,363,312,361,312,357,313,354,318,354,320,358,321" /> |
<area shape="poly" title="Malawi (0 inscrit)" class="zone-mw" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=mw" coords="396,427,399,423,402,421,402,413,394,404,390,397,388,395,388,393,390,390,390,381,388,379,387,375,385,375,387,382,385,385,385,396,382,399,382,403,381,405,386,410,392,410,394,412,394,419,393,424" /> |
<area shape="poly" title="Burkina Faso (7 inscrits)" class="zone-bf" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=bf" coords="113,225,112,220,140,219,144,215,149,215,150,212,149,208,144,208,141,204,140,201,135,196,135,194,134,191,129,191,127,193,114,202,112,202,108,203,106,204,103,211,97,217,97,219,96,224,99,228,102,228,111,227,113,228" /> |
<area shape="poly" title="Burkina Faso (31 inscrits)" class="zone-bf" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=bf" coords="113,225,112,220,140,219,144,215,149,215,150,212,149,208,144,208,141,204,140,201,135,196,135,194,134,191,129,191,127,193,114,202,112,202,108,203,106,204,103,211,97,217,97,219,96,224,99,228,102,228,111,227,113,228" /> |
<area shape="poly" title="Sierra Leone (0 inscrit)" class="zone-sl" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=sl" coords="48,248,50,246,54,243,55,240,54,235,51,230,42,229,36,236,37,240,39,242,43,247,45,247" /> |
<area shape="poly" title="Egypte (1 inscrit)" class="zone-eg" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=eg" coords="389,85,391,84,391,81,393,76,393,71,390,64,390,62,389,59,387,59,377,60,377,63,379,64,379,68,380,72,382,74,385,81 384,86,379,81,377,76,377,74,375,71,375,58,372,56,361,56,359,58,354,60,352,62,349,62,346,60,344,60,337,57,335,57,329,56,327,55,323,56,321,55,320,59,321,66,319,68,319,70,320,74,322,75,322,134,384,134,388,135,391,131,393,131,394,128,399,126,399,118,396,115,387,96,387,94,384,89" /> |
<area shape="poly" title="Gabon (7 inscrits)" class="zone-ga" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ga" coords="229,316,235,317,237,319,239,314,239,306,238,299,240,296,240,293,236,292,234,294,232,294,231,287,228,287,222,286,219,287,219,294,206,295,206,301,204,302,204,306,202,308,202,311,204,316,207,319,216,329,220,328,220,321" /> |
<area shape="poly" title="Egypte (2 inscrits)" class="zone-eg" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=eg" coords="389,85,391,84,391,81,393,76,393,71,390,64,390,62,389,59,387,59,377,60,377,63,379,64,379,68,380,72,382,74,385,81 384,86,379,81,377,76,377,74,375,71,375,58,372,56,361,56,359,58,354,60,352,62,349,62,346,60,344,60,337,57,335,57,329,56,327,55,323,56,321,55,320,59,321,66,319,68,319,70,320,74,322,75,322,134,384,134,388,135,391,131,393,131,394,128,399,126,399,118,396,115,387,96,387,94,384,89" /> |
<area shape="poly" title="Gabon (15 inscrits)" class="zone-ga" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ga" coords="229,316,235,317,237,319,239,314,239,306,238,299,240,296,240,293,236,292,234,294,232,294,231,287,228,287,222,286,219,287,219,294,206,295,206,301,204,302,204,306,202,308,202,311,204,316,207,319,216,329,220,328,220,321" /> |
<area shape="poly" title="Botswana (0 inscrit)" class="zone-bw" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=bw" coords="320,499,324,498,326,493,328,491,334,486,338,481,340,478,347,473,350,472,350,470,345,469,342,467,342,465,341,460,338,457,331,453,327,448,325,443,323,441,322,438,320,438,315,440,311,444,309,443,308,440,303,440,294,442,291,443,291,469,284,470,284,492,289,497,291,500,291,504,290,507,297,508,305,501,308,497,315,497,318,499" /> |
<area shape="poly" title="Ouganda (0 inscrit)" class="zone-ug" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ug" coords="361,309,371,309,371,307,372,304,374,302,377,300,382,300,385,299,389,300,390,297,392,295,396,290,396,284,391,278,391,274,388,273,386,275,379,275,373,276,368,275,366,278,366,282,369,285,369,287,366,290,364,291,364,293,360,298,358,307,358,311" /> |
<area shape="poly" title="Swaziland (0 inscrit)" class="zone-sz" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=sz" coords="371,511,373,509,373,503,369,502,366,507,367,511" /> |
<area shape="poly" title="Lesotho (0 inscrit)" class="zone-ls" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ls" coords="350,536,352,534,353,530,351,528,349,525,346,525,340,530,339,535,343,540,347,537" /> |
<area shape="poly" title="Ethiopie (0 inscrit)" class="zone-et" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=et" coords="448,272,450,270,452,270,455,269,458,266,463,264,471,264,482,253,491,245,491,243,484,243,475,239,473,239,466,236,464,236,456,228,454,225,454,221,449,222,447,220,447,217,449,212,449,209,446,206,443,202,441,201,437,196,431,195,429,194,421,195,418,193,416,196,408,196,408,201,406,206,401,210,397,217,397,220,391,225,391,238,389,240,384,241,384,243,387,244,390,247,392,250,396,253,396,255,399,260,402,261,404,263,404,267,408,267,421,274,423,274,430,275,434,271,436,271,442,270,445,272" /> |
<area shape="poly" title="Congo (5 inscrits)" class="zone-cg" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=cg" coords="219,332,223,336,224,338,229,334,233,337,235,337,238,334,241,334,242,337,244,337,253,329,254,321,256,316,258,314,260,311,266,306,266,300,267,292,268,287,272,280,272,277,266,277,261,276,255,282,255,289,252,290,249,288,246,288,234,287,233,291,239,290,242,293,242,297,240,300,240,304,241,317,240,320,236,321,234,319,230,319,228,318,226,320,222,323,222,329,219,330" /> |
<area shape="poly" title="Mauritanie (4 inscrits)" class="zone-mr" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=mr" coords="44,189,46,187,47,183,51,182,54,186,56,186,58,184,92,184,93,180,90,178,90,169,87,141,87,139,85,122,85,119,84,110,93,109,92,107,85,103,83,101,76,97,74,95,71,94,71,101,47,102,47,122,44,124,41,124,38,126,38,139,8,140,9,142,13,145,14,152,13,156,15,159,15,167,12,174,12,176,19,176,27,175,31,179,34,179,37,184,42,189" /> |
<area shape="poly" title="Ethiopie (1 inscrit)" class="zone-et" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=et" coords="448,272,450,270,452,270,455,269,458,266,463,264,471,264,482,253,491,245,491,243,484,243,475,239,473,239,466,236,464,236,456,228,454,225,454,221,449,222,447,220,447,217,449,212,449,209,446,206,443,202,441,201,437,196,431,195,429,194,421,195,418,193,416,196,408,196,408,201,406,206,401,210,397,217,397,220,391,225,391,238,389,240,384,241,384,243,387,244,390,247,392,250,396,253,396,255,399,260,402,261,404,263,404,267,408,267,421,274,423,274,430,275,434,271,436,271,442,270,445,272" /> |
<area shape="poly" title="Congo (13 inscrits)" class="zone-cg" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=cg" coords="219,332,223,336,224,338,229,334,233,337,235,337,238,334,241,334,242,337,244,337,253,329,254,321,256,316,258,314,260,311,266,306,266,300,267,292,268,287,272,280,272,277,266,277,261,276,255,282,255,289,252,290,249,288,246,288,234,287,233,291,239,290,242,293,242,297,240,300,240,304,241,317,240,320,236,321,234,319,230,319,228,318,226,320,222,323,222,329,219,330" /> |
<area shape="poly" title="Mauritanie (11 inscrits)" class="zone-mr" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=mr" coords="44,189,46,187,47,183,51,182,54,186,56,186,58,184,92,184,93,180,90,178,90,169,87,141,87,139,85,122,85,119,84,110,93,109,92,107,85,103,83,101,76,97,74,95,71,94,71,101,47,102,47,122,44,124,41,124,38,126,38,139,8,140,9,142,13,145,14,152,13,156,15,159,15,167,12,174,12,176,19,176,27,175,31,179,34,179,37,184,42,189" /> |
<area shape="poly" title="Soudan (0 inscrit)" class="zone-sd" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=sd" coords="377,274,385,273,392,267,402,267,402,264,397,261,394,256,394,254,392,252,389,250,386,246,384,246,381,244,381,242,383,239,386,239,389,237,389,224,391,222,392,220,395,219,395,216,398,211,400,209,405,203,405,200,406,189,409,179,409,177,410,173,413,172,415,170,420,168,421,165,414,160,412,157,412,142,410,140,409,135,404,130,401,128,399,128,396,129,395,132,392,133,390,135,389,137,384,137,322,136,322,150,315,151,315,183,313,185,307,185,307,187,303,192,300,205,303,207,303,211,307,218,307,221,311,226,312,233,311,235,314,236,317,239,320,239,324,242,324,245,331,250,333,252,333,254,334,256,339,259,342,264,344,266,345,268,354,268,357,267,360,270,365,274,373,273" /> |
<area shape="poly" title="Burundi (1 inscrit)" class="zone-bi" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=bi" coords="361,331,364,326,364,324,362,323,362,321,360,321,359,323,355,324,355,329,354,335,359,333" /> |
<area shape="poly" title="Burundi (3 inscrits)" class="zone-bi" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=bi" coords="361,331,364,326,364,324,362,323,362,321,360,321,359,323,355,324,355,329,354,335,359,333" /> |
<area shape="poly" title="Zambie (0 inscrit)" class="zone-zm" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=zm" coords="335,437,340,430,342,428,345,426,348,426,348,422,355,419,359,419,359,415,362,413,364,413,371,410,373,410,378,408,380,399,383,395,383,384,385,382,385,380,378,372,376,372,373,371,370,368,368,368,366,369,361,365,359,365,354,366,352,369,352,381,350,388,350,391,352,393,357,393,358,401,351,402,345,397,344,395,342,395,338,392,329,392,324,389,323,387,317,387,316,385,315,399,300,400,300,426,302,429,308,434,320,433,323,436,326,436" /> |
<area shape="poly" title="Gambie (1 inscrit)" class="zone-gm" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=gm" coords="15,202,22,200,20,199,18,201,11,201" /> |
<area shape="poly" title="Algérie (396 inscrits)" class="zone-dz" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=dz" coords="149,147,151,147,153,149,155,149,158,150,159,157,161,157,171,154,173,154,178,152,181,149,194,139,201,135,203,133,212,128,215,125,218,124,220,122,220,120,216,115,210,114,208,112,208,110,207,107,205,105,203,102,203,99,206,96,206,81,205,74,203,72,202,66,203,60,202,54,201,51,196,48,195,44,192,41,190,40,189,32,191,30,195,27,195,25,196,7,191,7,188,6,185,7,182,6,179,8,177,8,173,9,170,7,164,7,158,8,155,10,147,10,138,14,135,17,131,17,125,22,122,23,122,29,123,39,124,42,127,45,126,49,114,50,112,53,110,53,107,54,107,57,108,60,99,64,94,69,90,69,86,70,85,72,81,72,79,74,77,74,71,79,71,91,78,95,80,97,87,101,90,104,97,108,99,110,106,114,109,117,116,121,118,123,143,140,144,143" /> |
<area shape="poly" title="Algérie (980 inscrits)" class="zone-dz" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=dz" coords="149,147,151,147,153,149,155,149,158,150,159,157,161,157,171,154,173,154,178,152,181,149,194,139,201,135,203,133,212,128,215,125,218,124,220,122,220,120,216,115,210,114,208,112,208,110,207,107,205,105,203,102,203,99,206,96,206,81,205,74,203,72,202,66,203,60,202,54,201,51,196,48,195,44,192,41,190,40,189,32,191,30,195,27,195,25,196,7,191,7,188,6,185,7,182,6,179,8,177,8,173,9,170,7,164,7,158,8,155,10,147,10,138,14,135,17,131,17,125,22,122,23,122,29,123,39,124,42,127,45,126,49,114,50,112,53,110,53,107,54,107,57,108,60,99,64,94,69,90,69,86,70,85,72,81,72,79,74,77,74,71,79,71,91,78,95,80,97,87,101,90,104,97,108,99,110,106,114,109,117,116,121,118,123,143,140,144,143" /> |
<area shape="poly" title="Djibouti (1 inscrit)" class="zone-dj" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=dj" coords="456,217,454,216,454,214,457,212,457,209,455,208,451,212,451,214,449,217,449,220,452,220,455,219" /> |
<area shape="poly" title="Libéria (0 inscrit)" class="zone-lr" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=lr" coords="78,260,75,258,74,256,71,255,70,252,71,249,69,248,66,249,63,247,63,242,62,240,58,240,55,245,52,248,50,249,53,254,56,255,58,257,65,263,72,267,75,267,77,268,77,263" /> |
<area shape="poly" title="Togo (4 inscrits)" class="zone-tg" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=tg" coords="144,256,146,255,146,236,142,227,139,225,139,221,136,221,135,223,138,226,138,229,139,241,140,251" /> |
<area shape="poly" title="Togo (34 inscrits)" class="zone-tg" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=tg" coords="144,256,146,255,146,236,142,227,139,225,139,221,136,221,135,223,138,226,138,229,139,241,140,251" /> |
<area shape="poly" title="Cap Vert (1 inscrit)" class="zone-cv" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=cv" coords="58,349,58,346,56,345,56,348 66,335,65,335 46,328,45,328" /> |
<area shape="poly" title="Tanzanie (0 inscrit)" class="zone-tz" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=tz" coords="432,377,432,375,428,366,428,363,429,354,425,350,425,345,428,338,426,336,419,332,417,330,417,328,416,325,413,324,411,322,406,320,404,318,399,316,397,314,394,313,392,311,390,311,390,313,387,316,387,320,385,322,383,322,379,323,376,322,374,324,372,323,371,314,372,311,365,311,365,313,366,319,365,323,366,327,361,334,356,337,354,340,354,342,355,350,357,352,360,356,363,358,364,364,365,366,367,366,369,365,371,367,374,369,376,369,385,373,388,373,389,377,392,380,392,391,394,391,403,387,405,387,407,389,416,388,418,386,427,386,434,383,436,381" /> |
<area shape="poly" title="Guinée Bissau (0 inscrit)" class="zone-gw" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=gw" coords="23,219,23,217,25,215,30,214,30,210,31,208,20,208,14,209,13,211,16,213,20,213,21,215,20,218" /> |
<area shape="poly" title="Tanzanie (1 inscrit)" class="zone-tz" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=tz" coords="432,377,432,375,428,366,428,363,429,354,425,350,425,345,428,338,426,336,419,332,417,330,417,328,416,325,413,324,411,322,406,320,404,318,399,316,397,314,394,313,392,311,390,311,390,313,387,316,387,320,385,322,383,322,379,323,376,322,374,324,372,323,371,314,372,311,365,311,365,313,366,319,365,323,366,327,361,334,356,337,354,340,354,342,355,350,357,352,360,356,363,358,364,364,365,366,367,366,369,365,371,367,374,369,376,369,385,373,388,373,389,377,392,380,392,391,394,391,403,387,405,387,407,389,416,388,418,386,427,386,434,383,436,381" /> |
<area shape="poly" title="Guinée Bissau (1 inscrit)" class="zone-gw" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=gw" coords="23,219,23,217,25,215,30,214,30,210,31,208,20,208,14,209,13,211,16,213,20,213,21,215,20,218" /> |
<area shape="poly" title="Mozambique (0 inscrit)" class="zone-mz" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=mz" coords="372,472,372,479,374,488,374,500,375,507,379,508,379,506,377,504,377,501,379,500,381,497,390,493,392,493,398,488,398,485,397,483,399,476,399,473,397,471,397,469,395,462,393,460,393,454,398,449,402,446,403,444,405,444,407,442,407,440,409,439,411,436,420,431,423,431,428,427,430,426,436,419,436,415,437,410,436,395,435,390,438,385,438,383,437,383,433,386,431,386,428,388,419,388,417,390,410,390,406,391,401,390,392,394,391,396,394,399,397,404,400,407,404,412,404,422,401,425,399,426,399,429,396,430,391,425,390,421,392,418,392,413,385,412,382,409,363,415,361,416,361,418,362,422,370,422,379,426,381,428,381,430,382,442,380,447,381,456,378,461,378,463,376,466,376,468" /> |
<area shape="poly" title="Zimbabwe (0 inscrit)" class="zone-zw" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=zw" coords="349,467,352,469,356,469,361,471,367,471,370,472,373,468,379,455,379,451,378,445,380,440,380,433,379,429,377,427,373,426,370,424,362,424,359,421,355,421,352,423,350,423,350,427,346,428,344,430,340,433,337,437,336,439,326,439,324,438,327,442,330,449,333,452,336,453,339,456,343,459,343,463,344,466" /> |
<area shape="poly" title="Guinée équatoriale (0 inscrit)" class="zone-gq" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=gq" coords="217,293,217,287,208,287,206,292" /> |
<area shape="poly" title="République Démocratique du Congo (20 inscrits)" class="zone-cd" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=cd" coords="317,383,318,385,323,385,326,388,331,390,333,390,337,389,339,391,343,392,346,394,350,399,356,400,356,395,351,395,347,391,347,388,350,378,350,368,353,364,356,364,361,363,361,359,359,357,355,354,353,349,353,344,352,329,353,325,351,322,351,319,356,310,356,303,357,299,359,297,362,293,362,290,366,287,366,285,364,283,364,278,365,276,358,270,349,270,346,271,343,269,340,265,332,265,330,264,319,266,315,266,312,268,305,268,303,271,294,271,288,270,286,268,284,265,280,265,276,269,276,274,274,276,274,281,270,288,270,293,268,304,268,307,264,311,260,314,257,319,257,321,256,327,255,330,249,336,244,339,241,339,240,336,237,337,235,339,230,339,229,346,231,346,257,345,260,348,260,351,263,358,266,361,277,361,280,354,290,353,291,355,296,355,298,357,298,362,299,376,300,385,303,383" /> |
<area shape="poly" title="République Démocratique du Congo (54 inscrits)" class="zone-cd" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=cd" coords="317,383,318,385,323,385,326,388,331,390,333,390,337,389,339,391,343,392,346,394,350,399,356,400,356,395,351,395,347,391,347,388,350,378,350,368,353,364,356,364,361,363,361,359,359,357,355,354,353,349,353,344,352,329,353,325,351,322,351,319,356,310,356,303,357,299,359,297,362,293,362,290,366,287,366,285,364,283,364,278,365,276,358,270,349,270,346,271,343,269,340,265,332,265,330,264,319,266,315,266,312,268,305,268,303,271,294,271,288,270,286,268,284,265,280,265,276,269,276,274,274,276,274,281,270,288,270,293,268,304,268,307,264,311,260,314,257,319,257,321,256,327,255,330,249,336,244,339,241,339,240,336,237,337,235,339,230,339,229,346,231,346,257,345,260,348,260,351,263,358,266,361,277,361,280,354,290,353,291,355,296,355,298,357,298,362,299,376,300,385,303,383" /> |
<area shape="poly" title="Somalie (0 inscrit)" class="zone-so" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=so" coords="443,281,443,309,445,312,447,312,456,301,462,295,470,288,477,285,480,282,483,278,491,271,492,268,494,266,500,259,500,257,503,250,505,248,506,243,510,239,513,234,513,230,514,226,516,225,516,215,513,214,512,216,508,217,513,214,510,217,508,217,499,219,497,219,490,220,483,223,476,223,471,226,466,226,459,219,456,221,456,224,458,226,465,234,467,234,476,238,478,238,485,241,494,241,495,243,472,266,463,266,458,269,456,271,454,271,451,272,448,275" /> |
<area shape="poly" title="Tchad (5 inscrits)" class="zone-td" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=td" coords="257,243,259,243,262,244,267,241,273,241,276,238,276,235,285,233,287,233,294,226,296,225,296,222,298,220,303,219,304,217,301,212,301,208,298,208,297,204,298,199,300,196,300,193,302,191,305,186,305,184,311,183,313,182,313,155,262,129,260,127,255,125,252,125,249,126,248,139,249,142,251,144,254,146,254,149,252,154,252,158,250,173,250,175,244,181,238,188,237,192,235,193,236,198,240,202,243,204,245,207,245,209,246,220,249,224,249,228,241,229,241,232,242,234,244,234,247,237,249,244,250,246,255,245" /> |
<area shape="poly" title="Tchad (12 inscrits)" class="zone-td" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=td" coords="257,243,259,243,262,244,267,241,273,241,276,238,276,235,285,233,287,233,294,226,296,225,296,222,298,220,303,219,304,217,301,212,301,208,298,208,297,204,298,199,300,196,300,193,302,191,305,186,305,184,311,183,313,182,313,155,262,129,260,127,255,125,252,125,249,126,248,139,249,142,251,144,254,146,254,149,252,154,252,158,250,173,250,175,244,181,238,188,237,192,235,193,236,198,240,202,243,204,245,207,245,209,246,220,249,224,249,228,241,229,241,232,242,234,244,234,247,237,249,244,250,246,255,245" /> |
<area shape="poly" title="Libye (0 inscrit)" class="zone-ly" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ly" coords="317,67,319,65,319,62,318,56,319,52,315,52,306,50,305,46,298,44,294,44,290,45,286,49,284,50,284,52,283,54,285,59,282,64,279,66,273,66,270,63,263,60,260,60,255,59,252,58,248,54,247,49,238,45,235,45,224,44,220,43,220,47,217,50,210,56,210,58,211,62,208,65,205,66,204,69,207,73,207,80,208,96,205,100,209,107,209,109,210,112,214,112,219,115,222,120,238,121,245,125,247,125,252,123,256,123,313,152,313,150,320,149,320,76,318,74,318,71" /> |
<area shape="poly" title="Erythrée (0 inscrit)" class="zone-er" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=er" coords="451,208,454,207,453,205,450,203,447,199,445,198,441,193,439,193,437,191,435,191,433,189,433,187,431,187,428,185,426,180,426,178,424,171,423,169,416,172,415,174,422,169,413,174,411,179,411,181,408,191,408,194,411,194,413,193,415,194,416,191,419,190,422,193,424,193,430,192,436,193,438,195,442,198,443,200,448,204" /> |
<area shape="poly" title="Madagascar (27 inscrits)" class="zone-mg" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=mg" coords="462,479,462,481,463,484,462,486,463,490,468,495,471,497,474,497,477,495,480,495,485,493,489,484,489,481,493,468,493,466,501,441,501,436,504,429,504,421,506,420,508,421,508,405,504,398,502,397,501,399,497,401,498,406,494,409,492,409,492,412,491,416,487,417,487,419,482,422,482,425,479,426,476,425,474,427,468,427,467,431,464,436,465,443,464,445,467,449,468,453,465,456,465,459,464,463,460,468,459,475" /> |
<area shape="poly" title="Maroc (180 inscrits)" class="zone-ma" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ma" coords="38,123,43,122,45,121,45,101,69,100,69,78,74,73,78,72,80,70,84,70,86,68,89,68,93,67,99,61,101,61,105,58,105,53,110,51,113,48,124,48,125,45,123,44,121,39,121,31,120,26,117,24,115,24,112,22,110,22,100,23,98,21,96,20,94,17,92,19,93,17,91,19,91,21,86,32,84,34,80,37,73,40,68,45,67,50,64,53,62,58,62,63,63,68,59,75,56,78,51,81,48,84,38,87,38,89,36,91,35,95,33,97,30,98,28,100,25,110,23,112,16,122,15,127,12,132,10,133,10,135,9,138,36,138,36,126" /> |
<area shape="poly" title="Madagascar (76 inscrits)" class="zone-mg" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=mg" coords="462,479,462,481,463,484,462,486,463,490,468,495,471,497,474,497,477,495,480,495,485,493,489,484,489,481,493,468,493,466,501,441,501,436,504,429,504,421,506,420,508,421,508,405,504,398,502,397,501,399,497,401,498,406,494,409,492,409,492,412,491,416,487,417,487,419,482,422,482,425,479,426,476,425,474,427,468,427,467,431,464,436,465,443,464,445,467,449,468,453,465,456,465,459,464,463,460,468,459,475" /> |
<area shape="poly" title="Maroc (351 inscrits)" class="zone-ma" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ma" coords="38,123,43,122,45,121,45,101,69,100,69,78,74,73,78,72,80,70,84,70,86,68,89,68,93,67,99,61,101,61,105,58,105,53,110,51,113,48,124,48,125,45,123,44,121,39,121,31,120,26,117,24,115,24,112,22,110,22,100,23,98,21,96,20,94,17,92,19,93,17,91,19,91,21,86,32,84,34,80,37,73,40,68,45,67,50,64,53,62,58,62,63,63,68,59,75,56,78,51,81,48,84,38,87,38,89,36,91,35,95,33,97,30,98,28,100,25,110,23,112,16,122,15,127,12,132,10,133,10,135,9,138,36,138,36,126" /> |
<area shape="poly" title="Sao Tomé et Principe (1 inscrit)" class="zone-st" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=st" coords="182,299,182,296,181,296,180,300" /> |
<area shape="poly" title="Tunisie (65 inscrits)" class="zone-tn" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=tn" coords="214,49,218,46,218,41,214,38,210,37,207,35,207,32,209,31,213,26,215,25,216,19,213,17,212,11,215,8,211,8,210,5,204,4,198,9,198,25,197,28,195,30,191,33,191,37,192,39,196,42,197,46,202,49,204,56,204,59,205,64,208,62,208,55" /> |
<area shape="poly" title="République Centrafricaine (3 inscrits)" class="zone-cf" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=cf" coords="288,267,292,267,295,269,302,269,305,265,307,265,311,266,316,264,322,264,331,262,339,263,336,259,333,258,331,255,331,253,328,250,322,245,322,243,319,241,316,241,313,238,311,238,309,236,309,232,310,229,305,222,301,221,298,223,298,226,290,233,287,235,284,235,278,236,278,239,274,243,267,243,265,245,256,246,253,248,250,248,244,259,244,266,249,275,253,279,255,279,259,275,266,274,271,275,274,273,274,269,278,265,279,263,285,263" /> |
<area shape="poly" title="Tunisie (181 inscrits)" class="zone-tn" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=tn" coords="214,49,218,46,218,41,214,38,210,37,207,35,207,32,209,31,213,26,215,25,216,19,213,17,212,11,215,8,211,8,210,5,204,4,198,9,198,25,197,28,195,30,191,33,191,37,192,39,196,42,197,46,202,49,204,56,204,59,205,64,208,62,208,55" /> |
<area shape="poly" title="République Centrafricaine (4 inscrits)" class="zone-cf" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=cf" coords="288,267,292,267,295,269,302,269,305,265,307,265,311,266,316,264,322,264,331,262,339,263,336,259,333,258,331,255,331,253,328,250,322,245,322,243,319,241,316,241,313,238,311,238,309,236,309,232,310,229,305,222,301,221,298,223,298,226,290,233,287,235,284,235,278,236,278,239,274,243,267,243,265,245,256,246,253,248,250,248,244,259,244,266,249,275,253,279,255,279,259,275,266,274,271,275,274,273,274,269,278,265,279,263,285,263" /> |
<area shape="poly" title="Nigéria (0 inscrit)" class="zone-ng" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ng" coords="219,253,224,242,224,240,229,235,229,232,231,225,233,222,233,220,237,216,240,215,241,211,239,209,239,204,235,200,233,200,231,202,229,202,227,204,224,204,211,203,209,205,206,207,200,207,193,203,191,203,188,206,186,206,183,203,178,200,170,200,167,201,165,204,165,206,162,209,162,218,163,224,162,228,159,231,159,233,156,240,156,254,167,254,172,257,176,264,176,266,177,268,184,269,187,267,189,267,194,268,196,265,198,264,198,262,199,258,201,256,204,252,205,250,214,250,217,253" /> |
<area shape="poly" title="Niger (4 inscrits)" class="zone-ne" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ne" coords="165,200,170,198,178,198,183,201,185,203,188,203,191,201,194,201,198,204,200,204,205,205,209,202,224,201,226,202,233,197,234,196,233,192,235,191,235,189,238,186,245,178,248,174,248,166,249,157,250,152,252,147,250,145,248,144,246,139,246,127,243,127,240,124,222,123,220,125,213,129,211,131,204,135,202,137,195,141,193,143,180,153,177,155,175,155,168,157,166,158,166,182,162,185,161,187,144,187,143,189,137,190,136,193,139,198,143,202,146,206,150,206,151,211,153,211,153,209,155,208,159,211,160,208,163,205,163,203" /> |
<area shape="poly" title="Maurice (3 inscrits)" class="zone-mu" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=mu" coords="557,460,557,456,556,456,555,460 594,455,593,455" /> |
<area shape="poly" title="Cameroun (29 inscrits)" class="zone-cm" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=cm" coords="229,284,246,285,250,286,252,288,253,282,247,276,246,273,244,271,242,266,242,257,244,255,248,246,246,241,246,239,245,237,242,236,239,233,238,229,240,227,247,227,247,225,244,221,244,211,243,208,241,207,243,210,243,215,236,220,232,229,232,232,231,236,226,241,226,243,220,254,216,255,213,252,206,252,202,257,201,263,199,265,199,267,201,268,202,271,206,272,207,275,209,277,209,282,208,285,219,285" /> |
<area shape="poly" title="Bénin (24 inscrits)" class="zone-bj" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=bj" coords="152,255,154,254,154,238,156,235,156,233,157,230,160,228,160,225,161,220,160,215,156,211,152,215,155,211,151,215,150,217,145,217,142,220,141,224,144,226,146,229,146,231,148,236,148,253,149,255" /> |
<area shape="poly" title="Niger (21 inscrits)" class="zone-ne" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ne" coords="165,200,170,198,178,198,183,201,185,203,188,203,191,201,194,201,198,204,200,204,205,205,209,202,224,201,226,202,233,197,234,196,233,192,235,191,235,189,238,186,245,178,248,174,248,166,249,157,250,152,252,147,250,145,248,144,246,139,246,127,243,127,240,124,222,123,220,125,213,129,211,131,204,135,202,137,195,141,193,143,180,153,177,155,175,155,168,157,166,158,166,182,162,185,161,187,144,187,143,189,137,190,136,193,139,198,143,202,146,206,150,206,151,211,153,211,153,209,155,208,159,211,160,208,163,205,163,203" /> |
<area shape="poly" title="Maurice (10 inscrits)" class="zone-mu" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=mu" coords="557,460,557,456,556,456,555,460 594,455,593,455" /> |
<area shape="poly" title="Cameroun (87 inscrits)" class="zone-cm" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=cm" coords="229,284,246,285,250,286,252,288,253,282,247,276,246,273,244,271,242,266,242,257,244,255,248,246,246,241,246,239,245,237,242,236,239,233,238,229,240,227,247,227,247,225,244,221,244,211,243,208,241,207,243,210,243,215,236,220,232,229,232,232,231,236,226,241,226,243,220,254,216,255,213,252,206,252,202,257,201,263,199,265,199,267,201,268,202,271,206,272,207,275,209,277,209,282,208,285,219,285" /> |
<area shape="poly" title="Bénin (66 inscrits)" class="zone-bj" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=bj" coords="152,255,154,254,154,238,156,235,156,233,157,230,160,228,160,225,161,220,160,215,156,211,152,215,155,211,151,215,150,217,145,217,142,220,141,224,144,226,146,229,146,231,148,236,148,253,149,255" /> |
<area shape="poly" title="Seychelles (1 inscrit)" class="zone-sc" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=sc" coords="572,342,572,340,570,340,569,342" /> |
<area shape="poly" title="Kenya (0 inscrit)" class="zone-ke" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ke" coords="426,334,430,335,434,328,434,326,437,321,440,319,442,316,444,315,443,312,441,310,441,281,444,278,446,275,441,272,438,272,435,273,432,276,423,277,419,276,406,269,393,269,392,272,394,279,398,282,398,290,394,295,390,302,392,304,392,307,391,309,398,312,400,314,403,315,405,317,410,319,412,321,415,322,418,325,419,329,421,331,424,332" /> |
<area shape="poly" title="Sénégal (15 inscrits)" class="zone-sn" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=sn" coords="10,204,10,208,12,208,25,206,36,206,41,208,48,208,48,204,44,201,44,196,43,191,41,191,34,184,33,181,30,181,26,177,21,177,11,178,11,185,7,190,7,193,9,195,10,198,17,199,19,197,22,197,31,199,33,200,33,202,25,203,20,202,15,204" /> |
<area shape="poly" title="Sénégal (55 inscrits)" class="zone-sn" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=sn" coords="10,204,10,208,12,208,25,206,36,206,41,208,48,208,48,204,44,201,44,196,43,191,41,191,34,184,33,181,30,181,26,177,21,177,11,178,11,185,7,190,7,193,9,195,10,198,17,199,19,197,22,197,31,199,33,200,33,202,25,203,20,202,15,204" /> |
<area shape="poly" title="Namibie (0 inscrit)" class="zone-na" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=na" coords="282,470,284,468,289,468,289,442,292,440,296,440,305,438,309,438,310,440,312,440,314,438,318,437,319,435,312,435,307,436,302,438,300,438,289,439,276,438,271,434,237,434,234,431,229,431,224,432,222,434,222,436,223,440,230,450,239,469,241,471,243,482,243,488,245,493,245,498,249,515,251,517,256,523,258,523,260,521,262,521,266,524,267,527,276,527,278,525,281,524" /> |
<area shape="poly" title="Guinée (2 inscrits)" class="zone-gn" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=gn" coords="72,245,73,242,72,239,75,238,75,235,72,231,72,227,73,225,71,223,71,220,70,217,67,215,67,212,66,210,61,212,57,212,54,213,49,212,48,210,40,210,33,208,33,214,31,216,28,216,25,218,25,221,27,223,28,226,32,229,35,233,37,233,39,231,40,228,51,227,54,230,56,235,56,238,62,238,65,241,65,246,67,247,69,245" /> |
<area shape="poly" title="Angola (2 inscrits)" class="zone-ao" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ao" coords="226,343,227,340,226,340" /> |
<area shape="poly" title="Mali (10 inscrits)" class="zone-ml" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ml" coords="83,224,85,221,88,221,89,223,94,223,94,219,97,214,102,209,102,207,105,202,110,201,117,198,120,195,125,191,128,189,136,189,141,188,144,185,160,185,164,180,164,158,158,159,157,152,155,152,151,149,148,149,144,145,141,143,141,141,113,122,111,120,104,116,102,114,98,111,86,111,86,118,87,129,89,146,89,148,92,176,93,178,95,179,95,183,93,186,59,186,55,189,53,189,51,187,51,185,49,184,48,188,45,191,45,194,46,200,50,203,50,210,53,210,55,211,61,210,64,208,67,208,69,211,69,213,72,216,72,218,73,223,76,224,78,223" /> |
<area shape="poly" title="Ghana (0 inscrit)" class="zone-gh" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=gh" coords="120,266,125,263,128,263,135,259,141,259,142,257,139,254,137,231,136,227,133,224,133,221,114,221,114,224,116,235,116,237,117,241,115,243,114,248,112,250,112,256,115,260,115,265,117,265" /> |
<area shape="poly" title="Afrique du Sud (3 inscrits)" class="zone-za" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=za" coords="284,577,286,575,295,575,300,571,305,571,308,572,314,571,320,572,325,571,326,569,332,569,337,567,341,563,346,559,348,558,355,549,360,544,361,541,363,539,364,536,366,534,367,531,376,522,376,519,378,512,378,510,375,510,371,514,367,513,365,511,364,507,366,502,369,499,372,500,372,487,370,478,369,475,366,473,359,473,353,472,351,474,346,476,343,479,339,482,335,487,334,489,328,494,326,499,321,501,317,501,314,499,309,499,305,503,300,509,289,510,288,504,289,500,285,496,284,524,277,529,267,529,264,526,262,523,259,525,259,527,265,540,265,542,268,546,271,553,271,555,272,559,269,563,273,570,273,572,275,572,276,574,278,574,280,577" /> |
<area shape="poly" title="Guinée (13 inscrits)" class="zone-gn" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=gn" coords="72,245,73,242,72,239,75,238,75,235,72,231,72,227,73,225,71,223,71,220,70,217,67,215,67,212,66,210,61,212,57,212,54,213,49,212,48,210,40,210,33,208,33,214,31,216,28,216,25,218,25,221,27,223,28,226,32,229,35,233,37,233,39,231,40,228,51,227,54,230,56,235,56,238,62,238,65,241,65,246,67,247,69,245" /> |
<area shape="poly" title="Angola (4 inscrits)" class="zone-ao" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ao" coords="226,343,227,340,226,340" /> |
<area shape="poly" title="Mali (18 inscrits)" class="zone-ml" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=ml" coords="83,224,85,221,88,221,89,223,94,223,94,219,97,214,102,209,102,207,105,202,110,201,117,198,120,195,125,191,128,189,136,189,141,188,144,185,160,185,164,180,164,158,158,159,157,152,155,152,151,149,148,149,144,145,141,143,141,141,113,122,111,120,104,116,102,114,98,111,86,111,86,118,87,129,89,146,89,148,92,176,93,178,95,179,95,183,93,186,59,186,55,189,53,189,51,187,51,185,49,184,48,188,45,191,45,194,46,200,50,203,50,210,53,210,55,211,61,210,64,208,67,208,69,211,69,213,72,216,72,218,73,223,76,224,78,223" /> |
<area shape="poly" title="Ghana (1 inscrit)" class="zone-gh" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=gh" coords="120,266,125,263,128,263,135,259,141,259,142,257,139,254,137,231,136,227,133,224,133,221,114,221,114,224,116,235,116,237,117,241,115,243,114,248,112,250,112,256,115,260,115,265,117,265" /> |
<area shape="poly" title="Afrique du Sud (21 inscrits)" class="zone-za" href="?id_annuaire=1&continent=1&m=annuaire_inscrits_carto&pays=za" coords="284,577,286,575,295,575,300,571,305,571,308,572,314,571,320,572,325,571,326,569,332,569,337,567,341,563,346,559,348,558,355,549,360,544,361,541,363,539,364,536,366,534,367,531,376,522,376,519,378,512,378,510,375,510,371,514,367,513,365,511,364,507,366,502,369,499,372,500,372,487,370,478,369,475,366,473,359,473,353,472,351,474,346,476,343,479,339,482,335,487,334,489,328,494,326,499,321,501,317,501,314,499,309,499,305,503,300,509,289,510,288,504,289,500,285,496,284,524,277,529,267,529,264,526,262,523,259,525,259,527,265,540,265,542,268,546,271,553,271,555,272,559,269,563,273,570,273,572,275,572,276,574,278,574,280,577" /> |
</map> |
</div> |
/trunk/cartes/pays_afrique.png |
---|
Cannot display: file marked as a binary type. |
svn:mime-type = image/png |
/trunk/cartes |
---|
Property changes: |
Added: svn:ignore |
+continents.html |
+continents.png |
+pays_nord_amerique.html |
+pays_sud_amerique.html |
+pays_asie.html |
+pays_sud_amerique.png |
+pays_asie.png |
+pays_nord_amerique.png |
+pays_afrique.png |
+pays_oceanie.png |
+pays_europe.png |
+pays_moyen_orient.png |
+france.png |
+pays_oceanie.html |
+pays_europe.html |
+france.html |
+pays_afrique.html |
+pays_moyen_orient.html |
/trunk/composants/cartographie/Cartographie.php |
---|
330,13 → 330,13 |
} |
// Nous chercons à créer une image indéxées en sortie |
if (imageistruecolor(&$this->carte) && $this->formule_coloriage != 'legende') { |
if (imageistruecolor($this->carte) && $this->formule_coloriage != 'legende') { |
if ($this->coloriage_couleurs <= 253) { |
//imagetruecolortopalette(&$this->carte, false, ($this->coloriage_couleurs + 2));// + 2 car noir et blanc réservés. |
} else { |
// On force la création d'une palette... si cela pose problème ajouter un attribut permettant de désactiver |
// ce fonctionnement. |
imagetruecolortopalette(&$this->carte, false, 255); |
imagetruecolortopalette($this->carte, false, 255); |
} |
} |
353,7 → 353,7 |
unlink($fichier_image_carte); |
} |
imagepng(&$this->carte, $this->getCarteFichier()); |
imagepng($this->carte, $this->getCarteFichier()); |
return true; |
} |
505,6 → 505,11 |
// Nous attribuons les couleurs à chaque zone géographique |
foreach ($this->getCarteZones() as $cle => $zg) { |
if ($this->getModeDebug() && !isset($zg['rvb_fond'])) { |
$e = "La zone ".print_r($zg, true).") ne possède pas de clé 'rvb_fond'."; |
trigger_error($e, E_USER_WARNING); |
continue; |
} |
if (isset($this->coloriage_tableau_frequence[$zg['info_nombre']])) { |
$this->carte_correspondance_couleurs[$zg['rvb_fond']] = $this->coloriage_tableau_frequence[$zg['info_nombre']]; |
} else { |
540,7 → 545,7 |
} |
private function colorierCarte() { |
if (imageistruecolor(&$this->carte)) { |
if (imageistruecolor($this->carte)) { |
//+--------------------------------------------------------------------------------------------------------+ |
// Remplacement des couleurs sur la carte en mode vraies couleurs (RGB) |
$this->colorierCarteModeVraiCouleur(); |
553,14 → 558,14 |
private function colorierCarteModeVraiCouleur() { |
// Nous commençons le rempalcement des couleurs sur la carte de fond. |
$hauteur = imagesy(&$this->carte); |
$largeur = imagesx(&$this->carte); |
$hauteur = imagesy($this->carte); |
$largeur = imagesx($this->carte); |
// Tableau contenant les couleurs traitées, pour éviter de traiter plusieurs fois la même couleur |
$tab_rvb_ok = array(); |
for ($x = 0; $x < $largeur; $x++) { |
for ($y = 0; $y < $hauteur; $y++) { |
$rvb = ImageColorAt(&$this->carte, $x, $y); |
$rvb = ImageColorAt($this->carte, $x, $y); |
if (!isset($tab_rvb_ok[$rvb])) { |
// Récupération de la couleur rvb au format xxx-xxx-xxx |
$cle = (($rvb >> 16) & 0xFF).'-'.(($rvb >> 8) & 0xFF).'-'.($rvb & 0xFF); |
575,10 → 580,10 |
$rvb_final = $rouge<<16 | $vert<<8 | $bleu; |
} |
// Si le nombre de couleurs sur la carte finale est infèrieur à 255 nous créons une image indexée |
imagefill(&$this->carte, $x, $y, $rvb_final); |
imagefill($this->carte, $x, $y, $rvb_final); |
} else { |
$rvb_final = '128'<<16 | '128'<<8 | '128'; |
imagefill(&$this->carte, $x, $y, $rvb_final); |
imagefill($this->carte, $x, $y, $rvb_final); |
} |
// Nous ajoutons la couleur ajoutée à la carte dans le tableau des couleurs traitées |
$tab_rvb_ok[$rvb_final] = true; |
607,7 → 612,7 |
list($rouge, $vert, $bleu) = explode('-', $this->carte_correspondance_couleurs[$zg['rvb_fond']]); |
} |
if (isset($zg['index'])) { |
imagecolorset(&$this->carte, $zg['index'], $rouge, $vert, $bleu); |
imagecolorset($this->carte, $zg['index'], $rouge, $vert, $bleu); |
} else if ($this->getModeDebug()) { |
$e = "La zone '{$zg['nom']}' n'est pas présente sur la carte."; |
trigger_error($e, E_USER_WARNING); |
Property changes: |
Added: svnkit:entry:sha1-checksum |
+1b417d218f6840ed04efac7db592772c62f0020d |
\ No newline at end of property |
/trunk/jrest/services/InformationsUtilisateur.php |
---|
File deleted |
\ No newline at end of file |
/trunk/jrest/bibliotheque/JRestService.php |
---|
129,22 → 129,76 |
exit(0); |
} |
protected function envoyerMessageErreur($msg, $code) { |
$textHttp = $this->getCodeHttpText($code); |
header("HTTP/1.0 $code $textHttp"); |
header("Content-Type: text/plain; charset=utf-8"); |
die($msg); |
} |
private function getCodeHttpText($code) { |
$text = ''; |
switch ($code) { |
case 100: $text = 'Continue'; break; |
case 101: $text = 'Switching Protocols'; break; |
case 200: $text = 'OK'; break; |
case 201: $text = 'Created'; break; |
case 202: $text = 'Accepted'; break; |
case 203: $text = 'Non-Authoritative Information'; break; |
case 204: $text = 'No Content'; break; |
case 205: $text = 'Reset Content'; break; |
case 206: $text = 'Partial Content'; break; |
case 300: $text = 'Multiple Choices'; break; |
case 301: $text = 'Moved Permanently'; break; |
case 302: $text = 'Moved Temporarily'; break; |
case 303: $text = 'See Other'; break; |
case 304: $text = 'Not Modified'; break; |
case 305: $text = 'Use Proxy'; break; |
case 400: $text = 'Bad Request'; break; |
case 401: $text = 'Unauthorized'; break; |
case 402: $text = 'Payment Required'; break; |
case 403: $text = 'Forbidden'; break; |
case 404: $text = 'Not Found'; break; |
case 405: $text = 'Method Not Allowed'; break; |
case 406: $text = 'Not Acceptable'; break; |
case 407: $text = 'Proxy Authentication Required'; break; |
case 408: $text = 'Request Time-out'; break; |
case 409: $text = 'Conflict'; break; |
case 410: $text = 'Gone'; break; |
case 411: $text = 'Length Required'; break; |
case 412: $text = 'Precondition Failed'; break; |
case 413: $text = 'Request Entity Too Large'; break; |
case 414: $text = 'Request-URI Too Large'; break; |
case 415: $text = 'Unsupported Media Type'; break; |
case 500: $text = 'Internal Server Error'; break; |
case 501: $text = 'Not Implemented'; break; |
case 502: $text = 'Bad Gateway'; break; |
case 503: $text = 'Service Unavailable'; break; |
case 504: $text = 'Gateway Time-out'; break; |
case 505: $text = 'HTTP Version not supported'; break; |
default: |
exit('Unknown http status code "' . htmlentities($code) . '"'); |
break; |
} |
return $text; |
} |
//+----------------------------------------------------------------------------------------------------------------+ |
// GESTION de la BASE de DONNÉES |
private function connecterPDO($config, $base = 'database') { |
$cfg = $config[$base]; |
// ATTENTION : la connexin à la bdd peut échouer si l'host vaut localhost. Utiliser 127.0.0.1 à la place. |
// ATTENTION : la connexin à la bdd peut échouer si l'host vaut localhost. Utiliser 127.0.0.1 à la place. |
$dsn = $cfg['phptype'].':dbname='.$cfg['database'].';host='.$cfg['hostspec']; |
try { |
// Création de la connexion en UTF-8 à la BDD |
// Création de la connexion en UTF-8 à la BDD |
$PDO = new PDO($dsn, $cfg['username'], $cfg['password'], array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'")); |
} catch (PDOException $e) { |
echo 'La connexion à la base de donnée via PDO a échouée : ' .$dsn. $e->getMessage(); |
echo 'La connexion à la base de donnée via PDO a échouée : ' .$dsn. $e->getMessage(); |
} |
// Affiche les erreurs détectées par PDO (sinon mode silencieux => aucune erreur affiché) |
$PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); |
return $PDO; |
return $PDO; |
} |
protected function getTxt($id) { |
201,6 → 255,21 |
//+----------------------------------------------------------------------------------------------------------------+ |
// GESTION DE L'IDENTIFICATION |
public function controlerIpAutorisees() { |
$ipsAutorisees = $this->config['jrest_admin']['ip_autorisees']; |
$remoteIp = filter_input(INPUT_SERVER, 'REMOTE_ADDR', FILTER_VALIDATE_IP); |
$serverIp = filter_input(INPUT_SERVER, 'SERVER_ADDR', FILTER_VALIDATE_IP); |
if (in_array($remoteIp, $ipsAutorisees) == false) { |
if ($remoteIp != $serverIp) {// ATTENTION : maintenir ce test à l'intérieur du précédent |
$message = "Accès interdit. \n". |
"Vous n'êtes pas autorisé à accéder à ce service depuis '$remoteIp' !\n"; |
$this->envoyerMessageErreur($message, 401); |
} |
} |
return true; |
} |
protected function getIdentification(&$params) { |
// Initialisation des variables |
$utilisateur = array(0, session_id()); |
/trunk/modeles/AnnuaireModele.php |
---|
4,8 → 4,6 |
* Modèle d'accès à la base de données des listes |
* d'ontologies |
* |
* PHP Version 5 |
* |
* @package Framework |
* @category Class |
* @author aurelien <aurelien@tela-botanica.org> |
12,9 → 10,6 |
* @copyright 2009 Tela-Botanica |
* @license http://www.cecill.info/licences/Licence_CeCILL_V2-fr.txt Licence CECILL |
* @license http://www.gnu.org/licenses/gpl.html Licence GNU-GPL |
* @version SVN: $$Id: ListeAdmin.php 128 2009-09-02 12:20:55Z aurelien $$ |
* @link /doc/framework/ |
* |
*/ |
class AnnuaireModele extends Modele { |
25,9 → 20,10 |
* @return array un tableau contenant des informations sur les annuaires gérés par l'application |
*/ |
public function chargerListeAnnuaire() { |
$requete = 'SELECT * '. |
'FROM annu_annuaire '. |
'ORDER BY aa_id_annuaire'; |
$requete = 'SELECT * '. |
'FROM annu_annuaire '. |
'ORDER BY aa_id_annuaire '. |
'-- '.__FILE__.':'.__LINE__; |
$resultat = $this->requeteTous($requete); |
$annuaires = array(); |
foreach ($resultat as $ligne) { |
42,10 → 38,11 |
* @param boolean $charger_liste_champs indique si l'on doit ou non charger la liste des noms des champs |
* @return array un tableau contenant des objets d'informations sur les annuaires |
*/ |
public function chargerAnnuaire($identifiant, $charger_liste_champs = true) { |
$requete = 'SELECT * '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$identifiant.' '; |
public function chargerAnnuaire($identifiant, $charger_liste_champs = true) { |
$requete = 'SELECT * '. |
'FROM annu_annuaire '. |
"WHERE aa_id_annuaire = $identifiant ". |
'-- '.__FILE__.':'.__LINE__; |
$resultat = $this->requeteTous($requete); |
$annuaire = array(); |
foreach ($resultat as $ligne) { |
52,7 → 49,7 |
$annuaire['informations'] = $ligne; |
} |
if($charger_liste_champs) { |
if ($charger_liste_champs) { |
$requete = 'DESCRIBE '.$annuaire['informations']['aa_bdd'].'.'.$annuaire['informations']['aa_table']; |
$resultat = $this->requeteTous($requete); |
foreach ($resultat as $colonne) { |
59,7 → 56,6 |
$annuaire['colonnes'][] = $colonne; |
} |
} |
return $annuaire; |
} |
75,7 → 71,8 |
"WHERE at_ce_annuaire = {$this->proteger($id_annuaire)} ". |
" AND at_action IN ('champ_id', 'champ_mail', 'champ_nom', 'champ_prenom', 'champ_pass', ". |
" 'champ_lettre','champ_pays', 'champ_code_postal', 'champ_ville', 'champ_adresse', ". |
" 'champ_adresse_comp', 'champ_date_inscription') "; |
" 'champ_adresse_comp', 'champ_date_inscription') ". |
'-- '.__FILE__.':'.__LINE__; |
$resultat_champs_mappage = $this->requeteTous($requete); |
if (!$resultat_champs_mappage) { |
trigger_error('impossible de récupérer les champs de mappage de l\'annuaire '.$id_annuaire); |
99,20 → 96,18 |
$requete = 'SELECT * '. |
'FROM annu_triples '. |
"WHERE at_ce_annuaire = {$this->proteger($id_annuaire)} ". |
" AND at_action = 'champ_obligatoire' "; |
$resultat_champs_obligatoire = $this->requeteTous($requete); |
" AND at_action = 'champ_obligatoire' ". |
'-- '.__FILE__.':'.__LINE__; |
$resultats = $this->requeteTous($requete); |
$tableau_mappage = array(); |
if (!$resultat_champs_obligatoire) { |
return $tableau_mappage; |
// TODO faire une interface de gestion des champs obligatoires |
$tableau_obligatoire = array(); |
if ($resultats) { |
foreach ($resultats as $champ) { |
// le tableau des champs obligatoires se présente sous la forme nom_champ_metadonnee => nom_champ_annuaire |
$tableau_obligatoire[$champ['at_valeur']] = $champ['at_ressource']; |
} |
} |
foreach ($resultat_champs_obligatoire as $champ) { |
// le tableau des champs obligatoires se présente sous la forme nom_champ_metadonnee => nom_champ_annuaire |
$tableau_obligatoire[$champ['at_valeur']] = $champ['at_ressource']; |
} |
// TODO faire une interface de gestion des champs obligatoires |
return $tableau_obligatoire ; |
} |
123,18 → 118,18 |
*/ |
public function obtenirChampsCartographie($id_annuaire) { |
// TODO rendre les noms de champs plus générique |
$requete_champs_carto = 'SELECT * FROM annu_triples '. |
$requete = 'SELECT * '. |
'FROM annu_triples '. |
'WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '. |
"AND at_action IN ('champ_pays', 'champ_code_postal')"; |
"AND at_action IN ('champ_pays', 'champ_code_postal') ". |
'-- '.__FILE__.':'.__LINE__; |
$resultat_champs_carto = $this->requeteTous($requete_champs_carto); |
if (!$resultat_champs_carto) { |
trigger_error('impossible de récupérer les champs cartographiques de l\'annuaire '.$id_annuaire); |
$resultats = $this->requeteTous($requete); |
if(!$resultats) { |
trigger_error("Impossible de récupérer les champs cartographiques de l'annuaire $id_annuaire."); |
} |
$tableau_carto = array(); |
foreach ($resultat_champs_carto as $champ) { |
foreach ($resultats as $champ) { |
// le tableau des champs carto se présente sous la forme type de champ => [0] nom_champ_annuaire [1] nomù champ metadonnées |
$tableau_carto[$champ['at_action']][0] = $champ['at_ressource']; |
$tableau_carto[$champ['at_action']][1] = $champ['at_valeur']; |
148,20 → 143,19 |
* @return string l'identifiant du champ avatar dans l'annuaire donné ou false s'il n'en existe pas |
*/ |
public function obtenirChampAvatar($id_annuaire) { |
$requete_champs_avatar = 'SELECT * '. |
$idAnnuaireP = $this->proteger($id_annuaire); |
$requete = 'SELECT * '. |
'FROM annu_triples '. |
'WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '. |
"AND at_action = 'champ_avatar'"; |
"WHERE at_ce_annuaire = $idAnnuaireP ". |
"AND at_action = 'champ_avatar' ". |
'-- '.__FILE__.':'.__LINE__; |
$resultat_champs_avatar = $this->requeteUn($requete_champs_avatar); |
$champ_avatar = false; |
if (!$resultat_champs_avatar) { |
trigger_error('impossible de récupérer le champ avatar de l\'annuaire '.$id_annuaire); |
$resultat = $this->requeteUn($requete); |
if (!$resultat) { |
trigger_error("Impossible de récupérer le champ avatar de l'annuaire $id_annuaire."); |
} |
$champ_avatar = $resultat_champs_avatar['at_valeur']; |
return $champ_avatar ; |
$champ_avatar = ($resultat) ? $resultat['at_valeur'] : false; |
return $champ_avatar; |
} |
/** Renvoie l'identifiant du champ associé à l'image de profil (Avatar) dans un annuaire donné |
169,17 → 163,17 |
* @return string l'identifiant du champ date inscription dans l'annuaire donné ou false s'il n'en existe pas |
*/ |
public function obtenirChampDateEtValidite($id_annuaire) { |
$requete_champs_date_validite = 'SELECT * '. |
$requete = 'SELECT * '. |
'FROM annu_triples '. |
'WHERE at_ce_annuaire = '.$this->proteger($id_annuaire).' '. |
"AND at_action IN ('champ_date_inscription', 'champ_date_desinscription', 'champ_validite_inscription')"; |
"AND at_action IN ('champ_date_inscription', 'champ_date_desinscription', 'champ_validite_inscription') ". |
'-- '.__FILE__.':'.__LINE__; |
$resultats = $this->requeteTous($requete); |
$resultat_champs_date_validite = $this->requeteTous($requete_champs_date_validite); |
foreach ($resultat_champs_date_validite as $champ) { |
$resultat_champs_date_validite[$champ['at_action']] = $champ['at_ressource']; |
foreach ($resultats as $champ) { |
$champs_date_validite[$champ['at_action']] = $champ['at_ressource']; |
} |
return $resultat_champs_date_validite ; |
return $champs_date_validite ; |
} |
/** |
188,9 → 182,13 |
* @return array un tableau contenant les noms de champs mappés et les ids des champs métadonnées correspondants |
*/ |
public function obtenirChampsDescriptionAnnuaire($id_annuaire) { |
$requete_champs_mappage = 'SELECT * FROM annu_triples WHERE at_ce_annuaire = '.$this->proteger($id_annuaire); |
$idAnnuaireP = $this->proteger($id_annuaire); |
$requete = 'SELECT * '. |
'FROM annu_triples '. |
"WHERE at_ce_annuaire = $idAnnuaireP ". |
'-- '.__FILE__.':'.__LINE__; |
$resultat_champs_mappage = $this->requeteTous($requete_champs_mappage); |
$resultat_champs_mappage = $this->requeteTous($requete); |
if (!$resultat_champs_mappage) { |
trigger_error('impossible de récupérer les champs décrivant l\'annuaire '.$id_annuaire); |
} |
207,9 → 205,9 |
* @param int $identifiant l'identifiant de l'annuaire mappé |
*/ |
public function chargerNombreAnnuaireListeInscrits($identifiant) { |
$requete_informations_annuaire = 'SELECT aa_bdd, aa_table '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$identifiant.' '; |
$requete_informations_annuaire = 'SELECT aa_bdd, aa_table '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$identifiant.' '; |
$resultat_informations_annuaire = $this->requeteUn($requete_informations_annuaire); |
if (!$resultat_informations_annuaire) { |
240,7 → 238,7 |
* |
*/ |
public function chargerNombreAnnuaireListeInscritsParDepartement($identifiant) { |
$requete_informations_annuaire = 'SELECT aa_bdd, aa_table '. |
$requete_informations_annuaire = 'SELECT aa_bdd, aa_table '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$identifiant.' '; |
$resultat_informations_annuaire = $this->requeteUn($requete_informations_annuaire); |
292,45 → 290,41 |
* |
*/ |
public function chargerNombreAnnuaireListeInscritsParPays($id_annuaire, $ids_recherchees) { |
$requete_informations_annuaire = 'SELECT aa_bdd, aa_table '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat_informations_annuaire = $this->requeteUn($requete_informations_annuaire); |
if (!$resultat_informations_annuaire) { |
trigger_error('impossible de récupérer les informations de la table '.$id_annuaire); |
$requete = 'SELECT aa_bdd, aa_table '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$id_annuaire.' '. |
'-- '.__FILE__.':'.__LINE__; |
$infosAnnuaire = $this->requeteUn($requete); |
if (!$infosAnnuaire) { |
trigger_error("Impossible de récupérer les informations de la table $id_annuaire."); |
} |
$tableau_mappage = $this->obtenirChampsCartographie($id_annuaire); |
$champ_pays = $tableau_mappage['champ_pays'][0]; |
$requete_nombre_inscrits = 'SELECT '.$champ_pays.', COUNT(*) AS nbre '. |
'FROM '.$resultat_informations_annuaire['aa_bdd'].'.'.$resultat_informations_annuaire['aa_table'].' '. |
' WHERE '.$champ_pays.' IN '. |
'('.implode(',',$ids_recherchees).') '. |
'GROUP BY '.$champ_pays.' '. |
'ORDER BY '.$champ_pays.' ASC '; |
$tableAnnuaire = $infosAnnuaire['aa_bdd'].'.'.$infosAnnuaire['aa_table']; |
$requete = "SELECT $champ_pays, COUNT(*) AS nbre ". |
"FROM $tableAnnuaire ". |
"WHERE $champ_pays IN (".implode(',',$ids_recherchees).') '. |
"GROUP BY $champ_pays ". |
"ORDER BY $champ_pays ASC ". |
'-- '.__FILE__.':'.__LINE__; |
var_dump($requete); |
// Récupération des résultats |
$resultat_nombre_inscrits = array(); |
$nombreInscrits = array(); |
try { |
$donnees = $this->requeteTous($requete_nombre_inscrits); |
$donnees = $this->requeteTous($requete); |
if ($donnees === false) { |
$this->messages[] = "La requête n'a retourné aucun résultat."; |
} else { |
foreach ($donnees as $donnee) { |
$resultat_nombre_inscrits[$donnee[$champ_pays]] = $donnee['nbre']; |
$codePays = strtolower($donnee[$champ_pays]); |
$nombreInscrits[$codePays] = $donnee['nbre']; |
} |
} |
} catch (Exception $e) { |
$this->messages[] = sprintf($this->getTxt('sql_erreur'), $e->getFile(), $e->getLine(), $e->getMessage()); |
} |
if (!$resultat_informations_annuaire) { |
trigger_error('impossible de récupérer le nombre d\'inscrits de la table '.$resultat_informations_annuaire['aa_bdd'].'.'.$resultat_informations_annuaire['aa_table']); |
} |
return $resultat_nombre_inscrits; |
return $nombreInscrits; |
} |
private function formaterAbreviationPaysPourRecherche($chaine) { |
346,7 → 340,7 |
* @return array un tableau contenant la liste des inscrits dans l'annuaire donné, correspondants à ce critère |
*/ |
public function rechercherInscritDansAnnuaireMappeParTableauChamps($id_annuaire, $criteres, $modele = false, $numero_page = 1, $taille_page = 50) { |
$sep = $modele ? '%' : ''; |
$sep = ($modele) ? '%' : ''; |
foreach ($criteres as $champ => $valeur) { |
$criteres[$champ] = $valeur.$sep; |
363,9 → 357,9 |
* @param int $taille_page la taille de la page demandée |
* |
*/ |
public function chargerAnnuaireListeInscrits($id_annuaire, $numero_page = 1, $taille_page = 50) { |
public function chargerAnnuaireListeInscrits($id_annuaire, $numero_page = 1, $taille_page = 50) { |
$requete_informations_annuaire = 'SELECT aa_bdd, aa_table '. |
'FROM annu_annuaire '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat_informations_annuaire = $this->requeteUn($requete_informations_annuaire); |
458,10 → 452,10 |
// (Les requetes du style SELECT MAX(id)... ne garantissent pas qu'on récupère le bon id |
// si une autre insertion a eu lieu entre temps) |
// TODO utiliser du PDO pur et utiliser les fonctions last_insert_id générique |
$requete_nouvel_id = 'SELECT '.$nom_champs['champ_id'].' '. |
'FROM '.$annuaire['aa_bdd'].'.'.$annuaire['aa_table'].' '. |
'WHERE '. |
$nom_champs['champ_mail'].' = '.$this->proteger($valeurs_mappees[$nom_champs['champ_mail']]); |
$requete_nouvel_id = 'SELECT '.$nom_champs['champ_id'].' '. |
'FROM '.$annuaire['aa_bdd'].'.'.$annuaire['aa_table'].' '. |
'WHERE '. |
$nom_champs['champ_mail'].' = '.$this->proteger($valeurs_mappees[$nom_champs['champ_mail']]); |
$resultat_nouvel_id = $this->requeteUn($requete_nouvel_id); |
if (!$resultat_nouvel_id) { |
529,7 → 523,6 |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat_infos_annuaire = $this->requeteUn($requete_infos_annuaire); |
if (!$resultat_infos_annuaire) { |
return false; |
} |
542,7 → 535,6 |
'WHERE '.$champs_mappage['champ_id'].' = '.$id_utilisateur; |
$resultat_selection_valeur = $this->requeteUn($requete_selection_valeur); |
if (!$resultat_selection_valeur) { |
return false; |
} else { |
567,11 → 559,9 |
$id_utilisateur = $this->proteger($id_utilisateur); |
$valeur = $this->proteger($valeur); |
$requete_modification_valeur = |
'UPDATE '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '. |
"SET $champ = $valeur ". |
'WHERE '.$champs_mappage['champ_id'].' = '.$id_utilisateur; |
$requete_modification_valeur = 'UPDATE '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '. |
'SET '.$champ.' = '.$valeur.' '. |
'WHERE '.$champs_mappage['champ_id'].' = '.$id_utilisateur; |
$resultat_modification_valeur = $this->requeteUn($requete_modification_valeur); |
return $resultat_modification_valeur; |
} |
583,10 → 573,13 |
* @return string le mail associé à cet identifiant ou false si l'utilisateur n'existe pas |
*/ |
public function obtenirMailParId($id_annuaire, $id_utilisateur) { |
$champs_mappage = $this->obtenirChampsMappageAnnuaire($id_annuaire); |
// on ne garde que les champs de mappage correspondant au champ de l'annuaire principal |
$champs_mappage = $champs_mappage[0]; |
$requete_infos_annuaire = 'SELECT * '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat_infos_annuaire = $this->requeteUn($requete_infos_annuaire); |
if (!$resultat_infos_annuaire) { |
return false; |
601,9 → 594,8 |
$requete_selection_utilisateur = 'SELECT '.$champs_mappage['champ_mail'].' '. |
'FROM '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '. |
'WHERE '.$champs_mappage['champ_id'].' = '.$id_utilisateur; |
//echo $requete_selection_utilisateur; |
$resultat_selection_utilisateur = $this->requeteUn($requete_selection_utilisateur); |
if (!$resultat_selection_utilisateur) { |
return false; |
} else { |
619,10 → 611,13 |
* @return array un tableau contenant les mails associés à ces identifiant ou false si les utilisateurs n'existent pas |
*/ |
public function obtenirMailParTableauId($id_annuaire, $tableau_ids_utilisateurs) { |
$champs_mappage = $this->obtenirChampsMappageAnnuaire($id_annuaire); |
// on ne garde que les champs de mappage correspondant au champ de l'annuaire principal |
$champs_mappage = $champs_mappage[0]; |
$requete_infos_annuaire = 'SELECT * '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat_infos_annuaire = $this->requeteUn($requete_infos_annuaire); |
if (!$resultat_infos_annuaire) { |
return false; |
635,8 → 630,8 |
$str_ids_utilisateurs = implode(',',$tableau_ids_utilisateurs_p); |
$requete_selection_utilisateurs = 'SELECT '.$champs_mappage['champ_mail'].' '. |
'FROM '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '. |
'WHERE '.$champs_mappage['champ_id'].' IN ('.$str_ids_utilisateurs.')'; |
'FROM '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '. |
'WHERE '.$champs_mappage['champ_id'].' IN ('.$str_ids_utilisateurs.')'; |
$resultat_selection_utilisateurs = $this->requeteTous($requete_selection_utilisateurs); |
644,7 → 639,7 |
foreach ($resultat_selection_utilisateurs as $utilisateur) { |
$resultat_utilisateurs[] = $utilisateur[$champs_mappage['champ_mail']]; |
} |
if (!$resultat_selection_utilisateurs) { |
if(!$resultat_selection_utilisateurs) { |
return false; |
} else { |
return $resultat_utilisateurs; |
782,7 → 777,7 |
$mot_de_passe = $this->proteger($mot_de_passe); |
$id_utilisateur = $this->proteger($id_utilisateur); |
$requete_selection_utilisateur = 'SELECT COUNT(*) AS match_login_mdp '. |
$requete_selection_utilisateur = 'SELECT COUNT(*) as match_login_mdp '. |
'FROM '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '. |
'WHERE '.$champs_mappage['champ_id'].' = '.$id_utilisateur.' '. |
'AND '.$champs_mappage['champ_pass'].' = '.$mot_de_passe; |
806,25 → 801,28 |
* @return Array les informations demandées |
*/ |
public function obtenirValeursUtilisateur($id_annuaire, $id_utilisateur, $champs_mappage) { |
$requete = 'SELECT * '. |
$requete_infos_annuaire = 'SELECT * '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat = $this->requeteUn($requete); |
$resultat_infos_annuaire = $this->requeteUn($requete_infos_annuaire); |
if (!$resultat_infos_annuaire) { |
return false; |
} |
$retour = false; |
if ($resultat) { |
$champs_mappage_str = implode(',', $champs_mappage); |
$idUtilisateurP = $this->proteger($id_utilisateur); |
$champs_mappage_str = implode(',',$champs_mappage); |
$id_utilisateur = $this->proteger($id_utilisateur); |
$requete = 'SELECT '.$champs_mappage_str.' '. |
'FROM '.$resultat['aa_bdd'].'.'.$resultat['aa_table'].' '. |
'WHERE '.$champs_mappage['champ_id'].' = '.$idUtilisateurP; |
$requete_selection_utilisateur = 'SELECT '.$champs_mappage_str.' '. |
'FROM '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '. |
'WHERE '.$champs_mappage['champ_id'].' = '.$id_utilisateur; |
$resultat = $this->requeteUn($requete); |
if ($resultat) { |
$retour = $resultat; |
} |
$resultat = $this->requeteUn($requete); |
if (!$resultat_selection_utilisateur) { |
return false; |
} else { |
return $resultat_selection_utilisateur; |
} |
return $retour; |
} |
889,7 → 887,6 |
'ORDER BY '.$champ_order_by.' '.$dir.' LIMIT '.$limit; |
$resultat_selection_utilisateur = $this->requeteTous($requete_selection_utilisateur); |
if (!$resultat_selection_utilisateur) { |
return false; |
} else { |
926,7 → 923,6 |
if (!$resultat_nb_inscrits_intervalle) { |
return 0; |
} |
return $resultat_nb_inscrits_intervalle['nb']; |
} |
944,7 → 940,6 |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat_infos_annuaire = $this->requeteUn($requete_infos_annuaire); |
if (!$resultat_infos_annuaire) { |
return false; |
} |
951,12 → 946,9 |
$champs_date = $this->obtenirChampDateEtValidite($id_annuaire); |
$requete_suppression_utilisateur = |
'DELETE FROM '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '. |
$requete_suppression_utilisateur = 'DELETE FROM '.$resultat_infos_annuaire['aa_bdd'].'.'.$resultat_infos_annuaire['aa_table'].' '. |
'WHERE '.$champs_mappage[0]['champ_id'].' = '.$this->proteger($id_utilisateur); |
$resultat_suppression_utilisateur = $this->requeteUn($requete_suppression_utilisateur); |
if ($this->utilisateurExisteParId($id_annuaire, $id_utilisateur, $champs_mappage)) { |
return false; |
} |
973,10 → 965,10 |
$champs_mappage = $this->obtenirChampsMappageAnnuaire($id_annuaire); |
$requete_informations_annuaire = 'SELECT aa_bdd, aa_table '. |
'FROM annu_annuaire '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat_informations_annuaire = $this->requeteUn($requete_informations_annuaire); |
$resultat_informations_annuaire = $this->requeteUn($requete_informations_annuaire); |
if (!$resultat_informations_annuaire) { |
trigger_error('impossible de récupérer les informations de la table '.$id_annuaire); |
} |
1005,7 → 997,6 |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat_informations_annuaire = $this->requeteUn($requete_informations_annuaire); |
if (!$resultat_informations_annuaire) { |
trigger_error('impossible de récupérer les informations de la table '.$id_annuaire); |
} |
1015,6 → 1006,7 |
' WHERE '.$champs_mappage[0]['champ_mail'].' = '.$this->proteger($mail); |
$resultat_nombre_inscrits = $this->requeteUn($requete_nombre_inscrits); |
if (!$resultat_nombre_inscrits) { |
trigger_error('impossible de vérifier l\'existence de cet utilisateur '); |
} |
1037,7 → 1029,7 |
} |
$requete_informations_annuaire = 'SELECT aa_bdd, aa_table '. |
'FROM annu_annuaire '. |
'FROM annu_annuaire '. |
'WHERE aa_id_annuaire = '.$id_annuaire.' '; |
$resultat_informations_annuaire = $this->requeteUn($requete_informations_annuaire); |
1050,7 → 1042,11 |
$requete_conditions_inscrits = ''; |
$separateur = $exclusive ? ' AND ' : ' OR '; |
if ($exclusive) { |
$separateur = ' AND '; |
} else { |
$separateur = ' OR '; |
} |
// on inclut les identifiants déjà trouvé par les critères de métadonnées |
if (is_array($id_a_inclure) && count($id_a_inclure) != 0) { |
1137,6 → 1133,8 |
'WHERE t1.'.$champ_id.' != t2.'.$champ_id.' '. |
'ORDER BY '.$champ_nom.', '.$champ_prenom.' '; |
$requete_nb_doublons = 'SELECT COUNT(DISTINCT t2.'.$champs_mappage[0]['champ_id'].') as nb'. |
' FROM '.$resultat_informations_annuaire['aa_bdd'].'.'.$resultat_informations_annuaire['aa_table'].' t1 '. |
'LEFT JOIN '.$resultat_informations_annuaire['aa_bdd'].'.'.$resultat_informations_annuaire['aa_table'].' t2 '. |
1189,8 → 1187,6 |
if ($resultat_modification_mdp) { |
return $nouveau_mdp; |
} |
return false; |
} |
} |
?> |
Property changes: |
Added: svnkit:entry:sha1-checksum |
+04c6fe9575397f72f631043cb2cd8eb49adb09a6 |
\ No newline at end of property |
/trunk/. |
---|
Property changes: |
Modified: svn:mergeinfo |
Merged /branches/v1.2-autel:r443,445,450-455,457,459,461,463-464,470-472 |