WebSVN – eFlore/Projets.eflore-projets – Diff – /trunk/services/modules/0.1/moissonnage/cartes/SourceDonnees.php


<?php
 
class SourceDonnees {
	
	private $bdd = null;
	private $limitesCarte = '';
	private $taxon = array();
	
	private $nomRang = '';
	private $taxons = array();
	private $genres = array();
	private $utilisateurs = null;
	
	
	public function __construct($limitesCarte, $taxon) {
		$this->limitesCarte = $limitesCarte;
		foreach ($this->limitesCarte as $bord => $valeur) {
			$this->limitesCarte[$bord] = str_replace(",", ".", round($valeur, 6));
		}
		$this->bdd = new Bdd();
		$this->taxon = $taxon;
		$this->nomRang = $this->obtenirNomRang();
		if ($this->nomRang == 'espece' || $this->nomRang == 'sous_espece') {
			$this->taxons = $this->recupererSynonymesEtSousEspeces();
		} elseif ($this->nomRang == 'famille') {
			$this->genres = $this->recupererGenres();
		}
		$this->utilisateurs = new Utilisateurs();
	}
	
	private function obtenirNomRang() {
		$nomsRangs = array('famille', 'genre', 'espece', 'sous_espece');
		$rangs = explode(',', Config::get('rangs'));
		for ($index = 0; $index < count($nomsRangs) && $rangs[$index] != $this->taxon['rang']; $index ++);
		$position = $index == count($nomsRangs) ? count($nomsRangs)-1 : $index;
		return $nomsRangs[$position];
	}
	
	protected function recupererSynonymesEtSousEspeces() {
		$requete =
		"SELECT num_nom, nom_sci, nom_complet, num_taxonomique FROM ".Config::get('bdd_table_referentiel').
		" WHERE hierarchie LIKE '%-{$this->taxon['num_nom']}-%' ".
		"OR num_nom_retenu = {$this->taxon['num_nom_retenu']}";
		return $this->bdd->recupererTous($requete);
	}
	
	protected function recupererGenres() {
		$this->bdd->requeter("USE ".Config::get('bdd_nom'));
		$requete =
		"SELECT num_nom, nom_sci, num_taxonomique FROM ".Config::get('bdd_table_referentiel').
		" WHERE rang=220 AND num_tax_sup={$this->taxon['num_nom']}";
		return $this->bdd->recupererTous($requete);
	}
	
	public function recupererStationsFloradata() {
		$this->bdd->requeter("USE ".Config::get('bdd_nom_floradata'));
		$requete =
		"SELECT DISTINCTROW zone_geo AS commune, Date(date_observation) AS date, Floor(wgs84_latitude*10)/10 AS lat, ".
		"Floor(wgs84_longitude*10)/10 AS lng, courriel_utilisateur AS auteur ".
		"FROM cel_obs LEFT JOIN cel_zones_geo cz ON ce_zone_geo=id_zone_geo ".
		"WHERE ".$this->construireWhereTaxonFloradata()." AND transmission=1 AND nom_referentiel = '".Config::get('referentielsDispo')."' AND ".
		"wgs84_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".
		"AND wgs84_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".
		"AND date_observation<>'0000-00-00 00-00-00' ORDER BY lat DESC, lng ASC, commune, date";
		$stations = $this->bdd->recupererTous($requete);
		
		$this->extraireIdentitesAuteurs($stations);
		foreach($stations as &$station) {
			$station['auteur'] = $this->utilisateurs->getIntitule($station['auteur']);
		}	
		return $stations;
	}
	
	private function extraireIdentitesAuteurs($stations) {
		$courriels = array();
		foreach ($stations as &$station) {
			$courriels[] = $station['auteur'];
		}
		$this->utilisateurs->setCourriels($courriels);
		$this->utilisateurs->chargerIdentites();
	}
	
	private function construireWhereTaxonFloradata() {
		$criteres = array();
		$nomRang = $this->obtenirNomRang($this->taxon);
		if ($this->nomRang == 'famille') {
			$criteres[] = "famille=".$this->bdd->proteger($this->taxon['nom_sci']);
		} elseif ($this->nomRang == 'genre') {
			$criteres[] = "nom_sel LIKE ".$this->bdd->proteger($this->taxon['nom_sci'].'%');
		} else {
			$taxons = array($this->taxon['num_nom']);
			foreach ($this->taxons as $sousTaxon) {
				$taxons[] = $sousTaxon['num_nom'];
			}
			$criteres[] = "nom_sel_nn IN (".implode(',', array_unique($taxons))	.")";
		}
		return "(".implode(' OR ',array_unique($criteres)).")";
	}
	
	
	
