Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 880 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 880 Rev 890
Line 100... Line 100...
100
		$requete =
100
		$requete =
101
		"SELECT DISTINCTROW lieu_commune_code_insee, observation_date AS date, observateur_nom_complet AS auteur ".
101
		"SELECT DISTINCTROW lieu_commune_code_insee, observation_date AS date, observateur_nom_complet AS auteur ".
102
		"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage()." ".
102
		"FROM {$source}_tapir WHERE ".$this->construireWhereTaxonMoissonnage()." ".
103
		"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".
103
		"AND lieu_station_longitude BETWEEN ".$this->limitesCarte['ouest']." AND ".$this->limitesCarte['est']." ".
104
		"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".
104
		"AND lieu_station_latitude BETWEEN ".$this->limitesCarte['sud']." AND ".$this->limitesCarte['nord']." ".
105
		"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date";
105
		"AND Length(lieu_commune_code_insee)=5 ORDER BY lieu_commune_code_insee, date"." -- " . __FILE__ . ":" . __LINE__." ".$_SERVER['REQUEST_URI'];
106
		$stations = $this->bdd->recupererTous($requete);
106
		$stations = $this->bdd->recupererTous($requete);
107
		$this->rechercherInfosCommune($stations);
107
		$this->rechercherInfosCommune($stations);
108
		return $stations;
108
		return $stations;
109
	}
109
	}