Subversion Repositories Sites.obs-saisons.fr

Rev

Rev 282 | Rev 315 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 282 Rev 284
Line 167... Line 167...
167 
    	return $resultat;
 167 
    	return $resultat;
168 
    }
 168 
    }
Line 169... Line 169...
169
169
Line 170... Line 170...
170 
	public function getExportObservation($start = null,$limit = null, $order_by = 'oo_date') {
 170 
	public function getExportObservation($start = null,$limit = null, $order_by = 'oo_date') {
171
171
172 
		$requete_selection_observations = 'SELECT * FROM ods_observations '.
 172 
		$requete_selection_observations = 'SELECT oo.*, oi.*, os.*, oc.* FROM ods_observations oo'.
- 
 
 173 
									' LEFT JOIN ods_individus oi'.
- 
 
 174 
									' ON oi_id_individu = oo_ce_individu'.
- 
 
 175 
									' INNER JOIN ods_especes oe'.
173 
									' LEFT JOIN ods_individus '.
176 
									' ON oe.oe_espece_active = 1 '.
174 
									' ON oi_id_individu = oo_ce_individu'.
 177 
									' AND oe.oe_id_espece = oi_ce_espece '.
175 
									' LEFT JOIN ods_stations '.
 178 
									' LEFT JOIN ods_stations os'.
176 
									' ON oi_ce_station = os_id_station '.
 179 
									' ON oi_ce_station = os_id_station '.
177 
									' LEFT JOIN ods_communes '.
 180 
									' LEFT JOIN ods_communes oc'.
178 
									'ON os_ce_commune = oc_code_insee ';
 181 
									' ON os_ce_commune = oc_code_insee ';
179
182 
 
180 
		$requete_selection_observations .= $this->construireConditionRequete();
 183 
		$requete_selection_observations .= $this->construireConditionRequete();
181 
		$requete_selection_observations .= ' ORDER BY oo_date DESC';
 184 
		$requete_selection_observations .= ' ORDER BY oo_date DESC';
182
185 
 
183 
		$res_selection_observations = $this->executerRequete($requete_selection_observations);
 186 
		$res_selection_observations = $this->executerRequete($requete_selection_observations);
184
187 
 
Line 185... Line 188...
185 
		return $res_selection_observations;
 188 
		return $res_selection_observations;
186 
	}
 189 
	}
Line 366... Line 369...
366 
		$milieux = $this->obtenirValeursListeParAbreviation(self::ABBR_LISTE_MILIEUX);
 369 
		$milieux = $this->obtenirValeursListeParAbreviation(self::ABBR_LISTE_MILIEUX);
Line 367... Line 370...
367
370
Line 368... Line 371...
368 
		$codes_insee_communes = array();
 371 
		$codes_insee_communes = array();
369
- 
 
370 
		$resultats_formates = array();
 372
Line 371... Line 373...
371
373 
		$resultats_formates = array();
372 
		foreach($tableau_observations_infos as $observations_infos) {
 374 
		foreach($tableau_observations_infos as $observations_infos) {