279,7 → 279,7 |
$requete_selection_stations = 'SELECT * FROM ods_stations '. |
' LEFT JOIN ods_individus '. |
' ON ods_individus.oi_ce_station = ods_stations.os_id_station '. |
' ORDER BY ods_stations.os_id_station, ods_individus.oi_ce_espece '; |
' ORDER BY ods_stations.os_id_station, ods_individus.oi_ce_espece'; |
|
$res_selection_stations = $this->executerRequete($requete_selection_stations); |
|
298,31 → 298,38 |
|
foreach($tableau_stations_infos as &$stations_infos) { |
|
if($stations_infos['os_ce_commune'] == "NULL") { |
$stations_infos['os_ce_commune'] = ''; |
if(!isset($resultats_formates[$stations_infos['os_id_station']])) { |
if($stations_infos['os_ce_commune'] == "NULL") { |
$stations_infos['os_ce_commune'] = ''; |
} |
|
$resultats_formates[$stations_infos['os_id_station']] = array( |
'station' => $stations_infos['os_nom'], |
'code_commune' => $stations_infos['os_ce_commune'], |
'nom_commune' => '', |
'latitude' => $stations_infos['os_latitude'], |
'longitude' => $stations_infos['os_longitude'], |
'altitude' => $stations_infos['os_altitude'], |
'id_participant' => $stations_infos['os_ce_participant'], |
'pseudo_participant' => '', |
'mail_participant' => '', |
'especes' => array() |
); |
|
if(is_numeric($stations_infos['os_ce_commune'])) { |
$codes_insee_communes[] = $stations_infos['os_ce_commune']; |
} |
} |
|
$resultats_formates[$stations_infos['os_id_station']] = array( |
'station' => $stations_infos['os_nom'], |
'code_commune' => $stations_infos['os_ce_commune'], |
'nom_commune' => '', |
'latitude' => $stations_infos['os_latitude'], |
'longitude' => $stations_infos['os_longitude'], |
'altitude' => $stations_infos['os_altitude'], |
'id_participant' => $stations_infos['os_ce_participant'], |
'pseudo_participant' => '', |
'mail_participant' => '' |
); |
|
$infos_espece = $especes[$stations_infos['oi_ce_espece']]; |
if($infos_espece['type'] != "") { |
$infos_espece['type'] = $this->obtenirValeurTripleParId($infos_espece['type']); |
} |
|
$resultats_formates[$stations_infos['os_id_station']]['especes'][] = $infos_espece; |
|
if(is_numeric($stations_infos['os_ce_commune'])) { |
$codes_insee_communes[] = $stations_infos['os_ce_commune']; |
if($infos_espece != null) { |
|
if($infos_espece['type'] != "") { |
$infos_espece['type'] = $this->obtenirValeurTripleParId($infos_espece['type']); |
} |
|
$resultats_formates[$stations_infos['os_id_station']]['especes'][$infos_espece['id_espece']] = $infos_espece; |
} |
} |
|
338,7 → 345,13 |
$resultat['pseudo_participant'] = $correspondance_id_utilisateur[$resultat['id_participant']]['name']; |
$resultat['mail_participant'] = $correspondance_id_utilisateur[$resultat['id_participant']]['mail']; |
|
//TODO: selection champ infos complémentaires à transmettre |
$types = array("Particulier" ,"Établissement scolaire", "Association" ,"Professionnel", "Autre","Inconnu"); |
|
if(isset($correspondance_id_utilisateur[$resultat['id_participant']]['profile_type'])) { |
$resultat['type_participant'] = $correspondance_id_utilisateur[$resultat['id_participant']]['profile_type']; |
} else { |
$resultat['type_participant'] = "Inconnu"; |
} |
} |
|
return $resultats_formates; |