	public function recupererStationsMoissonnage($source) {
		$this->bdd->requeter("USE ".Config::get('bdd_nom'));
		$requete =
		"SELECT DISTINCTROW lieu_commune_code_insee, observation_date AS date, observateur_nom_complet AS auteur ".
		"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage($source)." ".
		"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".
		"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".
		"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ". @$_SERVER['REQUEST_URI'];
		$stations = $this->bdd->recupererTous($requete);
		$this->rechercherInfosCommune($stations);
		return $stations;
	}
	
	public function recupererStationsVigieFlore() {
		$this->bdd->requeter("USE ".Config::get('bdd_nom'));
		$requete =
		"SELECT DISTINCTROW lieu_commune_code_insee AS commune, Floor(lieu_station_longitude*10)/10 as lng, Floor(lieu_station_latitude*10)/10 as lat, observation_date AS date, observateur_nom_complet AS auteur ".
		"FROM vigie_flore_tapir WHERE ".$this->construireWhereTaxonMoissonnage($source)." ".
		"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".
		"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".
		" ORDER BY lat DESC, lng ASC, lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ". @$_SERVER['REQUEST_URI'];
		$stations = $this->bdd->recupererTous($requete);
		return $stations;
	}
	
	private function construireWhereTaxonMoissonnage($source) {
		$nomRang = $this->obtenirNomRang();
		$criteres = array();
		$criteres[] = ($source == "baznat" || $source == "ifn") ? 
						"num_nom = ".$this->taxon['num_nom'] : 
						"nom_scientifique_complet LIKE ".$this->bdd->proteger($this->taxon['nom_sci']) ;
		if ($this->nomRang == 'espece' || $this->nomRang == 'sous_espece') {
			foreach ($this->taxons as $sousTaxon) {
				$criteres[] = ($source == "baznat" || $source == "ifn") ?
										"num_nom = ".$sousTaxon['num_nom'] : 
										"nom_scientifique_complet LIKE ".$this->bdd->proteger($sousTaxon['nom_sci']) ;
			}
		} elseif ($this->nomRang == 'famille') {
			foreach ($this->genres as $genre) {
				$criteres[] = "nom_scientifique_complet LIKE ".$this->bdd->proteger($genre['nom_sci']."%");
			}
		}
		return "(".implode(' OR ',array_unique($criteres)).")";
	}
	
	private function rechercherInfosCommune(& $stations) {
		$codesInsee = array();
		foreach ($stations as $station) {
			$codeInsee = $station['lieu_commune_code_insee'];
			if (substr($codeInsee, 0, 2) == '20') {
				$codeInsee  = '2A'.substr($codeInsee, 2);
				$codeInsee2 = '2B'.substr($codeInsee, 2);
			}
			if (!in_array($codeInsee, $codesInsee)) {
				if (substr($codeInsee, 0, 2) == '20') {
					$codesInsee[] = "'$codeInsee2'";
				}
				$codesInsee[] = "'$codeInsee'";
			}
		}
		$nomTableCommunes = Config::get('bdd_table_communes');
		$communes = array();
		if(count($codesInsee) > 0) {
			$requete =
			"SELECT insee, nom AS commune, Floor(latitude_degre*10)/10 AS lat, Floor(longitude_degre*10)/10 AS lng ".
			"FROM $nomTableCommunes WHERE insee IN (".implode(',', array_unique($codesInsee)).") ORDER BY insee";
			$communes = $this->bdd->recupererTous($requete);
		}
		$indexStation = 0;
		foreach ($communes as $commune) {
			$codeInsee = $commune['insee'];
			if (substr($codeInsee, 0, 2) == '2A' || substr($codeInsee, 0, 2) == '2B') {
				$codeInsee = '20'.substr($codeInsee, 2);
			}
			while ($stations[$indexStation]['lieu_commune_code_insee'] < $codeInsee) {
				$indexStation ++;
			}
			if ($stations[$indexStation]['lieu_commune_code_insee'] == $codeInsee) {
				$stations[$indexStation]['lat'] = $commune['lat'];
				$stations[$indexStation]['lng'] = $commune['lng'];
				$stations[$indexStation]['commune'] = $commune['commune'];
			}
		}
		
		$lat = array();
		$lng = array();
		foreach ($stations as $index => $station) {
			if (!isset($station['lat'])) {
				$station['lat'] = -100;
				$station['lng'] = -100;
			}
			$lat[$index] = $station['lat'];
			$lng[$index] = $station['lng'];
		}
		array_multisort($lat, SORT_DESC, $lng, SORT_ASC, $stations);
	}
	
}
 
