Subversion Repositories Sites.obs-saisons.fr

    }

    public function getExportStationJson() {

    	$donnees = $this->getExportStation();

    	$donnees_formatees = $this->formaterListeStationPourExportJson($donnees);

    	$this->type_mime = 'application/json';

    	return $donnees_formatees;

    }

    public function getExportStation($start = null,$limit = null, $order_by = 'oo_date') {

    	$requete_selection_stations = 'SELECT * FROM ods_stations ';    

    	$res_selection_stations = $this->executerRequete($requete_selection_stations);

    	return $res_selection_stations;

    }

    public function formaterListeStationPourExportJson($tableau_stations_infos) {

    	$gestionnaire_especes = new OdsEspece($this->config);

    	$gestionnaire_communes = new OdsCommune($this->config);

    	$gestionnaire_utilisateurs = new OdsUtilisateur($this->config);

    	$especes = $gestionnaire_especes->getToutesEspeces();

    	$evenements = $this->obtenirValeursListeParAbreviation(self::ABBR_LISTE_EVENEMENTS);

    	$milieux = $this->obtenirValeursListeParAbreviation(self::ABBR_LISTE_MILIEUX);

    	$utilisateurs = $gestionnaire_utilisateurs->getListeUtilisateurAvecInfosComplementairesFormateeId();

    	$communes = $gestionnaire_communes->obtenirCommunesLieesAStationIndexeesCodeInsee();

    	$resultats_formates = array();

    	$stats = array('total' => count($tableau_stations_infos));

    	foreach($tableau_stations_infos as $stations_infos) {    		

    		$commune = isset($communes[$stations_infos['os_ce_commune']]['oc_nom']) ? $communes[$stations_infos['os_ce_commune']]['oc_nom'] : '';

    		$id_station = $stations_infos['os_id_station'];

    		$resultats_formates[$id_station]['nom'] = $stations_infos['os_nom'];

    		$resultats_formates[$id_station]['code_commune'] = is_numeric($stations_infos['os_ce_commune']) ? substr($stations_infos['os_ce_commune'], 0, 2) : '';

    		$resultats_formates[$id_station]['nom_commune'] = $commune;

    		$resultats_formates[$id_station]['latitude'] = $stations_infos['os_latitude'];

    		$resultats_formates[$id_station]['longitude'] = $stations_infos['os_longitude'];

    		$resultats_formates[$id_station]['altitude'] = $stations_infos['os_altitude'];

    		$resultats_formates[$id_station]['type_participant'] = 'Particulier';

    		if(isset($utilisateurs[$stations_infos['os_ce_participant']])) {

    			$participant = $utilisateurs[$stations_infos['os_ce_participant']];

    			$resultats_formates[$id_station]['participant']['id'] = $participant['uid'];

    			$resultats_formates[$id_station]['participant']['nom'] = $participant['name'];

    			$resultats_formates[$id_station]['type_participant'] = isset($participant['profile_type']) ? $participant['profile_type'] : 'Particulier';

    		} else {

    			$resultats_formates[$id_station]['participant']['id'] = null;

    			$resultats_formates[$id_station]['participant']['nom'] = 'Anonyme';

    			$resultats_formates[$id_station]['type_participant'] = 'Particulier';

    		}

    		if(isset($stats[$resultats_formates[$id_station]['type_participant']])) {

    			$stats[$resultats_formates[$id_station]['type_participant']]++;

    		} else {

    			$stats[$resultats_formates[$id_station]['type_participant']] = 1;

    		}

    	}

    	$resultat = array('stats' => $stats, 'stations' => $resultats_formates);

    	return $resultat;