169,12 → 169,15 |
|
public function getExportObservation($start = null,$limit = null, $order_by = 'oo_date') { |
|
$requete_selection_observations = 'SELECT * FROM ods_observations '. |
' LEFT JOIN ods_individus '. |
$requete_selection_observations = 'SELECT oo.*, oi.*, os.*, oc.* FROM ods_observations oo'. |
' LEFT JOIN ods_individus oi'. |
' ON oi_id_individu = oo_ce_individu'. |
' LEFT JOIN ods_stations '. |
' INNER JOIN ods_especes oe'. |
' ON oe.oe_espece_active = 1 '. |
' AND oe.oe_id_espece = oi_ce_espece '. |
' LEFT JOIN ods_stations os'. |
' ON oi_ce_station = os_id_station '. |
' LEFT JOIN ods_communes '. |
' LEFT JOIN ods_communes oc'. |
'ON os_ce_commune = oc_code_insee '; |
|
$requete_selection_observations .= $this->construireConditionRequete(); |
368,7 → 371,6 |
$codes_insee_communes = array(); |
|
$resultats_formates = array(); |
|
foreach($tableau_observations_infos as $observations_infos) { |
|
$id_espece = $observations_infos['oi_ce_espece']; |