?>

Subversion Repositories eFlore/Projets.eflore-projets

(root)/trunk/services/modules/0.1/moissonnage/cartes/SourceDonnees.php @ 998 – Rev 998 → 1192

Rev 998		Rev 1192
1	`<?php`	1	`<?php`
2		2
3	`class SourceDonnees {`	3	`class SourceDonnees {`
4		4
5	`private $bdd = null;`	5	`private $bdd = null;`
6	`private $limitesCarte = '';`	6	`private $limitesCarte = '';`
7	`private $taxon = array();`	7	`private $taxon = array();`
8		8
9	`private $nomRang = '';`	9	`private $nomRang = '';`
10	`private $taxons = array();`	10	`private $taxons = array();`
11	`private $genres = array();`	11	`private $genres = array();`
12	`private $utilisateurs = null;`	12	`private $utilisateurs = null;`
13		13
14		14
15	`public function __construct($limitesCarte, $taxon) {`	15	`public function __construct($limitesCarte, $taxon) {`
16	`$this->limitesCarte = $limitesCarte;`	16	`$this->limitesCarte = $limitesCarte;`
17	`foreach ($this->limitesCarte as $bord => $valeur) {`	17	`foreach ($this->limitesCarte as $bord => $valeur) {`
18	`$this->limitesCarte[$bord] = str_replace(",", ".", round($valeur, 6));`	18	`$this->limitesCarte[$bord] = str_replace(",", ".", round($valeur, 6));`
19	`}`	19	`}`
20	`$this->bdd = new Bdd();`	20	`$this->bdd = new Bdd();`
21	`$this->taxon = $taxon;`	21	`$this->taxon = $taxon;`
22	`$this->nomRang = $this->obtenirNomRang();`	22	`$this->nomRang = $this->obtenirNomRang();`
23	`if ($this->nomRang == 'espece' \|\| $this->nomRang == 'sous_espece') {`	23	`if ($this->nomRang == 'espece' \|\| $this->nomRang == 'sous_espece') {`
24	`$this->taxons = $this->recupererSynonymesEtSousEspeces();`	24	`$this->taxons = $this->recupererSynonymesEtSousEspeces();`
25	`} elseif ($this->nomRang == 'famille') {`	25	`} elseif ($this->nomRang == 'famille') {`
26	`$this->genres = $this->recupererGenres();`	26	`$this->genres = $this->recupererGenres();`
27	`}`	27	`}`
28	`$this->utilisateurs = new Utilisateurs();`	28	`$this->utilisateurs = new Utilisateurs();`
29	`}`	29	`}`
30		30
31	`private function obtenirNomRang() {`	31	`private function obtenirNomRang() {`
32	`$nomsRangs = array('famille', 'genre', 'espece', 'sous_espece');`	32	`$nomsRangs = array('famille', 'genre', 'espece', 'sous_espece');`
33	`$rangs = explode(',', Config::get('rangs'));`	33	`$rangs = explode(',', Config::get('rangs'));`
34	`for ($index = 0; $index < count($nomsRangs) && $rangs[$index] != $this->taxon['rang']; $index ++);`	34	`for ($index = 0; $index < count($nomsRangs) && $rangs[$index] != $this->taxon['rang']; $index ++);`
35	`$position = $index == count($nomsRangs) ? count($nomsRangs)-1 : $index;`	35	`$position = $index == count($nomsRangs) ? count($nomsRangs)-1 : $index;`
36	`return $nomsRangs[$position];`	36	`return $nomsRangs[$position];`
37	`}`	37	`}`
38		38
39	`protected function recupererSynonymesEtSousEspeces() {`	39	`protected function recupererSynonymesEtSousEspeces() {`
40	`$requete =`	40	`$requete =`
41	`"SELECT num_nom, nom_sci, nom_complet, num_taxonomique FROM ".Config::get('bdd_table_referentiel').`	41	`"SELECT num_nom, nom_sci, nom_complet, num_taxonomique FROM ".Config::get('bdd_table_referentiel').`
42	`" WHERE hierarchie LIKE '%-{$this->taxon['num_nom']}-%' ".`	42	`" WHERE hierarchie LIKE '%-{$this->taxon['num_nom']}-%' ".`
43	`"OR num_nom_retenu = {$this->taxon['num_nom_retenu']}";`	43	`"OR num_nom_retenu = {$this->taxon['num_nom_retenu']}";`
44	`return $this->bdd->recupererTous($requete);`	44	`return $this->bdd->recupererTous($requete);`
45	`}`	45	`}`
46		46
47	`protected function recupererGenres() {`	47	`protected function recupererGenres() {`
48	`$this->bdd->requeter("USE ".Config::get('bdd_nom'));`	48	`$this->bdd->requeter("USE ".Config::get('bdd_nom'));`
49	`$requete =`	49	`$requete =`
50	`"SELECT num_nom, nom_sci, num_taxonomique FROM ".Config::get('bdd_table_referentiel').`	50	`"SELECT num_nom, nom_sci, num_taxonomique FROM ".Config::get('bdd_table_referentiel').`
51	`" WHERE rang=220 AND num_tax_sup={$this->taxon['num_nom']}";`	51	`" WHERE rang=220 AND num_tax_sup={$this->taxon['num_nom']}";`
52	`return $this->bdd->recupererTous($requete);`	52	`return $this->bdd->recupererTous($requete);`
53	`}`	53	`}`
54		54
55	`public function recupererStationsFloradata() {`	55	`public function recupererStationsFloradata() {`
56	`$this->bdd->requeter("USE ".Config::get('bdd_nom_floradata'));`	56	`$this->bdd->requeter("USE ".Config::get('bdd_nom_floradata'));`
57	`$requete =`	57	`$requete =`
58	`"SELECT DISTINCTROW zone_geo AS commune, Date(date_observation) AS date, Floor(wgs84_latitude*10)/10 AS lat, ".`	58	`"SELECT DISTINCTROW zone_geo AS commune, Date(date_observation) AS date, Floor(wgs84_latitude*10)/10 AS lat, ".`
59	`"Floor(wgs84_longitude*10)/10 AS lng, courriel_utilisateur AS auteur ".`	59	`"Floor(wgs84_longitude*10)/10 AS lng, courriel_utilisateur AS auteur ".`
60	`"FROM cel_obs LEFT JOIN cel_zones_geo cz ON ce_zone_geo=id_zone_geo ".`	60	`"FROM cel_obs LEFT JOIN cel_zones_geo cz ON ce_zone_geo=id_zone_geo ".`
61	`"WHERE ".$this->construireWhereTaxonFloradata()." AND transmission=1 AND nom_referentiel = '".Config::get('referentielsDispo')."' AND ".`	61	`"WHERE ".$this->construireWhereTaxonFloradata()." AND transmission=1 AND nom_referentiel = '".Config::get('referentielsDispo')."' AND ".`
62	`"wgs84_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".`	62	`"wgs84_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".`
63	`"AND wgs84_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".`	63	`"AND wgs84_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".`
64	`"AND date_observation<>'0000-00-00 00-00-00' ORDER BY lat DESC, lng ASC, commune, date";`	64	`"AND date_observation<>'0000-00-00 00-00-00' ORDER BY lat DESC, lng ASC, commune, date";`
65	`$stations = $this->bdd->recupererTous($requete);`	65	`$stations = $this->bdd->recupererTous($requete);`
66		66
67	`$this->extraireIdentitesAuteurs($stations);`	67	`$this->extraireIdentitesAuteurs($stations);`
68	`foreach($stations as &$station) {`	68	`foreach($stations as &$station) {`
69	`$station['auteur'] = $this->utilisateurs->getIntitule($station['auteur']);`	69	`$station['auteur'] = $this->utilisateurs->getIntitule($station['auteur']);`
70	`}`	70	`}`
71	`return $stations;`	71	`return $stations;`
72	`}`	72	`}`
73		73
74	`private function extraireIdentitesAuteurs($stations) {`	74	`private function extraireIdentitesAuteurs($stations) {`
75	`$courriels = array();`	75	`$courriels = array();`
76	`foreach ($stations as &$station) {`	76	`foreach ($stations as &$station) {`
77	`$courriels[] = $station['auteur'];`	77	`$courriels[] = $station['auteur'];`
78	`}`	78	`}`
79	`$this->utilisateurs->setCourriels($courriels);`	79	`$this->utilisateurs->setCourriels($courriels);`
80	`$this->utilisateurs->chargerIdentites();`	80	`$this->utilisateurs->chargerIdentites();`
81	`}`	81	`}`
82		82
83	`private function construireWhereTaxonFloradata() {`	83	`private function construireWhereTaxonFloradata() {`
84	`$criteres = array();`	84	`$criteres = array();`
85	`$nomRang = $this->obtenirNomRang($this->taxon);`	85	`$nomRang = $this->obtenirNomRang($this->taxon);`
86	`if ($this->nomRang == 'famille') {`	86	`if ($this->nomRang == 'famille') {`
87	`$criteres[] = "famille=".$this->bdd->proteger($this->taxon['nom_sci']);`	87	`$criteres[] = "famille=".$this->bdd->proteger($this->taxon['nom_sci']);`
88	`} elseif ($this->nomRang == 'genre') {`	88	`} elseif ($this->nomRang == 'genre') {`
89	`$criteres[] = "nom_sel LIKE ".$this->bdd->proteger($this->taxon['nom_sci'].'%');`	89	`$criteres[] = "nom_sel LIKE ".$this->bdd->proteger($this->taxon['nom_sci'].'%');`
90	`} else {`	90	`} else {`
91	`$taxons = array($this->taxon['num_nom']);`	91	`$taxons = array($this->taxon['num_nom']);`
92	`foreach ($this->taxons as $sousTaxon) {`	92	`foreach ($this->taxons as $sousTaxon) {`
93	`$taxons[] = $sousTaxon['num_nom'];`	93	`$taxons[] = $sousTaxon['num_nom'];`
94	`}`	94	`}`
95	`$criteres[] = "nom_sel_nn IN (".implode(',', array_unique($taxons)) .")";`	95	`$criteres[] = "nom_sel_nn IN (".implode(',', array_unique($taxons)) .")";`
96	`}`	96	`}`
97	`return "(".implode(' OR ',array_unique($criteres)).")";`	97	`return "(".implode(' OR ',array_unique($criteres)).")";`
98	`}`	98	`}`
-		99
-		100
99		101
100	`public function recupererStationsMoissonnage($source) {`	102	`public function recupererStationsMoissonnage($source) {`
101	`$this->bdd->requeter("USE ".Config::get('bdd_nom'));`	103	`$this->bdd->requeter("USE ".Config::get('bdd_nom'));`
102	`$requete =`	104	`$requete =`
103	`"SELECT DISTINCTROW lieu_commune_code_insee, observation_date AS date, observateur_nom_complet AS auteur ".`	105	`"SELECT DISTINCTROW lieu_commune_code_insee, observation_date AS date, observateur_nom_complet AS auteur ".`
104	`"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage($source)." ".`	106	`"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage($source)." ".`
105	`"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".`	107	`"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".`
106	`"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".`	108	`"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".`
107	`"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ". @$_SERVER['REQUEST_URI'];`	109	`"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ". @$_SERVER['REQUEST_URI'];`
108	`$stations = $this->bdd->recupererTous($requete);`	110	`$stations = $this->bdd->recupererTous($requete);`
109	`$this->rechercherInfosCommune($stations);`	111	`$this->rechercherInfosCommune($stations);`
110	`return $stations;`	112	`return $stations;`
-		113	`}`
-		114
-		115	`public function recupererStationsVigieFlore() {`
-		116	`$this->bdd->requeter("USE ".Config::get('bdd_nom'));`
-		117	`$requete =`
-		118	`"SELECT DISTINCTROW lieu_commune_code_insee AS commune, Floor(lieu_station_longitude10)/10 as lng, Floor(lieu_station_latitude10)/10 as lat, observation_date AS date, observateur_nom_complet AS auteur ".`
-		119	`"FROM vigie_flore_tapir WHERE ".$this->construireWhereTaxonMoissonnage($source)." ".`
-		120	`"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".`
-		121	`"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".`
-		122	`" ORDER BY lat DESC, lng ASC, lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ". @$_SERVER['REQUEST_URI'];`
-		123	`$stations = $this->bdd->recupererTous($requete);`
-		124	`return $stations;`
111	`}`	125	`}`
112		126
113	`private function construireWhereTaxonMoissonnage($source) {`	127	`private function construireWhereTaxonMoissonnage($source) {`
114	`$nomRang = $this->obtenirNomRang();`	128	`$nomRang = $this->obtenirNomRang();`
115	`$criteres = array();`	129	`$criteres = array();`
116	`$criteres[] = ($source == "baznat" \|\| $source == "ifn") ?`	130	`$criteres[] = ($source == "baznat" \|\| $source == "ifn") ?`
117	`"num_nom = ".$this->taxon['num_nom'] :`	131	`"num_nom = ".$this->taxon['num_nom'] :`
118	`"nom_scientifique_complet LIKE ".$this->bdd->proteger($this->taxon['nom_sci']) ;`	132	`"nom_scientifique_complet LIKE ".$this->bdd->proteger($this->taxon['nom_sci']) ;`
119	`if ($this->nomRang == 'espece' \|\| $this->nomRang == 'sous_espece') {`	133	`if ($this->nomRang == 'espece' \|\| $this->nomRang == 'sous_espece') {`
120	`foreach ($this->taxons as $sousTaxon) {`	134	`foreach ($this->taxons as $sousTaxon) {`
121	`$criteres[] = ($source == "baznat" \|\| $source == "ifn") ?`	135	`$criteres[] = ($source == "baznat" \|\| $source == "ifn") ?`
122	`"num_nom = ".$sousTaxon['num_nom'] :`	136	`"num_nom = ".$sousTaxon['num_nom'] :`
123	`"nom_scientifique_complet LIKE ".$this->bdd->proteger($sousTaxon['nom_sci']) ;`	137	`"nom_scientifique_complet LIKE ".$this->bdd->proteger($sousTaxon['nom_sci']) ;`
124	`}`	138	`}`
125	`} elseif ($this->nomRang == 'famille') {`	139	`} elseif ($this->nomRang == 'famille') {`
126	`foreach ($this->genres as $genre) {`	140	`foreach ($this->genres as $genre) {`
127	`$criteres[] = "nom_scientifique_complet LIKE ".$this->bdd->proteger($genre['nom_sci']."%");`	141	`$criteres[] = "nom_scientifique_complet LIKE ".$this->bdd->proteger($genre['nom_sci']."%");`
128	`}`	142	`}`
129	`}`	143	`}`
130	`return "(".implode(' OR ',array_unique($criteres)).")";`	144	`return "(".implode(' OR ',array_unique($criteres)).")";`
131	`}`	145	`}`
132		146
133	`private function rechercherInfosCommune(& $stations) {`	147	`private function rechercherInfosCommune(& $stations) {`
134	`$codesInsee = array();`	148	`$codesInsee = array();`
135	`foreach ($stations as $station) {`	149	`foreach ($stations as $station) {`
136	`$codeInsee = $station['lieu_commune_code_insee'];`	150	`$codeInsee = $station['lieu_commune_code_insee'];`
137	`if (substr($codeInsee, 0, 2) == '20') {`	151	`if (substr($codeInsee, 0, 2) == '20') {`
138	`$codeInsee = '2A'.substr($codeInsee, 2);`	152	`$codeInsee = '2A'.substr($codeInsee, 2);`
139	`$codeInsee2 = '2B'.substr($codeInsee, 2);`	153	`$codeInsee2 = '2B'.substr($codeInsee, 2);`
140	`}`	154	`}`
141	`if (!in_array($codeInsee, $codesInsee)) {`	155	`if (!in_array($codeInsee, $codesInsee)) {`
142	`if (substr($codeInsee, 0, 2) == '20') {`	156	`if (substr($codeInsee, 0, 2) == '20') {`
143	`$codesInsee[] = "'$codeInsee2'";`	157	`$codesInsee[] = "'$codeInsee2'";`
144	`}`	158	`}`
145	`$codesInsee[] = "'$codeInsee'";`	159	`$codesInsee[] = "'$codeInsee'";`
146	`}`	160	`}`
147	`}`	161	`}`
148	`$nomTableCommunes = Config::get('bdd_table_communes');`	162	`$nomTableCommunes = Config::get('bdd_table_communes');`
149	`$communes = array();`	163	`$communes = array();`
150	`if(count($codesInsee) > 0) {`	164	`if(count($codesInsee) > 0) {`
151	`$requete =`	165	`$requete =`
152	`"SELECT insee, nom AS commune, Floor(latitude_degre10)/10 AS lat, Floor(longitude_degre10)/10 AS lng ".`	166	`"SELECT insee, nom AS commune, Floor(latitude_degre10)/10 AS lat, Floor(longitude_degre10)/10 AS lng ".`
153	`"FROM $nomTableCommunes WHERE insee IN (".implode(',', array_unique($codesInsee)).") ORDER BY insee";`	167	`"FROM $nomTableCommunes WHERE insee IN (".implode(',', array_unique($codesInsee)).") ORDER BY insee";`
154	`$communes = $this->bdd->recupererTous($requete);`	168	`$communes = $this->bdd->recupererTous($requete);`
155	`}`	169	`}`
156	`$indexStation = 0;`	170	`$indexStation = 0;`
157	`foreach ($communes as $commune) {`	171	`foreach ($communes as $commune) {`
158	`$codeInsee = $commune['insee'];`	172	`$codeInsee = $commune['insee'];`
159	`if (substr($codeInsee, 0, 2) == '2A' \|\| substr($codeInsee, 0, 2) == '2B') {`	173	`if (substr($codeInsee, 0, 2) == '2A' \|\| substr($codeInsee, 0, 2) == '2B') {`
160	`$codeInsee = '20'.substr($codeInsee, 2);`	174	`$codeInsee = '20'.substr($codeInsee, 2);`
161	`}`	175	`}`
162	`while ($stations[$indexStation]['lieu_commune_code_insee'] < $codeInsee) {`	176	`while ($stations[$indexStation]['lieu_commune_code_insee'] < $codeInsee) {`
163	`$indexStation ++;`	177	`$indexStation ++;`
164	`}`	178	`}`
165	`if ($stations[$indexStation]['lieu_commune_code_insee'] == $codeInsee) {`	179	`if ($stations[$indexStation]['lieu_commune_code_insee'] == $codeInsee) {`
166	`$stations[$indexStation]['lat'] = $commune['lat'];`	180	`$stations[$indexStation]['lat'] = $commune['lat'];`
167	`$stations[$indexStation]['lng'] = $commune['lng'];`	181	`$stations[$indexStation]['lng'] = $commune['lng'];`
168	`$stations[$indexStation]['commune'] = $commune['commune'];`	182	`$stations[$indexStation]['commune'] = $commune['commune'];`
169	`}`	183	`}`
170	`}`	184	`}`
171		185
172	`$lat = array();`	186	`$lat = array();`
173	`$lng = array();`	187	`$lng = array();`
174	`foreach ($stations as $index => $station) {`	188	`foreach ($stations as $index => $station) {`
175	`if (!isset($station['lat'])) {`	189	`if (!isset($station['lat'])) {`
176	`$station['lat'] = -100;`	190	`$station['lat'] = -100;`
177	`$station['lng'] = -100;`	191	`$station['lng'] = -100;`
178	`}`	192	`}`
179	`$lat[$index] = $station['lat'];`	193	`$lat[$index] = $station['lat'];`
180	`$lng[$index] = $station['lng'];`	194	`$lng[$index] = $station['lng'];`
181	`}`	195	`}`
182	`array_multisort($lat, SORT_DESC, $lng, SORT_ASC, $stations);`	196	`array_multisort($lat, SORT_DESC, $lng, SORT_ASC, $stations);`
183	`}`	197	`}`
184		198
185	`}`	199	`}`
186		200
187	`?>`	201	`?>`