Subversion Repositories eFlore/Applications.moissonnage

Rev

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

Rev 34 Rev 43
Line 63... Line 63...
63 
	}
 63 
	}
Line 64... Line 64...
64
64
65 
	final protected function construireRequeteWfs() {
 65 
	final protected function construireRequeteWfs() {
66 
		$requete =
 66 
		$requete =
67 
		"SELECT nom_scientifique_complet AS taxon, lieu_station_nom AS nom, lieu_station_latitude AS latitude, ".
 67 
		"SELECT nom_scientifique_complet AS taxon, lieu_station_nom AS nom, lieu_station_latitude AS latitude, ".
68 
		"lieu_station_longitude AS longitude, 'STATION' AS type_site, lieu_commune_code_insee AS code_insee, ".
 68 
		"lieu_station_longitude AS longitude, 'station' AS type_site, lieu_commune_code_insee AS code_insee, ".
- 
 
 69 
		"'{$this->nomSource}' AS source, observateur_nom_complet AS auteur ".
69 
		"'{$this->nomSource}' AS source FROM {$this->nomSource}_tapir WHERE 1 ".
 70 
		"FROM {$this->nomSource}_tapir WHERE 1 ".
70 
		$this->construireWhereCoordonneesBbox().' '.
 71 
		$this->construireWhereCoordonneesBbox().' '.
71 
		$this->construireWhereNomScientifique().' '.
 72 
		$this->construireWhereNomScientifique().' '.
72 
		"ORDER BY lieu_station_longitude, lieu_station_latitude";
 73 
		"ORDER BY lieu_station_longitude, lieu_station_latitude";
73 
		return $requete;
 74 
		return $requete;