Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 1011 Rev 1019
Line 96... Line 96...
96
	private function creerVueTapir() {
96
	private function creerVueTapir() {
97
		$requete = "DROP VIEW IF EXISTS ifn_tapir; CREATE VIEW ifn_tapir AS ".
97
		$requete = "DROP VIEW IF EXISTS ifn_tapir; CREATE VIEW ifn_tapir AS ".
98
			"SELECT f.idp as observation_id, b.nom_sci as nom_scientifique_complet, b.num_nom, ".
98
			"SELECT f.idp as observation_id, b.nom_sci as nom_scientifique_complet, b.num_nom, ".
99
				" fo.lieu_commune_code_insee, fo.lieu_station_latitude, fo.lieu_station_longitude,".
99
				" fo.lieu_commune_code_insee, fo.lieu_station_latitude, fo.lieu_station_longitude,".
100
				" 'WGS84' AS geodeticDatum, e.dateeco as observation_date, '' AS observateur_nom_complet".
100
				" 'WGS84' AS geodeticDatum, e.dateeco as observation_date, '' AS observateur_nom_complet".
101
				" FROM `bdtfx_v2_02` b, ifn_flore f, ifn_ecologie e, ifn_placettes_foret fo".
101
				" FROM `bdtfx_v2_01` b, ifn_flore f, ifn_ecologie e, ifn_placettes_foret fo".
102
				" WHERE f.idp = e.idp".
102
				" WHERE f.idp = e.idp".
103
				" AND e.idp = fo.idp".
103
				" AND e.idp = fo.idp".
104
				" AND b.cd_ref = f.cd_ref";
104
				" AND b.cd_nom = f.cd_ref";
105
		$this->getBdd()->requeter($requete);
105
		$this->getBdd()->requeter($requete);
106
	}
106
	}
Line 107... Line 107...
107
	
107
	
108
	private function ajouterTupleEfloreOntologies(){ // pour la légende
108
	private function ajouterTupleEfloreOntologies(){ // pour la légende