Subversion Repositories Sites.obs-saisons.fr

Rev

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

Rev 210 Rev 227
Line 33... Line 33...
33 
        // Envoi sur la sortie standard
 33 
        // Envoi sur la sortie standard
34 
        $this->envoyer($info);
 34 
        $this->envoyer($info);
35 
    }
 35 
    }
Line 36... Line 36...
36
36
37 
	public function getExportObservation($start = null,$limit = null, $order_by = 'oo_date') {
 37 
	public function getExportObservation($start = null,$limit = null, $order_by = 'oo_date') {
38
38
39 
		$requete_selection_observations = 'SELECT * FROM ods_observations '.
 39 
		$requete_selection_observations = 'SELECT * FROM ods_observations '.
40 
									' LEFT JOIN ods_individus '.
40 
									' LEFT JOIN ods_individus '.
41 
									' ON oi_id_individu = oo_ce_individu'.
 41 
									' ON oi_id_individu = oo_ce_individu'.
42 
									' LEFT JOIN ods_stations '.
 42 
									' LEFT JOIN ods_stations '.
Line 92... Line 92...
92
92
93 
			$condition .= ' AND ';
 93 
			$condition .= ' AND ';
Line 94... Line 94...
94 
		}
 94 
		}
- 
 
 95
- 
 
 96 
		$condition = rtrim($condition,'AND ');
- 
 
 97
- 
 
 98 
		$id_demo = $this->config['appli']['id_participant_demo'];
95
99 
		$id_admin = $this->config['appli']['id_participant_admin'];
- 
 
 100
Line 96... Line 101...
96 
		$condition = rtrim($condition,'AND ');
 101 
		$condition .= ' AND oo_ce_participant != '.$id_demo;
97 
		$condition .= ' AND oo_ce_participant != 4';
 102 
		$condition .= ' AND oo_ce_participant != '.$id_admin;
Line 98... Line 103...
98
103
Line 175... Line 180...
175
180
Line 176... Line 181...
176 
	public function formaterPourExportCSV($tableau_observations_infos) {
 181 
	public function formaterPourExportCSV($tableau_observations_infos) {
177
182
- 
 
 183 
		$gestionnaire_especes = new OdsEspece($this->config);
Line 178... Line 184...
178 
		$gestionnaire_especes = new OdsEspece($this->config);
 184 
		$gestionnaire_communes = new OdsCommune($this->config);
179 
		$gestionnaire_communes = new OdsCommune($this->config);
 185 
		$gestionnaire_utilisateurs = new OdsUtilisateur($this->config);
Line 180... Line 186...
180
186
Line 210... Line 216...
210 
				'nom_commune' => '',
 216 
				'nom_commune' => '',
211 
				'latitude' => $observations_infos['os_latitude'],
 217 
				'latitude' => $observations_infos['os_latitude'],
212 
				'longitude' => $observations_infos['os_longitude'],
 218 
				'longitude' => $observations_infos['os_longitude'],
213 
				'altitude' => $observations_infos['os_altitude'],
 219 
				'altitude' => $observations_infos['os_altitude'],
214 
				'milieu' => $observations_infos['os_milieu'],
 220 
				'milieu' => $observations_infos['os_milieu'],
215 
				'participant' => $observations_infos['os_ce_participant']
 221 
				'id_participant' => $observations_infos['os_ce_participant'],
- 
 
 222 
				'pseudo_participant' => '',
- 
 
 223 
				'mail_participant' => ''
216 
			);
 224 
			);
Line 217... Line 225...
217
225
Line 218... Line 226...
218 
			$resultats_formates[] = $infos_formatees;
 226 
			$resultats_formates[] = $infos_formatees;
219
227
220 
			if(is_numeric($observations_infos['os_ce_commune'])) {
 228 
			if(is_numeric($observations_infos['os_ce_commune'])) {
221 
				$codes_insee_communes[] = $observations_infos['os_ce_commune'];
 229 
				$codes_insee_communes[] = $observations_infos['os_ce_commune'];
Line 222... Line 230...
222 
			}
 230 
			}
- 
 
 231 
		}
Line 223... Line 232...
223 
		}
 232
Line 224... Line 233...
224
233 
		$correspondance_codes_insee_noms = $gestionnaire_communes->obtenirTableauNomsCommunesParTableauCodesInsee($codes_insee_communes);
225 
		$correspondance_codes_insee_noms = $gestionnaire_communes->obtenirTableauNomsCommunesParTableauCodesInsee($codes_insee_communes);
 - 
 
226
234 
		$correspondance_id_utilisateur = $gestionnaire_utilisateurs->getListeUtilisateurFormateeId();
227 
		foreach($resultats_formates as &$resultat) {
 235
- 
 
 236 
		foreach($resultats_formates as &$resultat) {
- 
 
 237
- 
 
 238 
			if(isset($correspondance_codes_insee_noms[$resultat['code_commune']]) && trim($correspondance_codes_insee_noms[$resultat['code_commune']]) != '') {
228
239 
				$resultat['nom_commune'] = $correspondance_codes_insee_noms[$resultat['code_commune']];
Line 229... Line 240...
229 
			if(isset($correspondance_codes_insee_noms[$resultat['code_commune']]) && trim($correspondance_codes_insee_noms[$resultat['code_commune']]) != '') {
240 
			}
230
241